I do not need trand lines as this does not suits my requirements. I have the following query
I am using Excel 2007.
I have a table wherein I have
1. Customer names in coumun EB7 till EB101.
2. Heading EB3 is "Customer Name".
3. Row ED3 till EO3 is the name of months viz: April, May, June......till March.
4. Cell EP3 is heading "Total".
5. Sales billed to each customer is fiiled in table range ED7 till EO101
6. Total sales made by the customer is calculated in clumn EP7 till EP101.
7. Total sales of each months is calculated in row ED102 till EO102.
Now each sustome buys as per their requirements, but seem to be having a pattern. Some buy every month, some alternate month, some once in a three months etc. Pattern varies from customer to customer.
Based on the pattern and their usual off-take I need to know
A) The likelyhood of a customer buying or not buying in next month.
B) Value a customer is likely to buy.
A) If I can know this then we can depute our sales person or call our customer well in advance before they plan to go to other store / supplier. (Also save our sales staff's effort, time and money by avoiding the vsits to the customer who are not likely to buy that month)
B) Plan our inventory acordingly so that as and when the customer places the order we are able to supply them in time.
Trendline does not works propelry as:
1. I have to make chart for each and every customer.
2. Have to make it every month.
3. Does not provides me with the value a customer is likely to buy.
Can you help me with some way wherein I can get a figure of 0 if customer is not likely to buy and with a value if the customer is likely to buy in cells in some column against each customer name. Say in row EC???
Pleas help.
With regards,
Rizvi.M.H.
<!-- / message -->
I am using Excel 2007.
I have a table wherein I have
1. Customer names in coumun EB7 till EB101.
2. Heading EB3 is "Customer Name".
3. Row ED3 till EO3 is the name of months viz: April, May, June......till March.
4. Cell EP3 is heading "Total".
5. Sales billed to each customer is fiiled in table range ED7 till EO101
6. Total sales made by the customer is calculated in clumn EP7 till EP101.
7. Total sales of each months is calculated in row ED102 till EO102.
Now each sustome buys as per their requirements, but seem to be having a pattern. Some buy every month, some alternate month, some once in a three months etc. Pattern varies from customer to customer.
Based on the pattern and their usual off-take I need to know
A) The likelyhood of a customer buying or not buying in next month.
B) Value a customer is likely to buy.
A) If I can know this then we can depute our sales person or call our customer well in advance before they plan to go to other store / supplier. (Also save our sales staff's effort, time and money by avoiding the vsits to the customer who are not likely to buy that month)
B) Plan our inventory acordingly so that as and when the customer places the order we are able to supply them in time.
Trendline does not works propelry as:
1. I have to make chart for each and every customer.
2. Have to make it every month.
3. Does not provides me with the value a customer is likely to buy.
Can you help me with some way wherein I can get a figure of 0 if customer is not likely to buy and with a value if the customer is likely to buy in cells in some column against each customer name. Say in row EC???
Pleas help.
With regards,
Rizvi.M.H.
<!-- / message -->
