Product structure: Data: M (5) Item On Hand Scheduled Receipts 150, week 3 Lot Size TEMPS Order Policy FOO 800 7 40, week 5; FOQ = Fixed order quantity. "O" signifies usage. Using the data given, answer parts A and B. START by COPYING the rest of the QUESTION (from 'A." to "ZZZZ") into the answer space. A. For Item L. fill out gross requirements, schedule receipts, projected on hand, net requirements and planned orders. Items left blank are assumed to have a value of zero. (6 pts). L LLC. Period Item: Lot FOQ 800 LT: size: 1 2 3 4 5 6 3 Gross Requirements: Scheduled Receipts: Projected on Hand: 90 Net Requirements: Planned Order (Receipt): Planned Order (Releases): B. For Item M, compute the gross requirements: period(s) of 1-6 they belong in (2 pts) and specify which ZZZZ (note: ignore formatting issues in answering questions. order releases of the parent item to determine the gross requirements of the components For example, look at Table 14.9c (the inventory record for the handle); its parent (cabinet door) has planned orders in periods 3 and 6. Therefore, the handle must have gross requirements in periods 3 and 6. Next, let's look at how MRP provides information to the production and inventory control planners. TABLE 14.9 Inventory Records for Remaining Components TABLE 14.9a Inventory Record for Door Magnet Item: Door Magnet Lot size rule: FOQ - 250 Lead time: 2 weeks Parent: Cabinet Door Children: none Beginning inventory: 12 2 3 4 5 6 0 216 0 0 216 10 11 12 1 0 7 0 8 0 9 0 Gross Requirements: Scheduled Receipts: Projected Available: Planned Orders: 12 12 46 46 80 80 80 80 80 46 250 250 TABLE 14.9b Inventory Record for Door Hinge Item: Door Hinge Lot size rule: FOQ = 932 Lead time: 4 weeks Parent: Cabinet Door Children: none Beginning inventory: 0 2 3 4 5 6 7 0 432 0 0 432 0 932 0 500 500 500 68 68 8 0 9 0 10 0 11 0 0 Gross Requirements: Scheduled Receipts: Projected Available: Planned Orders: 0 68 68 68 68 68 TABLE 14.9c Inventory Record for Door Handle Item: Handle Lot size rule: FOQ = 200 Lead time: 3 weeks Parent: Cabinet Door Children: none Beginning inventory: 50 2 3 4 5 6 0 216 0 0 216 200 50 34 34 34 18 200 7 0 8 0 9 0 10 0 11 0 Gross Requirements: Scheduled Receipts: Projected Available: Planned Orders: 50 18 18 18 18 18 18 T TABLE 14.9d Inventory Record for Door Screws Item: Screw Lot size rule: FOQ = 2000 Lead time: 1 week 1 Gross Requirements: 0 Scheduled Receipts: Projected Available: 500 Planned Orders: Parent: Cabinet Door, Cabinet Side Children: none Beginning inventory: 500 3 4 5 6 7 8 0 2160 0 0 2160 0 0 2 9 0 10 0 11 0 12 0 340 340 180 180 180 180 180 180 180 500 2000 340 2000 14. Resource Planning TABLE 14.8e Inventory Record for Cabinet Door Item: Cabinet Door Lot size rule: FOQ = 216 Lead time: 4 weeks 12 Gross Requirements: Scheduled Receipts: Projected Available: Planned Orders: Parent: CD Cabinet Children: Magnet, hinge, handle, screws Beginning inventory: 120 2 3 4 5 6 7 8 9 10 0 0 20000 20000 2000 216 120 120 136 136 136 152 152 152 168 168 168 216 216 168 TABLE 14.8d Inventory Record for Cabinet Sides 12 Item: Side Parent: CD Cabinet Lot size rule: FOQ - 216 Children: none Lead time: 3 weeks Beginning inventory: 0 2 3 4 5 6 7 8 9 10 11 Gross Requirements: 00 20000 20000 200 0 0 Scheduled Receipts: 216 Projected Available: 0 16 16 16 32 32 32 48 48 48 Planned Orders: 216 216 48 TABLE 14.8e Inventory Record for Cabinet Shelves Item: Shelf Lot size rule: L4L Lead time: 2 weeks Parent: CD Cabinet Children: none Beginning inventory: 0 2 3 4 5 6 7 8 9 10 11 0 0 400 0 0 40000 40000 Gross Requirements: Scheduled Receipts: Projected Available: Planned Orders: 0 0 400 0 0 0 400 0 0 0 400 0 0 0 0 TABLE 14.8f Inventory Record for Shelf Supports Parent: CD Cabinet Children: none Beginning inventory: 0 3 4 5 6 0 16000 0 1600 2 Item: Shelf Supports Lot size rule: FOQ = 2500 Lead time: 1 week 1 Gross Requirements: 0 Scheduled Receipts: Projected Available: 0 Planned Orders: 8 7 0 9 1600 10 0 11 0 12 0 0 900 900 200 200 200 200 0 2500 900 1800 1800 1800 2500 After MRP reviews and updates the children of the CD cabinet, it drops to the next lower level in the BOM and processes the inventory records at that level. In our example, those records are for the door magnet, door hinge, handle, screws, door catch, and feet. The cab. inet door is the parent item for the magnet, hinge, handle, and screws. The cabinet right side is the parent of the door catch as well as a second parent for the screws. The cabinet bottom is the parent of the feet. Table 14.9 shows the inventory records for these remaining come ents. The process is the same as for the children of the CD cabinet. You look to the pla Product structure: Data: M (5) Item On Hand Scheduled Receipts 150, week 3 Lot Size TEMPS Order Policy FOO 800 7 40, week 5; FOQ = Fixed order quantity. "O" signifies usage. Using the data given, answer parts A and B. START by COPYING the rest of the QUESTION (from 'A." to "ZZZZ") into the answer space. A. For Item L. fill out gross requirements, schedule receipts, projected on hand, net requirements and planned orders. Items left blank are assumed to have a value of zero. (6 pts). L LLC. Period Item: Lot FOQ 800 LT: size: 1 2 3 4 5 6 3 Gross Requirements: Scheduled Receipts: Projected on Hand: 90 Net Requirements: Planned Order (Receipt): Planned Order (Releases): B. For Item M, compute the gross requirements: period(s) of 1-6 they belong in (2 pts) and specify which ZZZZ (note: ignore formatting issues in answering questions. order releases of the parent item to determine the gross requirements of the components For example, look at Table 14.9c (the inventory record for the handle); its parent (cabinet door) has planned orders in periods 3 and 6. Therefore, the handle must have gross requirements in periods 3 and 6. Next, let's look at how MRP provides information to the production and inventory control planners. TABLE 14.9 Inventory Records for Remaining Components TABLE 14.9a Inventory Record for Door Magnet Item: Door Magnet Lot size rule: FOQ - 250 Lead time: 2 weeks Parent: Cabinet Door Children: none Beginning inventory: 12 2 3 4 5 6 0 216 0 0 216 10 11 12 1 0 7 0 8 0 9 0 Gross Requirements: Scheduled Receipts: Projected Available: Planned Orders: 12 12 46 46 80 80 80 80 80 46 250 250 TABLE 14.9b Inventory Record for Door Hinge Item: Door Hinge Lot size rule: FOQ = 932 Lead time: 4 weeks Parent: Cabinet Door Children: none Beginning inventory: 0 2 3 4 5 6 7 0 432 0 0 432 0 932 0 500 500 500 68 68 8 0 9 0 10 0 11 0 0 Gross Requirements: Scheduled Receipts: Projected Available: Planned Orders: 0 68 68 68 68 68 TABLE 14.9c Inventory Record for Door Handle Item: Handle Lot size rule: FOQ = 200 Lead time: 3 weeks Parent: Cabinet Door Children: none Beginning inventory: 50 2 3 4 5 6 0 216 0 0 216 200 50 34 34 34 18 200 7 0 8 0 9 0 10 0 11 0 Gross Requirements: Scheduled Receipts: Projected Available: Planned Orders: 50 18 18 18 18 18 18 T TABLE 14.9d Inventory Record for Door Screws Item: Screw Lot size rule: FOQ = 2000 Lead time: 1 week 1 Gross Requirements: 0 Scheduled Receipts: Projected Available: 500 Planned Orders: Parent: Cabinet Door, Cabinet Side Children: none Beginning inventory: 500 3 4 5 6 7 8 0 2160 0 0 2160 0 0 2 9 0 10 0 11 0 12 0 340 340 180 180 180 180 180 180 180 500 2000 340 2000 14. Resource Planning TABLE 14.8e Inventory Record for Cabinet Door Item: Cabinet Door Lot size rule: FOQ = 216 Lead time: 4 weeks 12 Gross Requirements: Scheduled Receipts: Projected Available: Planned Orders: Parent: CD Cabinet Children: Magnet, hinge, handle, screws Beginning inventory: 120 2 3 4 5 6 7 8 9 10 0 0 20000 20000 2000 216 120 120 136 136 136 152 152 152 168 168 168 216 216 168 TABLE 14.8d Inventory Record for Cabinet Sides 12 Item: Side Parent: CD Cabinet Lot size rule: FOQ - 216 Children: none Lead time: 3 weeks Beginning inventory: 0 2 3 4 5 6 7 8 9 10 11 Gross Requirements: 00 20000 20000 200 0 0 Scheduled Receipts: 216 Projected Available: 0 16 16 16 32 32 32 48 48 48 Planned Orders: 216 216 48 TABLE 14.8e Inventory Record for Cabinet Shelves Item: Shelf Lot size rule: L4L Lead time: 2 weeks Parent: CD Cabinet Children: none Beginning inventory: 0 2 3 4 5 6 7 8 9 10 11 0 0 400 0 0 40000 40000 Gross Requirements: Scheduled Receipts: Projected Available: Planned Orders: 0 0 400 0 0 0 400 0 0 0 400 0 0 0 0 TABLE 14.8f Inventory Record for Shelf Supports Parent: CD Cabinet Children: none Beginning inventory: 0 3 4 5 6 0 16000 0 1600 2 Item: Shelf Supports Lot size rule: FOQ = 2500 Lead time: 1 week 1 Gross Requirements: 0 Scheduled Receipts: Projected Available: 0 Planned Orders: 8 7 0 9 1600 10 0 11 0 12 0 0 900 900 200 200 200 200 0 2500 900 1800 1800 1800 2500 After MRP reviews and updates the children of the CD cabinet, it drops to the next lower level in the BOM and processes the inventory records at that level. In our example, those records are for the door magnet, door hinge, handle, screws, door catch, and feet. The cab. inet door is the parent item for the magnet, hinge, handle, and screws. The cabinet right side is the parent of the door catch as well as a second parent for the screws. The cabinet bottom is the parent of the feet. Table 14.9 shows the inventory records for these remaining come ents. The process is the same as for the children of the CD cabinet. You look to the pla