the optimal quantity is 2000 kg per month

Assume you are the management accountant for the Foleo Group. Tracey Chen, the CFO, has called you into a meeting, to discuss the performance of the Warehouse Manager of the Foleo Fones business unit in managing his inventory stocks. After his last meeting with the Production Manager, Allan Raymond, the Business Unit GM, has supplied Tracey with below data relating to the inventory management practices for the current year. Tracey asks you analyse this data and before her Board meeting next week. Inventory Management Activities Selection of Supplier Warehouse rental (variable) Handling of inventory Transportation of inventory Insurance Unloading delivered inventory from freight truck Inspecting delivered orders Spoilage and obsolescence of inventory Theft of inventory Current Year's Cost $300 $90,000 $1,100 $600 $7,400 $750 $900 $6,000 $4,300 The Production Manager has indicated that the Foleo Fones plant requires 24,000 kg of plastics annually and on average, the lead time for deliveries of the plastics is one month. He has also advised he orders 2,000 kg per month, and that the monthly usage typically fluctuates between 1,800 and 2,500 kg. This practice has resulted regularly in stock-out situations. The Manager has also estimated that the above ordering costs will increase by 5% and the carrying costs by 7% next year. (a) Using the above data, calculate the following: the amount of ordering cost that should be used in the EOQ formula, the amount of carrying cost that should be used in the EOQ formula, and the optimum order quantity for the plastics raw materials required to produce the SliFones for the CURRENT YEAR using the EOQ formula. (HINT: show all your workings and round up your EOQ if necessary.) (HINT: the above data is for the entire year, so you will need to calculate the total components for the year and then convert them to what you will need for the EOQ formula.) (1.5 marks) (b) Based on your calculations above, how many orders at the EOQ would be made for the plastics raw materials this year? (HINT: Show all your workings and round the number of orders up if necessary) (0.25 mark) (c) Based on the Production Manager's estimations of cost increases, calculate the EOQ for the plastics raw materials for the NEXT YEAR. (HINT: Show all your workings and round your EOQ up if necessary) (1 mark) (d) Based on your calculations in part (c), how many orders will now be made for the plastics raw materials next year? (HINT: Show all workings and round the number of orders up if necessary) (0.25 mark) (e) Using the appropriate formula and your EOQ from part (c) above, calculate the total annual cost of ordering and holding inventory for the plastics raw materials for the coming year (show all your workings). (1 mark) (f) Calculate the Safety Stock for the plastics raw materials (show all your workings). (0.5 mark) (g) Calculate the Reorder Point for the plastics raw materials (show all your workings) (0.5 mark) Assume you are the management accountant for the Foleo Group. Tracey Chen, the CFO, has called you into a meeting, to discuss the performance of the Warehouse Manager of the Foleo Fones business unit in managing his inventory stocks. After his last meeting with the Production Manager, Allan Raymond, the Business Unit GM, has supplied Tracey with below data relating to the inventory management practices for the current year. Tracey asks you analyse this data and before her Board meeting next week. Inventory Management Activities Selection of Supplier Warehouse rental (variable) Handling of inventory Transportation of inventory Insurance Unloading delivered inventory from freight truck Inspecting delivered orders Spoilage and obsolescence of inventory Theft of inventory Current Year's Cost $300 $90,000 $1,100 $600 $7,400 $750 $900 $6,000 $4,300 The Production Manager has indicated that the Foleo Fones plant requires 24,000 kg of plastics annually and on average, the lead time for deliveries of the plastics is one month. He has also advised he orders 2,000 kg per month, and that the monthly usage typically fluctuates between 1,800 and 2,500 kg. This practice has resulted regularly in stock-out situations. The Manager has also estimated that the above ordering costs will increase by 5% and the carrying costs by 7% next year. (a) Using the above data, calculate the following: the amount of ordering cost that should be used in the EOQ formula, the amount of carrying cost that should be used in the EOQ formula, and the optimum order quantity for the plastics raw materials required to produce the SliFones for the CURRENT YEAR using the EOQ formula. (HINT: show all your workings and round up your EOQ if necessary.) (HINT: the above data is for the entire year, so you will need to calculate the total components for the year and then convert them to what you will need for the EOQ formula.) (1.5 marks) (b) Based on your calculations above, how many orders at the EOQ would be made for the plastics raw materials this year? (HINT: Show all your workings and round the number of orders up if necessary) (0.25 mark) (c) Based on the Production Manager's estimations of cost increases, calculate the EOQ for the plastics raw materials for the NEXT YEAR. (HINT: Show all your workings and round your EOQ up if necessary) (1 mark) (d) Based on your calculations in part (c), how many orders will now be made for the plastics raw materials next year? (HINT: Show all workings and round the number of orders up if necessary) (0.25 mark) (e) Using the appropriate formula and your EOQ from part (c) above, calculate the total annual cost of ordering and holding inventory for the plastics raw materials for the coming year (show all your workings). (1 mark) (f) Calculate the Safety Stock for the plastics raw materials (show all your workings). (0.5 mark) (g) Calculate the Reorder Point for the plastics raw materials (show all your workings) (0.5 mark)