![]() Variances can be negative or positive but for our chart we need a positive value in all the cases therefore we have wrapped the difference of two values in ABS function (absolute) to give us the positive value in all the cases. Target figures and actual figures are provided by us where as Variance figure gets calculated on its own as we have a formula in that case which as follows: All figures are expressed in percentages. ![]() With the same idea in mind we have the data of sales target and actual sales achieved so far in terms of target with variance. Sales manager mostly set benchmarks to track the progress. Usually sales department settle targets for the month and at certain of the week monitor the achievements. ![]() For the purpose of following tutorial and to best apply the technique discussed download this excel workbookand follow the steps mentioned below ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |