Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to calculate lowest unit of measure?

in Sourcing 3 comments

Summary:

We have a need for the solicitation to convert the line items to the lowest unit of measure.
Example - supplier A provides pricing for green beans 12 oz cans @ 24/case - 24.00 per case. $1.00 per can = .083 per oz. This would convert to 288 oz at .083 unit of lowest measure.
Supplier B gives pricing for same greens beans 10 oz cans @ 18/case = 20.00. .90 cents per can - .09 per oz. This would convert to 180 oz at .09 per oz.
Would like to know if the system can calculate the lowest unit of measure without having to do manual calculation.

Content (please ensure you mask any confidential information):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!