Assignment Material

Questions

  1. 5-1. What is broad averaging, and what consequences can it have on costs?
  2. 5-2. Why should managers worry about product overcosting or undercosting?
  3. 5-3. What is costing system refinement? Describe three guidelines for refinement.
  4. 5-4. What is an activity-based approach to designing a costing system?
  5. 5-5. Describe four levels of a cost hierarchy.
  6. 5-6. Why is it important to classify costs into a cost hierarchy?
  7. 5-7. What are the key reasons for product cost differences between simple costing systems and ABC systems?
  8. 5-8. Describe four decisions for which ABC information is useful.
  9. 5-9. What are five behavioral issues to consider in implementing ABC systems?
  10. 5-10. Describe four signs that help indicate when ABC systems are likely to provide the most benefits.
  11. 5-11. What are the main costs and limitations of implementing ABC systems?
  12. 5-12. “ABC systems only apply to manufacturing companies.” Do you agree? Explain.
  13. 5-13. “Activity-based costing is the wave of the present and the future. All companies should adopt it.” Do you agree? Explain.
  14. 5-14. “Increasing the number of indirect-cost pools is guaranteed to sizably increase the accuracy of product or service costs.” Do you agree? Why?
  15. 5-15. The controller of a retail company has just had a $50,000 request to implement an ABC system quickly turned down. A senior vice president, in rejecting the request, noted, “Given a choice, I will always prefer a $50,000 investment in improving things a customer sees or experiences, such as our shelves or our store layout. How does a customer benefit by our spending $50,000 on a supposedly better accounting system?” How should the controller respond?

Multiple-Choice Questions

In partnership with Becker professional education
  1. 5-16. Conroe Company is reviewing the data provided by its management accounting system. Which of the following statements is/are correct?
    1. I. A cost driver is a causal factor that increases the total cost of a cost object.
    2. II. Cost drivers may be volume based or activity based.
    3. III. Cost drivers are normally the largest cost in the manufacturing process.
    4. 1. I, II, and III are correct.
    5. 2. I and II only are correct.
    6. 3. I only is correct.
    7. 4. II and III only are correct.
  2. 5-17. Nobis Company uses an ABC system. Which of the following statements is/are correct with respect to ABC?
    1. I. All cost allocation bases used in ABC systems are cost drivers.
    2. II. ABC systems are useful in manufacturing, but not in merchandising or service industries.
    3. III. ABC systems can eliminate cost distortions because ABC develops cost drivers that have a cause-and-effect relationship with the activities performed.
    4. 1. I, II, and III are correct.
    5. 2. II and III only are correct.
    6. 3. III only is correct.
    7. 4. None of the listed choices is correct.

©2016 DeVry/Becker Educational Development Corp. All Rights Reserved.

Exercises

  1. 5-18. COST HIERARCHY. Roberta, Inc., manufactures elliptical machines for several well-known companies. The machines differ significantly in their complexity and their manufacturing batch sizes. The following costs were incurred in 2020:
    1. a. Indirect manufacturing labor costs such as supervision that supports direct manufacturing labor, $935,000
    2. b. Procurement costs of placing purchase orders, receiving materials, and paying suppliers related to the number of purchase orders placed, $650,000
    3. c. Cost of indirect materials, $234,000
    4. d. Costs incurred to set up machines each time a different product needs to be manufactured, $392,000
    5. e. Designing processes, drawing process charts, and making engineering process changes for products, $236,900
    6. f. Machine-related overhead costs such as depreciation, maintenance, and production engineering, $865,000 (These resources relate to the activity of running the machines.)
    7. g. Plant management, plant rent, and plant insurance, $498,000
    8. Required
    9. 1. Classify each of the preceding costs as output unit–level, batch-level, product sustaining, or facility sustaining. Explain each answer.
    10. 2. Consider two types of elliptical machines made by Roberta, Inc. One machine, designed for professional use, is complex to make and is produced in many batches. The other machine, designed for home use, is simple to make and is produced in few batches. Suppose that Roberta needs the same number of machine-hours to make each type of elliptical machine and that Roberta allocates all overhead costs using machine-hours as the only allocation base. How, if at all, would the machines be miscosted? Briefly explain why.
    11. 3. How is the cost hierarchy helpful to Roberta in managing its business?
  2. 5-19. ABC, COST HIERARCHY, SERVICE. (CMA, adapted) Vineyard Test Laboratories does heat testing (HT) and stress testing (ST) on materials and operates at capacity. Under its current simple costing system, Vineyard aggregates all operating costs of $1,190,000 into a single overhead cost pool. Vineyard calculates a rate per test-hour of $17 ($1,190,000 ÷ 70,000 total test-hours). HT uses 40,000 test-hours, and ST uses 30,000 test-hours. Gary Celeste, Vineyard’s controller, believes that there is enough variation in test procedures and cost structures to establish separate costing and billing rates for HT and ST. The market for test services is becoming competitive. Without this information, any miscosting and mispricing of its services could cause Vineyard to lose business. Celeste divides Vineyard’s costs into four activity-cost categories.
    1. a. Direct-labor costs, $146,000. These costs can be directly traced to HT, $100,000, and ST, $46,000.
    2. b. Equipment-related costs (rent, maintenance, energy, and so on), $350,000. These costs are allocated to HT and ST on the basis of test-hours.
    3. c. Setup costs, $430,000. These costs are allocated to HT and ST on the basis of the number of setup-hours required. HT requires 13,600 setup-hours, and ST requires 3,600 setup-hours.
    4. d. Costs of designing tests, $264,000. These costs are allocated to HT and ST on the basis of the time required for designing the tests. HT requires 3,000 hours, and ST requires 1,400 hours.
    5. Required
    6. 1. Classify each activity cost as output unit–level, batch-level, product or service sustaining, or facility sustaining. Explain each answer.
    7. 2. Calculate the cost per test-hour for HT and ST. Explain briefly the reasons why these numbers differ from the $17 per test-hour that Vineyard calculated using its simple costing system.
    8. 3. Explain the accuracy of the product costs calculated using the simple costing system and the ABC system. How might Vineyard’s management use the cost hierarchy and ABC information to better manage its business?
  3. 5-20. ALTERNATIVE ALLOCATION BASES FOR A PROFESSIONAL SERVICES FIRM. The Walliston Group (WG) provides tax advice to multinational firms. WG charges clients for (a) direct professional time (at an hourly rate) and (b) support services (at 30% of the direct professional costs billed). The three professionals in WG and their rates per professional hour are as follows:
ProfessionalBilling Rate per Hour
Max Walliston$640
Alexa Boutin220
Jacob Abbington100
  1. WG has just prepared the May 2020 bills for two clients. The hours of professional time spent on each client are as follows:
<p>A table gives hours per client for Walliston Group</p>

The table depicts four professionals and the hours they each spent on two different clients, plus the total hours for each client. The details of the table are as follows:

  1. Walliston
    • Hours per client, San Antonio Dominion: 26
    • Hours per client, Amsterdam Enterprises: 4
  1. Boutin
    • Hours per client, San Antonio Dominion: 5
    • Hours per client, Amsterdam Enterprises: 14
  1. Abbington
    • Hours per client, San Antonio Dominion: 39
    • Hours per client, Amsterdam Enterprises: 52
  1. Total
    • Hours per client, San Antonio Dominion: 70
    • Hours per client, Amsterdam Enterprises: 70
    1. Required
    2. 1. What amounts did WG bill to San Antonio Dominion and Amsterdam Enterprises for May 2020?
    3. 2. Suppose support services were billed at $75 per professional labor-hour (instead of 30% of professional labor costs). How would this change affect the amounts WG billed to the two clients for May 2020? Comment on the differences between the amounts billed in requirements 1 and 2.
    4. 3. How would you determine whether professional labor costs or professional labor-hours is the more appropriate allocation base for WG’s support services?
  1. 5-21. PLANTWIDE, DEPARTMENT, AND ABC INDIRECT COST RATES. Roadster Company (RC) designs and produces automotive parts. In 2020, actual variable manufacturing overhead is $280,000. RC’s simple costing system allocates variable manufacturing overhead to its three customers based on machine-hours and prices its contracts based on full costs. One of its customers has regularly complained of being charged noncompetitive prices, so RC’s controller Matthew Draper realizes that it is time to examine the consumption of overhead resources more closely. He knows that there are three main departments that consume overhead resources: design, production, and engineering. Interviews with the department personnel and examination of time records yield the following detailed information:
A screenshot of a spreadsheet shows the cost driver, manufacturing overhead, and usage of cost drivers by customer contract for various departments.

The details of the spreadsheet are as follows:

  1. Department: Design

    1. Cost Driver: CAD–design–hours

    2. Manufacturing Overhead in 2017: dollar 35,000

    3. Usage of Cost Drivers by Customer Contract

      1. Southern Motors: 150

      2. Caesar Motors: 250

      3. Jupiter Auto: 100

  2. Department: Production

    1. Cost Driver: Engineering–hours

    2. Manufacturing Overhead in 2017: dollar 25,000

    3. Usage of Cost Drivers by Customer Contract

      1. Southern Motors: 130

      2. Caesar Motors: 100

      3. Jupiter Auto: 270

  3. Department: Engineering

    1. Cost Driver: Machine–hours

    2. Manufacturing Overhead in 2017: dollar 220,000

    3. Usage of Cost Drivers by Customer Contract

      1. Southern Motors: 300

      2. Caesar Motors: 3,700

      3. Jupiter Auto: 1,000

  4. Total manufacturing overhead in 2017: dollar 280,000

    1. Required
    2. 1. Compute the manufacturing overhead allocated to each customer in 2020 using the simple costing system that uses machine-hours as the allocation base.
    3. 2. Compute the manufacturing overhead allocated to each customer in 2020 using department-based manufacturing overhead rates.
    4. 3. Comment on your answers in requirements 1 and 2. Which customer do you think was complaining about being overcharged in the simple system? If the new department-based rates are used to price contracts, which customer(s) will be unhappy? How would you respond to these concerns?
    5. 4. How else might RC use the information available from its department-by-department analysis of manufacturing overhead costs?
    6. 5. RC’s managers are wondering if they should further refine the department-by-department costing system into an ABC system by identifying different activities within each department. Under what conditions would it not be worthwhile to further refine the department costing system into an ABC system?
  1. 5-22. PLANTWIDE, DEPARTMENT, AND ACTIVITY-COST RATES. Trendy Inc. makes two styles of trophies, basic and deluxe, and operates at capacity. Trendy does large custom orders. Trendy budgets to produce 10,000 basic trophies and 5,000 deluxe trophies. Manufacturing takes place in two production departments: forming and assembly. In the forming department, indirect manufacturing costs are accumulated in two cost pools, setup and general overhead. In the assembly department, all indirect manufacturing costs are accumulated in one general overhead cost pool. The basic trophies are formed in batches of 200 but because of the more intricate detail of the deluxe trophies, they are formed in batches of 50.
  2. The controller has asked you to compare plantwide, department, and activity-based cost allocation.
<p>A table shows plantwide, department, and activity-based cost allocation for Trendy Inc.</p>

The table depicts costs from the forming department and the assembly department for basic and deluxe styles of trophies, as well as totals. The details of the table are as follows:

  1. Forming Department, direct materials
    • Basic: 25,000 dollars
    • Deluxe: 19,800 dollars
    • Total: 44,800 dollars
  1. Forming Department, direct manufacturing labor
    • Basic: 24,000 dollars
    • Deluxe: 25,000 dollars
    • Total: 49,000 dollars
  1. Forming Department, overhead costs
    • Setup total: 36,750 dollars
    • General overhead total: 31,850 dollars
  1. Assembly Department, direct materials
    • Basic: 5,000 dollars
    • Deluxe: 4,450 dollars
    • Total: 9,450 dollars
  1. Assembly Department, direct manufacturing labor
    • Basic: 15,500 dollars
    • Deluxe: 19,500 dollars
    • Total: 35,000 dollars
  1. Assembly Department, overhead costs
    • General overhead total: 42,000 dollars
    1. Required
    2. 1. Calculate the budgeted unit cost of basic and deluxe trophies based on a single plantwide overhead rate, if total overhead is allocated based on total direct costs. (Don’t forget to include direct material and direct manufacturing labor cost in your unit cost calculation.)
    3. 2. Calculate the budgeted unit cost of basic and deluxe trophies based on departmental overhead rates, where forming department overhead costs are allocated based on direct manufacturing labor costs of the forming department and assembly department overhead costs are allocated based on total direct manufacturing labor costs of the assembly department.
    4. 3. Calculate the budgeted unit cost of basic and deluxe trophies if Trendy allocates overhead costs in each department using activity-based costing, where setup costs are allocated based on number of batches and general overhead costs for each department are allocated based on direct manufacturing labor costs of each department.
    5. 4. Explain briefly why plantwide, department, and activity-based costing systems show different costs for the basic and deluxe trophies. Which system would you recommend and why?
  1. 5-23. ABC, PROCESS COSTING. Walsh Company produces mathematical and financial calculators and operates at capacity. Data related to the two products are presented here:
<p>A table shows data for two products produced by Walsh Company</p>

The table depicts annual production in units, direct material costs, direct manufacturing labor costs, direct manufacturing labor-hours, machine-hours, number of production runs, and inspection-hours for mathematical and financial products. The details of the table are as follows:

  1. Annual production in units
    • Mathematical: 25,000
    • Financial: 50,000
  1. Direct material costs
    • Mathematical: 75,000 dollars
    • Financial: 150,000 dollars
  1. Direct manufacturing labor costs
    • Mathematical: 25,000 dollars
    • Financial: 50,000 dollars
  1. Direct manufacturing labor-hours
    • Mathematical: 1,250
    • Financial: 2,500
  1. Machine-hours
    • Mathematical: 40,000
    • Financial: 70,000
  1. Number of production runs
    • Mathematical: 50
    • Financial: 50
  1. Inspection-hours
    • Mathematical: 1,200
    • Financial: 800
  1. Total manufacturing overhead costs are as follows:
Total
Machining costs $440,000
Setup costs   110,000
Inspection costs   120,000
    1. Required
    2. 1. Choose a cost driver for each overhead cost pool and calculate the manufacturing overhead cost per unit for each product.
    3. 2. Compute the manufacturing cost per unit for each product.
    4. 3. How might Walsh’s managers use the new cost information from its activity-based costing system to better manage its business?
  1. 5-24. DEPARTMENT COSTING, SERVICE COMPANY. DLN is an architectural firm that designs and builds buildings. It prices each job on a cost plus 20% basis. Overhead costs in 2020 are $8,100,000. DLN’s simple costing system allocates overhead costs to its jobs based on number of jobs. There were three jobs in 2020. One customer, Chandler, has complained that the cost and price of its building in Chicago was not competitive. As a result, the controller has initiated a detailed review of the overhead allocation to determine whether overhead costs should be charged to jobs in proportion to consumption of overhead resources by jobs. She gathers the following information:
<p>A table gives information for DLN architectural firm</p>

The table depicts cost driver, overhead costs in 2020, and quantity of cost drivers used by each of three projects, Chandler, Henry, and Manley for three departments, design, engineering, and construction, as well as total overhead costs. The details of the table are as follows:

  1. Design department
    • Cost driver: Design department hours
    • Overhead costs in 2020: 3,000,000 dollars
    • Quantity of cost drivers used by Chandler: 2,000
    • Quantity of cost drivers used by Henry: 10,000
    • Quantity of cost drivers used by Manley: 8,000
  1. Engineering department
    • Cost driver: Number of engineering hours
    • Overhead costs in 2020: 1,000,000 dollars
    • Quantity of cost drivers used by Chandler: 4,000
    • Quantity of cost drivers used by Henry: 4,000
    • Quantity of cost drivers used by Manley: 4,500
  1. Construction department
    • Cost driver: Labor-hours
    • Overhead costs in 2020: 4,100,000 dollars
    • Quantity of cost drivers used by Chandler: 29,000
    • Quantity of cost drivers used by Henry: 27,000
    • Quantity of cost drivers used by Manley: 26,000
  1. Total Overhead Costs in 2020: 8,100,000 dollars
    1. Required
    2. 1. Compute the overhead allocated to each project in 2020 using the simple costing system that allocates overhead costs to jobs based on the number of jobs.
    3. 2. Compute the overhead allocated to each project in 2020 using department overhead cost rates.
    4. 3. Do you think Chandler had a valid reason for dissatisfaction with the cost and price of its building? How does the allocation based on department rates change costs for each project?\
  1. 5-25. ACTIVITY-BASED COSTING, SERVICE COMPANY. Aniline Corporation owns a small printing press that prints leaflets, brochures, and advertising materials. Aniline classifies its various printing jobs as standard jobs or special jobs. Aniline’s simple job-costing system has two direct-cost categories (direct materials and direct labor) and a single indirect-cost pool. Aniline operates at capacity and allocates all indirect costs using printing machine-hours as the allocation base.
  2. Aniline is concerned about the accuracy of the costs assigned to standard and special jobs and therefore is planning to implement an activity-based costing system. Aniline’s ABC system would have the same direct-cost categories as its simple costing system. However, instead of a single indirect-cost pool, there would now be six categories for assigning indirect costs: design, purchasing, setup, printing machine operations, marketing, and administration. To see how activity-based costing would affect the costs of standard and special jobs, Aniline collects the following information for the fiscal year 2020 that just ended.
A screenshot of a spreadsheet shows the information related to costs and hours of Aniline’s classified as standard and simple jobs.

The details of the information of Aniline are as follows:

  1. Standard job:

    1. Number of printing jobs: 2,400

    2. Price per job: dollar 1,700

    3. Cost of supplies per job: dollar 210

    4. Direct labor costs per job: dollar 170

    5. Printing machine-hours per job: 10

    6. Printing machine-hours per job: 6

    7. Total number of purchase orders: 330

    8. Design costs: dollar 7,000

    9. Marketing costs as a percentage of revenues: 4 percent

  2. Special job

    1. Number of printing jobs: 1,200

    2. Price per job: dollar 2,000

    3. Cost of supplies per job: dollar 310

    4. Direct labor costs per job: dollar 220

    5. Printing machine-hours per job: 10

    6. Printing machine-hours per job: 9

    7. Total number of purchase orders: 430

    8. Design costs: dollar 35,000

    9. Marketing costs as a percentage of revenues: 4 percent

  3. Total

    1. Cost of printing machine operations: dollar 1,008,000

    2. Setup costs: dollar 781,200

    3. Purchase order costs: dollar 27,360

    4. Design costs: dollar 42,000

    5. Marketing costs as a percentage of revenues: dollar 259,200

    6. Administration costs: dollar 309,120

  4. Cause-and-effect relationship between allocation base and activity cost

    1. Cost of printing machine operations: Indirect costs of operating printing machines increase with printing machine-hours

    2. Setup costs: Indirect setup costs increase with setup-hours

    3. Purchase order costs: Indirect purchase order costs increase with number of purchase orders

    4. Design costs: Design costs are allocated to standard and special jobs based on a special study of the design department

    5. Administration costs: Demand for administrative resources increases with direct labor costs

    1. Required
    2. 1. Calculate the cost of a standard job and a special job under the simple costing system.
    3. 2. Calculate the cost of a standard job and a special job under the activity-based costing system.
    4. 3. Compare the costs of a standard job and a special job in requirements 1 and 2. Why do the simple and activity-based costing systems differ in the cost of a standard job and a special job?
    5. 4. How might Aniline use the new cost information from its activity-based costing system to better manage its business?
  1. 5-26. ACTIVITY-BASED COSTING, MANUFACTURING. Decorative Doors, Inc., produces two types of doors, interior and exterior. The company’s simple costing system has two direct-cost categories (materials and labor) and one indirect-cost pool. The simple costing system allocates indirect costs on the basis of machine-hours. Recently, the owners of Decorative Doors have been concerned about a decline in the market share for their interior doors, usually their biggest seller. Information related to Decorative Doors production for the most recent year follows:
<p>A table gives production information for Decorative Doors</p>

The table depicts units sold, selling price, direct material cost per unit, direct manufacturing labor cost per hour, direct manufacturing labor-hours per unit, production runs, material moves, machine setups, machine-hours, and number of inspections for interior and exterior doors. The details of the table are as follows:

1. Units sold

2. Selling price

3. Direct material cost per unit

4. Direct manufacturing labor cost per hour

5. Direct manufacturing labor-hours per unit

6. Production runs

7. Material moves

8. Machine setups

9. Machine-hours

10. Number of inspections

  1. The owners have heard of other companies in the industry that are now using an activity-based costing system and are curious how an ABC system would affect their product costing decisions. After analyzing the indirect-cost pool for Decorative Doors, the owners identify six activities as generating indirect costs: production scheduling, material handling, machine setup, assembly, inspection, and marketing. Decorative Doors collected the following data related to the indirect-cost activities:
<p>A table gives information about indirect-cost activities for Decorative Doors</p>

The table depicts activity cost and activity-cost driver for five different activities: production scheduling, material handling, machine setup, assembly, and inspection. The details of the table are as follows:

  1. Production scheduling
    • Activity cost: 95,000 dollars
    • Activity-cost driver: Production runs
  1. Material handling
    • Activity cost: 45,000 dollars
    • Activity-cost driver: Material moves
  1. Machine setup
    • Activity cost: 25,000 dollars
    • Activity-cost driver: Machine setups
  1. Assembly
    • Activity cost: 60,000 dollars
    • Activity-cost driver: Machine-hours
  1. Inspection
    • Activity cost: 8,000 dollars
    • Activity-cost driver: Number of inspections
  1. Marketing costs were determined to be 3% of the sales revenue for each type of door.
    1. Required
    2. 1. Calculate the cost of an interior door and an exterior door under the existing simple costing system.
    3. 2. Calculate the cost of an interior door and an exterior door under an activity-based costing system.
    4. 3. Compare the costs of the doors in requirements 1 and 2. Why do the simple and activity-based costing systems differ in the cost of an interior door and an exterior door?
    5. 4. How might Decorative Doors, Inc., use the new cost information from its activity-based costing system to address the declining market share for interior doors?
  1. 5-27. ABC, RETAIL PRODUCT-LINE PROFITABILITY. Fitzgerald Supermarkets operates at capacity and decides to apply ABC analysis to three product lines: baked goods, milk and fruit juice, and frozen foods. It identifies four activities and their activity-cost rates as follows:
Ordering$95 per purchase order
Delivery and receipt of merchandise$76 per delivery
Shelf stocking$19 per hour
Customer support and assistance$0.15 per item sold
  1. The revenues, cost of goods sold, store support costs, activities that account for the store support costs, and activity-area usage of the three product lines are as follows:
<p>A table gives financial data and activity-area usage for three product lines for Fitzgerald Supermarkets</p>

The table depicts revenues, cost of goods sold, store support, and activity-area usage including ordering, delivery, shelf stocking, and customer support for baked goods, milk and fruit juice, and frozen foods. The details of the table are as follows:

  1. Revenues
    • Baked goods: 60,000 dollars
    • Milk and fruit juice: 66,500 dollars
    • Frozen foods: 50,500 dollars
  1. Cost of goods sold
    • Baked goods: 41,000 dollars
    • Milk and fruit juice: 51,000 dollars
    • Frozen foods: 32,000 dollars
  1. Store support
    • Baked goods: 12,300 dollars
    • Milk and fruit juice: 15,300 dollars
    • Frozen foods: 9,600 dollars
  1. Ordering (cost-allocation base: purchase orders)
    • Baked goods: 44
    • Milk and fruit juice: 24
    • Frozen foods: 14
  1. Delivery (cost-allocation base: deliveries)
    • Baked goods: 120
    • Milk and fruit juice: 60
    • Frozen foods: 36
  1. Shelf stocking (cost-allocation base: hours)
    • Baked goods: 170
    • Milk and fruit juice: 150
    • Frozen foods: 20
  1. Customer support (cost-allocation base: items sold)
    • Baked goods: 15,400
    • Milk and fruit juice: 20,200
    • Frozen foods: 7,960
  1. Under its simple costing system, Fitzgerald Supermarkets allocated support costs to products at the rate of 30% of cost of goods sold.
    1. Required
    2. 1. Use the simple costing system to prepare a product-line profitability report for Fitzgerald Supermarkets.
    3. 2. Use the ABC system to prepare a product-line profitability report for Fitzgerald Supermarkets.
    4. 3. What new insights does the ABC system in requirement 2 provide to Fitzgerald Supermarkets managers?
  1. 5-28. ABC, WHOLESALE, CUSTOMER PROFITABILITY. Ruiz Wholesalers operates at capacity and sells furniture items to four department-store chains (customers). Mr. Ruiz commented, “We apply ABC to determine product-line profitability. The same ideas apply to customer profitability, and we should find out our customer profitability as well.” Ruiz Wholesalers sends catalogs to corporate purchasing departments on a monthly basis. The customers are entitled to return unsold merchandise within a 6-month period from the purchase date and receive a full purchase price refund. The following data were collected from last year’s operations:
<p>A table gives data from last year’s operations for Ruiz Wholesalers</p>

The table depicts gross sales, sales returns: number of items, sales returns: amount, number of orders: regular, and number of orders: rush for Chains 1 through 4. The details of the table are as follows:

  1. Gross sales
    • Chain 1: 45,000 dollars
    • Chain 2: 35,000 dollars
    • Chain 3: 120,000 dollars
    • Chain 4: 80,000 dollars
  1. Sales returns: number of items
    • Chain 1: 107
    • Chain 2: 41
    • Chain 3: 55
    • Chain 4: 51
  1. Sales returns: amount
    • Chain 1: 9,000 dollars
    • Chain 2: 5,500 dollars
    • Chain 3: 8,400 dollars
    • Chain 4: 7,000 dollars
  1. Number of orders: regular
    • Chain 1: 35
    • Chain 2: 155
    • Chain 3: 60
    • Chain 4: 80
  1. Number of orders: rush
    • Chain 1: 9
    • Chain 2: 52
    • Chain 3: 15
    • Chain 4: 35
  1. Ruiz has calculated the following activity rates:
ActivityCost-Driver Rate
Regular order processing$22 per regular order
Rush order processing$110 per rush order
Returned items processing$10 per item
Catalogs and customer support$1,400 per customer
  1. Customers pay the transportation costs. The cost of goods sold averages 80% of net sales.
  2. Required
  3. Determine the contribution to profit from each customer last year. Comment on your solution.
  1. 5-29. ACTIVITY-BASED COSTING. The job-costing system at Shirley’s Custom Framing has five indirect-cost pools (purchasing, material handling, machine maintenance, product inspection, and packaging). The company is in the process of bidding on two jobs: Job 215, an order of 16 intricate personalized frames, and Job 325, an order of six standard personalized frames. The controller wants you to compare overhead allocated under the current simple job-costing system and a newly designed activity-based job-costing system. Total budgeted costs in each indirect-cost pool and the budgeted quantity of each activity driver are as follows.
<p>A table gives budget information for Shirley’s Custom Framing</p>

The table depicts budgeted overhead, activity driver, and budgeted quantity of activity driver for five indirect-cost pools: purchasing, material handling, machine maintenance, product inspection, and packaging, plus total budgeted overhead. The details of the table are as follows:

  1. Purchasing
    • Budgeted overhead: 25,600 dollars
    • Activity driver: Purchase orders processed
    • Budgeted quantity of activity driver: 1,600
  1. Material handling
    • Budgeted overhead: 32,900 dollars
    • Activity driver: Material moves
    • Budgeted quantity of activity driver: 4,700
  1. Machine maintenance
    • Budgeted overhead: 150,000 dollars
    • Activity driver: Machine-hours
    • Budgeted quantity of activity driver: 10,000
  1. Product inspection
    • Budgeted overhead: 11,200 dollars
    • Activity driver: Inspections
    • Budgeted quantity of activity driver: 1,600
  1. Packaging
    • Budgeted overhead: 12,400 dollars
    • Activity driver: Units produced
    • Budgeted quantity of activity driver: 3,100
  1. Total Budgeted Overhead: 232,100 dollars
  1. Information related to Job 215 and Job 325 follows. Job 215 incurs more batch-level costs because it uses more types of materials that need to be purchased, moved, and inspected relative to Job 325.
Job 215 Job 325
Number of purchase orders265
Number of material moves143
Machine-hours2080
Number of inspections125
Units produced166
    1. Required
    2. 1. Compute the total overhead allocated to each job under a simple costing system, where overhead is allocated based on machine-hours.
    3. 2. Compute the total overhead allocated to each job under an activity-based costing system using the appropriate activity drivers.
    4. 3. Explain why Shirley’s Custom Framing might favor the ABC job-costing system over the simple job-costing system, especially in its bidding process.
  1. 5-30. ABC, PRODUCT COSTING AT BANKS, CROSS-SUBSIDIZATION. United Savings Bank (USB) is examining the profitability of its Premier Account, a combined savings and checking account. Depositors receive a 2% annual interest rate on their average deposit. USB earns an interest rate spread of 3% (the difference between the rate at which it lends money and the rate it pays depositors) by lending money for home-loan purposes at 5%. Thus, USB would gain $60 on the interest spread if a depositor had an average Premier Account balance of $2,000 in 2020 ($2,000×3%=$60).
  2. The Premier Account allows depositors unlimited use of services such as deposits, withdrawals, checking accounts, and foreign currency drafts. Depositors with Premier Account balances of $1,000 or more receive unlimited free use of services. Depositors with minimum balances of less than $1,000 pay a $22-a-month service fee for their Premier Account.
  1. USB recently conducted an activity-based costing study of its services. It assessed the following costs for six individual services. The use of these services in 2020 by three customers is as follows:
<p>A table gives information from three customers of United Savings Bank</p>

The table depicts use of six individual banking services, activity-based cost per transaction, and account balance for three customers. The details of the table are as follows:

  1. Deposit/withdrawal with teller
    • Activity-based cost per &ldquo;transaction&rdquo;: 2.50 dollars
    • Account usage, Lindell: 44
    • Account usage, Welker: 49
    • Account usage, Colston: 4
  1. Deposit/withdrawal with automatic teller machine (ATM)
    • Activity-based cost per &ldquo;transaction&rdquo;: 0.80 dollars
    • Account usage, Lindell: 12
    • Account usage, Welker: 24
    • Account usage, Colston: 13
  1. Deposit/withdrawal on prearranged monthly basis
    • Activity-based cost per &ldquo;transaction&rdquo;: 0.50 dollars
    • Account usage, Lindell: 0
    • Account usage, Welker: 14
    • Account usage, Colston: 58
  1. Bank checks written
    • Activity-based cost per &ldquo;transaction&rdquo;: 8.20 dollars
    • Account usage, Lindell: 8
    • Account usage, Welker: 2
    • Account usage, Colston: 3
  1. Foreign currency drafts
    • Activity-based cost per &ldquo;transaction&rdquo;: 12.10 dollars
    • Account usage, Lindell: 6
    • Account usage, Welker: 1
    • Account usage, Colston: 5
  1. Inquiries about account balance
    • Activity-based cost per &ldquo;transaction&rdquo;: 1.70 dollars
    • Account usage, Lindell: 7
    • Account usage, Welker: 16
    • Account usage, Colston: 6
  1. Average Premier Account balance for 2020
    • Account usage, Lindell: 1,200 dollars
    • Account usage, Welker: 700 dollars
    • Account usage, Colston: 24,900 dollars
  1. Assume Lindell and Colston always maintain a balance above $1,000, whereas Welker always has a balance below $1,000.
    1. Required
    2. 1. Compute the 2020 profitability of the Lindell, Welker, and Colston Premier Accounts at USB.
    3. 2. Why might USB worry about the profitability of individual customers if the Premier Account product offering is profitable as a whole?
    4. 3. What changes would you recommend for USB’s Premier Account?

Problems

  1. 5-31. JOB COSTING WITH SINGLE DIRECT-COST CATEGORY, SINGLE INDIRECT-COST POOL, LAW FIRM. Timlin Associates is a recently formed law partnership. Rachel Hamilton, the managing partner of Timlin Associates, has just finished a tense phone call with Phil Lopez, president of Lopez Enterprises. Phil strongly complained about the price Timlin charged for some legal work done for his company.
  2. Hamilton also received a phone call from Timlin’s only other client, Clinical Inc., which was very pleased with both the quality of the work and the price charged on its most recent job.
  3. Timlin Associates operates at capacity and uses a cost-based approach to pricing (billing) each job. Currently it uses a simple costing system with a single direct-cost category (professional labor-hours) and a single indirect-cost pool (general support). Indirect costs are allocated to cases on the basis of professional labor-hours per case. The job files show the following:
Lopez EnterprisesClinical Inc.
Professional labor2,500 hours2,500 hours
  1. Professional labor costs at Timlin Associates are $250 an hour. Indirect costs are allocated to cases at $125 an hour. Total indirect costs in the most recent period were $625,000.
    1. Required
    2. 1. Why is it important for Timlin Associates to understand the costs associated with individual jobs?
    3. 2. Compute the costs of the Lopez Enterprises and Clinical Inc. jobs using Timlin’s simple costing system.
  1. 5-32. JOB COSTING WITH MULTIPLE DIRECT-COST CATEGORIES, SINGLE INDIRECT-COST POOL, LAW FIRM (CONTINUATION OF 5-31). Rachel Hamilton, the managing partner of Timlin Associates, asks her assistant to collect details on those costs included in the $625,000 indirect-cost pool that can be traced to each individual job. After analysis, Timlin is able to reclassify $450,000 of the $625,000 as direct costs:
<p>A table gives job costing information for Timlin Associates</p>

The table depicts direct costs, including research support labor, computer time, travel and allowances, telephones/faxes, and photocopying for Lopez Enterprises and Clinical Inc, as well as total costs. The details of the table are as follows:

  1. Research support labor
    • Lopez Enterprises: 41,000 dollars
    • Clinical Inc.: 232,500 dollars
  1. Computer time
    • Lopez Enterprises: 4,000 dollars
    • Clinical Inc.: 31,000 dollars
  1. Travel and allowances
    • Lopez Enterprises: 14,000 dollars
    • Clinical Inc.: 81,000 dollars
  1. Telephones/faxes
    • Lopez Enterprises: 4,500 dollars
    • Clinical Inc.: 21,000 dollars
  1. Photocopying
    • Lopez Enterprises: 6,500 dollars
    • Clinical Inc.: 14,500 dollars
  1. Total
    • Lopez Enterprises: 70,000 dollars
    • Clinical Inc.: 380,000 dollars
  1. Hamilton decides to calculate the costs of each job as if Timlin had used six direct-cost pools and a single indirect-cost pool. The single indirect-cost pool would have $175,000 of costs and would be allocated to each case using the professional labor-hours base.
    1. Required
    2. 1. Calculate the revised indirect-cost allocation rate per professional labor-hour for Timlin Associates when total indirect costs are $175,000.
    3. 2. Compute the costs of the Lopez Enterprises and Clinical Inc. jobs if Timlin Associates had used its refined costing system with multiple direct-cost categories and one indirect-cost pool.
    4. 3. Compare the costs of Lopez Enterprises and Clinical Inc. jobs in requirement 2 with those calculated using the simple costing system. Comment on the results.
  1. 5-33. JOB COSTING WITH MULTIPLE DIRECT-COST CATEGORIES, MULTIPLE INDIRECT-COST POOLS, LAW FIRM (CONTINUATION OF 5-31 AND 5-32). Timlin has two classifications of professional staff: partners and associates. Hamilton asks her assistant to examine the relative use of partners and associates on the recent Lopez Enterprises and Clinical Inc. jobs. The Lopez Enterprises job used 1,400 partner-hours and 1,100 associate-hours. The Clinical Inc. job used 1,100 partner-hours and 1,400 associate-hours. Therefore, totals of the two jobs together were 2,500 partner-hours and 2,500 associate-hours. Hamilton decides to examine how using separate direct-cost rates for partners and associates and using separate indirect-cost pools for partners and associates would have affected the costs of the Lopez Enterprises and Clinical Inc. jobs. Indirect costs in each indirect-cost pool would be allocated on the basis of total hours of that category of professional labor. From the total indirect-cost pool of $175,000, $100,000 is attributable to the activities of partners and $75,000 is attributable to the activities of associates.
  2. The rates per category of professional labor are as follows:
<p>A table gives direct and indirect cost per hour for two categories of labor</p>

The table depicts direct cost per hour and indirect cost per hour for partner and associate. The details of the table are as follows:

  1. Partner
    • Direct cost per hour: 200 dollars
    • Indirect cost per hour: 100,000 dollars divided by 2,500 hours equals 40 dollars
  1. Associate
    • Direct cost per hour: 150 dollars
    • Indirect cost per hour: 75,000 dollars divided by 2,500 hours equals 30 dollars
    1. Required
    2. 1. Compute the costs of the Lopez Enterprises and Clinical Inc. jobs using Timlin’s further refined system, with multiple direct-cost categories and multiple indirect-cost pools.
    3. 2. For what decisions might Timlin Associates find it more useful to use this job-costing approach rather than the approaches of a simple costing system or a refined costing system with multiple direct-cost categories and one indirect-cost pool?
  1. 5-34. FIRST-STAGE ALLOCATION, TIME-DRIVEN ACTIVITY-BASED COSTING, MANUFACTURING SECTOR. Marshall Devices manufactures metal products and uses activity-based costing to allocate overhead costs to customer orders for pricing purposes. Many customer orders are won through competitive bidding based on costs. Direct material and direct manufacturing labor costs are traced directly to each order. Marshall’s direct manufacturing labor rate is $20 per hour. The company reports the following budgeted yearly overhead costs:
<p>A table gives budgeted yearly overhead costs for Marshall Devices</p>
  1. Wages and salaries: 480,000 dollars
  2. Depreciation: 60,000 dollars

  3. Rent: 120,000 dollars

  4. Other overhead: 240,000 dollars

  5. Total overhead costs, 900,000 dollars

  1. Marshall has established four activity-cost pools and the following budgeted activity for each cost pool:
Activity-Cost PoolActivity MeasureBudgeted Total Activity for the Year
Direct manufacturing labor supportNumber of direct manufacturing labor-hours30,000 direct manufacturing labor-hours
Order processingNumber of customer orders500 orders
Design supportNumber of custom design-hours2,490 custom design-hours
OtherFacility-sustaining costs allocated to orders based on direct manufacturing labor-hours30,000 direct manufacturing labor-hours
  1. Some customer orders require more complex designs, while others need simple designs. Marshall estimates that it will do 120 complex designs during a year, which will each take 11.75 hours for a total of 1,410 design-hours. It estimates it will do 180 simple designs, which will each take 6 hours for a total of 1,080 design-hours.
  2. Paul Napoli, Marshall’s controller, has prepared the following estimates for distribution of the overhead costs across the four activity-cost pools:
Direct Manufacturing Labor SupportOrder ProcessingDesign SupportOtherTotal
Wages and salaries40%25%30%5%100%
Depreciation 25%10%15%50%100%
Rent30%25%10%35%100%
Other overhead20%30%35%15%100%
  1. Order 277100 consists of four different metal products. Three products require a complex design and one requires a simple design. Order 277100 requires $4,550 of direct materials and 80 direct manufacturing labor-hours.
    1. Required
    2. 1. Allocate the overhead costs to each activity-cost pool. Calculate the activity rate for each pool.
    3. 2. Determine the cost of Order 277100.
    4. 3. How does activity-based costing enhance Marshall’s ability to price its orders? Suppose Marshall used a simple costing system to allocate all overhead costs to orders on the basis of direct manufacturing labor-hours. How might this have affected Marshall’s pricing decision for Order 227100?
    5. 4. When designing its activity-based costing system, Marshall uses time-driven activity-based costing (TDABC) for its design department. What does this approach allow Marshall to do? How would the cost of Order 277100 have been different if Marshall had used the number of customer designs rather than the number of custom design-hours to allocate costs to different customer orders? Which cost driver do you prefer for design support? Why?
  1. 5-35. FIRST-STAGE ALLOCATION, TIME-DRIVEN ACTIVITY-BASED COSTING, SERVICE SECTOR. LawnCare USA provides lawn care and landscaping services to commercial clients. LawnCare USA uses activity-based costing to bid on jobs and to evaluate their profitability. LawnCare USA reports the following budgeted annual costs:
<p>A table gives budgeted annual costs for LawnCare USA.</p>

Wages and salaries: 360,000 dollars

Depreciation: 72,000 dollars

Supplies: 120,000 dollars

Other overhead: 288,000 dollars

Total overhead costs: 840,000 dollars

  1. John Gilroy, controller of LawnCare USA, has established four activity-cost pools and the following budgeted activity for each cost pool:
Activity-Cost PoolActivity MeasureTotal Activity for the Year
Estimating jobsNumber of job estimates250 estimates
Lawn careNumber of direct labor-hours10,000 direct labor-hours
Landscape designNumber of design hours 500 design hours
OtherFacility-sustaining costs that are not allocated to jobsNot applicable
  1. Gilroy estimates that LawnCare USA’s costs are distributed to the activity-cost pools as follows:
Estimating JobsLawn CareLandscape DesignOther Total
Wages and salaries5%70%15%10%100%
Depreciation10%65%10%15%100%
Supplies0%100% 0%0%100%
Other overhead 15%50%20%15% 100%
  1. Sunset Office Park, a new development in a nearby community, has contacted LawnCare USA to provide an estimate on landscape design and annual lawn maintenance. The job is estimated to require a single landscape design requiring 40 design hours in total and 250 direct labor-hours annually. LawnCare USA has a policy of pricing estimates at 150% of cost.
    1. Required
    2. 1. Allocate LawnCare USA’s costs to the activity-cost pools and determine the activity rate for each pool.
    3. 2. Estimate total cost for the Sunset Office Park job. How much would LawnCare USA bid to perform the job?
    4. 3. LawnCare USA does 30 landscape designs for its customers each year. Estimate the total cost for the Sunset Office park job if LawnCare USA allocated costs of the Landscape Design activity based on the number of landscape designs rather than the number of landscape design-hours. How much would LawnCare USA bid to perform the job? Which cost driver do you prefer for the Landscape Design activity? Why?
    5. 4. Sunset Office Park asks LawnCare USA to give an estimate for providing its services for a 2-year period. What are the advantages and disadvantages for LawnCare USA to provide a 2-year estimate?
  1. 5-36. DEPARTMENT AND ACTIVITY-COST RATES, SERVICE SECTOR. Raynham’s Radiology Center (RRC) performs X-rays, ultrasounds, computer tomography (CT) scans, and magnetic resonance imaging (MRI). RRC has developed a reputation as a top radiology center in the state. RRC has achieved this status because it constantly reexamines its processes and procedures. RRC has been using a single, facilitywide overhead allocation rate. The vice president of finance believes that RRC can make better process improvements if it uses more disaggregated cost information. She says, “We have state-of-the-art medical imaging technology. Can’t we have state-of-the-art accounting technology?”
<p>A table gives budget information for Raynham’s Radiology Center</p>

The table depicts technician labor, depreciation, materials, administration, maintenance, sanitation, and utilities costs for x-rays, ultrasound, CT scan, and MRI as well as totals. Number of procedures, minutes to clean after each procedure, and minutes for each procedure are included as well. The details of the table are as follows:

1. Technician labor

2. Depreciation

3. Materials

4. Administration: 20,000

5. Maintenance: 250,000

6. Sanitation: 252,500

7. Utilities: 151,100

8. Totals:

9. Number of procedures

10. Minutes to clean after each procedure

11. Minutes for each procedure

  1. RRC operates at capacity. The proposed allocation bases for overhead are:
AdministrationNumber of procedures
Maintenance (including parts)Capital cost of the equipment (use Depreciation)
SanitationTotal cleaning minutes
Utilities Total procedure minutes
    1. Required
    2. 1. Calculate the budgeted cost per service for X-rays, ultrasounds, CT scans, and MRI using direct technician labor costs as the allocation basis.
    3. 2. Calculate the budgeted cost per service of X-rays, ultrasounds, CT scans, and MRI if RRC allocated overhead costs using activity-based costing.
    4. 3. Explain how the disaggregation of information could be helpful to RRC’s intention to continuously improve its services.
  1. 5-37. ACTIVITY-BASED COSTING, MERCHANDISING. Pharmassist, Inc., a distributor of special pharmaceutical products, operates at capacity and has three main market segments:
    1. a. General supermarket chains
    2. b. Drugstore chains
    3. c. Mom-and-pop single-store pharmacies
  2. Rick Flair, the new controller of Pharmassist, reported the following data for 2020.
A screenshot of a spreadsheet shows the costs incurred to Pharmassist, for its three main market segments, general supermarket chains, drugstore chains, and mom-and-pop single stores, and its total operating income for the year 2020.

The details of the spreadsheet are as follows:

  1. General supermarkets chain:

    1. Revenues: dollar 3,704,000

    2. Cost of goods sold: dollar 3,612,000

    3. Gross margin: dollar 92,000

  2. Drugstore chains:

    1. Revenues: dollar 3,145,000

    2. Cost of goods sold: dollar 2,990,000

    3. Gross margin: dollar 155,000

  3. Mom-and-pop single stores:

    1. Revenues: dollar 1,988,000

    2. Cost of goods sold: dollar 1,804,000

    3. Gross margin: dollar 184,000

  4. Total for Pharmassist:

    1. Revenues: dollar 8,837,000

    2. Cost of goods sold: dollar 8,406,000

    3. Gross margin: dollar 431,000

    4. Other operating costs: dollar 313,075

    5. Operating income: dollar 117,925

  1. For many years, Pharmassist has used gross margin percentage to evaluate the relative profitability of its market segments. But Flair recently attended a seminar on activity-based costing and is considering using it at Pharmassist to analyze and allocate “other operating costs.” He meets with all the key managers and several of his operations and sales staff, and they agree that there are five key activities that drive other operating costs at Pharmassist:
Activity AreaCost Driver
Order processingNumber of customer purchase orders
Line-item processingNumber of line items ordered by customers
Delivering to storesNumber of store deliveries
Cartons shipped to storeNumber of cartons shipped
Stocking of customer store shelvesHours of shelf stocking
  1. Each customer order consists of one or more line items. A line item represents a single product (such as Extra-Strength Tylenol Tablets). Each product line item is delivered in one or more separate cartons. Each store delivery entails the delivery of one or more cartons of products to a customer. Pharmassist’s staff stacks cartons directly onto display shelves in customers’ stores. Currently, there is no additional charge to the customer for shelf stocking and not all customers use Pharmassist for this activity. The level of each activity in the three market segments and the total cost incurred for each activity in 2020 is as follows:
A table shows the activity based cost data for its three main market segments, general supermarket chains, drugstore chains, and mom-and-pop single stores, and the total cost of activity in 2020.

The details of the spreadsheet are as follows:

  1. Number of orders processed:

    1. General supermarkets chain: 200

    2. Drugstore chains: 500

    3. mom-and-pop single stores: 1,800

    4. Total cost of activity in 2020: dollar 87,500

  2. Number of line-items ordered

    1. General supermarkets chain: 2,100

    2. Drugstore chains: 4,800

    3. Mom-and-pop single stores: 15,600

    4. Total cost of activity in 2020: dollar 67,500

  3. Number of store deliveries made:

    1. General supermarkets chain: 110

    2. Drugstore chains: 280

    3. Mom-and-pop single stores: 990

    4. Total cost of activity in 2020: dollar 67,620

  4. Number of cartons shipped to stores:

    1. General supermarkets chain: 34,000

    2. Drugstore chains: 23,000

    3. Mom-and-pop single stores: 23,000

    4. Total cost of activity in 2020: dollar 80,000

  5. Number of shelf stocking hours

    1. General supermarkets chain: 310

    2. Drugstore chains: 210

    3. Mom-and-pop single stores: 95

    4. Total cost of activity: dollar 10,455

    5. Total cost of activity in 2020: dollar 313,075.

    1. Required
    2. 1. Compute the 2020 gross-margin percentage for each of Pharmassist’s three market segments.
    3. 2. Compute the cost driver rates for each of the five activity areas.
    4. 3. Use the activity-based costing information to allocate the $313,075 of “other operating costs” to each of the market segments. Compute the operating income for each market segment.
    5. 4. Comment on the results. What new insights are available with the activity-based costing information?
  1. 5-38. CHOOSING COST DRIVERS, ACTIVITY-BASED COSTING, ACTIVITY-BASED MANAGEMENT. Pastel Bags (PB) is a designer of high-quality backpacks and purses. Each design is made in small batches. Each spring, PB comes out with new designs for the backpack and the purse. The company uses these designs for a year and then moves on to the next trend. The bags are all made on the same fabrication equipment that is expected to operate at capacity. The equipment must be switched over to a new design and set up to prepare for the production of each new batch of products. When completed, each batch of products is immediately shipped to a wholesaler. Shipping costs vary with the number of shipments. Budgeted information for the year is as follows:
<p>A table gives budgeted information for Pastel Bags</p>

Direct materials, purses: 319,155 dollars

Direct materials, backpacks: 454,995 dollars

Direct manufacturing labor, purses: 99,000 dollars

Direct manufacturing labor, backpacks: 113,000 dollars

Setup: 64,000 dollars

Shipping: 73,000 dollars

Design: 169,000 dollars

Plant utilities and administration: 221,000 dollars

Total: 1,513,160 dollars

  1. Other budget information follows:
BackpacksPursesTotal
Number of bags6,1753,075 9,250
Hours of production1,665 2,5854,250
Number of batches   120      80   200
Number of designs      2       2       4
    1. Required
    2. 1. Identify the cost hierarchy level for each cost category.
    3. 2. Identify the most appropriate cost driver for each cost category. Explain briefly your choice of cost driver.
    4. 3. Calculate the budgeted cost per unit of cost driver for each cost category.
    5. 4. Calculate the budgeted total costs and cost per unit for each product line.
    6. 5. Explain how you could use the information in requirement 4 to reduce costs.
  1. 5-39. ABC, HEALTH CARE. Phoenix Medical Associates operates a walk-in medical clinic in Tempe, Arizona. The clinic includes two different departments, Urgent Care, which serves patients with minor to moderate acute illnesses and injuries, and Living Well, which administers vaccines, school and work physicals, and conducts workshops on healthy living topics. The center’s budget for 2020 follows.
<p>A table gives 2020 budget for a clinic run by Phoenix Medical Associates</p>

Professional salaries include the following:

4 physicians times 200,000 dollars: 800,000 dollars

2 x-ray technicians times 50,000 dollars: 100,000 dollars

12 nurses times 60,000 dollars: 720,000 dollars

1 nutritionist times 50,000 dollars: 50,000 dollars

For a total of 1,670,000 dollars

Medical supplies: 600,000 dollars

Rent and clinic maintenance: 180,000 dollars

Laboratory services: 216,000 dollars

General overhead, including administrative staff: 540,000 dollars

Total: 3,206,000 dollars

  1. Anita Alvarez, the director of the clinic, is keen on determining the cost of each department. Alvarez compiles the following data describing employee allocations to individual departments:
Urgent CareLiving Well Total
Physicians31  4
X-ray technicians2  2
Nurses7512
Nutritionist1  1
  1. Alvarez has recently become aware of activity-based costing as a method to refine costing systems. She asks her accountant, David Burke, how she should apply this technique. Burke obtains the following budgeted information for 2020:
Urgent Care Living WellTotal
Square feet of clinic space  6,00010,00016,000
Patient visits17,50022,50040,000
Number of laboratory tests15,000  3,00018,000
    1. Required
    2. 1. 
      1. a. Selecting cost-allocation bases that you believe are the most appropriate for allocating indirect costs to departments, calculate the budgeted indirect cost rates for medical supplies, rent and clinic maintenance, laboratory services, and general overhead.
      2. b. Using an activity-based costing approach to cost analysis, calculate the budgeted cost of each department and the budgeted cost per patient visit of each department.
      3. c. What benefits can Phoenix Medical Associates obtain by implementing the ABC system?
    3. 2. What factors, other than cost, do you think Phoenix Medical Associates should consider in allocating resources to its departments?
  1. 5-40. UNUSED CAPACITY, ACTIVITY-BASED COSTING, ACTIVITY-BASED MANAGEMENT. Zarson’s Netballs is a manufacturer of high-quality basketballs and volleyballs. Setup costs are driven by the number of setups. Equipment and maintenance costs increase with the number of machine-hours, and lease rent is paid per square foot. Capacity of the facility is 14,000 square feet, and Zarson is using only 80% of this capacity. Zarson records the cost of unused capacity as a separate line item and not as a product cost. The following is the budgeted information for Zarson:
<p>A table gives budget information for Zarson</p>

Zarson&rsquo;s Netballs Budgeted Costs and Activities for the Year Ended December 31, 2020 are as follows:

  1. Direct materials, basketballs: 168,100 dollars
  2. Direct materials, volleyballs: 303, 280 dollars
  3. Direct manufacturing labor, basketballs: 111,800 dollars
  4. Direct manufacturing labor, volleyballs: 100,820 dollars
  5. Setup: 157,500 dollars
  6. Equipment and maintenance costs: 115,200 dollars
  7. Lease rent: 210,000 dollars
  8. Total: 1,166,700 dollars
  1. Other budget information follows:
BasketballsVolleyballs
Number of balls58,00085,000
Machine-hours13,50010,500
Number of setups450300
Square footage of production space used 3,200 8,000
    1. Required
    2. 1. Calculate the budgeted cost per unit of cost driver for each indirect-cost pool.
    3. 2. What is the budgeted cost of unused capacity?
    4. 3. What is the budgeted total cost and the cost per unit of resources used to produce (a) basketballs and (b) volleyballs?2. What is the budgeted cost of unused capacity?
    5. 4. Why might excess capacity be beneficial for Zarson? What are some of the issues Zarson should consider before increasing production to use the space?
  1. 5-41. [UNUSED CAPACITY, ACTIVITY-BASED COSTING, ACTIVITY-BASED MANAGEMENT. Huntington Boards manufactures two models of surfboards, Basic and Competition, in a facility in Southern California. In fabrication, machine setup costs are driven by the number of setups, and machine maintenance and utility costs increase with the number of machine hours, and indirect labor costs increase with direct labor hours. Facility rent and machine depreciation are fixed, and are the basis of manufacturing capacity. Fixed costs are allocated equally to each unit produced, regardless of model. Currently, Huntington uses 80% of its manufacturing capacity. The cost of unused capacity is not assigned to products, but is expensed as a separate line item. For 2020, Huntington has budgeted the following:

Huntington Boards

Budgeted Costs for the

Year Ended December 31, 2020

Direct materials—Basic boards$260,000
Direct materials—Competition boards450,000
Direct manufacturing labor—Basic boards307,500
Direct manufacturing labor—Competition boards512,500
Machine setup costs90,000
Machine maintenance and utility costs251,100
Indirect labor costs330,000
Facility rent254,000
Machine depreciation63,500
  1. Other information:
BasicCompetition
Units produced  5,200  7,500
Machine hours31,20052,500
Number of setups     400     800
Direct labor-hours15,00025,000
    1. Required
    2. 1. Calculate the cost-allocation rate for each of the activity-cost pools for variable and fixed overhead costs.
    3. 2. Calculate the cost of unused capacity for the year.
    4. 3. Calculate the total cost for each model, and the cost per unit for each model.
    5. 4. Huntington has the opportunity to sublease the unused factory space to a startup company that will be manufacturing surf apparel. None of Huntington’s machinery will be used. Is there a minimum annual rent that Huntington should charge? Are there any other considerations that Huntington’s management should make prior to offering the space?
  1. 5-42. ABC, IMPLEMENTATION, ETHICS. (CMA, adapted) Plum Electronics, a division of Berry Corporation, manufactures two large-screen television models: the Mammoth, which has been produced since 2016 and sells for $990, and the Maximum, a newer model introduced in early 2018 that sells for $1,254. Based on the following income statement for the year ended November 30, 2020, senior management at Berry have decided to concentrate Plum’s marketing resources on the Maximum model and to begin to phase out the Mammoth model because Maximum generates much higher operating income per unit.
<p>A table gives an income statement for Plum Electronics</p>

Plum Electronics Income Statement for the Fiscal Year Ended November 30, 2020 is as follows:

  1. Revenues
    • Mammoth: 21,780,000 dollars
    • Maximum: 5,016,000 dollars
    • Total: 26,796,000 dollars
  1. Cost of goods sold
    • Mammoth: 13,794,000 dollars
    • Maximum: 3,511,200 dollars
    • Total: 17,305,200 dollars
  1. Gross margin
    • Mammoth: 7,986,000 dollars
    • Maximum: 1,504,800 dollars
    • Total: 9,490,800 dollars
  1. Selling and administrative expense
    • Mammoth: 6,413,000 dollars
    • Maximum: 1,075,800 dollars
    • Total: 7,488,800 dollars
  1. Operating income
    • Mammoth: 1,573,000 dollars
    • Maximum: 429,000 dollars
    • Total: 2,002,000 dollars
  1. Units produced and sold
    • Mammoth: 22,000 dollars
    • Maximum: 4,000 dollars
  1. Operating income per unit sold
    • Mammoth: 71.50 dollars
    • Maximum: 107.25 dollars
  1. Details for cost of goods sold for Mammoth and Maximum are as follows:
<p>A table gives details for cost of goods sold for Mammoth and Maximum</p>

The table depicts direct materials, direct manufacturing labor, machine costs, total direct costs, manufacturing overhead costs, and total cost of goods sold for Mammoth (total and per unit) and Maximum (total and per unit). The details of the table are as follows:

  1. Direct materials
    • Mammoth, total: 5,033,600 dollars
    • Mammoth, per unit: 228.80 dollars
    • Maximum, total: 2,569,600 dollars
    • Mammoth, per unit: 642.40 dollars
  1. Direct manufacturing labor
  2. Note: Mammoth requires 1.5 hours per unit and Maximum requires 3.5 hours per unit. The direct manufacturing labor cost is 13.20 dollars per hour.

    • Mammoth, total: 435,600 dollars
    • Mammoth, per unit: 19.80 dollars
    • Maximum, total: 184,800 dollars
    • Mammoth, per unit: 46.20 dollars
  1. Machine costs
  2. Note: Machine costs include lease costs of the machine, repairs, and maintenance. Mammoth requires 8 machine-hours per unit and Maximum requires 4 machine-hours per unit. The machine-hour rate is 19.80 dollars per hour.

    • Mammoth, total: 3,484,800 dollars
    • Mammoth, per unit: 158.40 dollars
    • Maximum, total: 316,800 dollars
    • Mammoth, per unit: 79.20 dollars
  1. Total direct costs
    • Mammoth, total: 8,954,000 dollars
    • Mammoth, per unit: 407.00 dollars
    • Maximum, total: 3,071,200 dollars
    • Mammoth, per unit: 767.80 dollars
  1. Manufacturing overhead costs
  2. Note: Manufacturing overhead costs are allocated to products based on machine-hours at the rate of 27.50 dollars per hour.

    • Mammoth, total: 4,840,000 dollars
    • Mammoth, per unit: 220.00 dollars
    • Maximum, total: 440,000 dollars
    • Mammoth, per unit: 110.00 dollars
  1. Total cost of goods sold
    • Mammoth, total: 13,794,000 dollars
    • Mammoth, per unit: 627.00 dollars
    • Maximum, total: 3,511,200 dollars
    • Mammoth, per unit: 877.80 dollars
  1. Plum’s controller, Steve Jacobs, is advocating the use of activity-based costing and activity-based management and has gathered the following information about the company’s manufacturing overhead costs for the year ended November 30, 2020.
<p>A table gives details for manufacturing overhead costs for Mammoth and Maximum</p>

The table depicts cost-allocation base, total activity cost, units of the cost-allocation base for Mammoth, units of the cost-allocation base for Maximum, and total units of the cost allocation base for soldering, shipments, quality control, purchase orders, machine power, and machine setups, as well as total manufacturing overhead. The details of the table are as follows:

  1. Soldering
    • Cost-allocation base: Number of solder points
    • Total activity costs: 1,036,200 dollars
    • Units of the cost-allocation base, Mammoth: 1,185,000
    • Units of the cost-allocation base, Maximum: 385,000
    • Total units of the cost-allocation base: 1,570,000
  1. Shipments
    • Cost-allocation base: Number of shipments
    • Total activity costs: 946,000 dollars
    • Units of the cost-allocation base, Mammoth: 16,200
    • Units of the cost-allocation base, Maximum: 3,800
    • Total units of the cost-allocation base: 20,000
  1. Quality control
    • Cost-allocation base: Number of inspections
    • Total activity costs: 1,364,000 dollars
    • Units of the cost-allocation base, Mammoth: 56,200
    • Units of the cost-allocation base, Maximum: 21,300
    • Total units of the cost-allocation base: 77,500
  1. Purchase orders
    • Cost-allocation base: Number of orders
    • Total activity costs: 1,045,440 dollars
    • Units of the cost-allocation base, Mammoth: 80,100
    • Units of the cost-allocation base, Maximum: 109,980
    • Total units of the cost-allocation base: 190,080
  1. Machine power
    • Cost-allocation base: Machine-hours
    • Total activity costs: 63,360 dollars
    • Units of the cost-allocation base, Mammoth: 176 ,000
    • Units of the cost-allocation base, Maximum: 16,000
    • Total units of the cost-allocation base: 192,000
  1. Machine setups
    • Cost-allocation base: Number of setups
    • Total activity costs: 825,000 dollars
    • Units of the cost-allocation base, Mammoth: 16,000
    • Units of the cost-allocation base, Maximum: 14,000
    • Total units of the cost-allocation base: 30,000
  1. Total manufacturing overhead: 5,280,000 dollars
  1. After completing his analysis, Jacobs shows the results to Charles Clark, the Plum division president. Clark does not like what he sees. “If you show headquarters this analysis, they are going to ask us to phase out the Maximum line, which we have just introduced. This whole costing stuff has been a major problem for us. First Mammoth was not profitable and now Maximum isn’t.
  2. “Looking at the ABC analysis, I see two problems. First, we do many more activities than the ones you have listed. If you had included all activities, maybe your conclusions would be different. Second, you used number of setups and number of inspections as allocation bases. The numbers would be different had you used setup-hours and inspection-hours instead. I know that measurement problems precluded you from using these other cost-allocation bases, but I believe you ought to make some adjustments to our current numbers to compensate for these issues. I know you can do better. We can’t afford to phase out either product.”
  3. Jacobs knows that his numbers are fairly accurate. As a quick check, he calculates the profitability of Maximum and Mammoth using more and different allocation bases. The set of activities and activity rates he had used results in numbers that closely approximate those based on more detailed analyses. He is confident that headquarters, knowing that Maximum was introduced only recently, will not ask Plum to phase it out. He is also aware that a sizable portion of Clark’s bonus is based on division revenues. Phasing out either product would adversely affect his bonus. Still, he feels some pressure from Clark to do something.
    1. Required
    2. 1. Using activity-based costing, calculate the gross margin per unit of the Maximum and Mammoth models.
    3. 2. Explain briefly why these numbers differ from the gross margin per unit of the Maximum and Mammoth models calculated using Plum’s existing simple costing system.
    4. 3. Comment on Clark’s concerns about the accuracy and limitations of ABC.
    5. 4. How might Plum find the ABC information helpful in managing its business?
    6. 5. What should Steve Jacobs do in response to Clark’s comments?
  1. 5-43. ACTIVITY-BASED COSTING, ACTIVITY-BASED MANAGEMENT, MERCHANDISING. Pet World operates a pet supply superstore in Atlanta with three main product lines: food, toys, and accessories. Pet World allocates common selling, general, and administration (SG&A) costs to each product line using the cost of merchandise of each product line. Department manager salaries, while considered SG&A, are direct and are assigned directly to each product line. The company wants to optimize the pricing and cost management of each product line and is wondering whether its accounting system is providing it with the best information for making such decisions. Store manager Jason Wu gathers the following information regarding the three product lines:
<p>A table gives information about three product lines for Pet World</p>

Pet World Product Line Information for the Year Ended December 31, 2020 is as follows:

1. Revenues

2. Cost of merchandise

3. Salary of department manager

4. Number of purchase orders placed

5. Number of boxes received

6. Square feet of store space

  1. For 2020, Pet World budgets the following selling, general, and administration costs:
<p>A table gives 2020 budget information for selling, general, and administration costs for Pet World</p>

Pet World S G and A Costs for the Year Ended December 31, 2020 are as follows:

  1. Purchasing department expense: 186,000 dollars
  2. Receiving department expense: 160,500 dollars

  3. Selling expense: 310,000 dollars

  4. Rent: 432,000 dollars

  5. Store manager&rsquo;s salary: 120,000 dollars

  6. Utilities: 62,000 dollars

  7. Total: 1,270,500 dollars

    1. Required
    2. 1. Prepare an income statement for Pet World, by product line and in total, allocating common SG&A expenses using cost of merchandise. Calculate the profit per square foot of store space for each product line.
    3. 2. Identify an improved method for allocating costs to the three product lines. Explain. Use the method for allocating SG&A costs that you propose to prepare new product-line income statements. Calculate the profit per square foot of store space for each product line. Compare your results to the results in requirement 1.
    4. 3. What recommendations would you make to the store manager based on the results of the activity-based costing analysis?