Determine the overhead activity cost allocations to products

Assignment Help Business Management
Reference no: EM131496709

1. Anderson Ltd. manufacture gearboxes for use in cars. At the start of the year, the management of Anderson Ltd. estimated that its costs would be:

 

% of sales value

Direct labour

8

Direct material

50

Variable production overhead

8

Fixed production overhead

12

Administration overhead

5

This was based on the following: 80 employees
2000 hours worked by each employee
40 000 gearboxes manufactured in the year as budgeted production
£200 unit selling price.

You have recently been employed by the company to establish a standard costing system. At the end of the year you were able to extract the following information:

- labour costs £4.40/hour
- 32 000 units sold
- £210/unit selling price
- 160 000 hours were worked
- variable production overheads were £640 000
- fixed production overheads were £810 000
- administration costs were £350 000
- raw material prices were 10% higher than expected
- total expenditure on raw material was £3.696 M
- there were no opening or closing stocks of raw materials.

(a) You are required to prepare an operating statement for the year, using a standard absorption costing system.

Calculations should proceed according to the following headings suffixing ‘A' for Adverse and ‘F' for Favourable where appropriate. Resulting quantities required for the statement are then entered in the ‘Operating Statement for the Year' sheet shown on page 6.

(All working must be shown.)

(Budgeted) Costs


Direct labour                                          Unit cost
                                                                    £

Direct materials

Variable overhead

Fixed overhead

Admin. overhead Total
Selling price

Standard profit (per unit) Budgeted profit

Sales price variance Sales quantity variance

(These last three entries are added to the ‘Operating Statement for the Year' on the final sheet of the calculations.)

Cost Variances Labour Variances Standard hours =

Standard cost/hour =

Rate variance =
Standard time =

Actual time =

Time variance = Efficiency variance =
(Add rate and efficiency variances to ‘Operating Statement for the Year' on the final sheet of the calculations.)

Material Variances

Material price =

Material usage - standard =
- actual

= Material usage variance =
(Add price and usage variances to ‘Operating Statement for the Year' on the final sheet of the calculations.)

Variable overheads Standard cost = Actual cost =
Expenditure variance = Efficiency variance =
(Add expenditure and efficiency variances to ‘Operating Statement for the Year' on the final sheet of the calculations.)

Fixed overheads Expenditure variance = Volume variance =
(Add these variances to ‘Operating Statement for the Year' on the final sheet of the calculations.)

Admin overhead (treat as fixed) Expenditure variance =
Volume variance =

(Add these variances to ‘Operating Statement for the Year' on the final sheet of the calculations.)

Operating Statement for the Year

                                               £'000                                 £'000

Budgeted Profit

Sales variance - price
- quantity

Cost variances

Labour - rate
- efficiency

Material - price
- usage

Variable - expenditure
- efficiency

Fixed - expenditure
- volume

Admin - expenditure
- volume

Actual Profit

(b) Give reasons/explanations why the variances in (a) above have occurred for the following:

(i) material price
(ii) labour efficiency
(iii) fixed overhead expenditure.

(c) The accountant suggests that a standard marginal costing system may be more suitable. He asks you to outline the strengths and weaknesses of both systems and recommend the most suitable.

(d) The Board of Anderson Ltd. want to adopt ‘ideal' standards because they feel it will encourage harder work. You are asked to produce a brief report giving your views.

2. (a) For the following categories of activities assign an appropriate cost driver from the list provided against each activity in TABLE 1.

Cost Drivers:

- Cost of Inspection/Test
- Machine use hours
- Direct Labour Hours
- Number of Purchase Orders
- Number of Production Runs
- Material Delivery/Invoices.

Activities to produce product

Cost Drivers

Activity Centre 1 Machining

 

Activity Centre 2 Machining

 

Product Assembly

 

 

 

Materials Procurement Activities

 

Product Materials Purchased

 

Material Reception/Storage

 

Materials Issued/Production Run

 

 

 

Support Activities

 

Production Planning

 

Machine Setting Up/Tooling

 

Statistical Quality Control

 

TABLE 1

(b) TABLE 2 shows the cost drivers, the quantity and unit cost of the cost driver, and total activity cost.

For two products A and B it is found that:

- The direct labour hours for products A and B are the same.

- It takes approximately four times as many machining hours in both cost centres to produce product B as product A.

- Product A requires one quarter of the materials purchased for B.

- Product A requires one third of the total Delivery notes/invoices.

- Product A has issued one third of the total materials issued per production run.

- Product A has issued one half of the planning per production run of that required by Product B.

- Product B requires twice as many machine set-ups as product A.

- The products have the same number of quality control inspections.

If the company produces 50 000 each of products A and B:

(i) Complete TABLE 2 to determine the cost driver unit costings in column 5 for the activities of column 1. Show also the product quantity splits in column 4 of each activity for product A and B (e.g. quantity of cost driver Activity Centre 1 is shown as split 100 000 product A and 400 000 product B).

(ii) Determine the overhead activity cost allocations to products A and B (using the activity proportions calculated in column 4) by completing TABLE 3.

(iii) Determine the total overhead allocations to products A and B.

(iv) Find the per unit product overhead cost allocations for each product.

 

Activity involved to Produce Product

Allocated Cost of Activity

£

Activity Cost Driver

Quantity of Cost Drivers

Cost Driver Unit cost/rate per Cost Driver £

Activity Centre 1 Machining

750 000

Machine Use hours

500 000

(100 000 prod A

400 000 prod B)

 

Activity Centre 2 Machining

500 000

Machine Use hours

250 000

 

Product Assembly

400 000

Direct labour hours

100 000

 

 

 

 

 

 

Materials Procurement Activities

 

 

 

 

Product Materials Purchase

 

600 000

 

Purchase Orders

 

5000

 

Product Material Reception/Storage

240 000

Number of Invoices or Material Delivery Notes

3000

 

Materials Issued/Production Run

225 000

Number of Production runs

1500

 

 

 

 

 

 

Support Activities

 

 

 

 

Production Run Planning

150 000

Number of Production runs

1500

 

Machine Setting Up/Tooling

30 000

Setting up/tooling labour hours

750

 

Statistical Quality Control

10 000

Sample inspection and Test Cost

400

 

Total

 

 

 

 

Verified Expert

Public limited company got added advantage of their brand which pull investors’ confidence over inventions and product development. They can use any channel options to advertise and market initial invention and try to create fund for completing product under research and development section. Once invention identified as useful for customer and show positive sign for future profit. Company associated with it look for following step: • Calculation of Retail Price • Estimation of cost of manufacturing • Determination of expected profit margin. • Current alternatives and future demand.

Reference no: EM131496709

Questions Cloud

Describe the supply chain : Consider a consumer product such as a bicycle - choose a popular model from one of the larger more famous brands and investigate its manufacturing process.
Create a working group between information technology : One of your first actions to improve the security program is to create a working group between the Information Technology, Engineering.
Selecting low-cost suppliers : Complete projects significantly under budget by selecting low-cost suppliers, which may have an adverse effect on project quality.
What does quality actually mean : The middle-aged mother buys clothes at Zara because they are cheap, while her teenage daughter buys there because they are in fashion.
Determine the overhead activity cost allocations to products : Determine the overhead activity cost allocations to products A and B (using the activity proportions calculated in column 4) by completing TABLE
Explores professional ethics and responsibilities : Explores professional ethics and responsibilities.You may use the slide notes function to explain slide contents as necessary.
Identify service elements attached to purchase of products : Review some consumer goods such as mobile phones, cars and kitchen appliances. Identify the service elements attached to the purchase of these products.
Discuss foreign market that the company should enter : Identify and discuss the foreign market that the company should enter and discuss the strategy it should use to enter the market.
What are the effects of nomophobia : What are the effects of Nomophobia? Does this vary from country to country? Age group to age group? Socio-economic status? Occupation?

Reviews

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

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