Project Performance Report Excel Template

							Page 1 of 2

Project Performance Metric Definitions
S# 1 2 3 4 5 6 7 8 9 10 11 12 Metric Budget at Completion Actual Cost Earned Value Planned Value Cost Variance Cost Performance Index Schedule Variance Schedule Performance Index Estimate to Completion Estimate at Completion Variance at Completion Status Abbrev. BAC AC EV PV CV CPI SV SPI ETC EAC VAC n/a Description Baseline project cost Total costs incurred in completing work during a given period Physical work completed during a given period Physical work scheduled for completion during a given period Cost overrun during a given period Cost efficiency ratio Schedule slipped during a given period Schedule efficiency ratio Expected additional cost needed Expected total cost Estimated cost overrun at end of project Average of CPI and SPI Status color key: GREEN = On track YELLOW = Slightly behind schedule/budget RED = Needs immediate attention BLACK = Needs to be killed or restored Formula/Value

EV-AC EV/AC EV-PV EV/PV EAC-AC BAC/CPI BAC-EAC (CPI+SPI)/2 1.0 0.85 but <1.0 0.65 but <0.85 <0.65

Page 1 of 2

Page 2 of 2

Project Performance Report
Budget Overall PV ($) BAC ($) 489 254 186 93 100 55 28 13 58 25 303 161 180 92 45 35 78 34 705 363 375 148 250 55 100 82 25 11 330 215 90 55 90 60 150 100 Earned EV ($) 225 90 50 14 26 135 80 20 35 405 210 125 70 15 195 60 50 85 Actual AC ($) 266 100 60 18 22 166 100 30 36 430 225 150 65 10 205 50 45 110 CV ($) (41) (10) (10) (4) 4 (31) (20) (10) (1) (25) (15) (25) 5 5 (10) 10 5 (25) Cost CV (%) -16% -11% -18% -31% 16% -19% -22% -29% -3% -7% -10% -45% 6% 45% -5% 18% 8% -25% Schedule SV ($) (29) (3) (5) 1 1 (26) (12) (15) 1 42 62 70 (12) 4 (20) 5 (10) (15) SV (%) -11% -3% -9% 8% 4% -16% -13% -43% 3% 12% 42% 127% -15% 36% -9% 9% -17% -15% Performance Index CPI 0.85 0.90 0.83 0.78 1.18 0.81 0.80 0.67 0.97 0.94 0.93 0.83 1.08 1.50 0.95 1.20 1.11 0.77 SPI 0.89 0.97 0.91 1.08 1.04 0.84 0.87 0.57 1.03 1.12 1.42 2.27 0.85 1.36 0.91 1.09 0.83 0.85 ETC 312 107 60 18 27 207 125 38 44 319 177 150 28 7 142 25 36 84 Forecast EAC 578 207 120 36 49 373 225 68 80 749 402 300 93 17 347 75 81 194 VAC (%) -18% -11% -20% -29% 15% -23% -25% -50% -3% -6% -7% -20% 7% 33% -5% 17% 10% -29% VAC ($) (89) (21) (20) (8) 9 (70) (45) (23) (2) (44) (27) (50) 7 8 (17) 15 9 (44) Average Index 0.87 0.93 0.87 0.93 1.11 0.83 0.83 0.62 1.00 1.03 1.18 1.55 0.97 1.43 0.93 1.15 0.97 0.81 Status YELLOW YELLOW YELLOW YELLOW GREEN RED RED BLACK GREEN GREEN GREEN GREEN YELLOW GREEN YELLOW GREEN YELLOW RED

S# Item Description A <Program A> A.1 <Project 1> A.1.1 <Deliverable 1> A.1.2 <Deliverable 2> A.1.n <Deliverable n> A.2 <Project 2> A.2.1 <Deliverable 1> A.2.2 <Deliverable 2> A.2.n <Deliverable n> B <Program B> B.1 <Project X> B.1.1 <Deliverable 1> B.1.2 <Deliverable 2> B.1.n <Deliverable n> B.2 <Project Y> B.2.1 <Deliverable 1> B.2.2 <Deliverable 2> B.2.n <Deliverable n>

Page 2 of 2