Blog tagged as MS Access

Stabilised ERP purchasing and planning by cleaning up master data (products, locations, vendors, BoMs) and introducing standards (naming conventions, mandatory fields). Assigned clear data owners to prevent relapse. Result: more reliable system signals and less downstream rework.

Implemented a lightweight non-conformance + corrective action workflow that teams actually used (native quality app or a controlled Excel log). Enabled simple issue logging, owner assignment, and follow-up. Result: faster containment, clearer accountability, and fewer repeat issues.

Implemented realistic routing and work-centre data (setup/run times) using motion studies. Capacity plans reflected real constraints, reducing overtime and rescheduling. Work was split into linked high-skill and low-skill steps, easing bottlenecks and increasing output.