ACC3015
Assignment
2014-15
ACC3015 - Assignment 2014/15
Please attempt all questions, this coursework represents 60% of your total mark for the module. Submit online only through NILE by 3rd April 2015
Maximum word count - 2,500
Case Study
You are a financial consultant employed by NENE Limited and they require you to answer the following questions. You are expected to write an academic essay of up to 2,500 words addressing these questions. You are expected to explain your calculations using detailed notes, where applicable, and carry out academic research to develop your discussion (cite references).
Question 1
The directors of NENE limited are considering two mutually exclusive investment projects. The company has
…show more content…
There are three models manufactured in the factory: A, B and C. The models, their quality and their price are aimed at different markets.
Product costs are computed on a blanket (business-wide) overhead-rate business using labour hour method. Prices as a general rule are set based on cost plus 20%. The following information is provided.
A
B
C
Material cost (£/Unit)
25
62.5
105
Direct Labour Hours (per unit)
½
1
1
Budget Production / sales (units)
20,000
1,000
10,000
The budgeted overheads for the business amounted to £4,410,000. Direct Labour is costs at £8 per hour.
The business is currently facing increasing competition, especially from imported goods. As a result, the selling price of A has been reduced to a level that produces a very low profit margin. To address this problem, an activity based costing approach has been suggested. The overheads are examined and these are grouped around main business activities of machining (£2,780,000), Logistics (£590,000) and establishment (£1,040,000) costs. It is maintained that these costs should be allocated respectively on cost drivers of machine hours, material orders and space, to reflect the use of resources in each of these areas. After analysis, the following proportionate statistics are
“Auerbach Enterprises uses machine hours as the cost driver to assign overhead costs to the air conditioners. The company has used a company-wide predetermined overhead rate in past years, but the new controller, Bennie Leon, is considering the use of departmental overhead rates beginning with the next year. “(Schneider, 2012). One product is affected more than the other by use of departmental rates rather than companywide rate.
Glaser Health Products manufactures medical items for the health care industry. Production involves machining, assembly and painting. Finished units are then packed and shipped. The financial controller is interested to introduce an activity-based costing (ABC) system to allocate (or distribute) indirect costs to products. Indirect costs, as distinct from direct costs, cannot be unambiguously linked to specific products. The controller would like to calculate product costs based on ABC for planning and control, not inventory valuation.
Overhead costs include rent, office staff, depreciation, and other. Once the flexible budget was complete, variances between the actual and flexible budget could be calculated (Exhibit B). The variance for frame assembly was favorable with actual costs being $82,663 less than in the flexible budget. The variances for wheel and final assembly however were both unfavorable. Wheel assembly had an unfavorable variance of $50,650, while final assembly variance was the highest at an unfavorable variance of $231,200. Taking into account these three aspects of direct cost, direct cost has an unfavorable variance $199,187. Although most overhead costs are fixed, 2/3 of other costs are variable and increase with the increased production. As shown in Exhibit B, overhead variance is unfavorable at $60,000. The direct cost variance and overhead variable together lead to a total unfavorable variance of $259,187.
Develop and diagram an activity based cost model using the information in the case. Provide your best estimates about the cost and profitability of Wilkerson’s three product lines. What difference does your cost assignment have on reported product costs and profitability? What causes any shifts in cost and profitability?
The purpose of this report is discussing the case of Wilkerson Company that confronting tough competition in price cutting in pumps which caused to a big drop of pre-tax operating income from 10% to 3%. After observing the existing costing allocation, we found out there is an issue on the existing costing report that the manager could not be able to see the real situation. In light of this, there will be brought to the discussion on the feasibility of using an alternative costing method – Activity based costing (ABC) in the latter paragraphs.
Coursework is receipted on the understanding that it is the student's own work and that it has not, in whole or part, been presented elsewhere for assessment. Where material has been used from other sources it has been properly acknowledged in accordance with the University's Regulations regarding Cheating and Plagiarism.
The above graph suggests that volume based computation of overhead costs does not reflect the real overhead costs based on actual production per product line (computed maximum in excess over actual). On the other hand, if we follow the allocation of overhead costs based on prime costs as illustrated in Exhibit 2 of the case, we need to consider other quantitative factors: 1. No data is available to determine the amount of raw materials used in producing each of the products. While we can assume that the production of small, colored glass ornaments uses fewer raw materials (e.g. glass) than large, colored glass ornaments, the amount of glass used to produce specialty ornaments cannot be derived from the facts of the case. 2. There is also no data available to determine the number of direct labor hours consumed for producing each product type, although evidently, specialty ornaments use more direct labor hours. Based on the above considerations, we deem it inaccurate to base overhead on prime costs, a common practice in traditional costing. In addition,
The method showed that the pricing that was being used for the three products were not correct. The price at which the pumps were being sold was low were high whereas flow controllers were low. Because of which the most profitable product was coming out to be flow controllers whereas it was actually the least profitable.
Nowadays, we know that activity based costing system assigns overhead costs to products or services products that using a two-stage process, which focuses on activities. ABC is a relatively new and very important topic in managerial accounting. ABC allows us to find a way that we could determine the profitability of every product, profitability of every customer we serve, and the profitability of our process. Contents in brief, first that comparing potential advantages of ABC versus traditional costing methods. The
Activity-based management, activity-based costing and continuous improvement, all these help in the improvement of the efficiency in manufacturing, better control of overhead costs and the accurate costing of products. With this in mind, We disagree with the advice that Chuck Davis, the firm’s controller, gave Leonard Bryner. The traditional way of costing produce average costs that severely overstated or understated. Without the accurate costs, the firm would not be able to price properly their products and that would be damaging to the firm. With activity-based costing and management, all costs are accounted for with the help activity-drivers and overhead costs are decreased. In turn, the costs that the firm has for their products are more accurate and pricing is much easier.
This paper provides a brief presentation of Activity-Based Costing methodology, how is used as well as its short comings.
Decision Making Area 3:Investment Decisions * Table of Articles * Summary of Articles * Observations * Conclusion
1. Tutti’s Sandwich Shop has the following information regarding costs at various levels of monthly sales. Help Tutti separate her costs into fixed costs and variable costs so that she can predict and evaluate costs at varying levels of guests served.
This is the final course assignment. When completing this assignment, keep in mind it is intended to capture the many concepts addressed in this course. As such, do not limit your content to just one aspect of the course. Also, be sure to write the essay as a scholarly assignment meaning there should be liberal use of citations of the course texts and notes in completing the assignment.
By resolving these issues, we can come up with a recommendation that will justify the Sales Department’s need to adjust the current selling prices of their products.