Current averaging by separate receiving dates

[JcsChalleger]

I am trying to see if I can create and inventory wb in excel that would allow to enter an amount qty received on various dates yet current average them in one place for average cost on hand. The sheet I created does this, however I have only been able to accomplish this by making columns for received 1 , cost 1, received 2, cost 2 etc as seen in my wb attached. I would ideally prefer to have the current average of weekly or monthly deliveries be entered in just one received column constantly updating on hand cost averages and totals. Thanks for any help you may be able to provide. J

[DavidBowman]

The best way to do this is have a sheet where you enter the beginning inventory and the receipts. Then have on another tab either a pivot table of even better yet cube formulas that calculate and update the information to give you a summary.