That's a very good point, and you're right. The bigger picture, we have three separate lines that are staffed by three different teams, so the formula for each line does not need to sum the headcount, only return the actual headcount required for the material being run if only one material is being run on the shift; or, if more than one material is being run on the same shift, the formula only needs to return the highest headcount of the materials being run on that shift. Does that make things easier?
As to the question whether more than 1 "11111 Example 1" will run on one shift, no, it might run on next shift or the day after, but not be documented as two separate line items on the schedule.
Bookmarks