1 day snapshot.xlsx

This is an operational data snapshot file from a Consolidated Mail Outpatient Pharmacy (CMOP) facility showing prescription order processing details for a single day. The spreadsheet contains granular transaction-level data for 16 orders across multiple order splits and detail records, tracking individual prescription items from receipt through picking, verification, and packing stages.

The dataset captures critical pharmacy operations metrics including order identifiers, product codes, National Drug Codes (NDCs), quantities requested and picked, days supply, pack sizes, unit types (tablets, capsules, each), bin locations, volumes, weights, and timestamps at each processing stage (picking, verification, packing completion). The data reflects high-volume pharmaceutical processing typical of the Dallas CMOP facility, which operates at approximately 90,000 prescriptions per day. Orders contain multiple items with varying quantities ranging from 3 to 540 units, days supply from 30 to 90 days, and processing times tracked in hours and minutes. Exception codes and cancellation data fields are present but unused in this snapshot, indicating standard processing without delays or order modifications. The file demonstrates the operational complexity and automation requirements necessary to maintain accuracy and efficiency in centralized prescription fulfillment operations serving Veterans Health Administration medical centers and community-based outpatient clinics nationwide.