Hi All,
I have a really big ask for some help!
I want to automate a resource plan against a forecast schedule. Specific details are the forecast is how many computers are to be deployed on a given day and how many people I need to make that happen over a period of time.
The reason for the automation is that the schedule is very fluid and a lot of effort is required to calculate resource requirements on a daily basis.
I've been trying to work out how to do this in Access and I am stumped. I don't even know if it is possible.
I have a Schedule table with the columns: date, day, location, number of deployments, number of logistic resource, number of rollout resource and number of floorwalker resource.
The resource calculation works on a ratio basis:
Logistics resource is 1 to 40 deployments, required the working day before.
Rollout is 1 to 20 deployments on the day of the deployment.
Floorwalker is 1 to 60 deployments on the day of deployment and following 2 days after deployment.
So an example schedule and resource forecast would look like
Deployments No of Logistic No of Rollout No of FWs
Day 1: 0 2 0 0
Day 2: 60 1 3 1
Day 3: 40 0 2 2
Day 4: 0 0 0 2
Day 5: 0 0 0 1
Logic to the above is:
Day 1 - Logistic resources work on a 40 to 1 ratio. As there are 60, there would be two required as you can't have 1.5 people!
Day 2 - 1x Logistic resource is required to prepare 40 on Day 3. 3 rollout engineers are required based on 20 to 1 ratio. 1 FW is required based on 60 to 1 ratio.
Day 3 - 0x logistic resource required because there are no more deployments that week. 2x rollout engineers are required to rollout the 40 devices. FW is where it gets complicated. There are 60 devices from the previous day, so 1 FW is required for that. Another 40 devices means that there are now 100 devices to support, so two FW are required.
Day 4 - Just the two FWs supporting 100.
Day 5 - 60 of the 100 deployments are now outside the two day support window, leaving just 40 to support. So now only one FW is required.
If I can get he resolution to just one of the above types of resources I can probably figure it out for the others.
Is what I am trying to do achievable? And if so, any advice is greatly appreciated!
Thanks,
G
I have a really big ask for some help!
I want to automate a resource plan against a forecast schedule. Specific details are the forecast is how many computers are to be deployed on a given day and how many people I need to make that happen over a period of time.
The reason for the automation is that the schedule is very fluid and a lot of effort is required to calculate resource requirements on a daily basis.
I've been trying to work out how to do this in Access and I am stumped. I don't even know if it is possible.
I have a Schedule table with the columns: date, day, location, number of deployments, number of logistic resource, number of rollout resource and number of floorwalker resource.
The resource calculation works on a ratio basis:
Logistics resource is 1 to 40 deployments, required the working day before.
Rollout is 1 to 20 deployments on the day of the deployment.
Floorwalker is 1 to 60 deployments on the day of deployment and following 2 days after deployment.
So an example schedule and resource forecast would look like
Deployments No of Logistic No of Rollout No of FWs
Day 1: 0 2 0 0
Day 2: 60 1 3 1
Day 3: 40 0 2 2
Day 4: 0 0 0 2
Day 5: 0 0 0 1
Logic to the above is:
Day 1 - Logistic resources work on a 40 to 1 ratio. As there are 60, there would be two required as you can't have 1.5 people!
Day 2 - 1x Logistic resource is required to prepare 40 on Day 3. 3 rollout engineers are required based on 20 to 1 ratio. 1 FW is required based on 60 to 1 ratio.
Day 3 - 0x logistic resource required because there are no more deployments that week. 2x rollout engineers are required to rollout the 40 devices. FW is where it gets complicated. There are 60 devices from the previous day, so 1 FW is required for that. Another 40 devices means that there are now 100 devices to support, so two FW are required.
Day 4 - Just the two FWs supporting 100.
Day 5 - 60 of the 100 deployments are now outside the two day support window, leaving just 40 to support. So now only one FW is required.
If I can get he resolution to just one of the above types of resources I can probably figure it out for the others.
Is what I am trying to do achievable? And if so, any advice is greatly appreciated!
Thanks,
G