Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I cleaned and manipulated the data into one table.   So for each 4 WE Period I need to calculate the Shipping Units minus the balance from the previous Period.  In this example the inventory Units for 4 W/E 01/27/18 is the Shipping Units (91,076) minus the Consumption Units (243.24) or 90,832.76.  The next period Inventory Units results for 4 WE 02/24/18 would be the results from the prior period (90,832.76) plus the shipping from Period 4 WE 02/24/18 (138,620.00) minus the Consumption for Period (4 W/E 02/24/18 (5,681.57) which would be 223,771.60.  This calc would repeat each month.  Thoughts on how to structure the Inventory Units calculation?

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

A follow up...I have added the date into the table to go along with the "Period" perhaps this helps any calculation(s).

 

Thoughts?