Question: Using the Simplex (Linear Programing Method) from MS Excel, determine the optimal allocation of inventory and the corresponding total transportation cost for the Stevenson &

Using the Simplex (Linear Programing Method) from MS Excel, determine the optimal allocation of inventory and the corresponding total transportation cost for the Stevenson & Sons distribution problem described un Module #5, considering that, as a result of a fleet enhancement, the maximum shipment size has been increased to 150 bags for shipments originating exclusively from the Chattanooga plant.

Using the Simplex (Linear Programing Method) from

E F G H Data From Solver Calculated B D 1 Stevenson & Sons - Expanded Network 2 3 4 5 Freight Cost 0.95 USD/bag-mile 6 Max Shipment Size 100 bags 7 8 Road Distances 9 Charleston Montgomery Valdosta 10 Macon 266 651 152 11 Gainesville 307 356 106 12 Charlotte 209 405 379 13 Chattanooga 416 233 346 14 15 16 Unit Trasnportation Costs (USD/bag) 17 Charleston Montgomery Valdosta 18 Macon 252.70 618.45 144.40 19 Gainesville 291.65 338.20 100.70 20 Charlotte 198.55 384.75 360.05 21 Chattanooga 395.20 221.35 328.70 22 23 24 Shipping Quantities Jacksonville 270 72 384 463 Knoxville 297 544 231 112 Jackson 464 575 626 384 Pensacola 336 343 568 395 Jacksonville 256.50 68.40 364.80 439.85 Knoxville 282.15 516.80 219.45 106.40 Jackson 440.80 546,25 594.70 364.80 Pensacola 319.20 325.85 539.60 375.25 Charleston Montgomery Valdosta Jacksonville Knoxville Jackson Pensacola Total to Ship 0 0 0 On Hand Inventory 100 200 300 550 Remaining Inventory 100 200 300 550 0 0 0 0 175 175 0 300 125 150 150 0 0 200 200 0 120 120 0 50 50 300 125 25 26 Macon 27 Gainesville 28 Charlotte 29 Chattanooga 30 Total to Receive 31 Orders 32 Uncovered Demand 33 34 Total Transportation Costs 35 36 Macon 37 Gainesville 38 Charlotte 39 Chattanooga 40 Totals 41 42 Valdosta Knoxville Jackson Pensacola Charleston 0 Montgomery 0 Jacksonville 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Transportation Cost 0 E F G H Data From Solver Calculated B D 1 Stevenson & Sons - Expanded Network 2 3 4 5 Freight Cost 0.95 USD/bag-mile 6 Max Shipment Size 100 bags 7 8 Road Distances 9 Charleston Montgomery Valdosta 10 Macon 266 651 152 11 Gainesville 307 356 106 12 Charlotte 209 405 379 13 Chattanooga 416 233 346 14 15 16 Unit Trasnportation Costs (USD/bag) 17 Charleston Montgomery Valdosta 18 Macon 252.70 618.45 144.40 19 Gainesville 291.65 338.20 100.70 20 Charlotte 198.55 384.75 360.05 21 Chattanooga 395.20 221.35 328.70 22 23 24 Shipping Quantities Jacksonville 270 72 384 463 Knoxville 297 544 231 112 Jackson 464 575 626 384 Pensacola 336 343 568 395 Jacksonville 256.50 68.40 364.80 439.85 Knoxville 282.15 516.80 219.45 106.40 Jackson 440.80 546,25 594.70 364.80 Pensacola 319.20 325.85 539.60 375.25 Charleston Montgomery Valdosta Jacksonville Knoxville Jackson Pensacola Total to Ship 0 0 0 On Hand Inventory 100 200 300 550 Remaining Inventory 100 200 300 550 0 0 0 0 175 175 0 300 125 150 150 0 0 200 200 0 120 120 0 50 50 300 125 25 26 Macon 27 Gainesville 28 Charlotte 29 Chattanooga 30 Total to Receive 31 Orders 32 Uncovered Demand 33 34 Total Transportation Costs 35 36 Macon 37 Gainesville 38 Charlotte 39 Chattanooga 40 Totals 41 42 Valdosta Knoxville Jackson Pensacola Charleston 0 Montgomery 0 Jacksonville 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Transportation Cost 0

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!

Please read instructions a) Solve Problem 9.2-9 (a) on page 559. Manually obtain ONLY the initial BF solution. Do not solve using the Transport simplex method. b) Solve Problem 9.3-6 (a) and (c) on...

whats the methodology for this case study? .. cricket LTE 12:13 PM 61% Done 1-s2.0-S2095268612000821-mai... International Journal of Mining Science and Technology Transportation problem: A special...

Supply Chain Management Introduction Outline What is supply chain management? Significance of supply chain management. Push vs. Pull processes utdallas.edu/~metin 1 A Generic Supply Chain Sources:...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

need total summary with result on this paper GANIT J. Bangladesh Math. Soc. (ISSN 1606-3694) 34 (2014) 75-87 SUPPLY CHAIN OPTIMIZATION BY MIXED INTEGER PROGRAM FOR MANUFACTURER AND RETAILER SYSTEM OF...

informs Vol. 34, No. 3, May-June 2004, pp. 191-205 issn 0092-2102 \u0001 eissn 1526-551X \u0001 04 \u0001 3403 \u0001 0191 doi 10.1287/inte.1030.0068 2004 INFORMS Inventory Decisions in Dell's Supply...

The world famous discount store, Fernwood Booksellers, specializes in selling paperback books for $7 each. The variable cost per book is $5. With current annual sales of 200,000 books, the publisher...

Consider rolling a green die and a white die. The roll (1, 5) is different from (5, 1). a. How many different outcomes are possible for this two-die experiment? b. How many different outcomes are...

Which of the following variances refers to when the price puit per unit allers foom the standard price per unit for direct materialp? a . wellume 4 . proy 8 . completilly 4 . verality

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...