Joe Bagov makes 500 donuts in Wayne and has customers in Tilden who want 100 donuts,...

 

Transcribed Image Text:

Joe Bagov makes 500 donuts in Wayne and has customers in Tilden who want 100 donuts, in Norfolk who want 200 donuts and in South Sioux City who want 200 donuts. Joe has distributors in Wisner and Laurel who will get the donuts and take them to the final destinations. Joe has to decide how much each distributor will take to each location. The locations have the following numbers to identify the locations: Wayne 1, Laurel 2, Wisner 3, Tilden 4, Norfolk 5, and South Sioux City 6. It costs 10 cents per donut to get donuts from Wayne to the distributors in both Laurel and Wisner. The costs per donut to go from Laurel to Tilden, Norfolk and South Sioux City are 15, 10, and 15 cents, respectively. Similarly, from Wisner to these locations, respectively, are 13, 9 and 16 cents. A-How many donuts are shipped on each route and what is the minimum cost of the shipping? List every route using city names, not numbers and include those routes where even 0 is shipped. B-Would the shipping amounts change if the cost of shipping from Wayne to Laurel changed to 6 cents? Yes or no? As you explain why, indicate where you look on the reports? C-What does the reduced cost of 0.01 on the variable X36 mean? Also mention what x36 means. D-What would happen to the total cost of shipping if Tilden only wanted 99 donuts? Explain where you are finding this on the report. Objective Cell (Min) Cell $J$3 Variable Cells Cell $B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $H$10 $I$10 Constraints Cell $J$4 $J$5 Name Cost Name x12 x13 x24 x25 x26 x34 x35 x36 Name Wayne Laurel $J$6 $J$7 $J$8 $J$9 South Sioux City Wisner Tilden Norfolk Original Value 0.98 Original Value Final Value Integer Contin Contin 1 1 1 1 1 1 1 1 Final Value 111 Cell Value 500 0 0 100 200 200 200 300 0 0 200 100 200 0 Contin Contin Contin Contin Contin Contin Formula Status Slack $J$4<=$L$4 Binding 0 $J$5-$L$5 Binding 0 $J$6-$L$6 Binding 0 $J$7=$L$7 Binding 0 $J$8-$L$8 Binding 0 $J$9-$L$9 Binding 0 Variable Cells Cell $B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $H$10 $I$10 Constraints Cell $J$4 $J$5 Name x12 x13 x24 X25 x26 x34 x35 x36 Name Wayne Laurel Wisner $J$6 $J$7 $J$8 $J$9 South Sioux City Tilden Norfolk 0.1 0.01 0.01 0.01 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 0 0.02 0.01 0 0 0 0.01 200 300 0 0 200 100 200 0 1E+30 1E+30 0.01 0.02 0.01 1E+30 0.01 0.02 0.01 1E+30 1E+30 1E+30 0.01 Final Shadow Value Price 500 0 -0.1 0 -0.1 0 100 0.23 200 0.19 200 0.25 0.1 0.15 0.1 0.15 0.13 0.09 0.16 Constraint Allowable Allowable Decrease R.H. Side Increase 500 0 0 1E+30 200 0 0 0 300 100 0 100 200 0 200 200 0 200 Joe Bagov makes 500 donuts in Wayne and has customers in Tilden who want 100 donuts, in Norfolk who want 200 donuts and in South Sioux City who want 200 donuts. Joe has distributors in Wisner and Laurel who will get the donuts and take them to the final destinations. Joe has to decide how much each distributor will take to each location. The locations have the following numbers to identify the locations: Wayne 1, Laurel 2, Wisner 3, Tilden 4, Norfolk 5, and South Sioux City 6. It costs 10 cents per donut to get donuts from Wayne to the distributors in both Laurel and Wisner. The costs per donut to go from Laurel to Tilden, Norfolk and South Sioux City are 15, 10, and 15 cents, respectively. Similarly, from Wisner to these locations, respectively, are 13, 9 and 16 cents. A-How many donuts are shipped on each route and what is the minimum cost of the shipping? List every route using city names, not numbers and include those routes where even 0 is shipped. B-Would the shipping amounts change if the cost of shipping from Wayne to Laurel changed to 6 cents? Yes or no? As you explain why, indicate where you look on the reports? C-What does the reduced cost of 0.01 on the variable X36 mean? Also mention what x36 means. D-What would happen to the total cost of shipping if Tilden only wanted 99 donuts? Explain where you are finding this on the report. Objective Cell (Min) Cell $J$3 Variable Cells Cell $B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $H$10 $I$10 Constraints Cell $J$4 $J$5 Name Cost Name x12 x13 x24 x25 x26 x34 x35 x36 Name Wayne Laurel $J$6 $J$7 $J$8 $J$9 South Sioux City Wisner Tilden Norfolk Original Value 0.98 Original Value Final Value Integer Contin Contin 1 1 1 1 1 1 1 1 Final Value 111 Cell Value 500 0 0 100 200 200 200 300 0 0 200 100 200 0 Contin Contin Contin Contin Contin Contin Formula Status Slack $J$4<=$L$4 Binding 0 $J$5-$L$5 Binding 0 $J$6-$L$6 Binding 0 $J$7=$L$7 Binding 0 $J$8-$L$8 Binding 0 $J$9-$L$9 Binding 0 Variable Cells Cell $B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $H$10 $I$10 Constraints Cell $J$4 $J$5 Name x12 x13 x24 X25 x26 x34 x35 x36 Name Wayne Laurel Wisner $J$6 $J$7 $J$8 $J$9 South Sioux City Tilden Norfolk 0.1 0.01 0.01 0.01 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 0 0.02 0.01 0 0 0 0.01 200 300 0 0 200 100 200 0 1E+30 1E+30 0.01 0.02 0.01 1E+30 0.01 0.02 0.01 1E+30 1E+30 1E+30 0.01 Final Shadow Value Price 500 0 -0.1 0 -0.1 0 100 0.23 200 0.19 200 0.25 0.1 0.15 0.1 0.15 0.13 0.09 0.16 Constraint Allowable Allowable Decrease R.H. Side Increase 500 0 0 1E+30 200 0 0 0 300 100 0 100 200 0 200 200 0 200

Answer rating: 100% (QA)

Based on the information provided in the images you sent we can answer the questions as follows A How many donuts are shipped on each route and what is the minimum cost of the shipping List every rout... View the full answer