{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lab 3-3 Rockie View Resort and Spa Indirect Expenses Allocations

Lab 3-3 Rockie View Resort and Spa Indirect Expenses Allocations

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
RockieView Resort & Spa Analysis of Indirect Expenses 1-Jul-10 Lounge Restaurant Spa Total Total Net Revenue $345,819.00  $192,190.00  $52,750.00  $212,300.00  $112,100.00  $622,350.00  $615,350.00  $92,900.00  $2,245,759.00  Cost of Sales  19,750.00   16,235.00   12,900.00   55,250.00   42,100.00   115,400.00   175,000.00   42,150.00   478,785.00  Direct Expenses  9,245.00   9,245.00   7,250.00   19,300.00   37,400.00   101,000.00   115,600.00   24,800.00   323,840.00  Indirect Expenses Administrative $10,394.16  $5,776.59  $1,585.49  $6,381.03  $3,369.35  $18,705.76  $18,495.36  $2,792.26  $67,500.00  Depreciation  16,414.60   1,367.88   2,227.70   9,770.60   2,071.37   11,724.72   10,474.08   4,299.06   58,350.00  Energy  6,513.67   3,620.00   993.57   3,998.78   2,111.46   11,722.28   11,590.43   1,749.82   42,300.00  Insurance  3,347.62   278.97   454.32   1,992.63   422.44   2,391.16   2,136.10   876.76   11,900.00  Maintenance  7,637.64 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 636.47 1,036.54 4,546.22 963.80 5,455.46 4,873.54 2,000.33 27,150.00 Marketing 8,203.69 4,559.23 1,251.36 5,036.29 2,659.29 14,763.69 14,597.64 2,203.82 53,275.00 Total Indirect Expenses $52,511.39 $16,239.13 $7,548.98 $31,725.53 $11,597.70 $64,763.06 $62,167.15 $13,922.06 $260,475.00 Net Income $264,312.61 $150,470.87 $25,051.02 $106,024.47 $21,002.30 $341,186.94 $262,582.85 $12,027.94 $1,182,659.00 Square Footage 10,500 875 1,425 6,250 1,325 7,500 6,700 2,750 37,325 Planned Indirect Expenses Administrative 67,500 Depreciation 58,350 Energy 42,300 Insurance 11,900 Maintenance 27,150 Marketing 53,275 Banquet Room Business Center Children's Game Room Conference Rooms Gift Shop Administrative; 26% Depreciation; 22% Energy; 16% Insurance; 5% Maintenance; 10% Marketing; 20% Indirect Expenses...
View Full Document

{[ snackBarMessage ]}