Interview Query

Out of Stock Inventory

Start Timer

0:00:00

Upvote
1
Downvote
Save question
Mark as completed
View comments (5)
Next question

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?

.
.
.
.
.


Comments

Loading comments