Complete the ITEM B MRP table for weeks 11-18 in the Excel spreadsheet. Item B uses a fixed order quantity (FOQ = 150) lot sizing rule.

In addition to filling out the table in the Excel spreadsheet, enter the two values requested below:

Item B Projected On Hand at the end of week 11:

Item B Projected On Hand at the end of week 12:

The Scheduled Receipt of 150 units in week 12 shown in the Item B MRP table (cell O24) probably originated as a Planned Release in week:

AL PRODUCT STRUCTURE TREE B (21 C5) 013) E (2) F4 | 11 | 12 13 14 16 16 17 18 19 ITEM C SCHEDULED RECEIPTS NEXT WEEX Wiki 12 13 14 16 16 17 18 Penul Release 10 1) 12 1 14 ITEM A 15 Wick Pend 16 Release 17 19 19 ITEM C 20 Cn and 21 Elly Black 22 Wock Cross 22 10 105 ITEM B On and Slly Black Weck Gross 110 50 Lead Time: 3 Veeds Lalsize: - 2 W 12 13 120 190 11 14 15 17 18 Losd Time: 2 Vins Lulis: F00 - 150 11 12 13 45 52 15 16 17 16 135 111 120 145 125 52 275 100 165 45 190 175 180 50 50 110 135 135 24 Pocits Proiected 25 Cn and Nel 25 Planned 23 Recelet Planned 28 PM Rool Projectes Onland Net |Rai' Parned Reonist Parned Rele 20 285 250 265 12 13 14 15 18 17 18 30 ITEMD GROSS REQUIREMENTS 31 W 11 Ge 32 Regione 31 34 ITEME GROSS REQUIREMENTS 35 W 11 Gre Requirements 12 13 14 15 1817 18