County Profile for Franklin - 2023



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2023 70,836
Total Cost Reports Filed in 2023 1 Total Births 495
Total Cost Reports Submitted 1 Total Deaths 754
Total Cost Reports Settled 0 Net Population Natural Change -259
Total Cost Reports Reopened 0 Total International Migration 152
Total Cost Reports Ammended 0 Total Domestic Migration -51
Total Cost Reports Audited 0 Total Residual -1
Net Population Change -159

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 20,126,440 Total Charges 335,854,517
Fixed Assets 46,949,053 Contract Allowance 220,563,943
Other Assets 881,589 Operating Revenue 115,290,574
Total Assets 67,957,082 Operating Expenses 128,288,403
Current Liabilities 18,136,246 Operating Margin -12,997,829
Long Term Liabilities 22,245,505 Other Income 11,007,599
Total Equity 27,575,331 Other Expense 0
Total Liabilities and Equity 67,957,082 Net Profit or Loss -1,990,230

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $26,208 Revenue per Bed $1,372,507 Revenue per Person $1,628
Net Margin per Discharge ($2,955) Net Margin per Bed ($154,736) Net Margin per Person ($183)
Net Profit per Discharge ($452) Net Profit per Bed ($23,693) Net Profit per Person ($28)
Net Fixed Assets per Discharge $10,673 Net Fixed Assets per Bed $558,917 Net Fixed Assets per Bed $663
Long Term Debt per Discharge $5,057 Long Term Debt per Bed $264,827 Long Term Debt per Person $314
Persons per Discharge 0 Persons per Bed 843
Occupancy Rate 60.3 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,037 Net Fixed Assets 1,024 Population Estimate 776
Total Revenue 1,007 Long Term Liabilities 945 Total Patient Discharges 811
Net Margin 2,706 Total Patient Beds 936
Net Profit or Loss 2,734

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 32,087,529 32,343,310 0.9921
31 Intensive Care Unit 3,023,502 2,438,963 1.2397
32 Coronary Care Unit 0 0
43 Nursery 921,729 1,504,420 0.6127
44 Skilled Nursing Care 0 0
50 Operating Room 2,044,015 2,070,078 0.9874
51 Recovery Room 3,249,146 2,838,992 1.1445
52 Labor and Delivery Room 438,466 6,970,414 0.0629

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,716,581 13 Nursing Administration 1,241,083
02,03 Captial Related - Movable Equipment 1,853,572 14 Central Services and Supply 6,994,506
04 Employee Benefits 10,205,018 15 Pharmacy 9,011,644
05 Administrative and General 17,855,814 16 Medical Records and Medical Library 899,610
06 Maintenance and Repairs 5,460,580 17 Social Services 314,332
07 Operation of Plant 0 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 2,002,134 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 1,415,214 20,21,22,23 Education Programs 844,723
Total General Service Cost Centers 61,814,811

County Profile for Franklin - 2023