Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only

Help for linear model execution

  • 1.  Help for linear model execution

    Posted 10/25/20 05:13 AM
    Hello, 

    I'm developing a linear model but it doesn't work correclty. 

    The model seeks to minimize the total cost resulting from the storage process (storage, transport and handling).  

    Brief expalnation about the process: Each product should exist in one picking area (index of the picking area 1 or 2 or 3) and as these areas cannot contain all the incoming quantity of each product, so the rest of the quantity should be allocated in one of the reserve area (index 4 or 5). 

    (Note: For a given product should exist in one picking area and if the condition of allocating in the reserve area is satisfied it could also be assigned in one reserve area). 

    Lij: is a continuous decision variable that mean the number of lane of storage of product i assigned to the storage area j. 

    In order to satisfy the constraint that deals with the restriction mentioned above, I formulated the idea using "If.Then constraint in MIP" where I added the binary variable zij. (In the first model where I considered just the three picking area it works exactly but when I have added the reverse area I didn't get the good result. 

    To explain, for example if we consider the first product (i=1) ( see figure 1) , just were are L12=8 and we find for z12, z14 and z15 equal to 1 ( in figure 2), which is not logic for the last two valued beause there value assigned to L14 and L15 are zero (Same problem for the other product). 

    Figure 1: 


    Figure 2: 


    Other problem is that in each picking area should contain different product but the program assigns only ( area 2 and 3) and unfortunately not  in area 1. Because the allocation of product the reserve area is based on the amount of product assigned in picking area 1 as if they reach a certain limit they, the qunatity that exceed this limit will be assigned in the reserve area. Also, I formulated this refers to the "if.. the constraint in MIP" were I've added the binary variable wij. But I found that the wij take the value 1 even if the condition is not holds ( how can I make the condition for assigning in the reserve area holds ) ( Figure 3) 
    Figure 3: 


    Any help, please. I didn't understand from any instruction comes the problem. 

    I've attached also the model if needed. 

    * The last question:  Is there any instruction which enables to get those results in excel file ?

    Thank you in advance.

    Regards,




     



    ------------------------------
    Khaoula EL MHAMDI
    ------------------------------

    #DecisionOptimization