Vending Tools
Spreadsheets, documents and other material designed to help you run your vending business.
48 files
-
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>
591 downloads
Updated
-
Free
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
-
Free
Route Tracking Spreadsheet
By caserri
Here is a great multi tabbed Excel spreadsheet provided by member Big Mike. It allows you to track the following information about your route.
Full location name and address Affiliated charity for each location Locator who secured the location Location POC Machine/equipment description Products on location Amount collected each service Average collection amount Lifetime collection amount Commission amount ROI
Included tabs...
Charity Racks Cranes Full Sheet Charity
866 downloads
Updated
-
Free
Profit and Loss Tracking
By caserri
This Excel spreadsheet is full of automatic calculations. Simply enter your information in the "green" sections.
Statistics tracked...
Monthly revenue Annual revenue COGs expenses Misc expenses Machine exposure tracking Profit and loss by location
598 downloads
Updated
-
Free
Vending Service Proposal (Full Line)
By caserri
Here is a full line vending services proposal that I used. Feel free to use this as a template and edit it as you see fit.
--Steve
801 downloads
Updated
-
Free
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.
687 downloads
Updated
-
Free
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
-
Free
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
-
Free
Permit to install vending machine
By Greatdane
Permit to install vending machine
Here are a few blank vending permits you may want to use in your business.
A little paperwork can save a lot of issues that may come up in the future.
Feel free to use as you like.
Enjoy!
Eddie
595 downloads
Submitted
-
Free
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
-
Free
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
-
Free
Vending Potential and Forecaster
By jerry1973
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!!
261 downloads
Submitted
-
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.
530 downloads
Updated
-
Free
Simple Profit & Loss Form
By Makes Cents
Simple split side form for monthly income vs expenses.
116 downloads
- p&l
- profit and loss
- (and 1 more)
Updated
-
Free
Telemarketing Log
By Makes Cents
A telemarketing log to track prospects and call backs. Also useful when you relocate the same areas at a later date.
86 downloads
- telemarketing
- log
- (and 1 more)
Updated
-
Free
Uturn suggested candy settings
By rodney69
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
103 downloads
- uturn
- candy settings
- (and 4 more)
Updated
-
Free
Rack Route Sheet
By BigRedvender
Here is a basic route sheet. It has space to keep an idea of product levels of each head up to 9 and also total sales and commission paid to each location. It has enough space for 12 months and a spot on the end so you can keep track of the monthly average for the stop at the end of the year.
I took this sheet and had it printed on 110# card stock so I can keep track of my stops and keep an average of what they are doing for a longer term then just month to month. PM me with any suggestions on how to make it better and I will see what I can do.
118 downloads
Updated
-
Free
Percentage Pricing Worksheet
By caserri
This Percentage Pricing Spreadsheet was designed and donated to TVF by member Grumpy.
In it, you can enter some information about the product you wish to vend and it will calculate the cost per vend. Try different variables as well to arrive at your desired cost per vend.
This worksheet is great for figuring out how much product you can afford to vend and still remain profitable.
555 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
-
Free
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
-
Free
Royal GIII Non-EVS Programming Chart
By AZVendor
<p>A flowchart of the programming in the Non-EVS version of the Royal GIII logic board.</p>
28 downloads
0 comments
Updated
-
Vending Sales Projector
By Grimsweeper
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.
118 downloads
- excel
- vending tools
- (and 1 more)
0 comments
Submitted
-
0 comments
Submitted
-
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
