County Profile for Honolulu - 2012



County Controls Information

Cost Report Counts Population
Total Hospital Count 13 Total Population on July 31, 2012 0
Total Cost Reports Filed in 2012 13 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 7 Net Population Natural Change 0
Total Cost Reports Reopened 2 Total International Migration 0
Total Cost Reports Ammended 3 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 1,064,216,794 Total Charges 4,436,203,667
Fixed Assets 587,519,984 Contract Allowance 2,612,590,010
Other Assets 199,034,667 Operating Revenue 1,823,613,657
Total Assets 1,850,771,445 Operating Expenses 2,145,948,364
Current Liabilities 287,420,607 Operating Margin -322,334,707
Long Term Liabilities 651,394,510 Other Income 136,765,040
Total Equity 911,956,328 Other Expense 23,081,169
Total Liabilities and Equity 1,850,771,445 Net Profit or Loss -208,650,836

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $22,856 Revenue per Bed $1,158,586 Revenue per Person $1,823,613,657
Net Margin per Discharge ($4,040) Net Margin per Bed ($204,787) Net Margin per Person ($322,334,707)
Net Profit per Discharge ($2,615) Net Profit per Bed ($132,561) Net Profit per Person ($208,650,836)
Net Fixed Assets per Discharge $7,364 Net Fixed Assets per Bed $373,266 Net Fixed Assets per Bed $587,519,984
Long Term Debt per Discharge $8,164 Long Term Debt per Bed $413,847 Long Term Debt per Person $651,394,510
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 74.1 %
Length of Stay 6 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 130 Net Fixed Assets 149 Population Estimate 1,151
Total Revenue 98 Long Term Liabilities 105 Total Patient Discharges 96
Net Margin 3,291 Total Patient Beds 91
Net Profit or Loss 3,302

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 458,446,836 691,496,091 0.6630
31 Intensive Care Unit 112,213,619 227,386,484 0.4935
32 Coronary Care Unit 3,884,948 8,818,216 0.4406
43 Nursery 18,248,744 21,459,649 0.8504
44 Skilled Nursing Care 39,538,603 40,917,057 0.9663
50 Operating Room 107,599,940 288,419,849 0.3731
51 Recovery Room 40,498,630 68,195,841 0.5939
52 Labor and Delivery Room 24,051,628 23,279,216 1.0332

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 52,343,034 13 Nursing Administration 24,339,176
02,03 Captial Related - Movable Equipment 40,004,337 14 Central Services and Supply 10,108,374
04 Employee Benefits 190,834,490 15 Pharmacy 42,755,827
05 Administrative and General 249,378,189 16 Medical Records and Medical Library 17,343,757
06 Maintenance and Repairs 36,465,119 17 Social Services 17,433,751
07 Operation of Plant 39,640,772 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 24,066,229 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 24,610,973 20,21,22,23 Education Programs 28,732,356
Total General Service Cost Centers 798,056,384

County Profile for Honolulu - 2012