Route-EXCELerator
 Product Detail Description Product Purchases Tab
|
|
       |
|
|
The “Product Purchases” Tab is the tab that you enter the product inventory purchases during the month. The specific purchase information is entered in the Blue cells. Date Purchased, Purchase Source, Total Cost (Amount of Invoice). The calculations are the Average Unit Price, Total Number of Units, and Total Number of Cases.
Then the quantities by brand are entered in the blue cells under the brand names.
With this format you can compare the unite price by vendor, you can also break out orders by common items ordered, i.e., Bottled Water, vs., Snapple products. The "Overall Average Unit Price" is still the same and feeds a number of formulas in the workbook. This Tab is very helpful in determining the best suppliers for your product mix.
Copyright © 2006
Mountain Top Enterprises, Inc. |
The Route-EXCELerator The Beverage Route-EXCELerator assumes a 24 item case, and the Snack Route-EXCELerator creates an average case size based on your input during the initial set up. Product Description Links: The “Daily Totals Area on the Overall Totals” tab Site Month To Date & Est. Freq. Tab
|
 | |
