Brand A · Sleep Aid Foil 15S

Stock Position

Real-time · gsheet Available is truth

On Hand · matches FG Inventory

1,417

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,417

+ Incoming (PO)No open POs

= Projected1,417

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

A-005

Barcode

9551234500059

Brand / Entity

Brand A

OEM

Acme Manufacturing Co

Billed by

Acme Manufacturing Co

Unit Cost

RM 8.000

Selling Price

RM 24.900

MOQ

500 units

Safety Stock

400 units

Lead Time

45 days

Qty per Carton

Shelf Life

24 months

Status

active

Sales Velocity

Calculated from movements

Last Month

441

→ vs L3M avg

L3M Avg

459

L6M Avg

452 units/month

→ vs L3M avg · healthy

Stock-Months Remaining

3.09

Available 1,417 ÷ L3M 459 = healthy

Recent Movements

Last 8 entries

Date	Brand	Warehouse	Starting	In	Out	Closing
2026-07-01	Brand A	HQ	1,976	—	-87	1,889
2026-06-01	Brand A	HQ	1,417	+1,000	-441	1,976
2026-05-01	Brand A	HQ	1,894	—	-477	1,417
2026-04-01	Brand A	HQ	1,353	+1,000	-459	1,894
2026-03-01	Brand A	HQ	1,758	—	-405	1,353
2026-02-01	Brand A	HQ	2,186	—	-428	1,758
2026-01-01	Brand A	HQ	1,190	+1,500	-504	2,186