Attachment 9b Deliverables Schedule.xlsx

XLSX spreadsheet 37 KB Posted

Attached to
Microsimulation modeling and analytical support services Federal contract opportunity
Solicitation number
12-3198-25-R-0002
Issued by
Department of Agriculture Food and Nutrition Service

About this file

This is a detailed Deliverables Schedule (Attachment 9b) for a federal contract focused on microsimulation modeling and analytical support services for the Department of Agriculture Food and Nutrition Service. The document outlines ten primary tasks with specific deliverables, due dates, and performance periods spanning from September 2025 to April 2027, including technical analyses, data acquisition, quality assurance checks, SNAP participation rate estimations, model updates, and reporting requirements. Key tasks include performing technical and statistical analyses, acquiring and checking Census data products, estimating national and state SNAP participation rates, preparing SNAP household characteristics reports, updating microsimulation models, and providing monthly progress reports.

The contract is valued at $7,278,072, with a total budget that includes a base contract amount of $6,031,178 and a travel budget of $1,246,894 not-to-exceed (NTE). The solicitation (12-3198-25-R-0002) is an Unrestricted Set-aside with a NAICS Code of 541611 and a Small Business Size Standard of $24.5M. The contract will be an Indefinite Delivery/Indefinite Quantity (IDIQ) with hybrid task order contract types including firm-fixed price (FFP), time and materials (T&M), and labor hour (LH) components. Deliverables are primarily electronic and include memoranda, reports, data files, programming code, and technical documentation across various tasks related to SNAP participation, poverty, food security, and related analytical work.

View the file

Other files for this federal contract opportunity

Other files attached to Microsimulation modeling and analytical support services, newest first.
File Type Posted
12-3198-25-R-0002 A0004 Questions and Responses.pdf PDF
12-3198-25-R-0002 A0004.pdf PDF
12-3198-25-R-0002 A0003.pdf PDF
12-3198-25-R-0002 A0002..pdf PDF
Attachment 9a IDIQ Pricing Schedule Revised.xlsx XLSX spreadsheet
Attachment 9b Deliverables Schedule Revised.xlsx XLSX spreadsheet
Amendment 0001_Attachment 9a IDIQ Pricing Schedule Rev. 1 _07-31-2025.xlsx XLSX spreadsheet
Amendment 0001_Attachment 9b Deliverables Schedule_Rev. 1 _07-31-2025.xlsx XLSX spreadsheet
Amendment 0001_RFP 12-3198-25-R-0002__07-31-2025.pdf PDF
12-3198-25-R-0002.pdf PDF
ATTACHMENT 2 2020 Programmers Guide-v2.pdf PDF
ATTACHMENT 3 FY 2023 QC Tech Doc.pdf PDF
ATTACHMENT 5 Trends-FY-2020-and-FY-2022.pdf PDF
ATTACHMENT 4 FY2023-Characteristics-Report.pdf PDF
ATTACHMENT 7 Forecasting Technical Assessment FINAL.pdf PDF
ATTACHMENT 8 Rules of Thumb Using 2012 QC Data.pdf PDF
10b Task Order Performance Work Statement PWS.pdf PDF
ATTACHMENT 1 2020-MATH-SIPP-TWP.pdf PDF
Attachment 9a IDIQ Pricing Schedule.xlsx XLSX spreadsheet
Attachment 10a IDIQ Performance Work statement PWS.pdf PDF
ATTACHMENT 6 SNAP-Participation-Rates-2022.pdf PDF
ATTACHMENT 11 QASP.pdf PDF
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

7.0

Attachment 9b: Deliverable Schedule for TO 1 PWS

SCHEDULE OF DELIVERABLES
CLINSLINTASKDELIVERABLEqtyFORMATDUEDUEMONTHLY AMOUNT
0001N/A1TASK 1: Perform Technical and Statistical Analyses Period of Performance: 09/01/2025 to 08/31/2026
1.1Provide Reform Simulations, Tabulations, and other Related Analyses1
1.1.1Submit results with accompanying tables or simulation model results and explanation1ElectronicWithin 2 business days of FNS request
1.1.2Data files and programming code used for each request1ElectronicWithin 3 business days of FNS request
1.1.3Final memorandum of quick response reform simultions, tabulations, or analysesElectronicWithin 30 days after FNS acceptance of initial results
1.1.4Report of all quick response work performed under Task 1.11Electronic8/10/26
1.2Provide improvements to the QC Data File and/or the QC Mini-Model1
1.2.1Implementation memorandum describing ad-hoc improvements or analysis for QC Data File and/or QC Mini-Model1ElectronicWithin 60 days of FNS request
1.3Provide improvements to the MATH-SIPP Model and / or the trends file1
1.3.1Implementation memorandum describing ad-hoc improvements or analysis for the MATH SIPP+ and/or the CPS-based trends file.1ElectronicWithin 60 days of FNS request
1.4Host SNAP QC Data1
1.4.1Host the SNAP QC data and technical documentation on website1N/A09/01/2025-08/31/2026
1.5Prepare and Host the QC Mini-Model and MATH SIPP+ Model1
1.5.1Host the QC Mini-Model and MATH SIPP+ Model on website1N/A09/01/2025-08/31/2026
0002N/A2TASK 2: Acquire and Perform Quality Assurance (QA) Checks on Census Data Products Period of Performance: 09/01/2025 to 08/31/20261
2.1Acquire 2025 CPS ASEC Data1
2.1.1Memorandum on planned release of 2025 CPS ASEC File1ElectronicWithin 7 days of data release announcement
2.1.2Memorandum on release of 2025 CPS ASEC File1ElectronicWithin 7 days of data release
2.2Perform QA Checks on CPS ASEC Data1
2.2.1Completion of QA checks on 2025 CPS ASEC Data1N/AWithin 30 days of data release
2.2.2Memorandum describing results of QA checks on 2025 CPS ASEC data1ElectronicWithin 30 days of data release
2.3Modify and Document CPS ASEC Data1Within 30 days of data release
2.3.12025 CPS ASEC data files and documentation1ElectronicWithin 30 days of data release
2.4Acquire ACS Data1
2.4.1Memorandum on planned release of 2024 ACS PUMS data1ElectronicWithin 7 days of data release announcement
2.4.2Host the SNAP QC data and technical documentation on website1ElectronicWithin 7 days of data release
2.5Perform QA Checks on 2024 CPS ACS PUMS Data1
2.5.1Perform QA Checks on 2024 CPS ACS PUMS Data1N/AWithin 30 days of data release
2.5.2Memorandum describing results of QA checks1ElectronicWithin 30 days of data release
2.6Deliver Documentation on ACS PUMS Data1
2.6.12024 ACS PUMS data files and documentation1ElectronicWithin 30 days of data release
2.7Acquire SIPP Data1
2.7.1Memorandum on acquisition of all SIPP products with release grid1ElectronicWithin 7 days of data release
2.8Perform QA Checks on SIPP Data1
2.8.1Completion of QA Checks on all SIP products1N/AWithin 30 days of data releaseWithin 30 days of data release
2.8.2Memorandum describing results of QA Checks1ElectronicWithin 30 days of data release
2.9Deliver Documentation on SIPP Data1
2.9.1SIPP data files and documentation1ElectronicWithin 30 days of data release
2.10Provide Technical Support for Census Data Products1
2.10.1Provide answers to technical questions as needed1ElectronicWithin 3 business days of request unless otherwise specified
00033TASK 3: Estimate National SNAP Participation Rates for FY 2025 Period of Performance: 09/01/2025 to 08/31/2026
3.1Finalize Study Plan
3.1.1Draft Study Plan1ElectronicWithin 6 weeks of award
3.1.2Final Study Plan1ElectronicWithin 2 weeks of receiving FNS comments on draft study plan
3.2Estimate National SNAP Participation Rates for 20241
3.2.1Memorandum on preliminary 2024 SNAP national participation rates1ElectronicWeek 22
3.3Prepare Report on National SNAP Participation Rates for 20241
3.3.1Draft 2024 National Participation Rates Report1ElectronicWithin 4 weeks of delivery of preliminary partocoaption rates memoWithin 30 days of data release
3.3.2Revised 2024 National Participation Rates Report1ElectronicWithin 4 weeks of receipt of FNS comments on draft reportWithin 30 days of data release
3.3.3Clearance 2024 National Participation Rates Report1ElectronicWithin 2 weeks of receipt of FNS comments on revised reportWithin 30 days of data release
3.3.4Final 2024 National Participation Rates Report1ElectronicWithin 1 week of clearance notice
3.3.5Data File and Programming Code1ElectronicWithin 1 week of clearance notice
00044TASK 4: Prepare the Edited FY 2025 SNAP QC Data File Period of Performance: 05/01/2026 - 04/30/2027
4.1Edit and Prepare FY 2025 SNAP QC Data1
0004AA4.1.1Draft Preliminary Tables1ElectronicWithin 16 weeks of receipt of initial FY 2025 QC data
0004AB4.1.2Final Preliminary Tables1ElectronicWithin 24 weeks of initial FY 2025 QC data
0004AC4.1.3Draf Edited FY 2025 QC Data File1ElectronicWithin 24 weeks of initial FY 2025 QC data
0004AD4.1.4Final Edited FY 2025 QC Data File1ElectronicWithin 36 weeks of initial FY 2025 QC data
0004AE4.1.5Data Cleaning Code Files1ElectronicWithin 44 weeks of initial FY 2025 QC data
4.2Document the Quality of the FY 2025 SNAP QC Data1
0004AA4.2.1Draft Data Assessment Memorandum1ElectronicWithin 28 weeks of receipt of initial FY 2025 QC data
0004AB4.2.2Final Data Assessment Memorandum1ElectronicWithin 36 weeks of initial FY 2025 QC data
4.3Edit and Prepare FY 2025 SNAP QC Data1
0004AA4.3.1Provide answers to technical questions as needed1ElectronicWithin 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.1Update the QC Mini-Model1
0004AA5.1.1Notice of Completion1ElectronicWithin 3 business days of completion of the QC mini-model
0004AB5.1.2Code for QC Mini-Model1ElectronicWithin 10 weeks of completion of the QC mini-model
5.2Prepare Model Documentation1
0004AD5.2.1Draft Technical Documentation1ElectronicWithin 30 weeks of receipt of initial FY 2025 QC data
0004AE5.2.2Final Technical Documentation1ElectronicWithin 38 weeks of receipt of initial FY 2025 QC data
00066TASK 6: Prepare the FY 2025 SNAP Household Characteristics Report Period of Performance: 05/01/2026 - 04/30/2027
6.1Prepare FY 2025 Report on the Characteristics of SNAP Households and Individuals1
0006AB6.1.1Draft Characteristics Report1ElectronicWithin 25 weeks of receipt of initial FY 2025 QC data
0006AC6.1.2Revised Characteristics Report6ElectronicWithin 3 weeks of receiving FNS comments on draft characteristic report
0006AB6.1.3Clearance Characteristics Report1ElectronicWithin 3 weeks of receiving FNS comments on revised characteristics report
0006AC6.1.4Final Characteristics Report6ElectronicWithin 3 weeks of receiving FNS comments on clearance characteristic report
0006AC6.1.5Final Characteristics Report (Hard Copies)625 Hard Bound CopiesWithin 5 weeks of COR approval to print
6.2Prepare Electronic Data File of the FY 2024 Report Tables1
0006AB6.2.1Data Tables in Characteristics Report1ElectronicWithin 1 week of delivering the final characteristics report
0006AC6.2.2Data Files and Programming Code for Characteristics Report Tables6ElectronicWithin 1 week of delivering the final characteristics report
00077TASK 7: Estimate State FY 2024 SNAP Participation Rates Period of Performance: 05/01/2026 - 04/30/2027
7.1Finalize Study Plan1
0007AA7.1.1Draft Study Plan1ElectronicWithin 6 weeks of award
0007AB7.1.2Final Study Plan1ElectronicWithin 2 weeks of receiving FNS comments on draft study plan
7.2Estimate FY 2024 State SNAP Participation Rates1
0007AA7.2.1Memorandum on Preliminary Participation Rates1ElectronicWithin 4 weeks of receiving all data required to generate regression model
7.3Prepare a Research Brief Presenting FY 2024 State SNAP Participation Rates1
0007AB7.3.1Draft Research Brief1ElectronicWithin 4 weeks of submission of memo with preliminary State participation rate estimates
0007AB7.3.2Revised Research Brief1ElectronicWithin 4 weeks of receiving comments from FNS on draft research brief
0007AB7.3.3Final Research Brief1ElectronicWithin 1 week of clearance notice
7.4Prepare a Technical Report on FY 2024 State Participation Rates1
0007AA7.4.1Draft Technical Report1ElectronicWithin 4 weeks of receiving comments from FNS on draft research brief
0007AB7.4.2Final Technical Report1ElectronicWithin 2 weeks of clearance of draft technical report
0007AB7.4.3Data Files and Programming Code1ElectronicWithin 2 weeks of clearance of final technical report
00088TASK 8: Update the CPS and SIPP-Based Microsimulation Model Period of Performance: 09/01/2025 - 04/30/2027
8.1Finalize Study Plan1
0008AA8.1.1Draft Study Plan1ElectronicWithin 4 weeks of QA completion of new SIPP data
0008AB8.1.2Final Study Plan1ElectronicWithin 2 weeks of receiving comments from FNS
8.2Update the Microsimulation Model1
0008AA8.2.1Draft Implementation Memorandum1Electronic12 months after QA completion of new SIPP data
0008AB8.2.2Final Implementation Memorandum1ElectronicWithin 2 weeks of receiving comments from FNS
0008AC8.2.3Data Files and Programming Code1Electronic14 months after QA completion of new SIPP data
8.3Prepare Model Documentation1
0008AA8.3.1Draft Technical Working Paper1Electronic13 months after QA completion of new SIPP data
0008AB8.3.2Final Technical Working Paper1ElectronicWithin 3 weeks of receiving FNS comments
0008AC8.3.3Draft Programmer’s Guide1Electronic14 months after QA completion of new SIPP data
0008AC8.3.4Final Programmer’s Guide1ElectronicWithin 3 weeks of receiving FNS comments
00099TASK 9: Prepare to Update the SNAP Participation Dynamics Report Series Period of Performance: 09/01/2025 - 08/31/2026
9.1Finalize Supplemental Work Plan1
0007AA9.1.1Draft Supplemental Work Plan1ElectronicWithin 8 weeks of award
0007AB9.1.2Final Supplemental Work Plan1ElectronicWithin 2 weeks of receiving FNS’s comments
9.2Assess Feasibility of Updating the SNAP Participation Dynamics Report Series1
0007AA9.2.1Draft Feasibility Study Results1ElectronicWithin 28 weeks of award
0007AB9.2.2Final Feasibility Study Results1ElectronicWithin 3 weeks of receiving FNS’s comments
9.3Assess Data and Develop Methodology1
0007AA9.2.1Draft Data Assessment and Methodology Memorandum1ElectronicWithin 8 weeks of submitting final feasibility study results
0007AB9.2.2Final Data Assessment and Methodology Memorandum1ElectronicWithin 3 weeks of receiving FNS’s comments
001010TASK 10: Monthly Reporting Period of Performance: 09/01/2025 - 04/30/2027
10.1Monthly Progress Reports1
0007AA10.1.1Monthly Progress Reports1ElectronicBy the 10th of each month, beginning 1 month after award
10.2Monthly Status Calls1
0007AA10.2.1Monthly Status Calls1Video- ConferencingMonthly, exact dates TBD
10.3E-mail Status Updates1
0007AA10.3.1E-mail Status Updates1ElectronicTBD

Sheet1

47QRAA18D00BQ-12319821F0057 P00001
PWS: Understanding the Relationship Between Poverty Food Security Status Well-Being & Food Security Status
PRICE BY CLIN/SUB‐ CLIN (PAYMENT SCHEDULE) - P00001
CLINSLINDeliverableDESCRIPTIONQTYUNITUNIT COSTCLIN / SUB-AMOUNTDEOB/OBULOESTIMATED DATE TO BE INVOICEDINVOICED
0001PWS Services1LO$6,031,178.00$6,031,178.00($5,618,252)$0N/AN/A
1.2.0Study Plan1LO$109,053.00$109,053.00$109,053$0-2/22/22
1.3.0Prepare Recruitment Materials & Pretest Data Collection1LO$235,047.00$235,047.00$235,047$0-7/19/22
1.4.0Develop Paperwork Reduction Act Clearance Package1LO$68,826.00$68,826.00$68,826$0-5/12/23
0002N/AN/ATravel* Not-to-Exceed (NTE)1LO$1,246,894.00$1,246,894.00$0$1,246,894Monthly during data collection, starting 6/30/2024
00031.1.0Project Orientation Meeting & Reporting
0003AA1.1.1Project orientation meeting & memo1JOB$17,172.00$17,172.00$17,172$17,17210/21/21
0003AB1.1.2Monthly progress reports20JOB$10,935.00$218,700.00$218,700$218,700Quarterly, starting from 8th September 2021
00041.5.0Prepare Data Collection Training Package
0004AA1.5.1Data training package1JOB$48,919.00$48,919.003/27/24
0004AB1.5.2Documentation of trainees’ readiness to collect data1JOB$74,538.00$74,538.005/15/24
0004AC1.5.3Technical memorandum summarizing training1JOB$74,538.00$74,538.005/22/24
0004AD1.5.4In-depth interview training package1JOB$18,959.00$18,959.008/9/24
0004AE1.5.5Documentation of trainees’ readiness to collect data1JOB$23,304.00$23,304.009/27/24
0004AF1.5.6Technical memorandum summarizing training1JOB$23,304.00$23,304.0010/4/24
00051.6.0Survey Sampling Frame & Data Collection
0005AB1.6.1State Data Use Agreements6JOB$9,793.00$58,758.00Per DUA, Fall 2023 to Spring 2024
0005AB1.6.2Draft Programmed Survey1JOB$59,984.00$59,984.0012/8/23
0005AC1.6.3Final Programmed Survey1JOB$59,984.00$59,984.003/15/24
0005AD1.6.4Draft memorandum of sampling plan1JOB$58,784.00$58,784.001/31/24
0005AE1.6.5Final memorandum of sampling plan1JOB$58,784.00$58,784.002/28/24
0005AF1.6.6Weekly data collection updates12JOB$288,132.50$3,457,590.00Monthly during data collection, starting 5/22/2024
0005AG1.6.7Technical memorandum of data collection completion1JOB$15,908.00$15,908.006/11/25
00061.7.0In-Depth Interview Sampling, Recruitment, Data Collection
0006AA1.7.1Draft memorandum of sampling plan1JOB$4,946.00$4,946.0011/15/24
0006AB1.7.2Final memorandum of sampling plan1JOB$4,946.00$4,946.0012/13/24
0006AC1.7.3Weekly data collection updates6JOB$20,576.00$123,456.00Monthly, starting 1/3/2025
0006AD1.7.4Technical memorandum of data collection completion1JOB$123,465.00$123,465.006/6/25
00071.8.0Create Analysis Files & Preliminary Analysis
0007AA1.8.1Revised survey analysis plan or analysis memorandum1JOB$118,420.00$118,420.009/10/25
0007AB1.8.2Revised in-depth interview analysis plan or analysis memorandum1JOB$163,621.00$163,621.001/12/26
00081.9.0Analysis
0008AA1.9.1Draft analytic survey tables & report outline1JOB$42,565.00$42,565.0012/3/25
0008AB1.9.2Revised analytic survey tables & report outline1JOB$42,565.00$42,565.0012/31/25
0008AC1.9.3Final analytic survey tables & report outline1JOB$42,565.00$42,565.001/28/26
0008AD1.9.4Draft analytic qualitative tables & report outline1JOB$56,251.00$56,251.003/9/26
0008AE1.9.5Revised analytic qualitative tables & report outline1JOB$56,251.00$56,251.004/6/26
0008AF1.9.6Final analytic qualitative tables & report outline1JOB$56,251.00$56,251.005/4/26
00091.10.0Prepare & Submit Final Report
0009AA1.10.1Draft final report1JOB$127,510.00$127,510.006/29/26
0009AB1.10.2Revised final report1JOB$127,510.00$127,510.007/27/26
0009AC1.10.3Final report1JOB$127,511.00$127,511.008/24/26
00101.11.0Briefing
0010AA1.11.1PowerPoint slides & handouts for briefing1JOB$20,274.00$20,274.008/3/26
0010AB1.11.2Hard copies & email of the approved presentation for distribution at the briefing1JOB$20,274.00$20,274.008/10/26
00111.12.0Prepare & Submit Data Files & Documentation
0011AA1.12.1Draft public use quantitative data files & documentation1JOB$7,814.00$7,814.008/10/26
0011AB1.12.2Revised public use quantitative data files & documentation1JOB$7,814.00$7,814.008/24/26
0011AC1.12.3Final public use quantitative data files & documentation1JOB$7,813.00$7,813.009/7/26
0011AD1.12.4Draft restricted use quantitative data files & documentation1JOB$7,814.00$7,814.008/10/26
0011AE1.12.5Revised restricted use quantitative data files & documentation1JOB$7,814.00$7,814.008/24/26
0011AF1.12.6Final restricted use quantitative data files & documentation1JOB$7,813.00$7,813.009/7/26
0011AG1.12.7Draft public use qualitative data files & documentation1JOB$7,294.00$7,294.008/10/26
0011AH1.12.8Revised public use qualitative data files & documentation1JOB$7,294.00$7,294.008/24/26
0011AJ1.12.9Final public use qualitative data files & documentation1JOB$7,293.00$7,293.009/7/26
0011AK1.12.10Draft restricted use qualitative data files & documentation1JOB$7,294.00$7,294.008/10/26
0011AL1.12.11Revised restricted use qualitative data files & documentation1JOB$7,295.00$7,295.008/24/26
0011AM1.12.12Final restricted use qualitative data files & documentation1JOB$7,293.00$7,293.009/7/26
SUB TOTAL$7,278,072
TOTAL$7,278,072.00

ByTask

CLINCLIN DESCRIPTIONQUANTITYUNIT COSTTOTAL AMOUNT
1Understanding the Relationship Between Poverty Well-Being and Food Security Status

5 Years

1.1.0Task 1: Project Orientation Meeting and Reporting1$235,872$235,872.42$235,872
1.2.0Task 2: Updated Study Plan1$109,053$109,053.40$109,053
1.3.0Task 3: Prepare Recruitment Materials and Pretest Data Collection Instruments1$235,047$235,047.30$235,047
1.4.0Task 4: Develop Paperwork Reduction Act Clearance Package1$68,826$68,825.86$68,826
1.5.0Task 5: Prepare Data Collection Training Package and Select and Train Data Collectors1$263,562$263,561.94$263,562
1.6.0Task 6: Survey Sampling Frame and Data Collection1$3,769,792$3,769,792.09$3,769,792
1.7.0Task 7: In-Depth Interview Sampling, Recruitment and Data Collection1$256,813$256,812.55$256,813
1.8.0Task 8: Create Analysis Files and Preliminary Analysis1$282,041$282,040.90$282,041
1.9.0Task 9: Analysis1$296,448$296,448.33$296,448
1.10.0Task 10: Prepare and Submit Final Report1$382,531$382,530.78$382,531
1.11.0Task 11: Briefing1$40,548$40,547.94$40,548
1.12.0Task 12: Prepare and Submit Data Files and Documentation1$90,644$90,644.29$90,644
……$6,031,178$6,031,177
Travel* Not-to-Exceed (NTE)$1,246,894
TOTAL$7,278,072
*Travel is in accordance with the Federal Travel Regulation (FTR) contained in 41 Code of Federal Regulations (CFR), Chapters 300 through 304. This is a cost reimbursable line item. Travel shall not be made unless authorized by the COR. Payment will be made for actual expenses with proper supporting documentation.

File details come from the government source that posted it. Updated .