Question: More data about the packages volumes, weights, transporting cost per kilometer is given in Table (3) Table (3): Volumes, weights and transporting cost of each
More data about the packages volumes, weights, transporting cost per kilometer is given in Table (3) Table (3): Volumes, weights and transporting cost of each package/kilometer Package type Volume (m) Weight (Kgs) Cost of transportation per kilometer $ 1234 0.2 20 4 2 30 7 0.8 35 9 1.2 40 10 In transporting packages from the main warehouses to the served areas, the agency currently has four types of trucks. Information about these trucks and their capacities are given in Table (4). The cost of transporting the different types of packages using any of the truck types depends on the package type and the transportation distances only as shown in Table (3) Table (4). Truck types and capacities Truck type Volume Weight Number available (Kgs) (m) 1234 100 2000 11 50 1500 7 20 1000 8 45 800 11 Distance in meters between main warehouses and candidate areas are given in Table (5) Table (5). Distances between main warehouses and candidate areas 1 2 3 4 5 6 7 8 9 10 1 3500 6000 4600 6500 8500 5000 4500 8900 10000 7500 2 2000 4000 3800 7500 10000 7200 6500 4800 3900 8700 A- As an independent consultant, you were assigned the task to help the agency in solving the problem. More specifically, the Terms of References (TOR) listed the following as outputs: 1- A table showing the minimum number and location of each of the potential distribution centers (at which of the 10 areas) 2- The number of units of each package to each DC from each warehouses 3- What is the minimum total cost? So, formulate the problem as a mixed integer programming problem and solve using LINDO or any software of your choice to answer the above questions. Clearly define the variables first. B- Based on the results, assume that you were asked to suggest the volumes and the weights of new trucks, how would you deal with such a problem? Explain your methodology. No need for formulation. C- If management is contemplating the use of Multi Criteria Decision Making Methods to study the problem 1- What criteria would you consider? 2- How you would obtain the importance of the criteria? 3- How would the objective function look like? (Use goal programming) More data about the packages volumes, weights, transporting cost per kilometer is given in Table (3) Table (3): Volumes, weights and transporting cost of each package/kilometer Package type Volume (m) Weight (Kgs) Cost of transportation per kilometer $ 1234 0.2 20 4 2 30 7 0.8 35 9 1.2 40 10 In transporting packages from the main warehouses to the served areas, the agency currently has four types of trucks. Information about these trucks and their capacities are given in Table (4). The cost of transporting the different types of packages using any of the truck types depends on the package type and the transportation distances only as shown in Table (3) Table (4). Truck types and capacities Truck type Volume Weight Number available (Kgs) (m) 1234 100 2000 11 50 1500 7 20 1000 8 45 800 11 Distance in meters between main warehouses and candidate areas are given in Table (5) Table (5). Distances between main warehouses and candidate areas 1 2 3 4 5 6 7 8 9 10 1 3500 6000 4600 6500 8500 5000 4500 8900 10000 7500 2 2000 4000 3800 7500 10000 7200 6500 4800 3900 8700 A- As an independent consultant, you were assigned the task to help the agency in solving the problem. More specifically, the Terms of References (TOR) listed the following as outputs: 1- A table showing the minimum number and location of each of the potential distribution centers (at which of the 10 areas) 2- The number of units of each package to each DC from each warehouses 3- What is the minimum total cost? So, formulate the problem as a mixed integer programming problem and solve using LINDO or any software of your choice to answer the above questions. Clearly define the variables first. B- Based on the results, assume that you were asked to suggest the volumes and the weights of new trucks, how would you deal with such a problem? Explain your methodology. No need for formulation. C- If management is contemplating the use of Multi Criteria Decision Making Methods to study the problem 1- What criteria would you consider? 2- How you would obtain the importance of the criteria? 3- How would the objective function look like? (Use goal programming)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
