My model currently reads tasks from a table and I am trying to model material consumption. For each task there are groups of materials: A, B, C, and priority values: 1, 2, 3. To complete a task, only one material type from each group A, B, and C must be consumed, and the order they are consumed in should be based of the priority. For example, if task one had entries like the table below, if all materials were available, materials 1,4,6 would be consumed. If material 1 was no longer available materials 2,4,6 would be used, and if material 6 was not available the task could not be done. The material requirement section in the processing task editor does not seem to support groupings and priority and was wondering if anyone had an idea on how to accomplish this.
Task
MaterialName
Group
Priority
Quantity
Task1
Material1
A
1
1
Task1
Material2
A
2
2
Task1
Material3
A
3
1
Task1
Material4
B
1
1
Task1
Material5
B
2
3
Task1
Material6
C
1
1