AA13 8 (2) 910 125 1 12 14 ITEM A 15 Week Planned 4) G " 0 a S T ITEM C SCHEDULED RECEIPTS NEXT WEEK 12 34 15 10 " 10 Week 12 13 14 15 14. 17 19 Planned 17 18 19 ITEM C ITEMB 20 On Hand 155 Lead Time 3 Weeks On Hand 100 21 Safety k 10 50 88 Lead Time 2 Weeks Lotsize FOO 150 11 12 13 14 14 17 18 Wook 11 12 13 14 Gres 23 met Shedd Gross 110 120 140 110 115 105 545 44 48 30 44 == 15 14 17 th 40 42 58 Paquirements Scheduled 275 150 24 Receuts Pacepla Projected Projected 45 200 165 50. 195 50 50 106 25 On Hend On and 5 300 105 26 Requ Requirement Planned Planned 215 250 Racet Planned 25 Release 30 Planned 215 250 Please ITEM D GROSS REQUIREMENTS 31 Wok 11 12 13 14 15 10 17 18 Gross ITEM E GROSS REQUIREMENTS 34 35 W Gro Regurements 11 12 19 14 15 14 17 18 Question 11 2 pts 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: Question 12 2 pts 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 D Question 13 2 pts 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 Question 14 2 pts 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: n Question 15 6 pts 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: 4 ITEM A Week Planned 15 Release 171 18 19 ITEM C BO DO C EG F 141 12 15 14 15 17 13 34 15 12 18 19 ITEM C SCHEDULED RECEIPTS NEXT WEEK 12 ITEM B 20 On Hand Ti3 W On Hent 108 21 Safety Stock 60 POQ-2 Safety Stack 50 Lead Time: 2 s Lotaire FOO 150 22 Wak Gross 23 Reques Schedules 11 12 13 14 15 16 17 18 11 12 13 14 75 15 17 18 710 540 110 2 115 105 145 44 54 44 4 42 275 24 Recent Projected 25 On Hand 155 45 200 40 185 . 50 105 2 Scheduled 108 150 $ 100 Marned 215 200 27 Rece Panned 216 250 28 P ITEM D GROSS REQUIREMENTS Wwk Gross 32 Requireme 12 14 16 10 14 " 12 12 14 1E 18 17 18 34 ITEM E GROSS REQUIREMENTS 35 w Cross * 38 39