Current Inventory_KPI Step 1. Create a Pivot Table to estimate "stock in daily sales"-how many days the current inventory for each product will last according to "average sales"- The following formulas can help: AverageSales = QUANTITY_SOLD NB_STEPS AVAILABLE CURRENT INVENTORY StockInDailySales = AverageSales Add the following Alerts: Red: If the stock in daily sales is less than 2 days. Yellow: If the stock in daily sales is between 2 and 5 days. Green: If the stock in daily sales is greater than 5 days. Step 2. Create a second Pivot Table to estimate the sales forecast for each product. Use the following formula to get the 5-day sales forecast according to average sales: SalesForecast = 5* QUANTITY_SOLD NB_STEPS AVAILABLE