Estoque De Tinturas.xlsx Here

= TODAY() - Last Receipt Date

| Dye Code | Current | Min | Usage/Mo | Lead (days) | Order Qty | Suggested Supplier | |----------|---------|-----|----------|-------------|-----------|--------------------| | RED-001 | 12 L | 20 | 8 L | 14 | =(20-12)+(8*0.5) = 12 L | ChemCo | ESTOQUE DE TINTURAS.xlsx

=MAX(0, Min_Stock - Current_Stock) + (Monthly_Usage * 0.5) = TODAY() - Last Receipt Date | Dye