Transcript
Page 1: Clinic analysis 2013 Sharable Midland PDF LINKEDIN

**** 2013

Color Code ---> Critical Important Goal Holiday

ME000 Gross Rev A

v

Member

Services

N

o

V

G

T

o

1st

Time

1

s

1st Cls % 2nd

Time

2

n

2nd Cls % V

G

V

G

V

G

Prospects T

o

Total Cls % Total Mem Active Mem

Dec-12 $137,831.87 876 234 17.5 % 213 20.7 % 447 19.0 % 1159 1013

Q1 Jan $80,881.22 981 325 23.38% 251 21.1% 580 22.24% 1250 1092

Q1 Feb $99,757.95 905 323 17.03% 188 9.6% 515 14.17% 1269 1123

Q1 Mar $85,420.18 974 296 17.91% 214 14.0% 511 16.24% 1317 1160

Q2 Apr $83,753.58 1,061 216 18.10% 176 13.6% 393 16.00% 1331 1145

Q2 May $108,427.14 1,044 266 14.30% 182 11.5% 448 13.20% 1337 1164

Q2 June $91,094.12 991 241 14.50% 181 10.5% 422 12.80% 1357 1196

Q3 July $88,506.96 1,099 235 17.00% 221 9.5% 456 13.40% 1365 1224

Q3 Aug $95,653.93 1,257 251 24.30% 212 26.9% 466 25.30% 1440 1315

Q3 Sept $97,688.83 1,294 252 26.60% 161 26.7% 413 26.60% 1507 1357

Q4 Oct $108,511.39 1,428 280 29.60% 162 19.1% 442 25.80% 1557 1451

Q4 Nov $100,668.74 1,317 197 33.50% 148 20.9% 349 28.10% 1623 1445

Q4 Dec $161,473.84 1,238 220 30.50% 156 28.2% 377 29.40% 1659 1572

Year AVG $100,153.16 1,132 259 22.23% 188 18% 448 20.27% 1,418 1,270

****, Over 12 months: * 52% increase Member Dues from January to December 2013 * 44% increase in Active Members from January to December 2013 * 32% increase in Adj. Gross rev. growth (Gross minus skewed GC Rev) from January to December (Continuous decrease in prospect revenue drove down adj. gross rev. %, but was needed) * 35% avg increase in Member Bookings/Services from January to December 2013 (Dec & Nov had about 3-4 days of closures with bad weather and holidays so Dec had 26% while, October, no closed days or holidays, had a 45% increase in member services) * With a skyrocketing cost of living and non proportionate compensation for employees, due to the boom which is the city's primary industry.

© William Shonk 2015, unauthorized use and possession is prohibited.

Page 2: Clinic analysis 2013 Sharable Midland PDF LINKEDIN

876

981 905

974 1,061 1,044

991 1,099

1,257 1,294

1,428

1,317 1,238

447

580 515 511

393 448 422 456 466

413 442

349 377

300 400 500 600 700 800 900

1,000 1,100 1,200 1,300 1,400 1,500

Dec-12 Q1 Jan Q1 Feb Q1 Mar Q2 Apr Q2 May Q2 June Q3 July Q3 Aug Q3 Sept Q4 Oct Q4 Nov Q4 Dec

Bookings by Member vs Prospect Member Services

Prospects

1159

1250 1269

1317 1331 1337 1357 1365

1440

1507 1557

1623 1659

1013

1092 1123

1160 1145 1164 1196

1224

1315 1357

1451 1445

1572

1000 1050 1100 1150 1200 1250 1300 1350 1400 1450 1500 1550 1600 1650 1700

Dec-12 Q1 Jan Q1 Feb Q1 Mar Q2 Apr Q2 May Q2 June Q3 July Q3 Aug Q3 Sept Q4 Oct Q4 Nov Q4 Dec

Total members vs Active Members Total Mem

Active Mem

© William Shonk 2015, unauthorized use and possession is prohibited.

Page 3: Clinic analysis 2013 Sharable Midland PDF LINKEDIN

Mem Dues D

u

A

u

V

G

G

i

Gift

Card

Avg

$

Retail

Rev

Adj Gross rev Inactive Mem % Upgrades % Facials Avg $ retail / facial

49,063$ 63,165$ 71$ 1,102$ $82,167 13% 3%

49,940$ 8,197$ 85$ 1,683$ $80,881 13% 5% 55 30.60$

54,616$ 20,643$ 75$ 1,276$ $85,899 12% 5% 69 18.49$

56,048$ 7,721$ 73$ 2,154$ $85,420 12% 7% 69 31.21$

56,222$ 7,011$ 72$ 1,991$ $83,754 14% 7% 162 12.29$

57,758$ 28,163$ 70$ 2,358$ $87,049 13% 10% 121 19.49$

59,538$ 11,344$ 77$ 2,479$ $86,535 12% 9% 136 18.23$

61,314$ 7,046$ 72 1,808$ $88,507 10% 8% 99 18.26$

62,928$ 5,970$ 71 1,996$ $95,654 9% 10% 86 23.21$

65,582$ 4,936$ 74 1,810$ $97,689 10% 12% 92 19.67$

72,464$ 7,105$ 75 1,972$ $108,511 7% 10% 135 14.61$

69,711$ 6,290$ 68 2,073$ $100,669 11% 11% 90 23.03$

76,165$ 61,764 74 1,631$ $106,494 5% 10% 78 20.91$

$61,857 6,784$ $74 $1,936 # $92,255.15 11% 9% $99 $20.83

***

Adj Gross Member Dues Active Mem Mem bookingscont'd Oct

0.316675537 0.525130156 0.43956044 0.262621 0.456399796

$106,494.32 76,165$ 1572 1238 1428

Mem base v Mem Serve

=

0.113717491

© William Shonk 2015, unauthorized use and possession is prohibited.

Page 4: Clinic analysis 2013 Sharable Midland PDF LINKEDIN

$49,063 $49,940

$54,616 $56,048 $56,222 $57,758 $59,538 $61,314

$62,928 $65,582 $72,464

$69,711

$76,165 $82,167

$80,881

$85,899 $85,420 $83,754 $87,049 $86,535

$88,507

$95,654 $97,689

$108,511

$100,669

$106,494

$45,000

$55,000

$65,000

$75,000

$85,000

$95,000

$105,000

$115,000

Dec-12 Q1 Jan Q1 Feb Q1 Mar Q2 Apr Q2 May Q2 June Q3 July Q3 Aug Q3 Sept Q4 Oct Q4 Nov Q4 Dec

Mem dues vs Adj Gross Rev Mem Dues Adj Gross rev

$30.60 $18.49

$31.21

$12.29

$19.49 $18.23 $18.26 $23.21 $19.67

$14.61 $23.03 $20.91

55 69 69

162

121 136

99 86 92

135

90 78

$-

$20.00

$40.00

$60.00

$80.00

$100.00

$120.00

$140.00

$160.00

$180.00

$200.00

Q1 Jan Q1 Feb Q1 Mar Q2 Apr Q2 May Q2 June Q3 July Q3 Aug Q3 Sept Q4 Oct Q4 Nov Q4 Dec

Facial Quantity vs Retail $ Amount

Facials

Avg $ retail / facial

© William Shonk 2015, unauthorized use and possession is prohibited.


Top Related