MPAPA_Exhibit_E-1.xlsx

XLSX spreadsheet 54 KB Posted

Attached to
Medicare Part A Provider Cost Report Appeals (MPAPA)
Solicitation number
HHSM-500-2013-RFP-0030
Issued by

About this file

Exhibit E-1

View the file

Other files

Show all 23

On GovTribe

Work with this file

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

Text version

Summary

CLINDESCRIPTIONCOSTFIXED FEETOTALPERIOD OF PERFORMANCE
0001Base Year (Year 1 Costs)
0002Option Year 1 (Year 2 Costs)
0003Option Year 2 (Year 3 Costs)
0004Option Year 3 (Year 4 Costs)
0005Option Year 4 (Year 5 Costs)
TOTAL$0.00$0.00$0.0060 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. Follow the format in headers and footers.
10. The date required in the footer is the date submitted, not the date the spreadsheet is opened or printed.

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

RFP HHSM-500-2013-RFP-0030

MPAPA &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

HHSM-500-2013-RFP-0030CLIN 0001, Base YearCLIN 0002, Year 2, Option Year 1CLIN 0003, Year 3, Option Year 2CLIN 0004, Year 4, Option Year 3CLIN 0005, Year 5, Option Year 4Total All Years
MPAPA
Tasks
Total FTEsHoursRatesTotalTotal FTEsHoursRatesTotalTotal FTEsHoursRatesTotalTotal FTEsHoursRatesTotalTotal FTEsHoursRatesTotalTotal FTEsHoursRatesTotal
COST ELEMENTS
Direct Labor (Add appropriate categories)
0.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0
0.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0
0.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0
0.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0
0.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0
0.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0
0.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0.00$00.000.00$0
SUBTOTAL DIRECT LABOR0.000.00$00.000.00$00.000.00$00.000.00$00.000.00$00.000.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 0.00% $0

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

Travel (See separate schedule E-2)$0$0$0$0$0$0
Subcontractors (list all subcontractors)
Subcontractor Name
Total Subcontractor0.000.00$0.000.000.00$0.000.000.00$0.000.000.00$0.000.000.00$0.000.000.00$0

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

SUBTOTAL ALL DIRECT COSTS $0 $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 0.00% $0

SUBTOTAL COSTS BEFORE FEE $0 $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 0.00% $0

Fixed Fee (at ______%) 0.00% $0 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 0.00 0.00 $0

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

MPAPA &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 01 Base Year

HHSM-500-2013-RFP-0030
MPAPASOW Sections
Total FTEsTask 1Task 2Task 3GRAND TOTAL
HoursRatesTotalHoursRatesTotalHoursRatesTotalHoursRatesTotal
COST ELEMENTS
Direct Labor (Add appropriate categories)
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
SUBTOTAL DIRECT LABOR0.000.00$00.00$00.00$00.00$0

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

TOTAL DIRECT LABOR $0 $0 $0 $0

Travel (See separate schedule E-2)$0$0$0$0
Subcontractors (list all subcontractors)
Subcontractor Name
Total Subcontractor0.000.00$0.000.000.000.000.00$0.000.000.00

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

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

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

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

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practice) 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

TOTAL COSTS 0.00 $0 $0 $0 $0

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

MPAPA &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 02 Yr 2 Opt Yr 1

HHSM-500-2013-RFP-0030
MPAPASOW Sections
Total FTEsTask 1Task 2Task3GRAND TOTAL
HoursRatesTotalHoursRatesTotalHoursRatesTotalHoursRatesTotal
COST ELEMENTS
Direct Labor (Add appropriate categories)
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
SUBTOTAL DIRECT LABOR0.000.00$00.00$00.00$00.00$0

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

TOTAL DIRECT LABOR $0 $0 $0 $0

Travel (See separate schedule E-2)$0$0$0$0
Subcontractors (list all subcontractors)
Subcontractor Name
Total Subcontractor0.000.00$0.000.000.000.000.00$0.000.000.00

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

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

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

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

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practice) 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

TOTAL COSTS 0.00 $0 $0 $0 $0

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

MPAPA &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 03 Yr 3 Opt Yr 2

HHSM-500-2013-RFP-0030
MPAPASOW Sections
Total FTEsTask 1Task 2Task 3GRAND TOTAL
HoursRatesTotalHoursRatesTotalHoursRatesTotalHoursRatesTotal
COST ELEMENTS
Direct Labor (Add appropriate categories)
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
SUBTOTAL DIRECT LABOR0.000.00$00.00$00.00$00.00$0

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

TOTAL DIRECT LABOR $0 $0 $0 $0

Travel (See separate schedule E-2)$0$0$0$0
Subcontractors (list all subcontractors)
Subcontractor Name
Total Subcontractor0.000.00$0.000.000.000.000.00$0.000.000.00

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

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

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

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

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practice) 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

TOTAL COSTS 0.00 $0 $0 $0 $0

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

MPAPA &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 04 Yr 4 Opt Yr 3

HHSM-500-2013-RFP-0030
MPAPASOW Sections
Total FTEsTask 1Task 2Task 3GRAND TOTAL
HoursRatesTotalHoursRatesTotalHoursRatesTotalHoursRatesTotal
COST ELEMENTS
Direct Labor (Add appropriate categories)
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
SUBTOTAL DIRECT LABOR0.000.00$00.00$00.00$00.00$0

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

TOTAL DIRECT LABOR $0 $0 $0 $0

Travel (See separate schedule E-2)$0$0$0$0
Subcontractors (list all subcontractors)
Subcontractor Name
Total Subcontractor0.000.00$0.000.000.000.000.00$0.000.000.00

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

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

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

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

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practice) 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

TOTAL COSTS 0.00 $0 $0 $0 $0

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

MPAPA &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 05 Yr 5 Opt Yr 4

HHSM-500-2013-RFP-0030
MPAPASOW Sections
Total FTEsTask 1Task 2Task 3GRAND TOTAL
HoursRatesTotalHoursRatesTotalHoursRatesTotalHoursRatesTotal
COST ELEMENTS
Direct Labor (Add appropriate categories)
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
0.000.00$0.00$00.00$0.00$00.00$0.00$00.00$0.00$0
SUBTOTAL DIRECT LABOR0.000.00$00.00$00.00$00.00$0

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

TOTAL DIRECT LABOR $0 $0 $0 $0

Travel (See separate schedule E-2)$0$0$0$0
Subcontractors (list all subcontractors)
Subcontractor Name
Total Subcontractor0.000.00$0.000.000.000.000.00$0.000.000.00

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

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

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

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

G&A @ 0.00% (Indirect rates should be IAW KTR's standard practice) 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

TOTAL COSTS 0.00 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

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

MPAPA &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

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