Cost Analysis
mbibey
cotemplate.xlsxSheet1
| SAMPLE HOSPITAL INC. | ||||||
| Activity Cost | $ 400,000 | $ 3,450,000 | $ 5,000,000 | |||
| Activity Base | 6,000 | patients | 23,000 | days | 200,000 | hours |
| Activity rate | per patient | per day | per hour | |||
| Procedure A | Usage | Rate | Total | |||
| Scheduling and Admitting | 300 | patient | ||||
| Housekeeping | 1,175 | days | ||||
| Nursing | 17,500 | hours | ||||
| Total | ||||||
| Procedure B | ||||||
| Scheduling and Admitting | 600 | patient | ||||
| Housekeeping | 2,300 | days | ||||
| Nursing | 7,000 | hours | ||||
| Total | ||||||
| Procedure C | ||||||
| Scheduling and Admitting | 1,050 | patient | ||||
| Housekeeping | 1,800 | days | ||||
| Nursing | 23,000 | hours | ||||
| Total | ||||||
| Procedure A | Procedure B | Procedure C | ||||
| Reimbursement ($1,000 per patient) | ||||||
| Cost per procedure | ||||||
| Excess (deficiency) | ||||||
| Analysis: | ||||||
