Multi-commodity facility location problem

Assignment Help Management Theories
Reference no: EM131071175

INDR262 - Term Project #2

Consider the two-echelon multi-commodity facility location problem. We are given a set V1 of suppliers, a set V2 of potential warehouses, a set V3 of demand points, and a set K of products. The capacity of supplier i∈V1 for product k∈K is qik units and the demand of customer r∈V2 for product k∈K is drk units. The unit cost of shipping from supplier i ∈ V1 to warehouse j∈V2 for product k∈K is Cijk and the unit cost of transportation from warehouse j∈V2 to demand point r∈V3 for product k∈ K is C'jrk. The minimum and maximum activity levels (uj) at potential warehouse j∈V2 is z-j and z+j , respectively. The cost of operating warehouse j∈ V2 is given by fj + gjuj. Suppose that the demand of each demand point for each product is divisible, i.e., a demand point can receive its demand for each product from many
warehouses.

Consider the following instance of this kind of problem.

We have only one type of product. There are five potential suppliers labeled 1,2,...,5 , five warehouses labeled 1,2,...,5 and six demand points labeled 1,2,...,6 .

The capacities of suppliers are given by 40, 20, 45, 30 and 28 respectively. The fixed costs of operating the warehouses are given by 200, 170, 100, 95, and 60, respectively. The demands of the demand points are given by 22, 26, 24, 23, 22, and 15, respectively.
The unit transportation costs from supplier i to warehouse j and from warehouse j to demand point r are given by the following functions:
Cij 1 2 3 4 5
1  2 2 2 3 3
2  2 2 2 3 3
3  2 2 2 3 3
4  4 4 4 2 2
5  4 4 4 2 2

C'jr 1 2 3 4 5 6
      1 2 2 2 3 3 3
      2 2 2 2 3 3 3
      3 2 2 2 3 3 3
      4 4 4 4 2 2 2
      5 4 4 4 2 2 2
Minimum and maximum activity levels for warehouses are as following:
warehouse Z-j Z+j

1 10 30
2 8 32
3 7 31
4 9 29
5 11 28

Management wants to operate just three warehouses. On the other hand the cost is important for management.

Formulate the problem as a linear programing problem.
-What are the decision variables?
- What are the constraints? Explain clearly.

a. Solve the problem using GAMS
-You should import parameters from an excel file. Also, you should export the results to an excel file for all the remaining parts of the question.
b. Suppose that you do not necessarily have to satisfy the demand of each customer. However for each customer r∈V3 there is a penalty cost Pr of each unit of unmet demand but management need to ensure that at least 80% of demand of each customer should be satisfied due to service level requirement.

Pr is stated in following table:
Demand point r Pr
1 190
2 190
3 90
4 100
5 95
6 180
Solve the problem using GAMS. You should import parameters from an excel file. Also, you should export the results to an excel file for all the remaining parts of the question.

c. Suppose that management has decided to operate warehouse 2 and 5 definitely because they have very good locations. Solve the problem using GAMS. You should import parameters from an excel file. Also, you should export the results to an excel file for all the remaining parts of the question.

*You are supposed to use DISPLAY function in your GAMS code.
NOTE: In this project you have to send your gms file and a word document which includes your results and model. Your results should include the value of all of the decision variables and objective functin. Also in the word file, you have to CLEARLY indicate your decision variables. DO NOT forget to add comments to your GAMS code. Please use Winzip or Winrar and name your file as (INDR262_Project_YourGroupNumber).

Reference no: EM131071175

Questions Cloud

Defend your choice of product or service : Evaluate the potential growth rate. Look for information on similar products or services to come up with a growth rate over three years; this may be adjusted in later revisions.
How scientific methodology can provide related information : Talk about a political issue and describe how scientific methodology can provide related information, but the core issue to be resolved cannot be answered with scientific methodology alone.
Analyze internal and external business processes : ISFM-300 Case Study, Stage 1: Business Environment Analysis - analyze internal and external business processes to identify information systems requirements
Prepare a briefing note for the organisational change : Develop a "TO BE" and "AS IS" process using BPMN or UML then compare theAs-Is and To-be diagrams to assess the impact of change and prepare a briefing note for the Organisational change and Training Team regarding the anticipated business impact o..
Multi-commodity facility location problem : Consider the two-echelon multi-commodity facility location problem. We are given a set V1 of suppliers, a set V2 of potential warehouses, a set V3 of demand points, and a set K of products.
Overpaying for the product : If you take out money to buy a home, a car etc. you will always be overpaying for the product that you are receiving. Generally, an ordinary person is not getting a 1% loan from the federal reserve, and they sure are not paying it back with the sp..
How these implications affect people and/or society : explain the ethical and social implications and how they relate to converging technologies. Justify your choices by analysing how these implications affect people and/or society.
Using another form of intellectual property protection : Describe two (2) reasons why The Coca-Cola Company would choose to protect its soft drink formula as a trade secret, as opposed to using another form of intellectual property protection (for example, a patent).
Construct a bitmap index on the attribute salary : Consider a query that requests all instructors in the Finance department with salary of 80000 or more. Outline the steps in answering the query, and show the final and intermediate bitmaps constructed to answer the query

Reviews

Write a Review

Management Theories Questions & Answers

  Learning in action

Learning contract proposal that will form the basis of your learning contract report.

  Change is the only constant

"Change is the only constant " Evaluate the different types of change that have occurred in Sony.

  How do advertisers try to use group influence

How do advertisers try to use group influence?  Will you find any specific examples and explain the relevant theory of group behavior and influence?

  Case study:saving sony

You have been appointed by Sony as a consultant on change management. Advise Sony on how they could implement the change by using the various theories of change you have learnt.

  How the stock market works

The purpose of this project is to help you to gain an understanding of how the stock market works and of the relationship between theory and practice.

  Find the optimal production quantities

Find not only the optimal production quantities, but also the optimal total cost.

  Describe the management process

Describe the management process and identify the skills required to manage business organizations.

  Case study : bert''s bonsai and aquatic sport museum

Case Study : Bert's Bonsai and Aquatic Sport Museum Prepare a knowledge management system.

  Knowledge management techniques

Demonstrate understanding of the many-sided nature of knowledge management

  Theory of transtheoretical model

Demonstrate understanding of the many-sided nature of knowledge management

  Write a paper on historical trends of management

Write a paper on Historical Trends of Management.

  Theory of reasoned action

Theory of Planned Behavior and Integrated Behaviors Model

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd