POM/MIS - 4410/5410 Operations Analytics - Fall 2019 Assignment #1: Monte-Carlo Simulation (Due Sunday, Sep 29, 2019) Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. You'll see that there are bunch of questions that you'll have to answer using the model you build. Include all your answers directly in your Excel file using text boxes or comment boxes. You can have separate Excel files for your data table and @RISK solution files. Make it easy for me to find your answers. Write concisely and clearly. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed by the finals a few days later. Each sweatshirt costs $10 to produce and sells for $25. However, in 3 weeks, any leftover sweatshirts will be put on sale for half price, $12.50. The student assumes that the demand for her sweatshirts during the next three weeks has the distribution shown in the file NCAASweatshirts-shell.xlsx in F5:G10. The residual demand, after the sweatshirts have been put on sale, has the distribution also shown in the same file in J5:K10. The student, being a profit maximizer, realizes that every sweatshirt sold, even at the sale price, makes a profit. However, she also realizes that any sweatshirts printed and still unsold (even at the sale price) must be given away, resulting in a loss of $10 per discarded shirt. Your job is: