Staff Scheduling using logarithms
- or -
Post a project like this4266
£3.0k(approx. $3.7k)
- Posted:
- Proposals: 25
- Remote
- #162661
- Awarded
Description
Experience Level: Expert
We are a Recycling and Waste Management company that empty the contents of wheelie containers and Front End Loader containers for businesses.
Our REL vehicles operate with 2 drivers. Our FEL vehicles operate with 1 driver.
We would like to automatically schedule our drivers shift patterns based on their Knowledge of the routes.
We would like to rotate the drivers every 4 weeks across 3 different routes. (Although we should be able to manually assign more routes to more capable drivers) The current routes are attached in the spreadsheet below.
We operate 4 types of vehicle and each driver can be trained on the different vehicles. The attached spreadsheet shows which vehicle each driver is trained on.
The spreadsheets are a reflection of what we are doing at this moment in time there will need to be a way to add more drivers and add more routes.
A good way to approach the problem of drivers knowledge is to give a driver a score of 1 for every completed week they are scheduled on a route up to a maximum of 20
• FULL - Person knows the full round and is experienced (eg. John Smith has completed REL1 on a Monday at least 4 times) System assigns a score of 4
• P3 - Person has completed the round 3 times. System assigns a score of 3
• P2 - Person has completed the round twice. System assigns a score of 2
• P1 - Person has compelted the round once. System assigns a score of 1
• NONE - Never completed. System assigns a score of 0
Using this logic, the system will look at each route and every possible combination of 2 drivers to find the optimum combined value of 4. If 4 isn't available, it'l llook for a 5 and so on. It will also look at each route scheduled for each day to determine which one has the least available experience available (eg. REL1 on a Monday might have 100 possible combinations of 4 whereas REL2 on a Monday might only have 50) and assign drivers to that round first. This should ensure that rounds that fewer people know are taken care of first.
Should anybody wish to book a holiday, or should somebody become qualified to drive another vehicle, we need to make the amendments using a quick form, re-run the scheduling wizard and re-structure the schedules with the new amendments taken care of
Points to note
Some REL routes can operate with a non-driver where the workload is not as high and some REL routes must always have 2 drivers assigned to the route. Therefore, we need the ability to select whether the route can be operated with 1 driver and a non driver
For training puposes we need the ability to be able to manually seclect a driver to train on certain routes and vehcile types.
Please see attached spreadsheets for current routes and which drivers have Full knowledge of those routes a spreadsheet showing the vehicles the drivers are trained on.
We would like to plan the schedules for 1 month ahead.
Please get in touch if you have more questions
Our REL vehicles operate with 2 drivers. Our FEL vehicles operate with 1 driver.
We would like to automatically schedule our drivers shift patterns based on their Knowledge of the routes.
We would like to rotate the drivers every 4 weeks across 3 different routes. (Although we should be able to manually assign more routes to more capable drivers) The current routes are attached in the spreadsheet below.
We operate 4 types of vehicle and each driver can be trained on the different vehicles. The attached spreadsheet shows which vehicle each driver is trained on.
The spreadsheets are a reflection of what we are doing at this moment in time there will need to be a way to add more drivers and add more routes.
A good way to approach the problem of drivers knowledge is to give a driver a score of 1 for every completed week they are scheduled on a route up to a maximum of 20
• FULL - Person knows the full round and is experienced (eg. John Smith has completed REL1 on a Monday at least 4 times) System assigns a score of 4
• P3 - Person has completed the round 3 times. System assigns a score of 3
• P2 - Person has completed the round twice. System assigns a score of 2
• P1 - Person has compelted the round once. System assigns a score of 1
• NONE - Never completed. System assigns a score of 0
Using this logic, the system will look at each route and every possible combination of 2 drivers to find the optimum combined value of 4. If 4 isn't available, it'l llook for a 5 and so on. It will also look at each route scheduled for each day to determine which one has the least available experience available (eg. REL1 on a Monday might have 100 possible combinations of 4 whereas REL2 on a Monday might only have 50) and assign drivers to that round first. This should ensure that rounds that fewer people know are taken care of first.
Should anybody wish to book a holiday, or should somebody become qualified to drive another vehicle, we need to make the amendments using a quick form, re-run the scheduling wizard and re-structure the schedules with the new amendments taken care of
Points to note
Some REL routes can operate with a non-driver where the workload is not as high and some REL routes must always have 2 drivers assigned to the route. Therefore, we need the ability to select whether the route can be operated with 1 driver and a non driver
For training puposes we need the ability to be able to manually seclect a driver to train on certain routes and vehcile types.
Please see attached spreadsheets for current routes and which drivers have Full knowledge of those routes a spreadsheet showing the vehicles the drivers are trained on.
We would like to plan the schedules for 1 month ahead.
Please get in touch if you have more questions
DAVID P.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
21 Aug 2012
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies