BCHDPOSworksheet(Brock Toner, Charley Powell, Yuqi Bian, Ford Jolley, Qin Zhou).xlsx

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

DPOS Assignment WorksheetResource Surgeon Weeks per year52 Less: Vacation & Holidays6 Less: Training and Leave2 Available weeks per year44 Hours per day10 Less: Breaks, training, meetings1.2 Available hours8.8 Less: Estimate of Research & Education time (%)25%Clinical Hours per day6.6 Cllinical minutes available per day396 Clinical minutes available per year87,120 Annual Cost per person$ 522,720 Capacity cost rate ($ per minute)$ 6.00 Personnel process times (minutes) Plagiocephaly18 Neoplasm skin excision22 Craniosynostosis40 Medical Diagnosis Cost per patient visit Surgeon Plagiocephaly$ 108.00 Neoplasm skin excision132.00 Craniosynostosis240.00 Plastic Surgery Dept.Charges$ 12,449,500 Costs7,469,700 Reimbursement7,967,680 RCC: Ratio of costs-to-charges60%Average DPOS reimbursement rate64%
Capacity QuestionSurgeon Plagiocephaly18 Neoplasm skin excision22 Craniosynostosis40 Number of personnel2.5Minutes demanded199,600 Minutes supplied217,800 Unused capacity (minutes)18,200 Cost of unused capacity$ 109,200 Percent capacity utilization91.64%Note: The numbers in this spreedsheet have been disguised and/or based on national num
We have neither giBrock Toner, ChASRRNCADate Completed: N5252524 4 ###2 2 ###46 46 ###8881.5 1.5 ###6.5 6.5 ###0%0%0%6.5 6.5 ###390 390 390 89,700 89,700 89,700 $ 89,700 $ 134,550 $ 71,760 $ 1.00 $ 1.50 $ 0.80 823 5 55.520 5 10.523 10 ASRRNCATotal costCharge$ 8.00 $ 34.50 $ 4.00 $ 154.50 $ 350 224.00 55.50 30.00 4.00 $ 221.50 $ 350 224.00 10.50 34.50 8.00 $ 293.00 $ 350 224.00 Average reimbursement
ASRRNCAAnnual Quantity 8 23 5 4,400 56 20 5 2,200 11 23 10 1,800 221176,200 186,600 51,000 179,400 179,400 89,700 3,200 (7,200) 38,700 $ 3,200 $ (10,800) $ 30,960 98.22%104.01%56.86%mbers and are not representative of actual operations of Boston Children's Hospital
iven nor received any unauthorized assistance on this assignment.harley Powell, Yuqi Bian, Ford Jolley, Qin ZhouNovember 18, 2018TDABC ProfitRCC CostRCC Profit$ 69.50 210.00 $ 14.00 $ 2.50 210.00 $ 14.00 $ (69.00) 210.00 $ 14.00

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture