Vending Tools
Spreadsheets, documents and other material designed to help you run your vending business.
48 files
-
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
-
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
-
Route Card - Front and Back
By mainor5251
Vending Service Route Cards, stole the basic layout from a buddy and tweaked it
810 downloads
0 comments
Updated
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
Route card and P&L tracking
By rjamesn86
Inventory, route card, and profit and loss card. I think that it still needs some work, so if you can see where an equation can be fixed let me know thanks.
229 downloads
0 comments
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
-
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
-
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
-
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
-
Vending PSA (Non-Compete)
By caserri
This Purchase and Sales Agreement is written to serve the selling of full line vending equipment but can easily be edited for other vending types.
This sales agreement covers the sales of multiple machines and multiple locations. It also includes a non compete clause.
149 downloads
0 comments
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
Updated