Stock
Planning
Buy enough to serve valuable demand without financing an optimistic forecast.
Build a stock plan that connects demand, supplier timing, safety stock, reorder triggers and order quantities. Learn how to handle promotions, uncertain launches, supplier constraints and cash limits without treating a forecast as a guarantee.
A stock plan is a decision under uncertainty.
Ecommerce stock planning determines which items to hold, when to replenish and how much capital to commit. The plan combines expected demand with supply timing, uncertainty, service priorities and business constraints. A forecast is an input to that decision, not a purchase authorization by itself.
Forecast demand, not only observed sales
Sales fall when stock is unavailable. Separate stockout-censored periods, promotions, returns and unusual events before interpreting history as underlying demand.
Measure usable lead time
Use the time from order release until stock can actually be sold, including production, transport, customs, receiving and inspection. Supplier dispatch time alone may understate the exposure.
Separate trigger from quantity
A reorder point protects expected demand during lead time plus a buffer. Quantity reflects the replenishment cycle, order costs, minimums, shelf life and available cash.
Segment the assortment
Core fast movers, intermittent sellers, seasonal goods and new launches need different planning rules. Prioritize economic importance and demand variability rather than applying one days-of-stock target everywhere.
Verify the service and cash result
A leaner stock balance is useful only if it preserves worthwhile demand. Check fill rate, stockouts, aged inventory, purchasing commitments and contribution after changes.
Plan for a range of outcomes. Use an explicit base case and downside, then decide which uncertainties deserve stock, supplier flexibility or a smaller commitment.
When to buy is not how much to buy.
The example uses a continuously reviewed, single-SKU policy. Demand averages 12 units per calendar day, replenishment lead time is 30 calendar days and the planning buffer is 100 units. That buffer is an illustrative choice, not a statistically calibrated service guarantee.
What triggers the order—and what determines its size?
Compare the trigger with inventory position.
For this illustration, inventory position equals usable on-hand plus firm on-order units minus backorders. If reservations are already removed from usable stock, do not subtract them again. Receipt timing still matters: an overdue purchase order cannot protect tomorrow's demand merely because it appears in the total.
A reorder point is a policy, not a universal stock target.
With 220 usable units on hand, 250 on order and 50 backordered, inventory position is 420: below the 460 trigger. A 600-unit order may be appropriate only after checking the earlier receipt, committed demand, capacity and cash. For a periodic review every seven days, the protection horizon includes the review interval as well as lead time. A simple order-up-to target would cover 37 days of forecast demand plus a buffer appropriate to that longer horizon. Keep the policy and unit definitions explicit . Do not apply a continuous-review formula to weekly ordering without considering the extra exposure between reviews.
Translate assumptions into a purchase decision.
The relationships are simple; the quality of the inputs is not. Use compatible time units and a dated demand view. In a seasonal business, forecast demand over the actual lead-time window rather than multiplying a flat annual average.
Seven checks before releasing an order
This workflow keeps the demand estimate, inventory position and cash commitment connected. Each number is an educational assumption.
Estimate demand
Use in-stock sales history, known commitments and justified promotional changes.
Measure lead time
Include all time until receipt becomes saleable, not only supplier production.
Set a buffer
Choose safety stock from uncertainty and a defined service objective; test the chosen policy.
Calculate the trigger
Expected lead-time demand is 12 × 30 = 360 units; add the buffer.
Check inventory position
220 usable on hand + 250 on order − 50 backorders.
Apply quantity constraints
A 600-unit MOQ at $15 cost creates a $9,000 stock commitment before other cash needs.
Review the receipt schedule
Confirm when existing and new supply arrives and whether the business can fund it.
Use scenarios where the history is sparse or the selling window is changing.
Cycle service level and unit fill rate are different measures; specify which matters.
Balance ordering and holding costs, then apply supplier and cash constraints.
Deposits, freight and supplier payment dates may precede the sale by weeks.
Where EOQ helps—and where it does not.
The basic Economic Order Quantity is √(2DS/H): D is annual units demanded, S the fixed cost per order and H annual holding cost per unit. Its simplifying assumptions include stable demand and costs, known lead time and replenishment without planned shortages. Use it as a starting comparison, then account for MOQ, pack size, capacity, shelf life, discounts and cash. Do not present the model's minimum as a precise answer for an uncertain seasonal launch.
Different uncertainty calls for different planning rules.
A single stock-cover target obscures the reasons inventory is held. Diagnose forecast variability, supply reliability, lifecycle and cash constraints separately before increasing or cutting buffers.
A forecast average hides the difficult days
An average of 12 units per day may combine quiet weekdays and a promotion spike. Promotions can shift demand forward rather than create entirely new demand. Returns and cancellations also complicate the relationship between gross orders and net stock consumption.
The higher scenario adds 180 units before any buffer. Buy only where campaign evidence, contribution and the selling window justify the commitment; do not add the same uplift to both the forecast and safety stock.
Improve the forecast inputs
The supplier average is not the whole distribution
A quoted 30-day lead time can conceal frequent 45-day receipts. Expected stock consumption continues while production, customs or receiving is delayed. A larger buffer is one response; improved supply reliability or an alternate source may be better.
At 12 daily units, a 15-day delay consumes 180 additional units. A 100-unit buffer does not fully protect that scenario. Review the actual receipt distribution and the economic cost of shortages rather than promising a service level from an arbitrary buffer.
Improve replenishment reliability
A slow mover should not inherit a bestseller policy
ABC-style prioritization can rank economic importance, while demand variability separates stable replenishment from intermittent demand. A high-revenue item with poor contribution may not deserve the highest service investment.
Use analogous products and staged commitments for launches, then update quickly with real demand. Seasonal items need a final order date and exit plan. The buffer for a short-lived product may have little recovery value after the selling window.
Plan by segment
A technically feasible order may be unaffordable
Minimums and freight discounts can push a replenishment quantity beyond the cash available before customer receipts arrive. A lower unit cost is not automatically better when the additional units face markdown risk.
The larger batch saves $1 on each unit but requires $5,000 more inventory spending in this comparison. Evaluate expected demand, total costs and the residual position; do not justify it from unit price alone.
Make tradeoffs explicit
Use stock where it addresses an economically important uncertainty.
Inventory cannot solve every planning problem. Supplier flexibility, simpler assortment and better demand evidence can reduce both excess and shortages. Colored fills are illustrative, not probability estimates.
Find the assumption behind the exception.
Review SKU-level projected availability with purchase receipts, demand scenarios and cash dates. A single average stock-cover number cannot explain a late supplier, a promotion spike and an uneconomic MOQ.
Illustrative exception register for a core SKU; no live forecast or automated purchasing recommendation.
The position combines usable stock, firm receipts and backorders under a documented definition. It must be checked against timing before an order is approved. Decorative fills do not represent a service score.
Forecast over the relevant upcoming window, not a universal run rate.
Measured until inventory becomes saleable.
Illustrative assumption requiring backtesting.
The feasible MOQ batch requires $9,000 at $15 per unit.
Stock Is Available in Total, but Not on Time
An on-order balance can make inventory position look adequate while the next receipt arrives after usable stock is exhausted. Backorders and reservations add pressure.
Build a dated receipt-and-demand schedule. Include the 50 backorders explicitly and avoid relying on simple cover as a promise. If the existing 250-unit receipt is late, compare expediting, transfer, substitution or demand moderation.
The Promotion Is Not in the Purchase Plan
An expected uplift from 12 to 18 units per day would raise 30-day demand from 360 to 540 units. Treat the uplift as a scenario until campaign evidence supports it.
Marketing and purchasing should agree on duration, confidence and contribution after discount and advertising. Stage the incremental commitment where possible and define an exit route for unsold promotional units.
The MOQ Exceeds Available Cash
The 600-unit minimum creates a $9,000 commitment, excluding any additional freight or deposits. If available inventory funding is only $7,000, the policy is not executable as written.
Finance and purchasing should compare supplier terms, smaller releases, substitutes or a deliberate service tradeoff. Do not silently cut the safety buffer to make the spreadsheet balance without evaluating lost contribution.
A planning exception should change a named assumption.
Demand belongs to the commercial owner, usable lead time to operations and suppliers, purchase constraints to purchasing, and payment timing to finance. Keep an approval record for the tradeoff.
For the underlying inventory models and their assumptions, review MIT logistics lecture notes on EOQ, probabilistic demand and safety stock. Apply a model only where its assumptions fit.
Build an executable stock plan.
Create a dated policy for each material SKU, then test the result against demand, supply and cash scenarios. Planning should reveal uncertainty early enough to change the commitment.
An eight-step Stock Planning Framework
The example owners and cadence are adaptable operating choices, not mandatory reporting frequencies.
Reconcile demand and inventory data
Align SKU identifiers, locations and units of measure. Use saleable stock and firm receipts, and distinguish reservations, backorders and quarantined returns.
Segment the assortment
Group by economic importance, demand variability, lead time and lifecycle. Use ABC-style rankings to focus review effort, then add product role and contribution context.
Build demand scenarios
Forecast the actual protection window with a base case and useful downside and upside cases. Separate baseline demand from promotions and unsupported growth assumptions.
Measure supply timing
Use release-to-saleable lead time and its variability. Track late and partial receipts and identify the operational step causing delay.
Choose review and buffer policies
Specify continuous or periodic review and the service measure to protect. Set safety stock from observed uncertainty, a suitable model or explicit scenarios, then test the result.
Set feasible reorder quantities
Calculate reorder points and an order-size candidate, then apply MOQ, case packs, shelf life, warehouse capacity and supplier constraints.
Fit the plan to cash
Map deposits, freight, supplier payments and expected customer receipts. Rank constrained purchases by economic importance and the contribution they protect.
Monitor outcomes and revise
Compare actual demand, lead times, availability and aging with the policy assumptions. Adjust rules when evidence changes rather than chasing a target turnover number.
Make the plan executable before making the purchase.
The final output is a dated order decision with a demand rationale, a supply schedule, a service tradeoff and a funding path.
Smaller batches, stronger planning discipline.
A hypothetical replenishable SKU sells 4,380 units per year, averaging 12 per day. Unit inventory cost is $15. Compare two continuous-review policies under simplified steady-demand assumptions, then test the risk that those assumptions miss.
Illustrative economics; no guaranteed service improvement or real customer results. Annual demand and unit cost are held constant.
The simplified steady-state estimate falls from $8,250 to $6,000; this is not an immediate cash receipt.
Annual demand divided by batch quantity. Actual orders are discrete and depend on opening and closing stock.
Illustrative 20% annual carrying charge applied to $2,250 less average inventory.
At $50 fixed cost per order, 2.92 additional annualized orders add $146.
How the policy comparison was built
The policy reduces cycle stock while increasing the uncertainty buffer. Its modeled economic benefit must be tested against real demand, lead time and supplier terms.
Calculate average cycle stock
In the simple steady-demand model, average on-hand inventory is approximately Q/2 plus safety stock: 1,000/2 + 50 = 550 units before.
550 unitsApply the revised policy
The new estimate is 600/2 + 100 = 400 units. At $15 cost, average inventory is $6,000. Pipeline inventory is excluded from this on-hand comparison.
400 unitsCompare modeled recurring costs
Annual holding savings of $450 less additional order cost of $146 gives a $304 modeled annual benefit. The 20% charge and $50 order cost are assumptions, not benchmarks.
$304/yearTest a delayed receipt
A 45-day lead time requires 540 units at base demand. The 460-unit reorder point would be 80 units short in that deterministic stress case, absent other interventions.
80-unit exposureChoose and monitor the tradeoff
Compare higher protection, faster supply or a deliberate service risk with the contribution at stake. Verify actual fill rate, urgent freight and aging before calling the change successful.
Backtest and reviewA better plan changes the composition of inventory.
The revised policy holds fewer routine cycle units and more uncertainty protection. It reduces the order commitment by $6,000 per batch without claiming that the entire difference is profit or permanent cash release. The average-inventory estimate excludes owned pipeline stock and assumes regular receipts, steady demand and no shortages. A full capital comparison must include the relevant ownership and payment boundaries.
Is the stock plan ready to execute?
These checks connect the forecast with a purchase that can arrive on time and be funded. An unresolved item needs a decision or an explicit exception.
Data
SKU units are consistent
Case packs, units and locations reconcile.
Usable stock is known
Quarantine and committed units are treated consistently.
Sales limitations are flagged
Stockouts and unusual events do not become normal demand.
Demand
Forecast windows match lead time
Demand is estimated for the actual upcoming exposure.
Promotions are explicit
Uplift, duration and confidence are documented.
New products have learning gates
Limited history leads to staged commitments where possible.
Supply
Lead time reaches saleable receipt
Production, transit and receiving are included.
Variability is reviewed
Late and partial deliveries inform the buffer decision.
Open orders have dates
Inventory position is checked against actual expected arrival.
Policy
Review cadence is stated
Continuous and periodic policies are not mixed silently.
Service measure is defined
Fill rate and cycle service level are distinguished.
Safety stock is tested
The buffer reflects uncertainty and economic priorities.
Feasibility
Minimums and packs are checked
Order quantity is operationally feasible.
Shelf life and season constrain buying
The residual after the selling window is considered.
Cash dates are mapped
Deposits and supplier payments fit the funding plan.
Feedback
Outcomes are monitored
Availability and aging are checked after changes.
Forecast bias has an owner
Persistent overforecasting triggers a rule change.
Policy versions are retained
Results are compared with assumptions recorded at approval.
A complete plan answers four questions.
What demand are we protecting, when will usable stock arrive, what uncertainty remains, and how will the commitment be funded?
Clean the demand history
Flag stockouts, promotions and SKU changes.
Check dates and constraints
Review receipt timing, minimums and cash together.
Compare actual outcomes
Measure service, excess and economic costs.
Six questions about practical stock planning.
These answers explain how the inputs fit together and why a model result still needs an operating decision.
01 Planning purpose What is ecommerce stock planning? +
Stock planning determines what to hold, when to reorder and how much to commit. It connects demand expectations, usable lead time, uncertainty, service priorities and funding.
A useful plan is SKU-specific where the economics warrant it. Core replenishment, intermittent demand, launches and seasonal goods should not inherit the same policy automatically.
The goal is profitable availability with controlled excess, not maximum inventory or minimum stock at any cost.
Review the summary →02 Reorder logic How do demand, lead time and safety stock determine reorder point? +
For a simple continuously reviewed SKU, the relationship is:
At 12 units per day and 30 days lead time, expected demand is 360 units. Adding an illustrative 100-unit buffer gives a 460-unit trigger.
Compare with inventory position . Define usable stock, firm receipts and backorders consistently. A periodic review policy also needs to protect the interval until the next review.
Review the framework →03 Uncertainty How much safety stock should an ecommerce business hold? +
There is no universal buffer. It depends on demand variability, replenishment uncertainty, service objectives, margin, shelf life and the cost of excess or lost sales.
Use a model or scenario approach suited to the data. A statistical safety factor requires appropriate assumptions; it does not convert a poor forecast or unreliable stock record into certainty.
Backtest availability and residual stock, then adjust the policy. More stock is not the only solution: shorter lead times, supplier reliability and smaller commitments may be better.
Review planning risks →Three questions answered. Three to apply.
Continue with EOQ, uncertain products and the ongoing review cycle.
04 Order quantity Is EOQ the quantity I should always order? +
No. Basic EOQ balances fixed ordering cost with annual holding cost under simplifying assumptions such as stable demand and costs. It is a comparison point, not an unconditional purchase instruction.
Apply business constraints after the model
Minimum orders, pack sizes, shelf life, seasonal windows, warehouse capacity, quantity discounts and cash may make a different order size preferable.
Check total economics and service after constraints. If a large minimum creates unacceptable residual stock, negotiate terms or reconsider the item rather than calling the minimum optimal.
Follow the action plan →05 Limited history How should new or seasonal products be planned? +
Use analogous products, committed demand and explicit scenarios. Limit the first commitment where supplier terms allow, then update with actual in-stock demand.
Define a learning gate and last-buy date
A seasonal forecast should follow the selling window rather than a flat annual average. Promotions need their own duration, confidence and post-event residual plan.
For background on inventory models and uncertainty, see MIT logistics lecture notes . Apply their assumptions deliberately rather than forcing a steady-demand model onto every launch.
Review the demand workflow →06 Control cycle Which measures show whether a stock plan is working? +
Monitor availability and capital together: fill rate, stockout days, late receipts, aged inventory, turnover and purchase commitments. Add contribution and urgent freight so a service gain is not mistaken for a profit gain.
Review material exceptions weekly where practical and reconcile the policy at a cadence suited to replenishment. Preserve forecast versions so actual results can be compared with the information available at approval.
Change one clearly identified assumption or constraint at a time when possible. A better turnover ratio alone does not prove better planning if profitable sales are being lost.
Apply the eight-step plan →All six stock-planning questions answered.
You can connect demand and supply assumptions with an executable reorder policy and a clear cash tradeoff.
Connect the stock plan with economic priorities.
Inventory turnover helps evaluate the capital supporting the plan; dead-stock analysis explains what happens when commitments outlive demand. Continue with Lesson 19 — Inventory Profitability to connect stock planning with margin, turnover and return on inventory investment.
Product Profitability Analysis
Assess product-level economics before assigning scarce inventory funding or high service priority.
Keep the forecast connected to the purchase. Review what actually arrived, sold and remained.
Maintain a dated plan with demand assumptions, receipt schedules, commitments and outcomes. Connect those records with product profitability. Explore MarginLab's published features to assess its current role in your wider analysis.