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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education