OE Recovery Act Financial Assistance Grants

---

Overview

Financials
JobData
Impact Metrics
RLS
Guidance&Definitions

---

Sheet 1: Financials

This data is being collected to ensure the Department of Energy meets public transparency and accountability standards for Recovery Act funds. Monitoring and tracking the progress of Recovery Act supported projects and Recovery Act recipients contribution to creating U.S. jobs.

Public reporting burden for this collection of information is estimated to average 2 hrs to complete the entire worksheet, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of Information Resources Management Policy, Plans, and Oversight, Records Management Division, HR-422 - GTN, Paperwork Reduction Project (1910-5148), U.S. Department of Energy, 1000 Independence Avenue, S.W., Washington, DC 20585; and to the Office of Management and Budget (OMB), Paperwork Reduction Project (1910-5148), Washington, DC 20503.

1. Planned and Actual Monthly Financial Expenditures

FY 10

FY 11

FY 12

FY 13

FY 14

FY 15

Program Office

Recipient Name

Award Value

FY 09

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

EERE

XXXX

$xxx

Obligation

Planned

Actual

Outlay

Planned

Actual

---

Sheet 2: JobData

2. Job Data

Project Details

Federally Funded Cummulative FTE

Non-Federal Funding Cummulative FTE

Project Name

Project Code

Total FTE

Prime Contractor Total FTE

Sub Contractor Total FTE

Prime Financial Assitance Recipient Total FTE

Sub Financial Assitance Recipient Total FTE

Total Cost-share/Matching FTE

Public reporting burden for this collection of information is estimated to average 2 hrs to complete the entire worksheet, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of Information Resources Management Policy, Plans, and Oversight, Records Management Division, HR-422 - GTN, Paperwork Reduction Project (1910-5148), U.S. Department of Energy, 1000 Independence Avenue, S.W., Washington, DC 20585; and to the Office of Management and Budget (OMB), Paperwork Reduction Project (1910-5148), Washington, DC 20503.

---

Sheet 3: Impact Metrics

3. Progress Toward Project Completion Against Planned Milestones

FY 10

FY 11

FY 12

FY 13

FY 14

FY 15

Milestone

Description

Lifetime Value/ Completion Milestone

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Project Start Date

Construction

Operation Begin

Annual tons of CO2e emissions abated

Tons of CO2e emissions abated

MW of coal with CCS capacity

Public reporting burden for this collection of information is estimated to average 2 hrs to complete the entire worksheet, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of Information Resources Management Policy, Plans, and Oversight, Records Management Division, HR-422 - GTN, Paperwork Reduction Project (1910-5148), U.S. Department of Energy, 1000 Independence Avenue, S.W., Washington, DC 20585; and to the Office of Management and Budget (OMB), Paperwork Reduction Project (1910-5148), Washington, DC 20503.

---

Sheet 4: RLS

4. Resource Loaded Schedule

Resource Loaded Schedule (RLS) Summary (Cost and Schedule Performance Data)

Project XYZ

Actual Start Date ___________________ Completion Date ___________________

TOTAL PLANNED COST ($M):

____________

ACTUAL COSTS (MONTH/QTR):

____________

ACTUAL COSTS (CUM):

____________

CPI (MONTH/QTR)

CPI (CUM)

SPI (MONTH/QTR)

SPI (CUM)

PERCENT COMPLETE

ESTIMATE TO COMPLETE ($M)

CPI = Cost Performance Index

SPI = Schedule Performance Index

VARIANCE ANALYSIS (i.e. EXPLANATION FOR CPI AND SPI VALUES THAT ARE LESS THAN 0.9 OR GREATER THAN 1.1)

Public reporting burden for this collection of information is estimated to average 2 hrs to complete the entire worksheet, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of Information Resources Management Policy, Plans, and Oversight, Records Management Division, HR-422 - GTN, Paperwork Reduction Project (1910-5148), U.S. Department of Energy, 1000 Independence Avenue, S.W., Washington, DC 20585; and to the Office of Management and Budget (OMB), Paperwork Reduction Project (1910-5148), Washington, DC 20503.

---

Sheet 5: Guidance&Definitions

Technical Guidance on Reporting Internal DOE Recovery Act Jobs per Memo M-01-01
•On 9/15/09, the Department of Energy issued guidance requiring Program Offices to collect certain information about jobs created or retained under the Recovery Act. In response to follow-up questions about this guidance, CFO/PA&E has developed this template to help create a uniformed standard for Program Offices to provide this information to CFO/PA&E. These data will better enable the Department to track the number of actual jobs created under the Recovery Act and transparently show the American public how these programs are helping create jobs and spur sustainable, economic growth. Per the guidance, Program Offices are asked to report jobs created or retained, using OMB-established definitions for FederalReporting.gov. The guidance is attached to this spreadsheet. If a Program Office already uses an existing database or spreadsheet to collect jobs information, please send that spreadsheet to CFO/PA&E and do not use this template. If you have any questions, please contact Howard Dickenson, Assistant Director for Recovery Act Operations, CFO/PA&E at [email protected]
•Once completed, please send this spreadsheet to CFO/PA&E at [email protected] . Data should be submitted by the Friday of the first week of every month, or new fiscal quarter depending on your situation (e.g.a Nov. 6th submission for the month of October or FY09 Quarter 4--note this submission will be unique because the data will be cumulative from the start of the Recovery Act ).
•Program offices should submit an FTE count for each project that falls under this guidance; FTE data should be rolled up for each project.
•Not all projects will need to report information for each field. If a field does not pertain to the project please enter a "0". Project Name, Project Code, and Total FTE are required fields for each project.
•All contractor and sub-contractor direct jobs created/retained must be reported cumulatively on a monthly basis. Prime contractors are still required to report quarterly to Federalreporting.gov for prime contractor jobs. However, as FederalReporting.gov does not require prime contractors to report subcontractor jobs, DOE is requesting this information to provide a more comprehensive jobs picture.
•All financial assistance awards that have a waiver from the Paperwork Reduction Act must submit FTE numbers on a monthly basis for both federally funded jobs and cost sharing/matching funds. Recipients must also still comply with reporting requirements to FederalReporting.gov. Currently, FederalReporting.gov does not collect jobs generated from cost-sharing; nor does FederalReporting.gov allow for monthly reporting for projects with a pre-existing Paperwork Reduction Act waiver for collecting such information.
•All financial assistance awards that do NOT have a waiver from the Paperwork Reduction Act but have cost sharing/matching funds must submit FTE numbers on a quarterly basis for both federally funded jobs and cost sharing/matching funds. Recipients must also still comply with reporting requirements to FederalReporting.gov. Currently, FederalReporting.gov does not require recipients to report jobs created from cost-sharing.
Project Details			Federally Funded Cummulative FTE				Non-Federal Funding Cummulative FTE
Project Name	Project Code	Total FTE Calculation: This number should include all jobs created by the Recovery Act funds including jobs created through matching/cost-sharing of federal funds. Jobs should be reported as "full-time equivalent" FTE jobs. The FTE calculation is cummulative, beginning from the point that funding was received. In order to perform the calculation, the total number of hours worked is needed, as well as the number of hours in a full-time monthly schedule: Cummulative Recovery Act Funded Hours Worked Cummulative Hours in a Full-Time Work Schedule This calculation should be used for all to determine all FTEs, regardless of funding type. Total FTE	Prime Contractor Definition: A non-federal organization that has entered into a mutually binding legal agreement (i.e., contract) with DOE that requires the prime contractor to provide services and/or supplies. For the purpose of these supplemental instructions, the contract should be funded directly by Recovery Act funds Prime Contractor Total FTE	Sub Contractor Definition: Non-Federal entities that are awarded Recovery funding through a legal instrument from the prime contractor to support the performance of any portion of the project for which the prime contractor received the Recovery funding. Data should be collected down to the level where the majority of the work is occuring, ie if 80% of the work occurs at the first-tier sub contractor then then collecting data down to the first-tier sub contractor is sufficient. Sub Contractor Total FTE	Prime Financial Assistance Recipient Definition: A non-federal organization that receive Recovery Act funding as Federal awards in the forms of grants, loans, or cooperative agreements directly from the federal government. Prime Financial Assitance Recipient Total FTE	Sub Financial Assistance Recipeint Definition: Non-Federal entities that are awarded Recovery funding through a legal instrument from the prime financial assistance recipeint to support the performance of any portion of the project for which the prime financial assistance recipient received the Recovery funding. Data should be collected down to the level where the majority of the work is occuring, ie if 80% of the work occurs at the first-tier sub then collecting data down to the first-tier sub financial assistance recipient is sufficient. Sub Financial Assitance Recipient Total FTE	Cost-share/Matching Definition: Jobs created through cost sharing, matching, or in-kind donation are jobs that were created through a portion of a project or program costs not borne by the Federal Government. However, these jobs would not have existed without the project receiving partial funding through Recovery Funds. For instance if 40% of funding resulted from Recovery Funds, the remaining 60% of funding, and consequent jobs would be a result of cost share or matching funds. Total Cost-share/Matching FTE