My client is a children's charity that provides entertainment (or experiences) for sick children in 10 different hospitals. I have the following business problem that am unsure how to go about it:
Problem: How many staffing hours (resources) to allocate at each hospital based on the number of experiences to children. We want to increase the amount of staffing hours only if it results in a significant increase in experiences to children. So for example if we were to increase hours by 20% then ideally we would like the number of experiences to increase by the same amount, if not more. Therefore, we need to work out the optimal hours that maximises the experiences.
My initial idea is that we look at say the past 2 years, for each day we know the number of staffing hours and the number of experiences. We can work out the relationship between those two variables, with a GLM, and see if the number of experiences plateau's after a certain number of staffing hours. The other big dependant variable here is the number of hospital admissions because we know that higher admissions means more experiences provided to children. Unfortunley we don't have that info for each day, but only as an annual figure, so unsure how we account for this.
I just want to know if there are other ways to go about this or if I'm on the right track?
Problem: How many staffing hours (resources) to allocate at each hospital based on the number of experiences to children. We want to increase the amount of staffing hours only if it results in a significant increase in experiences to children. So for example if we were to increase hours by 20% then ideally we would like the number of experiences to increase by the same amount, if not more. Therefore, we need to work out the optimal hours that maximises the experiences.
My initial idea is that we look at say the past 2 years, for each day we know the number of staffing hours and the number of experiences. We can work out the relationship between those two variables, with a GLM, and see if the number of experiences plateau's after a certain number of staffing hours. The other big dependant variable here is the number of hospital admissions because we know that higher admissions means more experiences provided to children. Unfortunley we don't have that info for each day, but only as an annual figure, so unsure how we account for this.
I just want to know if there are other ways to go about this or if I'm on the right track?
