For this assignment you will use the correct solution to Assignment 1 as a starting point. There you should have completed MRP tables for weeks 12-19 for the 32" RH, 32"LH, 36" RH, and 36" LH pre-hung door assemblies (all of the Level 0 items in our example.)
Based on the information, compute the Gross Requirements for all the BOM Level 1 items. It will be useful to refer back to the BOM information and "where used" list provided in MRP Inputs.xlsx. Enter your answers into the Excel worksheet linked below. Also, complete the entire MRP table for the 32" Doors, 36" Doors, and Hinges. Any open orders for these items are already reflected in the Scheduled Receipts row of the table linked below. (You do not need to enter any Scheduled Receipts information.)
MRP Assignment 2 (linked Excel workbook)
You do not need to complete MRP tables for the Level 2 items.
BIU D E F Safety Stock Sched. Recpt. Week of Sch. Rec. 11 11 10 75 10 1 Current system information (Week 11) On 3 Item Hand 4 32" RH Pre-Hung Door 5 32" LH Pre-Hung Door 6 36" RH Pre-Hung Door 7 36" LH Pre-Hung Door 8 32" RH Frame 9 32" LH Frame 10 36" RH Frame 11 36" LH Frame 12 32" Door 13 36" Door 14 Hinge 15 32" Top Jamb 16 36" Top Jamb 17 Side Jamb Lot Size POQ = 2 weeks POQ = 2 weeks POQ = 2 weeks POQ = 2 weeks LFL LFL LFL 12 10 LFL 131 11 50 11 300 600 11 300 LFL LFL LFL 11 280 600 BOMS Where Used Forecasts Data + K43 ( H 3 Item: 32" RH Frame 4 week: s Gross Requirements (just compute the Gross Requirements) 12 13 14 15 16 17 18 19 7 Item: 32" LH Frame * Week: 9 Gross Requirements just compute the Gross Requirements) 12 13 14 15 16 17 18 19 (compute Gross Requirements and complete table) 35 LT= 1 week Lotsize: 50 12 13 14 15 16 17 18 19 10 11 Item: 32" Door 12 On Hand: 13 Safety Stock: 14 week: 15 Gross Requirements 16 Scheduled Receipts 17 Projected On Hand (EI) 18 Net Requirement 9 Planned Receipt 20 Planned Release 150 22 Item: 36" RH Frame week: 4 Gross Requirements (just compute the Gross Requirements) 12 13 14 15 16 17 18 19 Item: 36" LH Frame week: Gross Requirements just compute the Gross Requirements) 12 13 14 15 16 17 18 19 (compute Gross Requirements and complete table) 65 LT = 1 week 10 Lotsize: 50 12 13 14 15 16 17 18 19 Item: 36" Door On Hand: Safety Stock: week: Gross Requirements Scheduled Receipts Projected On Hand (EI) Net Requirement Planned Receipt Planned Release Item: Hinges (all doors) On Hand: Safety Stork (compute Gross Requirements and complete table) LT= 1 week 300 Lotsize: 300 213 * Office Update To keep up-to-date with security updates, fixes, and improvements, choo K43 Ax & fox B C D E (compute Gross Requirements and complete table) 213 LT = 1 week 300 Lotsize: 300 12 13 14 15 16 17 18 19 -1 Item: Hinges (all doors) 2 On Hand: 3 Safety Stock: - week: 5 Gross Requirements 6 Scheduled Receipts 7 Projected On Hand (EI) s Net Requirement 9 Planned Receipt o Planned Release 300 R2325$ FERRER BIU D E F Safety Stock Sched. Recpt. Week of Sch. Rec. 11 11 10 75 10 1 Current system information (Week 11) On 3 Item Hand 4 32" RH Pre-Hung Door 5 32" LH Pre-Hung Door 6 36" RH Pre-Hung Door 7 36" LH Pre-Hung Door 8 32" RH Frame 9 32" LH Frame 10 36" RH Frame 11 36" LH Frame 12 32" Door 13 36" Door 14 Hinge 15 32" Top Jamb 16 36" Top Jamb 17 Side Jamb Lot Size POQ = 2 weeks POQ = 2 weeks POQ = 2 weeks POQ = 2 weeks LFL LFL LFL 12 10 LFL 131 11 50 11 300 600 11 300 LFL LFL LFL 11 280 600 BOMS Where Used Forecasts Data + K43 ( H 3 Item: 32" RH Frame 4 week: s Gross Requirements (just compute the Gross Requirements) 12 13 14 15 16 17 18 19 7 Item: 32" LH Frame * Week: 9 Gross Requirements just compute the Gross Requirements) 12 13 14 15 16 17 18 19 (compute Gross Requirements and complete table) 35 LT= 1 week Lotsize: 50 12 13 14 15 16 17 18 19 10 11 Item: 32" Door 12 On Hand: 13 Safety Stock: 14 week: 15 Gross Requirements 16 Scheduled Receipts 17 Projected On Hand (EI) 18 Net Requirement 9 Planned Receipt 20 Planned Release 150 22 Item: 36" RH Frame week: 4 Gross Requirements (just compute the Gross Requirements) 12 13 14 15 16 17 18 19 Item: 36" LH Frame week: Gross Requirements just compute the Gross Requirements) 12 13 14 15 16 17 18 19 (compute Gross Requirements and complete table) 65 LT = 1 week 10 Lotsize: 50 12 13 14 15 16 17 18 19 Item: 36" Door On Hand: Safety Stock: week: Gross Requirements Scheduled Receipts Projected On Hand (EI) Net Requirement Planned Receipt Planned Release Item: Hinges (all doors) On Hand: Safety Stork (compute Gross Requirements and complete table) LT= 1 week 300 Lotsize: 300 213 * Office Update To keep up-to-date with security updates, fixes, and improvements, choo K43 Ax & fox B C D E (compute Gross Requirements and complete table) 213 LT = 1 week 300 Lotsize: 300 12 13 14 15 16 17 18 19 -1 Item: Hinges (all doors) 2 On Hand: 3 Safety Stock: - week: 5 Gross Requirements 6 Scheduled Receipts 7 Projected On Hand (EI) s Net Requirement 9 Planned Receipt o Planned Release 300 R2325$ FERRER
