Calculate the product costs using given activity

Assignment Help Accounting Basics
Reference no: EM13921585

This assignment will assess the following learning outcomes:

• LO1 Analyse costs in business organisations contexts

• L02 Apply cost estimation techniques in a range of business situations

• L03 Evaluate cost and revenue information and costing method for managerial decision-making

• L04 Effectively communicate cost and revenue information in a decision making context. co

ANSWER ALL THE QUESTIONS

Question 1:

ALFIRDOS LTD provides the details of the costs, volume and cost drivers for the three products A, B and C for the year 2015:


A B C Total
Production and sales (Units) 30,000 20,000 8,000
Raw material usage (quantity) 5 5 11
Direct material costs (per unit) 25 20 11 1,238,000
Direct labour hours 1 1/3 2 1 88,000
Machine hours               1 1/3 1 2 76,000
Direct labour cost (per unit) 8 12 6
Number of production runs 3 7 20 30
Number of deliveries 9 3 20 32
Number of receipts 15 35 220 270
Number of production orders 15 10 25 50

The overhead costs are as follows:

Set up costs  30000 OMR
Machines Overheads 760000 OMR
Receiving costs  435000 OMR
Packing costs  250000 OMR
Engineering costs 373000 OMR
  1848000 OMR

The cost drivers for overhead costs are as follows:

Set up costs Number of Production runs
Machines Overheads Number of machine hours
Receiving costs Number of receipts
 Packing costs Number of deliveries
Engineering costs Number of production orders
Total

The company used to allocate overheads to products based on direct labour hours. However, the management noticed that the majority of overheads are more closely related to machine hours than direct labour hours.

Recently, they decided to redesign the cost system by recovering overheads using two volume related bases: machine hours and a materials handling overhead rate of the receiving department. But both current and previous cost system reported low profit margins for product A, which is the company's highest selling product.

After appointing Mr. Khalil as a cost manager, he drew the attention of the management to the benefits of the use of Activity Based Costing and Mr. Khalil Suggested analyzing the overheads of the last period by the major activities in order to compute activity based costs.
Based on the previous information you are required to:

a) Calculate the product costs using a traditional volume related costing system based on the following assumptions:

(i) All overheads are apportioned on the basis of direct labour hours (former costing system)

(ii) The overhead of the receiving department are appointed based on materials handling overhead rate and the remaining overheads are recovered using a machine hour rate.(Current costing system).

(b) Calculate the product costs using activity based costing suggested by Mr Khalil.

(c) Analyse and critically evaluate the differences reported between the product costs in (a) and (b).

Question 2:

KERALA Ltd is a company manufacturing filing cabinets at customer's specific requests without carrying any stock of readymade cabinets. The only stocks held in the stores are raw materials from which the cabinets are produced.

In KERALA Ltd, there are two production departments: Cutting and Assembly. There are also two service departments the Stores and Canteen. All departments are located in the same building.

The information provided below shows the company's budget for the financial year 2015.

Overhead budget for financial year 2015:

Overhead OMR
Factory premises rent (including service departments)  440000
Factory premises insurance (including service departments) 22,000
Sundry expenses (Cutting department)  17,080
Sundry expenses (Assembly department) 8,300
Plant and machinery insurance 7,800
Depreciation of factory plant and machinerY 48,000
Assembly department material 20,000
Indirect labour (including service departments) 352,000
Administration salaries 48,000
Sundry Stores costs 26,740
Canteen costs 59,280
Total 1,049,200

The administration salaries will be apportioned equally to the cutting department, assembly department, and the stores department.

The following information is also provided:

Department Floor area sq meter Indirect labour Direct labour Value of palnt and machinery OMR
Cutting  100,000 12 employees 48 employees 220,000
Assembly 100,000 12 employees 80 employees 50,000

10,000 4 employees 4 employees 10,000
Canteen 10,000 4 employees 6 employees 20,000

Service centre costs are apportioned as follows:

Department Basis
Canteen Total numer of employees 
Stores 70 % for the cutting departement and 30 % for the assembly departement

Kerala Ltd has also budgeted for the following levels of activity for the year 2015:

Department Labour hours Machine hours
Cutting  2,900 4,700
Assembly 4,200 680

Based on the previous information you are required to:

(a) Prepare the overhead analysis sheet for Kerala Ltd for the year 2015.

(b) Using appropriate bases, secondary apportion the service department costs to the production department.

(c) Calculate appropriate overhead absorption rates for the production departments. Justify the choice of cost unit.

(d) Using the rates calculated in question (C) above, estimate the amount of overhead to be charged to batch BB125 that would require the following labour and machine hours:

Department Labour hours Machine hours
Cutting  29 40
Assembly 30 6

The actual overhead cost of Batch BB125 is 10000 OMR.

(i) Calculate and compare the budgeted cost and the real cost of Batch BB125.

(ii) Analyse the causes of the under/over absorption shown in your answer to (i) above. Total

Question 3:

On the PDF page, you will find a testimony of Leon Van Schalkwayk, a Strategic finance executive at Impala Platinum, discussing the importance of management accounting and costing methods in the company.

Based on this testimony, your background in the module and on other academic references (books and articles: bibliography is required a minimum of 15 references), you are required to:

(a) Highlight the importance of management accounting in a company compared to financial accounting.

(b) Explain how, according to you as an accounts manager, Impala platinum was able to reduce costs and drive those costs 20% lower than competitors.

(c) As a management accountant, suggest, explain and critically evaluate a managerial accounting method that will assess the effects of volume changes on a firm's costs, revenues, and profit.

(d) Explain how, using different costing methods, Year Management accounting can show different profit levels for the same year.

Attachment:- Testimony of Leon Van Schalkwayk.pdf

Verified Expert

Reference no: EM13921585

Questions Cloud

Pharmaceutical companies and us consumers benefit : 1. How might US pharmaceutical companies and US consumers benefit from the rise of the Indian pharmaceutical industry? 2. Who might have lost out as a result of the recent rise of the Indian pharmaceutical industry?
Dividend growth rate is expected-current stock price : Your company just paid a dividend of $2.00. The dividend growth rate is expected to be 4% for 1 year, 5% the next year, then 6% for the following year, and a constant 7% thereafter. The stock's required return (rs) is 10%. What is the current stock p..
Health and safety practices plan-occupational safety : Use research, articles, and your text to complete your paper. Identify two injury or illness on-the-job issues related to your chosen company. Evaluate, through research, the issues and the possible effects of those issues regarding the following:
Acquire equipment-operating cost is expected to increase : EI plans to acquire equipment, with a 3-year MACRS life, at a cost of $65,000 and extra $7,500 for delivery and installation. EI expects the new equipment will help in boost its revenue by $40,000 annually for next 4 years and the operating cost is e..
Calculate the product costs using given activity : Analyse costs in business organisations contexts and Apply cost estimation techniques in a range of business situations - Calculate the product costs using a traditional volume related costing system
Explain the seven critical questions a firm needs : Based on the article by Thakur et al. (2006), define a customer relationship management (CRM) system. Identify and explain the seven critical questions a firm needs to answer before implementing a CRM system.
Capital budgeting purposes : Falcon Ridge Developers wants to compute the firm’s WACC for capital budgeting purposes. The firm uses 30% debt, 20% preferred stock and the remainder is in equity. The YTM on the firm’s debt is currently 4.5% and the firm’s marginal tax rate is 40%.
In what ways does the company create value : Choose a company that markets computer products over the Internet (e.g., through a Web search). In what ways does the company create value? Is it likely to capture much of this value? Explain.
Increase the present value of a lump sum future amount : An increase in which of the following will increase the present value of a lump sum future amount? Assume the interest rate is a positive value and interest is compounded.

Reviews

Write a Review

Accounting Basics Questions & Answers

  On february 11 2011 wilmar corporation borrowed 100000 from

on february 11 2011 wilmar corporation borrowed 100000 from its bank by signing a 12 percent 15-year note payable. the

  The cost formula for its materials and supplies is 1990 per

1 the cost formula for its materials and supplies is 1990 per month plus 8 per vehicle. for the month of november the

  As of december 31 gammelguard corporation has outstanding

as of december 31 gammelguard corporation has outstanding accounts receivable of 2.4 million. sales on credit during

  Incorporating time-value-of-money concepts

Incorporating time-value-of-money concepts and information from well-developed personal financial statements, identify your long-term financial goals and discuss the pertinent aspects for realizing these long-term financial goals.

  The sales manager of the walbrook company receives an

the sales manager of the walbrook company receives an annual bonus of 10 of net income after bonus and before income

  At the end of the year actual manufacturing overhead costs

at the end of the year actual manufacturing overhead costs were 170000 and applied manufacturing overhead costs were

  Which is the best course of action

If maximizing net income is the objective, which is the best course of action and show all of your computations.

  When a credit customer returns merchandise to the seller

when a credit customer returns merchandise to the seller under a perpetual inventory system the seller would debit

  Companies usually prepare an adjusting journal entry to

companies usually prepare an adjusting journal entry to accrue warranty expenses. when this is done the warranty

  Describing a secondary group

Which set of characteristics is most applicable to describing a secondary group?

  One of our closest stellar neighboursvega is 58 light years

one of our closest stellar neighbours.vega is 5.8 light years away.it has been suggested that tv programs from our

  How successful a company is at exploiting emerging

how successful a company is at exploiting emerging opportunities and dealing with associated threats depends on

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