MARY RUTAN HOSPITAL (SCH360197-00)

Sole community 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
  • SCH360197-00 MARY RUTAN HOSPITAL (Sole community 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 MARY RUTAN HOSPITAL (SCH360197-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$0$0$0$0$0$0
Payments receivedAggregate Payments Received for all 340B drugs dispensed by the Covered Entity$0$0$0$0$0$0
All prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B and non-340B)000000
340B prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B)000000
Percentage that were 340BPercentage of total prescriptions that were 340B#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Drugs dispensed through contract pharmacies

Drugs contract pharmacies dispensed on behalf of the covered entity.

Drugs dispensed through contract pharmacies, as stored, for MARY RUTAN HOSPITAL (SCH360197-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:$0$0$0$0$0$0$0
Payments receivedAggregate Payments Received for all 340B drugs dispensed by all Contract Pharmacies on behalf of the Covered Entity above:$0$0$0$0$0$0$0
All prescriptionsTotal number of Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity (340B and non-340B):0000000
340B prescriptionsTotal number of 340B Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity:0000000
Percentage that were 340BPercentage of total Covered-Entity associated prescriptions that were 340B:#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Drugs administered

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

Drugs administered, as stored, for MARY RUTAN HOSPITAL (SCH360197-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$0$0$0$0$0$418,396.41
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*$1,656,066$131,997$682,061$27,516$71,512$2,569,152
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)00000214,426
340B prescriptionsTotal number of Prescriptions administered by the Covered Entity (340B)00000104,590
Percentage that were 340BPercentage of total prescriptions that were 340B#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!48.78%

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.

Costs of running the program

Amounts in US dollars, as the workbook stores them.

Costs, as stored, for MARY RUTAN HOSPITAL (SCH360197-00)
CostAmountCell
Contract pharmacies-C46
Third-party administrators$21,150C47
Consultants-C48
Software and IT-C49
Other outside costs-C50
Staffing$22,440C53
Internal IT-C54
Other internal costs-C55

Contract pharmacies

Number of contract pharmacies as typed
0

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.

Narrative given where the entity cannot detail its uses, as typed

Our contribution to the operating margin from the 340B program are used to support costs of treating uninsured patients in our community as well as unreimbursed costs of treating Medicaid and Medicare patients. There are many service lines provided by our sole community hospital that are not profitable but are critical for our patient population.

The filer in the workbook

340B ID as typed
SCH36019700
NPIs as typed
  • 1548254931

Cells outside the template

The filer typed text in cells the template does not ask for. They are listed as found, by cell.

Cells outside the template, as typed, for MARY RUTAN HOSPITAL (SCH360197-00)
CellText
D82391638.53

Differences in this workbook

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

  1. The five payer cells of aggregate acquisition cost administered add up to the Total cell

    Expected
    0
    Stored
    418,396.41
    Difference
    418,396.41

    Aggregate acquisition cost, administered drugs. The total cell holds 418,396.41. The five payer cells add to 0.00.

    The form itself says the two figures agree. Rule administered_acquisition_cost.rows=total in Methods.

  2. The five payer cells of total prescriptions administered add up to the Total cell

    Expected
    0
    Stored
    214,426
    Difference
    214,426

    Total prescriptions, administered drugs. The total cell holds 214,426. The five payer cells add to 0.

    The form itself says the two figures agree. Rule administered_rx_all.rows=total in Methods.

  3. The five payer cells of 340B prescriptions administered add up to the Total cell

    Expected
    0
    Stored
    104,590
    Difference
    104,590

    340b prescriptions, administered drugs. The total cell holds 104,590. The five payer cells add to 0.

    The form itself says the two figures agree. Rule administered_rx_340b.rows=total in Methods.

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

    Expected
    1,656,066
    Stored
    0
    Difference
    -1,656,066

    Administered drugs, commercial column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 1,656,066.00.

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

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

    Expected
    131,997
    Stored
    0
    Difference
    -131,997

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

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

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

    Expected
    682,061
    Stored
    0
    Difference
    -682,061

    Administered drugs, medicaid column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 682,061.00.

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

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

    Expected
    27,516
    Stored
    0
    Difference
    -27,516

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

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

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

    Expected
    71,512
    Stored
    0
    Difference
    -71,512

    Administered drugs, uninsured column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 71,512.00.

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

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

    Expected
    2,569,152
    Stored
    0
    Difference
    -2,569,152

    Administered drugs, total column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 2,569,152.00.

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

Source

Workbook
Open SCH36019700.xlsx on the Ohio Department of Health's website
Size
22 KB
Retrieved
16 November 2026
SHA-256
d450b92335142ff8f66989cc917a91187edc667fb437ce474f75db8a4521fc80
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.