none
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:04 PM

All replies

  • Hi,

    You could create a report and use a formula to limit the displayed actual cost. And as a kind of explanation, you could add a boolean indicating that the actual cost has been "capped".

    If actual cost <= 40h then

    • Show actual Cost
    • Set Capped = False

    Else

    • Show Capped Actual Cost
    • Set Capped = True

    End

    Regards
    Wim


    Tuesday, April 10, 2012 12:52 PM