I have a 'net profit calculator' that i am needing assistance to automate.
The user defines their target net profit, then their overall expenses, their cost per unit and then sell price.
The intention of the calculator is then to returns results on the number of sales required, expenses, gross sales to reach the target net profit.
Then if the user add multiple units, it assumes equal value across each unit.
Ideally the result would show the units for each product - then the user could edit the units up and down to show its effect on net profit.
I have uploaded the sample basic version which has been done using manual calculations.