Trusted by Students Everywhere
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

Accounting Aug 16, 2020

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
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment