I’m working on a few other Lake Quivira data related projects.
See below for details of what they are and current progress – I will try to update this page on a regular basis.
Who does Lake Quivira Country Club compete with for members?
Historically, many Quivira, Inc. investments have been justified with the argument that they are either needed to attract new members (whose number will subsequently deliver improved financial performance) and “keep up with the competition” (i.e. maintain membership at existing levels).
Recent examples of this are the Lake Quivira Community Center and the new Golf Practice Facility.
How much is a new Country Club member worth?
One of the analyses I hope to complete in the future is a “Lifetime Value” revenue and profitability analysis of new Country Club members, with historical comparisons in order to identify the bottom line impacts of initiation fee discounts and promotions and understand whether new (non-resident) members are the panacea to current and future financial challenges that they have been claimed to be.
This would be a really easy analysis for Quivira, Inc. to do, and I think it would deliver some interesting and valuable insights, but without access to the right data, isn’t something that I can easily do to a level of accuracy I’d be comfortable with.
How many new members can Lake Quivira Country Club realistically attract?
Another thing I’d like to do is a detailed demographic analysis, using census data, to understand, by 9 figure (zip+4) zip-codes (i.e. postal enumeration district), what proportion of the realistic “addressable market” (i.e. Kansas City) is already a Lake Quivira member, and what the true “market opportunity” is (i.e. how many new Country Club members would it be reasonable to expect we could recruit, and how far or close are we already to that number).
This would be a relatively easy analysis to do, but requires a suitable “benchmark” of what percentage of the population is realistic to expect might want to join a Country Club. I’m still searching for a suitable statistic for this.
Is the “competition” even other Country Clubs?
I have already been able to do some analysis on who (or more likely, what) Lake Quivira competes with, to get a sense of current “market saturation” and how likely it might be that Lake Quivira can significantly increase Country Club membership (without building more houses).
By tallying the 9 digit (zip+4) zip-codes of all current Country Club members and then plotting instances of these within the latitude and longitude of postal enumeration districts with an accuracy of no greater than 1,500 metres to actual street addresses (the blue markers), it becomes immediately apparent that around 80% of non-resident Country Club members live within a 5 to 6 mile radius (the red circle) of Lake Quivira (the red star marker).
This being the case, I then plotted all the other Country Clubs (the orange markers) and Golf Clubs within a 12 mile radius to see who Lake Quivira might actually compete with.
As you can see, it appears that our biggest “competition” might actually be distance or drive time from suitable target populations, and that Lake Quivira might not actually really compete with many or any of the other local Country Clubs due to its location, and most certainly that the competition is most likely to be Milburn and Westbrook Country Clubs, not the clubs Quivira, Inc. typically compares itself against (e.g. Hallbrook, Mission Hills, Blue Hills etc.).
The embedded map is interactive: you can’t edit it or download any data, but you can zoom in, select different layers and overlays (like Golf Clubs) and “play with it” if you like.
I still have some work to do on this analysis (combining it with the demographic analysis I already mentioned), but I think it already is quite interesting.
While these analyses are far from “ready for prime-time”, hopefully you can get a sense of where I am currently at, and I hope you have found this section of interest.