Problem 1
Consider the completed MRP tables for the 32" Right Hand Pre-Hung Door and 32" Left Hand Pre-Hung Door from our earlier examples. The completed tables, (computed right at the start of week 11,covering weeks 11 through 18), are shown below:
Assignment 1 Figure 1. This figure shows completed MRP tables for items 32" RH Pre-Hung Door and 32" LH Pre-Hung door, using a planning horizon of weeks 11 to 18. The assignment, in contrast, asks you to fill out the table that would be used after week 11 is past, and we are planning weeks 12 to 19.
MRP applies a "rolling" planning horizon. In this example, we would develop a new 8-week plan every week. As we move through the rolling horizon, the MRP plans are continually being updated in response to the latest information.
Suppose it is now one week later, (so now we are just starting week 12) and we are currently planning weeks 12 through 19. In this case, we have new demand information (customer orders) for week 15, while the forecast (average weekly demand of 40 for each item) has been applied to week 19. Moreover, while we were "planning" to have 50 32" RH Pre-Hung doors in inventory at the beginning of week 12, we currently actually only have 45. (One of our customers called at the last minute and increased their order by 5.) Similarly, we actually have 54 32" left-hand doors in stock, vs. the 52 that was projected in last week's plan. Notice also, according to the tables developed last week, neither item has any scheduled receipts right now. The units that were previously showing up (in the tables above) as scheduled receipts in week 11 have been received, and some of them used, by the start of week 12.
Perform the calculations to fill out the week 12-19 MRP tables for both items. Use the blank tables with initial information provided in the spreadsheet linked below. Verify that the tables provided reflect the updated information described above. You do not need to enter Excel formulas into the tables, but you may do so if you wish. The alternative is to simply do the calculations with a calculator, and enter the resulting numbers into the table.
Problem 2
Last week's (week 11) completed MRP table for the 36" RH doors is shown below. Assuming we are now at the start of week 12, you are to develop the updated MRP plan for weeks 12-19. We actually have 7 of these doors in stock (vs. the value 10 that was projected in the tables computed back in week 11), with updated demand information as provided in the spreadsheet linked below. YOU need to enter any Scheduled Receipt information that belongs in the week 12-19 MRP table for 36" RH doors, based on what you see below in the week 11-18 MRP table. Notice the table below shows 142 of the 36" RH Pre-Hung Doors that should be ordered in week 11 (because the planned release is in week 11), to be received in week 12 (because the planned receipt is in week 12). Assuming we actually ordered those 142 doors in week 11 like we were supposed to, in week 12 they would be showing up as a scheduled receipt in week 12, rather than as a planned receipt in week 12.
As explained in the commentary, scheduled receipts are telling us when we will receive units that have already been ordered. The planned release row tells us when we should be ordering units that have not been ordered yet. (The planned receipt row shows us when we plan to be receiving orders that have not been ordered yet.) These "planned" quantities could still change when the MRP tables are recomputed using new information. Once an order is actually placed, (released for production or released to the supplier), the order quantity (now a scheduled receipt) typically does not change.
Assignment 1 Figure 2. This figure shows the completed MRP table for items 36" RH Pre-Hung Door, using a planning horizon of weeks 11 to 18.
Similarly, the weeks 11-18 MRP table for the 36"LH pre-hung door is shown below. Given this information, fill out the week 12-19 MRP table for this item, using the updated demand and inventory information provided in the spreadsheet linked below. You will need to update the Scheduled Receipt row for the 36"LH Pre-Hung door, based on what you see in the planned release and planned receipt for the week 11-18 MRP table shown below. (In the next lesson you will work with a real-life MRP system and see how this is implemented in practice.)
Assignment 1 Figure 3. This figure shows the completed MRP table for items 36" LH Pre-Hung Door, using a planning horizon of weeks 11 to 18.
Notice we are also producing the 32" and 36" versions in alternate weeks, and plan to stick to that schedule. (Notice all the scheduled and/or planned receipts for 32" doors are in odd-numbered weeks, while all the 36" versions have scheduled and/or planned receipts in even numbered weeks.) If a small net requirement to replenish safety stock appears to be prompting a planned receipt in an "off" week for the item in question, the net requirement will simply accumulate until the next "normal cycle" planned receipt period for that item. Your scheduled and planned receipts should stick to the "every other week" pattern established for each item, using the POQ = 2 weeks lot sizing rule. We will not expedite an order for the purpose of maintaining safety stock. To the contrary, we will remember that the purpose of safety stock is to help "stabilize" the production schedules and reduce the need for expediting.
Use the blank tables provided in the Excel workbook below for both problems. Be sure to enter your name in the indicated cell before you submit your solution.
Consider the completed MRP tables for the 32" Right Hand Pre-Ho earlier examples. The completed tables, (computed right at the sta shown below: Item: 32" RH Pre Hung Door On Hand: Safety Stock: = 1 week Lotsize: POQ 2 weeks 12 33 13 40 14 45 15 40 16 40 17 40 18 40 week: (11 Gross Requirements 42 Scheduled Reciepts 75 Projected On Hand (EH50 Net Requirement Planned Receipt Planned Release 17 55 101 10 80 Item: 32" LH Pre-Hung Door On Hand: Safety Stock: LT = 1 week Lotsize: POQ = 2 weeks 12 35 13 43 14 40 15 40 16 40 17 40 18 40 week: (11 Gross Requirements 42 Scheduled Reciepts 82 Projected On Hand (El) 52 Net Requirement Planned Receipt Planned Release 17 50 10 50 10 50 80 Assignment 1 Figure 1. This figure shows completed MRP tables for items 32" RH Pre-Hu horizon of weeks 11 to 18. The assignment, in contrast, asks you t past, and we are nlanning weeks 1 to 10 receipt row shows us when we plan to be receiving orders that have not been ordered could still change when the MRP tables are recomputed using new information. Once (released for production or released to the supplier), the order quantity (now a schedu change. Item: 36" RH Pre-Hung Door 80 On Hand: Safety Stock: LT = 1 week Lotsize: POQ = 2 weeks 10 11 70 12 65 13 77 14 82 15 70 16 70 17 70 18 70 week Gross Requirements Scheduled Receipts Projected On Hand (EN) Net Requirement Planned Receipt Planned Release 70 10 87 10 8010 80 10 0 65 0 820 70 0 1420 1520 1400 1420 1520 1400 70 Assignment 1 Figure 2. This figure shows the completed MRP table for items 36" RH Pre-Hung Door, using a pl Similarly, the weeks 11-18 MRP table for the 36"LH pre-hung door is shown below. Giv week 12-19 MRP table for this item, using the updated demand and inventory informal linked below. You will need to update the Scheduled Receipt row for the 36"LH Pre-Hu the planned release and planned receipt for the week 11-18 MRP table shown below. (l with a real-life MRP system and see how this is implemented in practice.) Item: 36" LH Pre-Hung Door LT= 1 week Lotsize: POQ = 2 weeks 14 15 16 17 18 65 65 65 65 65 11 67 12 73 13 70 On Hand: Safety Stock: week: Gross Requirements Scheduled Receipts Projected On Hand Net Requirement Planned Receipt Planned Release 16 80 10 75 1075 10 0 670 650 650 65 1370 1300 130 0 65 1370 1300 130 0 65 Assignment 1 Figure 3. This figure shows the completed MRP table for items 36" LH Pre-Hung Door, using a pla Format Office Update x To keep up-to-date with security updates, fixes, and improvements, choose Check for Up V fx U18 3 Item: 32" RH Pre-Hung Door 45 On Hand: 6 Safety Stock: 10 LT Lotsize: 1 week POQ = 2 weeks 12 33 13 40 14 15 4538 16 40 17 40 18 40 19 40 3 week: 9 Gross Requirements 10 Scheduled Reciepts 11 Projected On Hand 12 Net Requirement 13 Planned Receipt * Planned Release Item: 32" LH Pre-Hung Door 54 LT = Lotsize: 1 week POQ-2 weeks 12 35 13 43 14 40 15 35 16 40 17 40 18 40 19 40 19 On Hand: 20 Safety Stock: 21 22 week: 23 Gross Requirements 24 Scheduled Reciepts Projected On Hand 26 Net Requirement 21 Planned Receipt - Planned Release Item: 36" RH Pre-Hung Door (you need to add any scheduled receipts) On Hand: Safety Stock: LT = Lotsize: 1 week POQ = 2 weeks 12 65 13 77 14 82 15 73 16 70 17 70 18 70 19 70 week: 7 Gross Requirements Scheduled Receipts Projected On Hand EN Net Requirement Planned Receipt Planned Release MRP Homework 1 + Ready U18 45 Item: 36" LH Pre-Hung Door (you need to add any scheduled receipts) 47 On Hand: 4 Safety Stock: LT = Lotsize: 1 week POQ = 2 weeks 10 50 week: 31 Gross Requirements 12 73 13 70 14 65 15 65 16 65 17 65 18 65 19 65 33 Projected On Hand (EN 54 Net Requirement 55 Planned Receipt 56 Planned Release Consider the completed MRP tables for the 32" Right Hand Pre-Ho earlier examples. The completed tables, (computed right at the sta shown below: Item: 32" RH Pre Hung Door On Hand: Safety Stock: = 1 week Lotsize: POQ 2 weeks 12 33 13 40 14 45 15 40 16 40 17 40 18 40 week: (11 Gross Requirements 42 Scheduled Reciepts 75 Projected On Hand (EH50 Net Requirement Planned Receipt Planned Release 17 55 101 10 80 Item: 32" LH Pre-Hung Door On Hand: Safety Stock: LT = 1 week Lotsize: POQ = 2 weeks 12 35 13 43 14 40 15 40 16 40 17 40 18 40 week: (11 Gross Requirements 42 Scheduled Reciepts 82 Projected On Hand (El) 52 Net Requirement Planned Receipt Planned Release 17 50 10 50 10 50 80 Assignment 1 Figure 1. This figure shows completed MRP tables for items 32" RH Pre-Hu horizon of weeks 11 to 18. The assignment, in contrast, asks you t past, and we are nlanning weeks 1 to 10 receipt row shows us when we plan to be receiving orders that have not been ordered could still change when the MRP tables are recomputed using new information. Once (released for production or released to the supplier), the order quantity (now a schedu change. Item: 36" RH Pre-Hung Door 80 On Hand: Safety Stock: LT = 1 week Lotsize: POQ = 2 weeks 10 11 70 12 65 13 77 14 82 15 70 16 70 17 70 18 70 week Gross Requirements Scheduled Receipts Projected On Hand (EN) Net Requirement Planned Receipt Planned Release 70 10 87 10 8010 80 10 0 65 0 820 70 0 1420 1520 1400 1420 1520 1400 70 Assignment 1 Figure 2. This figure shows the completed MRP table for items 36" RH Pre-Hung Door, using a pl Similarly, the weeks 11-18 MRP table for the 36"LH pre-hung door is shown below. Giv week 12-19 MRP table for this item, using the updated demand and inventory informal linked below. You will need to update the Scheduled Receipt row for the 36"LH Pre-Hu the planned release and planned receipt for the week 11-18 MRP table shown below. (l with a real-life MRP system and see how this is implemented in practice.) Item: 36" LH Pre-Hung Door LT= 1 week Lotsize: POQ = 2 weeks 14 15 16 17 18 65 65 65 65 65 11 67 12 73 13 70 On Hand: Safety Stock: week: Gross Requirements Scheduled Receipts Projected On Hand Net Requirement Planned Receipt Planned Release 16 80 10 75 1075 10 0 670 650 650 65 1370 1300 130 0 65 1370 1300 130 0 65 Assignment 1 Figure 3. This figure shows the completed MRP table for items 36" LH Pre-Hung Door, using a pla Format Office Update x To keep up-to-date with security updates, fixes, and improvements, choose Check for Up V fx U18 3 Item: 32" RH Pre-Hung Door 45 On Hand: 6 Safety Stock: 10 LT Lotsize: 1 week POQ = 2 weeks 12 33 13 40 14 15 4538 16 40 17 40 18 40 19 40 3 week: 9 Gross Requirements 10 Scheduled Reciepts 11 Projected On Hand 12 Net Requirement 13 Planned Receipt * Planned Release Item: 32" LH Pre-Hung Door 54 LT = Lotsize: 1 week POQ-2 weeks 12 35 13 43 14 40 15 35 16 40 17 40 18 40 19 40 19 On Hand: 20 Safety Stock: 21 22 week: 23 Gross Requirements 24 Scheduled Reciepts Projected On Hand 26 Net Requirement 21 Planned Receipt - Planned Release Item: 36" RH Pre-Hung Door (you need to add any scheduled receipts) On Hand: Safety Stock: LT = Lotsize: 1 week POQ = 2 weeks 12 65 13 77 14 82 15 73 16 70 17 70 18 70 19 70 week: 7 Gross Requirements Scheduled Receipts Projected On Hand EN Net Requirement Planned Receipt Planned Release MRP Homework 1 + Ready U18 45 Item: 36" LH Pre-Hung Door (you need to add any scheduled receipts) 47 On Hand: 4 Safety Stock: LT = Lotsize: 1 week POQ = 2 weeks 10 50 week: 31 Gross Requirements 12 73 13 70 14 65 15 65 16 65 17 65 18 65 19 65 33 Projected On Hand (EN 54 Net Requirement 55 Planned Receipt 56 Planned Release
