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.
The Queenstown Airport is one of the fastest growing airports in Australasia. It has been experiencing a double digit average growth for over two years. While this type of growth is exciting and good for business, it can be extremely challenging for operations. One area of pain, from both the operational and customer points of view, was the car park.