Sequence of Production Schedule based on Priority and Line capacity

rlgarcia06

We would like to seek assistance on how we can build a requirement where Anaplan needs to recommend the sequence and volume of products to produce in a line with consideration of line capacity and priority.

Example:

Data:

Line 1 Capacity = 100,000

Products produced in Line 1   Priority                    Weekly Volume

Product A                                        1                           10,000

Product B                                        2                           40,000

Product C                                        3                           20,000

Product D                                        4                           50,000

Product E                                        5                           30,000

Expected Output

Line 1                                 Day 1                   Day 2

Product A                         10,000

Product B                          40,000

Product C                          20,000

Product D                         30,000                 20,000

Product E                                                      30,000

 

Is there a way to do this?

 

Thank you!