Sales Targets and Commission

[Fiyae]

Hi Everyone,

I am looking for advise on how to analysis sales targets and commission on daily bases. The table below is the one I had for a month but I would like to do break down on daily bases to track activity of my team on daily and weekly bases as well grant compensation.

	Driver 1	Driver 2	Driver 3	Driver 4
Delivery
Target	65	54	96	66
Actual	31	55	94	68
% of Goal	48%	102%	98%	103%
Variance	34	MET	2	MET

<colgroup><col span="5"></colgroup><tbody>
</tbody>

 

[oldbrewer]

date	driver	target	actual	percent				col I
01/10/2015	D1	56	50	89.3
01/10/2015	D2	65	53	81.5
02/10/2015	D1	59	56	94.9
02/10/2015	D2	69	59	85.5
03/10/2015	D1	62	62	100.0
03/10/2015	D2	73	65	89.0						D1	D2
04/10/2015	D1	65	68	104.6				01/10/2015	07/10/2015	104.62	92.21
04/10/2015	D2	77	71	92.2				08/10/2015	14/10/2015	108.31	93.88
05/10/2015	D1	68	74	108.8				15/10/2015	21/10/2015	116.27	93.38
05/10/2015	D2	81	77	95.1				22/10/2015	28/10/2015	#DIV/0!	#DIV/0!
06/10/2015	D1	71	80	112.7
06/10/2015	D2	85	83	97.6
07/10/2015	D1	74	86	116.2
07/10/2015	D2	89	89	100.0
08/10/2015	D1	77	92	119.5
08/10/2015	D2	93	95	102.2				formula giving 104.62 for D1
09/10/2015	D1	80	98	122.5
09/10/2015	D2	97	101	104.1				=100*SUMPRODUCT(($A$2:$A$41>=$I8)*($A$2:$A$41<=$J8)*($D$2:$D$41)*($B$2:$B$41=K$7))/SUMPRODUCT(($A$2:$A$41>=$I8)*($A$2:$A$41<=$J8)*($C$2:$C$41)*($B$2:$B$41=K$7))
10/10/2015	D1	83	77	92.8
10/10/2015	D2	101	80	79.2
11/10/2015	D1	86	83	96.5
11/10/2015	D2	105	86	81.9
12/10/2015	D1	89	89	100.0
12/10/2015	D2	109	92	84.4
13/10/2015	D1	92	95	103.3
13/10/2015	D2	113	115	101.8
14/10/2015	D1	95	118	124.2
14/10/2015	D2	117	121	103.4
15/10/2015	D1	98	124	126.5
15/10/2015	D2	121	127	105.0
16/10/2015	D1	101	130	128.7
16/10/2015	D2	125	133	106.4
17/10/2015	D1	104	136	130.8
17/10/2015	D2	129	119	92.2
18/10/2015	D1	107	122	114.0
18/10/2015	D2	133	125	94.0
19/10/2015	D1	110	109	99.1
19/10/2015	D2	137	112	81.8
20/10/2015	D1	113	115	101.8
20/10/2015	D2	141	118	83.7				row 41

<colgroup><col><col><col><col><col><col><col><col><col span="2"><col span="16"></colgroup><tbody>
</tbody>