I am having issues using the optimizer for production allocation. The model is for capacity planning.
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)
Factory Line 1
Factory Line 2
Factory Line 3
Factory Line 4
Factory Line 5
Factory Line 6
I have shared the demand values for each SKU in the attached file. The demand is in tons and needs to be divided by the throughput for that SKU-Line combination to give the loading time. E.g., for SKU-101 the demand 1393 will require (1393/4.8) = 291 hrs. on Factory line 1. The loading time available on Factory line 1 is 648 hrs.
These are the optimizer parameters I have used but I am not getting the right allocation. Need some help with where I'm going wrong. Please advise on what my constraints and objectives should be to get the result based on the logic in the problem statement.