Pharmacy dashboard examples: inventory and operations

Pharmacy dashboard examples are most useful when they compare aggregate prescription volume, inventory aging, and operating margin for the same branches and period. The operating question is whether a branch's workload, stock investment, and earnings move together. Use business exports with no patient information, and keep clinical decisions outside this review.

Start with a branch operating layout

Use a summary strip for total completed prescriptions, recognized net revenue, operating income, and closing inventory. Under it, put branches in rows with the same measures in columns. A separate inventory table should show the age of stock on hand at the reporting date.

This arrangement lets an operations manager distinguish a busy branch with weak earnings from a smaller branch with healthy earnings. It also makes the stock discussion specific: inventory sitting at one branch should not disappear into a company average.

For this illustrative US pharmacy group, the period is September 2026 and the stock snapshot is September 30, 2026. Completed prescriptions exclude canceled or reversed dispensing records. Revenue is the finance-approved amount recognized for the period, after relevant reversals and adjustments; it is not the cash received that month.

Keep cost definitions visible. The IRS explanation of gross profit subtracts cost of goods sold from net receipts before business expenses. Here, operating income then subtracts the branch operating expenses assigned by finance. The worked figures are an operating illustration, not a tax calculation.

Prepare the exports before comparing branches

Bring a branch-period dispensing summary, a branch-period income statement, and a closing inventory valuation. Each should identify the branch and reporting date. The dispensing summary needs only aggregate completed counts; the financial file needs recognized net revenue, cost of goods sold, and operating expenses.

The inventory file needs receipt date, quantity remaining, inventory value at cost, and branch. Preserve any lot distinctions needed to identify the actual receipt still on hand. Do not assign every unit the most recent purchase date when older receipts remain.

Apply one branch mapping across all files. A branch rename must not create a new location in one table while its expenses stay under the old name in another. Match the expense basis as well: either allocate agreed central operating expenses consistently or show them separately from branch results.

The dedicated inventory aging by site guide covers the aging method in detail. This dashboard uses its finished age groups to support the branch review.

Example: volume and operating margin together

The following table contains all inputs needed for the income calculation. Dollar amounts are USD. Margins are rounded to one decimal place only after calculation.

Operating income = Net revenue - COGS - Operating expenses

Operating margin = Operating income / Net revenue

North produces 420,000 - 315,000 - 84,000 = $21,000 of operating income. The company produces 1,000,000 - 743,600 - 207,200 = $49,200. Its unrounded margin is 49,200 / 1,000,000 = 4.92%, displayed as 4.9%.

North has the largest prescription count, but Central contributes more operating income. That is the useful exception to discuss. Review revenue mix, acquisition costs, expense allocation, and adjustments before attributing the difference to staff productivity.

Keep gross profit margin and operating margin distinct. Gross profit here is 1,000,000 - 743,600 = $256,400; subtracting operating expenses explains the bridge to $49,200. Neither prescription count nor gross profit alone gives the branch operating result.

Add inventory age without confusing it with expiration

Use mutually exclusive age groups based on days since receipt. These values are the cost of stock still on hand, not its potential selling price.

The age groups reconcile: 213,000 + 43,000 + 24,000 = $280,000. Stock over 90 days is 43,000 + 24,000 = $67,000, or 67,000 / 280,000 = 23.9% of closing inventory, rounded to one decimal place.

Age is a purchasing and working-capital signal. Expiration is a different attribute: the FDA explains that labeled expiration dates concern stability under labeled storage conditions. Do not infer expiration or product suitability from an age group. The pharmacy's established inventory procedures govern those questions.

Change one input: higher South acquisition cost

Now increase only South's period COGS by $11,000. Leave revenue, prescription counts, operating expenses, and the closing stock snapshot unchanged. This is a sensitivity example for costs assigned to units already sold.

South now produces 220,000 - 180,400 - 44,000 = -$4,400. Company operating margin becomes 38,200 / 1,000,000 = 3.82%, displayed as 3.8%. The exact decline is 4.92% - 3.82% = 1.10 percentage points.

Volume does not change. A dashboard centered on prescriptions alone would miss the entire deterioration. Finance should confirm the cost posting; procurement and branch operations should investigate the commercial cause.

Checks and common mistakes

Before presenting the dashboard, tie prescription counts to the completed dispensing summary, revenue and expenses to the branch income statements, and inventory age groups to the closing valuation. Sum branch operating income and also calculate it independently from company totals. Both routes must return $49,200 in the original case.

• Mixing cash and revenue. Collections can relate to earlier periods. Compare recognized revenue with the costs assigned to that same period.
• Using purchases as COGS. Goods bought but still held belong in inventory. Purchase payments do not automatically represent the cost of the period's completed sales.
• Averaging branch margins. Divide total operating income by total net revenue. An equal average gives a small branch the same influence as a large one.
• Resetting age after a transfer. Preserve the relevant receipt history when stock moves between branches; a new location does not necessarily mean newly acquired inventory.

Assign the manager responsible for each exception and record the evidence needed for the next review. Keep unresolved reconciliation differences visible until finance or operations clears them.

Review your pharmacy exports in Covirage

Bring an aggregate branch operating summary and inventory valuation, with patient information excluded, as a file or Google Sheet. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for healthcare teams for the supporting industry context.