Paste Accounting Copy - Format Painter Clipboard 2 Wrap Me Meigha Centet % 9948 Conditional format as Formatting Tables Styles R23 X fo -38-84/GoalSeek!R23 H Spa $70,000.00 36,715.00 14,750.00 Executive Room $350,000.00 106,600.00 63,890.00 Restaurant $625,850.00 325,600.00 252,975.00 Business Center $180,000.00 14,790.00 8,435.00 Conference Rooms $190,251.00 45,125.00 22,475.00 Reception R ON 8,650.00 6,940.00 Total 51,638,221.00 637,380.00 369,465.00 4 Sales 5 Cost of Sales 6 Direct Expenses 7 Indirect Expenses 8 Administrative 9 Rent 10 Electricity 11 Utility 12 Maintenance 13 Miscellaneous 14 Total Indirect Expenses 15 Net Income 16 Square Footage $3,097.87 6,100.60 1,965.55 1,245.02 2,589.64 2,232.60 $17,231.28 $1,303.72 2,500 $15,489.36 2 1,474.10 9,827.73 4,382.47 9,115.54 11,163.02 $71,452.23 $118,157.77 8,800 $27,697.19 $7,965.96 14,641.43 2,196.22 17,573.39 5,054.26 2,988.05 448.21 6,215.14 932.27 19,961.085 ,740.98 $89,076.29 $22,337.90 (541,801.29) $134,437.10 6,000 900 $8,419.62 $9,829.99 13,909.36 2,928.29 5,342.10 6,236.96 2,838.65 5 97.61 5,904.38 1,243.03 6,067.93 7,084.37 $42,482.06 $27,920.25 $80,168.95 #wwwwwwwww 5,700 1,200 $72,500.00 61,250.00 46,000.00 12,500.00 26,000.00 52,250.00 $270,500.00 $470,876.00 25,100 17 18 Planned Indirect Expenses 19 Administrative 20 Depreciation 21 Electricity 22 Insurance 23 Maintenance 24 Marketing $72,500.00 $61,250.00 $46,000.00 $12,500.00 $26,000.00 $52,250.00 26 Use the data provided above to answer the folowing questions. Use the Goal Seek Tool and TYPE the answer into the blue cell 27 1. In order to have the Total Net Income Equal to $500,000.00, the administrative expense must be 28 2. In order to have the Total Net Income Equal to $490,000.00, the electricity expense must be 29 3. In order to have the Total Net Income Equal to $480,000.00, the maintenance expense must be 30 11 11 Name Johnson Matilda 1