Pick a quick preset, or set a custom From/To window.
Available history:—
Date Range Click to change
📅Year to Date
Bay
Type
Total MANU Hours Behind Over Time Ozzy (outsourced) not included
Sum across all in-house bays (9 MANU + UC + JIG) of expected (PSD→Bay End burn-down) minus actual labor clocked in each bay's bucket. Ozzy's outsourced work is tracked separately on his own card below. Click any point to see the projects driving that week's debt.
Hours Behind Over Time — By Bay
Each bay's debt history. Red = currently behind, green = ahead or on-pace. Click any point to drill into that bay's projects for that week.
Load vs Realized Over Time
Load = each project's GOAL MANU spread evenly across its PSD → Bay End window. Realized = MANU labor actually clocked into that bay's projects Mon–Sun. The current/cutoff week is shown with its load pro-rated to the days already elapsed, so the chart stays apples-to-apples without a 14-day gap before the projection. The dashed portion past the “PROJECTED” marker is forward-looking ~3 months from the current data cutoff, computed from the Job Hours / Production Queue schedule. Future weeks only count projects with a confirmed Job Hours GOAL MANU row — anything missing GOAL MANU / bay / PQ timeline is surfaced in the refresh-time data-gaps report (no longer shown inline on the dashboard).
Consolidated — all in-house bays Ozzy (outsourced) not includedOzzy's outsourced hours are excluded here — see his card below. Click any week to drill into the projects active that week.
Goal Hours Efficiency Over Time
Variance % = (Actual MANU − Goal MANU) / Goal MANU × 100. Green = finished at or under projected hours. Red = took more hours than projected. Example: 100-hour goal → 120 actual = +20% red; 100-hour goal → 80 actual = −20% green. A project counts once MANU is signed off OR a PQ Actual Completion Date is set, whichever fires first. Actual hours = total MANU labor logged on the serial in the ERP YTD export, with Historical Hours board backfill applied when the ERP window doesn't cover the project's PSD. Projects that finished before the ERP window opened with no historical-board entry are excluded.
Consolidated — all in-house bays Ozzy (outsourced) not includedClick any week to see the projects MANU-completed that week.
Snapshot drill-down
How is "Hours Behind" calculated?
For each project that was active at a given weekly snapshot:
Expected MANU = pctComplete × GOAL MANU. pctComplete is the day-of-week weighted share of the PSD→Bay End window elapsed at the snapshot. Weights come from 17 months of YTD ERP labor (Mon-Thu ~84%, Fri ~11%, Sat ~4%, Sun ~0%) and are per-bay (A19/Magnum barely works Saturdays; A13 works some Saturdays; etc.). Sunday snapshots of week-aligned project windows match the old uniform-day math exactly; mid-week snapshots and non-Mon/Sun-bounded projects reflect each bay's real throughput pattern rather than a flat calendar-day spread. The drill-down "Days Elapsed / Days Total" columns are still calendar days for context.
Actual MANU = cumulative MANU labor rows from the ERP YTD export (Seq Description = MANUFACTURING or CONVEYOR LARGE, OR WC = A001 / A08L) dated on or before the snapshot.
Historical Hours backfill: for any project already closed out (Job Hours "Complete" group OR PQ Actual Completion Date set), we cross-reference the POST 8/1/22 Historical Hours board (numbers89). If ERP labor for that serial is less than 95% of the historical total (window predates the ERP export), we scale the ERP curve to match (or distribute linearly across PSD→BayEnd if there's no ERP data at all). The "Hist. Board MANU" column in drill-down shows the historical total when present.
Behind = Expected − Actual. If actual has already reached the goal, the project is treated as 100% complete (behind = 0).
MANU done short-circuit: a project drops out of "behind" from the day MANU is finished, using the earliest of three signals — PQ Manu Complete Date (real date, used historically), PQ MANU workstation tick (text59 contains a green check), or Weekly Team Lead board MANU green check (column auto-discovered on board 3347604135). Anything before that date still counts the project normally.
Completed projects also drop out from the day their PQ Actual Completion Date (date6) is set onward — same historical-preservation rule.
Bay assignment primary source is the Job Hours board group title (covers active and completed groups all the way back to 2022). Falls back to the PQ Team Lead mirror (Weekly Lead Meeting board) where Job Hours has no row.
Bay End primary source is the PQ Timeline column (start = PSD, end = kick-out-of-weld). Falls back to a capacity estimate PSD + (GOAL MANU / capacity) × 7 days when the planner hasn't entered a timeline yet.
Excluded: METSO projects, bay B15, idle TJ bay A4, B5. As of 2026-09-16 UC and JIG are included as their own bays (see next paragraph). JIG and UC hours are NOT counted in MANU, except A19 (Magnum) where JIG is folded into MANU for both Goal and Realized — Magnum jigs their own conveyors so JIG labor is real MANU work for that bay.
UC and JIG shadow rows: on the UC or JIG drill tables, most rows are "shadows" of a project that primarily lives in a MANU bay (e.g. a Wagner 48X150 running in A8A also needs undercarriage hours in UC). Shadow rows carry the primary bay id in the new Parent column and get a subtle burgundy left-border in the drill table. Goal Hrs / Actual Hrs / Behind on a shadow reflect that bay's own goal column and labor bucket (UC=numeric89+ERP UC bucket, JIG=numeric0+ERP JIG bucket). MANU Sign-off dates on shadow rows are inherited from the parent MANU bay and shown with a "(parent)" hint — they don't imply the UC or JIG work itself is done, and shadow rows keep counting until the project ships OR the shadow's own actual hits its own goal.
MANU bays: A11 Lyle 200 / A12 Matt 224 / A13 Jacob 268 / B12 Brandon 208 / A14 TJ 200 / A8 Randy 240 (A8A + A8B consolidated — shared crew & labor pool) / B3 Dustin 120 / A19 Magnum 240. In-house weekly MANU capacity = 1,500 hrs. Outsourced Work – Ozzy is tracked separately (jobs whose primary Team Lead is Ozzy). Because outsourced labor is not clocked in the ERP, Ozzy is excluded from every consolidated / “all bays” number on this dashboard — summary cards, the hero Hours Behind chart, the consolidated Load vs Realized chart, the consolidated Goal Efficiency chart, and their all-bays drill-downs. He keeps his own card in each per-bay grid. His capacity is a normalized planning reference of ~400 hr/wk (roughly his average forward scheduled load), not a hard in-house limit; on his Load vs Realized card the pills show average weekly scheduled load in hours instead of a utilization %.
Secondary bays (added 2026-09-16):UC (Undercarriage) 160 hr/wk — real Job Hours group, goal reads numeric89, realized from ERP WC=UNCR/Seq=UNDERCARRIAGE. JIG (shared) 100 hr/wk — virtual bay generated from every non-A19 project that has a JIG goal (numeric0); realized from ERP WC=JIGC/Seq=JIG. A19 (Magnum) still folds its JIG hours into MANU, so the JIG bay explicitly excludes Magnum projects to avoid double-counting.