Attachment 4 Price-Cost Worksheet.xlsx

XLSX spreadsheet 14 KB Posted

Attached to
Training Support Services for the Hazard Mitigation Technical Assistance Program Federal contract opportunity
Solicitation number
70FA2020R00000002
Issued by
Federal Emergency Management Agency Preparedness Section

View the file

Other files for this federal contract opportunity

Other files attached to Training Support Services for the Hazard Mitigation Technical Assistance Program, newest first.
File Type Posted
70FA2020R00000002 Amendment 0003.pdf PDF
Responses - 70FA2020R00000002 Questions and Answers - Final.pdf PDF
Attachment 4 Price-Cost Worksheet 12_19_19.xlsx XLSX spreadsheet
70FA2020R00000002 Solicitation posted 12_19_19.pdf PDF
Attachment 1 PWS_HMTAP TSS_ 12_17_2019.pdf PDF
70FA2020R00000002 Amendment 0002.pdf PDF
Attachment 5 Labor Category Descriptions_Final.xlsx XLSX spreadsheet
70FA2020R00000002 Amendment 0001.pdf PDF
Attachment 3 Wage Determination No. 2015-4269 Rev. 10.pdf PDF
Attachment 2 QASP - HMTAP TSS_05142019.pdf PDF
70FA2020R00000002 Solicitation.pdf PDF
Attachment 1 PWS HMTAP TSS 11_21_19.pdf PDF
Show all 12

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.

Sheet1

Attachment 4 Price/Cost Spreadsheet
ALL HIGHLIGHED AREAS BELOW MUST BE FILLED IN OR THIS WILL BE CONSIDERED INCOMPLETE
ORDERING PERIOD 1 02/29/2020 - 02/28/2021
Labor CategoryEstimated hoursFully Burdened Hourly RateTotal
Project Manager - Master835
Contract Specialist - Mid240
Training Coordinator - Mid500
Senior Training Specialist (Instructor)3000
Senior Training Specialist (ISD)3000
Senior Subject Matter Expert3000
Mid Training Specialist (ISD)3000
Senior Technical Editor3000
QA/QC Officer - Senior3000
QA/QC Officer - Mid3000
Senior Graphic Artist1000
Training Assistant Mid, Bilingual1000
Training Specialist (Instructor) - Master750
Training Specialist (Instructor) - Mid3000
Sub-Total28325
ODC fill in Base Period--$ 400,560.00
Surge fill in Base Period--$ 633,639.00
Total--
ODC G&A Rate/Handling Rate/Mark-up Rate-
ORDERING PERIOD 2 03/01/2021 - 02/28/2022
Labor CategoryEstimated hoursFully Burdened Hourly RateTotal
Project Manager - Master710
Contract Specialist - Mid165
Training Coordinator - Mid500
Senior Training Specialist (Instructor)1375
Senior Training Specialist (ISD)1125
Senior Subject Matter Expert1125
Mid Training Specialist (ISD)1125
Senior Technical Editor1125
QA/QC Officer - Senior1250
QA/QC Officer - Mid1375
Senior Graphic Artist375
Training Assistant Mid, Bilingual687.5
Training Specialist (Instructor) - Master437.5
Training Specialist (Instructor) - Mid1375
Sub-Total12750
ODC fill in Option Period 1--$ 420,588.00
Surge fill in Option Period 1--$ 398,508.00
Total--
ODC G&A Rate/Handling Rate/Mark-up Rate-
ORDERING PERIOD 3 03/01/2022 - 02/28/2023
Labor CategoryEstimated hoursFully Burdened Hourly RateTotal
Project Manager - Master710
Contract Specialist - Mid165
Training Coordinator - Mid500
Senior Training Specialist (Instructor)1375
Senior Training Specialist (ISD)1125
Senior Subject Matter Expert1125
Mid Training Specialist (ISD)1125
Senior Technical Editor1125
QA/QC Officer - Senior1250
QA/QC Officer - Mid1375
Senior Graphic Artist375
Training Assistant Mid, Bilingual687.5
Training Specialist (Instructor) - Master437.5
Training Specialist (Instructor) - Mid1375
Sub-Total12750
ODC fill in Option Period 2--$ 441,617.00
Surge fill in Option Period 2--$ 418,434.00
Total--
ODC G&A Rate/Handling Rate/Mark-up Rate-
ORDERING PERIOD 4 03/01/2023 - 02/28/2024
Labor CategoryEstimated hoursFully Burdened Hourly RateTotal
Project Manager - Master710
Contract Specialist - Mid165
Training Coordinator - Mid500
Senior Training Specialist (Instructor)1375
Senior Training Specialist (ISD)1125
Senior Subject Matter Expert1125
Mid Training Specialist (ISD)1125
Senior Technical Editor1125
QA/QC Officer - Senior1250
QA/QC Officer - Mid1375
Senior Graphic Artist375
Training Assistant Mid, Bilingual687.5
Training Specialist (Instructor) - Master437.5
Training Specialist (Instructor) - Mid1375
Sub-Total12750
ODC fill in Option Period 3--$ 463,698.00
Surge fill in Option Period 3--$ 439,355.00
Total--
ODC G&A Rate/Handling Rate/Mark-up Rate-
ORDERING PERIOD 5 03/01/2024 - 02/28/2025
Labor CategoryEstimated hoursFully Burdened Hourly RateTotal
Project Manager - Master710
Contract Specialist - Mid165
Training Coordinator - Mid500
Senior Training Specialist (Instructor)1375
Senior Training Specialist (ISD)1125
Senior Subject Matter Expert1125
Mid Training Specialist (ISD)1125
Senior Technical Editor1125
QA/QC Officer - Senior1250
QA/QC Officer - Mid1375
Senior Graphic Artist375
Training Assistant Mid, Bilingual687.5
Training Specialist (Instructor) - Master437.5
Training Specialist (Instructor) - Mid1375
Sub-Total12750
ODC fill in Option Period 4--$ 486,883.00
Surge fill in Option Period 4--$ 461,323.00
Total--
ODC G&A Rate/Handling Rate/Mark-up Rate-
Total ODC fill ins--$ 2,213,346.00
Total Surge fill ins--$ 2,351,259.00
Total Base and all Option Periods (includes labor, ODCs fill ins and surge fill ins)$

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