B08_SOL_Attachment_5_Coefficient__Spreadsheet.xlsx

This is a Coefficient Spreadsheet template for proposers to submit pricing for an Indefinite Delivery Indefinite Quantity (IDIQ) Job Order Contract (JOC) for electrical services with the National Park Service. The spreadsheet is organized into three geographic groups of parks within the National Capital Region, with Group 1 containing six parks in the DC area totaling 1,720 properties, Group 2 containing three parks in Virginia totaling 622 properties, and Group 3 containing five parks across Maryland, West Virginia, and Virginia totaling 866 properties.

Offerors must complete two pricing metrics for each of five ordering periods plus one six-month option period: Pre-Priced Coefficients (NET) and Non-Pre-Priced Indirect Cost and Profit Rates (NET). Pre-Priced Coefficients are multipliers applied to Unit Price Book line items and include allowable overhead, profit, supervision, and general conditions. Non-Pre-Priced rates are markups applied to non-Unit Price Book materials, equipment, or subcontracted costs. All coefficients must be entered in decimal format with no more than two decimal places, with entries required for all parks and ordering periods with no blank fields permitted unless specifically authorized. By submitting the spreadsheet, offerors certify that all entries are accurate, compliant, and complete. The spreadsheet automatically calculates totals, averages, and the offeror's total evaluated price coefficient across all parks and ordering periods.