Hi there,
I am trying to do an IF function formula to say for each $20,000,000 of annualized revenue (i.e. $1,666,667 per month), we need to add variable staffing costs of $300,000 per year ($30,000 per month). So, for example, if we were doing $100,000,000 of annualized revenue, we would need $1,500,000 per year (or $120,000 per month) of variable staffing costs....
I need this calculation on a month to month basis (so, based on pro-rata sales figures) for a 12 month budget.
Can anyone help with the formula?
Thanks in advance,
Dean
Bookmarks