Attachment 0001 - Government Format Pricing Model.xlsx

XLSX spreadsheet 48 KB Posted

Attached to
Intelligence and Automation Operations
Solicitation number
W50NH9-26-R-A002r1
Issued by

About this file

This is a Government Format Pricing Model (GFPM) template for a federal contract opportunity (W50NH9-025-R-0032) related to Intelligence and Automation Operations support services. The pricing model is structured as a Firm Fixed Price (FFP) with Level of Effort (LOE) and Cost Reimbursable line items for Other Direct Costs (ODCs). Offerors must complete all yellow-highlighted cells in the spreadsheet, including proposed Fully Burdened Labor Rates (FBLRs) for each contract period and ODC burden rates for travel and materials. The template specifies 28 distinct labor categories across multiple seniority levels (Senior, Mid, Junior) and locations (primarily Fort Belvoir, VA, with positions also at Fort Huachuca AZ, Fort Hood TX, and Joint Base Lewis-McChord WA), with a total of 44.75 Full-Time Equivalents (FTEs) and 85,562 hours per year during the base year and each of four option periods, plus a reduced 42,781 hours under FAR 52.217-8 ordering period. The model includes government-provided plug numbers for ODCs: $100,000 annually for travel and $35,000 annually for materials across all periods, with reduced amounts ($50,000 travel, $17,500 materials) for the FAR 52.217-8 ordering period, resulting in a total evaluated price of $742,500 for the base year plus option periods combined.

The pricing model requires offerors to propose ODC/Travel burden rates that will establish the maximum billing rates for those cost categories, with no profit or fee allowable on government-provided ODC amounts. All extended prices, subtotals, and totals auto-populate once FBLRs are entered, and offerors must follow the instructions completely or risk proposal rejection. The contract performance periods run annually from May 24 of each year through May 23 of the following year, starting with a base year (May 24, 2026 – May 23, 2027) followed by four one-year option periods. Supporting worksheets within the template automatically calculate contract rates and hours summaries from the period of performance data and require no offeror input.

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

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.
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-025-R-0032 - 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-025-R-0032 - Attachment 0001 - Government Format Pricing Model
Offeror Name:
Period of PerformanceBASE YEAR - 24 May 2026 - 23 May 2027Option Period 1 - 24 May 2027 - 23 May 2028Option Period 2 - 24 May 2028 - 23 May 2029Option Period 3 - 24 May 2029 - 23 May 2030Option Period 4 - 24 May 2030 - 23 May 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 Hood, TX0.25478$ - 0$ - 00.25478$ - 0$ - 00.25478$ - 0$ - 00.25478$ - 0$ - 00.25478$ - 0$ - 00.25239$ - 0$ - 0
Intelligence Solutions Integrator (Team Lead)SeniorFort Belvoir, VA11912$ - 0$ - 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, VA23,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 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 44.75 85,562 $ - 0 44.75 85,562 $ - 0 44.75 85,562 $ - 0 44.75 85,562 $ - 0 44.75 85,562 $ - 0 44.75 42,781 $ - 0

Other Direct Costs (ODCs)ERROR:#REF!
Total Proposed Labor44.7585562$ - 044.7585562$ - 044.7585562$ - 044.7585562$ - 044.7585562$ - 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 Hood, TX$ - 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 Year85,562
Option Year 185,562
Option Year 285,562
Option Year 385,562
Option Year 485,562
Sub-Total Hours427,810
FAR 52.217-842,781
Total Hours470,591

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