The numbers in this spreedsheet have been disguised and/or based on national numbers and are not representative of actual operations of Boston Children's Hospital CA Surgeon 52 Resource Weeks per year Less: Vacation & Holidays Less: Training and Leave Available weeks per year Ano 3 ASR 52 4 2 48 RN 52 4 2 48 52 4 2 48 10 1.2 8.8 25% 8.6 8 1.5 8.5 0% 6.5 8 1.5 8.5 096 8 1.5 8.5 0% 8.5 Hours per day 4 Less: Breaks, training, meetings Available hours Less: Estimate of Research & Education time (%) Clinical Hours per day Cilinical minutes available per day 9 Clinical minutes available per year 0 1 Annual Cost per person 2. Capacity cost rate (s per minute) 3 Personnel process times (minutes) 5 Plagiocephaly 3 Neoplasm skin excision 7 Craniosynostosis 8 S 522,720 S 89,700 S 134,550 $ 71,760 18 22 40 8 55.5 10.5 23 20 23 5 5 10 Total cost S S Average RCC Cost TDABC S 9 Medical diagnosis TDABC cost per patient visit Plagiocephaly 1 Neoplasm skin excision 2 Craniosynostosis 3 4 TDABC and RCC Comparison 5 8 7 8 9 0 Plastic Surgery Dept. 1 Charges 2 Costs 3 Reimbursement 4 RCC: Ratio of costs-to-charges 5 Average DPOS reimbursement rate S S S Charge 350 350 350 U ) RCC Profit S S S 12,449,500 7,469,700 7,967,680 64% Annual Volume 4,400 2,200 1,800 Surgeon RN CA 7 3 9 0 Plagiocephaly 1 Neoplasm skin excision 2 Craniosynostosis 3 -4 5 Number of full-time equivalent (FTE) worke 8 Minutes demanded per year based on total annual Minutes supplied per year (sum based on # of FTES) Unused capacity per year (in minutes) 9 Cost of unused capacity (dollars) per year Percent capacity utilization 1 Number of FTEs demanded based on annual volume 2 3 ASR 2 3 2 1 The numbers in this spreedsheet have been disguised and/or based on national numbers and are not representative of actual operations of Boston Children's Hospital CA Surgeon 52 Resource Weeks per year Less: Vacation & Holidays Less: Training and Leave Available weeks per year Ano 3 ASR 52 4 2 48 RN 52 4 2 48 52 4 2 48 10 1.2 8.8 25% 8.6 8 1.5 8.5 0% 6.5 8 1.5 8.5 096 8 1.5 8.5 0% 8.5 Hours per day 4 Less: Breaks, training, meetings Available hours Less: Estimate of Research & Education time (%) Clinical Hours per day Cilinical minutes available per day 9 Clinical minutes available per year 0 1 Annual Cost per person 2. Capacity cost rate (s per minute) 3 Personnel process times (minutes) 5 Plagiocephaly 3 Neoplasm skin excision 7 Craniosynostosis 8 S 522,720 S 89,700 S 134,550 $ 71,760 18 22 40 8 55.5 10.5 23 20 23 5 5 10 Total cost S S Average RCC Cost TDABC S 9 Medical diagnosis TDABC cost per patient visit Plagiocephaly 1 Neoplasm skin excision 2 Craniosynostosis 3 4 TDABC and RCC Comparison 5 8 7 8 9 0 Plastic Surgery Dept. 1 Charges 2 Costs 3 Reimbursement 4 RCC: Ratio of costs-to-charges 5 Average DPOS reimbursement rate S S S Charge 350 350 350 U ) RCC Profit S S S 12,449,500 7,469,700 7,967,680 64% Annual Volume 4,400 2,200 1,800 Surgeon RN CA 7 3 9 0 Plagiocephaly 1 Neoplasm skin excision 2 Craniosynostosis 3 -4 5 Number of full-time equivalent (FTE) worke 8 Minutes demanded per year based on total annual Minutes supplied per year (sum based on # of FTES) Unused capacity per year (in minutes) 9 Cost of unused capacity (dollars) per year Percent capacity utilization 1 Number of FTEs demanded based on annual volume 2 3 ASR 2 3 2 1
