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