How to calculate number required at a certain percentage to achieve target goal

[ilagas]

Hi Good day to everyone.
I need help in getting a formula of this problem. How can we solve for no of task required completed at a certain timeframe for the employees to pass at 100% to goal(lower is better). Im familiar but im not really good at algebra so now Im having a hard time solving this problem

Variables are
1.) No of tasks
2.) % to goal of the time employee took to complete the total no of task
3.) Goal at 100%
4.) No of tasks needed at at a certain timeframe in percentage(ex 90% of the time required) for the employee to finish

For example.
Employee 1 has 139% to goal at 20 tasks and his target goal is 100%(Lower the better). How many tasks does he needs to complete at 90% timeframe to reach 100%. I cant seem to find a solution online.

 

[StephenCrump]

Welcome to the Forum!

There's a similar question here: Compute Surveys Needed to Meet the Target

Using that basis, I get 80 extra tasks to bring the score just within (i.e. below) the 100% requirement.

BUT: This will work only if you are giving equal weight to each task's %. If you want to weight by length of task (?) we'll need a different formula.

Simple example: Is your average 109% or 150%?

	A	B	C	D
1	Task	Target hrs	Actual hrs	Percentage
2	A	1	2	200%
3	B	10	10	100%
4		11	12	109%
Sheet7

Cell Formulas
Range	Formula
D2:D4	D2	=C2/B2
B4:C4	B4	=SUM(B2:B3)

 

[joeu2004]

Also see How to calculate number of task required at a certain percentage to achieve target goal