If you have the 'near miss analysis' solution, you can use the Rebates analysis database in Phocas to view performance against targets in your Rebates agreements, seeing which rebate brackets have been reached, or how far away a higher level of rebate is.
This can help target your spend more effectively or, if you pay rebates, enable you to target customer purchasing to maximise benefits.
Enable near miss at project level
Even if you have the 'near miss' solution you still need to enable it for each project where near miss will be used.
Run a calculation with near miss enabled
To include near miss information in a calculation, select Calculate box and choose 'Yes' under Near Miss Analysis.
Schedule a calculation with near miss enabled
When scheduling a calculation, there is an option to include Near Miss Analysis, as shown below. In addition to this, select Update Phocas Databases after calculation and select the 'Rebates Near Miss Analysis' database.
Near miss results are calculated at the same time as scheduled or manual calculations. You do not need to post the data for near miss to be updated.
The calculation covers:
- Which bracket the recipient is currently in
- The corresponding rebate amount (what rebate will I get if I stop spending now?)
- How far within the bracket am I (%)?
- How much more do I need to spend to reach the next bracket?
- How much my rebate will be if I hit the next bracket?
The near miss dashboard in Phocas
If you have the 'near miss analysis' solution, your Rebates near miss analysis dashboard may look something like the main image below, although customized for your needs. On the dashboard you can see an overview of your rebates and which rebates are approaching the next bracket.
For example, if you pay rebates you can quickly identify the agreements where the rebate amount is potentially bigger than the spend. In the example below, the 'surplus' column shpws the difference between the spend required to get to the next bracket and the extra rebate received once you hit that bracket (in this case, the difference is close to $470).
Analyze in more detail
To analyze your Rebates near miss performance in more detail, click the code on a line to view the actual rebate details in Phocas Rebates.
For example, clicking the link highlighted below for 'Group A Rebates - (300197) opens the rebate screen for that particular rebate in Phocas Rebates ('Image 2' at bottom).
Image 1: Click the link from the dashboard to open in Rebates.
Image 2: The rebate in detail in Phocas Rebates.