DBC, TDABC, and ABC The Bienestar Cardiology Clinic has two major activities: diagnostic and treatment. The two activities use four resources: nursing, medical technicians, cardiologists, and equipment. Detale matrix shown below. Resources Total Activity Time Activity Nursing Technicians Cardiologists Equipment Diagnosing patients 0.70 0.80 0.40 0.60 12,000 hes Treating patients 0.30 0.20 0.60 0.40 8,000 hrs. Total time Chr 4.000 4,000 6.000 6.000 20,000 Cost $80.000 $80,000 $320,000 $320.000 The total time estimated corresponds to practical capacity (interviewers adjusted the total time to about 80 percent of the available time). The equipment time is measured in machine hour system is 20,000 hours. In considering the implementation of TDABC model, the following unit times and transaction information are also provided: Expected Activity Unit Time Driver Driver Quantity Diagnosing patients 3 hrs No. of patients 4,000 Treating patients 08h No of treatments 10,000 The dinic has identified three types of patients those with no heart disease, those with mild heart disease, and those with severe heart disease. The following additional data are provided Average Time Spent Servicing Patient Type Diagnosing Patients Treating Patients Each Patient Type (Cycle Time) No disease 2.000 0 3 hrs Mild disease 1,500 5.000 5.6 hrs. Severe disease 500 5.000 11.0 Required: 1. Calculate the activity costs for diagnosing and treating patients. Using the activity costs calculated, calculate the unit cost of servicing each type of patient using traditional Auc. Activity rates Diagnosing 56,000 Treating 24,000 Calculate the unit cost of servicing each type of patient using traditional ABC Unit Cost No Disease Mild Severe 2. Using TDABC-derived activity rates, calculate the unit cost of servicing each type of patient. If required round your answer to two decimal places. Activity rates Diagnosing 480,000 Treating 320,000 Unit Cost No Disease Mild Severe 3. Using DBC, calculate the unit cost of servicing each type of patient. If required round your answer to two decimal places. Unit Cost No Disease per patient Decal theoretired orwertowe decimale Le cost per un severe Piedical constrated city , to 10.00 hecho to the other 22 thout who we decimal 4 hours Freddy were st Ne Sew Shout the income Declaration that Heren Roth Then The White the 3. Using DBC, calculate the unit cost of servicing each type of patient. If required round your answer to two decimal places. Unit Cost No Disease per patient Mild per patient Severe per patient 4. Suppose that a medical consultant proposes a new patient-processing system that will shorten diagnostic and treatment times but would require more skilled nurses and technicians as well as an equipment upgrade. However, the total practical capacity would remain the same, at 20,000 hours. Total resource costs are predicted to increase by $100,000. The consultant estimates that the cycle times for each patient type would be reduced from 3 to 2 hours, 5.6 to 4.5 hours, and 11 to 9 hours. The physicians that own the clinic have expressed a willingness to implement the changes, provided that the unit cost of servicing each patient type decreases. Use DBC to estimate the new unit costs. If required round your answer to two decimal places. Unit Cost No Disease per patient Mild per patient Severe per patient Should the clinic implement the new system? Discuss the advantages of DBC for this analysis over ABC and TDABC. Finally, identify the data analytic types (descriptive, diagnostic, predictive, or prescriptive) that apply for this analysis (see Exhibits 2.5 and Exhibits 2.6, for a review of data analytic types). Note: More than one analytic type might apply. . The data analytic types are estimates. The patients suggest that the clinic The unit costs are what are likely to happen given the in unit costs and the in ability to process more adopt the new system. DBC, TDABC, and ABC The Bienestar Cardiology Clinic has two major activities: diagnostic and treatment. The two activities use four resources: nursing, medical technicians, cardiologists, and equipment. Detale matrix shown below. Resources Total Activity Time Activity Nursing Technicians Cardiologists Equipment Diagnosing patients 0.70 0.80 0.40 0.60 12,000 hes Treating patients 0.30 0.20 0.60 0.40 8,000 hrs. Total time Chr 4.000 4,000 6.000 6.000 20,000 Cost $80.000 $80,000 $320,000 $320.000 The total time estimated corresponds to practical capacity (interviewers adjusted the total time to about 80 percent of the available time). The equipment time is measured in machine hour system is 20,000 hours. In considering the implementation of TDABC model, the following unit times and transaction information are also provided: Expected Activity Unit Time Driver Driver Quantity Diagnosing patients 3 hrs No. of patients 4,000 Treating patients 08h No of treatments 10,000 The dinic has identified three types of patients those with no heart disease, those with mild heart disease, and those with severe heart disease. The following additional data are provided Average Time Spent Servicing Patient Type Diagnosing Patients Treating Patients Each Patient Type (Cycle Time) No disease 2.000 0 3 hrs Mild disease 1,500 5.000 5.6 hrs. Severe disease 500 5.000 11.0 Required: 1. Calculate the activity costs for diagnosing and treating patients. Using the activity costs calculated, calculate the unit cost of servicing each type of patient using traditional Auc. Activity rates Diagnosing 56,000 Treating 24,000 Calculate the unit cost of servicing each type of patient using traditional ABC Unit Cost No Disease Mild Severe 2. Using TDABC-derived activity rates, calculate the unit cost of servicing each type of patient. If required round your answer to two decimal places. Activity rates Diagnosing 480,000 Treating 320,000 Unit Cost No Disease Mild Severe 3. Using DBC, calculate the unit cost of servicing each type of patient. If required round your answer to two decimal places. Unit Cost No Disease per patient Decal theoretired orwertowe decimale Le cost per un severe Piedical constrated city , to 10.00 hecho to the other 22 thout who we decimal 4 hours Freddy were st Ne Sew Shout the income Declaration that Heren Roth Then The White the 3. Using DBC, calculate the unit cost of servicing each type of patient. If required round your answer to two decimal places. Unit Cost No Disease per patient Mild per patient Severe per patient 4. Suppose that a medical consultant proposes a new patient-processing system that will shorten diagnostic and treatment times but would require more skilled nurses and technicians as well as an equipment upgrade. However, the total practical capacity would remain the same, at 20,000 hours. Total resource costs are predicted to increase by $100,000. The consultant estimates that the cycle times for each patient type would be reduced from 3 to 2 hours, 5.6 to 4.5 hours, and 11 to 9 hours. The physicians that own the clinic have expressed a willingness to implement the changes, provided that the unit cost of servicing each patient type decreases. Use DBC to estimate the new unit costs. If required round your answer to two decimal places. Unit Cost No Disease per patient Mild per patient Severe per patient Should the clinic implement the new system? Discuss the advantages of DBC for this analysis over ABC and TDABC. Finally, identify the data analytic types (descriptive, diagnostic, predictive, or prescriptive) that apply for this analysis (see Exhibits 2.5 and Exhibits 2.6, for a review of data analytic types). Note: More than one analytic type might apply. . The data analytic types are estimates. The patients suggest that the clinic The unit costs are what are likely to happen given the in unit costs and the in ability to process more adopt the new system