Oregon State University has reached the final four in the 2016 NCAA Women's Basketball Tournament, and as a result, a sweatshirt supplier in Corvallis is trying to decide how many sweatshirts to print for the upcoming championships. The final four teams (Oregon State, University of Washington, Syracuse, and University of Connecticut) have emerged from the quarterfinal round, and there is a week left until the semifinals, which are then followed in a couple of days by the finals. Each sweatshirt costs $12 to produce and sells for $24. However, in three weeks, any leftover sweatshirts will be put on sale for half price, $12. The supplier assumes that the demand (in thousands) for his sweatshirts during the next three weeks, when interest is at its highest, follows the probability distribution shown in the table below. The residual demand, after the sweatshirts have been put on sale, also has the probability distribution shown in the table below. The supplier realizes that every sweatshirt sold, even at the sale price, yields a profit. However, he also realizes that any sweatshirts produced but not sold must be thrown away, resulting in a $12 loss per sweatshirt.

Demand distribution at regular price Demand distribution at reduced price

-Use @RISK simulation add-in to analyze the sweatshirt sales. Do this for normal distributions, where we assume that the regular demand is normally distributed with mean 10,000 and standard deviation 1500, and that the demand at the reduced price is normally distributed with mean 5,000 and standard deviation 1500.

Question

Oregon State University has reached the final four in the 2016 NCAA Women's Basketball Tournament, and as a result, a sweatshirt supplier in Corvallis is trying to decide how many sweatshirts to print for the upcoming championships. The final four teams (Oregon State, University of Washington, Syracuse, and University of Connecticut) have emerged from the quarterfinal round, and there is a week left until the semifinals, which are then followed in a couple of days by the finals. Each sweatshirt costs $12 to produce and sells for $24. However, in three weeks, any leftover sweatshirts will be put on sale for half price, $12. The supplier assumes that the demand (in thousands) for his sweatshirts during the next three weeks, when interest is at its highest, follows the probability distribution shown in the table below. The residual demand, after the sweatshirts have been put on sale, also has the probability distribution shown in the table below. The supplier realizes that every sweatshirt sold, even at the sale price, yields a profit. However, he also realizes that any sweatshirts produced but not sold must be thrown away, resulting in a $12 loss per sweatshirt.
​
Demand distribution at regular price Demand distribution at reduced price
​ 
-Use @RISK simulation add-in to analyze the sweatshirt sales. Do this for normal distributions, where we assume that the regular demand is normally distributed with mean 10,000 and standard deviation 1500, and that the demand at the reduced price is normally distributed with mean 5,000 and standard deviation 1500.

Quizplus · Accepted Answer

The Answer of Oregon State University has reached the final four in the 2016 NCAA Women's Basketball Tournament, and as a result, a sweatshirt supplier in Corvallis is trying to decide how many sweatshirts to print for the upcoming championships. The final four teams (Oregon State, University of Washington, Syracuse, and University of Connecticut) have emerged from the quarterfinal round, and there is a week left until the semifinals, which are then followed in a couple of days by the finals. Each sweatshirt costs $12 to produce and sells for $24. However, in three weeks, any leftover sweatshirts will be put on sale for half price, $12. The supplier assumes that the demand (in thousands) for his sweatshirts during the next three weeks, when interest is at its highest, follows the probability distribution shown in the table below. The residual demand, after the sweatshirts have been put on sale, also has the probability distribution shown in the table below. The supplier realizes that every sweatshirt sold, even at the sale price, yields a profit. However, he also realizes that any sweatshirts produced but not sold must be thrown away, resulting in a $12 loss per sweatshirt.
​
Demand distribution at regular price Demand distribution at reduced price
​ 
-Use @RISK simulation add-in to analyze the sweatshirt sales. Do this for normal distributions, where we assume that the regular demand is normally distributed with mean 10,000 and standard deviation 1500, and that the demand at the reduced price is normally distributed with mean 5,000 and standard deviation 1500.

Oregon State University Has Reached the Final Four in the 2016