HestaBit Illumate - MEFSCO SAP Analytics

MEFSCO - Dashboard

HestaBit

Illumate

Welcome to the HestaBit Illumate AI Assistant

Meet Illumate, your MEFSCO data expert. I am here to help you instantly get answers and insight across SAP modules covering Finance, Inventory, Maintenance, Production, Procurement, and Sales. I will also help you visualize on a realtime basis the cross module insights.

SAP Module Health Overview

Finance82%

Inventory64%

Maintenance75%

Production78%

Procurement79%

Sales85%

FI Dashboard (SAP Finance Module)

AR Risk Alert: 24% of receivables (3,369,600 SAR) are aged beyond 60 days. This exceeds the 20% threshold and represents a material working capital risk.

Revenue vs Budget

16,200,000SAR

Target: 18,600,000-12.9%

AR Aging

14,040,000SAR

24% over 60 days

AP Outstanding

8,520,000SAR

See aging breakdown below

Cash Position

5,670,000SAR

Available Liquidity

Cost Center Variance

-3.8%

vs. Budget

Working Capital

4,250,000SAR

Current Assets - Liabilities

VAT (Payable / Recoverable)

2430K / 1278KSAR

15% KSA VAT

Zakat Accrual

1,110,000SAR

Provision for Zakat

Revenue vs Budget Trend

AR Aging Breakdown (with amounts)

AP Aging Breakdown

Top Cost Center Contributors to Variance

Production Plant-6.8%

Actual: 285,000 SARBudget: 265,000 SAR

Logistics & Warehousing-4.1%

Actual: 142,000 SARBudget: 136,400 SAR

Admin & Overheads-1.2%

Actual: 114,840 SARBudget: 113,480 SAR

Cost Center Variance Trend (%)

IM Dashboard (Inventory Management)

CRITICAL: Wheat Flour (Grade A) & Vegetable Oil (Refined) -- the most critical raw materials -- are in safety stock breach. Wheat Flour has only 3 days of cover remaining. Food production operations at risk of stoppage.

Stock runs 12-20% above demand while Wheat Flour (most critical material) is in safety stock breach. Possible planning misalignment between MRP and manual reorders.

Safety Stock Breach Details -- Materials at Risk

Material	Breaches	Days of Cover	Reorder Qty	Status
Wheat Flour (Grade A)	2	3 days	180 Tons	CRITICAL
Vegetable Oil (Refined)	1	5 days	120 Tons	CRITICAL
Food Additives	1	7 days	8 Tons	WARNING
Salt (Iodized)	0	18 days	-	OK
Packaging Material	0	22 days	-	OK
Sugar	0	15 days	-	OK

Inventory Turnover

Higher is better

Stock Aging

42Days

Avg. Days in Stock

Dead Stock %

7.1%

Non-moving inventory

Safety Stock Breach

5Items

Materials below safety

Stock vs Demand

1.08Ratio

Stock / Demand coverage

MRP -- Materials at Risk This Week

Wheat Flour (Grade A)

Stock-out in 3 days

PO-2026-0412

Awaiting Approval

Vegetable Oil (Refined)

Stock-out in 5 days

PO-2026-0418

Vendor Confirmed

Food Additives

Below safety level

PR-2026-0891

Requisition Created

Batch Quality Tracking (Moisture % & Yield Impact)

Batch	Material	Moisture %	Grade	Yield Impact
WF-2026-041	Wheat Flour	12.2%	A	+1.2%
WF-2026-042	Wheat Flour	14.5%	B	-0.8%
WF-2026-043	Vegetable Oil	0.1%	C	-2.4%
SA-2026-015	Salt	1.1%	A	+0.5%

Stock vs Demand (Tons)

Inventory Turnover Trend

PM Dashboard (SAP Plant Maintenance)

Overall Equipment Effectiveness (OEE)

72.1%

OEE Score

88.5%

Availability

84.8%

Performance

96.5%

Quality

Equipment Downtime

22.4Hrs

Cumulative

MTTR

2.1Hrs

Mean Time to Repair

Preventive vs Corrective

68%

Target: 78%

Cost per Asset

75,000SAR

Cumulative

Work Order Backlog

14Orders

3 overdue

Equipment Downtime Breakdown (by Asset & Criticality)

Equipment	Func. Location	Criticality	Downtime (Hrs)
Production Line #1 (Milling)	PL-01-ML1	Class A	1.5 hrs
Mixer Unit #2	PL-01-MX2	Class A	0.8 hrs
Packaging Machine #1	PL-01-PK1	Class B	0.4 hrs
Quality Check System	PL-02-QC1	Class B	0.3 hrs
Refrigeration Unit	UT-01-REFR	Class C	0.2 hrs

Overdue Work Orders (with Equipment Criticality)

WO-4521 - Mixer Unit #2

Corrective | 3 days overdue

Class A

WO-4489 - Packaging Machine #1

Preventive | 5 days overdue

Class B

WO-4502 - Refrigeration Unit

Corrective | 2 days overdue

Class C

Downtime & MTTR Trend

Work Order Status Distribution

PP Dashboard (SAP Production Planning)

Production is -9.7% below plan. Scrap rate at 3.5% is above the 1-2% industry norm = ~58.8 tons/day lost = ~176,400 SAR daily waste.

Production vs Plan

1,680Tons

Target: 1,860-9.7%

Capacity Utilization

84.8%

Plant Utilization

Scrap Rate

3.5%

~58.8T lost = 176,400 SAR

Cycle Time

44Min

Avg. per batch

Energy / Ton

1,920kWh

Energy consumption

Production Deviation Reasons (Cross-Module Root Cause)

Jan 4: -13.5%

Production Line #1 downtime (5.2 hrs)

SAP PM

Jan 5: -16.1%

Wheat Flour safety stock breach

SAP MM

Jan 1: -11.3%

Mixer Unit corrective maintenance

SAP PM

Product-Grade Output Breakdown

Product Grade	Machine	Planned	Actual	Variance	Margin
Refined Wheat Flour	PL-1	105T	98T	-6.7%	22%
Instant Flour Mix	PL-2	120T	108T	-10.0%	15%
Baking Flour	PL-3	55T	52T	-5.5%	28%
Specialty Flour	PL-1	30T	27T	-10.0%	18%

Production vs Plan Trend

Energy Consumption per Ton (kWh)

Cycle Time Trend (Minutes)

Output Variance Trend (%)

MM Dashboard (Procurement)

PO Cycle Time

5.8Days

Internal SAP processing

Vendor Performance

79/100

Supplier Score

Purchase Price Variance

-3.1%

Favorable (below std cost)

Contract Compliance

85%

Target: 90% | Gap: 5%

Total Spend

17,400,000SAR

All categories

Supplier Concentration Risk

Supplier	Material	Share	Risk
Arabian Grain Trading	Wheat Flour	45%	HIGH
Gulf Food Suppliers	Wheat Flour	25%	MEDIUM
Middle East Commodities	Wheat Flour	15%	LOW
Al Mansour Trading	Vegetable Oil	10%	LOW
Others	Various	5%	LOW

Materials in Transit (Import Lead Times)

Wheat Flour (Premium) -- Arabian Grain Trading

PO-4521 | Origin: Australia

ETA: 18 days

1,200,000 SAR

Vegetable Oil (Refined) -- Gulf Food Suppliers

PO-4535 | Origin: Malaysia

ETA: 24 days

850,000 SAR

Flour Mix -- Middle East Commodities

PO-4542 | Origin: Ukraine

ETA: 32 days

680,000 SAR

Contract Compliance by Vendor Category

PPV Trend (Negative = Favorable)

Spend by Category (SAR)

SD Dashboard (SAP Sales & Distribution)

Sales vs Target

18,400,000SAR

Target: 21,000,000-12.4%

Margin %

17.8%

Gross Margin

Top Distributor

4,920,000SAR

Al Rajhi Trading

Top SKU

30%

Refined Wheat Flour

Domestic / Export

70% / 30%

KSA / GCC Split

Region Performance (SAR) -- Named Regions

Margin per SKU (Revenue & Profit Contribution)

SKU	Revenue	Margin
Copy Paper A4	1024K	22.1%
Kraft Paper	768K	17.8%
Tissue Base	576K	28.4%
Corrugated Medium	480K	14.6%
Specialty Grade	352K	31.2%

Domestic (KSA) vs GCC Export Split

Seasonal Demand Comparison (Daily Avg. SAR)

Distributor Performance (SAR)

SKU Volume Contribution (%)

Cross-Module Intelligence

Sales (SAR K) vs Production Output (Tons)

Inventory Level (Tons) vs Sales Velocity (SAR K)

Procurement Spend (SAR K) vs Margin Impact (%)

Maintenance Downtime (Hrs) vs Production Output (Tons)

Financial Impact of Inventory Aging (SAR K)