Hello Everyone,

I am trying to solve a simulation problem,which is quite difficult for me. It requires some statistics knowledge combined with excel functions.

I have attached a sample of the problem and the problem is like this.
We have 6 days,where we need to do repairs on computers for example.Maximum repairs per day are 6(they are generated randomly for each day) Each repair has a different status: small,medium,and huge(the type of repairs is also chosen randomly). Different number of employees are required to do the repairs: 3 for small,5 for medium and 7 for huge.The question is how many people do we need each day. However, there are two conditions(the ones,which I cannot figure out):
1)In 50% of all cases,where employees are doing a small repair,they can do another small or a medium repair at the same day
2)In 30% of all cases,where employees are doing a medium repair,they can do one small as well at the same day

If someone knows or has an idea how this can be solved,I will very grateful.
Thank you all for reading this.
Sample.xlsx