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,...
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...
Assume that Product Z is made of two units of A and three units of B....
Assume that Product Z is made of two units of A and three units of B. A is made of three units of C and four of D. D is made of two units of E      Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks.      Fifty two units of Product Z are required in Period 10. (Assume that...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT