Question: Use the information below to answer the following question ( s ) . Consider the following spreadsheet for an outsourcing decision model. table [

 Use the information below to answer the following question(s). Consider the

Use the information below to answer the following question(s).
Consider the following spreadsheet for an outsourcing decision model.
\table[[,A,B],[1,Outsourcing Decision Model,],[2,,],[3,Data,],[4,,],[5,Manufactured in-house,],[6,Fixed cost,560,000],[7,Unit variable cost,],[8,,],[9,Purchased from supplier,],[10,Unit cost,],[11,,],[12,Demand volume,],[13,,],[14,Model,],[15,,],[16,Total manufacturing cost,],[17,Total purchased cost,],[18,Difference,],[19,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 Analytic Solver Platform.
[Hint: choose the closest value.]
Determine the value of standard deviation found from the simulation results
Select one:
a. $9,175
b. $7,884
c. $3,860
d. $12,870
following spreadsheet for an outsourcing decision model. \table[[,A,B],[1,Outsourcing Decision Model,],[2,,],[3,Data,],[4,,],[5,Manufactured in-house,],[6,Fixed cost,560,000],[7,Unit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!