County Profile for Franklin - 2017



County Controls Information

Cost Report Counts Population
Total Hospital Count 2 Total Population on July 31, 2017 0
Total Cost Reports Filed in 2017 2 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 2 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 61,701,520 Total Charges 444,754,933
Fixed Assets 86,143,310 Contract Allowance 267,628,281
Other Assets 41,573,052 Operating Revenue 177,126,652
Total Assets 189,417,882 Operating Expenses 194,333,095
Current Liabilities 35,851,496 Operating Margin -17,206,443
Long Term Liabilities 66,011,988 Other Income 13,003,181
Total Equity 87,554,398 Other Expense -1,483,344
Total Liabilities and Equity 189,417,882 Net Profit or Loss -2,719,918

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $47,436 Revenue per Bed $1,213,196 Revenue per Person $177,126,652
Net Margin per Discharge ($4,608) Net Margin per Bed ($117,852) Net Margin per Person ($17,206,443)
Net Profit per Discharge ($728) Net Profit per Bed ($18,630) Net Profit per Person ($2,719,918)
Net Fixed Assets per Discharge $23,070 Net Fixed Assets per Bed $590,023 Net Fixed Assets per Bed $86,143,310
Long Term Debt per Discharge $17,679 Long Term Debt per Bed $452,137 Long Term Debt per Person $66,011,988
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 23.3 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 800 Net Fixed Assets 699 Population Estimate 1,151
Total Revenue 700 Long Term Liabilities 553 Total Patient Discharges 920
Net Margin 2,982 Total Patient Beds 725
Net Profit or Loss 2,955

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 19,292,498 14,012,044 1.3769
31 Intensive Care Unit 3,907,904 3,008,599 1.2989
32 Coronary Care Unit 0 0
43 Nursery 678,540 299,245 2.2675
44 Skilled Nursing Care 28,837,167 24,789,745 1.1633
50 Operating Room 11,204,275 40,935,458 0.2737
51 Recovery Room 1,007,540 3,002,432 0.3356
52 Labor and Delivery Room 0 0

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,444,929 13 Nursing Administration 0
02,03 Captial Related - Movable Equipment 2,669,170 14 Central Services and Supply 0
04 Employee Benefits 21,616,229 15 Pharmacy 0
05 Administrative and General 0 16 Medical Records and Medical Library 2,558,646
06 Maintenance and Repairs 1,981,875 17 Social Services 0
07 Operation of Plant 2,528,187 18 Other General Service Expense 5,627,066
08,09 Laundry, Linen and Housekeeping 2,896,178 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 1,868,177 20,21,22,23 Education Programs 23,643,419
Total General Service Cost Centers 68,833,876

County Profile for Franklin - 2017