I have a feeling this might be a linear programming problem. What I'm trying to do is work out the best combination of the yellow cells which are head counts. The total shifts should be as close as possible to the "required shifts". It doesn't matter if we're a bit over or a bit under, just as close as possible.
The following info might be helpful:
0.8PT = 16 shifts
0.6PT = 12 shifts
0.4PT = 10 shifts
Casual = 8 shifts
The only constraint I can think of is that headcounts are non-negative.
Can this be done?
I'm trying to attach the workbook but cant see how!
The following info might be helpful:
0.8PT = 16 shifts
0.6PT = 12 shifts
0.4PT = 10 shifts
Casual = 8 shifts
The only constraint I can think of is that headcounts are non-negative.
Can this be done?
I'm trying to attach the workbook but cant see how!
Last edited:
