nabeelw Full member - Member Since: Sep 2005 Subject - Tracking Sales on a Daily Basis Sales tracking on daily basis is very important to keep up with your sales targets and monitor the activities of your sales force as well as the market trend.
When you have an annual database of your previous sales track year by year you will be able to predict the motion of your market, thus you will be able to tell when your sales will boost and when it may go down, and why.
The most effective method to follow is an Excel file; create a table that states each (Product or Service) target, based on calculation of expenses, costs and targeted revenues.
Below that you will state your daily sales of those products or services, brought to that cell from another workbook. Underneath you will calculate the percentage achieved each day for each category.
To measure whether you are working up-to-day-to-day target calculate the days passed of the month over the number of days in the month. At the bottom of your table you may calculate percentage of Sales Achieved over percentage of days passed of the month.
The attached file is an excel workbook made specially to measure daily sales track of The Scientific Center in Kuwait, the first sheet specifies the achieved targets in the previous year, in addition to a comparison with the current year.
Going to the second sheet you will find a summary of the annual target of the current fiscal year Oct. 2004 – Sept. 2005, the information on this sheet comes collected from the following sheets of each month of the year.
Each month has a separate sheet that is fed from another workbook where sales are entered for every attraction at The Scientific Center.
The Graph Sheet reads the month-to-month sales motion (in visitors’ numbers) and feed it into a graph, showing each one of the attraction’s motion on monthly basis.
There is another sheet following this one where calculation of occupancy is made by hour, by attraction by day.
The last Graph is the Global Visitors’ motion month by month for The Scientific Center.
Now what we will benefit from reading those tables and graphs?
We will be able to monitor the activity of each attraction, stating which of the months are the lowest (i.e. in Kuwait during the fasting month of Ramadan; number of visitors go down).
We will be also able to state exactly when the drops have happened, and accordingly be simply referring to the marketing plan of the year will be able to state why that drop happened and what caused it.
This will be fed back to the Marketing Department to measure the effectiveness of their plans and accordingly rectify the cause.
Now you may read the attachment, you may also try to apply that for your own business… But remember that this was created by Nabeel S. Al Wazzan.
The File could not be attached you may find it here : http://www.geocities.com/nabeelw/tracking.xls
Thank you
Nabeel S. Al Wazzan
Marketing & Sales Consultants
A subsidiary of
Middle East Marketing Group Suraj Sharma - Member Since: Sep 2008 Subject - Re: Tracking Sales on a Daily Basis Please can u send me the format.
Suraj Sharma  rohit_4565 - Member Since: Jan 2009 Subject - Re: Tracking Sales on a Daily Basis Please send the same to me at  . Thanks in advance!!! shorifulis - Member Since: Nov 2008 Subject - sales tracking Please send me at 
thanks in advance. jang.sales - Member Since: Jul 2009 Subject - Re: Tracking Sales on a Daily Basis Hi Nabeel,
I would like to have a copy of the said file.. please send it on  . Thanks and more power to you.
Jang vipinvs - Member Since: Sep 2009 Subject - hi!! Hi,
I too could not download the file. Can you please send it to 
Thanks in advance.
Vipin Quote:
Originally Posted by nabeelw  Sales tracking on daily basis is very important to keep up with your sales targets and monitor the activities of your sales force as well as the market trend.
When you have an annual database of your previous sales track year by year you will be able to predict the motion of your market, thus you will be able to tell when your sales will boost and when it may go down, and why.
The most effective method to follow is an Excel file; create a table that states each (Product or Service) target, based on calculation of expenses, costs and targeted revenues.
Below that you will state your daily sales of those products or services, brought to that cell from another workbook. Underneath you will calculate the percentage achieved each day for each category.
To measure whether you are working up-to-day-to-day target calculate the days passed of the month over the number of days in the month. At the bottom of your table you may calculate percentage of Sales Achieved over percentage of days passed of the month.
The attached file is an excel workbook made specially to measure daily sales track of The Scientific Center in Kuwait, the first sheet specifies the achieved targets in the previous year, in addition to a comparison with the current year.
Going to the second sheet you will find a summary of the annual target of the current fiscal year Oct. 2004 – Sept. 2005, the information on this sheet comes collected from the following sheets of each month of the year.
Each month has a separate sheet that is fed from another workbook where sales are entered for every attraction at The Scientific Center.
The Graph Sheet reads the month-to-month sales motion (in visitors’ numbers) and feed it into a graph, showing each one of the attraction’s motion on monthly basis.
There is another sheet following this one where calculation of occupancy is made by hour, by attraction by day.
The last Graph is the Global Visitors’ motion month by month for The Scientific Center.
Now what we will benefit from reading those tables and graphs?
We will be able to monitor the activity of each attraction, stating which of the months are the lowest (i.e. in Kuwait during the fasting month of Ramadan; number of visitors go down).
We will be also able to state exactly when the drops have happened, and accordingly be simply referring to the marketing plan of the year will be able to state why that drop happened and what caused it.
This will be fed back to the Marketing Department to measure the effectiveness of their plans and accordingly rectify the cause.
Now you may read the attachment, you may also try to apply that for your own business… But remember that this was created by Nabeel S. Al Wazzan.
The File could not be attached you may find it here : http://www.geocities.com/nabeelw/tracking.xls
Thank you
Nabeel S. Al Wazzan
Marketing & Sales Consultants
A subsidiary of
Middle East Marketing Group | Rupendra Zala - Member Since: Oct 2009 Subject - Re: Tracking Sales on a Daily Basis I am not able to open the given URL
can u send me the excel format by mail on 
Thanks
Rupendra Rupendra Zala - Member Since: Oct 2009 Subject - Re: Tracking Sales on a Daily Basis I am not able to open the given URL
can u send me the excel format by mail on
Thanks
Rupendra avva - Member Since: Sep 2008 Subject - Re: Tracking Sales on a Daily Basis Cud you pls mail the format to:  Aquarian08 - Member Since: Nov 2009 Subject - Re: Tracking Sales on a Daily Basis Hi,
m new to this blog and unable to open the URL.
Can u pls send me the format @  ? placement673 - Member Since: Apr 2009 Subject - Re: Tracking Sales on a Daily Basis hi,
Greetings!!!,
kindly send the details to 
with regards,
govinda |
CiteSales is a community knowledgebase that let's you put your office or work related issues in front of a large group of peers and sales and marketing practitioners.
| |
