Forum Discussion
How to enter the number of workers in an assignment in MS Project?
My company philosophy in supervising projects is to get the number of Workers of each contractor and assign them to the task for that day. For example, I entered today that the Contractor1 provided 10 workers who worked for 5 hours on Task1, and tomorrow the Contractor 1 provided 3 workers who worked for 4 hours on Task 1 and 6 workers, worked for 6 hours on Task 2, and so on.
I figured out how to enter the number of hours for each day per resource. I don't know how to or where enter the number of workers for each task each day by each contractor. Is this even possible on Project?
If you want to assign by the number of workers each day then I suggest you use this approach. First, even though a task by span several days, break it into individual one day tasks of fixed duration. For example, let's say Task A spans 5 days total. This is easy to do using a Recurring task. Go to Task > Insert > Task > Recurring task. Repeat this for Task B and however many other tasks you need.
Second, on the Resource Sheet enter however many separate contractors you use (e.g. Contractor1, Contractor2, etc.) and set the Max Units to the maximum number of workers each contractor will ever supply. For example, let's say Contractor1 supplies 10 one day, 6 the next day and 15 the following day. Set the Max Units to 15. That will avoid any resource overallocation issues.
Third, for each task go to Resource > Assignments group > Assign Resources to bring up the Assign Resources window. For each contractor enter the number or workers into the Units field. If more than one contractor's workers will be assigned to that task, enter the number for each contractor.
Fourth, Project will automatically assign each of those workers at 100% (i.e. 8 hours assuming the Standard calendar), so for example if you have assigned 10 workers from contractor1 to the first day of Task A, Project will show 80 hours in the Work field. If that is not what you want, manually edit the hours in the Work field.
For your example, the Gantt Chart might look like this:
Hope this helps.
John
3 Replies
If you want to assign by the number of workers each day then I suggest you use this approach. First, even though a task by span several days, break it into individual one day tasks of fixed duration. For example, let's say Task A spans 5 days total. This is easy to do using a Recurring task. Go to Task > Insert > Task > Recurring task. Repeat this for Task B and however many other tasks you need.
Second, on the Resource Sheet enter however many separate contractors you use (e.g. Contractor1, Contractor2, etc.) and set the Max Units to the maximum number of workers each contractor will ever supply. For example, let's say Contractor1 supplies 10 one day, 6 the next day and 15 the following day. Set the Max Units to 15. That will avoid any resource overallocation issues.
Third, for each task go to Resource > Assignments group > Assign Resources to bring up the Assign Resources window. For each contractor enter the number or workers into the Units field. If more than one contractor's workers will be assigned to that task, enter the number for each contractor.
Fourth, Project will automatically assign each of those workers at 100% (i.e. 8 hours assuming the Standard calendar), so for example if you have assigned 10 workers from contractor1 to the first day of Task A, Project will show 80 hours in the Work field. If that is not what you want, manually edit the hours in the Work field.
For your example, the Gantt Chart might look like this:
Hope this helps.
John
Thank you very much for your help I thought there is no workaround. Best Regards John-project
