Attachment 04 - Pricing Schedule.xlsx
XLSX spreadsheet 16 KB Posted
- Solicitation number
- W912J327Q1001
- Issued by
-
Department of the Army National Guard
About this file
This is a Pricing Schedule template for the New Mexico Army National Guard (NMARNG) Dining Facility (DFAC) Food Services contract solicitation W912J327Q1001. The pricing schedule is structured as a protected Excel worksheet where quoters enter pricing data only in yellow-highlighted cells, with all calculations automated to ensure standardized evaluation. The contract covers a three-year period of performance from February 1, 2027, through January 31, 2030, consisting of a base year plus two one-year option years.
Quoters must provide pricing for six Contract Line Items (CLINs): management, administration, and fixed overhead for the base year (CLIN 0001) and each option year (CLINs 1001 and 2001), billed monthly at a flat rate; and operational culinary services for the base year (CLIN 0002) and each option year (CLINs 1002 and 2002), billed per cycle based on operational days completed. The operational services CLINs break down into three daily rate categories: Active Cooking & Meal Serving Days (196 estimated days), Pre-Course Preparation Days (16 estimated days), and Post-Course Replenishment Days (16 estimated days) for each contract year. Quoters must also complete administrative fields including company name, address, UID/UEI number, and CAGE code. The worksheet automatically calculates subtotals, extended prices, and a Total Evaluated Price (TEP) that combines all base year and option year costs for official price evaluation purposes. All completed pricing schedules must be submitted in original .xlsx format.
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 Step-by-Step Completion Guide:
| 1. Step 1: Enter Company Information |
| Complete the administrative fields in rows 4 through 7 (Company Name, Company Address, UID/UEI Number, and CAGE Code) |
| 2. Step 2: Enter Management & Overhead Rates (CLINs 0001, 1001, 2001) |
| Locate CLIN 0001 (Row 13), CLIN 1001 (Row 15), and CLIN 2001 (Row 17) in the Master Contract CLIN Summary table |
| In Column E (Unit Price), enter your quoted flat monthly/periodic rate for management, contract administration, and fixed overhead |
| The sheet will automatically calculate the extended total in Column F |
| 3. Step 3: Enter Operational Daily Rates (CLINs 0002, 1002, 2002 Breakdowns) |
| Scroll down to the Operational Breakdown (Established Daily Rates) table (Row 21) |
| For the Base Year (Rows 23–25), enter your Quoted Daily Rate ($) in Column E for: |
| 0002AA (Active Cooking & Meal Serving Days) |
| 0002AB (Pre-Course Preparation Days) |
| 0002AC (Post-Course Replenishment Days) |
| Repeat this process for Option Year 1 (Rows 28–30) and Option Year 2 (Rows 33–35) |
| The subtotals will automatically calculate in Column F and roll up into Master CLINs 0002, 1002, and 2002 |
| 4. Step 4: Verify the Total Evaluated Price (TEP) |
| Verify that the Total Evaluated Price (TEP) in Row 18 has calculated correctly. This is the mathematically summed total of the Base Year and both Option Years and will be the official figure used for price evaluations |
Save and submit the completed spreadsheet in its original .xlsx format with your quotation.
Pricing Schedule
| Attachment 4: Pricing Schedule - RTI DFAC Services | |
| Solicitation: W912J327Q1001 | |
| Period of Performance: 01 February 2027 to 31 January 2030 (Base Year + 2 Option Years) | |
| Company Name | |
| Company Address | |
| UID Number | |
| Cage Code | |
| Instructions | To ensure a fair, standardized, and mathematically accurate evaluation of all submitted quote, the Government has protected the structure and formulas of on this spreadsheet. Quoters are strictly prohibited from attempting to bypass, alter, or unlock the worksheet structure, as doing so may result in quote rejection. |
Offerors shall complete the worksheet by entering pricing data ONLY in the yellow-highlighted cells. All totals, subtotals, and the Total Evaluated Price (TEP) will calculate automatically. Instructions can be found on the instructions tab
| MASTER CONTRACT CLIN SUMMARY (Quantity: 1, Unit: Operating Unit [OU]) | ||||||
| CLIN | Description | Quantity | Unit of Measure | Unit Price ($) | Total FFP Amount ($) | Invoicing & Billing Instructions |
| 0001 | Base Year: Management, Administration, & Fixed Overhead | 1 | OU | $0.00 | Billed monthly (1/12th per month) | |
| 0002 | Base Year: DFAC Operational Culinary Services | 1 | OU | $0.00 | $0.00 | Billed per cycle based on operational days completed per month |
| 1001 | Option Year 1: Management, Administration, & Fixed Overhead | 1 | OU | $0.00 | Billed monthly (1/12th per month) | |
| 1002 | Option Year 1: DFAC Operational Culinary Services | 1 | OU | $0.00 | $0.00 | Billed per cycle based on operational days completed per month |
| 2001 | Option Year 2: Management, Administration, & Fixed Overhead | 1 | OU | $0.00 | Billed monthly (1/12th per month) | |
| 2002 | Option Year 2: DFAC Operational Culinary Services | 1 | OU | $0.00 | $0.00 | Billed per cycle based on operational days completed per month |
| TOTAL EVALUATED PRICE (Base Year + Both Option Years) | $0.00 | |||||
| CLIN 0002 / 1002 / 2002 OPERATIONAL BREAKDOWN (ESTABLISHED DAILY RATES) | ||||||
| Sub-Item | Service Category Description | Est. Days | Unit of Measure | Proposed Daily Rate ($) | Total Extended Price ($) | Notes |
| 0002AA | Active Cooking & Meal Serving Days (D/In) | 196 | Days (DY) | $0.00 | Governs future quantity additions/reductions | |
| 0002AB | Pre-Course Preparation Days (Prep) | 16 | Days (DY) | $0.00 | Governs pre-cycle setup days | |
| 0002AC | Post-Course Replenishment Days (Replenish) | 16 | Days (DY) | $0.00 | Governs post-cycle cleanup/inventory days | |
| 0002-SUB | CLIN 0002 Total (Carries to Master CLIN 0002) | 228 | OU | $0.00 | Rolls up to Master CLIN 0002 above |
| 1002AA | Active Cooking & Meal Serving Days (D/In) | 196 | Days (DY) | $0.00 | Governs future quantity additions/reductions |
| 1002AB | Pre-Course Preparation Days (Prep) | 16 | Days (DY) | $0.00 | Governs pre-cycle setup days |
| 1002AC | Post-Course Replenishment Days (Replenish) | 16 | Days (DY) | $0.00 | Governs post-cycle cleanup/inventory days |
| 1002-SUB | CLIN 1002 Total (Carries to Master CLIN 1002) | 228 | OU | $0.00 | Rolls up to Master CLIN 1002 above |
| 2002AA | Active Cooking & Meal Serving Days (D/In) | 196 | Days (DY) | $0.00 | Governs future quantity additions/reductions |
| 2002AB | Pre-Course Preparation Days (Prep) | 16 | Days (DY) | $0.00 | Governs pre-cycle setup days |
| 2002AC | Post-Course Replenishment Days (Replenish) | 16 | Days (DY) | $0.00 | Governs post-cycle cleanup/inventory days |
| 2002-SUB | CLIN 2002 Total (Carries to Master CLIN 2002) | 228 | OU | $0.00 | Rolls up to Master CLIN 2002 above |
File details come from the government source that posted it. Updated .