Furniture · Stockout · Epicor · VP Supply Chain

VP Supply Chain: furniture stockout, read from Epicor

A furniture VP Supply Chain on Epicor should not be hunting for stockout problems. Ward brings up them every morning.

How a furniture VP Supply Chain runs stockout on Epicor

Stockout Prediction is a insight card type Ward runs continuously. Ward detects SKUs trending toward zero-on-hand and alerts your team with replenishment recommendations before customers notice.

A Furniture Manufacturing & Retail operator is continuous review 10,000+ SKUs throughout locations. ERP-locked production data, long lead times, and margin erosion you don't see until quarter-end. Ward connects your internal systems and surfaces what matters.

You find out about stockouts after customers do. Ward surfaces the indicators that change a supply chain decision.

How Ward hands back Stockout cards: Ward analyzes sell-through velocity, current inventory levels, lead times, and supplier reliability to predict stockouts 24-72 hours before they occur.

The connection itself. Ward connects via Epicor REST API. Compatible with Epicor Prophet 21 and Epicor Eclipse.

What it does

  • Automated replenishment recommendations
  • Supplier-aware lead time modeling
  • Priority ranking by revenue impact
  • Reduce lost sales by catching gaps early
app.getward.ai Live demo
Acme Furniture @Finance: Margin Analyst claude-sonnet default
A

Chat

Ask anything. Ward routes to the right agent and returns cited answers.

Why is upholstery margin down four points this quarter?
You · 9:42 AM
Schema Scout · routed to Margin Agent

I pulled upholstery cost of goods by BOM line against the last price file. Three quarters of the drop is material and freight, not discounting.

SignalFinding
bom_cost_actualsFoam and frame stock +9.2% since the March price file, never carried to list
freight.inboundInbound container cost +$412 per unit-equivalent on the Vietnam lane
channel.mixWholesale share up 6pp, and wholesale runs 11pp under DTC margin

Recommend: reprice the six affected SKUs at the next list cycle, quote the alternate foam vendor, and hold wholesale allocation flat until list catches up.

11 parallel queries 4 sources cited confidence 0.90
Show me the SKU-level margin waterfall.
You · 9:43 AM
Margin Agent · building waterfall
Querying bom_cost_actuals
Ask anything, Ward routes to the right agent. Cmd+K

Reporting

Pinned views built from saved data-lake queries. Every number re-derivable from its SQL.

7d13w52w
Revenue vs. forecast
$19.8M
+1.8% WoW
Gross margin, upholstery
42.1%
−4.1pp
Order-to-delivery, custom
14.2 wks
+1.9 wks
Aged inventory, 180+ days
$6.4M
+$1.2M
Revenue vs. forecast 13 weeks actual, 6 weeks forecast, 80% interval
Actual Forecast 80% interval
% of plan 106 94 100 forecast → W−13 W−5 today +6wk
Holt-Winters + weather regressor MAPE 4.1% at 4wk Backtested 24 months Crosses plan in 3 weeks
Forecast error by horizon MAPE, 24-month backtest
1wk 2.1%
2wk 3.0%
4wk 4.1%
8wk 6.3%
13wk 8.9%
Accuracy bar for promo decisions: ≤5% at 4wk
Models in production Every forecast ships a model card
ModelHorizonMAPE
holt_winters4wk4.1%
arima_sarimax13wk8.9%
gbm_demand1wk2.1%
bayes_hiernew store11.4%

Sources

Connect external systems to the data lake.

NameTypeLast sync
epicor_production_stage_logimport2m ago
epicor_bom_cost_actualsimport2m ago
sap_inventory_snapshotimport14m ago
netsuite_sales_ordersimport1h ago
retail_showroom_posimport1h ago
retail_freight_inboundimport1h ago
retail_dealer_ordersimport1h ago

Policies

Browse and manage Cedar access policies for your tenant.

TLS 1.3 AES-256 Read-only SOC 2 II
Policy IDEffectResources
finance-read-defaultpermitModel::*
sourcing-read-bompermitModel::"bom_cost_actuals"
dealer-blockedforbidModel::"bom_*"
plant-read-productionpermitModel::"production_stage_log"
Stockout for Furniture on Epicor data, live product demo.

Why Stockout matters for Furniture retail

In furniture, a stockout is not a one-day gap, it is an 8 to 16 week hole. Replenishment often means a new container from an overseas plant, so the reorder decision has to fire weeks before the shelf runs dry. Ward models sell-through against inbound container schedules and supplier lead-time variance, flagging the reorder point early enough that a hero SKU never goes dark through a full production cycle.

Why this combination
is its own problem.

A VP Supply Chain does not need the stockout model explained. They need to know which stores moved, why, and what to do by end of day. Ward writes the finding at that altitude.

  • 01 Configurable SKUs are forecast at the parent level, hiding that one fabric or finish is driving the demand spike while the others sit.
  • 02 Reorder points are set on domestic lead-time assumptions when the real lead time is a 14-week overseas container, so the trigger fires far too late.

Benchmarks. Furniture lead times commonly run 8 to 16 weeks for imported goods. A stockout on a top-20 floor SKU typically costs 4 to 8% of category revenue for every month it persists, because customers who cannot buy the piece they came for rarely substitute and often leave the sale entirely.

What Ward has eyes on.

Coverage is store by store, category by category. Ward keeps a running read on inventory carrying cost, order-to-delivery cycle, gross margin by channel over 10,000+ SKUs and compares each store against its own baseline, not against the chain. That is the difference between knowing the footprint is fine and knowing which seven locations are not.

The connection to Epicor is read-only and runs on your schedule. Ward pulls from sales orders, inventory, and the rest of the feed, then combines it with external context your ERP does not carry: weather, local events, competitor pricing.

Know before the shelf empties. Ward runs the model continuously rather than on a reporting cycle, which is why a finding lands the morning the pattern starts instead of at the end of the period.

At the metric level. Ward tracks sell-through velocity by SKU and configuration, inbound container ETAs, supplier lead-time variance by plant, and on-hand plus in-transit position. Long lead times mean the cost of a late reorder is measured in lost months, not lost days, so Ward weights revenue-at-risk across the full replenishment window.

Signals · POS line items by SKU-configuration, on-hand and in-transit inventory, open POs, container ETAs, supplier lead-time history by plant, and catalog and marketing feature calendars.

What the first 90 days
actually look like.

  1. 01

    Week 1: read-only connection

    Ward sits on top of Epicor with read-only credentials and begins ingesting sales orders and inventory. No config changes on your side. First findings arrive within 48 hours.

  2. 02

    Weeks 2 to 3: calibration

    Baselines stabilize per store and per category. Ward stops flagging normal variance and starts flagging exceptions. This is the window where the false positive rate drops sharply.

  3. 03

    Weeks 4 to 12: steady state

    Ward delivers findings daily, each with root cause and a recommended action. Volume settles at a level a single person can read over coffee. The measure of success is not how many insight cards arrive, it is how many get acted on.

How Ward connects to Epicor

Ward integrates with Epicor for home improvement, furniture, and building supply retailers. Inventory, purchasing, production, and sales data power insight cards.

Setup: Ward connects via Epicor REST API. Compatible with Epicor Prophet 21 and Epicor Eclipse.

Data Ward reads from Epicor

Sales orders
Inventory
Purchase orders
Customer accounts
Pricing tiers
Vendor performance

Impact metrics with Epicor

Seasonal Accuracy
Pre-buy timing sharpened
Weather and event signals calibrate seasonal positioning.
Project Basket Value
Cross-sell patterns found
Project purchasing sequences reveal attachment opportunities.
Vendor Fill Rate
Degradation caught early
Fill rate drops flagged before shelf impact materializes.
Inventory Carrying Cost
Slow-movers identified
Demand-aligned ordering frees capital tied in dead stock.

Data lake enrichment

Ward enriches Epicor data with: Sales orders, Weather & events, Contractor/Pro data, Competitor pricing, Vendor scorecards

You find out about stockouts after customers do.

Pain points
  • ×Demand forecasts are off by 15-25% and nobody catches it until the shelf is empty
  • ×Supplier fill rate problems announce themselves at the receiving dock
  • ×Safety stock levels get set once a year and left alone
  • ×No early warning system for supply chain disruptions
  • ×Replenishment exceptions require manual triage every morning
How Ward helps
  • Stockout prediction cards arrive 24-72 hours before empty shelves
  • Supplier fill rate tracking with automatic escalation
  • Dynamic safety stock recommendations based on current demand signals
  • Weather, event, and macro-driven demand adjustments
  • Replenishment exceptions auto-prioritized by revenue impact

Stockouts cost retailers $1.14 trillion in missed sales globally each year. Source: IHL Group

Furniture KPI impact

Inventory Carrying Cost
Aged stock flagged
Slow-moving SKUs identified before carrying costs compound.
Order-to-Delivery Cycle
Bottleneck visibility
Cycle time tracked by production stage against baselines.
Gross Margin
Real-time by channel
Material cost drift detected the week it starts.
Stockout Frequency
Advance warning
POS and e-commerce signals feed back into production.

Frequently asked questions

Ward detects SKUs trending toward zero-on-hand and alerts your team with replenishment recommendations before customers notice. For Furniture retail specifically, Ward monitors 10,000+ SKUs across your locations and delivers automated insight cards with root cause analysis and recommended actions.

Ward tracks Inventory carrying cost, Order-to-delivery cycle, Gross margin by channel, Raw material cost variance, Custom order cycle time at the store-category level. Ward analyzes sell-through velocity, current inventory levels, lead times, and supplier reliability to predict stockouts 24-72 hours before they occur.

Ward connects via Epicor REST API. Compatible with Epicor Prophet 21 and Epicor Eclipse. Data points include: Sales orders, Inventory, Purchase orders, Customer accounts, Pricing tiers, Vendor performance.

Yes. Ward reads Epicor data and combines it with contextual signals (weather, events, demographics) to generate Furniture-specific insight cards. No custom development required.

You find out about stockouts after customers do. Ward solves this with automated insight cards: Stockout prediction cards arrive 24-72 hours before empty shelves. Supplier fill rate tracking with automatic escalation. Dynamic safety stock recommendations based on current demand signals.

Ward delivers daily insight cards covering Inventory carrying cost, Order-to-delivery cycle, Gross margin by channel, tailored for Supply Chain decision-making. Each card includes what changed, why it matters, and what to do next.

Ward tracks sell-through velocity by SKU and configuration, inbound container ETAs, supplier lead-time variance by plant, and on-hand plus in-transit position. Long lead times mean the cost of a late reorder is measured in lost months, not lost days, so Ward weights revenue-at-risk across the full replenishment window.

A best-selling sectional in one fabric colorway starts selling 40% above forecast across the showroom network after a catalog feature. On-hand covers six weeks, but the factory lead time is 14 weeks and the next container is not booked. Ward issues a stockout prediction card the moment velocity clears threshold, with the recommended reorder quantity and the booking deadline to avoid a two-month floor gap. The buyer places the PO with ten weeks of runway instead of finding out at the empty slot.

First insight cards arrive within 48 hours of data connection. Ward needs approximately 2 weeks to establish stable baselines for your specific operation.

No. Ward sits on top of your existing stack. It is the proactive intelligence layer that watches your data continuously and delivers insight cards, so your team acts on findings instead of hunting for them.

See what Furniture stockout problems Ward catches.

Root causes, not just alerts. See it on your data.

Read-only to start · your LLM keys · SOC 2 Type II underway · or book a call directly

Find out what your data has been hiding.

Tell us about your operation. We’ll show you the problems Ward catches, and the ones your current tools miss.

Step 1 of 3
What are your goals?
Step 2 of 3
About your operation
Step 3 of 3
Your contact info