Hi All
,
I am having issues using the optimizer for production allocation. The model is for capacity planning.
Problem statement
Need to allocate the SKU demand to compatible factory lines based on the following logic. Each SKU has a production priority and a factory line priority.
- If the production priority for a SKU is 1 total demand for the SKU must be allocated before moving to the SKU with production priority 2.
- For each SKU, each compatible factory line is given a priority value. For e.g., in the case of SKU-106 the maximum demand possible should be allotted to Line priority 1(Factory Line 3) and then the remaining demand can be allotted to Line priority 2(Factory Line 2)
Can anyone have idea ?