Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribedA-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$4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

My Adventures As An Auditor

Authors: Michael Quoter

1st Edition

1079508821, 978-1079508826

More Books

Students also viewed these Accounting questions