John Thomas, vice president of Mallett Company (a producer of a variety of plastic products), has been supervising the implementation of an ABC management system. John wants to improve process efficiency by improving the activities that define the processes. To illustrate the potential of the new system to the president, John has decided to focus on two processes: production and customer service.
Within each process, one activity will be selected for improvement: materials usage for production and sustaining engineering for customer service (sustaining engineers are responsible for redesigning products based on customer needs and feedback). Value-added standards are identified for each activity. For materials usage, the value-added standard calls for six pounds per unit of output (the products differ in shape and function, but their weight is uniform). The value-added standard is based on the elimination of all waste due to defective molds. The standard price of materials is $5 per pound. For sustaining engineering, the standard is 58% of current practical activity capacity. This standard is based on the fact that about 42% of the complaints have to do with design features that could have been avoided or anticipated by the company.
Current practical capacity (at the end of 20X1) is defined by the following requirements: 6,000 engineering hours for each product group that has been on the market or in development for 5 years or less and 2,400 hours per product group of more than 5 years. Four product groups have less than 5 years’ experience, and 10 product groups have more. Each of the 24 engineers is paid a salary of $60,000. Each engineer can provide 2,000 hours of service per year. No other significant costs are incurred for the engineering activity.
Actual materials usage for 20X1 was 25% above the level called for by the value-added standard; engineering usage was 46,000 hours. A total of 80,000 units of output were produced. John and the operational managers have selected some improvement measures that promise to reduce nonvalue-added activity usage by 40% in 20X2. Selected actual results achieved for 20X2 are as follows:
The actual prices paid for materials and engineering hours are identical to the standard or budgeted prices.
Required:
- 1. For 20X1, calculate the nonvalue-added usage and costs for materials usage and sustaining engineering.
- 2. CONCEPTUAL CONNECTION Using the budgeted improvements, calculate the expected activity usage levels for 20X2. Now, compute the 20X2 usage variances (the difference between the expected and actual values), expressed in both physical and financial measures, for materials and engineering. Comment on the company’s ability to achieve its targeted reductions. In particular, discuss what measures the company must take to capture any realized reductions in resource usage.
1.
Calculate the value of accounting costs which is apportion to a backpack before the duffle-bag line was added with the help of plant wide rate approach. Also, identify whether this approach is accurate or not.
Explanation of Solution
Non-Value Added Cost:
Non-value added cost refers to the cash and cash equivalents which are incurred due to the non-value activities or by the ineffective presentation of value-added activities.
Calculation of non-value added usage and costs for 20X1:
Particulars |
Actual Quantity (A) |
Value added Quantity (B) |
Non-value usage (C) |
Standard Price (D) |
Non-value cost ($) |
Materials | 600,0001 | 480,0003 | 120,000 | 5 | 600,000 |
Engineering | 48,0002 | 27,8404 | 20,160 | 305 | 604,800 |
Table (1)
Working Note:
1.
Calculation of actual quantity of material:
2.
Calculation of actual quantity of engineering:
3.
Calculation of value added quantity of material:
4.
Calculation of value added quantity of engineering:
5.
Calculation of standard price of engineering:
2.
Compute the value of expected activity usage levels for 20X2 with the help of budgeted improvements. Also, calculate the value of usage variances for 20X2. Explain the measures that company should take to capture any reductions in resource usage.
Explanation of Solution
Use the following formula to calculate expected activity usage levels for materials:
Substitute $480,000 for value added quantity, 60% for value added activity usage and 120,000 for non-value usage in the above formula.
Therefore, an expected activity usage level for materials is 552,000 pounds.
Use the following formula to calculate expected activity usage levels for engineering:
Substitute $27,840 for value added quantity, 60% for value added activity usage and 20,160 for non-value usage in the above formula.
Therefore, an expected activity usage level for engineering is 39,936 hours.
Calculation of non-value added usage and costs for 20X2:
Particulars |
Actual Quantity (A) |
Expected Quantity (B) |
Excess Non-value usage (C) |
Standard Price (D) |
Excess Non-value cost ($) |
Materials | 584,800 | 552,000 | 32,800 | 5 | 164,000(U) |
Engineering | 35,400 | 39,936 | 4,536 | 30 | 136,080(F) |
Table (2)
According to the above calculations, company is not able to attain the material standard but successfully achieve the engineering standard. The actual consumption of engineering is 35,400 hours and the activity usage is 48,000. Therefore, company is able to create an unused capacity of engineering of 12,600 hours
- Company lay off the six engineers to increase the total profits of the organization by saving the salaries amount of $360,000.
- Company should reassign the activities that have insufficient resources it will also helps to the organization in saving the engineering cost.
Want to see more full solutions like this?
Chapter 5 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
- Kagle design engineers are in the process of developing a new green product, one that will significantly reduce impact on the environment and yet still provide the desired customer functionality. Currently, two designs are being considered. The manager of Kagle has told the engineers that the cost for the new product cannot exceed 550 per unit (target cost). In the past, the Cost Accounting Department has given estimated costs using a unit-based system. At the request of the Engineering Department, Cost Accounting is providing both unit-and activity-based accounting information (made possible by a recent pilot study producing the activity-based data). Unit-based system: Variable conversion activity rate: 100 per direct labor hour Material usage rate: 20 per part ABC system: Labor usage: 15 per direct labor hour Material usage (direct materials): 20 per part Machining: 75 per machine hour Purchasing activity: 150 per purchase order Setup activity: 3,000 per setup hour Warranty activity: 500 per returned unit (usually requires extensive rework) Customer repair cost: 25 per repair hour (average) Required: 1. Select the lower-cost design using unit-based costing. Are logistical and post-purchase activities considered in this analysis? 2. Select the lower-cost design using ABC analysis. Explain why the analysis differs from the unit-based analysis. 3. What if the post-purchase cost was an environmental contaminant and amounted to 10 per unit for Design A and 40 per unit for Design B? Assume that the environmental cost is borne by society. Now which is the better design?arrow_forwardData Master is a computer software consulting company. Its three major functional areas are computer programming, information systems consulting, and software training. Cynthia Moore, a pricing analyst in the Accounting Department, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Moore is considering three different methods of allocating overhead costs: the direct method, the step method, and the reciprocal method. Moore assembled the following data on overhead from its two service departments, the Information Systems Department and the Facilities Department. Service Departments User Departments Info Systems Facilities Computer Program Consulting $ 50,000 $110,000 600 $25,000 400 $75,000 1,100 400,000 200,000 600,000 information systems are allocated on the basis of hours of computer usage; facilities are allocated on the basis of floor space. Required: Allocate the service…arrow_forwardweat ubject - accountingarrow_forward
- The Chief Information Officer (CIO) and the Managing Director (MD) of Illustrious Limited recently had the following conversation regarding the development of a new information system for the company: CIO: The way to go about the analysis is to first examine the old system, such as reviewing key documents and observing the workers performing their tasks. Then we can determine which aspects are working well and which should be preserved. MD: We have been through these types of projects before, and what always ends up happening is that we do not get the new system we are promised. Instead, we get a modified version of the old system. CIO: I can assure you that this will not happen this time. My team just wants a thorough understanding of what is working well and what is not. MD: I would feel much more comfortable if we first started with a list of our requirements. We should spend more time determining what exactly we want the system to do upfront. Then your team can come in and…arrow_forwardThe Chief Information Officer (CIO) and the Managing Director (MD) of Illustrious Limited recently had the following conversation regarding the development of a new information system for the company: CIO: The way to go about the analysis is to first examine the old system, such as reviewing key documents and observing the workers performing their tasks. Then we can determine which aspects are working well and which should be preserved. MD: We have been through these types of projects before, and what always ends up happening is that we do not get the new system we are promised. Instead, we get a modified version of the old system. CIO: I can assure you that this will not happen this time. My team just wants a thorough understanding of what is working well and what is not. MD: I would feel much more comfortable if we first started with a list of our requirements. We should spend more time determining what exactly we want the system to do upfront. Then your team can come in and…arrow_forwardThe Chief Information Officer (CIO) and the Managing Director (MD) of Illustrious Limited recently had the following conversation regarding the development of a new information system for the company: CIO: The way to go about the analysis is to first examine the old system, such as reviewing key documents and observing the workers performing their tasks. Then we can determine which aspects are working well and which should be preserved. MD: We have been through these types of projects before, and what always ends up happening is that we do not get the new system we are promised. Instead we get a modified version of the old system. CIO: I can assure you that will not happen this time. My team just want a thorough understanding of what is working well and what is not. MD: I would feel much more comfortable if we first started with a list of our requirements. We should spend more time in determining what exactly we want the system to do upfront. Then your team can come in and determine…arrow_forward
- The Chief Information Officer (CIO) and the Managing Director (MD) of Illustrious Limited recently had the following conversation regarding the development of a new information system for the company: CIO: The way to go about the analysis is to first examine the old system, such as reviewing key documents and observing the workers performing their tasks. Then we can determine which aspects are working well and which should be preserved. MD: We have been through these types of projects before, and what always ends up happening is that we do not get the new system we are promised. Instead we get a modified version of the old system. CIO: I can assure you that will not happen this time. My team just want a thorough understanding of what is working well and what is not. MD: I would feel much more comfortable if we first started with a list of our requirements. We should spend more time in determining what exactly we want the system to do upfront. Then your team can come in and determine…arrow_forwardData Performance, a computer software consulting company, has three major functional areas: computer programming, information systems consulting, and software training. Carol Bingham, a pricing analyst, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Carol is considering three different methods of the departmental allocation approach to allocate overhead costs: the direct method, the step method, and the reciprocal method. She assembled the following data from the two service departments, information systems and facilities: Service Departments Production Departments Information Systems Facilities Computer Programming Information Systems Consulting Software Training Total Budgeted overhead (base) $ 368,000 $ 184,000 $ 736,000 $ 874,000 $ 575,000 $ 2,737,000 Information Systems (computer hours) 600 1,200 300 900 3,000 Facilities (square feet) 240 960 600 600…arrow_forwardBriefly explain two (2) potential pitfalls encountered in the design of performance indicators and measurement systems.arrow_forward
- Ashvinarrow_forwardThe activity-based costing (ABC) system has been used by manufacturing companies for a long period of time. Recently, the ABC system has been used by banks, insurance companies, not-for-profit organizations, government agencies, and service companies. Assume that you were hired as a cost accountant to develop a plan to implement the ABC system for one of these service organizations. Create an ABC system development plan, including detailed steps needed to effectively implement the system. Then present the plan in the discussion. Response should include: A brief background on the organization's main activities. Whether there will be any limitation on implementing the ABC system in the organization selected.arrow_forwardSusan Mills, Company B's chief accountant, has developed an automated costing system that helps track the cost of production activities. This system is capable of accurately measuring and allocating post-manufacturing activities, such as selling, promotional, and distribution activities, in such a way where Company B gets a more detailed view of its product costs. One of the benefits of this system is that it allows Company B to determine which product lines are more profitable. When Susan implemented the new costing system, she realized that the company's current period profits would increase significantly if the new product cost information was used for inventory valuation on the financial statements. Susan has been under intense pressure to improve the company's profits, and this would be a quick and effective way for her to help meet the company's short-term profit goals. As a result, Susan has decided to use the automated costing system to determine the company's profits.…arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub