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.) Y = 9,345 + $ 0.71 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 12,000 occupancy-days? (Round the "Fixed cost" to the nearest dollar amount.)
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.) Y = 9,345 + $ 0.71 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 12,000 occupancy-days? (Round the "Fixed cost" to the nearest dollar amount.)
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
$9345 is incorrect.

Transcribed Image Text:The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months
were as follows:
Custodial
Supplies
Expense
$ 14,430
14,180
19,420
23,950
27,450
20,710
19,450
Occupancy-
Days
6,900
Month
March
April
May
7,900
13,600
20,500
25,500
17,800
15,000
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.)
Y =
9,345 +
$
0.71 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 12,000 occupancy-days? (Round the "Fixed cost" to the
nearest dollar amount.)
Variable cost
Fixed cost
Total cost
8,520
$
8,520
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images

Knowledge Booster
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.Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education