Question

Arial Copy BU - OAM SHO Sort Find D - 34 (B5-36-314) C Casa Grande Resort & Spa Profit Center Analysis of Indirect Expenses Conference $ Children's Gift Shop 88.450.00 $ 19,450,00 S Total Net Revenue Cost of Sales Direct Expenses $ Banquet Room 436.725.00 S 106,500.00 53.890.00 Spa 78,865.00 36.715.00 14.750.00 Lounge 492,800,00 136.500,00 152,975.00 Business Center 225,125.00 $ 14,790,00 8.435.00 Restaurant 5 92.500.00 325.500.00 252,975.00 196,475,00 S 45,125,00 22.475.00 31.600.00 6.940.00 2.622.33 4.947.50 Indirect Expenses Administrative Depreciation Energy 1 Insurance 2 Maintenance 3 Marketing 4 Total Indirect Expenses 5 Net Income 1.009.69 2.100.16 $1,889.89 14,233.40 13.166.60 2500 Square Footage 16 17 18 Planned Indirect Expenses 19 Administrative $72,500.00 20 Depreciation $61,250.00 21 Energy $46,000.00 Insurance $12,500.00 Instructions Function function indirect Expenses Gone 9 Type here to search DELL

Answer 1

Calibri 11 - AA== on ** Wrap Text General Paste * Cut EL Copy Format Painter Clipboard B IU M - A Merge & Center % 898 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Σ AutoSum * Α. Fill - Sort & Clear Filter Editing Find & Select Font Alignment Number Cells 115 X fr 1200 Spa 2 Total Net Revenue 3 Cost of Sales 4 Direct Expenses Lounge 78865 36715 14750 492800 136500 152975 Е Е Banquet Room Restaurant Business Center Conference Room Gift Shop Children's Game Room Total 486725 592500 225125 196475 88450 19450 106500 325600 14790 45125 37000 8650 53890 252975 8435 22475 31800 6940 2180390 710880 544240 5 6 Indirect Expenses 7 Administrative 8 Depreciation 9 Energy 10 Insurance 11 Maintenance 12 Marketing 13 Total Indirect Expenses 14 Net Income 15 Square Footage 16 17 Planned Indirect expenses 18 Administrative 19 Depreciation 20 Energy 21 Insurance 22 Maintenance 23 Marketing 2622.334766 4947.495961 1663.826196 1009.693053 2100.161551 1889.889538 14233.40107 13166.59893 2500 16386.05937 10092.89176 10396.67215 2059.773829 4284.329564 11809.26348 55028.99016 148296.0098 5100 16184.05996 17415.18578 10268.50701 3554.119548 7392.568659 11663.68459 66478.12556 259856.8744 8800 19701.17731 11873.99031 12500.05733 2423.263328 5040.387722 14198.43468 65737.31068 -51812.31068 6000 7485.616105 1781.098546 4749.494357 363.4894992 756.0581583 5394.80609 20530.56276 181369.4372 900 6532.976899 11280.29079 4145.061205 2302.100162 4788.368336 4708.248868 33757.04626 95117.95374 5700 2941.044951 1484.248788 1866.042314 302.907916 630.0484653 2119.580671 9343.873105 10306.12689 750 646.7306308 2374.798061 410.3394347 484.6526656 1008.077544 466.0920753 5390.690412 -1530.690412 1200) 72500 61250 46000 12500 26000 52250 270500 654770 30950 72500 61250 46000 12500 26000 52250 Activate Windows Go to Settings to activate Sheet1