I am still struggling to create a simulation I was wondering if anyone could point me in the right direction please?
I have a list of staff and their voluntary redundant salaries and compulsory redundant salaries
I have the figure of the number of job losses
I am predicting that 60% of job losses will be staff taking voluntary redundancy and the other 40% of job losses will be compulsory redundancies
Therefore I want to run 1000 trials of choosing these 60% and 40% to see the distribution of the total cost of redundancies.
Any ideas of how i can do this in excel?