Docstoc
EXCLUSIVE OFFER FOR DOCSTOC USERS
Try the all-new QuickBooks Online for FREE.  No credit card required.

Hospitality and Leisure Revenue Projection Worksheet

Document Sample
Hospitality and Leisure Revenue Projection Worksheet Powered By Docstoc
					                                                                       REVENUE FORECASTING
Revenue Forecasting For                                                Growth projection                      Percentage                $ AMOUNT
2011                                                                                                   2012          5%                 $ 44,100.00
                                                                                                       2013          5%                 $ 46,305.00
Product/Service A (Specify) Selling Price   $    10.00                                                 2014          5%                 $ 48,620.25
                                                                                                       2015          5%                 $ 51,051.26
Product/Service B (Specify) Selling Price   $     8.00                                                 2016          5%                 $ 53,603.83

Product/Service C (Specify) Selling Price   $     3.00


TOTAL REVENUE FOR THE YEAR                  $ 42,000.00

                                                 Jan-11       Feb-11       Mar-11       Apr-11       May-11       Jun-11       Jul-11       Aug-11        Sep-11

Unit sold for Product/Service A                     100          100          100          100          100          100          100           100          100

Total Revenue For Product/Service A         $ 1,000.00    $ 1,000.00   $ 1,000.00   $ 1,000.00   $ 1,000.00   $ 1,000.00   $ 1,000.00   $ 1,000.00    $ 1,000.00


Unit Sold for Product/Service B                     200          200          200          200          200          200          200           200          200

Total Revenue For Product/Service B         $ 1,600.00    $ 1,600.00   $ 1,600.00   $ 1,600.00   $ 1,600.00   $ 1,600.00   $ 1,600.00   $ 1,600.00    $ 1,600.00


Unit Sold For Product/Service C                     300          300          300          300          300          300          300           300          300

Total Revenue For Product/Service C         $   900.00    $   900.00   $   900.00   $   900.00   $   900.00   $   900.00   $   900.00   $   900.00    $   900.00


TOTAL REVENUES                              $ 3,500.00    $ 3,500.00   $ 3,500.00   $ 3,500.00   $ 3,500.00   $ 3,500.00   $ 3,500.00   $ 3,500.00    $ 3,500.00
                                         Annual
    Oct-11       Nov-11       Dec-11     Totals             2012          2013         2014          2015           2016

       100          100          100          1200          1260          1323      1389.15     1458.6075 1531.53788

$ 1,000.00   $ 1,000.00   $ 1,000.00   $ 12,000.00   $ 12,600.00   $ 13,230.00   $ 13,891.50   $ 14,586.08   $ 15,315.38


       200          200          200          2400          2520          2646        2778.3     2917.215 3063.07575

$ 1,600.00   $ 1,600.00   $ 1,600.00   $ 19,200.00   $ 20,160.00   $ 21,168.00   $ 22,226.40   $ 23,337.72   $ 24,504.61


       300          300          300          3600          3780          3969      4167.45     4375.8225 4594.61363

$   900.00   $   900.00   $   900.00   $ 10,800.00   $ 11,340.00   $ 11,907.00   $ 12,502.35   $ 13,127.47   $ 13,783.84


$ 3,500.00   $ 3,500.00   $ 3,500.00   $ 42,000.00   $ 44,100.00   $ 46,305.00   $ 48,620.25   $ 51,051.26   $ 53,603.83

				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:36
posted:5/31/2012
language:English
pages:2
Description: We don’t have a precise formula or metrics for forecasting revenues. Although revenues cannot be predicted with a 100% precise degree, this does not give business managers a leeway to perform their job haphazardly. Understanding the business, competitors, market and economic conditions will help a business manager develop sales projection which reflects on the reality of the industry.