Question

The Jedi Hotel has been tracking its property repairs and maintenance costs (PR&M) over the past year. The results were as follows for the year:

The Jedi Hotel Month Activity (Room Nights Sold) PR&M Costs

January 2050 $3,225

February 2800 $3,754

March 3200 $3,947

April 3800 $4,091

May 4100 $4,572

June 4350 $5,583

July 4700 $5,824

August 4900 $6,257

September 4500 $5,727

October 3300 $3,995

November 2700 $3,706

December 2400 $3,465

Required: Using the high-low two point method:

1. Calculate the variable cost per room night sold.

2. Calculate the monthly fixed PR&M cost.

3. Estimate the total amount that the Jedi Hotel will spend on PR&M cost when the forecasted activity level for the month is: 4813 room nights.

Answer 1

From the given data:

At High Point (August) :

• Activity = 4900
• PR & M Cost = $6257

At Low point (January) :

• Activity = 2050
• PR & M Cost = $3225

1, Variable Cost per room night sold = Change in variable cost / change in activity level

= (6257 - 3225) / (4900 - 2050)

= 1.0639 per room night

2. Monthly Fixed PR & M Cost:

At 4900 room night = 6257 - 4900 * 1.0639 = $1044

3. When the forcasted activity level for the month is 4813 room nights

• Variable Cost = 4813 * 1.0639 = $5121
• Fixed Cost = $1044

Therefore total cost of PR & M at 4813 level = $5121 + $1044 = $6,165

Kindly Up Vote