0% found this document useful (0 votes)
5 views2 pages

Project Performance Metrics Report

ty33
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views2 pages

Project Performance Metrics Report

ty33
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

PROJECT PERFORMANCE | REPORT DEFINITIONS

Budget Earned Actual Cost Schedule Performance Index Forecast

Overall
S# Item description P.V. ($) E.V. ($) A.C. ($) P.E.A. ($) C.V. ($) C.V. (%) S.V. ($) S.V. (%) C.P.I. S.P.I. E.T.C. E.A.C. V.A.C. (%) V.A.C. ($) Average index Status
B.A.C. ($)

A Program A 489 254 225 266 (41) -16% (29) -11% 0.85 0.89 312 578 -18% (89) 0.87 ORANGE

A.1 Project 1 186 93 90 100 (10) -11% (3) -3% 0.90 0.97 107 207 -11% (21) 0.93 ORANGE

A.1.1 Deliverable 1 100 55 50 60 (10) -18% (5) -9% 0.83 0.91 60 120 -20% (20) 0.87 ORANGE

A.1.2 Deliverable 2 28 13 14 18 (4) -31% 1 8% 0.78 1.08 18 36 -29% (8) 0.93 ORANGE

A.1.3 Deliverable 3 58 25 26 22 4 16% 1 4% 1.18 1.04 27 49 15% 9 1.11 GREEN

A.2 Project 2 303 161 135 166 (31) -19% (26) -16% 0.81 0.84 207 373 -23% (70) 0.83 RED

A.2.1 Deliverable 1 180 92 80 100 (20) -22% (12) -13% 0.80 0.87 125 225 -25% (45) 0.83 RED

A.2.2 Deliverable 2 45 35 20 30 (10) -29% (15) -43% 0.67 0.57 38 68 -50% (23) 0.62 BLACK

A.2.3 Deliverable 3 78 34 35 36 (1) -3% 1 3% 0.97 1.03 44 80 -3% (2) 1.00 GREEN

B Program B 705 363 405 430 (25) -7% 42 12% 0.94 1.12 319 749 -6% (44) 1.03 GREEN

B.1 Project 1 375 148 210 225 (15) -10% 62 42% 0.93 1.42 177 402 -7% (27) 1.18 GREEN

B.1.1 Deliverable 1 250 55 125 150 (25) -45% 70 127% 0.83 2.27 150 300 -20% (50) 1.55 GREEN

B.1.2 Deliverable 2 100 82 70 65 5 6% (12) -15% 1.08 0.85 28 93 7% 7 0.97 ORANGE

B.1.3 Deliverable 3 25 11 15 10 5 45% 4 36% 1.50 1.36 7 17 33% 8 1.43 GREEN

B.2 Project 2 330 215 195 205 (10) -5% (20) -9% 0.95 0.91 142 347 -5% (17) 0.93 ORANGE

B.2.1 Deliverable 1 90 55 60 50 10 18% 5 9% 1.20 1.09 25 75 17% 15 1.15 GREEN

B.2.2 Deliverable 2 90 60 50 45 5 8% (10) -17% 1.11 0.83 36 81 10% 9 0.97 ORANGE

B.2.3 Deliverable 3 150 100 85 110 (25) -25% (15) -15% 0.77 0.85 84 194 -29% (44) 0.81 RED
PROJECT PERFORMANCE | METRIC DEFINITIOREPORT
S# Metric Abbrev. Description Formula/Value Status Description Lower Value Limit

1 Budget at Completion Baseline project cost BLACK Needs to be killed or restored 0.00
B.A.C.
2 Actual Cost Total costs incurred in completing work during a given period RED Needs immediate attention 0.65
A.C.
3 Earned Value Physical work completed during a given period ORANGE Slightly behind schedule/budget 0.85
E.V.
4 Planned Value Physical work scheduled for completion during a given period GREEN On track 1.00
P.V.
5 Cost Variance Cost overrun during a given period
C.V. E.V.-A.C.
6 Cost Performance Index Cost efficiency ratio
C.P.I. E.V./A.C.
7 Schedule Variance Schedule slipped during a given period
S.V. E.V.-P.V.
8 Schedule Performance Index Schedule efficiency ratio
S.P.I. E.V./P.V.
9 Estimate to Completion Expected additional cost needed
E.T.C. E.A.C.-A.C.
10 Estimate at Completion Expected total cost
E.A.C. B.A.C./C.P.I.
11 Variance at Completion Estimated cost overrun at end of project
V.A.C. B.A.C.-E.A.C.
12 Status Average of CPI and SPI
n/a (C.P.I.+S.P.I.)/2
13 Planned, Earned, Actual Planned, Earned & Actual along with Sparkline
P.E.A.

Page 2 of 2

You might also like