125) Performance Pattern to Create Goals

125) How to Use Performance Pattern to Create Target Goals

At the time of this writing this article, it is in October 2017.
Most of the Sales Related people will start to Set Goals for next year. They want to achieve their goals for next year.

If you have set a yearly Target and divided by 12 months, you will get a Monthly Sales Target. Let's say you have $12,000 sales target. Dividing by 12 months will give you $1,000 every month. If your monthly sales are not consistent, you will achieve the target for some months and have shortfall for other months. This up and down targets will affect your emotions badly.

If you have to prepare a Sales Target, you may want to use your Sales Performance Pattern as a guide to set a MORE REALISTIC goal.

Click the link below to know more about finding your Performance Pattern.
http://highlevelrules.blogspot.my/2017/10/recognize-your-performance-pattern.html
 
You can use your past Sales Performance Pattern and calculate the averages. 
The example is for Yearly Target based on 3 years records:

Step 1: Calculate the Monthly Average for the past years. 
Step 2: Get the yearly average amount.
Step 3: Calculate Monthly Percentages of total year average.
Step 4: Multiply Total Year Target by the Monthly Percentages to get monthly target.

Here's a sample screen of the calculation.

There are those of you who prefers to calculate based on 10 months instead of 12 months. Reason being you want to have "Spare months". Just in case there is any shortfall, you will have extra 2 months to work to catch up the amount.

I have prepared another table based on 10 months target. The Total amount and Average amount are based on January to October amounts only. Below is how it looks like.

You may go to this link below to download the template used to create the Monthly Sales Target based on Performance Graphs.

https://drive.google.com/open?id=1T-mUUcLmlaY4DQ9FceLL_1I4O5YZC_Eh