Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows: Occupancy-Days Expense March9,600 $15,480 April9,800 15,640 May12,700 18,260 June20,500 24,200 July28,200 30,360 August19,600 22,130 September15,900 19,870 Occupancy-days are a measure of the overall activity at the hotel
The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows:
Occupancy-Days Expense
March9,600 $15,480
April9,800 15,640
May12,700 18,260
June20,500 24,200
July28,200 30,360
August19,600 22,130
September15,900 19,870
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 "Variable cost" to 2 decimal places.)
Y= + X
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,800 occupancy-days?
variable cost:
fixed cost:
total cost:
Expert Solution
1.Determination of Cost Formula for Custodial Supplies Expense:
Variable cost per unit = (Highest activity cost - Lowest activity cost)/(Highest activity - Lowest activity)
= ($30,360 - $15,480)/(28,200-9,600)
= $14,880/$18,600
Variable cost per unit = $0.80 per occupancy day
Fixed cost = (Highest activity cost - (Highest activity * Variable cost per occupancy day)
= $30,360 - (28,200*$0.80)
= $30,360 - $22,560
= $7,800
So, cost formula for custodial supplies expense:
Y = a + bX
Y = $7,800 + $0.80X
2.Computation of Amount of Custodial Supplies Expense would you expect to be incurred at an occupancy level of 14,800 occupancy-days:
Amount of Custodial Supplies Expense = $7,800 + $0.80*14,800
= $7,800+$11,840
Amount of Custodial Supplies Expense = $19,640
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





