Lab 3-2 Casa Grande Profit Center Analysis of Indirect Expenses

Lab 3-2 Casa Grande Profit Center Analysis of Indirect Expenses

Info iconThis preview shows pages 1–2. 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,622.33 $16,386.06 $16,184.06 $19,701.18 $7,485.62 Depreciation 4,947.50 10,092.89 17,415.19 11,873.99 1,781.10 Energy 1,663.83 10,396.67 10,268.51 12,500.06 4,749.49 Insurance 1,009.69 2,059.77 3,554.12 2,423.26 363.49 Maintenance 2,100.16 4,284.33 7,392.57 5,040.39 756.06 Marketing 1,889.89 11,809.26 11,663.68 14,198.43 5,394.81 Total Indirect Expenses $14,233.40 $55,028.99 $66,478.13 $65,737.31 $20,530.56 Net Income $13,166.60 $148,296.01 $259,856.87 ($51,812.31) $181,369.44 Square Footage
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: 2500 5100 8800 6000 900 Planned Indirect Expenses Administrative $72,500.00 Depreciation $61,250.00 Energy $46,000.00 Insurance $12,500.00 Maintenance $26,000.00 Marketing $52,250.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 $6,532.98 $2,941.04 $646.73 $72,500.00 11,280.29 1,484.25 2,374.80 61,250.00 4,145.06 1,866.04 410.34 46,000.00 2,302.10 302.91 484.65 12,500.00 4,788.37 630.05 1,008.08 26,000.00 4,708.25 2,119.58 466.09 52,250.00 $33,757.05 $9,343.87 $5,390.69 $270,500.00 $95,117.95 $10,306.13 ($1,530.69) $654,770.00 5700 750 1200 30950 Conference Rooms Children's Game Room...
View Full Document

This note was uploaded on 06/27/2008 for the course CIS 120 taught by Professor Donovan during the Fall '06 term at Mt. Wachusett.

Page1 / 2

Lab 3-2 Casa Grande Profit Center Analysis of Indirect Expenses

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