Compare each fixed-price line item with its cost estimate or commercial pricing basis before submission. FAR 15.404-1(g) says unbalanced pricing may increase performance risk and cause unreasonably high payments. Use the review sheet to find spreadsheet errors and explain intentional differences, not to impose a uniform markup or invent a legal pricing test.

Separating Spreadsheet Formula Drift from Intentional Pricing Strategy

Multi-CLIN pricing workbooks often go through rapid adjustments during the final days of proposal preparation. When a pricing team updates vendor quotes, revises labor mappings, or adjusts commercial discount tiers during a Section L and Section M pricing review, hardcoded cell overrides or broken links can unintentionally shift costs from one line item into another.

A practical pre-submittal pricing check separates two distinct situations:

  1. Unintended workbook mapping errors: Full-year software licenses pasted into a 30-day transition line item, broken escalation formulas across option periods, or top-down price edits applied to only one tab of the schedule.
  2. Intentional commercial or operational pricing choices: Deliberate line-item pricing grounded in commercial catalog structures, upfront vendor tooling or onboarding charges, volume discount tiers, or phase-specific staffing plans. Rather than forcing every CLIN into a mechanical markup ratio, the purpose of an internal review is to correct accidental spreadsheet drift and explain legitimate commercial or operational price differences clearly in the proposal narrative.

Recommended Pre-Submittal CLIN Price Review Worksheet

Use the worksheet below during your internal price review to compare each CLIN's proposed price against its underlying estimate or commercial pricing basis. A flag on this worksheet is an internal prompt to check your workbook formulas or add context to your pricing narrative, not a government rejection threshold or a legal test.

1. CLIN Scope-to-Estimate Mapping

  • Compare: Solicitation CLIN description vs. the internal basis of estimate, bill of materials, or commercial price list mapped to that CLIN.
  • Ask: Does the cost or commercial price input assigned to each CLIN match the actual deliverables and period of performance for that line item?
  • Next action: Pricing Lead: Correct any misallocated labor hours, material quotes, or license periods that were mapped to the wrong CLIN tab.

2. Startup & Transition Line Items

  • Compare: Proposed price for any separate transition, onboarding, or setup CLIN vs. documented transition tasks and vendor quotes.
  • Ask: Are ongoing operational costs sitting inside the startup CLIN, or are genuine one-time setup charges left unexplained?
  • Next action: Pricing & Capture Leads: Check the actual CLIN scope, vendor license terms and documented pricing basis before deciding whether to change an allocation or explain it. A recurring expense does not by itself dictate a transfer.

3. Period-Over-Period Unit Price Trend

  • Compare: Proposed unit prices across base and option periods vs. planned wage adjustments, vendor quotes, or lifecycle changes.
  • Ask: If unit prices rise or fall sharply between periods, is the change driven by a broken cell link or by a real operational change?
  • Next action: Pricing Lead: Fix unintended formula breaks, or write a clear note in the pricing narrative explaining the scheduled operational change.

4. Estimated-Quantity Schedule Sensitivity

  • Compare: Proposed unit prices across estimated-quantity CLINs or ordering tiers vs. unit delivery costs and commercial catalog tiers.
  • Ask: How would contract performance and revenue look if actual orders concentrated heavily on a single CLIN or quantity band?
  • Next action: Capture & Contracts Leads: Review whether individual unit prices remain commercially workable across realistic ordering mixes.

5. Basis-of-Estimate Narrative Alignment

  • Compare: Final pricing schedule numbers vs. the written assumptions and explanations in the pricing volume narrative.
  • Ask: Would a reviewer reading the schedule alone understand why specific CLINs differ in unit price or margin?
  • Next action: Proposal Lead: Add a concise explanation of vendor quotes, commercial catalog tiers, or nonrecurring tasks for any CLIN that looks unusual on its face.

Illustrative Workbook Error Log Entry (Labeled Example)

The following hypothetical model assumes that the actual CLIN scope and vendor license terms support time-based allocation across the two periods, and that the documented pricing basis treats the original entry as a paste error. Those assumptions make the following allocation useful for this example, not a universal pricing instruction:

  • Illustrative Schedule Scope:
    • CLIN 0001: 30-Day System Onboarding and Data Migration (1 Lot)
    • CLIN 0002: Managed Platform Operations, Months 2 through 12 (11 Months)
  • Initial Unreviewed Workbook Draft:
    • CLIN 0001 (30-Day Onboarding): Draft price = $112,000. Inspection of the backing tab shows $24,000 in migration labor, a $22,000 one-time vendor data-import fee, and $66,000 for 12 months of annual platform subscription licenses accidentally pasted into the onboarding column.
    • CLIN 0002 (11 Months Operations): Draft price = $330,000 ($30,000/month), omitting the platform subscription licenses used during those 11 operating months.
  • Illustrative Action Under Those Assumptions: The pricing lead moves the 11 operating months of platform subscription cost ($60,500) out of CLIN 0001 and into CLIN 0002 where those licenses are consumed, leaves the 1-month onboarding license share ($5,500) and the documented $22,000 one-time vendor data-import quote in CLIN 0001, and attaches the vendor quote summary to the pricing narrative so the reviewer can see why CLIN 0001 includes the one-time data-import charge.

Documenting Line-Item Pricing Rationale in the Proposal Volume

When legitimate technical, commercial, or operational factors cause different line-item prices, document the basis in the manner the actual solicitation permits. Reallocation is one possible response to a verified error, not a legal cure for every pricing difference. As part of a disciplined capture workflow, which you can explore in our RFP alert to pursuit worked example, pairing your fixed-price schedule with a brief basis-of-estimate summary of vendor quotes, commercial catalog terms, or phase-specific work scopes helps the contracting officer understand the factual basis behind each line item.

To find federal solicitations early enough to build and review clean multi-CLIN pricing schedules, search live opportunities on FedFinder and review subscription options on the FedFinder pricing page.

Sources

  • Federal Acquisition Regulation (FAR) 15.404-1, Proposal analysis techniques: https://www.acquisition.gov/far/15.404-1 (Retrieved 2026-11-06; Acquisition.gov baseline FAC 2026-01 effective 2026-03-13; actual agency and contract applicability must be checked against the solicitation).