Problem Statement

Identify products that need restocking analysis. Calculate: days of inventory remaining (stock/avg daily sales), revenue impact, warehouse location, and restock rank. Use order history for sales calculation and rank products by stock level and sales volume.

Relevant Tables