Forum Discussion
Lakshmisv1
Aug 10, 2023Copper Contributor
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
Sort By
- John-projectSilver ContributorLakshmisv1,
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- LakshmisvCopper ContributorThanks 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-projectSilver Contributor
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
- LakshmisvCopper ContributorThe budget is reset every quarter.