Calculate EOQ, ROP, and Safety Stock for both SKU?s; furthermore, you will explain the possible inventory savings across the entire inventory (10,000 SKUs)?

Transcribed Image Text:

A B 1 C D E FB378 Actual Forecast Demand F G GS131 Actual Forecast Demand 2 3 Week 4 1 56 57 52 55 62 63 58 69 7 4 57 74 85 60 61 96 60 60 10 7 72 69 11 8 56 65 12 9 54 75 13 10 69 50 14 11 73 63 146 133 15 12 67 66 125 139 16 13 72 63 94 145 17 14 74 73 117 136 18 15 60 53 146 106 19 16 65 72 140 148 20 17 62 73 101 145 21 18 53 58 112 124 22 19 54 65 137 137 23 20 67 63 94 141 24 21 72 68 128 95 25 22 53 60 96 98 26 23 60 52 99 119 27 24 64 58 136 101 28 25 52 65 136 107 29 26 55 66 140 107 30 27 52 93 31 32 33 Original Order Quantity: FB378 1000 GS131 650 34 35 A B 1 C D E FB378 Actual Forecast Demand F G GS131 Actual Forecast Demand 2 3 Week 4 1 56 57 52 55 62 63 58 69 7 4 57 74 85 60 61 96 60 60 10 7 72 69 11 8 56 65 12 9 54 75 13 10 69 50 14 11 73 63 146 133 15 12 67 66 125 139 16 13 72 63 94 145 17 14 74 73 117 136 18 15 60 53 146 106 19 16 65 72 140 148 20 17 62 73 101 145 21 18 53 58 112 124 22 19 54 65 137 137 23 20 67 63 94 141 24 21 72 68 128 95 25 22 53 60 96 98 26 23 60 52 99 119 27 24 64 58 136 101 28 25 52 65 136 107 29 26 55 66 140 107 30 27 52 93 31 32 33 Original Order Quantity: FB378 1000 GS131 650 34 35