NARRBEGIN: SA_93_95
After Michigan State University reached the final four in the 2000 NCAA Basketball
Tournament, a sweatshirt supplier in Lansing is trying to decide how many sweatshirts
to print for the upcoming championships. The final four teams (Michigan State, Florida,
Wisconsin, and North Carolina) 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.
NARREND
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.