I work in a software company where every week we produce a resource utilization report for the next 4-week period.
The purpose of this report is to document how the 40 resources (which includes Developers, Quality Assurance Engineers, Development/Network Managers) will be spending their time in the current and upcoming projects. Ideally, we will also want to generate various summary data at the end of the report.
I was wondering if:
1. any one can provide any tips on preparing such a report.
2. there is any Excel spreadsheet/template that i can use and is available for free to aid with this purpose. Any free desktop tool similar to an Excel spreadsheet is welcome too. Saving Changes...
Sort By:
Elyse NielsenSenior Project Manager| Ascension Health Information ServicesHaines City, Fl, United States
Hi,
Here are some lessons learned, from my previous experience. Hopefully, these lessons will be of use to you.
Have a Standardized Time Reporting Categories - Assures you are reporting apples to apples. For example, project meetings are project time categories, not administration.
Have a couple of different rollup categories - perhaps by time spent in Break/Fix, Project Work, etc..., by Team, by Project, by Individual.
Have a way to display scheduling conflicts for resources across all needed project work.
Have a comparison which displays what was predicted as need versus what was utilized.
Andrew MakarProgram Manager| AMAKAR LLCOakland Township, Mi, United States
Hi Shariar -
I had the exact same problem before and I solved it by creating a resource management model in MS Project. The ideas was to build a model with monthly forecasts to get an approximation of work so we could measure the capacity in the pipeline.
Can I compare the ROI method by dividing the total revenue of project with total required effort? Also I 'll take the utilization percentage per resource weekly. One parameter will be the investment the Project sponsor is doing will be a constant . If we can utilize the daily effort of the employee for multiple task in an effective way, we can maximize the ROI% from a resource remaining the investment constant.
May 24, 2018 2:41 PM
Kevin Tukei
...
Hi Andrew,
Looks like the link you shared is broken. Can you please re-post if possible?
I had the exact same problem before and I solved it by creating a resource management model in MS Project. The ideas was to build a model with monthly forecasts to get an approximation of work so we could measure the capacity in the pipeline.
Can I compare the ROI method by dividing the total revenue of project with total required effort? Also I 'll take the utilization percentage per resource weekly. One parameter will be the investment the Project sponsor is doing will be a constant . If we can utilize the daily effort of the employee for multiple task in an effective way, we can maximize the ROI% from a resource remaining the investment constant. Saving Changes...
Kevin TukeiProject Manager, PMP, CSMBurtonsville, Md, United States
Dec 01, 2009 12:33 PM
Replying to Andrew Makar
...
Hi Shariar -
I had the exact same problem before and I solved it by creating a resource management model in MS Project. The ideas was to build a model with monthly forecasts to get an approximation of work so we could measure the capacity in the pipeline.
