I am required to have a employment team meet a yearly percentage rate of 50% for a process. The team is currently short of the goal with a rate of 43%. My boss wants to know what percentage is needed each month to meet the rate at the end of the year. Is there a way I can get the percentage needed if I don't know what my future numerators or denominators are going to be?
cases complete total cases monthly % complete Total % complete JAN 20 40 50% 50% FEB 10 30 33% 43% MAR 40 50 80% 58% APR 20 60 30% 50% MAY 20 80 25% 43%
I need to make sure the team is above 50% after December. I have 7 more months to reach my required rate. Is it even possible to calculate a target % rate to show me what rate is needed each month to reach 50% at the end of the year? My boss insists that there is a way. I explained that we are currently 50 cases short of meeting our goal and that we need to make up the 50 cases by the end of the year and also meet the 50% goal each month to make 5o% at the end of the year. She was not satisfied with that response. She wants a percentage. Please help.