Sales Budgets - Set Targets to Achieve your goals

Watch this short video overview

 

Set SMART Targets to Motivate and Change Behaviours

How you define your Sales Targets is critical to your organisation as it will be a key factor to motivate and drive your sales team.  Key Objectives should also be SMART:

  • S - Specific
  • M - Measurable
  • A - Assignable
  • R - Relevant
  • T - Time based

Using BI4Cloud - Business Intelligence Cool Stuff (Enterprise 5) version, all businesses no matter how small, can now set flexible Monthly sales budgets and easily measure against them, based on all or any of the following key business drivers. Note each Organisation can choose what dimensions/levels to set their Sales Budgets at:

  • Who is Selling - Salesperson/Territory
  • Who is Buying - Customer/Customer Group/Channel
  • What is Sold - Item/Item Group/Brand

How to Setup and Enter Sales Budgets in BI4Cloud - Click Here.
How to start creating Sales Budget Favourite reports in BI4Cloud - Click Here.
Get help from a BI Expert to setup Budgets in BI - Book a BI Consulting Appointment

Before you get too deep into setting up your Budgets you should determine exactly what level of detail you wish to track in your Budgets. Please take a look at the following report examples to see the many ways you can report and measure Actual Sales results against Budgeted Sales.  

This example has been set up to budget all three of the above dimensions. 

  • Salesperson
    • Brand- e.g. 3M, Kreepy Krawley, Onga
      • Customer Group - e.g. Agent, Hotels Residential

Dashboards

A Dashboard showing overall performance then broken down by each Salesperson or Customer Sales Rep.

SB09 - Dashboard.png

Simply add a Filter for a Salesperson or Customer Sales Rep to each Widget Element to customise.  Customer Sales Rep v Salesperson - What is the difference?

Salesperson Dashboard

Run the Salesperson Dashboard, initially it will include data for ALL Sales reps. Simply add a Filter for one Salesperson and the whole Dashboard will show data just for that one person. 

SB 11 - salesrep dashboard.png

Build your own Dashboards by adding Widgets, reports and charts together. 

Analyse Type Reports - Simple List

Analyse by Customer Sales Rep or Salesperson - Actual v Budget

SB 01 - YTD by Rep.png

Analyse by Customer Group - Actual v Budget 

Change the Analyse by field e.g. Customer Group to change the dimension used in the rows. 

SB 02 - by Cust Group.png

 Analyse by Item Group - Actual v Budget 

Change the Analyse by field e.g. Brand or Item Group to change the dimension used in the rows. 

SB 03 - by Brand.png

Pivot - To see Multiple Dimensions at Once

To learn how to setup and change Pivot reports - Click Here

Pivot Reports are a great way to break out YTD data into Months to see trends.

Monthly by Customer Rep - Showing Metrics in Row

This report Analyses by Customer Rep in the Rows and Pivots on Invoice date by Month across the columns. It also shows the Metrics (Sales/Budget/Variance/Achieve %) on separate rows. This keeps the number of columns to a minimum.

SB 04 - mthly by rep.png

Monthly by Customer Rep V2- Showing Metrics in Columns

This report flips the dimensions and instead Analyses by Invoice date by Month in the Rows and Pivots on Customer Rep across the columns. It also shows the Metrics (Sales/Budget/Variance/Achieve %) as columns. This results in more columns but is a great design to review data and variances up and down a column. 

SB 05 - mthly by rep V2.png

Brand by Customer Rep V2- Showing Metrics in Columns

Use the prebuilt reports, copy the tab and create your own reports.

Pivot Brand v Customer Rep to compare Salesperson performance across Brands

SB 07 brand v rep.png

Quarterly Sales Actual V Budget

Pivot Customer Group v Sales by Quarter to compare Sales performance across Quarters showing Metrics in columns.

SB 06 - cust v qtr.png

 

 

Visualise - To Really See the Results!

 Sales v Budget Chart

SB 08 SvB Chart.png

 

www.BI4Cloud.com 

 

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more
Ask the BI4 Community
Need help using this report or feature?