Please solve the problem # 41 from chapter 14 of the textbook (on page 445) showing all details of your solution procedure, clearing showing all planned order receipts and planned order releases and answering the questions at the end of the case on page 445. The MPS for product A calls for 100 units to be completed in week 4 and 200 units in week 7 (the lead time is one week). Spare part demand for Item B is 10 units per week. The bill of materials for product A is shown in Exhibit 14.34, and the inventory records are shown below. a) Develop a material requirement plan for the next 7 weeks for items B and C. b) Will any action notices be generated? If so, what are they and explain why they must be generated. c) What would be the impact of a scheduled receipt of 100 units for item B in week 2 (and all other data remained the same) on your calculated planned order receipts and releases?

d) Please show in detail these impacts quantitatively in your answers.

Please solve the question and do not copy paste preexisting solutions here

Exhibit 14.34 Bill of Material for Problem 41 (B(1) C(2) (B(11) Item Item B FOQ = 500 2. Data category Lot sizing rule Lead time (weeks) Beginning (on-hand) inventory Scheduled receipts LFL 3 100 10 none 200 (week 2) Exhibit 14.34 Bill of Material for Problem 41 (B(1) C(2) (B(11) Item Item B FOQ = 500 2. Data category Lot sizing rule Lead time (weeks) Beginning (on-hand) inventory Scheduled receipts LFL 3 100 10 none 200 (week 2)