I really need some advice here... i am trying to sort out a budget calculation sheet and I am STUCK!!
Here is what I am trying to do...
i have a Fixed budget or "target value" for my Project say $100,000
I have a number of "budget" varible values that add up to this figure but become fixed when the price of the item is agreed or purchased..
What I need is a way to show the impact of the fixed item purchase on the remaining varibles as the project progresses along.
i.e. each time I purchase something the price becomes "fixed" if I go over my budget then I need to identify this and re-adjust all the varibles by a fixed percentage amount to still reach the given over all target of $100,000
So for example I budget for windows - say $5000 but then they really cost me $6000which then becomes the fixed value.
After this my budget is over and I need to save some money on the remaining varible.. But the question is by what percentage on each item ???
Bookmarks