G Gaia

Switch factory

CYTO-11 — Balakong Jaya CTSB CYTO-29 CTSB CYTOWELL-54 — Taming Jaya PIC/S CTWSB CYTOCNGZ-602 — Guangzhou CTCNGZ

Only factories you are granted appear here (Filament tenant menu).

Leo Lim

leo@navi.my · Owner / Admin

Profile settings Change password

Theme

Sign out
RetailSellR&DMakeBuyStockPlanItemsGMPAdminInsights
Sales Production Purchasing Inventory Retail

Production insights

Data refreshed at 08:00 · 2026-07-07

Reads the nightly snapshot, not the live DB.

Output this month

8,120 pcs

▲ +12% vs same days in Jun

Jul 1–7 · done task quantities

Yield — done tasks

94.9%

65,163 of 68,640 pcs planned

all-time, completed tasks

On-time MO rate

75%

▼ 3 of 4 — YGMSB-260401/1 overdue

open MOs vs planned dates

Machine utilisation

46%

▼ −14 pts vs 60% plan

5 machines · snapshot month

Machines down

1

✕ FL-02 — MWO-26-034 blocks 2 MOs

3 maintenance programs overdue

Output by week — last 12 weeks

Done task quantities per ISO week, pcs · 63,160 pcs in period

02K4K6K8K Week of Apr 20 — 4,800 pcs Week of Apr 27 — 5,600 pcs Week of May 4 — 3,150 pcs Week of May 11 — 6,240 pcs Week of May 18 — 5,020 pcs Week of May 25 — 4,410 pcs Week of Jun 1 — 7,680 pcs Week of Jun 8 — 5,910 pcs Week of Jun 15 — 3,880 pcs Week of Jun 22 — 6,300 pcs Week of Jun 29 — 5,480 pcs Week of Jul 6 — 4,690 pcs 7,680 Apr 20May 4May 18Jun 1Jun 15Jun 29

Machine utilisation — snapshot month

▏ site average 46%

machine_usage_logs hours ÷ available hours · status from the maintenance register

FL-01 — Sachet Filling Line 1● Running84%
MX-01 — Mixer● Running72%
PK-01 — Packing Line● Running66%
CP-01 — Capsule Filler▲ Maintenance38%

calibration overdue 12 d — dosing discs

FL-02 — Sachet Filling Line 2✕ Down12%

dosing pump failure — MWO-26-034, part ETA tomorrow · 2 MOs blocked

MO cycle times — last 5 done MOs (created → done) + the 4 open MOs (24,720 pcs planned)
MO Product Planned (pcs) Actual (pcs) Yield Created Done Cycle Status
MO-26-081AlphaMax V+12,00011,46095.5%2026-06-182026-06-279 d✓ Done
MO-26-078JuicyPop24,00022,73094.7%2026-06-052026-06-1712 d✓ Done
MO-26-075Double Root8,6408,20595.0%2026-05-262026-06-027 d✓ Done
MO-26-071Sunrise6,0005,74595.8%2026-05-142026-05-206 d✓ Done
MO-26-068Taurus4,0003,89097.3%2026-05-062026-05-115 d✓ Done
YGMSB-260401/1AlphaMax M+10,000——2026-04-01—97 d openOverdue
MO-26-088Sleep Gummies7,200——2026-06-30—7 d openBlocked — MWO-26-034
MO-26-089JuicyPop5,400——2026-07-01—6 d openBlocked — MWO-26-034
MO-26-090Sunrise2,120——2026-07-03—4 d openScheduled

Open MOs total 24,720 pcs planned. Yield on done MOs mirrors the 94.9% site figure; cycle time = working days between MO created and last task done.

Project Gaia — static mockup in Filament v3 idiom. No backend. Yield (65,163 / 68,640 = 94.9%), utilisation per machine and the 4 open MOs (24,720 pcs, YGMSB-260401/1 overdue, MWO-26-034 blocking 2) are the real snapshot figures; weekly output split is illustrative.

Production insights — field manifest

WidgetSource query (in words)
Output this month tileSUM of done-task quantities in fact_production for the current month (built from production task logs at snapshot time).
Yield tileSUM(actual done qty) ÷ SUM(planned qty) over all completed production tasks — 65,163 / 68,640 pcs = 94.9%.
On-time MO tileOpen MOs compared to their planned completion dates: 3 of 4 within plan; YGMSB-260401/1 past due since April.
Utilisation tile + bar-listmachine_usage_logs hours per machine ÷ available hours in the snapshot month; status chip joins the maintenance register (down = open breakdown WO, maintenance = overdue program).
Output by week chartfact_production done-task quantities grouped by dim_week, last 12 ISO weeks.
MO cycle tableDone MOs: days between created_at and last task done_at, with planned vs actual quantities from MO lines; open MOs listed with age and blocking WO if any.

Engine notes

  • Insights is a nightly materialized star-schema snapshot, not the live DB: fact tables are rebuilt from so_lines / retail_sale_lines / stock_movements / machine_usage_logs / maintenance_logs; dimensions are customer, item, category, site and week. "Refresh now" re-runs the materializer on demand.
  • Filament: these are custom Livewire pages with chart components (Blade + inline SVG), NOT Resources — read-only, no table actions, no forms.
  • No new operational tables: the snapshot lives in insights_* tables that can be dropped and rebuilt at any time; nothing operational writes to them.
  • Machine status is never color-alone — every chip pairs an icon and a label with the bar hue.