Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(All answers were generated using 1,000 trials and native Excel functionality.) Grear Tire Company has produced a new tire with an estimated mean lifetime

image text in transcribed

(All answers were generated using 1,000 trials and native Excel functionality.) Grear Tire Company has produced a new tire with an estimated mean lifetime mileage of 36,500 miles. Management also believes that the standard deviation is 5,000 miles and that tire mileage is normally distributed. To promote the new tire, Grear has offered to refund some money if the tire fails to reach 29,000 miles before the tire needs to be replaced. Specifically, for tires with a lifetime below 29,000 miles, Grear will refund a customer $1 per 100 miles short of 29,000. Construct a simulation model to answer the following questions. The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Generate trials on a new worksheet. X Download spreadsheet grear-6e7748.xlsx a. For each tire sold, what is the average cost of the promotion? Round your answer to the nearest cent. $ per tire b. What is the probability that Grear will refund more than $25 for a tire? Round your answer to one decimal percentage place. % Check My Work Reset Problem

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Real Analysis

Authors: Robert G. Bartle, Donald R. Sherbert

4th edition

471433314, 978-1118135853, 1118135857, 978-1118135860, 1118135865, 978-0471433316

More Books

Students also viewed these Mathematics questions