Profit at every quantity level
The standard calculation for profit is simply:Total Revenue - Total Costs
If we want to know how much profit we will receive if we sell 3 units, we simply use the formula:Profit(3 units) = Total Revenue (3 units) - Total Costs (3 units)
Once you do that for every level of quantity, your sheet should look like the one below.