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
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
Managerial Accounting
- 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_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_forwardA 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_forward
- 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.…arrow_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_forwardVishnuarrow_forward
- Providence Hospital generates monthly performance reports for each of its departments. The hospital must maintain an adequate staff of attending and on-call physicians at all times, so physician costs are not affected by the number of patient visits. But all other costs do vary with patient activity. Nurse- hours are used as the activity measure for nursing costs, and patient visits are used as the activity measure for the cost of supplies and other variable costs. The head physician of the hospital's emergency room, Yolanda Mortensen, is responsible for control of costs. During October, the emergency room unit expected to treat 3,500 patients but actually treated 4,000 patients. The following additional information for October is available: Budget Actual Variance Nurse-hours 2,100 2,320 -220 Nursing costs $46,200 $30,000 $16,200 Supplies & other variable $38,500 $25,500 $13,000 costs Fixed costs $104,200 $109,900 $-5,700 Required Compute the flexible-budget variances for each of the…arrow_forwardMission Company is preparing its annual profit plan. As part of its analysis of the profitability of individual products, the controller estimates the amount of overhead that should be allocated to the individual product lines from the information provided below. (CMA adapted) Multiple Choice Units produced Material moves per product line Direct labor-hours per product line Budgeted material handling costs: $279,500 Under an activity-based costing (ABC) system, the materials handling costs allocated to one unit of Specialty Windows would be: $6,450.00. $2,170.68. $12,900.00. Wall Mirrors 220 5 1,100 $10,320.00. Specialty Windows 20 60 1,200arrow_forwardplease give answer step by steparrow_forward
- Draw a graph of the cost behavior for each of the following costs incurred by the Mountain Summit Hospital. The hospital measures monthly activity in patient days. Label both axes and the cost line in each graph.1. The cost of food varies in proportion to the number of patient days of activity. In January, the hospital provided 3,000 patient days of care, and food costs amounted to $24,000.2. The cost of salaries and fringe benefits for the administrative staff totals $12,000 per month.3. The hospital’s laboratory costs include two components: (a) $40,000 per month for compensation of personnel and depreciation on equipment and (b) $10 per patient day for chemicals and other materials used in performing the tests.4. The cost of utilities depends on how many wards the hospital needs to use during a particular month. During months with activity under 2,000 patient days of care, two wards are used, resulting in utility costs of $10,000. During months with greater than 2,000 patient days…arrow_forwardMission Company is preparing its annual profit plan. As part of its analysis of the profitability of individual products, the controller estimates the amount of overhead that should be allocated to the individual product lines from the information provided below (CMA adapted) Multiple Choice Units produced Material moves per product line Direct labor-hours per product line Budgeted material handling costs: $594,000 Under a traditional costing system that allocates overhead on the basis of direct labor-hours, the materials handling costs allocated to one unit of Wall Mirrors would be O $1000 $1.350 $5,400 Wall Mirrors 210 5 1,050 $22.000 Specialty Nindows 25 46arrow_forwardNeed help using ABC product costing model. Grand Haven is a senior living community that offers a full range of services including independent living, assisted living, and skilled nursing care. The asssited living division provides residential space, meals, and medical services (MS) to its residents. The current costing system adds the cost of all of these services (space, meals, and MS) and divides by total resident days to get a cost per resident day for each month. Recognizing that MS tends to vary significantly among the residents, Grant Haven's accountant recommended that an ABC system be designed to calculate more accurated the cost of MS provided to residents. She decided that residents should be classified into four categories (A, B, C, D) based on the level of services received, with group A representing the lowest level of services and D representing the highest level of service. Two cost drivers being considered for measuring MS costs are number of assistance calls…arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning