Question
WireBuzz Ltd has been operating in the competitive electronics industry for over twenty years. The company produces a range of electronic systems and a few
WireBuzz Ltd has been operating in the competitive electronics industry for over twenty years. The company produces a range of electronic systems and a few years ago, began manufacturing several different types of wall key pad systems where now two of these, account for the majority of the company's sales. This case focuses on these two types of wall key pad systems: the simple push button pad (PBP) and the LCD wireless touchscreen pad (LWTP). PBP has been the more common product in the industry for several years. The market for this product is quite competitive and price sensitive. WireBuzz plans to sell 62,000 units in the 2021/2022 year at $170 each. LWTP is a recent addition to the Company's product line. This product is different to PBP namely, it incorporates technology that is more sophisticated and the materials used in its production are different to those used for PBP. As such, management has decided to sell LWTP at a premium price. The sales budget for 2021/2022 includes the sale of 35,000 units at $340 each. In addition, there is no beginning or ending inventory budgeted for the year.
The management team at WireBuzz usually meet to discuss key issues affecting the company. Since the company's profitability over the couple of years has not met expectations, the decision was made to schedule monthly meetings. Hence, beginning with the current month the next few meetings will focus on discussing strategies to increase the company's overall profitability in 2021/2022. In the first meeting, the main topic that management focused on was how to spend the sales and promotion dollars for 2021/2022. During the meeting Kane Fang, the National Sales Manager, said "I believe the market share for PBP could be ACC/ACF2200 Management Accounting Assignment 3 expanded, by concentrating WireBuzz's promotional work in this area". In response to this suggestion the Production Manager, Toni Price shook her head and said, "I disagree. I believe the company should go after a bigger market for LWTP. The costing sheets that I get show the contribution from LWTP is greater than the contribution from PBP. As we get a premium price for LWTP, focusing on expanding its sales should help overall profitability".
WireBuzz currently uses a traditional costing system. Budgeted direct materials costs are $10,830,000 in total, for production of the two types of wall key pads with $5,580,000 being the total budgeted cost for PBP direct materials. Direct labour is budgeted at $20 per direct labour hour (DLH). The company expects to use 4 DLH and 2 machine hours (MH) for each LWTP unit and 1.5 DLH and 1 MH for each PBP unit produced.
This traditional costing system was developed a number of years ago when the company first commenced operations and uses three types of manufacturing overhead: material-related overhead, variable manufacturing overhead and machine-related overhead. WireBuzz applies a material handling charge at 15 percent of direct materials cost, which is not included in variable manufacturing overhead. Variable manufacturing overhead is applied on the basis of direct labour hours. For 2021/2022 the budgeted variable manufacturing overhead rate is $5/DLH. In addition, machine-related overhead is applied on the basis of MH and is budgeted at $22/MH.
Jane Web the Company's Financial Controller, who recently joined the company, had previously worked in another company that used a different costing system which was predominately based on the principles of Activity Based Costing ACC/ACF2200 Management Accounting Assignment 4 (ABC). Upon having reviewed WireBuzz's past financial reports and costing information Jane became sceptical about the accuracy of the costing data for both PBP and LWTP. Based on her experience with ABC and the uncertainty she had, Jane made a recommendation to the management team during the first meeting. She recommended that before the group proceeded with the discussion about allocating sales and promotional dollars to individual products; it may be worthwhile to look at these products on the basis of the activities involved in their production. Jane further explained, "using this information, we can calculate an activity-based cost for PBP and LWTP and then compare each to the traditional costing we have been using". She also suggested at assessing the activities involved in production. The management team all agreed that Jane and her team should go ahead with the activity analysis she suggested and present back the results.
Subsequently, Jane and her team conducted an activity analysis and identified that the original three overhead categories used under the traditional costing system involved a series of different activities. Approximately 20% of material related overhead involved the procurement of material components; 18% involved the scheduling of production for the PBP and LWTP wall key pads; 15% involved moving materials around the production facility and the remaining overhead was incurred for packaging and shipping of the wall pads. Quality control accounted for 45% of the variable manufacturing overhead and involved ensuring that finished wall pads conformed to the design specifications for each type. The other variable manufacturing overhead comprised of: setting machines up in preparation for production; disposing of waste; and ordering and maintaining general supplies, which are used in producing the completed wall pads. These were incurred in the ratio of 0.7: 0.25: 0.05 respectively. Machinerelated overhead, was now considered a conversion cost, and involved machine soldering of the PBP and LWTP wall key pads and inserting material components into each PBP and LWTP wall key pad. The cost of soldering the wall pads ACC/ACF2200 Management Accounting Assignment 5 amounted to $634,800. Inserting material components into the wall key pads was a different process, where some of the material components were inserted by machines, and accounted for 30% of the activity cost pool. Other material components involved a more manual insertion process where a number of employees manually inserted individual components into the wall key pads. As a result of this analysis, Jane concluded that the direct labour category was no longer relevant and she also established that the only cost that would remain the same under both the traditional costing method and the ABC method is the cost of direct materials.
Jane and her team also identified information specific to PBP and LWTP. Each PBP wall key pad required two machine setups whilst each LWTP wall key pad required eight setups. A total of forty-six components were used to produce the PBP and LWTP wall key pads. Of these, thirty-four specific components were used in the production of each LWTP wall key pad and fifteen of these components were manually inserted onto the LWTP wall key pad by assembly line employees. The remaining components were used in the production of each PBP wall key pad and assembly line employees manually inserted five of these components onto each PBP wall key pad. Materials were moved three times for each PBP wall key pad and nine times for each LWTP wall key pad. Both types of wall key pads passed an inspection process which involved a total of ten inspections where 20% of these were for each PBP wall key pad and the remaining inspections were for each LWTP wall key pad. A total of 0.60kg of waste would arise from the production of one PBP wall key pad and one LWTP wall key pad, and approximately 15% of this came from the production of each PBP wall key pad.
As part of the analysis, Jane and her team also identified a number of activity cost drivers.
COST DRIVER
Number of Wall Key Pads
Number of Components
Number of Material Moves
Number of Setups
Number of Inspections
Number of Insertions**
Kilograms of Waste
** manual insertions
**machine (automated) insertions
Using the information provided design a new costing sytem based off the principles of Activity Based Costing (ABC) and calculate the total and unit cost for both the LWTP and PBP using the designed system (show all working)
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