In a project plan beside the Start and Finish date of activity, we also need to know When we need resource, and How many resource we need.
I will show you how to do it.
We have a simple project with 3 activities and is assigned resource as follow:
- Activity A : 10 worker and 1 Crane
- Activity B : 5 worker and 2 Crane
- Activity C : 20 worker
Now we will make a Labor, Equipment mobilization plan so that we know when we need the resource and how many we need.
First we need to make some configuration. Go to menu Admin -> Admin Preferences. Click on Time Periods tab. Edit the Hours value to match with your Project calendar.
For example if you use 6 days work-week, you have to adjust Hours/Week is 48, Hours/Month is 208 (8 x 26), Hours/Year is 2496 (208 x 12)
After finish, click Close button.
Click on Resource Usage Spreadsheet button.
Hold Ctrl button and select 2 resource : Worker and Crane
Now data will show on the right.
But all data is in Units format. We may don't care number of unit, we only care number of person or equipment.
You will right click on the table and select Spreadsheet Options
Click on Calculate Average and Base on Hours per Time Period
Now you can see the figure show in number of person and equipment.
On the week of 29-Sep you will need total 35 workers and 3 cranes.
You can also print the report by going to Print Preview
With this Resource Mobilization Plan you know when you need resource and how many.
Thank you for your time to read this article.
You can also find other post at my personal blog : https://doduykhuong.com