재고 재주문 계획
현재 재고 수준과 판매 속도를 기반으로 재고를 언제 다시 주문해야 하는지 결정하는 간단한 계획을 생성합니다.
4 uses
0 likes
1. List all your products in column A, starting from A2. 2. In column B (B2 onwards), input the current inventory level for each product as [currentInventory]. 3. In column C (C2 onwards), enter the average weekly sales quantity for each product as [weeklySales]. 4. In column D (D2 onwards), calculate the weeks until restock is needed with the formula '=B2/C2' for each product. 5. Highlight column D. Use Conditional Formatting to change the cell color if the value is less than 4, indicating it's time to plan a restock.
✓ Template processed with your variables!