Attachment I - Pricing Spreadsheet.xlsx

XLSX spreadsheet 615 KB Posted

Attached to
Head Start Training and Technical Assist. Network Federal contract opportunity
Solicitation number
140D0420R0017
Issued by
Department of the Interior Departmental Offices Interior Business Center

About this file

This document provides pricing details for technical assistance services required by the Head Start Training and Technical Assistance Network solicitation. The solicitation seeks proposals for regional training and technical assistance contracts to be awarded by the Department of Health and Human Services to support the Office of Head Start. Offerors must complete pricing spreadsheets providing fully burdened labor rates for up to nineteen staff across four functional areas. The spreadsheets also include plug numbers for other direct costs such as travel, consultants, and training. Pricing is required for a base period of eleven months and four one-year option periods, for a total potential contract value of over $1.7 million for Region 1. Similar spreadsheets are included for three other regions requiring between 28-43 staff each. Proposals are due by April 2020 with award anticipated by August 2020. Twelve fixed-price contracts will be awarded to provide services through 2025.

View the file

Other files for this federal contract opportunity

Show all 17

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

Instructions

Request for Proposals 140D0420R0017 Head Start Training and Technical Assistance Network Pricing Spreadsheet Instructions

Offerors shall complete the pricing spreadsheet tab for the region they are proposing, found within this workbook. All labor rates shall be fully burdened. The government has provided estimated Levels of Effort and corresponding number of personnel for the labor categories included in the SOW. Offerors may propose different levels of effort/number of personnel based on their technical approach, although Offerors shall not exceed the maximum number of personnel found within the pricing sheet. The level of effort/number of personnel shall be commensurate with the Offeror's Technical Proposal.

Additionally, the Government has provided plug numbers for the ODCs. Any changes to these numbers shall be properly documented in the Price Assumptions section of the proposal.

The workbook is prepopulated with mathematical formulas, but it is the Offerors responsibility to ensure the formulas reflect the correct price proposal.

Offerors may delete irrelevant tabs.

OHS TTA - Region 1

140D0420R0017 Pricing Spreadsheet
Project Title: OHS Regional TTA - REGION 1
Detailed Price Summary
Contract Line Item DescriptionBase Period (8-1-2020 to 6-30-2021)Option Year One (7-1-2021 to 6-30-2022)Option Year Two (7-1-2022 to 6-30-2023)Option Year Three (7-1-2023 to 6-30-2024)Option Year Four (7-1-2024 to 6-30-2025)
19 FTE's MAXIMUMLOE# KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal Price
T/TA Coordinator1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
EC Manager(s):3,5202$ - 03,8402$ - 03,8402$ - 03,8402$ - 03,8402$ - 0
GS Manager(s):1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Administrative Assistant1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
EC Specialists:12,3207$ - 013,4407$ - 013,4407$ - 013,4407$ - 013,4407$ - 0
Grantee Specialists:7,0404$ - 07,6804$ - 07,6804$ - 07,6804$ - 07,6804$ - 0
Health Specialist1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Systems Specialist1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Family Engagement Specialist1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Labor Subtotal33,44019$ - 036,48019$ - 036,48019$ - 036,48019$ - 036,48019$ - 0
ODC's
Travel$ 264,000.00$ 288,000.00$ 288,000.00$ 288,000.00$ 288,000.00
Consultants$ 16,500.00$ 18,000.00$ 18,000.00$ 18,000.00$ 18,000.00
Training Costs$ 41,250.00$ 45,000.00$ 45,000.00$ 45,000.00$ 45,000.00
Subtotal ODCs$ 321,750.00$ 351,000.00$ 351,000.00$ 351,000.00$ 351,000.00
Total Price$ 321,750.00$ 351,000.00$ 351,000.00$ 351,000.00$ 351,000.00
TOTAL ESTIMATED VALUE OF CONTRACT$ 1,725,750.00

&F&D&T

OHS TTA - Region 2

140D0420R0017 Pricing Spreadsheet
Project Title: OHS Regional TTA - REGION 2
Detailed Price Summary
Contract Line Item DescriptionBase Period (8-1-2020 to 6-30-2021)Option Year One (7-1-2021 to 6-30-2022)Option Year Two (7-1-2022 to 6-30-2023)Option Year Three (7-1-2023 to 6-30-2024)Option Year Four (7-1-2024 to 6-30-2025)
34 FTE's MAXIMUMLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal Price
T/TA Coordinator1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
EC Managers3,5202$ - 03,8402$ - 03,8402$ - 03,8402$ - 03,8402$ - 0
GS Manager1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Administrative Assistant1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
EC Specialists28,16016$ - 030,72016$ - 030,72016$ - 030,72016$ - 030,72016$ - 0
Grantee Specialist (8-1-20 to 9-30-2021)1,7601$ - 03201$ - 000$ - 000$ - 000$ - 0
Grantee Specialists10,5606$ - 011,5206$ - 011,5206$ - 011,5206$ - 011,5206$ - 0
Health Specialists (8-1-20 to 9-30-2021)3,5202$ - 06402$ - 000$ - 000$ - 000$ - 0
Health Specialist:3,5202$ - 01,9202$ - 01,9202$ - 01,9202$ - 01,9202$ - 0
Systems Specialist:1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Family Engagement Specialist:1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Labor Subtotal59,84034$ - 058,56034$ - 057,60031$ - 057,60031$ - 057,60031$ - 0
ODC's
Travel$ 363,000.00$ 390,000.00$ 390,000.00$ 390,000.00$ 390,000.00
Consultants$ 60,500.00$ 60,000.00$ 60,000.00$ 60,000.00$ 60,000.00
Training Costs$ 82,500.00$ 90,000.00$ 90,000.00$ 90,000.00$ 90,000.00
Subtotal ODCs$ 506,000.00$ 540,000.00$ 540,000.00$ 540,000.00$ 540,000.00
Total Price$ 506,000.00$ 540,000.00$ 540,000.00$ 540,000.00$ 540,000.00
TOTAL ESTIMATED VALUE OF CONTRACT$ 2,666,000.00

&F&D&T

OHS TTA - Region 3

140D0420R0017 Pricing Spreadsheet
Project Title: OHS Regional TTA - REGION 3
Detailed Price Summary
Contract Line Item DescriptionBase Period (8-1-2020 to 6-30-2021)Option Year One (7-1-2021 to 6-30-2022)Option Year Two (7-1-2022 to 6-30-2023)Option Year Three (7-1-2023 to 6-30-2024)Option Year Four (7-1-2024 to 6-30-2025)
28 FTE's MAXIMUMLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal Price
T/TA Coordinator1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
EC Manager(s): 1-23,5202$ - 03,8402$ - 03,8402$ - 03,8402$ - 03,8402$ - 0
GS Manager(s):1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Administrative Assistant1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
EC Specialists21,12012$ - 023,04012$ - 023,04012$ - 023,04012$ - 023,04012$ - 0
Grantee Specialists14,0808$ - 015,3608$ - 015,3608$ - 015,3608$ - 015,3608$ - 0
Health Specialist1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Systems Specialist1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Family Engagement Specialist:1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Labor Subtotal49,28028$ - 053,76028$ - 053,76028$ - 053,76028$ - 053,76028$ - 0
ODC's
Travel$ 445,500.00$ 486,000.00$ 486,000.00$ 486,000.00$ 486,000.00
Consultants$ 49,500.00$ 54,000.00$ 54,000.00$ 54,000.00$ 54,000.00
Training Costs$ 272,250.00$ 297,000.00$ 297,000.00$ 297,000.00$ 297,000.00
ODC Subtotal$ 767,250.00$ 837,000.00$ 837,000.00$ 837,000.00$ 837,000.00
Total Price$ 767,250.00$ 837,000.00$ 837,000.00$ 837,000.00$ 837,000.00
TOTAL ESTIMATED VALUE OF CONTRACT$ 4,115,250.00

&F&D&T

OHS TTA - Region 4

140D0420R0017 Pricing Spreadsheet
Project Title: OHS Regional TTA - REGION 4
Detailed Price Summary
Contract Line Item DescriptionBase Period (8-1-2020 to 6-30-2021)Option Year One (7-1-2021 to 6-30-2022)Option Year Two (7-1-2022 to 6-30-2023)Option Year Three (7-1-2023 to 6-30-2024)Option Year Four (7-1-2024 to 6-30-2025)
43 FTE's MAXIMUMLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal PriceLOE#KPRateTotal Price
T/TA Coordinator1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
EC Managers5,2803$ - 05,7603$ - 05,7603$ - 05,7603$ - 05,7603$ - 0
GS Managers3,5202$ - 03,8402$ - 03,8402$ - 03,8402$ - 03,8402$ - 0
Administrative Assistant1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
EC Specialists29,92017$ - 032,64017$ - 032,64017$ - 032,64017$ - 032,64017$ - 0
Grantee Specialists24,64014$ - 026,88014$ - 026,88014$ - 026,88014$ - 026,88014$ - 0
Health Specialist3,5202$ - 03,8402$ - 03,8402$ - 03,8402$ - 03,8402$ - 0
Systems Specialist3,5202$ - 03,8402$ - 03,8402$ - 03,8402$ - 03,8402$ - 0
Family Engagement Specialist1,7601$ - 01,9201$ - 01,9201$ - 01,9201$ - 01,9201$ - 0
Labor Subtotal75,68043$ - 082,56043$ - 082,56043$ - 082,56043$ - 082,56043$ - 0
ODC's
Travel$ 808,500.00$ 882,000.00$ 882,000.00$ 882,000.00$ 882,000.00
Consultants$ 38,500.00$ 42,000.00$ 42,000.00$ 42,000.00$ 42,000.00
Training Costs$ 346,500.00$ 378,000.00$ 378,000.00$ 378,000.00$ 378,000.00
Subtotal ODCs$ 1,193,500.00$ 1,302,000.00$ 1,302,000.00$ 1,302,000.00$ 1,302,000.00
Total Price$ 1,193,500.00$ 1,302,000.00$ 1,302,000.00$ 1,302,000.00$ 1,302,000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

This is the start of the file's text. The full file is on GovTribe.

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