County Profile for Franklin - 2013



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2013 0
Total Cost Reports Filed in 2013 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 29,029,600 Total Charges 166,833,735
Fixed Assets 35,249,395 Contract Allowance 92,683,380
Other Assets 4,298,145 Operating Revenue 74,150,355
Total Assets 68,577,140 Operating Expenses 84,151,660
Current Liabilities 9,174,191 Operating Margin -10,001,305
Long Term Liabilities 24,003,228 Other Income 3,840,230
Total Equity 35,399,721 Other Expense 0
Total Liabilities and Equity 68,577,140 Net Profit or Loss -6,161,075

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $31,353 Revenue per Bed $1,685,235 Revenue per Person $74,150,355
Net Margin per Discharge ($4,229) Net Margin per Bed ($227,302) Net Margin per Person ($10,001,305)
Net Profit per Discharge ($2,605) Net Profit per Bed ($140,024) Net Profit per Person ($6,161,075)
Net Fixed Assets per Discharge $14,905 Net Fixed Assets per Bed $801,123 Net Fixed Assets per Bed $35,249,395
Long Term Debt per Discharge $10,149 Long Term Debt per Bed $545,528 Long Term Debt per Person $24,003,228
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 51.5 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,107 Net Fixed Assets 1,067 Population Estimate 1,151
Total Revenue 1,038 Long Term Liabilities 925 Total Patient Discharges 1,151
Net Margin 2,913 Total Patient Beds 1,434
Net Profit or Loss 3,149

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 8,760,030 15,687,138 0.5584
31 Intensive Care Unit 1,463,655 1,835,035 0.7976
32 Coronary Care Unit 0 0
43 Nursery 759,135 1,040,485 0.7296
44 Skilled Nursing Care 0 0
50 Operating Room 6,681,625 18,564,128 0.3599
51 Recovery Room 0 0
52 Labor and Delivery Room 179,390 189,637 0.9460

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,521,862 13 Nursing Administration 679,473
02,03 Captial Related - Movable Equipment 1,964,713 14 Central Services and Supply 556,880
04 Employee Benefits 9,100,255 15 Pharmacy 1,416,915
05 Administrative and General 11,704,239 16 Medical Records and Medical Library 954,507
06 Maintenance and Repairs 809,575 17 Social Services 434,223
07 Operation of Plant 1,905,643 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 930,130 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 729,079 20,21,22,23 Education Programs 0
Total General Service Cost Centers 34,707,494

County Profile for Franklin - 2013