The text for problem #6.2 on pg. 220 reads as follows:

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. Range names and color-coding Must include a solver dialog box

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]