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 hotels business is highly seasonal, with peaks occurring during the ski season and in the summer Month Occupancy Days Electrical Costs January 2,640 $ 13,200 February 2,860 $ 14,300 March 980 $ 4,900 April 2,420 $ 12,100 May 2,090 $ 10,450 June 4,470 $ 18,860 July 4,020 $ 17,160 August 3,940 $ 16,760 September 1,630 $ 8,150 October 1,090 $ 5,450 November 1,390 $ 6,950 December 2,910 $ 14,550 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 )

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 30, 2024

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

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 hotels business is highly seasonal, with peaks occurring during the ski season and in the summer.

Month	Occupancy-Days	Electrical Costs
January	2,640	$	13,200
February	2,860	$	14,300
March	980	$	4,900
April	2,420	$	12,100
May	2,090	$	10,450
June	4,470	$	18,860
July	4,020	$	17,160
August	3,940	$	16,760
September	1,630	$	8,150
October	1,090	$	5,450
November	1,390	$	6,950
December	2,910	$	14,550

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.)