Question 1 Diagio Ltd, manufactures four products Alpha, Beta, Gamma and Delta in Tuas View Industrial Park and one product F-1 in Jurong Industrial Estate. Diagio Ltd. operates under Just-in-time (JIT) principle and does not hold any inventory of either finished goods or raw materials. Diagio Ltd. has entered into an agreement with Mallya Ltd. to supply 10,000 units per month of each product produced from Tuas View Industrial Park at a contracted price. Diagio Ltd. is bound to supply these contracted units to Mallya Ltd. without any fail. Following are the details related with non-contracted units of Tuas View Industrial Park. (Amounts in $) Particulars Selling price per unit Direct labour at $55 per hour Direct material M-1 @ $49 per kilo Direct material M-2 @ $31 per litre | Variable overheads (varies with labour hours) Variable overheads (varies with machine hours) Total variable cost Alpha | 365.00 | 137.50 49.00 93.00 12.50 9.00 Beta 290.00 82.50 98.00 46.50 7.50 12.00 Gamma Delta 295.00 215.00 165.00 82.50 0 73.50 62.00 15.00 7501 9.00 15.00 301.00 246.50 251.00 178.50 Other information Alpha Beta Gamma Delta Particulars Machine hours per unit Maximum demand per month of non- contracted units 90,000 95,000 80,000 75,000 The products manufactured in Tuas View Industrial Park use direct material M-1 and M-2 but product F-1 produced in Jurong Industrial Estate is made by a distinct raw material Z. Material Z is purchased from the outside market at $210.00 per unit. One unit of F-1 requires one unit of material Z Material Z can also be manufactured at Tuas View Industrial Park but for this 2 hours of direct labour, 3 hours of machine time and 2.5 litres of material M-2 will be required. Required (a) Determine whether Diagio Ltd, should manufacture material Z in Tuas View Industrial Park or continue to purchase it from the market? Support your conclusion with relevant calculations. (b) The Purchase manager has reported to the production manager that material M-1 and M-2 are in short supply in the market and only 650,000 Kilos of M-1 and 600,000 litres of M-2 can be purchased in a month. Calculate the total monthly usage requirement of direct material M-1 and M-2 at Tuas View Industrial Park and compare it with the available supply in the market to decide if there is any limiting factor. (c) Determine the optimal usage of available resources of Tuas View Industrial Park which will maximise operating profit for Diagio Ltd. In other words, calculate the optimal number of units of each product Alpha, Beta, Gamma, Delta, and Z ACCT1068 Final Assessment SIM, Semester 1, 2020 Page 2 of 5 that Diagio Ltd must produce in order to maximise operating profit. Question 1 Diagio Ltd, manufactures four products Alpha, Beta, Gamma and Delta in Tuas View Industrial Park and one product F-1 in Jurong Industrial Estate. Diagio Ltd. operates under Just-in-time (JIT) principle and does not hold any inventory of either finished goods or raw materials. Diagio Ltd. has entered into an agreement with Mallya Ltd. to supply 10,000 units per month of each product produced from Tuas View Industrial Park at a contracted price. Diagio Ltd. is bound to supply these contracted units to Mallya Ltd. without any fail. Following are the details related with non-contracted units of Tuas View Industrial Park. (Amounts in $) Particulars Selling price per unit Direct labour at $55 per hour Direct material M-1 @ $49 per kilo Direct material M-2 @ $31 per litre | Variable overheads (varies with labour hours) Variable overheads (varies with machine hours) Total variable cost Alpha | 365.00 | 137.50 49.00 93.00 12.50 9.00 Beta 290.00 82.50 98.00 46.50 7.50 12.00 Gamma Delta 295.00 215.00 165.00 82.50 0 73.50 62.00 15.00 7501 9.00 15.00 301.00 246.50 251.00 178.50 Other information Alpha Beta Gamma Delta Particulars Machine hours per unit Maximum demand per month of non- contracted units 90,000 95,000 80,000 75,000 The products manufactured in Tuas View Industrial Park use direct material M-1 and M-2 but product F-1 produced in Jurong Industrial Estate is made by a distinct raw material Z. Material Z is purchased from the outside market at $210.00 per unit. One unit of F-1 requires one unit of material Z Material Z can also be manufactured at Tuas View Industrial Park but for this 2 hours of direct labour, 3 hours of machine time and 2.5 litres of material M-2 will be required. Required (a) Determine whether Diagio Ltd, should manufacture material Z in Tuas View Industrial Park or continue to purchase it from the market? Support your conclusion with relevant calculations. (b) The Purchase manager has reported to the production manager that material M-1 and M-2 are in short supply in the market and only 650,000 Kilos of M-1 and 600,000 litres of M-2 can be purchased in a month. Calculate the total monthly usage requirement of direct material M-1 and M-2 at Tuas View Industrial Park and compare it with the available supply in the market to decide if there is any limiting factor. (c) Determine the optimal usage of available resources of Tuas View Industrial Park which will maximise operating profit for Diagio Ltd. In other words, calculate the optimal number of units of each product Alpha, Beta, Gamma, Delta, and Z ACCT1068 Final Assessment SIM, Semester 1, 2020 Page 2 of 5 that Diagio Ltd must produce in order to maximise operating profit