H. B. MAGRUDER MEMORIAL HOSPITAL (CAH361314-00)

Critical access hospital, Ohio, calendar year 2025. Everything below is as the workbook stored it, with figures shown to the cent. Each section follows the Ohio Department of Health's template, in its order and words.

The name is HRSA's, from its public list of covered entities read on 11 November 2026. The workbook prints the 340B ID and no name.

About this workbook

340B ID
  • CAH361314-00 H. B. MAGRUDER MEMORIAL HOSPITAL (Critical access hospital)
Reporting period as typed
January 1, 2025 - December 31, 2025
Form
Ohio Department of Health, ORC 3701.88 340B Covered Entity Reporting Template, calendar year 2025

Drugs dispensed in house

Drugs the covered entity dispensed through its own pharmacies.

Drugs dispensed in house, as stored, for H. B. MAGRUDER MEMORIAL HOSPITAL (CAH361314-00)
Row of the templateCommercial Insurance/Private InsuranceMedicareMedicaid (all states)Other Third-Party PayorUninsured/Self-PayTotal
Acquisition costAggregate Acquisition Cost for all 340B drugs dispensed by the Covered Entity$89,186.94$55,103.53$0$245.05$3,888.08$148,423.60
Payments receivedAggregate Payments Received for all 340B drugs dispensed by the Covered Entity$223,947.43$220,098.42$0$853.49$20,877.49$465,776.83
All prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B and non-340B)24,95723,36310,440426,73965,541
340B prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B)5,0093,9430171,57910,548
Percentage that were 340BPercentage of total prescriptions that were 340B20.07%16.88%0%40.48%23.43%16.09%

Drugs dispensed through contract pharmacies

Drugs contract pharmacies dispensed on behalf of the covered entity.

Drugs dispensed through contract pharmacies, as stored, for H. B. MAGRUDER MEMORIAL HOSPITAL (CAH361314-00)
Row of the templateCommercial Insurance/Private InsuranceMedicareMedicaid (all states)Other Third-Party PayorUninsured/Self-PayIndeterminate (Explain)Total
Acquisition costAggregate Acquisition Cost for all 340B drugs dispensed by all Contract Pharmacies on behalf of the Covered Entity above:$13,729.95$368,753$0$0$81.05$0$382,564
Payments receivedAggregate Payments Received for all 340B drugs dispensed by all Contract Pharmacies on behalf of the Covered Entity above:$25,490.05$608,285$0$362.97$0$634,138.02
All prescriptionsTotal number of Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity (340B and non-340B):Withheldnext to a small count10100Withheldfewer than 60147
340B prescriptionsTotal number of 340B Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity:Withheldnext to a small count10100Withheldfewer than 60147
Percentage that were 340BPercentage of total Covered-Entity associated prescriptions that were 340B:Withheldwould show a small count100%#DIV/0!#DIV/0!Withheldwould show a small count#DIV/0!100%

Drugs administered

Drugs the covered entity administered, for example by infusion or injection.

Drugs administered, as stored, for H. B. MAGRUDER MEMORIAL HOSPITAL (CAH361314-00)
Row of the templateCommercial Insurance/Private InsuranceMedicareMedicaid (all states)Other Third-Party PayorUninsured/Self-PayTotal
Acquisition costAggregate Acquisition Cost for all 340B drugs administered by the Covered Entity$37,230.11$44,615.36$0$38.86$589.25$82,473.58
Actual paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - Actual Payments$0$0$0$0$0$0
Estimated paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - Estimated Payments*$757,470.44$912,378.88$0$355.65$0$1,670,204.97
Total paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - TOTAL$0$0$0$0$0$0
All prescriptionsTotal number of Prescriptions administered by the Covered Entity (340B and non-340B)35,67067,076102997- This is total doses administered in hospital both IP and OP status across all insurance companies, unable to break down specific number of Medicaid dispenses.18071102,997
340B prescriptionsTotal number of Prescriptions administered by the Covered Entity (340B)6,01010,427Zero- Medicaid is carved out281116,476
Percentage that were 340BPercentage of total prescriptions that were 340B16.85%15.55%#VALUE!15.56%15.49%16%

Figures are shown to the cent. The downloads keep each figure exactly as it is written in the file, and the cell file lists the workbook cell each one was read from.

Cells marked Withheld. A count of prescriptions from 1 to 5 is never published, and neither is a figure that would let a reader work one out.

  • The figure is not withheld because it is small. Next to the printed totals it would let a reader work out a count of 1 to 5 in another cell.
  • The count of prescriptions is 1 to 5. A count that small is never published, here or in the data files.
  • The percentage would let a reader work out a count of 1 to 5 in another cell.

Costs of running the program

Amounts in US dollars, as the workbook stores them.

Costs, as stored, for H. B. MAGRUDER MEMORIAL HOSPITAL (CAH361314-00)
CostAmountCell
Contract pharmacies$93,180C46
Third-party administrators$45,993C47
Consultants-C48
Software and IT-C49
Other outside costs-C50
Staffing$32,657.66C53
Internal IT-C54
Other internal costs-C55

Contract pharmacies

Number of contract pharmacies as typed
3

Explanation of the Indeterminate column, as typed

Used 340b # as total # due to only 340b prescriptions were filled on our behalf, the rest of all prescriptions were filled of the contract pharmacy's own business structure and we were not involved.

Uses of 340B funds

What the filer typed under the template's questions about how it uses the money 340B brings in. A dash or an empty cell is left out.

Uses of 340B funds, as typed, for H. B. MAGRUDER MEMORIAL HOSPITAL (CAH361314-00)
KindDescriptionAmountCell
Program or serviceOpen Magruder Pharmacy at Bassetts Pharmacy to support community in the wake of Rite Aid closures and employ pharmacy staff. Recognized losses of having the pharmacy open for 2025.$289,657C65
Program or serviceOpening Vein and Body office to improve patient access to diverse services within the Port Clinton area. This office was being shut down in neighboring town and we were able to keep staff employed while also bringing new product line and services to our facility.$393,730C66
Program or serviceAgency staffing of Lab due to difficulties of hiring and maintaining staff necessary for continued operations. These are expenses incurred above and beyond our expected costs.$205,310C67
Program or serviceAgency staffing of MedSurg Nursing due to difficulties of hiring and maintaining staff necessary for continued operations. These are expenses incurred above and beyond our expected costs.$630,914C68
Program or serviceAgency staffing of Radiology due to difficulties of hiring and maintaining staff necessary for continued operations. These are expenses incurred above and beyond our expected costs.$441,942C69
ItemPhone system upgrade to maintain security, prevent cybersecurity incidents, and improve workflows/resource availability for all involved.$106,168C72
ItemC-Arm for Radiology department$122,908C73
ItemOpening of Neurology clinic to provide local care of patients without traveling to surrounding cities.$10,819C74
ItemRenovations of Physical Therapy area to continue to safely and effectively care for our older population in the area and enable their return to home at a prior or better level of mobility.$61,378C75

Narrative, as typed

We are a small community hospital but care for our older patient population and are the only hospital in our county. 340b savings are utilized in keeping our doors open and enabling renovations, staffing, and continued care for the patients in our area.

The filer in the workbook

340B ID as typed
CAH361314-00
NPIs as typed
  • 1922079532
  • 1740647031
  • 1952122236

Differences in this workbook

This workbook has 4 places where two of its figures differ. Nothing was changed; both figures are kept as stored.

  1. Administered drugs, commercial column: total payments equal actual payments plus estimated payments

    Expected
    757,470.44
    Stored
    0
    Difference
    -757,470.44

    Administered drugs, commercial column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 757,470.44.

    The form itself says the two figures agree. Rule administered_payments_total.commercial=actual+estimated in Methods.

  2. Administered drugs, medicare column: total payments equal actual payments plus estimated payments

    Expected
    912,378.88
    Stored
    0
    Difference
    -912,378.88

    Administered drugs, medicare column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 912,378.88.

    The form itself says the two figures agree. Rule administered_payments_total.medicare=actual+estimated in Methods.

  3. Administered drugs, other third party column: total payments equal actual payments plus estimated payments

    Expected
    355.65
    Stored
    0
    Difference
    -355.65

    Administered drugs, other third party column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 355.65.

    The form itself says the two figures agree. Rule administered_payments_total.other_third_party=actual+estimated in Methods.

  4. Administered drugs, total column: total payments equal actual payments plus estimated payments

    Expected
    1,670,204.9699999997
    Stored
    0
    Difference
    -1,670,204.9699999997

    Administered drugs, total column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 1,670,204.97.

    The form itself says the two figures agree. Rule administered_payments_total.total=actual+estimated in Methods.

Source

Workbook
Open CAH36131400.xlsx on the Ohio Department of Health's website
Size
22 KB
Retrieved
16 November 2026
SHA-256
9a905815d77a8db692d00f61c8d6cd301d1aa8018105a9a7d7e81604db9a4608
How it was read
Two separate programs read each cell of the workbook, and a value is kept when their reads agree. The cells of this workbook are listed one by one in the dataset repository.