Suppose that a firm can produce a part it uses for $520 per unit, with a fixed cost of $25,000. The company has been offered a contract from a supplier that allows it to purchase the part at a cost of $544 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,000 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. Please include table showing both the cost difference and decision for each trial. Please include the Excel worksheet with all the details with your answer.
Suppose that a firm can produce a part it uses for $520 per unit, with a fixed cost of $25,000. The company has been offered a contract from a supplier that allows it to purchase the part at a cost of $544 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,000 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. Please include table showing both the cost difference and decision for each trial. Please include the Excel worksheet with all the details with your answer.
Suppose that a firm can produce a part it uses for $520 per unit, with a fixed cost of $25,000. The company has been offered a contract from a supplier that allows it to purchase the part at a cost of $544 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,000 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. Please include table showing both the cost difference and decision for each trial. Please include the Excel worksheet with all the details with your answer.
Suppose that a firm can produce a part it uses for $520 per unit, with a fixed cost of $25,000. The company has been offered a contract from a supplier that allows it to purchase the part at a cost of $544 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,000 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. Please include table showing both the cost difference and decision for each trial. Please include the Excel worksheet with all the details with your answer.
Features Features Normal distribution is characterized by two parameters, mean (µ) and standard deviation (σ). When graphed, the mean represents the center of the bell curve and the graph is perfectly symmetric about the center. The mean, median, and mode are all equal for a normal distribution. The standard deviation measures the data's spread from the center. The higher the standard deviation, the more the data is spread out and the flatter the bell curve looks. Variance is another commonly used measure of the spread of the distribution and is equal to the square of the standard deviation.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
