Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Clarity around break even numbers #477

Closed
iteles opened this issue Jun 12, 2018 · 3 comments
Closed

Clarity around break even numbers #477

iteles opened this issue Jun 12, 2018 · 3 comments
Assignees
Labels
finance please-test Please test the feature in Staging Environment and confirm it's working as expected. priority-1 Highest priority issue. This is costing us money every minute that passes. T1h Time Estimate 1 Hour

Comments

@iteles
Copy link
Member

iteles commented Jun 12, 2018

Following on from making a good dent into our end of year accounts #406 (yay @rub1e! And it's not even the month before the deadline or anything!) and linked to #321

With a hybrid PAYE employee/freelancer model, there is a little less clarity around how much the true cost of each person in the organisation is and how much we have to make sure we cover with our contributions to overheads in order to have a good runway here.

@rub1e Could we please calculate the following so that when we are selling work we can ensure at a glance that we are not selling ourselves short?

  • Actual cost per day per PAYE employee (including all the things we need to pay the government on a monthly basis, pensions and apportioned holiday allowance)
  • Required contribution to overhead per day to support salaries (i.e. Ops and sales salaries)
    • We will need a separate column for contribution to overheads overall (i.e. including everything from rent to coffee to team activities), but we need further clarity on costs which will come once FY17/18 Year End Accounts #406 is complete before we get this
  • Required contribution to overheads per if there is a 90% utilisation rate (i.e. if 10% of the time people are working on internal dwyl products or are between projects)
  • Required contribution to overheads per if there is a 80% utilisation rate
  • Opportunity cost to not working on client projects (I can fill in this column).
@iteles iteles added priority-1 Highest priority issue. This is costing us money every minute that passes. finance labels Jun 12, 2018
@rub1e rub1e added in-progress An issue or pull request that is being worked on by the assigned person T1h Time Estimate 1 Hour and removed in-progress An issue or pull request that is being worked on by the assigned person labels Jun 13, 2018
@rub1e rub1e assigned iteles and unassigned rub1e Jun 19, 2018
@rub1e rub1e added the please-test Please test the feature in Staging Environment and confirm it's working as expected. label Jun 19, 2018
@iteles
Copy link
Member Author

iteles commented Jun 19, 2018

@rub1e You're a gem 💎
So nice to finally have some clarity around this kind of number #321.

Let's walk through them tomorrow and then we can close?

@rub1e
Copy link
Member

rub1e commented Jun 20, 2018

First thing to note is that employees cost a lot more than their headline pay figure, when pensions and taxes are included - c.10% more.

So, someone on e.g. £3k/month costs the company closer to £3.5k/month - and this needs to be factored in when doing this calculation (fortunately Xero calculates employees' total cost for us 😁)

So the calculation here would be:

  • Take employee's total monthly cost
  • Divide by total working days (228) & multiply by 12 to get daily cost
  • Do the same for salaries of Ops & Sales staff
  • Divide daily overheads cost by number of regular employees
  • Add this to each employee cost to get the desired break-even figure

This is the basic process; it doesn't include stuff like training costs or boxes of green tea etc etc

@iteles
Copy link
Member Author

iteles commented Jun 20, 2018

SO SO happy to finally have this. You're a peach @rub1e 🎉

Also, 😆 at the 🍵

@iteles iteles closed this as completed Jun 20, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
finance please-test Please test the feature in Staging Environment and confirm it's working as expected. priority-1 Highest priority issue. This is costing us money every minute that passes. T1h Time Estimate 1 Hour
Projects
None yet
Development

No branches or pull requests

2 participants