AttachmentJ_BusinessProposalWorksheet_12_revised_5-28-09.xls

XLS spreadsheet 138 KB Posted Jun 8, 2009

Attached to: 2011-12 NATIONAL POSTSECONDARY STUDENT AID STUDY (NPSAS:12) Federal contract opportunity
Solicitation number: ED-IES-09-R-0015
Issued by: Department of Education Contracts and Acquisition Management

About this file

From the source

Attachment J - Worksheet for Business proposal

View the file

Other files for this federal contract opportunity

Other files attached to 2011-12 NATIONAL POSTSECONDARY STUDENT AID STUDY (NPSAS:12), newest first.
File	Type	Posted
AttachmentE_Security_Procedures_12_pagenumbers.doc	DOC document	Jun 8, 2009
Attachment N - Pricing Table.doc	DOC document	Jun 8, 2009
AttachmentL_ContractorInformationForm_12_pagenumbers.doc	DOC document	Jun 8, 2009
AttachmentD_WebDASspecs_12_pagenumbers.doc	DOC document	Jun 8, 2009
AttachmentG_DataElements_12.xls	XLS spreadsheet	Jun 8, 2009
AttachmentI_TechnicalProposalWorksheet_12.xls	XLS spreadsheet	Jun 8, 2009
AttachmentC_Billing_Instructions_12_pagenumbers.doc	DOC document	Jun 8, 2009
Attachment O - Conflict of Interest Certification Form.doc	DOC document	Jun 8, 2009
AttachmentA_PWS 5-28-08.doc	DOC document	Jun 8, 2009
AttachmentB_AwardFeeExhAB_12_revised 5-28-09.xls	XLS spreadsheet	Jun 8, 2009
AttachmentF_AdditionalSecurityCompliance_12_pagenumbers.doc	DOC document	Jun 8, 2009
AttachmentM_SmallBusinessSubcontractingPlan_12_pagenumbers.doc	DOC document	Jun 8, 2009
RFP - NPSAS.pdf	PDF	Jun 8, 2009
NPSAS Draft SOW 4-15-09.doc	DOC document	Apr 15, 2009

Show all 14

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

Try for free Login

Text version

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

ATTACH_J_Sheet1

ATTACHMENT J RFP ED-09-R-0185

Worksheet #1 of 8 for Business Proposal for NPSAS:12

As part of their business proposal, offerors shall submit the information requested using the following format exactly. Costs presented

in this worksheet shall be for the work described in the offeror's technical proposal, including the technical proposal worksheet.

Answers provided on this worksheet will be used (in part) in evaluating offerors' business proposals. Thus, this worksheet is intended

primarily to assist the COR and CO in evaluating the business proposal based on the specific assumptions made by the offeror in the

technical proposal. In addition to completing each worksheet and submitting as part of their business proposal, offerors shall submit

each worksheet and their entire project budget by task and subtask, in an Excel spreadsheet on a CD (i.e., three

separate files). (Any FTS costs that can be billed directly to the government should not be included in the cost estimates below.

Any long distance telephone charges not billed through the FTS should be included in the cost estimates below.)

BASE CONTRACT

OPTION 1 Full-scale study in 2011 instead of 2012

OPTION 2 50 states, 4 sectors

OPTION 3 Add sample size

OPTION 4 Add data elements

OPTION 5a NPSAS incentives

OPTION 5b BPS:12/14 incentives

OPTION 5c BPS:12/17 incentives

OPTION 6 BPS:12/14

OPTION 7 BPS:12/17

OPTION 8 BPS High school transcript collection

OPTION 9 BPS Postsecondary transcript collection

OPTION 10 BPS:12/14 collection of financial aid data

OPTION 11 BPS:14/17 collection of financial aid data

OPTION 12 BPS:04/06/09 matching to administrative databases

COST REIMBURSEMENT TASKS

STUDY ACTIVITY

FIELD TEST CATI (web-based)

CATI Training

Total costs for CATI supervisor training:

Total costs for CATI interviewer training only:

Field Test CATI/web instrumentation

(NOTE: Include programming costs with each CATI, but do not include data collector or interviewer training with cost estimates for the specific CATI component).

Total costs for field test CATI/web-based data collection:

FULL-SCALE DATA COLLECTION

Total costs for CATI supervisor training:

Total costs for full-scale CATI interviewer training only:

Total costs for full-scale CATI

(including programming; excluding training):

Total costs for the full-scale data collection:

DATA LIBRARY

Total costs of initial data analysis system input files:

Total costs of initial restricted-use electronic codebooks

EVALUATION

Number of evaluation activities associated with the field test:

Number of evaluation activities associated with the full scale study:

Total cost for all evaluation activities for this component, including description to be included in Methodology report:

FIRST LOOK/DESCRIPTIVE REPORTS

For the First Look report:

Computing costs to analyze data, prepare & submit report:

Total costs for proposed First Look report:

For the Descriptive Reports:

Computing costs to analyze data, prepare & submit reports:

Total costs for all proposed tabulations/reports:

Methodology Reports (field test and full-scale reports

Computing costs to analyze data, prepare & submit reports:

Total costs for reports:

Final Technical Report

Total costs for report:

Total costs for methodology and other reports (listed above):

FOR SPECIAL TABULATIONS/ANALYSES

Number of data analysis system input files (enter a value from 5 to 50 based on the number of (sets of) DAS input files you expect to deliver as directed by NCES COR

Computing costs for creating input files for data analysis systems:

Computing costs to analyzing data, prepare and submit all special analysis and tabulations:

Total costs to analyze data, prepare and submit

special analyses and tabulations:

Computing costs for all reports and analyses:

Total costs for all reports/tabulations listed above:

For Locator/Directory File Transfer to NCES

Total costs for directory file activities:

Total costs for other Data Library activities:

Total costs for other activities not listed above:

STUDY SUMMARY

FIELD TEST (TOTAL)

FIELD TEST INSTRUMENTATION

FIELD TEST TRAINING

FIELD TEST DATA COLLECTION

FULL-SCALE (TOTAL)

FULL SCALE INSTRUMENTATION

FULL-SCALE STUDY TRAINING

FULL-SCALE DATA COLLECTION

DESCRIPTIVE FIRST LOOK/ REPORTS/ DATA ANALYSIS SYSTEMS, RESTRICTED-USE ELECTRONIC CODEBOOKS

DATA LIBRARY

METHODOLOGY REPORT

SPECIAL TABULATIONS/ANALYSES

Final Technical Report(s)

Total estimated cost for this component excluding long distance telephone charges

Proposed fixed fee

Estimated long-distance telephone charges billed directly to FTS

TOTAL ESTIMATED STUDY A32COST INCLUDING ALL LONG-DISTANCE TELEPHONE CHARGES (PLUS FIXED FEE)

Award fee

TOTAL

FIXED PRICE TASKS

STUDY ACTIVITY

PROJECT MANAGEMENT (including monthly reports)

Total person-days of project director time:

Total costs for all project management tasks:

TECHNICAL REVIEW PANEL

Number of panel members:

OMB PACKAGES:

INTEGRATED MONITORING SYSTEM

STUDY SUMMARY

PROJECT MANAGEMENT (including monthly reports)

TECHNICAL REVIEW PANEL

OMB PACKAGES:

INTEGRATED MONITORING SYSTEM

PROFIT/FEE

TOTAL

&LATTACHMENT J - Page &P

ATTACH_J_Sheet2

Attachment J ED 09 R 0185 Worksheet 2 of 8
Cost Estimate for each Task/subtask across Contractor/subcontractors to Conduct NPSAS:12
																	Base Contract Plus Options 5a, 5b, 5c, 6, and 7	Base Contract PlusOptions 5a, 5b, 5c, 6, 7, 8, 9, 10, and 11
		BASE CONTRACT	OPTION 1 NPSAS:11 instead of NPSAS:12	OPTION 2 50 states, 4 sectors	OPTION 3 Add sample size	OPTION 4 Add data elements	OPTION 5a NPSAS incentives	OPTION 5b BPS:12/14 incentives	OPTION 5c BPS:12/17 incentives	OPTION 6 BPS:12/14	OPTION 7 BPS:12/17	OPTION 8 BPS High school transcripts	OPTION 9 BPS Postsecondary transcripts	OPTION 10 BPS:12/14 collection of financial aid data	OPTION 11 BPS:14/17 collection of financial aid data	OPTION 12 BPS:04/06/09 matching to administrative databases	Contract Amount	Contract Amount
Project Task - Cost Reimbursement
2100	Field Test Design/sampling/contacting																0	0
2310	FT Instrumentation																0	0
2320	FT Institutional Data Collection Training																0	0
2330	FT Institutional/Administrative Data Collection																0	0
2340	FT Tracing/locating																0	0
2350	FT CATI/CAPI Training																0	0
2360	FT Web/CATI/CAPI/Re-interview Data Collection																0	0
2370	FT Data Processing/File Development																0	0
2400	FT Methodology Report																0	0
3100	FS Design/sampling/contacting																0	0
3310	FS Instrumentation																0	0
3320	FS Institutional Data Collection Training																0	0
3330	FS Institutional/Administrative Data Collection																0	0
3340	FS Tracing/locating																0	0
3350	FS CATI/CAPI Training																0	0
3360	FS WEB CATI/CAPI Data Collection (incl. ECB input files)																0	0
3370	FS Data Processing/File Development																0	0
3380	FS Perturbation, imputations, weighting, non-response bias																0	0
3400	Methodology Report																0	0
4100	First Look/ED TABS																0	0
4200	Data Analysis System (DAS)																0	0
4300	Special Tabulations																0	0
4400	Descriptive Summary Reports																0	0
4500	Help desk/info/DAS support																0	0
	Proposed fixed fee
	Award fee maximum (See Section H)																0	0
	Total (including fixed fee and maximum maximum award fee)																0	0
Project Task - Fixed Price
1100	Initial Meeting																0	0
1200	Schedules																0	0
1300	Monthly Project Reports																0	0
1400	Integrated Monitoring System																0	0
1500	Technical Review Panel																0	0
2200	FT OMB Clearances																0	0
3200	FS OMB Clearances																0	0
	Profit
	Total

&LATTACHMENT J - Page 1

ATTACH_J_Sheet3

ATTACHMENT J RFP ED-09-R-0185

Worksheet #3 of 8 for Business Proposal for NPSAS:12

Costs for the 2011–12 National Postsecondary Student Aid Study (NPSAS:12) base contract by year1

Summary by Year

Hourly

Year 1

Year 2

Year 3

Year 4

Year 5

Total

Rate

Hours

Cost

Hours

Cost

Hours

Cost

Hours

Cost

Hours

Cost

Hours

Cost

COST REIMBURSEMENT TASKS

Direct Labor

Project Director

Task leaders

Statisticians

Analysts

Technicians

Support staff

Total Labor

Fringe Benefits

Subtotal

Indirect Costs

Computer expenses

Consultants

Materials

Services

Shipping & postage

Subcontractors

Telephone

Telephone interviewers

Travel

Total Indirect Costs

Subtotal

G&A@15%

Subtotal

Fixed Fee@3.5%

QASP Fee @ approx 4%2

Total

FIXED PRICE TASKS

Direct Labor

Project Director

Task leaders

Statisticians

Analysts

Technicians

Support staff

Total Labor

Fringe Benefits

Subtotal

Indirect Costs

Computer expenses

Consultants

Materials

Services

Shipping & postage

Subcontractors

Telephone

Telephone interviewers

Travel

Total Indirect Costs

Subtotal

G&A

Subtotal

Profit

TOTAL

NPSAS:12 IT Costs

NPSAS:12 Non-IT Costs

1The estimates in this worksheet assume that the base contract will be funded and option 5a (incentives) for NPSAS.

2No award fee is calculated for incentives included in Task 3.

G&A@15% G&A

ATTACH_J_Sheet4

ATTACHMENT J RFP ED-09-R-0185
Worksheet #4 of 8 for Business Proposal for NPSAS:12
Year 1 Costs for the 2011–12 National Postsecondary Student Aid Study (NPSAS:12) base contract1
	Task 1			Task 2		Task 3		Task 4
	Hourly	Management, IMS, TRP		Field test		Full-scale		Data processing/reports		Total
	Rate	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost
Direct Labor
Project Director
Task leaders
Statisticians
Analysts
Technicians
Support staff
Total Labor
Fringe Benefits@150%
Subtotal
Indirect Costs
Computer expenses
Consultants
Materials
Services
Shipping & postage
Subcontractors
Telephone
Telephone interviewers
Travel
Total Indirect Costs
Subtotal
G&A@15%
Subtotal
Fixed Fee@3.5%
QASP Fee @ approx 4%2
TOTAL
FIXED PRICE TASKS
Direct Labor
Project Director
Task leaders
Statisticians
Analysts
Technicians
Support staff
Total Labor
Fringe Benefits
Subtotal
Indirect Costs
Computer expenses
Consultants
Materials
Services
Shipping & postage
Subcontractors
Telephone
Telephone interviewers
Travel
Total Indirect Costs
Subtotal
G&A
Subtotal
Profit
TOTAL
NPSAS:12 IT Costs
NPSAS:12 Non-IT Costs
1The estimates in this worksheet assume that the base contract will be funded and option 5a (incentives) for NPSAS.
2No award fee is calculated for incentives included in Task 3.

G&A@15% G&A

ATTACH_J_Sheet5

ATTACHMENT J RFP ED-09-R-0185
Worksheet #5 of 8 for Business Proposal for NPSAS:12
Year 2 Costs for the 2011–12 National Postsecondary Student Aid Study (NPSAS:12) base contract1
	Task 1			Task 2		Task 3		Task 4
	Hourly	Management, IMS, TRP		Field test		Full-scale		Data processing/reports		Total
	Rate	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost
Direct Labor
Project Director
Task leaders
Statisticians
Analysts
Technicians
Support staff
Total Labor
Fringe Benefits@150%
Subtotal
Indirect Costs
Computer expenses
Consultants
Materials
Services
Shipping & postage
Subcontractors
Telephone
Telephone interviewers
Travel
Total Indirect Costs
Subtotal
G&A@15%
Subtotal
Fixed Fee@3.5%
QASP Fee @ approx 4%2
TOTAL
FIXED PRICE TASKS
Direct Labor
Project Director
Task leaders
Statisticians
Analysts
Technicians
Support staff
Total Labor
Fringe Benefits
Subtotal
Indirect Costs
Computer expenses
Consultants
Materials
Services
Shipping & postage
Subcontractors
Telephone
Telephone interviewers
Travel
Total Indirect Costs
Subtotal
G&A
Subtotal
Profit
TOTAL
NPSAS:12 IT Costs
NPSAS:12 Non-IT Costs
1The estimates in this worksheet assume that the base contract will be funded and option 5a (incentives) for NPSAS.
2No award fee is calculated for incentives included in Task 3.

G&A@15% G&A

ATTACH_J_Sheet6

ATTACHMENT J RFP ED-09-R-0185
Worksheet #6 of 8 for Business Proposal for NPSAS:12
Year 3 Costs for the 2011–12 National Postsecondary Student Aid Study (NPSAS:12) base contract1
	Task 1			Task 2		Task 3		Task 4
	Hourly	Management, IMS, TRP		Field test		Full-scale		Data processing/reports		Total
	Rate	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost
Direct Labor
Project Director
Task leaders
Statisticians
Analysts
Technicians
Support staff
Total Labor
Fringe Benefits@150%
Subtotal
Indirect Costs
Computer expenses
Consultants
Materials
Services
Shipping & postage
Subcontractors
Telephone
Telephone interviewers
Travel
Total Indirect Costs
Subtotal
G&A@15%
Subtotal
Fixed Fee@3.5%
QASP Fee @ approx 4%2
TOTAL
FIXED PRICE TASKS
Direct Labor
Project Director
Task leaders
Statisticians
Analysts
Technicians
Support staff
Total Labor
Fringe Benefits
Subtotal
Indirect Costs
Computer expenses
Consultants
Materials
Services
Shipping & postage
Subcontractors
Telephone
Telephone interviewers
Travel
Total Indirect Costs
Subtotal
G&A
Subtotal
Profit
TOTAL
NPSAS:12 IT Costs
NPSAS:12 Non-IT Costs
1The estimates in this worksheet assume that the base contract will be funded and option 5a (incentives) for NPSAS.
2No award fee is calculated for incentives included in Task 3.

G&A@15% G&A

ATTACH_J_Sheet7

ATTACHMENT J RFP ED-09-R-0185
Worksheet #7 of 8 for Business Proposal for NPSAS:12
Year 4 Costs for the 2011–12 National Postsecondary Student Aid Study (NPSAS:12) base contract1
	Task 1			Task 2		Task 3		Task 4
	Hourly	Management, IMS, TRP		Field test		Full-scale		Data processing/reports		Total
	Rate	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost
Direct Labor
Project Director
Task leaders
Statisticians
Analysts
Technicians
Support staff
Total Labor
Fringe Benefits@150%
Subtotal
Indirect Costs
Computer expenses
Consultants
Materials
Services
Shipping & postage
Subcontractors
Telephone
Telephone interviewers
Travel
Total Indirect Costs
Subtotal
G&A@15%
Subtotal
Fixed Fee@3.5%
QASP Fee @ approx 4%2
TOTAL
FIXED PRICE TASKS
Direct Labor
Project Director
Task leaders
Statisticians
Analysts
Technicians
Support staff
Total Labor
Fringe Benefits
Subtotal
Indirect Costs
Computer expenses
Consultants
Materials
Services
Shipping & postage
Subcontractors
Telephone
Telephone interviewers
Travel
Total Indirect Costs
Subtotal
G&A
Subtotal
Profit
TOTAL
NPSAS:12 IT Costs
NPSAS:12 Non-IT Costs
1The estimates in this worksheet assume that the base contract will be funded and option 5a (incentives) for NPSAS.
2No award fee is calculated for incentives included in Task 3.

G&A@15% G&A

ATTACH_J_Sheet8

ATTACHMENT J RFP ED-09-R-0185
Worksheet #8 of 8 for Business Proposal for NPSAS:12
Year 5 Costs for the 2011–12 National Postsecondary Student Aid Study (NPSAS:12) base contract1
	Task 1			Task 2		Task 3		Task 4
	Hourly	Management, IMS, TRP		Field test		Full-scale		Data processing/reports		Total
	Rate	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost
Direct Labor
Project Director
Task leaders
Statisticians
Analysts
Technicians
Support staff
Total Labor
Fringe Benefits@150%
Subtotal
Indirect Costs
Computer expenses
Consultants
Materials
Services
Shipping & postage
Subcontractors
Telephone
Telephone interviewers
Travel
Total Indirect Costs
Subtotal
G&A@15%
Subtotal
Fixed Fee@3.5%
QASP Fee @ approx 4%2
TOTAL
FIXED PRICE TASKS
Direct Labor
Project Director
Task leaders
Statisticians
Analysts
Technicians
Support staff
Total Labor
Fringe Benefits
Subtotal
Indirect Costs
Computer expenses
Consultants
Materials
Services
Shipping & postage
Subcontractors
Telephone
Telephone interviewers
Travel
Total Indirect Costs
Subtotal
G&A
Subtotal
Profit
TOTAL
NPSAS:12 IT Costs
NPSAS:12 Non-IT Costs
1The estimates in this worksheet assume that the base contract will be funded and option 5a (incentives) for NPSAS.
2No award fee is calculated for incentives included in Task 3.

G&A@15% G&A

Option 1 Offerors are to Price each Option (1-12)

Option 2 Op

Option 3

Option 4 Op

Option 5

Option 6 O

Option 7

Option 8

Option 9

Option 10

Option 11

Option 12

File details come from the government source that posted it. Updated Nov 14, 2017.