Case to Solve: A company is producing 3 products A,B and C. BOM of each product is given in the table below. Material Steel Aluminum Wood Glass Rubber Sealer Screws Nut Bolt Unit Product A Product B Product C Ton 5 6 KG 50 40 10 0 0 30 120 CFT SFT RFT Pack Dozen 100 5 2 6 3 60 10 30 0 4 2 Calculate the material requirements for 6 months production for all the products if monthly demand for A=1000, B-1200 and C=1500 units SCM323 Class Activity 3 - MRP Based on the Example below, Identify the Material Requirements for the case given at the end. Example: A company is producing 2 products A and B. Bill of Materials for product A includes, Wood 2 CFT, Plastic 3Kg, Steel 10 Kg. Glue 0.2 Kg. Glass 5 SFT, while for Product B it is Wood 1.5 CFT, Plastic 3Kg, Steel 12 Kg, Glue 0.3kg and Glass 4SFT. Demand for product A is 500 units/month, and for Product B, it is 700 units/month. Calculate the total quantity of materials required for the production of both the items for next 1 month. Solution for the Example: Sr.# Product 1 A 2 B Materials Unit B.O.M Demand Quantity B.O.M Demand Quantity Total for one month MRP Wood CFT 2 500 1000 1.5 700 1050 Plastic Steel Glue Kg Kg Kg 3 500 1500 10 500 5000 0.2 500 100 3 12 0.3 700 700 700 2100 8400 210 2050 3600 13400 CFT Kg Kg 310 Kg Glass SFT 5 500 2500 4 700 2800 5300 SFT