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. Electrical Costs Month Occupancy- Days January 540 $ 1,620 February 3,810 $ 8,352 March 4,100 $ 8,736 April 1,730 $ 5,190 May 3,520 $ 7,968 June 1,320 $ 3,960 July 3,420 $ 7,668 August 4,120 $ 8,780 September 1,610 $ 4,830 October 830 $ 2,490 November December 1,420 2,320 $ 4,260 $ 6,960 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 per occupancy-day Fixed cost of electricity per month
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. Electrical Costs Month Occupancy- Days January 540 $ 1,620 February 3,810 $ 8,352 March 4,100 $ 8,736 April 1,730 $ 5,190 May 3,520 $ 7,968 June 1,320 $ 3,960 July 3,420 $ 7,668 August 4,120 $ 8,780 September 1,610 $ 4,830 October 830 $ 2,490 November December 1,420 2,320 $ 4,260 $ 6,960 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 per occupancy-day Fixed cost of electricity per month
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Help follow out pls
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.
Electrical
Costs
Month
Occupancy-
Days
January
540
$ 1,620
February
3,810
$ 8,352
March
4,100
$ 8,736
April
1,730
$ 5,190
May
3,520
$ 7,968
June
1,320
$ 3,960
July
3,420
$ 7,668
August
4,120
$ 8,780
September
1,610
$ 4,830
October
830
$ 2,490
November
December
1,420
2,320
$ 4,260
$ 6,960
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
per occupancy-day
Fixed cost of electricity
per month
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education