Budget cost on early stages
Hi I'm new here and hopefully i can contribute some here in the future. But I have some problems with budget cost.
I have a building project where I have the price estimation for the main post in the project. The price estimation is based on quantities and no resources have been made and no contractor have been assigned to the project. Therefor I have not put any resources yet, as I don't have all the criteria to determine the resources.
This looks some thing like this.
1. Excavation - 100.000
2. Foundations - 250.000
3. Pipes - 100.000
4. 1st floor - 100.000
5. 2nd floor - 200.000
6. Roof - 200.000
7. Internal finises - 150.000
8. External finises - 200.000
9. Gardening - 100.000
What I am trying to get for this is the cash flow pr.month. I have set up the estimated time for the project, predecessors etc. But I would like to see the cash flow based on these numbers. Usually I do this in excel but I would like to see if I can do this in ms-project.
I've Google d myself to the moon and back trying to find a solution, I have several books for MSP but the only thing I find is Budget cost and budget work where I can only set the total amount in the project and only for the project summary task, not divide the amount on tasks ( 1-9 )
Why? Well I work with clients who have a project, budget and limited time. Sometimes I can see right on that there is no way that some projects can't bee finished in this amount of time. The best way I find best is to show them how much the contractor has to produce in one month is money. That way they understand what I'm trying to tell them.
|