2:11M1M2:13 14 15 16 17 18 19 | 10 | 11 | 12 | 13 | 14 | 15 | 16 17 18 19 CASE MATERIALS: THE CLASSIC PEN COMPANY CASE Case Abstract The case is designed to help you develop an understanding of how to build an activity-based- costing model and why activity-based-costing may be more appropriate in practice than functional unit-based overhead cost allocation methods. The case requirements ask you to apply overhead and calculate product costs and gross profit using traditional plant-wide overhead allocation methods, assess the accuracy of the costing methodology given the operational environment, apply activity-based-costing concepts to recalculate the product costs and gross profit, and then effectively communicate the results of your analysis, evaluation, and recommendations in the form of a professional written memo. Case Narrative Jane Dempsey, controller of the Classic Pen Company, was concerned about the recent financial trends in operating results. Classic Pen had been the low-cost producer of traditional blue pens and black pens. Profit margins were over 20% of sales. Several years earlier, Dennis Selmor, the sales manager, had seen opportunities to expand the business by extending the product line into new products that offered premium selling prices over the traditional blue and black pens. As a result, five years ago, red pens were introduced. Red pens required the same basic production technology but could be sold at a 3% premium. Last year, purple pens were introduced because of the 10% premium in selling price they could command Jane reviewed the financial results for the most recent year and was keenly disappointed. While the new red and purple pens seemed to be more profitable than the blue and black pens, the overall profits were down and none of the product lines were earning profits at the level that the blue and black pens had earned in the past. She is wondering if more specialty pens selling at A Windows ak Aktivanja a window 1211 17 18 19 1 !:21:31:4:15:1.6.1:7:18:19: 110, 11, 12, 13, 14, 15, 16 business by extending the product line into new products that offered premium selling prices over the traditional blue and black pens. As a result, five years ago, red pens were introduced. Red pens required the same basic production technology but could be sold at a 3% premium. Last year, purple pens were introduced because of the 10% premium in selling price they could command. Jane reviewed the financial results for the most recent year and was keenly disappointed. While the new red and purple pens seemed to be more profitable than the blue and black pens, the overall profits were down and none of the product lines were earning profits at the level that the blue and black pens had earned in the past. She is wondering if more specialty pens selling at higher margins should be introduced to boost profits. The production manager, Jeffrey Donald, was concerned about this approach. "Five years ago. life was a lot simpler. We produced just blue and black pens in long production runs, and everything went smoothly. Difficulties started when the red pens were introduced and we had to make more changeovers. To product red pens, we have to stop production, empty the vats, clean out all remnants of the previous color, and then start production of red pens. Making black pens was easy. We didn't even have to clean out the residual blue ink from the previous run. It was absorbed in the darker black ink. However, even small traces of either blue or black ink caused quality problems with the red pens and to a lesser extent, with the purple pens." Jeffrey also reported that the new pens caused more time to be spent on purchasing, scheduling, and tracking. 1 This case is an adaptation of a Harvard Business School Case 9/17/98. A Window Aktivlja ali 15 16 17 18 19 MIA:2:13:14:151161171181.9, 10, 11, 12, 13, 14 Operations Classic produces pens in a single factory. The major task was preparing and mixing the ink for different colored pens. The ink was inserted into the pens in a semi automated process. A final packing and shipping stage was performed manually. Each product had a bill of materials that identified the quantity and cost of direct materials required for the product. A routing sheet identified the sequence of operations required for each manufacturing process. The information was used to calculate the labor expenses for each of the four products. All of the plant's indirect expenses were aggregated at the plant level and allocated to products based on direct labor cost. Labor is paid at the rate of $10 per hour. Indirect costs were estimated as follows: Amount 20,000 Expense Indirect labor Fringe benefits Computer systems Machinery Maintenance Energy Total 10,000 8,000 4,000 2,000 60,000 Fringe benefits were 40% of direct and indirect labor. About half of the indirect labor resulted from scheduling production runs, which includes scheduling orders, purchasing, preparing, and releasing material for each run. Approximately 40% of the indirect labor was required for the physical changeover from one color pen to another. As noted previously, the changeover from blue to black ink was relatively short (1 hour) while the changeover for the other color pens was much more extensive, particularly for A Windows Aktivlja a Wir Ba 2:1 1:1. V I .2 1.3 8 :1 9 | 10 | | 13 | 14 | 15 16 17 18 19 1.4 1.5 1.6 1.7. 1 | Indirect labor Fringe benefits | Computer systems Machinery Maintenance Energy Total 11 | 12 20,000 16,000 10,000 8,000 4,000 2,000 60,000 T Fringe benefits were 40% of direct and indirect labor. About half of the indirect labor resulted from scheduling production runs, which includes scheduling orders, purchasing, preparing, and releasing material for each run. Approximately 40% of the indirect labor was required for the physical changeover from one color pen to another. As noted previously, the changeover from blue to black ink was relatively short (1 hour) while the changeover for the other color pens was much more extensive, particularly for red pens. The remaining 10% of indirect labor was for time spent maintaining records on the four products. This activity was essentially equal for each product. Most of the computer expense was used to scheduling production runs in the factory and to order and pay for the materials required in each production run. Since each production run was specific to a single customer, the computer time required to prepare shipping documents and to invoice and collect from a customer was also included in this activity. In total, about 80% of the computer resource was involved in the production run activity. The remaining time was used to keep records on the four products, which was essentially equal. The remaining three categories of overhead expenses were incurred to supply machine capacity to produce the pens. The machines had a practical capability of 10,000 hours of productive time. A Windo Aktivlja a -2 11 2:13 14:15:16 17:18:19 | 10 | 11 | 12 | 13 | 14 | 15 16 17 18 Sales and production information for the four product lines is as follows: Blue Black Red Purple 1 000 Production sales volume Unit selling price Material cost per unit Direct labor per unit (hrs) Machine hours per unit Production runs | Setup time per run (hrs) 40,000 $1.50 $0.50 .02 $1.50 $0.50 02 .1 50 $1.6) $0.55 9,000 $1.55 $0.52 .02 -02 1 12 50 1 | 38 61 | Case Requirements 1. Calculate a plant-wide predetermined overhead allocation rate based on direct labor cost and apply overhead to the four product lines. Calculate total product costs for the four lines using the plant-wide allocation rate and show the gross profit rate and unit cost for each. 2. What assumptions are implicit in this company's method of allocating overhead costs to the product lines? Do you believe these assumptions are supported by the operational procedures described in this case? Discuss. 3. Identify the main activities performed in the production process. Perform a first stage cost allocation and calculate allocation rates for each activity. Comment on your results with respect to the current allocation method. Do you believe that the costs as currently calculated are accurate? Why or why not? A Wind Aktivlja 4. Determine the estimated cost of each product line using activity-based-costing and the 2 1: 17 18 19 1 2:13 14 15 16 17 18 19 | 10 | 11 | 12 | 13 | 14 | 15 16 | Setup Time per run (nrs) | Case Requirements 1. Calculate a plant-wide predetermined overhead allocation rate based on direct labor cost and apply overhead to the four product lines. Calculate total product costs for the four lines using the plant-wide allocation rate and show the gross profit rate and unit cost for each. 2. What assumptions are implicit in this company's method of allocating overhead costs to the product lines? Do you believe these assumptions are supported by the operational procedures described in this case? Discuss. 3. Identify the main activities performed in the production process. Perform a first stage cost allocation and calculate allocation rates for each activity. Comment on your results with respect to the current allocation method. Do you believe that the costs as currently calculated are accurate? Why or why not? 4. Determine the estimated cost of each product line using activity-based costing and the gross profit rate for each. What can you conclude about the cost accuracy of the two methods? Were costs distorted using a single allocation rate method? 5. As a result of the new cost information calculated. what actions can management take to make this company more profitable? Be explicit A Windows Aktivlja a Wir 2:11M1M2:13 14 15 16 17 18 19 | 10 | 11 | 12 | 13 | 14 | 15 | 16 17 18 19 CASE MATERIALS: THE CLASSIC PEN COMPANY CASE Case Abstract The case is designed to help you develop an understanding of how to build an activity-based- costing model and why activity-based-costing may be more appropriate in practice than functional unit-based overhead cost allocation methods. The case requirements ask you to apply overhead and calculate product costs and gross profit using traditional plant-wide overhead allocation methods, assess the accuracy of the costing methodology given the operational environment, apply activity-based-costing concepts to recalculate the product costs and gross profit, and then effectively communicate the results of your analysis, evaluation, and recommendations in the form of a professional written memo. Case Narrative Jane Dempsey, controller of the Classic Pen Company, was concerned about the recent financial trends in operating results. Classic Pen had been the low-cost producer of traditional blue pens and black pens. Profit margins were over 20% of sales. Several years earlier, Dennis Selmor, the sales manager, had seen opportunities to expand the business by extending the product line into new products that offered premium selling prices over the traditional blue and black pens. As a result, five years ago, red pens were introduced. Red pens required the same basic production technology but could be sold at a 3% premium. Last year, purple pens were introduced because of the 10% premium in selling price they could command Jane reviewed the financial results for the most recent year and was keenly disappointed. While the new red and purple pens seemed to be more profitable than the blue and black pens, the overall profits were down and none of the product lines were earning profits at the level that the blue and black pens had earned in the past. She is wondering if more specialty pens selling at A Windows ak Aktivanja a window 1211 17 18 19 1 !:21:31:4:15:1.6.1:7:18:19: 110, 11, 12, 13, 14, 15, 16 business by extending the product line into new products that offered premium selling prices over the traditional blue and black pens. As a result, five years ago, red pens were introduced. Red pens required the same basic production technology but could be sold at a 3% premium. Last year, purple pens were introduced because of the 10% premium in selling price they could command. Jane reviewed the financial results for the most recent year and was keenly disappointed. While the new red and purple pens seemed to be more profitable than the blue and black pens, the overall profits were down and none of the product lines were earning profits at the level that the blue and black pens had earned in the past. She is wondering if more specialty pens selling at higher margins should be introduced to boost profits. The production manager, Jeffrey Donald, was concerned about this approach. "Five years ago. life was a lot simpler. We produced just blue and black pens in long production runs, and everything went smoothly. Difficulties started when the red pens were introduced and we had to make more changeovers. To product red pens, we have to stop production, empty the vats, clean out all remnants of the previous color, and then start production of red pens. Making black pens was easy. We didn't even have to clean out the residual blue ink from the previous run. It was absorbed in the darker black ink. However, even small traces of either blue or black ink caused quality problems with the red pens and to a lesser extent, with the purple pens." Jeffrey also reported that the new pens caused more time to be spent on purchasing, scheduling, and tracking. 1 This case is an adaptation of a Harvard Business School Case 9/17/98. A Window Aktivlja ali 15 16 17 18 19 MIA:2:13:14:151161171181.9, 10, 11, 12, 13, 14 Operations Classic produces pens in a single factory. The major task was preparing and mixing the ink for different colored pens. The ink was inserted into the pens in a semi automated process. A final packing and shipping stage was performed manually. Each product had a bill of materials that identified the quantity and cost of direct materials required for the product. A routing sheet identified the sequence of operations required for each manufacturing process. The information was used to calculate the labor expenses for each of the four products. All of the plant's indirect expenses were aggregated at the plant level and allocated to products based on direct labor cost. Labor is paid at the rate of $10 per hour. Indirect costs were estimated as follows: Amount 20,000 Expense Indirect labor Fringe benefits Computer systems Machinery Maintenance Energy Total 10,000 8,000 4,000 2,000 60,000 Fringe benefits were 40% of direct and indirect labor. About half of the indirect labor resulted from scheduling production runs, which includes scheduling orders, purchasing, preparing, and releasing material for each run. Approximately 40% of the indirect labor was required for the physical changeover from one color pen to another. As noted previously, the changeover from blue to black ink was relatively short (1 hour) while the changeover for the other color pens was much more extensive, particularly for A Windows Aktivlja a Wir Ba 2:1 1:1. V I .2 1.3 8 :1 9 | 10 | | 13 | 14 | 15 16 17 18 19 1.4 1.5 1.6 1.7. 1 | Indirect labor Fringe benefits | Computer systems Machinery Maintenance Energy Total 11 | 12 20,000 16,000 10,000 8,000 4,000 2,000 60,000 T Fringe benefits were 40% of direct and indirect labor. About half of the indirect labor resulted from scheduling production runs, which includes scheduling orders, purchasing, preparing, and releasing material for each run. Approximately 40% of the indirect labor was required for the physical changeover from one color pen to another. As noted previously, the changeover from blue to black ink was relatively short (1 hour) while the changeover for the other color pens was much more extensive, particularly for red pens. The remaining 10% of indirect labor was for time spent maintaining records on the four products. This activity was essentially equal for each product. Most of the computer expense was used to scheduling production runs in the factory and to order and pay for the materials required in each production run. Since each production run was specific to a single customer, the computer time required to prepare shipping documents and to invoice and collect from a customer was also included in this activity. In total, about 80% of the computer resource was involved in the production run activity. The remaining time was used to keep records on the four products, which was essentially equal. The remaining three categories of overhead expenses were incurred to supply machine capacity to produce the pens. The machines had a practical capability of 10,000 hours of productive time. A Windo Aktivlja a -2 11 2:13 14:15:16 17:18:19 | 10 | 11 | 12 | 13 | 14 | 15 16 17 18 Sales and production information for the four product lines is as follows: Blue Black Red Purple 1 000 Production sales volume Unit selling price Material cost per unit Direct labor per unit (hrs) Machine hours per unit Production runs | Setup time per run (hrs) 40,000 $1.50 $0.50 .02 $1.50 $0.50 02 .1 50 $1.6) $0.55 9,000 $1.55 $0.52 .02 -02 1 12 50 1 | 38 61 | Case Requirements 1. Calculate a plant-wide predetermined overhead allocation rate based on direct labor cost and apply overhead to the four product lines. Calculate total product costs for the four lines using the plant-wide allocation rate and show the gross profit rate and unit cost for each. 2. What assumptions are implicit in this company's method of allocating overhead costs to the product lines? Do you believe these assumptions are supported by the operational procedures described in this case? Discuss. 3. Identify the main activities performed in the production process. Perform a first stage cost allocation and calculate allocation rates for each activity. Comment on your results with respect to the current allocation method. Do you believe that the costs as currently calculated are accurate? Why or why not? A Wind Aktivlja 4. Determine the estimated cost of each product line using activity-based-costing and the 2 1: 17 18 19 1 2:13 14 15 16 17 18 19 | 10 | 11 | 12 | 13 | 14 | 15 16 | Setup Time per run (nrs) | Case Requirements 1. Calculate a plant-wide predetermined overhead allocation rate based on direct labor cost and apply overhead to the four product lines. Calculate total product costs for the four lines using the plant-wide allocation rate and show the gross profit rate and unit cost for each. 2. What assumptions are implicit in this company's method of allocating overhead costs to the product lines? Do you believe these assumptions are supported by the operational procedures described in this case? Discuss. 3. Identify the main activities performed in the production process. Perform a first stage cost allocation and calculate allocation rates for each activity. Comment on your results with respect to the current allocation method. Do you believe that the costs as currently calculated are accurate? Why or why not? 4. Determine the estimated cost of each product line using activity-based costing and the gross profit rate for each. What can you conclude about the cost accuracy of the two methods? Were costs distorted using a single allocation rate method? 5. As a result of the new cost information calculated. what actions can management take to make this company more profitable? Be explicit A Windows Aktivlja a Wir