County Profile for Franklin - 2018



County Controls Information

Cost Report Counts Population
Total Hospital Count 2 Total Population on July 31, 2018 0
Total Cost Reports Filed in 2018 4 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 4 Net Population Natural Change 0
Total Cost Reports Reopened 0 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 0 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 19,084,309 Total Charges 228,402,716
Fixed Assets 24,555,183 Contract Allowance 131,466,980
Other Assets 6,958,823 Operating Revenue 96,935,736
Total Assets 50,598,315 Operating Expenses 109,030,257
Current Liabilities 10,493,961 Operating Margin -12,094,521
Long Term Liabilities 19,248,901 Other Income 3,767,893
Total Equity 20,855,453 Other Expense 0
Total Liabilities and Equity 50,598,315 Net Profit or Loss -8,326,628

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $39,405 Revenue per Bed $2,203,085 Revenue per Person $96,935,736
Net Margin per Discharge ($4,916) Net Margin per Bed ($274,875) Net Margin per Person ($12,094,521)
Net Profit per Discharge ($3,385) Net Profit per Bed ($189,242) Net Profit per Person ($8,326,628)
Net Fixed Assets per Discharge $9,982 Net Fixed Assets per Bed $558,072 Net Fixed Assets per Bed $24,555,183
Long Term Debt per Discharge $7,825 Long Term Debt per Bed $437,475 Long Term Debt per Person $19,248,901
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 40.9 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,095 Net Fixed Assets 1,311 Population Estimate 1,151
Total Revenue 975 Long Term Liabilities 1,032 Total Patient Discharges 1,071
Net Margin 2,893 Total Patient Beds 1,340
Net Profit or Loss 3,095

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 11,438,977 21,244,195 0.5385
31 Intensive Care Unit 979,405 2,009,957 0.4873
32 Coronary Care Unit 0 0
43 Nursery 1,397,212 1,218,941 1.1463
44 Skilled Nursing Care 0 0
50 Operating Room 10,490,741 24,931,418 0.4208
51 Recovery Room 0 0
52 Labor and Delivery Room 225,930 329,416 0.6859

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,512,450 13 Nursing Administration 832,342
02,03 Captial Related - Movable Equipment 1,487,112 14 Central Services and Supply 1,163,419
04 Employee Benefits 9,555,355 15 Pharmacy 709,930
05 Administrative and General 22,183,989 16 Medical Records and Medical Library 1,332,820
06 Maintenance and Repairs 1,490,391 17 Social Services 215,862
07 Operation of Plant 1,331,827 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 1,545,269 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 1,068,134 20,21,22,23 Education Programs 0
Total General Service Cost Centers 46,428,900

County Profile for Franklin - 2018