Inventory Planning using Microsoft Power BI

Inventory Planning using Microsoft Power BI

(Operations Planning, Inventory Planning, Sales & Operations Planning (S&OP))

A model which is completely retrospective to manage inventory flow with the help of controls like:

• Inventory Turn-Over Ratio to identify stock sold and replenished in a given period
• Inventory Carrying Cost
• Days / Weeks of on-hand inventory to analyze the average time it takes to sell the inventory
• Calculate and derive the ‘Sell-Through’ Rate which is the % of Units Sold
• Perform ‘What if’ analysis to observe the position of inventory