W911SA26RA006 TE-2 Coefficient Spreadsheet.xlsx

This is a coefficient spreadsheet (TE-2) for the Motor City Job Ordering Contract (W911SA26RA006), establishing pricing adjustment factors for construction services across multiple Army Reserve Component (USARC) facilities in Michigan. The spreadsheet covers 13 locations with a combined total of 534,151 square feet across 30 buildings, including named facilities such as Donald C. Schorling USARC in Ann Arbor, James J O'Rourke USARC/BMA in Bay City, and BG William H. Birbari USARC in Fraser. The contract utilizes a coefficient-based pricing structure with separate coefficients for pre-priced work in two tiers ($0.00–$6 Million and >$6 Million–$15 Million) and a non-pre-priced indirect cost and profit rate, all currently showing zero values in the spreadsheet template. Work will be performed during normal working hours at quantities specified in individual task orders, with pricing calculated by multiplying the unit price book (UPB) by the applicable coefficient factor. The overall evaluated price structure includes provisions for pre-priced coefficients in both contract value ranges, an average non-pre-priced indirect cost/profit rate, and an offeror's total evaluated price multiplier of 1.00.