Video Tutorial:

This is a financial model for manufacturers of anything to see how much they should charge for their products in order to meet certain profit margin goals.

It works by letting you input all your costs. Then, you simply enter 3 different unit sales volume scenarios. The unit sales should match with the period that the costs are for if you want something accurate.

Visuals included so you can see total $ sales, profit $ and profit per unit/cost per unit.