Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

# Formula to calculate Cost of Goods

Topic Labels: Formulas
Solved
552 2
cancel
Showing results for
Did you mean:
4 - Data Explorer

I want to create a table to calculate my cost of goods, for products that I make.

I have a table with the list of products and their RRP.
Another table with a list of expenses, ie labour cost, packaging cost, materials cost etc

I want to have a third table that takes (product RRP) - (total costs) = profit
For example (candle \$59) - (wax \$2, vessel \$5, packaging \$3, labour \$10) = \$39

I’m very new to tables and formulas, so it may be easy and obvious. Any help would be appreciated!

1 Solution

Accepted Solutions
11 - Venus

Hi @Simone_Nabholz and welcome back to the community!

Are these fixed prices? If yes, you could work with a field that links to 1 or multiple expenses and then use a rollup field to make the sum. U could then do the same for your products, or, if there’s only 1 product with a fixed price, use a lookup field for the “product RRP”.

2 Replies 2
11 - Venus

Hi @Simone_Nabholz and welcome back to the community!

Are these fixed prices? If yes, you could work with a field that links to 1 or multiple expenses and then use a rollup field to make the sum. U could then do the same for your products, or, if there’s only 1 product with a fixed price, use a lookup field for the “product RRP”.

4 - Data Explorer

Thank you, I’ll give that a go!