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

One unit of A is composed of two units of B and three units of C. Each B is comp

ID: 355687 • Letter: O

Question

One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of F. C is made of one unit of D, one unit of E, and two units of F, ltems A, B, C, and D have 20, 50, 30, and 25 units of on-hand inventory, respectively, Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F requre multiples of 50, 100, and 90, respectively, to be purchased. B has scheduled receipts of 20 units in Period 1. No other scheduled receipts exist. Lead times are one period for Items A, B, and D, and two periods for Items C, E, and F. Gross requirements for A are 20 units in Period 1, 10 units in Period 2, 55 units in Period 6, and 50 units in Period 8 Find the planned order releases for all items (Leave no cells blank be certain to enter "O" wherever required.) Gross requirements ltem A Scheduled receipts OH-20 Projeched LT 1 SS 0 Net requirements available balance Planned order receips Planned order releases Gross requirements Item 8 Scheduled receipts H1 5Projected available balance LT-1 SS Net requinements O LAL Planned order receipts Planned order lease Gross requirements ltem C Scheduled receipts CH 30 LT 2 SS 0 Net requirements Projected available balance Planned order receipts Planned order neleases Gross requirements ltem o Schedued recepts OH 25 LT-1 Projecled available balance SS Net requirements Planned order receipts Planned order releases

Explanation / Answer

MRP table is as follows:

Item: A
OH = 20
LT = 1
SS = 0
Q = L4L

1

2

3

4

5

6

7

8

GR

20

10

0

0

0

55

0

50

SR

PAB

20

NR

0

10

55

50

PORc

10

55

50

PORe

10

55

50

Each unit of A requires two unit of B, GR of B = 2 x (PORe of A)

Item: B
OH = 50
LT = 1
SS = 0
Q = L4L

1

2

3

4

5

6

7

8

GR

20

0

0

0

110

0

100

0

SR

20

PAB

50

50

50

NR

0

60

100

PORc

60

100

PORe

60

100

Each unit of A requires three unit of C, GR of C = 3 x (PORe of A)

Item: C
OH = 30
LT = 2
SS = 0
Q = L4L

1

2

3

4

5

6

7

8

GR

30

0

0

0

165

0

150

0

SR

PAB

30

NR

0

165

150

PORc

165

150

PORe

165

150

Each unit of C requires one unit of D, GR of CD = 1x (PORe of C)

Item: D
OH = 25
LT = 1
SS = 0
Q = 50

1

2

3

4

5

6

7

8

GR

0

0

165

0

150

0

0

0

SR

PAB

25

25

25

10

10

10

10

10

NR

0

140

140

PORc

150

150

PORe

150

150

Each unit of C requires one unit of E, GR of E = 1 x (PORe of C)

Item: E
OH = 0
LT = 2
SS = 0
Q = 100

1

2

3

4

5

6

7

8

GR

0

0

165

0

150

0

0

0

SR

PAB

35

35

85

85

85

NR

165

115

PORc

200

200

PORe

200

200

Each unit of B requires one unit of F and each unit of C requires wo units of F

GR of F = 1 x (PORe of B) +   2 x (PORe of C)

Item: F
OH = 0
LT = 2
SS = 0
Q = 90

1

2

3

4

5

6

7

8

GR

0

0

330

60

300

100

0

0

SR

PAB

30

60

30

NR

330

30

240

70

PORc

360

90

270

90

PORe

360

90

270

90

Item: A
OH = 20
LT = 1
SS = 0
Q = L4L

1

2

3

4

5

6

7

8

GR

20

10

0

0

0

55

0

50

SR

PAB

20

NR

0

10

55

50

PORc

10

55

50

PORe

10

55

50

Each unit of A requires two unit of B, GR of B = 2 x (PORe of A)

Item: B
OH = 50
LT = 1
SS = 0
Q = L4L

1

2

3

4

5

6

7

8

GR

20

0

0

0

110

0

100

0

SR

20

PAB

50

50

50

NR

0

60

100

PORc

60

100

PORe

60

100

Each unit of A requires three unit of C, GR of C = 3 x (PORe of A)

Item: C
OH = 30
LT = 2
SS = 0
Q = L4L

1

2

3

4

5

6

7

8

GR

30

0

0

0

165

0

150

0

SR

PAB

30

NR

0

165

150

PORc

165

150

PORe

165

150

Each unit of C requires one unit of D, GR of CD = 1x (PORe of C)

Item: D
OH = 25
LT = 1
SS = 0
Q = 50

1

2

3

4

5

6

7

8

GR

0

0

165

0

150

0

0

0

SR

PAB

25

25

25

10

10

10

10

10

NR

0

140

140

PORc

150

150

PORe

150

150

Each unit of C requires one unit of E, GR of E = 1 x (PORe of C)

Item: E
OH = 0
LT = 2
SS = 0
Q = 100

1

2

3

4

5

6

7

8

GR

0

0

165

0

150

0

0

0

SR

PAB

35

35

85

85

85

NR

165

115

PORc

200

200

PORe

200

200

Each unit of B requires one unit of F and each unit of C requires wo units of F

GR of F = 1 x (PORe of B) +   2 x (PORe of C)

Item: F
OH = 0
LT = 2
SS = 0
Q = 90

1

2

3

4

5

6

7

8

GR

0

0

330

60

300

100

0

0

SR

PAB

30

60

30

NR

330

30

240

70

PORc

360

90

270

90

PORe

360

90

270

90