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 Product B Product C Steel Ton 5 6 4 Aluminum KG 50 40 60 Wood CFT 10 10 Glass SFT 30 30 Rubber Sealer RFT 100 120 Screws Pack 5 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
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 Product B Product C Steel Ton 5 6 4 Aluminum KG 50 40 60 Wood CFT 10 10 Glass SFT 30 30 Rubber Sealer RFT 100 120 Screws Pack 5 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
Pkg Acc Infor Systems MS VISIO CD
10th Edition
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:Ulric J. Gelinas
Chapter15: Integrated Production Processes (ipps)
Section: Chapter Questions
Problem 1SP
Related questions
Question

Transcribed Image Text: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:
MRP
Materials
Wood Plastic
Steel
Glue
Glass
Sr.# Product
Unit
CFT
Kg
Kg
Kg
SFT
В.О.M
3
10
0.2
1 A
Demand
500
500
500
500
500
Quantity
1000
1500
5000
100
2500
В.О.M
1.5
3
12
0.3
4
2 B
Demand
700
700
700
700
700
Quantity
1050
2100
8400
210
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
Product B
Product C
Steel
Ton
5
6
4
Aluminum
KG
50
40
60
Wood
CFT
10
10
Glass
SFT
30
30
Rubber Sealer
RFT
100
120
Screws
Pack
4
Nut Bolt
Dozen
2
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
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you

Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L

Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L