Cost accounting

QUESTION 4 Cakerawala Bhd. is a manufacturing company that has three production departments; Machining Assembling, Finishing and one service department; store. The information given below relates to a four weeks accounting period: Departments Total Machining | Assembling|Finishing Store Factory Area (sq meters) 82,800 24,000 office (RM) 36,000 16,000 4,000 2,800 Plant & Equipment (RM) 584,500 300,400 209,600 56,200 10,300 8,000 Number of personnel 250 120 90 40 Machine hours 194.500 66,000 52,000 44,000 20,100 12,400 Building value (RM) 479,930 120,900 1 10,300 98,400 85,200 65,100 Cost of materials (RM) 89,900 42,600 31,100 16,200 Production hours 47,900 16,400 21.200 10,300 Allocated Costs: Total Machining (RM) Assembly (RM) Finishing (RM) Store (RM) Factory Indirect wages 260,00 office (RM) 90,900 45,500 64,200 36,100 23,300 Indirect materials 357,500 104.100 91.400 6,700 55,200 30,100 Maintenance 91,800 31,400 20,600 18,100 12,300 9,400 Other Costs: RM Depreciation on plant and equipment 65,700 Wages 99.200 Factory personnel 47,100 Insurance on plant and equipment 21,600 Supervisors' salary 86,800 Rates 26,700 Office electricity 40.200 Insurance on building 54.900 Required: a Prepare an overhead analysis sheet showing the basis of apportionment made. (ALL answers must be rounded-up to the nearest RM) (35 2 marks) b. Calculate an overhead absorption rate based on the following basis: Machining Department: Machine hours Assembly Department: Production hours Finishing Department: Machine hours (ALL answers must be rounded-up to the nearest RM) (4 1/2 marks)