Question: How do I answer this question in Excel using Solver? Question 3: A2Z owns four production plants at which a special customized high tech device
How do I answer this question in Excel using Solver?
Question 3: A2Z owns four production plants at which a special customized high tech device is produced. A2Z can sell up to 20,000 such devices per year at a unit price of $2,200. For each plant the production capacity, the production cost per device and the fixed cost of operating a plant for a year are given in the following table. a) Formulate a mixed-integer program to help A2Z maximize its annual profit from computer production. b) A2Z management decided that if plant 1 is operated, then plant 2 must produce at least 5,000 computers. In addition, plant 4 should not be operated unless plant 3 is operated. Modify your formulation to incorporate this condition. c) Management realizes that there is another constraint: If plant 2 is selected, then at most 7,000 can be produced on plants 1 and 3 combined
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
