The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows:...

Transcribed Image Text:

The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows: Custodial Occupancy Supplies. Month Days Expense March 18,400 $13,700 April 12,820 14,250 May 15,480 16,750 June 29,700 20,050 July 26,400 23,000 August 18,400 17,650 September 15,300 16,800 Occupancy-days are a measure of the overall activity at the hotel. For example, when a guest stays at the hotel for three days, it is counted as three occupancy-days. Required: 1. Using the high-low method, estimate a cost formula for custodial supplies expense. (Round the "Fixed cost" to the nearest dollar amount and "Variable cost" to 2 decimal places.) 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 14,600 occupancy-days? (In your computations, round "Variable cost per unit" to 2 decimal places and final answers to the nearest dollar amount.) Variable cost Fixed cost Total cost Amount $ 0 The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows: Custodial Occupancy Supplies. Month Days Expense March 18,400 $13,700 April 12,820 14,250 May 15,480 16,750 June 29,700 20,050 July 26,400 23,000 August 18,400 17,650 September 15,300 16,800 Occupancy-days are a measure of the overall activity at the hotel. For example, when a guest stays at the hotel for three days, it is counted as three occupancy-days. Required: 1. Using the high-low method, estimate a cost formula for custodial supplies expense. (Round the "Fixed cost" to the nearest dollar amount and "Variable cost" to 2 decimal places.) 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 14,600 occupancy-days? (In your computations, round "Variable cost per unit" to 2 decimal places and final answers to the nearest dollar amount.) Variable cost Fixed cost Total cost Amount $ 0