Question

In: Accounting

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 April 960 $ 2,857 May 360 $ 1,871 June 744 $ 2,696 July 2,108 $ 4,670 August 2,406 $ 5,148 September 840 $ 2,691 October 124 $ 1,588 November 720 $ 2,454 December 1,364 $ 3,529 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.) Seasonal factors like winter or summer. unchecked Systematic factors like guests, switching off fans and lights. unchecked Number of days present in a month. unchecked Fixed salary paid to hotel receptionist. unchecked Income taxes paid on hotel income. unchecked

Solutions

Expert Solution

Solution:-

1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day:-

Fixed cost 1,395 Per month
Variable cost 1.56 Per occupancy day

Explanation:-

Occupancy days Electricial cost
High activity level (august) 2,406 5,148
Low level activity (October) 124 1,588
Change 2,282 3,560

Variable cost= Change in cost ÷ Change in activity

= $3,560 ÷ 2,282 occupancy-days

= 1.56 per occupancy-day

Total cost (august) 5,148
Variable cost element ($1.56 per occupancy-day × 2,406 occupancy-days 3,753
Fixed cost element 1,395

2. What other factors in addition to occupancy-days are likely to affect the variation in electrical costs from month to month:-

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

?

Income taxes paid on hotel income

?


Related Solutions

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      ...
Exercise 6A-3 Cost Behavior; High-Low Method [LO6-10] Hoi Chong Transport, Ltd., operates a fleet of delivery...
Exercise 6A-3 Cost Behavior; High-Low Method [LO6-10] Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 96,000 kilometers during a year, the average operating cost is 10.3 cents per kilometer. If a truck is driven only 64,000 kilometers during a year, the average operating cost increases to 11.5 cents per kilometer. Required: 1. Using the high-low method, estimate the variable operating cost per kilometer and the annual...
Chapter 6 Homework Problem 6A-8 High-Low Method; Predicting Cost [LO6-10] Nova Company’s total overhead cost at...
Chapter 6 Homework Problem 6A-8 High-Low Method; Predicting Cost [LO6-10] Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine- Hours Total Overhead Cost April 46,000 $ 168,260 May 36,000 $ 144,660 June 56,000 $ 191,860 July 66,000 $ 215,460 Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 36,000 machine-hour level of activity is: Utilities (variable) $ 46,800 Supervisory salaries (fixed) 45,000...
Please show me the solution step by step. Exercise 9-16 Flexible Budgets in a Cost Center...
Please show me the solution step by step. Exercise 9-16 Flexible Budgets in a Cost Center [LO9-1, LO9-2] Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $15.80q Indirect labor $8,200 + $1.60q Utilities $6,400 + $0.80q Supplies...
1. What is the duration of the critical path? Please show me step by step on...
1. What is the duration of the critical path? Please show me step by step on how you were able to solve this. I WANT TO KNOW IN DETAILED STEPS ON HOW YOU DO THIS, I HAVE NO CLUE/HAVE KNOWLEDGE ABOUT THIS. Activity Duration Predecessor A 2 Start B 4 A,E C 6 A D 3 B,C E 7 Start F 2 E End - D,F
please show me step by step this problem? Problem 10-18 Return on Investment (ROI) and Residual...
please show me step by step this problem? Problem 10-18 Return on Investment (ROI) and Residual Income [LO10-1, LO10-2] “I know headquarters wants us to add that new product line,” said Dell Havasi, manager of Billings Company’s Office Products Division. “But I want to see the numbers before I make any move. Our division’s return on investment (ROI) has led the company for three years, and I don’t want any letdown.” Billings Company is a decentralized wholesaler with five autonomous...
Integrative Exercise Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel Using the High-Low Method to...
Integrative Exercise Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel Using the High-Low Method to Estimate Variable and Fixed Costs Located on Swiftcurrent Lake in Glacier National Park, Many Glacier Hotel was built in 1915 by the Great Northern Railway. In an effort to supplement its lodging revenue, the hotel decided in 20X1 to begin manufacturing and selling small wooden canoes decorated with symbols hand painted by Native Americans living near the park. Due to the great success of...
And please show me the step by step process of how you solved the question. I...
And please show me the step by step process of how you solved the question. I have a learning disability and I need to know the steps to solve the question If it takes 17.5 mL of 0.085 M NaOH to titrate a 15 mL sample of sauerkraut juice, what is the acidity of that juice, expressed as % lactic acid (wt/vol)?
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed “gross-ton miles,” which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $854,100 325,000 February 952,200 363,000 March 673,000 235,000 April 913,000 351,000 May 765,700...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed “gross-ton miles,” which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $929,600 247,000 February 1,036,400 276,000 March 732,500 179,000 April 993,700 268,000 May 833,400...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT