Question
Each Manufacturing Plant has 300 units on hand. Knowing this, Distribution Centers Distribution Centers Supply (units) Manufacturing Plants Portland (D1) Maine (D2) Maryland (D3) Portland
Each Manufacturing Plant has 300 units on hand. Knowing this,
| Distribution Centers | Distribution Centers | Supply (units) | ||||
| Manufacturing Plants | Portland (D1) | Maine (D2) | Maryland (D3) | Portland (D1) | 175 | |
| New York (M1) | $10.00 | $16.00 | $12.00 | Maine (D2) | 150 | |
| South Carolina (M2) | $14.00 | $15.00 | $17.00 | Maryland (D3) | 275 | |
| Total | 600 | |||||
| Demand Centers | Customers | Demand | ||||
| Distribution Centers | South Dakota(C1) | Utah(C2) | Vermont (C3) | South Dakota(C1) | 100 | |
| Portland (D1) | $11.00 | $7.00 | $11.00 | Utah(C2) | 200 | |
| Maine (D2) | $8.00 | $6.00 | $10.00 | Vermont (C3) | 300 | |
| Maryland (D3) | $5.00 | $4.00 | $12.00 | Total | 600 | |
b) Formulate this problem as a Linear Programming Model.
(c) Show your constraints and the objective function.
(d) Write down the LP Model.
(e) Setup the LP Model onto a spreadsheet in Microsoft Excel.
(f) Use Microsoft excel to determine the optimal shipping strategy
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Securing SQL Server Protecting Your Database From Attackers
Authors: Denny Cherry
1st Edition
1597496251, 978-1597496254
