# Prediction of Future Ski Jacket Demand Using Simulation

## Prediction of Future Ski Jacket Demand Using Simulation

﻿Prediction of Future Ski Jacket Demand Using Simulation
An Analysis.

Egress Inc.

Egress Inc. is a relatively new ski jacket production company. In order to predict the quantity of Ski Jackets Egress should manufacture for next season, we need to simulate the demand and also predict the quantity to manufacture that will maximize the profits.

Question No. 1
Egress management believes that a normal distribution is a reasonable model for the unknown demand in the coming year. What mean and standard deviation should Egress use for the demand distribution?
Assuming that the demand is distributed normally, using the twelve random values for demand predicted by the employees of the company as follows:
14,000
16,000
13,000
8,000
14,000
5,000
14,000
11,000
15,500
8,000
10,500
15,000

We calculate the mean of the demand by adding all the values in the above table and dividing them by 12. Alternatively we can use AVG function in excel as shown in the excel file.
Mean = 12,000
The standard deviation can be calculated using the STDEV function of excel as shown in the excel file.
Standard Deviation = 3497

Question No. 2
Use a spreadsheet model to simulate 1000 possible outcomes for demand in the coming year. Based on these scenarios, what is the expected profit if Egress produces Q = 7800 ski jackets? What is the expected profit if Egress produces Q = 12,000 ski jackets? What is the standard deviation of profit in these two cases?