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
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 DocumentRight 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

This note was uploaded on 06/30/2010 for the course CINS 8009 taught by Professor Jadams during the Spring '09 term at Ivy Tech Community College.

Page1 / 2

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

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online