3-2 Case 2 - $66,250.00 Depreciation $63,000.00 Energy...

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

View Full Document Right Arrow Icon
Profit Center Analysis of Indirect Expenses Spa Lounge Restaurant Total Net Revenue $78,865.00 $492,800.00 $486,725.00 $592,500.00 $225,125.00 Cost of Sales 36,715.00 136,500.00 106,500.00 325,600.00 14,790.00 Direct Expenses 14,750.00 152,975.00 53,890.00 252,975.00 8,435.00 Indirect Expenses Administrative $2,396.27 $14,973.47 $14,788.88 $18,002.80 $6,840.30 Depreciation 5,088.85 10,381.26 17,912.76 12,213.25 1,831.99 Energy 1,139.36 7,119.46 7,031.70 8,559.82 3,252.37 Insurance 1,817.45 3,707.59 6,397.42 4,361.87 654.28 Maintenance 2,261.71 4,613.89 7,961.23 5,428.11 814.22 Marketing 2,170.21 13,560.88 13,393.70 16,304.42 6,194.99 Total Indirect Expenses $14,873.85 $54,356.55 $67,485.69 $64,870.28 $19,588.15 Net Income $12,526.15 $148,968.45 $258,849.31 ($50,945.28) $182,311.85 Square Footage 2500 5100 8800 6000 900 Planned Indirect Expenses Administrative
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
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $66,250.00 Depreciation $63,000.00 Energy $31,500.00 Insurance $22,500.00 Maintenance $28,000.00 Marketing $60,000.00 CIS 120 Web Excel Project 2 on EX215 Donovan Banquet Room Business Center 1/12/2004 Gift Shop Total $196,475.00 $88,450.00 $19,450.00 $2,180,390.00 45,125.00 37,000.00 8,650.00 710,880.00 22,475.00 31,800.00 6,940.00 544,240.00 $5,969.79 $2,687.51 $590.98 $66,250.00 11,602.58 1,526.66 2,442.65 63,000.00 2,838.47 1,277.83 280.99 31,500.00 4,143.78 545.23 872.37 22,500.00 5,156.70 678.51 1,085.62 28,000.00 5,406.60 2,433.97 535.23 60,000.00 $35,117.93 $9,149.71 $5,807.84 $271,250.00 $93,757.07 $10,500.29 ($1,947.84) $654,020.00 5700 750 1200 30950 Conference Rooms Children's Game Room Administrative 24% Depreciation 23% Energy 12% Insurance 8% Maintenance 10% Marketing 22% Breakdown of Indirect Expenses...
View Full Document

Page1 / 3

3-2 Case 2 - $66,250.00 Depreciation $63,000.00 Energy...

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

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