Laboratory Reagent Inventory Optimization Model

Develop an advanced Excel model using Power Query and dynamic arrays to create a real-time scientific reagent management system. The solution must track inventory levels, predict consumption rates, generate automated purchase orders, and calculate cost-per-experiment metrics. Include predictive algorithms that factor in historical usage, shelf life, and vendor pricing variations. Implement conditional formatting to highlight critical inventory thresholds and create an interactive dashboard for lab managers.