Horngren's Accounting (12th Edition)
12th Edition
ISBN: 9780134486444
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 21, Problem S21.8SE
Computing contribution margin, units and required sales to break even, and units to achieve target profit Learning Objectives 2, 3
Compute the missing amounts for the following table
A | B | c | |
Sales price per unit | $ 200 | $4,000 | $5,220 |
Variable costs per unit | 80 | 1,000 | 2.088 |
Total fixed costs | 73,200 | 660,000 | 3,758,400 |
Target profit | 266,760 | 3,000,000 | 3,132,000 |
Calculate: | |||
Contribution margin per unit | _______ | _______ | _______ |
Contribution margin ratio | _______ | _______ | _______ |
Required units to break even | _______ | _______ | _______ |
Required sales dollars to break even | _______ | _______ | _______ |
Required units to achieve target profit | _______ | _______ | _______ |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Question 1 FNG Paint (Pty) Ltd produces finger paint and sells them to pre‐schools.The following information relates to a set of finger paint. A set of finger paint is considered to be one unit.
Direct labour needed for the first set of paint += 4 hoursDirect labour costs per unit = R30 per hourDirect material costs per unit = R25Total Fixed costs = R2 000Learning curve = 80%
Required:Using the learning curve theory and information provided above, calculate the expected average cost for one set of paint should four and sixteen sets be produced, respectively. Round off to two decimal places.
Specifically, Mr. Schaefer wants you to do the following:
PART 1. Prepare a cost-volume-profit (CVP) analysis of the proposal's financial implications.
1. Specifically, prepare an analysis that includes the projected revenue, variable costs, and fixed costs for enrollment levels of 20, 25, 30 and 37 students using the monthly projections in Attachment A of the case.
2. Then, compute the weighted average contribution margin (CM) per student (computed as the total CM divided by the number of students enrolled) and
3. The number of students that need to enroll at each of the four levels of enrollment for the center to break even. For this analysis, I have provided an Excel template in which I have already sorted variable and fixed costs: I have included the raw data. Note: Your enrollment information has already been weighted so you will not need to calculate weights for your weighted average CM.
Cost estimation, learning curves (continuation of 10-44). Inbee is concerned that she still does not understand the relationship between output and labor consumption. She consults with Jim Park, the head of engineering, and shares the results of her regression estimation. Jim indicates that the production of new smartphone models exhibits significant learning effects—as Hankuk gains experience with production, it can produce additional units using less time. He suggests that it is more appropriate to specify the following relationship:
where x is cumulative production in units, y is the cumulative average direct labor-hours per unit (i.e., cumulative DLH divided by cumulative production), and a and b are parameters of the learning effect. To estimate this, Inbee and Jim use the original data to calculate the cumulative output and cumulative average labor-hours per unit for each month. They then take natural logarithms of these variables in order to be able to estimate a regression…
Chapter 21 Solutions
Horngren's Accounting (12th 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 - What is cost stickiness? Why do managers need to...Ch. 21 - Prob. 23RQCh. 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. 26RQCh. 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. 31ARQCh. 21 - Prob. 32ARQCh. 21 - Identifying variable, fixed, and mixed costs...Ch. 21 - Prob. S21.2SECh. 21 - Using the high-low method Learning Objective 1...Ch. 21 - Prob. S21.4SECh. 21 - Prob. S21.5SECh. 21 - Prob. S21.6SECh. 21 - Prob. S21.7SECh. 21 - Computing contribution margin, units and required...Ch. 21 - Prob. S21.9SECh. 21 - Prob. S21.10SECh. 21 - Prob. S21.11SECh. 21 - Use the following information to complete Short...Ch. 21 - Use the following information to complete Short...Ch. 21 - Prob. S21.14SECh. 21 - Prob. S21.15SECh. 21 - Prob. S21.16SECh. 21 - Prob. S21.17SECh. 21 - S21A-18 Classifying costs
Learning Objective 6...Ch. 21 - Use the following information for Short Exercises...Ch. 21 - Prob. S21A.20SECh. 21 - Prob. S21A.21SECh. 21 - Prob. S21A.22SECh. 21 - Prob. S21A.23SECh. 21 - Prob. S21A.24SECh. 21 - Prob. S21A.25SECh. 21 - Prob. S21A.26SECh. 21 - Prob. E21.27ECh. 21 - Prob. E21.28ECh. 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 - Prob. E21.38ECh. 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 - Prob. E21A.49ECh. 21 - Prob. E21A.50ECh. 21 - Prob. E21A.51ECh. 21 - Prob. E21A.52ECh. 21 - Prob. E21A.53ECh. 21 - Prob. P21.54APGACh. 21 - Prob. P21.55APGACh. 21 - Analyzing CVP relationships Learning Objectives...Ch. 21 - Prob. P21.57APGACh. 21 - Prob. P21.58APGACh. 21 - Prob. P21A.59APGACh. 21 - Prob. P21A.60APGACh. 21 - Prob. P21.61BPGBCh. 21 - Prob. P21.62BPGBCh. 21 - Prob. P21.63BPGBCh. 21 - Prob. P21.64BPGBCh. 21 - Prob. P21.65BPGBCh. 21 - Prob. P21A.66BPGBCh. 21 - Prob. P21A.67BPGBCh. 21 - Using Excel for cost-volume-profit(CVP) analysis...Ch. 21 - Prob. P21.69CPCh. 21 - Comprehensive Problem for Chapters 18- 21 The...Ch. 21 - Comprehensive Problem for Chapters 18- 21 The...Ch. 21 - Comprehensive Problem for Chapters 18- 21 The...Ch. 21 - Comprehensive Problem for Chapters 18- 21 The...Ch. 21 - Comprehensive Problem for Chapters 18- 21 The...Ch. 21 - Prob. 6CPCh. 21 - Prob. 21.1TIATCCh. 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
- 7-23A Compute breakeven and project income (Learning Objectives 1 & 2)Grover’s Steel Parts produces parts for the automobile industry. The company hasmonthly fixed expenses of $630,000 and a contribution margin of 70% of revenues.Requirements1. Compute Grover’s Steel Parts’ monthly breakeven sales in dollars.2. Use the contribution margin ratio to project operating income (or loss) if revenues are$520,000 and if they are $1,010,000.3. Do the results in Requirement 2 make sense given the breakeven sales you computedin Requirement 1? Explain.arrow_forwardRobert's Repair Shop has a monthly target profit of $21,000. Variable costs are 40% of sales, and monthly fixed costs are $27,000. Requirements 1. Compute the monthly margin of safety in dollars if the shop achieves its income goal. 2. Express Robert's margin of safety as a percentage of target sales. 3. Why would Robert's management want to know the shop's margin of safety? Requirement 1. Compute the monthly margin of safety in dollars if the shop achieves its income goal. Select the labels and enter the amounts to compute Robert's Repair Shop's monthly margin of safety in dollars. (1) - (2) = Margin of safety in dollars - = Requirement 2. Express Robert's margin of safety as a percentage of target sales. (Enter your answer as a whole percent.) The margin of safety as a percentage of target sales is: %. Requirement 3. Why would Robert's management want to know the shop's margin of safety?…arrow_forward1. Set up a table with columns for cumulative number of units, cumulative average time per unit in hours, and cumulative total in hours using the cumulative average time learning curve. Complete the table for 1,2,4, and 8 units. What is the cumulative total time in hours for 8 units? 2. Set up a table assuming an 80% cummulative avergae time learning curve. What is the cumulative total time in hours for 8 units? 3. What is the difference in variable cost of producing four units? (between the result using the 0.90 model and 0.80 model)arrow_forward
- Computing margin of safety Robbie’s Repair Shop has a monthly target profit of $31,000. Variable costs are 20% of Sales, and monthly fixed costs are $19,000. Requirements Compute the monthly margin of Safety in dollars if the shop achieves its income goal. Express Robbie’s margin of safety, as a percentage of margin Sales. Why would Robbie’s management want to know the shop’s margin of safety?arrow_forwardComputing breakeven sales and sales needed to earn a target profit; graphing CVP relationships; performing sensitivity analysis National Investor Group is opening an office in Portland, Oregon. Fixed monthly costs are office rent ($8,100), depreciation on office furniture ($1,700), utilities ($2,000), special telephone lines ($1,500), a connection with an online brokerage service ($2,500), and the salary of a financial planner ($5,200). Variable costs include payments to the financial planner (9% of revenue), advertising (11% of revenue), supplies and postage (4% of revenue), and usage fees for the telephone lines and computerized brokerage service (6% of revenue). Requirements Use the contribution margin ratio approach to compute Nationals breakeven revenue in dollars. If the average trade leads to $1,000 in revenue for National, how many trades must be made to break even? Use the equation approach to compute the dollar revenues needed to earn a monthly target profit of $12,600.…arrow_forwardIf the variable cost is P15/unit, fixed cost is 265,000; and Sales is P55. Find the BEPs, and BEPx. Use the Target Profit Analysis Equation Method. Compute for the following: • Contribution Margin Ratio • Break-Even Point in Sales • Break-Even Point in Units IMPORTANT NOTE: PLEASE REFER TO THE GIVEN LESSON. USE THE FORMULA FROM THE LESSON IN THE PHOTE ATTACHED. THANK YOU. I will give you upvote for this.arrow_forward
- there are still these to answer Draw up a marginal cost statement on the basis that 12,000 units will be sold and calculate the net profit or loss c. Briefly explain what is meant by breakeven points d. Calculate the breakeven units in value and explain what it means to the director e. Calculate the sales activity to reach a target profit of £20,000.arrow_forwardComputing breakeven sales and sales needed to earn a target profit; performing sensitivity analysis This problem continues the Piedmont Computer Company situation from Chapter 19. Piedmont Computer Company manufactures personal computers and tablets. Based on the latest information from the cost accountant, using the current sales mix, the weighted-average sales price per unit is $750 and the weighed-average variable cost per unit is $450. The company does not expect the sales mix to vary for the next year. Average fixed costs per month are $156,000. Requirements What is the number of units that must be sold each month to reach the breakeven point? If the company currently sells 945 units per month, what is the margin of safety in units and dollars? If Piedmont Computer Company desires to make a profit of $15,000 per month, how many units must be sold? Piedmont Computer Company thinks it can restructure some costs so that fixed costs will be reduced to $90,000 per month, but the…arrow_forwardThe following terms are used to describe various economic characteristics of costs.a. Opportunity costb. Out-of-pocket costc. Sunk costd. Differential coste. Marginal costf. Average costRequired: Choose one of the terms listed above to characterize each of the amounts described below.1. The cost of feeding 500 children in a public school cafeteria is $800 per day, or $1.60 per child per day. What economic term describes this $1.60 cost?2. The cost of including one extra child in a day-care center.3. The cost of merchandise inventory purchased two years ago, which is now obsolete.4. The management of a high-rise office building uses 2,500 square feet of space in the building for its own management functions. This space could be rented for $250,000. What economic term describes this $250,000 in lost rental revenue?5. The cost of building an automated assembly line in a factory is $800,000. The cost of building a manually operated assembly line is $375,000. What economic term is used to…arrow_forward
- please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) Exhibit 1: Assumptions (Both Products) Product #1: Launch-it Sales price per unit $ 10.00 Variable costs per unit: $ 4.00 Monthly volume 240 Product #2: Treat-time Sales price per unit $ 30.00 Variable costs per unit: $ 14.00 Monthly volume 160 Total fixed costs per month $ 1,500.00 Target profit per month $ 8,000.00 Margin of Safety (in $) Margin of Safety % Degree of Operating Leverage Expected % change in operating income (%)arrow_forwardOn the Data Tables - Student tab in your Excel spreadsheet, update the given information section of the Income Statement for Hello Company with the data below: Income Statement Product A Product B Product C Max Capacity Units 42,000 7,000 3,000 52,000 Price per unit $ 11.00 $ 8.00 $ 60.00 Variable expense per unit $ 4.00 $ 2.00 $ 20.00 Total Fixed Costs $ 20,000 $ 40,000 $ 10,000 Required: 2. Using the Data Table What-If Analysis tool in Excel, determine the Units and Operating Income (Loss) for each product based on the following scenarios. (Hint: Don't forget that the warehouse can only hold up to 52,000 units.) Scenario 1: Pete wants to find the mix of units that will result in the highest overall Operating Income, perform this analysis using a two variable data table. Product A can vary between 39,000 units and a maximum of 44,000 units. Product B can vary between 5,000 units…arrow_forwardDownload and fill out the Section 5 Comprehensive Problem Template attached below to complete the problems (ignore question 5-2 as this applies to the "combined accounting and finance" course). Problem 5-1 Redlands Inc. sells one product for $5. The variable cost per item is $3, and the fixed costs for the firm are $40. Required: a. Compute the breakeven point in units. b. Compute the number of units and sales revenue needed to achieve a $20 profit. (Ignore income taxes.) c. Assume that the income tax rate for Redlands is 40%. Compute the number of units and sales revenue needed to achieve an $18 net profit. d. Compute the number of units and sales revenue needed to achieve an 8% profit margin. (Ignore income taxes.) e. Compute the number of units and sales revenue needed to achieve a 12% net profit margin. (Assume a 40% income tax rate.) f. Assume that Redlands currently sells 40 units. Redlands estimates that if it increased sales price to $6 per unit demand would decrease by…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
What is Risk Management? | Risk Management process; Author: Educationleaves;https://www.youtube.com/watch?v=IP-E75FGFkU;License: Standard youtube license