Attachment 0008_Price Worksheet.xlsx

This is a price worksheet template for Solicitation W31P4Q-26-R-0013 for Inert Warheads, Part Number 13540611, for the Reduced Range Practice Rocket M28A2. The worksheet is designed for offerors to submit pricing for a firm-fixed-price contract spanning one base year and two option years, with anticipated quantities ranging from 2,000 to 7,000 units per year. Offerors must complete sections highlighted in green, while blue-highlighted sections contain calculated fields that shall not be modified. The worksheet incorporates learning curve analysis using logarithmic functions to establish unit prices at the 2,000 and 7,000 quantity points, from which the Government will interpolate pricing for intermediate quantities during award.

Prior to awarding the base year and each option year, the Government will input the anticipated quantity in a designated cell to determine the corresponding unit price, which will then be used to calculate the extended price and update the contract. The template includes sections for the Base Year, Option Year 1, and Option Year 2, each with associated unit prices, extended prices, and total evaluated pricing calculations. This worksheet will be incorporated into the awarded contract and serves as the mechanism for determining final pricing across the contracted quantity range. The solicitation is a 100% Small Business Set-Aside restricted to U.S. small business concerns, issued by the Army Contracting Command - Redstone Arsenal.