Question: A B C D E F G H 1 The Wheat Shipping Transshipment Example 3 One Term for Every Branch One Constraint for Each Node

A B C D E F G H 1 The Wheat Shipping Transshipment Example 3 One Term for Every Branch One Constraint for Each Node Left Hand Right Hand Branch Decision Side of Side of Constraint 4 Beginning Branch End Variable Cost Node Constraint |= 5 1. Nebraska 3. Kansas City 16 1 300 6 1. Nebraska 4. Omaha 10 300 7 1. Nebraska 5. Des Moines 12 0 8 2. Colorado 3. Kansas City 15 0 CO VOC AW N 9 2. Colorado 4. Omaha 14 0 1 11 11 10 2. Colorado 5. Des Moines 17 200 11 3. Kansas City 6. Chicago 6 100 12 3. Kansas City 7. St. Louis 8 300 13 3. Kansas City 8. Cincinnati 10 14 4. Omaha 6. Chicago 15 4. Omaha 7. St. Louis 11 16 4. Omaha 8. Cincinnati minimize Z = 16X13 + 10X,4 + 12x15 + 15X23 + 14x24 + 17X25 + 6X38 + 17 5. Des Moines 6. Chicago 8X37 + 10X38 + 7X48 + 11X47 + 11X48 + 4X58 + 5X57 + 12x5s 18 5. Des Moines 7. St. Louis 19 5. Des Moines 8. Ci subject to 20 Node 1: X13 + X14 + X15 = 300 21 Node 2 X23 + X24 + X25 = 300 22 Total Cost Node 3 X13 + X23 - X36 - X37 - X38 = 0 23 Node 4: X14 + X24 - X48 - X47 - X48 = 0 24 Node 5 X15 + X25 - X5e - X57 - X58 = 0 25 Node 6: X36 + X46 + X56 = 200 26 Node 7 =0 29 Solver Parameters X Set Objective: 1 To: O Max O Min O Value Of: By Changing Variable Cells: Subject to the Constraints: Add Change Delete Reset All Load/Save Make Unconstrained Variables Non-Negative Select a Solving Simplex LP V Options Method:MTH 1140 Ch. 6 Transshipment Example (Balanced) 6 6 200 16 Kansas Chicago City 15 10 300 Nebraska 10 4 11 14 7 100 Omaha 11 St. Louis 300 2 12 17 Colorado V 5 5 12 8 300 Des Moines Cincinnati Objective Function: (One term for each arc) Constraints: (One constraint for each node: amount into node = amount out of node) Node 1: Node 2: Node 3: Node 4: Node 5: Node 6: Node 7: Node 8

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 Mathematics Questions!

For this project, you will be using everything we have discussed so far about programming in C++ to implement a game called "Sea Battle". This is a two-player version of the popular strategy game,...

Rename the Excel file in the following way: Lastname_firstname_AGEC 3413_Fall 22_HW 4" while submitting. For question # 2 you need to use a word file. The word file should be named in the following...

2.21 Can someone please explain how she came up with all the numbers on the table? how did she compute all the minutes and how she came up with 23.80 or 27.80 and so on on with the table? I need to...

I have attached all questions in the excel sheet. Please help in answering questions 3 through 6 in the different sheets. Please let me know if you need any additional information from myself. 1)...

1) Project Instructions (this document me) - requirements of the project. 2) Cycles processes and other information (document file) - description of what needs to be done for each process, list of...

Hello, I really need some help here. The instructions are on the bottom page. Please start reading from top to bottom. I have 24 hours to submitted. AutoSave . OFF 1 Flexible budget project_Student...

JAVA // A queue is implemented using a slngly linked list. // the variable: back "points" at the first node in the linked list // new elements ( enqueued) are added at the back // the variable: front...

Please show your work. A B C D E F G H J K L M N o F 1 Q1: 2 An important task in performing business valuations is normalizing the historical financial statements. (a). Using the information...

Hi There, I need someone to help me with the attached finance worksheet. There are 3 problems in this excel file - one problem on each individual tab. I am attaching a couple of additional files as...

A Planning Materiality Base of: Prot before tax A Planning Materiality percentage of: 5% A Planning Materiality amount of: $10,443,950 (5% x 208,879,000) A Clearly Trivial Threshold of: $261,100...

The following point velocities (m/sec) and depths (m) were collected in the river cross section shown in Figure 11.12 where the width of each vertical section is 1.0 m. Determine the discharge...

Upload your full answer (handwriting or tablet only) (Only the answer in the table of question 1.1, no need to show the full calculation) Writing 1 1. The following table shows the cost of delivery...

briefly describe any one internal control that might be applied to address a potential risk involving either of the following. Cash disbursements ( in the expenditure cycle ) Cash receipts ( in the...

ch 7 Excel Cash Budget with Supporting Cash Collections and Disbursements Schedules Prepare a sales budget, including a schedule of expected cash collections. Prepare a direct materials budget,...