Creating a Sales Forecast遵循这些提示学习如何开发销售公关ojections for your business plan.

ByTim Berry

Opinions expressed by Entrepreneur contributors are their own.

Your sales forecast is the backbone of your business plan. People measure a business and its growth by sales, and your sales forecast sets the standard for expenses, profits and growth.

When it comes to forecasting sales, don't fall for the trap that says forecasting takes training, mathematics or advanced degrees. Forecasting is mainly educated guessing. So don't expect to get it perfect; just make it reasonable. There's no business owner who isn't qualified to forecast sales--you don't need a business degree or accountant's certification. What you need is common sense, research of the factors, and motivation to make an educated guess.

Your sales forecast in a business plan should show sales by month for the next 12 months--at least--and then by year for the following two to five years. Three years, total, is generally enough for most business plans.

If you have more than one line of sales, show each line of sales separately and add them up. If you have more than 10 or so lines of sales, summarize them and consolidate. Remember, this is business planning, not accounting, so it has to be reasonable, but it doesn't need too much detail. Here are some tips to get you started:

  • Develop a unit sales projection.Where you can, start by forecasting unit sales per month. Not all businesses sell by units, but most do, and it's easier to forecast by breaking things down into their component parts. Product-oriented businesses obviously sell in units, but so do a lot of service businesses. For example, accountants and attorneys sell hours, taxis sell rides, and restaurants sell meals.
  • Use past data if you have it.Whenever you have past sales data, your best forecasting aid is the most recent past. There are some statistical analysis techniques that take past data and project it forward into the future. You can get just about the same results by projecting your two most recent years of sales by month on a line chart and then visually tracking it forward along the same line. Statistical tools are a nice addition, but they're rarely as valuable in a business plan as human common sense, particularly if it's guided by analysis.
  • Use factors for a new product.Having a new product is no excuse for not having a sales forecast. Of course you don't know what's going to happen, but that's no excuse for not drafting a sales projection. Nobody who plans a new product knows the future--you simply make educated guesses. So break it down by finding important decision factors or components of sales. If you have a completely new product with no history, find an existing product to use as a guide. For example, if you have the next great computer game, base your forecast on sales of a similar computer game. If you have a new auto accessory, look at sales of other auto accessories. Analysts projected sales of fax machines before they were released to the market by looking at typewriters and copiers.
  • Break the purchase down into factors.For example, you can forecast sales in a restaurant by looking at a reasonable number of tables occupied at different hours of the day and then multiplying the percent of tables occupied by the average estimated revenue per table. Some people project sales in certain kinds of retail businesses by investigating the average sales per square foot in similar businesses.
  • Be sure to project prices.The next step is prices. You've projected unit sales monthly for 12 months and then annually, so you must also project your prices. Think of this as a simple spreadsheet that adds the units of different sales items in one section, then sets the estimated prices in a second section. A third section then multiplies units times price to calculate sales. The math is simple--the hard part is making that estimated guess of unit sales.

A fourth section of your projected prices will set the average costs per unit. You want to set costs because a lot of financial analysis focuses on gross margin, which is sales less cost of sales. For financial reasons, cost of sales, also known as costs of goods sold and direct costs, are different from the other expenses that come out of profits.

The cost of sales isn't what you pay salespeople or for advertising. It's the amount you pay to buy what you sell. This is usually easy to understand. In any retail store, for example, the cost of goods sold is what the store pays for the products it sells. In service businesses, the costs of sales can be less obvious, but it can still be figured out.

Finally, in a fifth and final section, you multiply unit sales times average cost per unit to calculate your cost of sales. This gives you a sales forecast that you can use for the rest of your financial projections. The first place you'll use it is at the beginning of your profit and loss statement, which normally starts with sales and cost of sales.

Of course, not all businesses fit easily into the units sales model. Some business plans will have sales forecasts that project dollar sales only, by line of sales, and then direct costs, by other factors. For example, a taxi business might simply estimate total fares as its sales forecast and gasoline, maintenance and other items as its cost of sales. A graphic artist might stick with the simple dollar-value sales forecast and project cost of sales as photocopies, color proofs, etc. In the end, it's alwaysyourplan, so you have to make the decisions that are best for you.

Wavy Line
Tim Berry

Entrepreneur, Business Planner and Angel Investor

Tim Berry is the chairman of Eugene, Ore.-Palo Alto Software, which produces business-planning software. He foundedBplans.comand wroteThe Plan-As-You-Go Business Plan, published by Entrepreneur Press. Berry is also a co-founder ofHavePresence.com, a leader in a local angel-investment group and a judge of international business-plan competitions.

Editor's Pick

We're Now Finding Out TheDamaging Results of The Mandated Return to Office— And It's Worse Than We Thought.
He 'Grew Up in Bars' and Was Drinking By Age 10 — But Entrepreneurs Changed His Life. Now a Business Owner Himself,He's Paying It Forward.
LinkedIn Changed Its Algorithms — Here's How YourPosts Will Get More Attention Now
'Focus Is Just as Important as Passion': How to Avoid狗万官方企业家精神缺失症in Franchising
Lock
Kevin O'Leary Recommends This6-Step Strategyfor Making Money on Social Media
Lock
ThisMindset Shift Changed My Life— And Gave Me the Courage to Leave My Well-Paid Full-Time Job.
Business News

'Pre-Boarding Scam': Customers Furious at Southwest Airlines After 20 Passengers Ask For Wheelchair Assistance to Board

A viral tweet is slamming the airline's wheelchair policy for boarding and disembarking.

Growing a Business

We're Now Finding Out The Damaging Results of The Mandated Return to Office — And It's Worse Than We Thought.

Companies knew the mandated return to the office would cause some attrition, however, they were not prepared for the serious problems that would present.

Business News

Costco Cracks Down on Membership Sharing: 'We Don't Feel It's Right'

The wholesaler is now asking for a photo ID with the membership card at checkout.

Business News

Daymond John Slams 'Shark Tank' Contestants With Restraining Order: 'It Is Unfortunate That It Has Come to This'

Bubba's Q boneless ribs first appeared on Season 5 of the hit ABC show.

Business News

'Have We Not Learned Anything': Virgin Galactic Slammed For Announcing Commercial Flights Days After Titan Submersible Implosion

Virgin Galactic is set to launch its first space tourism flight on Thursday out of New Mexico.

Business News

After Being Told They Could Work From Home Forever, Employees Made Major Life Changes. Then, a New CEO Ordered Them Back to the Office.

Farmers Group CEO Raul Vargas is facing backlash for the change, but he says being in the office brings more "collaboration" and "innovation."