SKU Forecast

Clearstock forecast for all SKUs.

Based on actual monthly sell-through, computes daily sell rate per SKU and compares against required pace to clear stock before lot expiry.

KPI Forecast

Total SKUs

32

At Risk

11

Watch

0

Stock on Hand

163,218

Period: May 2026·Elapsed: 23/31 days·Remaining: 8 days
HB006

GLUTA WHITE (C/30V) (CHLC)

At risk
Lot date2026-08-22(90d)

Stock on Hand

7,333

Sold This Period

229

Current Pace

10/day

Required Pace

81.5/day

-71.5/day→ push 2,445/mo
HB031

HB COQ10 150MG (C/30V) (CHLC)

At risk
Lot date2027-01-27(248d)

Stock on Hand

13,373

Sold This Period

113

Current Pace

4.9/day

Required Pace

53.9/day

-49/day→ push 1,618/mo
HB009

OMEGA 3.6.9 (C/100V) (HTG)

At risk
Lot date2028-03-08(654d)

Stock on Hand

20,270

Sold This Period

470

Current Pace

20.4/day

Required Pace

31/day

-10.6/day→ push 930/mo
HB037

HBGUTCARE (C/30V) (CHLC)

At risk
Lot date2028-02-16(633d)

Stock on Hand

10,636

Sold This Period

154

Current Pace

6.7/day

Required Pace

16.8/day

-10.1/day→ push 504/mo
HB036

HB GINKGO BILOBA 120MG (H/60V) (CHLC)

At risk
Lot date2028-02-18(635d)

Stock on Hand

10,434

Sold This Period

195

Current Pace

8.5/day

Required Pace

16.4/day

-8/day→ push 493/mo
HB007

SLIM DAY (C/60V) (CHLC)

At risk
Lot date2027-11-08(533d)

Stock on Hand

6,046

Sold This Period

138

Current Pace

6/day

Required Pace

11.3/day

-5.3/day→ push 341/mo
HB028

HB BLACKHAIR (C/30V) (CHLC)

At risk
Lot date2028-10-28(888d)

Stock on Hand

5,770

Sold This Period

42

Current Pace

1.8/day

Required Pace

6.5/day

-4.7/day→ push 195/mo
HB038

HBGUTCARE (H/60V) (BT)

At risk
Lot date2028-02-16(633d)

Stock on Hand

3,534

Sold This Period

40

Current Pace

1.7/day

Required Pace

5.6/day

-3.8/day→ push 168/mo
HB026

HB BLACKHAIR (C/60V) (BT)

At risk
Lot date2028-10-28(888d)

Stock on Hand

4,531

Sold This Period

36

Current Pace

1.6/day

Required Pace

5.1/day

-3.5/day→ push 153/mo
HB034

HB PRENATAL SUPPORT (H/60V) (CHLC)

At risk
Lot date2027-12-28(583d)

Stock on Hand

4,983

Sold This Period

136

Current Pace

5.9/day

Required Pace

8.6/day

-2.6/day→ push 257/mo
HB018

HB ARGINMILK PLUS (H/60V) (HTG)

At risk
Lot date2027-11-30(555d)

Stock on Hand

5

Sold This Period

-1

Current Pace

-0/day

Required Pace

0/day

-0.1/day→ push 1/mo
HB015

HB CORDY EXTRACT (C/60V) (BT)

Healthy
Lot date2028-01-26(612d)

Stock on Hand

9,327

Sold This Period

351

Current Pace

15.3/day

Required Pace

15.2/day

+0/day→ push 458/mo
HB004

HB GLUCOSAMINE 3 IN 1 (C/200V) (HTG)

Healthy
Lot date2028-05-13(720d)

Stock on Hand

2,692

Sold This Period

87

Current Pace

3.8/day

Required Pace

3.7/day

+0/day→ push 113/mo
HB033

HB PRENATAL SUPPORT (C/30V) (BT)

Healthy
Lot date2026-07-22(59d)

Stock on Hand

15

Sold This Period

10

Current Pace

0.4/day

Required Pace

0.3/day

+0.2/day→ push 8/mo
HB001

HB COLLAGEN TYPE 1,2&3 (C/120V) (CHLC)

Healthy
Lot date2027-08-15(448d)

Stock on Hand

2,086

Sold This Period

120

Current Pace

5.2/day

Required Pace

4.7/day

+0.6/day→ push 140/mo
HB011

OMEGA 3.6.9 (C/200V) (HTG)

Healthy
Lot date2028-03-08(654d)

Stock on Hand

3,146

Sold This Period

132

Current Pace

5.7/day

Required Pace

4.8/day

+0.9/day→ push 145/mo
HB003

GLUCOLLAGEN 7 IN 1 (C/60V) (CHLC)

Healthy
Lot date2027-04-24(335d)

Stock on Hand

8,036

Sold This Period

675

Current Pace

29.4/day

Required Pace

24/day

+5.4/day→ push 720/mo
HB030

HB GLUTATHION - C PLUS (H/30V) (CHLC)

Healthy
Lot date2027-08-26(459d)

Stock on Hand

6,755

Sold This Period

519

Current Pace

22.6/day

Required Pace

14.7/day

+7.9/day→ push 442/mo
HB039

HB PRENATAL SUPPORT (H/30V) (CHLC)

Healthy
Lot date2027-12-28(583d)

Stock on Hand

6,688

Sold This Period

477

Current Pace

20.7/day

Required Pace

11.5/day

+9.3/day→ push 345/mo
HB035

HB GINKGO BILOBA 120MG (C/30V) (BT)

Healthy
Lot date2028-02-18(635d)

Stock on Hand

10,539

Sold This Period

676

Current Pace

29.4/day

Required Pace

16.6/day

+12.8/day→ push 499/mo
HB002

GLUCOLLAGEN 7 IN 1 (C/30V) (BT)

Healthy
Lot date2027-04-24(335d)

Stock on Hand

3,135

Sold This Period

623

Current Pace

27.1/day

Required Pace

9.4/day

+17.7/day→ push 281/mo
HB025

HB CALCIDSOFT (H/60V) (BT)

Healthy
Lot date2028-06-16(754d)

Stock on Hand

15,753

Sold This Period

907

Current Pace

39.4/day

Required Pace

20.9/day

+18.5/day→ push 627/mo
HB005

HB GLUCOSAMINE 3 IN 1 (C/60V) (HTG)

Healthy
Lot date2028-05-13(720d)

Stock on Hand

7,952

Sold This Period

847

Current Pace

36.8/day

Required Pace

11/day

+25.8/day→ push 332/mo
HB024

HB CALCIDSOFT (H/30V) (BT)

Healthy
Lot date2027-10-26(520d)

Stock on Hand

179

Sold This Period

1,064

Current Pace

46.3/day

Required Pace

0.3/day

+45.9/day→ push 11/mo

* Current Pace = total sold ÷ elapsed days. Required Pace = stock on hand ÷ days until lot expiry.