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.)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

$9345 is incorrect.

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
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
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Accounting Changes and Error Analysis
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education