Unsold Inventory Calculation

I need to get an idea on how to calculate inventory levels on a monthly basis.  I have a table with monthly sales to retailers and another one that shows actual customer sales.  The calculation would...