Question

In: Operations Management

One unit of A is made of two units of B, three units of C, and...

One unit of A is made of two units of B, three units of C, and two units of D. B is composed of one unit of E and two units of F. C is made of two units of F and one unit of D. E is made of two units of D. Items A, C, D, and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D; lots of size 60 and 200 are used for Items E and F, respectively. Item C has an on-hand (beginning) inventory of 10; D has an on-hand inventory of 50; all other items have zero beginning inventory. We are scheduled to receive 20 units of Item E in Week 2; there are no other scheduled receipts.

If 20 units of A are required in Week 8, use the low-level-coded bill-of-materials to find the necessary planned order releases for all components. (Leave no cells blank - be certain to enter "0" wherever required.)

Solutions

Expert Solution

A
LT 1
Q = L4L

On Hand

1

2

3

4

5

6

7

8

Gross Requirement

0

0

0

0

0

0

0

20

Scheduled Receipts

0

0

0

0

0

0

0

0

Projected on Hand

0

0

0

0

0

0

0

0

0

Net Requirements

0

0

0

0

0

0

0

20

Planned Order Receipts

0

0

0

0

0

0

0

20

Planned Order Releases

0

0

0

0

0

0

20

0

B
LT 2
Q = L4L

Gross Requirement

0

0

0

0

0

0

40

0

Scheduled Receipts

0

0

0

0

0

0

0

0

Projected on Hand

0

0

0

0

0

0

0

0

0

Net Requirements

0

0

0

0

0

0

40

0

Planned Order Receipts

0

0

0

0

0

0

40

0

Planned Order Releases

0

0

0

0

40

0

0

0

C
LT 1
Q = L4L

Gross Requirement

0

0

0

0

0

0

60

0

Scheduled Receipts

0

0

0

0

0

0

0

0

Projected on Hand

10

10

10

10

10

10

10

0

0

Net Requirements

0

0

0

0

0

0

50

0

Planned Order Receipts

0

0

0

0

0

0

50

0

Planned Order Releases

0

0

0

0

0

50

0

0

E
LT 2
Q = 60

Gross Requirement

0

0

0

0

40

0

0

0

Scheduled Receipts

0

20

0

0

0

0

0

0

Projected on Hand

0

0

20

20

20

40

40

40

40

Net Requirements

0

0

0

0

20

0

0

0

Planned Order Receipts

0

0

0

0

60

0

0

0

Planned Order Releases

0

0

60

0

0

0

0

0

F
LT 1
Q = 200

Gross Requirement

0

0

0

0

80

100

0

0

Scheduled Receipts

Related Solutions

One unit of A is made of two units of B, three units of C, and...
One unit of A is made of two units of B, three units of C, and two units of D. B is composed of one unit of E and two units of F. C is made of two units of F and one unit of D. E is made of two units of D. Items A, C, D, and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for...
One unit of A is made of three units of B, one unit of C, and...
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is...
One unit of A is made of three units of B, one unit of C, and...
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F.      Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks.      Assume that lot-for-lot (L4L) lot sizing is...
One unit of A is made of three units of B, one unit of C, and...
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is...
One unit of A is made of three units of B, one unit of C, and...
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is...
One unit of A is composed of two units of B and three units of C....
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. Items A, B, C, and D have 20, 40, 60, 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 require multiples of 50,...
One unit of A is composed of two units of B and three units of C....
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. Items A, B, C, and D have 15, 40, 36, 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 require multiples of 62,...
One unit of A is composed of two units of B and three units of C....
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. Items A, B, C, and D have 10, 60, 60, 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 require multiples of 60,...
Each unit of A is composed of one unit of B, two units of C, and...
Each unit of A is composed of one unit of B, two units of C, and one unit of D. C is composed of two units of D and three units of E. Items A, C, D, and E have on-hand inventories of 20, 10, 20, and 10 units, respectively. Item B has a scheduled receipt of 10 units in Period 1, and C has a scheduled receipt of 50 units in Period 1. Lot-for-lot (L4L) lot sizing is used...
Problem 9-16 One unit of A is composed of two units of B and three units...
Problem 9-16 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. Items A, B, C, and D have 15, 50, 45, 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 require multiples...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT