University of Wisconsin Extended Campus is now Wisconsin Online Collaboratives! This name reflects the partnerships of the 13 universities within the Universities of Wisconsin–our state's premier system of public higher education. Through these partnerships we will continue to support online degrees, certificates and courses–along with support services to you.

Capstone Projects

Time-series Forecasting of Material Usage in Warehouse

Program: Data Science Master's
Location: Juno Beach, Florida (onsite)
Student: Aditya Praveen Kumar Nanduri

This study analyzed time-series forecasting methods on material usage to predict future material usage at the warehouse level. An accurate forecast of material usage will help the material management and Procurement team to plan their procurement better and cost-effectively. These forecasting methods were evaluated with data collected from ERP backend tables. Various statistical analysis has been performed and machine learning algorithms have been applied. Some of the machine learning algorithms include average, exponential smoothing, autoregressive integrated moving average (ARIMA), Facebook inhouse python package – fbprophet, Seasonal Auto-Regressive Integrated Moving Average (SARIMA). To forecast accurately, different models are applied based on the frequency of material usage.