Medical Supply Chain Demand Forecasting Model

Develop an advanced demand forecasting model for medical supplies using machine learning in Google Sheets. Create a script that analyzes historical consumption data, seasonal variations, and external factors to predict precise medical supply requirements. Implement time-series forecasting algorithms, generate probabilistic supply chain recommendations, and provide real-time inventory optimization strategies.