I am trying to build a model to easily change the crew size of each area and shift. What's the best way of doing this. My first thought was to build a dispatcher for each, but with 5 shifts and 15+areas, I was hoping there might be a better way that I am not thinking about. Any ideas?
Machinist | Welder | Inspector | |
Shift 1 | 10 | 8 | 5 |
Shift 2 | 7 | 3 | 3 |