Brand C · Honey Lemon Tea 30s

Stock Position

Real-time · gsheet Available is truth

On Hand · matches FG Inventory

1,071

as of 06 Jul, 23:10 · healthy vs safety: 400

This is what your warehouse currently holds. Incoming POs don't roll in until the next daily upload.

Projected after PO + commitments

Opening

1,071

+ Incoming (PO)No open POs

= Projected1,071

Committed (as record)No commitments

Already deducted in gsheet Available — shown here for visibility only.

Informational only. Available stays at On Hand until you record the PO receipt.

Product Master & Purchase Metrics

Static fields + calculated metrics

SKU

C-002

Barcode

9551234700021

Brand / Entity

Brand C

OEM

Pacific Foods Sdn Bhd

Billed by

Pacific Foods Sdn Bhd

Unit Cost

RM 9.000

Selling Price

RM 28.900

MOQ

800 units

Safety Stock

400 units

Lead Time

45 days

Qty per Carton

Shelf Life

18 months

Status

active

Sales Velocity

Calculated from movements

Last Month

510

→ vs L3M avg

L3M Avg

530

L6M Avg

523 units/month

→ vs L3M avg · low — draft PO suggested

Stock-Months Remaining

2.02

Available 1,071 ÷ L3M 530 = low — draft PO suggested

Recent Movements

Last 8 entries

Date	Brand	Warehouse	Starting	In	Out	Closing
2026-07-01	Brand C	HQ	1,529	—	-101	1,428
2026-06-01	Brand C	HQ	2,039	—	-510	1,529
2026-05-01	Brand C	HQ	2,590	—	-551	2,039
2026-04-01	Brand C	HQ	1,520	+1,600	-530	2,590
2026-03-01	Brand C	HQ	1,988	—	-468	1,520
2026-02-01	Brand C	HQ	2,482	—	-494	1,988
2026-01-01	Brand C	HQ	1,464	+1,600	-582	2,482