A B D E Blue Valley Resort 1 2 Profit Analysis Business Executive Room 3 Spa Restaurant Center 4 Sales $70,000.00 $350,000.00 $625,850.00 $180,000.00 5 Cost of Sales 36,715.00 106,500.00 325,600.00 14,790.00 6 Direct Expenses 14,750.00 53,890.00 252,975.00 8,435.00 7 Indirect Expenses 8 Administrative $3,097.87 $15,489.36 $27,697.19 $7,965.96 9 Rent 6,100.60 21,474.10 14,641.43 2,196.22 10 Electricity 1,965.55 9,827.73 17,573.39 5,054.26 11 Utility 1,245.02 4,382.47 2,988.05 448.21 12 Maintenance 2,589.64 9,115.54 6,215.14 932.27 13 Miscellaneous 2,232.60 11.163.02 19,961.08 5,740.98 14 Total Indirect Expenses $17,231.28 $71,452.23 $89,076.29 $22,337.90 15 Net Income $1,303.72 2,500 $118,157.77 ($41,801.29) $134,437.10 6,000 16 Square Footage 8,800 900 17 18 Planned Indirect Expenses 19 Administrative $72,500.00 20 Depreciation $61,250.00 21 $46,000.00 Electricity Insurance Maintenance Marketing $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. 1. In order to have the Total Net Income Equal to $500,000.00, the administrative expense must be 2. In order to have the Total Net Income Equal to $490,000.00, the electricity expense must be 3. In order to have the Total Net Income Equal to $480,000.00, the maintenance expense must be 58222 23 24 258827 29 F G Conference Rooms Reception $190,251.00 $222,120.00 45,125.00 8,650.00 22,475.00 6,940,00 $8,419.62 $9,829.99 13,909.36 2,928.29 5,342.10 6,236.96 2,838.65 597.61 5,904.38 1,243.03 6,067.93 7,084.37 $42,482.05 $27,920.25 $50,168.95 $178,609.75 5,700 1,200 30 H Total $1,638,221.00 537,380.00 359,465.00 $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