Purchase Solution

ILP Transportation Problem

Not what you're looking for?

Ask Custom Question

The table below indicates required supplies delivered to four destinations.
Destinations
Port D1 D2 D3 D4
A 70 80 90 56
B 100 75 100 85
C 42 60 89 62
Demand 500 600 450 700

The ports are supplied by one of two stock suppliers. Supplier 1 carries 1200 tonnes of supplies while Supplier 2 carries 1120 tons of supplies. These suppliers can only offer a single port and each port can only accommodate one supplier. Assume the costs for a supplier to supply are not part of the objective function. Formulate the ILP for this problem capturing the supplier choice of port and the transportation from the port to the destinations.

Purchase this Solution
Solution Summary

The solution assists with answering the ILP transportation problem.

Solution Preview

Please view the attached files (one Word document and one Excel file) as these will help you answer your question. I have attached an Excel file which solves the problem using Excel Solver. Go to Data - > Solver to see the objective function, decision variables and constraints. Optimal solution is available in the file.

Port-Supplier Selection - ILP
Problem definition: A commodity needs to be supplied to four destinations. ...

Purchase this Solution
Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

View More Free Quizzes
Related BrainMass Solutions

  • Linear and integer programming problems

    This posting contains solution to following ILP and LPP problems.

  • ILP Formulation

    Thank you The word file contains ILP formulation and Excel file contains model implementation and optimal solution of the problem.

  • ILP and LPP Problems

    Solve this transportation problem by using the computer (note: if using QM for Windows, be sure to select the transportation module). Hi Please find attached the solutions to your problems. Hope you find it useful.

  • Integer programming problem: Kentwood electronics

    Formulate an ILP model for this problem. (Hint: Let your decision variables represent the number of batches of each item to produce.) b. Create a spreadsheet model for this problem and solve it. c. What is the optimal solution?

  • Integer Linear Programming (ILP) : Formulation and Optimal

    Formulate an ILP problem to determine which sites should be selected so as to provide convenient service to all locations in the least costly manner. b. Implement your model in a spreadsheet and solve it. c. What is the optimal solution?

  • Linear programming spreadsheet

    246824 ILP Spreadsheet Model This is problem 28 in Chapter 6 of "Spreadsheet Modeling and Decision Analysis" 5E by Cliff Ragsdale. KPS Communications is planning to bring wireless internet access to the town of Ames, Iowa.

  • 8906-Interger Linear Programming Spreadsheet Modeling & Decision Analysis 4ed

    Note: I have the ILP model, I just don't know how to implement it in a spreadsheet. The ILP model is attached. See the attached file. For model see the sover command...............

  • Integer Problem

    Formulate an ILP for determining the product mix that maximizes total profit subject to the resource constraints. 5. A manufacturing company produces three products each of which must be processed on two machines.

  • optimal solution

    a) Formulate the model for this problem. b) What is the optimal solution? The problem is also attached in WORD format. please see attached a) Formulate the model for this problem. b) What is the optimal solution?

View More Related Solutions