Multi-period pooled blending problem
Hi,
I'm attempting to use LSGRG engine to solve a pooled blending problem over multiple time periods. I'm having issues with Solver coming up with a solution however, and was wondering if there is a recommended structure to model this type of problem, or whether it is beyond the scope of an Excel based solution?
The model structure is similar to a refinery type problem, where stocks are produced, and can be blended to produce other products. The current time period closing stocks end up as the opening stocks for the next time period. The products all have quality parameters which need to be met also.
I currently am trying to model 8 feed stocks, into 4 pooled tanks, which can be blended into 5 products. There are 5 quality parameters being tracked. I'm trying to solve this over 12 time periods.
Should I be optimising each time period separately and passing the solution forward to the next time period? I didn't want to do this because I thought the solution for time periods at the back end could be handicapped by previous solutions.
Regards,
Matt
Please sign in to leave a comment.
Comments
0 comments