One of the most important aspects of any project is the budget. If you don't keep a close eye on expenditures you can easily run over, which can have serious consequences. Finding potential problems early gives you the chance to take cost-cutting action before it's too late. Looking for cost problems is quick and easy with Microsoft Office, and you can learn how with this simple tutorial.
While a project is underway you need to keep an eye on Costs.…Project has Tables, Filters, and Reports that help you look at Project Cost and…find Tasks or Resources that cost more than planned.…The first place to look is the Cost table, because it shows cost variance.…So go to the View tab, click the Tables button, and then choose Costs.…Here you can see total cost is the scheduled Costs for tasks.…Then there's the baseline and Cost Variance, if it's negative it means that it's under budget.…
You can see the total cost here is less than the Baseline.…You can look for Tasks that are running over budget with a filter.…In the Filter dropdown list, choose More Filters, then click Cost Overbudget, and click Apply.…Here you see the tasks that have a higher scheduled cost than the baseline.…These are the ones with a positive cost variance.…Another place to look is Tasks that have more work than planned.…To see those, click the down arrow in the Filter box, choose More Filters, and…then apply the Work Overbudget filter.…
Author
Released
4/18/2013- Choosing the right Project edition
- Creating and saving projects
- Setting up calendars
- Creating individual and recurring tasks
- Linking and timing tasks
- Assigning tasks to resources
- Viewing your data differently with sorting, grouping, and filtering
- Fine-tuning the project schedule
- Understanding baseline, schedule, and actual values
- Reporting on the project status
- Sharing projects<br><br>
- The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
Skill Level Beginner
Duration
Views
Related Courses
-
Excel 2013 Essential Training
with Dennis Taylor6h 32m Intermediate -
Management Tips
with Todd Dewett7h 50m Intermediate -
Access 2013 Essential Training
with Adam Wilbert5h 4m Beginner -
Advanced Microsoft Project
with Bonnie Biafore5h 18m Intermediate
-
Introduction
-
Welcome57s
-
-
1. Working with Project
-
Using the Ribbon4m 19s
-
Finding commands3m 49s
-
-
2. Setting Up Project Files
-
Setting up calendars2m 45s
-
Setting basic options5m 27s
-
3. Creating Tasks
-
Creating a manual task2m 31s
-
Creating a milestone task1m 25s
-
Creating a recurring task4m 18s
-
Creating a summary task4m 8s
-
Displaying summary tasks2m 30s
-
4. Linking and Timing Tasks
-
Linking tasks5m 51s
-
Adding lag or lead time2m 46s
-
Viewing tasks and task links4m 57s
-
-
5. Creating Resources
-
Understanding resources2m 16s
-
Creating a work resource8m 45s
-
Creating a cost resource3m 21s
-
-
6. Assigning Tasks to Resources
-
Finding overallocations3m 56s
-
7. Working with Views
-
Choosing a view4m 50s
-
Working with a table3m 1s
-
Using the Timeline view5m 17s
-
Sorting tasks and resources4m 27s
-
Grouping tasks and resources4m 45s
-
Modifying task bar layout2m 48s
-
Modifying text formatting2m 52s
-
-
8. Fine-Tuning the Project Schedule
-
Reviewing the critical path3m 53s
-
Splitting a task2m 7s
-
Adjusting a work contour2m 53s
-
Leveling resources4m 54s
-
Inactivating a task2m 41s
-
-
9. Tracking and Managing a Project
-
Adding tasks to a baseline5m 54s
-
Updating the schedule8m 45s
-
Assigning overtime4m 35s
-
Updating costs2m 15s
-
Rescheduling unfinished work3m 45s
-
10. Viewing and Reporting Project Information
-
Using earned value5m 12s
-
Printing views and reports4m 22s
-
11. Sharing Projects
-
Saving to other formats5m 27s
-
Importing and exporting5m 47s
-
-
Conclusion
-
Next steps56s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Looking for cost problems