Forum Discussion

Lakshmisv1's avatar
Lakshmisv1
Copper Contributor
Aug 10, 2023
Solved

Specifying a budget

How can I specify a quarterly budget for a group of tasks ?

e.g Actual effort for all tasks in a  quarter (April 1 - May 30) should not cross 1000 hours.

 

Thanks

 

9 Replies

  • John-project's avatar
    John-project
    Silver Contributor
    Lakshmisv1,
    Normally a budget is associated with cost but your example talks about effort which is work. However, either way you can set up a "budget" but there is no flag in Project that will be raised if the budget is exceeded. That's something you will have to monitor yourself.

    John
    • Lakshmisv's avatar
      Lakshmisv
      Copper Contributor
      Thanks for your reply John.

      I defined a Project level custom field X which calculates [Budget Work] - [Work] to see the variance from Budget Work at project level
      This works fine and the value comes correctly. You are right though that there is no flag raised and I have to monitor it.
      My problem is that I would like the value of [Budget work] to be reset at the start of each quarter and it should be only applicable to the activities of that quarter. Please advise on how to handle that.
      Thanks
      • John-project's avatar
        John-project
        Silver Contributor

        Lakshmisv,

        I can only see a couple of options.

         

        The first involves a manual calculation of Budget Work minus Cumulative Work for a 3 month time span. Reset the budget each quarter and run the calculation.

         

        The second option requires VBA to essentially do the calculation and dump the result in a custom field at project level.

         

        I only use the desktop version of Project so perhaps there are more ideas with enterprise versions. Maybe someone else will jump in with their suggestions.

         

        John

Resources