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

Sales insights

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

Reads the nightly snapshot, not the live DB.

Revenue — delivered

7.79M MYR

▲ +6.2% vs prior 12 wks

280 delivered SOs · MTD 312,450

COGS

2.40M MYR

30.8% of revenue

2,401,219.93 · tax 407.63

Profit

5.39M MYR

▲ +8.1% vs prior 12 wks

5,386,444.38 all-time delivered

Profit margin

69.2%

▲ +34.2 pts vs 35% target

blended, delivered orders

Open SO book

527,909 MYR

15 open SOs

+ CRM pipeline 823,000

Revenue vs profit — last 12 weeks

Revenue Profit Margin %

Weekly delivered revenue & profit, MYR · margin panel vs 35% target

020K40K60K80K 040%80% target 35% 76.8K36.6K25.3K69.1% Apr 20May 4May 18Jun 1Jun 15Jun 29 Week of Apr 20 — Revenue 42,300 · Profit 30,000 · Margin 70.9%Week of Apr 27 — Revenue 18,600 · Profit 12,100 · Margin 65.1%Week of May 4 — Revenue 55,100 · Profit 39,700 · Margin 72.1%Week of May 11 — Revenue 30,900 · Profit 21,000 · Margin 68.0%Week of May 18 — Revenue 9,400 · Profit 5,450 · Margin 58.0%Week of May 25 — Revenue 63,700 · Profit 45,900 · Margin 72.1%Week of Jun 1 — Revenue 27,200 · Profit 18,200 · Margin 66.9%Week of Jun 8 — Revenue 76,800 · Profit 56,100 · Margin 73.0%Week of Jun 15 — Revenue 48,000 · Profit 33,600 · Margin 70.0%Week of Jun 22 — Revenue 21,500 · Profit 13,800 · Margin 64.2%Week of Jun 29 — Revenue 58,400 · Profit 41,500 · Margin 71.1%Week of Jul 6 — Revenue 36,600 · Profit 25,300 · Margin 69.1%

Orders delivered by week — last 12 weeks

Count of SOs reaching Delivered per ISO week · 63 in period, 280 all-time

0510 Week of Apr 20 — 5 orders Week of Apr 27 — 3 orders Week of May 4 — 7 orders Week of May 11 — 4 orders Week of May 18 — 2 orders Week of May 25 — 8 orders Week of Jun 1 — 4 orders Week of Jun 8 — 9 orders Week of Jun 15 — 6 orders Week of Jun 22 — 3 orders Week of Jun 29 — 7 orders Week of Jul 6 — 5 orders 9 Apr 20May 4May 18Jun 1Jun 15Jun 29

Top customers — delivered revenue

All-time, MYR · share of 7,788,071.92

NatusVincere Marketing3,214,500 · 41%
Yes Global1,478,900 · 19%
Aureca942,300 · 12%
TSL Distribution611,750 · 8%
All others (34 customers)1,540,621.92 · 20%

Low-margin products — needs a look

Blended margin below 25% · sample SOs invoiced at 0 MYR drive the negatives

AlphaMax V+ — sample runs−100%

0.00 MYR revenue · 1,240 pcs shipped as samples

Sunrise — FOC replacements−100%

0.00 MYR revenue · 380 pcs free-of-charge

Sleep Gummies12.6%

launch pricing below list

JuicyPop — OEM run21.9%

contract-priced OEM batch

Top products by revenue — delivered SO lines, all-time · reconciles to 7,788,071.92 MYR
Product Qty delivered (pcs) Revenue (MYR) Share Margin
AlphaMax V+41,2002,455,300.0031.5%73.8%
AlphaMax M+29,7501,731,450.0022.2%71.2%
Double Root18,4001,204,880.0015.5%68.4%
JuicyPop96,000892,610.0011.5%61.9%
Sunrise22,300671,240.008.6%66.0%
Taurus9,850458,930.005.9%64.1%
All others (incl. Sleep Gummies)31,480373,661.924.8%41.3%
Total — delivered248,9807,788,071.92100%69.2%

Project Gaia — static mockup in Filament v3 idiom. No backend. Totals are the real snapshot figures (7,788,071.92 delivered revenue · 5,386,444.38 profit · 527,908.70 open book); weekly splits and per-product breakdowns are illustrative but reconcile to those totals.

Sales insights — field manifest

WidgetSource query (in words)
Revenue / COGS / Profit / Margin tilesSUM of fact_sales rows (delivered so_lines joined to item cost at ship date) — all-time delivered; margin = profit ÷ revenue. MTD figure is the same fact filtered to dim_week in the current month.
Open SO book tileSUM of so_lines on SOs not yet delivered/cancelled at snapshot time (15 SOs → 527,908.70); pipeline figure reads CRM opportunities marked open.
Revenue vs profit chartfact_sales grouped by dim_week, last 12 ISO weeks; margin panel = weekly profit ÷ weekly revenue vs the 35% target constant.
Orders by week chartCOUNT(DISTINCT so_id) of SOs reaching Delivered, grouped by dim_week, last 12 weeks.
Top customers bar-listfact_sales grouped by dim_customer, ordered by revenue DESC, top 4 + "All others" fold.
Low-margin products bar-listfact_sales grouped by dim_item HAVING blended margin < 25%; sample/FOC SOs invoiced at 0 MYR surface here as −100%.
Top products tablefact_sales grouped by dim_item, ORDER BY revenue DESC LIMIT 6 + "All others" remainder row; footer reconciles to the tile totals.

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.
  • Every chart has a table or labelled-list twin on the page, so no value is gated behind color or hover.