Consider the transportation problem having the following data.

Table 1: Transportation Problem Data

Destination
	1	2	3	SUPPLY
Source
1	$6.00	$7.00	$4.00	40
2	$5.00	$8.00	$6.00	60
Demand	30	40	30

Image 1: Transportation Problem Data for Clarity of above Table

a. Formulate a network model for this problem as a minimum-cost flow problem by drawing a network similar to Figure 6.3 (however, your model will not include a Distribution center).

*Hint: for letter a, please use the Insert tab (Illustrations group, and Shapes button) in Excel 2007 to assist you with the model (snapshot of Figure 6.3 is listed below as an example).

b. Formulate and solve a spreadsheet model for this problem. Has to have range name table

Destination 23 SUPPLY Source $6.00 40 $7.00 $8.00 40 $5.00 30 $4.00 $6.00 30 60 Demand $200 / $400 $400 [ [50] { F2 [0] Destination 23 SUPPLY Source $6.00 40 $7.00 $8.00 40 $5.00 30 $4.00 $6.00 30 60 Demand $200 / $400 $400 [ [50] { F2 [0]