Solve problem 3 (part b only) on pages 647-648. The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand.
Item
Lead Time
Amount on Hand
Direct Component
End
1
–
L(2), C(1), K(3)
L
2
10
B(2), J(3)
C
2
15
G(2), B(2)
K
3
20
H(4), B(2)
B
2
30
J
3
30
G
3
5
H
2
–
An order for the end item is scheduled to be shipped at the start of week 8. What is the latest week that the order can be started and still be ready to ship on time? (Hint: you don’t need to develop an MRP plan)
A table is assembled using three components, as shown in the accompanying product structure tree. The company that makes the tale wants to ship 100 units at the beginning of day 4, 80 units at the beginning of day 5, 300 units at the beginning of day 6, and 200 units at the beginning of day 7. Receipts of 100 wood sections are scheduled at the beginning of day 2. There are 120 legs on hand. An additional 10 percent of the order size on legs is added for safety stock. There are 60 braces on hand with no safety stock requirement. Lead times (in days) for all items are shown in the following table. Prepare a material requirements plan using lot-for-lot ordering.
Lead Time Table
Quantity Lead Time
1 – 200 1
201 – 550 2
551 – 999 3
Product Structure Tree
Table
______________|____________
| | |
Wood sections (2) Braces (3) Legs (4)
Solution 2 Template:
Master Schedule
Day Number
1
2
3
4
5
6
7
8
for a table:
Quantity
 
 
 
 
 
 
 
 
Wood Sections
 
Gross requirements
 
 
 
 
 
 
 
 
 
 
Scheduled receipts
 
 
 
 
 
 
 
 
Quantity =
1-200
Projected on hand
 
 
LT =
1
Net requirements
 
 
Lot Size =
 
Planned-order receipts
 
 
 
 
Planned-order releases
 
 
 
 
 
 
 
 
Braces
 
Gross…