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 Ke. Glue 0.2 Kg, Glass 5 SFT, 3K, Ke5 , while for Product it is Wood 1.5 CFT, Plastic 3ke, Steel 12 kg. Glue 0.3kg and Glass 4SFT 3Kg Kg, Demand for product 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: MRP Materials Wood Plastic Steel Unit CFT kg Kg Glue Sr.# Product Glass SFT kg 1 1 B.O.M Demand Quantity 2 500 1000 3 500 1500 10 500 0.2 500 100 5 500 2500 5000 4 2 B B.O.M Demand Quantity 1.5 700 1050 3 700 2100 12 700 8400 0.3 700 210 700 2800 Total for one month 2050 3600 13400 310 5300 CFT Kg Kg Kg SFT Case to Solve: A company is producing 3 products A,B and C. BOM of each product is given in the table below. Material Unit Product A Products Product C Steel Ton 5 6 4 Aluminum KG 50 40 60 Wood CFT 10 0 10 Glass SFT 0 30 30 Rubber Sealer RFT 100 120 0 Screws Pack 5 6 6 4 Nut Bolt Dozen 2 3 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