Question

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.
Demand distribution at regular price
Demand distribution at reduced price
DemandProbability
DemandProbability
70.05
20.2
80.1
30.3
90.25
40.2
100.3
50.15
110.2
60.1
120.1
70.05
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.

Answer

This answer is hidden. It contains 298 characters.