Line Priority Allocation

Options

Hi,

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.

  1. 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.
  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)

SKU Code

Production Priority

Factory Line 1

Factory Line 2

Factory Line 3

Factory Line 4

Factory Line 5

Factory Line 6

SKU-106

1

 

2

1

 

 

 

SKU-107

3

1

 

 

 

 

 

SKU-108

10

 

 

 

1

 

 

 

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.

@rob_marshall Do u have any ideas how we can achieve using optimizer

 Thanks In Advance

Ashutosh

Answers