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
icon
Related questions
Question
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
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
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Special order decisions
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L