60.1K

Verified Solution

Link Copied!

please show the formulas for everything and excel coordinates thank you

Item 500 LT = 1 wks Part 501(2) Part 502(1) Part 503(3) Part 504(2) LT = 2 wks LT = 1 wk LT = 3 wks LT = 2 wks Part 812(2) Part 813(3) LT = 2wks LT =1 wks Item 500 Period 0 1 2 3 4 5 6 7 8 9 10 250 250 250 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time = 0 0 0 0 0 0 0 0 0 0 0 0 250 250 250 0 0 1 Lot size= L4L Safety stock 0 Part: 501 Period 1 2 3 3 4 5 6 7 8 9 10 500 500 500 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time 600 600 600 600 600 100 100 600 600 100 600 1000 1000 2 Lot size= 1000 Safety stock 0 Part: 502 Period 0 1 2 3 4 5 6 7 8 9 10 250 250 Gross requirements Scheduled receipts Projected on hand Planned order releases 0 0 0 0 0 0 0 0 0 0 0 0 Lead time = 1 Lot size= L4L Safety stock 0 Part: 503 Period 0 1 1 2 3 4 5 6 7 9 9 10 8 750 750 750 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time = 800 800 800 50 50 50 50 50 50 50 50 3 Lot size= 1500 Safety stock 50 Part: 504 Period 0 1 2 3 4 5 6 7 8 9 10 Gross requirements 500 500 500 600 600 600 600 100 100 1600 1100 600 600 600 Scheduled receipts Projected on hand Planned order releases Lead time 2 Lot size 2000 Safety stock = 0 Part: 812 Period 0 1 2 3 4 5 6 7 8 8 9 10 500 500 500 500 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time = 500 500 500 500 0 0 0 0 0 0 0 500 500 500 500 2 Lot size= L4L Safety stock 0 Part: 813 Period 0 1 2 2 3 4 5 6 7 8 9 10 0 0 0 750 0 750 0 750 Gross requirements Scheduled receipts Projected on hand Planned order releases 1500 1500 1500 1500 750 750 0 0 750 750 750 Lead time 1 Lot size- 1500 Safety stock = 0 0 1 2 3 4 5 6 7 8 9 10 ITEM 500 250 250 250 PART 501 100 PART 502 250 250 250 PART 503 1500 PART 504 2000 PART 812 500 500 PART 813 1500 Item 500 LT = wks Part 501021 Part 50211 Part 5033) Part 50402) LT 2 ks LT1 LT LTE 2 w Part 01212) Part 8133) LT2wks LTS 10 1 Item 500 Period 2 O 2 3 4 5 8 0 10 250 250 250 13 74 15 16 17 18 19 20 Gross regalements Scheduled receipts Prelected on hand Plaved order releases de Safety wock 0 Part: 501 Period 1 2 5 6 7 10 21 Gross requirements Scheduled recept Projected on hand Planned order releases 600 23 24 25 time Doo Soldy stock 26 27 Part: 502 Period 28 0 1 2 3 4 5 6 7 10 29 30 Gross requirements Scheduled receipes Proiected on and Planned order releases 31 0 32 33 Sdey stock 34 35 36 Part 503 Period 0 2 3 4 5 6 7 TO 37 38 Gross requirements Scheduled receipts Prejected on hand Planned order releases 39 B00 40 MRP EOQ3 EOQ13 + D Lime G 1 42 43 Part:504 Period 1 2 5 10 45 46 Gross requirements Sched receipt Proiected on hand Planerades 000 Le Part:312 Period 2 10 13 Grossements Sched recept Pelected on and Pland order releases 500 es 0 Part 13 Period 60 0 2 5 10 61 62 Gross requirements Scheduled receipt Projected on hand Planned order released 15.00 64 65 O 06 67 68 60 70 71 0 1 2 3 4 6 5 19 73 74 75 76 77 ITEM 500 PART 501 PART 502 PART 503 PART 504 PART 512 PART 613 RESES Item 500 LT = 1 wks Part 501(2) Part 502(1) Part 503(3) Part 504(2) LT = 2 wks LT = 1 wk LT = 3 wks LT = 2 wks Part 812(2) Part 813(3) LT = 2wks LT =1 wks Item 500 Period 0 1 2 3 4 5 6 7 8 9 10 250 250 250 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time = 0 0 0 0 0 0 0 0 0 0 0 0 250 250 250 0 0 1 Lot size= L4L Safety stock 0 Part: 501 Period 1 2 3 3 4 5 6 7 8 9 10 500 500 500 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time 600 600 600 600 600 100 100 600 600 100 600 1000 1000 2 Lot size= 1000 Safety stock 0 Part: 502 Period 0 1 2 3 4 5 6 7 8 9 10 250 250 Gross requirements Scheduled receipts Projected on hand Planned order releases 0 0 0 0 0 0 0 0 0 0 0 0 Lead time = 1 Lot size= L4L Safety stock 0 Part: 503 Period 0 1 1 2 3 4 5 6 7 9 9 10 8 750 750 750 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time = 800 800 800 50 50 50 50 50 50 50 50 3 Lot size= 1500 Safety stock 50 Part: 504 Period 0 1 2 3 4 5 6 7 8 9 10 Gross requirements 500 500 500 600 600 600 600 100 100 1600 1100 600 600 600 Scheduled receipts Projected on hand Planned order releases Lead time 2 Lot size 2000 Safety stock = 0 Part: 812 Period 0 1 2 3 4 5 6 7 8 8 9 10 500 500 500 500 Gross requirements Scheduled receipts Projected on hand Planned order releases Lead time = 500 500 500 500 0 0 0 0 0 0 0 500 500 500 500 2 Lot size= L4L Safety stock 0 Part: 813 Period 0 1 2 2 3 4 5 6 7 8 9 10 0 0 0 750 0 750 0 750 Gross requirements Scheduled receipts Projected on hand Planned order releases 1500 1500 1500 1500 750 750 0 0 750 750 750 Lead time 1 Lot size- 1500 Safety stock = 0 0 1 2 3 4 5 6 7 8 9 10 ITEM 500 250 250 250 PART 501 100 PART 502 250 250 250 PART 503 1500 PART 504 2000 PART 812 500 500 PART 813 1500 Item 500 LT = wks Part 501021 Part 50211 Part 5033) Part 50402) LT 2 ks LT1 LT LTE 2 w Part 01212) Part 8133) LT2wks LTS 10 1 Item 500 Period 2 O 2 3 4 5 8 0 10 250 250 250 13 74 15 16 17 18 19 20 Gross regalements Scheduled receipts Prelected on hand Plaved order releases de Safety wock 0 Part: 501 Period 1 2 5 6 7 10 21 Gross requirements Scheduled recept Projected on hand Planned order releases 600 23 24 25 time Doo Soldy stock 26 27 Part: 502 Period 28 0 1 2 3 4 5 6 7 10 29 30 Gross requirements Scheduled receipes Proiected on and Planned order releases 31 0 32 33 Sdey stock 34 35 36 Part 503 Period 0 2 3 4 5 6 7 TO 37 38 Gross requirements Scheduled receipts Prejected on hand Planned order releases 39 B00 40 MRP EOQ3 EOQ13 + D Lime G 1 42 43 Part:504 Period 1 2 5 10 45 46 Gross requirements Sched receipt Proiected on hand Planerades 000 Le Part:312 Period 2 10 13 Grossements Sched recept Pelected on and Pland order releases 500 es 0 Part 13 Period 60 0 2 5 10 61 62 Gross requirements Scheduled receipt Projected on hand Planned order released 15.00 64 65 O 06 67 68 60 70 71 0 1 2 3 4 6 5 19 73 74 75 76 77 ITEM 500 PART 501 PART 502 PART 503 PART 504 PART 512 PART 613 RESES

Answer & Explanation Solved by verified expert

See Answer