(LP MODEL+ Sensitivity Report) on .pdf + Solution on .xlsx ?

EXAMPLE 3.1 The Goodwin Manufacturing Company The Goodwin Manufacturing Company is planning next week's shipments from its three man- ufacturing plants to its four distribution warehouses and is seeking a minimum-cost shipping schedule. Each plant has a potential capacity, expressed in cartons of product, and each ware- house has a demand requirement for the week that must be met. There are 12 possible shipment routes, and for every plant-warehouse combination, the unit shipping cost is known. The following table provides the given information. (To) Warehouse (From) plant Atlanta Boston Chicago Denver Capacity Minneapolis Pittsburgh Tucson $0.60 0.36 0.65 $0.56 0.30 0.68 $0.22 0.28 0.55 $0.40 0.58 0.42 10,000 15,000 15,000 Requirement 8000 10,000 12,000 9000