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_forwardActivity-based costing: selling and administrative expenses Jungle Junior Company manufactures and sells outdoor play equipment. Jungle Junior uses activity-based costing to determine the cost of the sales order processing and the customer return activity. The sales order processing activity has an activity rate of 20 per sales order, and the customer return activity has an activity rate of 100 per return. Jungle Junior sold 2,500 swing sets, which consisted of 750 orders and 80 returns. Determine (A) the total and (B) the per-unit sales order processing and customer return activity cost for swing sets.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_forward
- Medical 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_forwardOverhead 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_forwardVarney Corporation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services Department (CCS) costs to profit centers. The following table lists the types of services and cost drivers for each service. The table also includes the budgeted cost and quantity for each service for August. One of the profit centers for Varney Corporation is the Communication Systems (COMM) division. Assume the following information for COMM: COMM has 2,500 employees, of whom 20% are office employees. All of the office employees have been issued a smartphone, and 95% of them have a computer on the network. One hundred percent of the employees with a computer also have an email account. The average number of help desk calls for August was 0.6 call per individual with a computer. There are 400 additional printers, servers, and peripherals on the network beyond the personal computers. a. Compute the service allocation rate for each of CCSs services for August. b. Compute the allocation of CCSs services to COMM for August.arrow_forward
- Bumblebee 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_forwardThe management of Nova Industries Inc. manufactures gasoline and diesel engines through two production departments, Fabrication and Assembly. Management needs accurate product cost information in order to guide product strategy. Presently, the company uses a single plantwide factory overhead rate for allocating factory overhead to the two products. However, management is considering the multiple production department factory overhead rate method. The following factory overhead was budgeted for Nova: Direct labor hours were estimated as follows: In addition, the direct labor hours (dlh) used to produce a unit of each product in each department were determined from engineering records, as follows: a. Determine the per-unit factory overhead allocated to the gasoline and diesel engines under the single plantwide factory overhead rate method, using direct labor hours as the activity base. b. Determine the per-unit factory overhead allocated to the gasoline and diesel engines under the multiple production department factory overhead rate method, using direct labor hours as the activity base for each department. c. Recommend to management a product costing approach, based on your analyses in (a) and (b). Support your recommendation.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_forwardAllocating selling and administrative expenses using activity-based costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: In addition, the company incurs selling and administrative expenses of 414,030. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related to its three major nonmanufacturing activities: customer service, sales order processing, and advertising support. The advertising support is in the form of advertisements that are placed by Shrute Inc. to support the retailers sale of Shrute copiers to consumers. The budgeted activity costs and activity bases associated with these activities are: Activity-base usage and unit volume information for the three customers is as follows: Instructions Determine the activity rates for each of the three nonmanufacturing activities. Determine the activity costs allocated to the three customers, using the activity rates in (1). Construct customer profitability reports for the three customers, dated for the year ended December 31, using the activity costs in (2). The reports should disclose the gross profit and operating income associated with each customer. Provide recommendations to management, based on the profitability reports in (3).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
- 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
- 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