The shop just made 10,000 ft of 5" pipe. There is 1,000 ft in stock with an average cost of $0.40 per ft and a new (November 1) cost of $.036 ft. When I do an adjustment, I select Quantity and Cost, then Increase, and then I enter 10000 in quantity and the cost comes up $4,000.00, so I have to enter in $3,600.00.