Ms Project Shift Work

%3CLINGO-SUB%20id%3D%22lingo-sub-2652874%22%20slang%3D%22en-US%22%3EMs%20Project%20Shift%20Work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2652874%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20currently%20changing%20how%20I%20manage%20our%20production%20schedule%20within%20MS%20Project.....%3C%2FP%3E%3CP%3EBackground%20-%20I%20work%20at%20an%20industrial%20repair%20facility%2C%20durations%20are%20roughly%20estimated%2C%20i%20use%20%22Work%22%20as%20an%20estimate%2C%20and%20our%20resources%20work%20two%20shifts.%3CBR%20%2F%3EEach%20department%20has%20a%20different%20amount%20of%20employees%20per%20shift%20I.E%20machine%20shop%20has%205%20People%20on%20Days%201%20on%20Nights.%3CBR%20%2F%3EEach%20schedule%20has%20different%20known%20requirements%20for%20working%20days%20and%20times%2C%20and%20some%20Tasks%20may%20hold%20their%20own%20Task%20Calendar.%3CBR%20%2F%3EI%20use%20a%20resource%20pool%2C%20and%20a%20master%20schedule%20file%3CBR%20%2F%3EMy%20standard%20scheduling%20options%20are%3CBR%20%2F%3EFixed%20Units%20%2F%207am-%2011pm%2024hrs%20per%20day%20168%20hrs%20per%20week%2030%20days%20per%20month%20Tasks%20are%20NOT%20effort%20driven%3CBR%20%2F%3EI%20have%20a%20few%20project%20calendars%20(Base%20Calendar%205%20Days%208%20Hours%20%3D%20M-F%208%20hours%20first%20shift%208%20hours%20second%20Shift)%3CBR%20%2F%3EAll%20Resource%20calendars%20are%20listed%20as%20a%20variation%20of%20the%2024hr%20schedule%2C%20variation%20includes%20Lunches%20and%20turn%20over%20before%20and%20after%20each%20shift%20for%20a%20total%2022%20hrs%20per%20day%20of%20available%20work.%3C%2FP%3E%3CP%3EIssue%201%20I%20add%20Task%201%2C%20with%20each%20task%20having%20Work%2010%20hrs%2C%20I%20assign%201%20Day%20shift%20and%201%20Night%20shift%2C%20There%20seems%20to%20be%20unwanted%20level%20loading%20between%20the%20two%20resources%3CBR%20%2F%3EFor%20example%20Day%20shift%20resource%201%20starts%20at%207am%20on%20a%2010%20hour%20task%20which%20should%20leave%202.75%20hrs%20left%20on%20the%20task%2C%20so%20the%20night%20shift%20resource%20will%20have%202.75%20hrs%20to%20preform%20on%20their%20shift.%3CBR%20%2F%3ENow%2C%20sometimes%20it%20is%20doing%20the%20calculation%20correctly.%20But%2C%20most%20of%20the%20time%20it%20will%20split%20the%2010%20hrs%20of%20work%20evenly%20between%20the%202%20resources.%20So%20instead%20of%20finishing%20at%206%3A30%20PM%20it%20would%20instead%20finish%20at%209am%20(Lunch%20break%20included)%3C%2FP%3E%3CP%3EMy%20work%20around%20so%20far%20is%20going%20into%20task%20usage%20to%20manually%20adjust%20working%20times.%20I%20have%20hundreds%20of%20tasks%20to%20schedule%20so%20i%20would%20really%20like%20to%20avoid%20the%20manual%20adjustments.%3C%2FP%3E%3CP%3EAny%20help%20with%20a%20better%20way%20to%20show%20shift%20work%20would%20be%20greatly%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2652874%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%20Desktop%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2652919%22%20slang%3D%22en-US%22%3ERe%3A%20Ms%20Project%20Shift%20Work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2652919%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Chris_Legereit_0-1629129053966.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303555i0712A741FA345337%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Chris_Legereit_0-1629129053966.png%22%20alt%3D%22Chris_Legereit_0-1629129053966.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Chris_Legereit_2-1629129089558.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303557i60A9240A7C5B6AEB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Chris_Legereit_2-1629129089558.png%22%20alt%3D%22Chris_Legereit_2-1629129089558.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2653272%22%20slang%3D%22en-US%22%3ERe%3A%20Ms%20Project%20Shift%20Work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2653272%22%20slang%3D%22en-US%22%3EChris%2C%3CBR%20%2F%3EYou%20have%20a%20very%20complex%20structure%20(i.e.%20multiple%20files%2C%20resource%20pool%20and%20master%20file).%20I%20assume%20you%20understand%20that%20structure%20is%20prone%20to%20corruption%20if%20not%20managed%20with%20extreme%20discipline.%3CBR%20%2F%3E%3CBR%20%2F%3EWith%20regard%20to%20your%20basic%20question%2C%20Project%20does%20not%20optimize%20resource%20assignments.%20By%20default%20Project%20linearly%20spreads%20work%20among%20multiple%20resources%20assigned%20to%20a%20given%20task.%20The%20fact%20that%20it%20is%20%22doing%20the%20calculation%20correctly%22%20is%20most%20likely%20the%20result%20of%20a%20unique%20assignment%20that%20just%20happens%20to%20produce%20the%20result%20you%20want.%20You%20may%20want%20to%20take%20a%20closer%20look%20at%20that%20assignment%20and%20see%20if%20you%20can%20apply%20it%20to%20others.%3CBR%20%2F%3E%3CBR%20%2F%3EA%20quick%20look%20at%20the%20custom%20resource%20calendars%20you%20show%2C%20the%202nd%20shift%20appears%20to%20have%20an%20error.%20It%20shows%2012%3A00%20AM%20to%203%3A30%20AM%20and%20then%20a%20rather%20long%20%22lunch%22%20from%203%3A30%20AM%20to%203%3A00%20PM.%20Maybe%20that's%20intended%2C%20I%20don't%20know.%3CBR%20%2F%3E%3CBR%20%2F%3EJohn%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2653335%22%20slang%3D%22en-US%22%3ERe%3A%20Ms%20Project%20Shift%20Work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2653335%22%20slang%3D%22en-US%22%3EJohn%2C%3CBR%20%2F%3EThanks%20for%20your%20reply.%3CBR%20%2F%3EI%20definitely%20understand%20that%20my%20file%20is%20very%20complex.%20There%20are%20many%20moving%20parts%20and%20the%20ability%20to%20be%20agile%20is%20a%20huge%20barrier%20in%20regards%20to%20shortened%20or%20lengthened%20durations%20due%20to%20the%20nature%20of%20our%20repairs.%3CBR%20%2F%3EI%20will%20take%20a%20look%20into%20the%20assignments%20and%20see%20if%20there%20is%20something%20i%20was%20missing.%3CBR%20%2F%3EWhat%20we%20had%20done%20in%20the%20past%20was%20create%20individual%20calendars%20that%20would%20reference%20the%20working%20times%201%20shift%205%20days%208%20hours%20through%202%20shifts%2012%20hours%207%20days%20and%20everything%20in%20between.%20Then%20each%20department%20would%20have%20multiple%20resources%20(%20all%20of%20which%20would%20reference%20the%20department%20and%20one%20of%20the%20listed%20calendars)%3CBR%20%2F%3EAssembly%201X5X8%3CBR%20%2F%3EAssembly%201X5X10%3CBR%20%2F%3EAssembly%201X5X12%20......%20so%20on%20and%20so%20forth%3CBR%20%2F%3EThe%20system%20%22Worked%22%20but%20only%20in%20a%20sense%20of%20showing%20an%20accurate%20Start%2FFinish....%20No%20Over%20Allocations%2C%20Cost%2C%20or%20Hour%20By%20Hour%20views.%3CBR%20%2F%3E%3CBR%20%2F%3EMaybe%20what%20i%20am%20trying%20to%20do%20would%20be%20better%20suited%20for%20another%20program%2C%20but%20i%20would%20really%20like%20to%20make%20MS%20Project%20work%20for%20me.%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20far%20as%20the%20calendar%20goes...%20The%2012AM%20to%203%3A30AM%20would%20be%20the%20End%20of%20Shift%20from%20the%20previous%20day%20(2nd%20Shift)%20Then%20pick%20back%20up%20starting%20at%203%3A30%20PM.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20again.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2653561%22%20slang%3D%22en-US%22%3ERe%3A%20Ms%20Project%20Shift%20Work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2653561%22%20slang%3D%22en-US%22%3EChris%2C%3CBR%20%2F%3EYou're%20welcome%20and%20thanks%20for%20the%20feedback.%3CBR%20%2F%3E%3CBR%20%2F%3EProject%20will%20do%20what%20you%20need%20although%20with%20the%20complexity%20of%20your%20structure%2C%20it%20may%20take%20more%20effort%20than%20you%20want%2Fexpect.%20I%20would%20definitely%20limit%20the%20number%20of%20custom%20work%20calendars.%20Take%20a%20close%20look%20at%20what%20you%20need%20to%20define%20the%20work%20and%20limit%20the%20options%20for%20calendars.%20In%20my%20view%20you're%20already%20in%20deep%20yogurt%2C%20no%20need%20to%20keep%20piling%20on%20the%20%22toppings%22%2C%20so%20to%20speak.%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20that%20I%20look%20at%20your%20second%20shift%2C%20I%20missed%20the%20fact%20that%20it%20is%20correct.%20The%20order%20of%20the%20work%20times%20threw%20me%20off.%3CBR%20%2F%3E%3CBR%20%2F%3EGood%20luck%3CBR%20%2F%3EJohn%3C%2FLINGO-BODY%3E
Occasional Contributor

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 file
My standard scheduling options are
Fixed Units / 7am- 11pm 24hrs per day 168 hrs per week 30 days per month Tasks are NOT effort driven
I 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 resources
For 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!

8 Replies

Chris_Legereit_0-1629129053966.png

Chris_Legereit_2-1629129089558.png

 

 

 

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

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 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.
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 luck
John
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 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.
Chris,
Thanks for the update. A couple of comments.

If you assign your Planning calendar as the Project calendar, all tasks will follow that calendar and there won't be any need for separate Task Calendars, unless specific tasks need to deviate from the Project calendar.

In Project, duration is the time span during which a task is performed. Work is the effort expended to perform the task. Project only has one definition for a "day". With multiple custom calendars you should avoid entering duration in anything other than hours. Hours are hours but days, weeks, and months may vary.
John
Thanks John,
I agree that for my specific needs Duration is best suited for hours entry rather than days/weeks
I have been messing with the options for [hours per day] [hours per week] [days per month]
Can you please verify something for me.

During the initial build of a schedule if the base calendar is 2 shifts 8 hours per shift [16 total hours with 15 hours of work available due to lunch breaks]
The option would be [16 hours per day] [80 hours per week] [20 days per month]
This would be scaled to the appropriate initial base schedule.
The reason I ask is that it seems to be just very slightly off.

Again, Thank you for your continued support!

@Chris_Legereit,

I'm not sure what you mean by "scaled to the appropriate initial base schedule" but this is what the options mean: The "day", "week" and "month" options describe working time. They define the value in the Duration field. For example, if you use a normal Standard calendar and you enter 5 days in the Duration field, that represents 5 working days of 8 hours each. If however, you elect the 24 Hour Calendar as the project calendar and leave the definition of a "day" at the default 8 hours, then it will take 3 "days" to cover a full 24 hour time period. So if a plan has a mix of project, task and resource calendars, the definition of a "day" (or "week" or "month") can create real headaches. I recommend Excedrin.

 

Using hours in the Duration field is always a good bet since an hour is an hour (universal).

 

Attempting to use months for duration is even worse since Project does not provide for more than one definition. The default 20 days is working days and is a compromise that attempts to cover the actual Gregorian calendar. That's why entering months in the Duration field is fraught with frustration. It is sometimes useful to enter duration in "elapsed time". For example, an entry of "7ed" covers a calendar week, Monday through Sunday, whereas an entry of "7d" will cover Monday through Friday, skip the non-working weekend, and continue with Monday and Tuesday of the next week.

 

When faced with dates that seem "slightly off" it is often useful to set the general option for date format to include the time.

 

Hope this helps.

John