Your Company · Products · Brand A · A-001

A-001 · BRAND A

Brand A · Vitality Powder 30S

Stock Position

Real-time · gsheet Available is truth

On Hand · matches FG Inventory

6,557

as of 06 Jul, 23:09 · healthy vs safety: 800

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

Projected after PO + commitments

Opening

6,557

+ Incoming (PO)No open POs

= Projected6,557

Committed (as record)1 wms_order

300

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

A-001

Barcode

9551234500011

Brand / Entity

Brand A

OEM

Acme Manufacturing Co

Billed by

Acme Manufacturing Co

Unit Cost

RM 12.500

Selling Price

RM 39.900

MOQ

1,000 units

Safety Stock

800 units

Lead Time

45 days

Qty per Carton

Shelf Life

24 months

Status

active

Sales Velocity

Calculated from movements

Last Month

2,352

→ vs L3M avg

L3M Avg

2,448

L6M Avg

2,412 units/month

→ vs L3M avg · healthy

Stock-Months Remaining

2.56

Available 6,257 ÷ L3M 2,448 = healthy

Recent Movements

Last 8 entries

Date	Brand	Warehouse	Starting	In	Out	Closing
2026-07-01	Brand A	HQ	9,208	—	-465	8,743
2026-06-01	Brand A	HQ	7,560	+4,000	-2,352	9,208
2026-05-01	Brand A	HQ	10,104	—	-2,544	7,560
2026-04-01	Brand A	HQ	7,552	+5,000	-2,448	10,104
2026-03-01	Brand A	HQ	9,712	—	-2,160	7,552
2026-02-01	Brand A	HQ	6,992	+5,000	-2,280	9,712
2026-01-01	Brand A	HQ	9,680	—	-2,688	6,992