Question: Please answer the following. It's one question with different parts A table is assembled using three components, as shown in the accompanying product structure tree.

Please answer the following. It's one question with different parts
Please answer the following. It's one question
Please answer the following. It's one question
Please answer the following. It's one question
Please answer the following. It's one question
A table is assembled using three components, as shown in the accompanying product structure tree. The company that makes the table wants to ship 100 units at the beginning of day 4, 150 units at the beginning of day 5, 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, and 60 braces on hand. Lead times (in days) for all items are shown in the following table. Prepare a material requirements plan using lot-for-lot ordering. (Note: Since the lead time varies based on order quantity it is possible to place two separate orders on the same day. Leave no cells blank - be certain to enter "0" wherever required.) Quantity 1 - 200 201 - 550 551 - 999 Lead Time 1 2 3 Click here for the Excel Data File Table Wood sections (2) Bracos (3) Legs (4) ancos Master Schedule Blogny Duantity Beg. In Table Lot so: Lot for Lot size: Lot-for-Lot Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Bog. In Wood Sections (2) Lot Lot for Lot Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beg. Inv. 3 5 Braces (3) Lot size: Lot-for-Lot Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beg: Inv. Legs (4) Lot size Lot-for-Lou Gross requirements Scheduled receipts Projected on hand Planned-order recept Plane-onders A B C. D 1 2 Quantity Lead Time 1-200 1 201-550 551-999 4 6 12-6 + 10 12 13 Sheet1 Sheet2 Shee

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!