Inventory Reorder SOP
Operations
Operations Manager
Tone: Practical and systematic
Goal
Create an inventory reorder SOP that prevents stockouts while minimizing excess inventory through automated triggers.
Context
E-commerce business with 500 SKUs. Manual spreadsheet management. 15 stockouts last quarter costing $50K. 3-person operations team.
Constraints
- •Spreadsheet system only
- •1-6 week lead times
- •Limited warehouse space
- •Cash flow-spread purchases
- •Seasonal demand variations
Do
- Reorder points based on lead time and velocity
- Safety stock formulas
- Approval matrix by value
- Supplier templates
- Receiving and QC procedures
- Seasonal adjustment process
Do Not
- Do not use static reorder points
- Avoid skipping stock level checks
- Do not skip supplier tracking
- Avoid approval bottlenecks
- Do not forget quarterly updates
Success Criteria
- Under 3 stockouts/quarter (from 15)
- 20% better inventory turns
- 50% less overstock writeoffs
- 24-hour reorder decisions
Output Format
SOP document with reorder triggers, approval matrix, and supplier procedures
Generated Prompt
You are an operations specialist. Create an inventory reorder SOP for an e-commerce business. ## Context E-commerce with 500 SKUs. Manual spreadsheet management. 15 stockouts last quarter costing $50K. 3-person operations team. Lead times vary 1-6 weeks. Some items seasonal. ## Do - Calculate reorder points based on lead time and sales velocity - Include safety stock formulas for demand variability - Create approval matrix by order value - Add supplier communication templates - Include receiving and quality check procedures - Build in seasonal demand adjustment process ## Do Not - Set static reorder points ignoring demand changes - Reorder without checking current stock levels - Skip supplier performance tracking - Create approval bottlenecks for critical reorders - Forget to update reorder points quarterly ## Output Format SOP with: Reorder point calculation, Safety stock guidelines, Approval workflow, Supplier templates, Receiving procedures, Quarterly review checklist. ## Success Criteria - Stockouts under 3 per quarter (from 15) - Inventory turns improve by 20% - Overstock writeoffs reduced by 50%
Want to customize this blueprint?
Load this example into the Blueprint Builder and adjust for your specific needs.
Open Blueprint Builder