Vending Tools
Spreadsheets, documents and other material designed to help you run your vending business.
48 files
-
2020 Beaver Vending Machine Brochure
This is the beaver 2020 vending machine brochure. Hopes this helps you find a quality machine
34 downloads
0 comments
Submitted
-
ADA rules for Vending
Summary of updated ADA requirements for vending locations, from Vending Times, March 2012.
48 downloads
- ada
- americans with disabilities act
- (and 1 more)
0 comments
Submitted
-
All American Chicken Machine Locating Flyers
By caserri
A couple of nice full color flyers to use when locating the Parsal All American Chicken. For best results take these files to your favorite copy/print center and have them printed on glossy stock.
171 downloads
- all american chicken
- chicken
- (and 1 more)
0 comments
Submitted
-
Angels' Crossing Vending Outreach Pledge Form
By BCB434
Introducing Angels' Crossing Vending Outreach Program
Purpose is to provide additional charities to choose from when doing charity vending.
They help facilitate foster care and adoption services. Check out the website for more details.
Angelscrossingtx.org
They are local to South Texas but are interested in starting a national Vending Outreach Program in which I volunteered to help them setup.
This is a new program for them and as I helped introduce them to this idea and create this program there was one goal for this program for both the charity and for the vendor. The goal was too keep it simple.
There is a Vending Outreach Donor Pledge Form to fill out,
Then after form is sent in labels will be provided for you for your vending machines.
To help keep this simple and efficient labels will be provided and sent as a PDF and vendor can print, laminate, and use as needed. (Just keep in mind a pledge form is to be done first and also just like all Charity Vending Programs there is a lot riding on the honor system).
More literature and brochures can also be requested as needed.
$1 per month, per sticker, on location is the part of the pledge agreement, of course more is always appreciated.
Pledge Form attached and available for d/l, you can send to me or directly to charity for labels.
30 downloads
0 comments
Submitted
-
Asset Depreciation Worksheet
By caserri
A handy spreadsheet to help you correctly depreciate your vending machines. Calculations in this worksheet are performed automatically.
125 downloads
0 comments
Updated
-
ATM Placement Contract
By caserri
Here is the contract we use in the placement of ATMs. File is an editable document. Feel free to edit as you see fit.
Contract spells out expectations in the following areas...
FILLING THE MACHINE AND PROCESSING FEES TELEPHONE & ELECTRICAL REQUIREMENTS TELEPHONE & ELECTRICAL REQUIREMENTS SIGNAGE TERM OF AGREEMENT MERCHANT COMMISSION SALE OR RELOCATION OF BUSINESS TERMINATION FOR DAMAGES TERMINATION FOR LOW USAGE TERMINATION FOR CAUSE INSURANCE REQUIREMENTS
And More.
53 downloads
0 comments
Updated
-
Bulk Route Manager
By caserri
Here is an Excel spreadsheet that sold on eBay a couple years ago. It was marketed as a bulk vending route manager. It is a simple way to keep track of the basic details of a small route.
Directions
Route Manager
Easy Use Instructions
Note: The first ticket listed in your service record is filled in as an example. You may use it as a reference or, once you are more comfortable with the format, you can fill it in with one of your own locations.
Description of Features
The Service Account Number (ex. sa0001): This number is located at the top left of every ticket. It is used to identify each account. It is therefore a quick and easy identifier when pulling up existing accounts.
Map: The “Map” is used to physically locate your account. Simply add the map code to your account’s address in this space. You can find the map code to your account’s address by looking up the address in the back of a map book. The best map book in my opinion is The Thomas Guide but any map or map book will do.
Address: Enter the address of your account here.
Phone: Enter your account’s phone number here.
Hours: Enter your account’s open hours here.
Service: Enter how often your machine needs to be serviced. For example, you may have a real busy location which needs to be serviced on a monthly basis. You could simply write “monthly” in this space. A slower location may be better serviced “bimonthly.”
Key: Enter the color and code (if any) of your machine’s key. You may end up with different keys as your route grows and this will save you a lot of headaches.
Date: Enter the date in which you service your account.
Bag#: When you service your machines, the easiest way to collect your money is with a bag. You can even use large zip lock bags. Write a number on each bag, making sure to have enough bags to service your route for the day. When you service your location grab any of the bags (it doesn’t matter what number it is) and collect your coins. When you return to your car write down on your ticket what bag number or numbers you used. When you go home to count your money you’ll know exactly which bag goes to which location.
Lft. M. Rt.: These represent the type of candy in each head or section of your machine. If you have a double head just fill in the type of candy for the left and right head. If you have a trivend, fill in the type of candy for the left, middle and right section.
Lft$ Rt$: These symbols represent how much money you collect from each respective section on your machine. If you have a trivend, there will be only one section for your coins to fall into and you can therefore just fill in the amount on one side. This will help you to monitor the productivity of each particular candy and allow you to make any necessary adjustments.
Comments: Any important notes may be filled in here.
Total: Your account’s monthly running total will automatically be added here for you. This will make your job a little easier come tax time.
Getting Your Tickets Ready!
You are almost ready to go service your machines, but first…
1. Enter your account’s name, map code, address, phone#, hours, service frequency, key code, map code, and candy type for each location you have.
2. Print your tickets. I have found that 8½” by 11” white “card stock” paper works the best. It is thick and durable and easy to take with you.
1. Go to File
2. Go to print
3. Go to print range and click on “pages from”
4. Look at the service ticket number or “sa number.” This number is also the page number. Type pages from 1 to 1 if your ticket number is sa0001.
5. Click O.K.
Congratulations! you’re ready to go service you’re machines!
When You Return.
To find your accounts quickly using your Route Manager…
1. Go to Edit.
2. Click on Find
3. Type either:
A. The location name
B.Or type the sa number. (Remember the sa number is much quicker and easier to use.)
4. Click on Find Next. (You should now be at your desired ticket.)
5. Enter your service data.
569 downloads
0 comments
Updated
-
Bulk Vend Profit Tracking
By TheCandy
I put this spreadsheet together to help me with keeping track of most of the major things taking place i.e. gross, COGs, charity/commission, net profit, notes, keys, locations, etc. I have created some formulas within the sheet so that you only have to enter some information each time you service the machine, and the sheet will keep track of the rest. This is also a book with the final page "Totals" will total up your entire route for you.
Fields in Yellow are Auto Fill, Fields in Blue are Manual. When completing the form with information from servicing, enter the requested numbers in the blue fields. The yellow fields will automatically update when you are finished.
The "Totals" page is all autofill and will update from the information from across the book.
To create new sheets, right click on any of the sheet tabs at the bottom of the book other than the totals sheet and select "move or copy",choose where you want the new sheet to appear and check the "create copy box". You will need to rename the newly created sheet by right clicking on the new tab at the bottom and left click on "rename"
When you create a new sheet, you will need to update the "totals" page formulas to include the new sheets. To do this, left click on the yellow field. The formula will appear in the edit bar at the top of the page. You will need to edit the last number before the exclamation mark to the name of number of your newest page. For example: Change =SUM('1:4'!E7) to =SUM('1:99'!E7).
Any suggestions on improvements to the form, the book, or my lousy instructions are welcomed. Hope a few people can make good use of this form. I will update once I have received some suggestions for improvements.
Thanks
354 downloads
Updated
-
Business Valuation Worksheet
By caserri
A template designed to help you place a specific dollar value on your business. It will do so by using three of the most commonly discussed valuation methods. Consequently, it will provide three specific, and very different, values that could be used under different buy/sell situations.
Worksheet is in Excel format.
194 downloads
0 comments
Updated
-
Candy Machine Route Sheet
By BigRedvender
Here is another version of the Route sheet I did. It is set up more for candy and GB locations. Up to 4 products for those larger 4 ways and the odd Uturn and Vedesign 4 way out there. Hope it can help a few of you guys. I took it and had it printed on 110 lb card stock and paper punched for a 3 ring binder to help keep track of things on my route. I now have 32 stops and it gets a little tough to remember what every location has in it for candy. This way I can look at a few stops and see what I need to carry for the day and keep track of sales a little closer.
168 downloads
0 comments
Updated
-
Charity Locating Letter
By caserri
Here is a template of a locating letter for charity machines. This template is in Word Pad so feel free to edit it as you see fit.
632 downloads
Updated
-
Coinco MDB to USB Converter Software
By orsd
This is the software for the Coinco USB to MDB converter.
You need VisualBasic 6 to run the USB2MDB Demo, the MFC Demo Should work fine.
Great tool to test Coin mechs and Bill vals.
68 downloads
0 comments
Submitted
-
Commission Payout Worksheet
By caserri
This worksheet can be printed out and used when you collect from your commissioned locations. Simply count the number of quarters and do the math. It also provides a receipt for your locations and a well documented paper trail.
233 downloads
0 comments
Updated
-
Cost of Goods Calculator
By rodney69
This is in the early stages, I still need to add toys, shipping and so on.
If you fill in the cost per pound it will do the rest! You can modify everything on it currently. I will continue working on this as I have time. I hope it helps!
172 downloads
Updated
-
DEX harness for AP 748
By Walta
<p>Dex harness to fix AP 748 food part number 593-1843</p><p> </p><p>This cable is still available for about $75.00 If you need 10 of them you may want to make them.</p><p> </p><p>One end is a female DB9</p><p> </p><p>The other end is a 3 conductor ¼ inch phone plug female.</p><p> </p><p>DB9 pin 3 connects to phone Tip</p><p>DB9 pin 4 connects to phone ring</p><p>DB9 pin connects to phone sleeve.</p><p> </p><p>This jack photo shows a male plug</p><p>Number 1 points to the Sleeve.</p><p>Number 2 points to the Ring.</p><p>Number 3 points to the Tip.</p><p> </p><p> </p><p>This cable may also fit</p><p>Rowe 7800, Rowe 748</p><p>Automatic products 748</p><p> </p><p>Walta</p><p> </p>
10 downloads
0 comments
Updated
-
0 comments
Submitted
-
Full Line Cover Letter
By caserri
Here is a template a cover letter for your full line locating packet. It is a simple introduction to you and your services. Feel free to edit as you see fit.
284 downloads
Updated
-
Full Line Vending Contract
By caserri
Template for full line vending service contract. Provision included for commission payments.
Word document can be edited as you see fit.
427 downloads
Updated
-
Honor Box Location Binder Templates
By VAVending
These are templates (Apple Numbers and Microsoft Excel respectively) that follow the accounting model from Vending-Business-Information.com, as laid out by Dennis.
This sheet will do all of the percentage calculations for you as well as auto filling your "Route Totals" sheet. I recommend adding a new "digital binder" for every route you run.
To input a location, simply duplicate the template sheet and fill in the information from your location card. Then add that location to the formula on the "Route Totals" page and drag the new formula over all of the cells.
I hope this helps y'all avoid the confusion I faced when first starting out.
Benjamin
133 downloads
- honor box
- vending-business-information.com
- (and 1 more)
Updated
-
Inventory and Sales Tracking
<p>This is a very shortened version of the spread sheet I use.</p><p>Tracks machine sales, product purchases and cost, spoiled product, monthly and yearly sales.</p><p>Very much a work in progress and I welcome any input at all.</p>
591 downloads
Updated
-
Locating Scripts, Tips, Objections and Rebuttals
By caserri
This 10 page PDF is a compilation of the various locating tips, scripts, objections and rebuttals that have been posted to the forum over the years. We have put this information in an easy to download and print format to help you in your locating efforts.
Topics include...
5 Telemarketing scripts
14 In person scripts
1 voicemail script
1 direct mail script
9 common objections and their rebuttals
1 Craigslist ad
Misc locating advice from our members
All of this information was written by TVF members and remains the property of TVF. You are free to use this information in your personal locating efforts however, any other reproduction or reposting for disemination or sale without prior written permission is expressly prohibited under the policy of TVF and the copyright laws of the United States.
688 downloads
Updated
-
Location and Sales Tracking
By caserri
Simple yet effective Excel spreadsheet for tracking locations and sales.
The following automatic calculations are included.
Days in service Revenue per day Projected annual revenue by location Total active revenue Total revenue per day Projected annual revenue for entire route Machine daily average
All of these calculations are done for you after you make entries into the "pink" column.
There is also a section to track inactive locations.
1,131 downloads
Updated
-
Media/Crane/Dixie Mass File
By Kingpacks
I have uploaded a mass amounts of files for Merchant Media keypad, 7 inch and 9 inch touch as well as telemetry info and 5800 cheat sheets. I hope that anyone could use these tools in this file.
551 downloads
Updated
-
MEI Vending Machine Reference Chart PDF
By Walta
This chart lists most vending machines.
It will help you select the correct Mars Coin mech, BA, harness with notes on how to adjust your setting.
143 downloads
0 comments
Updated
-
0 comments
Submitted