Here is a picture of my Excel file of my analysis of my newest location. Across the top I have the number of sodas that might be vended. Since this is a location without a lot of people, I am expecting just a few vends a day. The next row is the expected income based on selling the soda for $0.65. Right now I am able to get the soda at $0.27 which gives a profit of $0.38 per can of soda. The next row shows the net profit per day. The net profit per month is based on 24 working days a month. The profit per year is based on 12 (24 day months).The next group of rows shows how many days that I could theoretically go between services. I do not like to leave the machine for too long, so I would go at least once a month. This assumes that all of the selections are purchased at equal frequency which is not always the case. Often one selection will run out before all the other ones.
The next group of rows shows how many days of income it would take to pay for the gas to service the machine based on various gas prices.
The next group of rows show the expected profit per month taking gas prices into account. Finally, the last group of rows shows the extimated profit per year after taking the price of gas into account.
I hope that this is helpful. I also hope that you can read the Excel numbers easily. I will try to find a better method of placing them in my blog.
No comments:
Post a Comment