Welcome to The VENDiscuss Forums

Register now to gain access to all of our features. Once registered and logged in, you will be able to contribute to this site by submitting your own content or replying to existing content. You'll be able to customize your profile, while also communicating with other members via your own private inbox! After 1 approved post you are able to access our download section. This message will be removed once you have signed in.

jstolpe

Tracking your products

17 posts in this topic

Does anyone actually track and caculate every products cost, income, proft etc ? or do you just record how much money you take out of the machine each time you service it? I have a few full line machines and am trying to get a better process for my records keeping. Thanks!

Share this post


Link to post
Share on other sites

I run mostly triples for bulk and no I don't calculate the costs for each head, however I do track the total expense and income for each machine. I use to use an excel spreadsheet but recently moved to vendingtrak and from what I have seen so far it is much better even though it will end up costing me $30 a month. It does a good job for my soda and snack machines as well and I really like the route service sheets it allows me to print when i service my routes. All in all I think it's worth the $30 and it helps me see where my money is going out and where it is coming in.

Share this post


Link to post
Share on other sites

Does anyone actually track and caculate every products cost, income, proft etc ? or do you just record how much money you take out of the machine each time you service it? I have a few full line machines and am trying to get a better process for my records keeping. Thanks!

I own and operate a multiple 6 figure route, I only track my total cost of goods for the entire business. Unless you have the machines, software and the capability to retrieve DEX data anything that I have seen is, IMO, too cumbersome and time consuming to deal with.

Share this post


Link to post
Share on other sites

I own and operate a multiple 6 figure route, I only track my total cost of goods for the entire business. Unless you have the machines, software and the capability to retrieve DEX data anything that I have seen is, IMO, too cumbersome and time consuming to deal with.

I agree 100%. Who in the heck has time to record how many bags of doritos a particular machine goes through on a weekly basis? And to what end? Time is money and if I can't see some direct financial benefit to doing something, it is not done.

Share this post


Link to post
Share on other sites

People track sales/trends for a lot of reasons....some are financial, some are just because.

I am one of those that track "just because". I am the type that wants to know how many bags of doritos I sold last month in this machine.....vs how many I sold at a different spot.

With the right spreadsheet, it's not really that much work (however I will tell you I spent alot of time perfecting my spreadsheet).

The spreadsheet calculates unit cost, profit, profit % as well as keeping track on spoilage total sales etc. I further break it down to Sodas, snacks, chips, frozen and fresh foods.

Again, not for everyone....but some find it interesting/useful.

Travis

1 person likes this

Share this post


Link to post
Share on other sites

Too complicated just remember ur top 5 - 10 best sellers and that's it

Share this post


Link to post
Share on other sites

People track sales/trends for a lot of reasons....some are financial, some are just because.

I am one of those that track "just because". I am the type that wants to know how many bags of doritos I sold last month in this machine.....vs how many I sold at a different spot.

With the right spreadsheet, it's not really that much work (however I will tell you I spent alot of time perfecting my spreadsheet).

The spreadsheet calculates unit cost, profit, profit % as well as keeping track on spoilage total sales etc. I further break it down to Sodas, snacks, chips, frozen and fresh foods.

Again, not for everyone....but some find it interesting/useful.

Travis

i agree i do the same thing, but i have a small route. i use pre-printed route cards that act as a plan-o-gram

for each machine. it has empty spaces for "# of stales removed" and "# of items added" as well as notes

and the pre-printed par level. when i enter those figures at home it calculates totals for everything and cogs, so i can tell if

a particular product is moving, if its making me money and if the price needs to be adjusted. this allows me to keep down my

spoilage on a small route,which is really important on smaller routes controlling spoilage is very difficult because you dont have those whale accts where u can offload any short dated products

Share this post


Link to post
Share on other sites

People track sales/trends for a lot of reasons....some are financial, some are just because.

I am one of those that track "just because". I am the type that wants to know how many bags of doritos I sold last month in this machine.....vs how many I sold at a different spot.

With the right spreadsheet, it's not really that much work (however I will tell you I spent alot of time perfecting my spreadsheet).

The spreadsheet calculates unit cost, profit, profit % as well as keeping track on spoilage total sales etc. I further break it down to Sodas, snacks, chips, frozen and fresh foods.

Again, not for everyone....but some find it interesting/useful.

Travis

Fully agree with this. To run biz finance indicator is a very important flag to direct the biz going direction.

Wilson

Share this post


Link to post
Share on other sites

Fully agree with this. To run biz finance indicator is a very important flag to direct the biz going direction.

Wilson

So do you represent ICT, or are you a distributor?

Share this post


Link to post
Share on other sites

So do you represent ICT, or are you a distributor?

Hi Alden,

I am from ICT Europe branch office but currently station in the HQ. Do you work with us before?

US is not my responsibility region but I like Vendiscuss and often am here reading some posts so that we know what the customer's need and feedback is.

cheers!

Share this post


Link to post
Share on other sites

I own and operate a multiple 6 figure route, I only track my total cost of goods for the entire business. Unless you have the machines, software and the capability to retrieve DEX data anything that I have seen is, IMO, too cumbersome and time consuming to deal with.

So how do you know what a particular location is trending to? I'm still new at this and trying to track everything and already seeing different trends at diff locations. My spreadsheets have changed/morphed/evolved so many times I'm not sure what I really need now. I'd really like to see what everyone else has done to track their sales/purchases.

1 person likes this

Share this post


Link to post
Share on other sites

So how do you know what a particular location is trending to? I'm still new at this and trying to track everything and already seeing different trends at diff locations. My spreadsheets have changed/morphed/evolved so many times I'm not sure what I really need now. I'd really like to see what everyone else has done to track their sales/purchases.

I use vendtrak to keep track of everything. I can also print out a summary to send to my accountant instead of all those receipts.John

Share this post


Link to post
Share on other sites

So how do you know what a particular location is trending to? I'm still new at this and trying to track everything and already seeing different trends at diff locations. My spreadsheets have changed/morphed/evolved so many times I'm not sure what I really need now. I'd really like to see what everyone else has done to track their sales/purchases.

I do a planogram for each machines so I know what was in each row if it happens to be empty. I also use placeholder cards in some machines.

Share this post


Link to post
Share on other sites

Yep, I tend to stock each of my machines in the same order....so it's always easy to remember, but because old age is starting to creep in, I also keep a plan-o-gram in the bottom of each machine.

Travis

1 person likes this

Share this post


Link to post
Share on other sites

I have a database on my phone for each machine with par levels for each product.

Share this post


Link to post
Share on other sites

Yep, I tend to stock each of my machines in the same order....so it's always easy to remember, but because old age is starting to creep in, I also keep a plan-o-gram in the bottom of each machine.

Travis

That's a good idea Travis - I think I'll make copies of mine and put them down there. I've got a binder with all my snack machines in it but don't carry it with me.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now