Attachment 04 - Pricing Schedule.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
New Mexico Army National Guard (NMARNG) Dining Facility (DFAC) Food Services
Solicitation number
W912J327Q1001
Issued by

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
InstructionsTo 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])
CLINDescriptionQuantityUnit of MeasureUnit Price ($)Total FFP Amount ($)Invoicing & Billing Instructions
0001Base Year: Management, Administration, & Fixed Overhead1OU$0.00Billed monthly (1/12th per month)
0002Base Year: DFAC Operational Culinary Services1OU$0.00$0.00Billed per cycle based on operational days completed per month
1001Option Year 1: Management, Administration, & Fixed Overhead1OU$0.00Billed monthly (1/12th per month)
1002Option Year 1: DFAC Operational Culinary Services1OU$0.00$0.00Billed per cycle based on operational days completed per month
2001Option Year 2: Management, Administration, & Fixed Overhead1OU$0.00Billed monthly (1/12th per month)
2002Option Year 2: DFAC Operational Culinary Services1OU$0.00$0.00Billed 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-ItemService Category DescriptionEst. DaysUnit of MeasureProposed Daily Rate ($)Total Extended Price ($)Notes
0002AAActive Cooking & Meal Serving Days (D/In)196Days (DY)$0.00Governs future quantity additions/reductions
0002ABPre-Course Preparation Days (Prep)16Days (DY)$0.00Governs pre-cycle setup days
0002ACPost-Course Replenishment Days (Replenish)16Days (DY)$0.00Governs post-cycle cleanup/inventory days
0002-SUBCLIN 0002 Total (Carries to Master CLIN 0002)228OU$0.00Rolls up to Master CLIN 0002 above
1002AAActive Cooking & Meal Serving Days (D/In)196Days (DY)$0.00Governs future quantity additions/reductions
1002ABPre-Course Preparation Days (Prep)16Days (DY)$0.00Governs pre-cycle setup days
1002ACPost-Course Replenishment Days (Replenish)16Days (DY)$0.00Governs post-cycle cleanup/inventory days
1002-SUBCLIN 1002 Total (Carries to Master CLIN 1002)228OU$0.00Rolls up to Master CLIN 1002 above
2002AAActive Cooking & Meal Serving Days (D/In)196Days (DY)$0.00Governs future quantity additions/reductions
2002ABPre-Course Preparation Days (Prep)16Days (DY)$0.00Governs pre-cycle setup days
2002ACPost-Course Replenishment Days (Replenish)16Days (DY)$0.00Governs post-cycle cleanup/inventory days
2002-SUBCLIN 2002 Total (Carries to Master CLIN 2002)228OU$0.00Rolls up to Master CLIN 2002 above

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