County Profile for Franklin - 2012



County Controls Information

Cost Report Counts Population
Total Hospital Count 2 Total Population on July 31, 2012 0
Total Cost Reports Filed in 2012 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 2 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 42,023,816 Total Charges 312,010,951
Fixed Assets 56,148,487 Contract Allowance 163,573,573
Other Assets 21,275,479 Operating Revenue 148,437,378
Total Assets 119,447,782 Operating Expenses 158,859,874
Current Liabilities 26,332,608 Operating Margin -10,422,496
Long Term Liabilities 20,710,235 Other Income 9,838,261
Total Equity 72,404,939 Other Expense 1,544,150
Total Liabilities and Equity 119,447,782 Net Profit or Loss -2,128,385

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $28,784 Revenue per Bed $1,016,694 Revenue per Person $148,437,378
Net Margin per Discharge ($2,021) Net Margin per Bed ($71,387) Net Margin per Person ($10,422,496)
Net Profit per Discharge ($413) Net Profit per Bed ($14,578) Net Profit per Person ($2,128,385)
Net Fixed Assets per Discharge $10,888 Net Fixed Assets per Bed $384,579 Net Fixed Assets per Bed $56,148,487
Long Term Debt per Discharge $4,016 Long Term Debt per Bed $141,851 Long Term Debt per Person $20,710,235
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 37.0 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 808 Net Fixed Assets 838 Population Estimate 1,151
Total Revenue 705 Long Term Liabilities 985 Total Patient Discharges 838
Net Margin 3,025 Total Patient Beds 742
Net Profit or Loss 3,031

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 18,003,495 18,413,481 0.9777
31 Intensive Care Unit 4,324,446 4,190,917 1.0319
32 Coronary Care Unit 0 0
43 Nursery 549,736 390,987 1.4060
44 Skilled Nursing Care 12,826,713 15,044,749 0.8526
50 Operating Room 11,676,695 23,773,638 0.4912
51 Recovery Room 980,535 2,188,518 0.4480
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,129,738 13 Nursing Administration 0
02,03 Captial Related - Movable Equipment 3,484,654 14 Central Services and Supply 0
04 Employee Benefits 18,877,028 15 Pharmacy 0
05 Administrative and General 7,109,179 16 Medical Records and Medical Library 2,457,860
06 Maintenance and Repairs 2,508,154 17 Social Services 0
07 Operation of Plant 2,706,534 18 Other General Service Expense 4,660,988
08,09 Laundry, Linen and Housekeeping 2,875,921 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 2,508,473 20,21,22,23 Education Programs 10,188,675
Total General Service Cost Centers 61,507,204

County Profile for Franklin - 2012