Mark Aldred

Developed downtime data entry spreadsheet in Excel which reported on equipment efficiencies and assisted in identifying & analysing potential capital projects.

Included the calculation use of; • Overall Equipment Effectiveness (OEE) • Net Present Value (NPV) • Monte Carlo Simulation with probability distributions and a sensitivity analysis • Failure Mode & Effect Criticality Analysis (FMECA)

Excel Spreadsheet for Downtime Data Entry at a Bottled Water Production Plant

Failure Mode & Effect Criticality Analysis (FMECA) & Overall Equipment Effectiveness (OEE) reporting tool. Uses data from the operator downtime data entry form

Net Present Value (NPV) analysis and Monte Carlo Simulation of potential capital projects that could provide financial benefits and improved Overall Equipment Effectiveness (OEE).