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.50
B	$4	$5	$4.50
C	$3	$3	$3
a) Develop the following shipping assignment table that uses the Solver function to find the optimal shipping patterns between the plants and the stores.
Plant	Store
X	Y	Z
A
B
C
b) What is the minimal shipping cost?