millertime33
New Member
- Joined
- Jan 18, 2016
- Messages
- 2
I'm looking to determine the Weeks on Hand (WOH) of inventory based on Quantity on hand (D2) and the forecasts(G2:R2). I don't want to just take an average of forecasts, but I need to take into account that the actual run-out will be sooner than the 'average' run-out due to high seasonality in the summer months. Make sense? Can someone offer some guidance please? Thanks!
A B C D E F G H I J K L
<colgroup><col><col><col><col><col><col><col><col span="11"></colgroup><tbody>
</tbody>
A B C D E F G H I J K L
1 Item | Description | Type | Qnty on hand | MOH | MOH&MOO | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
2 12345 | wowsers | 20 | 3 | 3 | 4 | 5 | 6 | 7 | 7 | 8 | 7 | 6 | 5 | 4 |
<colgroup><col><col><col><col><col><col><col><col span="11"></colgroup><tbody>
</tbody>