Question & Answer: The Cheyenne Hotel in Big sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days…..

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 out for one day. The hotels business is highly seasonal, with peaks occurring during the ski season and in the summer Occupancy- Days 3,300 2,960 3,550 1,600 1,370 1,350 3,490 3,750 1,390 1,060 1,520 2,900 Electrical Costs $8,024 $7,767 $8,265 $4,800 $4,110 $4,050 $8,117 $8,560 $4,170 $3,180 $4,560 $7,746 Month January February March ril May June Li August September October November December 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) Occupancy Days Electrical Costs High activity level Low activity level Change Variable cost per occupancy-day Fixed cost element

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 out for one day. The hotel’s business is highly seasonal, with peaks occurring during the ski season and in the summer. 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)

Expert Answer

 

Occupancy days Electrical costs
High activity level 3750 $8560
Low activity level 1060 $3180
Change (3750-1060)=2690 (8560-3180)=$5380
Variable cost(Change in electrical costs/Change in occupancy days) ($5380/2690)=$2 per occupancy day
Fixed cost element $8560-(2*3750)

=$1060.

Still stressed from student homework?
Get quality assistance from academic writers!