CLIN Structure for AMWS Q2 Price Quote.xlsx

This is a pricing template spreadsheet for food service support at the Vermont Regional Training Institute, structured with 27 Contract Line Item Numbers (CLINs) spanning January-March 2025. The spreadsheet breaks down meal requirements across three months, with each month requiring similar quantities: approximately 608 regular breakfasts, 48 AT breakfasts, 56 bag breakfasts, 48 regular lunches, 16 AT lunches, 192 bag lunches, 72 IDT bag lunches, 664 dinners, and 48 AT dinners per month.

The template is designed to capture unit pricing for each meal type, with columns for quantity, unit price, and total price calculations. The performance periods are broken into three segments: January 11-24, 2025 (CLINs 0001-0009), February 1-14, 2025 (CLINs 0010-0018), and March 8-21, 2025 (CLINs 0019-0027). The spreadsheet includes automated totaling functions for each month's services and an overall contract price calculation field.