← Maintenance Planner case study

LIVE DEMO · SAP WORKFLOW AUTOMATION

Maintenance Planner

Every week, a maintenance planner exports work orders from SAP and rebuilds the same schedule by hand: reading priorities, checking which technicians are actually on shift, working around production runs, and balancing hours across the crew. SAP holds the work, but it does not answer the planner’s real question — who does what, in which week.

This is the scheduling engine from the C# desktop application, ported to TypeScript and running live in your browser. It is the same logic: regulatory PMs placed first, everything else assigned to whichever technician and week has the most remaining capacity, bounded by blocked periods and by each technician’s real availability — including the Panama 2-2-3 rotation, where a 12-hour crew works 36 hours one week and 48 the next.

Edit the crew, the calendar, or the hours and the plan regenerates immediately. Nothing is sent to a server, and no SAP connection is involved — the work orders below are a representative export.

Inputs

The SAP export, the crew, and the calendar. Change anything here and the plan below is regenerated by the real scheduling engine.

Technicians (6)

40h40h40h40h
24h60h24h60h
40h40h40h40h
60h24h60h24h
40h40h40h40h
32h32h32h32h

The four numbers under each technician are their real available hours for weeks 1–4. Switch someone to a rotating shift and watch those numbers stop being constant — that is the Panama 2-2-3 cycle, and it is why capacity has to be computed per week instead of assumed at 40.

Blocked periods (1)

A blocked period closes a work center for the weeks it overlaps. Widen the production run to cover more weeks and the mechanical work is forced out of them entirely.

The SAP export (16 work orders)
OrderDescriptionTypeWork ctrPrioHours
4100231Annual boiler safety valve certificationPM03REGMECH1
4100232Statutory crane load testZR01REGMECH1
4100233Pressure vessel inspectionPM05REGPIPE2
4100234Replace conveyor drive bearingPM01MECH2
4100235Rebuild hydraulic power unitPM01MECH3
4100236Motor control center thermographyPM02ELEC2
4100237Replace VFD on extruder linePM01ELEC2
4100238Calibrate flow transmittersPM02INST3
4100239Loop check reactor temperaturePM02INST3
4100240Repair steam line insulationPM01PIPE4
4100241Replace pump mechanical sealPM01PIPE2
4100242Gearbox oil change and inspectionPM02MECH3
4100243Lighting circuit repair, bay 3PM01ELEC4
4100244Replace failed proximity sensorsPM01INST3
4100245Weld repair on process pipingPM01PIPE3
4100246Compressor valve overhaulPM01MECH3

Regulatory PMs are detected from the SAP order type (PM03, PM05, ZR01, ZR02) and are highlighted, exactly as the desktop application does on import.

Generated plan

Four weeks, balanced by utilisation, with regulatory work pulled to the earliest week that is open.

Work orders16
Planned hours182h
Regulatory PMs3
Unplaceable0
FW 29Jul 13Jul 19
R. Alvarez12h / 40h
K. Petrov8h / 24h
D. Whitfield16h / 40h
S. Nakamura10h / 60h
M. Okafor6h / 40h
J. Brennan9h / 32h
  • 4100231Annual boiler safety valve certification
    MECHR. Alvarez12hREG
  • 4100232Statutory crane load test
    MECHK. Petrov8hREG
  • 4100233Pressure vessel inspection
    PIPED. Whitfield16hREG
  • 4100234Replace conveyor drive bearing
    MECHS. Nakamura10h
  • 4100236Motor control center thermography
    ELECM. Okafor6h
  • 4100241Replace pump mechanical seal
    PIPEJ. Brennan9h
FW 30Jul 20Jul 26
blocked: MECH
R. Alvarez14h / 40h
K. Petrov7h / 60h
D. Whitfield8h / 40h
S. Nakamura10h / 24h
M. Okafor15h / 40h
J. Brennan12h / 32h
  • 4100237Replace VFD on extruder line
    ELECR. Alvarez14h
  • 4100244Replace failed proximity sensors
    INSTK. Petrov7h
  • 4100238Calibrate flow transmitters
    INSTD. Whitfield8h
  • 4100239Loop check reactor temperature
    INSTS. Nakamura10h
  • 4100245Weld repair on process piping
    PIPEM. Okafor15h
  • 4100240Repair steam line insulation
    PIPEJ. Brennan12h
FW 31Jul 27Aug 2
R. Alvarez24h / 40h
K. Petrov6h / 24h
D. Whitfield20h / 40h
S. Nakamura5h / 60h
M. Okafor0h / 40h
J. Brennan0h / 32h
  • 4100235Rebuild hydraulic power unit
    MECHR. Alvarez24h
  • 4100242Gearbox oil change and inspection
    MECHK. Petrov6h
  • 4100246Compressor valve overhaul
    MECHD. Whitfield20h
  • 4100243Lighting circuit repair, bay 3
    ELECS. Nakamura5h
FW 32Aug 3Aug 9
R. Alvarez0h / 40h
K. Petrov0h / 60h
D. Whitfield0h / 40h
S. Nakamura0h / 24h
M. Okafor0h / 40h
J. Brennan0h / 32h
  • No work assigned this week.