B08 Attachment 2 Scientific and Engineering Support_Price_Model 05052026.xlsx

XLSX spreadsheet 246 KB Posted

Attached to
ATC Scientific and Engineering Requirement Solicitation
Solicitation number
W91CRB26RA020
Issued by

About this file

This is a pricing model template for the Scientific and Engineering Support contract (Solicitation W91CRB-26-B-A002) issued by the Department of the Army Materiel Command, Army Contracting Command at Aberdeen Proving Ground. The template is designed for offerors to populate with their labor rates, indirect costs, and other pricing details for a three-year base period contract valued at $9,000,000 total ($3,000,000 per year).

The pricing model includes three contract line items (CLINs): CLIN 0001 for Time & Materials labor services with an annual productive hours requirement of 1,500 hours and anticipated 36,346 total labor hours across the three-year period, and CLINs 0002 and 0003 for Firm Fixed Price material and labor configuration costs estimated at $3,000,000 and $6,000,000 respectively. The template requires offerors to detail labor categories across 24 positions (ranging from Administrator to Tool and Die Maker) located in Aberdeen Proving Ground, Maryland, with specified full-time equivalents and hourly rates. Offerors must also provide indirect rate schedules including fringe benefits, overhead, and general & administrative (G&A) rates for each contract year. The template includes worksheets for cost summary, direct labor rate schedules, labor cost detail, material cost detail, and indirect rate calculations. However, the provided version contains all zero values for labor rates and indirect costs, indicating this is a blank template awaiting offeror input rather than a completed proposal submission.

View the file

Other files

Show all 12

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

Instructions

Instructions
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Government Inputs
Solicitation Number:W91CRB-26-B-A002
Name of Action:Scientific and Engineering Support
Period of Performance:
Annual Productive Hours:1,500
Offeror Inputs
Prime Contractor/Subcontractor Name/Division:
Street Address:
City, State and Zip Code:

Section B

Section B - Supplies or Services Costs and/or Prices
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
BASE PERIOD
CLINSUPPLIES/SERVICESQTYUNITAMOUNT
0001Base Period (3 years)1Each
Labor -T&M$ - 0From Cost Summary Worksheet
CLINSUPPLIES/SERVICESQTYUNITAMOUNT
0003Material Cost Detail1Each
COSTFirm Fixed Price$ 3,000,000.00From Cost Summary Worksheet (Labor for Material configuration)
Subtotal$ 3,000,000.00
CLINSUPPLIES/SERVICESQTYUNITAMOUNT
0003Material Cost Detail1Each
COSTFirm Fixed Price$ 6,000,000.00From Cost Summary Worksheet (Labor for Material configuration)
Subtotal$ 6,000,000.00
TOTAL
TOTAL
Estimated cost (T&M, FFP, COST) =$ 9,000,000.00

Total Price $ 9,000,000.00

Double check figure$ 9,000,000.00Total of clin totals
Double check figure$ 9,000,000.00Cost Summary Total
Double check figureERROR:#REF!Total from individual Worksheets

Cost Summary

Cost Summary Spreadsheet
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Scientific and Engineering SupportYear 1Year 2Year 3Total
Labor & Subcontract Labor Hours CLIN (0001) T&M12,11512,11512,11536,346From Labor Cost Detail Worksheet
Direct & Indirect Labor & Subcontract Labor CLIN (0002) FFP$ - 0$ - 0$ - 0$ - 0From Labor Cost Detail Worksheet
Labor & Subcontract Labor Hours CLIN (0003) COST$ 1,000,000.00$ 1,000,000.00$ 1,000,000.00$ 3,000,000.00
Material Cost Detail$ 2,000,000.00$ 2,000,000.00$ 2,000,000.00$ 6,000,000.00
Total Labor & ODC Costs$ 3,000,000.00$ 3,000,000.00$ 3,000,000.00$ 9,000,000.00

Direct Labor Rate Schedule

Direct Labor Rate Schedule
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
CLIN 0001: Base Period - Year 1CLIN 0001: Base Period - Year 2CLIN 0001: Base Period - Year 3ERROR:#REF!ERROR:#REF!
Labor CategoriesLocationLabor TypeSCA IdentifierProposed Labor RateCost Realism Basis for Rate ProposedProposed Labor RateEscalationProposed Labor RateEscalationProposed Labor RateEscalationProposed Labor RateEscalationProposed Labor Rate
AdministratorAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Computer EngineerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Electronic/Electrical EngineerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Manufacturing EngineerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
MathematicianAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Mechanical EngineerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Operations Research AnalystAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Project EngineerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Project ManagerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Senior Computer EngineerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Senior Electrical EngineerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Senior Mechanical EngineerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Senior Project EngineerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Senior Software Engineer/Computer ScientistAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Senior Systems EngineerAPG, MDProfessional$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Computer Programmer IIAPG, MDSCA14073$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Computer Programmer IIIAPG, MDSCA14074$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Computer Programmer IVAPG, MDSCA$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Electronics Technician Maintenance IIIAPG, MDSCA23183$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Engineering Technician IIAPG, MDSCA30082$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Engineering Technician IIIAPG, MDSCA30083$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Engineering Technician VIAPG, MDSCA30086$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Machine-Tool OperatorAPG, MDSCA19010$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Material Handling LaborerAPG, MDSCA21050$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Technical Writer IIIAPG, MDSCA30463$0.00$0.000.00%$0.000.00%$0.000.00%$0.00
Tool And Die MakerAPG, MDSCA19040$0.00$0.000.00%$0.000.00%$0.000.00%$0.00

Labor Cost Detail

Labor Cost Detail Spreadsheet
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Annual Productive Hours: 1500
Direct CostIndirect Cost
CLIN 0001: Base Period - Year 10.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
APG, MDProfessionalAdministratorEnter P or S0.51768.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalComputer EngineerEnter P or S0.20307.20$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalElectronic/Electrical EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalManufacturing EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalMathematicianEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalMechanical EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalOperations Research AnalystEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalProject EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalProject ManagerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Computer EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Electrical EngineerEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Mechanical EngineerEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Project EngineerEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Software Engineer/Computer ScientistEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Systems EngineerEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAComputer Programmer IIEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAComputer Programmer IIIEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAComputer Programmer IVEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAElectronics Technician Maintenance IIIEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAEngineering Technician IIEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAEngineering Technician IIIEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAEngineering Technician VIEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAMachine-Tool OperatorEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAMaterial Handling LaborerEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCATechnical Writer IIIEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCATool And Die MakerEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:8.0812,115.20$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,500.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 0001: Base Period - Year 20.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
APG, MDProfessionalAdministratorEnter P or S0.51768.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalComputer EngineerEnter P or S0.20307.20$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalElectronic/Electrical EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalManufacturing EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalMathematicianEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalMechanical EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalOperations Research AnalystEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalProject EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalProject ManagerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Computer EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Electrical EngineerEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Mechanical EngineerEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Project EngineerEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Software Engineer/Computer ScientistEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Systems EngineerEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAComputer Programmer IIEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAComputer Programmer IIIEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAComputer Programmer IVEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAElectronics Technician Maintenance IIIEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAEngineering Technician IIEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAEngineering Technician IIIEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAEngineering Technician VIEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAMachine-Tool OperatorEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAMaterial Handling LaborerEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCATechnical Writer IIIEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCATool And Die MakerEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:8.0812,115.20$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,500.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 0001: Base Period - Year 30.00%0.00%0.00%0.00%
Location (Note 1)Labor Type (Note 2)Labor Categories (Note 3)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 4)If Column D=S, Enter Name of Subcontractor(s) (Note 5)FTEs (Note 6)Total Productive Hours (Note 7)Hourly Base Pay Rate (Note 8)Fringe (Note 9)Overhead (Note 10)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 11)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 12)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijk = h + i + jl = g x kmn = l + oop = n + oq = p/gr = q/h
APG, MDProfessionalAdministratorEnter P or S0.51768.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0219,705.60
APG, MDProfessionalComputer EngineerEnter P or S0.20307.20$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalElectronic/Electrical EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalManufacturing EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalMathematicianEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalMechanical EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalOperations Research AnalystEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalProject EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalProject ManagerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Computer EngineerEnter P or S0.48720.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Electrical EngineerEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Mechanical EngineerEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Project EngineerEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Software Engineer/Computer ScientistEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDProfessionalSenior Systems EngineerEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAComputer Programmer IIEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAComputer Programmer IIIEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAComputer Programmer IVEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAElectronics Technician Maintenance IIIEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAEngineering Technician IIEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAEngineering Technician IIIEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAEngineering Technician VIEnter P or S0.16240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAMachine-Tool OperatorEnter P or S0.32480.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCAMaterial Handling LaborerEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCATechnical Writer IIIEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
APG, MDSCATool And Die MakerEnter P or S0.13192.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:8.0812,115.20$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,500.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!

Material Cost Detail

Material Cost Detail Spreadsheet (Note 13)
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
CLINDescriptionODCsBurden/G&A RateG&ATotal ODC Cost
abcde = c x df = c + e
ODCs Year 1$ 2,000,000.00$ - 0$ 2,000,000.00
ODCs Year 2$ 2,000,000.00$ - 0$ 2,000,000.00
ODCs Year 3$ 2,000,000.00$ - 0$ 2,000,000.00
Total$ 6,000,000.000.00%$ - 0$ 6,000,000.00
(To Section B)

Indirect Rate Summary

Indirect Rate Summary Spreadsheet
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
EntityContract TypeFringe RateOverhead RateG&A RateProposed Fee Rate% of Effort Performed by Prime and Subs Based on Labor Hours
Year 1
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(i.e. 100%)
Year 2
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(i.e. 100%)
Year 3
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(i.e. 100%)
Year 4
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%
Year 5
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%

Please enter corresponding indirect rates for the prime and each subcontractor for each of the periods.

Subcontractors may provide data separately in the above format for proprietary reasons.

Provide the necessary narrative describing how the rates were derived and applied, the composition of the allocation pools & bases, and provide any supporting forward rate agreements and DCAA/DCMA agreements/reports.

If rates proposed are based on other than actual rates, please state the reason(s).

Sample Fringe, Overhead, and G&A worksheet schedules follow this tab.

Fringe Benefit Worksheet

Fringe Benefit Worksheet
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Statutory Fringe Benefits:*Enter %**
FICA0.00%
FUTA0.00%
SUTA0.00%
Workman's Compensation0.00%
Etc - Enter Additional Categories As Needed0.00%
Fringe Benefits:*Fringe benefit offered to all professional employees? (Yes/No) (Explain, if no)Employer ShareEmployee Share, if applicableEnter %**Describe fringe benefit and enter any additional comments
Paid Leave/Vacation0%
Holidays0%
Sick Leave0%
Jury Duty0%
Military Leave0%
Bereavement Leave0%
Health Insurance0%
Health/Flexible Spending Account0%
Dental Insurance0%
Vision Insurance0%
Health Reimbursement0%
Disability Insurance Short & Term0%
Disability Insurance Long Term0%
Life insurance0%
401K or retirement plan0%
Profit sharing0%
Tuition Reimbursement0%
Etc - Enter Additional Categories As Needed0%

Paid Leave/Vacation (PTO, Sick, Military, etc.) Years of Experience Hours Alloted Per Year

*Please enter all the fringe benefit categories to be offered to professional FLSA exempt employees under this contract. Please complete this sheet for each fringe benefit pool if multiple pools exist.
**What % of the fringe benefit category contributes to the overall fringe benefit rate?

Fringe Rate Worksheet

Fringe Rate Worksheet
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Fringe Expenses:Estimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
Indirect payroll$ - 0$ - 0$ - 0$ - 0$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)$ - 0$ - 0$ - 0$ - 0$ - 0
Vacation (PTO)$ - 0$ - 0$ - 0$ - 0$ - 0
Holiday$ - 0$ - 0$ - 0$ - 0$ - 0
Sick Leave$ - 0$ - 0$ - 0$ - 0$ - 0
Health/Disability Ins$ - 0$ - 0$ - 0$ - 0$ - 0
Workmans Compensation/Defense Base Act$ - 0$ - 0$ - 0$ - 0$ - 0
Bonuses$ - 0$ - 0$ - 0$ - 0$ - 0
Retention Pay$ - 0$ - 0$ - 0$ - 0$ - 0
401k Match$ - 0$ - 0$ - 0$ - 0$ - 0
Mil Leave$ - 0$ - 0$ - 0$ - 0$ - 0
Breavement$ - 0$ - 0$ - 0$ - 0$ - 0
Insurance$ - 0$ - 0$ - 0$ - 0$ - 0
Total Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Cost
Entertainment, etc.$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Net Allowable cost$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0
OH Labor$ - 0$ - 0$ - 0$ - 0$ - 0
B&P Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Base$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Overhead Rate Worksheet

Overhead Rate Worksheet
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
Overhead Expenses:Estimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Cost
Entertainment, etc.$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0
Net Allowable cost$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0
OH Labor$ - 0$ - 0$ - 0$ - 0$ - 0
B&P Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Base$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

G&A Rate Worksheet

G&A Rate Worksheet
Solicitation Number: W91CRB-26-B-A002
Name of Action: Scientific and Engineering Support
Prime Contractor/Subcontractor Name/Division:
Period of Performance:
G&A Expenses:Estimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe$ - 0$ - 0$ - 0$ - 0$ - 0
Subscriptions$ - 0$ - 0$ - 0$ - 0$ - 0
Postage$ - 0$ - 0$ - 0$ - 0$ - 0
Printing$ - 0$ - 0$ - 0$ - 0$ - 0
Supplies$ - 0$ - 0$ - 0$ - 0$ - 0
Telephone$ - 0$ - 0$ - 0$ - 0$ - 0
Travel$ - 0$ - 0$ - 0$ - 0$ - 0
Misc$ - 0$ - 0$ - 0$ - 0$ - 0
Training$ - 0$ - 0$ - 0$ - 0$ - 0
Recruiting$ - 0$ - 0$ - 0$ - 0$ - 0
Maint$ - 0$ - 0$ - 0$ - 0$ - 0
Equip$ - 0$ - 0$ - 0$ - 0$ - 0
Consultants$ - 0$ - 0$ - 0$ - 0$ - 0
Prof fees$ - 0$ - 0$ - 0$ - 0$ - 0
Filings$ - 0$ - 0$ - 0$ - 0$ - 0
Legal$ - 0$ - 0$ - 0$ - 0$ - 0
Total G&A$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Costs
Interest$ - 0$ - 0$ - 0$ - 0$ - 0
Contributions$ - 0$ - 0$ - 0$ - 0$ - 0
Advertising, etc.$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0
G&A Pool After Deducting Unallowable Cost$ - 0$ - 0$ - 0$ - 0$ - 0
Allocation Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead (including any unallowable cost)$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Costs (inclusing any unallowable cost)$ - 0$ - 0$ - 0$ - 0$ - 0
Total G&A Allocation Base$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

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