Question

In: Accounting

The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of...

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


2. What other factors in addition to occupancy-days are likely to affect the variation in electrical costs from month to month? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

  • Systematic factors like guests, switching off fans and lights.unanswered
  • Number of days present in a month.unanswered
  • Income taxes paid on hotel income.unanswered
  • Seasonal factors like winter or summer.unanswered
  • Fixed salary paid to hotel receptionist.

Solutions

Expert Solution

High low method uses highest and lowest activity to find variable cost

Occupancy days Electrical cost
High activity level 4,470 $18,860
Low activity level 980 $4,900
change 3,490[4470-980] $13,960[$18,860-4,900]
Variable cost $4[$13,960/3,490]
Fixed cost* $980

*Total cost = variable cost+fixed cost

$18,860=$4*4,470 + fixed cost

fixed cost = $980

2)

  • Systematic factors like guests, switching off fans and lights. √
  • Number of days present in a month.√
  • Seasonal factors like winter or summer.√

Income taxes paid on hotel income.wont affect the electrical cost.. Electrical cost affects income tax

Fixed salary paid to hotel receptionist wii not affect electrical cost.

Seasonal factors like winter or summer affects electrical cost as eclectrical cost would be higher in summers due to higher power consumption

Number of days present in a month and Systematic factors like guests, switching off fans and lights affectes electrical cost .Higher the days present higher the electrical cost

Please upvote if you find this helpful.Incase of query please comment.


Related Solutions

The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of...
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 2,710 $ 5,270 February 3,600 $ 6,205 March 860 $ 2,150 April 2,170 $ 4,350 May 4,200 $ 7,160 June 1,530 $...
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of...
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.   Month Occupancy- Days Electrical Costs   January 3,180          $ 6,510   February 2,920          $ 6,261   March 3,780          $ 7,392         April 2,160          $ 5,569...
Exercise 5A-1 High-Low Method [LO5-10] The Cheyenne Hotel in Big Sky, Montana, has accumulated records of...
Exercise 5A-1 High-Low Method [LO5-10] 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,560 $ 6,573 February 3,420 $ 6,209 March 4,120 $ 7,022       April 1,990 $ 5,174      ...
The Katz Motel in Nowhere, Kansas, has accumulated records of the total electrical costs of the...
The Katz Motel in Nowhere, Kansas, has accumulated records of the total electrical costs of the motel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The motel’s business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy-Days Electrical Costs January 3,180 $ 6,510 February 2,920 $ 6,261 March 3,780 $ 7,392 April 2,160 $ 5,569 May 650 $ 1,820 June 2,050 $ 5,261...
Please show me step by step. Exercise 6A-1 High-Low Method [LO6-10] The Cheyenne Hotel in Big...
Please show me step by step. Exercise 6A-1 High-Low Method [LO6-10] 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 1,736 $ 4,127 February 1,904 $ 4,207 March 2,356 $ 5,083...
Let's assume A Hotel has 900 rooms. The total fix costs for thehotel on any...
Let's assume A Hotel has 900 rooms. The total fix costs for the hotel on any given night are 22350.The variable costs per rooms is 43. assume the average daily rate for hotel last night is 90. How many room have been sold be break-even last night? What percent of occupancy should have made to be break-even last night?
Alexandra Marcus, manager of the Sky Club Hotel, has requested your assistance on a queuing issue...
Alexandra Marcus, manager of the Sky Club Hotel, has requested your assistance on a queuing issue to improve the guest service at the hotel. Alexandra Marcus is considering how to restructure the front desk to reach an optimal level of staff efficiency and guest service. Observation of arrivals during the peak check-in time of 3:00PM to 5:00PM shows that an average of 80 guests arrive each hour. It takes an average of 3 minutes for the front-desk clerk to register...
High-Low and Cost Formula Harrison Company has accumulated the following total manufacturing overhead costs for two...
High-Low and Cost Formula Harrison Company has accumulated the following total manufacturing overhead costs for two levels of activity (within the relevant range): Low High Activity (direct labor hours) 90,000 130,000 Total manufacturing overhead $484,000 $628,000 The total overhead cost includes variable, fixed, and mixed costs. At 130,000 direct labor hours, the total cost breakdown is as follows: Variable cost $286,000 Fixed cost 85,000 Semi-mixed cost $257,000 a. Using the high-low method of cost analysis, determine the variable portion of...
High-Low and Cost Formula Adams Company has accumulated the following total manufacturing overhead costs for two...
High-Low and Cost Formula Adams Company has accumulated the following total manufacturing overhead costs for two levels of activity (within the relevant range): Low High Activity (direct labor hours) 30,000 50,000 Total manufacturing overhead $270,000 $362,000 The total overhead cost includes variable, fixed, and mixed costs. At 50,000 direct labor hours, the total cost breakdown is as follows: Variable cost $200,000 Fixed cost 90,000 Semi-mixed cost $72,000 a. Using the high-low method of cost analysis, determine the variable portion of...
The director of capital budgeting for Big Sky Health System, Inc. has estimated the following cash...
The director of capital budgeting for Big Sky Health System, Inc. has estimated the following cash flows for a new service and has a cost of capital of 8%. What is the project’s payback period? year annual cash flows project cost of capital 0 $ (125,000) 8% 1 $ 75,000 2 $ 55,000 3 $ 25,000 Choice: 4 years Choice: Not enough information to tell. Choice: 1.91 years Choice: 2.4 years
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT