In: Finance
Based on the table below calculate the cost for patient X using the ratio of cost to charge method
Billed | Calculated | |||||
Department | Charges | Cost | RCC | Charges | Cost | |
Med/Surg | $42,000,000 | $14,000,000 | ________ | $14,000 | ________ | |
ICU | $10,000,000 | $4,000,000 | ________ | 0 | ________ | |
OR | $15,000,000 | $6,000,000 | ________ | $5,000 | ________ | |
Respiratory therapy | $2,000,000 | $1,000,000 | ________ | $500 | ________ | |
Rehab therapy | $5,000,000 | $2,000,000 | ________ | $2,000 | ________ | |
Clinical Lab | $7,000,000 | $2,000,000 | ________ | $2,000 | ________ | |
Radiology | $8,000,000 | $3,000,000 | ________ | $1,000 | ________ | |
Pharmacy | $9,000,000 | $3,000,000 | ________ | $1,500 | ________ | |
Cardiology | $3,000,000 | $2,000,000 | ________ | $1,000 | ________ | |
Total Direct Cost | $101,000,000 | $37,000,000 | $27,000 | ________ | ||
Indirect cost (66.7% of direct cost, i.e., 40% of total cost) | ________ | |||||
Total cost patient X | ________ |
Particulars | Cost | Charge | Cost to Charge Ratio | Bill Charged | Cost of Patient X |
Med/Surg | $ 14,00,000.00 | $ 42,00,000.00 | 0.33 | $ 14,000.00 | $ 4,666.67 |
ICU | $ 4,00,000.00 | $ 10,00,000.00 | 0.40 | $ - | $ - |
OR | $ 6,00,000.00 | $ 15,00,000.00 | 0.40 | $ 5,000.00 | $ 2,000.00 |
Respiratory therapy | $ 1,00,000.00 | $ 2,00,000.00 | 0.50 | $ 500.00 | $ 250.00 |
Rehab therapy | $ 2,00,000.00 | $ 5,00,000.00 | 0.40 | $ 2,000.00 | $ 800.00 |
Clinical Lab | $ 2,00,000.00 | $ 7,00,000.00 | 0.29 | $ 2,000.00 | $ 571.43 |
Radiology | $ 3,00,000.00 | $ 8,00,000.00 | 0.38 | $ 1,000.00 | $ 375.00 |
Pharmacy | $ 3,00,000.00 | $ 9,00,000.00 | 0.33 | $ 1,500.00 | $ 500.00 |
Cardiology | $ 2,00,000.00 | $ 3,00,000.00 | 0.67 | $ 1,000.00 | $ 666.67 |
Total Direct Cost | $ 37,00,000.00 | $ 1,01,00,000.00 | $ 27,000.00 | $ 9,829.76 | |
Total Indirect Cost @ 66.7% of Direct Cost | $ 6,556.45 | ||||
Total Cost of Patient X | $ 16,386.21 |