Attachment_1_PRICE.xlsx

XLSX spreadsheet 106 KB Posted

Attached to
Analytical Support Services
Solicitation number
W91CRB-17-T-0033
Issued by

About this file

Attachment 1 Pricing Template

View the file

Other files

File Type Posted
Amendment_0001.pdf PDF
Attachment_2_DD254.pdf PDF
W91CRB-17-T-0033_Solicitation.pdf PDF

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

Section B Labor & ODC Proposed Labor & ODC

DIRECT LABOR**# of PersonnelEst. Productive Hours Per (Billed Hours)Loaded Rated per Hour *Estimated Cost
System Administration1ERROR:#REF!ERROR:#REF!ERROR:#REF!
Database Management Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
Web Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Applications Programming Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Information Assurance Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Comsec Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
Logistics Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
VTC Support5
Optional Categories
Training Support1ERROR:#REF!
IT Customer Support3ERROR:#REF!
Configuration Management Support2ERROR:#REF!ERROR:#REF!ERROR:#REF!
Systems Analyst Support10ERROR:#REF!ERROR:#REF!ERROR:#REF!
Telephone Support1ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!ERROR:#REF!
Total LaborERROR:#REF!ERROR:#REF!
Burden Rate
Total ODC's$ - 0$ - 0
Total Travel$ - 0$ - 0

Grand Total ERROR:#REF!

Entering the appropriate percentages in the shaded areas will automatically compute the corresponding amounts in the spreadsheet.
* = From labor detail spreadsheet.
** = NOTE: In this case, OCONUS means Iraq or Afghanistan. If performance is required in an OCONUS location other than Iraq or Afghanistan, proposed OCONUS rates will not be in effect. See CLIN 0001 for more detail.
Attachment 1Labor Categories and
Level of EffortW91CRB-08-R-0092

INSTRUCTIONS

INSTRUCTIONS

SECTION B

SECTION B - SUPPLIES OR SERVICES & PRICES
Solicitation #
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0001Labor / Travel (months 1 - 60)1Each$ - 0
FFPLabor =$ - 0From Labor Worksheet
Profit on Labor =$ - 0From Labor Worksheet
Travel =$ 100,000.00From ODC Worksheet
Total FFP$ 100,000.00
CLINSUPPLIES/SERVICESQUANTITY
0002Accounting for Contract Services (CMRA) Base Period1
NOT SEPARATELY PRICED$ - 0
$ - 0
TOTAL
Estimated Price =$ 100,000.00
Profit =$ - 0
Total =$ 100,000.00

$ 100,000.00 double check number from Labor + Travel Summary worksheets

&F, &A

PAGE &P OF &N

Labor

Labor - Cost Detail Spreadsheet
Solicitation #LABOR COST COST DETAIL
Prime Contractor/Subcontractor Name/Division:
0.00%
CLIN 0001- Year 10.00%0.00%0.00%0.00%
POSITON TITLESTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor(s)Hourly Base Pay Rate (Note 3 )Fringe(Note 4)Overhead (Note 4)Rate Before Application Of Prime G&A & Fee (Note 5)Total Prime & Sub Labor Before Prime G&A & FeeG&A TotalSubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcdefgh = g X fringeijk = d X jlm = k + lno = m + np = o/d
GOVERNMENT SITE POSITIONS
C3CO Analyst320Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
CBRN Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Demlitarization Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Dmilitarization Engineer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computational Fluid Dynamics Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospacial Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Technician320Enter P or S0.000.000.000.000.000.000.000.000.000.00
ISR Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Lead Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Power and Energy Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Reliability Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Research Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Web Application/Database Developer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CONTRACTOR SITE POSITIONS
C3CO Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Demlitarization Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Dmilitarization Engineer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computational Fluid Dynamics Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospacial Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Technician320Enter P or S0.000.000.000.000.000.000.000.000.000.00
ISR Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Lead Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Power and Energy Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Reliability Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Research Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Web Application/Database Developer320Enter P or S0.000.000.000.000.000.000.000.000.000.00

14,720 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

0.00%
CLIN 0001- Year 20.00%0.00%0.00%0.00%
POSITON TITLESTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor(s)Hourly Base Pay Rate (Note 3 )Fringe (Note 4)Overhead (Note 4)Rate Before Application Of Prime G&A & Fee (Note 5)Total Prime & Sub Labor Before Prime G&A & FeeG&ASubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcd=b X cefgh = g X fringeijk = d X jlm = k + lno = m + np = o/d
GOVERNMENT SITE POSITIONS
C3CO Analyst320Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
CBRN Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Demlitarization Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Dmilitarization Engineer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computational Fluid Dynamics Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospacial Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Technician320Enter P or S0.000.000.000.000.000.000.000.000.000.00
ISR Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Lead Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Power and Energy Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Reliability Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Research Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Web Application/Database Developer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CONTRACTOR SITE POSITIONS
C3CO Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Demlitarization Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Dmilitarization Engineer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computational Fluid Dynamics Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospacial Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Technician320Enter P or S0.000.000.000.000.000.000.000.000.000.00
ISR Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Lead Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Power and Energy Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Reliability Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Research Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Web Application/Database Developer320Enter P or S0.000.000.000.000.000.000.000.000.000.00

14,720 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

0.00%
CLIN 0001- Year 30.00%0.00%0.00%0.00%
POSITON TITLESTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor(s)Hourly Base Pay Rate (Note 3 )Fringe (Note 4)Overhead (Note 4)Rate Before Application Of Prime G&A & Fee (Note 5)Total Prime & Sub Labor Before Prime G&A & FeeG&ASubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcd=b X cefgh = g X fringeijk = d X jlm = k + lno = m + np = o/d
GOVERNMENT SITE POSITIONS
C3CO Analyst320Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
CBRN Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Demlitarization Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Dmilitarization Engineer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computational Fluid Dynamics Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospacial Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Technician320Enter P or S0.000.000.000.000.000.000.000.000.000.00
ISR Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Lead Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Power and Energy Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Reliability Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Research Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Web Application/Database Developer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CONTRACTOR SITE POSITIONS
C3CO Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Demlitarization Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Dmilitarization Engineer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computational Fluid Dynamics Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospacial Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Technician320Enter P or S0.000.000.000.000.000.000.000.000.000.00
ISR Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Lead Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Power and Energy Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Reliability Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Research Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Web Application/Database Developer320Enter P or S0.000.000.000.000.000.000.000.000.000.00

14,720 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

0.00%
CLIN 0001- Year 40.00%0.00%0.00%0.00%
POSITON TITLESTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor(s)Hourly Base Pay Rate (Note 3 )Fringe (Note 4)Overhead (Note 4)Rate Before Application Of Prime G&A & Fee (Note 5)Total Prime & Sub Labor Before Prime G&A & FeeG&ASubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcd=b X cefgh = g X fringeijk = d X jlm = k + lno = m + np = o/d
GOVERNMENT SITE POSITIONS
C3CO Analyst320Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
CBRN Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Demlitarization Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Dmilitarization Engineer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computational Fluid Dynamics Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospacial Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Technician320Enter P or S0.000.000.000.000.000.000.000.000.000.00
ISR Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Lead Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Power and Energy Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Reliability Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Research Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Web Application/Database Developer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CONTRACTOR SITE POSITIONS
C3CO Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Demlitarization Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Dmilitarization Engineer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computational Fluid Dynamics Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospacial Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Technician320Enter P or S0.000.000.000.000.000.000.000.000.000.00
ISR Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Lead Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Power and Energy Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Reliability Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Research Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Web Application/Database Developer320Enter P or S0.000.000.000.000.000.000.000.000.000.00

14,720 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

0.00%
CLIN 0001- Year 50.00%0.00%0.00%0.00%
POSITON TITLESTotal HoursEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor(s)Hourly Base Pay Rate (Note 3 )Fringe (Note 4)Overhead (Note 4)Rate Before Application Of Prime G&A & Fee (Note 5)Total Prime & Sub Labor Before Prime G&A & FeeG&ASubtotalProfit TotalTotalTotal Burdened Rate Including Fee
abcd=b X cefgh = g X fringeijk = d X jlm = k + lno = m + np = o/d
GOVERNMENT SITE POSITIONS
C3CO Analyst320Enter P or S$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
CBRN Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Demlitarization Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Dmilitarization Engineer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computational Fluid Dynamics Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospacial Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Technician320Enter P or S0.000.000.000.000.000.000.000.000.000.00
ISR Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Lead Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Power and Energy Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Reliability Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Research Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Web Application/Database Developer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CONTRACTOR SITE POSITIONS
C3CO Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
CBRN Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Demlitarization Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Chemical Dmilitarization Engineer320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Computational Fluid Dynamics Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Dynamics Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Finite Element Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospacial Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Analyst - Senior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Geospatial Technician320Enter P or S0.000.000.000.000.000.000.000.000.000.00
ISR Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Lead Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Mobility Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Power and Energy Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Reliability Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Research Analyst320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Journeyman320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Vibration Analyst - Junior320Enter P or S0.000.000.000.000.000.000.000.000.000.00
Web Application/Database Developer320Enter P or S0.000.000.000.000.000.000.000.000.000.00

14,720 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

&F, &A

PAGE &P OF &N

Travel - Summary Travel Detail Spreadsheet

Prime Contractor/Subcontractor Name/Division:

Travel DETAIL

CLINTravel/ODCs (Note 6)Burden/G&A and/or MH RateIndirect $Total Travel
abcd = b X ce = b + d
CLIN 0001 - Travel Year 1 (months 1-12)$ 20,000.000%$ - 0$ 20,000.00
CLIN 0001 - Travel Year 2 (months 13-24)$ 20,000.000%$ - 0$ 20,000.00
CLIN 0001 - Travel Year 3 (months 25-36)$ 20,000.000%$ - 0$ 20,000.00
CLIN 0001 - Travel Year 4 (months 37-48)$ 20,000.000%$ - 0$ 20,000.00
CLIN 0001 - Travel Year 5 (months 49-60)$ 20,000.000%$ - 0$ 20,000.00
Total$ 100,000.00$ - 0$ 100,000.00
(To Section B)$ 100,000.00
Travel will be on a Firm Fixed Price basis based on each individual Task Order not-to-exceed $100,000 for the contract period of 5 years.
For proposal purposes, offerors may to enter aplicable indirects to their travel in the blue shaded cells.
Travel is broken out for basic IDIQ proposal purposes only - to allow for normalized competition.

DIRECT LABOR RATES

DIRECT LABOR RATES
Solicitation #
YEAR 1YEAR 2YEAR 3YEAR 4YEAR 5
LABOR CATEGORIESPROPOSED DIRECT LABOR RATESBASIS OF PROPOSED RATE FOR COST REALISM PURPOSESESCALATIONPROPOSED DIRECT LABOR RATESESCALATIONPROPOSED DIRECT LABOR RATESESCALATIONPROPOSED DIRECT LABOR RATESESCALATIONPROPOSED DIRECT LABOR RATES
NOTE 1NOTE 2NOTE 3NOTE 3NOTE 3NOTE 3
NOTE 1: Please enter all the corresponding labor categories proposed in the labor cost detail spreadhseets.
NOTE 2: For realism purposes in accordance with 52.222-46, indicate the basis of the proposed rates and provide documentation to substantiate the rates.
If the rates are based on actuals provide pay stubs, signed employee letters of intent, etc.
If the rates are based on estimates provide salary survey data and other data to corroborate the realism of the rates.
NOTE 3: Please provide the basis of escalation.

Sample Fringe -Worksheet

DIRECT LABOR FRINGE/OVERHEAD RATE
Solicitation #
Company, Inc.
Anycity, USA
Proposal Submitted In Response to XXXXX
DIRECT LABOR FRINGE RATE
20152016CurrentEstimatedEstimatedEstimated
Overhead Expenses:ActualActualActualYear 1Year 2Year 3
Indirect payroll$ - 0$ - 0$ - 0$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)$ 12,000.00$ 12,000.00$ 12,000.00$ 11,000.00$ 10,000.00$ 8,700.00
Vacation (PTO)$ 12,000.00$ 12,000.00$ 12,000.00$ 11,000.00$ 10,000.00$ 8,000.00
Holiday$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sick Leave$ 600.00$ 600.00$ 600.00$ 600.00$ 600.00$ 600.00
Health/Disability Ins$ 7,000.00$ 7,000.00$ 7,000.00$ 7,000.00$ 7,000.00$ 6,500.00
Workmans Compensation$ 4,000.00$ 4,000.00$ 4,000.00$ 4,000.00$ 4,000.00$ 4,000.00
Bonuses$ 1,000.00$ 1,000.00$ 1,000.00$ 1,000.00$ 1,000.00$ 1,000.00
Retention Pay$ 2,000.00$ 2,000.00$ 2,000.00$ 1,000.00$ 1,000.00$ 1,000.00
401k Match$ 4,000.00$ 4,000.00$ 4,000.00$ 3,500.00$ 3,000.00$ 3,000.00
Mil Leave$ 100.00$ 100.00$ 100.00$ 100.00$ 100.00$ 50.00
Breavement$ 100.00$ 100.00$ 100.00$ 200.00$ 200.00$ 50.00
Insurance$ 200.00$ 200.00$ 200.00$ 200.00$ 200.00$ 100.00
Total Pool$ 43,000.00$ 43,000.00$ 43,000.00$ 39,600.00$ 37,100.00$ 33,000.00
Less: FAR 31 Unallowable Cost
Entertainment, etc.
Net Allowable cost$ 43,000.00$ 43,000.00$ 43,000.00$ 39,600.00$ 37,100.00$ 33,000.00
Labor Base
Direct Labor$ 113,500.00$ 113,500.00$ 113,500.00$ 100,000.00$ 90,000.00$ 80,000.00
OH Labor$ 4,352.00$ 4,352.00$ 4,352.00$ 4,200.00$ 4,100.00$ 4,000.00
B&P Labor$ 1,200.00$ 1,200.00$ 1,200.00$ 1,100.00$ 1,100.00$ 1,000.00
Total Labor Base$ 119,052.00$ 119,052.00$ 119,052.00$ 105,300.00$ 95,200.00$ 85,000.00

Rate 36.12% 36.12% 36.12% 37.61% 38.97% 38.82%

This exhibit shows a combined fringe benefit/overhead allocation. However the offeror may in actuality have separate
allocations for fringe benefits and overhead depending on its accounting system.

Sample Overhead -Worksheet

DIRECT LABOR FRINGE/OVERHEAD RATE
Solicitation #
Company, Inc.
Anycity, USA
Proposal Submitted In Response to XXXXX
OVERHEAD RATE
CurrentEstimatedEstimatedEstimated
Overhead Expenses:ActualYear 1Year 2Year 3
Indirect payroll$ - 0$ - 0$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)$ 12,000.00$ 11,000.00$ 10,000.00$ 8,700.00
Vacation (PTO)$ 12,000.00$ 11,000.00$ 10,000.00$ 8,000.00
Holiday$ - 0$ - 0$ - 0$ - 0
Sick Leave$ 600.00$ 600.00$ 600.00$ 600.00
Health/Disability Ins$ 7,000.00$ 7,000.00$ 7,000.00$ 6,500.00
Workmans Compensation$ 4,000.00$ 4,000.00$ 4,000.00$ 4,000.00
Bonuses$ 1,000.00$ 1,000.00$ 1,000.00$ 1,000.00
Retention Pay$ 2,000.00$ 1,000.00$ 1,000.00$ 1,000.00
401k Match$ 4,000.00$ 3,500.00$ 3,000.00$ 3,000.00
Mil Leave$ 100.00$ 100.00$ 100.00$ 50.00
Breavement$ 100.00$ 200.00$ 200.00$ 50.00
Insurance$ 200.00$ 200.00$ 200.00$ 100.00
Total Pool$ 43,000.00$ 39,600.00$ 37,100.00$ 33,000.00
Less: FAR 31 Unallowable Cost
Entertainment, etc.
Net Allowable cost$ 43,000.00$ 39,600.00$ 37,100.00$ 33,000.00
Labor Base
Direct Labor$ 113,500.00$ 100,000.00$ 90,000.00$ 80,000.00
OH Labor$ 4,352.00$ 4,200.00$ 4,100.00$ 4,000.00
B&P Labor$ 1,200.00$ 1,100.00$ 1,100.00$ 1,000.00
Total Labor Base$ 119,052.00$ 105,300.00$ 95,200.00$ 85,000.00

Rate 36.12% 37.61% 38.97% 38.82%

This exhibit shows a combined fringe benefit/overhead allocation. However the offeror may in actuality have separate
allocations for fringe benefits and overhead depending on its accounting system.

Sample G&A Worksheet

GENERAL & ADMINISTRATIVE (G&A) EXPENSE
Solicitation #
Company, Inc
Yourcity, USA
Proposal Submitted In Response to xxxxxx
GENERAL & ADMINISTRATIVE (G&A) EXPENSE RATE
CurrentEstimatedEstimatedEstimated
G&A Expenses:ActualsYear 1Year 2Year 3
Labor11,000.0011,000.0011,000.0011,000.00
Fringe2,700.002,700.002,600.002,500.00
Subscriptions85.0085.0085.0085.00
Postage45.0045.0045.0045.00
Printing16.0016.0016.0016.00
Supplies101.00100.00100.00100.00
Telephone334.00334.00334.00334.00
Travel675.00650.00625.00600.00
Misc118.00110.00105.00100.00
Training294.00270.00260.00250.00
Recruiting87.0087.0087.0087.00
Maint125.00125.00125.00125.00
Equip265.00265.00265.00265.00
Consultants35.0035.0035.0035.00
Prof fees573.00570.00570.00570.00
Filings300.00300.00300.00300.00
Legal275.00275.00275.00275.00
Total G&A17,028.0016,967.0016,827.0016,687.00
Less: FAR 31 Unallowable Costs
Interest
Contributions
Advertising, etc.
Total Unallowable Costs0.000.000.000.00
G&A Pool After Deducting Unallowable Cost17,028.0016,967.0016,827.0016,687.00
Allocation Base
Direct Labor$240,000.00$239,000.00$238,000.00$200,000.00
Fringe$82,000.00$81,000.00$80,000.00$79,000.00
Overhead (including any unallowable cost)$33,500.00$33,400.00$33,300.00$33,200.00
Other Direct Costs (inclusing any unallowable cost)$373,000.00$372,000.00$371,000.00$371,000.00
Total G&A Allocation Base$728,500.00$725,400.00$722,300.00$683,200.00

Rate 2.30% 2.30% 2.30% 2.40%

Microsoft_Word_Document1.docx General: Offeror is to provide a cost/price proposal and accompanying narrative as part of their proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed enclosed spreadsheets shall be part of the cost/price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any and all divisions and subcontractors proposed to perform effort in response to this solicitation. The information will be evaluated for acceptability, fairness, and reasonableness based on the cost/price analysis criteria in FAR 15.404-1. Please enter the requested data in the light blue shaded areas in the Labor spreadsheet and in the Direct Labor Rates spreadsheet. The spreadsheets are designed to automatically compute and populate other cells in the Excel spreadsheets and workbooks.

Section B Worksheet: The Section B worksheet imports data from the Labor Spreadsheet and Travel Summary spreadsheet and is used as a basis for the proposed formal Section B.

Labor Worksheet:

General: Enter the requested data in the blue shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect differences or nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes.

NOTE 1: not used.

NOTE 2: Column a of the Labor Spreadsheets contains labor categories. During contract performance these categories ostensibly may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a P in Col e if the effort is to be performed by the prime contractor, and a S if performed by another division or subcontractor. Enter the name of the division or contractor in Col f. If the particular individual category is to be performed by more than one entity, the offeror will be required to insert additional row(s) under the labor category and to allocate the Col d hours for the individual category among the Col d cells in the original and inserted rows to reflect the proposed performance during the contract. After this allocation, the total of the original and inserted rows under the individual category shall total to the number of hours proposed for the respective labor category.

NOTE 3: Please enter the base labor rate for the labor categories listed. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead, G&A, and fee. Data in this field and the data in Column h (fringe) will be used to evaluate offerors total compensation in accordance with FAR 52.222-46.

NOTE 4: Apply fringe/overhead to prime offeror derived rates. "Sample Fringe-Worksheet" provides a sample to be used to compute fringe/overhead.

NOTE 5: Please enter the prime offeror or subcontractor billing rate (if performed by a subcontractor) BEFORE application of prime offeror general and administrative (G&A) expense and fixed fee. Therefore, the rate entered for prime contractor performed rate categories is as follows: rate = prime base labor rate + prime fringe + prime overhead. If the labor category is performed by a subcontractor, the rate entered in Col j is as follows: Rate = sub base rate +sub fringe + sub overhead + sub G&A + sub fee (i.e. subcontractor loaded rate EXCEPT for prime G&A and fee).

Travel-Summary - Spreadsheet:

NOTE 6: A contract not-to-exceed amount for travel/ODCs has been specified for proposal purposes. Each offeror is to include this amount in their proposal. Any material handling and/or G&A is to be applied as appropriate. Since this is an estimated amount that may or may not occur, no fixed fee will be proposed.

Direct Labor Rate Schedule – Supporting direct labor rate worksheet. Offeror should enter all of the corresponding labor categories proposed in the labor cost detail worksheets proposed on a cost basis. For cost realism in accordance with 52.222-46 purposes, prime should indicate their basis of the proposed rates and provide documentation to substantiate the rates.

Sample Fringe and Overhead Worksheet: This spreadsheet shows a generally accepted format for fringe benefit and/or overhead pool/base/rate calculations. Fringe benefit and overhead pool, base, and rate calculations are required as part of the offeror's cost/price proposal. The fringe and overhead rates may be calculated together or separately depending on the contactor/subcontractor's accounting system. Please provide a similar schedule for fringe and overhead for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please indicate if the rates are based on a forward pricing rate agreement (FPRA) or other signed rate agreement with DCAA and/or DCMA. Subcontractor data may be submitted directly to the Contracting Officer for proprietary reasons.

Sample G&A Worksheet: This spreadsheet shows a generally accepted format for G&A pool/base/rate calculations. G&A pool, base, and rate calculations are required as part of the offeror's cost/price proposal. Please provide a similar schedule for G&A for each FY for the offeror and each division or subcontractor. Describe as necessary in the cost/price narrative. Please indicate if the G&A rates are based on a forward pricing rate agreement (FPRA) or other signed rate agreement with DCAA and/or DCMA. Subcontractor data may be submitted directly to the Contracting Officer for proprietary reasons.

image2.emf

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