Points total: 3.5 Problem 1 (2 pts). One unit of A is made of one unit of B and one unit of C. B is made of four units of C and one unit each of E and F. C is made of two units of D and one unit of E. E is made of three units of F. Item C has a lead time of one week. Item A, B, E, and F have two-week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items A, D, and E; lots of size 50, 100, and 50 are used for Items B, C, and F, respectively. Items A, C, D, and E have on-hand (beginning) inventories of 20, 50, 100, and 10, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 1, 100 units of C in Week 1, and 100 units of D in Week 3; there are no other scheduled receipts. If 50 units of A are required in Week 10, use the low-level-coded bill-of-materials to find the necessary planned order releases for all components. (Hints: Refer to the examples in Lecture14_Exercise, Lecture 14_MRP slides, and Lecture notes 14_MRP on CANVAS. A step video link is provided in the lecture notes) (Grading Hints: correctness of bill of material (Product structure tree), the completeness and correctness of the MRP scheduling Table) (1). Product structure tree (low level coded) (2). MRP table 1 2 3 4 5 6 7 8 9 10 Item: OH: LT: SS: Q: Item: OH: LT: SS: Q: Item: : LT: SS: Q: Period: Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item: OH: LT: SS: Q: Item: OH: LT: SS: Q: Item: OH: LT: SS: Q: Points total: 3.5 Problem 1 (2 pts). One unit of A is made of one unit of B and one unit of C. B is made of four units of C and one unit each of E and F. C is made of two units of D and one unit of E. E is made of three units of F. Item C has a lead time of one week. Item A, B, E, and F have two-week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items A, D, and E; lots of size 50, 100, and 50 are used for Items B, C, and F, respectively. Items A, C, D, and E have on-hand (beginning) inventories of 20, 50, 100, and 10, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 1, 100 units of C in Week 1, and 100 units of D in Week 3; there are no other scheduled receipts. If 50 units of A are required in Week 10, use the low-level-coded bill-of-materials to find the necessary planned order releases for all components. (Hints: Refer to the examples in Lecture14_Exercise, Lecture 14_MRP slides, and Lecture notes 14_MRP on CANVAS. A step video link is provided in the lecture notes) (Grading Hints: correctness of bill of material (Product structure tree), the completeness and correctness of the MRP scheduling Table) (1). Product structure tree (low level coded) (2). MRP table 1 2 3 4 5 6 7 8 9 10 Item: OH: LT: SS: Q: Item: OH: LT: SS: Q: Item: : LT: SS: Q: Period: Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item: OH: LT: SS: Q: Item: OH: LT: SS: Q: Item: OH: LT: SS
