Forecasting

Is supported several ways

  • Sales based upon invoiced dollars
  • Receivables based upon actual monies deposited in the bank
  • Re-ocurriing billing e.g. units
  • Re-ocurring standing order, customer has agreed to pay for service


Each of these alternatives has a report that can be printed for use in analysis and actual generation of a forecast.


These results need o be reviewed and given detail of cause like Sales are up becasue

  • New large developmemts
  • Sales program of advertising
  • Local competitors left market
  • etc. 


Sales based upon invoiced dollars

Steps to print this report is as follows:

  1. This reporty can be printed by going to the main menu option \ Reports \ Financial \  Sales tab  \
  2. Enter invoice date for 3 years 1/1/2013 to 12/31/2016. Typically more then three years is un reliable
  3. Click search
  4. Select report from menu 30 - year and month sales
Inspect the summary boxes at the end of the report for 
  • Month to date % sales
  • Year to date % sales
  • End of year % at far right column

Receivables based upon actual monies deposited in the bank
Cash in the bank tends to be given greater weight in that it can be verified by bank deposits.  This cash analysis report is the same format as the sales analysis report above.  The steps are similier.

Steps to print this report is as follows:

 

  1. This reporty can be printed by going to the main menu option \ Reports \ Financial \  Receivables tab  \
  2. Enter Post date for 3 years 1/1/2013 to 12/31/2016. Typically more then three years is un reliable
  3. Click search
  4. Select report from menu 32 - year and month receivables
Inspect the summary boxes at the end of the report for 

 

  • Month to date % sales
  • Year to date % sales
  • End of year % at far right column

Re-ocurriing billing e.g. units
Re-ocurring billing is generated automatically from several sources. 
  • Units assigned to a service location e.g. tank retnal, Service contracts, Portable toliets , etc
  • Re-ocurring work orders that are converted to invoiced line items
  • Re-occuring  events manged through the sales group which are manually entered
The "Rate analysis report" breack down monthly billing by type of unit and service internal and prints low, high, avarage and total for each one.  In addition at the end of the report and summary chart is printed across all unit types .

Steps to print this report is as follows:

 

  1. This reporty can be printed by going to the main menu option \ Reports \ Inventory \  Units  tab  \
  2. The default is assigned units, just click search
  3. Select report from menu 10 - Rental rate analysis

Re-ocurring standing order, customer has agreed to pay for service
Standing orders can be used as reminders for followup and to generate work to be completed. To use stadning ordes as a forecasting tool, these need to be entered as work to be completed that the customer as agreed to pay for. Business like grease, commercial septic, Medical waste, Yellow oil use stadning orders in that the intervals to service a location differs for each location.  The standing order allows any number of days, weeks or months before an work order is geneated.

Since the actual revenue can be different depending upon work completed this is the most qualitative tool. it requires view and analysis to get a "reasonable" results.

Steps to print these reports are as follows:

 

  1. These reports can be printed by going to the main menu option \ Reports \ Dispatch \  Standing orders4  tab  \
  2. Click seach to get all standing orders. Once these are viewed, yo can go back and select the seach options to limit the report range to specific date and or services
  3. Select report from menu 22 - Rate code analysis as a stating point.  
  4. Once you can set the seach for a specific forecast group we recommend you print each report to find the one that best fits your needs
  5. All reports can be exported to Excel for further analysis and expanded forecasting