I was wodnering if anyone could kindly help please. I may go on a little bit but please bare with me. I am stuck on how to calculate this particular scenario.
A company charges its clients various different prices depending on the amount of sales per month as follows:
£0-300 sales / £30.00 fees per month
£301-600 sales / £60.00 fees per month
£601-1000 sales / £90.00 fees per month
£1001-2000 sales / £180.00 fees per month
£2001-3000 sales / £250.00 fees per month
£3001-5000 sales / £300.00 fees per month
£5001-7000 sales / £400.00 fees per month
£7001-10,000 sales / £500.00 fees per month
The company has a one off cost £300 per client to set up its clients.
the company has 15 clients and they all get charged different fees per month as they do not have the same sales figures per month.
My question is what would be the best way to have a formula where I can see the breakeven point for the company. As the company would only ever have a one off cost of £300 per client but have various sales revenue figures, I am finding it hard to think of how to do this.
I would very much appreciate it if someone could guide me to a formula. Thank you in advance 🙂