Jump to content

Vending Tools

Spreadsheets, documents and other material designed to help you run your vending business.

44 files

  1. Free

    Honor Box Location Binder Templates

    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

    46 downloads

    1 comment

    Updated

  2. Free

    Transfer of ownership payrange

    It’s the form that you need to transfer ownership of payrange 

    14 downloads

    0 comments

    Submitted

  3. Free

    Angels' Crossing Vending Outreach Pledge Form

    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.

    22 downloads

    0 comments

    Submitted

  4. Free

    Coinco MDB to USB Converter Software

    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.

    17 downloads

    0 comments

    Submitted

  5. Free

    Route Evaluator

    Nice simple tool for evaluating the value of a route, based on value of machines, upkeep costs, income, and length of service. 

    65 downloads

    0 comments

    Submitted

  6. Free

    ADA rules for Vending

    Summary of updated ADA requirements for vending locations, from Vending Times, March 2012.

    25 downloads

    0 comments

    Submitted

  7. Free

    Excell Mint Box Sheet

    Excell spread sheet for keeping track of mint box sales

    71 downloads

    0 comments

    Submitted

  8. Free

    National vendors RAM Clear Procedures

    National vendors RAM Clear Procedures

    24 downloads

    0 comments

    Submitted

  9. Free

    Vending Sales Projector

    Excel Spreadsheet that projects sales for up to 13 products. This sheet is set up for drinks but can be edited any way you like.Input your data into the pink columns, projections are automatically made in the green columns for daily, weekly and annual sales. Special thanks to Caserri, I used his location and sales tracking sheet as a base model.

    75 downloads

    0 comments

    Submitted

  10. Free

    Royal GIII Non-EVS Programming Chart

    <p>A flowchart of the programming in the Non-EVS version of the Royal GIII logic board.</p>

    22 downloads

    0 comments

    Updated

  11. Free

    Cost of Goods Calculator

    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!

    123 downloads

    4 comments

    Updated

  12. Free

    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>

    378 downloads

    11 comments

    Updated

  13. Free

    ATM Placement Contract

    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.
     
     
     

    36 downloads

    0 comments

    Updated

  14. Free

    DEX harness for AP 748

    <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>

    5 downloads

    0 comments

    Updated

  15. Free

    Uturn suggested candy settings

    This is a setting list for U-turn vending machines. It gives you an idea of what to set your machines at and what will come out, pieces per vend, and appx. vends per bag. 
    There are a few different things that aren't completely accurate, but it's a great start!
    I personally use setting 2 for M&I, 3 for HT, and 4 for P M&M for 7 pieces.
     
    Hope this helps those of you that have U-turns.
     
    Rodney

    79 downloads

    1 comment

    Updated

  16. Free

    Simple Profit & Loss Form

    Simple split side form for monthly income vs expenses.

    95 downloads

    2 comments

    Updated

  17. Free

    Service Tasks

    A list of tasks performed by our drivers at each stop.

    109 downloads

    0 comments

    Updated

  18. Free

    Nestlé Spring Water Brands Bottle Vend Settings

    For your convenience, we are happy to provide the following Nestlé Waters North America’s Regional Spring Water Brands 16 oz. Vend Bottle Settings for Dixie Narco, Royal Vendors, and Vendo vending machines.
    Information courtesy of Nestlé Waters North America

    44 downloads

    0 comments

    Submitted

  19. Free

    MEI Vending Machine Reference Chart PDF

    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.

    112 downloads

    0 comments

    Updated

  20. Free

    Vending Potential and Forecaster

    This spreadsheet will forecast the potential growth of a vending company. You input number of machines, percent of cogs/expenses, cost of machines and how many gross dollars in sales you expect from each unit, and you can if you choose to add in any extra money for any month that you want for an en extra boost in growth. Only edit the top line on the entries that are in red and say (edit). Enjoy!!

    206 downloads

    3 comments

    Submitted

  21. Free

    Telemarketing Log

    A telemarketing log to track prospects and call backs. Also useful when you relocate the same areas at a later date.

    71 downloads

    1 comment

    Updated

  22. Free

    All American Chicken Machine Locating Flyers

    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.

    156 downloads

    0 comments

    Submitted

  23. Free

    Bulk Vend Profit Tracking

    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

    290 downloads

    3 comments

    Updated

  24. Free

    Locating Scripts, Tips, Objections and Rebuttals

    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.
     

    504 downloads

    6 comments

    Updated

  25. Free

    Candy Machine Route Sheet

    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. 

    141 downloads

    0 comments

    Updated



×