You are scheduling production of your popular Rustic Coffee table. The demand for these coffee tables is 640 tables on day 5, 640 tables on day 6 and 256 tables on day 7. The components of the table are a top and a base assembly. The base assembly is composed of 4 legs, 2 short braces and 2 long braces. There is a brass cap that goes on the bottom of each leg.
|
Item
|
On Hand
|
Safety Stock
|
Allocated
|
Lot Size*
|
Lead Time (Days)
|
Scheduled Receipts
|
|
Coffee table
|
100
|
25
|
25
|
LFL
|
1
|
|
|
Top
|
200
|
100
|
0
|
LFL
|
3
|
|
|
Base Assembly
|
50
|
0
|
50
|
LFL
|
1
|
600 at the start of Day 3
|
|
Short Braces
|
0
|
0
|
0
|
LFL
|
2
|
|
|
Long Braces
|
0
|
0
|
0
|
LFL
|
2
|
|
|
Legs
|
0
|
0
|
0
|
1000@
|
3
|
3,000 at the start of Day 1
|
|
Brass caps
|
2,000
|
0
|
0
|
1,000+
|
1
|
|
*Notes:
- The company wants to try buying a pre-assembled Base Assembly in the future so it has bought 600 from a potential supplier and these are scheduled to arrive at the start of Day 3. There are also 3,000 Legs already scheduled to arrive at the start of Day 1.
- For the brass caps, the plus (+) sign indicates the minimum order quantity is 1,000; above that the order quantity is LFL.
- For the Legs, the @ sign indicates that the legs are ordered in increments of 1,000.
a) Construct the product structure tree for the coffee table and all of the items required to construct the table.
b) Complete the MRP for the coffee table and all of the items required to construct the table.