Marginal Books

How to Track Schedules, Costs and Earned Value with Microsoft Project

TitleHow to Track Schedules, Costs and Earned Value with Microsoft Project
AuthorAkram Najjar
PublishedJanuary 2017
152 pages (36,500 words)

Microsoft Project hits a steep learning curve climb when the project manager starts tracking the actual values of schedules, costs and analyzing earned value. It has a wide range of options to be configured. These affect one another, sometimes in drastic ways, and hence your results. You need to setup pre-requisites before you can track and control execution.

Secondly, although Earned Value Analysis (EVA) is available out of the box, its use requires elaborate procedures and reporting functions. Both schedule and cost reporting as well as EVA fall under the "tracking" activities a PM has to address during the complex task of project execution. (Planning a project is presented in a companion eBook by the author: Click Here).

This eBook concentrates on tracking, only, i.e., all execution activities that commence after the approval of a project plan. Procedures presented in terms of focused workouts are provided to allow you as the PM to track schedules and costs. These are tracked at both the Task and the Assignment levels. Material and Cost assignments also tackled. Each of these procedures requires elaborate "dancing" through the options provided by Microsoft Project. These are discussed in detail. Related facilities such as progress lines, updating groups of tasks and baselines are also addressed. 

39 Workouts are presented in a step by step fashion, supported by screen captures. The download also contains a good number of useful templates and supporting documents.

Where can you Purchase the eBook?

Click Here to view the Online Stores where the eBook can be purchased.


Click Here to download a sample chapter from the book.

Click Here to download the workouts and templates for the eBook.

(A password is provided in the purchased eBook).

Table of Contents

Guidelines and Exclusions
Downloading the Supporting Files
A Global Example - An Apology
The Generic Workflow for Cost Tracking and EVA in Microsoft Project
What EVA Fields Does MSP Provide?
What Options do You Need to Set for Cost Tracking and EVA?
Where to Enter and View EVA Data in Microsoft Project
Set the Baseline for Comparative Analysis
What to Report to Track a Project's Progress?

(Note: the following chapters include EVA procedures):

Track your Schedules: at the Task Level
Track your Schedules: at the Assignment Level
Track your Costs: at the Task Level
Track your Progress using Various Facilities
Report your Actual Costs: at both Levels
Track your Costs: at the Assignment Level
Track Material Consumption: at the Assignment Level
Track other Costs: at the Assignment Level

Top of Page