My Math Forum Sales conversion linked to sales enquiries and orders

 Elementary Math Fractions, Percentages, Word Problems, Equations, Inequations, Factorization, Expansion

July 3rd, 2013, 08:28 AM   #1
Newbie

Joined: Jul 2013

Posts: 1
Thanks: 0

Sales conversion linked to sales enquiries and orders

Hello,

I am not a maths genius so I'll try to explain it as clearly as I can.

I am trying to find a graph which I can use to demonstrate the relation between three variables the fourth value is month:

- Number of sales enquiries
- enquiry/sales conversion
- order processing

It is easy to see the relationship if I look at two variables e.g. enquiries / (enquiry/sales conversion) or enquiries / order processing but what I need is to generate a visual presentation that shows me the relation between the three and ideally at what stage I reach the optimum enquiry/sales conversion.

I have attached an excel work sheet with the data that I am looking at and I am trying to find out what the combination enquiries and orders has on the conversion rate.

The obvious conclusion is that if a sales person spends a lot of time executing orders he will have less time on converting enquiries, however if there are only a few enquiries to deal with at the time when he is busy executing orders then he can still have a high conversion percentage.

On the other hand if he has few orders but lots of enquiries to deal with, then he can also have a low conversion...

Not every enquiry will convert into a sales so although I would like a higher conversion I assume that 25% of the enquiries are 'convertable' and that the remaining 75% would never convert to a sales no matter what we do.

So how, in graphical form, can I see what combination between enquiries and orders will give me the best enquiry / sales conversion or in other words, what impact has a busy order month with lots of enquiries have on my conversion figure?

I have been struggling with this and look forward to receiving some suggestions (in plain English please as I am not a maths genius.)

Thanks!

Rogier
Attached Files
 Book1.xls (25.0 KB, 22 views)

 July 3rd, 2013, 08:55 AM #2 Math Team   Joined: Oct 2011 From: Ottawa Ontario, Canada Posts: 14,597 Thanks: 1039 Re: Sales conversion linked to sales enquiries and orders

 Tags conversion, enquiries, linked, orders, sales

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post spitzke Algebra 5 March 26th, 2014 11:20 AM Spook Advanced Statistics 1 September 13th, 2012 04:55 AM tomb Economics 5 November 16th, 2011 10:06 AM Dld3 Economics 3 November 2nd, 2011 11:17 AM spitzke Calculus 0 December 31st, 1969 04:00 PM

 Contact - Home - Forums - Cryptocurrency Forum - Top