Consider the following spreadsheet for an outsourcing decision model.

	A	B
1	Outsourcing Decision Model
2
3	Data
4
5	Manufactured in-house
6	Fixed cost	$ 60,000
7	Unit variable cost	$ 130
8
9	Purchased from supplier
10	Unit cost	$ 165
11
12	Demand volume	1,000
13
14	Model
15
16	Total manufacturing cost
17	Total purchased cost
18
19	Difference
20	Decision

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 Risk Solver Platform.

1.What is the value of mode obtained from the simulation results? [Hint: Choose the nearest answer.]

A)$28,435

B)$22,485

C)$25,394

What is the value of mean absolute deviation obtained from the simulation results? [Hint: Choose the nearest answer.]

A)$10,893

B)$7,443

C)$5,885

2. What is the cost difference lower cutoff in thousands of dollars if the likelihood is 60%? [Hint: Choose the nearest answer.]

A)approximately 13.56

B)approximately 22.45

C)approximately 38.97

3. What is the cost difference upper cutoff in thousands of dollars if the likelihood is 75%? [Hint: Choose the nearest answer.]

A) approximately 46

B) approximately 32

C) approximately 59