Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / 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

Accounting

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.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

  • 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