Complete the sensitivity report on excel !

Acme Forklifts The distribution system for Acme Forklifts consists of 3 manufacturing plants, 2 warehouses and 4 distribution centers. Plant capacities and shipping costs per forklift from each plant to each warehouse are shown below. Acme is interested in achieving the lowest possible total shipping costs, subject to meeting its forecasted demand at each distribution center. Plant P1 P2 P3 Warehouse W1 W2 550 $ 575 $ 775 $ 625 $ 625 $ Capacity 500 520 400 525 Forecasted demand for each Distribution Center and per unit shipping costs from each warehouse to each distribution center are as follows: Acme has 14 DVS and 9 constraints. Correctly solved, total shipping costs > $ 1.4 million. Expect questions on costs from plants to warehouses, or warehouses to Distribution Centers. Several questions come from the sensitivity report. Be prepared to resolve the problem if an arc is closed. Warehouse W1 W2 Distribution Center D1 D2 D3 $ 480 $ 575 $ 625 $ 325$ 500 $575 D4 $ 425 $ 675 Demand 300 400 300 400