ONLY QUESTION #5, AND SHOW THE STEPS ON HOW TO FORMAT THE OUTPUT

Questionl Ada Hotel has been tracking its utilities expense over the past years. For 2017, the results were as follows Ada Hotel Month Activity (Room Nights Sold) Utilities Expense S5,910 S5,970 S6,138 S7,170 S8,010 S8,274 9,090 S9,570 $8,970 $8,070 $7,110 6,330 nu 2050 March 2240 3100 3800 4020 4700 5100 4600 3850 3050 2400 Ma June Jul Se October November December ber Managers of Ada Hotel believe that utilities expense is a mixed cost. Required Using the high-low two-point method, determine the variable utilities expense per room night sold for the Ada Hotel Calculate the monthly fixed utilities expense and variable utilities expense for the high activity month. Construct the cost function based on the high-low two point method, and estimate the total amount that Ada Hotel will spend on utilities expense when the forecasted activity level for the month is 5,450 rooms in a given month. Prepare the scatter diagram and show the cost function from the scatter diagram Run regression analysis on Excel to determine the variable cost per unit and fixed cost for utilities expense per month. Format your output neatly so that it clearly shows variable cost per unit and fixed cost per month. 1. 2. 3. 4. 5