Get Adobe Flash player

Home Services About FAQS

Follow Us!

Get Adobe Flash player

Follow numericalinsigh on Twitter

 
FINDING THE DRIVING FORCE BEHIND SALES

This example is dedicated to the dilemma of where to invest the company money... in more sales personnel or advertising? 

What is the driving force behind the company's sales numbers?

Background: My client, Company ABC sells medical equipment throughout the country. They have collected data on the company sales, the amount spent on advertising in each region and the sales bonus paid out to each region. They are interested in knowing whether there is a correlation between sales, advertising and regional bonus payouts.

Analysis:  A sample of data from 25 regions was used to produce a mathematical estimate of sales. The  regression analysis produces the following equation: SALES = -516 + 2.47 ADV + 1.86 BONUS. Both advertising (ADV) and bonus payout (BONUS) are found to be significant in the prediction.

What does this mean in plain English? This equation can now provide the company with an estimate of expected sales for a given level of advertising and bonus payouts. Moreover, if the advertising investment is held constant, the sales trend tends to rise $1160 for each bonus dollar paid out. Similarly, if the bonus payout is held constant, the sales tends to rise $2470 for every extra dollar spent on advertising. Both advertising and bonus payouts will drive sales, but advertising appears to have a greater ROI if extra funds are available.

 

Company Information

Location: Germantown, Collierville, Memphis, TN.

Fee Structure : $125/hour plus expenses.

Email:
tsmith@numericalinsights.com

Services

  • Data analysis / statistical analysis.
  • Profitability analysis at the product or customer level.
  • Inventory performance analysis.
  • Online surveys and survey analysis.
  • Business courses from simple business math to advanced numerical methods.
  • Linear & non-linear forecasting.
  • Seasonal & time series forecasting.
  • Graphical Analysis.
  • Predictive modeling.
  • Development and analysis of company metrics.
 

Copyright 2008-2010 NumericalInsights.com. All Rights Reserved