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.
| Row of the template | Commercial Insurance/Private Insurance | Medicare | Medicaid (all states) | Other Third-Party Payor | Uninsured/Self-Pay | Total |
|---|---|---|---|---|---|---|
| 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,957 | 23,363 | 10,440 | 42 | 6,739 | 65,541 |
| 340B prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B) | 5,009 | 3,943 | 0 | 17 | 1,579 | 10,548 |
| Percentage that were 340BPercentage of total prescriptions that were 340B | 20.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.
| Row of the template | Commercial Insurance/Private Insurance | Medicare | Medicaid (all states) | Other Third-Party Payor | Uninsured/Self-Pay | Indeterminate (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 count | 101 | 0 | 0 | Withheldfewer than 6 | 0 | 147 |
| 340B prescriptionsTotal number of 340B Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity: | Withheldnext to a small count | 101 | 0 | 0 | Withheldfewer than 6 | 0 | 147 |
| Percentage that were 340BPercentage of total Covered-Entity associated prescriptions that were 340B: | Withheldwould show a small count | 100% | #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.
| Row of the template | Commercial Insurance/Private Insurance | Medicare | Medicaid (all states) | Other Third-Party Payor | Uninsured/Self-Pay | Total |
|---|---|---|---|---|---|---|
| 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,670 | 67,076 | 102997- 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. | 180 | 71 | 102,997 |
| 340B prescriptionsTotal number of Prescriptions administered by the Covered Entity (340B) | 6,010 | 10,427 | Zero- Medicaid is carved out | 28 | 11 | 16,476 |
| Percentage that were 340BPercentage of total prescriptions that were 340B | 16.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.
| Cost | Amount | Cell |
|---|---|---|
| Contract pharmacies | $93,180 | C46 |
| Third-party administrators | $45,993 | C47 |
| Consultants | - | C48 |
| Software and IT | - | C49 |
| Other outside costs | - | C50 |
| Staffing | $32,657.66 | C53 |
| Internal IT | - | C54 |
| Other internal costs | - | C55 |
Contract pharmacies
- Number of contract pharmacies as typed
- 3
Explanation of the Indeterminate column, as typed
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.
| Kind | Description | Amount | Cell |
|---|---|---|---|
| Program or service | Open 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,657 | C65 |
| Program or service | Opening 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,730 | C66 |
| Program or service | Agency 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,310 | C67 |
| Program or service | Agency 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,914 | C68 |
| Program or service | Agency 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,942 | C69 |
| Item | Phone system upgrade to maintain security, prevent cybersecurity incidents, and improve workflows/resource availability for all involved. | $106,168 | C72 |
| Item | C-Arm for Radiology department | $122,908 | C73 |
| Item | Opening of Neurology clinic to provide local care of patients without traveling to surrounding cities. | $10,819 | C74 |
| Item | Renovations 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,378 | C75 |
Narrative, as typed
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.
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+estimatedin Methods.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+estimatedin Methods.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+estimatedin Methods.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+estimatedin 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.