Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data is provide the question below Kindly anwer question A to E TQ 1. Ali is planning a budget to purchase the motors from b
Data is provide the question below Kindly anwer question A to E TQ
1. Ali 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 and data given from below identify the following aspects of the inventory policy for the motors. All the data was given on below. a) 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 data is gvien, anwer from question a-e) TQ! 1 Year 2 E 4 5 4 5 6 7 . 6: 10 11 17 13 14 15 10 17 Rearrange the same data in the following format: 15 NOV Madlyw Uge 2 WTIME 15 27 SEP 4 5 SUMMUT 9 7 & 6 30 11 13 2019 2020 2021 2022 14 15 16 P 18 19 21 C Year Quarter Period 1 Flag Flag Flag Flag Sales t M 1 WIN |1 2 2 21 12 al 31 31 3 4 4 41 4 1 TE Quarter 1 Quarter 2 Quarter 3 Quarter 4 465 476 581 422 E E 485 517 F 4 41 4 4 2 16 16 TE 3 3 4 1 2 3 4 1 22 E 1 2 3 12 GEFUND 1 al ET E 3 2 4 1 MUST 1 al El 30 4 4 11 30 # Onderstoder fre P 1 2 3 12 # 4 4 15 501 542 550 6 7 E 10 11 5 12 13 14 15 16 d 21 E 0 4 k 17 18 4 E 19 20 16 201 11 12 13 14 25 S jot o 3 E of of o of E 1 d of 0 of 1 al of 30 0 10 Predicted Sales value for all quarters for 2023 as follows: D 13 Year Quarter Period 1 Flag 02 Flag Q3 Flag Flag Sales po of O 595 540 571 466 To p 1 P E a of C E c D C of P Po FORAMIN jo 4 18 C C C CO -11 10 of of PP P P of of O d C 1: of 10 199 492 528 Tr P d 4 C 4 E C 0 of E P d 6 of E D of 6 jp P 1331 12 of d D of 10 A P 10 jo E JP 10 C jo 10 465 475 0 350 581 10 e 13 10 10 to 11 A a 4 301 E C 540 d E JB P 12 P 301 C 540 399 485 542 = d 10 200 31 381 432 4 10 10 10 46 542 # 371 492 4 317 950 M KCP 16 492 517 550 400 www 338 Predicted Sales ISP 329 334 343 1. Ali 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 and data given from below identify the following aspects of the inventory policy for the motors. All the data was given on below. a) 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 data is gvien, anwer from question a-e) TQ! 1 Year 2 E 4 5 4 5 6 7 . 6: 10 11 17 13 14 15 10 17 Rearrange the same data in the following format: 15 NOV Madlyw Uge 2 WTIME 15 27 SEP 4 5 SUMMUT 9 7 & 6 30 11 13 2019 2020 2021 2022 14 15 16 P 18 19 21 C Year Quarter Period 1 Flag Flag Flag Flag Sales t M 1 WIN |1 2 2 21 12 al 31 31 3 4 4 41 4 1 TE Quarter 1 Quarter 2 Quarter 3 Quarter 4 465 476 581 422 E E 485 517 F 4 41 4 4 2 16 16 TE 3 3 4 1 2 3 4 1 22 E 1 2 3 12 GEFUND 1 al ET E 3 2 4 1 MUST 1 al El 30 4 4 11 30 # Onderstoder fre P 1 2 3 12 # 4 4 15 501 542 550 6 7 E 10 11 5 12 13 14 15 16 d 21 E 0 4 k 17 18 4 E 19 20 16 201 11 12 13 14 25 S jot o 3 E of of o of E 1 d of 0 of 1 al of 30 0 10 Predicted Sales value for all quarters for 2023 as follows: D 13 Year Quarter Period 1 Flag 02 Flag Q3 Flag Flag Sales po of O 595 540 571 466 To p 1 P E a of C E c D C of P Po FORAMIN jo 4 18 C C C CO -11 10 of of PP P P of of O d C 1: of 10 199 492 528 Tr P d 4 C 4 E C 0 of E P d 6 of E D of 6 jp P 1331 12 of d D of 10 A P 10 jo E JP 10 C jo 10 465 475 0 350 581 10 e 13 10 10 to 11 A a 4 301 E C 540 d E JB P 12 P 301 C 540 399 485 542 = d 10 200 31 381 432 4 10 10 10 46 542 # 371 492 4 317 950 M KCP 16 492 517 550 400 www 338 Predicted Sales ISP 329 334 343 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started