Docstoc

New Product Sales Forecast

Document Sample
New Product Sales Forecast Powered By Docstoc
					                         New Product Sales Forecast
                                                Widget Model II
                                               December 31, 2006


Base Annual Sales                $50,000

                              Worst Case       Most Likely       Best Case             Total
Probability                      10.00%          50.00%            40.00%             100%

Growth Rates                         Year 2         Year 3           Year 4          Year 5         Year 6
 Worst Case                          0.00%          2.00%            3.00%           3.00%          3.00%
 Most Likely                         5.00%          5.00%            5.00%           6.00%          6.00%
 Best Case                           6.00%          7.00%            8.00%           8.00%          8.00%


                                                                    Forecasted Sales
                            Seasonality        Worst             Most             Best         Weighted
Year           Month          Factor           Case              Likely          Case          Average
2001           Jan                  1.20         $5,000              $5,250          $5,300        $5,245
               Feb                  1.10         $4,583              $4,813          $4,858        $4,808
               Mar                  1.00         $4,167              $4,375          $4,417        $4,371
               Apr                  1.00         $4,167              $4,375          $4,417        $4,371
               May                  0.80         $3,333              $3,500          $3,533        $3,497
               Jun                  0.65         $2,708              $2,844          $2,871        $2,841
               Jul                  0.55         $2,292              $2,406          $2,429        $2,404
               Aug                  0.60         $2,500              $2,625          $2,650        $2,623
               Sep                  0.60         $2,500              $2,625          $2,650        $2,623
               Oct                  1.00         $4,167              $4,375          $4,417        $4,371
               Nov                  1.50         $6,250              $6,563          $6,625        $6,556
               Dec                  2.00         $8,333              $8,750          $8,833        $8,742
               Total               12.00        $50,000            $52,500         $53,000        $52,450

2002           Jan                    1.20         $5,100           $5,513          $5,671         $5,535
               Feb                    1.10         $4,675           $5,053          $5,198         $5,073
               Mar                    1.00         $4,250           $4,594          $4,726         $4,612
               Apr                    1.00         $4,250           $4,594          $4,726         $4,612
               May                    0.80         $3,400           $3,675          $3,781         $3,690
               Jun                    0.65         $2,763           $2,986          $3,072         $2,998
               Jul                    0.55         $2,338           $2,527          $2,599         $2,537
               Aug                    0.60         $2,550           $2,756          $2,836         $2,767
               Sep                    0.60         $2,550           $2,756          $2,836         $2,767
               Oct                    1.00         $4,250           $4,594          $4,726         $4,612
               Nov                    1.50         $6,375           $6,891          $7,089         $6,918
               Dec                    2.00         $8,500           $9,188          $9,452         $9,224
               Total                 12.00        $51,000          $55,125         $56,710        $55,347

2003           Total Year Forecast                $52,530          $57,881         $61,247        $58,692

2004           Total Year Forecast                $54,106          $61,354         $66,147        $62,546

2005           Total Year Forecast                $55,729          $65,035         $71,438        $66,666


                               © Copyright, 2006, Jaxworks, All Rights Reserved.
Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and ass
documents, that cover a number of financial, accounting and sales functions. These are invalua

Also included Free are:
   - business plan tools, including spreadsheets and excellent instructions
   - Excel functions glossary and guide;
   - free training courses for most Microsoft Office applications. These guides are in
     PDF format and rival commercial books!
   - comprehensive list of acronyms, ratios and formulas in customer financial
     analysis, and financial terms;
   - suite of online calculators, including, breakeven analysis, productivity analysis,
     business evaluation;
   - Altman Z-Score (covering publicly and privately held firms, and small
     businesses);
   - and payroll analysis.

If you are involved in financial analysis at any level, or want to learn more about MS Excel and o
suite this site is invaluable.




                                              JaxWorks Small Business Spreadsheet Factory
 preadsheets, and associated MS Word, PDF and HTML
ons. These are invaluable small business tools.




ides are in



 analysis,




 about MS Excel and other applications in the Office




sheet Factory

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:589
posted:1/6/2008
language:English
pages:3