MOFEED is an agricultural company in Missouri that creates livestock feed. Their main selling product category is the compound feed, manufactured in the Arrow Rock, MO plant which has a capacity of 10,000 tons of feed per quarter, The company ships products from the plant to their customers located in Kentucky, Montana, Nebraska, Oklahoma, South Dakota, and Texas using two distribution centers located in Texas and Nebraska. Determine the optimal transportation plan that minimizes transportation costs for MOFEED using the information on customer demand and transportation costs provided in the graph below. Demand (tons) 4 2,000 2 50 Oklahoma Oklahoma Distribution Center 340 5. 5,000 Texas 500 1,080 1 Arrow Rock 700 500 600 Kentucky 650 1,500 7 1,000 Nebraska 200 670 South Dakota Distribution Center 8 500 Montana 3.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
2
1,000
Nebraska
200
670
South Dakota
Distribution
Center
8
500
Montana
70
9
South Dakota
1,000
Excel Hint - The decision variables for this problem are:
Decision Variables
X12
X13
X15
X16
X17
X18
X24
X25
X37
X38
X39
How many tons of feed is transported using the South Dakota Distribution Center?
3.
Transcribed Image Text:1,000 Nebraska 200 670 South Dakota Distribution Center 8 500 Montana 70 9 South Dakota 1,000 Excel Hint - The decision variables for this problem are: Decision Variables X12 X13 X15 X16 X17 X18 X24 X25 X37 X38 X39 How many tons of feed is transported using the South Dakota Distribution Center? 3.
MOFEED is an agricultural company in Missouri that creates livestock feed. Their main selling product category is
the compound feed, manufactured in the Arrow Rock, MO plant which has a capacity of 10,000 tons of feed per
quarter, The company ships products from the plant to their customers located in Kentucky, Montana, Nebraska,
Oklahoma, South Dakota, and Texas using two distribution centers located in Texas and Nebraska. Determine the
optimal transportation plan that minimizes transportation costs for MOFEED using the information on customer
demand and transportation costs provided in the graph below.
Demand
(tons)
4
2,000
Oklahoma
50
Oklahoma
Distribution
Center
340
5.
5,000
Техas
500
1,080
1
Arrow Rock
700
600
Kentucky
500
650
1,500
7
1,000
Nebraska
3
200
670
South Dakota
Distribution
Center
8.
500
Montana
Transcribed Image Text:MOFEED is an agricultural company in Missouri that creates livestock feed. Their main selling product category is the compound feed, manufactured in the Arrow Rock, MO plant which has a capacity of 10,000 tons of feed per quarter, The company ships products from the plant to their customers located in Kentucky, Montana, Nebraska, Oklahoma, South Dakota, and Texas using two distribution centers located in Texas and Nebraska. Determine the optimal transportation plan that minimizes transportation costs for MOFEED using the information on customer demand and transportation costs provided in the graph below. Demand (tons) 4 2,000 Oklahoma 50 Oklahoma Distribution Center 340 5. 5,000 Техas 500 1,080 1 Arrow Rock 700 600 Kentucky 500 650 1,500 7 1,000 Nebraska 3 200 670 South Dakota Distribution Center 8. 500 Montana
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.