Forum Discussion
Opening and Closing Inventory Balance - Forecasting
Hi all, new to the forum. Im having trouble dealing with closing balance of inventory when the forward forecast results in negatives. I have: -current starting Inventory -monthly sales foreca...
Hi,
Share a simple dataset and show the expected result there.
Thanks For responding. This is what Im getting:
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| OPENING INV | 120 | 20 | 120 | 20 | -80 | -180 | -280 | 20 | -80 | -180 | -280 | -380 |
| FORECAST | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| PURCHASES | 0 | 200 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 |
| ENDING INV | 20 | 120 | 20 | -80 | -180 | -280 | 20 | -80 | -180 | -280 | -380 | -480 |
| FUTURE | FUTURE | FUTURE | FUTURE | FUTURE | FUTURE | FUTURE | FUTURE | FUTURE |
This is the desired result:
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| OPENING INV | 120 | 20 | 120 | 20 | 0 | 0 | 0 | 300 | 200 | 100 | 0 | 0 |
| FORECAST | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| PURCHASES | 0 | 200 | 0 | 0 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 |
| ENDING INV | 20 | 120 | 20 | 0 | 0 | 0 | 300 | 200 | 100 | 0 | 0 | 0 |
| FUTURE | FUTURE | FUTURE | FUTURE | FUTURE | FUTURE | FUTURE | FUTURE | FUTURE |
Hi,
Share the link from where i can download your PBI file.
Hi, unfortunately im unable to share files as per my company's privacy policies.
Hi was unable to send the PBI file but I mocked up a ppvt file for an illustration of what I want.