QUESTION: a is planning a budget to purchase the motors from b in 2023. Currently a is purchasing the motors quarterly.
Posted: Fri Jul 01, 2022 8:59 am
QUESTION: a is planning a budget to purchase the motors from b in 2023. Currently a is purchasing the motors quarterly. But, now they have decided to apply EOQ model instead of purchasing quarterly. Assume that a is now experiencing regular demand from the customer, the ordering cost is RM50 per order, the unit cost is RM320 per motor, and annual holding cost are 20% of the unit cost. a also has 250 working days per year and a lead time of 5 days. Based on the result from Q2) identify the following aspects of the inventory policy for the motors: Economic order quantity (EOQ) b) Reorder point c) Cycle time d) Total annual inventory cost e) If a want to choose between quarterly and EOQ, which purchasing practice would you recommend to it. Justify your selection. Below is the data and details provided, please do it step by step TQ Table 1 show a's quarterly demand over the past four years (2019-2022). A 1 2 3 4 3 4 S 1 Year 4 7 A 9 10 11 12 Year 13 14 15 16 17 18 19 20 2010 2020 2021 2022 A 1 1 # C D Quarter 1 Quarter 2 Quarter 3 Quarter 4 465 476 596 181 422 501 340 399 542 571 492 500 400 528 C G M Quarter Period 1 Flag Q2 Flag Q3 Flag Q4 Flag Sales al 31 21 2 4 4 4 11 31 3 H 41 485 517 3 El al S 31 D 4 1 2 $1 4 1 2 D 4 1 3 D 4 11 3 3 4 2 3 4 3 s 2 3 31 30 31 32 13 14 15 30 37 31 23 20 E d of E Cl of 6 31 E o of 1 a d D 1 d af d 1 0 0 0 1 0 ol 1 0 C D 1 D 0 D 31 0 0 of # of # of # 41 d 4 E el of G 1 d of G 11 of 46 of c # # of O El a C d EL of C C E of d of 465 470 395 581 472 501 540 399 405 542 573 412 317 Predicted Sales 530 406 528 464 301 334 541