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

  According to many articles written on the subject the

according to many articles written on the subject the corporate world of the united states has been whacking away at

  What is the amount of cash collected from customers

Sage Company had a $300,000 balance in Accounts Receivable on January 1.The balance in Allowance for Bad Debts on January 1 was $36,000. Sales for the year totaled $1,700,000. All sales were credit sales.

  Evalute the performance of canadian subsidiary

Critically evalute the performance of Canadian Subsidiary if the following data summarizes. Net investment is calculated as total assets less allsubsidiary

  Lenter supply company is a medium-sized distributor of

lenter supply company is a medium-sized distributor of wholesale hardware supplies in the central ohio area. it has

  Preparing a well organized and formatted schedule

Sue ask for you to prepare a well organized and formatted schedule showing what the variable manufacturing cost is as a percentage of total sales for each of the three product sales for 2007.

  You assemble the following information for henderson

you assemble the following information for henderson department store which computes its inventory under the

  Interest expense on the income statement relates to the 15

income statement for the year ended december 31 2011

  Income statement-disclosed net of tax

Which of the following items on the income statement is not disclosed net of tax?

  Management of financial institutions questions

Identify two financial intermediaries. What are their respective functions? What are their major roles in the economy? What are the money markets and what are the capital markets? How do they differ? What are their respective activities?

  When the project concludes in four years the working

oakmont company has an opportunity to manufacture and sell a new product for a four-year period. the companys discount

  Formula for computing book value per share

The ledger of JFK, Inc. shows common stock, common treasury stock, and no preferred stock. For this company, the formula for computing book value per share is?

  Assume that you are the ceo of a small but growing business

assume that you are the ceo of a small but growing business and have decided that it is time to expand the business

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