County Profile for Franklin - 2012



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2012 0
Total Cost Reports Filed in 2012 1 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 0 Net Population Natural Change 0
Total Cost Reports Reopened 1 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 20,934,301 Total Charges 206,963,901
Fixed Assets 32,857,154 Contract Allowance 129,379,865
Other Assets 942,043 Operating Revenue 77,584,036
Total Assets 54,733,498 Operating Expenses 80,934,104
Current Liabilities 12,450,039 Operating Margin -3,350,068
Long Term Liabilities 20,627,260 Other Income 4,106,435
Total Equity 21,656,199 Other Expense 0
Total Liabilities and Equity 54,733,498 Net Profit or Loss 756,367

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $19,980 Revenue per Bed $912,753 Revenue per Person $77,584,036
Net Margin per Discharge ($863) Net Margin per Bed ($39,413) Net Margin per Person ($3,350,068)
Net Profit per Discharge $195 Net Profit per Bed $8,898 Net Profit per Person $756,367
Net Fixed Assets per Discharge $8,462 Net Fixed Assets per Bed $386,555 Net Fixed Assets per Bed $32,857,154
Long Term Debt per Discharge $5,312 Long Term Debt per Bed $242,674 Long Term Debt per Person $20,627,260
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 59.1 %
Length of Stay 5 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 989 Net Fixed Assets 1,087 Population Estimate 1,151
Total Revenue 1,018 Long Term Liabilities 986 Total Patient Discharges 957
Net Margin 2,634 Total Patient Beds 1,035
Net Profit or Loss 1,455

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 19,631,748 21,824,234 0.8995
31 Intensive Care Unit 2,453,079 2,794,790 0.8777
32 Coronary Care Unit 0 0
43 Nursery 723,913 1,410,118 0.5134
44 Skilled Nursing Care 0 0
50 Operating Room 2,154,760 4,304,285 0.5006
51 Recovery Room 1,947,925 4,421,552 0.4406
52 Labor and Delivery Room 428,058 4,604,751 0.0930

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,053,336 13 Nursing Administration 865,852
02,03 Captial Related - Movable Equipment 1,712,086 14 Central Services and Supply 5,376,663
04 Employee Benefits 8,483,294 15 Pharmacy 5,409,412
05 Administrative and General 14,564,113 16 Medical Records and Medical Library 467,093
06 Maintenance and Repairs 4,108,094 17 Social Services 204,104
07 Operation of Plant 0 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 1,089,707 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 1,160,874 20,21,22,23 Education Programs 0
Total General Service Cost Centers 46,494,628

County Profile for Franklin - 2012