Vaccine Sales Dashboard

Clinic assumptions

Total Clinic Events 2,200

Flu Profit per Event $72

COVID Profit per Event $120

Customer Visit Frequency (Weekly) 0.51x

Visit likelihood multiplier scaling overall traffic potential.

Projected Average Clinic Output Baseline 30 Doses

Expected incremental vaccinations administered per clinic event.

Optimal Clinic Allocation Schedule

Calculated optimal placement of clinics across weekdays to maximize total yield based on foot traffic & visit multiplier

Daily Financial Projection & Scheduling Model

Weekday	Relative Traffic Index	Optimal Clinic Share	Recommended Clinic Count	Projected Profit
Total Schedule	100.0%	100.0%	2,200	$0

Phased Campaign Schedule & skip-week Calendar (FY27 Plan)

Operational timetable detailing when to run clinics, which weeks, and set-interval skip schedules

SET 1: Early Peak Campaign Wk 37 & 38

Dates: Sep 14, 2026 – Sep 26, 2026

Focuses on **Back-to-School** families and **Early Senior** vaccinations before the cold season.

Diamond Clubs: 6 straight days / week (Mon-Sat)
Gold Clubs: Monday & Friday only
Silver Clubs: Friday only

REPLENISHMENT: The Skip Week Wk 39

Dates: Sep 27, 2026 – Oct 3, 2026

**NO active clinics scheduled.** This 1-week break is operationally critical:

Allows warehouse/distributors to replenish cold-chain stock
Prevents clinical and pharmacy staff burnout
Gives space to review Set 1 data and adjust product targets

SET 2: Main Peak Campaign Wk 41 & 42

Dates: Oct 5, 2026 – Oct 17, 2026

Focuses on the **General Public** and late-season senior catch-ups during the absolute peak.

Diamond Clubs: Second 6-day stretch (Mon-Sat)
Gold Clubs: Second targeted set (Mon & Fri)
Silver Clubs: Second targeted set (Friday only)

Mathematical Allocation & Scheduling Model (Exact 2,350 Clinics)

The exact scheduling math distributed across clubs and weeks to meet your precise 2,350 clinic target

Club Tier	No. of Clubs	Clinics / Week	Active Weeks	Clinics / Club	Total Clinics
Tier 1: Diamond Clubs (Top 8.7%)	50 Clubs	6 Days / Wk	4 Weeks	15 Clinics	750 Clinics
Tier 2: Gold Clubs (Top 26%)	100 Clubs	2 Days / Wk (M/F)	4 Weeks	8 Clinics	800 Clinics
Tier 3: Silver Clubs (Top 61%)	200 Clubs	1 Day / Wk (Fri)	4 Weeks	4 Clinics	800 Clinics
Tier 4: Walk-In Only	224 Clubs	0 Days / Wk	0 Weeks	0 Clinics	0 Clinics
Grand Total Schedule	574 Clubs	—	—	—	2,350 Clinics

Allocation with Performance-Based Promotions (Actual)

66 clubs promoted based on LY output: >40 fills/clinic to Diamond, >30 to Gold, >18 to Silver = +707 clinics

Tier (Actual)	Clubs	Per Club	Total
Diamond	83	15	1,245
Gold	119	8	952
Silver	215	4	860
Bronze	157	0	0
TOTAL (With Promotions)	574	—	3,057 Clinics

Performance Promotion Impact:

66 clubs promoted from lower tiers based on LY performance
+707 additional clinics allocated vs. baseline
Baseline (rank-only): 2,350 clinics
Actual (with promotions): 3,057 clinics
Thresholds: >40 LY avg output = Diamond, >30 = Gold, >18 = Silver

Master Clinic Allocation Schedule (All 574 Clubs)

Full data schedule of active club clinic resources mapped by tiers

Show Clubs:

Proposed FY27 Clinics 2,200 Nationwide Target

LY Clinics Held (Flu+Covid) 0 Prior Year Total Events

LY Fills Achieved (Campaign) 0 Prior Year Total Output

LY Average Clinic Output 0.0 Fills / Clinic Event (LY)

Mathematical Allocation & Scheduling Model (Baseline)

The standard mathematically suggested clinic schedule distributed strictly by sales/fills rank:

CLUB TIER	NO. OF CLUBS	CLINICS / WEEK	ACTIVE WEEKS	CLINICS / CLUB	TOTAL CLINICS
Tier 1: Diamond (Top 3%)	15 Clubs	6 Days / Wk	4 Weeks	24 Clinics	360 Clinics
Tier 2: Gold (Top 10%)	20 Clubs	2 Days / Wk (M/F)	4 Weeks	8 Clinics	160 Clinics
Tier 3: Silver (Top 25%)	420 Clubs	1 Day / Wk (Fri)	4 Weeks	4 Clinics	1,680 Clinics
Tier 4: Walk-In Only	119 Clubs	0 Days / Wk	0 Weeks	0 Clinics	0 Clinics
Grand Total Suggested	574 Clubs	—	—	—	2,350 Clinics

Actual Adjusted Model (Manual Overrides & Tuning)

Your live customized clinic schedule incorporating all active manual overrides in real-time:

CLUB TIER	NO. OF CLUBS	CLINICS / WEEK	ACTIVE WEEKS	CLINICS / CLUB	TOTAL CLINICS
Tier 1: Diamond	83 Clubs	6 Days / Wk	4 Weeks	15 Clinics	1,245 Clinics
Tier 2: Gold	119 Clubs	2 Days / Wk	4 Weeks	8 Clinics	952 Clinics
Tier 3: Silver	215 Clubs	1 Day / Wk	4 Weeks	4 Clinics	860 Clinics
Tier 4: Walk-In Only	157 Clubs	0 Days / Wk	0 Weeks	0 Clinics	0 Clinics
Grand Total Actual	574 Clubs	—	—	—	3,057 Clinics

Tier Clinic Settings & Tuning

Customize the number of clinic events allocated to each tier for the currently selected Region or nationally.

Tuning Scope (Region Selection)

Diamond Tier Clinics Default: 24 (6 Days × 4 Wks)

Gold Tier Clinics Default: 8 (2 Days × 4 Wks)

Silver Tier Clinics Default: 4 (1 Day × 4 Wks)

Bronze Tier Clinics Default: 0 (Walk-In Only)

Geographic Summary: Regions

Click on a Region to audit its Markets and filter the table below:

Geographic Summary: Markets

Select a Region on the left to see its Markets:

FY27 Proposed Clinics vs. LY Performance Review

Paging list of all 574 clubs sorted by Suggested Rank

Rank	Club	Region	Market	Suggested Tier	Proposed Clinics	LY Clinics Held	LY Flu Fills	LY Covid Fills	LY Total Fills	LY Avg Output	LY Best Week	Manual Override

Showing 1 to 50 of 574 clubs

➕ Schedule New Clinic Event

Clinic Date *

Club Number *

Hours

Pharmacists

Techs

New Transfers (opt)

Clinic Type *

Notes (opt)

Status	Date ▲	Club	Pre-Order	Hours	Pharmacists	Techs	New Transfers	Clinic Type	Notes	Actions
No clinic events yet. Schedule one above ↑

➕ New Order Request

Requestor Name *

Market # *

Club # *

Request Date *

Clinic / Event?

Comments / Reason

Doses Requested by Product

📂

Click or drag the Excel file here

IMZ 25-26 Replenishment.xlsx · WRO tab parsed automatically

Once loaded, data persists for all users until refreshed

📅 Data as of: —

🔄 Last refreshed: —

— clubs

View

Products

Columns

| WoH ≤ BOH Cur ≤ BOH Aft ≤

Season Summary — Flu vs COVID

Weeks – Compare:

🌡️ 2027: % 💉 2027: %

Target Progress Tracker (2027 Season Pace)

Flu Actuals to Date 0% vs. Target

Est. Target:

Actuals to Date:

COVID Actuals to Date 0% vs. Target

Est. Target:

Actuals to Date:

Dose Portfolio Split Mix

Focus Yr:

Flu: 0%

COVID: 0%

Clinic Financial Spend & Staffing Allocation Analyzer

Compare historical FY26 spend against live projected & completed FY27 planned spend based on pharmacist and technician hourly rates.

PHARMACIST RATE / HR $

TECHNICIAN RATE / HR $

HIERARCHY	FY 2026 SPEND	PROJECTED CLINICS	ACTUALIZED CLINICS	PROJECTED SPEND	ACTUALIZED SPEND

Disease:

Year

Wk to

Show

All Regions

All Markets

Select a Market

📂 Load Full Season ➕ Add Incremental Weeks

📂 Upload Classification File

Loading… | Not loaded.

NDC / GPI	Drug Name	Category	Display Name (optional)
No drugs loaded yet.

🔐 User Access Management

📂 Upload User File

Role Permissions — check a role to grant access to all users in it; admins may override individuals via Edit

Role	State Map	Management	Rankings	Clinic Optimizer	LY Performance	Combined	Flu	COVID	Clinics	WRO	Order Requests	Master Data	Security

Name	User ID	Email	Role	Regions	Markets	Clubs	Active	State Map	Management	Rankings	Clinic Optimizer	LY Performance	Combined	Flu	COVID	Clinics	WRO	Order Requests	Master Data	Security	Actions
Loading…