Attachment_9_-_EST_Labor_Hour_Contract_Cost_Template.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
Command Information Management System (CIMS) III Federal contract opportunity
Solicitation number
W9126017R0001
Issued by
Department of the Army Materiel Command Contracting Command Redstone Arsenal

About this file

From the source

Updated Attachment 9 - EST Labor Hour Contract Cost Template

View the file

Other files for this federal contract opportunity

Other files attached to Command Information Management System (CIMS) III, newest first.
File Type Posted
Attachment_8_-_Contract_Cost_and_Price_Template.xlsx XLSX spreadsheet
Response_to_Questions_Amended_21_Sept_17.pdf PDF
Attachment_1_CIMS_III_IDIQ_PWS_19_Sep_17.pdf PDF
Solicitation_W91260-17-R-0001_Amendment_0001.pdf PDF
Attachment_8_-_Contract_Cost_and_Price_Template.xlsx XLSX spreadsheet
Attachment_9_-_EST_Labor_Hour_Contract_Cost_Template.xlsx XLSX spreadsheet
Attachment_4_-_Sample_TO_PWS.docx DOCX document
Response_to_Questions_Amended_18_Sept_17.pdf PDF
Attachment_10_-_Accounting_System_Checklist.docx DOCX document
Attachment_1_-_CIMS_III_IDIQ_PWS_24_Aug_17.pdf PDF
Attachment_7_-_Consent_Letter_Sample.doc DOC document
Attachment_6_-_Past_Performance_Cover_Letter_and_Questionnaire.docx DOCX document
Solicitation_W91260-17-R-0001.pdf PDF
Attachment_3_-_Position_Description_(PD)_Format.docx DOCX document
Attachment_4_-_Sample_TO_PWS.pdf PDF
Attachment_2_-_DD254_Retrieval_Information.pdf PDF
Attachment_11_-_Team_Composition_Matrix.doc DOC document
Attachment_8_-_Contract_Cost_and_Price_Template.xlsx XLSX spreadsheet
Attachment_5_-_Past_Performance_Information_(PPI).docx DOCX document
Attachment_9_-_EST_Labor_Hour_Contract_Cost_Template.xlsx XLSX spreadsheet
Response_to_Questions_Amended_13_Sept_17.pdf PDF
Response_to_Questions.pdf PDF
CIMS_III_Draft_Solicitation.pdf PDF
Attachment_6_-_Draft_Past_Performance_Cover_Letter_and_Questionnaire_Ready.docx DOCX document
Attachment_2_-_Draft_DD254_Retrieval_Information_Ready.pdf PDF
Attachment_10_-_Draft_Accounting_System_Checklist.docx DOCX document
Attachment_5_-_Draft_Past_Performance_Information_(PPI)_Ready.docx DOCX document
Attachment_1_-_Draft_CIMS_III_IDIQ_PWS.pdf PDF
Attachment_11_-_Draft_Team_Composition_Matrix.doc DOC document
Attachment_8_-_Draft_Contract_Cost_and_Price_Template.xlsx XLSX spreadsheet
Attachment_3_-_Draft_Position_Description_(PD)_Format_Ready.docx DOCX document
Attachment_4_-_Draft_Sample_TO_PWS.docx DOCX document
Attachment_9_-_Draft_EST_Labor_Hour_Contract_Cost_Template.xlsx XLSX spreadsheet
16_Aug_17_CIMS_III_Q&A.pdf PDF
Attachment_7_-_Draft_Consent_Letter_Sample_Ready.doc DOC document
5_Jun_17_Attch_1_CIMS_III_Acquisition_Questions_&_Answers.pdf PDF
5_Jun_17_Attch_2_CIMS_III_Bidder_Data_Access_Training.ppt PPT presentation
5_Jun_17_Attch_3_CIMS_III_-_How_to_Get_a_CAC_Training.ppt PPT presentation
5_Jun_17_Attch_4_CIMS_III_-_How_to_Get_an_AKO_Account_Training.ppt PPT presentation
DRAFT_CIMS_III_IDIQ_PWS.pdf PDF
Show all 40

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.

Proposal Cover Sheet

Proposal Cover Sheet
1Solicitation No.:W91260-17-R-0001
2Offeror Name & AddressIf subcontractor, list prime below:
3Point of Contact
Name, Position
Phone Number(s)
Email
4Contract Administration Office
DCMA Office (Address & POC)DCAA Office (Address & POC)
5Type of Contract ActionNew Contract
6Date:

&"Times New Roman,Bold"Attachment 9

Summary EST Labor Cost

Offeror Name
Proposal Submitted in Response to Solicitation W91260-17-R-0001
Estimated Labor Hour Cost
Summary - Total Burdened
Labor CategoryYear 1Year 2Year 3Year 4Year 56 Month ExtTOTAL
Help Desk Technician Entry/Mid$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Cybersecurity Analyst - Entry$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Cybersecurity Analyst - Mid$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Network Administrator - Entry$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Network Administrator - Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager - Entry/Mid$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager - Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Software Developer - Entry/Mid$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Software Developer - Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
System Administrator - Entry/Mid$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
System Administrator - Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Video Teleconference Administrator IV - Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Field Technician - Entry$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Systems Engineer Entry/Mid$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Telecommunications Administrator Entry/Mid$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contracts Administrator$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Systems Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Systems Integrator$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Systems Programmer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Security Services Lead Technician$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ODC/Travel$ 1,348,268.00$ 1,348,268.00$ 1,348,268.00$ 1,348,268.00$ 1,348,268.00$ 635,244.84$ 7,376,584.84
TOTAL$ 1,348,268.00$ 1,348,268.00$ 1,348,268.00$ 1,348,268.00$ 1,348,268.00$ 635,244.84$ 7,376,584.84
*The cells are populated from the "Burdened Total" columns in Schedule 1 and 2.
**If a particular labor category is performed by both the Prime and the subcontractor,
divy up the labor hours accordingly and duplicate the labor category in the summary tab
to capture both the Prime and the subcontractors Burdened Totals.

&"-,Bold"Attachment 9

Schedule 1 - EST Labor Cost Prime Offeror Name or Subcontractor Name is Subcontractor Submits as Unsanitized Schedule 1 Estimated (EST) Labor Hour Contract Cost

Escalation Rate for 2019Escalation Rate for 2020Escalation Rate for 2021Escalation Rate for 2022Escalation Rate for 2023
Year 1Year 2Year 3Year 4Year 56 Month Ext
Labor CategoryLabor HoursBurdened
Rate/HrBurdenend TotalLabor CategoryLabor HoursBurdened
Rate/HrBurdenend TotalLabor CategoryLabor HoursBurdened
Rate/HrBurdenend TotalLabor CategoryLabor HoursBurdened
Rate/HrBurdenend TotalLabor CategoryLabor HoursBurdened
Rate/HrBurdenend TotalLabor CategoryLabor HoursBurdened
Rate/HrBurdenend Total
Help Desk Technician Entry/Mid6,366$ - 0$ - 0Help Desk Technician Entry/Mid6,366$ - 0$ - 0Help Desk Technician Entry/Mid6,366$ - 0$ - 0Help Desk Technician Entry/Mid6,366$ - 0$ - 0Help Desk Technician Entry/Mid6,366$ - 0$ - 0Help Desk Technician Entry/Mid3,172$ - 0$ - 0
Cybersecurity Analyst - Entry8,498$ - 0$ - 0Cybersecurity Analyst - Entry8,498$ - 0$ - 0Cybersecurity Analyst - Entry8,498$ - 0$ - 0Cybersecurity Analyst - Entry8,498$ - 0$ - 0Cybersecurity Analyst - Entry8,498$ - 0$ - 0Cybersecurity Analyst - Entry6,336$ - 0$ - 0
Cybersecurity Analyst - Mid19,133$ - 0$ - 0Cybersecurity Analyst - Mid17,046$ - 0$ - 0Cybersecurity Analyst - Mid17,046$ - 0$ - 0Cybersecurity Analyst - Mid17,046$ - 0$ - 0Cybersecurity Analyst - Mid17,046$ - 0$ - 0Cybersecurity Analyst - Mid9,571$ - 0$ - 0
Network Administrator - Entry2,087$ - 0$ - 0Network Administrator - Entry0$ - 0$ - 0Network Administrator - Entry0$ - 0$ - 0Network Administrator - Entry0$ - 0$ - 0Network Administrator - Entry0$ - 0$ - 0Network Administrator - Entry0$ - 0$ - 0
Network Administrator - Senior2,212$ - 0$ - 0Network Administrator - Senior2,212$ - 0$ - 0Network Administrator - Senior2,212$ - 0$ - 0Network Administrator - Senior2,212$ - 0$ - 0Network Administrator - Senior2,212$ - 0$ - 0Network Administrator - Senior1,102$ - 0$ - 0
Program Manager - Entry/Mid2,412$ - 0$ - 0Program Manager - Entry/Mid2,437$ - 0$ - 0Program Manager - Entry/Mid2,412$ - 0$ - 0Program Manager - Entry/Mid2,437$ - 0$ - 0Program Manager - Entry/Mid2,412$ - 0$ - 0Program Manager - Entry/Mid1,199$ - 0$ - 0
Program Manager - Senior4,970$ - 0$ - 0Program Manager - Senior4,710$ - 0$ - 0Program Manager - Senior4,660$ - 0$ - 0Program Manager - Senior4,710$ - 0$ - 0Program Manager - Senior4,660$ - 0$ - 0Program Manager - Senior2,512$ - 0$ - 0
Software Developer - Entry/Mid14,759$ - 0$ - 0Software Developer - Entry/Mid14,759$ - 0$ - 0Software Developer - Entry/Mid14,759$ - 0$ - 0Software Developer - Entry/Mid14,759$ - 0$ - 0Software Developer - Entry/Mid14,759$ - 0$ - 0Software Developer - Entry/Mid7,369$ - 0$ - 0
Software Developer - Senior2,087$ - 0$ - 0Software Developer - Senior2,087$ - 0$ - 0Software Developer - Senior2,087$ - 0$ - 0Software Developer - Senior2,087$ - 0$ - 0Software Developer - Senior2,087$ - 0$ - 0Software Developer - Senior1,040$ - 0$ - 0
System Administrator - Entry/Mid80$ - 0$ - 0System Administrator - Entry/Mid80$ - 0$ - 0System Administrator - Entry/Mid80$ - 0$ - 0System Administrator - Entry/Mid80$ - 0$ - 0System Administrator - Entry/Mid80$ - 0$ - 0System Administrator - Entry/Mid40$ - 0$ - 0
System Administrator - Senior2,137$ - 0$ - 0System Administrator - Senior2,265$ - 0$ - 0System Administrator - Senior2,187$ - 0$ - 0System Administrator - Senior2,265$ - 0$ - 0System Administrator - Senior2,187$ - 0$ - 0System Administrator - Senior1,090$ - 0$ - 0
Video Teleconference Administrator IV - Senior2,137$ - 0$ - 0Video Teleconference Administrator IV - Senior2,137$ - 0$ - 0Video Teleconference Administrator IV - Senior2,137$ - 0$ - 0Video Teleconference Administrator IV - Senior2,137$ - 0$ - 0Video Teleconference Administrator IV - Senior2,137$ - 0$ - 0Video Teleconference Administrator IV - Senior1,040$ - 0$ - 0
Field Technician - Entry3,550$ - 0$ - 0Field Technician - Entry3,550$ - 0$ - 0Field Technician - Entry3,550$ - 0$ - 0Field Technician - Entry3,550$ - 0$ - 0Field Technician - Entry3,550$ - 0$ - 0Field Technician - Entry1,745$ - 0$ - 0
Systems Engineer Entry/Mid230$ - 0$ - 0Systems Engineer Entry/Mid230$ - 0$ - 0Systems Engineer Entry/Mid230$ - 0$ - 0Systems Engineer Entry/Mid230$ - 0$ - 0Systems Engineer Entry/Mid230$ - 0$ - 0Systems Engineer Entry/Mid100$ - 0$ - 0
Telecommunications Administrator Entry/Mid2,137$ - 0$ - 0Telecommunications Administrator Entry/Mid2,137$ - 0$ - 0Telecommunications Administrator Entry/Mid2,137$ - 0$ - 0Telecommunications Administrator Entry/Mid2,137$ - 0$ - 0Telecommunications Administrator Entry/Mid2,137$ - 0$ - 0Telecommunications Administrator Entry/Mid1,065$ - 0$ - 0
Contracts Administrator610$ - 0$ - 0Contracts Administrator610$ - 0$ - 0Contracts Administrator610$ - 0$ - 0Contracts Administrator610$ - 0$ - 0Contracts Administrator610$ - 0$ - 0Contracts Administrator290$ - 0$ - 0
Systems Analyst285$ - 0$ - 0Systems Analyst285$ - 0$ - 0Systems Analyst285$ - 0$ - 0Systems Analyst285$ - 0$ - 0Systems Analyst285$ - 0$ - 0Systems Analyst130$ - 0$ - 0
Systems Integrator2,500$ - 0$ - 0Systems Integrator2,500$ - 0$ - 0Systems Integrator2,500$ - 0$ - 0Systems Integrator2,500$ - 0$ - 0Systems Integrator2,500$ - 0$ - 0Systems Integrator1,235$ - 0$ - 0
Systems Programmer500$ - 0$ - 0Systems Programmer500$ - 0$ - 0Systems Programmer500$ - 0$ - 0Systems Programmer500$ - 0$ - 0Systems Programmer500$ - 0$ - 0Systems Programmer240$ - 0$ - 0
Security Services Lead Technician0$ - 0$ - 0Security Services Lead Technician97$ - 0$ - 0Security Services Lead Technician0$ - 0$ - 0Security Services Lead Technician97$ - 0$ - 0Security Services Lead Technician0$ - 0$ - 0Security Services Lead Technician0$ - 0$ - 0
RateRateRateRateRateRate
FringeFringeFringeFringeFringeFringe
OverheadOverheadOverheadOverheadOverheadOverhead
G&AG&AG&AG&AG&AG&A
SCMHSCMHSCMHSCMHSCMHSCMH

Maximum Fixed Fee Maximum Fixed Fee Maximum Fixed Fee Maximum Fixed Fee Maximum Fixed Fee Maximum Fixed Fee

*DO NOT change the numbers provided in the "Labor Hours" coulmn under each year.
**If a particular labor category above will be solely performed by a significant contractor,
as identified in the Team Composition Matrix, input the applicable labor category,
number of hours provided, and any other requested information in tab "Schedule 2-EST sub Sanitized".
***If a particular labor category is performed by both the Prime and the subcontractor,
divy up the labor hours accordingly and duplicate the labor category in the summary tab
to capture both the Prime and the subcontractors Burdened Totals.

Schedule 2 - EST Sub Sanitized

Prime Offeror Name
Subcontractor Name
Schedule 2 Estimated (EST) Labor Hour Contract Cost
Escalation Rate for 2019Escalation Rate for 2020Escalation Rate for 2021Escalation Rate for 2022Escalation Rate for 2023
Year 1Year 2Year 3Year 4Year 56 Month Ext
Labor CategoryLabor HoursBurdened
Rate/HrBurdened TotalLabor CategoryLabor HoursBurdened
Rate/HrBurdened TotalLabor CategoryLabor HoursBurdened
Rate/HrBurdened TotalLabor CategoryLabor HoursBurdened
Rate/HrBurdened TotalLabor CategoryLabor HoursBurdened
Rate/HrBurdened TotalLabor CategoryLabor HoursBurdened
Rate/HrBurdened Total
$ - 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$ - 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$ - 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$ - 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$ - 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$ - 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
$ - 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$ - 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
RateRateRateRateRateRate
Prime Burdened (Indirect Rate)Prime Burdened (Indirect Rate)Prime Burdened (Indirect Rate)Prime Burdened (Indirect Rate)Prime Burdened (Indirect Rate)Prime Burdened (Indirect Rate)
*The cost elements included in the subcontractors proposal should be reflected in this Schedule.
** Fully Burdened (FBR). This rate should include the base labor rate, applicable burdens, and max fixed fee.
***The Fully Burdened Subcontractor Rate proposed above should tie to the subcontractor's proposal.

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