Attachment 0001 - Government Format Pricing Model.xlsx

XLSX spreadsheet 48 KB Posted

Attached to
Intelligence and Automation Operations Federal contract opportunity
Solicitation number
W50NH9-26-R-A002
Issued by
Department of the Army Materiel Command Contracting Command Detroit Arsenal

About this file

Written by GovTribe AI ·

This is a Government Format Pricing Model (GFPM) template in Excel format for the Intelligence and Automation Operations contract (W50NH9-26-R-A002) issued by the U.S. Army Contracting Command-Detroit Arsenal under INSCOM. The pricing model is structured as a firm fixed price (FFP) level of effort contract with cost-reimbursable line items for Other Direct Costs (ODCs), requiring offerors to propose Fully Burdened Labor Rates (FBLRs) for all performance periods.

The template specifies staffing requirements across a base year (August 1, 2026 – July 31, 2027) and four option periods of equal duration, with a total of 46.5 full-time equivalent (FTE) positions across multiple labor categories and military installations including Fort Belvoir VA, Fort Huachuca AZ, Fort Liberty NC, and Joint Base Lewis-McChord WA. The labor categories include intelligence specialists, developers, system administrators, trainers, and support personnel, with a total of 88,908 hours per year (444,540 hours across the base and four option periods, plus 44,454 hours for FAR 52.217-8 adjustment, totaling 488,994 hours). Government-provided plug numbers for ODCs include $100,000 annually for travel and $35,000 annually for materials across all periods, with a FAR 52.217-8 adjustment of $50,000 for travel and $17,500 for materials. Offerors must complete all yellow-highlighted cells with proposed FBLRs for each labor category and period, propose ODC/Travel burden rates (which become maximum billing rates), and leave all other cells unmanipulated. The total evaluated price across all periods is $742,500, comprising $675,000 for the base and four options and $67,500 for FAR 52.217-8 adjustment.

View the file

Other files for this federal contract opportunity

Other files attached to Intelligence and Automation Operations, newest first.
File Type Posted
Solicitation Amendment 0003 - W50NH926RA0020003 Professional Appearance.pdf PDF
Solicitation Amendment 0003 - W50NH926RA0020003 SF 30.pdf PDF
Attachment 0002 - Performance Work Statement 4.16.2026.pdf PDF
Attachment 0002 - Performance Work Statement 4.9.2026.pdf PDF
Solicitation Amendment 0002 - W50NH926RA0020002 Professional Appearance.pdf PDF
Solicitation Amendment 0002 W50NH926RA0020002 SF 30.pdf PDF
Solicitation Questions and Answers 4.9.2026.xlsx XLSX spreadsheet
Solicitation Amendment W50NH926RA0020001 SF 30.pdf PDF
Solicitation Amendment 0001 - W50NH926RA0020001 Professional Appearance.pdf PDF
Solicitation - W50NH926RA002 Professional Appearance.pdf PDF
Exhibit A - Contract Data Requirements List.pdf PDF
Solicitation - W50NH926RA002 Professional Appearance.pdf PDF
Attachment 0002 - Performance Work Statement.pdf PDF
Attachment 0003 - DD254 - Solicitation.pdf PDF
Show all 14

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.

Instructions

CUI

Government Format Pricing Model - Instructions To Offeror
General
1Firm Fixed Price (FFP) Level of Effort (LOE) with Cost Reimbursable CLINS for ODCs.
2Do not manipulate any cells other than those highlighted in yellow unless specifically authorized in these instructions or an overt mathematic calculation exists. If an error is identified in this GFPM, immediately contact the Contract Specialist or Contracting Officer.
3If an offeror does not follow these instructions COMPLETELY (such as by not completing ALL cells highlighted in yellow with a proposed price), the offeror's proposal may be rejected. If the offeror intends a cell to be zero, they must explicitly enter "0".
Summary Tab
1Offeror shall input offeror name in cell A4
2No other offeror input is necessary, all totals will auto-populate from the period of performance tab.
3The total proposed price is calculated in cell B23. Total Evaluated price is calculated in cell B25.
Period of Performance Tab
1Offeror input is required in all cells highlighted in yellow.
2The offeror shall input its proposed Fully Burdened Labor Rate (FBLR) in Columns Highlighted in Yellow for all periods.
3All extended and subtotal values are automatically calculated.
Other Direct Costs (ODCs)
1Other Direct Costs-Are Government provided plug numbers inclusive of burdens No profit or fee is allowable on ODCs. Offerors shall propose an ODC/Travel burden rate for each period which includes all burdens applied to ODCs/Travel in accordance with the offeror’s accounting system in cells D15 thru D20 and H15 thru H20. These rates will become the ODC/Travel Maximum Billing Rates (OTMBRs).
Contract Rates (FBLRs) Tab
1This tab contains a summary of all proposed Fully Burdened Labor Rates (FBLRs) for all periods auto populated from the period of performance tab. No Input is required. Do not manipulate anything on this tab.
Hours Sheet Tab
1This tab contains a summary of all proposed hours for all periods auto populated from the period of performance tab. No Input is required. Do not manipulate anything on this tab.

Summary

CUI

W50NH9-26-R-A002 - Attachment 0001 - Government Format Pricing Model
Offeror Name:
Base YearOption Period 1Option Period 2Option Period 3Option Period 4Sum TotalFAR 52.217-8Totals
Labor
Labor Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Proposal Labor Totals$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Costs
Materials$35,000.00$35,000.00$35,000.00$35,000.00$35,000.00$175,000.00$17,500.00$192,500.00
Travel (Government Provided Plug Number)$100,000.00$100,000.00$100,000.00$100,000.00$100,000.00$500,000.00$50,000.00$550,000.00
Proposal ODC Totals$135,000.00$135,000.00$135,000.00$135,000.00$135,000.00$675,000.00$67,500.00$742,500.00
Total Proposal Price$135,000.00$135,000.00$135,000.00$135,000.00$135,000.00$675,000.00$67,500.00$742,500.00
Total Proposed Price
Ordering Period One$135,000.00
Ordering Period Two$135,000.00
Ordering Period Three$135,000.00
Ordering Period Four$135,000.00
Ordering Period Five$135,000.00
Total Proposed Price$675,000.00
FAR 52.217-8$67,500.00
Total Evaluated Price$742,500.00

Period of Performance

CUI

W50NH9-26-R-A002 - Attachment 0001 - Government Format Pricing Model
Offeror Name:
Period of PerformanceBASE YEAR - 1 August 2026 - 31 July 2027Option Period 1 - 1 August 2027 - 31 July 2028Option Period 2 - 1 August 2028 - 31 July 2029Option Period 3 - 1 August 2029 - 31 July 2030Option Period 4 - 1 August 2030 - 31 July 2031FAR 52.217-8
Labor CategoriesLevelLocationNumber of FTEsTotal HoursProposed FBLRExtended PriceNumber of FTEsTotal HoursProposed FBLRExtended PriceNumber of FTEsTotal HoursProposed FBLRExtended PriceNumber of FTEsTotal HoursProposed FBLRExtended PriceNumber of FTEsTotal HoursProposed FBLRExtended PriceNumber of FTEsTotal HoursProposed FBLRExtended Price
Dissemination Specialist (Team Lead)SeniorFort Belvoir, VA11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Dissemination SpecialistSeniorFort Belvoir, VA11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Dissemination SpecialistMidFort Belvoir, VA23824$ - 0$ - 023824$ - 0$ - 023824$ - 0$ - 023824$ - 0$ - 023824$ - 0$ - 021912$ - 0$ - 0
Content Site ManagerSeniorFort Belvoir, VA35736$ - 0$ - 035736$ - 0$ - 035736$ - 0$ - 035736$ - 0$ - 035736$ - 0$ - 032868$ - 0$ - 0
Business AdministratorSeniorFort Belvoir, VA11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Intelligence Management SpecialistSeniorFort Belvoir, VA11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Mission Trainer (Team Lead)SeniorFort Belvoir, VA11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Mission TrainerSeniorFort Belvoir, VA23824$ - 0$ - 023824$ - 0$ - 023824$ - 0$ - 023824$ - 0$ - 023824$ - 0$ - 021912$ - 0$ - 0
Mission TrainerSeniorFort Huachuca, AZ11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Mission TrainerSeniorFort Liberty, NC11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Intelligence Solutions Integrator (Team Lead)SeniorFort Belvoir, VA11912$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Intelligence Solutions IntegratorSeniorFort Belvoir, VA11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Intelligence Sharing SpecialistMidFort Belvoir, VA11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Intelligence Solutions IntegratorSeniorJoint Base Lewis-McChord (JBLM), WA11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Data Integration (Team Lead)SeniorFort Belvoir, VA11912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 011912$ - 0$ - 01956$ - 0$ - 0
Helpdesk / Access ManagerSeniorFort Belvoir, VA35,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 032,868$ - 0$ - 0
Helpdesk / Access ManagerMidFort Belvoir, VA23,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
Data Steward / Policy ManagerSeniorFort Belvoir, VA47,648$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 043,824$ - 0$ - 0
Messaging ManagerSeniorFort Belvoir, VA23,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
Messaging ManagerMidFort Belvoir, VA23,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
Program ManagerSeniorFort Belvoir, VA0.5956$ - 0$ - 00.5956$ - 0$ - 00.5956$ - 0$ - 00.5956$ - 0$ - 00.5956$ - 0$ - 00.5478$ - 0$ - 0
.NET / C# DeveloperSeniorFort Belvoir, VA35,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 032,868$ - 0$ - 0
SQL Database AdministratorSeniorFort Belvoir, VA23,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
Microsoft System AdministratorSeniorFort Belvoir, VA23,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
Microsoft System AdministratorJuniorFort Belvoir, VA23,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
Software Engineer / Quality Assurance AnalystSeniorFort Belvoir, VA11,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
Business Analyst / Requirements EngineerSeniorFort Belvoir, VA23,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
ScrumMasterSeniorFort Belvoir, VA11,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
Sharepoint DeveloperSeniorFort Belvoir, VA11,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0

Total Labor 46.50 88,908 $ - 0 46.50 88,908 $ - 0 46.50 88,908 $ - 0 46.50 88,908 $ - 0 46.50 88,908 $ - 0 46.50 44,454 $ - 0

Other Direct Costs (ODCs)ERROR:#REF!
Total Proposed Labor46.5088908$ - 046.5088908$ - 046.5088908$ - 046.5088908$ - 046.5088908$ - 0$ - 0

ODCs

CUI
ODCs Travel- Government ProvidedODCs Material- Government Provided
PeriodPlug NumberPeriodPlug Number
Base Period$ 100,000.00Base Period$ 35,000.00
Option Period 1$ 100,000.00Option Period 1$ 35,000.00
Option Period 2$ 100,000.00Option Period 2$ 35,000.00
Option Period 3$ 100,000.00Option Period 3$ 35,000.00
Option Period 4$ 100,000.00Option Period 4$ 35,000.00
FAR 52.217-8$ 50,000.00FAR 52.217-8$ 17,500.00
ODC (Travel & Material) Burden RateODC ( Material) Burden Rate
PeriodRatePeriodRate
Base PeriodBase Period
Option Period 1Option Period 1
Option Period 2Option Period 2
Option Period 3Option Period 3
Option Period 4Option Period 4
FAR 52.217-8FAR 52.217-8
ODC (Travel & Material) with BurdensODC (Material) with Burdens
PeriodEvaluated ODCsPeriodEvaluated ODCs
Base Period$ 100,000.00Base Period$ 35,000.00
Option Period 1$ 100,000.00Option Period 1$ 35,000.00
Option Period 2$ 100,000.00Option Period 2$ 35,000.00
Option Period 3$ 100,000.00Option Period 3$ 35,000.00
Option Period 4$ 100,000.00Option Period 4$ 35,000.00
FAR 52.217-8$ 50,000.00FAR 52.217-8$ 17,500.00

Contract Rates

CUI
Contract Rates (FBLRs)

Labor Categories Level Location Base Year Option Year 1 Option Year 2 Option Year 3 Option Year 4 FAR 52.217-8

Dissemination Specialist (Team Lead)SeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Dissemination SpecialistSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Dissemination SpecialistMidFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Content Site ManagerSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Business AdministratorSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Intelligence Management SpecialistSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mission Trainer (Team Lead)SeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mission TrainerSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mission TrainerSeniorFort Huachuca, AZ$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mission TrainerSeniorFort Bragg, NC$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Intelligence Solutions Integrator (Team Lead)SeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Intelligence Solutions IntegratorSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Intelligence Sharing SpecialistMidFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Intelligence Solutions IntegratorSeniorJoint Base Lewis-McChord (JBLM), WA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Data Integration (Team Lead)SeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Helpdesk / Access ManagerSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Helpdesk / Access ManagerMidFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Data Steward / Policy ManagerSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Messaging ManagerSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Messaging ManagerMidFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Program ManagerSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
.NET / C# DeveloperSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
SQL Database AdministratorSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Microsoft System AdministratorSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Microsoft System AdministratorJuniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Software Engineer / Quality Assurance AnalystSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Business Analyst / Requirements EngineerSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ScrumMasterSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sharepoint DeveloperSeniorFort Belvoir, VA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Hours

CUI
Hours
PerformanceProposed Hours
Base Year88,908
Option Year 188,908
Option Year 288,908
Option Year 388,908
Option Year 488,908
Sub-Total Hours444,540
FAR 52.217-844,454
Total Hours488,994

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