Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-02-2010, 12:15 PM
ttorneby ttorneby is offline How to apply budget for earned value analysis Windows Vista How to apply budget for earned value analysis Office 2007
Novice
How to apply budget for earned value analysis
 
Join Date: Jun 2010
Posts: 1
ttorneby is on a distinguished road
Default How to apply budget for earned value analysis

I'm having huge problems finishing a plan I'm working on. Maybe someone here has some clever ideas.



To take it from the beginning: This is a part of some school work, and I have a number of tasks, and for each of the tasks I have details on what the budget is, and the planned duration. At a specific point in time I have details on the completion rate of each task, as well as the money spent, and the actual duration. From these figures, I want MS Project to calculate figures such as BCWS, ACWP, BCWP, EAC, SPI and CPI.

My problem is that I have not found a place to enter the budget cost for each task, without having to assign resources and all this. I've only found two coloums containing the word "budget", but neither of them allows me to enter values. Is there not a simple way to do this?

Also, it seems like "actual duration" and "% work completed follow each other. F.ex. on a specific task, 13 out of 16 weeks are spent, but the work is only 75% completed. MS Project doesn't seem to accept this.

I've attached a screeshot of what I'm working on, in case it might be at help.

Any help on this matter is highly appreciated!
Attached Images
File Type: jpg screenshot.jpg (143.1 KB, 15 views)
Reply With Quote
  #2  
Old 06-03-2010, 04:17 PM
Kimberly Kimberly is offline How to apply budget for earned value analysis Windows 7 How to apply budget for earned value analysis Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Project uses your baseline plan to make the calculations, which should be the perfect budget since you estimated work, materials, and costs on a task-by-task basis.

You may have read about Budget Resources, which can be created if desired for the sake of comparison. If you are inclined to do so, create the resources (check the Budget checkbox). Assign the budget resources to the project summary task, and then enter the amounts. You can enter the amounts in either Task Usage or Resource Usage Views, but you will have to insert the fields Budget Work and Budget Cost.


Regarding "Also, it seems like "actual duration" and "% work completed follow each other": Yes. The variables Work and Duration are definitely are linked together.
Reply With Quote
  #3  
Old 06-03-2010, 04:52 PM
Kimberly Kimberly is offline How to apply budget for earned value analysis Windows 7 How to apply budget for earned value analysis Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

I just realized in your screenshot, not even EAC is being shown, which made me re-read your post... "without having to assign resources and all this."
You have to assign resources and all this so that Project can make accurate calculations.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Analysis of Amount based on following criterion. aligahk06 Excel 1 04-24-2010 10:34 AM
Income/Budget Calendar? Guinea Excel 4 03-11-2010 09:11 PM
automatically extract footnotes into new file and apply character format to footnote hrdwa Word 0 02-27-2010 03:16 AM
Good commission to be earned for writing some office questions iqnetsys Office 0 02-23-2009 05:22 AM
Apply design template to existing slide mellowyellow PowerPoint 0 01-26-2009 12:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:13 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