Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LearnQuest

Capstone Project: Predicting Safety Stock

LearnQuest via Coursera

Overview

In this course, we'll make predictions on product usage and calculate optimal safety stock storage. We'll start with a time series of shoe sales across multiple stores on three different continents. To begin, we'll look for unique insights and other interesting things we can find in the data by performing groupings and comparing products within each store. Then, we'll use a seasonal autoregressive integrated moving average (SARIMA) model to make predictions on future sales. In addition to making predictions, we'll analyze the provided statistics (such as p-score) to judge the viability of using the SARIMA model to make predictions. Then, we'll tune the hyper-parameters of the model to garner better results and higher statistical significance. Finally, we'll make predictions on safety stock by looking to the data for monthly usage predictions and calculating safety stock from the formula involving lead times.

Syllabus

  • Exploratory Data Analysis Using Pandas and Groupby
    • In this module, we'll get acquainted with our dataset by exploring some of the most obvious groupings and identifying the variation in products. We'll discover which products sell where and prepare ourselves to use timeseries forecasts and safety stock predictions.
  • Demand Predictions Using SARIMA
    • In this module, we'll use the SARIMA model to make predictions on future sales. We'll then visualize some of these predicted sales before evaluating the accuracy and viability of our chosen model.
  • Calculating Safety Stock
    • In this module, we'll finish the project by calculating safety stock from monthly usage and lead times. We'll start by grouping products in order to find more accurate usage numbers. Then, we'll conclude by using the known formula along with our insights from the data in the calculation of safety stock for each product.

Taught by

Rajvir Dua and Neelesh Tiruviluamala

Reviews

Start your review of Capstone Project: Predicting Safety Stock

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.