The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows: Custodial Occupancy- Days 10,200 9,000 12,500 20,500 28,800 20,000 16,100 Supplies Expense $ 17,540 15,750 19,450 24,750 30,560 23,e50 21,020 Month March April May June July August September 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 least-squares regression (you may use a spreadsheet to compute the fixed and variable costs), estimate a cost formula for custodial supplies expense. (Round the "Fixed cost" to the nearest dollar amount and "Veriable 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 15,200 occupancy-days? (Round the "Fixed cost" to the nearest dollar amount.) Variable cost Fixed cost Total cost

Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter19: Accounting For Post Retirement Benefits
Section: Chapter Questions
Problem 14E: Refer to the information provided in E19-13. Required: Using the years-of-future-service method,...
icon
Related questions
Question
The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows:
Occupancy-
Days
10, 200
9,000
12,500
20,500
28,800
20,000
16,100
Custodial
Supplies
Expense
$ 17,540
15,750
19,450
24,750
30,560
23,050
21,020
Month
March
April
May
June
July
August
September
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 least-squares regression (you may use a spreadsheet to compute the fixed and variable costs), estimate a cost formula for
custodial supplies expense. (Round the "Fixed cost" to the nearest dollar amount and "Variable cost" to 2 decimal places.)
|x
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 15,200 occupancy-days? (Round the "Fixed cost" to the nearest dollar amount.)
Variable cost
Fixed cost
Total cost
Transcribed Image Text:The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows: Occupancy- Days 10, 200 9,000 12,500 20,500 28,800 20,000 16,100 Custodial Supplies Expense $ 17,540 15,750 19,450 24,750 30,560 23,050 21,020 Month March April May June July August September 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 least-squares regression (you may use a spreadsheet to compute the fixed and variable costs), estimate a cost formula for custodial supplies expense. (Round the "Fixed cost" to the nearest dollar amount and "Variable cost" to 2 decimal places.) |x 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 15,200 occupancy-days? (Round the "Fixed cost" to the nearest dollar amount.) Variable cost Fixed cost Total cost
Expert Solution
steps

Step by step

Solved in 3 steps with 6 images

Blurred answer
Knowledge Booster
Attestation engagements
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
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
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub