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. Month Occupancy-Days Electrical Costs January 3,030 $9,044 February 3,080 $9,234 March 3,980 $11,913 April 1,630 $6,194 May 1,270 $4,826 June 2,110 $8,018 July 650 $2,470 August 3,690 $11,552 September 1,960 $7,448 October 4,410 $12,998 November 1,600 $6,080 December 2,230 $8,474 Required: Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy day.

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter3: Cost Behavior
Section: Chapter Questions
Problem 2CE: Corazon Manufacturing Company has a purchasing department staffed by five purchasing agents. Each...
icon
Related questions
Question
100%

The Cheyenne Hotel in Big Sky, please provide answer the accounting question

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.
Month
Occupancy-Days Electrical Costs
January
3,030
$9,044
February 3,080
$9,234
March
3,980
$11,913
April
1,630
$6,194
May
1,270
$4,826
June
2,110
$8,018
July
650
$2,470
August 3,690
$11,552
September 1,960
$7,448
October 4,410
$12,998
November 1,600
$6,080
December 2,230
$8,474
Required:
Using the high-low method, estimate the fixed cost of electricity per month and the
variable cost of electricity per occupancy day.
Transcribed Image Text: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. Month Occupancy-Days Electrical Costs January 3,030 $9,044 February 3,080 $9,234 March 3,980 $11,913 April 1,630 $6,194 May 1,270 $4,826 June 2,110 $8,018 July 650 $2,470 August 3,690 $11,552 September 1,960 $7,448 October 4,410 $12,998 November 1,600 $6,080 December 2,230 $8,474 Required: Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy day.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning