Column A I bought 16 kgs of coffee beans @65. Total is 1,040. Let's ignore the A7 (5% VAT) p;ease. Now I'd like to know how much it costs me for a gram of beans. I'll divide 1040/16kg then convert it into Grams: 1040/16kg/1000. As simple as that.
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Coffee Beans | Monin Blue Ocean syrup | Monin Pomergranate syrup | Monin Vanilla syrup | |||
2 | Unit cost | 65 | 57 | 57 | 57 | ||
3 | Item unit basis qty (as sold) | 1 | 1 | 700 | 700 | ||
4 | Item unit basis (as sold) [A] | kg | L | mL | mL | ||
5 | Preferred unit basis | ||||||
Sheet8 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2 | B2 | =65 |
C2:E2 | C2 | =57 |
B7:E7 | B7 | =B2/B3/B6 |
Book2 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Coffee Beans | Monin Blue Ocean syrup | Monin Pomergranate syrup | Monin Vanilla syrup | |||
2 | Unit cost | 65 | 57 | 57 | 57 | ||
3 | Item unit basis qty (as sold) | 1 | 1 | 700 | 700 | ||
4 | Item unit basis (as sold) [A] | kg | L | mL | mL | ||
5 | Preferred unit basis | ||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B7:E7 | B7 | =B2/B3/B6 |
unitconv.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Coffee Beans | Monin Blue Ocean syrup | Monin Pomergranate syrup | Monin Vanilla syrup | |||
2 | Unit cost | 65 | 57 | 57 | 57 | ||
3 | Item unit basis qty (as sold) | 1 | 1 | 700 | 700 | ||
4 | Item unit basis (as sold) (A) | kg | L | mL | mL | ||
5 | Preferred unit basis (B) | g | mL | mL | mL | ||
6 | Conversion factor (A/cf=B) | 1000 | 1000 | 1 | 1 | ||
7 | Cost per preferred unit basis | 0.065 | 0.057 | 0.081428571 | 0.081428571 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B7:E7 | B7 | =B2/B3/B6 |