Share via

Duration, Hours and Workforce

Anonymous
2020-09-25T19:33:48+00:00

Hi,

I have a task that is to take 2 days, 10 hour shifts (set up in calendar)  and I have 200% labour (which represents 2 employees), 100% Mechanic and 100% Technician. When I change the days to 4 days instead of 2 days only the Mechanic's and Technician's "Work" changes to 40 hours. My question is how do I get the Labour to calculate 4days x 2 Employees x 10 hours days?.

Thank you

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2020-09-26T23:46:33+00:00

    JenniferEady,

    first we need to fill in the gaps in the information you have provided in your question. You haven't said what you mean by "2 days". I will assume that the definition of "day" is 8 hours, which is the default definition file, options, schedule. So your durations of 2 days and 4 days means 8 working hours and 16 working hours respectively.

    To avoid the usual ambiguity, I will be inputting durations in hours, explicitly.

    You haven't said what the start and finish times are for the two x 10 hours shifts, or on what days they occur.

    I will assume that the first day shift starts at 06:00 on a Monday and runs to 16:00 on the same Monday.

    I will assume that the first night shift starts immediately after at 16:00 on the same Monday and runs to 00:00 on the same Monday and then 00:00 - 02:00 on the following Tuesday, and so on.

    You also haven't said whether the task, if it were not for the resources, can be done at any time and on any day, or whether there should be a task calendar which prevents the task from happening on certain days and at certain times.

    I will assume that the task can be be done anytime, so I will assign the built in 24 hour calendar as the task calendar.

    So:

    Monday 06:00 - 16:00 Day Shift

    Monday 16:00 - 00:00 Night Shift

    Tuesday 00:00 - 02:00 Night Shift

    Tuesday 06:00 - 16:00 Day Shift

    Tuesday 16:00 -00:00 Night Shift

    Wednesday 00:00 - 02:00 Night Shift

    Thursday 06:00 - 16:00 Day Shift

    Thursday 16:00 - 00:00 Night Shift

    Friday 00:00 - 16:00 Day Shift

    Friday 06:00 - 00:00 Night Shift

    ..then the cycle starts again on Monday.

    Make this into two calendars and assign each one to the appropriate resource.

    Let's say that a shift crew is 4 x people, since I do not like or recommend aggregating/merging individuals, so resources being:

    Resource Name Type Base Calendar
    Day Shift Mechanical Work AA Day Shift
    Day Shift Technician Work AA Day Shift
    Day Shift Labourer 01 Work AA Day Shift
    Day Shift Labourer 02 Work AA Day Shift
    Night Shift Mechanical Work AA Night Shift
    Night Shift Technician Work AA Night Shift
    Night Shift Labourer 01 Work AA Night Shift
    Night Shift Labourer 02 Work AA Night Shift

    Imposing a MSO date constraint to force the task to start on 06:00 on the first Monday 28/09/2020 06:00.

    Assign all 8 x resources to the task at 100%.

    You can see in the task usage view that each resource works only when the task calendar and the resource calendar allow. When the duration is 16 hours, the work is 64 hours.

    Day shift resources have 10 hours of work each and night shift resources have 6 hours of work each.

    When the duration is doubled to 32 hours, the work is 128 hours.

    Day shift resources have 20 hours of work each and night shift resources have 12 hours of work each.

    If your intention is to start with duration = 20 hours and then be changed to 40 hours:

    Work is 80 hours, being 10 hours for each resource.

    Then duration is 40 hours and work is 160 hours, 20 hours for each resource.

    Any help?

    Was this answer helpful?

    0 comments No comments
  2. John Project 49,705 Reputation points Volunteer Moderator
    2020-09-25T20:49:32+00:00

    JenniferEady,

    You say you set up a custom calendar for 10 hour shifts. Did you make that the Project calendar? Did you also set the option such that a day is defined as 10 hours instead of the default 8 hours? Did you insure the resource's Base Calendar is also the custom 10h day calendar?

    I'm confused by your second sentence that says when you change the duration to 4 days "only" the resource's work changes to 40 hours. What was their work before you changed the duration? If you initially assigned your resources at 200% to the original 2 day task, the Work should have been 40 hours, like this

    Then depending on the task type, increasing the duration to 4 days yields this

    Does that help?

    John

    Was this answer helpful?

    0 comments No comments