County Profile for Franklin - 2013



County Controls Information

Cost Report Counts Population
Total Hospital Count 2 Total Population on July 31, 2013 0
Total Cost Reports Filed in 2013 2 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 1 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 53,642,918 Total Charges 311,628,322
Fixed Assets 62,207,916 Contract Allowance 163,964,048
Other Assets 44,999,319 Operating Revenue 147,664,274
Total Assets 160,850,153 Operating Expenses 155,046,106
Current Liabilities 36,337,567 Operating Margin -7,381,832
Long Term Liabilities 42,162,231 Other Income 10,247,710
Total Equity 82,350,355 Other Expense 1,205,042
Total Liabilities and Equity 160,850,153 Net Profit or Loss 1,660,836

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $32,836 Revenue per Bed $1,011,399 Revenue per Person $147,664,274
Net Margin per Discharge ($1,642) Net Margin per Bed ($50,560) Net Margin per Person ($7,381,832)
Net Profit per Discharge $369 Net Profit per Bed $11,376 Net Profit per Person $1,660,836
Net Fixed Assets per Discharge $13,833 Net Fixed Assets per Bed $426,082 Net Fixed Assets per Bed $62,207,916
Long Term Debt per Discharge $9,376 Long Term Debt per Bed $288,782 Long Term Debt per Person $42,162,231
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 36.0 %
Length of Stay 5 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 831 Net Fixed Assets 798 Population Estimate 1,151
Total Revenue 712 Long Term Liabilities 699 Total Patient Discharges 885
Net Margin 2,809 Total Patient Beds 741
Net Profit or Loss 1,174

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 15,408,620 19,006,021 0.8107
31 Intensive Care Unit 4,129,798 3,362,646 1.2281
32 Coronary Care Unit 0 0
43 Nursery 688,131 353,091 1.9489
44 Skilled Nursing Care 13,997,325 14,788,788 0.9465
50 Operating Room 11,439,322 23,547,436 0.4858
51 Recovery Room 896,808 2,098,057 0.4274
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 4,105,341 13 Nursing Administration 0
02,03 Captial Related - Movable Equipment 3,371,538 14 Central Services and Supply 0
04 Employee Benefits 16,547,848 15 Pharmacy 0
05 Administrative and General 0 16 Medical Records and Medical Library 2,171,028
06 Maintenance and Repairs 2,222,203 17 Social Services 0
07 Operation of Plant 2,511,310 18 Other General Service Expense 4,133,584
08,09 Laundry, Linen and Housekeeping 2,750,128 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 2,419,362 20,21,22,23 Education Programs 18,376,940
Total General Service Cost Centers 58,609,282

County Profile for Franklin - 2013