LAGOS
Casting WO Dashboard · Studio-BKK
Sign In
Each team has its own password.
Contact Planning if you need access.
LAGOS
Casting WO Dashboard
Studio-BKK · Production Planning
—
No file loaded
⚠
Could not load dashboard data
The dashboard could not fetch the work order file from Google Cloud Storage.

Option 1: Ask Chatchai to upload the latest file via the upload page.
Option 2: Load a local Excel file manually below.
Fallback only · Supports .xlsx · Sheet: WO STA
Processing workbook…
— —
Overview
⚠ Needs Attention
Casting Allocation
WO Detail
⚡ Priority Override
📅 Capacity Planning
⚖ Raw Material
🔧 WIP Progress
Open Work Orders by Type
No mapping loaded

📥 Drag & drop the WO Type mapping Excel or · columns: Document Number, WO Type

Upload the WO Type mapping to see the breakdown.
Casting WO Status
At-Risk FG WOs by Due Month
Open Casting Qty by Location
Casting Completion Rate by Status Group
Casting WOs Requiring Attention
—
Casting Allocation by WO_FG (Due-Date Priority)
● Covered ● Partial ● Shortage
All WO STA Rows
—
How Priority Override works: Upload an Excel or CSV file listing WO_FG numbers with their new priority due dates. The dashboard will re-sort casting allocation using these dates instead of the original WO STA due dates. Only the listed WO_FGs are affected — all others keep their original dates. The Casting Allocation tab will reflect the revised result immediately.
Upload Priority List
📋

Drag & drop or

Excel (.xlsx) or CSV · Required columns: WO_FG, Priority_Due_Date

Loaded Priority List
No priority file loaded yet.
Multi-Unit Capacity (pcs/day)
Default: 10,000–12,000
Single-Unit Capacity (pcs/day)
Default: 3,000
Schedule
Regular: Tue–Fri (4 days/week)
Weekly Demand vs. Capacity (pcs)
Production Days Required per Week
Week-by-Week Production Schedule
● Multi-Unit ● Single-Unit ● Overloaded
Component Injection Type Reference From: Casting Capacity Planning Reference email
Multi-Unit Injection (10,000–12,000 pcs/day)
Single-Unit Injection (3,000 pcs/day)
Wax Injection Yield Matrix —
Yield = finished units produced per wax injection. SKUs not listed below default to Single-Unit, 1 unit/injection. Injections Required = ⌈Open Qty ÷ Yield⌉ · Injection Hours = Injections ÷ Rate.
Injection Rate (inj/hour)
Wax Injection Hours/Day
—
Yield Factors (editable)

📥 Drag & drop yield list Excel or · columns: Assembly Item, Yield, Type (optional)

Injections Required (Open Casting WOs) —
Specification Sheet ⬤ Built-in spec (Jun 2026)
📋

Drag & drop a new spec sheet or

Excel (.xlsx) · Sheet: CLEANED_DATA · Required columns: Parent Style, Component, Category, Quantity, Is_Latest_CostSheet_Version

Loaded Spec Summary —
Load a spec sheet to see summary.
Total Raw Material by Metal Type (grams)
Monthly Requirement by Metal Type (grams)
Weekly Raw Material Requirements
—
Monthly Raw Material Requirements
Detail: Raw Material per Casting SKU
—
Casting WIP Progress Upload ⬤ No file loaded
🔧

Drag & drop the WIP tracking file or

Excel (.xlsx) · Casting operators upload daily progress here — visible to all teams

Process Step Legend
O Step completed (ทำแล้ว)
X Not done yet (ยังไม่ทำ)
– Step not applicable (ไม่มีขั้นตอนนี้)
Steps: Wax Injection → Assemble Wax Tree → Cast → Cut Off Sprues & Clean Up