I am using the sample spreadsheet that user highbarger provided on April 4, 2011. I added unit costs to the spreadsheet along with other columns. The cost for some products changes with the supplier with new purchases. Is there a formula I can use determine which unit cost to use? I know the number of each product in the master inventory prior to the purchase, so when the total count left in inventory gets to that number, I can change the unit cost to the new price.
Bookmarks