Review the case study on Managing Growth at SportsStuff below, for Excel sheet set up to solve this problem.
The problem is to identify the best set of small and/or large warehouses to meet the demand.
Answer the following questions:
a. Write the mathematical model that should be used to solve this problem.
b. For the current setting in the Excel sheet, using linear inventory model, what supply chain network configuration do you recommend?
c. If you were told that Philadelphia must be selected and Seattle must be ignored simultaneously, how would you go about doing this? What is the resulting solution?