1 2 D EF G H 1 J K L 3 4 MRP assignment 4.1 5 Lot-for-lot Model 6 7 Week Number 1 2 3 4 5 6 8 9 Item A: LT = 1 week 0 15 15 18 8 12 16 10 Gross Requirements 11 Scheduled Receipts 12 Projected on Hand 13 Net Requirements 14 Planned-Order Receipts 15 Planned-Order Releases 16 17 Item B: LT = 2 weeks 18 Gross Requirements 19 Scheduled Receipts 20 Projected on Hand 21 Net Requirements 22 Planned-Order Receipts 23 Planned-Order Releases 40 12 24 25 Item C: LT = 1 week 50 26 Gross Requirements 27 Scheduled Receipts 28 Projected on Hand 29 Net Requirements 30 Planned-Order Receipts 31 Planned-Order Releases Definitions: 1 Gross requirements: anticipated future usage of (or demand for) the item during each period. 2 Scheduled receipts: existing replenishment orders for the item due in at the beginning of each period. 3 Projected on hand: projected inventory status for the item at the beginning of each period. 4 Net requirements: calculated as Gross Requirements plus Scheduled Receipts minus Projected on hand. 5 Planned order receipt: planned receipt of replenishment orders at the beginning of the period. 6 Planned order releases: release of planned replenishment orders for the item using lead-time offset. Computations: 1 gross requirements = given in problem 2 scheduled receipts = given in problem if any 3 projected on hand for current week = projected on hand previous week + planned order receipts previous week - gross requirements previous week + gross requirements current week 4 net requirements = max [gross requirements - projected on hand),0] 5 planned order receipts = net requirements 6 planned order releases= planned order receipts in week X (where X is the week corresponding to the proper lead time for that item) Items A and C=1 week lead time Items B = 2 weeks lead time 1 2 D EF G H 1 J K L 3 4 MRP assignment 4.1 5 Lot-for-lot Model 6 7 Week Number 1 2 3 4 5 6 8 9 Item A: LT = 1 week 0 15 15 18 8 12 16 10 Gross Requirements 11 Scheduled Receipts 12 Projected on Hand 13 Net Requirements 14 Planned-Order Receipts 15 Planned-Order Releases 16 17 Item B: LT = 2 weeks 18 Gross Requirements 19 Scheduled Receipts 20 Projected on Hand 21 Net Requirements 22 Planned-Order Receipts 23 Planned-Order Releases 40 12 24 25 Item C: LT = 1 week 50 26 Gross Requirements 27 Scheduled Receipts 28 Projected on Hand 29 Net Requirements 30 Planned-Order Receipts 31 Planned-Order Releases Definitions: 1 Gross requirements: anticipated future usage of (or demand for) the item during each period. 2 Scheduled receipts: existing replenishment orders for the item due in at the beginning of each period. 3 Projected on hand: projected inventory status for the item at the beginning of each period. 4 Net requirements: calculated as Gross Requirements plus Scheduled Receipts minus Projected on hand. 5 Planned order receipt: planned receipt of replenishment orders at the beginning of the period. 6 Planned order releases: release of planned replenishment orders for the item using lead-time offset. Computations: 1 gross requirements = given in problem 2 scheduled receipts = given in problem if any 3 projected on hand for current week = projected on hand previous week + planned order receipts previous week - gross requirements previous week + gross requirements current week 4 net requirements = max [gross requirements - projected on hand),0] 5 planned order receipts = net requirements 6 planned order releases= planned order receipts in week X (where X is the week corresponding to the proper lead time for that item) Items A and C=1 week lead time Items B = 2 weeks lead time
