Solve the following Make in-house or outsource decision model using Monte Carlo Simulation of Data Table. The production level has to be set equal to demand. Demand is assumed to follow a normal distribution of mean = 1200 and a standard deviation of 175. Make 1000 trials to simulate demand to find out the approximate probability to meet the demand through outsourcing, Data Manufactured in-house Fixed cost $50,000 Unit variable cost $135 Purchased from supplier Unit cost $180 Production volume Model Total manufacturing cost Total purchased cost Cost difference Decision (Production/ Outsourcing)

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
icon
Related questions
Question

Solve the following Make in-house or outsource decision model using Monte Carlo Simulation of Data Table. The production level has to be set equal to demand. Demand is assumed to follow a normal distribution of mean = 1200 and a standard deviation of 175. Make 1000 trials to simulate demand to find out the approximate probability to meet the demand through outsourcing,
Data
Manufactured in-house
Fixed cost
$50,000
Unit variable cost
$135


Purchased from supplier
Unit cost
$180


Production volume

Model


Total manufacturing cost
Total purchased cost

Cost difference
Decision (Production/ Outsourcing)

Expert Solution
steps

Step by step

Solved in 4 steps with 8 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill