RFP_PFDC_Exhibit_E-1.xlsx

XLSX spreadsheet 49 KB Posted Mar 13, 2015

Attached to: Recovery - HITECH Payment File Development Contractor Federal contract opportunity
Solicitation number: HHSM-500-2015-RFP-0110
Issued by: Department of Health and Human Services Centers for Medicare and Medicaid Services

About this file

From the source

RFP PFDC Exhibit E-1

View the file

Other files for this federal contract opportunity

Other files attached to Recovery - HITECH Payment File Development Contractor, newest first.
File	Type	Posted
J.1_HITECH_PFDC_SOW_(Amendment_000001).pdf	PDF	Mar 30, 2015
HHSM-500-2015-RFP-0110_Solicitation_(Amendment_000001).pdf	PDF	Mar 30, 2015
HHSM-500-2015-RFP-0110_(Amendment_000001_SF-30).pdf	PDF	Mar 30, 2015
Questions_ _Answers_for_PFDC.pdf	PDF	Mar 30, 2015
J.11_QA_HHSM-500-2015-RFP-0110.pdf	PDF	Mar 13, 2015
J.1_HITECH_PFDC_SOW.pdf	PDF	Mar 13, 2015
HHSM-500-2015-RFP-0110_Solicitation_Document.pdf	PDF	Mar 13, 2015
J.7_SAMPLE_BANK_NOTIFICATION_LETTER.pdf	PDF	Mar 13, 2015
J.4_Non_Disclosure_Statement.pdf	PDF	Mar 13, 2015
RFP_PFDC_Exhibit_E-3.xlsx	XLSX spreadsheet	Mar 13, 2015
J.8_Past_Performance_Questionnaire.pdf	PDF	Mar 13, 2015
J.9_Virus_Detection_Certification.pdf	PDF	Mar 13, 2015
RFP_PFDC_Exhibit_E-2.xlsx	XLSX spreadsheet	Mar 13, 2015
J.3_Personal_Conflicts_of_Interest_Financial_Disclosure.pdf	PDF	Mar 13, 2015
J.5_HHS_OSDBU_Small_Business_Subcontracting_Plan.pdf	PDF	Mar 13, 2015
J.2_Business_Ethics_Conflict_of_Interst_and_Compliance_Submission_by_Offeror-Contractor.pdf	PDF	Mar 13, 2015
J.6_Subcontractor_Checklist.pdf	PDF	Mar 13, 2015
J.12_CMS_730A_Request_for_Physical_Access_to_CMS_Facilities.pdf	PDF	Mar 13, 2015

Show all 18

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.

Summary

CLIN	DESCRIPTION	COST	FIXED FEE	TOTAL	PERIOD OF PERFORMANCE
0001	Base Period
0002	Option Year 1
0003	Option Year 2
0004	Option Year 3
0005	Option Year 4
TOTAL					60 months
	Instructions:	Instructions will not print.
	1. All labor categories, subcontractors names, additional rows, and descriptive information and percentages required most be linked. (i.e. Summary to Recap to appropriate year)

2. Task columns (hours, rate & total) shall be the corresponding tasks of the SOW.

3. Contractors and subcontractors shall use indirect rates IAW their accounting practises.

4. When there are sub CLIN spreadsheets for any period, place them to the left of the combined period CLIN (e.g., CLIN 0001AA and CLIN 0001AB are sub CLINs of CLIN 0001).

5. Bujsiness proposal provide escalation rates used and their rationaleas a separate paragraph. The same procedure will be followed by subcontractors. Subcontractors who submitted sealed proposals shall also identify the escalation rates and rationale in their sealed proposals. Follow this same procedures for travel.

6. Travel, subcontractor, and other direct costs must be linked from their respective worksheets in to the spreadsheets of each year except when there are sub CLINs. If there are sub CLINs, then the links are into the respective fields of the sub CLINs.

7. All tab names must carry the specific title used in the solicitation/RFP including the appropriate CLIN number. If the government provides different labels in the draft spreadsheets than the labels used in Section B of the solicitation, use the titles in section B.

Edward M. Rutherford: Edward M. Rutherford:

8. No data are to be entered into the Summary and Summary Roll-up by CLIN tabs -- they should populate automatically from subordinate spreadsheets (combined CLIN and primary CLIN spreadsheets as opposed to sub CLIN spreadsheets).

9. All FTE columns are to be calculated using 1880 in the denominator, for both the prime and subcontractors even if the subcontractors use a different basis for their workyear.

10. Follow the format in headers and footers.

11. The date required in the footer is the date submitted, not the date the spreadsheet is opened or printed.

Exhibit E.1 &"Arial,Bold Italic"(Company Name)&"Arial,Regular"

RFP-CMS-2010-0031

PFDC &P of &N

&"Arial,Bold Italic"Date used is the date sent to OAGM, not the date button from above.&"Arial,Regular"

Confidential - Procurement Sensitive &"Arial,Bold Italic"&A

Summary Roll Up by CLIN Payment File Development Contractor CLIN 0001, Base Year CLIN 0002, Option Year 2 CLIN 0003, Option Year 3 CLIN 0004, Option Year 3 Total All Years

Tasks
	Total FTEs	Hours	Rates	Total	Total FTEs	Hours	Rates	Total	Total FTEs	Hours	Rates	Total	Total FTEs	Hours	Rates	Total	Total FTEs	Hours	Rates	Total
COST ELEMENTS
Direct Labor (Add appropriate categories)
	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00		$0
	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00		$0
	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00		$0
	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00		$0
	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00		$0
	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00		$0
	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00	$0.00	$0	0.00	0.00		$0
SUBTOTAL DIRECT LABOR	0.00	0.00		$0	0.00	0.00		$0	0.00	0.00		$0	0.00	0.00		$0	0.00	0.00		$0

Fringe Benefits (at ____%) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0 0.00% $0 0.00% $0

TOTAL DIRECT LABOR $0 $0 $0 $0 $0

Travel (See separate schedule E-2)	$0	$0	$0	$0	$0
Subcontractors (list all subcontractors)

Subcontractor Name
Total Subcontractor	0.00	0.00	$0.00	0.00	0.00	$0.00	0.00	0.00	$0.00	0.00	0.00	$0.00	0.00	0.00	$0

Other Direct Costs (See separate schedule E-3) $0 $0 $0 $0 $0

SUBTOTAL ALL DIRECT COSTS $0 $0 $0 $0 $0

Indirect Costs (at ______ %) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0 0.00% $0 0.00% $0

SUBTOTAL COSTS BEFORE FEE $0 $0 $0 $0 $0

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0 0.00% $0 0.00% $0

Fixed Fee (at ______%) 0.00% $0 0.00% $0 0.00% $0 0.00% $0 0.00% $0

TOTAL COSTS 0.00 0.00 $0 0.00 0.00 $0 0.00 0.00 $0 0.00 0.00 $0 0.00 0.00 $0

Exhibit E.1 &"Arial,Bold Italic"(Company Name)&"Arial,Regular"

PFDC &P of &N

&"Arial,Bold Italic"Date used is the date sent to OAGM, not the date button from above.&"Arial,Regular"

&"Arial,Bold Italic"&A

CLIN 0001 Base Period

Payment File Development Contractor
Time frame (date from & to)
Tasks	Total FTEs	TASK # (per SOW)			TASK # (per SOW)			GRAND TOTAL
		Hours	Rates	Total	Hours	Rates	Total	Hours	Rates	Total
COST ELEMENTS
Direct Labor (Add appropriate categories)
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
SUBTOTAL DIRECT LABOR	0.00	0.00		$0	0.00		$0	0.00		$0

Fringe Benefits (at ____%) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

TOTAL DIRECT LABOR $0 $0 $0

Travel (See separate schedule E-2)	$0	$0	$0
Subcontractors (list all subcontractors)

Subcontractor Name
Total Subcontractor	0.00	0.00	$0.00	0.00	0.00	$0.00	0.00	0.00

Other Direct Costs (See separate schedule E-3) $0 $0 $0

SUBTOTAL ALL DIRECT COSTS 0.00 0.00 $0 $0 $0

Indirect Costs (at ______ %) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

SUBTOTAL COSTS BEFORE FEE $0 $0 $0

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

Award Fee (at _____%) (if applicable) 0.00% $0 0.00% $0 0.00% $0

Fixed Fee (at ______%) 0.00% $0 0.00% $0 0.00% $0

TOTAL COSTS 0.00 $0 $0 $0

Exhibit E.1 &"Arial,Bold Italic"(Company Name)&"Arial,Regular"

PFDC &P of &N

&"Arial,Bold Italic"Date used is the date sent to OAGM, not the date button from above.&"Arial,Regular"

&"Arial,Bold Italic"&A

CLIN 0002 Option Year 1

Payment File Development Contractor
Time frame (date from & to)
Tasks	Total FTEs	TASK # (per SOW)			TASK # (per SOW)			GRAND TOTAL
		Hours	Rates	Total	Hours	Rates	Total	Hours	Rates	Total
COST ELEMENTS
Direct Labor (Add appropriate categories)
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
SUBTOTAL DIRECT LABOR	0.00	0.00		$0	0.00		$0	0.00		$0

Fringe Benefits (at ____%) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

TOTAL DIRECT LABOR $0 $0 $0

Travel (See separate schedule E-2)	$0	$0	$0
Subcontractors (list all subcontractors)

Subcontractor Name
Total Subcontractor	0.00	0.00	$0.00	0.00	0.00	$0.00	0.00	0.00

Other Direct Costs (See separate schedule E-3) $0 $0 $0

SUBTOTAL ALL DIRECT COSTS 0.00 0.00 $0 $0 $0

Indirect Costs (at ______ %) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

SUBTOTAL COSTS BEFORE FEE $0 $0 $0

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

Award Fee (at _____%) (if applicable) 0.00% $0 0.00% $0 0.00% $0

Fixed Fee (at ______%) 0.00% $0 0.00% $0 0.00% $0

TOTAL COSTS 0.00 $0 $0 $0

Exhibit E.1 &"Arial,Bold Italic"(Company Name)&"Arial,Regular"

PFDC &P of &N

&"Arial,Bold Italic"Date used is the date sent to OAGM, not the date button from above.&"Arial,Regular"

&"Arial,Bold Italic"&A

CLIN 0003 Option Year 2

Payment File Development Contractor
Time frame (date from & to)
Tasks	Total FTEs	TASK # (per SOW)			TASK # (per SOW)			GRAND TOTAL
		Hours	Rates	Total	Hours	Rates	Total	Hours	Rates	Total
COST ELEMENTS
Direct Labor (Add appropriate categories)
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
SUBTOTAL DIRECT LABOR	0.00	0.00		$0	0.00		$0	0.00		$0

Fringe Benefits (at ____%) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

TOTAL DIRECT LABOR $0 $0 $0

Travel (See separate schedule E-2)	$0	$0	$0
Subcontractors (list all subcontractors)

Subcontractor Name
Total Subcontractor	0.00	0.00	$0.00	0.00	0.00	$0.00	0.00	0.00

Other Direct Costs (See separate schedule E-3) $0 $0 $0

SUBTOTAL ALL DIRECT COSTS 0.00 0.00 $0 $0 $0

Indirect Costs (at ______ %) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

SUBTOTAL COSTS BEFORE FEE $0 $0 $0

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

Award Fee (at _____%) (if applicable) 0.00% $0 0.00% $0 0.00% $0

Fixed Fee (at ______%) 0.00% $0 0.00% $0 0.00% $0

TOTAL COSTS 0.00 $0 $0 $0

Exhibit E.1 &"Arial,Bold Italic"(Company Name)&"Arial,Regular"

PFDC &P of &N

&"Arial,Bold Italic"Date used is the date sent to OAGM, not the date button from above.&"Arial,Regular"

&"Arial,Bold Italic"&A

CLIN 0004 Option Year 3

Payment File Development Contractor
Time frame (date from & to)
Tasks	Total FTEs	TASK # (per SOW)			TASK # (per SOW)			GRAND TOTAL
		Hours	Rates	Total	Hours	Rates	Total	Hours	Rates	Total
COST ELEMENTS
Direct Labor (Add appropriate categories)
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
SUBTOTAL DIRECT LABOR	0.00	0.00		$0	0.00		$0	0.00		$0

Fringe Benefits (at ____%) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

TOTAL DIRECT LABOR $0 $0 $0

Travel (See separate schedule E-2)	$0	$0	$0
Subcontractors (list all subcontractors)

Subcontractor Name
Total Subcontractor	0.00	0.00	$0.00	0.00	0.00	$0.00	0.00	0.00

Other Direct Costs (See separate schedule E-3) $0 $0 $0

SUBTOTAL ALL DIRECT COSTS 0.00 0.00 $0 $0 $0

Indirect Costs (at ______ %) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

SUBTOTAL COSTS BEFORE FEE $0 $0 $0

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

Award Fee (at _____%) (if applicable) 0.00% $0 0.00% $0 0.00% $0

Fixed Fee (at ______%) 0.00% $0 0.00% $0 0.00% $0

TOTAL COSTS 0.00 $0 $0 $0

Exhibit E.1 &"Arial,Bold Italic"(Company Name)&"Arial,Regular"

PFDC &P of &N

&"Arial,Bold Italic"Date used is the date sent to OAGM, not the date button from above.&"Arial,Regular"

&"Arial,Bold Italic"&A

CLIN 0005 Option Year 4

Payment File Development Contractor
Time frame (date from & to)
Tasks	Total FTEs	TASK # (per SOW)			TASK # (per SOW)			GRAND TOTAL
		Hours	Rates	Total	Hours	Rates	Total	Hours	Rates	Total
COST ELEMENTS
Direct Labor (Add appropriate categories)
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
	0.00	0.00	$0.00	$0	0.00	$0.00	$0	0.00	$0.00	$0
SUBTOTAL DIRECT LABOR	0.00	0.00		$0	0.00		$0	0.00		$0

Fringe Benefits (at ____%) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

TOTAL DIRECT LABOR $0 $0 $0

Travel (See separate schedule E-2)	$0	$0	$0
Subcontractors (list all subcontractors)

Subcontractor Name
Total Subcontractor	0.00	0.00	$0.00	0.00	0.00	$0.00	0.00	0.00

Other Direct Costs (See separate schedule E-3) $0 $0 $0

SUBTOTAL ALL DIRECT COSTS 0.00 0.00 $0 $0 $0

Indirect Costs (at ______ %) (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

SUBTOTAL COSTS BEFORE FEE $0 $0 $0

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practise) 0.00% $0 0.00% $0 0.00% $0

Award Fee (at _____%) (if applicable) 0.00% $0 0.00% $0 0.00% $0

Fixed Fee (at ______%) 0.00% $0 0.00% $0 0.00% $0

TOTAL COSTS 0.00 $0 $0 $0

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