Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The manager of a hotel would like to develop a cost model to predict the future costs of running the hotel. Unfortunately, the only available

The manager of a hotel would like to develop a cost model to predict the future costs of running the hotel. Unfortunately, the only available data is the level of activity (number of guests) in a given month and the total costs incurred in each month. Being a new hire at the company, the manager assigns you the task of anticipating the costs that would be incurred in the following month (September).

Use high low method and calculate

a) variable costs per guest.

b) variable and fixed costs in all months in January-August period.

c) predict total costs in September if you assume 3,000 guests in this month.

d) based on your calculations evaluate how much precisely is the high low method predicting the costs in the hotel, explain your answer.

month total costs number of guests
January 133 000 1 500
February 203 000 2 300
March 87 200 980
April 379 000 4 300
May 398 000 4 500
June 305 000 3 500
July 386 000 4 300
August 188 000 2 100
September 3 000

This is all I got. No more information available...

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

Management Accounting Evolution Not Revolution

Authors: Michael Bromwich, Al Bhimani

1st Edition

0908269137, 978-0908269136

More Books

Students also viewed these Accounting questions

Question

1. Identify the sources for this conflict.

Answered: 1 week ago

Question

3. The group answers the questions.

Answered: 1 week ago