Unit Conversion with Unit of Measurements for Items, has anyone successfully figured this out????
I am currently using google sheets to break down my per cost of items I buy in bulk. We are a non-profit that creates kits and resells at the exact price we pay for the items to our customers or uses grants from the government to pay for them. I can not get the Unit Conversion with Unit of Measurements for Items to work correctly for items I regularly buy from Amazon and Walmart to break the cost down for me at all.
I have all of the need info ready to go but have no idea what to put in following parts:
- UoM
- Unit Precision
- Unit Conversions
- Target Unit
- Conversion Rate
Some examples of groupings I'm looking to break down:
| Item Name | #/Pack | Total Cost | Item Cost |
| Non-Toxic Pest Traps | 6 | $23.36 | $3.89 |
| Squegee | 12 | $19.99 | $1.67 |
| Spray Bottle (16oz) | 18 | $32.99 | $1.83 |
| Scrub Brush | 24 | $21.99 | $0.92 |
| Reuseable Rubber Gloves | 36 | $34.79 | $0.97 |
| Cinch Bags | 50 | $32.99 | $0.66 |
| N-95 Mask | 60 | $19.99 | $0.33 |
| Shipping Box | 96 | $39.99 | $0.42 |
| Microfiber Cleaning Cloth | 100 | $30.99 | $0.31 |
| Shipping Tape | 240 | $39.99 | $0.17 |
| Bags | 750 | $900.10 | $1.20 |
| Calendar | 1000 | $1,499.63 | $1.50 |
| Cue Cards | 1250 | $2,020.18 | $1.62 |
I know how to make a spread sheet do the work but I'd like my inventory system do the work now.