The Old Ironhorse Dilemma: Optimizing an Aging Pumping Station

The Case

The first thing Alex did as the new Asset Manager for the Clearwater Valley Water Authority was walk the grounds of Pumping Station 3. The locals called it "Old Ironhorse." Built in the 1970s, it was a monument to brute-force engineering, all oversized cast iron and humming transformers that sounded like a sleeping giant. It was the heart of the district's water distribution, and it hadn't failed in 40 years. That was the problem.

Alex’s predecessor, a man nearing retirement, operated on a simple principle: "If it ain't broke, don't fix it." On the surface, it worked. But digging into the performance logs and financial reports, Alex saw a different story. Energy costs for Station 3 were astronomical and had climbed 15% in just the last two years. The station's primary pump, a behemoth known as Pump 1, ran almost constantly, whether demand was at its peak mid-afternoon or at its lowest ebb at 3 a.m. It was like using a sledgehammer to crack a nut.

The maintenance logs were another source of concern. They were filled with entries for routine lubrication and inspections, but there were no records of vibration analysis, thermal imaging, or any modern predictive maintenance. The last major overhaul was over two decades ago. Old Ironhorse wasn't just inefficient; it was a black box of operational risk. If that main pump failed unexpectedly, half the valley would be without water pressure for days.

Alex’s director, Maria, is aware of the budget strain but trusts the station's legendary reliability. "That station has never let us down," she said during their initial meeting. "But the finance department is screaming about our energy bills. They want cuts." She handed Alex a folder. "The board has approved a capital projects budget for next year. We could get them to fund a full replacement of the pumps at Station 3, but that means a six-week shutdown and a price tag that would make your eyes water. Or we could do nothing and hope for the best."

Maria leaned forward, her expression serious. "I don't like either of those options. You're the asset manager. You have the data. You have the budget constraints. I need a real plan. Analyze the situation and tell me what our best move is. Don't just tell me to fix it or replace it. Tell me how to optimize our assets to improve efficiency and guarantee reliability for the next 20 years. I need your recommendation by the end of the week."

Resources and Data

Here is the information Alex has to work with. Review it carefully to understand the full scope of the problem at Pumping Station 3.

Pumping Station 3 - Performance Log (Sample Week)

TimestampPump IDFlow Rate GPMEnergy Consumption kWhStatus
2023-10-23T00:00:00ZPump_19855.4510.2Running
2023-10-23T00:00:00ZPump_200.2Standby
2023-10-23T00:00:00ZPump_300.2Standby
2023-10-23T01:00:00ZPump_12150.8425.6Running
2023-10-23T01:00:00ZPump_200.2Standby
2023-10-23T01:00:00ZPump_300.2Standby
2023-10-23T02:00:00ZPump_11988.2418.9Running
2023-10-23T02:00:00ZPump_200.2Standby
2023-10-23T02:00:00ZPump_300.2Standby
2023-10-23T03:00:00ZPump_11850.5411.3Running
2023-10-23T03:00:00ZPump_200.2Standby
2023-10-23T03:00:00ZPump_300.2Standby
2023-10-23T04:00:00ZPump_12890.1435.7Running
2023-10-23T04:00:00ZPump_200.2Standby
2023-10-23T04:00:00ZPump_300.2Standby
2023-10-23T05:00:00ZPump_18540.3495.1Running
2023-10-23T05:00:00ZPump_200.2Standby
2023-10-23T05:00:00ZPump_300.2Standby
2023-10-23T06:00:00ZPump_111500.6540.8Running
2023-10-23T06:00:00ZPump_200.2Standby
2023-10-23T06:00:00ZPump_300.2Standby
2023-10-23T07:00:00ZPump_111890.2548.3Running
2023-10-23T07:00:00ZPump_200.2Standby
2023-10-23T07:00:00ZPump_300.2Standby
2023-10-23T08:00:00ZPump_111950.4550.0Running
2023-10-23T08:00:00ZPump_200.2Standby
2023-10-23T08:00:00ZPump_300.2Standby
2023-10-23T09:00:00ZPump_111200.1535.5Running
2023-10-23T09:00:00ZPump_200.2Standby
2023-10-23T09:00:00ZPump_300.2Standby
2023-10-23T10:00:00ZPump_110500.7520.1Running
2023-10-23T10:00:00ZPump_200.2Standby
2023-10-23T10:00:00ZPump_300.2Standby
2023-10-23T11:00:00ZPump_110800.3528.4Running
2023-10-23T11:00:00ZPump_200.2Standby
2023-10-23T11:00:00ZPump_300.2Standby
2023-10-23T12:00:00ZPump_19999.9515.9Running
2023-10-23T12:00:00ZPump_200.2Standby
2023-10-23T12:00:00ZPump_300.2Standby
2023-10-23T13:00:00ZPump_110101.1518.2Running
2023-10-23T13:00:00ZPump_200.2Standby
2023-10-23T13:00:00ZPump_300.2Standby
2023-10-23T14:00:00ZPump_110345.6522.0Running
2023-10-23T14:00:00ZPump_200.2Standby
2023-10-23T14:00:00ZPump_300.2Standby
2023-10-23T15:00:00ZPump_100.5Standby
2023-10-23T15:00:00ZPump_22350.758.1Running
2023-10-23T15:00:00ZPump_300.2Standby
2023-10-23T16:00:00ZPump_111300.8538.2Running
2023-10-23T16:00:00ZPump_200.2Standby
2023-10-23T16:00:00ZPump_300.2Standby
2023-10-23T17:00:00ZPump_111750.3545.9Running
2023-10-23T17:00:00ZPump_200.2Standby
2023-10-23T17:00:00ZPump_300.2Standby
2023-10-23T18:00:00ZPump_111200.5535.6Running
2023-10-23T18:00:00ZPump_200.2Standby
2023-10-23T18:00:00ZPump_300.2Standby
2023-10-23T19:00:00ZPump_110800.1528.5Running
2023-10-23T19:00:00ZPump_200.2Standby
2023-10-23T19:00:00ZPump_300.2Standby
2023-10-23T20:00:00ZPump_19500.8505.3Running
2023-10-23T20:00:00ZPump_200.2Standby
2023-10-23T20:00:00ZPump_300.2Standby
2023-10-23T21:00:00ZPump_18500.4495.0Running
2023-10-23T21:00:00ZPump_200.2Standby
2023-10-23T21:00:00ZPump_300.2Standby
2023-10-23T22:00:00ZPump_17500.2485.1Running
2023-10-23T22:00:00ZPump_200.2Standby
2023-10-23T22:00:00ZPump_300.2Standby
2023-10-23T23:00:00ZPump_16500.9475.8Running
2023-10-23T23:00:00ZPump_200.2Standby
2023-10-23T23:00:00ZPump_300.2Standby
2023-10-24T00:00:00ZPump_19742.6508.7Running
2023-10-24T00:00:00ZPump_200.2Standby
2023-10-24T00:00:00ZPump_300.2Standby
2023-10-24T01:00:00ZPump_12201.3428.1Running
2023-10-24T01:00:00ZPump_200.2Standby
2023-10-24T01:00:00ZPump_300.2Standby
2023-10-24T02:00:00ZPump_12014.7420.4Running
2023-10-24T02:00:00ZPump_200.2Standby
2023-10-24T02:00:00ZPump_300.2Standby
2023-10-24T03:00:00ZPump_11799.8409.9Running
2023-10-24T03:00:00ZPump_200.2Standby
2023-10-24T03:00:00ZPump_300.2Standby
2023-10-24T04:00:00ZPump_12950.3438.2Running
2023-10-24T04:00:00ZPump_200.2Standby
2023-10-24T04:00:00ZPump_300.2Standby
2023-10-24T05:00:00ZPump_18600.2496.5Running
2023-10-24T05:00:00ZPump_200.2Standby
2023-10-24T05:00:00ZPump_300.2Standby
2023-10-24T06:00:00ZPump_111450.9539.9Running
2023-10-24T06:00:00ZPump_200.2Standby
2023-10-24T06:00:00ZPump_300.2Standby
2023-10-24T07:00:00ZPump_100.5Standby
2023-10-24T07:00:00ZPump_200.2Standby
2023-10-24T07:00:00ZPump_32410.160.5Running
2023-10-24T08:00:00ZPump_111980.7549.6Running
2023-10-24T08:00:00ZPump_200.2Standby
2023-10-24T08:00:00ZPump_300.2Standby
2023-10-24T09:00:00ZPump_111250.3536.8Running
2023-10-24T09:00:00ZPump_200.2Standby
2023-10-24T09:00:00ZPump_300.2Standby
2023-10-24T10:00:00ZPump_110550.9521.7Running
2023-10-24T10:00:00ZPump_200.2Standby
2023-10-24T10:00:00ZPump_300.2Standby
2023-10-24T11:00:00ZPump_110850.5529.8Running
2023-10-24T11:00:00ZPump_200.2Standby
2023-10-24T11:00:00ZPump_300.2Standby
2023-10-24T12:00:00ZPump_110050.2517.2Running
2023-10-24T12:00:00ZPump_200.2Standby
2023-10-24T12:00:00ZPump_300.2Standby
2023-10-24T13:00:00ZPump_110151.4519.5Running
2023-10-24T13:00:00ZPump_200.2Standby
2023-10-24T13:00:00ZPump_300.2Standby
2023-10-24T14:00:00ZPump_110395.8523.4Running
2023-10-24T14:00:00ZPump_200.2Standby
2023-10-24T14:00:00ZPump_300.2Standby
2023-10-24T15:00:00ZPump_110999.1532.7Running
2023-10-24T15:00:00ZPump_200.2Standby
2023-10-24T15:00:00ZPump_300.2Standby
2023-10-24T16:00:00ZPump_111350.2539.1Running
2023-10-24T16:00:00ZPump_200.2Standby
2023-10-24T16:00:00ZPump_300.2Standby
2023-10-24T17:00:00ZPump_111800.6547.1Running
2023-10-24T17:00:00ZPump_200.2Standby
2023-10-24T17:00:00ZPump_300.2Standby
2023-10-24T18:00:00ZPump_111250.7536.9Running
2023-10-24T18:00:00ZPump_200.2Standby
2023-10-24T18:00:00ZPump_300.2Standby
2023-10-24T19:00:00ZPump_110850.3529.9Running
2023-10-24T19:00:00ZPump_200.2Standby
2023-10-24T19:00:00ZPump_300.2Standby
2023-10-24T20:00:00ZPump_19550.1506.6Running
2023-10-24T20:00:00ZPump_200.2Standby
2023-10-24T20:00:00ZPump_300.2Standby
2023-10-24T21:00:00ZPump_18550.6496.2Running
2023-10-24T21:00:00ZPump_200.2Standby
2023-10-24T21:00:00ZPump_300.2Standby
2023-10-24T22:00:00ZPump_17550.4486.3Running
2023-10-24T22:00:00ZPump_200.2Standby
2023-10-24T22:00:00ZPump_300.2Standby
2023-10-24T23:00:00ZPump_16550.1476.9Running
2023-10-24T23:00:00ZPump_200.2Standby
2023-10-24T23:00:00ZPump_300.2Standby
2023-10-25T00:00:00ZPump_19742.6508.7Running
2023-10-25T00:00:00ZPump_200.2Standby
2023-10-25T00:00:00ZPump_300.2Standby
2023-10-25T01:00:00ZPump_12201.3428.1Running
2023-10-25T01:00:00ZPump_200.2Standby
2023-10-25T01:00:00ZPump_300.2Standby
2023-10-25T02:00:00ZPump_100.5Standby
2023-10-25T02:00:00ZPump_22488.961.2Running
2023-10-25T02:00:00ZPump_300.2Standby
2023-10-25T03:00:00ZPump_11799.8409.9Running
2023-10-25T03:00:00ZPump_200.2Standby
2023-10-25T03:00:00ZPump_300.2Standby
2023-10-25T04:00:00ZPump_12950.3438.2Running
2023-10-25T04:00:00ZPump_200.2Standby
2023-10-25T04:00:00ZPump_300.2Standby
2023-10-25T05:00:00ZPump_18600.2496.5Running
2023-10-25T05:00:00ZPump_200.2Standby
2023-10-25T05:00:00ZPump_300.2Standby
2023-10-25T06:00:00ZPump_111450.9539.9Running
2023-10-25T06:00:00ZPump_200.2Standby
2023-10-25T06:00:00ZPump_300.2Standby
2023-10-25T07:00:00ZPump_111850.5547.9Running
2023-10-25T07:00:00ZPump_200.2Standby
2023-10-25T07:00:00ZPump_300.2Standby
2023-10-25T08:00:00ZPump_111980.7549.6Running
2023-10-25T08:00:00ZPump_200.2Standby
2023-10-25T08:00:00ZPump_300.2Standby
2023-10-25T09:00:00ZPump_111250.3536.8Running
2023-10-25T09:00:00ZPump_200.2Standby
2023-10-25T09:00:00ZPump_300.2Standby
2023-10-25T10:00:00ZPump_110550.9521.7Running
2023-10-25T10:00:00ZPump_200.2Standby
2023-10-25T10:00:00ZPump_300.2Standby
2023-10-25T11:00:00ZPump_110850.5529.8Running
2023-10-25T11:00:00ZPump_200.2Standby
2023-10-25T11:00:00ZPump_300.2Standby
2023-10-25T12:00:00ZPump_110050.2517.2Running
2023-10-25T12:00:00ZPump_200.2Standby
2023-10-25T12:00:00ZPump_300.2Standby
2023-10-25T13:00:00ZPump_110151.4519.5Running
2023-10-25T13:00:00ZPump_200.2Standby
2023-10-25T13:00:00ZPump_300.2Standby
2023-10-25T14:00:00ZPump_110395.8523.4Running
2023-10-25T14:00:00ZPump_200.2Standby
2023-10-25T14:00:00ZPump_300.2Standby
2023-10-25T15:00:00ZPump_110999.1532.7Running
2023-10-25T15:00:00ZPump_200.2Standby
2023-10-25T15:00:00ZPump_300.2Standby
2023-10-25T16:00:00ZPump_111350.2539.1Running
2023-10-25T16:00:00ZPump_200.2Standby
2023-10-25T16:00:00ZPump_300.2Standby
2023-10-25T17:00:00ZPump_111800.6547.1Running
2023-10-25T17:00:00ZPump_200.2Standby
2023-10-25T17:00:00ZPump_300.2Standby
2023-10-25T18:00:00ZPump_111250.7536.9Running
2023-10-25T18:00:00ZPump_200.2Standby
2023-10-25T18:00:00ZPump_300.2Standby
2023-10-25T19:00:00ZPump_110850.3529.9Running
2023-10-25T19:00:00ZPump_200.2Standby
2023-10-25T19:00:00ZPump_300.2Standby
2023-10-25T20:00:00ZPump_19550.1506.6Running
2023-10-25T20:00:00ZPump_200.2Standby
2023-10-25T20:00:00ZPump_300.2Standby
2023-10-25T21:00:00ZPump_18550.6496.2Running
2023-10-25T21:00:00ZPump_200.2Standby
2023-10-25T21:00:00ZPump_300.2Standby
2023-10-25T22:00:00ZPump_17550.4486.3Running
2023-10-25T22:00:00ZPump_200.2Standby
2023-10-25T22:00:00ZPump_300.2Standby
2023-10-25T23:00:00ZPump_16550.1476.9Running
2023-10-25T23:00:00ZPump_200.2Standby
2023-10-25T23:00:00ZPump_300.2Standby
2023-10-26T00:00:00ZPump_19742.6508.7Running
2023-10-26T00:00:00ZPump_200.2Standby
2023-10-26T00:00:00ZPump_300.2Standby
2023-10-26T01:00:00ZPump_12201.3428.1Running
2023-10-26T01:00:00ZPump_200.2Standby
2023-10-26T01:00:00ZPump_300.2Standby
2023-10-26T02:00:00ZPump_12014.7420.4Running
2023-10-26T02:00:00ZPump_200.2Standby
2023-10-26T02:00:00ZPump_300.2Standby
2023-10-26T03:00:00ZPump_11799.8409.9Running
2023-10-26T03:00:00ZPump_200.2Standby
2023-10-26T03:00:00ZPump_300.2Standby
2023-10-26T04:00:00ZPump_12950.3438.2Running
2023-10-26T04:00:00ZPump_200.2Standby
2023-10-26T04:00:00ZPump_300.2Standby
2023-10-26T05:00:00ZPump_18600.2496.5Running
2023-10-26T05:00:00ZPump_200.2Standby
2023-10-26T05:00:00ZPump_300.2Standby
2023-10-26T06:00:00ZPump_111450.9539.9Running
2023-10-26T06:00:00ZPump_200.2Standby
2023-10-26T06:00:00ZPump_300.2Standby
2023-10-26T07:00:00ZPump_111850.5547.9Running
2023-10-26T07:00:00ZPump_200.2Standby
2023-10-26T07:00:00ZPump_300.2Standby
2023-10-26T08:00:00ZPump_111980.7549.6Running
2023-10-26T08:00:00ZPump_200.2Standby
2023-10-26T08:00:00ZPump_300.2Standby
2023-10-26T09:00:00ZPump_111250.3536.8Running
2023-10-26T09:00:00ZPump_200.2Standby
2023-10-26T09:00:00ZPump_300.2Standby
2023-10-26T10:00:00ZPump_110550.9521.7Running
2023-10-26T10:00:00ZPump_200.2Standby
2023-10-26T10:00:00ZPump_300.2Standby
2023-10-26T11:00:00ZPump_100.5Standby
2023-10-26T11:00:00ZPump_200.2Standby
2023-10-26T11:00:00ZPump_32290.457.8Running
2023-10-26T12:00:00ZPump_110050.2517.2Running
2023-10-26T12:00:00ZPump_200.2Standby
2023-10-26T12:00:00ZPump_300.2Standby
2023-10-26T13:00:00ZPump_110151.4519.5Running
2023-10-26T13:00:00ZPump_200.2Standby
2023-10-26T13:00:00ZPump_300.2Standby
2023-10-26T14:00:00ZPump_110395.8523.4Running
2023-10-26T14:00:00ZPump_200.2Standby
2023-10-26T14:00:00ZPump_300.2Standby
2023-10-26T15:00:00ZPump_110999.1532.7Running
2023-10-26T15:00:00ZPump_200.2Standby
2023-10-26T15:00:00ZPump_300.2Standby
2023-10-26T16:00:00ZPump_111350.2539.1Running
2023-10-26T16:00:00ZPump_200.2Standby
2023-10-26T16:00:00ZPump_300.2Standby
2023-10-26T17:00:00ZPump_111800.6547.1Running
2023-10-26T17:00:00ZPump_200.2Standby
2023-10-26T17:00:00ZPump_300.2Standby
2023-10-26T18:00:00ZPump_111250.7536.9Running
2023-10-26T18:00:00ZPump_200.2Standby
2023-10-26T18:00:00ZPump_300.2Standby
2023-10-26T19:00:00ZPump_110850.3529.9Running
2023-10-26T19:00:00ZPump_200.2Standby
2023-10-26T19:00:00ZPump_300.2Standby
2023-10-26T20:00:00ZPump_19550.1506.6Running
2023-10-26T20:00:00ZPump_200.2Standby
2023-10-26T20:00:00ZPump_300.2Standby
2023-10-26T21:00:00ZPump_18550.6496.2Running
2023-10-26T21:00:00ZPump_200.2Standby
2023-10-26T21:00:00ZPump_300.2Standby
2023-10-26T22:00:00ZPump_17550.4486.3Running
2023-10-26T22:00:00ZPump_200.2Standby
2023-10-26T22:00:00ZPump_300.2Standby
2023-10-26T23:00:00ZPump_16550.1476.9Running
2023-10-26T23:00:00ZPump_200.2Standby
2023-10-26T23:00:00ZPump_300.2Standby
2023-10-27T00:00:00ZPump_19742.6508.7Running
2023-10-27T00:00:00ZPump_200.2Standby
2023-10-27T00:00:00ZPump_300.2Standby
2023-10-27T01:00:00ZPump_12201.3428.1Running
2023-10-27T01:00:00ZPump_200.2Standby
2023-10-27T01:00:00ZPump_300.2Standby
2023-10-27T02:00:00ZPump_12014.7420.4Running
2023-10-27T02:00:00ZPump_200.2Standby
2023-10-27T02:00:00ZPump_300.2Standby
2023-10-27T03:00:00ZPump_11799.8409.9Running
2023-10-27T03:00:00ZPump_200.2Standby
2023-10-27T03:00:00ZPump_300.2Standby
2023-10-27T04:00:00ZPump_12950.3438.2Running
2023-10-27T04:00:00ZPump_200.2Standby
2023-10-27T04:00:00ZPump_300.2Standby
2023-10-27T05:00:00ZPump_18600.2496.5Running
2023-10-27T05:00:00ZPump_200.2Standby
2023-10-27T05:00:00ZPump_300.2Standby
2023-10-27T06:00:00ZPump_111450.9539.9Running
2023-10-27T06:00:00ZPump_200.2Standby
2023-10-27T06:00:00ZPump_300.2Standby
2023-10-27T07:00:00ZPump_111850.5547.9Running
2023-10-27T07:00:00ZPump_200.2Standby
2023-10-27T07:00:00ZPump_300.2Standby
2023-10-27T08:00:00ZPump_111980.7549.6Running
2023-10-27T08:00:00ZPump_200.2Standby
2023-10-27T08:00:00ZPump_300.2Standby
2023-10-27T09:00:00ZPump_111250.3536.8Running
2023-10-27T09:00:00ZPump_200.2Standby
2023-10-27T09:00:00ZPump_300.2Standby
2023-10-27T10:00:00ZPump_110550.9521.7Running
2023-10-27T10:00:00ZPump_200.2Standby
2023-10-27T10:00:00ZPump_300.2Standby
2023-10-27T11:00:00ZPump_110850.5529.8Running
2023-10-27T11:00:00ZPump_200.2Standby
2023-10-27T11:00:00ZPump_300.2Standby
2023-10-27T12:00:00ZPump_110050.2517.2Running
2023-10-27T12:00:00ZPump_200.2Standby
2023-10-27T12:00:00ZPump_300.2Standby
2023-10-27T13:00:00ZPump_110151.4519.5Running
2023-10-27T13:00:00ZPump_200.2Standby
2023-10-27T13:00:00ZPump_300.2Standby
2023-10-27T14:00:00ZPump_110395.8523.4Running
2023-10-27T14:00:00ZPump_200.2Standby
2023-10-27T14:00:00ZPump_300.2Standby
2023-10-27T15:00:00ZPump_110999.1532.7Running
2023-10-27T15:00:00ZPump_200.2Standby
2023-10-27T15:00:00ZPump_300.2Standby
2023-10-27T16:00:00ZPump_111350.2539.1Running
2023-10-27T16:00:00ZPump_200.2Standby
2023-10-27T16:00:00ZPump_300.2Standby
2023-10-27T17:00:00ZPump_111800.6547.1Running
2023-10-27T17:00:00ZPump_200.2Standby
2023-10-27T17:00:00ZPump_300.2Standby
2023-10-27T18:00:00ZPump_111250.7536.9Running
2023-10-27T18:00:00ZPump_200.2Standby
2023-10-27T18:00:00ZPump_300.2Standby
2023-10-27T19:00:00ZPump_110850.3529.9Running
2023-10-27T19:00:00ZPump_200.2Standby
2023-10-27T19:00:00ZPump_300.2Standby
2023-10-27T20:00:00ZPump_19550.1506.6Running
2023-10-27T20:00:00ZPump_200.2Standby
2023-10-27T20:00:00ZPump_300.2Standby
2023-10-27T21:00:00ZPump_18550.6496.2Running
2023-10-27T21:00:00ZPump_200.2Standby
2023-10-27T21:00:00ZPump_300.2Standby
2023-10-27T22:00:00ZPump_17550.4486.3Running
2023-10-27T22:00:00ZPump_200.2Standby
2023-10-27T22:00:00ZPump_300.2Standby
2023-10-27T23:00:00ZPump_16550.1476.9Running
2023-10-27T23:00:00ZPump_200.2Standby
2023-10-27T23:00:00ZPump_300.2Standby
2023-10-28T00:00:00ZPump_19742.6508.7Running
2023-10-28T00:00:00ZPump_200.2Standby
2023-10-28T00:00:00ZPump_300.2Standby
2023-10-28T01:00:00ZPump_12201.3428.1Running
2023-10-28T01:00:00ZPump_200.2Standby
2023-10-28T01:00:00ZPump_300.2Standby
2023-10-28T02:00:00ZPump_12014.7420.4Running
2023-10-28T02:00:00ZPump_200.2Standby
2023-10-28T02:00:00ZPump_300.2Standby
2023-10-28T03:00:00ZPump_11799.8409.9Running
2023-10-28T03:00:00ZPump_200.2Standby
2023-10-28T03:00:00ZPump_300.2Standby
2023-10-28T04:00:00ZPump_12950.3438.2Running
2023-10-28T04:00:00ZPump_200.2Standby
2023-10-28T04:00:00ZPump_300.2Standby
2023-10-28T05:00:00ZPump_18600.2496.5Running
2023-10-28T05:00:00ZPump_200.2Standby
2023-10-28T05:00:00ZPump_300.2Standby
2023-10-28T06:00:00ZPump_111450.9539.9Running
2023-10-28T06:00:00ZPump_200.2Standby
2023-10-28T06:00:00ZPump_300.2Standby
2023-10-28T07:00:00ZPump_111850.5547.9Running
2023-10-28T07:00:00ZPump_200.2Standby
2023-10-28T07:00:00ZPump_300.2Standby
2023-10-28T08:00:00ZPump_111980.7549.6Running
2023-10-28T08:00:00ZPump_200.2Standby
2023-10-28T08:00:00ZPump_300.2Standby
2023-10-28T09:00:00ZPump_111250.3536.8Running
2023-10-28T09:00:00ZPump_200.2Standby
2023-10-28T09:00:00ZPump_300.2Standby
2023-10-28T10:00:00ZPump_110550.9521.7Running
2023-10-28T10:00:00ZPump_200.2Standby
2023-10-28T10:00:00ZPump_300.2Standby
2023-10-28T11:00:00ZPump_110850.5529.8Running
2023-10-28T11:00:00ZPump_200.2Standby
2023-10-28T11:00:00ZPump_300.2Standby
2023-10-28T12:00:00ZPump_110050.2517.2Running
2023-10-28T12:00:00ZPump_200.2Standby
2023-10-28T12:00:00ZPump_300.2Standby
2023-10-28T13:00:00ZPump_110151.4519.5Running
2023-10-28T13:00:00ZPump_200.2Standby
2023-10-28T13:00:00ZPump_300.2Standby
2023-10-28T14:00:00ZPump_110395.8523.4Running
2023-10-28T14:00:00ZPump_200.2Standby
2023-10-28T14:00:00ZPump_300.2Standby
2023-10-28T15:00:00ZPump_110999.1532.7Running
2023-10-28T15:00:00ZPump_200.2Standby
2023-10-28T15:00:00ZPump_300.2Standby
2023-10-28T16:00:00ZPump_111350.2539.1Running
2023-10-28T16:00:00ZPump_200.2Standby
2023-10-28T16:00:00ZPump_300.2Standby
2023-10-28T17:00:00ZPump_111800.6547.1Running
2023-10-28T17:00:00ZPump_200.2Standby
2023-10-28T17:00:00ZPump_300.2Standby
2023-10-28T18:00:00ZPump_111250.7536.9Running
2023-10-28T18:00:00ZPump_200.2Standby
2023-10-28T18:00:00ZPump_300.2Standby
2023-10-28T19:00:00ZPump_110850.3529.9Running
2023-10-28T19:00:00ZPump_200.2Standby
2023-10-28T19:00:00ZPump_300.2Standby
2023-10-28T20:00:00ZPump_19550.1506.6Running
2023-10-28T20:00:00ZPump_200.2Standby
2023-10-28T20:00:00ZPump_300.2Standby
2023-10-28T21:00:00ZPump_18550.6496.2Running
2023-10-28T21:00:00ZPump_200.2Standby
2023-10-28T21:00:00ZPump_300.2Standby
2023-10-28T22:00:00ZPump_17550.4486.3Running
2023-10-28T22:00:00ZPump_200.2Standby
2023-10-28T22:00:00ZPump_300.2Standby
2023-10-28T23:00:00ZPump_16550.1476.9Running
2023-10-28T23:00:00ZPump_200.2Standby
2023-10-28T23:00:00ZPump_300.2Standby
2023-10-29T00:00:00ZPump_19742.6508.7Running
2023-10-29T00:00:00ZPump_200.2Standby
2023-10-29T00:00:00ZPump_300.2Standby
2023-10-29T01:00:00ZPump_12201.3428.1Running
2023-10-29T01:00:00ZPump_200.2Standby
2023-10-29T01:00:00ZPump_300.2Standby
2023-10-29T02:00:00ZPump_12014.7420.4Running
2023-10-29T02:00:00ZPump_200.2Standby
2023-10-29T02:00:00ZPump_300.2Standby
2023-10-29T03:00:00ZPump_11799.8409.9Running
2023-10-29T03:00:00ZPump_200.2Standby
2023-10-29T03:00:00ZPump_300.2Standby
2023-10-29T04:00:00ZPump_12950.3438.2Running
2023-10-29T04:00:00ZPump_200.2Standby
2023-10-29T04:00:00ZPump_300.2Standby
2023-10-29T05:00:00ZPump_18600.2496.5Running
2023-10-29T05:00:00ZPump_200.2Standby
2023-10-29T05:00:00ZPump_300.2Standby
2023-10-29T06:00:00ZPump_111450.9539.9Running
2023-10-29T06:00:00ZPump_200.2Standby
2023-10-29T06:00:00ZPump_300.2Standby
2023-10-29T07:00:00ZPump_111850.5547.9Running
2023-10-29T07:00:00ZPump_200.2Standby
2023-10-29T07:00:00ZPump_300.2Standby
2023-10-29T08:00:00ZPump_111980.7549.6Running
2023-10-29T08:00:00ZPump_200.2Standby
2023-10-29T08:00:00ZPump_300.2Standby
2023-10-29T09:00:00ZPump_111250.3536.8Running
2023-10-29T09:00:00ZPump_200.2Standby
2023-10-29T09:00:00ZPump_300.2Standby
2023-10-29T10:00:00ZPump_110550.9521.7Running
2023-10-29T10:00:00ZPump_200.2Standby
2023-10-29T10:00:00ZPump_300.2Standby
2023-10-29T11:00:00ZPump_110850.5529.8Running
2023-10-29T11:00:00ZPump_200.2Standby
2023-10-29T11:00:00ZPump_300.2Standby
2023-10-29T12:00:00ZPump_110050.2517.2Running
2023-10-29T12:00:00ZPump_200.2Standby
2023-10-29T12:00:00ZPump_300.2Standby
2023-10-29T13:00:00ZPump_110151.4519.5Running
2023-10-29T13:00:00ZPump_200.2Standby
2023-10-29T13:00:00ZPump_300.2Standby
2023-10-29T14:00:00ZPump_110395.8523.4Running
2023-10-29T14:00:00ZPump_200.2Standby
2023-10-29T14:00:00ZPump_300.2Standby
2023-10-29T15:00:00ZPump_110999.1532.7Running
2023-10-29T15:00:00ZPump_200.2Standby
2023-10-29T15:00:00ZPump_300.2Standby
2023-10-29T16:00:00ZPump_111350.2539.1Running
2023-10-29T16:00:00ZPump_200.2Standby
2023-10-29T16:00:00ZPump_300.2Standby
2023-10-29T17:00:00ZPump_111800.6547.1Running
2023-10-29T17:00:00ZPump_200.2Standby
2023-10-29T17:00:00ZPump_300.2Standby
2023-10-29T18:00:00ZPump_111250.7536.9Running
2023-10-29T18:00:00ZPump_200.2Standby
2023-10-29T18:00:00ZPump_300.2Standby
2023-10-29T19:00:00ZPump_110850.3529.9Running
2023-10-29T19:00:00ZPump_200.2Standby
2023-10-29T19:00:00ZPump_300.2Standby
2023-10-29T20:00:00ZPump_19550.1506.6Running
2023-10-29T20:00:00ZPump_200.2Standby
2023-10-29T20:00:00ZPump_300.2Standby
2023-10-29T21:00:00ZPump_18550.6496.2Running
2023-10-29T21:00:00ZPump_200.2Standby
2023-10-29T21:00:00ZPump_300.2Standby
2023-10-29T22:00:00ZPump_17550.4486.3Running
2023-10-29T22:00:00ZPump_200.2Standby
2023-10-29T22:00:00ZPump_300.2Standby
2023-10-29T23:00:00ZPump_16550.1476.9Running
2023-10-29T23:00:00ZPump_200.2Standby
2023-10-29T23:00:00ZPump_300.2Standby

Asset Reliability

Your Task

You are Alex, the Asset Manager for the Clearwater Valley Water Authority. Your director has tasked you with creating a formal recommendation for Pumping Station 3. Your analysis must be thorough, and your recommendation must be backed by the evidence provided. You need to balance the immediate financial pressures, the long-term operational risks, and the need for a reliable water supply for the community.

Your final output will be a recommendation that outlines your proposed course of action. You must justify your decision, explaining how it addresses the core problems of inefficiency and risk while being fiscally responsible.

Info Icon

How to Structure Your Recommendation

A strong recommendation follows a clear, logical path. Use this four-step framework to build your response:

  1. Define the Problem: Start by clearly stating the primary problem(s) you've identified at Pumping Station 3.
  2. Identify Core Issues: Use the provided data and documents to pinpoint the root causes of the problem.
  3. Evaluate Possible Solutions: Briefly consider the pros and cons of different approaches (e.g., do nothing, full replacement, optimization).
  4. Recommend the Best Solution: State your final recommendation clearly. Provide a strong rationale, using evidence to explain why your chosen solution is the most effective and responsible path forward.

Guiding Questions

Use these questions to guide your analysis of the case.

  1. Based on the email from the Finance Director, what is the most immediate pressure facing the Operations department?
  2. Looking at the ironhorse-station-performance-data, what patterns do you see in the operation of Pump 1? How does its energy consumption relate to its flow rate, particularly during late-night hours?
  3. The pumping-station-current-logic diagram shows that Pump 1 is always activated. How does this contribute to the problems identified in the data?
  4. According to the pump-performance-curve-infographic, what is the likely consequence of running Pump 1 during periods of low water demand?
  5. What are the primary risks associated with the "do nothing" approach?
  6. What are the main benefits and drawbacks of a full, immediate replacement of the pumps? Consider cost, downtime, and long-term value.
  7. Is there a third option besides "do nothing" or "full replacement"? How could the smaller, standby pumps be used more effectively?
  8. What is your final recommendation? How does it balance the competing demands of cost, reliability, and efficiency?

An Expert Response

Info Icon

This is a Sample Response

The following is one example of a strong, well-reasoned recommendation. Remember, in the real world, different asset managers might propose other valid solutions. The key is to justify your position with evidence and sound analysis. Use this expert response to compare against your own conclusions.

TO: Maria Flores, Director of Operations FROM: Alex Chen, Asset Manager SUBJECT: Recommendation for Pumping Station 3 Optimization

1. Problem Definition

Pumping Station 3 ("Old Ironhorse") is currently the source of a significant budget overrun due to excessive energy consumption. Furthermore, its reliance on aging, single-pump operational logic presents an unacceptable level of risk for a critical failure that would impact service to a large portion of the valley. The current strategy is neither financially sustainable nor operationally resilient.

2. Analysis of Core Issues

My analysis of the performance data and station logic reveals two core issues:

3. Evaluation of Alternatives

4. Recommendation

I recommend we immediately pursue Option C: Data-Driven Optimization & Phased Modernization. This plan consists of two phases:

Phase 1: Immediate Operational Optimization (30-60 Days)

Phase 2: Phased Capital Replacement (1-3 Years)

This two-phase approach provides an immediate, low-cost solution to our most pressing financial problem while creating a clear, data-informed path to modernize our most critical pumping station and ensure its long-term reliability.

Assess Yourself

Info Icon

Evaluate Your Own Response

Before you move on, take a moment to reflect on the recommendation you formulated. Use the criteria below to self-assess your analysis. How does your response measure up? Where is it strong, and where could it be improved?

Learning Progress

By working through the Old Ironhorse dilemma, you have just practiced a core competency of asset management. You've demonstrated how to analyze performance data and operational context to develop a recommendation that improves asset availability, reliability, and efficiency.

Next Steps

Excellent work analyzing this complex scenario. You have successfully completed this case study. Please navigate back to the main course page to continue with your next activity.