Need help with my simple warehouse project

Hi Anakin,
Had a quick look at your warehouse spreadsheet.
I've made a few (well, a lot actually - LOL!) assumptions but I'd probably tackle it this way (please see attached).
I've used 'weighted average' for valuation of stock and have associated items with a specific warehouse location rather than allocate the location on delivery (it doesn't have to be that way but I'm guessing you'd hit problems taking an item from different locations on the same dispatch note).
Again, a small script but it's only cosmetic (and it would work just the same without it).
Anyway, hopefully you can use it as a bit of a guide, if nothing else.
Regards,
Derek.