Earned Value Management Report Form

Environmental Public Health Tracking Network (Tracking Network)

Att5d_EarnedValueManagementReport_Form.xls

Earned Value Management Report

OMB: 0920-1175

Document [xlsx]
Download: xlsx | pdf

Overview

OMB
WBS
EVA


Sheet 1: OMB




































































































































































































































































Sheet 2: WBS

Environmental Public Health Tracking's goal is to improve environmental health surveillance nationally and locally to better identify and mitigate health effects resulting from environmental exposures.


A successful Tracking program will provide tools, informations, and strategies that may help to decrease the chronic disease burden resulting from environmental exposures


HHS: Provide work breakdown structure (WBS) tasks at a single WBS level in the “tasks” column that is appropriate to the size and complexity of the investment. The next page provides a simple example of WBS reporting level. The spreadsheet does not provide for reporting multiple levels within the WBS. There is currently room for 34 tasks. Provide the number of tasks that, once again, is appropriate to the size and complexity of the investment. CDC: Use the WBS reported in the Exhibit 300. If one or more of the milestones/workpackages are comprised of very large dollar values (e.g. $1 million or more), consider de-composing that workpackage into separate tasks and reporting at that level. DME vs. O&M – Definitions can be found in Exhibit 300 instructions on page 300-5. Do not report O&M workpackages, only DME workpackages. TASK - Activities to be Implemented BAC: This is the total planned cost for that particular task or Budget At Completion (BAC). BAC (planned) Planned Start date Planned End Date Total Months Provide the Budgeted Cost of Work Scheduled (BCWS) for each task as of the start of the budget period. This is the cumulative planned cost for that task. BCWS Provide the Actual Cost of Work Performed (ACWP) for each task to-date, or as of end of budget period. ACWP Provide the percentage PLANNED completed for that task as of the REPORTING DATE. % PL. COMP Provide the percentage ACTUALLY completed for that task as of the end of budget period. % ACT COMP Budged Cost of Work Performed (BCWP). This is the Earned Value BCWP Program Name:




























0 $0.000


$- CDC NEPHT Program




0 $0.000


$-





0 $0.000


$- OPDIV: CDC/NCEH; EHHE




0 $0.000


$-





0 $0.000


$- Enter the "as of date" for this EVA to show date of latest update. December 15, 2008
















0 $0.000


$-





0 $0.000


$-





0 $0.000


$-





0 $0.000


$-





0 $0.000


$-





0 $0.000


$-





0 $0.000


$-





0 $0.000


$-





0 $0.000


$-










$-





0 $0.000


$-





0 $0.000


$-





0 $0.000


$-





0 $0.000


$-

Total poe0: Must total your annual budget award $0.000


$0.000 $0.000

$-


BAC


BCWS ACWP

BCWP


























Response









Criteria to meet this performance measure: 1. Infrastructure is in place to access data for core nationally consistent measures and data, and 2. Relationships/agreements with necessary data owners have been established and data necessary to calculate core measures have been received, and 3. Core nationally consistent measures and data are available through role-based access on the State Tracking Network For example, state X has the infrastructure to support the exchange of EPHT environmental and health data for core measures between data partner X and state X. State X has access to the necessary data from the data owner and has processed the data to allow controlled access to EPHT environmental and health data for core measures. Complete by: State, Local











Clarification: Any of the following are examples of components of a public health action: action to identify populations at risk, respond to outbreaks, clusters and emerging threats; establish the relationship between environmental hazards and disease; guide intervention and prevention strategies; identify, reduce and prevent harmful environmental risks; improve the public health basis for policymaking; enable the public’s right to know about health and the environment; inform legislators, policy makers, communities, and/or individuals regarding potential environmental health risks. If you have previously reported this information in a past progress report or cooperative agreement template, please reference the name and date of the report. Title: (Specific enough to allow reader to understand what the action was) Please address each of the following by including your response under each question: 1) What was the problem/situation? 2) How was Tracking involved? 3) What action was taken to resolve the problem?































































































































































































Legend:










Budget At Completion (BAC)










Budgeted Cost of Work Scheduled (BCWS)










Budgeted Cost of Work Performed (BCWP)










Actual Cost of Work Performed (ACWP)










Cost Variation (CV)










Schedule Variation (SV)










Earned Value Analysis (EVA)










Work Breakdown Structure (WBS)










Program Management Tool (PMT)











Sheet 3: EVA


The Following Cells Are Formula-Driven Based On Your Work Packages Entered Above










Budget At Completion (BAC)


0.00






Budgeted Cost of Work Scheduled (BCWS)


0.00






Budgeted Cost of Work Performed (BCWP)


0.00






Actual Cost of Work Performed (ACWP)


0.00






COST VARIANCE










Cost Variance in $


0.00 Cost Variance = BCWP - ACWP (negative value = over budget)





Cost Variance %


#DIV/0! Cost Variance Percentage = (CV / BCWP)





CPI-Cost Performance Index (On 1-to-100 Scale)


#DIV/0! Cost Performance Index = BCWP / ACWP





SCHEDULE VARIANCE










Schedule Variance in $


0.00 Schedule Variance=BCWP - BCWS (negative value = behind schedule)





Schedule Variance %


#DIV/0! Schedule Variance Percentage = (SV / BCWS)





SPI-Schedule Performance Index (On 1-to-100 Scale)


#DIV/0! Schedule Performance Index = BCWP / BCWS





FORECAST FOR FUTURE PERFORMANCE










Best Case Estimate (EAC1)










Estimate At Completion - Best Case (EAC1)


#DIV/0! EAC1 = ACWP + (BAC - BCWP) / CPI





Variance At Completion - Best Case (VAC1)


#DIV/0! VAC1 = BAC - EAC1





Variance At Completion % - Best Case (VAC1%)


#DIV/0! VAC1 % = (VAC1/BAC)





Worst Case Estimate (EAC2)










Estimate At Completion - Worst Case (EAC2)


#DIV/0! EAC2 = ACWP + (BAC - BCWP) / (CPI * SPI)





Variance At Completion - Worst Case (VAC2)


#DIV/0! VAC2 = BAC - EAC2





Variance At Completion % - Worst Case (VAC2%)


#DIV/0! VAC2 % = (VAC2/BAC)





End-of-Project Estimates










Expected Funds to Completion


#DIV/0! ((EAC1+EAC2)/2)-ACWP (Avg of high & low EAC minus ACWP)





Expected Completion Month/Year


07/312009





File Typeapplication/vnd.ms-excel
Authorpoe0
Last Modified BySID
File Modified2016-07-01
File Created2008-06-13

© 2024 OMB.report | Privacy Policy