Formula to calculate Cost of Goods

[Simone_Nabholz]

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!

[Databaser · Accepted solution]

Hi @Simone_Nabholz and welcome back to the community!

Simone_Nabholz:

(wax $2, vessel $5, packaging $3, labour $10)

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”.

[Simone_Nabholz]

Thank you, I’ll give that a go!