I want to solve the following LP transportation problem graphically in Excel Des Moines has a monthly limit of 100, Evansville's limit is 300, and Fort Lauderdale's limit is 300 Each warehouse is limited in its storage with Albuquerque at 300 but Boston and Cleveland at 200 The costs of shipping are shown in the table How much should each factory send to each warehouse Warehouse Factory Albuquerque Boston Cleveland Des Moines 5 4 3 Evansville 8 4 3 Fort Lauderdale 9 7 5 I don't need a solution to this problem The question I have is Does anyone know a convenient way how to draw a network diagram in Excel The onliest way I have found is to use shapes however, this can be time consuming, especially with labeling all arcs Thank you in advance

The Answer is in the image, click to view ...

Question: I want to solve the following LP transportation problem graphically in Excel: Des Moines has a monthly limit of 100, Evansville's limit is 300, and

I want to solve the following LP transportation problem graphically in Excel: Des Moines has a monthly limit of 100, Evansville's limit is 300, and Fort Lauderdale's limit is 300. Each warehouse is limited in its storage with Albuquerque at 300 but Boston and Cleveland at 200. The costs of shipping are shown in the table. How much should each factory send to each warehouse?

	Warehouse
Factory	Albuquerque	Boston	Cleveland
Des Moines	5	4	3
Evansville	8	4	3
Fort Lauderdale	9	7	5

I don't need a solution to this problem. The question I have is: Does anyone know a convenient way how to draw a network diagram in Excel? The onliest way I have found is to use shapes; however, this can be time-consuming, especially with labeling all arcs. Thank you in advance!

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!

A flat piece of cast iron 100. mm wide and 150. mm long is to be milled with a feed rate of 200. mm/ minute with a depth of cut of 1.0 mm. The milling cutter rotates at 100. RPM, and is wider than...

I want to solve the following LP transportation problem graphically in Excel: Des Moines has a monthly limit of 1 0 0 , Evansville's limit is 3 0 0 , and Fort Lauderdale's limit is 3 0 0 . Each...

(need answers for this question) the transportation problem A. PDP-Builder has built a new elementary school so that the town now has a total of four schools - Addeen, Bashiron, Cobbith and Daimman....

SECTION A: STRUCTURED QUESTIONS (100 MARKS) ANSWER ALL QUESTIONS Royal Canin: More than 50 years of health nutrition Since 1968 Royal Canin has worked to make nutrition cats and dogs first medicine....

Royal Canin trying to make the most effective use of an organizations resources. Therefore, Royal Canin plan to produces two types of cat biscuits which are chicken-flavored and fish-flavored...

Planning Demand and Supply in a Supply Chain Capacity Planning and Assignment 1 utdallas.edu/~metin Outline Capacity Planning Product-to-plant Assignment utdallas.edu/~metin 2 Deterministic Capacity...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

My tutor that I Have been using for the past 5 weeks bailed on me with an assignment due tomorrow by 9PM Central USA time. There is 3 weeks left in this course. I am looking for someone that is...

---The Driver we using is in the example--- Part 2 The questions in this part of the assignment will be graded. Programming Question #1: Hangman Games (multiple and simultaneous) Use either the...

I need help! This is the last assignment and it's the end of the semester.... Your help is greatly appreciated. I have provided my program and it needs to be converted to a class called "Hangman"...

------For the Driver we use the one on the example----- Part 2 The questions in this part of the assignment will be graded. Programming Question #1: Hangman Games (multiple and simultaneous) Use...

K's tax liability was $2,000 in 2017, $15,000 in 2018, $30,000 in2019 and is expected to be $40,000 in 2021. What is the minimum total amount of the tax installments required for 2020?

Chromium has been investigated as a coating for steel cans. The thickness of the chromium film is determined by dissolving a sample of a can in acid and oxidizing the resulting Cr 3+ to Cr 2 O 7 2-...

How is the WACC calculated?

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...