Problem 2 (4.0 pts.) Consider the BOM below. End Item Item A (3) 1 week Item B (2) 2 weeks Item C (1) 3 weeks Item D (2) 2 weeks Item E (1) 2 weeks Item B (2) 2 weeks Item E (1) Item F (2) 2 week 1 week The forecasted demand and scheduled receipts for End Item is shown in the table below. Currently, there are no on-hand inventory Week Demand Scheduled Receipts 11 100 12 90 30 13 90 14 100 30 15 120 16 110 30 17 90 (2a) Create an MPS for the End Item (2b) Using Lot-for-Lot method, create an MRP table to calculate the Planned Order Release for Item A. (20) Using Lot-for-Lot method, create an MRP table to calculate the Planned Order Release for Item C. (20) Based on your response to 25 and 2c, using lot size of 600 units, create an MRP table to calculate the Planned Order Release for Item E. (2) For Item E MRP calculated in 2d, setup cost is $3,000 per setup, holding cost is $5 per unit per week. What is the total relevant costs (i.e. holding and setup)