Forum Discussion
Overstock Bracket Value
Hi, I wonder someone can help. I am working on Inventory Health to acertain overstocks. I worked out my stock weeks cover by simply looking at my balance on hand devided by average week sale...
Anonymous
Please include the expected results as well as column
Please see below results. - it's driven by basic if statement to identify stock on hand that is associated to each overtock criteria.
| ProductID | Price/Unit (£) | Balance on Hand | Avg Wk Sale (Units) | Avg Wk Sale (£) | Wks Cover | Overstock Bracket | 12-16 | 16-26 | 26+56 | 56+ | No Demand |
| 12 | 6.71 | 2257 | 178 | 1194.38 | 12.7 | 12-16 | 121 | 0 | 0 | 0 | 0 |
| 33 | 5.64 | 392 | 19 | 107.16 | 20.6 | 16-26 | 164 | 0 | 0 | 0 | 0 |
| 67 | 20.8 | 989 | 1 | 20.8 | 989 | 56+ | 14 | 26 | 4 | 933 | 0 |
| 116 | 27.22 | 1557 | 1412 | 38434.64 | 1.1 | 0 | 0 | 0 | 0 | 0 | |
| 133 | 92.43 | 41 | 0 | 0 | 1000000 | No Demand | 0 | 0 | 0 | 0 | 41 |
| 189 | 0.39 | 4518 | 171 | 66.69 | 26.4 | 26-56 | 2394 | 72 | 0 | 0 | 0 |