Business decision model question. Need excel, chart, explanations, simulations, statistics. please answer with excel. The question is in the attachment. Only one question, please help. Need excel charts.

Question 1: Simulation (20 marks) Julia (from Julia foods week 6) has decided that some of the assumptions she made in her LP model for her food booth were too unrealistic and she has decided to try a simulation model as well. In particular, she was uncomfortable with the assumption that she would be able to sell everything that she prepares for sale. This will naturally depend on stochastic factors like the weather. Julia still wants to base her model on a single game but has consulted a few experts and determined that the demand for pizza slices and hot dogs depends heavily on the weather. When the weather is good, she expects pizza slice sales to follow a Poisson distribution with a mean of 1000 (remember she still has several constraints she cannot exceed from the original problem). Hot dog sales follow the same distribution when the weather is good. If the weather is average, the distributions remain Poisson but the mean drops to 800 for pizza slices and 700 for hot dogs. Things get a bit more complicated when the weather is poor. People seem to dislike wet hot dog buns so the mean drops to 500. Pizza slices fare better in poor weather with a mean of 700. The real challenge, of course is predicting the weather. Julia consulted two different weather apps and got slightly conicting forecasts that she has summarized as follows: Forecast 1: Probability good = 0.5, Average = 0.3, poor = 0.2 Forecast 2: Probability good = 0.3, Average = 0.3, poor = 0.4 Develop a conceptual model (ow chart) and well labelled simulation model to help improve Julia's decision making. The rst scenario to try is the optimal solution from the deterministic LP model ( 1250 slices and 1250 Hot Dogs). Develop at least 3 additional scenarios that do not violate any of the existing constraints. You can run two sets of simulations (one for each weather pattern) or try to cleverly combine them into a single simulation. Base your recommendations on 100 iterations of each scenario. Should Julia rent the booth? If yes, how many slices and hot dogs should she stock? Try to estimate her probability of breaking even