Cap Actual Effort Hours for Cost Calculations RRS feed

  • Question

  • Hello - I am using Microsoft Project Server 2007.  I have a question with regard to the setup in Server for tracking effort hours.  For purposes of calculatng actual cost, my organization does not reflect effort hours in excess of 40; when cost is calculated (in a spreadsheet), effort hours are capped at 40.  I would like to use Server to calculate actual project cost instead of downloading the data to Excel and performing the calculations there.  As a project manager, I would like to track the actual effort hours, regardless of whether the hours exceed 40 or not, but cap the hours at 40 (per week for each resource).  Is it possible to configure Server to cap effort hours at 40 for purposes of calculating actual cost?  For the earned value calculations, I would like to use actual hours rather than capped hours.  Is it possible to accomplish this?  Let me know if I have not provided enough information.  Thanks!
    Wednesday, January 5, 2011 8:01 PM


  • Hello.  Several possible solutions popped into my head reading your question, but as I write this I'm not 100% which I would choose.  So here they are for you to ponder and consider...

    First, you could use the OT HRs field to record those hours above the 40 hrs (capped), making your overtime rate as 1 instead of the typical 1.5 or even 2.0. Then in reporting you can the two together to get your actual (or create a third field with a formula to autosum them).

    Second, you could keep the actual work (aka hours) as is and simply put in a custom field for the capped hours for cost and reporting.

    Third, flip idea #2, and make actual work your capped hours and use a custom field for tracking the "real" actual hours.

    Hope this gives you some ideas of possible things you could try.

    Maybe post back to let us know what you decide and why.  Or to give more information.

    Good luck!



    Thursday, January 6, 2011 12:37 AM