Loading chart
Loading chart
Loading chart
Loading chart
Retail Pharmacy Chain
Enterprise
Pelloway Pharmacy
Script volume, generic dispensing, adherence, and payer reimbursement
50% OFF
$12.00$6.00USD, plus applicable tax
18 tables2.7M rowsParquet + CSV
About Pelloway Pharmacy
Industry
Retail Pharmacy Chain
Company size
Fictional large regional chain with 42 stores across six districts.
Pharmacy volume
About 775,000 prescriptions filled per year, roughly 1.55M across the two-year window.
Total revenue
Roughly $290M to $310M in total chain revenue across the two-year window, blending pharmacy and front-of-store.
Pharmacy revenue
Near $100M per year in dispensed-prescription revenue at about $134 per script.
Gross margin
Around $19M per year in pharmacy gross margin, near 18 to 19 percent.
Generic dispensing rate
About 78 percent of fills dispensed as generic.
Patients and prescribers
360,000 fictional patients and 3,200 prescribers.
Product catalogue
900 invented drug products across 16 therapeutic classes and 13 fictional labelers.
Clinical services
About 69,000 immunizations administered per year across five vaccine types.
Pelloway Pharmacy is a fictional regional retail pharmacy chain used for synthetic BI analysis. The company story is built around a portfolio of neighborhood pharmacy stores, the prescriptions they fill, the patients and prescribers behind those scripts, the payers and pharmacy-benefit plans that reimburse them, and the front-of-store retail that rounds out each location. Everything here is invented for analytics practice. No real pharmacy chain, retailer, drug manufacturer, payer, prescriber, or patient is represented, and every drug name is fabricated rather than tied to a real product.
Operating Profile
- Runs a community-pharmacy model: each store fills prescriptions, administers vaccines, runs therapy reviews, and sells a front-of-store assortment.
- Economics center on claim adjudication: every fill carries ingredient cost, dispensing fee, copay, and third-party reimbursement.
- High-volume chronic classes drive script counts and adherence economics, while acute classes turn over faster at thinner per-script value.
- Front-of-store is a monthly category sales snapshot, and the store and prescriber scorecards are monthly rollups of the dispensing detail.
- Adherence is a monthly quality-measure cohort panel tracking one chronic programme per enrolled patient, kept alongside dispensing rather than derived from it.
- Excludes real National Drug Codes, formularies, plan names, protected health information, labor scheduling, and full ledger.
Recent Business Events
- 1The fall cold-and-flu season is an executive focus because immunizations and respiratory fills lift sharply and pull store traffic with them.
- 2A push on generic dispensing and chronic-therapy adherence is reshaping per-script margin and the days-covered cohorts behind star ratings.
- 3Leadership wants one view connecting script volume, margin, adherence, payer reimbursement, inventory, and front-of-store performance.
KPI Focus Areas
These are the operating questions this kit is optimized to answer first.
01Focus
Script volume, revenue, and gross margin by store, region, prescriber, and therapeutic class
02Focus
Generic dispensing rate, ingredient cost, copay, and reimbursement by plan type
03Focus
Proportion of days covered and adherence band by therapeutic class
04Focus
Claims billed, reimbursed, rejected, and days in accounts receivable by plan
05Focus
Inventory turns and on-hand value by drug category
06Focus
Front-of-store sales and margin by retail category, plus vaccine mix by season and age band
Embedded Analytical Stories
Seasonal dispensing
Script volume, gross margin, and influenza doses all rise through the fall cold-and-flu season and ease in summer.
The generic lever
Generics are about 78 percent of fills at low ingredient cost, so the brand-generic mix drives per-script margin.
Chronic backbone
Cardiovascular, cholesterol, diabetes, thyroid, and mental-health classes dominate script volume and anchor the chronic side.
Payer behaviour
Plan type drives reimbursement, rejection, copay, and receivable days, separating Medicaid and Medicare from commercial.
Scorecard drillthrough
Store and prescriber scorecards are sums of the dispensing detail, so both trace back to individual fills.
Revenue gate
Only fills that reached the patient carry money, with an explicit dispensed flag separating returns and will-call waits.
Pelloway Pharmacy
Buy Now$6.00USD, plus applicable tax