Problem 1 Transportation Problem Review m-supply points n-demand points Recall the complete Transportation Model we studied (page 30 of Chapter 11). To make sure you are comfortable with the Excel Solver, set up the model in a Spreadsheet, and solve it. Once you get the same optimal solution and objective value as MPL (page 31), upload your Excel file (labeled: \"Group # - Problem 1\") on Moodle. Notes: * This is rather a large problem, consisting of 18 decision variables and 12 constraints. Be patient while setting up the model in Excel! * Remember that you have a mixed-integer problem, so make sure to define certain variables (not all) as binary. * Please do not include any report (answer, sensitivity, limits) in your Excel file. "L MPL for Windows 4.2 - [C: \\Documents and Settings\\trisha\\My Documents\\TEACHING\\FOMGT353-MANAGEMENT SCIENCE\\Notes\\11. IP\\SupplyDemand. ... - X File Edit Search Project Run View Graph Options Window Help - 5 X Variables x11, *12 , *13 , *14, x15 x21, x22, x23 , x24, x25 x31, x32 , x33, x34, x35 Binary Variables y1 y2 U3 Min 2x11 + 3x12 + 1x13 + 5x14 + 1x15 + 3x21 + 2x22 + 1x23 + 4X24 + 2x25 1x31 + 5x32 + 3x33 + 2x34 + 1x35 300y1 + 20042 + 15093; subject to *11 + x12 + x13 + x14 + x15 Main model file: SupplyDemand.mpl 4:18 Modified Solved start @ 11. IP MRL MPL for Windows 4.2 ... 09 2 3 8:59 AM"IMPL for Windows 4.2 - [View File: SupplyDemand.sol] Boy File Edit Search Project Run View Graph Options Window G X SOLUTION RESULT We only ship out Optimal integer solution found of warehouse 1! MIN Z 1250 .0090 RETAIL STORE DECISION VARIABLES WAREHOUSE 1 50 PLAIN VARIABLES Variable Name Activity Reduced Cost 400 1 x11 2 50 x12 50 -0906 x13 106 .9090 x14 100 .0900 x15 106 . 0506 3 . 0906 2 x21 0 . 0606 300 2 . 0906 x22 0 . 5006 3 100 x23 1 .0509 x24 x25 2 . 0906 x31 2 . 0050 x32 5.0090 200 3 x33 5.0506 4 100 x34 9 .0906 *35 3 . 0905 y1 42 -100 .0509 y3 -509 .9090 5 100 Main model file: SupplyDemand.mpl Solved start 11. IP "PL MPL for Windows 4.2 ... 9 2 31% 8:55 AM