Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Lakeshore Hotel's occupancy days and custodial supplies expense over the last seven months were as follows: Custodial Supplies Month Occupancy Days Expense March 513700

image text in transcribed
image text in transcribed
The Lakeshore Hotel's occupancy days and custodial supplies expense over the last seven months were as follows: Custodial Supplies Month Occupancy Days Expense March 513700 8 200 12.950 13 300 16750 ine 20.500 20.050 26.400 23.000 August 18.400 17650 September 15.300 15,800 7000 Apri May Occupancy days are a menure 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 fowed 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 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 17 600 neinar. Round the "Fred cost to the nearest dollar amount Check my work Required: 1. Using least squares regression (you may use a spreadsheet to compute the fixed and variable contu), estimates cost formula for custodial supplies expense. (Round the "Fixed cost to the nearest dollar amount and "Variable cost" to 2 decimal places) 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,600 occupancy.days (Round the "Fixed coor" to the nearest dollar amount) Variable cost Fixed cost Total cost $ 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions

Question

What needs do all people have in common?

Answered: 1 week ago