Template_for_Cost_Data.xlsx

XLSX spreadsheet 44 KB Posted

Attached to
US Army Chemical Materiel (CMA) Recoverd Chemical Materiel Directorate (RCMD) Mission Support
Solicitation number
W911SR17R0003
Issued by

View the file

Other files

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

Proposal Price Summary

W911SR-17-R-0003, Attachment #2
ServiceContract TypeTotal Cost Included Travel & ODCFixed FeeTotal CPFF
Base ContractCPFFCLIN 0000
T.O 1 CONUSCPFFCLIN 0001
T.O 1 OCONUSCPFFCLIN 000X
Total$0$0$0
Link Cells to Appropriate Cells on "Breakout" tabs

Base Contract Cost Breakout

First Year Base ContractSecond Year Base ContractThird Year Base ContractFourth Year Base ContractFifth Year Base ContractTotal
LaborHoursRateDollarsHoursRateDollarsHoursRateDollarsHoursRateDollarsHoursRateDollarsHoursDollars
e.g. Program Manager0$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$0
e.g. SME0$0.00$00$0.00$00$0.00$00$0.00$00$0.00$000
--> Link to Job Title on LCAT Tab0$0.00$00$0.00$00$0.00$00$0.00$00$0.00$000
Labor Category 40$0.00$00$0.00$00$0.00$00$0.00$00$0.00$000
Labor Category 50$0.00$00$0.00$00$0.00$00$0.00$00$0.00$000
Labor Category 60$0.00$00$0.00$00$0.00$00$0.00$00$0.00$000
Labor Category 70$0.00$00$0.00$00$0.00$00$0.00$00$0.00$000
Labor Category 80$0.00$00$0.00$00$0.00$00$0.00$00$0.00$000
Labor Category 90$0.00$00$0.00$00$0.00$00$0.00$00$0.00$000
Labor Category 100$0.00$00$0.00$00$0.00$00$0.00$00$0.00$000
Labor Category…0$0.00$00$0.00$00$0.00$00$0.00$00$0.00$000
Subtotal, Direct Labor0$00$00$00$00$000
Fringe (DL)0.00%$00.00%$00.00%$00.00%$00.00%$00
Overhead (DL+Fringe)0.00%$00.00%$00.00%$00.00%$00.00%$00
Labor0$00$00$00$00$00
BaseBaseBaseBaseBase
G&A [Fee-Bearing]<Sum>0.00%ERROR:#VALUE!<Sum>0.00%ERROR:#VALUE!<Sum>0.00%ERROR:#VALUE!<Sum>0.00%ERROR:#VALUE!<Sum>0.00%ERROR:#VALUE!ERROR:#VALUE!
Total Fee-Bearing Cost<Sum><Sum><Sum><Sum><Sum>0
Fixed Fee<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!<rate>ERROR:#VALUE!ERROR:#VALUE!

TOTAL CPFF ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

*Delete Rows, Add Rows/Columns, and Change Equations as Needed.
*Allocation pools vary by offeror. Equations, pool names, etc. will need to be adjusted by offerors.

T.O 1 CONUS Cost Breakout

Period of Performance: 12 months
LaborHours/UnitsRateDollars
e.g. Program Manager0$0.00$0
e.g. SME0$0.00$0
--> Link to Job Title on LCAT Tab0$0.00$0
Labor Category 40$0.00$0
Labor Category 50$0.00$0
Labor Category 60$0.00$0
Labor Category 70$0.00$0
Labor Category 80$0.00$0
Labor Category 90$0.00$0
Labor Category 100$0.00$0
Labor Category…0$0.00$0
Subtotal, Direct Labor0$0
Fringe (DL)0.00%$0
Overhead (DL+Fringe)0.00%$0
Labor0$0
Subcontracts
e.g. ABC Tech, T&M (See ABC Tab)<Ref><Ref>
e.g. XYZ Inc., FFP (See XYZ Tab)<Ref><Ref>
Subcontractor…<Ref><Ref>
Subtotal, Subcontracts0$0
Sub Handling0.00%$0
Subcontracts0$0
Materials
Subtotal, Materials (PWS Ref)<Plug-in Number>
Material Handling0.00%ERROR:#VALUE!
MaterialsERROR:#VALUE!
Base
G&A [Fee-Bearing]<Sum>0.00%ERROR:#VALUE!
Total Fee-Bearing Cost<Sum>
Fixed Fee<rate>ERROR:#VALUE!

Travel (See Travel Tab) <Ref>

ODCs
Subtotal, ODCs (PWS Ref)<Plug-in Number>
…
Subtotal, ODCs$0
Base
G&A [Non-Fee Bearing]<Sum>0.00%ERROR:#VALUE!
Total Non-Fee Bearing Cost<Sum>
TOTAL CPFFERROR:#VALUE!
*Delete Rows, Add Rows/Columns, and Change Equations as Needed.
*Allocation pools vary by offeror. Equations, pool names, etc. will need to be adjusted by offerors.

T.O 1 OCONUS Cost Breakout

Period of Performance: 12 months
LaborHours/UnitsRateDollars
e.g. Program Manager0$0.00$0
e.g. SME0$0.00$0
--> Link to Job Title on LCAT Tab0$0.00$0
Labor Category 40$0.00$0
Labor Category 50$0.00$0
Labor Category 60$0.00$0
Labor Category 70$0.00$0
Labor Category 80$0.00$0
Labor Category 90$0.00$0
Labor Category 100$0.00$0
Labor Category…0$0.00$0
Subtotal, Direct Labor0$0
Fringe (DL)0.00%$0
Overhead (DL+Fringe)0.00%$0
Labor0$0
Subcontracts
e.g. ABC Tech, T&M (See ABC Tab)<Ref><Ref>
e.g. XYZ Inc., FFP (See XYZ Tab)<Ref><Ref>
Subcontractor…<Ref><Ref>
Subtotal, Subcontracts0$0
Sub Handling0.00%$0
Subcontracts0$0
Materials
Subtotal, Materials (PWS Ref)<Plug-in Number>
Material Handling0.00%ERROR:#VALUE!
MaterialsERROR:#VALUE!
Base
G&A [Fee-Bearing]<Sum>0.00%ERROR:#VALUE!
Total Fee-Bearing Cost<Sum>
Fixed Fee<rate>ERROR:#VALUE!

Travel (See Travel Tab) <Ref>

ODCs
Subtotal, ODCs (PWS Ref)<Plug-in Number>
…
Subtotal, ODCs$0
Base
G&A [Non-Fee Bearing]<Sum>0.00%ERROR:#VALUE!
Total Non-Fee Bearing Cost<Sum>
TOTAL CPFFERROR:#VALUE!
*Delete Rows, Add Rows/Columns, and Change Equations as Needed.
*Allocation pools vary by offeror. Equations, pool names, etc. will need to be adjusted by offerors.

Labor Hours

Job TitleTotal Hours Entire ProposalUmbrella PWSTotal Hours T.O 1 PWSTO PWS 3.1 Contract ManagementTO PWS 3.2 Program Management SupportTO PWS 3.3 Mission SupportPWS 3.4 Operational Support
Total Umbrella PWS:Umbrella PWS 3.1.1Umbrella PWS 3.1.2Umbrella PWS 3.1.3Umbrella PWS 3.1.4Umbrella PWS 3.1.5Umbrella PWS 3.1.6Umbrella PWS 3.1.7SubtotalPWS 3.1.1PWS 3.1.2PWS 3.1.3PWS 3.1.4PWS 3.1.5PWS 3.1.6PWS 3.1.7SubtotalPWS 3.2.1 & its sub-paraPWS 3.2.2 & its sub-paraPWS 3.2.3 & its sub-paraSubtotalPWS 3.3.1.1PWS 3.3.1.2 & its sub-paraPWS 3.3.1.3 & its sub-paraPWS 3.3.1.4 & its sub-paraPWS 3.3.1.5 & its sub-paraPWS 3.3.1.6 & its sub-paraPWS 3.3.1.7 & its sub-paraSubtotalPWS 3.4.1 & its sub-paraPWS 3.4.2 & its sub-paraPWS 3.4.3 & its sub-paraPWS 3.4.4 & its sub-paraPWS 3.4.5 & its sub-paraPWS 3.4.6 & its sub-para
e.g. Program Manager0000000
e.g. SME0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000
Links to Job Title on LCAT Tab0000000

LCAT

Prime (P) or Subcontractor (S)Government Site (GS) or Contractor Site (CS)Job Title/LCATCurrent workforce (CW) or Contigent Hire (CH)Labor Category (LCAT) DescriptionMinimum EducationMinimum Experience
PCSe.g. Program ManagerCWResponsible for managing / supervising a team on an activity for one or more moderately large customer accounts…Bachelor's Degree; Master's preferred5+ years
SGSe.g. SMECHConsults with client or department heads to define need or problem. Oversees research, administers studies and surveys to obtain data, and analyzes problems to advise on or recommend solutions….Bachelor's Degree10 years
Labor Category 3
Labor Category 4
Labor Category 5
Labor Category 6
Labor Category 7
Labor Category 8
Labor Category 9
Labor Category 10
Labor Category…

SubKtr_ABC Tech, T&M

Base PeriodOption Year 1Option Year 2Total
LaborHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsRateDollarsHours/UnitsDollars
e.g. SME0$0.00$00$0.00$00$0.00$0
--> Link to Job Title on LCAT Tab0$0.00$00$0.00$00$0.00$0
--> Link to Job Title on LCAT Tab0$0.00$00$0.00$00$0.00$0
Labor Category 40$0.00$00$0.00$00$0.00$0
Labor Category 50$0.00$00$0.00$00$0.00$0
Labor Category…0$0.00$00$0.00$00$0.00$0
Subtotal, Direct Labor0$00$00$0
Materials
Material 10$0.00$00$0.00$00$0.00$0
Material 20$0.00$00$0.00$00$0.00$0
Material 30$0.00$00$0.00$00$0.00$0
Material 40$0.00$00$0.00$00$0.00$0
Material 50$0.00$00$0.00$00$0.00$0
…0$0.00$00$0.00$00$0.00$0
Subtotal, Materials$0$0$0
Travel
Travel 1$0$0$0
Travel 2$0$0$0
Subtotal, Travels
ODCs
ODC 10$0.00$00$0.00$00$0.00$0
ODC 20$0.00$00$0.00$00$0.00$0
ODC 30$0.00$00$0.00$00$0.00$0
ODC 40$0.00$00$0.00$00$0.00$0
…0$0.00$00$0.00$00$0.00$0
Subtotal, ODCs$0$0$0
TOTAL COST<Sum><Sum><Sum>
*Delete Rows, Add Rows/Columns, and Change Equations as Needed.
** Delete or add more subcontractor tabs as applicable.

Travel Breakout

Base PeriodNumber ofDurationR/TPer DiemDaily Car RentalOther per TripTotalTotal Cost
PeopleTripsDaysAirfareLodgingM&IEAirfareLodgingM&IERentalOther
From <Origin> to <Destination> 1$0$0$0$0$0$0
e.g. From APG, MD to Huston, TX323$375$118$71$50$34$2,250$1,416$1,065$600$67$5,398
From <Origin> to <Destination> 3$0$0$0$0$0$0
From <Origin> to <Destination> 4$0$0$0$0$0$0
From <Origin> to <Destination> 5$0$0$0$0$0$0
From <Origin> to <Destination> 6$0$0$0$0$0$0
From <Origin> to <Destination> 7$0$0$0$0$0$0
From <Origin> to <Destination> 8$0$0$0$0$0$0
From <Origin> to <Destination> 9$0$0$0$0$0$0
From <Origin> to <Destination> 10$0$0$0$0$0$0
Total$2,250$1,416$1,065$600$67$5,398

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