StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Activity Based Accounting and Managerial Accounting - Assignment Example

Cite this document
Summary
The author of the assignment "Activity Based Accounting and Managerial Accounting" provides information about the labor hours required for models. However, it does not state the number of units that are produced during the given labor hours. …
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER95.8% of users find it useful
Activity Based Accounting and Managerial Accounting
Read Text Preview

Extract of sample "Activity Based Accounting and Managerial Accounting"

This assignment considers that the minimum labor hours illustrated in Table 2 relate to the minimum units per month illustrated in Table 1. Based on this assumption the following is deducted:

 

Model             Labor hour                  Labor hour                  Total             Unit

                        Motor assembly          Harness fitting Final assembly            LH

FL                   20                                9                                  6                                  35            40

TL                   12                                4                                  4                                  20            150

HE                   18                                8                                  4                                  30            30

 

Labor cost = $35 * 4 = $ 140 per hour

 

 

Model             Labor hour / Unit        Labor cost / Unit ($)

FL                   35/40 = 0.88                140 * 0.88 = 122.50

TL                   150/20 = 0.13              140 * 0.13 = 18.67

HE                   30/30 = 1                     140 * 1 = 140

 

Calculation using per Unit

 

Cost calculation

Front-loaders               Top loaders High-efficiency Total

Number of Units                     300                  503                              100                              903

Raw material /unit ($) 330                  250                              400

Labor cost/unit ($)                122.50             18.67                           140.00

OH cost/unit ($)                    554                  554                              554     

Total cost/unit ($)                   1,007               823                              1,094

 

Profit / Loss calculation

 

                                                FL                   TL                   HE

No. of units                             300                  503                  100

Sales price/unit 500                  380                  650

Cost/unit 1,007               823                  1,094

Revenue                                  150,00             191,140           65,000

Cost                                         302,100           413,969           109,400

Loss                                        (150,100)        (222,829)        (44,400)

 

Question 2.

Front-loaders                           Top loaders                 High efficiency

Units:              300                                          503                              100

Labor hours    unknown                                unknown                     unknown

 

Total LH per model calculation

Model             Units               Total assembly LH    

FL                   300                  (35/40) * 300  = 263

TL                   503                  (20/150) * 503 = 67

HE                  100                  (30/30) * 100 = 30

 

Front-loaders                           Top loaders High-efficiency Total

Units:              300                                          503                              100                              903

Labor hours    263                                          67                                100                              430

Total overhead: $500,000 / month

Overhead (OH) per LH:  500,000 / 430 = $1,163

Total OH         263*1163=305,869                 67*1163=77,921         100*1163 = 116,300

OH/unit           1,020                                       155                              1,163

 

 

 

 

Calculation using Overhead per Labor hour

 

Front-loaders               Top loaders High-efficiency Total

Unit                             300                              503                              100                              903

Raw mat. /unit ($)      330                              250                              400

Labor cost/unit ($)    123                              19                                140

OH cost/unit ($)        1,020                           155                              1,163  

Total cost/unit ($)      1,473                           424                              1,703

Sale/unit ($)              500                              380                              650

Revenue                      150,000                       191,140                       65,000

Cost                             441,900                       213,272                       170,300

Loss                            (291,900)                    (22,132)                      (105,300)

 

 

 

                                    Front-loaders               Top loaders                 High efficiency

 

Raw mat. /unit ($)      330                              250                              400

Labor cost/unit ($)    123                              19                                140

OH cost/unit ($)        1,020                           155                              1,163  

Total cost/unit ($)      1,473                           424                              1,703

 

Answer:  Most profitable is the Top loader; the cost takes to produce 1 unit is $424, which is the

 

lowest among the three models. 

 

Answer:  The current production plan is consistent; it produces the highest quantity (503 units) of a top loader.  An alternative plan is not needed, but sales prices have to be increased or OH needs to be reduced.

Question 2a.

 

Cost locators              Overhead        Cost driver                  Total                Overhead rate

 

Plant and equipment   $250,000         Square feet                  200,000           1.25$ / sqft

Management               $140,00           Labor hours                57,000             2.46$ / LH

Purchasing                  $70,000           Purchase orders          1,890               37.04$ / order

Sales and shipping      $40,000           Customer orders         105                  380.95$ / order

 

 

Unit cost per model

Cost locator

Rate

FL

OH

TL

OH

HE

OH

Sq.ft

1.25

50,000

62,500

70,000

87,500

80,000

100,00

LH

2.46

25,000

61,404

12,000

29,474

20,000

49,113

PO

37.04

450

16,667

1,080

40,000

360

13,333

Customer orders

380.95

25

9,524

60

22,857

20

7,619

 

 

 

150,094

 

179,831

 

170,075

OH / Unit                                            500                                   358                                 1,701  

Profit / Loss calculation

 

FL

TL

HE

units

300

503

100

Raw mat/unit

330

250

400

labor/unit

123

19

140

OH/unit

500

358

1,701

Cost/unit

953

627

2,241

Sale/unit

500

380

650

 

 

 

 

Revenue

150,000

191,140

65,000

Cost

285,750

315,213

224,100

Loss

-135,750

-124,073

-159,100

 

FL                                TL                               HE

Overhead/unit using labor hour        1,020                           155                              1,163

 

Loss from operation using

labor hour method                              (291,900)                    (22,132)                      (105,300

 

Loss from operation using

cost locator method                            (135,750)                    (124,073)                    (159,100)

 

 

 

 

 

 

 

Question 2b.

 

The above calculations show losses. A new calculation is presented using the following production plan: front loader 500 units, top loader 1,200 units, and high-efficiency loader 400 units.

ABC allocation method

           

 

FL

TL

HE

Units

500

1,200

400

Raw mat/unit

330

250

400

labor/unit

123

19

140

OH/unit

500

358

1,701

Cost/unit

953

627

2,241

Sale/unit

500

380

650

 

 

 

 

Revenue

250,000

456,000

260,000

Cost

476,250

752,000

896,400

Loss

-226,250

-296,000

-636,400

 

Labor hour allocation method

 

 

FL

TL

HE

Labor cost ($/Labor hour)

140

140

140

Number of units

500

1200

400

Labor hour for Table 1

35

20

30

Units (Table 2)

40

150

30

Total LH

438

160

400

LH/Unit

0.88

0.13

1.00

Labor cost/unit

123

19

140

Overhead cost/labor hour

501

501

501

Overhead cost for total LH

219,298

80,201

200,501

Overhead/unit

439

67

501

 

 

 

 

Raw mat/unit

330

250

400

Labor cost/unit

123

19

140

Overhead cost/unit

439

67

501

Cost/unit

891

336

1041

sale/unit

500

380

650

 

 

 

 

Revenue

250,000

456,000

260,000

Cost

445,548

402,601

416,501

Losses

-195,548

53,399

-156,501

 

Comparison

 

Labor hour allocation method (195,548)                    53,399                         (156,501)

 

 

ABC allocation                                   (226,250)                   (296,000)                    (636,400)

 

Question 2c

The ABC method uses fixed overhead for all cost locators, which makes overhead per unit fixed.  It does not consider the influence of labor hours needed to manufacture different quantities of the same product (Harmon, n.d.).

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Part 1 A manufacturer of Washing Machines produces three models, Assignment”, n.d.)
Part 1 A manufacturer of Washing Machines produces three models, Assignment. Retrieved from https://studentshare.org/design-technology/1627352-part-1-a-manufacturer-of-washing-machines-produces-three-models-namely-a-front-loader-top-loader-and-a-high-efficiency-top-loader-these-three-machines-are-produced-on-the-same-production-line-with-three-stations-namely-motor-assembly-harness-fittin
(Part 1 A Manufacturer of Washing Machines Produces Three Models, Assignment)
Part 1 A Manufacturer of Washing Machines Produces Three Models, Assignment. https://studentshare.org/design-technology/1627352-part-1-a-manufacturer-of-washing-machines-produces-three-models-namely-a-front-loader-top-loader-and-a-high-efficiency-top-loader-these-three-machines-are-produced-on-the-same-production-line-with-three-stations-namely-motor-assembly-harness-fittin.
“Part 1 A Manufacturer of Washing Machines Produces Three Models, Assignment”, n.d. https://studentshare.org/design-technology/1627352-part-1-a-manufacturer-of-washing-machines-produces-three-models-namely-a-front-loader-top-loader-and-a-high-efficiency-top-loader-these-three-machines-are-produced-on-the-same-production-line-with-three-stations-namely-motor-assembly-harness-fittin.
  • Cited: 0 times

CHECK THESE SAMPLES OF Activity Based Accounting and Managerial Accounting

Managerial Accounting

managerial accounting Company Background The company Delegat's Group Limited was established in 1947 in the business of producing and marketing of the internationally acclaimed Oyster Bay and Delegat's wine.... Planning Control and Decision making process Management accounting is related to the system of accounting information used by the managers within an organisation.... The management accounting provides the managers with the basis of information essential in the decision making of the company so that the resources of the company can be better utilised and functions are in control....
10 Pages (2500 words) Assignment

Managerial AccountinG

Managerial versus Financial Accounting My friend who is nowadays interested in finance and accounting came to me to understand the difference between financial and managerial accounting.... managerial accounting Assignment By 23 March 2011 Task 1 Communicating Theft of Finished Good The theft of finished goods is a crime by all means.... managerial accounting Assignment By 23 March Task Communicating Theft of Finished Good The theft of finished goods is a crime by all means....
1 Pages (250 words) Assignment

Managerial Accounting Practices

you did not think it fit and proper to examine the financial statements prepared by the external accounting department discloses your dissatisfaction with the present state of affairs within the Company, and mostly with the present inventory and accounting system.... The financial reports focus on what has happened in the past – whereas what you are looking for is improvement – improvement in all sectors (manufacturing, sales, accounting, customer relations) at present and in future....
5 Pages (1250 words) Essay

International Accounting and Finance

The paper "International accounting and Finance" highlights that the cost pools used under the full costing or absorption costing traditionally include only one or a limited number of pools whereas the activity-based costing uses many and different activity pools for recuperating overhead expenses.... Upon interviewing the present accountant, he admits that the old system is wanting but insists on continuing this cost accounting system because of the ease of computing the total factory overhead costs....
11 Pages (2750 words) Essay

Managerial Accounting Theories

This essay "managerial accounting Theories" discusses the accounting profession which is a fascinating academic discipline whose roots date back over 5000 years (Giroux, 1999).... The accounting profession evolved a lot in the second half of the 20th century due to the globalization movement and the increased complexity of the business world.... The purpose of this paper is to discuss how accounting theories differ from each other including real-life examples that show contrasting accounting theories in the real world....
6 Pages (1500 words) Essay

Managerial Accounting: Activity Based Costing

The paper "managerial accounting: Activity Based Costing" seeks to discuss activity based costing as an element of managerial accounting.... It also explores the relationship between activity based costing, traditional methods, and activity based management.... activity based costing is a costing method in which an organization assigns costs to its products based on involved processes.... The process of activity based costing, therefore "identifies activities that generate costs and assigns costs to those activities" (Hermanson, Edwards and Ivancevich, 2006, p....
4 Pages (1000 words) Research Paper

The Role of the Management Accountant

raditional Role of Management Accountants The inquiry into this section involved a critical review of the concept of management accounting and how it evolved over the years.... The paper 'The Role of the Management Accountant' is an impressive example of finance & accounting coursework.... The paper 'The Role of the Management Accountant' is an impressive example of finance & accounting coursework.... Maskell (1993) provides a very insightful into to evolution of management accounting....
9 Pages (2250 words) Coursework

Decision Making with Managerial Accounting

The paper 'Decision Making with managerial accounting' is an informative example of a finance & accounting report.... This paper presents some of the managerial accounting techniques used to enhance the decision-making process in organizations.... The paper 'Decision Making with managerial accounting' is an informative example of a finance & accounting report.... This paper presents some of the managerial accounting techniques used to enhance the decision-making process in organizations....
10 Pages (2500 words)
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us