County Profile for Columbia - 2017



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2017 0
Total Cost Reports Filed in 2017 1 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 1 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 35,116,374 Total Charges 472,788,791
Fixed Assets 48,181,775 Contract Allowance 328,844,390
Other Assets 10,824,238 Operating Revenue 143,944,401
Total Assets 94,122,387 Operating Expenses 158,825,471
Current Liabilities 27,168,804 Operating Margin -14,881,070
Long Term Liabilities 32,289,247 Other Income 14,264,003
Total Equity 34,664,336 Other Expense -2,055,767
Total Liabilities and Equity 94,122,387 Net Profit or Loss 1,438,700

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $32,059 Revenue per Bed $1,673,772 Revenue per Person $143,944,401
Net Margin per Discharge ($3,314) Net Margin per Bed ($173,036) Net Margin per Person ($14,881,070)
Net Profit per Discharge $320 Net Profit per Bed $16,729 Net Profit per Person $1,438,700
Net Fixed Assets per Discharge $10,731 Net Fixed Assets per Bed $560,253 Net Fixed Assets per Bed $48,181,775
Long Term Debt per Discharge $7,191 Long Term Debt per Bed $375,456 Long Term Debt per Person $32,289,247
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 70.3 %
Length of Stay 5 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 768 Net Fixed Assets 948 Population Estimate 1,151
Total Revenue 786 Long Term Liabilities 809 Total Patient Discharges 844
Net Margin 2,956 Total Patient Beds 977
Net Profit or Loss 1,198

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 18,514,296 26,907,258 0.6881
31 Intensive Care Unit 2,815,213 3,254,208 0.8651
32 Coronary Care Unit 0 0
43 Nursery 694,183 1,363,202 0.5092
44 Skilled Nursing Care 0 0
50 Operating Room 8,569,457 32,114,348 0.2668
51 Recovery Room 0 0
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,635,659 13 Nursing Administration 0
02,03 Captial Related - Movable Equipment 3,048,876 14 Central Services and Supply 0
04 Employee Benefits 17,062,160 15 Pharmacy 0
05 Administrative and General 14,081,520 16 Medical Records and Medical Library 2,335,593
06 Maintenance and Repairs 0 17 Social Services 1,104,576
07 Operation of Plant 1,373,565 18 Other General Service Expense -1,511,644
08,09 Laundry, Linen and Housekeeping 1,938,847 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 2,037,671 20,21,22,23 Education Programs 0
Total General Service Cost Centers 46,106,823

County Profile for Columbia - 2017