Prob Set For each case, {1) W build a simulation model, replicate the model, organize results in a table, 2-3 and provide conclusions (answers). {2) We (3) Submit We. Perform analysis work (complete BFDA) for these two cases in one excel le. For each case, use 1000 trials a after obtaining the results you will use. be sure to treeze the 1000 values of the objective measures. Case 1 UD Pizza -- 3-Year Financial Analysis- Consider the business situation of exercise 21, page 410IpIage 91 -- using the tollowing additional intormation. Assume this case concerns the six locations oi a new enterprise, UD Flyer Pizza. In addition to average 3yr prot {no trend chart required), suppose the U0 Flyer Pizza general manager also wants you to estimate (1] the likelihood that the 3year profit will be over $1,800,000, (2} over $2,000,000, and {3) risk that the prot will not show an increase over the three years, i.e. the 2nd and 3rd year prots will, on average, be no more than the lst year. Since the 1st year prot is estimated at $500,00, this is the same as the probability that 3-yr profit is