Scheduling - Create planning based on employee productivity

[Kzantip974]

Hi community,

I hope you are doing well. I am working on a cool project to build cost-efficiency through better scheduling based on our staff productivity.

CONTEXT
- We are a pizza delivery company, employing drivers to deliver pizzas.
- We proceed to schedule driver planning on a weekly basis (Column A).
- We create shifts blocks (blue blocks) based on rider productivity (Row 30), Rider productivity means how many orders a driver can deliver within an hour
- On a weekly basis, we assume deliveries forecast (Row 3) for each Business hour (Row 2)

CURRENT PROCESS
- We manually create shift blocks to ensure Total hours planned/business hours (Row 29) reach our productivity target (Row 30)

OPPORTUNITY
- How can automatically generate shift blocks, which fulfill our productivity requirements?

PARAMETERS
- min shift duration = 5, max shift duration = 8
- Productivity target = 2, min= 1.6, max=2.4

Would you have a solution to automate the shift creation based on the above parameters? It would be great to hear your feedback. That project would have a great impact on the company's performance.

Thanks again
best
File