ATTACHMENT 3 - FA664326Q0004 Pricing Worksheet.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Aeromedical Case Management Support
- Solicitation number
- FA664326Q0004
About this file
This is a Pricing Worksheet template for solicitation FA664326Q0004, an Aeromedical Case Management Support Services contract issued by the Department of the Air Force Reserve Command. The worksheet is designed for offerors to submit firm-fixed-price labor rates across a 12-month Base Year and four optional one-year periods. Offerors must populate only designated yellow cells with their proposed labor categories mapped to Department of Labor Service Contract Act (SCA) wage determinations, direct labor rates that meet or exceed SCA minimums, fringe benefits covering health and welfare, vacation and holidays, overhead percentages, G&A rates, and profit/fee percentages. The fully burdened hourly rates and annual extended labor values are calculated automatically by locked formulas. All proposed Full-Time Equivalents (FTEs) must align with the Staffing Matrix submitted in the Technical Capability Volume, with any discrepancies potentially affecting evaluation of quotation realism and consistency.
The pricing worksheet extends across five contract line items (CLINs): CLIN 0001 (Base Year), CLIN 1001 through 4001 (Option Periods 1-4), with monthly pricing on a Firm-Fixed-Price basis. Phase-in costs associated with a 30-day startup must be fully amortized into Base Year rates without separate upfront payment. The worksheet calculates total proposed price for Base Year plus all options, and for evaluation purposes only, includes a six-month evaluated extension of services under FAC 52.217-8 to determine total evaluated price. Offerors are prohibited from modifying protected cells, deleting formulas, or altering worksheet structure; any such manipulation may render quotations ineligible for award. The solicitation is a 100 percent small business set-aside with quotation submissions required by August 7, 2026, at 4:00 PM EST.
View the file
Other files
Show all 11
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 (READ ME FIRST)
| FA664326Q0004 - AEROMEDICAL CASE MANAGEMENT SUPPORT SERVICES - PRICING WORKSHEET |
| Instructions to Offerors |
| 1. Yellow Cells Only: Offerors must only input data into the highlighted yellow cells. All other cells contain locked formulas. |
| 2. SCA Compliance: Offerors must map their proposed labor categories to the attached Department of Labor Wage Determination. The "Direct Labor Rate" must meet or exceed the SCA minimum wage, and the "Fringe" must account for the required Health & Welfare (H&W) rate, vacation, and holidays. |
| 3. FTE Realism: Offerors must input their anticipated number of Full-Time Equivalents (FTEs). The total proposed FTEs reflected in this workbook must match the Staffing Matrix submitted within the Technical Capability Volume. Discrepancies between the Pricing and Technical volumes may be evaluated in determining the realism and consistency of the quotation. |
| 4. Phase-In Costs: Any costs associated with the 30-day Phase-In must be amortized in the Base Year (CLIN 0001) fully burdened rates. No separate upfront payment will be made. |
| 5. Workbook Manipulation: Offerors shall not modify, delete, or overwrite protected cells, formulas, worksheet structure, or embedded calculations. Alteration of locked formulas workbook functionality may render the quotation ineligible for award. |
NOTE: If any cells appear to be broken or formulas are miscalculating, please reach out to the Contracting Officer for immediate assistance.
Labor Rate Buildup
| BASE YEAR | |||||||||||
| Proposed Labor Category | Mapped SCA Code & Title | Number of Proposed FTEs | Productive Hours/ FTEs | Direct Labor Rate (Hourly) | Fringe/H&W ($ or %) | Overhead (%) | G&A (%) | Profit/Fee (%) | Fully Burdened Hourly Rate | Annual Extended Labor Value | |
| EX | e.g., Medical Case Mgr | 12190 - Med Record Tech | 1 | 1,920 | $ 28.50 | $4.00 | 5% | 5% | 5% | $ 37.62 | $ 72,235.80 |
| $ - 0 | $ - 0 | ||||||||||
| $ - 0 | $ - 0 | ||||||||||
| $ - 0 | $ - 0 | ||||||||||
| $ - 0 | $ - 0 | ||||||||||
| TOTALS: | 0 | ERROR:#DIV/0! | $ - 0 |
| Option Period 1 | ||||||||||
| Proposed Labor Category | Mapped SCA Code & Title | Number of Proposed FTEs | Productive Hours/ FTEs | Direct Labor Rate (Hourly) | Fringe/H&W ($ or %) | Overhead (%) | G&A (%) | Profit/Fee (%) | Fully Burdened Hourly Rate | Annual Extended Labor Value |
| e.g., Medical Case Mgr | 12190 - Med Record Tech | 1 | 1,920 | $ 28.50 | $4.00 | 5% | 5% | 5% | $ 37.62 | $ 72,235.80 |
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| TOTALS: | 0 | ERROR:#DIV/0! | $ - 0 |
| Option Period 2 | ||||||||||
| Proposed Labor Category | Mapped SCA Code & Title | Number of Proposed FTEs | Productive Hours/ FTEs | Direct Labor Rate (Hourly) | Fringe/H&W ($ or %) | Overhead (%) | G&A (%) | Profit/Fee (%) | Fully Burdened Hourly Rate | Annual Extended Labor Value |
| e.g., Medical Case Mgr | 12190 - Med Record Tech | 1 | 1,920 | $ 28.50 | $4.00 | 5% | 5% | 5% | $ 37.62 | $ 72,235.80 |
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| TOTALS: | 0 | ERROR:#DIV/0! | $ - 0 |
| Option Period 3 | ||||||||||
| Proposed Labor Category | Mapped SCA Code & Title | Number of Proposed FTEs | Productive Hours/ FTEs | Direct Labor Rate (Hourly) | Fringe/H&W ($ or %) | Overhead (%) | G&A (%) | Profit/Fee (%) | Fully Burdened Hourly Rate | Annual Extended Labor Value |
| e.g., Medical Case Mgr | 12190 - Med Record Tech | 1 | 1,920 | $ 28.50 | $4.00 | 5% | 5% | 5% | $ 37.62 | $ 72,235.80 |
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| TOTALS: | 0 | ERROR:#DIV/0! | $ - 0 |
| Option Period 4 | ||||||||||
| Proposed Labor Category | Mapped SCA Code & Title | Number of Proposed FTEs | Productive Hours/ FTEs | Direct Labor Rate (Hourly) | Fringe/H&W ($ or %) | Overhead (%) | G&A (%) | Profit/Fee (%) | Fully Burdened Hourly Rate | Annual Extended Labor Value |
| e.g., Medical Case Mgr | 12190 - Med Record Tech | 1 | 1,920 | $ 28.50 | $4.00 | 5% | 5% | 5% | $ 37.62 | $ 72,235.80 |
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | |||||||||
| TOTALS: | 0 | ERROR:#DIV/0! | $ - 0 |
CLIN Summary
| CLIN | Period of Performance | Unit of Issue | QTY | Monthly FFP Rate | Total Annual FFP |
| 0001 | Base Year | Months (MO) | 12 | $ - 0 | |
| 1001 | Option Year 1 | Months (MO) | 12 | $ - 0 | |
| 2001 | Option Year 2 | Months (MO) | 12 | $ - 0 | |
| 3001 | Option Year 3 | Months (MO) | 12 | $ - 0 | |
| 4001 | Option Year 4 | Months (MO) | 12 | $ - 0 |
| TOTAL BASE + ALL OPTIONS | $ - 0 | |
| This figure represents the total proposed amount for Base + All Options, it does not reflect the potential of a RFO 52.217-8 extension of services. |
EVALUATED EXTENSION OF SERVICES (RFO 52.217-8) [FOR EVALUATION PURPOSES ONLY] $ - 0 BARKSDALE, BIANNICA Q CIV USAF AFRC HQ AFRC/PKA: BARKSDALE, BIANNICA Q CIV USAF AFRC HQ AFRC/PKA:
F7 * 6 MONTHS
| TOTAL EVALUATED PRICE (BASE, ALL OPTIONS, AND EVALUATED EXTENSION OF SERVICES | $ - 0 | |
| *NOTE* For evaluation puroses only, the Government will calculate the evaluated extension of services by multiplying the proposed monthly Firm-Fixed-Price for the final evaluated option period by six (6) months (G13). The total evaluated extension price is then added to the total proposed price (G9) for a Total Evaluated price. This calculation does not obligate the Government to exercise RFO 52.217-8 or any specific duration of an extension. |
File details come from the government source that posted it. Updated .