Case Study 2 Mentara Bumi Berhad produces three products, the 'Gadget', the Midget and the 'Widget' Each of the products requires the use of labour and of materials, including a special material, 'Material X. Manufacturing labour is equally capable of working on all three products. Demand for all three products has increased strongly over recent months and is expected to remain high. Information about the products, relating to the foreseeable future, is as follows: Gadgets Material X usage (metres per product) 55 Manufacturing labour (minutes per product) 40 Selling price (RM per product) 20.00 Other materials (RM per product) 1.50 Expected demand (units a week) 200 Manufacturing overheads Midgets Widgets 25 20 35 50 16.00 20.00 1.00 1.00 500 200 see below -------- Material X costs the business RM0.10 a metre and the manufacturing workers are paid RM8 an hour. The manufacturing workers are all employed on contracts that guarantee all 12 of them a 40-hour week (that is, the manufacturing workers are paid RM320 a week, irrespective of the amount of work carried out). There are no other employment costs associated with the workers. It is not possible to expand the staff by employing other manufacturing workers and the existing ones are reluctant to work overtime. Material X is in short supply and only 30,000 metres a week are expected to be available for the foreseeable future. The business holds no inventories of Material X Supplies of it are received at the beginning of each week. The business incurs manufacturing overheads that are believed to be partially fixed and partially variable with manufacturing labour time. During two recent consecutive weeks, these costs RM2,700 in week one and RM3,010 in week two. Output for those two weeks was as follows: Widgets Gadgets 150 150 Week one Week two Midgets 320 380 160 180 There have not been, nor are there expected to be in the foreseeable future, any price changes, either of sales prices or of cost elements. (a) Required: Show calculations that indicate whether it is the current level of staffing or the supply of Material X that will constrain the business from meeting the expected demand for baskets. (10 marks) (b) Determine, with clear workings and justification (including assumptions made), the optimal quantity of each product that the business should produce each week. (25 marks) (c) Determine: The maximum amount that the business should be prepared to pay as an overtime rate to the manufacturing workers, should any of them be prepared to work extra hours. The maximum amount that the business should be prepared to pay for any additional quantities of Material X. In each case explain how any additional resources would be deployed, if at all. (5 marks) (d) Explain possible steps that the business might take to improve its profitability in the near future. (5 marks) Case Study 2 Mentara Bumi Berhad produces three products, the 'Gadget', the Midget and the 'Widget' Each of the products requires the use of labour and of materials, including a special material, 'Material X. Manufacturing labour is equally capable of working on all three products. Demand for all three products has increased strongly over recent months and is expected to remain high. Information about the products, relating to the foreseeable future, is as follows: Gadgets Material X usage (metres per product) 55 Manufacturing labour (minutes per product) 40 Selling price (RM per product) 20.00 Other materials (RM per product) 1.50 Expected demand (units a week) 200 Manufacturing overheads Midgets Widgets 25 20 35 50 16.00 20.00 1.00 1.00 500 200 see below -------- Material X costs the business RM0.10 a metre and the manufacturing workers are paid RM8 an hour. The manufacturing workers are all employed on contracts that guarantee all 12 of them a 40-hour week (that is, the manufacturing workers are paid RM320 a week, irrespective of the amount of work carried out). There are no other employment costs associated with the workers. It is not possible to expand the staff by employing other manufacturing workers and the existing ones are reluctant to work overtime. Material X is in short supply and only 30,000 metres a week are expected to be available for the foreseeable future. The business holds no inventories of Material X Supplies of it are received at the beginning of each week. The business incurs manufacturing overheads that are believed to be partially fixed and partially variable with manufacturing labour time. During two recent consecutive weeks, these costs RM2,700 in week one and RM3,010 in week two. Output for those two weeks was as follows: Widgets Gadgets 150 150 Week one Week two Midgets 320 380 160 180 There have not been, nor are there expected to be in the foreseeable future, any price changes, either of sales prices or of cost elements. (a) Required: Show calculations that indicate whether it is the current level of staffing or the supply of Material X that will constrain the business from meeting the expected demand for baskets. (10 marks) (b) Determine, with clear workings and justification (including assumptions made), the optimal quantity of each product that the business should produce each week. (25 marks) (c) Determine: The maximum amount that the business should be prepared to pay as an overtime rate to the manufacturing workers, should any of them be prepared to work extra hours. The maximum amount that the business should be prepared to pay for any additional quantities of Material X. In each case explain how any additional resources would be deployed, if at all. (5 marks) (d) Explain possible steps that the business might take to improve its profitability in the near future