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
