Operations Management: The "Pain-o-Meter" & Personnel Resourcing

Operations Management: The "Pain-o-Meter" & Personnel Resourcing

With the Queenstown Airport moving from single shift to extended hours operations , I had to develop a model for personnel resourcing based on more than just gut feel. Using some intense Excel formulas, insights from the team and a healthy dose of logical thought, the "Pain-o-meter" was born. This tool helped me make sense of a six-month flight schedule and the fluctuating requirements of a seasonal, holiday destination airport.