I think one of the things not taken into account is the hours a facility is open because a 24/7 facility with 100k ops is half as busy as a facility open 12 hours a day with 100k ops given they have the same number of CPCs.
tldr; the higher the number in the final column, the more ops every CPC did per hour their facility was open, the lower the number the number the less ops every CPC did per hour their facility was open
This is borderline autistic but stay with me. I took all the facilities in the Cleveland, Chicago, Indianapolis, and Minneapolis districts (basically the entire Great Lakes region) and determined how many hours they were open for the year. I even took into account some oddball facilities that have different hours for different months or days of the week so it should be fairly accurate. If a facility was an up/down, I doubled the hours open so it would be on par with the tower only/TRACON only facilities (if you don’t think that’s fair then just ignore the up/downs). I then divided the total number of operations by the number of hours open to get the average number of ops per hours open (a more accurate representation of how busy a facility is than ops/year). I went through the priority placement tool for each month of 2023 and took the average off all the months for each facility for a more accurate representation of average CPCs for the entire year. I then took the ops/hour open number and divided it by the average CPC number to get a final number showing the average ops per hour open per CPC.
This doesn’t take account for 114s, parental leave, or any other things that hurt your staffing but don’t show up on the PPT.