Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
6th Edition
ISBN: 9780134486857
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 20, Problem 3SE
Mark 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,200 machine hours. The lowest utility bill of $2,300 occurred in December when the machines worked 600 machine hours.
Requirements
- 1. Use the high-low method to calculate the variable cost per machine hour and the total fixed utility cost.
- 2. Show the equation for determining the total utility cost for the machine shop.
- 3. If Mark anticipates using 800 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
Bill owns a machine shop. In reviewing the shop's utility bills for the past 12 months,
he found that the highest bill of $2,800 occurred in August when the machines
worked 1,200 machine hours. The lowest utility bill of $2,200 occurred in December
when the machines worked 600 machine hours. Using the high-low method, the
variable cost per machine hour is
per machine hour and the total fixed
utility cost is
|
O $1.20 and $1,530
O $3,40 and $1,800
O $1.50 and $1,700
O $2.00 and $1,400
O $1.00 and $1,600
身
Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours:
1. What is the cost equation for maintenance costs using the high-low method?
2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1.
Month
Maintenance Costs
Machine Hours
1
$ 2,660
1,750
2
2,820
1,830
3
2,970
1,910
4
3,080
1,930
5
3,160
1,960
6
3,130
1,940
7
3,070
1,920
8
2,910
1,900
9
2,680
1,760
10
2,280
1,160
11
2,290
1,360
12
2,510
1,650
Janice Huffman has decided to start Rundle Cleaning, a residential housecleaning service company. She is able to rent cleaning
equipment at a cost of $760 per month. Labor costs are expected to be $90 per house cleaned and supplies are expected to cost $6
per house.
Required
a. Determine the total expected cost of equipment rental and the average expected cost of equipment rental per house cleaned,
assuming that Rundle Cleaning cleans 20, 30, or 40 houses during one month. Is the cost of equipment a fixed or a variable cost?
b. Determine the total expected cost of labor and the average expected cost of labor per house cleaned, assuming that Rundle
Cleaning cleans 20, 30, or 40 houses during one month. Is the cost of labor a fixed or a variable cost?
c. Determine the total expected cost of supplies and the average expected cost of supplies per house cleaned, assuming that Rundle
Cleaning cleans 20, 30, or 40 houses during one month. Is the cost of supplies a fixed or a variable cost?
d.…
Chapter 20 Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Ch. 20 - Following is a list of costs for a furniture...Ch. 20 - Following is a list of costs for a furniture...Ch. 20 - Prob. 3TICh. 20 - Following is a list of costs for a furniture...Ch. 20 - Following is a list of costs for a furniture...Ch. 20 - Prob. 6TICh. 20 - Prob. 7TICh. 20 - Prob. 8TICh. 20 - Prob. 9TICh. 20 - Prob. 10TI
Ch. 20 - Prob. 11TICh. 20 - Prob. 12TICh. 20 - Prob. 13TICh. 20 - Prob. 14TICh. 20 - Prob. 15TICh. 20 - Prob. 16TICh. 20 - Prob. 17TICh. 20 - Prob. 18TICh. 20 - A furniture manufacturer specializes in wood...Ch. 20 - For Franks Funky Sounds, straight-line...Ch. 20 - Assume Intervale Railway is considering hiring a...Ch. 20 - If Intervale Railways fixed costs total 90,000 per...Ch. 20 - If Intervale Railways fixed costs total 90,000 per...Ch. 20 - If Intervale Railways fixed costs total 90,000 per...Ch. 20 - On a CVP graph, the total cost line intersects the...Ch. 20 - If a company increases its sales price per unit...Ch. 20 - If a company increases its fixed costs for Product...Ch. 20 - Prob. 9QCCh. 20 - Rocky Mountain Waterpark sells half of its tickets...Ch. 20 - What is a variable cost? Give an example.Ch. 20 - What is a fixed cost? Give an example.Ch. 20 - What is a mixed cost? Give an example.Ch. 20 - What is the purpose of using the high-low method?Ch. 20 - Describe the three steps of the high-low method.Ch. 20 - Prob. 6RQCh. 20 - Prob. 7RQCh. 20 - Prob. 8RQCh. 20 - Prob. 9RQCh. 20 - What are the three ways contribution margin can be...Ch. 20 - Prob. 11RQCh. 20 - What is cost-volume-profit analysis?Ch. 20 - What are the CVP assumptions?Ch. 20 - What is the breakeven point?Ch. 20 - Prob. 15RQCh. 20 - Prob. 16RQCh. 20 - Prob. 17RQCh. 20 - Why is the calculation to determine the target...Ch. 20 - Prob. 19RQCh. 20 - What is sensitivity analysis? How do managers use...Ch. 20 - What effect does an increase in sales price have...Ch. 20 - Prob. 22RQCh. 20 - What is the margin of safety? What are the three...Ch. 20 - What is a companys cost structure? How can cost...Ch. 20 - What is operating leverage? What does it mean if a...Ch. 20 - Prob. 26RQCh. 20 - Philadelphia Acoustics builds innovative speakers...Ch. 20 - Hollys Day Care has been in operation for several...Ch. 20 - Mark owns a machine shop. In reviewing the shops...Ch. 20 - Glenn Company sells a product for 80 per unit....Ch. 20 - Gabelman Company sells a product for 95 per unit....Ch. 20 - Mackler, Inc. sells a product with a contribution...Ch. 20 - Ocean Company sells a product with a contribution...Ch. 20 - Compute the missing amounts for the following...Ch. 20 - Compute the missing amounts for the following...Ch. 20 - Use the following information to complete Short...Ch. 20 - Compute Funday Parks contribution margin ratio....Ch. 20 - Using the Funday Park information presented, do...Ch. 20 - Prob. 13SECh. 20 - Refer to the original information (ignoring the...Ch. 20 - Refer to the original information (ignoring the...Ch. 20 - Prob. 16SECh. 20 - For 2019, Wild Waters expects a sales mix of four...Ch. 20 - Match the following terms with the correct...Ch. 20 - Identify each cost as variable (V), fixed (F), or...Ch. 20 - For each total fixed cost listed below, determine...Ch. 20 - Prob. 21ECh. 20 - Prob. 22ECh. 20 - The manager of Trusty Car Inspection reviewed the...Ch. 20 - For its top managers, Worldwide Travel formats its...Ch. 20 - Complete the table below for contribution margin...Ch. 20 - Prob. 26ECh. 20 - Prob. 27ECh. 20 - Owner Shan Mu is considering franchising her...Ch. 20 - Prob. 29ECh. 20 - Prob. 30ECh. 20 - Determine how each change effects the elements of...Ch. 20 - Mi Tierra Driving School charges 680 per student...Ch. 20 - Prob. 33ECh. 20 - Robbies Repair Shop has a monthly target profit of...Ch. 20 - Prob. 35ECh. 20 - Prob. 36ECh. 20 - The budgets of four companies yield the following...Ch. 20 - England Productions performs London shows. The...Ch. 20 - Crandall Company sells flags with team logos....Ch. 20 - Prob. 40APCh. 20 - The contribution margin income statement of Sugar...Ch. 20 - The budgets of four companies yield the following...Ch. 20 - Famous Productions performs London shows. The...Ch. 20 - White Company sells flags with team logos. White...Ch. 20 - Diversified Investor Group is opening an office in...Ch. 20 - The contribution margin income statement of...Ch. 20 - Prob. 48PCh. 20 - The Jacksonville Shirt Company makes two types of...Ch. 20 - Prob. 1TIATCCh. 20 - Steve and Linda Hom live in Bartlesville,...Ch. 20 - Prob. 1EI
Additional Business Textbook Solutions
Find more solutions based on key concepts
Preparing Financial Statements from a Trial Balance The following accounts are taken from Equilibrium Riding, I...
Fundamentals of Financial Accounting
Analysis of inventory errors A2 Hallam Company’s financial statements show the following. The company recently ...
FINANCIAL ACCT.FUND.(LOOSELEAF)
List five asset accounts, three liability accounts, and five expense accounts included in the acquisition and p...
Auditing and Assurance Services (16th Edition)
E6-14 Using accounting vocabulary
Learning Objective 1, 2
Match the accounting terms with the corresponding d...
Horngren's Accounting (11th Edition)
What are assets limited as to use and how do they differ from restricted assets?
Accounting For Governmental & Nonprofit Entities
Interest-bearing notes payable with year-end adjustments P1 Keesha Co. borrows $200,000 cash on November 1, 201...
Financial Accounting: Information for Decisions
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
- Jean and Tom Perritz own and manage Happy Home Helpers, Inc. (HHH), a house-cleaning service. Each cleaning (cleaning one house one time) takes a team of three house cleaners about 1.5 hours. On average, HHH completes about 15,000 cleanings per year. The following total costs are associated with the total cleanings: Required: 1. Calculate the prime cost per cleaning. 2. Calculate the conversion cost per cleaning. 3. Calculate the total variable cost per cleaning. 4. Calculate the total service cost per cleaning. 5. What if rent on the office that Jean and Tom use to run HHH increased by 1,500? Explain the impact on the following: a. Prime cost per cleaning b. Conversion cost per cleaning c. Total variable cost per cleaning d. Total service cost per cleaningarrow_forwardJanice Huffman has decided to start Rundle Cleaning, a residential housecleaning service company. She is able to rent cleaning equipment at a cost of $760 per month. Labor costs are expected to be $90 per house cleaned and supplies are expected to cost $6 per house. Required a. Determine the total expected cost of equipment rental and the average expected cost of equipment rental per house cleaned, assuming that Rundle Cleaning cleans 20, 30, or 40 houses during one month. Is the cost of equipment a fixed or a variable cost? b. Determine the total expected cost of labor and the average expected cost of labor per house cleaned, assuming that Rundle Cleaning cleans 20, 30, or 40 houses during one month. Is the cost of labor a fixed or a variable cost? c. Determine the total expected cost of supplies and the average expected cost of supplies per house cleaned, assuming that Rundle Cleaning cleans 20, 30, or 40 houses during one month. Is the cost of supplies a fixed or a variable cost? d.…arrow_forwardLouis Petit, a manager of Doggone Gorgeous, Inc., was reviewing the water bills of a dog daycare and spa. He determined that its highest and lowest bills of $3,800and $2,000 were incurred in the months of May and November, respectively. If 600 dogs were washed in May and 100 dogs were washed in November, what was the fixed cost associated with the company's water bill? (Round any intermediate calculations to the nearest cent and your final answer to the nearest dollar.) A.$ 2 comma 000 $2,000 B.$ 1 comma 800 $1,800 C.$ 1 comma 640 $1,640 D.$ 3 comma 800arrow_forward
- Data table Month Total Cost Machine Hours January.. 3,420 1,090 February..... S 3,760 1,120 March .... $ 3,532 1,080 April ..... 3,720 1,220 May S 4,800 1,330 June 4,192 1,480 .. %24 %24arrow_forwardA factory company has compiled the following data for the last six months of 2009 to analyze utility cost. Question: What is the cost formula for utility expense?arrow_forwardJPAK manufactures and sells mountain bikes. It operates eight hours a day, five days a week. Using this information,classify each of the following costs as fixed or variable with respect to the number of bikes made. Taxes on propertyarrow_forward
- Write a linear cost function equation for each of the following conditions. Use y for estimated costsand X for activity of the cost driver. Machine operating costs include $1,000 of maintenance per month, and $15.00 of coolant usagecosts for each day the machinery is in operation.arrow_forwardBethany Liang delivers parts for several local auto parts stores. She charges clients $3.65 per mile driven. She has determined that if she drives 2,800 miles in a month, her average operating cost is $3.45 per mile. If Bethany drives 5,600 miles in a month, her average operating cost is $2.30 per mile. Required: 1. Using the high-low method, determine Bethany's variable and fixed operating cost components. 2. Complete the contribution margin income statement for the business last month, when Bethany drove 3,080 miles. (Assume this falls within the relevant range of operations). Complete this question by entering your answers in the tabs below. Required 1 Required 2 Using the high-low method, determine Bethany's variable and fixed operating cost components. Note: Round your cost per mile answer to 2 decimal places. Variable cost per mile driven Fixed costarrow_forwardBethany Liang delivers parts for several local auto parts stores. She charges clients $3.28 per mile driven. She has determined that if she drives 2,700 miles in a month, her average operating cost is $3.08 per mile. If Bethany drives 5,400 miles in a month, her average operating cost is $2.20 per mile. Required: 1. Using the high-low method, determine Bethany's variable and fixed operating cost components. 2. Complete the contribution margin income statement for the business last month, when Bethany drove 2,970 miles. (Assume this falls within the relevant range of operations). Complete this question by entering your answers in the tabs below. Required 1 Required 2 Using the high-low method, determine Bethany's variable and fixed operating cost components. Note: Round your cost per mile answer to 2 decimal places. Variable cost per mile driven Fixed cost $ 0.01arrow_forward
- Ethan Manufacturing Inc. produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month 1 2345 67 000 8 9 10 11 12 Maintenance Costs $ 2,740 2,900 3,050 3,160 3,240 3,210 3,150 2,990 2,760 2,360 2,370 2,590 Machine Hours 1,830 1,910 1,990 2,010 2,040 2,020 2,000 1,980 1,840 Required 1 Required 2 1,240 1,440 1,730 Required: 1. What is the cost equation for maintenance costs using the high-low method? 2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. Complete this question by entering your answers in the tabs below. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. (Do not round intermediate calculations, with the exception…arrow_forwardBethany Link delivers parts for several local auto parts stores. She charges clients $1.73 per mile driven. She has determined that if she drives 1,400 miles in a month, her average operating cost is $1.53 per mile. If Bethany drives 2,800 miles in a month, her average operating cost is $0.90 per mile. Required: 1. Using the high-low method, determine Bethany's variable and fixed operating cost components. 2. Complete the contribution margin income statement for the business last month, when Bethany drove 1,540 miles. (Assume this falls within the relevant range of operations). Complete this question by entering your answers in the tabs below. Required 1 Required 2 Using the high-low method, determine Bethany's variable and fixed operating cost components. (Round your cost per unit answer to 2 decimal places.)arrow_forwardJoyce Murphy runs a courier service in downtown Seattle. She charges clients $0.62 per mile driven. Joyce has determined that if she drives 2,450 miles in a month, her total operating cost is $725. If she drives 3,550 miles in a month, her total operating cost is $857. Required: 1. Using the high-low method, determine Joyce's variable and fixed operating cost components. 2. Complete the contribution margin income statement for Joyce's service assuming she drove 1,600 miles last month. (Assume this falls within the relevant range of operations).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
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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
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
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