County Profile for Franklin - 2023



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2023 30,828
Total Cost Reports Filed in 2023 1 Total Births 226
Total Cost Reports Submitted 1 Total Deaths 411
Total Cost Reports Settled 0 Net Population Natural Change -185
Total Cost Reports Reopened 0 Total International Migration 16
Total Cost Reports Ammended 0 Total Domestic Migration 403
Total Cost Reports Audited 0 Total Residual -1
Net Population Change 233

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 31,836,418 Total Charges 288,689,167
Fixed Assets 26,729,435 Contract Allowance 172,919,858
Other Assets 4,240,313 Operating Revenue 115,769,309
Total Assets 62,806,166 Operating Expenses 129,147,007
Current Liabilities 14,844,907 Operating Margin -13,377,698
Long Term Liabilities 7,484,149 Other Income 16,354,178
Total Equity 40,477,110 Other Expense 0
Total Liabilities and Equity 62,806,166 Net Profit or Loss 2,976,480

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $65,333 Revenue per Bed $3,046,561 Revenue per Person $3,755
Net Margin per Discharge ($7,549) Net Margin per Bed ($352,045) Net Margin per Person ($434)
Net Profit per Discharge $1,680 Net Profit per Bed $78,328 Net Profit per Person $97
Net Fixed Assets per Discharge $15,084 Net Fixed Assets per Bed $703,406 Net Fixed Assets per Bed $867
Long Term Debt per Discharge $4,224 Long Term Debt per Bed $196,951 Long Term Debt per Person $243
Persons per Discharge 0 Persons per Bed 811
Occupancy Rate 52.8 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,098 Net Fixed Assets 1,331 Population Estimate 1,415
Total Revenue 1,002 Long Term Liabilities 1,347 Total Patient Discharges 1,148
Net Margin 2,716 Total Patient Beds 1,389
Net Profit or Loss 1,086

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 12,545,638 20,134,280 0.6231
31 Intensive Care Unit 1,891,773 2,246,840 0.8420
32 Coronary Care Unit 0 0
43 Nursery 1,376,568 1,291,450 1.0659
44 Skilled Nursing Care 0 0
50 Operating Room 9,328,001 30,715,421 0.3037
51 Recovery Room 0 0
52 Labor and Delivery Room 232,762 457,239 0.5091

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 2,299,002 13 Nursing Administration 1,291,735
02,03 Captial Related - Movable Equipment 3,163,200 14 Central Services and Supply 458,487
04 Employee Benefits 12,298,871 15 Pharmacy 3,544,795
05 Administrative and General 23,545,058 16 Medical Records and Medical Library 130,316
06 Maintenance and Repairs 1,705,859 17 Social Services 349,491
07 Operation of Plant 1,327,845 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 1,505,681 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 1,076,137 20,21,22,23 Education Programs 0
Total General Service Cost Centers 52,696,477

County Profile for Franklin - 2023