please answer step by step using excel formula ( or type out how it comes out, like revenues)

A B C D E F G H J K L Mr. Liu, the manager of the MCU Hotel, desires to know the breakdown of the electric costs between variable and fixed elements. WON Month Electronic ExpenseDccupancy Percentage January 6,200 62 April 6,600 68 August 7,200 78 December 5,500 50 LD Using the high/low two point method to: 10 1 Determine the variable cost per 1 percent of occupancy 11 2 Estimate the fixed costs per month 12 3 What is the estimated total electric expense at 62 pecent of occupancy? 13 14 15 ANSWER 16 17 Month Electronic Expenses Occupancy Percentage 18 High ( formula) ( formula) (formula) 19 Low ( formula) (formula) (formula) 20 Difference ( formula) ( formula) 21 22 1 Variable cost per 1% of occupancy = (formula) 23 24 2 Total variable cost of electric expense for December = ( formula) 25 Total fixed cost of electric expense for December = (formula) 26 27 Total variable cost of electric expense for August = (formula) 28 Total fixed cost of electric expense for August = (formula) 29 30 3 Using the fixed cost for December as the total fixed cost for estimation 31 Total variable cost of electric expense at 62% occupancy = (formula) 32 Total fixed cost of electric expense at 62% occupancy = (formula) 33 Estimated total electric expense at 62% occupancy = (formula)