12% 13:47 BAF 3021 - A...nment One ASSIGNMENT ONE BAF 3021: MANAGEMENT ACCOUNTING COHORT: JULY 2018 COHORT - FULL TIME/EVENING Instructions: Due date and time: 15 January 2021, 12:00 hours Submission type: By email-typed soft copy ASSIGNMENT PROBLEM Chansa Habeenzu plc makes and sells a range of products. Management has carried out an analysis of the total cost of production. The information in the table below reflects this analysis of budget cost for the six month period from 1 January to 30 June 2021 Table: Budget Data for Six months to 30 June 2021 Description Product A Product B Material cost per product unit K60 K45 Production line X - machine hours per unit 0.8 0.5 Production batch size (units) 100 200 Total production (units) 9000 15000 20 12 Components per product unit (quantity) Number of customers 5 10 Number of production line set-ups 15 25 Production line X - maintenance hours 300 150 Cost category Product line X (K) Factory total (K) 294,000 40,000 Labour, power, etc Set-up of machines Production Scheduling WIP movements 29,600 36,400 U DD Tools Mobile View Share Edit on PC dgn scieduling WIP movements 12% 13:47 36,400 Purchasing and receipt of material 49,500 Material scheduling system 18,000 Design/testing routine Production line development 16,000 25,000 9,000 Production line maintenance 500,000 General factory administration General factory occupancy 268,000 The analysis has identified that the factory is organized in order to permit the operation of three production lines X, Y and Z. Each production line facilitates the production of two or more products Production line X only used for the production of products A and B. The products are manufactured in batches on a just-in-time basis in order to fulfil orders from customers. Additional information is available for production line X as follows: 0 Production line machine costs including labour, power, etc., vary in proportion to machine hours, (11) Costs incurred for production scheduling, WIP movement, purchasing and receipt of materials are assumed to be incurred in proportion to the number of batches of product which are manufactured. Machine set-up costs vary in proportion to the number of set-ups required and are linked to a batch throughput system. (iii) Costs for material scheduling systems and design/testing routines are assumed to be incurred by each product in proportion to the total quantity of components purchased and the total number of types of components used respectively. The number of different components deigned/tested for products A and B are 12 and B respectively. (iv) Product line development cost is identified with changes in product design and production method. At present such costs for production line X are apportioned 80 per cent 20 per cent to products A and B respectively Production line maintenance costs are assumed to vary in proportion to the maintenance hours required for each product (v) General factory costs are apportioned to each of production lines X, Y and Z in the ratios 25 per cent: 30 per cent: 45 per cent respectively. Such costs are absorbed by product units at an average rate per unit through each production line Required: U DD Tools Mobile View Share Edit on PC Production line maintenance costs are assumed to vary in proportion to thaintenance hours required for ez Prict du 12% 13:47 (v) General factory costs are apportioned to each of production lines X, Y and Z in the ratios 25 per cent 30 per cent: 45 per cent respectively. Such costs are absorbed by product units at an average rate per unit through each production line Required: A. Prepare an activity based budget for production line X for six months to 30 June 2021 analysed into sub-sets for activities which are product unit based, batch based, product sustaining, production line sustaining and factory sustaining (30 Marks) The budget should show. 0 Total cost for each activity sub-set grouped to reflect the differing operational levels at which each sub-set is incurred/controlled. (11) Average cost per unit for each of products A and B analysed by activity sub-set. B. Discuss the incidence and use of each of the following terms in relation to Chansa Habeenzu plc, giving examples from the question to illustrate your answer 0 Hierarchy of activities (2 Marks) (11) Cost pools (2 Marks) (11) Cost drivers (2 Marks) C. Prepare a sequential set of steps which may be included in an investigation of activities in order to improve company profitability (14 Marks) END OF ASSIGNMENT DD U Tools Mobile View Share Edit on PC 12% 13:47 BAF 3021 - A...nment One ASSIGNMENT ONE BAF 3021: MANAGEMENT ACCOUNTING COHORT: JULY 2018 COHORT - FULL TIME/EVENING Instructions: Due date and time: 15 January 2021, 12:00 hours Submission type: By email-typed soft copy ASSIGNMENT PROBLEM Chansa Habeenzu plc makes and sells a range of products. Management has carried out an analysis of the total cost of production. The information in the table below reflects this analysis of budget cost for the six month period from 1 January to 30 June 2021 Table: Budget Data for Six months to 30 June 2021 Description Product A Product B Material cost per product unit K60 K45 Production line X - machine hours per unit 0.8 0.5 Production batch size (units) 100 200 Total production (units) 9000 15000 20 12 Components per product unit (quantity) Number of customers 5 10 Number of production line set-ups 15 25 Production line X - maintenance hours 300 150 Cost category Product line X (K) Factory total (K) 294,000 40,000 Labour, power, etc Set-up of machines Production Scheduling WIP movements 29,600 36,400 U DD Tools Mobile View Share Edit on PC dgn scieduling WIP movements 12% 13:47 36,400 Purchasing and receipt of material 49,500 Material scheduling system 18,000 Design/testing routine Production line development 16,000 25,000 9,000 Production line maintenance 500,000 General factory administration General factory occupancy 268,000 The analysis has identified that the factory is organized in order to permit the operation of three production lines X, Y and Z. Each production line facilitates the production of two or more products Production line X only used for the production of products A and B. The products are manufactured in batches on a just-in-time basis in order to fulfil orders from customers. Additional information is available for production line X as follows: 0 Production line machine costs including labour, power, etc., vary in proportion to machine hours, (11) Costs incurred for production scheduling, WIP movement, purchasing and receipt of materials are assumed to be incurred in proportion to the number of batches of product which are manufactured. Machine set-up costs vary in proportion to the number of set-ups required and are linked to a batch throughput system. (iii) Costs for material scheduling systems and design/testing routines are assumed to be incurred by each product in proportion to the total quantity of components purchased and the total number of types of components used respectively. The number of different components deigned/tested for products A and B are 12 and B respectively. (iv) Product line development cost is identified with changes in product design and production method. At present such costs for production line X are apportioned 80 per cent 20 per cent to products A and B respectively Production line maintenance costs are assumed to vary in proportion to the maintenance hours required for each product (v) General factory costs are apportioned to each of production lines X, Y and Z in the ratios 25 per cent: 30 per cent: 45 per cent respectively. Such costs are absorbed by product units at an average rate per unit through each production line Required: U DD Tools Mobile View Share Edit on PC Production line maintenance costs are assumed to vary in proportion to thaintenance hours required for ez Prict du 12% 13:47 (v) General factory costs are apportioned to each of production lines X, Y and Z in the ratios 25 per cent 30 per cent: 45 per cent respectively. Such costs are absorbed by product units at an average rate per unit through each production line Required: A. Prepare an activity based budget for production line X for six months to 30 June 2021 analysed into sub-sets for activities which are product unit based, batch based, product sustaining, production line sustaining and factory sustaining (30 Marks) The budget should show. 0 Total cost for each activity sub-set grouped to reflect the differing operational levels at which each sub-set is incurred/controlled. (11) Average cost per unit for each of products A and B analysed by activity sub-set. B. Discuss the incidence and use of each of the following terms in relation to Chansa Habeenzu plc, giving examples from the question to illustrate your answer 0 Hierarchy of activities (2 Marks) (11) Cost pools (2 Marks) (11) Cost drivers (2 Marks) C. Prepare a sequential set of steps which may be included in an investigation of activities in order to improve company profitability (14 Marks) END OF ASSIGNMENT DD U Tools Mobile View Share Edit on PC