Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
Sinar Kemboja a company manufacturing concern operates on the three machines; Moulding, Shaping and Cutting
Sinar Kemboja a company manufacturing concern operates on the three machines; Moulding, Shaping and Cutting. Other two service departments; Maintenance and Store are supporting the three machines to be operated smoothly. The budgeted overhead costs for all five departments for the year 2021 are as follows: RM Allocated overheads: Moulding Shaping Cutting Maintenance Store 220,000 210,000 190,000 100,000 88,000 Other costs: Rent and rates Power Heating and lighting Insurance on building Insurance on machine Insurance on motor vehicles Supervision Telephone expenses Depreciation on motor vehicles 65,800 72,600 64,200 34,000 28,800 105,600 54,500 12,000 32,000
The following information relates to the machine: Cutting 100 Maintenance 50 Store 50 15 8,000 2,000 5 5,000 1,000 Total Floor area 500 Number of personnel 380 No of calls 60,000 Horse power 20,000 Machine hours 15,400 Motor vehicles at cost (RM) 800,000 Machine at cost (RM) 900,000 No of material requisition 6,500 Maintenance hours 30,000 Direct labour hours 69,500 Moulding Shaping 150 150 130 120 18,000 16,000 7,000 6,000 6,600 4,800 280,000 148,000 320,000 230,000 2,600 2,400 11,800 9,200 25,000 24,000 110 13,000 4,000 4,000 220,000 200,000 1,500 9,000 20,500 70,000 82,000 150,000
Required: Prepare an overhead analysis sheet showing the basis of apportionment made. (ALL answers must be rounded-up to the nearest RM) a. (35 marks) b. Calculate an overhead absorption rate (CAR) based on the following basis: Moulding: Machine hours Shaping: Machine hours Cutting: Direct labour hours (ALL answers must be rounded-up to the nearest RM) (5 marks) C. Explain FIVE (5) examples of overhead for KUPTM.
Expert Solution
-
Overhead Analysis Sheet Manufacturing Departments Service Department Particulars Moulding Shaping Cutting Maintenance Store Allocated Ovrehead 220000 210000 190000 100000 88000 Allocation of Other Cost Rent and Rates 19740 19740 13160 6580 6580 Power 25410 21780 14520 7260 3630 Heating and Lighting 22470 19260 12840 6420 3210 Insurance on building 10200 10200 6800 3400 3400 Insurance on Machine 10240 7360 6400 4800 0 Insurance on Motor Vehicles 36960 19536 29040 10824 9240 Supervision 18645 17211 15776 2151 717 Telephone Expenses 3600 3200 2600 1600 1000 Depreciation on motor vehicles 11378 8178 7111 5333 0 Total Overhead 378643 336464 298247 148369 115777 Allocation of other cost Cost Basis for allocation Ratio Moulding Shaping Cutting Maintenance Store Toal Rent and Rates Floor Area 15:15:10:5:5 19740 19740 13160 6580 6580 65800 Power Horse Power 7:6:4:2:1 25410 21780 14520 7260 3630 72600 Heating and Lighting Horse Power 7:6:4:2:1 22470 19260 12840 6420 3210 64200 Insurance on building Floor Area 15:15:10:5:5 10200 10200 6800 3400 3400 34000 Insurance on Machine Cost of machine 32:23:20:15 10240 7360 6400 4800 0 28800 Insurance on Motor Vehicles Cost of vehicles 280:148:220:82:70 36960 19536 29040 10824 9240 105600 Supervision No. of personnel 130:120:110:15:5 18645 17211 15776 2151 717 54500 Telephone Expenses No of Calls 18:16:13:8:5 3600 3200 2600 1600 1000 12000 Depreciation on motor vehicles Cost of machine 32:23:20:15 11378 8178 7111 5333 0.00 32000 Particulars Moulding Shaping Cutting Allocated Cost as per above table 378643 336464 298247 Add: Re-allocation of service department cost Maintenance in the ratio of Maintenance Hours 63587 46245 38537 (66:48:40) Store in the ration of No.of Material Requisition 46311 42748 26718 (26:24:15) Total Overhead 488540 425458 363503 Particulars Moulding Shaping Cutting Caculation of Absorption Rate Aborption Rate = Total Overhead / Basis a Total Overhead 488540 425458 363503 Basis Machine Hrs Machine Hrs Direct Labour Hrs b 6600 Hrs 4800 Hrs 20500 Hrs c Aborption Rate (a/b) 74 89 18
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





