Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Essentials Quick Access To The Important Facts And Concepts Complete Overview Simply Presented Easy To Grasp

Authors: Frank C. Giove, Accounting Study Guides

1st Edition

0878918795, 978-0878918799

More Books

Students also viewed these Accounting questions

Question

b. What groups were most represented? Why do you think this is so?

Answered: 1 week ago