Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Really need help practising for Exams. The Lakeshore Hotel's guest-days of occupancy and custodial supplies expense over the last seven months were: Guest-days of Custodial

Really need help practising for Exams.

image text in transcribed
The Lakeshore Hotel's guest-days of occupancy and custodial supplies expense over the last seven months were: Guest-days of Custodial Month occupancy supplies expense March 4,100 E 6,485 April 6,700 8,520 May 8,200 9,870 June 10,800 12,180 July 12,300 13,455 August 9,200 10,600 September 7,700 9,545 Guest-days is a measure of the overall activity at the hotel. For example, a guest stay at the hotel lasting for three days is counted as three guest-days Required: 1. The data above should be plotted on a scattergraph and a line of best fit, or a regression line, fitted over the data by visual inspection. The version below represents the above data graphically. Use this for the remaining parts of this question. 2. What is the approximate monthly fixed cost as per the scattergraph? (Round your answer to the nearest whole pound.) What is the approximate variable cost per guest-day as per the scattergraph? (Round fixed cost element to the nearest whole pound in the intermediate calculations. Round your answer to 2 decimal places.) Approximate variable cost per guest-day 3. Scrutinize the points on the graph and explain why the high-low method would or would not yield an accurate cost formula in this situation

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

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

Recommended Textbook for

Using Microsoft Excel And Access 2013 For Accounting

Authors: Glenn Owen

4th Edition

1305161858, 9781305161856

More Books

Students also viewed these Accounting questions

Question

Go, do not wait until I come

Answered: 1 week ago

Question

Make eye contact when talking and listening

Answered: 1 week ago

Question

Do not go, wait until I come

Answered: 1 week ago