Materials requirements planning (MRP) In Tutorial Library

This is Tutorial details page

TITLE: Materials requirements planning (MRP)

CLASS / COURSE: Operations Research Assignment

QUESTION DESCRIPTION:

 

1. Correctly fill in the materials plans for all the items.  All lot sizing is lot-for-lot.

 

 

       
 
   
 

 


Item

Lead time

Inventory on hand

 

                       X                                   Y

X

1

45

 

              A                 B                         C

Y

1

35

 

             (1)               (2)                        (2)

A

2

45

 

 

B

2

410

 

                                                             B

C

3

220

 

                                                            (3)

 

Master Schedule

Period

1

2

3

4

5

6

7

8

9

10

11

12

X

10

10

20

10

35

20

10

30

5

15

 

 

Y

15

25

20

20

40

20

10

45

15

15

 

 

 

MRP Worksheets

Item:  X

Lead  

time=

1

Lot

Sizing

rule =

LFL

 

 

 

 

 

Gross Requirements

 

 

 

 

 

 

 

 

 

 

 

 

Scheduled Receipts

 

 

 

 

 

 

 

 

 

 

 

 

Projected on Hand         

 

 

 

 

 

 

 

 

 

 

 

 

Net Requirements

 

 

 

 

 

 

 

 

 

 

 

 

Planned Order Receipts

 

 

 

 

 

 

 

 

 

 

 

 

Planned Order Releases

 

 

 

 

 

 

 

 

 

 

 

 

 

Item:  Y

Lead  

time=

 

Lot

sizing

rule =

 

 

 

 

 

 

Gross Requirements

 

 

 

 

 

 

 

 

 

 

 

 

Scheduled Receipts

20

 

 

 

 

 

 

 

 

 

 

 

Projected on Hand        

 

 

 

 

 

 

 

 

 

 

 

 

Net Requirements

 

 

 

 

 

 

 

 

 

 

 

 

Planned Order Receipts

 

 

 

 

 

 

 

 

 

 

 

 

Planned Order Releases

 

 

 

 

 

 

 

 

 

 

 

 

 

Item:  A

Lead  

time=

 

Lot

sizing

rule =

 

 

 

 

 

 

Gross Requirements

 

 

 

 

 

 

 

 

 

 

 

 

Scheduled Receipts

 

 

 

 

 

 

 

 

 

 

 

 

Projected on Hand        

 

 

 

 

 

 

 

 

 

 

 

 

Net Requirements

 

 

 

 

 

 

 

 

 

 

 

 

Planned Order Receipts

 

 

 

 

 

 

 

 

 

 

 

 

Planned Order Releases

 

 

 

 

 

 

 

 

 

 

 

 

 

Item:  B

Lead  

time=

 

Lot

Sizing

rule =

 

 

 

 

 

 

Gross Requirements

 

 

 

 

 

 

 

 

 

 

 

 

Scheduled Receipts

 

 

 

 

 

 

 

 

 

 

 

 

Projected on Hand        

 

 

 

 

 

 

 

 

 

 

 

 

Net Requirements

 

 

 

 

 

 

 

 

 

 

 

 

Planned Order Receipts

 

 

 

 

 

 

 

 

 

 

 

 

Planned Order Releases

 

 

 

 

 

 

 

 

 

 

 

 

 

Period

1

2

3

4

5

6

7

8

9

10

11

12

Item:  C

Lead  

time=

 

Lot

Sizing

rule =

 

 

 

 

 

 

Gross Requirements

 

 

 

 

 

 

 

 

 

 

 

 

Scheduled Receipts

 

 

 

 

 

 

 

 

 

 

 

 

Projected on Hand        

 

 

 

 

 

 

 

 

 

 

 

 

Net Requirements

 

 

 

 

 

 

 

 

 

 

 

 

Planned Order Receipts

 

 

 

 

 

 

 

 

 

 

 

 

Planned Order Releases

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SOLUTION DESCRIPTION:   Completed Solution is attached. Click on Buy button and then download file to get full solution.

SUBJECTS / CATEGORIES:
1. Operation Research
2. Operations Management

DOWNLOAD QUESTION FILE:

$15.00 USD

Press BUY button to download solution of this Question.

Buy

Comment

    No comment on this tutorial.