Docstoc

36 Month Sales Forecast

Document Sample
36 Month Sales Forecast Powered By Docstoc
					Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and associated MS Word, PDF and HTML
documents, that cover a number of financial, accounting and sales functions. These are invaluable small business tools.

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 other applications in the Of fice
suite this site is invaluable.




                                             © Copyright, 2010, Jaxworks, All Rights Reserved.
                                                                                   36 Month Sales Forecast
Fiscal Year 1           2009


                                                                                                                   2009
                          Jan            Feb             Mar               Apr            May              Jun               Jul            Aug           Sep             Oct           Nov            Dec     Totals
Product Name    Enter Product Name Here
Units                    1,000       1,500             1,000          1,000              1,000           1,000            1,100           1,200          1,300          1,400          1,500          1,600   14,600
Selling Price            $5.00       $5.00             $5.00          $5.00              $5.00           $5.00            $5.00           $5.00          $5.00          $5.00          $5.00          $5.00
Total Sales             $5,000      $7,500            $5,000         $5,000             $5,000          $5,000           $5,500          $6,000         $6,500         $7,000         $7,500         $8,000   $73,000
% of Total               6.85%      10.27%             6.85%          6.85%              6.85%           6.85%            7.53%           8.22%          8.90%          9.59%         10.27%         10.96%   100.00%


                                                                                                                   2010
                          Jan            Feb             Mar               Apr            May              Jun               Jul            Aug           Sep             Oct           Nov            Dec     Totals

Units                   1,300           1,500          1,200          1,300              1,400           1,500            1,600           1,200          1,300          1,400          1,500          1,600   16,800
Selling Price           $5.10           $5.10          $5.10          $5.10              $5.10           $5.10            $5.10           $5.10          $5.10          $5.10          $5.10          $5.10
Total Sales            $6,630          $7,650         $6,120         $6,630             $7,140          $7,650           $8,160          $6,120         $6,630         $7,140         $7,650         $8,160   $85,680
% of Total              7.74%           8.93%          7.14%          7.74%              8.33%           8.93%            9.52%           7.14%          7.74%          8.33%          8.93%          9.52%   100.00%


                                                                                                                   2011
                          Jan            Feb             Mar               Apr            May              Jun               Jul            Aug           Sep             Oct           Nov            Dec     Totals

Units                   1,500           1,600           2,000         1,000              1,000           1,000            1,100           1,200          1,300          1,400          1,500          1,600   16,200
Selling Price           $5.10           $5.10           $5.10         $5.10              $5.10           $5.10            $5.10           $5.10          $5.10          $5.10          $5.10          $5.10
Total Sales            $7,650          $8,160         $10,200        $5,100             $5,100          $5,100           $5,610          $6,120         $6,630         $7,140         $7,650         $8,160   $82,620
% of Total              9.26%           9.88%          12.35%         6.17%              6.17%           6.17%            6.79%           7.41%          8.02%          8.64%          9.26%          9.88%   100.00%

                                                                                    36 Month Sales Forecast

                Jan              Feb            Mar             Apr
                                                                100,000           May            Jun              Jul              Aug            Sep            Oct            Nov            Dec
                             0              1               2                 3            4                  5                6              7              8              9             10             11
                                                                 80,000
                                                                                       2009               2010             2011
                                                                 60,000
                                                                Units                14,600             16,800           16,200     Units
                                                                Total Sales
                                                                 40,000             $73,000            $85,680          $82,620
                                                                                                                                    Total Sales
                                                                 20,000
                                                                       0
                                                                                  2009       2010            2011


                                                                           © Copyright, 2010, Jaxworks, All Rights Reserved.




                                                                       © Copyright, 2010, JaxWorks, All Rights Reserved.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:6/21/2012
language:
pages:2
Mleek rafat Mleek rafat Mr
About like all Hr&finance formes