Lemonhaus — Inventory Management

Simulation · live-looking sample data

Warehouse overview

3 warehouses · 1,096 active SKUs · Last sync 2 min ago

Inventory healthy4 SKUs low1 stock-out

Total units on hand

3,716

▲ 4.1% MoM

Inventory value

$2.96M

▲ $118k MoM

Incoming (30d)

2,500

7 open POs

Days of cover

41d

▼ 3d vs prior mo

Turn rate (annualized)

8.9×

▲ 0.4×

Fill rate

97.4%

▲ 0.6 pts

Shrinkage (30d)

0.42%

▼ 0.11 pts

Stock-outs (30d)

▲ 1 vs prior mo

Ask the AI

Lovable AI · Gemini

Hi Sam. Inventory is up 4.1% MoM and 3 SKUs need attention today. Try one of the prompts below or ask anything about stock, vendors, or reorders.

Simulated responses. In production, this assistant queries live warehouse & ERP data through Lovable AI Gateway.

AI Insights

Lovable AI

Stock-outFragrance

Lemongrass Room Spray hit zero this morning at AT-03. A 600-unit PO arrives Jul 08 — expedite to Jul 05 to avoid 4 days of lost sales (~$3.2k).

WatchBath

Citrus Hand Soap velocity is up 31% WoW. Current cover is 3 days — recommend raising reorder point from 300 → 450.

OpportunityGifts

Peel & Pith Gift Set trending down 27% — pull 120 units to SF-01 for the Q3 corporate gifting campaign.

Units moved — trailing 12 months

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Total: 48,320 units

Peak: Dec (5,100)

YoY: +22%

Warehouse utilization

SF-01 San Francisco

412 SKUs · $1.24M

82% of capacity

NY-02 Brooklyn

388 SKUs · $980k

67% of capacity

AT-03 Atlanta

296 SKUs · $742k

91% of capacity

Stock by SKU

SKU	Product	Warehouse	On hand	Stock level	Incoming	Status
LM-001	Lemon Zest Candle 8oz Home	SF-01	1,420	reorder @ 500 · max 2000	—	Healthy
LM-014	Citrus Hand Soap 12oz Bath	SF-01	180	reorder @ 300 · max 1500	+800	Reorder
LM-027	Meyer Diffuser Reeds Home	NY-02	62	reorder @ 150 · max 900	+400	Reorder
LM-033	Bergamot Body Butter Bath	NY-02	940	reorder @ 250 · max 1400	—	Healthy
LM-045	Lemongrass Room Spray Home	AT-03	0	reorder @ 200 · max 1200	+600	Stock-out
LM-058	Sicilian Lemon Cologne Fragrance	SF-01	310	reorder @ 120 · max 800	—	Healthy
LM-061	Yuzu Shower Gel Bath	AT-03	720	reorder @ 300 · max 1600	+500	Healthy
LM-072	Peel & Pith Gift Set Gifts	NY-02	84	reorder @ 100 · max 500	+200	Reorder

Open purchase orders

PO #	Vendor	Items	Value	ETA	Status
PO-10241	Amalfi Supply Co.	4	$18,420	Jul 08	In Transit
PO-10238	Meyer Botanicals	2	$6,180	Jul 06	In Transit
PO-10233	Cedarwood Packaging	6	$24,900	Jul 11	Confirmed
PO-10229	Verde Essentials	3	$9,340	Jul 04	Delayed
PO-10221	Amalfi Supply Co.	5	$21,760	Jul 02	Received

Reorder suggestions

AI-generated

Citrus Hand Soap 12oz

LM-014 · SF-01 · 3d cover

Low

Order 1,650 units

Meyer Diffuser Reeds

LM-027 · NY-02 · 3d cover

Low

Order 540 units

Lemongrass Room Spray

LM-045 · AT-03 · 0d cover

Out

Order 990 units

Peel & Pith Gift Set

LM-072 · NY-02 · 3d cover

Low

Order 660 units