The XYZ Manufacturing Company is evaluating options for spending on product quality and wants to find the optimal amount to spend on changing its processes to further prevent defects. Its engineers have developed the following estimates: 1. Defects The current defect rate is 10%. If it invests an additional $10 per unit in prevention costs, the defect rate will drop to 6%; spending $20 per unit on prevention drops the defect rate to 3%; spending $30 per unit drops the defect rate to 1.5%; and investing $40 per unit on prevention reduces the defect rate to 1%. 2. Inspection Inspection costs are $5 per unit. Inspection is successful at detecting 98% of defective units; the remaining 2% of defective products are sold and eventually returned for warranty repairs or replacement at no cost to the customer. 3. Internal failure costs are $400 per defective unit that is detected. 4. External failure costs are $1000 per unit returned. 5. Current production level is 1 million units. REQUIRED: A. Create and submit a spreadsheet that calculates total quality costs for the existing process and for each of the four options for investing in additional prevention.

The XYZ Manufacturing Company is evaluating options for spending on product quality and wants to find the optimal amount to spend on changing its processes to further prevent defects. Its engineers have developed the following estimates: 1. Defects The current defect rate is 10%. If it invests an additional $10 per unit in prevention costs, the defect rate will drop to 6%; spending $20 per unit on prevention drops the defect rate to 3%; spending $30 per unit drops the defect rate to 1.5%; and investing $40 per unit on prevention reduces the defect rate to 1%. 2. Inspection Inspection costs are $5 per unit. Inspection is successful at detecting 98% of defective units; the remaining 2% of defective products are sold and eventually returned for warranty repairs or replacement at no cost to the customer. 3. Internal failure costs are $400 per defective unit that is detected. 4. External failure costs are $1000 per unit returned. 5. Current production level is 1 million units. REQUIRED: A. Create and submit a spreadsheet that calculates total quality costs for the existing process and for each of the four options for investing in additional prevention.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter15: Decision Analysis

Section: Chapter Questions

Problem 5P: Hudson Corporation is considering three options for managing its data warehouse: continuing with its...

See similar textbooks

Similar questions

CleanTech manufactures equipment to mitigate the environmental effects of waste. (a) If Product A has fixed expenses of $15,000 per year and each unit of product has a $0.20 variable cost, and Product B has fixed expenses of $5000 per year and a $0.50 variable cost, at what number of units of annual production will A have the same overall cost as B? (b) As a manager at CleanTech what other data would you need to evaluate these two products?
RoboGarden sells a robot lawn aerator. At the current price, RoboGarden's contribution margin is $129.84 per unit. Because of a shortage of silicon chips, RoboGarden expects variable cost to increase by $10.17. In response, RoboGarden is thinking about raising its selling price by $36.36. Calculate the percent profit breakeven metric for this situation. Report the correct sign for the result. Report your answer as a percent. Report -25.5%, for example, as "-25.5". Rounding: tenth of a percent.
Consider a drill press containing three drill bits. The current policy (called individual replacement) is to replace a drill bit when it fails. The firm is considering changing to a block replacement policy in which all three drillbits are replaced whenever a single drill bit fails. Each time the drill press is shut down, the cost is $100. A drill bit costs $50, and the variable cost of replacing a drill bit is $10. Assume that the time to replace a drill bit isnegligible. Also, assume that the time until failure for a drill bit follows an exponential distribution with a mean of 100 hours. This can be modeled in @RISK with the formula 5RISKEXPON (100). (Note: If you have the academic version of @RISK, this problem will require more RISKEXPON functions than the 100 allowed, but there is an easy workaround. An exponentially distributed random variable can be generated with Excel functions only using the formula =-Mean*LN(RAND()). Then @RISK can still be used to run the simulation.)…
A manager is trying to decide whether to buy one machine or two. If only one machine is purchased and demand proves to be excessive, the second machine can be purchased later. Some sales would be lost, however, because the lead time for delivery of this type of machine is 6 months. In addition, the cost per machine will be lower if both machines are purchased at the same time. The probability of low demand is estimated to be 0.30 and that of high demand to be 0.70. The after-tax NPV of the benefits from purchasing two machines together is $90,000 if demand is low and $170,000 if demand is high. If one machine is purchased and demand is low, the NPV is $120,000. If demand is high, the manager has three options: (1) doing nothing, which has an NPV of $120,000; (2) subcontracting, with an NPV of $140,000; and (3) buying the second machine, with an NPV of $130,000. a. Draw a decision tree for this problem. b. What is the best decision and what is its expected payoff?
A manager is trying to decide whether to buy one machine or two. If only one machine is purchased and demand proves to be excessive, the second machine can be purchased later. Some sales would be lost, however, because the lead time for delivery of this type of machine is six months. In addition, the cost per machine will be lower if both machines are purchased at the same time. The probability of low demand is estimated to be 0.20 and that of high demand to be 0.80. The after-tax NPV of the benefits from purchasing two machines together is $70,000 if demand is low and $170,000 if demand is high. If one machine is purchased and demand is low, the NPV is $100,000. If demand is high, the manager has three options: (1) doing nothing, which has an NPV of $100,000; (2) subcontracting, with an NPV of $140,000; and (3) buying the second machine, with an NPV of $120,000. What is the best decision and what is its expected payoff? Best decision is to buy nothing…
A manager is trying to decide whether to buy one machine or two. If only one is purchased and demand proves to be excessive, the second machine can be purchased later. Some sales will be lost, however, because the lead time for producing this type of machine is six months. In addition, the cost per machine will be lower if both are purchased at the same time. The probability of low demand is estimated to be 0.20. The after-tax net present value of the benefits from purchasing the two machines together is $80,000 if demand is low and $180,000 if demand is high. If one machine is purchased and demand is low, the net present value is $110,000. If demand is high, the manager has three options. Doing nothing has a net present value of $110,000; subcontracting, $160,000; and buying the second machine, $130,000. a. Choose the correct decision tree for this problem. Note that each payoff is given in thousands of dollars.
RoboGarden sells a robot lawn aerator. At the current price, RoboGarden's contribution margin is $146.18 per unit. Because of a shortage of silicon chips, RoboGarden expects variable cost to increase by $12.09. In response, RoboGarden is thinking about raising its selling price by $33.76. Calculate the percent profit breakeven metric for this situation. Report the correct sign for the result. Report your answer as a percent. Report -25.5%, for example, as "-25.5. Rounding: tenth of a percent. Answer: 6.7 x (-12.9)
Berwin Inc. is a small industrial equipment manufacturer with approximately $3.5 million in annual sales.Berwin can always compete with other small appliance manufacturers. However, the market expandsonly when there is product innovation. The following is information on Berwin Inc's performance report:Required : Compute and analyze if the variance is favorable or unfavorable! Identify the strengths and weaknesses of the performance report and give your explanation! How should the report be revised to eliminate these weaknesses? Please explain!
Tell what life-cycle cost management is and how it can be usedto maximize profits over a product's life cycle.Nico Parts, Inc., produces electronic products with short life cycles (of lessthan two years). Development has to be rapid, and the profitability of theproducts is tied strongly to the ability to find designs that will keep production and logistics costs low. Recently, management has also decided that postpurchase costs are important in design decisions. Last month, a proposal for a new product was presented to management. The total market was projected at 200,000 units (for the two-year period). The proposed selling price was $130 per unit. At this price, market share was expected to be 25 percent. The manufacturing and logistics costs were estimated to be $120 per unit. Upon reviewing the projected figures, Brian Metcalf, president of Nico, called in his chief design engineer, Mark Williams, and his marketing manager, CathyMcCourt. The following conversation was recorded:…
Tell what life-cycle cost management is and how it can be usedto maximize profits over a product's life cycle.Nico Parts, Inc., produces electronic products with short life cycles (of lessthan two years). Development has to be rapid, and the profitability of theproducts is tied strongly to the ability to find designs that will keep production and logistics costs low. Recently, management has also decided that postpurchase costs are important in design decisions. Last month, a proposal for a new product was presented to management. The total market was projected at 200,000 units (for the two-year period). The proposed selling price was $130 per unit. At this price, market share was expected to be 25 percent. The manufacturing and logistics costs were estimated to be $120 per unit. Upon reviewing the projected figures, Brian Metcalf, president of Nico, called in his chief design engineer, Mark Williams, and his marketing manager, CathyMcCourt. The following conversation was recorded:…
Cysco Corp has a budget of $1,200,000 in 2017 for prevention costs. If it decides to automate a portion of its prevention activities, it will save $103,000 in variable costs. The new method will require $51,000 in training costs and $148,000 in annual equipment costs. Management is willing to adjust the budget for an amount up to the cost of the new equipment. The budgeted production level is 207,000 units. Appraisal costs for the year are budgeted at $508,000. The new prevention procedures will save appraisal costs of $50,000. Internal failure costs average $34 per failed unit of finished goods. The internal failure rate is expected to be 5% of all completed items. The proposed changes will cut the internal failure rate by one-half. Internal failure units are destroyed. External failure costs average $52 per failed unit. The company's average external failures average 4.5% of units sold. The new proposal will reduce this rate to 1%. Assume all units produced are sold and there are no…
Boxer Production, Inc., is in the process of considering a flexible manufacturing system that will help the company react more swiftly to customer needs. The controller, Mick Morrell, estimated that the system will have a 10-year life and a required return of 10% with a net present value of negative $500,000. Nevertheless, he acknowledges that he did not quantify the potential sales increases that might result from this improvement on the issue of on-time delivery, because it was too difficult to quantify. If there is a general agreement that qualitative factors may offer an additional net cash flow of $150,000 per year, how should Boxer proceed with this Investment?