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.
|Summary||Straight forward way for a manufacturing business to see cost per unit and define margins in order to see suggesting selling prices per unit.|
|Screenshots / Pictures|
|Use Cases||Accounting, CFO, Cost Calculation, Excel, Financial Feasibility, Financial Projections, Pricing, Profitability Analysis|