Digital grey inward
Empty slot = sheet not posted/received (OPT-001). 09-04 recovered via backfill — sheet exists despite FOSTTA holiday. Click to expand.
Watch list (active now)
- 09-19 "Chalu nhi ho rha" PC (unidentified) — fix reply pending; check next run.
- Ductable coil replacements (2/3) + Ricoh compressor arrival — dates pending.
- Mc1 09-18 stop: no further status found in window; presumed resolved or superseded — confirm closed.
- 09-18/09-19 production reports not yet posted at data end (intraday-normal).
Priority findings
P1 OPT-003HVAC — pre-planning + spares policy delivered 09-19 (5 days late); installs pendingOPEN
HVAC chronic: cooling failures → colour cut + machine stops; 09-19 pre-planning+spares policy delivered (2/3 ductable coils to replace, warranty-only compressors), design-room split Done 09-18; installs (coils/compressor) pending, response SLA unmeasured
P1 OPT-004IT/PC — one same-day close (hang→Done 09-18); one new open ("Chalu nhi ho rha" 09-19); photos carry no serialsOPEN
IT/PC recurring hardware failures (UPS ×2 in 4 days, motherboard repeat failure); IT task open >1 month until escalation. Owner update 09-18: motherboard failures are power-related per IT's own reports ("power line repaired" phrasing) → power-quality protection (logging → SPD/servo + online UPS + earthing check) now part of this finding's fix path
Machine utilization (window)
Bar = avg mtr/day on running days. Green ≥80% days active · amber ≥30% · red <30%. Click the chart to expand.
Findings
P1 OPT-003HVAC — pre-planning + spares policy delivered 09-19 (5 days late); installs pendingOPEN
HVAC chronic: cooling failures → colour cut + machine stops; 09-19 pre-planning+spares policy delivered (2/3 ductable coils to replace, warranty-only compressors), design-room split Done 09-18; installs (coils/compressor) pending, response SLA unmeasured
Findings
P1 OPT-004IT/PC — one same-day close (hang→Done 09-18); one new open ("Chalu nhi ho rha" 09-19); photos carry no serialsOPEN
IT/PC recurring hardware failures (UPS ×2 in 4 days, motherboard repeat failure); IT task open >1 month until escalation. Owner update 09-18: motherboard failures are power-related per IT's own reports ("power line repaired" phrasing) → power-quality protection (logging → SPD/servo + online UPS + earthing check) now part of this finding's fix path
Insights & suggestions
What the data shows
- UPS failures on 3 different PCs in 4 days (8/29, 9/14, 9/17) — one needed a battery change
- Repeat motherboard deaths (8/31 paper-print MC1, 9/7) — one back after 4–5 months with the same fault; management assesses power-related (IT states no cause)
- Procurement confirms the chain: 3 SMPS ordered 09-01 for poly-print PCs; motherboard chase same day; 09-17 RTC-section board repair quoted ₹1800+GST
- AC electrical signals: office-AC sparking (9/12), design-room compressor dead (9/16), Ricoh compressor undelivered, m/c stopped from heat (9/5)
- Cuts themselves are routine — the damage is what dies after them
44 PCs across 4 sections (+23 design-dev PCs in the 08-28 xlsx) · CPU generation mix:
| ≤2013 (gen ≤4) | 5 |
| 2015–18 (gen 5–8) | 12 |
| 2019–21 (gen 9–11) | 14 |
| 2022+ (gen 12+) | 10 |
| other/unknown | 3 |
Pre-2019 machines = 17 of 44 — aging boards + budget PSUs (ARTIS/ANT/EVM) tolerate dirty power badly. Register has no UPS column — add one, log PSU swaps per PC.
| If the log shows… | Then buy | Indicative cost |
|---|---|---|
| Unstable voltage (sag/swell) | Servo stabilizer — 150 kVA whole-plant, or 2×75–100 kVA segmented + 15–20 kVA PC room (segmented preferred; copper windings, ±1%, bypass panel) | ₹2.1–3.1 L · ₹2.8–4.2 L |
| Stable voltage, spikes after cuts | SPD surge protection at main panel only | ₹15–40k |
| PSU rails out of spec on failed PCs | Bulk PSU replacement policy: board dies → PSU replaced same ticket (priority: Vishl RTX3060, PRINTER PC, DIGI1/ABC23, JAGRUTI) | ₹2.5–4.5k / PC |
| UPS = dead batteries, boards = dust/heat | Bulk battery replacement + PC-room cooling + cleaning | < ₹25k |
| Bad earth | Earth pits + bonding | ₹10–20k |
Payback: last 30 days — 2 dead compressors, 3 UPS failures, repeat motherboard, 3 SMPS ordered (09-01), RTC-section board repair quoted (09-17). Preventing 2 failures/year covers the package in <12 months.
Defect mentions by type (window)
Keyword mentions across dagi + main groups. Parties hit most: Diwan ×3; Meesha, Mukesh, Saha, Kamal, Golobel ×2 each. Split across two groups = no single defect ledger (OPT-006). Click to expand.
White / finish lots
Total 2,266 taka (≈ 227 k mtr) across 129 lots, 08-28 → 09-06. Shortage complaints map here (OPT-009). Click to expand.
Findings
P2 OPT-006Defect stream — 2 new reports + 09-18 folding dugi on 4 lots; still zero closuresOPEN
Defect stream has no closure loop; whole-lot defects (Sep 10, Sep 15) with no disposition or mtr recorded
Findings
P2 OPT-011Design loop — Zari/44-pana rounds 09-18 eveningOPEN
Design color-correction loop: 3+ rounds per design, chased till 11pm; files mostly unnamed
What would move the needle
- Pickup aging log (posted → picked, escalate >48h) — kills the "8 din se challan" class of problems (OPT-012)
- Color spec sheet per client (whiteness %, brightness reference) — cuts the 3-round correction loop (OPT-011)
- Lot closure rule: taka expected vs received before "complete" — settles shortages same day (OPT-009)
- Stop reason + restart time for every loop/stenter pause — already emerging via Altaf's posts; make it the norm (OPT-010)
Open-issues ledger (cross-run, all IDs)
| ID | First seen | Priority | Status | Summary |
|---|---|---|---|---|
| OPT-001 | 2026-09-18 | P2 | PARTIAL | Grey-inward stall — Digital scope 09-07→09-18 known (09-18 Digital 175 added 09-19; manifest seeded). Remainder: 09-12/09-13 never posted; 09-17 Digital −40 human verify; structural risk (manual lag + failed downloads hidden) open |
| OPT-002 | 2026-09-18 | P1 | OPEN | Production report loop: byte-identical repost (Sep 15→16 hole in day attribution, Homer base −3,018) + ~1 arithmetic slip per 4 days |
| OPT-003 | 2026-09-18 | P1 | OPEN | HVAC chronic: cooling failures → colour cut + machine stops; 09-19 pre-planning+spares policy delivered (2/3 ductable coils to replace, warranty-only compressors), design-room split Done 09-18; installs (coils/compressor) pending, response SLA unmeasured |
| OPT-004 | 2026-09-18 | P1 | OPEN | IT/PC recurring hardware failures (UPS ×2 in 4 days, motherboard repeat failure); IT task open >1 month until escalation. Owner update 09-18: motherboard failures are power-related per IT's own reports ("power line repaired" phrasing) → power-quality protection (logging → SPD/servo + online UPS + earthing check) now part of this finding's fix path |
| OPT-005 | 2026-09-18 | P2 | OPEN | Zero-run machines (Stenter 7/−6, Whinch M/C no 1, Fuzing 2) — idle vs unallocated unconfirmed |
| OPT-006 | 2026-09-18 | P2 | OPEN | Defect stream has no closure loop; whole-lot defects (Sep 10, Sep 15) with no disposition or mtr recorded |
| OPT-007 | 2026-09-18 | P2 | OPEN | Machine-name churn fragments series (Folding dispatch ×3 names; Ritesh (k.man) missing from CSV) |
| OPT-008 | 2026-09-18 | P1 | OPEN | IT procurement confirms PSU/board power chain: 3 SMPS ordered 09-01, motherboard chase, 09-17 RTC-section repair quote; 15/23 Digital PCs on budget PSUs |
| OPT-009 | 2026-09-18 | P1 | OPEN | White/finish lot shortages: 7 "taka kam" events in 3 weeks ≈ 700–1,000+ mtr unaccounted (1 taka ≈ 100 mtr), no reconciliation loop |
| OPT-010 | 2026-09-18 | P2 | OPEN | Processing stops: cotton-loop coil leakage cost a full day (09-06→09-07); recurring loop/stenter pauses |
| OPT-011 | 2026-09-18 | P2 | OPEN | Design color-correction loop: 3+ rounds per design, chased till 11pm; files mostly unnamed |
| OPT-012 | 2026-09-18 | P2 | OPEN | Dispatch grey pickups age >1 week ("party garam"); no pickup-aging view |
OPT-001/002/007 (data-hygiene, internal) are detailed here only; run report: data/insights/optimization/2026-09-19.md