F29 SAMPLE HOSPITAL INC. 4 5 Activity Cost 6 Activity Base 7Activity rate $400,000 $ 3450,000 5,000,000 6,000 patients 23,000 days 200,000 hours per patient per day per hour Usage Rate Total 10 Procedure A Scheduling and 11 Admitting 12 Housekeeping 13 Nursing 14 Total 15 16 Procedure B 300 patient 1,175 days 17,500 hours Scheduling and 600 patient 2,300 days 7,000 hours 17 Admitting 18 Housekeeping 19 Nursing 20 Total 21 22 Procedure C Scheduling and 1,050 patient 1,800 days 23,000 hours 23 Admitting 24 Housekeeping 25 Nursing 26 Total 27 28 Procedure A Procedure B Procedure C Reimbursement ($1,000 per patient) Sheet1Sheet2 Sheet3 Start 17,500 hours 13 Nursing 14 Total 15 16 Procedure B Scheduling and 17 Admitting 18 Housekeeping 19 Nursing 20 Total 21 22 Procedure C 600 patient 2,300 days 7,000 hours Scheduling and 23 Admitting 24 Housekeeping 25 Nursing 26 Total 27 28 1,050 patient 1,800 days 23,000 hours Procedure A Procedure B Procedure C Reimbursement 29 ($1,000 per patient) 30 Cost per procedure 31 Excess (deficiency) 32 33 Analysis: 34 25 Sheet Sheet2 Sheets Start