Concept explainers
Product costing and decision analysis for a service company
Pleasant Slay Medical Inc. wishes to determine its product costs. Pleasant Stay offers a variety of medical procedures (operations) that are considered its “products.” The
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 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:
Activity-Base Usage | |
Procedure A | |
Number of patients | 280 |
Average length of stay | × 6 days |
Patient days | 1,680 |
Weighted care units | 1,200 |
Procedure B | |
Number of patients | 650 |
Average length of stay | × 5 days |
Patient days | 3,250 |
Weighted care units | 6,000 |
Procedure C | |
Number of patients | 1,200 |
Average length of stay | × 4 days |
Patient days | 4,800 |
Weighted care units | 24,000 |
Private insurance reimburses the hospital for these activities at a fixed daily rate of $406 per patient day for all three procedures.
Instructions
- 1. Determine the activity rates.
- 2. Determine the activity cost for each procedure.
- 3. Determine the excess or deficiency of reimbursements to activity cost.
- 4. Interpret your results.
Want to see the full answer?
Check out a sample textbook solutionChapter 18 Solutions
Financial & 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_forwardProduct costing and decision analysis for a service company Blue Star Airline provides passenger airline service, using small jets. The airline connects four major cities: Charlotte, Pittsburgh, Detroit, and San Francisco. The company expects to fly 170,000 miles during a month. The following costs are budgeted for a month: Blue Star management wishes to assign these costs to individual flights in order to gauge the profitability of its service offerings. The following activity bases were identified with the budgeted costs: The size of the companys ground operation in each city is determined by the size of the workforce. The following monthly data are available from corporate records for each terminal operation: Three recent representative flights have been selected for the profitability study. Their characteristics are as follows: Instructions Determine the fuel, crew, and depreciation cost per mile flown. Determine the cost per arrival or departure by terminal city. Use the information in (1) and (2) to construct a profitability report for the three flights. Each flight has a single arrival and departure to its origin and destination city pairs.arrow_forwardMedical Tape makes two products: Generic and Label. It estimates it will produce 423,694 units of Generic and 652,200 of Label, and the overhead for each of its cost pools is as follows: It has also estimated the activities for each cost driver as follows: How much is the overhead allocated to each unit of Generic and Label?arrow_forward
- Overhead Rates, Unit Costs Folsom Company manufactures specialty tools to customer order. There are three producing departments. Departmental information on budgeted overhead and various activity measures for the coming year is as follows: Currently, overhead is applied on the basis of machine hours using a plantwide rate. However, Janine, the controller, has been wondering whether it might be worthwhile to use departmental overhead rates. She has analyzed the overhead costs and drivers for the various departments and decided that Welding and Finishing should base their overhead rates on machine hours and that Assembly should base its overhead rate on direct labor hours. Janine has been asked to prepare bids for two jobs with the following information: The typical bid price includes a 35% markup over full manufacturing cost. Round all overhead rates to the nearest cent. Round all bid prices to the nearest dollar. Required: 1. Calculate a plantwide rate for Folsom Company based on machine hours. What is the bid price of each job using this rate? 2. Calculate departmental overhead rates for the producing departments. What is the bid price of each job using these rates?arrow_forwardBumblebee Mobiles manufactures a line of cell phones. The management has identified the following overhead costs and related cost drivers for the coming year. The following were incurred in manufacturing two of their cell phones, Bubble and Burst, during the first quarter. REQUIREMENT Review the worksheet called ABC that follows these requirements. You have been asked to determine the cost of each product using an activity-based cost system. Note that the problem information is already entered into the Data Section of the ABC worksheet.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
- Firenza Company manufactures specialty tools to customer order. Budgeted overhead for the coming year is: Previously, Sanjay Bhatt, Firenza Companys controller, had applied overhead on the basis of machine hours. Expected machine hours for the coming year are 50,000. Sanjay has been reading about activity-based costing, and he wonders whether or not it might offer some advantages to his company. He decided that appropriate drivers for overhead activities are purchase orders for purchasing, number of setups for setup cost, engineering hours for engineering cost, and machine hours for other. Budgeted amounts for these drivers are 5,000 purchase orders, 500 setups, and 2,500 engineering hours. Sanjay has been asked to prepare bids for two jobs with the following information: The typical bid price includes a 40 percent markup over full manufacturing cost. Required: 1. Calculate a plantwide rate for Firenza Company based on machine hours. What is the bid price of each job using this rate? 2. Calculate activity rates for the four overhead activities. What is the bid price of each job using these rates? 3. Which bids are more accurate? Why?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_forwardObjective: Consider that you are an analyst at Regeneron Pharmaceuticals. You need to decide how to allocate administrative overhead costs to Regeneron's main commercial products (Eylea, Dupixent, Kevzara and Praluent). Determine how to appropriately allocate the costs in the table below to each of the commercial products using an allocation methodology of your choice. Department2019 Annual Operating ExpenseTime spent supporting Commercial productsCommercial$200MM100%IT$100MM25%Facilities$150MM0%Finance$25MM20%Human Resources$75MM10% Use the supporting document Net Product Sales of REGN Products to facilitate your analysis. Provide a written summary of how you allocated the overhead costs to each product in an outline of no more than one page. As a starting point, it's recommended that you revisit the material we covered in Chapter 12. Guidance on calculations:Start off with Net Product Sales of REGN Products. Your objective pertains to 2019 expenses, so you should be reviewing 2019…arrow_forward
- The pool rate is defined as the cost per unit of the cost driver for a particular activity cost pool. Group of answer choices True False Rocket Products manufactures three types of remote-control devices: Economy, Standard, and Deluxe. The company, which uses activity-based costing, has identified five activities (and related cost drivers). Each activity, its budgeted cost, and related cost driver is identified below. Activity Cost Cost Driver Material handling $ 225,000 Number of parts Material insertion 2,475,000 Number of parts Automated machinery 840,000 Machine hours Finishing 170,000 Direct labor hours Packaging 170,000 Orders shipped Total $ 3,880,000 The following information pertains to the three product lines for next year: Economy Standard Deluxe Units to be produced 10,000 5,000 2,000 Orders to be shipped 1,000 500 200 Number of parts per unit 10 15 25 Machine…arrow_forwardActivity-Based Costing and Customer Profitability Schneider Electric manufactures power distribution equipment for commercial customers, such as hospitals and manufacturers. Activity-based costing was used to determine customer profitability. Customer service activities were assigned to individual customers, using the following assumed customer service activities, activity base, and activity rate: Customer Service Activity Activity Base Activity Rate Bid preparation Number of bid requests $400 per request Shipment Number of shipments $ 80 per shipment Support standard items Number of standard items ordered $ 25 per std. item Support nonstandard items Number of nonstandard items ordered $150 per nonstd. item Assume that the company had the following gross profit information for three representative customers: Customer 1 Customer 2 Customer 3 Revenues $120,000 $200,000 $160,000 Cost of goods sold 76,800 110,000 83,200 Gross profit…arrow_forwardActivity-Based Costing and Customer Profitability Schneider Electric manufactures power distribution equipment for commercial customers, such as hospitals and manufacturers. Activity-based costing was used to determine customer profitability. Customer service activities were assigned to individual customers, using the following assumed customer service activities, activity base, and activity rate: Customer Service Activity Activity Base Activity Rate Bid preparation Number of bid requests $400 per request Shipment Number of shipments $ 80 per shipment Support standard items Number of standard items ordered $ 25 per std. item Support nonstandard items Number of nonstandard items ordered $150 per nonstd. item Assume that the company had the following gross profit information for three representative customers: Customer 1 Customer 2 Customer 3 Revenues $120,000 $200,000 $160,000 Cost of goods sold 76,800 110,000 83,200 Gross profit…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 PubManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning