Alice's Sewing Company Incorporated Case-Demonstrating Bottom-Up Replanning Alice's Sewing Company provided aftermarket leather seats to the van conversion market. They have an ERP system that they are using to plan and schedule raw material and manufacturing activities. Two of the products that they manufacture are armrests and headrests for the Freestar van. Both the headrest (H) and armrest (A) are made of the same raw material black hide (X). There are other component parts for these parts (Q, R, and S) that also use the black hide. There is an independent service demand for part number S. 4. Assignment: (All information required is found in the files that follow.) 1. Create product structure trees for Hand A. 2. Create MRP worksheets for all parts required to manufacture Hand A. 3. What if any exception messages would be generated by MRP? You have a phone call from the Tannery that the truck hit a moose on route to the airport. Unfortunately, all of the leather was destroyed in the accident. This is the Scheduled receipt due in Week 3. It will take them until week #5 to replace the order using the normal transportation mode. The hides will be available for shipment in Week 4 and an option is they can be air expressed for a premium of $2000 and you could receive on Tuesday of Week 4. The SR for week 2 is in Montreal and will arrive as scheduled. Given this situation, what are your options? Make sure you use pegging to determine your solution. What can you do specifically to prevent any shortages of your finished goods? Where-used Bill of Material Files Where used file-Part Q Where used file- Part R Where used file -Parts Parent H Parent A Parent A Quantity Quantity Quantity 2 3 1 Where used file- Part X Parent . Quantity 2 2 NO R 1 S 3 MPS Week 4 5 4 Part 1 2 3 6 7 8 9 10 . 75 75 95 105 95 200 200 200 200 S 25 25 25 25 25 Item Master, Inventory and Open Order Files H A Q Lot Size 50 300 Lead Time 1 2 1 On hand Inv. 80 100 Safety Stock On order 100, wki Part Number R L4L 2 L4L S 200 1 75 1000 4 1500 100 600, wk2 1000 Wk2&.3 Part Number 1 2 3 4 5 6 7 8 9 10 Lot Size Lead Time On hand Parent Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipt Planned Order Release Safety Stock Low-Level Code Part Number Parent 1 2 3 4 5 6 7 9 10 Lot Size Lead Time Gross Requirements Scheduled Receipts Projected Available Net Requirements On hand Safety Stock Low-Level Code Planned Order Receipt Planned Order Release Part Number 1 2 3 4 5 6 7 8 9 10 Lot Size Parent Gross Requirements Scheduled Receipts Lead Time Projected Available On hand Net Requirements Safety Stock Low-Level Code Planned Order Receipt Planned Order Release Alice's Sewing Company Incorporated Case-Demonstrating Bottom-Up Replanning Alice's Sewing Company provided aftermarket leather seats to the van conversion market. They have an ERP system that they are using to plan and schedule raw material and manufacturing activities. Two of the products that they manufacture are armrests and headrests for the Freestar van. Both the headrest (H) and armrest (A) are made of the same raw material black hide (X). There are other component parts for these parts (Q, R, and S) that also use the black hide. There is an independent service demand for part number S. 4. Assignment: (All information required is found in the files that follow.) 1. Create product structure trees for Hand A. 2. Create MRP worksheets for all parts required to manufacture Hand A. 3. What if any exception messages would be generated by MRP? You have a phone call from the Tannery that the truck hit a moose on route to the airport. Unfortunately, all of the leather was destroyed in the accident. This is the Scheduled receipt due in Week 3. It will take them until week #5 to replace the order using the normal transportation mode. The hides will be available for shipment in Week 4 and an option is they can be air expressed for a premium of $2000 and you could receive on Tuesday of Week 4. The SR for week 2 is in Montreal and will arrive as scheduled. Given this situation, what are your options? Make sure you use pegging to determine your solution. What can you do specifically to prevent any shortages of your finished goods? Where-used Bill of Material Files Where used file-Part Q Where used file- Part R Where used file -Parts Parent H Parent A Parent A Quantity Quantity Quantity 2 3 1 Where used file- Part X Parent . Quantity 2 2 NO R 1 S 3 MPS Week 4 5 4 Part 1 2 3 6 7 8 9 10 . 75 75 95 105 95 200 200 200 200 S 25 25 25 25 25 Item Master, Inventory and Open Order Files H A Q Lot Size 50 300 Lead Time 1 2 1 On hand Inv. 80 100 Safety Stock On order 100, wki Part Number R L4L 2 L4L S 200 1 75 1000 4 1500 100 600, wk2 1000 Wk2&.3 Part Number 1 2 3 4 5 6 7 8 9 10 Lot Size Lead Time On hand Parent Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipt Planned Order Release Safety Stock Low-Level Code Part Number Parent 1 2 3 4 5 6 7 9 10 Lot Size Lead Time Gross Requirements Scheduled Receipts Projected Available Net Requirements On hand Safety Stock Low-Level Code Planned Order Receipt Planned Order Release Part Number 1 2 3 4 5 6 7 8 9 10 Lot Size Parent Gross Requirements Scheduled Receipts Lead Time Projected Available On hand Net Requirements Safety Stock Low-Level Code Planned Order Receipt Planned Order Release