Based on the information provided, what are the current Planned Releases for Product A for weeks 11-18. Enter these into cells C16-J16 on the MRP Problem tab of your workbook.

In addition to filling in the complete row in the Excel spreadsheet, enter the two values requested below:

Planned Releases for Item A in week 11:

Planned Releases for Item A in week 12:

Based on the information provided, what are the current Gross Requirements for Item D for weeks 11-18. Enter these into cells C32-J32 on the MRP Problem tab of your workbook.

In addition to filling in the complete row in the Excel spreadsheet, enter the two values requested below:

Item D Gross Requirements for Week 11

Item D Gross Requirements for Week 12

Based on the information provided, what are the current Gross Requirements for Item E for weeks 11-18. Enter these into cells C36-J36 on the MRP Problem tab of your workbook.

In addition to filling in the complete row in the Excel spreadsheet, enter the two values requested below:

Item E Gross Requirements for Week 11

Item E Gross Requirements for Week 12

Based on the information provided, what will we be seeing next week in the Scheduled Receipt row, when we come back and complete the Item C MRP table covering weeks 12-19. Enter these into the cells N16-U16 on the MRP Problem tab of your workbook.

In addition to filling in the complete row in the Excel spreadsheet, enter the two values requested below:

Item C Scheduled Receipts for week 12, in the week 12-19 MRP table:

Item C Scheduled Receipts for week 13, in the week 12-19 MRP table:

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:

PRODUCT STRUCTURE TREE B (2) C (5) D (3) E (2) F (4) 11 12 13 14 15 16 17 18 14 15 16 17 18 19 ITEM A Week: Planned Release ITEM C SCHEDULED RECEIPTS NEXT WEEK Week: 12 13 Planned Release 170 50 Lead Time: 3 Weeks Lotsize: POQ = 2 Weeks 12 13 14 112 50 Lead Time: 2 Weeks Lotsize: FOQ = 150 12 13 11 15 16 17 18 11 14 15 16 17 18 125 135 145 140 120 120 120 50 54 58 56 48 48 48 275 150 ITEM C On Hand: Safety Stock: Week: Gross Requirements Scheduled Receipts Projected On Hand Net Requirement Planned Receipt Planned Release ITEM B On Hand: Safety Stock: Week: Gross Requirements Scheduled Receipts Projected On Hand Net Requirement Planned Receipt Planned Release 170 45 185 40 170 50 170 50 50 112 5 10 150 120 270 240 270 240 12 13 14 15 16 17 18 ITEM D GROSS REQUIREMENTS Week: 11 Gross Requirements B 12 13 14 15 16 17 18 ITEM E GROSS REQUIREMENTS Week: 11 Gross Requirements