Back to Case Studies

A lightweight procurement calculator for sterile drugs that turns messy dosing, vial, and compliance rules into fast, defensible purchasing math.

Overview

SterileCalc is a user-friendly web application designed for healthcare professionals and clinic operators who are new to sterile drug procurement. It provides quick, accurate calculations that routinely slow down purchasing decisions: injection volume conversions across changing strengths, cost per dose under real-world handling rules, doses per unit based on vial constraints, and days remaining until Best Use Date (BUD).

The app is intentionally lightweight (static web) and works offline once loaded, making it practical for busy operators who need answers in the moment, not a complex platform rollout.

Context / Risk

Sterile drug purchasing is full of hidden "gotchas" that directly affect patient safety, compliance exposure, and cost. Small mistakes compound quickly: ordering the wrong strength for a protocol, misjudging how many usable doses are available before disposal rules apply, or underestimating waste for preservative-free vials. For teams without procurement experience, these calculations are frequently done ad hoc in spreadsheets, by memory, or not at all.

SterileCalc reduces that risk by encoding the math and the rules into a simple tool that provides real-time feedback as inputs change.

The Problem

New procurement stakeholders often inherit sterile sourcing responsibilities without the context required to price and compare products correctly. The same drug can appear in multiple strengths, vial sizes, and packaging formats, with different waste characteristics depending on:

  • Prescribed dose and dosing frequency
  • Drug concentration (strength per mL)
  • Vial size and pack quantity
  • Preservative status (preserved vs preservative-free)
  • Supplier type and regulatory constraints (503A patient-specific vs 503B/commercial shared use)
  • USP <797> handling guidance for puncture/disposal windows
  • Best Use Date (BUD) and shelf-life expectations

Without a consistent calculator, teams struggle to compare options apples-to-apples, especially when switching suppliers during shortages.

Why Existing Approaches Failed

Most teams try to solve these calculations with one-off spreadsheets, tribal knowledge, or scattered notes. That approach breaks down because:

  • Spreadsheets rarely enforce unit consistency (mcg/mg/g) and are easy to mis-key.
  • Waste and disposal rules are often ignored or applied inconsistently across buyers.
  • 503A restrictions (patient-specific use) fundamentally change dose availability.
  • People need an answer quickly while evaluating quotes, not a "modeling project."

SterileCalc was built as a "fast truth" layer: transparent inputs, immediate outputs, and logic aligned with real procurement constraints.

System Design

SterileCalc is a static web application built with HTML/CSS/JavaScript to maximize speed, accessibility, and portability. The interface is optimized for use on both desktop and mobile devices, and the app works offline once loaded.

Core Design Principles

  • Right-sized: no backend required, fast load, low maintenance.
  • Transparent: users can see exactly what assumptions drive results.
  • Constraint-aware: calculations incorporate real-world sterile rules and purchasing restrictions.
  • Immediate feedback: outputs update as inputs change to support quote evaluation and scenario checking.

Rule-Aware Logic

The calculators encode procurement-relevant sterile constraints including USP <797> puncture/disposal guidance and sourcing restrictions for 503A versus 503B/commercial purchasing.

  • Preservative-free products assume disposal after a short puncture window (higher waste risk).
  • Preserved products allow longer reuse windows (lower waste risk), bounded by BUD.
  • 503A purchases are treated as patient-specific, limiting usable doses per vial/unit based on a patient's 28-day protocol constraints.
  • 503B/commercial purchases assume shared use across patients (bulk in-office workflows).

Key Features

  • Injection Volume Converter: translate a prescribed dose into mL (and insulin "units") across changing strengths.
  • Doses per Unit: estimate usable doses in a purchasable unit based on strength, vial size, pack quantity, preservative status, and supplier type.
  • Cost per Dose: compute true per-dose cost using usable dose availability (not theoretical content).
  • Days Until BUD: quickly evaluate shelf-life risk against best use date.
  • Unit Toggle Support: handles mcg/mg/g conversions to reduce errors.
  • Offline-friendly: works offline once loaded in a browser.

Product Views

These screenshots highlight the application's core calculators and the procurement reasoning they support.

SterileCalc landing page and calculator hub

Lightweight navigation for quick access to the most common sterile purchasing calculations. Designed for speed and low cognitive load.

Calculate injection volume calculator

Converts prescribed dose and product strength into injection volume (mL) and insulin "units," supporting safe protocol translation across products with different concentrations.

Doses per package quantity calculator

Calculates usable doses per unit while honoring preservative status, USP <797> puncture/disposal guidance, and 503A patient-specific constraints versus 503B/commercial shared use.

Cost per dose calculator

Translates quote price into true per-dose cost based on usable doses (not theoretical content), enabling apples-to-apples vendor comparisons.

Days until best use date calculator

Quickly evaluates shelf-life runway between today and the product's BUD, supporting purchasing decisions that minimize expiration risk.

Decisions Enabled

  • Quote evaluation: compare products and suppliers using true cost-per-dose, not sticker price.
  • Waste-aware purchasing: quantify how preservative status and puncture rules change usable doses.
  • Compliance-aware workflows: incorporate 503A patient-specific constraints vs 503B/commercial bulk use.
  • Protocol fit checks: identify when a product's concentration creates impractical injection volumes.
  • Shelf-life planning: reduce expiration risk by checking days to BUD at the point of purchase.

Who This Was For

SterileCalc is built for non-procurement specialists who are responsible for buying and administering sterile drugs, including clinic operators, nurse-led practices, med spa owners, and new procurement stakeholders who need fast, reliable calculations without building complex spreadsheets.

Technical Notes

SterileCalc is implemented as a static site with vanilla JavaScript. Key implementation patterns include unit normalization (mcg/mg/g), defensive input validation, and transparent result strings designed to educate the user while answering the question.

  • Static web app: HTML/CSS/JS for speed, simplicity, and easy deployment.
  • Deterministic calculation functions: reusable functions for dose conversion, total content, doses per unit, cost per dose, and BUD math.
  • Rule-aware branching: distinct logic paths for 503A vs 503B/commercial and preservative-free vs preserved handling assumptions.
  • UX for clarity: inputs grouped by protocol, drug details, and supplier constraints to mirror how procurement evaluates products.

The app includes a clear disclaimer to reinforce that it supports procurement calculations and does not replace clinical judgment.