Solve for Solver

X14 = # of bushels sent to Mt. Dora (site 1) to Ocala (site 4)

X15 = # of bushels sent to Mt. Dora (site 1) to Orlando (site 5)

X16 = # of bushels sent to Mt. Dora (site 1) to Leesburg (site 6)

X24 = # of bushels sent to Eustis (site 2) to Ocala (site 4)

X25 = # of bushels sent to Eustis (site 2) to Orlando (site 5)

X26 = # of bushels sent to Eustis (site 2) to Leesburg (site 6)

X34 = # of bushels sent to Clermont (site 3) to Ocala (site 4)

X35 = # of bushels sent to Clermont (site 3) to Orlando (site 5)

X36 = # of bushels sent to Clermont (site 3) to Leesburg (site 6)

Objective:

MIN: 21X14 + 50X15 + 40X16 +

35X24 + 30X25 + 22X26 +

55X34 + 20X35 + 25X36

 

FILE Paste D2 1 2 3 4 5 6 7 8 9 10 11 12 13. 14 15 16 17 18 19 20 21 READY e S HOME Cut EB Copy Format Painter Clipboard . INSERT PAGE LAYOUT B Arial 8 X fix Sensitivity: Restricted A BIU. Grove Mt. Dora Eustis Clermont C Ocala 21 35 55 0 Ocala 0 0 0 Grove Mt. Dora Eustis Clermont Received 0 Capacity 200,000 Shipping Report Font - 10 4 24 D Tropicsun Distances From Groves to Plant at Orlando 50 + FORMULAS 30 20 Total Distance (in bushel-miles) Bushels Shipped From Groves to Plant at Orlando 0 0 0 0 600,000 A A e A 5 P O E Leesburg 40 22 25 DATA Leesburg 0 0 0 0 225,000 0 W REVIEW VIEW Alignment Public F Fig3-24 (1) (2) (Compatibility Mode] - Excel Wrap Text Merge & Center P G Bushels Bushels Shipped Available 0 275,000 0 400,000 0 300,000 Restricted Protect Protection H X Custom $%$ Number Sensitive 1 588 G J Conditional Format as Cell Formatting Table Styles Styles Password Encryption 11 K I 4 L B 28 62 Insert Delete Format M 1+1 Cells N B B AutoSum Fill- Clear- * ES 0 M ? Gabriel E. Caro Ayala AY H Sort & Find & Filter Select Editing 1600- P A + * + 120% 10:22 AM 10/11/2018