Compare traditional and ABC allocations at a pharmacy (Learning Objective 2)
Dover Pharmacy, part of a large chain of pharmacies, fills a variety of prescriptions for customers. The complexity of prescriptions filled by Dover varies widely; pharmacists can spend between five minutes and six hours on a prescription order. Traditionally, the pharmacy has allocated its
The pharmacy chain’s controller is exploring whether activity-based costing (ABC) may better allocate the pharmacy overhead costs to pharmacy orders. The controller has gathered the following information:
The clerk for Dover has gathered the following information regarding two recent pharmacy orders:
Requirements
- 1. What is the traditional overhead rate based on the number of prescriptions?
- 2. How much pharmacy overhead would be allocated to customer order number 1247 if traditional overhead allocation based on the number of prescriptions is used?
- 3. How much pharmacy overhead would be allocated to customer order number 1248 if traditional overhead allocation based on the number of prescriptions is used?
- 4. What are the following cost pool allocation rates?
- a. Pharmacy occupancy costs
- b. Packaging supplies
- c. Professional training and insurance costs
- 5. How much would be allocated to customer order number 1247 if activity-based costing (ABC) is used to allocate the pharmacy overhead costs?
- 6. How much would be allocated to customer order number 1248 if activity-based costing (ABC) is used to allocate the pharmacy overhead costs?
- 7. Which allocation method (traditional or activity-based costing) would produce a more accurate product cost? Explain your answer.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Managerial Accounting (5th Edition)
- Cost Identification Following is a list of cost terms described in the chapter as well as a list of brief descriptive settings for each item. Cost terms: a. Opportunity cost b. Period cost c. Product cost d. Direct labor cost e. Selling cost f. Conversion cost g. Prime cost h. Direct materials cost i. Manufacturing overhead cost j. Administrative cost Settings: 1. Marcus Armstrong, manager of Timmins Optical, estimated that the cost of plastic, wages of the technician producing the lenses, and overhead totaled 30 per pair of single-vision lenses. 2. Linda was having a hard time deciding whether to return to school. She was concerned about the salary she would have to give up for the next 4 years. 3. Randy Harris is the finished goods warehouse manager for a medium-sized manufacturing firm. He is paid a salary of 90,000 per year. As he studied the financial statements prepared by the local certified public accounting firm, he wondered how his salary was treated. 4. Jamie Young is in charge of the legal department at company headquarters. Her salary is 95,000 per year. She reports to the chief executive officer. 5. All factory costs that are not classified as direct materials or direct labor. 6. The new product required machining, assembly, and painting. The design engineer asked the accounting department to estimate the labor cost of each of the three operations. The engineer supplied the estimated labor hours for each operation. 7. After obtaining the estimate of direct labor cost, the design engineer estimated the cost of the materials that would be used for the new product. 8. The design engineer totaled the costs of materials and direct labor for the new product. 9. The design engineer also estimated the cost of converting the raw materials into their final form. 10. The auditor for a soft drink bottling plant pointed out that the depreciation on the delivery trucks had been incorrectly assigned to product cost (through overhead). Accordingly, the depreciation charge was reallocated on the income statement. Required: Match the cost terms with the settings. More than one cost classification may be associated with each setting; however, select the setting that seems to fit the item best. When you are done, each cost term will be used just once.arrow_forwardMaloney Pharmaceuticals manufacturers an over-the-counter allergy medication. The company sells both large commercial containers of 1,000 capsules to health care facilities and travel packs of 20 capsules to shops in airports, train stations, and hotels. The following information has been developed to determine if an activity-based costing system would be beneficial: LOADING... (Click the icon to view the information.) Read the requirements LOADING... . Requirement 1. Maloney's original single plantwide overhead allocation rate costing system allocated indirect costs to products at $154.88 per machine hour. Compute the total indirect costs allocated to the commercial containers and to the travel packs under the original system. Then compute the indirect cost per unit for each product. Round to two decimal places. Select the formula, and then enter the amounts to compute the indirect cost per unit for each product.…arrow_forwardMatch each of the following cost items with the value chain business function where you would expect the cost to be incurred: Cost Item 1. Labor time to repair products under warranty 2. Radio commercials 3. Labor costs of delivering customer orders 4. Testing of competitor's product 5. Direct manufacturing labor costs 6. Development of order tracking system for online sales 7. Design cost of new product brochures 8. Hours spent designing childproof bottles 9. Training costs for representatives to staff the customer call center 10. Installation of robotics equipment in manufacturing plant Business Functionarrow_forward
- Burgess Business School has two degree programs, BBA and MBA. The school uses an ABC system to cost the three support services it provides to students from both programs: Career Center, Events, and Library. Following are the costs of these three activities and the cost drivers used in the system: Activity Cost Activity Career Center Event planning and hosting. Library For the most recent year, data collected from the central IT systems indicate the following: MBA 5,600 4,500 30,300 BBA 10,400 5,500 70,700 $ 448,000 440,000 606,000 Cost Driver Interview-hours Event attendance Number of visits Interview-hours Event attendance Library visits Required: a. Compute the cost-driver rates for the three activities at the school. b. Suppose that in a future period, no students from the MBA program visited the Library. What amount of the Library cost would be assigned to the MBA program?arrow_forwardCalculating and Interpreting Activity-Based Costing Data Hiram’s Lakeside is a popular restaurant located on Lake Washington in Seattle. The owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an activity-based costing study. The intern, in consultation with the owner, identified three major activities and then completed the first-stage allocations of costs to the activity cost pools. The results appear below. The above costs include all of the costs of the restaurant except for organization-sustaining costs such as rent, property taxes, and top-management salaries. Some costs, such as the cost of cleaning the linens that cover the restaurant’s tables, vary with the number of parties served. Other costs, such as washing plates and glasses, depend on the number of diners served or the number of drinks served. Prior to the activity-based costing study, the owner knew very little about the costs of the restaurant.…arrow_forwardUse ABC to allocate manufacturing overhead (Learning Objective 2)Several years after reengineering its production process, King Corporation hired a new controller, Christine Erickson . She developed an ABC system very similar to the one used by King's chief rival. Part of the reason Erickson developed the ABC system was because King's profits had been declining, even though the company had shifted its product mix toward the product that had appeared most profitable under the old system . Before adopting the new ABC system, the company had used a plantwide overhead rate, based on direct labor hours developed years ago .For the upcoming year, King's budgeted ABC manufacturing overhead allocation rates are as follows :ActivityMaterials handling .......................... Machine setup ................................ Insertion of parts ............................ Finishing .........................................Allocation BaseNumber of partsNumber of setupsNumber of partsFinishing…arrow_forward
- Please solve the task by reading attached pictures of background knowledge. Christine wants to improve the profit situation of her company - and learn more about the profit per product for the past month. Christine is a follower of a full costing approach. Therefore all the costs should be allocated to the products. Perform this calculation by calculating three alternatives for the distribution of fixed overheads:? •Distribution in equal parts? •Distribution proportional to sales ? •Distribution proportional to sales. All three allocation keys are common allocation routes in practice. Which one should Christine prefer?arrow_forwardApplying Excel - Data Visualization: Exercise (Part 2 of 2) On the Data Visualization - Student tab in your Excel spreadsheet, update the price per unit for all four products for Office Warehouse Inc. with the data below: Products Available Paper Pens Sticky Notes Envelopes Required: Create a Pivot Table and determine the following information while analyzing the data: 2. Which product has the highest total units ordered and the highest total sales? (Enter your Units Ordered to the nearest whole unit and your Total Sales to 2 decimal places.) Units Ordered Total Sales Price per Unit $20.00 per case: $ 9.00 per box $9.00 per package $ 4.50 per box Product Totalarrow_forwardMed Max buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to dozens of hospitals. In the face of declining profits, Med Max decided to implement an activity-based costing system to improve its understanding of the costs incurred to serve each hospital. The company broke its selling and administrative expenses into four activities as shown below: Activity Cost Pool Customer deliveries Manual order processing Activity Measure Number of deliveries Number of manual orders Number of electronic orders Number of line items picked Electronic order processing Line item picking Total selling and administrative expenses Med Max gathered the data below for two of the many hospitals that it serves-City General and County General: Activity City General 10 0 10 100 Required 1 Required 2 County General Activity Cost Pool 20 40 Required: 1. Compute the activity rate for each activity cost pool. 2. Compute the total activity costs that would be assigned…arrow_forward
- Fanning Academy is a profit-oriented education business. Fanning provides remedial training for high school students who have fallen behind in their classroom studies. It charges its students $730 per course. During the previous year, Fanning provided instruction for 1,000 students. The income statement for the company follows: Revenue Cost of instructors Overhead costs Net income $ 730,000 (434,000) (232,500) $ 63,500 The company president, Andria Rossi, indicated in a discussion with the accountant, Sam Trent, that she was extremely pleased with the growth in the area of computer-assisted instruction. She observed that this department served 300 students using only three part- time instructors. In contrast, the classroom-based instructional department required 28 instructors to teach 700 students. Ms. Rossi noted that the per-student cost of instruction was dramatically lower for the computer-assisted department. She based her conclusion on the following information: Fanning pays its…arrow_forwardA training company runs courses for students that vary in length between one day and four weeks. The size of classes varies between 5 students and 40 students. The company wants to set a price for its courses based on a mark-up on cost. What would be the most appropriate basis for measuring costs? Question 2 options: 1) Cost per student per day 2) Cost per course 3) Cost per student 4) Cost per dayarrow_forwardA local picnic table manufacturer has budgeted these overhead costs: They are considering adapting ABC costing and have estimated the cost drivers for each pool as shown: Recent success has yielded an order for 1,000 tables. Assume direct labor costs per hour of $20. Determine how much the job would cost given the following activities:arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College