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
Requests Formulations Lab trials
← R&D requests / RND-2026-00011 — Collagen coffee blend

RND-2026-00011

Sample sent CTSB
Requested → In development → Sample sent · current → Confirmed | Cancelled

Feedback FAIL loops Sample sent → In development (trial # increments). Design is a parallel side-track — it never gates this flow; costing lives inside In development.

Request info

filled by Sales at creation
Customer
Wellness Mart Sdn Bhd
Contact person
James Tan
Contact number
012-345-6789
Product type
Sachet
Target ingredients
Collagen, Coffee, Creamer
Reference product
“Something like Brand X collagen coffee”
Target price point
RM 12–15 per box
Target quantity
5,000 boxes / month
Requested
2026-03-15
Deadline (the only priority)
2026-04-20
Factory
Cyto Tech Sdn Bhd (CT1)

Client context

Visible to Sales + Boss + R&D lead ONLY
Budget-sensitive client. Prefers cheaper packaging. Previously ordered from competitor but unhappy with taste. Wants quality but won't pay premium. James is the decision maker — responds slow on WhatsApp. Boss (Mr. Lim) overrides James sometimes. Expect 2-3 rounds of revisions minimum.

Section-level visibility policy — hidden from FM / QC / QA / operators.

Progress log · newest first

  • Status

    In development → Sample sent. Sent 2 sachets via Pos Laju (EH123456789MY). Customer to taste test this week.

    2026-04-10 · Siti · auto-logged on Advance stage

  • Trial 2

    Reduced Tongkat Ali to 150mg (was 200mg). Added vanilla masking flavor 50mg. Changed capsule to size 0. Taste much improved. Sample approved for sending.

    2026-04-08 · Siti

  • Remark

    Customer called — boss is pushing. Promised by Apr 10.

    2026-04-01 · Sales

  • Trial 1

    Tongkat Ali 200mg + Coffee 7.5g + Creamer 4g. Bitter, overpowering. FAIL — reformulate.

    2026-03-25 · Siti

  • Status

    Requested → In development

    2026-03-20 · Siti · auto-logged

  • Status

    — → Requested. Created by Sales (customer tagged).

    2026-03-15 · James (Sales) · auto-logged

Entry types: Status (auto-logged on stage change) · Trial (trial # auto-increments) · Remark · Feedback. Trial material quantities live here — no stock deduction (founder decision).

Status history

derived from progress log · read-only
Date Change Elapsed
2026-04-10 In development → Sample sent 26 days
2026-03-20 Requested → In development 5 days
2026-03-15 — → Requested —

Drives the two KPI clocks: internal = Σ In development (21d here) · awaiting feedback = Σ Sample sent (2d and counting — customer clock, tracked separately, not R&D's fault).

Draft ingredients · informal, pre-BOM

enabled when Status = Confirmed
Draft only — no stock tracking, no deduction; free text allowed. “Create BOM” copies valid item links into the recipe; free-text lines get created via quick entry.
Ingredient Qty UoM Note
Tongkat Ali Extract 150 mg reduced after Trial 1
Instant Coffee Powder 7,500 mg —
Non-Dairy Creamer 4,000 mg —
Vanilla Masking Flavor free text — not in item master yet 50 mg Added Trial 2. Not in item master yet
Sachet Film (15g) 1 pc —

Assignment

SA

Siti Aminah

PIC · R&D lead

LW

Lee Wei Ming

Designer

Sample tracking

Sent
Sample qty
2 sachets
Ship date
2026-04-10
Courier
Pos Laju
Tracking no.
EH123456789MY
Customer feedback
Awaiting feedback

Feedback = Approved is required before Confirmed.

Design track

parallel — does not gate R&D

Draft v2
  • Brief sent2026-03-20
  • Draft v22026-04-02
  • Approvedpending
Designer
Lee Wei Ming
Artwork file
wm-coffee-box_v2.pdf

Side-track advanced by the designer concurrently (Brief sent → Draft vN → Approved) — never blocks the R&D status.

Costing

part of development — updated during sourcing/trials

Not started
Est. RM cost
—
Production cost
—
Total est. cost
—

No separate Costing stage — fills during In development; feeds the quote (quotes.html — “Awaiting R&D” lane).

Confirmation

Not confirmed
Confirmed date
—
Confirmed by
—

Requires sample feedback = Approved. On Confirmed, “Create BOM from draft” unlocks and the deal moves to quote / SO.

Project Gaia — static mockup in Filament v3 idiom. No backend. Founder's worked example (snapshot 2026-04-12); appears in rnd-requests.html as the Sample sent row.

R&D request detail — field manifest

FieldFilament componentTypeSourceFK target
Request info sectionSection → TextInput / Select / DatePickermixedstored: rnd_requests — customer_id, contact_name, contact_phone, product_type enum, target_ingredients text, reference_product text, target_price text, target_qty text, requested_date, deadline, factory_id (tenant)customers / factories
Client contextTextarea in Section::visible(fn)textstored: rnd_requests.client_context — section-level visibility policy: Sales + Boss + R&D lead only; hidden from FM / QC / QA / operators (never rendered, not just disabled)—
AssignmentSelect → usersFK ×2stored: pic_user_id, designer_user_idusers.id
Progress logRelationManager (repeater rows)child tablestored: rnd_progress_log — date, by_user_id, type enum (Status / Trial / Remark / Feedback), trial_no (auto-increment when type = Trial), text. Status changes auto-logged by the Advance-stage actionrnd_requests.id
Add progress entryAction::form() modal on the ProgressLog RelationManagerchild insertstored: rnd_progress_log (date, by_user_id, type enum Trial / Remark / Feedback, trial_no auto when Trial, text). Feedback type may simultaneously set rnd_requests.sample_feedbackrnd_requests.id
Status historyTable (read-only)derivedderived: progress_log entries of type Status → transition + days-in-stage (elapsed between Status entries). Drives the two KPI clocks: internal = Σ In-development durations (loops included); awaiting-feedback = Σ Sample-sent durations (customer clock, tracked separately)rnd_progress_log
Draft ingredientsRepeaterchild tablestored: rnd_draft_ingredients — item_id nullable, free_text, qty, uom, note. Informal pre-BOM list: no stock tracking, no deductionitems.id (nullable)
Sample trackingSection → inputs + badgemixedstored: sample_qty, sample_ship_date, courier, tracking_no, sample_feedback enum (Awaiting / Approved / Rejected — with remarks)—
Design trackSection → Select + FileUploadmixedstored: design_track — design_status enum (Brief sent / Draft vN / Approved), designer_user_id, artwork_version int, artwork_file. Parallel side-track advanced by the designer — NOT a request status, never gates the R&D flowusers.id
CostingSection → money inputsmoney ×3stored: est_rm_cost, production_cost, total_est_cost — a section within In development (no Costing stage), updated during sourcing/trials; feeds the quote (quotes.html)quotes
ConfirmationSection + Create BOM Actionmixedstored: confirmed_date, confirmed_by — set by Advance stage into Confirmed—

Advance-stage validations

  • Each Advance stage → validates the required fields of the target stage, then auto-logs a Status entry (this page's log is the audit trail).
  • → Sample sent: requires sample qty + ship date (courier / tracking optional but nagged).
  • → Confirmed: requires sample feedback = Approved.
  • Status enum simplified to 5 (founder decision): Requested → In development → Sample sent → Confirmed, plus terminal Cancelled. Sample sent loops back to In development on feedback FAIL (trial # increments — revision rounds); Cancelled possible at any stage = rejected / withdrawn. The design track never gates any transition.

Engine notes

  • Trial stock consumption is NOT tracked (founder decision): trial quantities are noted in the progress log only — no reservation, no movement, no Committed netting. Trial amounts are too small to matter.
  • Confirmed → Create BOM: copies the draft ingredients into recipe rows on the target product; lines with item_id link directly, free-text lines prompt quick item creation. The BOM stores rnd_request_id so production traces back to the request.
  • Costing values flow into the linked quote (quotes.html “Awaiting R&D” → priced); the confirmed deal proceeds to SO → MO as usual.
  • Manual progress entries are Trial / Remark / Feedback only — Status rows are written exclusively by the Advance-stage action, keeping the log a trustworthy audit trail.