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.

This is what i have but it wont solve

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] cortneydickinsonpr3(AutoRecovered) Home Data Share AutoSave OFF S U Insert Draw Page Layout Calibri (Body) 16 BIU : Formulas A A A Review View = = ? SE Comments - alle Wrap Text insert Delete General $ % 47 Merge & Center 98 .co70 Conditional Format Formatting as Table Cell Styles Format Sort & Filter Ideas X Find & Select Yes No Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover thom? H17 x fx Solver Cost per unit to deliver > Objective (Minimize $B$18) Destination 1 Destination 2 Destination 3 Source 1 6 Source 2 5 > Variables ($C$11:$E$12) Constraints ($C$14:$E$14 >= $C$16:$E$16,...) 9 Recommended shipping model Ship Destination 1 Destination 2 Destination 3 Source 1 1 Source 2 Capacity 40 $C$1 SE$14>= $0$10:$E$18 $F$11 SF$12 -$4$11:$K$12 Model (Type: linear) > Engines (Standard LP/Simplex) Insert Example Login for Upgrade A Network Model B. Spreadsheet Model 2017 FrontlineHelp. Examples. Upgrades + Hal - + 100%