Interview Query

Out of Stock Inventory

Have you seen this question before?

You are given a table regarding out of stock inventory with the following parameters:

  • Date
  • Country
  • Company
  • Product
  • Out of stock or not (boolean)

Let’s say we want to calculate these metrics for each company:

  1. Completely free of stock-outs
  2. Had a stock-out in only one of the countries
  3. Had stock-outs in multiple countries simultaneously

What business-relevant hypotheses can you think of that might make sense to check based on the calculated parameters and observed results?

Next question: Programming Risk Combat
Loading comments