Question: Continuing the transportation problem in the case where Supply < demand. We determined in class that when we add the dummy node, the algebraic form

  1. Continuing the transportation problem in the case where Supply < demand.

We determined in class that when we add the dummy node, the algebraic form of the LP changes to the following:

Min 0.8 X11 + X12 + 1.2 X13 + 0.6 X21 + 0.8 X22 + X23 + 0 X31 + 0 X32 + 0X33

s.t.

X11 + X12 + X13 5000 Pakistan supply

X21 + X22 + X23 5000 Vietnam supply

X31 + X32 + X33 2000 Dummy supply

X11 + X21 + X31 = 4000 LA demand

X12 + X22 + X32 = 3000 Houston demand

X13 + X23 + X33 = 5000 NYC demand

Xij 0, i = 1, 2, 3; j = 1,2,3

How to set this problem into excel? Asking for excel spreadsheet picture with Objective function and constraints.

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!

Q:

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:...

Q:

Submitted to Management Science manuscript MS-0001-1922.65 Authors are encouraged to submit new papers to INFORMS journals by means of a style file template, which includes the journal title....

Q:

MGMT 430 Exam II 1. The problem which deals with the distribution of goods from several sources to several destinations is the maximal flow problem transportation problem assignment problem...

Q:

Solving Two-stage Robust Optimization Problems by A Constraint-and-Column Generation Method Bo Zeng Department of Industrial and Management Systems Engineering University of South Florida, Email:...

Q:

I'm working on a team case study project for my business finance class where our team is reporting on Kimberly Clark. I have been assigned the following section and I'm struggling. I have attached...

Q:

OPERATIONS MANAGEMENT ASSIGNMENT 6 1 Human resources, project management and operations management are all equally vital to a business's success. Each of these focuses on different areas of the...

Q:

hi, expert, thank you very much for your reply, i really want to paid more for your quality answer, but there is no money left from my bank card, that's the last amount i have, but this work is...

Q:

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

Q:

A US ceramics company imports blue-and-white porcelain vases to its stores in the US. They commissioned two manufacturers, one in the town of Li Thiu in southern Vietnam and the other in Jingdezhen...

Q:

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...

Q:

1. You work for Athens Inc., and you must estimate the Year 1 operating cash flow for a project with the following data. What is the Year 1 operating cash flow? Sales revenues $15,000 Capital cost...

Q:

Jack Dorsey (CEO of Twitter & Square) is donating $1 Billion of stock in Square to support the COVID-19 relief. However, he is doing it through an LLC, not directly to a non-profit to retain...

Q:

George has a number of investment accounts that his investment advisor manages. This is great as George is 7 0 years old and getting on with age where he relies more and more on his trusted advisor,...

Q:

A company shows the following account balances on December 31: Accounts Receivable $480,987 Dr. Allowance for Uncollectible Accounts 18,369 Cr. Sales 724,889 Cr. Sales Discounts 25,091 Dr. The...