Prepare an overhead analysis sheet, Managerial Accounting

Assignment Help:

QUESTION 1:

PART A

You are the Cost Accountant of an industrial concern and have been assigned the duty of preparing a cost accounting system. Initially it has been decided to prepare three production cost centers and two service cost centers.

The subsequent data relating to the next accounting period have been estimated as follows:

                                      Production Cost Centres          Service Cost Centres              Total

 

Milling

Assembly

 

Spraying

Stores

Maintenance

 

 

 

No. of employees

 

 

30

 

 

75

 

 

 

25

 

 

6

 

 

14

 

 

150

 

Labour hours

 

1,510

 

3,320

 

 

950

 

252

 

595

 

6,627

 

Plant & Machines values

 

225,000

 

75,000

 

 

45,000

 

17,000

 

85,000

 

447,000

 

Area (m2)

 

7,500

 

10,000

 

 

3,500

 

500

 

1,000

 

22,500

 

Material requisitions

 

1,400

 

300

 

 

250

 

 

550

 

2,500

 

Maintenance hours (minor works)

 

 

75

 

 

30

 

 

 

45

 

 

 

 

150

 

KWH ('000)

 

300

 

70

 

 

50

 

10

 

170

 

600

 

Machine hours

 

8,400

 

1,100

 

 

300

 

 

 

9,800

During the period the following data were recorded

 

Milling

Assembly

Spraying

Stores

Maintenance

Total

Indirect materials

Indirect labour

Maintenance works

2,500

 

5,250

18,500

1,000

 

2,500

7,500

1,500

 

2,250

4,500

300

 

4,250

1,700

 

11,750

7,000

 

26,000

30,500

The following details were obtained from the accounts relating to the period:

Fire Insurance

1,250

Power

4,500

Heating and Lighting

2,000

Rates

1,800

Machine depreciation

8,400

Machine Insurance

850

Canteen deficit

4,250

Balance of maintenance costs (excl. major works)

17,500

Required:

(a) Prepare an overhead analysis sheet showing how overhead costs should be apportioned between the departments.

(b) Determine suitable overhead absorption rates for the Milling, Spraying and Assembly departments, stating clearly the overhead absorption basis used.

PART B

The daughter of the managing director of ABC Ltd is attending a university degree course in accounting and finance. In the mean while a telephone call to his daughter the managing director asked her to enquire from her lecturers which of the following is correct when considering allocation, apportionment and reapportionment of overheads in an absorption costing situation:

- Only production related costs should be considered.

- Allocation is the situation where part of an overhead is assigned to a cost centre.

- Costs may only be reapportioned from production centres to service centres.

- Any overheads assigned to a single department should be ignored

Required:

Briefly Explain what should be the advice of the lecturers to the Managing Director's daughter.

PART C

Activity Based Costing is a costing model which examines the problem that has faced accountants and accounting technicians for decades - that of the allocation and  absorption  of  overhead.  As  such  Activity  Based  Costing  or  ABC  offers  a workable and more effective insight into overhead

Required:

Briefly describe on three uses and three limitations to the Activity Based Costing system.


Related Discussions:- Prepare an overhead analysis sheet

Starbucks project, 1)Prepare a three (3) year forecast of estimated future ...

1)Prepare a three (3) year forecast of estimated future cash flows for you company and give valid economic/business reasons for your projections. This means you will have a stateme

Credit investigation, Once the credit information is accumulated the subseq...

Once the credit information is accumulated the subsequent step is to analyze the gathered information and isolate those matters that may need further investigation. The factors whi

Stock-out costs, Stock-out costs These are the opportunity costs of run...

Stock-out costs These are the opportunity costs of running out of stock. They comprise: 1) The costs of lost customer sales, and therefore lost contribution to fixed costs.

Transfer pricing-performance evaluation, Transfer Pricing and Performance E...

Transfer Pricing and Performance Evaluation Transfer pricing is simple in concept and yet complex in implementation. It provides a divisional output valuation where output from

Chapter 3, Cretin Enterprises uses a predetermined overhead rate of $21.40 ...

Cretin Enterprises uses a predetermined overhead rate of $21.40 per direct labor-hour. This predetermined rate was based on a cost formula that estimated $171,200 of total manufact

Absorption and marginal costing, opening stock unit were 8500 and closing s...

opening stock unit were 8500 and closing stock units were 6750.frofit of 61200 using managerial costing.fixed overhead absorbed rate was 3 pr unit.what is the profit using absorpti

International transfer pricing, International Transfer pricing Internat...

International Transfer pricing International transfer pricing refers to the determination of prices to be charged between related persons and in particular within a multination

Process Inventory, Hoe to find the cost of goods transferred under weighted...

Hoe to find the cost of goods transferred under weighted average method

Eoq model with quantity discounts, EOQ Model with quantity discounts Ci...

EOQ Model with quantity discounts Circumstances frequently occur where firms are able to obtain quantity discounts for large purchase orders. Buying in bulkiness has some merit

Financial planning programs, Financial planning programs Such programs ...

Financial planning programs Such programs differ in complexity. Some simple programs can include only those variables discussed while other more complicated ones can include an

Write Your Message!

Captcha
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