FY27 SOW_New Award_YR1.xlsx
XLSX spreadsheet 41 KB Posted
- Opportunity number
- W81XWH-22-DHAPP
- Issued by
-
Department of the Army Medical Command
About this file
This is a Statement of Work (SOW) budget template for FY2027 awards under the Department of Defense HIV/AIDS Prevention Program (DHAPP), administered by the Defense Health Agency through the USAMRAA execution office. The template is designed for Phase 1 new awards and uses a cooperative agreement funding instrument with the federal agency designated as DOD and partner name as DHA. The template establishes a standardized framework for budget planning and narrative documentation across up to 20 distinct interventions, with all monetary values currently showing $0 pending data population.
The template structure requires implementing partners to complete metadata fields including Award Number (TBD), Vendor ID, Mech ID, Prime DUNS Number (requiring 9 characters), and Operating Unit information. Data entry occurs in the "Work Plan Budget" tab and "DHAPP SOW" tab, with mandatory fields for Program Area selection from a dropdown list, Beneficiary designation, and cost category allocation across 18 line items including personnel salaries, fringe benefits, travel, equipment, supplies, contractual services, construction, training, and subrecipient costs. The DHAPP SOW tab requires population of MER Indicator Targets, Above Site (AS) activity outputs, and intervention narratives, with budgeted amounts in this column matching the Work Plan Budget total. Supporting reference data includes detailed Area of Cooperation categories (2.1 through 2.6), Sub-Categories spanning surveillance, laboratory systems, commodities, frontline health workers, data systems, and strategic assistance, and eligible Health Program Areas (HIV, TB, Malaria, GHS, and N/A for Partner Government Funding Only). The template accommodates fringe benefit rates and the number of subrecipients (0-100) for financial planning purposes.
SOW DHAPP Template Year 1
View the file
Other files
| File | Type | Posted |
|---|---|---|
| PKG00276874.pdf | ||
| SOW_DHAPP USAMRAA PA TEMPLATE for Proposal Submission_Y2-Y4.xlsx | XLSX spreadsheet | |
| SOW_DHAPP TEMPLATE for Proposal Submission_Y2-Y4.xlsx | XLSX spreadsheet | |
| SOW_DHAPP TEMPLATE for Proposal Submission_Y1.xlsx | XLSX spreadsheet | |
| SOW_DHAPP USAMRAA PA TEMPLATE for Proposal Submission_Y1_FY2024.xlsx | XLSX spreadsheet | |
| W81XWH-22-DHAPP 10.11.2024.pdf | ||
| W81XWH-22-DHAPP 1.17.2024.pdf | ||
| W81XWH-22-DHAPP rev 10 May.pdf | ||
| W81XWH-22-DHAPP.pdf | ||
| W81XWH-22-DHAPP.pdf | ||
| W81XWH-22-DHAPP rev 12 April.pdf | ||
| W81XWH-22-DHAPP 12.11.2024.pdf | ||
| W81XWH-22-DHAPP 7.11.2024.pdf | ||
| W81XWH-22-DHAPP 11.6.2024.pdf | ||
| W81XWH-22-DHAPP.pdf | ||
| W81XWH-22-DHAPP 12.18.2024.pdf |
Show all 16
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
Summary & Instructions
| Data Prepopulated From Data Entry Tabs | |||||
| Federal Agency | DOD | Partner Name | 0 | DHA PO | 0 |
| Funding Source | 0 | Award Number | TBD | Vendor ID | 0 |
| Mech ID | 0 | Phase | Phase 1 | Unique Entity Identifier (UEI) | 0 |
| Prime DUNS Number | 0 | Operating Unit | 0 | Execution Office | USAMRAA |
| COP/DOP YR | 0 | Implementation Year | FY2027 |
| COP/DOP IM Total Auth | |
| Total Budget per Intervention from COP Auth | $0 |
| Work Plan Budget Total | $0 |
| Delta | $0 |
| Instructions | |
| Data Entry requirements are in Blue Work Plan Budget tab and Green DHAPP SOW tab. Data Entry only allowed in GREEN CELLS | |
| Work Plan Budget | 1. Row: 2-6: DHAPP HQ will complete Metadata Section: this pre-populates info throughout this workbook. *DUNS Number MUST be 9 characters in length. |
| 2. Row 10: Select from the drop down list each Program Area for each intervention listed. Guidance on Budget Classifications structure can be found at the following website https://datim.zendesk.com/hc/en-us/articles/360015671212-PEPFAR-Financial-Classifications-Reference-Guide | |
| 3. Row 11: Select from the drop down list each Beneficiary for each intervention listed. | |
| 4. Rows 13 - 31: Enter the budgeted amount for each cost category within each intervention. | |
| 6. Row 40: Indicate the number of subrecipients |
| DHAPP SOW | 1.Columns A-F should be prepopulated from Metadata in the Work Plan Budget tab. |
| 2. Columns G-J will be pre-populated from the work plan budget tab. | |
| 3. Column K: Populate MER Indicator Target as applicable. | |
| 4. Column L: If intervention is for Above Site (AS) activities, populate outputs as applicable. | |
| 5. Column M: Populate narrative field for intervention. | |
| 5. Total budgeted in column J should equal total budgeted in Work Plan Budget. | |
| Reference Tab | Available Program Areas, Beneficiaries, Budget Codes and Interventions are listed in the reference tab. |
System Metadata dc2
Work Plan Budget
| Metadata | |||||
| Federal Agency | DOD | Partner Name | DHA PO | ||
| Funding Source | Award Number | TBD | Vendor ID | ||
| Mech ID | Phase | Phase 1 | Unique Entity Identifier (UEI) | ||
| Prime DUNS Number | Operating Unit | Execution Office | USAMRAA | ||
| COP/DOP YR | Implementation Year | FY2027 |
| Program | |||||||||||||||||||||||||
| Management | Categorization of Intervention 2 | Categorization of Intervention 3 | Categorization of Intervention 4 | Categorization of Intervention 5 | Categorization of Intervention 6 | Categorization of Intervention 7 | Categorization of Intervention 8 | Categorization of Intervention 9 | Categorization of Intervention 10 | Categorization of Intervention 11 | Categorization of Intervention 12 | Categorization of Intervention 13 | Categorization of Intervention 14 | Categorization of Intervention 15 | Categorization of Intervention 16 | Categorization of Intervention 17 | Categorization of Intervention 18 | Categorization of Intervention 19 | Categorization of Intervention 20 | ||||||
| Intervention Name or Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | |||||
| Area of Cooperation | 2.6: Strategic Assistance | ||||||||||||||||||||||||
| Sub-Category | 2.6.10: IP Program Management | ||||||||||||||||||||||||
| Health Program Area | HIV | TOTAL | % Total | ||||||||||||||||||||||
| Personnel: Salaries - Health Care Workers | NA | $0 | 0% | ||||||||||||||||||||||
| Personnel: Salaries - Other Staff | $0 | 0% | |||||||||||||||||||||||
| Fringe Benefits | $0 | 0% | |||||||||||||||||||||||
| Travel: International Travel | $0 | 0% | |||||||||||||||||||||||
| Travel: Domestic Travel | $0 | 0% | |||||||||||||||||||||||
| Equipment: Health Equipment | $0 | 0% | |||||||||||||||||||||||
| Equipment: Non-Health Equipment | $0 | 0% | |||||||||||||||||||||||
| Supplies: Pharmaceutical | NA | $0 | 0% | ||||||||||||||||||||||
| Supplies: Health- Non Pharmaceutical | NA | $0 | 0% | ||||||||||||||||||||||
| Supplies: Other Supplies | $0 | 0% | |||||||||||||||||||||||
| Contractual: Contracted Health Care Workers | NA | $0 | 0% | ||||||||||||||||||||||
| Contractual: Contracted Interventions | NA | $0 | 0% | ||||||||||||||||||||||
| Contractual: Other Contracts | $0 | 0% | |||||||||||||||||||||||
| Construction | $0 | 0% | |||||||||||||||||||||||
| Training | $0 | 0% | |||||||||||||||||||||||
| Subrecipient Total | NA | $0 | 0% | ||||||||||||||||||||||
| Other: Financial Support for Beneficiaries | $0 | 0% | |||||||||||||||||||||||
| Other: Other | $0 | 0% | |||||||||||||||||||||||
| Indirect Charges | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | $0 | 0% | ||||
| Total Budget per Intervention (Sum of Cost Categories) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0% | |||
| Total Budget per Intervention from COP Auth | $0 | ||||||||||||||||||||||||
| Total Budget in Template minus Total Budget from COP | $0 | ||||||||||||||||||||||||
| % by Intervention | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% |
Fringe Benefit Rate
Number of subrecipients (0-100)
DHAPP SOW
| Pre-populates from Metadata | Pre-populates from Work Plan Budget Tab | Data Entry - to be completed by IP | ||||||||||
| Award Number | Phase | COP/DOP YR | Operating Unit | Partner Name | Mech ID | Area of Cooperation | Sub-Category | Intervention | Total Amount Budgeted | MER Indicator Target | Outputs for Above Site (AS) Activities | Narrative |
| $0 | ||||||||||||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 2.6: Strategic Assistance | 2.6.10: IP Program Management | 1 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | $0 | |||
| TBD | Phase 1 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | $0 |
Reference Data Guidance around Budget Classifications structure can be found at the following website
List
| Area of Cooperation | Sub-Category | Health Program Area |
| 2.1: Surveillance and Outbreak Response | 2.1.1: Surveys and Assessments | HIV |
| 2.2: Laboratory Systems | 2.1.2: Outbreak Response Capacities | TB |
| 2.3: Commodities | 2.1.3: Multisectoral Coordination for Animal and Human Outbreak Surveillance and Response | Malaria |
| 2.4: Frontline Health Workers | 2.1.4: Outbreak Readiness | GHS |
| 2.5: Data Systems | 2.2.1: Lab Consumables Procurement | N/A (Partner Government Funding Only |
| 2.6: Strategic Assistance | 2.2.2: Lab Reagents and Diagnostic Test Kit Procurement | |
| 2.2.3: Lab Equipment Procurement | ||
| 2.2.4: Lab Service and Maintenance Costs | ||
| 2.2.5: All-Inclusive Pricing Laboratory Procurements | ||
| 2.2.6: Frontline Lab Workers | ||
| 2.2.7: Lab Sample Transport | ||
| 2.2.8: Lab Accreditation | ||
| 2.2.9: Lab System Support | ||
| 2.3.1: Prevention Commodity Procurement | ||
| 2.3.2: Diagnostic Commodity Procurement | ||
| 2.3.3: Therapeutic Commodity Procurement | ||
| 2.3.4: Response Commodity Procurement | ||
| 2.3.5: In-Country Warehousing and Distribution | ||
| 2.3.6: Supply Chain Systems Support | ||
| 2.3.7: Campaigns | ||
| 2.4.1: Campaign Workers | ||
| 2.4.2: Community Health Workers/Community-Based Staff | ||
| 2.4.3: Doctors/Clinical Officers | ||
| 2.4.4: Nurses/Midwives | ||
| 2.4.5: Epidemiologists & Surveillance Officers | ||
| 2.4.6: Other Health Workers | ||
| 2.5.1: Data Systems Developer Staff | ||
| 2.5.2: Data Systems Infrastructure | ||
| 2.5.3: Licenses & Software | ||
| 2.5.4: Cybersecurity | ||
| 2.6.1: TA to Introduce New Innovative Diagnostics, Vaccines, Drugs, and Other Interventions (Including Integated Services) | ||
| 2.6.2: Training (Pre and In-Service) and Supervision of Front Line Health Care Workers | ||
| 2.6.3: TA to Support Program Transition to Government or Local Partners | ||
| 2.6.4: TA to Support Public Financial Management | ||
| 2.6.5: TA Support to Achieve Co-Financing | ||
| 2.6.6: Staff Secondment to MOH | ||
| 2.6.7: Other Health Systems Strengthening | ||
| 2.6.8: Other Commodity Procurement | ||
| 2.6.9: Other Health Worker Costs | ||
| 2.6.10: IP Program Management |
File details come from the government source that posted it. Updated .