Aberdeen Computer Corp. (ACC) is located in Aberdeen, Washington. The company has developed the Web-Surfer, a low-cost e-mail and Web-surfing appliance. This product is manufactured at four plants, located in Atlanta, Kansas City, Aberdeen, and Austin. After production, the Web-Surfers are shipped to three warehouses, located in Nashville, San Jose, and Houston. ACC sells the Web-Surfers through the retail channel. In particular, five different retailers currently sell the Web-Surfer-Sears, Best Buy, Fry's, Comp USA, and Office Max. ACC makes weekly shipments to the main warehouses of these five retailers. The shipping cost from each plant to each warehouse, along with the production cost and weekly production capacity at each plant, are given in the table below.

The shipping cost from each warehouse to each customer, the variable cost (cost per unit moved through the warehouse), the capacity (maximum number of units that can be moved through the warehouse per week) for each warehouse, and the weekly demand for each customer are given in the table below.

a. Formulate and solve a linear programming model in a spreadsheet to determine the plan for weekly production and distribution of the Web-Surfer from the various plants, through the warehouses, to the customers that will minimize total costs.
____________________________________ Fixed Cost
Plant ________________________________ ($/week)
Atlanta .............................................. $8,000
Kansas City ........................................ $9,000
Aberdeen ........................................... $9,000
Austin ............................................. $10,000
___________________________________ Fixed Cost
Warehouse __________________________ ($/week)
Nashville .......................................... $4,000
San Jose .......................................... $5,000
Houston .......................................... $5,000
b. Now suppose that ACC is considering saving money by closing some of its production facilities and/or warehouses. Suppose there is a fixed cost to operate each plant and each warehouse as indicated in the tables above. Add binary variables to your model in part a to incorporate the decision of which plants and warehouses to keep open so as to minimize total cost (including the fixed costs for
any plant or warehouse that is operated).

Shipping Cost (S/unit) Production Capacity Plant Cost ($/unit) (units/week) Nashville San Jose Houston $30 $25 $45 $30 $50 $40 $55 Atlanta Kansas City $208 $214 $215 $210 200 $45 300 Aberdeen $30 $50 300 $30 Austin Shipping Cost ($/unit) Comp Variable Cost Office Max Warehouse Sears Best Fry's (units/week) Capacity (S/unit) Buy $45 $50 $35 USA $30 $25 $4 300 Nashville San Jose Houston Customer demand (per week) $40 $25 $20 $40 $15 $50 $15 $40 $5 $5 500 $50 $15 75 100 50 300 150