APRIL NOT ON PACE
UPDATED CONTRACTION DATA
Mo ------- Rx -------- Rev ------ $/Rx ------ #
Prev Six Month Control # --------------- 625
Jan --- 15,500 --- $1.30M --- $84.00 --- 646
Feb --- 16,700 --- $1.10M --- $66.00 --- 696
Mar --- 18,600 --- $1.50M --- $83.00 --- 689
Apr --- 16,500 --- $1.40M --- $85.00 --- 635
May -- 17,500 --- $1.40M --- $80.00 --- 700
Jun --- 18,000 --- $1.70M --- $95.00 --- 692
All Months Exceed 625 Control #
Averaged 51 Extra Scripts Per W-Day
Now Creates A New 676 Control #
THEN ANOTHER GROWTH SPURT
New Six Month Control # --------------- 676
July --- 16,600 --- $1.50M --- $90.00 --- 664
Aug --- 20,000 --- $1.75M --- $87.00 --- 741
Sep --- 19,000 --- $1.60M --- $83.00 --- 760
Oct --- 18,600 --- $1.60M --- $86.00 --- 744
Nov --- 18,500 --- $1.70M --- $91.00 --- 771
Dec --- 18,000 --- $1.70M --- $95.00 --- 692
All But July Exceeds 676 Control #
Averaged 52 Extra Scripts Per W-Day
Now Creates A New 728 Control #
GROWTH HAS NOW FLATTENED
New Six Month Control # --------------- 728
Jan --- 17,500 --- $1.60M --- $91.00 --- 700
Feb --- 16,500 --- $1.50M --- $90.00 --- 717
Mar --- 18,500 --- $1.75M --- $94.00 --- 685
Apr --- 00,00? --- $0.0?M --- $00.0? --- 0?0
W-Day 728 Control Number Not Being Met
Scripts Avg Has Decreased 28 Per W-Day
A Topping-Out & Contraction Is Setting In
TREND SHOWS CONTRACTION
WHEN COMPARING 728 CONSTANT
A Number Above 728 = POS GROWTH
A Number Around 728 = NO GROWTH
A Number Below 728 = NEG GROWTH
=================================
NEEDED TO JUST REMAIN NEUTRAL
Jan Thru April Has 100 Working-Days
They Need To Beat 728 Avg Scripts / W-Day
To Continue With Any Kind Of Growth At All
So By End Of April They Should Have At
Least 72,800 Total Script Units (100 X 728)
So Far Jan-Mar Had A Total Of 52,500 Units
Which Means April Needs 20,300 Script Units
(72,800 Total - 52,500 So Far = 20,300 Needed)
And Since April Needs To Produce 20,300 Units
That Would Then Require 812 Scripts Per W-Day
In Order To Balance Out The 728 Control Number
(20,300 Units / 25 W-Days = 812 Needed For April)
Using The Q1 Avg Script $ Per Unit Of $91.79
The Total April Script Rev Should Be About :
(20,300 Units X $91.79 / Script) = $1,863,337
Then Add $10,000 For April "Service" Rev
Total April Revenue = $1,873,337
The 812 Is Needed To Just Remain Neutral
They Need To Exceed 812 To Show Any Growth
Anything Close To 812 Will Show Things Are Flat
Staying Below The 812 Will Show More Contraction
NEEDED FOR APRIL TO STAY FLAT
Scripts: 20,300 / 25 W-Days = 812
Rx Rev: 20,300 X $91.79 = $1,863,337
Estimated Service Rev = $10,000
Total Rev = $1,873,337
WILL APRIL EVEN BE ABLE TO MEET
THE ORIGINAL CONTROL NUMBER ?
Scripts: 18,200 / 25 W-Days = 728
Rx Rev: 18,200 X $91.79 = $1,670,578
Estimated Service Rev = $10,000
Total Revenue = $1,680,578
=================================
NOW WHAT ABOUT $22M FY REV
At An Average Of $91.79 Per Script
The Avg Scripts Needed Per W-Day
Is Far Above The 728 Control Number
And Now Becomes 812 Scripts Per W-Day
But Since Reality Is Falling Below Projections,
The 812 Number For April Needs To Be 1038
This Allows For A Generous $180K In
FY Serv Rev, Which Avgs $15K / Mo
NEEDED FOR APRIL TO
KEEP FY $22M ON TRACK
Scripts: 25,954 / 25 W-Days = 1038
Rx Rev: 25,954 X $91.79 = $2,382,318
Estimated Service Rev = $15,000
Total Revenue = $2,397,318
=================================
* C O N T R A C T I O N *
-------------- AND --------------
FAILED PROJECTIONS
JMO
AI
