Route-EXCELerator

 

Product Detail Description

The “Overall Totals” Tab

How ROUTE-EXCELerator Works

The “Overall Totals” tab is the highest level view of your vending  business.  It has two sections, the overall route totals, and the business from a day of the month view. 

The Route-EXCELerator is able to track and manage up to eleven routes. So you see the route names listed on the left and the totals and averages moving to the right, starting with Total Units Sold, Total Number of Stops, Average Revenue per Stop, Total Revenue for the route and Total Working Capital generated.  All these fields are automatically updated as additional daily Data Entry Sheet information is copied at the end of each day throughout the month.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The Total Working Capital calculation is the total revenue minus average cost of product, minus any location commission paid.  Giving you a clearer picture of location and machine productivity – How much cash does it generate (not including machine amortization costs).

 Next are the Overall Business Route totals for the same categories.  This is a bottom line view of how your vending business is progressing, from month to month you can easily track and manage your vending business.  Number of stops made, overall product revenue, product cost and working capital generated.

 Next are the Monthly Inventory and Revenue Target Achievements for each day of the month with percent attainment. See Monthly Settings sheet description, and Setting Revenue Targets in Support and Procedures.  This feature shows you on a daily basis if your vending business is achieving your revenue goals.

And finally the Overall Average Vends per day and Overall Average monthly vend price calculations.  The “Overall Average Vend price” is an average of all locations vend price (or averaged vend price) entered in the “Site MTD & Est. Freq.”  tab.  As you add, change or delete locations, the Route-EXCELerator automatically calculates your overall average vending price.  So you are able to manage your vending business profits machine by machine.  Pick your profit margin and manage your distribution outlets by weeding out the lower performing accounts and marketing new locations at the higher price points. 

 

 

 

 

Copyright © 2006 Mountain Top Enterprises, Inc.

The Route-EXCELerator Overall Totals tab gives you a 'birds eye' view of your business, by giving you the ability to look at the total business performance, review each route, and compare the routes to one another. 

This can be a starting point to evaluate route geography, stop frequency,  consumption trends and profitability.

You also get a snapshot of your inventory sold and 'On Hand', to track better inventory management. 

Total Working Capital generated is a true indicator of route, location and machine performance.  By tracking this you will be able to see what are your best performing accounts and routes. 

Its not what you make, but what you keep that really matters!

Product Description Links:

The “Overall Totals” tab

The “Daily Totals Area on the Overall Totals” tab

Site Month To Date & Est. Freq. Tab

Customer Info Tab

Column Asgn Tab

Account summary Tab

Pick List Tab

Monthly Visit Summary Tab

V-Hist  Tab

Vend-Price Tab

Product $$ Tab

Product Sales Tab

Daily Sales Sheets 1 - 31

Monthly Settings Tab

Product Purchases Tab

Product Inventory Tab

Top Product Sales Graph Tab

Revenue by Route Graph Tab

 

Search for text anywhere on our site