Purchase Solution

Excel: Design, Reliability and Warranty

Not what you're looking for?

Ask Custom Question

1. Prepare an analysis of product reliability and MTBF data on the drive-train components for an important line of heavy-duty equipment. The client has been offering a 12-month warranty on the drive-train package but believes that unit volume could be increased by as much as 10% if the warranty can be extended to 18 months.

2. A phone call to Mike Russell, the clients Director of Engineering, reveals that warranty costs average $40 per episode

a. Your first objective is to determine what percentage of product requires service in the 12-month warranty period assuming service distributed along an Exponential Curve. You determine that figure below and attached:___________________ 24.85%
b. Assuming that the client currently sells an average of 6,380 units monthly, a 10% increase to 7,018 units would increase estimated warranty expense from___________________ to ____________________
Current warranty expenses $63,422.99
Warranty expenses with extended warranty $97,848.03
Warranty expense will increase from $63,422.99 to $97,848.03 $34,425.03
c. Based on your earlier work with the results table above you are able to determine the degree of operating income generated by the sales lift and compare it with the increase in warranty expense. That difference is_______________________________
Data not available to answer this. We need profit margins or profits per unit to answer this. Suppose the profit per unit is $50, then operating income would increase by $50*638= $31900. The increase in warranty expense is $97848.03 - $63,422.99=$34,425.03. Hence, the extended warranty expenses are higher than the increase in profits on additional units sold. You can work the same with correct operating income per unit. 31900

d. After the discussion on warranty costs, Russell wants to talk about projected returns on R & D investments. Russell has four high-risk but potentially high pay-off projects in the works and is concerned that he'll draw four 'blanks.' You're quick to assure him that he's made a wise move. Costs, probability of success, and pay-off values are attached:
1) The probability of at least one success is:________________________ 0.90616
2) The probability of at least two successes is:_________________ 0.57328
3) The probability of at least three successes is: 0.19497
4) The probability that all will succeed is: 0.02559
_______________________

Attachments
Purchase this Solution

Solution Summary

Design, reliability and warranty for Excel are examined. The percentages of products which require services are given.

Solution Preview

See the attached file. Thanks

1.    prepare an analysis of product reliability and MTBF data on the drive-train components for an important line of heavy-duty equipment. The client has been offering a 12-month warranty on the drive-train package but believes that unit volume could be increased by as much as 10% if the warranty can be extended to 18 months.

2.    A phone call to Mike Russell, the clients Director of Engineering, reveals that warranty costs average $40 per episode

a.    Your first objective is to determine what percentage of product requires service in the 12-month warranty period ...

Purchase this Solution


Free BrainMass Quizzes
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Learning Lean

This quiz will help you understand the basic concepts of Lean.