Question
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
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 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 didnt 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.
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 plants 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: Expense Amount Indirect labor 20,000 Fringe benefits 16,000 Computer systems 10,000 Machinery 8,000 Maintenance 4,000 Energy 2,000 Total 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 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. Sales and production information for the four product lines is as follows: Blue Black Red Purple Production sales volume 50,000 40,000 9,000 1,000 Unit selling price $1.50 $1.50 $1.55 $1.65 Material cost per unit $0.50 $0.50 $0.52 $0.55 Direct labor per unit (hrs) .02 .02 .02 .02 Machine hours per unit .1 .1 .1 .1 Production runs 50 50 38 12 Setup time per run (hrs) 4, 1, 6, 4
QUESTIONS
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 companys 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
This is a complete multipart accounting and cost management question and I will proceed to solve it step by step Question 1 Calculate a Plantwide Predetermined Overhead Allocation Rate To calculate th...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started