Add-On Dashboard

The Add-On Dashboard was specifically requested and paid for by Phoenix. Data is taken from the current day's jobs and is automatically refreshed every minute.

The column definitions are as follows.

Jobs per Route	Formula (Boked Jobs/ Routes)	Add -on Goal %	We add	MTD Add-on	Technician Close out Report MTD - Add-on Revenue Percent - Zerorez - Phoenix Total	MTD Job Avg	Technician Close out Report MTD - Job Average - Zerorez - Phoenix Total	Job Average	Technician Close out Report - Job Average - Zerorez - Phoenix Total	(“Booked Revenue” + “Add On Amount”) * commission %
Routes	Booked Rev	Booked Jobs	Add-on Goal	Add-on Amount	Add-on to Goal	Add-on %	Jobs Closed	Total Revenue	17% Commission	Estimated Commission
Formula? Count how many route names and minus Notes.	Booked Revenue Report - Booked Revenue - Zerorez - Phoenix Total	Booked Revenue Report - Number of Bookings - Zerorez -Phoenix Total	Formula - (Booked Revenue / (100-Add-on goal Percentage) x Add-on goal Percentage (See Report example )	Technician Close out Report - Add on Revenue - Zerorez - Pohenix Total	Formula with Conditional Highlighting - Add-on Amount minus Add-on Goal	Technician Close Out Report - Add-on Revenue Percent	Technician Close out Report - Number of Jobs	Technician Close out Report - Total Revenue	Formula - Total Revenue times .17	(“Booked Revenue” + “Add On Amount”) * commission %. These values all come from this report
Booked Revenue Report - Primary Technician	Booked Revenue Report - Booked Revenue	Booked Revenue Report - Number of Bookings	Formula - (Booked Revenue / (100-Add-on goal Percentage) x Add-on goal percentage (See Report example)	Technician Close out Report - Add on Revenue.	Formula with Conditional Highlighting - Add-on Amount minus Add-on Goal	Technician Close out Report - Add-on Revenue Percent. Zerorez - Phoenix Total	Technician Close out Report - Number of Jobs	Technician Close out Report - Total Revenue	Formula - Total Revenue times .17

Note: Some formulas may be different than what is currently used in Jasper reports. Therefore, when comparing data from this report with reports run from the "Reporting" tab in zr ware™, a direct comparison is not always possible, even for columns with the same name.

Add-on Goal% and Commission %. These percentages can be adjusted and the rest of the report will adjust accordingly.
Right-clicking on a row will remove it from the report and its numbers will be excluded from the report. The page must be refreshed to include the row again.
You have the option to choose what date data shows up for.

Additional Information:

This is being tracked on GMT time which may lead to some bases seeing the data disappear in the evenings.