APEX — Inventory

Inventory Management

Synced from Bysinc Infotech · Last updated 2 min ago

Total SKUs Tracked

Across 6 categories

Items Below Par Level

3 critical · 2 watch

Inventory Variance Cost

RM 4,820

This week · up RM 840 WoW

Total Stock Value

RM 84,240

Working capital tied up

Weekly Purchases

RM 31,480

↓ 4.2% vs last week

▲

APEX Inventory Intelligence

Three items are generating 91% of this week's RM 4,820 variance cost: Beef Short Ribs (14.2% shrinkage, RM 1,840), Butter (12.3%, RM 890), and Kaffir Lime Leaf (11.6%, RM 420). The beef and butter issues are concentrated at Bangsar and Cheras — pointing to a portioning or kitchen discipline gap at those two outlets, not a supply problem.

Stock Overview

Consumption vs Theoretical

Waste & Variance

Suppliers & Orders

All Inventory Items

3 Critical 5 Watch

SKU	Item	Category	Stock on Hand	Daily Usage	Days Left	Par Level	Shrinkage	Unit Cost	Action

Theoretical vs Actual Consumption

This Week · Chain

How This Works

Theoretical Consumption

Calculated from your recipe cards × covers sold from POS. This is what the kitchen should have used if every dish was made exactly to recipe.

Actual Consumption

Opening stock + deliveries received − closing stock count from Bysinc. This is what was actually used, including all waste, portioning errors, and unrecorded use.

The Gap = Variance

Actual − Theoretical = unexplained consumption. This gap represents a mix of: portion drift, unrecorded waste, kitchen cross-use, or theft. APEX flags anything above 5%.

Why This Matters

Without linking recipes to inventory, you can only see total spend — not which specific dish or outlet is leaking cost. This connection is what makes your food cost actionable.

Item-Level Consumption Detail

This Week

Item	Opening Stock	Received	Closing Stock	Theo. Consumed	Actual Consumed	Variance Qty	Variance %	Variance RM	Status
Beef Short Ribs	14.2 kg	12.0 kg	4.1 kg	19.0 kg	22.1 kg	+3.1 kg	14.2%	+RM 119
Butter (unsalted)	3.4 kg	3.5 kg	1.8 kg	4.6 kg	5.1 kg	+0.5 kg	12.3%	+RM 24
Kaffir Lime Leaf	0.8 kg	1.0 kg	0.4 kg	1.2 kg	1.4 kg	+0.2 kg	11.6%	+RM 4
Salmon Fillet	4.2 kg	3.8 kg	2.4 kg	5.2 kg	5.6 kg	+0.4 kg	6.2%	+RM 27	Monitoring
Baby Spinach	2.8 kg	3.0 kg	1.2 kg	4.2 kg	4.6 kg	+0.4 kg	8.4%	+RM 5	Check shelf-life
Chicken Breast	18.0 kg	21.0 kg	9.2 kg	28.1 kg	29.8 kg	+1.7 kg	6.0%	+RM 27	Monitoring
Prawns (Tiger 21/25)	9.8 kg	8.4 kg	4.6 kg	13.3 kg	13.6 kg	+0.3 kg	2.3%	+RM 16	Normal
Jasmine Rice	108 kg	55 kg	52 kg	109.4 kg	111 kg	+1.6 kg	1.4%	+RM 7	Normal
Coconut Milk	72 tins	58 tins	28 tins	99.4 tins	102 tins	+2.6	2.6%	+RM 11	Normal

Shrinkage % by Item

Top offenders

Variance RM Cost — by Outlet

This Week

Outlet Variance Comparison — Which Outlet Has the Problem?

Same item, different outlets

Item	Bangsar	KLCC	Sunway	Mont Kiara	Damansara	Cheras	Insight
Beef Short Ribs	16.8%	2.1%	1.8%	2.4%	3.1%	11.6%	Bangsar & Cheras chefs only — portioning issue
Butter	18.4%	3.2%	4.1%	6.8%	2.9%	14.2%	Same two outlets — same chef team?
Kaffir Lime Leaf	9.2%	8.4%	7.1%	6.8%	4.2%	9.8%	Chain-wide — delivery freshness or storage issue
Salmon Fillet	4.1%	8.2%	3.8%	4.4%	3.9%	4.2%	KLCC only — review trimming technique
Chicken Breast	7.4%	3.2%	4.1%	2.8%	3.6%	5.8%	Slight elevation at Bangsar — consistent with other flags

APEX PATTERN DETECTED

Bangsar and Cheras share variance spikes across multiple high-value proteins. This is unlikely to be a supply issue — it points to a kitchen discipline or training gap at these two outlets. A single coaching visit + portion scale audit would likely resolve 70% of the variance cost.

Weekly Spend by Supplier

Price Movement — Key Proteins

Last 8 weeks

Supplier Directory

6 active

Supplier	Items Supplied	Weekly Spend	Delivery Lead Time	Accuracy	Price Stability	Status
Dindings Poultry	Chicken breast, chicken thigh	RM 8,420	Next-day	96%	Stable	Active
Agro Food Sdn Bhd	Beef short ribs, beef mince	RM 6,840	2 days	89%	↑ 4.2% this month	Monitor
Ocean Fresh	Tiger prawns, cockles, salmon	RM 9,120	Same-day	93%	Stable	Active
Cameron Highland Fresh	Baby spinach, cherry tomato, herbs	RM 2,840	Next-day	82%	Stable	Delivery gaps
Bernas	Jasmine rice, flour, dry goods	RM 3,840	3 days	98%	Stable	Active
Anchor Dairy	Butter, whipping cream	RM 4,240	2 days	91%	↑ 6.8% this month	Price alert

Purchase Orders

3 pending+ New PO

PO-2847 · Dindings Poultry

50kg chicken breast — Bangsar urgent reorder

RM 800

Due: Thu 8am

Pending Confirm

PO-2846 · Ocean Fresh

24kg tiger prawns, 8kg salmon fillet — chain restock

RM 4,100

Due: Wed 7am

In Transit

PO-2845 · Bernas

10 bags jasmine rice, assorted dry goods

RM 620

Delivered Mon

Received ✓

PO-2844 · Anchor Dairy

5kg butter, 4L whipping cream

RM 288

Delivered Mon

Received ✓