Question
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
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. Use the answer report and sensitivity report on the next slide to answer the following questions.
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.
Variable Cells Objective Cell (Min) Cell Name $J$3 Cost Original Value Final Value 0.98 111 Name x12 x13 Name X24 X25 Cell $B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $H$10 $1$10 Variable Cells Cell $B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $H$10 $1$10 x12 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 200 0 0.1 0.01 0.01 300 0 0.1 0.01 0.01 0 0.02 0.15 1E+30 0.02 0 0.01 0.1 1E+30 0.01 200 0 0.15 0.01 1E+30 100 0 0.13 0.02 1E+30 200 0 0.09 0.01 1E+30 0 0.01 0.16 1E+30 0.01 X26 X34 Original Value Final Value Integer 1 200 Contin 1 300 Contin 1 0 Contin 1 0 Contin 1 200 Contin 1 100 Contin 1 200 Contin 1 0 Contin x13 x24 x25 X26 X34 X35 X36 x35 x36 Constraints Cell Name $J$4 Wayne $J$5 Laurel $J$6 Wisner $J$7 Tilden $J$8 Norfolk $J$9 South Sioux City Cell Value 500 0 0 100 200 Formula Status Slack $J$4Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started