Attachment_9_-_Draft_EST_Labor_Hour_Contract_Cost_Template.xlsx

XLSX spreadsheet 32 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

Draft 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
Attachment_9_-_EST_Labor_Hour_Contract_Cost_Template.xlsx XLSX spreadsheet
Response_to_Questions_Amended_21_Sept_17.pdf PDF
Attachment_4_-_Sample_TO_PWS.docx DOCX document
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
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_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
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
Response_to_Questions_Amended_13_Sept_17.pdf PDF
Response_to_Questions.pdf PDF
CIMS_III_Draft_Solicitation.pdf PDF
Attachment_3_-_Draft_Position_Description_(PD)_Format_Ready.docx DOCX document
Attachment_4_-_Draft_Sample_TO_PWS.docx DOCX document
16_Aug_17_CIMS_III_Q&A.pdf PDF
Attachment_7_-_Draft_Consent_Letter_Sample_Ready.doc DOC document
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
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

DRAFT

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 II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Help Desk Technician III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
IA Analyst II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
IA Analyst III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
IA Analyst IV$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Network Administrator II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Network Administrator III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Network Administrator IV$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Network Administrator V$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program Manager III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Software Developer II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Software Developer III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Software Developer IV$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
System Administrator I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
System Administrator IV$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
System Administrator V$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Video Teleconference Administrator IV$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Field Technician I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Systems Engineer II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Systems Engineer III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Telecommunications Administrator III$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contract Manager$ - 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

DRAFT

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 II2,137$ - 0$ - 0Help Desk Technician II2,137$ - 0$ - 0Help Desk Technician II2,137$ - 0$ - 0Help Desk Technician II2,137$ - 0$ - 0Help Desk Technician II2,137$ - 0$ - 0Help Desk Technician II1065$ - 0$ - 0
Help Desk Technician III4,229$ - 0$ - 0Help Desk Technician III4,229$ - 0$ - 0Help Desk Technician III4,229$ - 0$ - 0Help Desk Technician III4,229$ - 0$ - 0Help Desk Technician III4,229$ - 0$ - 0Help Desk Technician III2107$ - 0$ - 0
IA Analyst II8,498$ - 0$ - 0IA Analyst II8,498$ - 0$ - 0IA Analyst II8,498$ - 0$ - 0IA Analyst II8,498$ - 0$ - 0IA Analyst II8,498$ - 0$ - 0IA Analyst II6336$ - 0$ - 0
IA Analyst III19,133$ - 0$ - 0IA Analyst III17,046$ - 0$ - 0IA Analyst III17,046$ - 0$ - 0IA Analyst III17,046$ - 0$ - 0IA Analyst III17,046$ - 0$ - 0IA Analyst III9571$ - 0$ - 0
Network Administrator II2,087$ - 0$ - 0Network Administrator II0$ - 0$ - 0Network Administrator II0$ - 0$ - 0Network Administrator II0$ - 0$ - 0Network Administrator II0$ - 0$ - 0Network Administrator II0$ - 0$ - 0
Network Administrator IV2,187$ - 0$ - 0Network Administrator IV2,187$ - 0$ - 0Network Administrator IV2,187$ - 0$ - 0Network Administrator IV2,187$ - 0$ - 0Network Administrator IV2,187$ - 0$ - 0Network Administrator IV1090$ - 0$ - 0
Network Administrator V25$ - 0$ - 0Network Administrator V25$ - 0$ - 0Network Administrator V25$ - 0$ - 0Network Administrator V25$ - 0$ - 0Network Administrator V25$ - 0$ - 0Network Administrator V12$ - 0$ - 0
Program Manager I2,287$ - 0$ - 0Program Manager I2,287$ - 0$ - 0Program Manager I2,287$ - 0$ - 0Program Manager I2,287$ - 0$ - 0Program Manager I2,287$ - 0$ - 0Program Manager I1137$ - 0$ - 0
Program Manager II125$ - 0$ - 0Program Manager II150$ - 0$ - 0Program Manager II125$ - 0$ - 0Program Manager II150$ - 0$ - 0Program Manager II125$ - 0$ - 0Program Manager II62$ - 0$ - 0
Program Manager III4,970$ - 0$ - 0Program Manager III4,710$ - 0$ - 0Program Manager III4,660$ - 0$ - 0Program Manager III4,710$ - 0$ - 0Program Manager III4,660$ - 0$ - 0Program Manager III2512$ - 0$ - 0
Software Developer II6,311$ - 0$ - 0Software Developer II6,311$ - 0$ - 0Software Developer II6,311$ - 0$ - 0Software Developer II6,311$ - 0$ - 0Software Developer II6,311$ - 0$ - 0Software Developer II3152$ - 0$ - 0
Software Developer III6,361$ - 0$ - 0Software Developer III6,361$ - 0$ - 0Software Developer III6,361$ - 0$ - 0Software Developer III6,361$ - 0$ - 0Software Developer III6,361$ - 0$ - 0Software Developer III3177$ - 0$ - 0
Software Developer IV2,087$ - 0$ - 0Software Developer IV2,087$ - 0$ - 0Software Developer IV2,087$ - 0$ - 0Software Developer IV2,087$ - 0$ - 0Software Developer IV2,087$ - 0$ - 0Software Developer IV1040$ - 0$ - 0
System Administrator I80$ - 0$ - 0System Administrator I80$ - 0$ - 0System Administrator I80$ - 0$ - 0System Administrator I80$ - 0$ - 0System Administrator I80$ - 0$ - 0System Administrator I40$ - 0$ - 0
System Administrator IV0$ - 0$ - 0System Administrator IV128$ - 0$ - 0System Administrator IV50$ - 0$ - 0System Administrator IV128$ - 0$ - 0System Administrator IV50$ - 0$ - 0System Administrator IV25$ - 0$ - 0
System Administrator V2,137$ - 0$ - 0System Administrator V2,137$ - 0$ - 0System Administrator V2,137$ - 0$ - 0System Administrator V2,137$ - 0$ - 0System Administrator V2,137$ - 0$ - 0System Administrator V1065$ - 0$ - 0
Video Teleconference Administrator IV2,137$ - 0$ - 0Video Teleconference Administrator IV2,137$ - 0$ - 0Video Teleconference Administrator IV2,137$ - 0$ - 0Video Teleconference Administrator IV2,137$ - 0$ - 0Video Teleconference Administrator IV2,137$ - 0$ - 0Video Teleconference Administrator IV1040$ - 0$ - 0
Field Technician I3,550$ - 0$ - 0Field Technician I3,550$ - 0$ - 0Field Technician I3,550$ - 0$ - 0Field Technician I3,550$ - 0$ - 0Field Technician I3,550$ - 0$ - 0Field Technician I1745$ - 0$ - 0
Systems Engineer II30$ - 0$ - 0Systems Engineer II30$ - 0$ - 0Systems Engineer II30$ - 0$ - 0Systems Engineer II30$ - 0$ - 0Systems Engineer II30$ - 0$ - 0Systems Engineer II10$ - 0$ - 0
Systems Engineer III200$ - 0$ - 0Systems Engineer III200$ - 0$ - 0Systems Engineer III200$ - 0$ - 0Systems Engineer III200$ - 0$ - 0Systems Engineer III200$ - 0$ - 0Systems Engineer III90$ - 0$ - 0
Telecommunications Administrator III2,137$ - 0$ - 0Telecommunications Administrator III2,137$ - 0$ - 0Telecommunications Administrator III2,137$ - 0$ - 0Telecommunications Administrator III2,137$ - 0$ - 0Telecommunications Administrator III2,137$ - 0$ - 0Telecommunications Administrator III1065$ - 0$ - 0
Contracts Administrator610$ - 0$ - 0Contracts Administrator610$ - 0$ - 0Contracts Administrator610$ - 0$ - 0Contracts Administrator610$ - 0$ - 0Contracts Administrator610$ - 0$ - 0Contracts Administrator290$ - 0$ - 0
Content Management Specialist II2,087$ - 0$ - 0Content Management Specialist II2,087$ - 0$ - 0Content Management Specialist II2,087$ - 0$ - 0Content Management Specialist II2,087$ - 0$ - 0Content Management Specialist II2,087$ - 0$ - 0Content Management Specialist II1040$ - 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 Integrator1235$ - 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.

DRAFT

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 .