FY2024 SLCGP Project Worksheet_9-18-24.xlsx
XLSX spreadsheet 98 KB Posted
- Opportunity number
- DHS-24-GPD-137-00-99
- Issued by
-
Federal Emergency Management Agency
About this file
This document is a Project Worksheet for the Fiscal Year 2024 State and Local Cybersecurity Grant Program (SLCGP), which is funded through the Homeland Security Act of 2002 and administered by the Federal Emergency Management Agency. The worksheet is used to capture baseline project information and implementation details for SLCGP awards.
Key details include: the federal award amount, cost share requirements, pass-through funding allocations for state and local/rural projects, and project management steps. Applicants must align projects to at least one of the four SLCGP program objectives, such as establishing governance structures, assessing cybersecurity posture, implementing security protections, and ensuring personnel training. The worksheet provides instructions for completing the required information, including project descriptions, locations, core capabilities, budgets, and timelines. This document serves as a template for applicants to submit their projects for the FY2024 SLCGP funding opportunity.
FY2024 SLCGP Project Worksheet_9-18-24
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Overview SLCGP Project Worksheet Overview
| Complete rows 5-15 with the information for the SLCGP award and SAA organization. Replace the instructive language with the appropriate information. | |
| Award Number | EMW-20XX-CY-XXXXX |
| Project Worksheet Submission #: | The first project worksheet submission is at time of application and therefore would be (#1). Subsequent submissions for revisions or additional projects would be sequential (e.g., #2, #3, etc.) |
| Federal Fiscal Year: | FY 2024 |
| Federal Award Amount: | |
| Total Cost Share Amount: | |
| State Administrative Agency (SAA): | |
| SAA POC Name: | |
| SAA POC Title: | |
| SAA Address: | |
| SAA POC Phone Number: | |
| SAA POC Email Address: | |
| PAPERWORK BURDEN DISCLOSURE NOTICE |
Public reporting burden for this data collection is estimated to average 6 hours per response. The burden estimate includes the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and submitting this form. You are not required to respond to this collection of information unless a valid OMB control number is displayed on this form. Send comments regarding the accuracy of the burden estimate and any suggestions for reducing the burden to: Information Collections Management, Department of Homeland Security, Federal Emergency Management Agency, 500 C Street. SW, Washington, DC 20472-3100, Paperwork Reduction Project (1660-0156) NOTE: Do not send your completed form to this address.
PRIVACY NOTICE
GENERAL: This information is being collected for the primary purpose of determining eligibility and administration of SLCGP and to ensure compliance with existing laws and regulations regarding SLCGP.
AUTHORITY: The collection of this information is authorized by the Consolidated Appropriations Act, 2023 and 2 CFR Part 200.
USES AND SHARING: FEMA will not share the information collected from POCs, including personally identifiable information, outside of the collecting agency. Further information regarding FEMA’s use and sharing of information can be found within the DHS/FEMA/PIA-013 Grant Management Programs Privacy Impact Assessment. The Department’s list of Privacy Impact Assessments can be found on the Department’s website at https://www.dhs.gov/privacy-impact-assessments.
EFFECTS OF NONDISCLOSURE: The disclosure of information on this form is voluntary; however, failure to provide the information requested may delay or prevent the organization from receiving grant funding.
Baseline Instructions
| Below provides instructions for the Baseline Project Information Tab in the SLCGP Project Worksheet. |
| FOR APPLICATION PURPOSES ONLY: PLEASE ENTER THE DOLLAR AMOUNTS IN WHOLE DOLLARS ONLY-NO DOLLARS AND CENTS. |
FOR POST-AWARD PURPOSES: DOLLAR AMOUNTS CAN BE ENTERED IN DOLLARS AND CENTS.
| Tab | Column | Instructions |
| Baseline Project Tab | Column A) State/Territory/Local Agency Name | Enter in State/Territory/Local government entity name. |
| Column B) Investment (Objective #) | List the Investment's applicable Objective # in which the project is associated. | |
| Column C) Project Name | Enter in the project title. | |
| Column D) Project Alignment to Plan's 16 Cybersecurity Elements | List which of the Plan's 16 required elements this project aligns (e.g., 1, 5, 10). | |
| Column E) Project Description | Please enter the project description in this cell. There are no character limits for the description. | |
| Column F) Project Location (Zip Code) | List the zip code for the physical location of the Project. | |
| Column G) Primary Core Capability | Enter in Cybersecurity. | |
| Column H) Sustain or Build | Please list if the project will be used to Sustain or Build capabilities. | |
| Column I-M) POETE | Enter the total project dollar amount (federal amount plus cost share, as applicable) for the Planning, Organization, Equipment, Training, and Exercise category(s) associated with each Investment (Columns I-M). | |
| Column N) POETE Subtotal | Do NOT manually enter any value in this cell. Column N totals values entered into Columns I-M. | |
| Column O) State Projects (up to 20%) | Enter the Dollar amount allocated to State projects (up to 20%). | |
| Column P) Local Pass-Through Amount (80%) | Enter the Dollar amount of the SAA's Subgrant (Awarded Projects) to the LOCAL government entity. This number should INCLUDE the pass through to the rural areas. | |
| Column Q) Rural Pass-Through Amount (25%) | Enter the Dollar amount of the SAA's Subgrant (Awarded Projects) to a Local government entity within a RURAL area (population less than 50,000). The pass-through to rural areas is a part of the overall 80% local pass-through. If the project does not include funding for rural areas, enter $0. | |
| Column R) Value of the 80% Local Pass-Through in Services | Enter the Dollar value of the SAA's Pass-Through Services, Solutions, etc. for LOCAL government entities. This number should INCLUDE the pass-through to the rural areas. | |
| Column S) Value of the 25% Rural Pass-Through in Services | Enter the Dollar value of the SAA's Pass-Through Services, Solutions, etc. for local government entities within a RURAL areas. The pass-through of services to rural areas is a part of the overall 80% local pass-through. If the project does not include services for rural areas, enter $0. | |
| Column T) Do you have an approved Cost Share Waiver? | In the associated cells under column U, there is a drop down menu that will give you the option to enter in Yes/No. |
Choose one of the two options.
| Column U) Federal Amount | Do NOT manually enter any value in this cell.The Federal Amount is automatically calculated based on the total project costs captured in column N (POETE subtotal). | |
| Column V) Cost Share | Do NOT manually enter any value in this cell. The Cost Share is automatically calculated based on the total project costs captured in column N (POETE subtotal) and the yes/no entered into Column T. | |
| Column W) Total Project Costs | Do NOT manually enter any value in this cell. The Total Project Costs are automatically calculated based on the total project costs captured in column N (POETE subtotal) | |
| Note: In lieu of subgrant award funding to local government entities to meet the pass-through requirement, the SAA can pass through items, services, capabilities, or activities to local governments as long as the SAA obtains the written consent of these local governments. In this case, the dollar value of these services, items, activities or capabilities must be a minimum of 80% of the federal award amount. This same requirement applies to the 25% that must be passed through to rural areas. To meet the 25% rural pass-through requirement, the eligible subrecipient must be a local government entity within a rural area (a jurisdiction with a population of less than 50,000 individuals). |
Management and Administrative (M&A) funding must be included in the PW. Up to 5% of the Federal Award Amount can be retained for M&A purposes.
Remove blank project rows and example text from tab before submission. Data is populated throughout the tabs for reference of how to complete form. Ensure all formulas and totals are aligned under Total Project Costs.
Baseline Project Information
| This draft Project Worksheet should be used until the final form is approved by OMB | |||||||||||||||||||||||
| State/Territory/Local Agency Name | Investment (Objective #) | Project Name | Project Alignment to which of the Plan's 16 Required Cybersecurity Elements | Project Description | Project Location (ZIP Code) | Primary Core Capability | Sustain or Build | Planning | Organization | Equipment | Training | Exercises | POETE Subtotal (Do not manually enter amount) | State Share of Award (up to 20%) | |||||||||
| Amount allocated for State Projects | 80% Local Pass-Through Amount | ||||||||||||||||||||||
| (SUBAWARDS to LOCAL Government) | 25% Rural Pass-Through Amount (SUBAWARDS to LOCAL Jurisdictions in RURAL Communities- less than 50,000 population) | *Value of the SAA's Pass-Through Services, Solutions, etc. for LOCAL Government (If dollar amount is entered in Columns P and/or Q, do not enter a dollar amount in this column) | *Value of the SAA's Pass-Through Services, Solutions, etc. to RURAL Communities (If dollar amount is entered in Columns P and/or Q, do not enter a dollar amount in this column) | Do you have an approved Cost Share Waiver? (Indicate Yes/No) | Federal Amount (Do not manually enter amount) | Cost Share (Do not manually enter amount) | Total Project Costs (Federal + Cost Share) (Formula; do not manually enter) | ||||||||||||||||
| State/Territory XXX | e.g. (Objective 3, Security Protections) | IJ 1 Endpoint Detection | $ 707,070.00 | $ - 0 | $ 5.00 | $ 5.00 | $ 500,000.00 | $ 1,207,080.00 | $ - 0 | $ - 0 | $ - 0 | $ 100,000.00 | $ 25,000.00 | No | $ 844,956.00 | $ 362,124.00 | $ 1,207,080.00 | ||||||
| State/Territory XXX | e.g. (Objective 4, Training) | IJ 2 Cybersecurity Subgrant Statewide Training | $ 10,000.00 | $ 15,000.00 | $ - 0 | $ - 0 | $ - 0 | $ 25,000.00 | $ - 0 | $ 700,000.00 | $ 250,000.00 | $ - 0 | $ - 0 | No | $ 17,500.00 | $ 7,500.00 | $ 25,000.00 | ||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 | |||||||||
| State/Territory SAA | Management and Administration (M&A) | ||||||||||||||||||||||
| (Up to 5% of the Federal Award Amount) | Management and Administration (M&A) | N/A | Funding to provide for the administration, oversight, compliance of the grant award. | Cybersecurity | Build | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | No | $ - 0 | $ - 0 | $ - 0 |
$ 717,070.00 $ 15,000.00 $ 5.00 $ 5.00 $ 500,000.00 $ 1,232,080.00 $ - 0 $700,000 $250,000 $100,000 $25,000 $862,456.00 $369,624.00 $1,232,080.00
| Source of Cost-Share | Total Amount |
| Hard (Cash) | $ - 0 |
| Description | (e.g. General Fund) |
| Soft (in kind) | $ - 0 |
| Description | (e.g., the value of salaries and fringe benefits paid for with general fund monies for staff directly involved in the development of the cybersecurity plan. See the SLCGP NOFO for other examples) |
Implementation Instructions
| Below provides brief instructions for the Project Implementation Tab in the SLCGP Project Worksheet. |
| This tab requires outlining key project activities and tasks associated with each project. The standard definition of a project is a temporary endeavor with a defined beginning and end (usually time-constrained, and often constrained by funding or a deliverable), undertaken to meet unique goals and objectives, typically to bring about beneficial change or added value. Applying this standard to projects using preparedness grant funds, a project is a related set of activities and purchases supporting the building or sustaining of core capabilities; and is associated with a single entity responsible for execution. This approach will allow CISA/FEMA and applicants to categorize the grant-funded project as a discrete unit for post-award management, reporting, and monitoring purposes. |
Please see below for specific instructions and information on filling out the Project Implementation Tab
| Note: Any additional line items added to the 15 available in the Baseline Project Information, please add the same amount to the Project Implementation tab and drag the formula down. | ||
| Tab | Column | Instructions |
| Project Implementation | Column A) State/Territory/Local Agency Name | Do NOT manually enter any value in these cells. Columns A, B, C and D auto populate from columns A, B, C and E in the Baseline Project Information Tab. |
| Column B) Investment Objective # | |
| Column C) Project Name | |
| Column D) Project Description | |
| Column E) Does the Project Support a Previously Awarded Investment? Yes or No | In the associated cells under column E, there is a drop down that will allow you to select Yes/No. Please indicate if your project supports a previously awarded investment. Choose one of the two options. |
| Column F) If yes, from which year? | Enter the approriate year of the investment if the previous question in column E is answered yes. |
| Column G) If Yes, which investment? | Enter in the Project name if the answer in column E is yes. |
| Column H) Project Management Step | For this column, please see below for information on each of the steps and processes of the Project Management Lifecycle. In the associated cells for column H, there is a drop down. Choose the appropriate step of your investment. |
The main steps and processes of the Project Management Lifecycle are Initiate, Execute, Control, Close Out.
1) Initiate: The authorization to begin work or resume work on any particular activity.
2) Execute: The period within the project life cycle during which the actual work of creating the project’s deliverables is carried out.
3) Control: A mechanism which reacts to the current project status to ensure accomplishment of project objectives. This involves planning, measuring, monitoring, and taking corrective action based on the results of the monitoring.
4) Close Out: The completion of all work on a project. Can also refer to completion of a phase of the project.
| Column I) Start Date | Enter in the estimated start dates of each project |
| Column J) End Date | Enter in the estimated completion dates of each project |
| Column K) Milestone 1 | For each project, enter the Milestones (Key Activities) necessary to accomplish the Project(s) goals from the Cybersecurity Plan. |
Additional information on the Implementation Schedule and Milestones can be found in the SLCGP NOFO.
| Column L) Milestone 2 | ||
| Column M) Milestone 3 | ||
| Column N) Federal Amount | Do NOT manually enter any value in these cells. Columns N, O, and P auto populate from Columns U, V, and W on the Baseline Project Information Tab. | |
| Column O) Cost Share | ||
| Column P) Total Project Costs (Federal + Cost Share) | ||
| For additional information on the Project Management Lifecycle, please visit Project Management Institute's (PMI) A Guide to the Project |
Management Body of Knowledge (PMBOK Guide) at http://www.pmi.org/PMBOK-Guide-and-Standards.aspx. Specifically, applicants are encouraged to reference Chapter three of the PMBOK Guide, The Standard for Project Management of a Project.
Project Implementation
| State/Territory/Local Agency Name (Autopopulates from Baseline Project Information) | Investment Objective # | |||||||||||||||
| (Autopopulates from Baseline Project Information) | Project Name | |||||||||||||||
| (Autopopulates from Baseline Project Information) | Project Description | |||||||||||||||
| (Autopopulates from Baseline Project Information) | Does the Project Support a Previously Awarded Investment? Yes or No | If yes, from which year? | If Yes, which investment? | Project Management Step | Start Date | End Date | Milestone 1 | Milestone 2 | Milestone 3 | Federal Amount (Autopopulates from Baseline Project Information) | Cost Share (Autopopulates from Baseline Project Information | Total Project Costs (Federal + Cost Share) (Autopopulates from Baseline Project Information) | ||||
| State/Territory XXX | e.g. (Objective 3, Security Protections) | IJ 1 Endpoint Detection | 0 | $ 844,956.00 | $ 362,124.00 | $ 1,207,080.00 | ||||||||||
| State/Territory XXX | e.g. (Objective 4, Training) | IJ 2 Cybersecurity Subgrant Statewide Training | 0 | $ 17,500.00 | $ 7,500.00 | $ 25,000.00 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| State/Territory SAA | Management and Administration (M&A) | |||||||||||||||
| (Up to 5% of the Federal Award Amount) | Management and Administration (M&A) | Funding to provide for the administration, oversight, compliance of the grant award. | No | N/A | N/A | N/A | $ - 0 | $ - 0 | $ - 0 | |||||||
| $ 862,456.00 | $ 369,624.00 | $ 1,232,080.00 |
File details come from the government source that posted it. Updated .