Question: Consider the Outsourcing Decision Model spreadsheet for an outsourcing decision model.We assume that the production ( demand ) volume is normally distributed with a mean
Consider the Outsourcing Decision Model spreadsheet for an outsourcing decision model.We assume that the production demand volume is normally distributed with a mean of and a standard deviation of For the unit cost, select the triangular distribution. It has a minimum value of $ most likely value of $ and a maximum value of $ The number of trials per simulation is equal to at a Sim. Random Seed of Run the simulation and answer the following questions using the Analytic Solver Platform. Hint: choose the closest value. Do all the calculations and keep them as reference.A B Outsourcing Decision Model Data Manufactured In House Fixed Cost $ Unit Variable Cost $ Purchased from Supplier Unit Cost $ Triangular random variate unit cost #NAME? Demand Volume $ Normal distribution demand volume $ Model Total Manufacturing Cost Total Purchased Cost Difference $ Decision Outsource
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
