Boston Children's Hospital Excel Sheet.xlsx - Department of...

This preview shows page 1 - 3 out of 3 pages.

Department of Plastic and Oral Surgery: Input data (Exh 9) Surgeon Compensation: Salary, fringes, bonus 5,500,000 390,000 1,098,500 235,300 Malpractice insurance 220,000 - - - Billing services 760,000 - - - Office expenses: Rent, utilities, insurance, supplies 400,000 148,200 247,000 123,500 Total 6,880,000 538,200 1,345,500 358,800 Research and teaching time (surgeons) 25% Clinical time (surgeons) 75% Surgeons' clinical expenses 5,160,000 Medical supplies 67,200 Total Clinical Costs $5,227,200 $538,200 $1,345,500 $358,800 Number of employees 10 6 10 5 Clinical Cost per Employee $522,720 $89,700 $134,550 $71,760 Ambulatory service rep (ASR) Registered nurse (RN) Clinical assistant (CA)
TOTAL 7,223,800 220,000 760,000 918,700 9,122,500 $7,469,700 31
Department of Plastic and Oral Surgery: Cost Worksheet NOTE: Green=you fill in; Yellow=you calcula RESOURCE Surgeon ASR RN CA Weeks per year 52 52 52 52 Less: Vacation & Holidays 6 4 4 4 (from case, pp. 7-8) Less: Training and Leave 2 2 2 2 Available weeks per year 44 46 46 46 Hours per day 10 8 8 8 Less: Breaks, training, meetings 1.2 1.5 1.5 1.5 Available hours 8.8 6.5 6.5 6.5 Less: Estimate of Research and Education time (%) 25 0 0 0 Clinical hours per day 6.6 6.5 6.5 6.5 Clinical minutes available per day

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture