Home Insert Page Layout Formulas Data Review View 9 10 wrap

Home Insert Page Layout Formulas Data Review View 9 10 wrap Text Paste Merge & Center- Si. % , il ta\' conditional Format Cel Formatting as Table Styles 86*84 Casa Grande Resort & Spa Profit Center Analysis of Indirect Expenses Conference Children Spa Restaurant CenterRooms Shop Game Roonm Total Net Revenue Cost of Sales Direct 715,00, 14,750.00 1- 8.865 0013-492,800001-486725.001-592,500.00 1- 106,500.001-325,000.00 136,500 00 152.9 75.00 14,790.00 8,435.00 $125.00 196,475.00 3 88450.00 19,450.00 S 2,180,390.00 37.000.001 8650.00 710,880.00 6.940.00 S 544 240.00 297500 22.475001 31,800.00 Indirect Expenses Administrative Depreciation Insuran Maintenance Marketing Total Indirect Expenses Net Income Square Footage 2500 5100 8800 6000 900 5700 750 1200 Planned Indirect Expenses $72,500.00 $61,250.00 $46,000.00 $12,500.00 26,000.00 52,250.00 Marketin Instructions #fFunction1 lfFunction2 Indirect Expenses Goa Seek +

Solution

Casa Grande Resort & Spa Profit Center analysis of Indirect Expenses Spa Lounge Banquet Room Restaurant Business center Conference Rooms Gift shop Childern\'s Game Room Total Total Net Revenue 78865 492800 486725 592500 225125 196475 88450 19450 2180390 Cost of sales 36715 136500 106500 325600 14790 45125 37000 8650 710880 Direct expenses 14750 152975 53890 252975 8435 22475 31800 6940 544240 Indirect expenses Administrative 2622.33 16386.06 16184.06 19701.18 7485.62 6532.98 2941.04 646.73 72500 Depreciation 4947.50 10092.89 17415.19 11873.99 1781.10 11280.29 1484.25 2374.80 61250 Energy 1663.83 10396.67 10268.51 12500.06 4749.49 4145.06 1866.04 410.34 46000 Insurance 1009.69 2059.77 3554.12 2423.26 363.49 2302.10 302.91 484.65 12500 Maintenance 2100.16 4284.33 7392.57 5040.39 756.06 4788.37 630.05 1008.08 26000 Marketing 1889.89 11809.26 11663.68 14198.43 5394.81 4708.25 2119.58 466.09 52250 Total Indirect expenses 14233.40 55028.99 66478.13 65737.31 20530.56 33757.05 9343.87 5390.69 270500.00 Net Income 13166.60 148296.01 259856.87 -51812.31 181369.44 95117.95 10306.13 -1530.69 654770.00 Square footage 2500 5100 8800 6000 900 5700 750 1200 30950