A family of Microsoft relational database management systems designed for ease of use.
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?