Reference no: EM132892794

Suppose that a firm can produce a part it uses for $520 per unit, with a fixed cost of $24,000. The company has been offered a contract from a supplier that allows it to purchase the part at a cost of $540 per unit, which includes transportation. The key outputs in the model are the difference in these costs and the decision that results in the lower cost. Assume that the production volume is uncertain. Suppose the manufacturer has enough data and information to estimate that the production volume will be normally distributed with a mean of 1,200 and a standard deviation of 85. Use a 100-trial Monte Carlo simulation to find the average cost difference and percent of trials that result in manufacturing or outsourcing as the best decision. (Your data table should show both the cost difference and decision for each trial.)

Note: Please include Excel worksheet with all the details with your answer.