Unfortunately, the calculation of the correct level of safety stock should be conditioned upon more than just lead time and average demand -- which are the limits of the standard approach to safety stock calculations. For example, what if the item is seasonal? What if the item has experienced unusual demand in the "average demand" calculation period? What if the item is subject to forecasts? The the accuracy of prior forecasts should be considered, as well. Yet another consideration is demand trends. Are sales at the facility increasing overall? Is the sales product line or purchase product line increasing or decreasing at a rate different than the overall trend at the facility.
Safety stock is specifically to cover variation in order to achieve specific levels of customer service; therefore, two goals should be held in mind and included in the calculation simultaneously: 1) achieving a specified level of customer service on the item and 2) minimizing inventory on-hand.
Good solutions for safety stock calculations should include replenishment factors that are dynamically maintained including:
1) Average lead time
2) Average daily demand based on working days (not calendar days or months)
3) Order cycle (for purchase product line)
4) Demand adjustments (for unusually high or low actual demand in "average demand" calculation look-back period)
5) Desired customer service level for item (SKU)
6) Trends
Few software solutions accomplish this task successfully.
Safety Stock Calcuations
Search
Categories
- 1099 (1)
- accounting (2)
- Accounts Payable (1)
- ADMS (1)
- AP (1)
- automated document management (1)
- BI (1)
- big-box (1)
- Budget (1)
- Budgeting (1)
- business (1)
- Business forms automation (2)
- Business Insights Analyzer (1)
- Business Insights Explorer (1)
- business intelligence (1)
- Calendar (1)
- Configuration (1)
- Cost (1)
- cost of carrying (2)
- customer service level (1)
- data views (1)
- Demand Deviation (2)
- Distribution (2)
- EDI (1)
- environment (1)
- EOQ (1)
- Expenses (1)
- Fiscal Period (1)
- Formula (1)
- FRx (1)
- General Ledger (1)
- gross margin (1)
- IM (6)
- Inventory Management (8)
- Inventory Period (2)
- Inventory Replenishment (6)
- Invoice (1)
- IR (2)
- ItemID (1)
- Items (2)
- lead time (1)
- Manufacturing (5)
- MAS 500 (8)
- MAS500 (8)
- Material Requirements Planning (1)
- MICR printing (1)
- Microsoft (1)
- Min/Max (1)
- MRP (1)
- NIREP (1)
- order cycle (1)
- paperless office (1)
- Part Numbers (1)
- Positive Pay (1)
- Purchase Orders (1)
- Purchasing (2)
- Quotes (1)
- RFID (1)
- Safety Stock (2)
- Sales Orders (1)
- savings (1)
- Security (1)
- Setup (1)
- SQL Server (2)
- Statements (1)
- T-SQL (1)
- Unit of Measure (1)
- UOM (1)
- Vulnerability (1)
- Warning (1)
- Year-End Processing (1)
0 Comments Received
Post a Comment