The Lakeshore Hotel's guest-days of occupancy and custodial supplies expense over the last seven months were: Month March April May June July August September Guest-Day of Occupancy 4,000 6,500 8,000 10,500 12,000 9,000 7,500 Custodial Supplies Expense $ 7,500 $ 8,250 $ 10,500 $ 12,000 $ 13,500 $ 10,750 $ 9,750 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. (Round the Variable cost per guest-day to 2 decimal points.) Guest-Days Custodial Supplies Expense High activity level Low activity level Change per guest-day Variable cost per guest-day Fixed cost per month Y= + 2. Using the cost formula you derived above, what amount of custodial supplies expense would you expect to be incurred at an occupancy level of 11,000 guest-days? (Do not round your intermediate calculations.) Variable cost Fixed 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 horizontal axis.) 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. Custodial Supplies Expense 16000 14000 12000- 10000 8000 6000- 4000 2000- Oh 0 2000 4000 6000 8000 10000 12000 14000 Guest Days reset