Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The owner of Fix-a-dent Auto Repair wants to study the growth of his business using simulation. He is interested in simulating the number of damaged
The owner of Fix-a-dent Auto Repair wants to study the growth of his business using simulation. He is interested in simulating the number of damaged cars and the amount of damage to the cars each month. He currently repairs 100 cars per month and feels the change in number of cars can vary uniformly between a decrease of as much as 3% and an increase of up to 5% (average change of 1%). The dollar value of the damage to the cars is a normally distributed random variable with a mean of $3,000 and a standard deviation of $500. The average repair bill has been increasing steadily over the years and the owner expects the mean repair bill will increase by 1% per month. A spreadsheet model to simulate the problem has been run 300 times. A part of the simulation statistics output from Risk Solver Platform (RSP)and a spreadsheet for computing confidence intervals follows. Using the information in Exhibit 12.2. what is the worst case scenario for the Fix-a-dent company The owner of Fix-a-dent Auto Repair wants to study the growth of his business using simulation. He is interested in simulating the number of damaged cars and the amount of damage to the cars each month. He currently repairs 100 cars per month and feels the change in number of cars can vary uniformly between a decrease of as much as 3% and an increase of up to 5% (average change of 1%). The dollar value of the damage to the cars is a normally distributed random variable with a mean of $3,000 and a standard deviation of $500. The average repair bill has been increasing steadily over the years and the owner expects the mean repair bill will increase by 1% per month. A spreadsheet model to simulate the problem has been run 300 times. A part of the simulation statistics output from Risk Solver Platform (RSP)and a spreadsheet for computing confidence intervals follows. Using the information in Exhibit 12.2. what is the worst case scenario for the Fix-a-dent company
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started