Free Essay

Abc Costing

In:

Submitted By 01varshu
Words 8613
Pages 35
Available online at www.interscience.in

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study
1

Seema G. Bhol, 2Arun Mishra & 3Srikanta Patnaik Sambalpur University, Burla, Orissa, India, 2Head (IT Services), L&T, Kansbhal, Orissa, India, 3 Department of Computer Science ITER , SOA University , Bhubaneswar, Orissa, India E-mail : guptaseema@hotmail.com, arun-kbl@kbl.ltindia.com, patnaik_srikanta@yahoo.co.in

1

Abstract - One need to be very accurate in what the products and services are costing. Inaccurate cost components could cost an organization more dearly. So, to full fill our present and future requirements and ambitions in all respect of life, it is essential enhance our expertise to link the power of today's information technology with the tools of economic theory and business strategy.[2] This paper aims at throwing new lights on various developments and formulate strategy for their implementation. Keywords— Business Mapping Report (BMR), Product costing, Dataflow Diagram, Enterprise Resources Planning (ERP), cost overhead, cost centres, Cost variance report, WIP.

. 1. INTRODUCTION businesses, non-profit organizations and governments now all utilize ERP systems. The use of erp module saves time and money without sacrificing accuracy and control. Product costs are analysed quickly and accurately, which empowers the organization with the ability to perform minute analysis and projections of product cost. Few of the many advantages of product costing are: • • • • • Streamlined integration Enhanced data accuracy Powerful cost analysis Automated cost calculation Extensive instant reports

Businesses all around the world are increasing their reliance on ERP programs as a cost efficient alternative to their current manual procedures or their piecemeal software applications. [1] ERP (enterprise resource planning) is an industry term for the broad set of activities supported by multimodule application software that help a manufacturer or other business manage the important parts of its business, including product planning, parts purchasing, maintaining inventories, interacting with suppliers, providing customer service, and tracking orders. Enterprise Resource Planning (ERP) systems attempt to integrate all data and processes of an organization into a unified system. A typical ERP system will use multiple components of computer software and hardware to achieve the integration. A key ingredient of most ERP systems is the use of a unified database to store data for the various system modules. [7] MRP vs. ERP — Manufacturing management systems have evolved in stages over the past 30 years from a simple means of calculating materials requirements to the automation of an entire enterprise. Around 1980, MRP (Material Requirement Planning) was evolved into a new concept: Manufacturing Resource Planning (or MRP2) and finally the generic concept Enterprise Resource Planning (ERP).[1] [7] ERP systems now attempt to cover all basic functions of an enterprise, regardless of the organization's business or charter. Non-manufacturing

Product costing module in ERP has eased out all hassles of costing a manufactured product. Product costing module uses data for valuation from the Production planning (PP) module. The Manufacturing module defines the production process, calculates and tracks product and job cost, and records all of the activities necessary to manufacture products. Stages of the manufacturing are consolidated into a process specification. Actual cost rollups with in the process specification are compared to standard job cost for each lot or batch produced. All manufacturing-related activities (including issue of materials which automatically decreases inventory balances, recording of production outputs which increase inventory balances) are tracked and charged to a Job, thereby determining actual job cost and variances. General Ledger journal

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

entries automatically created for all transactions. And the lot trace information is recorded from the manufacturing activities. Among the many benefits of ERP is that data need only be captured once.[4] Typically this originates outside of the enterprise and is often communicated via paper documents. Examples include sales orders, supplier invoices, credit notes, delivery notes, remittance advice and every imaginable type of form. And as data entry volumes continue to grow, costs continue to rise and opportunities for savings become more apparent. By capturing data at source, an organisation loses the costs associated with manual data entry, improves capture cycle times and eliminates errors due to rekeying but in reality businesses continue to create and consume paper. Organisations can decide to implement an EDI program with its suppliers. Another option is to use data capture and document recognition software to replace or complement manual data entry. This class of solution will read data from paper using OCR/ICR and upload directly to information systems with greater accuracy and at a fraction of the cost of human operators.[4] The competitive forces prevailing in the world of commerce today require firms to operate as efficiently and productively as possible in order to maintain and enhance market share, profitability and shareholder value. An essential element to achieving success involves the continuous enhancement of knowledge and understanding of the business environment by employees at all levels. This can be accomplished by implementing processes which augment the accessibility and communication of value added information throughout the organization. As a result there has been an increased demand for cutting-edge information technology by businesses in all industries. 2. Brief Description of Larsen & Toubro Limited (L&T)

Kansbahal Works, a unit under the Machinery & Industrial Products Division of L&T, is an Integrated Machine Building Centre with facilities for Casting, Fabrication, Machining and Assembly, complimented by excellent design, engineering, quality control and logistics support. Set up in 1962 as an Indo-German Venture, it merged with L&T in 1982. The business portfolio includes Crushing and Screening systems, Pulp & Paper machinery, Wind mill components, Cast products and various other industrial products. L &T's only foundry facility is located at Kansbahal and is equipped with the latest state-of-the-art facilities to manufacture quality castings in steel, alloy iron, SG/ cast iron, with intricate geometries and large tonnages. L & T Kansbahal Works have complete in-house facilities like technology centre, pattern shop, hand and machine moulding facilities, melting and heat treatment facilities, and complete QA tools. Machine Shop is equipped with a wide range of machines for Turning (upto 3.5 m dia x 10 m long) , Boring (10 m x 5 m x 2.2 m with 65 T table capacity), Cylinder Grinding (2.5 m dia x 10 m long) and Planning (2 m x 1.6 m x 6 m) of complex welded structures/ castings / forging.. LRIS qualified welders deal with a variety of materials such as carbon steel, low alloy steel, nickel alloys confirming to the different international standards. The Kansbahal Works R&D wing is equipped to carry out process engineering, mechanical design / analysis, 3D modelling, Finite Element Analysis, basic and detailed engineering. A team of 60 highly experienced and qualified engineers focus on customized product development. A dedicated cell called Crushing Technology Centre caters to design and developments of crushers and surface miners. The Quality System in L & T has been designed and adapted in accordance with ISO 9001. L&T Kansbahal Works have acquired quality accreditation ISO - 9001 certified by DNV and approved by Lloyds Register of Shipping, London and TUV for pressure tested castings CBB (Central Boiler Board) as "Well Known Foundry". L&T’s belief that progress must be achieved in harmony with the environment lead to a commitment to community welfare and environmental protection as an integral part of the corporate vision. 3. Business Analysis Report

Larsen & Toubro Limited (L&T) is a technology, engineering, construction and manufacturing company. L&T has an international presence, with a global spread of offices. The company has manufacturing facilities in India, China, Oman and Saudi Arabia. It has a global supply network with offices in 10 locations worldwide, including Houston, London, Milan, Shanghai, and Seoul. Customers include global majors in over 30 countries. It is one of the largest and most respected companies in India’s private sector. The company's businesses are supported by a wide marketing and distribution network, and have a strong customer support.

The Business Survey Document is prepared based on the discussions with users, study of reports, study of existing system and study of present customer, business processes and practices. This also documents solutions to the requirements. Human Resource Management System (HRMS) has two components namely personnel and training.

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

All the financial transactions involve either a receipt or payment of money resulting in accounting entries. Payments made towards expenses are either relating to manufacturing or administrative activities. In financial accounts, the expenses incurred for a specific purpose are recorded in total under an account code no allotted for the purpose. In cost account it is analyzed the expenses by various departments /cost centres and allocating them wherever necessary. The expenses incidental to manufacturing, form part of product cost. This is done through predefined overhead recovery rates. Manufacturing operations involve consumption of raw materials and consumables and through separate issue notes the cost of materials consumed for production gets established. Costing, Budgeting and MIS is a section of Accounts department, which is responsible for costing of jobs, budgeting activities of different cost centres and generating reports for management information. Material Accounts is another section, which deals with material accounting and perpetual inventory system. The material Accounts and the financial accounts are not integrated at L & T Kansbahal. The transactions at material ledger do not hit any Financial Accounts. RMC (Raw Material and Component) Ledger is generated only at Kansbahal level.



Cost Of Sales: cost of sales is the total cost incurred for an Item, which is to be sold. It is compared with the selling price to get the margin. Finished Goods: It is the inventory held for sale.



3.2 Material Accounting Material Accounting department maintains three ledgers to integrate with Financial Accounting. These ledgers are: • • • Inventory Ledger WIP Ledger FG ledger

Material Accounting maintains three following database systems: • • • 1. Financial System Material Accounting System Costing System

Items are divided in two groups Stock items- Items which are routed through inventory, and for which entries are passed in RMC ledger. Non-Stock items –Items that are not routed through inventory, but directly debited to projects. Hence no entry is passed in RMC ledger. However, for imported non –stock items, the transactions are routed through inventory ledger (Where MAR and PMI are sent together). Input of the Process: 1.MAR (Material Arrival Report) 2.PMI (Production Material Issue Note) 3.GMI (General Material Issue Note) Output Of the Process: 1.Material Ledger 2.Analysis Of Inventory

2.

3.1 Existing System Currently Costing Department is using ‘Job Costing & WIP System’ for followings transactions: • • Labour Cost Accounting: Calculation of labour cost as per the overheads for respective shops. Material Cost: Material Cost Accounting as explained below. All the PMI details, Direct Material Expenses, Direct Debits etc. Captive Cost Transfer: In case of Captive Orders captive cost is booked against respective business unit (Foundry or Industrial Machinery) Job Time Card: Direct labour booking in all shops for total labour hours booked in a particular order. Monthly Stores credit Entry: Once the FGN is prepared by a shop the jobs is Store credited and Monthly Store Credit Entry is done in the system. WIP Ledger: WIP ledger is maintained for ongoing orders which gives the Work In Progress for Individual order



• •



3.2.1 Material Receipt Following is the procedure for Material receipt: 1. Material can be of two types, i.e., Non stock and stock

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

2. 3.

MAR (Material Arrival Report) is prepared once the material is recd in the stores Copy of MAR is sent to material accounts department if MAR is for stock type or non-stock type imported items. Material Accounts sends MAR to Accounts Payable group for supplier's bill Accounts Payable group sends the MAR back to Material Accounts with copies of Supplier's bill The MAR is priced by Material accounts group, based on Supplier's bill. If Bill is not available, PO rate is used to price the MAR At the end of the month, the priced material is run for generating material ledger, and the list of priced MAR is available to Accounts for verification Such priced MAR does not generate a financial entry. The inventory Account is updated by Accounts Payable group by voucher booking

iii. Material Cost For Melting Material iv. Material Cost Of Non-stock Items v. Material Overheads vi. WIP Interest
Labour Fixed Overhead for:

4. 5. 6.

1. Pattern Making 2. Molding Shop
Labour Variable Overhead for:

1. Molding 2. Melting 3. Fettling 4. Heat Treatment 5. AOD
Material Cost For Melting Material: Actual Melting Cost For Melting Material as per the Monthly Melting Statement Material Cost For Non-stock Items: Non-stock items are directly debited to the SWO 3.3.2 Foundry Overheads 1. 2. 3. 4. 5. Machine cost in case of furnaces in H.T & Melting Labour Cost in fettling, H.T., Melting Additional costs like: Electricity & oil Depreciation Material cost in case of Molding Shop as per the Standard norms decided in Budget. Also in case of Pattern Making Shop material cost is taken care by the Overhead rates.

7.

8.

3.2.2 Material Issue Following is the Procedure for Material Issue1. The issue from stores can be through two documents-PMI (Production Material Issue Note) and GMI (General Material Issue Note) PMI is made for items issued to specific Work order, GMI is made for items to cost centres PMIs and GMIs are sent to Material Accounting Group, where it is entered into Material Accounting System PMIs and GMIs are priced at weighted average method by the system and Material ledger is updated at the end of the month The PMIs and GMIs do not pass any financial entry by themselves. At the end of the month, All PMIs and GMIs are consolidated and an IV is prepared by Material Accounts, with appropriate accounts (This is the consumption entry), and it is sent to Accounts for entering into the financial system.

2. 3.

4.

5. 6.

These overheads are arrived at on the basis of previous experience and the budget for the current year. 3.3.3 Calculation of Labour and Machine Overheads In the existing system the Labour & Overheads rates are defined for following various cost centres in case of Foundry: Sr. No. CC NO 302 1 2 310 311 Rate/Hr s/Tins 360 400 7500 Description Pattern Making Hand Molding Fixed OHs Hand Molding-CI (Variable)

3.3 Process of Foundry 3.3.1 Cost Components Of Foundry Following are the main cost components in case of foundry

i. Labour Variable Overheads ii. Labour Fixed Overheads

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

311 325 325 325 325 325 325 325 325 325 330 330 330 330 335 335 335 340 340

9000 15000 14000 14900 14100 18000 19000 17900 19100 4000 3000 7500 10900 11000 4500 9000 13400 12000 12000

Hand Molding-CS (Variable) Melting CI unto 6 T Melting CI above 6 T Melting Alloy CI unto 6T Melting Alloy CI above 6T Melting CS unto 6 T Melting CS above 6 T Melting Alloy CS unto 6T Melting Alloy CS above 6 T Ferro-Manganese Fettling CI/SG Fettling Alloy CI/SG Fettling CS Fettling Alloy CS H/T CI/SG H/T CS/Ball/Man. Steel H/T NH/Hi Chrome/Fem. AOD for FerroManganese AOD for Ferro Castings

Melting statement input for each month is prepared for SWO 60000 and 79000. This statement contains date wise and stock material code wise actual issues of material against PMI and GMI for these dummies SWO. This information can be taken from system directly. “Summarized melting Statement” contains statement for a month prepared by Melting Shop. It contains different items (material code wise) charged in a month for different alloy groups for a particular heat. These quantities are taken from furnace log sheet. Three columns “Total”, “Qty. Avl “ and “Diff” in the sheet have following significance: Qty Avl– Quantity actually drawn from stores against 60000 through PMI Total – Actual material consumed in melting Diff – Stores credit note or stores return of material unconsumed for the month Total foundry melting material has been divided into 5 material groups in above-mentioned sheet no. 2 namely return, scrap, Ferro alloy, additives and flux. This categorization is used for forecasting of material. This sheet also contains a section called “Analysis” which contains information about melting loss, additives and slag, metal tapped etc. Different heads in Analysis section are as follows. Total Group I to V: Weight of total material charged for each alloy type. Metal Tapped: Actual liquid metal tapped Melting Loss = Total Group – Liquid Metal Tapped PIG/ST Block Returns: Material returned (risers etc) Total Gross Production = Metal Tapped – PIG/ST Block Good Production: Actual production booked to various orders Replacement Production: rework or rejection Internal production: Production for cost centre At the month end weighted average rate is calculated as shown in the table below for each item in stock master. Let the table below shows for item X.

3.3.4 Direct Labour Booking Operation Time Card does direct labour booking in case of Pattern Making & Molding shop. Also if any repairing of a pattern is done in Pattern Shop labour hours are recorded & booked against the SWO. Refer the screen shots for Job time card for M/C Shop & Fabrication Shop at the end of document. Similarly Job Booking for Foundry is done. 3.3.5 Assignment of material cost to work order in foundry All the materials in foundry are issued against dummy SWO 60000/00 for melting and 79000 for AOD operation in foundry. Materials are issued and punched in system at stores. Hard copies of PMI or GMI are sent to material account department.

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

Cost Of A SWO in Foundry Date Receipt Qty. 10 20 10 15 20 50 Issue Qty. Rate Value = Material Cost for Melting Material + Direct Debits for Non-stock Items + Labour Fixed OH + Variable OH + WIP Interest +Material OH

1st Jan 2nd Jan 15th Jan 29th Jan 31st Jan Total

10 20 12 12 5

100 400 120 180 100 600 2 Shift report 3.3.7 Documents Followings Documents are required for Foundry Costing Sr. No. 1 Description Gen By Recd By Purpose

Operation Time Card

Pattern Shop Molding

Accounts

Labour Booking Labour Booking Material Costing

Accounts

Weighted average for item = 600/50 = 12 At the month end all the material issued will be valued at the rate of 12 as shown in rate column of the table against issue transaction for item X. This issue rate is generated by material accounts department. “Cost / Kg Metal Tapped” is calculated: The sum of quantity against each alloy group is multiplied by respective rate gives the amount for each alloy group. When this amount for an alloy group is divided by total quantity of metal tapped we get “Cost/KG Metal Tapped” of that particular alloy group. Current months return are used in next month so returns issued in next month will be at the rate of previous month. CI returns, CYL returns and SG returns are of same category and are priced at same rate. “Metal cost/KG” which is nothing but Cost / KG Metal Tapped. 3.3.6 Material cost is assigned to a work order “Daily Production of Foundry” sheet is prepared by foundry planning. It contains the detail of one-month production SWO wise for each material quality and alloy group combination. There are two material quality codes - 01 (Cast Iron) and 02 (Cast Steel). Alloy groups are 463, 479, 468 etc. In this sheet total weight against each sales work order for each alloy group is provided. The “Cost/KG metal tapped” figure for an alloy group is multiplied by total weight of a sales work order belonging to same alloy group as given in “Daily Production of Foundry sheet” to find the metal cost of that work order. 3.4 Process of Industrial Machinery 3.4.1 Cost Components For IM 5 3 Daily Productions Of foundry Labour OH Rates-04 Monthly Melting Statement Material Arrival Report Supplier Bill Molding Accounts

4

Costing

OH Rates

Melting

Accounts

Material Costing

6

Stores

Material Accounts

Material Accounting

7

supplier

Accounts

Costing

Following are the main cost components in case of foundry

1. 2. 3. 4. 5. 6.

Relatable Overheads Non Relatable Overheads Material Overhead Material Cost For Stock Items Material Cost Of Non-stock Items WIP Interest

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

PMI/GMI From Stores

Supplier Bill Payment

Labour Hrs/Machine Hrs booked By CC

Material

Direct debit

Material OH

Relatable OH , yZ

Nonrelatable OH , yZ

WIP Interest

Prime Cost WIP For Accounting

Overhead for Accounting

Overhead For Recovery

  ‘” ‡…‘˜‡”›
3.4.4 3.4.2 Work Order Cost is collected Work order wise. For production work order, SWO no itself is the Work order. The types of work orders are: • • • • Customer Orders received directly Customer Orders received through divisions Captive Orders Stock Order Overheads For IM

Overheads are collection of all expenditure, which are not directly identified with the product. In KBL, all the expenditures are grouped cost centre wise (Except expenditures of Marketing Cost Centres, which are not taken as overheads, but deducted from margin, either by direct allocation or by apportionment. Service cost centre expenses are then allocated to production cost centres. The expenditures are salary, depreciation, power, repairs and maintenance etc. After the expenditures are collected cost centre wise, the budgeted hrs for each cost centre are calculated (labour hrs. or machine hrs,-depending on whether the cost centre is labour intensive or machine intensive). Overhead rate for a cost centre

other

A work order is issued for every job for which cost data have to be collected. The stock material gets accounted against the work order. PMI is the document through which material gets drawn to the work order. 3.4.3 Direct Labour Booking

=

1. In the existing system Job Costing System is used 2. for entering the labour hours required for every sales work order. The labour hrs are booked by the shop floor people (Only direct workers). The total hrs booked by each cost centre are consolidated for each work order to arrive at total overhead. Job time Card is referred for M/C Shop as well as for Fabrication Shop. Similarly Job Time booking for Assembly Shop is done.

Expenditur e of the cos t centre Budgeted Hr for the Cost Centre

Relatable Overhead Relatable overhead is that portion of the overhead, which is spent in the effort of production, like salaries, depreciation etc. Relatable Overhead rate for a cost centre

3.

=

Re latable Expenditur e of the cos t centre Budgeted Hr for the Cost centre

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

Non relatable Overhead Relatable Overhead: Relatable overhead is that portion of the overhead, which is not, spent in the effort of production, like Expenditures on colony, welfare expenditure etc. It also includes notional expenditure like Interest on Working Capital etc. Non Relatable Overhead rate for a cost centre

17 18 19

170 158 160

20 21

173 175

Non Re latable Expenditure of the CC = Budgeted Hr for the Cost centre

‹•– ‘ˆ …‘•– …‡–”‡•
Following is the list of Cost centres and respective overheads: I.
Sr. No

22 23 24 25

176 100 162 181

Table Type Plainer CNC Borer Vertical Boring Light Facing Lathe Facing Lathe SPAOF Grinding Marking Vertical Borer PAMA Machine

682 1091 636

68 109 64

750 1200 700

455 909

45 91

500 1000

909 364 1136 3182

91 36 114 318

1000 400 1250 3500

Machine Shop
CC No Cost Centre Relatable OH Non Relatable OH Total In Rs/Hr

II. For Fabrication Shop
Sr. No CC No Cost Centre Relatable OH Non Relatable OH Total In Rs/Hr

1 2 3 4 5

103 120 125 130 110

6 7 8 9 10 11 12

136 140 142 143 145 174 115

13

150

14 15

152 180

16

156

Turning Medium Drilling Drilling Radial Not Available Turning – VWF & POREBA Slotting Machine Not Available Vertical Milling Floor Milling Grinding Turning TurningRetrofitted Lathe Boring – Floor TypeSKODA Boring – Floor Type CNC Slant Bed Turning Centre Boring

455 455 364 455 455

45 45 36 45 45

500 500 400 500 500

1 2 3 4 5 6 7

205 210 215 216 2201 2202 225

Marking Fitting Welding Assembly Gas Cutter Plasma Cutter CNC Operation

364 364 364 409 364

36 36 36 41 36

400 400 400 450 400

546

54

600

455 455 455 455 455 455 455

45 45 45 45 45 45 45

500 500 500 500 500 500 500

III. Assembly Shop
Sr. No CC No Cost Centre Relatable OH Non Relatable OH Total In Rs/Hr

1 2

178 195

Dynamic Balancing Assembly

773 409

77 41

850 450

3.5 Manufacturing Accounting Once the production is complete, and FGN is raised WIP account is credited and FG account is debited with the cost of the product. If a work order involves production of multiple items and these items are store credited separately, the cost of each such item is arrived manually. The accounting is as follows WIP ledger and Financial Accounts are not integrated. Hence JV/IV for every transaction has to be passed manually.

1136

114

1250

1136 682

114 68

1250 750

500

50

550

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

Material consumption: The material is issued to work order through PMIs. This updates the material cost in the work order after month end processing. A manual entry is passed (an IV) to give effect to consumption account. WIP account is debited by the program, crediting ‘Direct Materials and Direct expenses Offset’ Account Material Overhead Recovery (WIP built up): WIP relatable overhead Dr Applied material Overhead (Offset Account) Cr Shop Relatable Overhead (WIP Build up) WIP Relatable OH Dr Fabrication Mfg Shop OH (Offset Account) Cr Assembly Shop OH (offset account) Cr Machine Shop Mfg OH (offset account) Cr Finished Goods Addition: Finished Goods Prime Cost Dr Finished Goods Relatable OH Dr WIP Prime Cost Cr WIP Relatable OH Cr Finished Goods Sold: Cost Of Sales Dr Finished Goods Prime cost Cr Finished Goods relatable OH Cr Captive work (job done by IM for Foundry or vice versa) WIP Prime Cost Dr WIP Relatable OH Dr WIP Prime Cost Cr WIP Relatable OH Cr Supplement Cost For Closed Jobs: Post Completion Cost Dr Bought Out Components Cr Expenses chargeable to jobs Cr Travelling Expenses Cr Goods Sold Directly from WIP Cost Of Sales Dr WIP Prime cost Cr WIP relatable OH Cr 3.5.1 Documents Followings documents are involved in case of Industrial Machinery Costing

Sr. No 1 2

Description Material Arrival Report Direct Debits

Gen By Stores Accounts

Recd By Accounts Costing

Purpose Material Accounting To check the accuracy of WIP ledger

3 4

Material debits Cost of sales Costing Costing To arrive at the cost of goods sold To arrive at the production value for a month. To get the credit in the PMS in the profitability of foundry

5

Stores Credit Note

Completio n Centre

Costing

6

Captive Casting Transfer

Foundry

Costing

7 8

Check list for captive castings Consumption Voucher

Costing Costing

Costing Accounts To pass the financial entry for consumption & inventory account To find the cost incurred for a work order after its closure. To find the cost incurred for a work order after its closure. Labour hours booking To calculate the estimated cost

9

Supplementary PMI statement

Costing

Costing

10

Supplementary For Direct Debits

Costing

Costing

11 12

Time Card Entry Estimated break up sheet

Shop floor Estimation

Costing Costing

3.6 Reports Under the cost centre accounting system, actual expenses incurred by all the departments under various expense groups are established. Periodical reports are released to the departments to enable them to know the areas of adverse variances and institute control measures. The details of expenses so collected are categorized under manufacturing units, supporting services units and

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

other departments. These details help the management to determine the overhead recovery rates for future years. From the records maintained at costing departments, cost data to the manufacturing departments broken down in terms of materials, manufacturing overheads etc is given by costing departments. Some of the Reports that are applicable for Foundry as well as Industrial Machinery are described as follows: 3.6.1 Cost Sheet As & when the job is completed, the department releases the cost sheet, which has broken down into the various elements of cost .Refer the enclosed screenshots at the end of document for cost sheet for completed /work in progress orders. The cost sheet contains following fields: Header level Information: The header information consists of following information: level

• • • • • • •

Captive Transfer cost Material Overheads Direct expenses cost: It includes direct debits as well as direct expenses. Shop overheads Interest On WIP Travel On Jobs: Travelling expenditures Total cost for estimated and actual cost

Analysis Of Direct Materials: Estimated cost for direct Material and the actual material consumed during the production is analyzed. 3.6.2 Cost Variance Report

Cost variance report consist of

i. SWO No ii. Customer Name iii. SC-SV: Sales value for Stores credited items iv. SC-TP: Transfer price for Store credited items v. Production cost: vi. Relatable Overheads vii. Non relatable Overheads viii. WIP Interest ix. Supplementary Cost x. Estimated cost xi. Total cost xii. Cost Variance
Following Table gives the list for existing Reports
Sr. No 1 Description Sales & Margin Summary SV/TP store credited for monthly basis Effective Recovery report Idle Report Hours Gen By Costing Recd By Marketing Purpose To find out the margin for SWO

i. Customer Name ii. Production description iii. SWO No iv. Delivery Date v. Position as on --------(The required date) vi. Sales value: Sales value indicates the selling price of the end item.

vii. Transfer Price: TP is the indicator of cost of total manufacturing cost as well as other expenses like engg. and design charges.

viii. Rejection Cost: The cost for rework or rejected job through extra labour hours

ix. Total cost: Addition of all the cost
Cost Of Performance Summary: It consists of • Estimated cost: Estimated cost is derived from estimated break up sheet and estimated hours for shop overheads. Actual cost is derived from actual material consumption through PMIs, Material Overheads, and Direct Debits in case of Non-stock materials, direct expenses. Variance: The difference between Estimated and actual is the variance for the order.



2

Costing



3

Costing

All shops

Following elements of cost are considered for Estimated as well as actual cost: • Direct Materials cost
4

To find out the effectivene ss of shops Loss because of

Costing

All Shops

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

Idle hours 5 6 7 Shop utilization report Costing & loss Profit Costing Costing Costing All shops Shops All Shops Profit/loss due to Mfg. To find out Variance To find out the cost variance

4. Data Flow Diagram
A Data flow diagram (DFD) is a significant modeling technique for analyzing and constructing information processes. DFD literally means an illustration that explains the course or movement of information in a process. A DFD illustrates technical or business processes with the help of the external data stored, the data flowing from a process to another, and the results. Data flow diagrams present the logical flow of information through a system in graphical or pictorial form.

Cost Sheet

8

Cost Variance report

Costing

All shops/Mar keting

Buy SmartDraw!- purchased copies print this document without a watermark . Visit www.smartdraw.com or call 1-800-768-3729.

Fig 2 DFD for Product Costing
• •

Data flow diagrams have only four symbols, which makes useful for communication between analysts and users. A DFD usually comprises of four components. These four components can be represented by four simple symbols. These symbols are explained as follows:

External entities (source/destination of data) are represented by rectangles/squares; Processes (input-processing-output) represented by Circles are

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

• • 5

Data Flows (physical or electronic data) are represented by arrows Data Stores (physical or electronic) represented by open-ended rectangles. are

Development of a solution for a small, but representative part of the business and scale up in subsequent roll-outs 2. Complex ---> Simple Development of a solution covering almost the complete functionality and roll-out of a repository to more There is no single “preferred” approach. The unique requirements of each organization dictate which approach is most suitable. The careful analysis of the numerous options and the selection of the most appropriate approach is the key for a successful, time and cost effective implementation. The Problem of ERP Implementation The success of an ERP solution depends on how quick the benefits can be reaped from it. This necessitates rapid implementations which lead to shortened ROI periods. Traditional approach to implementation has been to carry out a Business Process Re-engineering exercise and define a ``TO BE'' model before the ERP system implementation. This led to mismatches between the proposed model and the ERP functionality, the consequence of which was customizations, extended implementation time frames, higher costs and loss of user confidence. Because of the need to adapt the generic software to the specific needs of the firm, ERP vendors were required to provide tools and utilities that will allow the firm’s in house IT personnel or independent consulting firms to customize the software. Customization and implementation of ERP software became an industry on its own. The industry standard is 3 to 5 between amount spend on software purchase versus amount spent on software customization and implementation services [1] “There is No Magic in ERP Software: It’s in Preparation of the Process and People,” [3] ERP system logic is sometimes illogical, functionality is missing, functions perform poorly and so on.[3]. Because of their wide scope of application within a business, ERP software systems are typically complex and usually impose significant changes on staff work practices. Implementing ERP software is typically not an "in-house" skill, so even smaller projects are more cost effective if specialist ERP implementation consultants are employed. The length of time to implement an ERP system depends on the size of the business, the scope of the change and willingness of the customer to take ownership for the project[7]

Implementation

The deployment of an ERP system can involve considerable business process analysis, employee retraining, and new work procedures. 5.1 Implementation Approach : Challenges Minimization of _ Implementation time _ Implementation costs _ Repetitive developments _ Risk

Maximization of _ Implementation benefits _ Return on Investment _ Proof of concept _ Flexibility

5.2 Implementation Strategy There are two main implementation Strategies: 1. Big Bang All geographical locations and organizational entities are brought up with all planned functionality at once • • • All functions at all sites go “live” at once Typically feasible only in small and mid sized operations with relatively few sites All encompassing Big Bang versus local Big Bang

2. Phased Implementation • • Staged implementation site by site, etc. Pilot (“proof of concept”) and roll-out

Similarly the solution can be developed by using either of following two strategies 1. Simple ---> Complex

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

To implement ERP systems, companies often seek the help of an ERP vendor or of third-party consulting companies. These firms typically provide three areas of professional services: consulting, customisation and support [7] 5.4 Implementation Scenario There can be two scenarios: 1. Comprehensive Implementation Scenario: Here the focus is more on business improvement than on technical improvement during the implementation. This approach is suitable when: Improvements in business processes are required. Customizations are necessary Different alternative strategies need to be evaluated High level of integration with other systems are required Multiple Sites have to be implemented. Compact Implementation Scenario: Here the focus is on technical migration during the implementation with enhanced business improvements coming at a later stage. This approach is suitable when; Improvements in business processes are not required immediately Change-minded organization with firm decision making process Company operating according to common business practices. Single site has to be implemented. [5] Customization

In material requirement planning, common items i.e. stock items are checked quarterly in live project list. Quantity of specific items is computed and checked against its stock position in inventory. The Purchase order is placed for required quantity of specified stock items. In the Erp used, There was no direct way to classify products into two categories i.e. stock and non stock items. The extra fields available in the specific table are customized for type of material i.e. stock or non stock material. Moreover reports containing description of materials are also customized to include type of material. The engineering department places the requirement of certain items in terms of area but purchase department procures in terms of weight, hence suitable conversion is required to convert quantity of material from sqm to kg. This is known as conversion factor. The material issue process is customized to include conversion factor. Steel plates are one of the stock item. The Thickness of steel plates in not uniform, they come with some variations in the thickness. The maximum weight variance of 10% is acceptable in procurement of steel plates. Hence Receipt module is customized to take care of weight variance. The Bill of material needs to have link with procurement of that item and it is done through customisation. There are many finer requirements in procurement module with regard to type of procurement and hence some amount of customisation is done here. The tax structures in ERPs made by western guys lack Indian laws and hence customisation in that space is inevitable. It includes making an invoice to a customer and making a payment to a vendor through cheque too. The connectivity through net payment to vendors is achieved through customisation. 6.1 Role of Costing Professionals and the Costing system Once a system is put in place, the feeling comes to our mind that what could be the role of so many persons in that department. For example, the costing department in L&T had five people before going for ERP implementation. The system can not replace all but now due to better system in place the department is manned by three persons. Organisations do not have a large IT Team who will be able to support the ERP implementation across all locations and require the services of ERP consultants, who have a good domain knowledge; a good knowledge of the ERP system; a good understanding of various business processes; guiding them thru the implementation course.

2.

6.

The Customization is the process of extending or changing how the system works by writing new user interfaces and underlying application code. Such customizations typically reflect local work practices that are not currently in the core routines of the ERP system software.[7] Customization is done to align the engineering needs of the organization with ERP The costing in L &T, Kansbahal has mainly three components. First one is the material cost, second is labour and overhead cost and the third one is the subcontracting cost. None of the ERPs are designed the way the costing is done at Kansbahal and hence some amount of customization is needed to take care of these requirements. The standard provisions in ERP do not have facilities to capture all dimensions of equipment (finish dimension as well as raw dimensions). here. The Bill of material prepared by engineering department has six dimensions for the product –rd1,rd2,rd3 for raw material and fd1,fd2,fd3 for finished material . In shop floor and stores department, customization has been done to include to all six dimensions of the material.

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

7.

Conclusions and Future Directions

(a)

With ERP one can manage all of the resources required to produce a product - in every stage of the manufacturing process – with unlimited inputs and outputs. Bills of material need to reflect components used in the factory, input quantities need to be accurate and sufficient allowance needs to be made for component waste as well as scrap/rejects. Routings need to reflect process steps in the factory, resource and capacity requirements must be based on achievable standards based on best practice. Erp solution offers a flexible framework to enable and support real-time business change - whether proactive through continuous business innovation, changing business processes and unique practices in order to out- manoeuvre the competition or reactive in response to government regulations or competitor innovation. Currently, L & T is not having proper integrated system and business performance data to the top management is not available on line. L & T Management wants to have data on line so that they shall be able to monitor the performance of the business There are following performance issues with JD Edward ERP package 1. The ERP package, JD Edwards provide less number of reports which are not enough to carry our data query efficiently The people of costing department found documentation of JD Edward complex and not user friendly. The through put time is very high. Security needs to be provided to ensure that once status changed can not be changed to a lower status. This was not dealt during CRP. For example, Engineering department should not be able to change status from 110 to 105 for a released PR. As PR can be prepared in JD without making supplementary parts list, hence shops will not be able to know the relation between the Parts List and the PR seeing a Parts List already released to shop by Planning. In view of this, it was decided that a comprehensive report is needed for the shops/Engineering to correlate between the PRs released and their link between the Parts List items based on the JD item number and the source type (BUPR, BOPR, ICPR etc.) of the P/L.

Customization is costly, time consuming and, in many cases, impractical. This leads to a situation in which the organization must change many of its work processes and to adapt to the ERP program rather than the other way around. Implementation of an ERP project is a long process, exhausting precious time of the firm’s key people and usually interfering with the on going firm’s operations. Poor training and inappropriate preparation of the firm’s personnel results in poor usage of the system and insufficient exploitation of the new technology. [1]

(b)

(c)

Organisation should acquire flexible ERP information technology that can accommodate rapidly changing business conditions. The high-velocity flow of information needed to support action up and down the supply chain is a major step forward [3] .One should focus on their business strategy and not just software selection and implementation. Many problems are reinforced by contradictory objectives and performance measures that actually create inconsistent. When ERP implementations fail to deliver, it’s usually because management hasn’t taken the time to structure the organization to take advantage of these systems. [3] No amount of information technology will correct these problems. Companies need a well thoughtout. Comprehensive process to help plan, guide and control the entire ERP implementation effort.[3] The ERP software search, evaluation and selection process must be done right to minimize this risk.[3] Data capture using OCR embedded within workflows has become a mature and effective technology. Solutions are robust and straddle the gap between corporate data systems and document based processes, offering security, audit, reporting and management functions that fit within corporate regulatory environments - delivering a measurable return that is unique amongst most IT solutions[4] The best project is well thought out and fully researched. It is not limited to a budget and timeline, but focuses on tasks, owners, goals, and milestones. It begins at the time of software selection and goes well beyond go-live. And although most projects will stumble along the way, successful implementations that actually end on time and on budget are quite possible if managed properly[6] 7.2 ERP Systems - The Future The Internet represents the next major technology enabler which allows rapid supply chain management between multiple operations and trading partners. Most ERP systems are enhancing

2.

3. 4.

5.

Current ERP program suffer from a number of shortcomings which make it especially difficult for organization to enjoy the tremendous benefits of ERP:

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

their products to become ``Internet Enabled'' so that customers worldwide can have direct to the supplier's ERP system[5] . Recognizing the need to go beyond the MRP-II and ERP vendors are busy adding to their product portfolio. BAAN for example has already introduced concepts like IRP (Intelligence Resource Planning), MRP-III (Money Resources Planning) and has acquired companies for strategic technologies like Visual Product configuration, Product Data Management and Finite Scheduling. [5] REFERENCES 1. 2. 3. 1.Avshalom Aderet, Ph.D. , A New Approach to ERP Customization ,Eshbel Technologies IT and Business Intelligence (ITBI).htm R. Michael Donovan, Implementation the www.rmdonovan.com. Successful First ERP Time,

14. 15.

Julian Bossong, Managing ERP Applications for Strategic Advantage Andrew Stein, Paul Hawking and Susan Foster, SECOND WAVE ERP Local Implementation Challenges Andreas Vogel and Ian Kimbell, ERP FOR DUMMIES® published by Wiley Publication date: October 10, 2005 Waldner, Jean-Baptiste (1992). CIM: Principles of Computer Integrated Manufacturing. Chichester: John Wiley & Sons Ltd, p47. ISBN 047193450X. Injazz J. Chen (2001), "Planning for ERP systems: analysis and future trend", Business Process Management Journal (MCB UP Ltd) 7: 374-386, ISSN 1463-7154 Anderegg, Travis, MRP/MRPII/ERP/ERM Confusting Terms and Definitions for a Murkey Alphabet Soup, <http://www.wlug.org.nz/EnterpriseSpeak>. Retrieved on 25 October 2007 Monk, Ellen & Wagner, Bret (2006), Concepts in Enterprise Resource Planning (Second ed.), Boston: Thomson Course Technology, ISBN 0619-21663-8 Turban et al. (2008). Information Technology for Management, Transforming Organizations in the Digital Economy. Massachusetts: John Wiley & Sons, Inc., pp. 300-343. ISBN-13 978-0-47178712-9 Brown, C., and I. Vessey, "Managing the Next Wave of Enterprise Systems: Leveraging Lessons from ERP," MIS Quarterly Executive, 2(1), 2003. King. W., "Ensuring ERP implementation success," Information Systems Management, Summer 2005 Yusuf, Y., A. Gunasekaran, and M. Abthorpe, "Enterprise Information Systems Project Implementation: A Case Study of ERP in RollsRoyce," International Journal of Production Economics, 87(3), February 2004. Turban et al. (2008). Information Technology for Management, Transforming Organizations in the Digital Economy. Massachusetts: John Wiley & Sons, Inc., p. 320. ISBN-13 978-0-471-78712-9 Dehning,B. and T.Stratopoulos, 'Determinants of a Sustainable Competitive Advantage Due to an IT-enabled Strategy,' Journal of Strategic Information Systems, Vol. 12, 2003

16.

17.

18.

19.

4. 5. 6.

  Ending the ERP Paper Chase?, IBC Interactive Business Communications Shankarnarayanan S, ERP Systems -- Using IT to gain a competitive advantage Rebecca Gill, Implementing Enterprise Software On Time, On Task And On Budget, CRM Mastery e-Journal Wikipedia, the free encyclopedia Young B. Moon , Enterprise Resource Planning (ERP): a review of the literature, International Journal of Management and Enterprise Development 2007 - Vol. 4, No.3 pp. 235 - 264 Shankarnarayanan S, ERP Systems -- Using IT to gain a competitive advantage Wikipedia, the free encyclopedia, Enterprise resource planning Guillaume A. Rousselet , Jesse S. Husk , Patrick J. Bennett , Allison B. Sekuler : Time course and robustness of ERP object and face differences, Volume 8, Number 12, Article 3, Pages 1-18 doi:10.1167/8.12.3http://journalofvision.org/ 8/12/3/ ISSN 1534-7362 Adrian Mello, ERP Fundamentals Chun-Chin Wei, Evaluating the performance of an ERP system based on the knowledge of ERP implementation objectives, Received: 4 September 2006 / Accepted: 25 July 2007 / Published online: 9 September 2007,# SpringerVerlag London Limited 2007 26. 24. 20.

21.

7. 8.

22.

9. 10. 11.

23.

25.

12. 13.

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Development of Product Costing Module in ERP for L&T Kansbahal Works, Kansbhal, Orissa : A Case Study

27.

Walsh, Katherine (January 2008). The ERP Security Challenge. CSOonline. CXO Media Inc. Retrieved on 2008-01-17. Avi Wasser, Maya Lincoln, and Reuven Karni, ERP Reference Process Models: From Generic to Specific, J. Eder, S. Dustdar et al. (Eds.): BPM 2006 Workshops, LNCS 4103, pp. 45 – 54, 2006. © Springer-Verlag Berlin Heidelberg 2006 Charles F. Mason, Aarik Ragowsky , How Supplier Characteristics Influence the Value of a Supplier Management ERP Application, Information Technology and Management 3, 161– 180, 2002,2002 Kluwer Academic Publishers. Manufactured in The Netherlands. Maya Daneva Æ Roel Wieringa, Cost estimation for cross-organizational ERP projects: research perspectives, Software Qual J (2008) 16:459–481 DOI 10.1007/s11219-008-9045-8 Gail Corbitt and James Mensching, Integrating SAP R/3 into a College of Business, Information Technology and Management 1 (2000) 247–258 247

32.

28.

Vijayan Sugumaran , Mohan Tanniru , Veda C. Storey, A knowledge-based framework for extracting components in agile systems development, Inf Technol Manage (2008) 9:37– 53 DOI 10.1007/s10799-007-0025-7, Published online: 24 July 2007 _ Springer Science+Business Media, LLC 2007 Anitesh Barua Æ Suryanarayanan Ravindran Æ Andrew B. Whinston, Enabling information sharing within organizations, Inf Technol Manage (2007) 8:31–45 DOI 10.1007/s10799-006-0001-7 ,Published online: 13 February 2007_ Springer Science+Business Media, LLC 2007 Andrew Stein, Paul Hawking ,Susan Foster, SECOND WAVE ERP: Local Implementation Challenges , http://www.aueb.gr/ ifip-isglob03/ proceedings/26%20-%20Stein.pdf.

33.

29.

34.

30.

31.

International Journal of Computer Science & Informatics, Volume-I, Issue-II, 2011

Similar Documents

Premium Essay

Abc Costing System

...cz Abstract Paper analyses the specifics of the application of Activity-Based Costing method in hospital management. Primary objective of the paper is to outline the methodology of the ABC application in hospitals. First part of the paper analyzes the ways of ABC implementation in published foreign studies. Second part describes the individual steps in ABC application and discusses the differences in the application procedures between the manufacturing and hospital organization. Key words: Healthcare Management, Cost Management, Activity-based costing, Introduction In the last decade, many non-profit and hospital organizations started to face difficulties and challenges in balancing limited resources and costs to provide their demand for services. Due to the introduction of modern medical techniques and medicines and consequent increase of consumed costs, many hospitals are under pressure to adopt more advanced cost management techniques usually utilized only in profit organization sector. Hospital managers frequently seek the advanced techniques, for better understanding of relations between the cost and provided services. One of the key factors of effective company management is ability of accurate estimation of the cost of products. Product costing is an essential economic tool used to quantify the cost of individual interventions carried out. The need for an accurate method of costing in hospital organizations is frequently emphasized by many authors. Gujral et al...

Words: 3077 - Pages: 13

Premium Essay

Abc Costing System

...supports continuous learning and improvement activities and | | |serves as a linkage between strategy and execution of that strategy. | |Learning outcomes |At the end of this course, students are able to: | | |Compare and explain about costs and the best ways to make better decisions in the selection of products, price and investments. [C4] | | |Prepare and produce a budget, understand chain processes and apply the said techniques. [P4] | | |Utilise strategic costing, understand and implement ways to review inventory and quality, and...

Words: 2279 - Pages: 10

Premium Essay

Abc Costing

...* Traditional Costing * * Under Traditional Costing, all operating expenses are allocated by percent of sales. This causes the larger segments to carry more cost automatically. For Southlake, Textbooks generate the most income, however the gross profit percentage is only 26%. Clothing has one of the best gross profits and generates the 2nd most income. With traditional costing, computers are operating at a loss. Under Traditional Costing, all operating expenses are allocated by percent of sales. This causes the larger segments to carry more cost automatically. For Southlake, Textbooks generate the most income, however the gross profit percentage is only 26%. Clothing has one of the best gross profits and generates the 2nd most income. With traditional costing, computers are operating at a loss. ABC Costing * When allocating the operating costs based on cost driver rather than percentage of sales the segments performance differs. Depending on management’s choice of cost driver, results will vary. We allocated all costs to each product line but used different drivers. Under ABC costing, less cost is allocated to the biggest segment, textbooks. Textbooks still create the most income, but both supplies and computers are operating at a loss. When allocating the operating costs based on cost driver rather than percentage of sales the segments performance differs. Depending on management’s choice of cost driver, results will vary. We allocated all costs to each...

Words: 861 - Pages: 4

Premium Essay

Activity Based Costing: Abc/Abm Implementation

...usually underestimates costs for low-volume products or services and over-estimates costs of high-volume products or services. To avoid such situations Activity Based Costing (ABC) system was developed. ABC system main principle is to identify main activities of the company, group costs of these activities, identify how these activities can be measured and assign costs to products or services though these measures. ABC system helps managers to allocate costs more accurate to final products or services. However, ABC system has some limitations. For ABC implementation company needs a lot of resources (trained personnel, additional IT and information resources). Some of the potential users are often change their mind of ABC implementation after expenses for system implementation and maintenance are calculated. Other disadvantage is the complexity of the system. Implementation of ABC system could be highly complex if company has a lot of products and need to allocate its costs to a number of activities. Support and maintenance of such systems is complicated and time consuming process. ABC system gathers and provides valuable information for decision making. This approach is called Activity Based Management and could be used to improve efficiency of the company. Notwithstanding its limitations, recent surveys confirm that ABC system is useful and used in a number of small and big companies around the world.   Introduction In highly competitive world where information about products and...

Words: 3673 - Pages: 15

Premium Essay

Abc Costing

...Coverdrive Ltd Case Study: Activity Based Costing Situation At a recent management meeting at Coverdrive Ltd, the members of the senior management team discussed the introduction of a new product to the company’s range of high quality, hand made cricket bats. A major agenda item was pricing. The management accountant, since his appointment, had given much thought to pricing policy and one of his concerns was that of dealing with the recovery of overhead within a full cost pricing policy. The discussion centred around the traditional method currently in use, compared and contrasted with ABC, Activity Based Costing a technique which re-examines the problem that has faced accountants for decades – that of allocation and absorption of overhead. Traditional pricing method has been based upon absorption costing and the treatment of overhead usually followed a set procedure. ( Cost centres are identified and established within the organisation. ( Cost centres may be producing or service centres. ( Wherever possible a direct charge is made to a cost centre ie allocated overhead. ( Where overhead is jointly incurred it is apportioned to the cost centres on an equitable base. ( The overhead cost for the service centre is then transferred to producing centres. ( The total overhead cost for each producing centre is then divided by for example, machine or labour hours per the cost centre. ( An overhead recovery rate results. ( This is then used to...

Words: 1460 - Pages: 6

Free Essay

Abc Costing

...November 7, 2012 Writing Assignment 2 ABC Costing 1. Briefly describe the ABC system adopted in Super Bakery. The ABC system implemented by Super Bakery was done to separate costs by customer instead of allocating overhead evenly across the entire customer base. Their reason for doing this was simple; they wanted to see how profitable each customer was. In the nature of this business, it is described in the article that “…very few customers’ orders consume the same amount of resources.” (Davis 4) Because of this reason, different customers produced different amounts of profits, and this is one reason that Super Bakery adopted an ABC system. Another reason this company adopted the ABC system was to track outside contractors. The business is a virtual corporation, and the people who work for them often have the power to make more decisions. If they are too free to make these decisions on their own, it often happens that they try to do certain things with money to make their job easier. While doing this, it could be hurting the virtual company at the same time. With an ABC system in place, the type of spending brokers, contractors, and other outside workers is monitored closer and can be tracked more easily. 2. Do you think it is necessary to adopt an ABC system in Super Bakery? Why or why not? What are the benefits/costs? I believe that with this type of business, it is absolutely necessary to have an ABC system in place. Because of the way this business...

Words: 387 - Pages: 2

Free Essay

Abc-Costing

...ACTIVITY-BASED COSTING Activity-Based Costing (ABC) adalah suatu sistem informasi akuntansi yang mengidentifikasi berbagai aktivitas yang dikerjakan dalam suatu organisasi dan mengumpulkan biaya dengan dasar dan sifat yang ada dan perluasan dari aktivitasnya. ABC memfokuskan pada biaya yang melekat pada produk berdasarkan aktivitas untuk memproduksi, mendistribusikan atau menunjang produk yang bersangkutan. Sistem ABC timbul sebagai akibat dari kebutuhan manajemen akan informasi akuntansi yang mampu mencerminkan konsumsi sumber daya dalam berbagai aktivitas untuk menghasilkan produk secara akurat. Hal ini didorong oleh: 1. Persaingan global yang tajam yang memaksa perusahaan untuk cost effective 2. Advanced manufacturing technology yang menyebabkan proporsi biaya overhead pabrik dalam product cost menjadi lebih tinggi dari primary cost. 3. Adanya strategi perusahaan yang menerapkan market driven strategy Kelemahan sistem akuntansi biaya tradisional: a. Akuntansi biaya tradisional dirancang hanya menyajikan informasi biaya pada tahap produksi. b. Alokasi biaya overhead pabrik hanya didasarkan pada jam tenaga kerja langsung atau hanya dengan volume produksi. c. Ada diversitas produk, dimana masing-masing produk mengkonsumsi biaya overhead yang berbeda beda. Penerapan ABC sistem akan relevan bila biaya overhead pabrik merupakan biaya yang paling dominan dan multiproduk. Dalam merancang ABC sistem, aktivitas untuk membuat dan menjual produk digolonhkan dalam 4 kelompok...

Words: 962 - Pages: 4

Premium Essay

Abc Costing

...148 86 ( DM+ TOTAL OVERHEAD ) Output Overhead Output QC Overhead QC Total overhead cost for each job Total hours Material Customer initited worked correction of house error TOTAL COST Profit for each 12 1778 9 777 11426 93 5400 2700 19526 -9926 12 1778 11 950 9341 81 3500 1100 13941 -4341 16 2371 8 691 13013 146 4500 17513 5487 4 593 4 345 5007 58 1800 6807 5193 4 593 4 345 4863 56 1500 6363 4637 4 593 6 518 5324 62 1500 6824 4176 8 1186 5 432 9537 110 3300 12837 10163 8 1186 6 518 10184 118 3400 13584 8416 8 1186 8 691 9522 110 3200 12722 7278 35 5187 33 2849 42896 457 13000 1000 1000 57896 -7896 4 593 4 345 5025 59 1800 6825 975 10 1482 9 777 8833 70 3100 1000 12933 -4933 6 889 4 345 8010 65 3900 1000 12910 -4910 4 593 5 432 6129 71 2100 8229 771 4 593 4 345 5842 68 2000 7842 1958 4 593 4 345 6160 72 2200 8360 2640 9 1334 7 604 8185 79 3600 1500 13285 -2285 8 1186 9 777 9425 110 3300 12725 7275 1 148 1 86 1607 19 600 2207 -207 3 445 1 86 2567 21 1000 500 4067 -2667 4 593 3 259 5973 70 2100 8073 -73 4 593 5 432 6290 74 2500 1000 9790 210 3 445 1 86 2219 20 1600 1000 4819 -819 1 148 1 86 2214 21 1700 3914 -1914 4 593 5 432 6336 75 2200 8536 3464 1 148 1 86 553 6 200 753 -753 TOTAL PROFIT...

Words: 279 - Pages: 2

Free Essay

Abc Costing

...SELECTION CRITERIA FOR IIMs/OTHER B-SCHOOLS FOR THE LAST YEAR/THIS YEAR IIM Kozhikode (last year) There is a 2 stage process of selection Stage1 A basic short listing done on the basis of percentile cut-offs in CAT is given below QA GEN SC/ST Stage2 In stage 2, an index score is computed with 50% weight for the overall CAT score, 20% weight for academic performance in secondary school, 20% weight for higher secondary school and 10% weight for the Work Experience of the candidate. The academic performance is taken as the percentage of marks reported by the candidates and is standardized across the board using the data available with IIMK for four years including the current year. In each category, the top ranking candidates based on this index score are called for further process. The following was the criteria used for final selection of candidate to PGP 2010-12 batch. Index score obtained in stage 2 of short listing for GD/PI - 50% Group discussion and social skills - 15% Personal interview - 25% Writing task (Essay) - 10% IIM Ahmedabad The selection of candidates for admission to the 2011-13 batch of the PGP at IIM Ahmedabad is a two-step process. In the first step, candidates are short-listed for personal interviews from among candidates who have a valid CAT/GMAT score who have applied for the programme and who satisfy the eligibility criteria for the programme. A non-overseas candidate who applies with a CAT score is required to perform well in all three sections in CAT to...

Words: 3406 - Pages: 14

Premium Essay

Abc Costing

...Using a conceptual framework in setting accounting standards Ian Dennis Business School Oxford Brookes University Abstract The paper examines the nature and role of a conceptual framework for financial reporting. Although much has been written about such frameworks and their purported role and the FASB and IASB are currently revising and converging their frameworks there are still questions about the kind of thing it is and how it is used in setting accounting standards. Using insights from the philosophical literature this paper considers the nature of the statements that appear in the chapters of the conceptual framework on objectives and qualitative characteristics. It then considers how these statements are used by standard setters in reasoning towards accounting standards. The kind of reasoning involved and the type of statements that are used in such reasoning is examined. The idea that some of the statements in the conceptual framework express desires that are to be fulfilled by financial reporting regulated by accounting standards is explored. These should be conceived as expressing general desires that are used in practical or instrumental reasoning towards accounting standards rather than as universal desires that enable the deduction of such standards. The need for the exercise of judgement in such reasoning is explored. The nature of the other statements in the conceptual framework is ambiguous. They are sometimes taken to be empirical statements about...

Words: 12464 - Pages: 50

Premium Essay

Super Bakery Abc Costing

...several other unique tactics, helped Super Bakery increase their sales and productivity in the years following. However, when implementing a virtual corporation, there are several risks involved which management was well aware of. The wide variety of costs involved with serving such a broad range of customers proved to be problematic. Super Bakery decided to implement an ABC costing system, whose main focus is capturing cost by customer order rather than by a specific product. Consumptions of costs are recorded directly when then occur, or through the use of cost drivers as needed. Super Bakery uses historical costs when actual costs or unavailable, and costs drivers when historical cost and direct costing are unattainable. Super Bakery uses specific responsibility centers for those functions they perform in house, and other arm’s length centers for outsourced activities. Through the use of the company’s relational database, Super Bakery is able to examine costs incurred by several different fields, and evaluate such costs based on profitability and performance of different parts of the business. B) The ABC system adopted by Super Bakery proved to be a necessary addition to help the company maximize their profits by enabling them to accurately control their costs. Prior to the implementation of the ABS system, many of the costs assigned to customers were not associated with their actual costs. The costs were being misrepresented because of the wide variety of customers and...

Words: 574 - Pages: 3

Premium Essay

Abc & Process Costing Unit 3 (Ip) 05-11-2012

...Activity-based & Process Costing Unit 3 (IP) AIU Online Virtual Campus 05-11-2012 Abstract The discussion on this paper will be about a ski company that is considering branching out their company by either buying or producing some manufactured goods to boost their business during the winter months. This ski company produces and sells an exceedingly victorious profile of water skis, but are studying about the most current intersect-country skis. If this company decides on obtaining the strip wanted or they can produce the bindings for their skis to switch them into snow skis for the winter then they would need to know whether they are gaining or losing profits for the company. If gaining the profits then the company will need to expand the business, but if losing the profits then they will need to go back to step one and look to see if they did not jump before the gun on a much bigger step than they should have taken. Activity-based & Process Costing A collection of techniques and tools can identify with how management’s decisions can affect costs through a cost management system (CMS). The CMS computes the organizations activities in performance and by the costs of resources, in order to access the change in costs in the business activities. This system can provide to your business an aggregate measure of inventory value and the manufactured cost of goods on the external reports that are submitted to the investors, creditors, plus other external stakeholders that...

Words: 1093 - Pages: 5

Premium Essay

Abc Activity-Based Costing and Management

...Chapter 7 Activity-Based Costing and Management LEARNING OBJECTIVES Chapter 7 addresses the following questions: Q1 How is activity-based costing (ABC) different from traditional costing? Q2 What are activities, and how are they identified? Q3 What process is used to assign costs in an ABC system? Q4 How are cost drivers selected for activities? Q5 What is activity-based management (ABM)? Q6 What are the benefits, costs, and limitations of ABC and ABM? These learning questions (Q1 through Q6) are cross-referenced in the textbook to individual exercises and problems. COMPLEXITY SYMBOLS The textbook uses a coding system to identify the complexity of individual requirements in the exercises and problems. Questions Having a Single Correct Answer: No Symbol This question requires students to recall or apply knowledge as shown in the textbook. e This question requires students to extend knowledge beyond the applications shown in the textbook. Open-ended questions are coded according to the skills described in Steps for Better Thinking (Exhibit 1.10):  Step 1 skills (Identifying) ...

Words: 12709 - Pages: 51

Premium Essay

Communication Paper

...Individual: Communication Paper Suzanne Beal BCOM/230 October 08, 2012 Hank Parisi First I want to take this opportunity to welcome you to ABC Accounting, Inc. I am very confident that you will follow in my footsteps to lead this team to success. I want to take this time and give you a few words of wisdom that I have acquired through the years to help you make this transition go as smoothly as possible. Your main responsibility here at ABC Accounting is to maintain a cohesive working team. One of the more challenging responsibilities will be introducing new employees to the team members. Here are some of the barriers that you could encounter and some suggestions for some possible solutions. One of the most common barriers that you will come across is what I call the no it all’s. On occasion you have someone join the team who thinks they have the answers to everything. You need to be careful with this because you do not want to deter them from sharing their thoughts neither do you want them to steal the show. Always allow them the chance to give their input because sometimes their ideas are a welcomed change. Another barrier that you may come across is personality clashes. This can be tricky because you do not want to look as though you are taking sides so give each person a chance to speak and see if you can work out the differences together. You may also encounter those who are reserved and just listen without giving input...

Words: 1026 - Pages: 5

Premium Essay

Activity-Based Costing (Abc) in Service Industries

...Activity-Based Costing (ABC) in Service Industries H & R Block H & R Block A Study of TDABC Costing Robert Kaplan defines activity based costing (ABC) as a system that “provides the conceptual framework for linking financial, production, scheduling, order-entry, marketing, and sales data… into a comprehensive costing and profitability model that reports profitability by individual product, customer, and even by order. (Kaplan, 2009). Time-driven ABC has taken this methodology a step further and simplified the process to make an even more powerful tool to measure the financial effectiveness of a company. This paper is attempts to take a U.S. service company and map out an implementation of TDABC to prove the ease and effectiveness of this accounting tool. Company Description H&R Block is one of the oldest and largest tax service providers. It was founded in 1955 by brothers Henry and Richard Bloch. The company began franchising in 1956 and went public in 1962. It employs over 100,000 trained tax professional both within the U.S. and worldwide. According to their web-site, H&R Block prepares one in every 7 U.S. tax returns.(HRBlock.com, 2013) One key to their success is that they claim to have a retail office within 5 miles of most Americans. H & R Block offers their services both in person and on-line. The tax-payer can chose to walk into an office and work face-to-face with the tax specialist, they can work totally on their own using the online or packaged...

Words: 2005 - Pages: 9