It was 11 PM on a Wednesday. My business partner and I were in our conference room, and things were getting heated.
"This is insane," he said for the fourth time, jabbing at the spreadsheet on his laptop. "You want to guarantee actual revenue? Do you understand what that means?"
I understood. I also understood what 527 rows of workshop data meant.
"Look at the numbers," I said. "Eighty-two percent success rate. Average revenue $12,400. Cost per failure—"
"I don't care about averages!" He slammed the laptop shut. "What about the disasters? What about the practices that fail three, four times? We'll go bankrupt!"
That's when I pulled up row 387.
The Workshop That Changed Everything
Row 387. Dr. Mitchell. Small town Kansas. Population 47,000.
First workshop: 6 attendees. $1,800 revenue. Total disaster.
"See?" my partner said. "This is exactly—"
"Keep reading," I said.
Second workshop (free under our guarantee): 11 attendees. $6,200 revenue.
Third workshop: 18 attendees. $14,400 revenue.
Fourth workshop: 24 attendees. $22,000 revenue.
"One failure," I said, "led to $42,600 in revenue over four months. Cost us one free workshop. $500 in our time."
He opened the laptop again.
The 2 AM Revelation
We sat there until 2 AM, going through every single workshop. Every failure. Every success. Every variable we could think of.
"What's this column?" he asked around midnight.
"Weather," I admitted.
He looked at me. "You tracked... weather?"
"Mild bad weather increases attendance by 20%," I said defensively. "Perfect days are actually terrible for indoor events."
He laughed. Actually laughed. "You're insane."
"Insanely accurate," I corrected. "Our no-show prediction model is 87% accurate within two people."
"We have a no-show prediction model?"
I showed him the formula. He stared at it like it was hieroglyphics.
The Moment Everything Shifted
Around 1:30 AM, something shifted. He wasn't arguing anymore. He was asking different questions:
"What about seasonal variations?"
"Spring workshops generate 20% more revenue. Tax refunds plus allergy season."
"Market size correlation?"
"Above 100k population, 87% success rate. Below 50k, 65%."
"Ad spend efficiency?"
"$600-900 is optimal. Logarithmic curve, not linear."
For every concern, the data had an answer. Not hope. Not theory. Data.
The Partnership Test
At 2:17 AM, he leaned back in his chair.
"The guarantee would cost us 3.75% of revenue," he said slowly.
"Correct."
"Insurance companies would kill for that loss ratio."
"Correct."
"My wife is going to think we've both lost our minds."
"Probably correct."
He closed the laptop. Stood up. Extended his hand.
"Let's do it."
The Eighteen Month Update
That was 18 months ago. Since then:
- 300+ practices guaranteed
- 18% needed free workshops
- 0% have bankrupted us
- My partner hugs his calculator
Last week, he called me into his office. Had the same spreadsheet open. Now it has 827 rows.
"You know what I love about this?" he said.
"What?"
"Row 387. Dr. Mitchell just completed workshop twelve. $28,000 revenue. From a guy we almost wrote off as a failure."
"The math works," I said.
"No," he corrected. "The math is beautiful."
Coming from a guy who once called me insane at 11 PM on a Wednesday? I'll take it.
P.S. - He still makes fun of me for tracking weather patterns. But guess who checks the forecast before scheduling every workshop now?
[See the complete data analysis that converted a skeptic] → https://blog.optometrylabs.com/post/the-math-behind-the-magic-statistical-analysis-of-500-workshops
No comments:
Post a Comment