Hi, I am using optizer to decide for each station(or Site) who is the best supplier & terminal for supplying product based on minimum sourcing cost. Input variables: Site Demand Volume, Each supplier and terminal sourcing cost. Output variables: Site Demand volume(will be decided by optimizer) Objective: Optimized cost ( Formula: Optimizer output demand volume * Each supplier and terminal sourcing cost input variable) Constraint: Output variable Site demand volume = Input variable Site demand volume. Scenario 1: Input variable line item: Each supplier and terminal sourcing cost is getting value from another module based on following formula: Station purchase unit cost per terminal.'Total unit cost, $/gallon'[LOOKUP: 'Site/Terminal Cost Lookup'] and this formula returns some zero values as well if a supplier does not provide any sourcing cost at specific terminals. In this scenario if i run the optimizer it is completing in 12 minutes and deciding who is the best supplier & terminal by assigning demand volume for each site. Unfortunately it is always deciding one terminal and supplier which is having zero cost.(In reality supplier has not provided any cost here). and it is not correct to decide to like that. Scenario 2: To skip or ignore these zero cost suppliers & Terminals i have modified the formula on input variable line item: Each supplier and terminal sourcing cost as below: It will assign 99999 value if there is not cost or zero cost from a supplier. It it is very huge value when compared to actual sourcing cost(Usually < 2 dollars) IF Station purchase unit cost per terminal.'Total unit cost, $/gallon'[LOOKUP: 'Site/Terminal Cost Lookup'] =0 THEN 99999 ELSE Station purchase unit cost per terminal.'Total unit cost, $/gallon'[LOOKUP: 'Site/Terminal Cost Lookup'] In This scenario when i am running optimizer i am getting timed out error. I have tried with 1 hour time set on optimizer but still same error it is giving. Please find attached time out error and also optimizer action screen shot. I am stuck on how to deal with it now . I hope someone can help me on it. Please let me know if you need more details on it. Thanks!. @Suman.
... View more
Hi Suman, Ratio is independent of time. You can use it in a module which doesn't have a time dimension as well. @jasonblinn Has given an example for reference. Alternative method if you want to go for timesum specifically. Create one lineitem say Check ,boolean formatted; formula : If X>0 then true else false.[X is the line item with values] Now, for Timesum lineitem :- If check then Timesum(,,,,) else 0 Hope this helps ~Abhi
... View more