The Lakeshore Hoter's guest-days of occupancy and custodial supplies expense over the last seven months were: Month March April May June July August Guest-Days of Supplies Expense S 13,100 s12,600 15,100 11,000 16,600 18,600 17,800 15,100 7,500 7,000 9,500 13,000 12,000 9,500 Guest-days is a measure of the overall activity at the hotel. For example, a guest who stays at the hotel for three days is counted as three guest-days Required: 1. Using the high-low method, estimate a cost formula for custodial supplies expense. (Do not round your intermediate calculations and Round the Variable cost por quest-day to 2 decimal points) Quest-Days Supplies High activity level Low activity level Change Variable cost per guest-day Fixed cost per month per guest-day formula you derived above, what amount of custodial supplies expense would you expect to be incurred at an occupanoy Intermedlate calculations.) level of 12,200 guest-days? (Do not round your Variable cost Flxed cost Total cost 3. Prepare a scattergraph using the data given above. (Place custodial supplies expense on the vertical axis and guest-days on the hortzoalaxis. Rtound your plotting points to the nearest hundredth value.) Instructions: 1.On the graph below, use the point tool (Mar) to plot custodial supplies expense on the vertical axis and guest-days on the horizontal axis. 2. Repeat the same process for the plotter tools (Apr, May, June, July, Aug, Sep). 3. To enter exact coordinates, click on the point and enter the values of x and y 4. To remove a point from the graph, click on the point and select delete option. May 00 10000 4000 18000 18000 Guest Days