Explore BrainMass
Share

Excel: Design, Reliability and Warranty

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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
_______________________

© BrainMass Inc. brainmass.com October 17, 2018, 3:06 am ad1c9bdddf
https://brainmass.com/business/strategy-and-business-analysis/excel-design-reliability-warranty-408781

Attachments

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 ...

Solution Summary

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

$2.19
Similar Posting

Riordan supply chain and operational design

Riordan Supply-Chain and Operational Design Analysis Pt.1
• Ch. 9 Quality
• Previous Assignment Information
• Riordan Simulation
• Project Requirements (Dr. Tom)
Writing Tense: 3rd Person (He, She, They, or It)
Writing Style: Expository (Explain, Review, and Describe - Be Objective - Avoid Personal Opinions)
Minimum Word Count for the Assignment: Between 450 - 600 total words
Answer the following discussion points with operational concepts presented within the course material.
Operational Analysis:
• Determine Riordan's manufacturing strategy (Chase, Level, or combination) and explain its benefits.
• Describe how lean production principles may be used to maximize the efficiency and effectiveness of the supply chain process
• Create an analysis-based process flow diagram for the existing versus the proposed supply-chain and operational processes
Assignment Quality Requirements
• Includes an active attempt to present the information in a clear, and concise manner
• Includes one or more supporting citations for each discussion point. The primary supporting citation must be from the course text, and or, course support documents.
• Includes external support citations from a minimum of two peer-reviewed journal articles less than 5-years old. The supporting article references satisfy the writing requirements for conducting research beyond the course material.
(Basic definitions and concepts not cited from the course text and support materials will result in points deducted from the overall assignment score.)
• Formatted based on the standard APA citation rules
• Submitted through the Plagiarism Checker/Grammarly Tools and demonstrate a reasonable attempt to correct quality issues
• Reviewed and adjusted per writing requirements in the course Instructor

View Full Posting Details