Hello All,
I am preparing a scorecard for 200 employees where the Resolve Per Hour (RPH) target changed from 2.5 to 3.5 in middle of month. I need the help on calculating Production Efficiency % and achieved RPH when employees are working on different Resolve Per Hour target.Resolves per hour.xlsx.
Excel Sheet attached for reference.
Please help me with this task.