Cost Estimate

---

Overview

General Guidance
BY17 IT Data Call
Activities
Variance

---

Sheet 1: General Guidance

---

Sheet 2: BY17 IT Data Call

	Name		FHWAX077: Congestion Mitigation and Air Quality System (CMAQ)
	Lifecycle Timeframe
	Enter the Year the Investment or Web Site was Initiated						Enter the Year of the Estimated End of Useful life for this Investment or Web Site
	Start Year		2002				End Year		2017
	Status		Active
	Business Contact Information
	Position		Name		Org.		Phone		Email
	Executive Business Sponsor		Gloria Shepherd		HEP-1		202-366-0116		[email protected]
	Investment or Web Owner		Mark Glaze		HEPN-10		202-366-4053		[email protected]
	Investment or Web Manager		James Lieu		FHWA-HAIM-43		202-493-0104		[email protected]
	Description
	Description: The Congestion Mitigation and Air Quality (CMAQ) Improvement Program Project Tracking System is a repository for data submitted by states regarding the expenditure of program funds on air quality beneficial transportation projects. End uses include reports to Congress and internal program management.
	Government Full Time Equivalent (GFTE) Estimates:
	Enter the Grades and Percentages of time that Government staff will spend directly on the investment or web site. Enter a separate entry for each unique Grade.
	Examples: If two GS-13s will spend 20% of their time on O&M activities, enter 40% in the O&M column. If one GS-14 will spend 5% of his or her time on new development, enter 5% in the DME column.
	Last Year's Data Call (CY16): GFTE Costs (pre-populated)						Current Submission (BY17) GFTE Salary based upon OPM Salary Table (Effective January 2015)						ACTIVITIES
	GRADE	DME %	DME GFTE Costs	O&M %	O&M GFTE Costs		Select Grade	DME %	DME GFTE Costs	O&M %	O&M GFTE Costs		Investments with DME costs must have breakout of DME related activities on the Activities tab.
	15	10%	$19,301	0%	$-		15	10%	$19,886		$-
	14	30%	$49,225	10%	$16,408		14	30%	$50,718	10%	$16,906
	0	0%	$-	0%	$-				$-		$-
	0	0%	$-	0%	$-				$-		$-
	0	0%	$-	0%	$-				$-		$-
	0	0%	$-	0%	$-				$-		$-
	GFTE Costs		$68,527		$16,408		Total		$70,604		$16,906
	Total GFTE Costs		84,935				Total GFTE Costs		87,510
	*** BUDGET REQUEST - Enter 2017 Budget Estimates. Please do NOT include GFTE cost in Estimates****
	Last Year's Data Call (CY16): Budget Request (pre-populated)						Current Submission (BY17)
	Funding Source			DME	O&M		Funding Source			DME	O&M
	OITS PROGRAM OFFICE GOE			$-	$-		OITS PROGRAM OFFICE GOE			$-	$-
	OITS PROGRAM OFFICE GOE - Task Lead			$-	$9,948		OITS PROGRAM OFFICE GOE - Task Lead			$-	$10,000
	PROGRAM OFFICE GOE			$-	$-		PROGRAM OFFICE GOE			$-	$-
	RESEARCH FUNDS			$-	$30,000		RESEARCH FUNDS			$-	$30,000
	PROGRAM FUNDS			$-	$-		PROGRAM FUNDS			$-	$-
	PROGRAM FUNDS - IT Support (FLH only)			$-	$-		PROGRAM FUNDS - IT Support (FLH only)			$-	$-
	TOTAL (excludes GFTE)			$-	$39,948		TOTAL (excludes GFTE)			$-	$40,000
	TOTAL GFTE COSTS (Populated from GFTE section)			$68,527	$16,408		TOTAL GFTE COSTS (Populated from GFTE section)			$70,604	$16,906
	TOTAL BUDGET REQUEST plus GFTE COSTS			$68,527	$56,356		TOTAL BUDGET REQUEST plus GFTE COSTS			$70,604	$56,906
	TOTAL BUDGET REQUEST			124,883			TOTAL BUDGET REQUEST			127,510
	#NAME?
	BY2016 - 2017 Summary
		2016	2017
	DME	$68,527	$70,604
	O&M	$56,356	$56,906
		$124,883	$127,510

---

Sheet 3: Activities

ACTIVITIES

INSTRUCTIONS

General Guidance: The activity data required is a new requirement for all investments in the BY 2017 data call. Only DME activities require details to be reported on this tab. O&M data will be pulled from the IT Data Call tab. The following guidance is specific to the data field within the form. Please do not hesitate to contact the FHWA CPIC Team at [email protected] should you require additional guidance. A project schedule is typically used to populate this tab.

Activity Name/Description: Describe each activity for the investment or web site that started in 2015 or earlier and are not yet completed. Also add any activities that are scheduled to start in 2016 and 2017.

Activity Work Breakdown Structure (WBS): A WBS is a key project deliverable that organizes the team's work into manageable sections. Provide the high levels of the WBS to align with project activities. An example of WBS numbering is 1.0 (investment) and 1.1 or 1.1.2 (activities). You can enter as many levels as needed.

Key Deliverable: Select the applicable deliverable for each activity. Each deliverable must be at intervals of no more than six months in duration.

Baselined Dates and Costs: Enter the dates and costs for each activity. These dates and costs set your schedule and cost baseline.

Estimated Dates and Costs: Provide the estimated dates and costs for all ongoing and future activities (Note: On-going activities should have actual start dates provided; however the completion dates and costs may still only have projections).

Actual Dates and Costs: When an activity has started and/ or completed, provide the associated actual dates and costs.

Activity Status: Select "Active" for all completed/ongoing/future activities. Select "Deactivated" if rebaseline or other events require the removal of activities that are no longer in scope.

Adding additional rows: If additional rows need to be added: In the O&M Activities section – (1) click on the number “22” for row 22 and ‘right click’ on your mouse. (2) Click “Insert.” (3) Repeat this as many times as necessary to add the desired number of rows. In the DMS Activities section – follow the procedures for O&M above, only modifying the guidance for the associated row number.

Note: Security patches, upgrades, and related activities are covered in FHWA IT Security Investment

FHWAX077: Congestion Mitigation and Air Quality System (CMAQ)

DME Activities

Suggested Activities are listed; however, fields can be modified to accurately reflect Development activities.

#

Activity Name

Activity Description

Activity WBS

Key Deliverable

Start Date (Baseline)

Start Date (Estimate)

Start Date (Actual)

Completion Date (Baseline)

Completion Date (Estimate)

Completion Date (Actual)

Total Costs (Baseline)

Total Costs (Estimate)

Total Costs (Actual)

Activity Status

1

Requirements Definition

Determine functional requirements for all areas of the application

2

Design

Determine features and operations in detail, including screen layouts, business rules, process diagrams, pseudo code and other documentation.

3

Development & Testing

Develop and test all software which supports the process of establishing and modifying the system

4

Acceptance & Implementation

Software is accepted and put into the production environment

5

6

7

8

---

Sheet 4: Variance

Investment		FHWAX077: Congestion Mitigation and Air Quality System (CMAQ)
BY 2017 - Variance Justification
CY16 Budget Request	$124,883
10% of Total CY16 Budget Request	$12,488	Variance Justification Requirement The 10% is calculated using the CY16 Total Budget Request.
BY17 Budget Request	$127,510	ATTENTION: BY17 is under 10% of CY16 - Justification Required
$112,394.68	2.10%	Variance %
$137,371.28