Attachment F- Cost Proposal Template Workbook.xlsx

XLSX spreadsheet 108 KB Posted

Attached to
National Assessment of Educational Progress (NAEP) Alliance
Solicitation number
91990018R0018
Issued by

About this file

From the source

Attachment F

View the file

Other files

File Type Posted
91990018R0018_Amendment_0002_FormSF30(1).pdf PDF
91990018R0018_Amendment_001.pdf PDF
FormSF33-91990018R0018.pdf PDF
Attachment E- NAEP Technical Exhibits.pdf PDF
Attachment G - Contractor Personnel Listing.xlsx XLSX spreadsheet
https://www.fbo.gov/index.php?s=opportunity&mode=form&id=c7fdd361e66c64d618fb510180dc50a2&tab=core&_cview=1 HTML file

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Instructions for completing the NAEP 2019-24 Cost Proposal Template Workbook
19-24 Bidder Assumptions Tab
This tab will be a unifed alliance-wide sumbmission, however contrators shall include this in each of their technical and cost proposal. This will assure that all Alliance members are in agreement and creating individual cost estimates based on common variables.
19-24 ID Assumptions Tab
This tab will be a unifed alliance-wide sumbmission, however contrators shall include this in each of their technical and cost proposal. This will assure that all Alliance members are in agreement and creating individual cost estimates based on common variables.
11.1 Anticipated Cost Categories Tab
Anticipated required cost categories for contractor monthly cost report to include separate columns for hours and dollars for each task with appropriate task label and a summary column on the right. This will be submitted for each cost proposal based on the individual contract requirements. Technical proposal shall include hours; business proposal to include both hours and cost.
11.2 Reporting Components Tab
Summary of reporting categories for contractor monthly cost report by report type to include seperate columns for hours and dollars for each report level with appropriate label and a summary column on the right. This will be submitted for each cost proposal based on the individual contract requirements. Technical proposal shall include hours; business proposal to include both hours and cost.
11.3 Distribution of costs by Cost Component: Assessment Type Tab
Summary of cost categories for contractor by assessment for monthly cost report to include separate columns for hours and dollars for each task with appropriate task label and a summary column on the right. This will be submitted for each cost proposal based on the individual contract requirements.
11.4 Distribution of costs by Cost Component: Subject (and session type) Tab
Summary of cost categories for contractor by assessment and/or session type for monthly cost report to include separate columns for hours and dollars for each task with appropriate task label and a summary column on the right. This will be submitted for each cost proposal based on the individual contract requirements.
2019-24 Annual Expenditure Summary Tab
Offerors shall provide estimated costs for the Period depending on instructions to submit PROPOSAL
2019-24 All Option Summary Tab
Offerors shall provide estimated SUMMARY costs ALL OPTIONS for the Period depending on instructions to submit PROPOSAL
2019-24 Option Template Tab
Offerors shall provide estimated costs FOR EACH OPTION for the Period depending on instructions to submit PROPOSAL
2019-24 Cost By Quarter Tab
Offerors shall provide estimated costs by quarter for each year of the period to submit PROPOSAL

19-24 Bidder Assumptions

YearGrade/AgeAssessmentEstimated Number of Sampled Schools [see note]Estimated Number of Participating Schools [see note]Estimated Number of Sampled StudentsEstimated Number of Participating Students
2020Grade 42021 Writing Pilot (DBA)
2020Grade 82021 Writing Pilot (DBA)
2020Grade 122021 Writing Pilot (DBA)
2020Grade 82022 U.S History Pilot (DBA)
2020Grade 122022 U.S History Pilot (DBA)
2020Grade 82022 Civics Pilot (DBA)
2020Grade 122022 Civics Pilot (DBA)
2020Grade 82022 Geography Pilot (DBA)
2020Grade 122022 Geography Pilot (DBA)
2020Grade 122022 Economics Pilot (DBA)
2020Grade 82022 Technology Engineering and Literacy Pilot (DBA)
2020Grade 122022 Technology Engineering and Literacy Pilot (DBA)
2020Grade 122020 U. S History (Start Up)
2020Grade 122020 Civics (Start Up)
2020Grade 122020 Geography (Start Up)
2021Grade 42021 Reading Operational
2021Grade 82021 Reading Operational
2021Grade 42021 Mathematics Operational
2021Grade 82021 Mathematics Operational
2021Grade 42021 Writing Operational
2021Grade 82021 Writing Operational
2021Grade 122021 Writing Operational
2021Grade 42023 Reading Pilot
2021Grade 82023 Reading Pilot
2021Grade 122023 Reading Pilot
2021Grade 42023 Mathematics Pilot
2021Grade 82023 Mathematics Pilot
2021Grade 122023 Mathematics Pilot
2021Grade 42023 Science Pilot
2021Grade 82023 Science Pilot
2021Grade 122023 Science Pilot
2022Grade 82024 Arts Pilot
2022Grade 122024 Foreign Language Pilot
2022Grade 82022 U.S History Operational
2022Grade 122022 U.S History Operational
2022Grade 82022 Civics Operational
2022Grade 122022 Civics Operational
2022Grade 82022 Geography Operational
2022Grade 122022 Geography Operational
2022Grade 122022 Economics Operational
2022Grade 82022 Technology Engineering and Literacy Operational
2022Grade 122022 Technology Engineering and Literacy Operational
2023Grade 42023 Reading Operational
2023Grade 82023 Reading Operational
2023Grade 122023 Reading Operational
2023Grade 42023 Mathematics Operational
2023Grade 82023 Mathematics Operational
2023Grade 122023 Mathematics Operational
2023Grade 42023 Science Operational
2023Grade 82023 Science Operational
2023Grade 122023 Science Operational
2023Grade 12High School Transcript Study
2024Grade 42025 Reading Pilot
2024Grade 82025 Reading Pilot
2024Grade 42025 Mathematics Pilot
2024Grade 82025 Mathematics Pilot
2024Grade 42025 Writing Pilot
2024Grade 82025 Writing Pilot
2024Grade 122025 Writing Pilot
2024Grade 82024 Arts Operational
2024Grade 122024 Foreign Language Operational
2024Long-Term Trend Operational
Note-- only include numbers for sampled and participating pilot schools if the assessment pilot will NOT be conducted in the same schools as the operational assessments

ADD Any other studies that were included in the total 5-year cost submitted with your original proposal

Revised 12/6/18

&"Arial,Bold"&11Estimated Costs for Various Components of NAEP Assessments in 2008-2012

19-24 ID Assumptions

`YearGrade/AgeAssessmentNumber of blocks neededFinal number of MC items needed (to be delivered)Final number of SCR needed (to be delivered)Final number of ECR needed (to be delivered)
2019Grade 42023 Reading
2019Grade 82023 Reading
2019Grade 122023 Reading
2019Grade 42023 Mathematics
2019Grade 82023 Mathematics
2019Grade 122023 Mathematics
2019Grade 42023 Science
2019Grade 82023 Science
2019Grade 122023 Science
2020Grade 82024 Arts
2020Grade 122024 Foreign Language
0
2022Grade 42025 Reading
2022Grade 82025 Reading
2022Grade 122025 Reading
2022Grade 42025 Mathematics
2022Grade 82025 Mathematics
2022Grade 122025 Mathematics
2022Grade 42025 Writing
2022Grade 82025 Writing
2022Grade 122025 Writing
2023Grade 82026 U.S. History
2023Grade 122026 U.S. History
2023Grade 82026 Civics
2023Grade 122026 Civics
2023Grade 82026 Geography
2023Grade 122026 Geography
2023Grade 122026 Economics
2023Grade 82026 Technology and Engineering Literacy
2023Grade 122026 Technology and Engineering Literacy
2024Grade 42027 Reading
2024Grade 82027 Reading
2024Grade 122027 Reading
2024Grade 42027 Mathematics
2024Grade 82027 Mathematics
2024Grade 122027 Mathematics
2024Grade 42027 Science
2024Grade 82027 Science
2024Grade 122027 Science

ADD Any other studies that were included in the total 5-year cost submitted with your original proposal

Revised 12/6/18

&"Arial,Bold"&11Estimated Costs for Various Components of NAEP Assessments in 2008-2012

11. 1 Anticip. Cost Categories

Exhibit 11-1. Anticipated Required Cost Categories for Contractor Monthly Cost Report (include separate columns for hours and dollars for each task with appropriate task label) and a summary column on the right.
TASK 1TASK 2TASK 3TASK 4TASK 5Additional tasks as neededSUMMARY
Direct Labor CostsHoursCostHoursCostHoursCostHoursCostHoursCostHoursCostHoursCost
On-site Full-time Staff
Staff categories such as
Project Director
Associate Director/Deputy Project Director
Senior Manager/Supervisor
Statistician
Senior Programmer/Analyst
Research Analyst
Junior Programmer
Research Assistant
Other ____________
Other ____________
Other ____________
Admin/Clerical
Total On-site Full-time Labor
Part Time Staff
Staff categories such as
Supervisor
Field data collector
Clerical
Research Analyst
Senior Programmer/Analyst
Research Assistant
Admin/Clerical
Other _________________
Other _________________
Total Part Time Labor
Off-site Staff
Staff categories such as
Supervisor
Field data collector
Clerical
Research Analyst
Senior Programmer/Analyst
Research Assistant
Other _________________
Other _________________
Other _________________
Total Off-site Labor
Total Labor
Other Direct Costs
Telephone
Computing- hardware
Computing- peripherals
Computing- networks
Computing-software development.
Computing-COTS
Copying
Printing
Postage/delivery
Supplies
Travel
Consultants
Meetings
Subcontractors
Outside Services
Total Other Direct Costs
Total Direct Costs
Indirect Costs
Overhead
Permanent/temp labor (__.00%)
Permanent/temp labor (__.00%)
Permanent/temp labor (__.00%)
Permanent/temp labor (other)
Field Labor (___%)
Consultants (___%)
Fringe Benefits (__%)
Fringe Benefits (__%)
Fringe Benefits (__%)
Total Overhead Costs

Total Direct + Overhead

G&A (__%)

Total direct + indirect/ overhead, G&A

Award Fee
Respondent incentive/ reimbursements
TOTAL COST [INCLUDING ALL FEES]

Revised 12/6/18

11.2 Reporting Components

Exhibit 11-2. Reporting Components for NAEP Contractors

Reporting Component 1: Assessment Types

TUDA assessments
State assessments (exclusive of TUDA costs)
National-only assessments
Main assessment, including Long Term Trend (Operational)
Pilot tests
Field Tests
Transcript Studies
Special Studies (delineated by individual study*)

Reporting Component 2: Subjects

Reading
Mathematics
Science
Writing
U.S. History
Economics
Civics
Arts
LTT Mathematics
LTT Reading
Geography
TEL
Foreign Language

Reporting Component 3: Grade

Grade 4
Grade 8
Grade 12

Revised 12/6/18

11.3 Distrib. by Assess Type

11.3 Distribution of costs by Cost Component: Assessment Type

Section A. Use for percentage distribution
By Type of Assessment, Percent Attributable to Each
Actual Dollars, Current Month% TUDA Assessment% State Assessment (minus TUDA)% National Only, broken out by typeTotal National OnlyShow Sum to 100%
LABOR% Main% Pilot% Field% Transcript Study% Special Studies
Total Permanent Labor
Total Part time Labor
Total Off-site Labor
TOTAL LABOR
Other Direct Costs
Travel
Computing
Consultants
Subcontractors
All other ODCs
TOTAL OTHER DIRECT COSTS
Section B. Use only for actual cost input (you may enter actual cost in relevant cell here INSTEAD of entering a percentage in the corresponding cell in Secion A)
By Type of Assessment, Percent Attributable to Each
Actual Dollars, Current MonthTUDA AssessmentState Assessment (minus TUDA)National Only, broken out by typeTotal National Only
LABORMainPilotFieldTranscript StudySpecial Studies
Total Permanent Labor
Total Part time Labor
Total Off-site Labor
TOTAL LABOR
Other Direct Costs
Travel
Computing
Consultants
Subcontractors
All other ODCs
TOTAL OTHER DIRECT COSTS

Revised 12/6/18

11.4 Distribution by Type Sub2

11.4 Distribution of costs by Cost Component: Subject (and session type)

Section A. Use for percentage distribution
By Type of Assessment, Percent Attributable to Each
Actual Dollars, Current Month% Arts% LTT% Reading% Math% Science% Writing% U.S. History% Civics% Geography% Economics% TEL% Foreign Language% TBDShow Sum to 100%
LABOR
Total Permanent Labor
Total Part time Labor
Total Off-site Labor
TOTAL LABOR
Other Direct Costs
Travel
Computing
Consultants
Subcontractors
All other ODCs
TOTAL OTHER DIRECT COSTS
Sec B. Use only for actual cost input (you may enter actual cost in relevant cell here INSTEAD of entering a percentage in the corresponding cell in Secion A)
By Type of Assessment, Percent Attributable to Each
Actual Dollars, Current MonthArtsLTTReadingMathScienceWritingU.S. HistoryCivics% Econ% Geo% TEL% Foreign Language% TBD
LABOR
Total Permanent Labor
Total Part time Labor
Total Off-site Labor
TOTAL LABOR
Other Direct Costs
Travel
Computing
Consultants
Subcontractors
All other ODCs
TOTAL OTHER DIRECT COSTS
Revised 12/6/18

2019-24 Ann Expenditure Summary

Offerors shall provide estimated costs for the Period depending on instructions to submit PROPOSALFull contract estimated amount here$0
Contract Number
ABCDEFGHIJKLMN
Estimated Number of Hours for Entire ContractEstimated Cost of Entire ContractBudgeted Hours for FY19Budgeted Dollars for FY19Budgeted Hours for FY20Budgeted Dollars for FY20Budgeted Hours for FY21Budgeted Dollars for FY21Budgeted Hours for FY22Budgeted Dollars for FY22Budgeted Hours for FY23Budgeted Dollars for FY23Budgeted Hours for FY24Budgeted Dollars for FY24
Permanent staff
Project Director00
Associate Directors/Deputy project directors00
Senior Managers/supervisors00
Statisticians00
Senior Programmers/Analysts00
Research Analysts00
Junior Programmers00
Research Assistants00
Other ____________00
Other ____________00
Other ____________00
Other ____________00
Secretaries/administrative assistants/other clerical support00
Total Permanent Labor000000000000
Temporary staff
Supervisors00
Field data collectors00
Clerical00
Other _________________00
Other _________________00
Other _________________00
Other _________________00
Other _________________00
Other _________________00
Total Temporary Labor000000000000
Other Direct Costs
Telephone0
Computing0
Copying0
Printing0
Postage/delivery0
Supplies0
Travel0
Training/honoraria0
Other _________________0
Other _________________0
Other _________________0
Other _________________0
Total Other Direct Costs000000

Total Direct Costs 0 0 0 0 0 0

Overhead
Permanent labor (___%)0
Temporary labor (___%)0
Field Labor (___%)0
Consultants (___%)0
_______________ (___%)0
Total Overhead000000

Total Direct + Overhead 0 0 0 0 0 0

Total G&A (___%)000000
_______________ (___%)0
_______________ (___%)0
_______________ (___%)0
_______________ (___%)0
Total direct + indirect/overhead G&A000000
Fixed Fee (___%)0
Award fee (___%)0
Respondent incentive/reimbursements0
TOTAL COST [INCLUDING ALL FEE]000000

Revised 12/6/18

To be submitted at the time of Cost Questions

2019-24 All Options Summary

Offerors shall provide estimated costs for the Period depending on instructions to submit PROPOSALAll options estimated amount$0
Contract Number
ABCDEFGHIJKLMN
Estimated Number of Hours for Entire ContractEstimated Cost of Entire ContractBudgeted Hours for FY19Budgeted Dollars for FY19Budgeted Hours for FY20Budgeted Dollars for FY20Budgeted Hours for FY21Budgeted Dollars for FY21Budgeted Hours for FY22Budgeted Dollars for FY22Budgeted Hours for FY23Budgeted Dollars for FY23Budgeted Hours for FY24Budgeted Dollars for FY24
Permanent staff
Project Director00
Associate Directors/Deputy project directors00
Senior Managers/supervisors00
Statisticians00
Senior Programmers/Analysts00
Research Analysts00
Junior Programmers00
Research Assistants00
Other ____________00
Other ____________00
Other ____________00
Other ____________00
Secretaries/administrative assistants/other clerical support00
Total Permanent Labor0000000000000
Temporary staff
Supervisors00
Field data collectors00
Clerical00
Other _________________00
Other _________________00
Other _________________00
Other _________________00
Other _________________00
Other _________________00
Total Temporary Labor00000000000000
Other Direct Costs
Telephone0
Computing0
Copying0
Printing0
Postage/delivery0
Supplies0
Travel0
Training/honoraria0
Other _________________0
Other _________________0
Other _________________0
Total Other Direct Costs0000000

Total Direct Costs

Overhead
Permanent labor (___%)0
Temporary labor (___%)0
Field Labor (___%)0
Consultants (___%)0
_______________ (___%)0
Total Overhead

Total Direct + Overhead

Total G&A (___%)
_______________ (___%)0
_______________ (___%)0
_______________ (___%)0
_______________ (___%)0
Total direct + indirect/overhead G&A
Award fee (___%)0
Respondent incentive/reimbursements0
TOTAL COST [INCLUDING ALL FEE]

Revised 08/27/2018

To be submitted at the time of Cost Questions

2019-24 Option Template

Offerors shall provide estimated costs for the Period depending on instructions to submit PROPOSALOption ________ (fill in option title here)Full option estimated amount$0
Contract Number
ABCDEFGHIJKLMN
Estimated Number of Hours for Entire ContractEstimated Cost of Entire ContractBudgeted Hours for FY19Budgeted Dollars for FY19Budgeted Hours for FY20Budgeted Dollars for FY20Budgeted Hours for FY21Budgeted Dollars for FY21Budgeted Hours for FY22Budgeted Dollars for FY22Budgeted Hours for FY23Budgeted Dollars for FY23Budgeted Hours for FY24Budgeted Dollars for FY24
Permanent staff
Project Director00
Associate Directors/Deputy project directors00
Senior Managers/supervisors00
Statisticians00
Senior Programmers/Analysts00
Research Analysts00
Junior Programmers00
Research Assistants00
Other ____________00
Other ____________00
Other ____________00
Other ____________00
Secretaries/administrative assistants/other clerical support00
Total Permanent Labor000000000000
Temporary staff
Supervisors00
Field data collectors00
Clerical00
Other _________________00
Other _________________00
Other _________________00
Other _________________00
Other _________________00
Other _________________00
Total Temporary Labor000000000000
Other Direct Costs
Telephone0
Computing0
Copying0
Printing0
Postage/delivery0
Supplies0
Travel0
Training/honoraria0
Other _________________0
Other _________________0
Other _________________0
Other _________________0
Total Other Direct Costs000000

Total Direct Costs 0 0 0 0 0 0

Overhead
Permanent labor (___%)0
Temporary labor (___%)0
Field Labor (___%)0
Consultants (___%)0
_______________ (___%)0
Total Overhead000000

Total Direct + Overhead 0 0 0 0 0 0

Total G&A (___%)000000
_______________ (___%)0
_______________ (___%)0
_______________ (___%)0
_______________ (___%)0
Total direct + indirect/overhead G&A000000
Fixed Fee (___%)0
Award fee (___%)0
Respondent incentive/reimbursements0
TOTAL COST [INCLUDING ALL FEE]000000
Revised 08/27/2018

To be submitted at the time of Cost Questions

2019-24 Cost By Quarter Offerors shall provide estimated costs by quarter and cumulative costs for the Period depending on instructions to submit PROPOSAL

Alliance
Planning and CoordinationProgam Support ManagementDesign, Analysis and ReportingItem DevelopmentSampling and Data CollectionNAEP Support and Service CenterMaterials, Distribution, Processing and ScoringWeb/Technology Development, Operations and MaintenanceNAEP Platform DevelopmentNAEP Data WarehouseTotal

Quarter beginning Estimate Cumulative Estimate Cumulative Estimate Cumulative Estimate Cumulative Estimate Cumulative Estimate Cumulative Estimate Cumulative Estimate Cumulative Estimate Cumulative Estimate Cumulative Estimate Cumulative

43647.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

43739.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

43831.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

43922.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44013.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44105.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44197.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44287.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44378.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44470.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44562.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44652.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44743.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44835.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

44927.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

45017.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

45108.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

45200.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

45292.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

45383.000000000000000
Jan-08

Apr-08

Jul-08

Oct-08

Jan-09

Apr-09

Jul-09

Oct-09

Jan-10

Apr-10

Jul-10

Oct-10

Jan-11

Apr-11

Jul-11

Oct-11

Jan-12

Apr-12

Revised 08/27/2018

&A

File details come from the government source that posted it.