Baseline % Complete with RAG indicator

[vanmi]

Good day Experts,
I'm trying to create a RAG indicator based on project progress. That is to RAG a work activity that is tracked against the predicated workload at time of observation (baseline estimate at that time), against the actual time delivered). For example, the baseline estimate is 20 days. At time 10 days the baseline estimate is (10/20) = 50% supposed to be completed. Then actual is e.g. 30% at time 10. Therefore the project has predicated to have slipped. The Red, Amber, Green should be able to be set for this measurement at a percentage level. If 0% variance or in front of delivery it is "GREEN", if it is 10% behind at time T, it is amber, and if it is more than 20% it is Red. Then also futher indicators that you would deem is the best way to determine the risk on delivery of the work activity

[ProjectPlanner]

These 2 blog posts should help you.

1. Microsoft Project Baseline Percent (%) with Weighted Summary Roll-up This will show you how to set-up a custom field for baseline %
2. Microsoft Project Progress Status Traffic Light (RAG Status)This will show you how to set-up a RAG but instead of using the default % complete field as shown in the blog post, use the baseline % from #1 above for the RAG.