Stateline Shipping & Transport Company
Question #1 – Transportation Model Plant Waste Disposal | A. White Water | B. Los Canos | C. Duras | Supply | 1. Kingsport | 12 | 15 | 17 | 35 | 2. Danville | 14 | 9 | 10 | 26 | 3. Macon | 13 | 20 | 11 | 42 | 4. Selma | 17 | 16 | 19 | 53 | 5. Columbus | 7 | 14 | 12 | 29 | 6. Allentown | 22 | 16 | 18 | 38 | Demand | 65 | 80 | 105 | |
Xij = Shipping from plant to disposal site. i = PLANT = 1,2,3,4,5,6 j = disposal sites = A, B, C
The objective function of the manager is to minimize the total transportation cost for all shipments. Therefore, the objective function is the sum of the individual shipping costs …show more content…
There are 9 constraints- one for each plant supply and one for each waste disposal site’s demand.
Subject …show more content…
For doing the analysis using Excel solver we assume the shipping cost per barrel for the decision variables , , , ,,,,, are assumed to be 100 in order to make sure that the variable representing that routes do not have a value in the optimal solution. Plant | Plant | | Kingsport | Danville | Macon | Selma | Columbus | Allentown | Kingsport | 0.0 | 0.0 | 19.0 | 0.0 | 0.0 | 0.0 | Danville | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Macon | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Selma | 0.0 | 0.0 | 17.0 | 0.0 | 36.0 | 0.0 | Columbus | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Allentown | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Waste Received | 0.0 | 0.0 | 36.0 | 0.0 | 36.0 | 0.0 | | | | | | | | | | | | | | | | Plant | Waste Disposal Sites | Supply | Accum Supply | | | Whitewater | Los Canos | Duras | | | | Kingsport | 0.0 | 16.0 | 0.0 | 35.0 | 16.0