Analysis - Southern Utah University

Download Report

Transcript Analysis - Southern Utah University

Estimating the Cost of a Defense Contract with Performance Indices Do the Old Methods Still Work?

David S. Christensen, Ph.D.

Southern Utah University (435)865-8058 [email protected]

Air Force Institute of Technology 20 May 2002

Overview

• Background – Earned Value Management Systems – Variance Analysis • Evaluating the EAC • Are the rules still valid?

Earned Value Management Systems (EVMS)

Links:

http://www.acq.osd.mil/pm

http://www.suu.edu/faculty/christensend/ev-bib.html

Cost Management Reports (DOD 5000.2-R)

Contract Cost Data Report Contract Fund Status Report Cost Schedule Status Report Cost Performance Report

Cost/Schedule Status Report

• Monthly • Cost thresholds(FY00$)

– Prod < $315 MIL – R&D < $73 MIL

• FFP contracts normally exempt

Cost Performance Report

• Monthly • Cost thresholds

– Prod > $315M – R&D > 73M

• FFP normally exempt • EVM criteria required

Objectives of EV Criteria

To provide insight into contract progress, implementing EVMS provides the program manager with data which: – Relate time-phased budgets to specific contract tasks/work; – Indicate work progress; – Properly relate cost, schedule, and technical accomplishment; – Are valid, timely, and auditable; – Supply managers with information at a practical level of summarization; and – Are derived from the same internal EMVS used by the contractor to manage the contract

Cost Performance Report

• Does it provide data or information?

• Is it reliable?

• Is it relevant?

Relevance

Decision Usefulness

Reliability Predictive Value EAC Feedback Value VARIANCE ANALYSIS Timely MONTHLY Verifiable A C CESS Valid Neutral SAME DATABASE OBJECTIVE DATA Comparability/Consistency Benefits > Costs THRESHOLDS, SUMMARY REPORTS DIDs, CWBS

THE BASIC DATA ELEMENTS

• Actual Cost of Work Performed (ACWP) $ • Budgeted Cost of Work Scheduled (BCWS) – aka “Planned Value” ACWP BCWS BCWP

Budgeted Cost of Work Performed (BCWP)

aka “Earned Value

” NOW TIME EAC BAC

THE BASIC DATA ELEMENTS

Estimate At Completion (EAC) Budget At Completion (BAC) $ EAC NOW ACWP BCWS BCWP TIME BAC

THREE VARIANCES

Variance at Completion = BAC - EAC Cost Variance = BCWP - ACWP Schedule Variance = BCWP - BCWS $ EAC VAC ACWP BCWS BCWP SV CV NOW TIME BAC

Performance Measurement Baseline (PMB)

$ EAC NOW ACWP

PMB

BCWS BCWP TIME BAC

1. IDENTIFY THE SCOPE OF W ORK

2. EXTEND TO W ORK PACKAGE LEVEL

DESIGN MATERIAL ORDER ASSEMBLY TEST 3. ARRANGE W ORK PACKAGES IN ORDER

JAN FEB MAR APR MAY JUN DESIGN MATERIAL ORDER ASSEMBLY TEST 4. SCHEDULE WORK PACKAGES

DESIGN MATERIAL ORDER ASSEMBLY LABOR 10 MATERIAL 2 OTHER 2 10 3 0 20 10 0 TEST 1 0 5 TOTAL 14 13 30 6 5. BUDGET THE W ORK PACKAGES

JAN FEB MAR APR MAY JUN DESIGN 2 9 3 MATERIAL ORDER ASSEMBLY 4 7 2 9 15 TEST 6. SPREAD BUDGET OVER TIME 5 3 1 3

JAN FEB MAR APR MAY JUN DESIGN 2 9 3 MATERIAL ORDER ASSEMBLY 4 7 2 9 15 TEST BCWS 2 13 19 17 7. CALCULATE MONTHLY BCWS 5 3 8 1 3 4

PERFORMANCE MEASUREMENT BASELINE (PMB )

60 50 40 30 20 10 0 JAN FEB 8. CREATE PMB MAR APR MAY JUN

Numerical Example

The Plan Build 5 sections of railroad track in 5 weeks for $5000

BCWS per week = ?

BAC = ?

Performance After two weeks, one section is completed for $2600

Cumulative ACWP = ?

Cumulative BCWS = ?

Cumulative BCWP = ?

EAC = ?

$

Numerical Example

EAC = ?

BAC = $ 5000 ACWP = $2600 BCWS = $2000 BCWP = $1000 2 Weeks 5 Weeks

Variance Analysis

An example from an aircraft project

AIA LASER SCANNER AIRCRAFT

Dollars in thousands WBS L Description 2 Air Vehicle 3 Air Frame 3 Avionics 3 Auto Flt Cont 3 Cent Integ 3 Aux Elec Eq 3 Wpns Deliv 2 NonStd Spt Eq 2 Sys T&E 3 Dev Tests 3 Mockups 3 T&E Support 3 Sys T&E Integ 2 Sys/Prog Mngt 2 Data 1 Acft Sys (Direct) Indirect G&A UB PMB MR Total 1-31 October, 1991 Cumulative BCWS 69171 62377 2896 260 1166 1688 784 396 36175 34210 854 635 476 15907 139 121788 57619 19735 BCWP 65533 58944 2780 248 1127 1689 745 414 33154 31165 897 616 476 15901 134 115136 54086 18614 199142 199142 187836 187836 ACWP 72611 66855 2425 242 877 1561 651 326 37160 35233 904 586 437 15274 119 125490 58000 20184 203674 203674 SV -3638 -3433 -116 -12 -39 1 CV At Completion BAC -7078 174269 LRE 177187 -7911 355 6 250 128 151900 6230 3941 3679 5014 155300 5900 3928 3639 4971 -39 18 -3021 -3045 43 -19 0 -6 -5 30 39 627 15 -6652 -10354 -3533 -1121 94 88 -4006 -4068 -7 -3914 -1570 -11306 -15838 -11306 -15838 3505 3474 92417 77800 1084 12700 833 34000 324 304484 127116 51297 2200 485097 32534 517631 3449 3474 96417 81800 1101 12700 816 33600 314 310992 131086 50502 2200 494780 21891 516671 -9683 10643 960 VAC -2918 -3400 330 13 40 43 56 0 -4000 -4000 -17 0 17 400 10 -6508 -3970 795

Level 4 detail supporting Level 3, Air Frame AIA LASER SCANNER AIRCRAFT

1-31 October, 1991 Dollars in thousands WBS L Description 4 Basic Struct 4 Flt Veh Power 4 Envi Cont Sys 4 Crew Station 4 A/V Design Spt 4 Eng Equip 4 Aux Control 4 Landing Gear 4 Integ/Assembly 4 A/V Tech Spt 3 Air Frame Cumulative BCWS 15500 10350 3057 9700 11600 2264 1830 591 2385 5100 62377 BCWP 14000 9900 2985 9056 11500 2240 1820 503 1940 5000 58944 ACWP SV 16812 -1500 11500 2660 -450 -72 12400 11500 2150 2000 -644 -100 -24 -10 514 2650 -88 -445 4669 -100 66855 -3433 CV -2812 -1600 325 At Completion BAC 51500 20000 6325 LRE 53000 21500 6450 -3344 0 90 -180 -11 -710 331 -7911 18700 15500 5850 6384 2950 15700 8991 151900 18800 15600 5800 6584 2986 15880 8700 155300 VAC -1500 -1500 -125 -100 -100 50 -200 -36 -180 291 -3400

Level 5 detail supporting Level 4, Crew Station AIA LASER SCANNER AIRCRAFT

1-31 October, 1991 Dollars in thousands WBS L Description 5 Cont & Display 5 Crew Accomoda 5 Crw Escape/Safety 5 Life Support 5 Crw Stat Integ 4 Crew Station Cumulative BCWS 3000 1400 3900 600 800 9700 BCWP 2900 1300 3500 586 770 9056 ACWP 3400 1800 5400 800 1000 12400 SV -100 -100 -400 -14 -30 -644 CV At Completion BAC LRE -500 -500 -1900 -214 -230 -3344 4800 3000 8000 1000 1900 18700 4400 3300 8000 1100 2000 18800 VAC 400 -300 0 -100 -100 -100

CREW ESCAPE AND SAFETY - Cost Account

Cost Element Labor Material A Material B Other BCWP 200,000 hours @ $7.80/hr 5,000 lbs @ $200/lb 16,000 lbs @ $50.00/lb .14 x Material A Analysis of Cost Variance (CV) by Element of Expense ($000) ACWP 234,000 hours @ $10.00/hr 8,000 lbs @ 187.50/lb 27,000 lbs @ $50.00/lb .14 x Material A Labor Material A Material B Other Total BCWP 1560.0

1000.0

800.0

140.0

3500.0

ACWP 2340.0

1500.0

1350.0

210.0

5400.0

CV -780.0

-500.0

-550.0

-70.0

-1900.0

Analysis of Cost Variance (CV) by Price and Usage ($000) Labor Material A Material B Other Total Price -514.8

100.0

0.0

14.0

-400.8

Usage -265.2

-600.0

-550.0

-84.0

-1499.2

CV -780.0

-500.0

-550.0

-70.0

-1900.0

Evaluating the Estimate At Completion Using Earned Value Performance Indices

Estimate At Completion(EAC)

• The EAC appears on the

Cost/Schedule Status Report

the

Cost Performance Report

• Accuracy controlled by EVMS Criteria • Factors to consider – Actual Costs to date – Performance to date – Cost and schedule variances – Reliability and relevance of data Overhead and Inflation rates Future performance on work Changes to requirements Organizational culture

EAC Formula

EAC = Costs to date + Estimated Cost of Remaining Work $ Predicted final cost Plan Cost to date Performance to date now Time

EAC Formula

EAC = ACWPcum + [(BAC - BCWPcum)/Performance Factor] $ EAC BAC ACWP BCWP now Time

Performance Factor

Usually a performance index: • CPI • SPI • Combination of CPI and SPI • w1(CPI) +w2(SPI), where w1 +w2 =1 • CPI x SPI

Cost Performance Index

Example Data BCWSc = $10 million BCWPc = $8 million ACWPc = $12 million BAC = $20 million LRE = $25 million CPI = BCWP/ACWP

= 8 / 12 = 0.67

Interpretation Cumulative, Current, Average

Schedule Performance Index

Example Data BCWSc = $10 million BCWPc = $8 million ACWPc = $12 million BAC = $20 million LRE = $25 million SPI = BCWP / BCWS

= 8 / 10 = 0.8

Interpretation Cumulative, Current, Average Value is 1 at end of contract

$

BCWS = BCWP = BAC when all work is completed

EAC BAC ACWP BCWS now BCWP Time

Combinations of CPI and SPI w1(CPI) + w2(SPI)

• .8(CPI) + .2(SPI) is an AF favorite • Always between CPI and SPI Example Data BCWSc = $10 million BCWPc = $8 million ACWPc = $12 million BAC = $20 million LRE = $25 million

.8 (.67) + .2 (.8) = 0.69

Combinations of CPI and SPI w1(CPI) + w2(SPI)

Sometimes based on Percent Complete: Weight .8

SPI CPI .2

0% 100%

Combinations of CPI and SPI CPI x SPI

• An OSD favorite Example Data BCWSc = $10 million BCWPc = $8 million ACWPc = $12 million BAC = $20 million LRE = $25 million • When CPI <1 and SPI < 1, SCI <<1

0.67 x 0.80 = 0.53

Twelve index-based EAC formulas

Index

CPI SPI w1(CPI) + w2(SPI) CPI x SPI

Monthly

x x x x

Cumulative

x x x x

Average

x x x x

Which one is best?

A-12 CPR Data (April 1990, $MIL) BCWS BCWP ACWP

2080 1491 1950

SV

-589

CV BAC LRE VAC

-459 4046 4400 -354

Index

CPI x SPI SPI .8CPI + .2SPI

CPI

Value

0.5481

0.7168

0.7551

0.7646

EAC

6,612 5,514 5,334 5,292

Which EAC is best?

Estimates at Completion A-12 Program

7 6.5

6 5.5

5 4.5

4 3.5

M ar -89 M ay 89 Ju l-89 Se p 89 N ov 89 Jan -90 M ar -90 SPIxCPI CPI3 CPI6 CPIcum Government Contractor

Evaluating the EAC

1. Compare the CV to the VAC CV -459 VAC -354 Implication LRE too small DOD Experience: Once a contract is more than 15-20% complete, the final overrun will be worse than the present overrun

(Christensen/Wilson 1992)

Evaluating the EAC

2.

Compare the CPI with the TCPI LRE CPI 0.7646

TCPI 1.043

Implication LRE is too small TCPI LRE = (BAC - BCWPcum) / (LRE - ACWPcum) = (4046 - 1491) / (4400 - 1950) DOD Experience:

Once a contract is over 20% compete, the cum CPI does not change by more than 10 percent, and in most cases it only worsens

(Christensen/Heise 1993)

Evaluating the EAC

3.

Compare to a range of independent EACs LRE 4400 IEAC floor 5292 IEAC ceiling Implication 6612 LRE is too low DOD Experience

CPI-based EAC is floor to final cost SCI-based EAC is often the most accurate estimate

(Christensen 1996)

Evaluating the EAC

DOD Experience: No single EAC formula is always best.

(Christensen, Antolini, McKinney 1992)

Navy (Covach, et al., 1981 14 Development, 13 Production)

State of completion Best index-based formula

Early (0-40%) Middle (20-80%) Late (60-100%) CPI3, CPI6, SCIc CPI3, CPI6, CPIc, SCI CPI3, CPI6, CPI12

Army (Howard and Bright, 1981, 11 Develoment)

State of completion Best index-based formula

Early (0-40%) Regression, Composite, SPIc, SCI Middle (31-80%) Late (81-100%) CPI3, CPI6, CPI12, SCI CPIc, SCI

Evaluating the EAC

DOD Experience: No single EAC formula is always best.

(Christensen, Antolini, McKinney 1992)

Air Force (Riedel and Chance, 1989 16 Development 40 Production)

Phase

Devel Prod Devel Prod Devel Prod

System

Aircraft Aircraft Avionics Avionics Engine Engine

25%

SCIc SCIc SCIc 20/80 CPImon PC

50%

CPI3 CPI3 CPI3 SCIc SCIc CPIc

75%

CPI3 SCIc SCIc 20/80 CPI3 SCIc

100%

20/80 CPIc CPIc SCIc CPI3 PC

Overall

SCIc SCIc CPI3 20/80 CPI3 CPIc

Organizational Culture and the EAC

• Accuracy controlled by EVMS Criteria • Factors to consider – Actual Costs to date – Performance to date – Cost and schedule variances – Reliability and relevance of data Overhead and Inflation rates Future performance on work Changes to requirements

Organizational culture

Organizational Culture and the most likely EAC

• Program managers do not support EACs most likely to be experienced on their programs.

• Instead they support EACs most likely to be tolerated by OUSD and Congress.

Estimates at Completion A-12 Program

7 6.5

6 5.5

5 4.5

4 3.5

M ar -89 M ay 89 Ju l-89 Se p 89 N ov 89 Jan -90 M ar -90 SPIxCPI CPI3 CPI6 CPIcum Government Contractor

Why were the contractor and government EACs the smallest?

EAC Comparisons (64 contracts) 0.05

0 -0.05

-0.1

-0.15

-0.2

-0.25

10 20 30 40 50 60 70 Percent Complete 80 90 100

How did the government and contractor estimates compare to this range?

(Christensen, 1996)

EACsci EACcpi

EAC Comparisons (64 contracts) 0.05

0 -0.05

-0.1

-0.15

-0.2

-0.25

10 20 30 40 50 60 70 80 90 100 Percent Complete

(Christensen, 1996)

EACsci EACgov EACcon EACcpi

Overrun Optimism (64 Contracts) 22 20 18 16 14 12 10 8 6 4 2 0 -2 10 Current Overrun Est Final Overrun(G) Est Final Overrun(K) 20 30 40 50 60 70 80 Percent Complete (Christensen, 1994) 90 100

EAC Evaluation Methods: Do They Work On Post-A12 Contracts?

David S. Christensen, Carl Templin, and David Rees Southern Utah University (435)865-8058 [email protected]

2002 National Conference of the Society of Cost Estimating and Analysis Scottsdale, Arizona (June 11-14, 2002)

References

• Christensen, David S. and Carl Templin. “EAC Evaluation Methods: Do They Still Work?” Acquisition Review Quarterly (forthcoming) • Christensen, David S., and David A. Rees. “Is The CPI-based EAC a Lower Bound to the Final Cost of Post-A12 Contracts?” Journal of Cost Analysis and Management (forthcoming) • Earned value literature bibliography: http://www.suu.edu/faculty/christensend/ev-bib.html

Background

• A-12 cancellation – a catalyst for change – The A-12 EAC was too low – Realistic EACs were suppressed – DOD-wide epidemic (Beach 1992) • DoD policy changes to achieve cost realism – Have not worked previously (Drezner et al 1993) – Will they work this time?

Background

• Current reform initiatives are improving cost performance (Coopers and Lybrand 1997) • Methods to evaluate EACs which assume deteriorating cost performance may no longer be valid

EAC Evaluation Rules

• 1.

2.

• 3.

The final cost variance (in dollars or as a percentage) will be worse than the cost variance at the 20 percent completion point The cumulative cost performance index (CPI) will not change by more than 0.10 from its value at the 20 percent completion point, and in most cases only worsens The EAC computed using the cumulative CPI is a reasonable lower bound to final cost Based on observations made by OUSD; validated by researchers at AFIT on contracts completed in 1970s and 1980s; cited by Beach A12 Example – CV 20 – CPI 20 – = -$459M Estimated Final Cost Variance = -$354M = 0.765 To Complete Performance Index = 1.043

CPI-based EAC = $5,292M Contractor EAC = $4,400M

Hypotheses

• The final cost variance will be worse than the cost variance at the 20% completion point CV$ final CV% final – CV$ 20 < 0 – CV% 20 < 0 CV$ = Earned Value – Actual Cost CV% = (CV$ / Earned Value) x 100

Hypotheses

• The cumulative CPI will not change by more than 0.10 from its value at the 20% completion point, and in most cases only worsens |CPI final CPI final – CPI 20 | < 0.10

– CPI 20 < 0 CPI = Cumulative Earned Value / Cumulative Actual Cost

Hypotheses

• The EAC computed using the cumulative CPI is a reasonable lower bound to final cost CPI-based EAC < Final Cost • To control for differences in contract size, DAC < 0 EAC = (BAC – Earned Value)/ Cum CPI + Actual Cost Deviation at completion (DAC) = (EAC – Final Cost) / Final Cost

More Definitions

• CV 20 • CV final = Cumulative CV at 20 percent completion point = Cumulative CV at end of contract • CPI 20 • CPI final = CPI at end of contract = CPI at end of contract • Percent Complete = Cumulative Earned Value / BAC

Hypothesis testing

• Averages of the differences were computed and hypotheses were tested at alpha of .05 using paired-t test • Sensitivity of results were tested across – Contract phase (development versus production) – Contract type (fixed price versus cost reimbursable – Managing service (Army, Air Force, Navy)

The data

• DAES database – Based mostly on CPR data – Its reliability is controlled via EVMS Criteria • Every completed contract was included with actual cost, earned value, and BAC at 20% complete and at completion, resulting in – 147 pre-A12 contracts (finished before A12 cancellation) – 52 post A12 contracts (started after A12 cancellation) – 42 “transition period” contracts (started before and finished after A12 cancellation) • 31 Dec 91, about one year after the A-12 cancellation, was chosen as the cut-off date

Results

• Cost variances did not worsen significantly on Post-A12 contracts from the 20% completion point • The cumulative CPI is a reasonable floor to final cost in the early and middle stages of contract life on Post-A12 contacts • Cost performance during the Transition period contracts was worse than cost performance during Pre-A12 and Post-A12 periods • Results generally insensitive to contract size, contract phase, and military service

The Final Cost Variance Will Be Worse Than The Cost Variance At The 20 Percent Completion Point

0.00

-50.00

-100.00

-150.00

Cost Variance ($MIL)

CV$20 CV$final Pre-A12 Transition Post-A12 n CV$20 CV$final Difference Significance Pre-A12 Transition 147 -0.80

-12.2

-11.4

0.000

41 -3.40

-120.8

-117.4

0.000

Post-A12 52 -3.00

-15.8

-12.8

0.008

The mean CV$ worsened significantly for each period of contracts (but CV$ is not adjusted for contract size and inflation) 0.00

-5.00

-10.00

-15.00

Cost Varince (Percentage)

CV%20 CV%final Pre-A12 Transition Post-A12 n CV%20 CV%final Difference Significance Pre-A12 Transition 147 -1.70

-6.5

-4.8

0.000

41 -2.00

-13.9

-11.9

0.000

Post-A12 52 -2.60

-4.4

-1.7

0.286

The mean CV% worsened significantly for Pre-A12 and Transition period contracts but not for Post-A12 contracts

The Final Cumulative CPI Will Not Change By More Than 0.10 From Its Value At The 20% Completion Point, And In Most Cases It Only Worsens Mean Absolute Deviation (MAD) of the Cumulative CPI

0.150

0.100

0.050

0.000

Pre-A12 Transition Post-A12 n MAD Significance Pre-A12 Transition 147 41 0.085

0.000

0.117

0.487

Post-A12 52 0.067

0.000

The "10% rule" is valid on Pre-A12 and Post-A12 contracts, but not on Transition period contracts

Cumulative Cost Performance Index

CPI20 CPIfinal 1.050

1.000

0.950

0.900

0.850

0.800

Pre-A12 Transition Post-A12 n CPI20 CPIfinal Difference Significance Pre-A12 Transition 147 0.996

0.951

-0.045

0.000

41 0.990

0.896

-0.094

0.000

Post-A12 52 0.977

0.964

-0.013

0.286

The mean cumCPI worsened for Pre-A12 and Transition period contracts, but not for Post-A12 contracts

The Cumulative CPI-based EAC Is A Floor To Final Cost

0.0% -5.0% -10.0% -15.0% -20.0% -25.0% -30.0%

Deviation at Completion (147 pre-A12 contracts)

Early Middle

Contract Stage

Late Pre-A12 Significance Early -10.3% 0.000

Middle -0.2% 0.475

Late -0.2% 0.4535

Deviation at Completion (41 Transition Contracts)

0.0% -5.0% -10.0% -15.0% -20.0% -25.0% -30.0% Transition Significance Early Middle

Contract Stage

Late Early -24.3% 0.000

Middle -11.2% 0.000

Late -5.7% 0.005

Deviation at Completion (52 Post-A12 Contracts)

0.0% -5.0% -10.0% -15.0% -20.0% -25.0% -30.0% Post-A12 Significance Early Middle

Contract Stage

Late Early -10.7% 0.001

Middle -4.4% 0.020

Late -1.9% 0.215

Conclusion

• Cost performance on post-A12 contracts is improving • The A-12 cancellation changed the acquisition culture • The EAC evaluations should continue to be used • Acquisition reform initiatives can adversely affect cost performance of on-going contracts