3. Weber has two production plants (P1, P2), from which it ships barbeque grills to its three national warehouses (W1, W2, W3). From these warehouses it feeds the supply chain of Lowes through eight regional distribution centers (D1, D2, D3, D4, D5, D6, D7, D8). The shipping costs between these locations, plant supply capacity and the weekly supply demand data in cases are shown below:

	Supply Capacity	Shipping Cost W1 W2 W3				Weekly Demand	Shipping Cost W1 W2		W3
P1	30000	$3.25	$4.50	$1.25	D1	8000	$4	$3	$1
P2	30000	$4.40	$1.50	$1.00	D2	13500	$3	$4	$1
					D3	11900	$2	$5	$4
					D4	3200	$1	$6	$2
					D5	1400	$1	$3	$5
					D6	800	$5	$2	$3
					D7	6800	$4	$1	$2
					D8	900	$5	$2	$1

1. Solve the network distribution problem via LP using MS-Solver
2. Plant P2 needs to shut down one of its assembly lines and the capacity is reduced to 23000 units. What is the new distribution plan, and what is the additional supply chain cost.
3. If the W2 warehouse has a maximum distribution capacity of 5000 units/week how does the solution in (i) change?
4. If the production costs at P2 are $3 higher than P1, how does the solution in (i) change?