Freight Allocation

humdingaling,

Thanks for the weighted cost. I have one more question regarding your first formula. I also need to allocate the sales tax. I have attached a file here. I do not know how to allocate the sales tax to the product only without assigning it to the freight charge?