Attachment J.1 Cost Proposal Template.xlsx

This is a Cost Proposal Template in Excel format for a Time and Materials (T&M) task order under NHTSA RFP 693JJ919R000090 titled "Low Cost Pedestrian Safety Zones Demonstrations."

The template provides pricing structures across three performance periods: a 12-month Base Period (Year 1), Option Period 1 (Year 2), and Option Period 2 (Year 3). The Base Period requires 12,240 total labor hours across seven labor categories: Senior Project Manager (KEY) at 1,000 hours, Senior Software Engineer at 1,880 hours, Software Engineer at 1,880 hours, Solutions Architect at 900 hours, Senior Data Architect at 1,880 hours, Senior Business Analyst at 1,880 hours, and Quality Assurance Specialist at 2,820 hours. Option Year 2 reduces labor to 7,230 hours, and Option Year 3 further reduces to 5,290 hours. The template accommodates fixed loaded hourly rates for each labor category, with separate line items for travel and Other Direct Costs (ODCs) with associated indirect rate calculations. Offerors are permitted to add task columns as necessary to incorporate all required tasks. The template is structured to calculate total labor costs, ODC costs, indirect costs applied only to ODCs, and cumulative task order term costs with a Not-To-Exceed (NTE) amount for each performance period.