ISyE 3104: Introduction to Supply Chain Modeling: Manufacturing and Warehousing Instructor : Spyros Reveliotis Spring 2006 Solutions for Homework #3 Problem set



Download 194.42 Kb.
Page3/3
Date20.05.2018
Size194.42 Kb.
#49906
1   2   3

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:


  1. 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.

  2. The decision variables (changing cells) are xij and yi.

  3. There are four sets of constraints.

    1. Non-negativity of technology dedicated to each product family.(Constraint 7)

    2. For each technology, the capacity dedicated to each product family is less than or equal to the units leased. (Constraints 4, 5)

    3. Integrality of leasing quantity. (Constraint 6)

    4. 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:













Download 194.42 Kb.

Share with your friends:
1   2   3




The database is protected by copyright ©ininet.org 2024
send message

    Main page