Question

ABC Ltd manufactures products to the precise specifications of individual customers in three separate production departments. Thank you
Using the information provided above: (1) Prepare in a columnar form a statement showing the overhead cost budgeted for EACH
0 0
Add a comment Improve this question Transcribed image text
Answer #1
(i) Statement Showing the Apportionment of Overheads
Items of Overheads Basis of Apportionment Total Production Department Service Department
Cutting Machining Pressing Stores Maintenance
Rent & Taxes                   [60:25:6:5:4] Floor Area Occupied (Sq.Ft) £15,000 9,000 3,750 900 750 600
[15,000 x 60/100] [15,000 x 25/100] [15,000 x 6/100] [15,000 x 5/100] [15,000 x 4/100]
Machine Insurance             [20:8:7:4:1] Machine Value £10,000 5,000 2,000 1,750 1,000 250
[10,000 x 20/40] [10,000 x 8/40] [10,000 x 7/40] [10,000 x 4/40] [10,000 x 1/40]
Telephone Charges           [60:25:6:5:4] Floor Area Occupied (Sq.Ft) £5,000 3,000 1,250 300 250 200
[5,000 x 60/100] [5,000 x 25/100] [5,000 x 6/100] [5,000 x 5/100] [5,000 x 4/100]
Depreciation                        [3:6:5:2:4] Machine Value £20,000 10,000 4,000 3,500 2,000 500
[20,000 x 20/40] [20,000 x 8/40] [20,000 x 7/40] [20,000 x 4/40] [20,000 x 1/40]
Production Supervisor Salary      [1:2:1] Direct Labour Hours £25,000 6,250 12,500 6,250 - -
[25,000 x 1/4] [25,000 x 2/4] [25,000 x 1/4]
Heating / Lighting             [60:25:6:5:4] Floor Area Occupied (Sq.Ft) £10,000 6,000 2,500 600 500 400
[10,000 x 60/100] [10,000 x 25/100] [10,000 x 6/100] [10,000 x 5/100] [10,000 x 4/100]
Total Costs            £85,000 £39,250 £26,000 £13,300 £4,500 £1,950
Overheads Distribution Statement
Items of Overheads Total Production Department Service Department
Cutting Machining Pressing Stores Maintenance
Overheads as per Primary Distribution £85,000 £39,250 £26,000 £13,300 £4,500 £1,950
Allocated Overheads Specific to each department £8,000 £3,000 £2,000 £1,500 £1,000 £500
Total Overhead Allocated £93,000 £42,250 £28,000 £14,800 £5,500 £2,450
Cost of Stores apportioned in the ratio (5:3:2) £0.00 £2,750 £1,650 £1,100 -£5,500 -
[5,500 x 5/10] [5,500 x 3/10] [5,500 x 2/10]
Cost of Maintenance apportioned in the ratio (3:2:5) £0.00 £735 £490 £1,225 -£2,450
[2,450 x 3/10] [2,450 x 2/10] [2,450 x 5/10]
Total OH Costs            £93,000 £45,735 £30,140 £17,125 £0 £0
DETERMINE THE OVERHEAD RATE BASED ON DIRECT LABOUR HOURS
PARTICULARS AMOUNT BASIS DL HOURS OH RATE
[A] [B] [C] [D] = {A/C}
OVERHEAD COST £93,000 Direct Labour Hours 4,000 £23.25
Know the answer?
Add Answer to:
Thank you ABC Ltd manufactures products to the precise specifications of individual customers in three separate...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • ABC Ltd manufactures products to the precise specifications of individual customers in three separate production departments....

    ABC Ltd manufactures products to the precise specifications of individual customers in three separate production departments. It also has two service departments. The following overhead costs are predicted to occur during the coming year: Total Rent and rates (£) 15,000 Machine insurance (£) 10,000 Telephone charges () 5,000 Depreciation (£) 20,000 Production supervisors' salaries (£) 25,000 Heating/lighting (E) 10,000 85,000 Details relating to each department are given below: Production Service Total Cutting Machining Pressing Stores Maint- enance Floor area occupied...

  • A furniture making business manufactures quality furniture to customers' orders. It has three production departments and...

    A furniture making business manufactures quality furniture to customers' orders. It has three production departments and two service departments. Budgeted overhead costs for the coming year are: Totals £ Rent and Rates 12, 800 21.00 Machine insurance 6,000 2,000 Canteen 3200 6,400 Depreciation 18,000 36000 Production supervisor's salaries Heating and lighting 6,400 2,810 70,400 32.000 The three production departments - A B and C,, and the two service departments - X and V, are housed in the new premises, the...

  • LILI SDN BHD is a manufacturer and supplier of home cabinets. It has two main Departments...

    LILI SDN BHD is a manufacturer and supplier of home cabinets. It has two main Departments that is the Production Department and the Service Department. The Production department has three (3) sub-departments: Machining, Assembly and Finishing. All three departments are labor-intensive. The Service Department has two sub-department which is Maintenance and General Services. Cost Data Production Departments Service Departments Cost Items (RM) Fabrication Assembly Finishing Maintenance Gen.Services Indirect Supplies 3,000 2,500 2,000 1,000 2,500 Indirect Labour 18,000 10,000 8,000 4,500...

  • new answer no plagrism pls and typed up not hand written B. Alphabet Co has three...

    new answer no plagrism pls and typed up not hand written B. Alphabet Co has three production departments A, B, and C and one service department S. Alphabet Co are preparing their annual budget for the final quarter of 2020. Planned overhead costs for the quarter are as follows: Overheads Supervision Depreciation Insurance Rates and Rent Other bills £ Absorption basis 12000 Direct Labour Hours 15000 Machine value 5000 Machine value 30000 Floor area 2500 Floor area The following information...

  • Question 3 Blue Ltd a manufacturing business with three production departments and one service department and...

    Question 3 Blue Ltd a manufacturing business with three production departments and one service department and has budgeted costs by department as follows: Dept Dept2 Depr3 Stores 320 480 200 Direct labour (£000) 240 280 240 Indirect labour (£000) 320 Production Requisition notes (000's) 120 160 40 Indirect materials (£000) 30,000 30,000 20,000 10,000 Area occupied (sqm) 20 70 10 Use of external maintenance (%) 40 The following additional information is available: • Total external maintenance costs will be £25,000...

  • McKinsey Machines Ltd manufactures a single product A.   It has two cost centers namely molding department...

    McKinsey Machines Ltd manufactures a single product A.   It has two cost centers namely molding department and painting department. Information Molding Department Painting Department Total Manufacturing overheads $ 1,806,000 $ 2,205,000 Total Machine hours (estimated) 210,000 Total Direct Labour Cost $ 1,260,000 McKinsey Ltd executes job no. 410.   The cost and output details of Job No.410 are given below: Information Molding Department Painting Department Direct Materials $ 1,410 $ 996 Direct Labour $ 870 $ 2,040 Number of machine hours...

  • Case Study: Williams Ltd Williams Ltd manufactures iron gates to individual customers’ specifications. The company use...

    Case Study: Williams Ltd Williams Ltd manufactures iron gates to individual customers’ specifications. The company use the tender process to obtain work, where the company responds to an invitation to submit a competitive bid. Over the last few months, Williams Ltd. has been very quiet, and the managing director, Jack Jones, is concerned that the business will fail if it does not improve its success rate with tenders. The company has two production departments, Bending and Welding, and the production...

  • Bob's Electronics Inc. manufactures high-tech screens for computers. In June, the two production departments had budgeted...

    Bob's Electronics Inc. manufactures high-tech screens for computers. In June, the two production departments had budgeted allocation bases of 8,300 machine hours in Department 1 and 5,760 direct manufacturing labour hours in Department 2. The budgeted manufacturing overheads for the month were $32,000 and $27,500, respectively. For Job 101, the actual costs incurred in the two departments were as follows: Department Department 2 Direct materials purchased on account $66,000 $106,500 Direct materials used 12.500 9,100 Direct manufacturing labour 32,500 32,200...

  • Bob's Electronics Inc. manufactures high-tech screens for computers. In June, the two production departments had budgeted...

    Bob's Electronics Inc. manufactures high-tech screens for computers. In June, the two production departments had budgeted allocation bases of 8,400 machine hours in Department 1 and 5,860 direct manufacturing labour hours in Department 2. The budgeted manufacturing overheads for the month were $32,000 and $27,500, respectively. For Job 101, the actual costs incurred in the two departments were as follows: Department 2 $106,500 9,100 Department 1 Direct materials purchased on account $66,000 Direct materials used 12,500 Direct manufacturing labour 32,500...

  • Bob’s Electronics Inc. manufactures high-tech screens for computers. In June, the two production departments had budgeted...

    Bob’s Electronics Inc. manufactures high-tech screens for computers. In June, the two production departments had budgeted allocation bases of 8,200 machine hours in Department 1 and 5,660 direct manufacturing labour hours in Department 2. The budgeted manufacturing overheads for the month were $32,000 and $27,500, respectively. For Job 101, the actual costs incurred in the two departments were as follows: Department 1 Department 2 Direct materials purchased on account $66,000 $106,500 Direct materials used 12,500 9,100 Direct manufacturing labour 32,500...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT