IN and MI Historical Trends Dispensary.xlsx

This is a historical trends analysis spreadsheet for optical dispensing services provided to Department of Veterans Affairs facilities across Indiana and Michigan. The data tracks weekly shipment volumes and estimated annual totals across 18 care sites within VISN 10, comparing FY25 performance through June 21, 2025 (39 weeks of shipped data) against FY24 baselines.

The largest volume facilities include Detroit (estimated 11,395 annual units in FY25), Grand Rapids/Wyoming (11,115 units), and Fort Wayne (4,843 units), with smaller veteran clinic locations such as Wakeman VA Clinic (776 units) and Shelbyville VA Eye Clinic (544 units) representing lower-volume distribution points. Weekly averages demonstrate consistent demand patterns, with Detroit averaging 234 weekly units in FY25 and Grand Rapids averaging 218 weekly units. The spreadsheet provides facility-level performance metrics essential for understanding regional optical dispensing service requirements and capacity planning for the IN & MI Optical Dispensing Service solicitation (36C25026R0012).