Please provde correct answers and formulas

MRP Explosion - Level 1 of BOM on Visual 5-6, page 5 - 13 1. Review the explosion and planning for subassembly B. Pay special attention to the PAB formulas. 2. Refer back to the BOM example provided on the worksheet tab, or on Visual 5-6 to review the planning data (Qty Per and LT) for Subassembly D. 3. Complete the gross requirements explosion for Subassembly D. Complete the row in the grid for Subassembly D below. 4. Complete the grid for each week by calculating the projected available balance, net requirements, planned order receipts for each we words Lot for Lot Order only what is needed to Note: Order Quantity Amount is 1. or in other 5. Offset by lead time to complete the planned order release row. cover net requirements. Don't confuse this with 6. Please phone me or email me if you have any questions. Qty Per in the BOM, 3 ***** Take your time and walk through this step by step ******* Note the formula: On hand ending inventory or projected available balance (prior period) + scheduled receipts + MRP planned receipts - gross requirements (all within the period) 50+o+0-35 + 15 PAB 1 4 Weekly Periods 5 6 110 120 9 2 901 10 7 135 35 95 90 140 145 0 Note: A scheduled receipt exists for Period 2. This is also considered an open order in MRP. MRP didn't plan this one, a planner placed an order in the system for this quantity. MRP still needs to account for it as it impacts the PAB. Weekly Periods 0 A & B have been completed already 1 Product A 2 MRP Planned Order Release 3 4 Lead Time Weeks = 1 5 Order Quantity = 1 6 On Hand Inventory = 50 7 Subassembly B 3 Gross Requirements 9 MRP Scheduled Receipts O Projected Available Balance 1 Net Requirements 2 MRP Planned Order Receipt 3 MRP Planned Order Release 4 1 2 4 9 10 5 110 6 1201 7 135 8 140 35 95 901 145 0 901 501 0 0 25 15 PAB + 50 schedule reciept - 90 gross requirement = 25 net requirement 15 0 U 0 0 0 0 95 95 901 90 90 110 110 110 120 25 951 0 0 135 135 140 120 120 135 0 0 140 140 1451 145 145 25 MRP plans an order for 25 since the PAB would be negative by that amount without it. Go ahead and remove the planned order of 25 in Week 2 to see what happens. Then, add it back. If you want to play with this, go ahead and copy this entire worksheet to another worksheet tab and remove all of the plannned orders. If you remove the planned orders, PAB will go negative. These are MRP's net requirements. 5 Homework Problem - Item D, Level 1 BOM 6 7 The yellow "cells" are to guide students on where actual numbers need to be placed. I have provide a few numbers in green. placed. I have pro requirements. The yellow "cells" are to guide students on where actual numbers need to be placed. I have provide a few numbers in green. Period 2 MRP Planned Order Release for A 90 X 2 = 180 Hint: Remember that 2 D's make 1 A from the BOM on the second tab, so you need to look back at A's MRP Pinned Order Release for Lead Time Weeks = 1 period 1 to figure out D's new gross Order Quantity = 1 requirement. On Hand Inventory = 75 35 x 2 = 70 gross requirement for period 1 Subassembly D 1 3 Gross Requirements 70 180 MRP Scheduled Receipts 100 Projected Available Balance Weekly Periods 4 5 6 7 8 9 10 270 0 0 0 0 0 0 0 0 0 Net Requirements 75 180 0 Hint: These two rows, each period will be the same. So, for period 4 the net requirement will be 180 and the MRP Planned Orde Reciept will be 180 180 270 280 0 MRP Planned Order Receipt MRP Planned Order Release 75 190 75 270 280 0 0 0 on hand inventory + (0 scheduled receipt + 0 planned reciept) gross requirment from period 1 = PAB for period 1 See the pattern here. If there is a MRP Planned Order Release aty then it needs to become a MRP Planned order reciept during the next period. MRP Explosion - Level 1 of BOM on Visual 5-6, page 5 - 13 1. Review the explosion and planning for subassembly B. Pay special attention to the PAB formulas. 2. Refer back to the BOM example provided on the worksheet tab, or on Visual 5-6 to review the planning data (Qty Per and LT) for Subassembly D. 3. Complete the gross requirements explosion for Subassembly D. Complete the row in the grid for Subassembly D below. 4. Complete the grid for each week by calculating the projected available balance, net requirements, planned order receipts for each we words Lot for Lot Order only what is needed to Note: Order Quantity Amount is 1. or in other 5. Offset by lead time to complete the planned order release row. cover net requirements. Don't confuse this with 6. Please phone me or email me if you have any questions. Qty Per in the BOM, 3 ***** Take your time and walk through this step by step ******* Note the formula: On hand ending inventory or projected available balance (prior period) + scheduled receipts + MRP planned receipts - gross requirements (all within the period) 50+o+0-35 + 15 PAB 1 4 Weekly Periods 5 6 110 120 9 2 901 10 7 135 35 95 90 140 145 0 Note: A scheduled receipt exists for Period 2. This is also considered an open order in MRP. MRP didn't plan this one, a planner placed an order in the system for this quantity. MRP still needs to account for it as it impacts the PAB. Weekly Periods 0 A & B have been completed already 1 Product A 2 MRP Planned Order Release 3 4 Lead Time Weeks = 1 5 Order Quantity = 1 6 On Hand Inventory = 50 7 Subassembly B 3 Gross Requirements 9 MRP Scheduled Receipts O Projected Available Balance 1 Net Requirements 2 MRP Planned Order Receipt 3 MRP Planned Order Release 4 1 2 4 9 10 5 110 6 1201 7 135 8 140 35 95 901 145 0 901 501 0 0 25 15 PAB + 50 schedule reciept - 90 gross requirement = 25 net requirement 15 0 U 0 0 0 0 95 95 901 90 90 110 110 110 120 25 951 0 0 135 135 140 120 120 135 0 0 140 140 1451 145 145 25 MRP plans an order for 25 since the PAB would be negative by that amount without it. Go ahead and remove the planned order of 25 in Week 2 to see what happens. Then, add it back. If you want to play with this, go ahead and copy this entire worksheet to another worksheet tab and remove all of the plannned orders. If you remove the planned orders, PAB will go negative. These are MRP's net requirements. 5 Homework Problem - Item D, Level 1 BOM 6 7 The yellow "cells" are to guide students on where actual numbers need to be placed. I have provide a few numbers in green. placed. I have pro requirements. The yellow "cells" are to guide students on where actual numbers need to be placed. I have provide a few numbers in green. Period 2 MRP Planned Order Release for A 90 X 2 = 180 Hint: Remember that 2 D's make 1 A from the BOM on the second tab, so you need to look back at A's MRP Pinned Order Release for Lead Time Weeks = 1 period 1 to figure out D's new gross Order Quantity = 1 requirement. On Hand Inventory = 75 35 x 2 = 70 gross requirement for period 1 Subassembly D 1 3 Gross Requirements 70 180 MRP Scheduled Receipts 100 Projected Available Balance Weekly Periods 4 5 6 7 8 9 10 270 0 0 0 0 0 0 0 0 0 Net Requirements 75 180 0 Hint: These two rows, each period will be the same. So, for period 4 the net requirement will be 180 and the MRP Planned Orde Reciept will be 180 180 270 280 0 MRP Planned Order Receipt MRP Planned Order Release 75 190 75 270 280 0 0 0 on hand inventory + (0 scheduled receipt + 0 planned reciept) gross requirment from period 1 = PAB for period 1 See the pattern here. If there is a MRP Planned Order Release aty then it needs to become a MRP Planned order reciept during the next period