How to Set-up Sales Funnel Template

Sales funnel template

Sales funnel template: Whether you’re setting up a business plan to present to a bank or investors or you’re just punching a line item on your To-Do list.

Sales projections can be a valuable management tool if done right.

When you project sales and follow-through by comparing actual figures to the forecast.

You more accurately gauge what’s going on in your business and more quickly make course corrections as needed.

Follow the steps in this article to accurately project sales for your business.

The way to get started is to quit talking and begin doing. You can request publication of your article for publication by sending it to us via our Email below. Click here to start business now with

Break Your Business into Manageable Sales or Expense Units

Start with expenses.

  • Consider fixed and variable expenses, from rents and fixed loans to payroll and utilities.
  • Plus capital equipment and inventory, as well as a marketing or advertising budget.
  • Allow for bad debt or returns and a profit margin.

Factor in income sources.

  • Any business, whether product or service, will have units to measure, even if it’s time itself (such as professionals billing by the quarter-hour).

Sales funnel template

Review past sales figures to determine the cycle your business operates in: its ebb and flow.

  • For example, most retail establishments can run in the red during summer vacation and make the bulk of their income during the holidays.

Divide income by expenses to arrive at a baseline sales price.

  • To manage your business going forward, tie this sales price back to the income units, such as by product type or by seasonality, so you can compare future figures to past sales.

Analyze Your Market

Compare the average sales per square foot for your store to stores like yours.

  • Compare stores of similar size, in a similar industry, in a similar locale.

Create a target zone around your business and estimate the total number of consumers using or needing your product or service within each zone (for example, within 1 mile (1.6 km), 5 miles (8.0 km), 10 miles).

  • Determine market share. Which businesses do consumers patronize for your product or service? What percentage do you get compared to competitors?

    Sales funnel template

Use your unit breakdown and weight the per-unit figure by overall sales.

  • For example, you sell five-item categories total. 1 category sells 5 units per day, 2 sell 3 units each, and 2 sell 1 unit each.
  • Multiply the price of each unit by the number sold for a total current revenue figure.

Develop a Marketing Projection

Decide how best to promote your products and services, and estimate the number of customers you anticipate reaching.

List how you plan to grow your business.

  • Options include selling more current products to existing customers, attracting more customers with current products, and introducing new products to current or prospective customers.

Review past marketing approaches to see which yielded the best results.

  • How well do these promotions match your current product and customer mix? Can you replicate the promotions? Do different promotions promote sales to different customer groups, or move different product categories?

Sales funnel template

Match the promotion, product, and customer base to estimate how much you anticipate selling as you move forward.

Calculate projected sales with this simple equation:

Multiply a total number of customers times the average per-unit price.

Run this equation several times:

By product category, by customer type, by the anticipated outcome of promotions.

  • The more meticulous you have been in breaking down your business, the more accurately you can project sales.

Sales funnel template

Compare your figures against industry norms.

  • Ask a business associate or mentor to look over your figures.
  • Look up forecasts from within the industry, often published in trade magazines.
  • Peruse an annual report of a competitor or a business of similar size in your area.
  • Check out sample plans your banker, Chamber of Commerce, or Small Business Administration office may make available.

Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like