Kegshoe Keg Tracking | ROI Calculator

	A	D	F
1		How to use	To begin using this sheet, go to File > Make a Copy or File > Download. This will save your own copy to edit. Once you've made your own copy, fill in your estimated keg fleet size, keg cost, and loss rate. The spreadsheet will automatically update to reflect your data.
2		How to use
3	Keg Tracking ROI Calculator	Ready to start saving? Upgrade your tracking	Upgrade your inventory management to Kegshoe Keg Tracking for mobile scanning apps, unit history, in-depth reporting, and more. Visit kegshoe.ca or call 1-855-815-5534 for more information.
4
5	Estimated Savings (Year 1)	$14,175.00	Estimated savings from improved keg retention. See: Keg Retention over Time and the ROI Report
6	Estimated Savings (After 5 years)	$58,500.00
7
8		Update these ↓
9	Number of kegs	1000	The estimated number of kegs you've purchased or leased.
10
11	Avg. keg value	$75.00	The average book value of your existing kegs. If you collect keg deposits, subtract the deposit amount.
12
13	New keg cost	$150.00	What you would expect to pay for an additional keg (whether new or used).
14
15	Cycle time (months)	3.0	How long it takes (on average) for a keg to return back to your brewery after being filled and delivered.
16
17	Keg recovery rate (per cycle)	98.00%	For every 100 kegs that you send out, how many do you receive back? 96–98% is normal for most breweries without keg tracking, but can be lower if using third-party distributors.
18
19	Estimated annual keg loss	7.76%	The number of kegs you likely lose on an annual basis. To verify, you can compare the number of kegs you have on-hand + recently delivered kegs to the total number of kegs you've purchased. 5–10% annual keg loss is normal for most breweries without keg tracking.
20
21	Annual keg loss with Kegshoe	1.50%	With proper processes in place, breweries who use Kegshoe can reduce their annual keg loss to 1–2%.
22
23			Disclaimer: Keg loss rates will vary. For optimal keg retention, proper operational and logistical processes are required.
24
25	Copyright Kegshoe Inc.