Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2 The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows: Custodial Supplies 10 Occupancy- Month points Days

image text in transcribed

2 The Lakeshore Hotel's occupancy-days and custodial supplies expense over the last seven months were as follows: Custodial Supplies 10 Occupancy- Month points Days Expense March 9,300 $ 19,180 April 8,700 17,870 May 12,800 21,580 June 20,500 25,900 Print July August 27,900 30,340 19,400 23,890 September 15,800 22,430 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 = EX 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 14,600 occupancy-days? (Round the "Fixed cost" to the nearest dollar amount.) Variable cost Fixed cost Total cost

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting concepts and applications

Authors: Albrecht Stice, Stice Swain

11th Edition

978-0538750196, 538745487, 538750197, 978-0538745482

More Books

Students also viewed these Accounting questions