QUESTION 5 (40 MARKS) Bino Lid produces suits in three separate production departments (viz. Cutting Sewing and Finishing). Production is serviced by three service centres (viz. Material store, Canteen and Maintenance) The Material store cost centre's costs are apportioned to other departments using the direct method while the reciprocal method based on simultaneous equations is used to apportion Canteen and Maintenance centres costs. The Maintenance costs are apportioned based on floor area. It is Bino's policy to set selling prices to ensure a profit margin of 30% on sales The company received a new order for 1 000 suits which will require the following costs Cost Quantity and price Material- fabric 11 500 metres costing N$20 per metre Direct labour 12 000 hours at a rate of N$30 per hour Administration and selling costs 10% of production costs The following hours will also be needed for the 1 000 suits Cutting Sewing Direct Labour Hours 1000 1 Machine hours 700 500 Finishing 700 300 200 NS 120 Budgeted expenses and other details for the year ended 28 February 2020 were as follows: Table 1 Budgeted manufacturing costs and overhead allocation bases Material Total Cutting Sewing Finishing store Canteen Maintenance NS NS NS NS NS NS Direct wages (NS) 000 50 000 30 000 40 000 100 Indirect wages (NS) 000 10 000 20 000 20 000 32 000 10 000 8.000 Consumables (NS) 50 000 5 000 4 000 20 000 15 000 6000 Depreciation - Equip (NS) 90 000 ? ? ? ? Fuel (NS) 30 000 ? ? ? ? ? Heat and light (NS) 15 000 777 77 Rental and prop Taxes NS) 45 000 ? ? ? 300 100 Equipment Value (NS) 000 000 60 000 100 000 10000 10 000 20 000 Number of Employees 250 25 100 1 100 1010 Floor space used (m) 30 000 9000 9000 8000 2000 1000 1 000 Fuel usage (8) 100 30110 401 105 100 Direct labour hours 000 8 000 50 000 42 000 Machine hours 90 000 15000 45000 30 000 Material issues (%) 100 60 15 15 . . It is company policy to allocate (absorb) manufacturing overheads in the cutting department based on direct labour hours while the manufacturing overheads in the sewing and finishing departments are allocated (absorbed) based on machine hours. 5 Required: Using examples that relate to this question, explain the difference between apportionment of overheads and allocation (or absorption) of overheads Perform a primary apportionment of production overheads to respective departments clearly showing the basis of apportionment. Answers without bases of apportionment will be regarded as guesswork and will not get any 52 mark Now assume that the primary apportionment has been correctly done for you as follows: Table 2: Primary allocation of production overheads Material Total Cutting Sewing Finishing store Canteen Maintenance NS NS N$ N$ NS Total overheads 330 000 72 000 63 000 98 000 42 000 31 500 23 500 Mark 10 Required: Using the primary apportioned overheads in Table 2. and any relevant Information from the question including Table 1. perform a secondary overhead apportionment of service departmental overheads to production departments using (1) appropriate basis of apportionment and ) applicable method(s) of apportioning service departmental overheads to production departments Calculate the predetermined overhead rates to be used in each of the three production departments 5.6 Determine the sales value of the 1 000 suits ordered Assuming that for the year ended 28 February 2019 the actual manufacturing overheads for the sewing department were N$110 000. actual machine hours 5.7 were 14 000 hours and actual direct labour hours were 9 000 hours, calculate the over/under absorption of manufacturing overheads in the sewing departments 58 Explain how underlover recoveries of overheads arise and why pre-determined overhead rates are used Total QUESTION 5 (40 MARKS) Bino Lid produces suits in three separate production departments (viz. Cutting Sewing and Finishing). Production is serviced by three service centres (viz. Material store, Canteen and Maintenance) The Material store cost centre's costs are apportioned to other departments using the direct method while the reciprocal method based on simultaneous equations is used to apportion Canteen and Maintenance centres costs. The Maintenance costs are apportioned based on floor area. It is Bino's policy to set selling prices to ensure a profit margin of 30% on sales The company received a new order for 1 000 suits which will require the following costs Cost Quantity and price Material- fabric 11 500 metres costing N$20 per metre Direct labour 12 000 hours at a rate of N$30 per hour Administration and selling costs 10% of production costs The following hours will also be needed for the 1 000 suits Cutting Sewing Direct Labour Hours 1000 1 Machine hours 700 500 Finishing 700 300 200 NS 120 Budgeted expenses and other details for the year ended 28 February 2020 were as follows: Table 1 Budgeted manufacturing costs and overhead allocation bases Material Total Cutting Sewing Finishing store Canteen Maintenance NS NS NS NS NS NS Direct wages (NS) 000 50 000 30 000 40 000 100 Indirect wages (NS) 000 10 000 20 000 20 000 32 000 10 000 8.000 Consumables (NS) 50 000 5 000 4 000 20 000 15 000 6000 Depreciation - Equip (NS) 90 000 ? ? ? ? Fuel (NS) 30 000 ? ? ? ? ? Heat and light (NS) 15 000 777 77 Rental and prop Taxes NS) 45 000 ? ? ? 300 100 Equipment Value (NS) 000 000 60 000 100 000 10000 10 000 20 000 Number of Employees 250 25 100 1 100 1010 Floor space used (m) 30 000 9000 9000 8000 2000 1000 1 000 Fuel usage (8) 100 30110 401 105 100 Direct labour hours 000 8 000 50 000 42 000 Machine hours 90 000 15000 45000 30 000 Material issues (%) 100 60 15 15 . . It is company policy to allocate (absorb) manufacturing overheads in the cutting department based on direct labour hours while the manufacturing overheads in the sewing and finishing departments are allocated (absorbed) based on machine hours. 5 Required: Using examples that relate to this question, explain the difference between apportionment of overheads and allocation (or absorption) of overheads Perform a primary apportionment of production overheads to respective departments clearly showing the basis of apportionment. Answers without bases of apportionment will be regarded as guesswork and will not get any 52 mark Now assume that the primary apportionment has been correctly done for you as follows: Table 2: Primary allocation of production overheads Material Total Cutting Sewing Finishing store Canteen Maintenance NS NS N$ N$ NS Total overheads 330 000 72 000 63 000 98 000 42 000 31 500 23 500 Mark 10 Required: Using the primary apportioned overheads in Table 2. and any relevant Information from the question including Table 1. perform a secondary overhead apportionment of service departmental overheads to production departments using (1) appropriate basis of apportionment and ) applicable method(s) of apportioning service departmental overheads to production departments Calculate the predetermined overhead rates to be used in each of the three production departments 5.6 Determine the sales value of the 1 000 suits ordered Assuming that for the year ended 28 February 2019 the actual manufacturing overheads for the sewing department were N$110 000. actual machine hours 5.7 were 14 000 hours and actual direct labour hours were 9 000 hours, calculate the over/under absorption of manufacturing overheads in the sewing departments 58 Explain how underlover recoveries of overheads arise and why pre-determined overhead rates are used Total