Prepare a schedule showing cost per roll of each product

Assignment Help Accounting Basics
Reference no: EM131794807

Problem -

Timberland's Overhead Allocation Problem

Background:

Eastvaco recently purchased a pulp manufacturing company, Timberland, Inc., located in Columbia, South Carolina. Eastvaco's management is concerned about the current cost structure currently used by Timberland. The pulp industry in general as been on an economic downturn but Timberland has historically shown below average net income and return on equity. Timberland produces four products. Each product is a variation of paper, for instance, difference thickness, color and/or width. Timberland supplies other Eastavco segments, in particular, the Charlotte plant, product A, a key raw material for their manufacturing process. The CEO of Eastvaco has dispatched several accountants from their corporate office to Columbia to review Timberland's cost allocation structure. Corporate accountants suspect that Timberland's current overhead allocation, based on multiplying the overhead rate by material costs, is causing an over-allocation of overhead for some products. This leads to inaccurate product profitability analysis. It is believed that product changes and slitting are not being allocated correctly.

The Typical Pulp Manufacturing Process:

The manufacturing process begins with timber in the form of logs or wood chips. If raw materials are received in the form of logs, the first step in the process is debarking. A rotating drum that measures 16 feet in diameter by 100 feet in length tumbles the logs to remove the bark. After debarking, chippers reduce the logs into one-inch cubes. Then wood chips are cooked to break down the glue-like material bonding the wood fibers. Chemicals used in the process are reclaimed and reused in future production. Next, the naturally brown fibers are washed and screened. A bleaching process converts brown pulp into white pulp.

The paperboard manufacturing process begins by mixing pulp with water and chemicals. The mixture is applied to a porous wire mesh; formation of paper actually occurs within this step. The wire mesh travels through a press that forces the pulp mixture against the wire to eliminate water within the mixture and to form the desired paper thickness. The material then proceeds to a drying section where it travels across numerous cylindrical dryers that are heated with steam. In the final section of the paper machine, long sections of paperboard (approximately five miles long and weighing ten tons) are rolled up into parent rolls and are removed from the machine. The parent roll is further processed by the Company's customers (including other Eastvaco segments) to make various types of paperboard containers.

Sometimes customers require additional processing on parent rolls. For example, food processors often require widths of 18 inches, rather than the standard width of a roll (approximately 12 feet). Thus, rolls are loaded onto a rewinder slitter to produce eight rolls 18 inches wide from one 12-foot-wide roll. The Company had always combined labor and machine costs of the slitter with those of the paper machine for allocation purposes. Thus, all paperboard products shared in the costs of slitting even though most products were not slit. It is now thought that slitting may be more expensive than previously thought. In addition to the costs of specialized equipment and extra labor, knives used in the slitting process often damage the paperboard's edges. Thus, more quality inspection and testing are required when producing slit rolls.

Timberland's Cost Allocation Process:

The Company had always combined labor and machine costs of the slitter with those of the paper machine for allocation purposes. Thus, all paperboard products shared in the costs of slitting even though most products were not slit. It is now thought that slitting may be more expensive than previously thought. In addition to the costs of specialized equipment and extra labor, knives used in the slitting process often damage the paperboard's edges.

Thus, more quality inspection and testing are required when producing slit rolls. Continuous processors, such as chemical and paper producers, historically have used volume-related drivers to attach overhead to products. The Company traditionally applied overhead to its products as a function of material costs. Management believed using "material costs" as an allocation base made sense because thicker products required more machine time to process as they demanded slower machine speeds. Additionally, drying time and energy consumption increase with thicker basis weights. (See Table 1 for material costs associated with each product,) Thus, unit level (or volume-related) drivers made sense for applying certain types of overhead to products. However, other important costs were incurred without respect to volume. For example, product changes induce instabilities into the manufacturing process that result in scrap until the process resumes stability.

On average, production engineers estimate that approximately one-half roll is lost to scrap each time a product change is made. Just as discrete-part manufacturers incur machine setup costs between production runs of two different products, scrap produced following product changes is a predictable cost of production. Some of the pulp can be recovered by recycling the scrapped paper, termed "broke" paper. Thus, the product change cost figures presented in Table 2 include only depreciation, labor, energy, and waste materials associated with product changes.

Recently, some managers at the company began questioning the long-standing strategic policy of producing a full product line. Because selling prices and profit margins significantly varied across the product mix, some managers questioned whether the company's assets were being used to the greatest advantage. Currently the Company was experiencing demand in excess of its production capacity.

A sample representing significant categories of products is presented in Table 1. The sample contains thin paperboard products(caliper .013) as well as heavier products (caliper .020). In addition, Table 1 identifies whether a given product is coated or uncoated, or slit. The sample is representative of the variation in batch quantities. Some are produced and sold in small quantities, while the market demands significantly more production of other products. Material cost per roll includes pulp and chemical costs, while the selling price reflects recent market prices. Pulp and paperboard is a capital-intensive industry requiring expensive processing equipment. The company cost accountants estimated that manufacturing overhead, including labor, energy, and depreciation on capital equipment, approximates 105% of material costs.

Table 1

Selected production and financial data:

Product Thickness Coated/Uncoated Slit

A 0.013 Coated Yes

B 0.014 Uncoated No

C 0.015 Coated Yes

D 0.02 Coated No

Continue table:

Prod/Aver rolls per Batch/Materials Cost per roll/Selling Price per Roll

A 50 $4,800 $12,600

B 2 $5,200 $13,500

C 35 $5,600 $14,200

D 175 $7,400 $19,500

Table 2

Overhead:

Total Depreciation is $800,000 = Product Change **$8,000 + Slitting $70,000 + Net *$722,000

Total Labor is $300,000 = Product Change ** $3,000 + Slitting $25,000 + Net *$272,000

Total Energy is $500,000 = Product Change **$5,000 + Slitting $80,000 + Net * $415,000

Total Other is $198,470 = Product Change **$1,000 + Slitting $20,000 + Net * $177,470

Total Waste is $ 30,000 = Product Change **$30,000 + Slitting -0- + Net -0-

* Net is equal to total amount minus product change cost and minus slitting cost. This amount represents the general overhead, ie. Overhead that is not specific to a particular product.

**Product change is required of all four products and the cost is to be divided equally among the four products.

Total product cost is equal to materials, overhead, product cost and where incurred slitting costs.

Requirements -

1. Prepare a schedule proving that overhead is currently 105% of material costs.

2. Prepare a schedule showing cost per roll of each of the four products using the 105% overhead rate.

3. As Eastvaco's cost accountant you believe the general overhead should be allocated separately. Prepare a schedule showing what you believe the new overhead rate should be.

4. Using the new overhead rate from requirement 3, prepare a schedule calculating the revised cost per roll of each product.

5. Assuming that the selling price for each product is relatively inelastic, write a short memo to Eastvaco's CEO with your conclusions and suggestions.

Reference no: EM131794807

Questions Cloud

Compute the cost of the ending inventory under FIFO method : Assuming there are 394 units on hand, compute the cost of the ending inventory under the (a) FIFO method and (b) LIFO method
Apply levels of prevention : Discuss the following in your post - Create three scenarios where you would apply each of the three the levels of prevention
Discuss what are the defining elements of academic crime : What are the defining elements of academic crime, and why is it more of a problem or less of a problem than the crimes of other professions
Show the various splitting merging stages of binary merge : Use diagrams like those in the text to show the various splitting merging stages of binary merge sort for the following lists of numbers.
Prepare a schedule showing cost per roll of each product : Prepare a schedule showing cost per roll of each of the four products using the 105% overhead rate
Discuss the principal evidence on the scope of retail crime : Discuss the principal evidence on the scope of retail crime, and factors that tend to promote or inhibit it
Write a function to find the median of a list using method : The median of a set with an odd number of elements is the middle value if the data items are arranged in order.
Discuss promote a high level of employee crime : Discuss the principal problems involved in defining employee crime and measuring its scope accurately. Which forms of employee crime are most harmful
Problem based on special journals and subsidiary ledgers : Problem based on Special journals, subsidiary ledgers, trial balance-perpetual. Church Company completes transactions and events during March of current year.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd