The Kelly Company is a producer of canned vegetables. The companys food processing plants are located in
Question:
The Kelly Company is a producer of canned vegetables. The company’s food processing plants are located in Sacramento and Dallas. Distribution centers are located in Denver, Cincinnati, Phoenix, and Atlanta. The supply chain manager wants to minimize the cost of shipping the goods from the processing plants to the distribution centers. Relevant data are given below. Develop and solve a linear optimization model to minimize the cost of shipping while meeting capacity and demand requirements. Evaluate the sensitivity report and provide a full explanation and any recommendations to the supply chain manager.
Per Case Cost of Shipping | ||||
Denver | Phoenix | Cincinnati | Atlanta | |
Sacremento | $1.75 | $1.25 | $3.25 | $5.50 |
Dallas | $1.90 | $1.35 | $2.75 | $2.55 |
Weekly Capacity (cases) | |
Sacremento | 3,000 |
Dallas | 5,000 |
Weekly Demand (cases) | |
Denver | 1,200 |
Phoenix | 1,000 |
Cincinnati | 1,900 |
Atlanta | 2,500 |
Xij as amount shipped from processing plant i to distribution center j
Mathematical Model:
Min 1.75X11 +1.25X12 + 3.25X13 + 5.50X14 + 1.9X21 + 1.35X22 + 2.75X23 + 2.55X24
Constraints
X11 + X12 + X 13 + X14 ≤ 3000
X21 + X22 + X 23 + X24 ≤ 5000
weekly demand
X11 + X21 = 1200
X12 + X22 = 1000
X13 + X23 = 1900
X14 + X24 = 2500
Xij ≥ 0
DistributionThe word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...
Step by Step Answer:
Statistics Data Analysis And Decision Modeling
ISBN: 9780132744287
5th Edition
Authors: James R. Evans