Medical Supply Chain Inventory Optimization Model

Design a sophisticated Excel financial model that predicts medical supply inventory requirements using predictive analytics and dynamic forecasting. Implement Monte Carlo simulation techniques to model potential supply chain disruptions, integrate real-time pricing data, and create conditional formatting that automatically flags potential stockout risks or overordering scenarios. Include a dynamic dashboard that shows probabilistic inventory projections with confidence intervals.