Question #3 (5 points) Consider the following transportation decision-making information:

Plant	Capacity	Store	Demand
A	400	X	200
B	500	Y	250
C	100	Z	300
Total	1000	Total	750

Cost to ship from plant to store (per unit of demand)

Plant	Store
	X	Y	Z
A	$2	$2	$3.5
B	$4	$5	$4.5
C	$3	$3	$3

1. Develop the following shipping assignment table that uses the Solver function to find the optimal shipping patterns between the plants and the stores.

Optimal Shipping Plan

Plant	Store
	X	Y	Z	Total
A	150	250	0	400
B	50	0	200	250
C	0	0	100	100
Total	200	250	300

2. What is the minimal shipping cost?