Analysis of Indirect Expenses - Excel - Excel

Document Sample
Analysis of Indirect Expenses - Excel - Excel Powered By Docstoc
					Rockview Resort & Spa
Analysis of Indirect Expenses
                                                                    Childrens Game
                                Banquet Room     Business Center         Room
Total Revenue               $       345,819.00   $    192,190.00    $    52,750.00
Cost of Sales                        19,750.00         16,235.00         12,900.00
Direct Expenses                       9,245.00          9,245.00          7,250.00
Indirect Expenses
 Administrative             $        10,394.16   $      5,776.59    $     1,585.49
 Depreciation                        16,414.60          1,367.88          2,227.70
 Energy                               6,513.67          3,620.00            993.57
 Insurance                            3,347.62            278.97            454.32
 Maintenance                          7,637.64            636.47          1,036.54
 Marketing                            8,203.69          4,559.23          1,251.36
Total Indirect Expenses              52,511.39          16,239.13          7,548.98

Net Income                  $      264,312.61    $   150,470.87     $    25,051.02

Square Footage                         10,500                875             1,425
Planned Indirect Expenses
 Administrative                         67,500
 Depreciation                           58,350
 Energy                                 42,300
 Insurance                              11,900
 Maintenance                            27,150
 Marketing                              53,275
Conference Rooms        Gift Shop          Lounge            Restaurant            Spa
$     212,300.00    $    112,100.00    $   622,350.00    $       615,350.00    $   92,900.00
       55,250.00          42,100.00        115,400.00            175,000.00        42,150.00
       19,300.00          37,400.00        101,000.00            115,600.00        24,800.00



$       6,381.03    $      3,369.35    $    18,705.76    $        18,495.36    $    2,792.26
        9,770.60           2,071.37         11,724.72             10,474.08         4,299.06
        3,998.78           2,111.46         11,722.28             11,590.43         1,749.82
        1,992.63             422.44          2,391.16              2,136.10           876.76
        4,546.22             963.80          5,455.46              4,873.54         2,000.33
        5,036.29           2,659.29         14,763.69             14,597.64         2,203.82
        31,725.53          11,597.70         64,763.06             62,167.15        13,922.06

$    106,024.47     $     21,002.30    $   341,186.94    $      262,582.85     $   12,027.94

           6,250              1,325             7,500                 6,700              2,750
      05-Nov-08

    Total
$   2,245,759.00
      478,785.00
     323,840.00



$     67,500.00
      58,350.00
      42,300.00
      11,900.00
      27,150.00
      53,275.00
      260,475.00

$   1,182,659.00

            37,325
                          Indirect Expenses
                                              Administrative
              Marketing                          26%
               21%




Maintenance
   10%


     Insurance
        5%
                                                   Depreciation
                              Energy
                                                     22%
                              16%