File Home Insert Page Layout Formulas Data Review View Help G10 A D E 1 2 3 4 5 7 8 9 Question 2: Michael Abrams runs a specialty clothing store that sells collegiate sports apparel. One of his primary business opportunities involves selling custom screenprinted sweatshirts for college football bowl games. He is trying to determine how many sweatshirts to produce for the upcoming Tangerine Bowl game. During the month before the game, Michael plans to sell his sweatshirts for $25 apiece. At this price, he believes the demand for sweatshirts will be triangularly distributed with a minimum demand of 10,000, maximum demand of 30,000 and a most likely demand of 18,000. During the month after the game, Michael plans to sell any remaining sweat shirts for $12 apiece. At this price, he believes the demand for sweatshirts will be normally distributed with a mean of 5,000, and a standar deviation of 1,000. Two months after the game, Michael plans to sell any remaining sweatshirts to a surplus store that has agreed to buy up to 2,000 sweatshirts for a price of $3 per shirt. Michael can order custom screenprinted sweatshirts for $8 apiece . Suppose that he has decided to order 18,000 sweatshirts, perform a simulation-based analysis on his totoal profit. 10 11 12 13 14 15 16 17 18 Simulation model File Home Insert Page Layout Formulas Data Review View Help Shape Form toShap... X H A Simulation model Cost per item ($) Number of items ordered int 1: Items sold is the minimum of items orderd and demar 8 18000 Hint 2: Use Round function to round the demand 25 Month before the game Selling price per item Demand Items sold Revenue 1 Month after the game Items left Selling price per item Demand Items sold 12 Revenue2 Two Month after the game Items left Selling price per item Max Demand Items sold 3 2000 Revenue 3 Total Revenue 2 Question 1 Question 2