Question: SHOW STEPS IN EXCEL AND SOLVER Problem 2. Wheat is harvested at farms in Nebraska and Colorado before being shipped to the three grain elevators

SHOW STEPS IN EXCEL AND SOLVER

Problem 2. Wheat is harvested at farms in Nebraska and Colorado before being shipped to the three grain elevators in Kansas City, Omaha, and Des Moines. The amount of wheat harvested at each farm is 320 tons. The wheat is then shipped from grain elevators to the mills in Chicago, St. Louis, and Cincinnati. Each mill demands the following number of tons of wheat: Chicago - 200, St. Louis - 100, and Cincinnati - 300. The unit shipping cost (i.e., cost per ton) between points are given in the table below. The maximum capacities of the three grain elevators are: Kansas City - 160, Omaha - 185, Des Moines - 285. Create a model to determine the best shipment plan, which meets all requirements and minimizes the total shipment cost. Unit shipping costs (per ton) Nebraska Colorado Chicago St. Louis Cincinnati Kansas City $19 $18 To Des Moines $15 $19 Omaha $14 $16 Nebraska Colorado Kansas City Omaha Des Moines Chicago St. Louis Cincinnati $7 $9 $7 $11 $13 $7 $13 $12 $15 From Network formulation (flows in tons) Origin Destination Flow balance constraints Net flow out/in Cost Flow Index 1 2 3 4 5 6 7 8 Capacity constraint for Kansas City, Omaha, and Des Moines 3 4 5 Total Cost

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!

1 x fx Problem 2. Wheat is harvested at farms in Nebraska and Colorado before being shipped to the A B C D E F G H I J Problem 2. Wheat is harvested at farms in Nebraska and Colorado before being...

IN EXCEL FORMULAS ONLY A F H K B E G Problem 2. Wheat is harvested at farms in Nebraska and Colorado before being shipped to the three grain elevators in Kansas City, Omaha, and Des Moines. The...

Problem 1 Problem 1. Wheat is harvested at farms in Nebraska and Colorado before being shipped to the three grain elevators in Kansas City, Omaha, and Des Moines. The amount of wheat harvested at...

Problem 1. Wheat is harvested at farms in Nebraska and Colorado before being shipped to the three grain elevators in Kansas City, Omaha, and Des Moines. The amount of wheat harvested at each farm is...

Problem 1 Wheat is harvested at farms in Nebraska and Colorado before being shipped to the three grain elevators in Kansas City, Omaha, and Des Moines. The amount of wheat harvested at each farm is...

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

Wheat is harvested at farms in Nebraska and Colorado before being shipped to the three grain elevators in Kansas City, Omaha, and Des Moines, which are now transshipment points. The amount of wheat...

Wheat is harvested at farms in Nebraska and Colorado before being shipped to three grain elevators in Kansas City, Omaha, and Des Moines. The amount of wheat harvested at each farms is 300 tons. The...

Large banks often borrow heavily in the federal funds market and maintain small investment portfolios relative to their asset size. Are these offsetting risk positions? Why do large banks organize...

Identify the three major flows of communication in an organization.

Real World Case 1 2 - 4 ( Static ) Available - for - sale investments; equity method investments; flnancial statement effects; disclosures [ LO 1 2 - 4 , 1 2 - 6 ] General Motors invests in securibes...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...