We have a company that uses as lot of different sized steel beams and columns. In the BOM’s we use for the base unit of measure FT1, it’s the unit on all drawings and used in design. All these beams have a fixed conversion factor to their weight. Their weight is used to calculate the purchase price by the vendor and fluctuates weekly. Say, for one hundred different items we could use the same purchase price per LB which will convert in different prices in FY1 for each different beam.
Would there be a way to automate the calculation of the new standard cost (or unit cost) per FT1 if we get a new purchase quote )new steel price per LB) once a week?
Thank you, Niels