Answered step by step
Verified Expert Solution
Question
1 Approved Answer
We recommend using a new workbook for each@Risk part and combining all workbooks together at the end. For each@Risk part, use the following instructions to
We recommend using a new workbook for each@Risk part and combining all workbooks together at the end. For each@Risk part, use the following instructions to export simulation results to Excel: - Click on Explore and select Results Summary. - Click on Export in the lower right-hand corner and select "Export to Excel...". - Choose "New Worksheet in Active Workbook". - Check "Export Active Table Only". - Click "OK". The Purdue Athletic Department is trying to decide how many sweatshirts to print for the upcoming NCAA basketball championships. The final four teams have emerged from the quarterfinal round, and there is now a week left until the semifinals, which are then followed in a couple of days by the finals. Each sweatshirt costs $20 to produce and sells for $50. However, in three weeks, any leftover sweatshirts will be put on sale for half price, \$25. The Athletic Department assumes that the demand for the sweatshirts during the next three weeks (when interest in the tournament is at its highest) is normally distributed with mean 500 and standard deviation 150 . The residual demand, after the sweatshirts have been put on sale, is a binomial distribution with probability of a sale at 40%. The Athletic Department realizes that every sweatshirt sold, even at the sale price, yields a profit. However, it also realizes that any sweatshirts produced but not sold (even at the sale price) must be thrown away or donated, resulting in a $20 loss per sweatshirt. It is considering ordering 300, 350, 400,450,500,550,600,650, or 700 sweatshirts. a. Determine the best order alternative of sweatshirts to produce using Excel functions only. Create a one-way table to store the results for each order alternative. b. Determine the best order alternative of sweatshirts to produce using an @ Risk model. Remember to include the Results Summary report. For both parts, include a textbox stating the best order alternative and the average profit
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started