Attachment 7 - Historical Data_Amend 01.xlsx

This file is Amendment 01 to Attachment 7, providing historical shipment and regional distribution data for the Navy Advanced Traceability and Control (ATAC V) contract. The document contains detailed transaction-level shipment records and aggregated monthly and regional analyses spanning January 2022 through April 2026.

The historical data is organized in three primary sections: (1) monthly shipment volumes broken down by weight categories (1-150 lbs, 151-499 lbs, 500-1999 lbs, and 2000+ lbs); (2) regional distribution matrices showing shipment flows between nine domestic regions plus Canada across multiple calendar years; and (3) granular line-item transaction records from 2022 that identify specific origin cities, destination cities, quantities, and regional assignments for each shipment. Key patterns show consistent high-volume movements between Region 2 (Norfolk, VA area) and Region 4 (Jacksonville, FL and Southeast locations), as well as Region 8 (San Diego, CA and West Coast locations), with total shipment counts ranging from approximately 22,000 to 31,000 annually. The data supports forecasting and capacity planning for a transportation contract covering movement of Depot Level Repairables across the continental United States, Hawaii, Alaska, and Canada.