Attachment 9b Deliverables Schedule Revised.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Microsimulation modeling and analytical support services Federal contract opportunity
- Solicitation number
- 12-3198-25-R-0002
About this file
This is a revised deliverables schedule (Attachment 9b) for Task Order 1 of a federal contract opportunity for microsimulation modeling and analytical support services with the USDA Food and Nutrition Service. The schedule outlines 10 distinct tasks with specific deliverables, formats, and due dates spanning from September 1, 2025, through April 30, 2027.
The key tasks include performing technical and statistical analyses with quick-turnaround deliverables (within 2-3 business days), acquiring and conducting quality assurance checks on Census data products including CPS ASEC, ACS PUMS, and SIPP data, estimating national and state SNAP participation rates for FY 2024-2025, preparing edited FY 2025 SNAP QC data files, updating the QC Mini-Model and MATH-SIPP+ microsimulation model, and preparing comprehensive reports on SNAP household characteristics. Most deliverables are electronic format with specific timeframes ranging from immediate responses to multi-week development periods. The contract also requires continuous hosting of SNAP QC data and models on websites, monthly progress reporting by the 10th of each month, and monthly status calls via video conferencing. This deliverables schedule supports the main RFP 12-3198-25-R-0002, which is structured as an unrestricted IDIQ contract with hybrid pricing mechanisms including firm-fixed price, time and materials, and labor hour arrangements.
View the file
Other files for this federal contract opportunity
Show all 22
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Attachment 9b: Deliverable Schedule for TO 1 PWS Revised
| SCHEDULE OF DELIVERABLES | |||||
| CLIN | TASK | DELIVERABLE | FORMAT | DUE | MONTHLY AMOUNT |
| 0001 | 1 | TASK 1: Perform Technical and Statistical Analyses Period of Performance: 09/01/2025 to 08/31/2026 | |||
| 1.1 | Provide Reform Simulations, Tabulations, and other Related Analyses | ||||
| 1.1.1 | Submit results with accompanying tables or simulation model results and explanation | Electronic | Within 2 business days of FNS request | ||
| 1.1.2 | Data files and programming code used for each request | Electronic | Within 3 business days of FNS request | ||
| 1.1.3 | Final memorandum of quick response reform simultions, tabulations, or analyses | Electronic | Within 30 days after FNS acceptance of initial results | ||
| 1.1.4 | Report of all quick response work performed under Task 1.1 | Electronic | 8/10/26 | ||
| 1.2 | Provide improvements to the QC Data File and/or the QC Mini-Model | ||||
| 1.2.1 | Implementation memorandum describing ad-hoc improvements or analysis for QC Data File and/or QC Mini-Model | Electronic | Within 60 days of FNS request | ||
| 1.3 | Provide improvements to the MATH-SIPP Model and / or the trends file | ||||
| 1.3.1 | Implementation memorandum describing ad-hoc improvements or analysis for the MATH SIPP+ and/or the CPS-based trends file. | Electronic | Within 60 days of FNS request | ||
| 1.4 | Host SNAP QC Data | ||||
| 1.4.1 | Host the SNAP QC data and technical documentation on website | N/A | 09/01/2025-08/31/2026 | ||
| 1.5 | Prepare and Host the QC Mini-Model and MATH SIPP+ Model | ||||
| 1.5.1 | Host the QC Mini-Model and MATH SIPP+ Model on website | N/A | 09/01/2025-08/31/2026 |
| 0002 | 2 | TASK 2: Acquire and Perform Quality Assurance (QA) Checks on Census Data Products Period of Performance: 09/01/2025 to 08/31/2026 | ||
| 2.1 | Acquire 2025 CPS ASEC Data | |||
| 2.1.1 | Memorandum on planned release of 2025 CPS ASEC File | Electronic | Within 7 days of data release announcement | |
| 2.1.2 | Memorandum on release of 2025 CPS ASEC File | Electronic | Within 7 days of data release | |
| 2.2 | Perform QA Checks on CPS ASEC Data | |||
| 2.2.1 | Completion of QA checks on 2025 CPS ASEC Data | N/A | Within 30 days of data release | |
| 2.2.2 | Memorandum describing results of QA checks on 2025 CPS ASEC data | Electronic | Within 30 days of data release | |
| 2.3 | Modify and Document CPS ASEC Data | Within 30 days of data release | ||
| 2.3.1 | 2025 CPS ASEC data files and documentation | Electronic | Within 30 days of data release | |
| 2.4 | Acquire ACS Data | |||
| 2.4.1 | Memorandum on planned release of 2024 ACS PUMS data | Electronic | Within 7 days of data release announcement | |
| 2.4.2 | Host the SNAP QC data and technical documentation on website | Electronic | Within 7 days of data release | |
| 2.5 | Perform QA Checks on 2024 CPS ACS PUMS Data | |||
| 2.5.1 | Perform QA Checks on 2024 CPS ACS PUMS Data | N/A | Within 30 days of data release | |
| 2.5.2 | Memorandum describing results of QA checks | Electronic | Within 30 days of data release | |
| 2.6 | Deliver Documentation on ACS PUMS Data | |||
| 2.6.1 | 2024 ACS PUMS data files and documentation | Electronic | Within 30 days of data release | |
| 2.7 | Acquire SIPP Data | |||
| 2.7.1 | Memorandum on acquisition of all SIPP products with release grid | Electronic | Within 7 days of data release | |
| 2.8 | Perform QA Checks on SIPP Data | |||
| 2.8.1 | Completion of QA Checks on all SIP products | N/A | Within 30 days of data release | |
| 2.8.2 | Memorandum describing results of QA Checks | Electronic | Within 30 days of data release | |
| 2.9 | Deliver Documentation on SIPP Data | |||
| 2.9.1 | SIPP data files and documentation | Electronic | Within 30 days of data release | |
| 2.10 | Provide Technical Support for Census Data Products | |||
| 2.10.1 | Provide answers to technical questions as needed | Electronic | Within 3 business days of request unless otherwise specified |
| 0003 | 3 | TASK 3: Estimate National SNAP Participation Rates for FY 2025 Period of Performance: 09/01/2025 to 08/31/2026 | ||
| 3.1 | Finalize Study Plan | |||
| 3.1.1 | Draft Study Plan | Electronic | Within 6 weeks of award | |
| 3.1.2 | Final Study Plan | Electronic | Within 2 weeks of receiving FNS comments on draft study plan | |
| 3.2 | Estimate National SNAP Participation Rates for 2024 | |||
| 3.2.1 | Memorandum on preliminary 2024 SNAP national participation rates | Electronic | Week 22 | |
| 3.3 | Prepare Report on National SNAP Participation Rates for 2024 | |||
| 3.3.1 | Draft 2024 National Participation Rates Report | Electronic | Within 4 weeks of delivery of preliminary partocoaption rates memo | |
| 3.3.2 | Revised 2024 National Participation Rates Report | Electronic | Within 4 weeks of receipt of FNS comments on draft report | |
| 3.3.3 | Clearance 2024 National Participation Rates Report | Electronic | Within 2 weeks of receipt of FNS comments on revised report | |
| 3.3.4 | Final 2024 National Participation Rates Report | Electronic | Within 1 week of clearance notice | |
| 3.3.5 | Data File and Programming Code | Electronic | Within 1 week of clearance notice |
| 0004 | 4 | TASK 4: Prepare the Edited FY 2025 SNAP QC Data File Period of Performance: 05/01/2026 - 04/30/2027 | ||
| 4.1 | Edit and Prepare FY 2025 SNAP QC Data | |||
| 4.1.1 | Draft Preliminary Tables | Electronic | Within 16 weeks of receipt of initial FY 2025 QC data | |
| 4.1.2 | Final Preliminary Tables | Electronic | Within 24 weeks of initial FY 2025 QC data | |
| 4.1.3 | Draf Edited FY 2025 QC Data File | Electronic | Within 24 weeks of initial FY 2025 QC data | |
| 4.1.4 | Final Edited FY 2025 QC Data File | Electronic | Within 36 weeks of initial FY 2025 QC data | |
| 4.1.5 | Data Cleaning Code Files | Electronic | Within 44 weeks of initial FY 2025 QC data | |
| 4.2 | Document the Quality of the FY 2025 SNAP QC Data | |||
| 4.2.1 | Draft Data Assessment Memorandum | Electronic | Within 28 weeks of receipt of initial FY 2025 QC data | |
| 4.2.2 | Final Data Assessment Memorandum | Electronic | Within 36 weeks of initial FY 2025 QC data | |
| 4.3 | Edit and Prepare FY 2025 SNAP QC Data | |||
| 4.3.1 | Provide answers to technical questions as needed | Electronic | Within 3 business days of request unless otherwise specified |
5 5 TASK 5: Update the QC Mini-Model with FY 2025 Data Period of Performance: 05/01/2026 – 04/30/2027
| 5.1 | Update the QC Mini-Model | ||
| 5.1.1 | Notice of Completion | Electronic | Within 3 business days of completion of the QC mini-model |
| 5.1.2 | Code for QC Mini-Model | Electronic | Within 10 weeks of completion of the QC mini-model |
| 5.2 | Prepare Model Documentation | ||
| 5.2.1 | Draft Technical Documentation | Electronic | Within 30 weeks of receipt of initial FY 2025 QC data |
| 5.2.2 | Final Technical Documentation | Electronic | Within 38 weeks of receipt of initial FY 2025 QC data |
| 0006 | 6 | TASK 6: Prepare the FY 2025 SNAP Household Characteristics Report Period of Performance: 05/01/2026 - 04/30/2027 | ||
| 6.1 | Prepare FY 2025 Report on the Characteristics of SNAP Households and Individuals | |||
| 6.1.1 | Draft Characteristics Report | Electronic | Within 25 weeks of receipt of initial FY 2025 QC data | |
| 6.1.2 | Revised Characteristics Report | Electronic | Within 3 weeks of receiving FNS comments on draft characteristic report | |
| 6.1.3 | Clearance Characteristics Report | Electronic | Within 3 weeks of receiving FNS comments on revised characteristics report | |
| 6.1.4 | Final Characteristics Report | Electronic | Within 3 weeks of receiving FNS comments on clearance characteristic report | |
| 6.1.5 | Final Characteristics Report (Hard Copies) | 25 Hard Bound Copies | Within 5 weeks of COR approval to print | |
| 6.2 | Prepare Electronic Data File of the FY 2024 Report Tables | |||
| 6.2.1 | Data Tables in Characteristics Report | Electronic | Within 1 week of delivering the final characteristics report | |
| 6.2.2 | Data Files and Programming Code for Characteristics Report Tables | Electronic | Within 1 week of delivering the final characteristics report |
| 0007 | 7 | TASK 7: Estimate State FY 2024 SNAP Participation Rates Period of Performance: 05/01/2026 - 04/30/2027 | ||
| 7.1 | Finalize Study Plan | |||
| 7.1.1 | Draft Study Plan | Electronic | Within 6 weeks of award | |
| 7.1.2 | Final Study Plan | Electronic | Within 2 weeks of receiving FNS comments on draft study plan | |
| 7.2 | Estimate FY 2024 State SNAP Participation Rates | |||
| 7.2.1 | Memorandum on Preliminary Participation Rates | Electronic | Within 4 weeks of receiving all data required to generate regression model | |
| 7.3 | Prepare a Research Brief Presenting FY 2024 State SNAP Participation Rates | |||
| 7.3.1 | Draft Research Brief | Electronic | Within 4 weeks of submission of memo with preliminary State participation rate estimates | |
| 7.3.2 | Revised Research Brief | Electronic | Within 4 weeks of receiving comments from FNS on draft research brief | |
| 7.3.3 | Final Research Brief | Electronic | Within 1 week of clearance notice | |
| 7.4 | Prepare a Technical Report on FY 2024 State Participation Rates | |||
| 7.4.1 | Draft Technical Report | Electronic | Within 4 weeks of receiving comments from FNS on draft research brief | |
| 7.4.2 | Final Technical Report | Electronic | Within 2 weeks of clearance of draft technical report | |
| 7.4.3 | Data Files and Programming Code | Electronic | Within 2 weeks of clearance of final technical report |
| 0008 | 8 | TASK 8: Update the CPS and SIPP-Based Microsimulation Model Period of Performance: 09/01/2025 - 04/30/2027 | ||
| 8.1 | Finalize Study Plan | |||
| 8.1.1 | Draft Study Plan | Electronic | Within 4 weeks of QA completion of new SIPP data | |
| 8.1.2 | Final Study Plan | Electronic | Within 2 weeks of receiving comments from FNS | |
| 8.2 | Update the Microsimulation Model | |||
| 8.2.1 | Draft Implementation Memorandum | Electronic | 12 months after QA completion of new SIPP data | |
| 8.2.2 | Final Implementation Memorandum | Electronic | Within 2 weeks of receiving comments from FNS | |
| 8.2.3 | Data Files and Programming Code | Electronic | 14 months after QA completion of new SIPP data | |
| 8.3 | Prepare Model Documentation | |||
| 8.3.1 | Draft Technical Working Paper | Electronic | 13 months after QA completion of new SIPP data | |
| 8.3.2 | Final Technical Working Paper | Electronic | Within 3 weeks of receiving FNS comments | |
| 8.3.3 | Draft Programmer’s Guide | Electronic | 14 months after QA completion of new SIPP data | |
| 8.3.4 | Final Programmer’s Guide | Electronic | Within 3 weeks of receiving FNS comments |
| 0009 | 9 | TASK 9: Prepare to Update the SNAP Participation Dynamics Report Series Period of Performance: 09/01/2025 - 08/31/2026 | ||
| 9.1 | Finalize Supplemental Work Plan | |||
| 9.1.1 | Draft Supplemental Work Plan | Electronic | Within 8 weeks of award | |
| 9.1.2 | Final Supplemental Work Plan | Electronic | Within 2 weeks of receiving FNS’s comments | |
| 9.2 | Assess Feasibility of Updating the SNAP Participation Dynamics Report Series | |||
| 9.2.1 | Draft Feasibility Study Results | Electronic | Within 28 weeks of award | |
| 9.2.2 | Final Feasibility Study Results | Electronic | Within 3 weeks of receiving FNS’s comments | |
| 9.3 | Assess Data and Develop Methodology | |||
| 9.2.1 | Draft Data Assessment and Methodology Memorandum | Electronic | Within 8 weeks of submitting final feasibility study results | |
| 9.2.2 | Final Data Assessment and Methodology Memorandum | Electronic | Within 3 weeks of receiving FNS’s comments |
| 0010 | 10 | TASK 10: Monthly Reporting Period of Performance: 09/01/2025 - 04/30/2027 | ||
| 10.1 | Monthly Progress Reports | |||
| 10.1.1 | Monthly Progress Reports | Electronic | By the 10th of each month, beginning 1 month after award | |
| 10.2 | Monthly Status Calls | |||
| 10.2.1 | Monthly Status Calls | Video- Conferencing | Monthly, exact dates TBD | |
| 10.3 | E-mail Status Updates | |||
| 10.3.1 | E-mail Status Updates | Electronic | TBD |
Sheet1
File details come from the government source that posted it. Updated .