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.)

Image description: First half of the correct solution to Assignment 1.

Image description: Second half of the correct solution to Assignment 1.

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.)

Image description: "Where used" list.

You do not need to complete MRP tables for the Level 2 items.

Image description: 1/3 of workbook.

Image description: 2/3 of workbook.

Image description: 3/3 of workbook.

Jolynn Steiler JS - AutoSave on H File Home 2 Insert B Draw MRP Assignment_Edited Version Page Layout Formulas Data Review Search Help x Comments View FactSet Share A 16 A A = == 28 22 Wrap Text Merge & Center Insert 2X Delete Format Paste Ideas A . Arial BIU. B Font - X General $ -% 8-98 Numbers Conditional Format as Cell Formatting Table Styles Styles Sort & Filter Find & Select Alignment Editing Ideas Clipboard N54 fx 3 Item: 32" RH Pre-Hung Door 5 On Hand: 5 Safety Stock: 10 LT = 1 week Lotsize: POQ = 2 weeks 14 45 40 15 38 16 40 17 40 18 40 19 40 33 3 week: Gross Requirements Scheduled Reciepts Projected On Hand E Net Requirement Planned Receipt - Planned Release 10 10 10 10 1255 38 83 83 50 38 78 50 40 80 78 80 40 r Item: 32" LH Pre-Hung Door 1) On Hand: 21 Safety Stock: LT = 1 week Lotsize: POQ = 2 weeks 10 12 35 13 43 14 40 15 35 16 40 17 40 18 40 19 40 22 week: 2 Gross Requirements Scheduled Reciepts Projected On Hand * Net Requirement 27 Planned Receipt z Planned Release 1950 10 50 10 MRP Homework 1 @ - 55% E - + 4:47 PM 4/24/2020 Type here to search Et w 16 * 18 - AutoSave on H File Home 2 Insert B Draw MRP Assignment_Edited Version Page Layout Formulas Data Review Search Help x Comments View FactSet A 16 A A = == Arial BIU. B Font 22 Wrap Text Merge & Center Paste Jolynn Steiler JS Share Insert E47 2X Delete Sort & Find & Format Filter Select Editing Ideas A . General $ -% 8-98 Numbers Conditional Format as Cell Formatting Table Styles Styles Clipboard Alignment Ideas N54 Item: 36" RH Pre-Hung Door (you need to add any scheduled receipts) 3. On Hand: Safety Stock: LT= 1 week Lotsize: POQ = 2 weeks 13 77 14 82 15 73 16 70 17 70 18 70 19 70 I week: 37 Gross Requirements Scheduled Receipts 3. Projected On Hand Net Requirement 4 Planned Receipt 4 Planned Release 12 65 142 84 1 3 83 1080 1080 10 85 70 70 140 140 140 140 158 158 43 Item: 36" LH Pre-Hung Door (you need to add any scheduled receipts) 20 47 On Hand: - Safety Stock: 10 LT = 1 week Lotsize: POQ = 2 weeks 14 65 15 65 16 65 17 65 18 65 19 65 75 10 10 75 10 50 Week: 12 13 51 Gross Requirements 73 70 2 Scheduled Receipts 137 5.Projected On Hand 84 14 54Net Requirement w Planned Receipt So Planned Release 126 MRP Homework 1 75 65 130 126 130 130 + @ -- - + 55% Type here to search AutoSave On H B - MRP Inputs Search - x Comments File Home Insert Draw Page Layout Formulas Data Review View Help FactSet - == A A .A. 23 Wrap Text Merge & Center Pastele Jolynn Steilerus Share Insert E47 0 Delete Sort & Find & Format Filter Select Cells Editing Calibri 10 BIU.B Font - X fc Ideas General $ -% Number 8-98 : Conditional Format as Formatting Table Styles Cell Styles Alignment ideas Clipboard 136 D A 1 "Where Used" list: E F G H I J K L M N O 3 Item 4 32" RH Frame 5 32" LH Frame 6 36" RH Frarre 7 36" H Frame 8 37" Door # Per Parent 1 1 i 1 10 36" Door 12 Hinge 13 14 15 16 32" Top lamb 17 18 36" Top Jamb Where Used (Parent Item) 32" RH Pre-Hung. Door 32" LH Pre-Hung Door 36" RH Pre-Hung Door 36" LH Pre Hung Door 32" RH Pre-Hung Door 32" LH Pre-Hung Door 36" RH Pre-Hung Door 36" LH Pre-Hung Door 32" RH Pre-Hung Door 32" LH Pre-Hung Door 36" RI Pre-Ilung Door 36" LH Pre-Hung Door 32" RH Frame 32" LH Frame 36" RH Frame 36" LH Frame 32" RH Frame 32" LH Frame 36" RH Frame 36" H Frame 19 20 Side Jamb 21 22 24 BOMS Where Used Forecasts Data + Ready @ -- Type here to search Type her Et w + + 100% 4:50 PM 1/24/2020 18 - 4 AutoSave on H 2 = MRP Assignment 2 (2) - Excel Search Jolynn Steilerus - x Comments File Home Insert Draw Page Layout Formulas Data Review View Help FactSet Share X 16 A 49 Arial BIU A A == S 22 Wrap Text Merge & Center Insert Delete Format Paste E E General $ -% Number 8-98 Conditional Format as Cell Formatting Table Styles Styles Sort & Filter Ideas Find & Select Clipboard Font Alignment Cells Editing Ideas K38 B C D E F G H I J K L M N O P Q R S 3 Item: 32" RH Frame 1 week: 5 Gross Requirements (just compute the Gross Requirements) 12 13 14 15 16 17 18 19 1 Item: 32" LH Frame 8 Week: 9 Gross Requirements (just compute the Gross Requirements) 12 13 14 15 16 17 18 10 (compute Gross Requirements and complete table) 35 LT = 1 week 10 Lotsize: 50 12 13 14 15 16 17 18 19 11 Item: 32" Door 12 On Hand: 13 Safety Stock: 14 week: 15 Gross Requirements 16 Scheduled Receipts 17 Projected On Hand (EI) 10 Net Requirement 19 Planned Receipt 20 Planned Release 150 MRP Homework 2 @ -- 80% Type here to search o Etw - + 4:54 PM 4/24/2020 A 1 4 18 AutoSave on H 2 = MRP Assignment 2 (2) - Excel Search Jolynn Steilerus - x Comments File Home Insert Draw Page Layout Formulas Data Review View Help FactSet Share X 16 A 49 Arial BIU A A == S 22 Wrap Text Merge & Center Insert Delete Format Paste E E General $ -% Number 8-98 Conditional Format as Cell Formatting Table Styles Styles Sort & Filter Ideas Find & Select Font Alignment Cells Editing Ideas Clipboard K38 B C D E F G H I J K L M N O P Q R S 21 2 Item: 36" RH Frame 23 week: 24 Gross Requirements (just compute the Gross Requirements) 12 13 14 15 16 17 18 19 (just compute the Gross Requirements) 12 13 14 15 16 17 18 65 23 Item: 36" LH Frame 27 week: 28 Gross Requirements 29 30 Item: 36" Door 31 On Hand: 32 Safety Stock: 33 week: 34 Gross Requirements 35 Scheduled Receipts 38 Projected On Hand (EI) 37 Net Requirement 39 Planned Receipt 39 Planned Release (compute Gross Requirements and complete table) LT = 1 week 10 Lotsize: 50 12 13 14 15 16 17 18 19 MRP Homework 2 @ -- 80% Type here to search o Etw @ - + 4:54 PM 4/24/2020 18 AutoSave on H 2 = MRP Assignment 2 (2) - Excel Search Jolynn Steilerus - x Comments File Home Insert Draw Page Layout Formulas Data Review View Help FactSet A A A = == 22 Wrap Text Merge & Center Insert Delete Format Pasto LE E47 Sort & Filter Share 0 Find & Select Arial 16 BIU. B A Font - X fx . General $ -% 8-98 Numbers Ideas Conditional Format as Formatting Table Styles Cell Styles Alignment Editing Ideas Clipboard 047 C D H I J K L M N O P Q R S 10 12 E F Lotsize: 15 16 G 50 17 13 14 18 19 32 Safety Stock: 33 week: 34 Gross Requirements 35 Scheduled Receipts 38 Projected On Hand (EI) 37 Net Requirement 39 Planned Receipt 39 Planned Release 41 Item: Hinges (all doors) (compute Gross Requirements and complete table) 42 On Hand: 213 LT = 1 week 43 Safety Stock: 300 Lotsize: 300 44 week: 12 13 14 15 16 17 18 19 45 Gross Requirements 46 Scheduled Receipts 300 17 Projected On Hand (EI) 48 Net Requirement 49 Planned Receipt 50 Planned Release MRP Homework 2 -- 80% Type here to search @ - + 4:54 PM 4/24/2020 18 Jolynn Steiler JS - AutoSave on H File Home 2 Insert B Draw MRP Assignment_Edited Version Page Layout Formulas Data Review Search Help x Comments View FactSet Share A 16 A A = == 28 22 Wrap Text Merge & Center Insert 2X Delete Format Paste Ideas A . Arial BIU. B Font - X General $ -% 8-98 Numbers Conditional Format as Cell Formatting Table Styles Styles Sort & Filter Find & Select Alignment Editing Ideas Clipboard N54 fx 3 Item: 32" RH Pre-Hung Door 5 On Hand: 5 Safety Stock: 10 LT = 1 week Lotsize: POQ = 2 weeks 14 45 40 15 38 16 40 17 40 18 40 19 40 33 3 week: Gross Requirements Scheduled Reciepts Projected On Hand E Net Requirement Planned Receipt - Planned Release 10 10 10 10 1255 38 83 83 50 38 78 50 40 80 78 80 40 r Item: 32" LH Pre-Hung Door 1) On Hand: 21 Safety Stock: LT = 1 week Lotsize: POQ = 2 weeks 10 12 35 13 43 14 40 15 35 16 40 17 40 18 40 19 40 22 week: 2 Gross Requirements Scheduled Reciepts Projected On Hand * Net Requirement 27 Planned Receipt z Planned Release 1950 10 50 10 MRP Homework 1 @ - 55% E - + 4:47 PM 4/24/2020 Type here to search Et w 16 * 18 - AutoSave on H File Home 2 Insert B Draw MRP Assignment_Edited Version Page Layout Formulas Data Review Search Help x Comments View FactSet A 16 A A = == Arial BIU. B Font 22 Wrap Text Merge & Center Paste Jolynn Steiler JS Share Insert E47 2X Delete Sort & Find & Format Filter Select Editing Ideas A . General $ -% 8-98 Numbers Conditional Format as Cell Formatting Table Styles Styles Clipboard Alignment Ideas N54 Item: 36" RH Pre-Hung Door (you need to add any scheduled receipts) 3. On Hand: Safety Stock: LT= 1 week Lotsize: POQ = 2 weeks 13 77 14 82 15 73 16 70 17 70 18 70 19 70 I week: 37 Gross Requirements Scheduled Receipts 3. Projected On Hand Net Requirement 4 Planned Receipt 4 Planned Release 12 65 142 84 1 3 83 1080 1080 10 85 70 70 140 140 140 140 158 158 43 Item: 36" LH Pre-Hung Door (you need to add any scheduled receipts) 20 47 On Hand: - Safety Stock: 10 LT = 1 week Lotsize: POQ = 2 weeks 14 65 15 65 16 65 17 65 18 65 19 65 75 10 10 75 10 50 Week: 12 13 51 Gross Requirements 73 70 2 Scheduled Receipts 137 5.Projected On Hand 84 14 54Net Requirement w Planned Receipt So Planned Release 126 MRP Homework 1 75 65 130 126 130 130 + @ -- - + 55% Type here to search AutoSave On H B - MRP Inputs Search - x Comments File Home Insert Draw Page Layout Formulas Data Review View Help FactSet - == A A .A. 23 Wrap Text Merge & Center Pastele Jolynn Steilerus Share Insert E47 0 Delete Sort & Find & Format Filter Select Cells Editing Calibri 10 BIU.B Font - X fc Ideas General $ -% Number 8-98 : Conditional Format as Formatting Table Styles Cell Styles Alignment ideas Clipboard 136 D A 1 "Where Used" list: E F G H I J K L M N O 3 Item 4 32" RH Frame 5 32" LH Frame 6 36" RH Frarre 7 36" H Frame 8 37" Door # Per Parent 1 1 i 1 10 36" Door 12 Hinge 13 14 15 16 32" Top lamb 17 18 36" Top Jamb Where Used (Parent Item) 32" RH Pre-Hung. Door 32" LH Pre-Hung Door 36" RH Pre-Hung Door 36" LH Pre Hung Door 32" RH Pre-Hung Door 32" LH Pre-Hung Door 36" RH Pre-Hung Door 36" LH Pre-Hung Door 32" RH Pre-Hung Door 32" LH Pre-Hung Door 36" RI Pre-Ilung Door 36" LH Pre-Hung Door 32" RH Frame 32" LH Frame 36" RH Frame 36" LH Frame 32" RH Frame 32" LH Frame 36" RH Frame 36" H Frame 19 20 Side Jamb 21 22 24 BOMS Where Used Forecasts Data + Ready @ -- Type here to search Type her Et w + + 100% 4:50 PM 1/24/2020 18 - 4 AutoSave on H 2 = MRP Assignment 2 (2) - Excel Search Jolynn Steilerus - x Comments File Home Insert Draw Page Layout Formulas Data Review View Help FactSet Share X 16 A 49 Arial BIU A A == S 22 Wrap Text Merge & Center Insert Delete Format Paste E E General $ -% Number 8-98 Conditional Format as Cell Formatting Table Styles Styles Sort & Filter Ideas Find & Select Clipboard Font Alignment Cells Editing Ideas K38 B C D E F G H I J K L M N O P Q R S 3 Item: 32" RH Frame 1 week: 5 Gross Requirements (just compute the Gross Requirements) 12 13 14 15 16 17 18 19 1 Item: 32" LH Frame 8 Week: 9 Gross Requirements (just compute the Gross Requirements) 12 13 14 15 16 17 18 10 (compute Gross Requirements and complete table) 35 LT = 1 week 10 Lotsize: 50 12 13 14 15 16 17 18 19 11 Item: 32" Door 12 On Hand: 13 Safety Stock: 14 week: 15 Gross Requirements 16 Scheduled Receipts 17 Projected On Hand (EI) 10 Net Requirement 19 Planned Receipt 20 Planned Release 150 MRP Homework 2 @ -- 80% Type here to search o Etw - + 4:54 PM 4/24/2020 A 1 4 18 AutoSave on H 2 = MRP Assignment 2 (2) - Excel Search Jolynn Steilerus - x Comments File Home Insert Draw Page Layout Formulas Data Review View Help FactSet Share X 16 A 49 Arial BIU A A == S 22 Wrap Text Merge & Center Insert Delete Format Paste E E General $ -% Number 8-98 Conditional Format as Cell Formatting Table Styles Styles Sort & Filter Ideas Find & Select Font Alignment Cells Editing Ideas Clipboard K38 B C D E F G H I J K L M N O P Q R S 21 2 Item: 36" RH Frame 23 week: 24 Gross Requirements (just compute the Gross Requirements) 12 13 14 15 16 17 18 19 (just compute the Gross Requirements) 12 13 14 15 16 17 18 65 23 Item: 36" LH Frame 27 week: 28 Gross Requirements 29 30 Item: 36" Door 31 On Hand: 32 Safety Stock: 33 week: 34 Gross Requirements 35 Scheduled Receipts 38 Projected On Hand (EI) 37 Net Requirement 39 Planned Receipt 39 Planned Release (compute Gross Requirements and complete table) LT = 1 week 10 Lotsize: 50 12 13 14 15 16 17 18 19 MRP Homework 2 @ -- 80% Type here to search o Etw @ - + 4:54 PM 4/24/2020 18 AutoSave on H 2 = MRP Assignment 2 (2) - Excel Search Jolynn Steilerus - x Comments File Home Insert Draw Page Layout Formulas Data Review View Help FactSet A A A = == 22 Wrap Text Merge & Center Insert Delete Format Pasto LE E47 Sort & Filter Share 0 Find & Select Arial 16 BIU. B A Font - X fx . General $ -% 8-98 Numbers Ideas Conditional Format as Formatting Table Styles Cell Styles Alignment Editing Ideas Clipboard 047 C D H I J K L M N O P Q R S 10 12 E F Lotsize: 15 16 G 50 17 13 14 18 19 32 Safety Stock: 33 week: 34 Gross Requirements 35 Scheduled Receipts 38 Projected On Hand (EI) 37 Net Requirement 39 Planned Receipt 39 Planned Release 41 Item: Hinges (all doors) (compute Gross Requirements and complete table) 42 On Hand: 213 LT = 1 week 43 Safety Stock: 300 Lotsize: 300 44 week: 12 13 14 15 16 17 18 19 45 Gross Requirements 46 Scheduled Receipts 300 17 Projected On Hand (EI) 48 Net Requirement 49 Planned Receipt 50 Planned Release MRP Homework 2 -- 80% Type here to search @ - + 4:54 PM 4/24/2020 18