Route-EXCELerator

 

Product Detail Description

Product Inventory Tab 

How ROUTE-EXCELerator Works

The “Product Inventory”  Tab is the tab that you use to track your total inventory. The only information that you manually enter is entered in the Blue cells under each brand, which represent the "On-Hand" inventory.  At the beginning of each month you inventory the "On-Hand inventory and clear out the Product Purchases data, to create a "Start-of-Month" inventory snap shot.  

 

 

 

 

 

 

 

 

 

 

 

 

Copyright © 2006 Mountain Top Enterprises, Inc.

The Route-EXCELerator

You can copy the last day of the previous months  "Total on Hand Inventory" numbers into the Next Months " blue cells to carry forward the last inventory status into the next month.  Or you can take an inventory audit each month to obtain the current  inventory stocks.

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