
08-09-2005, 01:44 PM
|  | Senior Member | | Join Date: Sep 2005 Location: Kuwait
Posts: 134
| | 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
__________________
If you want to Soar with Eagles, do not fly with Turkeys
| 
05-11-2005, 11:29 AM
|  | Junior Member | | Join Date: Sep 2005 Location: Delhi
Posts: 5
| | 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  | 
04-06-2008, 11:48 AM
|  | Guest | | | | Hi,
Can u send me the file on  | 
04-07-2008, 12:41 PM
|  | Junior Member | | Join Date: Feb 2008 Location: mumbai
Posts: 1
| | hi nabeel plz send me mail as i am not unable to open the url
Regards
Kavita | 
05-07-2008, 11:36 AM
|  | Junior Member | | Join Date: Jan 2008 Location: Lahore, Pakistan
Posts: 6
| | dear please send me the formates on this address  | 
08-07-2008, 02:56 PM
|  | Junior Member | | Join Date: Jul 2008
Posts: 2
| | Hello Sir
Can u send me the excel file format to
thanx
prkumar | 
11-08-2008, 11:02 AM
|  | Junior Member | | Join Date: Aug 2008
Posts: 2
| | Hello Nabil,
I was not able to open ur link. please email to me at 
thanks | 
15-08-2008, 05:38 PM
|  | Junior Member | | Join Date: Jul 2007 Location: New Delhi
Posts: 3
| | Hi Nabeel kindly send the report to . Thanks for the same anywayz. Sachin | 
25-09-2008, 09:57 AM
|  | Guest | | | | PLEASE SEND ME THE FILEAS WELL ON
Thanks
Vignesh | 
30-09-2008, 03:45 PM
|  | Junior Member | | Join Date: Dec 2007 Location: mumbai
Posts: 1
| | Hi Pl mail the format to me on
Thanks & Regards,
Rita |
| |
| |