Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Question 3: Mate rial Requirement Planning A company manufactures two products A

ID: 325533 • Letter: Q

Question

Question 3: Mate

rial Requirement Planning

A company manufactures two products A and B. Each A requires two C’s and one D. Each D requires two F’s and one E, while each E requires one F. Each product B requires one D and two E’s. The table below shows data from the inventory records.

The MPS for product A calls for 85 units to be started in week 3 and 100 units to be started in week 6. The MPS for product B calls for 180 units to be started in week 5.

Develop the material requirements plan for the next six weeks for items C, D, E and F.

D

Explanation / Answer

  

MPS -A                                                                                                                                                                                

Week

1

2

3

4

5

6

MPS

85

100

MRP-C (Fixed lot 220,Lead time =3 weeks ,Initial inventory=25)

Week

1

2

3

4

5

6

GR

200

SR

280

PAB (25)

305

305

135

135

135

155

POR

220

MRP D(lot for lot, Leadtime =2 weeks, Initial Inventory=0)

Week

1

2

3

4

5

6

GR

85

0

0

100

SR

PAB (0)

0

0

0

0

0

0

POR

85

100

MRP E(Fixed lot=300,LT=3 weeks, Initial Inventory=150)

Week

1

2

3

4

5

6

GR

100

0

0

0

0

0

SR

300

PAB (150)

65

65

365

565

0

0

POR

300

MRP F(POQ=2, initial inventory =600 LT=2 weeks)

Week

1

2

3

4

5

6

GR

0

200

SR

PAB (600)

130

0

0

0

POR

200

                                                               

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                MPS B

Week

1

2

3

4

5

6

MPS

180

MRP D

Week

1

2

3

4

5

6

GR

180

SR

PAB (0)

0

0

0

0

0

0

POR

180

MRP E

Week

1

2

3

4

5

6

GR

0

360

SR

300

PAB (300)

300

-60

240

240

180

180

POR

300

MRP F

Week

1

2

3

4

5

6

GR

0

0

SR

PAB (600)

600

300

300

300

300

300

POR

Week

1

2

3

4

5

6

MPS

85

100

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote