Question
Hardcopy Paper Inc. has three paper mills, one of which is located in Canlubang, Laguna. The Canlubang mill produce 300 different types of coated and
Hardcopy Paper Inc. has three paper mills, one of which is located in Canlubang, Laguna. The Canlubang mill produce 300 different types of coated and uncoated specialty printing papers. Management was convinced that the value of the large variety of products more than offset the extra costs of the increased complexity.
During 2020, the Canlubang mill produced 120,000 tons of coated paper and 80,000 tons of uncoated paper. Of the 200,000 tons produced, 180,000 were sold. Sixty products account for 80% of the tons sold. Thus, 240 products are classified as low-volume products.
Lightweight lime hopsack in cartons (LLHC) is one of the low-volume products. LLHC is produced in rolls, converted into sheets of paper, and then sold in cartons. In 2020, the cost to produce and sell one ton of LLHC was as follows:
Direct materials:
Furnish (3 different pulps) 2,225 pounds P 22,500
Additives (11 different items) 200 pounds 25,000
Tub size 75 pounds 500
Recycled scrap paper (296 pounds) (1,000)
Total direct materials P 47,000
Direct labor P 22,500
Overhead:
Paper machine (P5,000 per ton x 2,500 pounds) P 6,250
Finishing machine (P6,000 per ton x 2,500 pounds) 7,500
Total overhead P 13,750
Shipping and warehousing P 1,500
Total manufacturing and selling cost P 84,750
Overhead is applied by using a two-stage process. First, overhead is allocated to the paper and finishing machine by using the direct method of allocation with carefully selected cost drivers. Second, the overhead assigned to each machine is divided by the budgeted tons of output. These rates are then multiplied by the number of pounds required to produce one good ton.
In 2020, LLHC sold for P120,000 per ton, making it one of the most profitable products. A similar examination of some of the other low-volume products revealed that they also had very respectable profit margin. Unfortunately, the performance of the high-volume products was less impressive, with many showing losses or very low profit margins. This situation led Alex Catapang to call a meeting with his marketing vice president, Jennifer Wales, and his controller, Kyle Alcaraz.
Alex: The above-average profitability of our low-volume specialty products and the poor profit performance of our high-volume products make me believe that we should switch our marketing emphasis to the low-volume line. Perhaps we should drop some of our high-volume products, particularly those showing a loss.
Jennifer: Im not convinced that solution is the right one. I know our high-volume products are of high quality and Im convinced that we are as efficient in our production as other firms. I think that somehow our costs are not being assigned correctly. For example, the shipping and warehousing costs are assigned by dividing these costs by the total tons of paper sold. Yet.
Kyle: Jennifer, I hate to disagree, but the P1,500-per-ton- charge for shipping and warehousing seems reasonable. I know that our method to assign these costs is identical to a number of other paper companies.
Jennifer: Well,, that may be true, but do these other companies have the variety of products that we have? Our low-volume products require special handling and processing, but when we assign shipping and warehousing costs, we average these special costs across our entire product line. Every ton produced in our mill passes through our mill shipping department and is either sent directly to the customer or to our distribution center and then eventually to customers. My records indicate quite clearly that virtually all of the high-volume products are sent directly to all of the customers, whereas most of the low-volume products are sent to the distribution center. Now, all of the products passing through the mill shipping department should receive a share of the P100M annual shipping costs. Im not convinced, however, that all products should receive a share of the receiving and shipping costs of the distribution center as currently practiced.
Alex: Kyle, is this true? Does our system allocate our shipping and warehousing costs in this way?
Kyle: Yes, Im afraid it does. Jennifer may have a point. Perhaps we need to reevaluate our method to assign these costs to the product lines.
Alex: Jennifer, do you have any suggestions concerning how the shipping and warehousing costs should be assigned?
Jennifer: It seems reasonable to make a distinction between products that spend time in the distribution center and those that do not. We should also distinguish between the receiving and shipping activities at the distribution center. All incoming shipments are packed on pallets and weigh one ton each. There are 14 cartoons of paper per pallet. In 20X1, the receiving department processed 56,000 tons of paper. Receiving employs 15 people at an annual cost of P30,000,000. Other receiving costs total about P25,000,000. I would recommend that these costs be assigned by using tons processed.
Shipping however is different. There are two activities associated with shipping; picking the order from inventory and loading the paper. We employ 30 people for picking and 10 for loading, at an annual cost of P60,000,000. Other shipping costs total P55,000,000. Picking and loading are more concerned with the number of shipping items than with tonnage. That is, a shipping item may consist of two or three cartons instead of pallets. Accordingly, the shipping costs of the distribution center should be assigned by using the number of items shipped. In 2020, for example, we handled 190,000 shipping items.
Alex: These suggestions have merit. Kyle, I would like to see what effect Jennifers suggestions have on the per-unit assignment of shipping and warehousing for LLHC. If the effect is significant, then we will expand the analysis to include all products.
Kyle: Im willing to compute the effect, but Id like to suggest one additional feature. Currently, we have a policy to carry 25 tons of LLHC in inventory. Our current costing system totally ignores the cost of carrying this inventory. Since it costs us P83,250 to produce each ton of this product, we are tying up a lot of money in inventory money that could be invested in other productive opportunities. In fact, the return lost is about 16% per year. This cost should also be assigned to the units sold.
Alex: Kyle, this also sounds good to me. Go ahead and include the carrying cost in your computation.
To help in the analysis, Kyle gathered the following data for LLHC for 2020:
Tons sold 10
Average cartons per shipment 2
Average shipment per ton 7
Required:
- Identify the flaw associated with the current method of assigning shipping and warehousing costs to Hardcopys products.
- Compute the shipping and warehousing cost per ton of LLHC sold by using the new method suggested by Jennifer and Kyle. Round rates and the cost per ton to two decimal places.
- Using the new costs computed in Requirement 2, compute the profit per ton of LLHC. Compare this with the profit per ton computed by using the old method. Do you think that this same effect would be realized for other low-volume products? Explain.
- Comment on Alex proposal to drop some high-volume products and place more emphasis on low-volume products. Discuss the role of the accounting system in supporting this type of decision making.
- After receiving the analysis of LLHC, Alex decided to expand the analysis to all products. He also had Kyle reevaluate the way in which all mill overhead was assigned to products. After the restructuring was completed, Alex took the following actions: (a) the prices of most low-volume products were increased, (b) the prices of several high-volume products were decreased, and (c) some low-volume products were dropped. Explain why this strategy changed so dramatically.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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