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!