Open-to-Buy and Safety Stock Basics: The Cash-Preserving Formula for CPG Brands
By: Samantha Rose
TL;DR: Safety stock prevents stockouts; open-to-buy prevents cash hemorrhage. Brands that calculate both correctly maintain 95%+ service levels while turning inventory 6–8× annually. The math is straightforward: (Lead Time × Daily Demand × Service Factor) + (OTB Budget - Committed Inventory - Planned Receipts). Master these two formulas and you control the two biggest levers in commerce operations—customer satisfaction and cash flow.
Why Safety Stock and OTB Are Your Only Real Profit Levers
According to research from the Supply Chain Management Review, companies with optimized safety stock policies achieve 23% higher inventory turns while maintaining service levels above 95%. Yet most emerging CPG brands still use gut feel or spreadsheet guesswork, resulting in either chronic stockouts or trapped cash in slow inventory.
“The difference between a profitable year and a cash crisis often comes down to safety stock calculation,” notes supply chain analyst Dr. Yossi Sheffi of MIT. “Brands that systematize this decision outperform competitors by 15–20% on working capital efficiency.”
Open-to-buy (OTB) complements safety stock by creating a financial framework for purchasing decisions. Where safety stock answers how much to keep on hand, OTB answers how much to spend. Together, they form the operational boundaries that keep brands growing without overleveraging.
Safety Stock: The Service Level Protection Formula
The Core Calculation
Safety stock exists to absorb two types of variability: demand uncertainty and lead-time uncertainty. The standard formula:
Safety Stock = Z-score × √(Lead Time × Demand Variance + (Average Demand² × Lead Time Variance))
Simplified for operators:
Safety Stock = Service Level Factor × Daily Demand × √Lead Time in Days
For a 95% service level (Z-score of 1.65), selling 100 units/day with a 30-day lead time:
Safety Stock = 1.65 × 100 × √30 = 1.65 × 100 × 5.48 = 904 units
Service Level Factors (Z-scores)
- 90% service level: 1.28 (acceptable for low-margin, high-volume SKUs)
- 95% service level: 1.65 (standard for most CPG products)
- 98% service level: 2.05 (high-margin or strategic SKUs)
- 99% service level: 2.33 (hero products, promotion-critical items)
When to Adjust Safety Stock
Increase safety stock when:
- Lead time volatility is high: Supplier on-time delivery below 85%
- Demand variability spikes: CV (coefficient of variation) above 0.5
- Cost of stockout exceeds holding cost: Lost revenue + brand damage > inventory carrying cost
- Promotional activity planned: Marketing spend tied to availability
- Seasonal peak approaching: Q4 for most consumer brands
Decrease safety stock when:
- Product in decline phase: Sales trending down 3+ consecutive months
- Inventory turn target missed: Current turns below 4×/year
- Cash flow constrained: Working capital ratio below 1.5
- Supplier reliability improves: Consistent on-time delivery above 95%
Channel-Specific Safety Stock Strategy
Different sales channels require different safety stock approaches:
DTC/E-commerce:
- 7–14 days of safety stock
- Faster replenishment cycles
- Higher tolerance for backorders if messaging is proactive
- Customer willingness to wait for hero products: 67% (Baymard Institute)
Wholesale/Retail:
- 30–60 days of safety stock
- Retailer scorecards penalize stockouts severely
- Fill rate requirements typically 95–98%
- Chargebacks for missed delivery windows average 3–5% of order value
Amazon FBA:
- 45–60 days due to restock lead times
- IPI (Inventory Performance Index) penalties below 400
- Storage fees incentivize lean inventory
- Lost Buy Box from stockouts reduces sales 60–80%
Open-to-Buy: The Cash Control Framework
The OTB Formula
Open-to-buy calculates how much purchasing budget remains for a given period:
OTB = Planned Sales + Planned EOM Inventory - Current Inventory - Planned Receipts
Example:
- Planned sales (next 90 days): $500,000
- Target end-of-month inventory: $200,000
- Current inventory: $300,000
- Planned receipts (POs already committed): $150,000
OTB = $500,000 + $200,000 - $300,000 - $150,000 = $250,000
You have $250,000 in purchasing power for the period.
OTB Best Practices by Growth Stage
Startup Phase ($1M–$5M revenue):
- Calculate OTB monthly
- Maintain 4–6 weeks of forward inventory
- Preserve 20–30% cash buffer for opportunistic buys
- Focus OTB on proven SKUs; limit new product investment to 10–15% of budget
Growth Phase ($5M–$25M revenue):
- Calculate OTB bi-weekly
- Extend forward coverage to 8–12 weeks for core SKUs
- Separate OTB budgets by channel (DTC, wholesale, Amazon)
- Seasonal OTB planning 4–6 months ahead for Q4
Scale Phase ($25M+ revenue):
- Real-time OTB visibility across all buyers
- Category-level OTB with buyer accountability
- Integrated OTB and cash flow forecasting
- Automated alerts when OTB utilization exceeds 85%
Connecting Safety Stock to OTB
Your safety stock requirements directly inform OTB planning:
- Calculate total safety stock investment across all active SKUs
- Add cycle stock requirements (reorder quantity ÷ 2 on average)
- Factor in pipeline inventory (goods in transit or production)
- Set OTB ceiling at total required inventory × average unit cost
This prevents the common mistake of over-ordering beyond operational needs, which turns working capital into trapped cash.
Implementation Plan: 30-Day Safety Stock & OTB Rollout
Week 1: Data Collection & Baseline
- Export 12 months of sales data by SKU and channel
- Document current lead times by supplier (mean and standard deviation)
- Calculate current inventory turns and service levels
- Identify top 20% of SKUs by revenue (these need tightest control)
Week 2: Safety Stock Calculation
- Choose service level targets by SKU category (hero vs. support)
- Calculate demand variance and lead-time variance
- Run safety stock formula for all active SKUs
- Compare current stock levels to calculated safety stock
- Flag over- and under-stocked items
Week 3: OTB Framework Setup
- Set revenue targets by month for next 12 months
- Define target inventory turn rate (benchmark: 6–8× for CPG)
- Calculate target end-of-period inventory levels
- Build OTB tracking spreadsheet or dashboard
- Establish approval workflows for OTB exceptions
Week 4: Operationalize & Monitor
- Train buyers/planners on new formulas and targets
- Set weekly OTB review cadence
- Create reorder point alerts based on safety stock levels
- Establish monthly review cycle for safety stock parameter updates
The Hidden Costs of Getting This Wrong
Scenario: Inadequate Safety Stock
- Brand targeting $10M annual revenue
- Stockout rate of 15% (vs. industry standard 5%)
- Average stockout duration: 21 days
- Lost sales impact: $1.5M annually
- Customer acquisition cost wasted: ~$200K in ad spend for customers who churned
Scenario: Excessive Safety Stock
- $2M inventory investment vs. optimal $1.2M
- Excess inventory: $800K
- Carrying cost at 25%/year: $200K
- Opportunity cost: $800K trapped, not funding growth initiatives
- Higher risk of obsolescence and markdowns
The data is clear: brands that implement systematic safety stock and OTB frameworks reduce inventory investment by 15–25% while improving service levels by 8–12 percentage points.
Advanced Tactics for Experienced Operators
Dynamic Safety Stock Adjustments
Rather than static safety stock levels, sophisticated brands adjust based on:
- Velocity changes: Recalculate weekly for fast movers
- Supplier performance trends: Increase buffer when on-time delivery drops
- Promotional calendar: Boost safety stock 30 days before major campaigns
- Seasonality: Higher safety stock entering peak season, lower post-peak
Inventory Classification (ABC Analysis)
Segment SKUs and apply differentiated strategies:
A-items (top 20% of SKUs, 80% of revenue):
- 98% service level target
- Weekly safety stock review
- Dedicated supplier relationships
- Never allow stockouts
B-items (next 30% of SKUs, 15% of revenue):
- 95% service level target
- Monthly safety stock review
- Standard supplier management
- Occasional stockouts acceptable
C-items (bottom 50% of SKUs, 5% of revenue):
- 90% service level or lower
- Quarterly safety stock review
- Consider discontinuation if turns below 2×/year
- Evaluate drop-ship or made-to-order models
Connecting OTB to Cash Flow Forecasting
Integrate OTB planning with financial planning:
Cash Required for Inventory = OTB Budget × (1 - (Payment Terms / 365))
If your OTB is $500K and you have net-60 terms:
Cash Required = $500,000 × (1 - (60/365)) = $500,000 × 0.836 = $418,000
This reveals the actual cash commitment, not just the inventory value.
How CommerceOS Automates Safety Stock & OTB
Manual safety stock and OTB calculations work at small scale but break down as SKU count, channel count, and complexity grow. CommerceOS automates:
- Real-time safety stock calculation based on rolling demand variance and lead-time performance
- OTB dashboards by channel and category with drill-down to SKU level
- Automated reorder point alerts when available inventory falls below safety stock
- PO proposal generation that respects OTB budget constraints and MOQs
- Scenario planning tools to model inventory investment for new channels or seasonal ramps
Brands using CommerceOS reduce inventory planning time by 70% while improving forecast accuracy and service levels.
Frequently Asked Questions
How often should I recalculate safety stock levels?
Recalculate safety stock monthly as a baseline, but review weekly for your top-performing SKUs (A-items). Any time demand variance increases significantly (>20% change), lead times shift, or supplier reliability changes, trigger an immediate recalculation. During promotional periods or seasonal transitions, increase frequency to weekly for affected SKUs.
What’s a realistic target inventory turn rate for CPG brands?
Most CPG brands should target 6–8 inventory turns annually. Food and beverage brands with shorter shelf life aim for 10–12 turns. Luxury or slow-moving categories may achieve 4–6 turns. Calculate turns as: Cost of Goods Sold ÷ Average Inventory Value. Anything below 4 turns suggests excess inventory or demand issues.
Should safety stock be the same across all sales channels?
No. DTC channels can operate with lower safety stock (7–14 days) due to faster replenishment and customer tolerance for backorders. Wholesale requires 30–60 days due to retailer fill-rate requirements and less frequent ordering cycles. Amazon FBA needs 45–60 days because of restock lead times and the severe penalty of losing Buy Box during stockouts.
How do I set service level targets for new products with no sales history?
Use category benchmarks or comparable products as proxies. Start conservatively with 95% service level targets for hero products and 90% for line extensions. After 90 days, you’ll have enough data to calculate actual demand variance and adjust safety stock accordingly. Over-ordering new products is more dangerous than conservative launches.
What happens when my OTB budget shows negative available funds?
Negative OTB means you’ve over-ordered relative to planned sales and inventory targets. Options: 1) Reduce planned receipts by delaying or canceling non-critical POs, 2) Increase sales through promotions to move inventory faster, 3) Adjust target end-of-period inventory downward if it was set too aggressively, or 4) Seek additional working capital if growth opportunities justify the investment.
How do supplier minimum order quantities (MOQs) affect safety stock and OTB?
MOQs often force higher inventory levels than safety stock calculations suggest. When MOQ exceeds optimal order quantity, evaluate: 1) True carrying cost vs. per-unit price savings from larger orders, 2) Risk of obsolescence if demand doesn’t materialize, 3) Negotiate lower MOQs with supplier by committing to regular order cadence, or 4) Consider alternative suppliers with lower minimums, even at slightly higher unit cost.
Should I include seasonal products in my OTB budget year-round?
No. Separate seasonal OTB planning from evergreen products. Calculate seasonal OTB 4–6 months before peak season, commit inventory 90–150 days ahead, and plan for liquidation or storage post-season. Mixing seasonal and evergreen in the same OTB obscures performance and leads to cash flow surprises.
How do I balance safety stock investment across hundreds of SKUs?
Use ABC analysis to prioritize. Invest heavily in safety stock for A-items (top revenue generators), maintain moderate safety stock for B-items, and run C-items lean or consider discontinuation. Many brands find that 80% of revenue comes from 20% of SKUs—focus safety stock investment there. CommerceOS automates this prioritization based on revenue contribution and strategic importance.
Implementation Difficulty: 2/5 (formulas are straightforward; discipline in execution is the challenge)
Impact Estimates:
- Conservative: 10% reduction in stockouts, 8% improvement in inventory turns
- Likely: 15% reduction in stockouts, 12% improvement in turns, 15% reduction in trapped capital
- Upside: 25% stockout reduction, 18% turn improvement, 25% working capital freed, enabling faster growth or margin expansion
Time to Value: 30 days to establish baseline and implement framework; 90 days to see measurable improvement in service levels and working capital efficiency.
Commerce is chaos.
Tame your tech stack with one system that brings it all together—and actually works.
Book a DemoInsights to master the chaos of commerce
Stay ahead with expert tips, industry trends, and actionable insights delivered straight to your inbox. Subscribe to the Endless Commerce newsletter today.