In: Accounting
show excel function please
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: | ||||||||||
???? |