Forum Discussion
Ms Project Shift Work
Chris,
You have a very complex structure (i.e. multiple files, resource pool and master file). I assume you understand that structure is prone to corruption if not managed with extreme discipline.
With regard to your basic question, Project does not optimize resource assignments. By default Project linearly and equally spreads work among multiple resources assigned to a given task. The fact that it is "doing the calculation correctly" is most likely the result of a unique assignment that just happens to produce the result you want. You may want to take a closer look at that assignment and see if you can apply it to others.
A quick look at the custom resource calendars you show, the 2nd shift appears to have an error. It shows 12:00 AM to 3:30 AM and then a rather long "lunch" from 3:30 AM to 3:00 PM. Maybe that's intended, I don't know.
John
- Chris_LegereitAug 16, 2021Copper ContributorJohn,
Thanks for your reply.
I definitely understand that my file is very complex. There are many moving parts and the ability to be agile is a huge barrier in regards to shortened or lengthened durations due to the nature of our repairs.
I will take a look into the assignments and see if there is something i was missing.
What we had done in the past was create individual calendars that would reference the working times 1 shift 5 days 8 hours through 2 shifts 12 hours 7 days and everything in between. Then each department would have multiple resources ( all of which would reference the department and one of the listed calendars)
Assembly 1X5X8
Assembly 1X5X10
Assembly 1X5X12 ...... so on and so forth
The system "Worked" but only in a sense of showing an accurate Start/Finish.... No Over Allocations, Cost, or Hour By Hour views.
Maybe what i am trying to do would be better suited for another program, but i would really like to make MS Project work for me.
As far as the calendar goes... The 12AM to 3:30AM would be the End of Shift from the previous day (2nd Shift) Then pick back up starting at 3:30 PM.
Thanks again.- John-projectAug 16, 2021Silver ContributorChris,
You're welcome and thanks for the feedback.
Project will do what you need although with the complexity of your structure, it may take more effort than you want/expect. I would definitely limit the number of custom work calendars. Take a close look at what you need to define the work and limit the options for calendars. In my view you're already in deep yogurt, no need to keep piling on the "toppings", so to speak.
Now that I look at your second shift, I missed the fact that it is correct. The order of the work times threw me off.
Good luck
John- Chris_LegereitAug 17, 2021Copper ContributorPartially Solved.
This is slightly cumbersome but it does work.
I have created an additional Resource named "Planning". This resource is a modified 24hr Calendar that shows a lunch break per shift.
When the initial schedule is created every task will be assigned to "Planning"
Then, each task will hold its own TASK CALENDAR
Then, using the calculated Start/End times i will assign the correct resources. In the times that there is WORK runover from one shift to the next I assign both day and night resource.... So far there has been no (and I know that this verbiage is wrong) Level Loading.
Each task falls into the anticipated time slot. The only other minor modification that i made was using DURATION instead of WORK..... Understanding that DURATION should be assigned on a day/week level, instead i am using hours. this also correctly changes the total work for the task.
I will update if there are any issues going forward, or if I find a better way to tackle this.