I think what the OP misses in his calculations is that tips spent on dancers are virtually irrelevant to the club, with the exception of those clubs who take a mandatory percentage or fixed cut of her tips as club revenue.
What matters to a club when looking at total revenue is total spend per customer, or average spend per hour/visit. So the club gets revenue from things like parking valet fees, cover fees, food & drink fees, dance space fees (floor, bench, booth, room, etc.) per song or per unit of time, and perhaps fees from ATMs and from selling "club bucks" and club swag to suckers.
So why is a Whale always good for a club? Because he consumes all of the above fee-generating services, and he consumes them at a rate much higher than a typical PL looking to get max service (dances, LDK, or extras) for the minimum price.
The guy who, like me, buys the minimum number of drinks per hour and nothing else besides dances may only generate $20-$30 in revenue to the cub per visit, even if he (that is, I) spend $300-$500 on tips to a dancer. But a whale who will always use the valet, buy several drinks/bottles, possibly get multiple dances from multiple dancers or get very long VIPs at very high prices may generate $100-$1,000 in club revenue, in addition to the possibly hundreds to thousands in tips he gives to a dancer or dancers.
In virtually every business on the planet, including the sex business, there is something called the "80/20 Rule." This rule says that 80% of a businesses' revenue comes from it's top 20% of customers.
PL's are in the bottom 80% of customers
Whales are the top 20% of customers