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.

Plant	Store
X	Y	Z
A
B
C

1. What is the minimal shipping cost?