**PLEASE SOLVE WTH HAND WRTNG, DON'T USE EXCEL**

PROBLEM-2) (35 pts) A company manufactures products X and Y. The table below contains the master production schedules for the two products. The weekly figures show the number of products that are planned for production start. 1 3 5 7 9 2 500 4 300 6 400 8 600 10 200 Week 1 Product X Product 300 Y 400 200 400 200 200 200 Product X consists of item A (2 pcs) and item B (4 pcs). Product Y consists of item B (3 pcs) and item C (2 pieces). Item C consists of item A (1 pes) and item D (2 pieces). Item A consists of item E (2 pcs) and item F (1 piece) The items have the following planning data: Lot Sizes Item A B C D E F Lead Time 3 weeks 2 week 2 weeks 2 week 2 week 2 week Stock on Hand (Pes.) 1500 1200 500 500 300 350 K= 100 h=1 a. Conduct an MRP calculation for 10 weeks for items A and B. (The lot sizes are determined according to the silver meal algorithm) (30 pts) b. Calculate the total cost (Inventory holding cost and setup cost) (5 pts)