Hours assigned to Resources

%3CLINGO-SUB%20id%3D%22lingo-sub-2776451%22%20slang%3D%22en-US%22%3EHours%20assigned%20to%20Resources%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2776451%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20assigned%20a%20resource%20(with%203%25%20units)%20to%20a%20task%20which%20has%20a%20duration%20of%203%20months.%20When%20I%20generate%20a%20work%20report%20and%20see%20resource%20usage%20across%20two%20months%2C%20looks%20like%20the%20resource%20is%20working%20more%20hours%20in%20the%20initial%20weeks%20and%20then%20this%20tapers%20off.%20Is%20there%20a%20reason%20why%20this%20may%20be%20happening%3F%20I%20would%20want%20the%20resource%20to%20be%20employed%20equally%20across%20those%203%20months.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2776764%22%20slang%3D%22en-US%22%3ERe%3A%20Hours%20assigned%20to%20Resources%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2776764%22%20slang%3D%22en-US%22%3Eashpandit9%2C%3CBR%20%2F%3EFrom%20your%20brief%20description%20it%20sounds%20like%20the%20resource's%20work%20is%20contoured%20but%20there%20are%20many%20factors%20that%20can%20influence%20how%20work%20is%20distributed%20over%20the%20duration.%3CBR%20%2F%3E%3CBR%20%2F%3EA%20screen%20shot%20might%20be%20helpful%20but%20take%20a%20look%20at%20the%20Resource%20Usage%20view%20and%20add%20the%20Work%20Contour%20field%20as%20a%20column.%20If%20it%20shows%20%22Front%20Loaded%22%20then%20that's%20the%20answer%20explaining%20what%20you%20see.%20By%20default%20Work%20Contour%20is%20%22Flat%22%20meaning%20the%20assignment%20work%20is%20spread%20evenly%20over%20the%20full%20duration.%3CBR%20%2F%3E%3CBR%20%2F%3EJohn%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2776901%22%20slang%3D%22en-US%22%3ERe%3A%20Hours%20assigned%20to%20Resources%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2776901%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20was%20helpful%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F917748%22%20target%3D%22_blank%22%3E%40John-project%3C%2FA%3E.%20I%20was%20able%20to%20check%2C%20and%20found%20the%20work%20contour%20as%20mostly%20'Flat'.%20A%20bigger%20concern%20for%20me%20on%20closer%20evaluation%20is%20that%20for%20the%20same%20%25%20units%20assigned%20to%20a%20resource%20for%20separate%20tasks%2C%20I%20see%20different%20hours%20in%20the%20work%20column.%20My%20current%20plan%20is%20~2500%20lines%20so%20I'm%20curious%20if%20there%20is%20a%20way%20to%20fix%20this%3F%20For%20example%2C%20if%20I%20mention%2050%25%20as%20the%20units%20for%20a%20task%20that%20lasts%2010%20edays%2C%20I%20want%20it%20to%20show%20120%20hours%20for%20all%20tasks%20which%20say%2010%20edays%20with%2050%25%20for%20one%20resource.%20Currently%2C%20this%20is%20different%20for%20some%20reason.%20Screenshot%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have assigned a resource (with 3% units) to a task which has a duration of 3 months. When I generate a work report and see resource usage across two months, looks like the resource is working more hours in the initial weeks and then this tapers off. Is there a reason why this may be happening? I would want the resource to be employed equally across those 3 months.

8 Replies
ashpandit9,
From your brief description it sounds like the resource's work is contoured but there are many factors that can influence how work is distributed over the duration.

A screen shot might be helpful but take a look at the Resource Usage view and add the Work Contour field as a column. If it shows "Front Loaded" then that's the answer explaining what you see. By default Work Contour is "Flat" meaning the assignment work is spread evenly over the full duration.

John

This was helpful @John-project. I was able to check, and found the work contour as mostly 'Flat'. A bigger concern for me on closer evaluation is that for the same % units assigned to a resource for separate tasks, I see different hours in the work column. My current plan is ~2500 lines so I'm curious if there is a way to fix this? For example, if I mention 50% as the units for a task that lasts 10 edays, I want it to show 120 hours for all tasks which say 10 edays with 50% for one resource. Currently, this is different for some reason. Screenshot attached.

@ashpandit9,

I like your term, "mostly flat". That might tell the whole story right there.

 

There are several factors that could influence what you show in the screen shot but without more information, I can only guess what might be causing the issue. For example, all your durations are in elapsed time, so what is your Project calendar? What is the base calendar of your resources?, Have you applied any task calendars? How exactly did you assign the resources?

 

I duplicated your example using the Standard calendar as the Project and resource Base Calendar. I assigned the resources via Resource > Assignments group > Assign Resources. This is the result as shown in the Resource Usage view. It would be helpful to see this same screen shot from your file including the field and details I show in my screen shot.

John

2021-09-23_08-01-06.png

@John-project There was just one task which was not flat, and I changed that. Other than that, rest all were flat. But I think that issue looks resolved.

I have been building this plan for the last few months, but it mostly captured linkages, costs, ownership (in the resource column) etc. We recently decided to understand effort levels and accordingly put % for each owner based on how much time they would be spending on that task. During this process we added/removed names for multiple tasks. I have been using elapsed time, since it helped get more accurate estimates when dealing with longer time periods (weeks, 10s of months), and the default calendar is the standard calendar.

I'm okay with a 24 hr work level show for a 1 eday task. However, I'm getting different hours for the same amount of Units (%). I basically need to make sure 100% is 24 hrs (in elapsed time), 50% is 12 hrs, etc. across all tasks. I can then work from there on. Is there a fix for this

Unable to attach screen shot. Will try again.

@John-project Attaching Screen shots from dummy file here

The only reason an assignment would not have a flat work contour is if the user manually edited the work, so there must be more to the story than is being revealed.

It sounds like you've done a lot of massaging on the plan and that can always result in unexpected behavior. I'm not sure how using elapsed time would help get more accurate estimates. Using elapsed time shows work planned over non-working days but that conflicts with a resource whose base work calendar is the Standard (i.e. working days, not elapsed days). Accurate estimates are achieved when a plan is laid out according to how it will be performed. If indeed you need a 7-day workweek, then create a custom calendar for that and set that as the Project calendar. Elapsed days in the Duration field are best used for tasks that do not have resources assigned.

Unfortunately the screen shots you attached do not show the fields and timescaled details I requested. Perhaps it would be better if you could send me your file so I could see what I need to see. My address is below. I will ask some questions.
John
jmacprojataticlouddotdotcom
(remove obvious redundancies)
Thanks John. I'm not sure if your address had two 'dots'. Anyway, I figured the issue. My hours were changing because of chopping and changing of my durations and resource allocations. If I delete the resource allocation cells and then paste again, it gets realigned as desired. Thanks for your help!

@ashpandit9 

You're welcome and thanks for the feedback. I'm glad you figured it out.

 

John