Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Lakeshore Hotels occupancy-days and custodial supplies expense over the last seven months were as follows: Month Occupancy-Days Custodial Supplies Expense March 9,600 $ 15,480

The Lakeshore Hotels occupancy-days and custodial supplies expense over the last seven months were as follows:

Month Occupancy-Days Custodial Supplies Expense
March 9,600 $ 15,480
April 8,800 13,890
May 12,700 18,260
June 20,500 24,200
July 28,200 30,360
August 19,600 22,130
September 15,900 19,870

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

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,800 occupancy-days? (Round the "Fixed cost" to the nearest dollar amount.)

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