Yogesh ManeyBusiness Process & System Analyst| Crest Animation Studios LtdMumbai, Maharastra, India
How can the following be put in MS Proejct :
I have resource pool of say 500 people. With Salary Ranging from 100 to 1000.
While planning or bidding we generally don't deploy perticular person, we take average salary for cost estimation.
But in actual while execution we take actual resource salary which is deployed.
How this can be establish in MS Project. Saving Changes...
John ColePM II| County of RiversideRiverside, Ca, United States
Yogesh,
We resolved this issue (200+ resources) by doing the following:
1. Establish Generic Resources in the MS Project Resource Pool. The Generics may be either position titles or roles.
2. Establish an average rate per generic resource. For instance, if you have 5 DBAs (with various pay ranges), the DBA (generic resource) rate will be the average of the 5 DBAs. Note this can/should be different than the average rate for a SysAdmin (or any other IT role).
2a. One variation that I've seen used is instead of using an average rate for estimating (obviously, some estimates will be low) is to simply use the highest actual rate an individual earns as the rate for the generic. The only downside to this is that all of your estimates will be high (meaning if actual hours is equal to estimated hours, all of your estimates will be higher than your actual billing). Your customers might like this, but your management may not...that's up to your organization.
3. If you want, you can put the actual pay in the resource pool for each individual resource. Due to privacy concerns, we actually moved the comparison of actuals vs estimates to our accounting/finance/billing group.
3a. If you don't want to put the actual pay in for each resource, then you might use 2a listed above, and then put the average for that role in as another rate. This allows you to compare max salary vs average, which should give you close to what you're looking for without disclosing private information.
A couple of random notes:
1. To do any of this in MS Project, you will need to double-click on the resource name, then in the new window, click the cost tab. Use the different rate tables per employee to input the desired information.
2. There is an MS Project and MS Project Server newslist that is publicly available. The links are on MS's website. Use it!! It is extremely helpful.
Feel free to contact me if you have any follow-up questions. Saving Changes...
