---
title: Steel Fab Hours Behind - Masaba Inc
---

Loading Steel Fab Hours Behind

Fetching snapshots...

# Steel Fab Hours Behind

WORKCENTER

[Home](https://offers.masabainc.com/kpi-home?hsLang=en) [OTC](https://offers.masabainc.com/otc-dashboard?hsLang=en) [Engineering](https://offers.masabainc.com/engineering-dashboard?hsLang=en) [MANU Hours Behind](https://offers.masabainc.com/manu-hours-behind-dashboard?hsLang=en) Fab Hours Behind [Assembly Capacity](https://offers.masabainc.com/assembly-capacity-dashboard?hsLang=en) [Routing](https://offers.masabainc.com/routing-dashboard?hsLang=en) [Schedule KPIs](https://offers.masabainc.com/schedule-kpi-dashboard?hsLang=en) [TPI Quality](https://offers.masabainc.com/tpi-dashboard?hsLang=en)

Loading...

 Logout

## Select Date Range

Pick a quick preset, or set a custom From/To window.

**Available history:** -

Year to Date

Last 3 Months

Last 6 Months

Last 12 Months

All Available History

From

To

Cancel

Apply

Hide Filters

Date Range Click to change

📅 Year to Date

Workcenter

All Workcenters

Status

All Behind only On track only

Reset

?

Total Fab Hours Behind Over Time

Sum across all 4 fab workcenters of (goal hours - actual hours) for any project past its Pre-Fab Goal (PSD - 7 days) where the workcenter is not yet signed off. Click any point to drill into the projects driving that snapshot's debt.

Hours Behind Over Time — By Workcenter

Each workcenter's debt history. Red = currently behind, green = on track or signed off. Click any card to drill into that WC's late projects.

Load vs Realized Over Time

Load = sum of goal hours for each workcenter where the project's Pre-Fab Goal falls in the Mon-Sun week (binary; metals fab has no PSD→end ramp). Realized = ERP labor clocked that week, bucketed via `wc_seq_mapping.json`. Future weeks dashed (90-day projection).

Consolidated — all workcentersClick any week to drill into the projects loading that week.

Goal Hours Efficiency Over Time

Variance % = (Actual - Goal) / Goal × 100 on closed-out (project, workcenter) pairs. Green = finished at or under projected hours. Red = took more hours than projected. A WC counts as closed once every non-NA sub-station on the PQ board shows a green check.

Consolidated — all workcentersClick any week to see the WC closeouts in that week.

Snapshot drill-down

Export CSV

Close

### How is "Fab Hours Behind" calculated?

For each project x workcenter at a given weekly snapshot:

- **Pre-Fab Goal** = `PSD - 7 days` — the deadline by which the workcenter should be signed off. Mirrors `PREFAB_GOAL_OFFSET_DAYS` in `refresh-otc-incremental.js`.
- **On track**: if today ≤ Pre-Fab Goal, behind = 0 regardless of progress (metals fab has no PSD→end ramp, so this is binary).
- **Workcenter complete**: a WC counts as done when every non-`NA` sub-station on the PQ board shows a green check (`✅`). The WC's completion date is the latest sub-station completion date from `otc-cache.json`.
- **Behind** (only when Pre-Fab Goal has passed AND WC is not yet complete): `max(0, goalHours[wc] - actualHours[wc])`. Pro-rated against actual ERP labor so a crew that's clocked half the hours doesn't get flagged for the full deficit.
- **Goal hours**: Job Hours board GOAL row, per fab workcenter (`numeric` SAW, `numeric5` PLAS, `numeric8` PRESS, `numeric95` MACH/IRON). DRILL was retired 2026-06-30 — still exists in `wc_seq_mapping.json` but no longer surfaced here.
- **Actual hours**: ERP YTD export rows bucketed via `wc_seq_mapping.json`. Same Seq/WC -> column rules as the Job Hours updater. HYD/ELEC labor was pulled out of ASSY on 2026-07-22 — it doesn't affect fab either way (already excluded), but the ERP totals for those work centers now show as unmapped in run reports.
- **Completed projects** (PQ Actual Completion Date set) drop out of "behind" from that day forward; historical snapshots before then still count them normally.
- **Excluded**: REWORK rows, ERP rows that don't bucket to one of the 4 fab WCs (MANU/ASSY/PNT/SAND/JIG/UC have their own dashboards or are out of scope).

**Workcenter rollup (PQ sub-station → JH column):**

- `SAW` = V25/M20-1 + S20-4 + Voortman + Tube Laser
- `PLAS` = PLAS + LASER
- `PRESS` = PRESS
- `MACH/IRON` = MACH + IW

Weekly capacities (`WC_CAPACITY` in `refresh-fab-behind-data.js`) are seeded defaults — swap in real shop targets once known.

Got it