LLC Leadtime Lot Sizing Rule Item Skate Lace Box Board 11 Lot for Lot FOO-300 | Foo-400 Lot for Lot FOQ-800 Lot for Lot Lot for Lot |FOQ-1400 2 Wheel Assembly Body Axle Hardware 2| 3 BOM Draw Product Structures Here Boxed Skates Skates (2) Body Axle (2) Hardware (2) Wheel Assembly (2) Laces (2) Box Skateboard Board Wheel Assembly (4) Axle (4) Hardware (4) Complete the transaction files. On a separate sheet, of paper, make a list of any actions that should be taken in the first week.
Expert Answer
First, let us admit that the ‘Skateboard’ BOM’s indentation is wrong, the Wheel Assembly, Axle, and Hardware are having LLC=2 and that of the Board is 1, so, the BOM should be as following:
Skateboard
- Board
- Wheel Assembly (4)
- Axle (4)
- Hardware (4)
Also, note that the FOQ of ‘Lace’ is different in the first table (300) and in the MRP table (500). I have taken it 500.
—————————
Product trees
—————————–
MPS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |
Boxed Skates | 80 | 80 | 140 | |||||||
Skateboards | 150 | 150 | 200 | |||||||
Skate | Leadtime = 1 week | L4L | SS = 0 | |||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
Gross Req | 0 | 160 | 0 | 160 | 0 | 280 | 0 | 0 | 0 | |
Sch Rec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
On hand | 175 | 175 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 |
POR | 0 | 0 | 145 | 0 | 280 | 0 | 0 | 0 | 0 | |
Laces | Leadtime = 1 week | FOQ = 500 | SS = 50 | |||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
Gross Req | 0 | 160 | 0 | 160 | 0 | 280 | 0 | 0 | 0 | |
Sch Rec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
On hand | 300 | 300 | 140 | 140 | 480 | 480 | 200 | 200 | 200 | 200 |
POR | 0 | 0 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | |
Box | Leadtime = 2 weeks | FOQ = 400 | SS = 0 | |||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
Gross Req | 0 | 80 | 0 | 80 | 0 | 140 | 0 | 0 | 0 | |
Sch Rec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
On hand | 15 | 15 | 335 | 335 | 255 | 255 | 115 | 115 | 115 | 115 |
POR | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Board | Leadtime = 2 weeks | L4L | SS = 0 | |||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
Gross Req | 0 | 0 | 150 | 0 | 150 | 0 | 200 | 0 | 0 | |
Sch Rec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
On hand | 20 | 20 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
POR | 130 | 0 | 150 | 0 | 200 | 0 | 0 | 0 | 0 | |
Wheel Assy | Leadtime = 1 week | FOQ = 800 | SS = 0 | |||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
Gross Req | 520 | 160 | 600 | 160 | 800 | 280 | 0 | 0 | 0 | |
Sch Rec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
On hand | 450 | 730 | 570 | 770 | 610 | 610 | 330 | 330 | 330 | 330 |
POR | 800 | 0 | 800 | 0 | 800 | 0 | 0 | 0 | 0 | 0 |
Body | Leadtime = 2 weeks | L4L | SS = 0 | |||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
Gross Req | 0 | 80 | 0 | 80 | 0 | 140 | 0 | 0 | 0 | |
Sch Rec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
On hand | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
POR | 70 | 0 | 80 | 0 | 140 | 0 | 0 | 0 | 0 | 0 |
Axle | Leadtime = 1 week | L4L | SS = 35 | |||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
Gross Req | 520 | 0 | 890 | 0 | 1360 | 0 | 0 | 0 | 0 | |
Sch Rec | ||||||||||
On hand | 225 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 |
Net Req | 330 | 0 | 890 | 0 | 1360 | 0 | 0 | 0 | 0 | |
POR | 330 | 0 | 890 | 0 | 1360 | 0 | 0 | 0 | 0 | |
POR | 330 | 0 | 890 | 0 | 1360 | 0 | 0 | 0 | 0 | 0 |
Hardware | Leadtime = 3 weeks | FOQ=1400 | SS = 150 | |||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
Gross Req | 520 | 0 | 890 | 0 | 1360 | 0 | 0 | 0 | 0 | |
Sch Rec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
On hand | 700 | 180 | 180 | 690 | 690 | 730 | 730 | 730 | 730 | 730 |
POR | 1400 | 0 | 1400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |