Question: 10 Exercise 5A-1 (Algo) High-Low Method [LO5-10] 10 points The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs

10 Exercise 5A-1 (Algo) High-Low Method [LO5-10] 10 points The Cheyenne Hotelin Big Sky, Montana, has accumulated records of the total electrical costsof the hotel and the number of occupancy-days over the last year.An occupancy-day represents a room rented for one day. The hotel's businessis highly seasonal, with peaks occurring during the ski season and inthe summer. Occupancy-Days 3,000 Electrical Costa $15,000 Month eBook January February 850$4,250 March- 4,430 $18,570 H April 1,470 $7,350 May 3,650 Print $18,250

10 Exercise 5A-1 (Algo) High-Low Method [LO5-10] 10 points The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Occupancy-Days 3,000 Electrical Costa $15,000 Month eBook January February 850 $4,250 March- 4,430 $18,570 H April 1,470 $7,350 May 3,650 Print $18,250 June 1,120 $.5,600 References July 3,910 $17,425 August 3,840 $17,288 September 1,900 $9,500 October 1,090 $ 5,450 November 2,040 December 2,990 $10,200 $14,950 Required: 1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. (Do not round your intermediate calculations. Round your Variable cost answer to 2 decimal places and Fixed cost element answer to nearest whole dollar amount.) Variable cost of electricity Fixed cost of electricity per occupancy-day per month Check my wor

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!