Answered step by step
Verified Expert Solution
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
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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started