25000 x12 + 45000 x22 ≥ 100000 …….. (2)
30000 x13 + 45000 x23 ≥ 100000 …….. (3)
x11 + x12 + x13 ≤ y1 …….. (4)
x21 + x22 + x23 ≤ y2 …….. (5)
y1, y2 integers …….. (6)
xij ≥ 0, for i = 1, 2, j = 1, 2, 3 …….. (7)
Example of using the Excel Solver to find the optimal solution:
The objective is set to minimize the total cost, which is the sum of products of the leasing cost and the units to be leased for each technology.
The decision variables (changing cells) are xij and yi.
There are four sets of constraints.
Non-negativity of technology dedicated to each product family.(Constraint 7)
For each technology, the capacity dedicated to each product family is less than or equal to the units leased. (Constraints 4, 5)
Integrality of leasing quantity. (Constraint 6)
For each product, the dedicated capacity is adequate to meet its demand. (Constraints 1 to 3)
The optimal solution is found to be leasing 2 units of technology 1, and 5 units of technology 2. The screenshots and answer report are as follow:
Share with your friends: |