Question: ANSWER IN EXCEL The Air Force has established a distribution network for the supply of a materials critical to its functioning. These materials have to
ANSWER IN EXCEL
The Air Force has established a distribution network for the supply of a materials critical to its functioning. These materials have to ship from Wright-Patterson, OH, Langley, VA and Andrews AF base, MD to Malstrom, MT, Hill AF base, UT and Cheyenne Mountain, CO. Malstrom has a demand of 2800 lbs, Hill has a demand of 2700 lbs, and Cheyenne Mountain has a demand of 3500 lbs. The three supply locations can supply 3200 lbs of materials each. The transportation costs are given below. Formulate and solve a linear program to determine the shipping arrangements that will minimize the total shipping cost.
| Malstrom | Hill | Cheyenne Mountain | |
| Wright Patterson | $8 | $7 | $11 |
| Langley | $7 | $9 | $12 |
| Andrews | $10 | $9 | $6 |
- What is the objective function?
- What are the constraints?
- How many pounds of materials are transported from Wright-Patterson to all destination locations?
- How many pounds of materials are transported from Andrews to all destination locations?
- How many pounds of materials are transported from Langley to all destination locations?
- What is the total cost of this distribution network?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help