Question: A table is assembled using three components, as shown in the following product structure tree. The company that makes the table wants to ship 9

A table is assembled using three components, as shown in the following product structure tree. The company that makes the table wants to ship 90 units at the beginning of day 4,130 units at the beginning of day 5, and 170 units at the beginning of day 7. Receipts of 90 wood sections are scheduled at the beginning of day 2. There are 130 legs on hand. An additional 10 percent of the order size on legs is added for scrap allowance. There are 70 braces on hand. Lead time (in days) for all items is a function of each order quantity and is shown below.
Order Quantity Lead Time (days)
11701
1714002
4018003
Prepare the material requirements plan using lot-for-lot ordering. (Do not leave any empty spaces; input a 0 wherever it is required.)
Production Schedule
Day Beg. Inv. 1234567
Quantity 90130170
Table (*Variable LT) Beg. Inv. 1234567
Gross requirements
0
0
90
130
170
Scheduled receipts
Projected on hand
Net requirements
0
0
90
130
170
Planned-order receipts
0
0
90
130
170
Planned-order releases
0
0
90
130
170
0
Wood Sections * Beg. Inv. 1234567
Gross requirements
340
Scheduled receipts
90
0
Projected on hand
0
Net requirements
340
Planned-order receipts
340
Planned-order releases
340
0
Braces * Beg. Inv. 1234567
Gross requirements
510
Scheduled receipts
Projected on hand
70
70
Net requirements
440
Planned-order receipts
440
Planned-order releases
440
0
Legs *
10% extra safety stock Beg. Inv. 1234567
Gross requirements
748
Scheduled receipts
Projected on hand
130
130
130
130
130
130
130
130
Net requirements
681
Planned-order receipts
681
Planned-order releases
681
0 wants to ship 90 units at the beginning of day 4,130 units at the beginning of day 5, and 170 units at the beginning of day 7. Receipts
of 90 wood sections are scheduled at the beginning of day 2. There are 130 legs on hand. An additional 10 percent of the order size
on legs is added for scrap allowance. There are 70 braces on hand. Lead time (in days) for all items is a function of each order quantity
and is shown below.
Prepare the material requirements plan using lot-for-lot ordering. (Do not leave any empty spaces; Input a 0 wherever it is required.)
Note that lead time is a function of lot size.
 A table is assembled using three components, as shown in the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!