Ms Project Shift Work

Question

Hello,I am currently changing how I manage our production schedule within MS Project.....Background - I work at an industrial repair facility, durations are roughly estimated, i use "Work" as an estimate, and our resources work two shifts.Each department has a different amount of employees per shift I.E machine shop has 5 People on Days 1 on Nights.Each schedule has different known requirements for working days and times, and some Tasks may hold their own Task Calendar.I use a resource pool, and a master schedule fileMy standard scheduling options areFixed Units / 7am- 11pm 24hrs per day 168 hrs per week 30 days per month Tasks are NOT effort drivenI have a few project calendars (Base Calendar 5 Days 8 Hours = M-F 8 hours first shift 8 hours second Shift)All Resource calendars are listed as a variation of the 24hr schedule, variation includes Lunches and turn over before and after each shift for a total 22 hrs per day of available work.Issue 1 I add Task 1, with each task having Work 10 hrs, I assign 1 Day shift and 1 Night shift, There seems to be unwanted level loading between the two resourcesFor example Day shift resource 1 starts at 7am on a 10 hour task which should leave 2.75 hrs left on the task, so the night shift resource will have 2.75 hrs to preform on their shift.Now, sometimes it is doing the calculation correctly. But, most of the time it will split the 10 hrs of work evenly between the 2 resources. So instead of finishing at 6:30 PM it would instead finish at 9am (Lunch break included)My work around so far is going into task usage to manually adjust working times. I have hundreds of tasks to schedule so i would really like to avoid the manual adjustments.Any help with a better way to show shift work would be greatly appreciated!

chris_legereit · Answer

&nbsp;&nbsp;&nbsp;

john-project · Answer

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_legereit · Answer

John,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 1X5X8Assembly 1X5X10Assembly 1X5X12 ...... so on and so forthThe 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-project · Answer

Chris,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 luckJohn

chris_legereit · Answer

Partially 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 CALENDARThen, 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.

Forum Discussion

Ms Project Shift Work

Share

Resources