Managerial Accounting
17th Edition
ISBN: 9781260247787
Author: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Publisher: RENT MCG
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 5.A, Problem 1E
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.
Required:
- Using the high-low method, estimate the feed cost of electricity per month and the variable cost of electricity per occupancy-day. Round off the feed cost to the nearest whole dollar and the variable cost to the nearest whole cent.
- What other factors in addition to occupancy-days are likely to affect the variation in electrical costs from month to month?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Exercise 5A-1 (Algo) High-Low Method [LO5-10]
The Cheyenne Hotel in Big Sky, Montana, recorded its total electrical costs and 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
January
February
March.
April
May
June
July
August
September
October
November
December
Occupancy-
Days
3,400
4,150
3,080
2,230
1,570
1,910
3,880
3,830
2,060
1,940
1,050
2,710
Electrical
Costs
$ 9,536
$ 10, 180
Variable cost of electricity
Fixed cost of electricity
$9,184
$ 7,136
$ 5,024
$ 6,112
$ 9,997
$ 9,904
$ 6,592
$ 6,208
$ 3,360
$ 8,168
Required:
1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day.
Note: 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.
per…
High-Low Method
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.
Required:
1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. Round off the fixed cost to the nearest whole dollar and the variable cost to the nearest whole cent.
2. What other factors in addition to occupancy-days are likely to affect the variation in electrical costs from month to month?
Chapter 20 Excel Online Problems
eBook
High-low method for a service company
Show Me How
Office 365
Sierra Railroad Inc. 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 Sierra Railroad is "gross-ton miles," which is the total number of tons multiplied by the miles moved.
January
February
March
April
May
June
Transportation Costs
Gross-Ton Miles
$732,000
217,000
816,200
242,000
576,800
157,000
782,500
235,000
656,300
841,400
189,000
255,000
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
Open spreadsheet
Determine the variable cost per gross-ton mile and the total fixed cost.
Variable cost (If required, round to two decimal places.) $
Total fixed cost $
X per gross-ton mile
Chapter 5 Solutions
Managerial Accounting
Ch. 5.A - EXERCISE 5A-1 High-Low Method LO5-10 The Cheyenne...Ch. 5.A - EXERCISE 5A-2 Least-Squares Regression LO5-11...Ch. 5.A - EXERCISE 5A-3 Cost Behavior; High-Low Method...Ch. 5.A - Prob. 4ECh. 5.A - EXERCISE 5A-5 Least-Squares Regression LO5-11...Ch. 5.A - Prob. 6PCh. 5.A - Problem 5A-7 Cost Behavior; High-Low Method;...Ch. 5.A - Problem 5A-8 High-Low Method; Predicting Cost...Ch. 5.A - Prob. 9PCh. 5.A - Prob. 10P
Ch. 5.A - Case 5A-11 Mixed Cost Analysis and the Relevant...Ch. 5.A - CASE 5A-12 Analysis of Mixed Costs in a Pricing...Ch. 5 - Prob. 1QCh. 5 - Often the most direct route to a business decision...Ch. 5 - Prob. 3QCh. 5 - What is the meaning of operating leverage?Ch. 5 - What is the meaning of break-even point?Ch. 5 - 5-6 In response to a request from your immediate...Ch. 5 - Prob. 7QCh. 5 - Prob. 8QCh. 5 - Prob. 9QCh. 5 - Prob. 1AECh. 5 - Prob. 2AECh. 5 - Prob. 3AECh. 5 - Prob. 4AECh. 5 - Prob. 5AECh. 5 - Prob. 1F15Ch. 5 - Prob. 2F15Ch. 5 - Prob. 3F15Ch. 5 - Prob. 4F15Ch. 5 - Prob. 5F15Ch. 5 - Prob. 6F15Ch. 5 - Prob. 7F15Ch. 5 - Prob. 8F15Ch. 5 - Prob. 9F15Ch. 5 - Prob. 10F15Ch. 5 - Prob. 11F15Ch. 5 - Prob. 12F15Ch. 5 - Prob. 13F15Ch. 5 - Prob. 14F15Ch. 5 - Prob. 15F15Ch. 5 - Prob. 1ECh. 5 - Prob. 2ECh. 5 - Prob. 3ECh. 5 - Prob. 4ECh. 5 - Prob. 5ECh. 5 - Prob. 6ECh. 5 - Prob. 7ECh. 5 - Prob. 8ECh. 5 - Prob. 9ECh. 5 - EXERCISE 5-10 Multiproduct Break-Even Analysis...Ch. 5 - Prob. 11ECh. 5 - EXERCISE 5-12 Multiproduct Break-Even Analysis...Ch. 5 - EXERCISE 5-13 Changes in Selling Price, Sales...Ch. 5 - Prob. 14ECh. 5 - Prob. 15ECh. 5 - Prob. 16ECh. 5 - Prob. 17ECh. 5 - Prob. 18ECh. 5 - Prob. 19PCh. 5 - PROBLEM 5-20 CVP Applications: Break-Even...Ch. 5 - PROBLEM 5-21 Sales Mix; Multiproduct Break-Even...Ch. 5 - Prob. 22PCh. 5 - Prob. 23PCh. 5 - Prob. 24PCh. 5 - Prob. 25PCh. 5 -
PROBLEM 5-26 CVP Applications; Break-Even...Ch. 5 - Prob. 27PCh. 5 - Prob. 28PCh. 5 - Prob. 29PCh. 5 - Prob. 30PCh. 5 -
PROBLEM 5-31 Interpretive Questions on the CVP...Ch. 5 - Prob. 32C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 9:49 A Month January February March April May June July July August September October November December Occupancy- Days Exercise 6A-1 (Static) 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. 1,736 1,904 2,356 960 360 744 100 2,108 406 2,406 840 124 720 1,364 0 KB/s Variable cost of electricity Fixed cost of electricity Electrical Costs $4,127 $ 4,207 $5,083 2,857 $ 1,871 $ $ 2,696 2.696 $ 4,670 $ 5,148 anscribed Text $ 2,691 $ 1,588 $ 2,454 $ 3,529 ? Seasonal factors like winter or summer. J 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…arrow_forwardQuestion #4 Stephens Marine Repair is trying to establish the standard labor cost of a typical water-cooling pump repair. The following data have been collected from time and motion studies conducted over the past month. Actual time spent on pump repair $24.00 Hourly wage rate Payroll taxes Onsite setup and downtime Final adjustments and testing Fringe benefits 20% of wage rate Required (a) repair (b) (c) 10% of wage rate repair. (d) 1.75 hours 5% of actual labor time 10% of actual labor time Determine the standard direct labor hours per pump Determine the standard direct labor hourly rate. Determine the standard direct labor cost per pump If a pump repair took 1.75 hours at the standard hourly rate, what was the direct labor quantity variance?arrow_forwardEXERCISE S-10 Compute the Break-Even Polnt for a Multiproduct Company (LOS-9) Lucido Products markets two computer gamex Clatmjumper and Makeover. A contribution forunat hcome statement for a recent Month for the two games appears bekn Claimjumper Makeover Total Bales Variable experses $30,000 20,000 $10,000 $70,000 B0.000 $20,000 $100,000 70,000 30,000 24,000 $ 6.000 Contribution mrgin Fixed expenses Net operating inicome Required 1, Compute thbe overall contrilsution margin (CM) ratio for the company 2. Compute the overall break-even poiot for the company in dollar salos. 1Nerily the overall break-even point for the crimpany hy constructing a contributiin fomat income slatement showing the appropriaté levels of sales for the two prmducis.arrow_forward
- Question No. 2 CVP – Basic Analysis Raveen Products sells camping equipment. One of the company’s products, a camp lantern, sells for $90 per unit. Variable expenses are $63 per lantern, and fixed expenses associated with the lantern total $135,000 per month. Required: Compute the company’s break-even point in number of lanterns and in total sales dollars. Compute the company’s Margin of Safety in sales dollar and in percentage. At present, the company is selling 8,000 lanterns per month. The sales manager is convinced that a 10% reduction in the selling price will result in a 25% increase in the number of lanterns sold each month. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes. Show both total and per unit data on your statements. Refer to the data in (3) above. How many lanterns would have to be sold at the new selling price to yield a minimum net operating income of $72,000…arrow_forwardQuestion 7 You are contemplating leaving your full-time employment to concentrate your ability on the marketing of a new low-energy portable heater. You have spoken to a group of manufacturers of similar product, and you have produced the following data based upon the production of 1200 heaters in the six months to December 31, 2021. R R Unit selling price 160 Less: Direct materials 50 Direct labour 30 Fixed Overheads: Admin 4.00 Rent 7.50 Rates…arrow_forwardCVP – Basic Analysis Raveen Products sells camping equipment. One of the company’s products, a camp lantern, sells for $90 per unit. Variable expenses are $63 per lantern, and fixed expenses associated with the lantern total $135,000 per month. Required: a) Compute the company’s break-even point in number of lanterns and in total sales dollars, Compute the company’s Margin of Safety in sales dollar and in percentage,At present, the company is selling 8,000 lanterns per month. The sales manager is convinced that a 10% reduction in the selling price will result in a 25% increase in the number of lanterns sold each month. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes. Show both total and per unit data on your statements. b) Refer to the data in above. How many lanterns would have to be sold at the new selling price to yield a minimum net…arrow_forward
- Problem #5 Assume the following business and financial data for the L&N Trucking Company: The L&N Trucking Company achieved total miles driven of 2,425,000 systemwide for their latest fiscal year. For the latest fiscal year, the trucking company earned average revenue of $5.48 per mile driven. L&N Trucking's average variable cost per mile driven for the year was $2.85. The trucking company's total fixed costs for the year were $1,857,000. 5a) Show the cost-volume-profit (CVP) income statement for L&N Trucking, including contribution margin and net income, in both total dollars and per unit. 5b) Calculate the trucking company's breakeven level in both total sales dollars and units 5c) Compute L&N Trucking's margin of safety and margin of safety ratio, based on the latest year's results.arrow_forwardExercise 12-11 (Algo) Estimating costs based on behavior patterns LO 3 Larry estimates that the costs of insurance, license, and depreciation to operate his car total $450 per month and that the gas, oil, and maintenance costs are 39 cents per mile. Larry also estimates that, on average, he drives his car 2,000 miles per month. Required: a. How much cost would Larry expect to incur during April if he drove the car 1,519 miles? (Round your answer to 2 decimal places.) Answer is complete but not entirely correct. Total cost 1,070.49 b. Would it be meaningful for Larry to calculate an estimated average cost per mile for a typical 2,000-mile month? Yes O Noarrow_forwardExercise 12-11 (Algo) Estimating costs based on behavior patterns LO 3 Larry estimates that the costs of insurance, license, and depreciation to operate his car total $450 per month and that the gas, oil, and maintenance costs are 39 cents per mile. Larry also estimates that, on average, he drives his car 2,000 miles per month. Required: a. How much cost would Larry expect to incur during April if he drove the car 1,519 miles? (Round your answer to 2 decimal places.) b. Would it be meaningful for Larry to calculate an estimated average cost per mile for a typical 2,000-mile month?multiple choice Yes noarrow_forward
- Question 5 You are contemplating leaving your full-time employment to concentrate your ability on the marketing of a new low-energy portable heater. You have spoken to a group of manufacturers of similar product, and you have produced the following data based upon the production of 1200 heaters in the six months to December 31, 2021. R R Unit selling price 160 Less: Direct materials 50 Direct labour 30 Fixed Overheads: Admin 4.00 Rent 7.50 Rates…arrow_forwardQuestion 11 You are contemplating leaving your full-time employment to concentrate your ability on the marketing of a new low-energy portable heater. You have spoken to a group of manufacturers of similar product, and you have produced the following data based upon the production of 1200 heaters in the six months to December 31, 2021. R R Unit selling price 160 Less: Direct materials 50 Direct labour 30 Fixed Overheads: Admin 4.00 Rent 7.50 Rates…arrow_forwardQuestion 23 You are contemplating leaving your full-time employment to concentrate your ability on the marketing of a new low-energy portable heater. You have spoken to a group of manufacturers of similar product, and you have produced the following data based upon the production of 1200 heaters in the six months to December 31, 2021. R R Unit selling price 160 Less: Direct materials 50 Direct labour 30 Fixed Overheads: Admin 4.00 Rent 7.50 Rates…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
How to Estimate Project Costs: A Method for Cost Estimation; Author: Online PM Courses - Mike Clayton;https://www.youtube.com/watch?v=YQ2Wi3Jh3X0;License: Standard Youtube License