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.
[TABLE="width: 400"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD] [/TD]
[TD]Driver 1[/TD]
[TD]Driver 2[/TD]
[TD]Driver 3[/TD]
[TD]Driver 4[/TD]
[/TR]
[TR]
[TD]Delivery [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Target[/TD]
[TD]65[/TD]
[TD]54[/TD]
[TD]96[/TD]
[TD]66[/TD]
[/TR]
[TR]
[TD]Actual[/TD]
[TD]31[/TD]
[TD]55[/TD]
[TD]94[/TD]
[TD]68[/TD]
[/TR]
[TR]
[TD]% of Goal [/TD]
[TD]48%[/TD]
[TD]102%[/TD]
[TD]98%[/TD]
[TD]103%[/TD]
[/TR]
[TR]
[TD]Variance[/TD]
[TD]34[/TD]
[TD]MET[/TD]
[TD]2[/TD]
[TD]MET[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 400"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD] [/TD]
[TD]Driver 1[/TD]
[TD]Driver 2[/TD]
[TD]Driver 3[/TD]
[TD]Driver 4[/TD]
[/TR]
[TR]
[TD]Delivery [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Target[/TD]
[TD]65[/TD]
[TD]54[/TD]
[TD]96[/TD]
[TD]66[/TD]
[/TR]
[TR]
[TD]Actual[/TD]
[TD]31[/TD]
[TD]55[/TD]
[TD]94[/TD]
[TD]68[/TD]
[/TR]
[TR]
[TD]% of Goal [/TD]
[TD]48%[/TD]
[TD]102%[/TD]
[TD]98%[/TD]
[TD]103%[/TD]
[/TR]
[TR]
[TD]Variance[/TD]
[TD]34[/TD]
[TD]MET[/TD]
[TD]2[/TD]
[TD]MET[/TD]
[/TR]
</tbody>[/TABLE]