The Lakeshore Hotel guest days of occupancy and custodial supplies expense over the last seven months were:                                                                                             Month           Guest Days of Occupancy            Custodial Supplies Expense March                                                                                                                          4,000                             $7,500 April                                                                                                                                                        6,500                               $8,250 May                                                                                                                               8,000                            $10,500 June                                                                                                                                                                                                                                                                                       12,000                              $13,500 July                                                                                                                                  9,000                          $10,750 August                                                                                                                             7,500                       $  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: Use the High-Low method, estimate a cost formula for custodial supplies expense 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?

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 12EB: Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the...
icon
Related questions
icon
Concept explainers
Question

The Lakeshore Hotel guest days of occupancy and custodial supplies expense over the last seven months were:

                                                                                         

 

Month           Guest Days of Occupancy            Custodial Supplies Expense

March                                                                                                                          4,000                             $7,500

April                                                                                                                                                        6,500                               $8,250

May                                                                                                                               8,000                            $10,500

June                                                                                                                                                                                                                                                                                       12,000                              $13,500

July                                                                                                                                  9,000                          $10,750

August                                                                                                                             7,500                       $  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. Use the High-Low method, estimate a cost formula for custodial supplies expense
  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?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
PAYROLL ACCT., 2019 ED.(LL)-TEXT
PAYROLL ACCT., 2019 ED.(LL)-TEXT
Accounting
ISBN:
9781337619783
Author:
BIEG
Publisher:
CENGAGE L