Please, help with excel assignment. and if possible, provide the formulas to type in?

E F G H Blue Valley Resort Profit Analysis Business Conference Executive Room Spa Restaurant Center Rooms Reception Total Sales $190,251.00 $222,120.00 $1,638,221.00 $70,000.00 $350,000.00 $625,850.00 $180,000.00 36,715.00 106,500.00 325,600.00 14,790.00 45,125.00 8,650.00 537,380.00 14,750.00 53,890.00 252,975.00 8,435.00 22,475.00 6,940.00 359,465.00 Cost of Sales Direct Expenses Indirect Expenses Administrative $3,097.87 $15,489.36 $27,697.19 $7,965.96 $8,419.62 $9,829.99 $72,500.00 6,100.60 21,474.10 14,641.43 2,196.22 13,909.36 2,928.29 61,250.00 Rent Electricity Utility 1,965.55 9,827.73 17,573.39 5,054.26 5,342.10 6,236.96 46,000.00 1,245.02 4,382.47 2,988.05 448.21 2,838.65 597.61 12,500.00 Maintenance 2,589.64 9,115.54 6,215.14 932.27 5,904.38 1,243.03 26,000.00 Miscellaneous 2,232.60 11,163.02 19,961.08 5,740.98 6,067.93 7,084.37 52,250.00 Total Indirect Expenses Net Income $17,231.28 $71,452.23 $1,303.72 $118,157.77 2,500 8,800 $89,076.29 $22,337.90 ($41,801.29) $134,437.10 6,000 $42,482.05 $27,920.25 $80,168.95 $178,609.75 5,700 1,200 $270,500.00 $470,876.00 25,100 Square Footage 900 Planned Indirect Expenses Administrative $72,500.00 Depreciation $61,250.00 Electricity $46,000.00 Insurance $12,500.00 Maintenance $26,000.00 Marketing $52.250.00 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 Name: AyadMaged||||||||||||| Instructions 1. Use Goal Seek function to determine the value in cells H27-H29. Please ensure once you solved for an answer, click "cancel" to return to the original data before starting another goal seek