I t is March, and the annual NCAA Basketball Tournament is down to the final 4 teams. Randy Kitchell is a t-shirt vendor who plans to order t-shirts with the names of the final 4 teams from a...

I t is March, and the annual NCAA Basketball Tournament is down to the final 4 teams. Randy Kitchell is a t-shirt vendor who plans to order t-shirts with the names of the final 4 teams from a manufacturer and then sell them to the fans. The fixed cost of any order is $750, the variable cost per t-shirt to Randy is $6, and Randy’s selling price is $10. However, this price will be charged only until a week after the tournament. After that time, Randy figures that interest in the t-shirts will be low, so he plans to sell all remaining t-shirts, if any, at $4 each. His best guess is that demand for the t-shirts during the full-price period will be 1500. He is thinking about ordering 1400 t-shirts, but he wants to build a spreadsheet model that will let him experiment with the uncertain demand and his order quantity. How should he proceed?

Objective To build a spreadsheet model in a series of stages, all stages being correct but each stage being more readable and flexible than the p