Excel Format

Finished Good 500 LT = 2 weeks Part 501 Usage=2 LT-2 weeks Part 502 Usage = 1 LT = 1 week Part 503 Usage = 3 LT - 3 weeks Part 504 Usage = 2 LT = 2 weeks Part 812 Usa ge=2 LT = 2 weeks Part 813 Usage = 4 LT = 1 week Forecasted demand for item 500: Week 2: 250 Week 4: 250 Week 6: 500 Week 8: 350 Week 10: 300 Item/Part Lot Size Rule LT Item 500 Part 501 Part 502 Part 503 Part 504 Part 812 Part 813 Beginning Inventory 200 400 80 800 250 900 120 Scheduled Receipts 300 - Week 1 None 100-Week 2 None None 200 - Week 1 None L4L FOQ-800 L4L FOQ=500 FOQ-800 FOQ=200 FOQ=300 || 2 2 1 3 2 2 1 Using MRP Template, create the MRP plan for Item 500 and all its parts for a 10 week planning period