Simulated inventory value (GBP)
£2.2k
2,524 units across the demo subsetSimulated inventory value (GBP) trendSimulated inventory value (GBP) trend: 12 observations. 782 to 2,524; rose.Use arrow keys to inspect data. Press Enter or Space to pin a value. Press Escape to clear.
Demo SKUs in scope
14
Illustrative subset, not the full catalogueDemo SKUs in scope trendDemo SKUs in scope trend: 12 observations. 8 to 14; rose.Use arrow keys to inspect data. Press Enter or Space to pin a value. Press Escape to clear.
Low stock items
9
8 criticalLow stock items trendLow stock items trend: 12 observations. 3 to 9; rose.Use arrow keys to inspect data. Press Enter or Space to pin a value. Press Escape to clear.
Pending orders
5
4 constrainedPending orders trendPending orders trend: 12 observations. 1 to 5; rose.Use arrow keys to inspect data. Press Enter or Space to pin a value. Press Escape to clear.

Stock movement

Portfolio units over the 28-day review window ending 2011-11-30.

28-day window
Stock movement28-day historical review window. Sources on the left add to stock: opening 1,957 units, receipts 1,086, returns 158. Destinations on the right consume or close stock: demand 3,223, adjustments 519, closing 2,524.SOURCES INTO STOCK →→ OUT OF STOCK / CLOSINGOpening1,957Receipts1,086Returns158Demand3,223Adjustments519Closing2,524Use arrow keys to inspect data. Press Enter or Space to pin a value. Press Escape to clear.

Top categories

Simulated on-hand cost by product group, in GBP.

By value
Category exposure6 categories totaling £2.2k. Largest category: Celebration. Celebration: £887, 40%. Home accents: £477, 22%. Kitchen & dining: £353, 16%. Bags & storage: £349, 16%. Other categories: 129, 6%.ON-HAND COST£2.2k6 categoriesCelebration: £887, 40% of the total.Celebration£88740%Home accents: £477, 22% of the total.Homeaccents£47722%Kitchen & dining: £353, 16% of the total.Kitchen& dining£35316%Bags & storage: £349, 16% of the total.Bags& storage£34916%Other categories: 129, 6% of the total.Othercategories1296%Use arrow keys to inspect data. Press Enter or Space to pin a value. Press Escape to clear.

Alerts

Items that need buyer attention.

View all
  • Stockout exposureProducts above the high-risk threshold9
  • Orders need fundingRecommended lines reduced or deferred4
  • Elevated returnsBuyer review before replenishment2
  • Manual review gateCoverage or calibration below policy limits1

Recent inventory

Highest-priority changes, as of 2011-11-30. Every date below comes from the dataset, which ends 2011-12-09.

View all
Highest-priority historical simulation recommendations
ProductSKUCategoryStatusQty changeSupplierOrder by (dataset)
85099BBags & storageReorder+384Paper Lane Trading2011-11-30
85123AHome accentsReorder+252North Star Homewares2011-11-30
20725Bags & storageReorder+192Paper Lane Trading2011-11-30
22086SeasonalReview+348Field & Form2011-12-07
22423Kitchen & diningReorder+108Ember Works2011-11-30

Calculation log

Deterministic events from the 2011-11-30 run, not live traffic.

Method
  1. Plan evaluated1200 units approved across 5 lines.
  2. Service target applied95% target over lead time and review period.
  3. Constraint check passedfeasible-greedy; no optimality claim.
  4. Artifact loadedsupplylens-demo-ui-v1.0.0; representative UI fixture.

Inventory-risk matrix

Stockout probability against simulated excess exposure.

Size shows forecast volume
Stockout risk and excess exposure14 products. Highest stockout risk: Jumbo Bag Red Retrospot, 98.9%. Mark colour and shape both show the risk band; point size represents units when supplied. Jumbo Bag Red Retrospot: 98.9% stockout risk and 0% excess exposure. White Hanging Heart T-light Holder: 97.3% stockout risk and 0% excess exposure. Lunch Bag Red Retrospot: 96% stockout risk and 0% excess exposure. Paper Chain Kit 50's Christmas: 79.8% stockout risk and 0% excess exposure. Regency Cakestand 3 Tier: 97% stockout risk and 0% excess exposure. Small Popcorn Holder: 91.1% stockout risk and 0% excess exposure. Rabbit Night Light: 87.4% stockout risk and 0% excess exposure. Set Of 3 Cake Tins Pantry Design: 88.9% stockout risk and 0% excess exposure. Pack Of 72 Retrospot Cake Cases: 42.8% stockout risk and 0% excess exposure. Jam Making Set With Jars: 35% stockout risk and 0% excess exposure. Assorted Colour Bird Ornament: 0% stockout risk and 69% excess exposure. Jumbo Bag Pink Polkadot: 0% stockout risk and 100% excess exposure. Party Bunting: 0% stockout risk and 100% excess exposure. Spotty Bunting: 0% stockout risk and 69% excess exposure.0%0%25%25%50%50%75%75%100%100%EXCESS REVIEWDUAL RISKWITHIN RANGEREPLENISHMENT RISKPaper Chain Kit 50's Christmas. High / critical risk band. Stockout risk 79.8%; excess exposure 0%; 233 units.2 products overlap at this chart scale. Small Popcorn Holder. High / critical risk band. Stockout risk 91.1%; excess exposure 0%; 160 units. Set Of 3 Cake Tins Pantry Design. High / critical risk band. Stockout risk 88.9%; excess exposure 0%; 44 units.Rabbit Night Light. High / critical risk band. Stockout risk 87.4%; excess exposure 0%; 124 units.Pack Of 72 Retrospot Cake Cases. High / critical risk band. Stockout risk 42.8%; excess exposure 0%; 304 units.Jam Making Set With Jars. Moderate risk band. Stockout risk 35%; excess exposure 0%; 46 units.2 products overlap at this chart scale. Assorted Colour Bird Ornament. Low risk band. Stockout risk 0%; excess exposure 69%; 205 units. Spotty Bunting. Low risk band. Stockout risk 0%; excess exposure 69%; 23 units.2 products overlap at this chart scale. Jumbo Bag Pink Polkadot. Low risk band. Stockout risk 0%; excess exposure 100%; 85 units. Party Bunting. Low risk band. Stockout risk 0%; excess exposure 100%; 49 units.4 products overlap at this chart scale. Jumbo Bag Red Retrospot. High / critical risk band. Stockout risk 98.9%; excess exposure 0%; 374 units. White Hanging Heart T-light Holder. High / critical risk band. Stockout risk 97.3%; excess exposure 0%; 292 units. Lunch Bag Red Retrospot. High / critical risk band. Stockout risk 96%; excess exposure 0%; 191 units. Regency Cakestand 3 Tier. High / critical risk band. Stockout risk 97%; excess exposure 0%; 97 units.White Hanging…PRIORITYRISK / EXCESSJumbo Bag Red Retrospot. High / critical risk band. Stockout risk 98.9%; excess exposure 0%; 374 units.01Jumbo Bag Red…98.9% / 0%White Hanging Heart T-light Holder. High / critical risk band. Stockout risk 97.3%; excess exposure 0%; 292 units.02White Hanging…97.3% / 0%Regency Cakestand 3 Tier. High / critical risk band. Stockout risk 97%; excess exposure 0%; 97 units.03Regency Cakes…97% / 0%Lunch Bag Red Retrospot. High / critical risk band. Stockout risk 96%; excess exposure 0%; 191 units.04Lunch Bag Red…96% / 0%Small Popcorn Holder. High / critical risk band. Stockout risk 91.1%; excess exposure 0%; 160 units.05Small Popcorn…91.1% / 0%Set Of 3 Cake Tins Pantry Design. High / critical risk band. Stockout risk 88.9%; excess exposure 0%; 44 units.06Set Of 3 Cake…88.9% / 0%Rabbit Night Light. High / critical risk band. Stockout risk 87.4%; excess exposure 0%; 124 units.07Rabbit Night…87.4% / 0%Paper Chain Kit 50's Christmas. High / critical risk band. Stockout risk 79.8%; excess exposure 0%; 233 units.08Paper Chain K…79.8% / 0%Stockout risk →Excess exposure →
Use arrow keys to inspect data. Press Enter or Space to pin a value. Press Escape to clear.

Demand and inventory projection

85123A · White Hanging Heart T-light Holder

Demand and projected inventory for 85123A85123A. 24 periods. Final forecast 122 units. Final projected inventory 0 units. Reorder point 208 units.DEMAND / UNITSObservedForecastIntervalInventory07915808-08: observed demand 97 units.08-15: observed demand 75 units.08-22: observed demand 88 units.08-29: observed demand 84 units.09-05: observed demand 110 units.09-12: observed demand 129 units.09-19: observed demand 133 units.09-26: observed demand 108 units.10-03: observed demand 106 units.10-10: observed demand 84 units.10-17: observed demand 78 units.10-24: observed demand 107 units.10-31: observed demand 128 units.11-07: observed demand 122 units.11-14: observed demand 113 units.11-21: observed demand 98 units.11-28: observed demand 106 units.FORECAST STARTPROJECTED INVENTORY / UNITS0208ROP 208+12008-0809-0510-0310-3111-2812-2601-16Use arrow keys to inspect data. Press Enter or Space to pin a value. Press Escape to clear.

Data source

UCI Online Retail II, dataset 502

Chen, D. (2012). Online Retail II. UCI Machine Learning Repository. https://doi.org/10.24432/C5CG6D

Licence Creative Commons Attribution 4.0 International · DOI 10.24432/C5CG6D

Scope and units

An illustrative 14-SKU subset of the source catalogue. Inventory, supplier, cost, budget, and storage figures are simulated.

Amounts are in pounds sterling because the source is a UK retailer. Dates run 2009-12-01 to 2011-12-09, so every plan here is historical.

Artifact supplylens-demo-ui-v1.0.0.

Built by

Noma Zama

Source on GitHub

Nothing here submits a purchase order or claims measured business impact.