Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help for my inventory cover analysis. Inorder to get the following:
FLOOR COVER: (InventoryBeginning-CurrentForecast)/NextForecast
INVENTORY BEGINNING: Previous InventoryBeginning + Previous Purchase Order - Previous Forecast
Look at the table below:
FORECAST
MONTH YEAR | QTY |
---|---|
Jan 2012 | 100 |
Feb 2012 | 150 |
Mar 2012 | 130 |
PURCHASE ORDER
MONTH YEAR | QTY |
---|---|
Jan 2012 | 120 |
Feb 2012 | 180 |
Mar 2012 | 135 |
AND BELOW SHOULD BE THE REPORT FORMAT
Jan 2012 | Feb 2012 | Mar 2012 | |
---|---|---|---|
Inventory Beginning | 300 | 320 | 350 |
Forecast | 100 | 150 | 130 |
Purchase Order | 120 | 180 | 135 |
Floor Cover | 1.33% | 1.31% | - |
Any help with will be more appreciated.
Regards,
Bill
Hi Bill
check attached qvw file
Hi Pari Pari,
Thanks for your help, I'd been thinking for the solution. Great work!
Regards,
Bill