Info Tech Project/Team Management

Requirements Traceability Matrix

Project Name:

Project Number:

 V1

Project Manager:

Purpose: To manage requirements throughout the software development lifecycle. The Traceabilty Matrix ensures that requirements are captured in the design, implemented in the code, and verified by testing.

Task ID

Requirement Number

Requirement Description

Status

Release

Test Case

Design Component / Module

Comments

Responsibility Assignment Matrix

Enter a "X" if that individual is responsible for the WBS task.

Project Manager

Business Analyst

Report Developers

ETL Developers

Architect

Quality Assurance

Subject Matter Expert

Database Administrator

Developer

WBS Element

You

Kevin Smith

Roy Kirk

Corrina Kees

Rohn Laquanda

Joan Willmon

Trey Mattia

Ellena Borel

Ricarda Sienkiewicz

Walton Almeda

Jacqualine Water

Earned Value Calculation

Milestone Completion

Actual Cost (AC)

Actual % Complete (APC)

Planned % Complete (PPC)

Budgeted Cost at Completion (BAC)

Current

Earned Value (EV)

EV = BAC * APC

Planned Value(PV)

PV = BAC * PPC

Schedule Performance Index(SPI)

SPI = EV/PV

Schedule Variance (SV)

SV = EV - PV

Cost Performance Index (CPI)

CPI = EV/AC

Cost Variance (CV)

CV = EV - AC

Forecast

Estimated Cost at Completion(EAC)

EAC = BAC/CPI

Variance at Completion (VAC)

VAC = BAC - EAC

Estimated Cost to Complete (ETC)

ETC = EAC - AC

SPI

If < 1

Behind Schedule

If > 1

Ahead of Schedule

If = 1

On Schedule

CPI

If < 1

Over budget

If > 1

Under budget

If = 1

On budget