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...
thanks for your feedback.
Please see below sample data for all overstock scenarios.
It's worth noting that 'no demand' bracket is generated if ProductID have no sales.
| ProductID | Price/Unit (£) | Balance on Hand | Avg Wk Sale (Units) | Avg Wk Sale (£) | Wks Cover | Overstock Bracket |
| 12 | 6.71 | 2257 | 178 | 1194.38 | 12.7 | 12-16 |
| 33 | 5.64 | 392 | 19 | 107.16 | 20.6 | 16-26 |
| 67 | 20.8 | 989 | 1 | 20.8 | 989 | 56+ |
| 116 | 27.22 | 1557 | 1412 | 38434.64 | 1.1 | |
| 133 | 92.43 | 41 | 0 | 0 | 1000000 | No Demand |
| 189 | 0.39 | 4518 | 171 | 66.69 | 26.4 | 26-56 |
Anonymous
Please include the expected results as well as column