Monthly Status Report Template V0.2

1
SMS-TO3 January 30, 2004 Project Review
Presented to NDOT Safety Engineering by IMGS Dav
id Doerter Friday, February 6, 2004
SMS Monthly Status Report Version 0.5 January 30,
2004
2
Revisions
3
Contents

• Project Overview
• Status Overview
• Current Stage
• Project Indicators
• Critical Issues
• Cost Status
• Technical and Schedule Status
• Issues and Concerns
• Risks
• Document List
• Summary and Discussion

4
Project Overview
5
Project Overview
6
Project Overview Description

• Project Description
• SMS is a multi-phased project to develop a
  Statewide Roadway Safety Management System to
  compile and analyze statewide crash data,
  inventory high crash locations, analyze crash
  causation, model solutions, evaluate, and program
  overall roadway safety at NDOT.
• Business Problem Solved
• Plan, design, construct, and implement a computer
  system to replace outdated existing legacy
  system.

7
Project Overview -Organization
8
Status Overview
9
Status Overview
1
2
NA
10
Status OverviewInc. Oversight Task

• Tasks 4 LRS Migration, 5 Event Migration, 8
  Maintenance Report, 11 HAL Prototype
• Task Description
• Issue Tasks are behind schedule and will run
  past the contract end date of January 31, 2004.
• Impact
• Recommended Action Continue work until
  complete.
• New Direction None. Estimate that project is
  within weeks of completion.

11
Status OverviewCritical Task

• Tasks All tasks except Kick-off, JumpStart
  Support, and CrossRoads Coordination.
• Task Description
• Issue Costs for tasks exceed budgeted estimates
  due to unanticipated difficulty with data
  migration effort and underestimation of effort to
  perform tasks.
• Impact IMGS project financial difficulty.
  Underestimation of effort also negatively impacts
  schedule. No cost impact to NDOT.
• Recommended Action Continue to perform work
  necessary for a successful project.
• New Direction None. Estimate that project is
  within weeks of completion.

12
Cost Status
13
Cost Status Overview

• SMS Task Order 3 (5) - (awarded 01/01/03, PoP
  thru 10/31/03, extended to 1/31/04)
• Total Funding Available 305,050
• Less Expended (as of 10/31/03) 299,616
• Funding Remaining 5,434
• Monthly Burn Rate Estimated at 23.5K (Travel
  Estimate Labor Estimate)
• Remaining Funding Estimate (through 1/31/04)
• 0.23 months of funding remain to cover 0
  remaining project months (Funding Remaining /
  Burn Rate)
• Travel Estimate - 5,399
• Labor Estimate - 35

14
Invoice Status

• Invoice Status
• Total Invoiced thru 11/28/03 244,688.75
• Invoice MPJ0003445 (pd.) 15,852.70
• Invoice MPJ0003587 (pd.) 18,515.00
• Invoice MPJ0003877 (pd.) 18,697.50
• Invoice MPJ0003994 (pd.) 16,692.50
• Invoice MPJ0004164 (pd.) 13,446.56
• Invoice MPJ0004438 (pd.) 76,702.50
• Invoice MPJ0004738 84,781.99
• Total Paid 159,906.76
• Net Outstanding 84,781.99

15
Budget / ActualComparison by TASK
Note Travel and expenses are not current and
will be updated after IMGS updates invoicing.
Believe travel is actually 100 used..
16
Cost Status Summary
(Cumulative)
17
Technical and Schedule Status
18
Schedule Status By Task
1Q03
4Q03
1Q04
2Q04
3Q03
2Q03
TASK
Kick-off
1/03
3/03
Req Update
2/04
ATP
12/03
LRS Data
2/04
Event Data
2/04
Training
8/03
Support
4/04
Maint Req
2/04
Coordinate
11/03
Project Mgt
2/04
HAL P-Type
2/04
Baseline Original Plan LRE Latest Revised
Estimate
19
Schedule Status - Deliverables
20
Schedule Status Deliverables (cont.)
21
Issues and Concerns
22
Issues and Concerns

• Concern See critical tasks.
• Cause
• Impact
• Corrective Action / Recommendation
• Get Well Date

23
Risks
24
Risks
25
Risks
26
Document List
27
Document List
28
Document List
29
Document List
30
Document List
31
Document List
32
Document List
33
Summary Comments