Question: Hello! Could you please help me answer these questions. using the attached answer and sensitivity report, thank you so much in advance! 1) 25 points

Hello! Could you please help me answer theseHello! Could you please help me answer theseHello! Could you please help me answer these questions. using the attached answer and sensitivity report, thank you so much in advance!

1) 25 points 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 Ois 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 Variable Cells Cell $B$10 $C$10 SD$10 SE$10 $F$10 SG$ 10 SH$10 SI$10 Name x12 x13 x24 x25 x26 X34 X35 X36 Original Value Final Value Integer 1 200 Contin 1 1 300 Contin 1 1 0 Contin 1 0 Contin 1 200 Contin 1 100 Contin 1 200 Contin 1 0 Contin Cell SB510 SCS10 SD$10 SES 10 SF$10 SG$10 SH$10 SI$10 Name x12 x13 X24 X25 x26 X34 x35 x36 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 Constraints Cell Name $J$4 $J$5 Laurel $J$6 Wisner SJ$ 7 Tilden SJ$8 Norfolk $J$9 South Sioux City Wayne Cell Value 500 0 0 100 200 200 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SJS4 Wayne 500 0 500 1E+30 0 $J$5 Laurel 0 -0.1 0 200 0 SJ$6 Wisner 0 -0.1 0 300 0 $J$7 Tilden 100 0.23 100 0 0 100 SJS8 Norfolk 200 0.19 200 0 200 $J$9 South Sioux City 200 0.25 200 0 200 Formula Status Slack $J$4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!