Concept explainers
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.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Bundle: Managerial Accounting, 15th + Cengagenowv2, 1 Term Printed Access Card
- Bounce Back Insurance Company carries three major lines of insurance: auto, workers compensation, and homeowners. The company has prepared the following report: Management is concerned that the administrative expenses may make some of the insurance lines unprofitable. However, the administrative expenses have not been allocated to the insurance lines. The controller has suggested that the administrative expenses could be assigned to the insurance lines using activity-based costing. The administrative expenses are comprised of five activities. The activities and their rates are as follows: Activity-base usage data for each line of insurance were retrieved from the corporate records as follows: a. Complete the product profitability report through the administrative activities. Determine the operating income as a percent of premium revenue, rounded to the nearest whole percent. b. Interpret the report.arrow_forwardHospital activity-based costing analysis Lancaster County Hospital uses activity-based costing to determine the cost of serving patients. The hospital identified common treatments and developed the activity-based cost per patient by treatment. The activities and activity rates for a patient receiving coronary bypass surgery are as follows: Nursing care units are measures of time and effort to perform nursing duties, such as providing IV care, checking vital signs, and administering drugs. It is determined that there are an average of 10 nursing care units per patient day in the hospital for a coronary bypass. The average bypass patient is in the hospital for 6 days. The bypass procedure requires an average of 3 hours of operating room time. A. Determine the activity cost per patient for the coronary bypass treatment. B. Assume the hospital was able to make improvements such that the average length of stay in the hospital for the bypass was reduced from 6 days to 5 days. Further assume that additional improvements in medical technology reduced the operating room time for a bypass to 2 hours. Determine the activity cost per patient for the coronary bypass treatment under these revised conditions. What is the cost improvement?arrow_forwardMethod of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Required: 1. Using the results from the method of least squares, prepare a cost formula for the receiving activity. 2. Using the formula from Requirement 1, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? (Note: Round your answer to the nearest dollar.) 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated?arrow_forward
- A manufacturing company has two service and two production departments. Human Resources and Machine Repair are the service departments. The production departments are Grinding and Polishing. The following data have been estimated for next years operations: The direct charges identified with each of the departments are as follows: The human resources department services all departments of the company, and its costs are allocated using the numbers of employees within each department, while machine repair costs are allocable to Grinding and Polishing on the basis of machine hours. 1. Distribute the service department costs, using the direct method. 2. Distribute the service department costs, using the sequential distribution method, with the department servicing the greatest number of other departments distributed first.arrow_forwardCan you help with part 4 of this quesstion? Parts 1, 2, and 3 have been answered. 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: ActivityBudgeted Activity CostActivity BaseScheduling and admitting$432,000 Number of patientsHousekeeping4,212,000 Number of patient daysNursing5,376,000 Weighted care unitTotal 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 average patient is expected to have a a little more than a…arrow_forwardCan you help with the second part of part 4 of this quesstion? Parts 1, 2, 3, and part of question 4 have been answered. 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: ActivityBudgeted Activity CostActivity BaseScheduling and admitting$432,000 Number of patientsHousekeeping4,212,000 Number of patient daysNursing5,376,000 Weighted care unitTotal 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 average patient is…arrow_forward
- Standard costs are divided into which of the following components? A. price standard and quantity standard B. quality standard and quantity standard C. variance standard and quantity standard D. materials standard and labor standard Which of the following activity bases would be the most appropriate for food costs of a hospital? A. how many MRI's are taken B. number of patients who stay in the hospital C. quantity of prescriptions filled D. number of nurses scheduled to work To calculate income from operations, total service department charges are A. subtracted from operating expenses B. subtracted from income from operations before service department charges C. subtracted from gross profit margin D. added to income from operations before service department chargesarrow_forwardCompute the linear cost function, relating total overhead costs to physician contact hours, using the representative observations of 200 and 300 hours. Plot the linear cost function. Does the constant component of the cost function represent the fixed overhead costs of Young and Associates? Why?arrow_forwardRequired information [The following information applies to the questions displayed below.] Raner, Harris and Chan is a consulting firm specializing in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. It classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given below: Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Total Company Net operating income increase $ 468,000 234,000 234,000 131,040 102,960 65,520 $ 37,440 100.00% 50.00% 50.00% 28.00% 22.00% 14.00% 8.00% Chicago $ 156,000 46,800 109, 200 81,120 $ 28,080 Office 100.00% 30.00% 70.00% 52.00% 18.00% Minneapolis $ 312,000 187, 200 124,800 49,920 $ 74,880 100.00% 60.00% 40.00% 16.00% 24.00% 2. How much would the company's net operating income increase if…arrow_forward
- Required information [The following information applies to the questions displayed below.] Raner, Harris and Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given: Sales Variable expenses Contribution margin Traceable fixed expenses office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 477,000 238,500 238,500 133,560 104,940 66,780 $38,160 100.00% 50.00% 50.00% 28.00% 22.00% 14.00% 8.00% Chicago $ 159,000 47,700 111,300 82,680 $ 28,620 Office 100.00% 30.00% 70.00% 52.00% 18.00 % Minneapolis $318,000 190,800 127, 200 50,880 $ 76,320 100.00% 60.00% 40.00% 16.00% 24.00% Required: 1-a. Compute the companywide break-even point in dollar sales. 1-b. Compute the…arrow_forwardRequired information [The following information applies to the questions displayed below.] Raner, Harris and Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given: Sales Variable expenses Contribution margin Traceable fixed expenses Office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 454,500 227,250 227,250 127,260 99,990 63,630 $ 36,360 100.00% 50.00% 50.00% 28.00% 22.00% 14.00% 8.00% Chicago $ 151,500 45,450 106,050 78,780 $ 27,270 Office 100.00% 30.00% 70.00% 52.00% 18.00% Minneapolis $ 303,000 181,800 121,200 48,480 $ 72,720 100.00% 60.00% 40.00% 16.00% 24.00% 3. Assume that sales in Chicago increase by $50,500 next year and that sales in Minneapolis remain…arrow_forwardCrosswinds 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.…arrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning