*After purchase, the model will be e-mailed to you.
The model was designed to be as simple as possible, but still allow user to show all their direct and indirect costs and have 3 scenarios (low, medium, and high) sales volumes. This will drive what price you can sell each unit for and still make a desired margin.
This model assumes the costs you are putting in match the units you are putting in your expected forecast. Remember this is not production units, but rather sales units. If you want to make the model smart enough to auto-calculate unit sales based on the variable costs, that function can be built in, but for the purpose of making something everyone can use generally, this is the format.
See my financial model hourly billing rate for work that you want done to the model. I understand everyone has their specific situations and scenarios they want to evaluate.
Visuals were also added to this so you can see how much profit you are taking away from total sales $'s and how many units you are selling in such a scenario. Additionally, there is a chart to show cost per unit and profit per unit.
My favorite way to drive a suggested selling price is to take all your costs per unit and then determine a given profit % target. As you change the profit % targets, your selling price will adjust. You would then test various margins to see what resulting sale price looks the most reasonable. Or, if you have a target margin you want to hit, the model auto-calculates the selling price per unit to do so.