2 Activity-based costing for a service companyCrosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs:ActivityActivity RateRoom and meals$177 per dayRadiology$250 per imagePharmacy$48 per physician orderChemistry lab$87 per testOperating room$860 per operating room hourThe activity usage information associated with the two patients is as follows:Abel PutinCheryl UmitNumber of days10 days.Number of images8 imagesNumber of physician orders7 ordersNumber of tests7 testsNumber of operating room hours7 hoursThis information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.XOpen spreadsheet4 days4 images5 orders.4 tests2.5 hoursa. Determine the activity cost associated with each patient.Abel Putin sCheryl Umit $b. Why is the total activity cost different for the two patients?apparently had a different condition that required more extensive treatment. Thus, the activity cost tois more than the activity cost of the other patient.

Under activity-based costing method, the cost is allocated to each activity based on its…

Activity-based costing for a service company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $177 per day Radiology $250 per image Pharmacy $48 per physician order Chemistry lab $87 per test Operating room $860 per operating room hour The activity usage information associated with the two patients is as follows: Cheryl Umit Abel Putin 4 days 10 days 4 images 8 images 5 orders 7 orders 4 tests 2.5 hours Number of days Number of images Number of physician orders Number of tests 7 tests Number of operating room hours 7 hours This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the activity cost associated with each patient. Abel Putin s Cheryl Umit s b. Why is the total activity cost different for the two patients? apparently had a different condition that required more extensive treatment. Thus, the activity cost to is more than the activity cost of the other patient.

Activity-based costing for a service company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $177 per day Radiology $250 per image Pharmacy $48 per physician order Chemistry lab $87 per test Operating room $860 per operating room hour The activity usage information associated with the two patients is as follows: Cheryl Umit Abel Putin 4 days 10 days 4 images 8 images 5 orders 7 orders 4 tests 2.5 hours Number of days Number of images Number of physician orders Number of tests 7 tests Number of operating room hours 7 hours This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the activity cost associated with each patient. Abel Putin s Cheryl Umit s b. Why is the total activity cost different for the two patients? apparently had a different condition that required more extensive treatment. Thus, the activity cost to is more than the activity cost of the other patient.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter4: Activity-based Costing

Section: Chapter Questions

Problem 20E: Activity-based costing for a service company Crosswinds Hospital plans to use activity-based costing...

See similar textbooks

Similar questions

Product costing and decision analysis for a service company Pleasant Stay Medical Inc. wishes to determine its product costs. Pleasant Stay offers a variety of medical procedures (operations) that are considered its products. The overhead has been separated into three major activities. The annual estimated activity costs and activity bases follow: Total patient days are determined by multiplying the number of patients by the average length of stay in the hospital. A weighted care unit (wcu) is a measure of nursing effort used to care for patients. There were 192,000 weighted care units estimated for the year. In addition, Pleasant Stay estimated 6,000 patients and 27,000 patient days for the year. (The average patient is expected to have a a little more than a four-day stay in the hospital.) During a portion of the year, Pleasant Stay collected patient information for three selected procedures, as follows: Private insurance reimburses the hospital for these activities at a fixed daily rate of 406 per patient day for all three procedures. Instructions Determine the activity rates. Determine the activity cost for each procedure. Determine the excess or deficiency of reimbursements to activity cost. Interpret your results.
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $176 per day Radiology $248 per image Pharmacy $38 per physician order Chemistry lab $96 per test Operating room $760 per operating room hour The activity usage information associated with the two patients is as follows: Abel Putin Cheryl Umit Number of days 5 days 11 days Number of images 4 images 5 images Number of physician orders 7 orders 9 orders Number of tests 2 tests 5 tests Number of operating room hours 3 hours 6.5 hours a. Determine the activity cost associated with each patient. Abel Putin $fill in the blank 1 Cheryl Umit $fill in the blank 2 b. Why is the total activity cost different for the two patients? apparently had a…
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $175 per day Radiology $247 per image Pharmacy $49 per physician order Chemistry lab $104 per test Operating room $720 per operating room hour The activity usage information associated with the two patients is as follows: Abel Putin Cheryl Umit Number of days 6 days 11 days Number of images 3 images 7 images Number of physician orders 5 orders 7 orders Number of tests 2 tests 5 tests Number of operating room hours 4 hours 7 hours a. Determine the activity cost associated with each patient. Abel Putin $fill in the blank 1 Cheryl Umit $fill in the blank 2
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate $274 per day $386 per image $61 per physician order $108 per test $940 per operating room hour The activity usage information associated with the two patients is as follows: Room and meals Radiology Pharmacy Chemistry lab Operating room Number of days Number of images Number of physician orders Number of tests Abel Putin LA Abel Putin atient. 3 days 5 images 7 orders Number of operating room hours a. Determine the activity cost associated with each patient. LA 2 tests Cheryl Umi 9 days 6 images 9 orders 4.5 hours 5 tests 6.5 hours Cheryl Umit p. Why is the total activity cost different for the two patients? apparently had a different condition that equired more extensive treatment. Thus, the activity…
Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $230 per day Radiology $185 per image Pharmacy $50 per physician order Chemistry lab $90 per test Operating room $1,030 per operating room hour The activity usage information associated with the two patients is as follows: Abel Putin Cheryl Umit Number of days 6 days 3 days Number of images 5 images 3 images Number of physician orders 7 orders 2 orders Number of tests 6 tests 2 tests Number of operating room hours 9 hours 5 hours This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Determine the activity cost associated with each patient.…
Zamboanga Hospital plans to use the activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: (Refer to image) Determine the activity cost associated with Patient 2. a. P1,388 b. P 908 c. P1,816 d. P4,555
ces Optimal Health is an outpatient surgical clinic. The clinic's three activities, their overhead cost, and their cost drivers follow. Activity Supplies Service General surgery Orthopedic surgery Patient services Building cost The two main surgical units and their actual activity usage follow. Actual Activity Usage Square Feet 750 Activity Budgeted Cost $ Supplies Patient services Building cost 2,700,000 30,000 368,000 Surgical Hours 2,800 12, 200 Supplies Patient services Building cost Activity Cost Driver Surgical hours (SH) Number of Orthopedic Surgery Supplies Patient services Building cost patients Square feet Patients 300 1. Compute activity rates using activity-based costing. Budgeted Cost 100 Required: 1. Compute activity rates using activity-based costing. 2. Allocate overhead cost to the general surgery and to the orthopedic surgery units. Compute overhead cost per patient for each surgery unit. 1,550 Budgeted Activity Usage 15,000 400 2,300 Budgeted Activity Usage 2.…
Optimal Health is an outpatient surgical clinic. The clinic's three activities, their overhead cost, and their cost drivers follow. Budgeted Activity Activity Supplies Patient services Activity Cost Driver Surgical hours (SH) Number of patients Square feet Building cost The two main surgical units and their actual activity usage follow. Actual Activity Usage Budgeted Cost $ 2,310,000 39,000 294,000 Service General surgery Orthopedic surgery Surgical Hours 2,600 8,400 Patients 300 200 Square Feet 720 1,380 Usage 11,000 500 2,100 Required: 1. Compute activity rates using activity-based costing. 2. Allocate overhead cost to the general surgery and to the orthopedic surgery units. Compute overhead cost per patient for each surgery unit.
Product Costing and Decision Analysis for a Service Company Pleasant Stay Medical Inc. wishes to determine its product costs. Pleasant Stay offers a variety of medical procedures (operations) that are considered its “products.” The overhead has been separated into three major activities. The annual estimated activity costs and activity bases follow: Activity Budgeted Activity Cost Activity Base Scheduling and admitting $432,000 Number of patients Housekeeping 4,212,000 Number of patient days Nursing 5,376,000 Weighted care unit Total costs $10,020,000 Total “patient days” are determined by multiplying the number of patients by the average length of stay in the hospital. A weighted care unit (wcu) is a measure of nursing effort used to care for patients. There were 192,000 weighted care units estimated for the year. In addition, Pleasant Stay estimated 6,000 patients and 27,000 patient days for the year. (The…
Pareto chart and cost of quality report for a service company The administrator of Liberty Hospital has been asked to perform an activity analysis of the emergency room (ER). The ER activities include cost of quality and other patient care activities. The lab tests and transportation are hospital services external to the ER for determining external failure costs. The result of the activity analysis is summarized as follows: Activities Activity Cost Patient registration $ 6,500 Verifying patient information 9,700 Assigning patients 13,000 Searching/waiting for doctor 9,200 Doctor exam 4,900 Waiting for transport 17,500 Transporting patients 16,200 Verifying lab orders 14,500 Searching for equipment 8,200 Incorrect labs 11,300 Lab tests 17,000 Counting supplies 19,000 Looking for supplies 8,200 Staff training 4,800 Total $160,000 a. b. c. d. Classify the…
Assume that the hospital uses the direct method for cost allocation Question: how to solve question a & b ?
Activity-Based Product Costing Suppose that a surgical ward has gathered the following information for four nursing activities and two types of patients: Patient Category Driver Normal Intensive Activity Rate Treating patients Treatments 7,400 9,500 $4.00 Providing hygienic care Hygienic hours 5,300 18,600 5.00 Responding to requests Requests 32,000 80,000 2.00 Monitoring patients Monitoring hours 6,000 72,000 3.00 Required: 1. Determine the total nursing costs assigned to each patient category. Costs Assigned Normal $fill in the blank 1 Intensive $fill in the blank 2 2. Output is measured in patient days. Assuming that the normal patient category uses 8,000 patient days and the intensive patient category uses 6,400 patient days, calculate the nursing cost per patient day for each type of patient. Round your answers to the nearest cent. Normal $fill in the blank 3 per patient day Intensive $fill in the blank 4 per patient day 3. Conceptual…