Question: please don't do it in excell Order Quantity 500 Week desired 4 1 2 400 5 3 300 1 4 300 7 5. The BOM

please don't do it in excell please don't do it in excell Order Quantity 500
Order Quantity 500 Week desired 4 1 2 400 5 3 300 1 4 300 7 5. The BOM for product A and data from the inventory records are given below. The MPS start row in the master production schedule for product A calls for 50 units in weeks 2, 6, 8, and 9. Develop the material requirements plan for the next 10 weeks for each item. 2... LT=1 B3 LT = 2 C(1) LT-3 001) (1) (E(2 (F(1) LT = 3 LT = 6 LT=1 LT = 3 G(1 LT=3 BOM for product A Item B D E F G L4L L4L L4L L4L FOO-100 Lot-size rule Lead time Safety stock POQ ( P2) 3 weeks 6 weeks 1 week 3 weeks 2 weeks 30 3 weeks 10 0 0 0 0 SO 400 None None Scheduled receipts On-hand inventory 150 (week 2) 30 (week 6) (week 2) 20 40 (week 3) 0 60 400 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!