Ada Hotel Month Activity (Room Nights Sold) Utilities Expense $5,910 $5,970 $6,138 $7,170 $8,010 $8,274 $9,090 $9,570 $8,970 $8,070 $7.110 February March 2100 2240 3100 3800 4020 4700 5100 4600 3850 3050 2400 May June July October Decembetr Managers of Ada Hotel believe that utilities expense is a mixed cost. Required: 1. Using the high-low two-point method, determine the variable utilities expense per 2. Calculate the monthly fixed utilities expense and variable utilities expense for the high 3. Construct the cost function based on the high-low two point method, and estimate the room night sold for the Ada Hotel. activity month. 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. the scatter diagram and show the cost function from the scatter diagram ion 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