Horngren's Accounting (11th Edition)
11th Edition
ISBN: 9780133856781
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 21, Problem S21.3SE
Using the high-low method
Mel owns a machine shop. In reviewing the shop’s utility bills for the past 12 months, he found that the highest bill of $2,600 occurred in August when the machines worked 1,400 machine hours. The lowest utility bill of $2,300 occurred in December when the machines worked 900 machine hours.
Requirements
- Calculate the variable rate per machine hour and the total fixed utility cost.
- Show the equation for determining the total utility cost for the machine shop
- If Mel anticipates using 1,000 machine hours in January, predict the shop’s total utility bill using the equation from Requirement 2.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Vishnu
Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is
concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were
higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's
profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the
previous fiscal year for maintenance costs and machine hours follow:
Month Maintenance Costs Machine Hours
$ 2,665
2,710
2,760
1
2
3
4
6
7
8
9
10
11
12
2,860
2,895
Maintenance cost
3,045
2,905
2,945
2,820
2,610
2,630
2,930
1,566
1,670
1,685
1,735
1,855
1,890
1,865
1,885
1,775
1,450
1,630
1,465
Required:
1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit
variable cost)" to 4 decimal places. Enter the…
Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is
concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were
higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's
profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the
previous fiscal year for maintenance costs and machine hours follow:
Month Maintenance Costs Machine Hours
$ 2,695
2,740
2,790
2,890
2,925
3,025
2,935
1
2
3
4
56789012
10
11
2,975
2,850
2,640
2,660
2,960
Maintenance cost
1,620
1,730
1,745
1,795
1,790
1,890
1,810
1,845
1,835
1,480
1,690
1,495
Required:
1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (uni
variable cost)" to 4 decimal places. Enter the "slope…
Chapter 21 Solutions
Horngren's Accounting (11th Edition)
Ch. 21 - For Frank’s Funky Sounds, straight-line...Ch. 21 - Prob. 2QCCh. 21 - Prob. 3QCCh. 21 - Prob. 4QCCh. 21 - Prob. 5QCCh. 21 - On a CVP graph, the total cost line intersects the...Ch. 21 - If a company increases its sales price per unit...Ch. 21 - Prob. 8QCCh. 21 - Prob. 9QCCh. 21 - Prob. 10QC
Ch. 21 - Donovan Company incurred the following costs while...Ch. 21 - Prob. 12AQCCh. 21 - Prob. 1RQCh. 21 - Prob. 2RQCh. 21 - What is a mixed cost? Give an example.Ch. 21 - What is the purpose of using the high-low method?Ch. 21 - Describe the three steps of the high-low method.Ch. 21 - What is the relevant range?Ch. 21 - A chain of convenience stores has one manager per...Ch. 21 - A chain of convenience stores has one manager per...Ch. 21 - Prob. 9RQCh. 21 - Prob. 10RQCh. 21 - Prob. 11RQCh. 21 - What is cost-volume-profit analysis?Ch. 21 - Prob. 13RQCh. 21 - Prob. 14RQCh. 21 - Prob. 15RQCh. 21 - Of the three approaches to calculate sales...Ch. 21 - Prob. 17RQCh. 21 - Prob. 18RQCh. 21 - On the CVP graph, where is the breakeven point...Ch. 21 - What is sensitivity analysis? How do managers use...Ch. 21 - Prob. 21RQCh. 21 - Prob. 22RQCh. 21 - What is a company's cost structure? How can cost...Ch. 21 - What is operating leverage? What does it mean if a...Ch. 21 - Prob. 25RQCh. 21 - What is absorption costing?Ch. 21 - What is variable costing?Ch. 21 - How are absorption costing and variable costing...Ch. 21 - When units produced equal units sold, how does...Ch. 21 - Prob. 30ARQCh. 21 - Prob. 31ARQCh. 21 - Prob. 32ARQCh. 21 - Prob. 33ARQCh. 21 - Identifying variable, fixed, and mixed costs...Ch. 21 - Prob. S21.2SECh. 21 - Using the high-low method Mel owns a machine shop....Ch. 21 - Prob. S21.4SECh. 21 - Prob. S21.5SECh. 21 - Prob. S21.6SECh. 21 - Prob. S21.7SECh. 21 - Prob. S21.8SECh. 21 - Prob. S21.9SECh. 21 - Prob. S21.10SECh. 21 - Prob. S21.11SECh. 21 - Prob. S21.12SECh. 21 - Computing margin of safety Refer to the original...Ch. 21 - Prob. S21.14SECh. 21 - Prob. S21.15SECh. 21 - Prob. S21.16SECh. 21 - S21A-18 Classifying costs
Learning Objective 6...Ch. 21 - Prob. S21A.18SECh. 21 - Use the following information for Short Exercises...Ch. 21 - Prob. S21A.20SECh. 21 - Use the following information for Short Exercises...Ch. 21 - Computing absorption cost per unit Abrey, Inc. has...Ch. 21 - Prob. S21A.23SECh. 21 - Prob. S21A.24SECh. 21 - Prob. E21.25ECh. 21 - Prob. E21.26ECh. 21 - Prob. E21.27ECh. 21 -
E21-28 Determining total variable cost
For each...Ch. 21 - Prob. E21.29ECh. 21 - Prob. E21.30ECh. 21 - Prob. E21.31ECh. 21 - Prob. E21.32ECh. 21 - Prob. E21.33ECh. 21 - Prob. E21.34ECh. 21 - Prob. E21.35ECh. 21 - Prob. E21.36ECh. 21 - Prob. E21.37ECh. 21 - E21-38 Computing margin of safety
Ricky’s Repair...Ch. 21 - Prob. E21.39ECh. 21 - Prob. E21.40ECh. 21 - Prob. E21.41ECh. 21 - Prob. E21.42ECh. 21 - Prob. E21.43ECh. 21 - Prob. E21.44ECh. 21 - Prob. E21.45ECh. 21 - Prob. E21A.46ECh. 21 - Prob. E21A.47ECh. 21 - Prob. E21A.48ECh. 21 - Calculating cost-volume-profit elements The...Ch. 21 - Prob. P21.50APGACh. 21 - Prob. P21.51APGACh. 21 - Prob. P21.52APGACh. 21 - Prob. P21.53APGACh. 21 - Prob. P21.54APGACh. 21 - Prob. P21.55APGACh. 21 - Prob. P21.56BPGBCh. 21 - Prob. P21.57BPGBCh. 21 - Prob. P21.58BPGBCh. 21 - Computing breakeven sales and sales needed to earn...Ch. 21 - Prob. P21.60BPGBCh. 21 - Prob. P21.61BPGBCh. 21 - Prob. P21.62BPGBCh. 21 - Prob. P21.63CPCh. 21 - The Savannah Shirt Company makes two types of...Ch. 21 - The Savannah Shirt Company makes two types of...Ch. 21 - Prob. 3CPCh. 21 - Prob. 4CPCh. 21 - The Savannah Shirt Company makes two types of...Ch. 21 - Prob. 6CPCh. 21 - Prob. 21.1DCCh. 21 - Prob. 21.1EI
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
- Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month 1 3 4 6 7 8 9 10 11 12 Maintenance Costs Machine Hours $ 2,665 2,710 2,760 2,860 2,895 3,045 2,905 2,945 2,820 2,610 2,630 2,930 Maintenance cost 1,566 1,670 1,685 1,735 1,855 1,890 1,865 1,885 1,775 1,450 1,630 1,465 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit variable cost)" to 4 decimal places. Enter the…arrow_forwardMukhiarrow_forwardPlease provide answer in text (Without image) and show calculationarrow_forward
- Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Revenue Raw materials Wages Utilities Rent Insurance Miscellaneous Revenue Expenses: Fixed Element per Month Raw materials Wages Utilities Rent $ 6,500 $ 2,530 $3,500 $2,250 $ 740 Insurance Miscellaneous While gelato is sold by the cone or cup, the shop measures its activity in terms of the total number of liters of gelato sold. For example, wages should be $6,500 plus $2.30 per liter of gelato sold and the actual wages for June were $21,300. Via Gelato expected to sell 6,400 liters in June, but actually sold 6,600 liters. Total expense Net operating income Variable Element per Actual Total Liter for June $ 21.00 $ 133,540 $ 5.55 $ 37,130 $ 21,300 $ 10,000 Required: Calculate Via Gelato revenue and spending variances for June. (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect…arrow_forwardNathaniel installs mufflers at NUBD Company. He is paid 500 per hour and an extra 100 per hour for every hour over 40 that is worked in a given week. Last week he worked 50 hours with 2 of these correctly classified as idle time. How much of Nathaniel’s wages last week should be included in manufacturing overhead cost?arrow_forwardVia Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Revenue Raw materials Mages Utilities Rent Insurance Miscellaneous $ 1.35 While gelato is sold by the cone or cup, the shop measures its activity in terms of the total number of liters of gelato sold. For example, wages should be $6,600 plus $2.40 per liter of gelato sold and the actual wages for June were $21,000. Via Gelato expected to sell 6,000 liters in June, but actually sold 6,200 liters. Revenue Expenses Fixed Variable Element Element per Month per Liter $ 22.00 $5.65 $2.40 $ 1.20 Required: Calculate Via Gelato revenue and spending variances for June. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Via Gelato Revenue and Spending Variances For the Month Ended June 30 Raw materials $ 6,600 $ 2,630 $ 3,600 $…arrow_forward
- Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Revenue Raw materials Wages Utilities Rent Insurance Miscellaneous Revenue Expenses: While gelato is sold by the cone or cup, the shop measures its activity in terms of the total number of liters of gelato sold. For example, ages should be $6,500 plus $2.30 per liter of gelato sold and the actual wages for June were $21,300. Via Gelato expected to sell 6,400 liters in June, but actually sold 6,600 liters. Raw materials Fixed Element per Month Required: Calculate Via Gelato revenue and spending variances for June. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Wages Utilities Rent $ 6,500 $ 2,530 $ 3,500 $ 2,250 $ 740 Answer is complete but not entirely correct. Via Gelato Revenue and Spending Variances For the…arrow_forwardVia Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Revenue Raw materials Wages Utilities Rent Insurance Miscellaneous Revenue Expenses: Fixed Element per Month Raw materials $6,500 $ 2,530 $ 3,500 $ 2,250 $ 740 While gelato is sold by the cone or cup, the shop measures its activity in terms of the total number of liters of gelato sold. For example, wages should be $6,500 plus $2.30 per liter of gelato sold and the actual wages for June were $21,300. Via Gelato expected to sell 6,400 liters in June, but actually sold 6,600 liters. Via Gelato Revenue and Spending Variances For the Month Ended June 30 Wages Utilities Rent Insurance Miscellaneous Variable Element per Liter $ 21.00 $ 5.55 $ 2.30 $ 1.10 Required: Calculate Via Gelato revenue and spending variances for June. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero…arrow_forwardAmy Andrews is a CPA who works as a managerial accounting consultant for a variety of firms. To determine her hourly rate, Amy uses a cost-plus pricing system, which she updates each year. The hourly cost of her assistant (including taxes and benefits) is $18, the hourly cost of her office space is $3, the hourly cost of her marketing and other overhead materials is $5, and Amy's own hourly salary (again, including taxes and benefits) is $84. Amy adds a 30% premium to her costs. What is her hourly rate using a cost-plus pricing strategy? 1:02 Multiple Choice $115 $143 $110 $140 Mc Graw MacBook Pro %23 %24 & 2 3 4 6 7 8. R. Y P D H J K V N mmand command option O O Oarrow_forward
- Southern Tier Heating, Inc. installs heating systems in new homes built in the southern tier counties of New York state. Jobs are priced using the time and materials method. The president of Southern Tier Heating, EIwing, is pricing a job involving the heating systems for six houses to be built by a local developer. He has made the following estimates. Material cost $ 60,000 Labor hours 400 The following predictions pertain to the company’s operations for the next year. Labor rate, including fringe benefits $ 16.00 per hour Annual labor hours 12,000 hours Annual overhead costs: Material handling and storage $ 25,000 Other overhead costs $ 108,000 Annual cost of materials used $ 250,000 Perbanas adds a markup of $ 4 per hour on its time charges, but there is no markup on material costs. Required: 1. Calculate the company's time charges and the material charges percentage. 2. Compute the price for the job 3. What would be the price of the job if Perbanas also added a markup of 10 % on…arrow_forwardVia Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Revenue Raw materials Wages Utilities Rent Insurance Miscellaneous Revenue Expenses: Fixed Element per Month Raw materials $ 5,900 $ 1,930 $ 2,900 $1,650 $ 680 While gelato is sold by the cone or cup, the shop measures its activity in terms of the total number of liters of gelato sold. For example, wages should be $5,900 plus $1.70 per liter of gelato sold and the actual wages for June were $15,900. Via Gelato expected to sell 6,000 liters in June, but actually sold 6,200 liters. Wages Utilities Rent Insurance Miscellaneous Variable for June Element per Actual Total Liter $15.00 $4.95 $ 1.70 $ 0.50 Required: Calculate Via Gelato revenue and spending variances for June. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)…arrow_forwardPLEASE ANSWER THEM ALL CORRECTLY FOR AN UPVOTE AND POSITIVE RATINGS. THANK YOU.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
What is Business Analysis?; Author: WolvesAndFinance;https://www.youtube.com/watch?v=gG2WpW3sr6k;License: Standard Youtube License