Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-24-2014, 03:02 AM
Baddim Baddim is offline Budget cost on early stages Windows 7 64bit Budget cost on early stages Office 2010 64bit
Novice
Budget cost on early stages
 
Join Date: Oct 2014
Location: Iceland
Posts: 3
Baddim is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 10-24-2014, 04:53 AM
Guloluseus Guloluseus is offline Budget cost on early stages Windows 7 64bit Budget cost on early stages Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

This si one of the things Project was made for.
Assuming you are using Project 2010, I have made a quick programme of works based on your values and descriptions (attached). The cost column has your budget values in, so that we can create a cash flow.
Once you have the base programme planned out, go to the "Project" tab in project and select "Visual Reports". In th elist that comes up you will see "Cash Flow"- click this and it will create an Excel graph giving all the details you need. Note that the first page (graph) reflects the second page (data), and you can expand this to greater detail levels (see attached cash flow sheet).

Hope this helps
Attached Files
File Type: xls building prog cash flow.xls (63.5 KB, 12 views)
Reply With Quote
  #3  
Old 10-24-2014, 04:57 AM
Guloluseus Guloluseus is offline Budget cost on early stages Windows 7 64bit Budget cost on early stages Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

Sorry, the prog didnt upload. I have had to zip it as the site wont accept mpp files.. which is really weird for a Project forum...lol
Attached Files
File Type: zip Building prog.zip (24.0 KB, 11 views)
Reply With Quote
  #4  
Old 10-24-2014, 05:33 AM
Baddim Baddim is offline Budget cost on early stages Windows 7 64bit Budget cost on early stages Office 2010 64bit
Novice
Budget cost on early stages
 
Join Date: Oct 2014
Location: Iceland
Posts: 3
Baddim is on a distinguished road
Default

Thank you for this. That helped. I did try to use the "cost" column but one of my superior told me that I should use "budget cost" and "budget work" As he is more experienced than me in msp. I worked my ass off to get his suggestions to work. Should have done i my way from the start.

One thing in the "cost" column I find odd is that when I add value to some of the tasks msp subtracts some small amount of the value and adds some small amount to others.

Some examples.
28.900.000 turns into 28.899.998
48.500.000 turns into 48.899.998
93.500.000 turns into 93.499.996
78.600.000 turns into 78.599.997

Any ideas?
Reply With Quote
  #5  
Old 10-25-2014, 04:26 PM
JulieS JulieS is offline Budget cost on early stages Windows 7 64bit Budget cost on early stages Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

As you have discovered, the budget cost and budget work field are "top down" estimates and can only be applied to the Project Summary task.

As you have more detailed estimated, I suggest adding the Fixed Cost field to the Gantt chart view and entering the values there. Then you can save a baseline after all planning is complete and have a "baseline" cost for comparison once you start tracking. The "baseline cost" is frequently referred to as the "budget".

Regarding the odd numbers - what version of Project and what service pack is applied?
Reply With Quote
  #6  
Old 10-29-2014, 06:32 AM
Baddim Baddim is offline Budget cost on early stages Windows 7 64bit Budget cost on early stages Office 2010 64bit
Novice
Budget cost on early stages
 
Join Date: Oct 2014
Location: Iceland
Posts: 3
Baddim is on a distinguished road
Default

Thank you Julie
I'm running Microsoft Project Professional 2010 - Service pack 2

I've tried several columns where I can put in value/cost and every time the numbers change. At first I thought is was because i had linked the tasks together (predecessors) So I started from scratch but all the same. It's odd that some numbers change while others do not. I also tried to add value to the number where the value was subtracted but then a new number would appear. There is no logic to these changing of value. Some numbers is added with 1, 2, 4 add 4 and other subtracted wit the same numbers.
Reply With Quote
  #7  
Old 10-29-2014, 10:53 AM
JulieS JulieS is offline Budget cost on early stages Windows 7 64bit Budget cost on early stages Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Does the error occur in a new project file? I have never seen Project randomly add or subtract values and I cannot reproduce entering values directly into the Cost field in Project 2010 SP-2. Linking should have no effect on costs.

Are you seeing the changed values in the Visual Reports or in the native project file? If you look at the Task Usage view and add Cost to the right side, does all appear normally?
Reply With Quote
  #8  
Old 10-29-2014, 01:58 PM
ketanco ketanco is offline Budget cost on early stages Windows 7 64bit Budget cost on early stages Office 2010 64bit
Expert
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

to see a cost distribution by time you can first assign fixed costs to the item summary tasks as you wrote in your original post.

then go to task view. select cummulative cost. you will see a cumulative cost distribution by time and then you can copy paste these to excel and draw a nice graph
Reply With Quote
  #9  
Old 10-29-2014, 02:48 PM
JulieS JulieS is offline Budget cost on early stages Windows 7 64bit Budget cost on early stages Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Or use the Cash Flow Visual report to export the data to Excel and have a nice graph.
Reply With Quote
  #10  
Old 10-30-2014, 03:06 AM
Guloluseus Guloluseus is offline Budget cost on early stages Windows 7 64bit Budget cost on early stages Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

Similar tothe one in post #2? <g>

I have played with the prog to replicate the error, and cant do it either. The only things I can think of is that the costs have become time related, and somewhere there is a tiny difference in calenders, although this seems improbable at best or that there is a prior resource with a weird calender.
Have you tried on a different computer? A quick input of the base programme would show it up, if values didnt change it woul dsuggest that there is a possible error in global settings.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Budget cost on early stages Auto Adjust After Early Finish LeonvdW Project 1 10-04-2013 05:27 AM
providing early start date ketanco Project 1 02-22-2013 02:32 PM
How to receive an error if values exceed budget cryoffalcon Excel 1 05-09-2012 04:12 AM
Budget cost on early stages How to apply budget for earned value analysis ttorneby Project 2 06-03-2010 04:52 PM
Income/Budget Calendar? Guinea Excel 4 03-11-2010 09:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft