Simulation tab

I have tried by creating metrics (company, curency, fix, variable) but it does not work

Hi Alix,

Hope you’re doing well!

Keen to help you with this problem but I have a few questions:

1. Is the formula for ‘Total Gross (EUR)’: (Fixed + Variable)*FX Rate ?
2. If so, have you created an FX conversion metric?
3. How does ‘Company’ affect the calculations? Or does it not?

Thanks,

Hello, thanks!! 

1. Total gross : (fix + var)* FX rate where fixe is an amount multiplied by a coefficient of sociale charges (coming from metric “Assumptions: Tax Rate”).
2. No as for exiting costs i do it directly in the transaction list of salary packages
3. it affects in order to have the coefficient of sociale charges linked

Thanks!

Hi Alix,

Thanks for your prompt responses to my questions.

So, if my understanding is correct, for your simulation table you need 3 input metrics:

1. Company Input

2. Fixed Cost Input

3. Source Currency Input

You also need 2 assumption metrics (one of which I believe you already have):

1. Tax Input % (this is the one you’ve already got, and it is dimensioned by Company)

2. FX Conversion (this will be a number type metric dimensioned by the Currency dimension list, and will be the XXX -> EUR conversion rate. So for EUR, it would be 1)

You will then need to create 2 calculation metrics:

1. Variable Cost (multiply the Fixed Cost by the Tax Input %, referencing the Company Input)

2. Total Gross (Add the Variable Cost by the Fixed Cost, then multiply the whole thing by the FX Conversion, referencing the Source Currency Input)

Hope this helps! Let me know if you get stuck :)

Cheers,

Thanks! I’ll try that :) 

Hello, 

I have created:

• company, fix, variable, currency input metrics
• taxes and currency assumption metrics (by using remove last non blank)

I could not achieve to compute the total cost. How can I refere to the company input (to get the tax) and the currency input, in my formula?

I’v tried by a select but it does not work:

Thanks a lot!! I’ll try