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? (hint: using sample mean and std dev)b)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? c)based on the same 1000 scenarios, how many ski jackets should egress produce to maximize expected profit? shouldthe optimal productionequal mean demand or not? explain. d)create a histogram of profit at the optimal production level. create a histogram of profit when the production level equals mean demand. what is the probability of a loss greater than $100,000 in each case?