Working on a project to try and reduce excess stock by moving it to regions that will need the stock. Have gotten to a list of several materials in several regions with the stock that needs to be moved or the stock the region needs moved in. Looking for a process to reduce the values a material has in plants that have excess to the plants that need the stock. Depleting all the stock in the plant with the most excess first and then moving to the next plant. Filling only what is needed in the plants that need stock. For example, below the material S60 in plant 33 would move 3261 to plant 73 then 568 to plant HD and so on until the excess stock in 33 has been depleted. Then the tool would start pulling from the next plant 41. This process would have to work through several different materials.
| MATERIAL | PLANT | WEEK | MOVE/NEED | OVER/UNDER MAXCAP |
| S60 | 33 | 8/23/2021 | MOVE | 11182 |
| S60 | 41 | 8/23/2021 | MOVE | 3656 |
| S70 | HF | 8/23/2021 | MOVE | 2842 |
| S70 | OC | 8/23/2021 | MOVE | 2243 |
| S70 | MH | 8/23/2021 | MOVE | 1790 |
| S70 | 21 | 8/23/2021 | MOVE | 1007 |
| S60 | HB | 8/23/2021 | NEED | -204 |
| S60 | 43 | 8/23/2021 | NEED | -421 |
| S60 | HD | 8/23/2021 | NEED | -568 |
| S70 | 73 | 8/23/2021 | NEED | -1058 |
| S70 | CG | 8/23/2021 | NEED | -1134 |
| S70 | 44 | 8/23/2021 | NEED | -1814 |
| S70 | 41 | 8/23/2021 | NEED | -1971 |
| S60 | 73 | 8/23/2021 | NEED | -3261 |
