Wilkerson Company Case Study Essay
Chapter 18 ADDITIONAL ASPECTS OF PRODUCT COSTING SYSTEMS Changes from Tenth Edition Chapter 18 was modified to include discussions of customer-related and business-related cost drivers and recent evidence about the usage and success of activity-based cost systems. Approach Our treatment of job costing and process costing is as brief as we can make it and still get the general points across. Students do need to understand the general idea of these cost accumulation procedures; otherwise they are unable to visualize how costs are actually collected. The details, however, are appropriately left for an advanced course.
The principal pedagogical problem here is how to get across the idea of equivalent production in process costing. Some introductory texts omit this idea, but this strikes us as dangerous because some student is almost sure to ask what happens in a process cost system if not all the units are completed by the end of the period. If the answer is not in the text, the instructor either has to duck the question, or attempt the difficult task of explaining it on the spot. In the text and in most problems, we assume that units are 50 percent completed as to labor and overhead.
Since this assumption is widely used in practice, we see no point in complicating the text by introducing other percentages. Certainly, the most difficult part of this chapter is the section on development of overhead rates. In our experience, mastery of this material greatly reduces the omnipresent problems students have later with production overhead variances. We also find in this regard that students need to be referred back to the text section, “Why Overhead Rates Are Predetermined,” especially in later discussions of the overhead volume variance.
We have placed emphasis on the flexible overhead budget to help minimize these learning difficulties. We feel that the new section on ABC provides the appropriate level of depth for a required course. Students need to understand the potential benefits of ABC as well as that it are not a panacea. It is important for students to realize that ABC is a decision-support model rather than a transaction processing system. Cases Wilkerson Company is a simple activity-based costing case.
It requires students to calculate the costs of three products using on a new set of cost drivers, to compare those costs with those calculated using traditional direct labor-based allocation bases, and then to understand what the numbers mean. (This is a new case with the Eleventh Edition. ) Huron Automotive Company gives practice in computing and using costing rates and shows the differences that result from different definitions of cost centers. It also has two optional questions involving differential analysis, for the instructor who wishes to keep emphasizing that full costs are not used for all cost-related management decisions.
Siemens Electric Motor Works (A) effectively helps students discover the key concepts and potential benefits of ABC. (If an additional case is desired, we suggest the John Deere case cited in footnote 17. ) Dakota Office Products requires students to understand the mechanics of customer profitability analysis and then to use the information for strategic decision making purposes. (This is a new case with the Eleventh Edition. ) Problems Problem 18-1: Elliott Company a. Overhead rate = b. | Work in Process Inventory| 22,500| | | Raw Materials Inventory| | 6,000| | Direct Labor| | 6,600| | Production Overhead (6,600 x $1. 0)| | 9,900| c. | Overhead absorbed @ $1. 50/direct labor hour| $9,900| | | Actual overhead| 9,550| | | Overabsorbed| $ 350| | Problem 18-2: Ryan Corporation Cost Distributions| | | Cost Center| | | __A__| __B__| __C__| (a)| Heat, light, power| $24,000| $ 8,000| $8,000| (b)| Depreciation:| | | | | Building| 2,400| 300| 300| | Furniture and fixtures| | 600| 200| | Machinery and equipment| 20,000| | | (c)| Insurance:| | | | | Inventories| 100| 100| | | Building| 1,040| 130| 130| | Furniture and fixtures| | 45| | Machinery and equipment| 850| | 15| (d)| Building repairs| 2,400| 800| 800| | Machinery repairs| 1,900| | | (e)| Telephone expense| 360| 1,080| 360| | Totals| $53,050| $11,055| $9,805| Calculations (a) Heat, light, power–basis of distribution, cubic feet: A| 600,000| | B| 200,000| | C| 200,000| 1,000,000 cubic feet| 6/10 x $40,000 = $24,000 A 2/10 x $40,000 = $8,000 B 2/10 x $40,000 = $8,000 C (b) Building depreciation–basis of distribution, square feet: Manufacturing| 48,000| | Selling| 9,000| | Administrative| 3,000| 60,000 square feet| 48/60 x $3,000 = $2,400 A /60 x $3,000 = 300 B 6/60 x $3,000 = 300 C Furniture and fixtures depreciation — 75% ($800) = $600 B 25% ($800) = $200 C (c) Insurance–basis of distribution, square feet for building: 48/60 x $1,300 = $1,040 A 6/60 x $1,300 = $130 B 6/60 x $1,300 = $130 C Insurance on inventories–half B; half A Insurance on furniture and fixtures — 75% ($60) = $45 B 25% ($60) = $15 C (d) Building repairs–basis for distribution, square feet: 48/60 x $4,000 = $3,200 A 6/60 x $4,000 = $400 B 6/60 x $4,000 = $400 C (e) Telephone–basis for distribution, number of extensions: Total extensions — 45 /45 x $1,800 = $360 A 27/45 x $1,800 = $1,080 B 9/45 x $1,800 = $360 C Problem 18-3: Mid-City College a. | ($000)| | | Service Centers| Instruction Centers| | Total| Bldg. and Grounds| Cent. Adm. | Arts and Sciences| Education| Bus. Adm. | Overhead costs| $l0,500| $1,575| $1,050| $3,150| $2,625| $2,100| Buildings and Grounds| | (1,575)| 262| 525| 438| 350| Central Administrator| ______| _____| (1,312)| 525| 315| 472| Overhead| $10,500| $ 0| $ 0| $4,200| $3,378| $2,922| *Reassignment of Building and Grounds Department using percent of space occupied:
Cost Center| Percent of Floor Space| Cost Reassignment| Central Administration| 15| | Arts and Sciences| 30| | Education| 25| | Business Administration| 20| | Total| 90| $1,575| **Reassignment of Central Administration Department using number of employees: Cost Center| Number of Employees| Cost Reassignment| Arts and Sciences| 80| | Education| 48| | Business Administration| 72| | Total| 200| $1,312| b. | Instruction Center| Overhead Cost| Number of Students| Overhead Cost per Student| | Arts and Sciences| $ 4,200| 6,000| $ . 70| | Education| 3,378| 2,500| 1. 35| Business Administration| 2,922| 1,500| 1. 95| | | $10,500| 10,000| | Problem 18-4 Weld a. Actual overhead Canning Company Busy season| $180,000| ? | 15,000 hours| =| $12 per hour| Slack season| $ 80,000| ? | 5,000 hours| =| $16 per hour| At 1 hour per case, a case has $12 of factory overhead cost in the busy season and $16 in the slack season. Inventory at December 31 will consist of all “busy season” production, so at $12 per hour, the overhead cost component is 25,000 cases x $12 = $300,000. b. Predetermined overhead Total factory overhead costs| | 6 months @ $180,000| $1,080,000| 6 months @ 80,000| 480,000|
Total| $1,560,000| Total direct labor hours| | 6 months @ 15,000| 90,000| 6 months @ 5,000| 30,000| Total| 120,000| $1,560,000 ? 120,000 hours = $13. 00 per hour Inventory at December 31 will have an overhead cost component of 25,000 cases x $13. 00 = $325,000. c. In this case, where the same type of product is packed each month, the most valid overhead rate to use is probably the annual rate of $13. 00 per hour. A case of a given product whether packed in the slack season or the busy season should bear the same share of indirect cost, assuming the same production techniques, raw materials, and labor usage.
Problem 18-5 Journey’s End, Inc. This is a pretty standard, but simplified, activity-based costing situation. The main twist is that distribution channels, rather than products or customers, is the cost object. Students must do the Stage I allocations (trace the costs to activities), compute the proper Stage II cost driver percentages (showing the channels’ consumption of the activities), to apply those percentages in allocating the activity costs to the channels. 1. Tracing the costs to activities. The SG&A line-item costs should be multiplied by the percentages shown in the activity table, as ollows: Table TN-1 SG&Aline-item:| ———————— Activity ————————–| | | Customer mailing| Take phone or Internet order| Take field order| Special negotiation—field order| Process customer invoice| Other| Total| Marketing and sales support| $600| $600| $1,800| $3,000| 0| 0| $6,000| Design| 0| 0| 0| 810| 0| 90| 900| Information systems| 0| 200| 0| 0| 200| 1,600| 2,000| General administration| 0| 0| 0| 300| 300| 2,400| 3,000| Total| $600| $800| $1,800| $4,110| $500| $4,090| $11,900| 2. Channels’ consumption of the activities.
These are calculated from the second major table in the problem, as follows: Table TN-2 Activity| ———– Channel ———–| Total| | Catalog| Corporate| Retail| | Customer mailings| 98%| 1%| 1%| 100%| Number of phone orders| 97%| 1%| 2%| 100%| Number of field orders| 0| 50%| 50%| 100%| Number of field orders requiring special negotiation| 0| 75%| 25%| 100%| Total number of orders| 77%| 11%| 12%| 100%| 3. Allocating the activity costs to channels. This is done by multiplying the percentages in Table TN-2 by the dollar figures in Table TN-1, as follows:
Table TN-3 Activity| ———– Channel ———–| Total| | Catalog| Corporate| Retail| | Customer mailings| $588| $6| $6| $600| Number of phone orders| 776| 8| 16| 800| Number of field orders| 0| 900| 900| 1,800| Number of field orders requiring special negotiation| 0| 3,083| 1,027| 4,110| Total| $1,749| $4,052| $2,009| 7,810| | | | Other| 4,090| | | | | $11,900| One error that some students might make is to allocate the “other” costs to channels, by assuming a cost driver. No reasonable basis for a cost driver assumption is provided in the case.
Allocating these costs could swamp the meaningful allocations that could be made. Table TN-4 summarizes the channel profit information revealed from this new analysis. Table TN-4 | ———– Channel ———–| Total| | Catalog| Corporate| Retail| | Sales| $30,000| $10,000| $20,000| $60,000| Cost of Sales| 15,000| 6,500| 14,000| 35,500| Gross margin| 15,000| 3,500| 6,000| 24,500| SG&A| 1,749| 4,052| 2,009| 7,810| Net profit| $13,251| $(552)| $3,991| $6,690| Profit % sales| 44. 2%| (5. 6%)| 20. 0%| 11. 2%| Question 2 in the suggested assignment asks for the implications of this analysis.
Here are some of the questions raised: * Should the company should continue to use the channel now revealed to be a loser (corporate)? * Are there some cross selling possibilities or sticky or unavoidable costs that make it undesirable to exit the corporate business? * Should/can prices be raised in certain areas? * Can some of the costs (e. g. , those related to the costly negotiation process, commissions) be reduced? * Should a minimum order size be instituted in the corporate business? * Should the company’s cost system be altered to consider SG&A costs on a regular basis?
Cases Case 18-1: Wilkerson Company Purpose of Case This case provides a description of a simple activity-based cost (ABC) system. Within a minimum of complexity, it illustrates the ABC principles and the effects that use of such a system can have. Teaching Plan 1. Start with student giving competitive situation faced by Wilkerson: Mature products, declining profits. The price environment is confusing. There are high margins and little price competition in one line (flow controllers), and continued price pressure in another (pumps). 2.
What is the structure of the existing cost system? Direct labor ????. $271,250 Direct material ????. $458,000 Overhead ????. $806,000 Products ??. (300% of DL$) 3. What are the features of this system? High overhead costs ($806,000) being applied using DLS$ ($271,250), leading to high burden rate: 300% Single production cost center Some processes use automated machines; different ratios of machine hours to DLH; probably better to have costs driven by machine hours in automated processes Simple, easy to implement since already measuring DL$ at the individual product level
Fails to capture product diversity & complexity: valves and pumps have only 4-5 components; flow controllers have 10 components. Each component requires purchasing, receiving, setup and machining activity. 4. Should Wilkerson abandon its overhead cost allocation system and make managerial decision based on contribution margin (price less variable costs); in effect use marginal costs rather than average costs? Not easy to know which elements of overhead are variable. Contribution margin OK for short-term decisions, such as whether to accept a one-time order when operating with excess capacity.
With only three main product lines, and overhead ($806,000) well in excess of DL and DM costs, CM does not reveal the different demands that individual products make on overhead resources (for machine time, engineering design, setups, receiving, shipping, etc. ). Want to understand the impact of variety in use of OH resources by individual products. If cut prices based on contribution margin to get new business, should be cautious about: (i. ) competitive reactions, (ii. ) having to lower prices to existing customers, (iii. filling up capacity with business that doesn’t pay for capacity costs. If cutting prices, when near capacity, demand could increase beyond existing capacity. You end up having to supply more capacity for support resources to handle the work, and not being paid for supplying these capacity resources. 5. What would an ABC system look like? Overhead ???? $806,000 Machining Set-up ReceivingEngineering Shipping ?? ??. ????????? ??.???. Products ?? $336,000 $40,000 $180,000 $100,000 $150,000 ??? | ???? | ???? | ?? (?? )| ????? ?????? | $336,000| ???? | 11,200| 30 | ?????? | $40,000| ???? | 160| 250 | ????????? | $180,000| ???? | 160| 1,125 | ???? | $100,000| ???? | 1,250| 80 | ?????? | $150,000| ????. | 300| 500 | At Actual Usage Machine rate:$30/ hour Setups:250/run Receiving:1,125/run Engg:$80/engr. hour Shipping:$500/shipment 6. What cost drivers should be selected for the various activities? What is the calculated cost driver rate? At Actual UsageAt Capacity Machine rate:$30/ hour$28/ hour Setups:250/run$222. 22/ run Receiving:1,125/run$1,000/ run Engg:$80/engr. our$80/engr. hour Shipping:$500/shipment$375/shipment Note that we have two unit-level activity cost drivers (direct labor and machine hours), three batch activities (setup machines, receive materials, ship products), and one product-sustaining activity (perform engineering support). Could also note that we have: Transaction drivers:# shipments, # production runs (setups) assumes same cost/incident Duration driver:machine hours, engineering hours assumes same cost per hour of use (no difference in capital intensity or quality/pay of engineers).
If this assumption is invalid, then use intensity driver – actual cost of resources used or create more activity centers to reflect differential pricing. Optional:Before doing any calculations, which products will be most affected by using the ABC system? Cost of valves will decrease – high volume product benefits from lower unit-level costs, long runs, little engineering support Cost of flow controllers will increase – had less unit level activity (DLH, Mhrs) and more transactional (production runs, shipments) and product support (engineering hours) activity . Which cost driver rates should we use: actual or capacity-based? Doesn’t make a huge difference here because working near capacity Recall Anagene; when a plant is well below capacity, the cost driver rate is high; could lead to under-utilization of the resource (engineers will spec their products to run on resources with lower rates – thereby increasing the demand on bottleneck resources; and avoid using resources with high rates – thereby further under-utilizing a resource with lots of surplus capacity.
Attempts to recover the high resource cost in pricing will likely lead to lower demand, less utilization of the resource, and a potential death spiral. Conceptually, preferable to use capacity costing (or the capacity utilization anticipated when the resource (machine) was acquired). Resource costs not assigned to actual production will be featured in an unused capacity category. 8. What are the revised product costs? Overhead @ ActualOverhead @ Capacity Valves$151,250 ($20. 17)$140,972 ($18. 80) Pumps$321,250 ( 25. 70)$292,361 ( 23. 39) Flow Controllers$333,500 ( 83. 8)$288,322 ( 72. 08) Calculate new profit margins and interpret Valves46. 3%47. 9% Pumps33. 1 %35. 8% Flow Controllers(9. 9)%0. 9% Valves are actually highly profitable; pumps are about normal profitability – probably the right decision to match competitors’ prices; flow controllers are just breaking even–now we understand why competitors are not undercutting our recent price increases. 9. Why have the cost shifts occurred? Valves are high-volume, have low support costs per unit: Flow controllers are “overhead-intensive;” consume lots of overhead resources per unit produced.
Units/runUnits/shipmentEngg $/unit Valves750750$ 2. 67 Pumps250178$ 2. 40 Flow Controllers4018$12. 50 Let’s look at the costs of a product, like flow controllers, comparing the traditional with the ABC cost estimates. See Exhibit TN-1. 10. What actions are suggested by the traditional cost system? Lower material costs: Choose cheapest suppliers and components (look for discounts for high volume purchases, perhaps compromise on quality, search for overseas suppliers. Design products with lots of components, many unique, if this leads to lower material costs.
Don’t worry about using common components across different product lines (no apparent benefit) so enormous component proliferation: in 1985 Hewlett Packard and Tektronix used upwards of 150K different components in their various products. Each time a new instrument was designed, engineers started with a clean slate – no motivation or incentive to use components already being ordered and stored in large quantities for existing products. Enormous proliferation of vendors – keep shopping for lowest price from any vendors – leads to large “vendor-sustaining costs. ”
Lower labor costs: Spend lots of IE resources to reduce standard DL times (save DL$ + 300%); Automate; shift production overseas to low labor cost countries. Leads to highly efficient production machines (based on run time) but which could be very inflexible – long changeover times. 11. What actions are suggested by the ABC system? Managers still get benefits from lowering material, labor and machine time costs; but they also see big opportunities from: * Operational improvements to perform batch and product sustaining activities more efficiently (with fewer resources): e. . , decrease setup times, lower cost of receiving and materials handling, cost of packaging and shipping, and the engineering support required for flow controllers * Redesigning flow controllers to use fewer components; to reduce demand for receiving, setup, and engineering activities. Try to share components already being used by high-volume valves and pumps. Examples of problems in this area: * Campbell Soup – 17 different specifications for diced carrots in its soups. * Chrysler – how many different wire harnesses should they have?
Eaton thought 6, cost accountants said 12. ABC said 6 based on production costs. But counting distribution and dealer inventory costs – best number was 2. * Try to achieve uniqueness at final stage of assembly (Dell Computer – many, many final combinations from a very limited range of ICs, monitors, hard drives, RAM, printers, … ) rather than assembling unique products from uniquely-fabricated components. “Strategic actions” to reduce the quantity of activities Wilkerson has to perform: Pricing – be more aggressive on pricing flow controllers; continue to meet competition for pumps since profit margins still reasonable; valves – no reason to start discounting the price if customers are not complaining or defecting, but watch for competitors undercutting our prices to steal customers. If fewer orders (from higher prices), then fewer activities to perform. * Minimum order size – particularly with flow controllers to reduce the high overhead cost per unit associated with small production runs and small shipments
Hope that someone brings up questions about how the above actions lead to lower expenses for Wilkerson. If reduce demands for OH resources through combination of strategic actions and operational improvements, will create unused capacity. Must act to exploit this unused capacity either by increasing the volume the company produces and sells or by eliminating resources (capacity) no longer needed. Can retain “unprofitable” or low margin products – since many indirect and support resources are not easily reduced in the short run.
But then the CFO must insist that no capacity-expanding investments will be made until all unprofitable products are removed from current resources. Cheapest source of new capacity is that freed up from stopping the production of products that are not paying for the existing capacity. 12. What are the limitations of the analysis? (a) Measurement issues: ABC analysis is expensive, requires more data collection for a small company, with limited staff and information resources. Estimates are more subjective and have higher measurement error– especially on engineering effort. Could the measures be biased by management judgments?
Also, the cost drivers in Exhibit 4 (except for engineering and machine hours) are all transactional – assume that each setup, each production run, each receipt, each shipment requires the same resources. These activities could have different durations (or intensities) for the different products – will need to investigate and test the homogeneity assumption that allows us to summarize activities with simple transaction drivers. (b) The analysis ignores the substantial GS&A expenses, which at $559,650 are larger than any single overhead category (as well as direct labor or materials expenses).
Wilkerson should analyze the GS&A expenses, try to drive these to product lines or customers not just product profitability. This opens up the opportunity for targeted actions for individual customers. (c) Management issues: defensive reactions to revelation of unprofitable products or customers; inefficient processes (excess capacity); poorly-designed products. Managers will not say they feel threatened or embarrassed. Rather they will criticize the ABC model – simplistic (or too complex), doesn’t capture well the “real world. ” Analysts don’t understand the complexity of the business.
Analysts/consultants must be willing to be vulnerable but not weak. Offer to work with the critic to improve the model to the point where he/she is satisfied it captures economically reality sufficiently well (add cost centers or new activities, use more accurate cost drivers (duration, intensity), …. But then expect that the manager will take some action to address current drains on company profitability. [See Argyris & Kaplan, Accounting Horizons (Sept. 1994)] 13. If time is available, you can ask about any changes in compensating salespersons.
With the ABC information, you can move from commissions on sales volume to net operating margins (see Exhibit TN-3). Allow salespeople to sell unprofitable products – but these will not be commissionable, or commissions can be based on net margins generated by salesperson, across all products and customers sold. Allow salespeople to discount when they feel it necessary, and accept small orders for non-standard products. Exhibit TN-1 Wilkerson: ABC Analysis of Flow Controllers at Capacity Total Costs Unit Costs Unit-Level Expenses:
Direct labor$10. 00 Direct materials22. 00 Machine run time 8. 40 Total:4,000 units @$40. 40$161,600$40. 40 Batch-Level Expenses: Setup:100 runs @ $25025,000. Receiving: 100 runs @ $1,000100,000. Pack and Ship: 220 @ $37582,500. 207,50051. 875 Product-Sustaining Expenses: Engineering: 625 hours @ $80 50,00012. 50 Total Expenses: Flow Controllers $419,100104. 775 Product Line Income Statement ValvesPumpsFlow ControlTotal Revenues$645,000$1,087,500$420,000$2,152,500
Unit level expenses300,000581,250161,6001,042,850 (Gross margin53. 5%46. 6%61. 5%51. 6%) Batch level expenses16,25088,750207,500 Product-sustaining20,00030,00050,000 Operating margin308,750387,500900607,150 (Margin %47. 9%35. 6%0. 2%32%) Less: Unused capacity79,900 SG&A559,600 Operating profit57,600 Exhibit TN-2 Cost Analysis of Flow Controllers | Flow Controllers| | | | | | | | | | Cost| | | Percent| | | | | Unit-Level Expenses| Quantity| Driver Rate| Total Costs| Unit Costs| of Costs| | | | | Direct Labor| 1,600| 25. 00 | 40,000 | 10. 0 | 10%| | | | | Direct Materials| 4,000| 22. 00 | 88,000 | 22. 00 | 21%| | | | | Machine Run Time| 1,200| 28. 00 | 33,600 | 8. 40 | 8%| | | | | Total Unit-Level| | | 161,600 | 40. 40 | 39%| | | | | | | | | | | | | | | Batch-Level Expenses| | | | | | | | | | Setup: | 100| 222 | 22,222 | 5. 56 | 5%| | | | | Receive and Production Control:| 100| 1,000 | 100,000 | 25. 00 | 24%| | | | | Pack and Ship:| 220| 375| 82,500 | 20. 3 | 20%| | | | | Total Batch Level| | | 204,722 | 51. 18 | 49%| | | | | | | | | | | | | | | Product-Sustaining Expenses| | | | | | | | | | Engineering:| 625| 80 | 50,000 | 12. 50 | 12%| | | | | | | | | | | | | | | Total Expenses: Flow Controllers| | 416,322 | 104. 08 | 100%| | | | | | | | | | | | | | | Exhibit TN-3 Product Line Income Statement | | | | | | | | | | | | Wilkerson Product Line Income Statement| Percent of Revenues| | | | | | Flow | | | | | Flow | | | Valves| Pumps| Controllers| Total| | Valves| Pumps| Controllers| Total| | Revenues| 645,000 | 1,087,500 | 420,000 | 2,152,500 | | 100%| 100%| 100%| 100%| | Unit Level Expenses| 300,000 | 581,250 | 161,600 | 1,042,850 | | 47%| 53%| 38%| 48%| | Gross Margin| 345,000 | 506,250 | 258,400 | 1,109,650 | | 53%| 47%| 62%| 52%| | Batch Level Expenses| 15,972 | 87,361 | 204,722 | 308,056 | | 2%| 8%| 49%| 14%| | Product-Sustaining| 20,000 | 30,000 | 50,000 | 100,000 | | 3%| 3%| 12%| 5%| | Operating Margin| 309,028 | 388,889 | 3,678 | 701,594 | | 48%| 36%| 1%| 33%| | Less: Unused Capacity| | | | 84,344 | | | | | 4%| | SG&A| | | | 559,650 | | | | | 26%| | Operating Profit| | | | 57,600 | | | | | 3%| | | | | | | | | | | | | | | | | | | | | | | | ——————————————– [ 2 ]. 98% x $600 [ 3 ]. This teaching note was written by Kenneth A. Merchant based partly on notes provided by Robert S. Kaplan.