Question
Consider the following spreadsheet for an outsourcing decision model, where we assume that the production (demand) volume is normally distributed with a mean of 1,000
Consider the following spreadsheet for an outsourcing decision model, where we assume that the production (demand) volume is normally distributed with a mean of 1,000 and a standard deviation of 100. For the unit cost, select the triangular distribution. It has a minimum value of $150, most likely value of $165, and a maximum value of $190. The number of trials per simulation is equal to 5,000 at a Sim. Random Seed of 1. Run the simulation and answer the following question(s) using the Analytic Solver Platform.
[Hint: choose the closest value.]
What is the expected loss determined from the simulation results?
Question options:
| $(78) |
| $(120) |
| $(47) |
| $(60) |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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