Roi Calculator Excel Template 43102 | Wot Roi Calculator Restaurant

Partial file snippet.

Sheet 1: ROI Calculator_ 4 Wine Example

	
	
	
	
	
	
	
	
	
	
		

		Restaurant Specific Information (Operator to Input)
		
	
		

		
	
		

		Cost / Bottle
		Price you Charge Per Glass
		Estimated Cost of Equipment & Installation
		Glasses Sold/Monthly 
		Glass Pours Gained from Eliminated Bottle Loss and Spoilage
		Revenue Increase from Decreased Spoilage
		Bottles Saved from Landfill
		Return on Investment (Number of Months)
	
	
		Wine 1 (Pinot Grigio)
		$7 (example)
		 $8.50 
		 $4,000.00 
		60
		5
		 $40.80 
		 605 
		#VALUE!
	
	
		Wine 2 (House White)
		$4.5 (example)
		 $8.00 
		72
		6
		 $46.08 
		
	
		Wine 3 Pinot Noir
		$7.50 
		 $9.00 
		48
		4
		 $34.56 
		
	
		Wine 4 (House Red)
		$4.50 
		 $8.00 
		72
		6
		 $46.08 
		
	
		

		

		

		

		

		20
		 $167.52 
		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		Assumptions:
		

		Data Calculations: What do they Mean?
		
	
		

		

		Current % Spoilage
		
		Assumption:
Spoilage tpyically ranges from 5% - 10%
		8%
		

		Glass Pours Gained from Eliminated Loss & Spoilage
		Glasses of wine NOT lost to bottle waste and spoilage.
	
	
		

		

		Cases sold per year (Wines 1 - 8)
		50
		

		Revenue Increase from Decreased Spoilage
		(Monthly) revenue increase (dollars that hit your bottom line) from an increased number of glasses sold due to eliminated waste and spoilage.
	
	
		

		

		Ounces / Pour
		5
		

		Bottles Saved from Landfill
		The number of bottles saved in your restaurant alone by using kegs vs. bottles. Remember, each keg = 26 bottles you don't have to throw away!
	
	
		

		

		Cost / Bottle Savings
		
		Assumption:
Savings tpyically range fom $.25 - $.75 per bottle
		0.25
		

		Return on Investment (in months)
		The amount of time it will take to make your initial investment (equipment and installation costs) back.
	



Sheet 2: ROI Calculator_8 Wine Example

	
	
	
	
	
	
	
	
	
	
	
		

		

		

		

		

		Wine On Tap ROI Calculator
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		Restaurant Specific Information (Operator to Input)
		
	
		

		
	
		 Wine List (Example)
		Cost per Bottle 
		Price you Charge Per Glass
		Monthly Bottles Purchased
		Estimated Cost of Equipment and Installation
		# Glasses Sold per Month
		Glass Pours Gained from Eliminated Wine Loss and Spoilage
		Monthly Revenue Increase from Decreased Spoilage
		Bottles Saved from Landfill
		Return on Investment (Number of Months)
	
	
		White Wine 1 (Pinot Grigio)
		$7.00 (example)
		 $8.50 
		36
		 $7,500.00 
		144
		12
		 $97.92 
		3,341
		6.0
	
	
		White Wine 2 (House Chardonnay)
		4 (example)
		 $8.00 
		72
		288
		23
		 $184.32 
		
	
		White Wine 3 (Chardonnay)
		$9.00 
		 $11.00 
		24
		96
		8
		 $84.48 
		
	
		White Wine 4 (Sauvignon Blanc)
		$8.00 
		 $10.00 
		36
		144
		12
		 $115.20 
		
	
		Red Wine 5 (Pinot Noir)
		$7.50 
		 $9.00 
		48
		192
		15
		 $138.24 
		
	
		Red Wine 6 (Merlot)
		$8.00 
		 $8.50 
		24
		96
		8
		 $65.28 
		
	
		Red Wine 7 (House Cabernet)
		$5.00 
		 $8.00 
		72
		288
		23
		 $184.32 
		
	
		Red Wine 8 (Malbec)
		$8.50 
		 $10.00 
		36
		144
		12
		 $115.20 
		
	
		

		

		

		

		

		

		111
		 $984.96 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		Assumptions:
		

		

		Data Calculations: What do they Mean?
		
	
		Current % Spoilage 
		
		Assumption:
Spoilage typically ranges from 5% - 10%
		8%
		

		

		Glass Pours Gained from Eliminated Loss & Spoilage
		Glasses of wine NOT lost to bottle waste and spoilage. 
		
	
		Cases sold per year (Wines 1 - 8)
		278
		

		

		Revenue increased from decreased spoilage.
		Revenue increase from increased # of glasses sold due to eliminated waste and spoilage.
		
	
		Ounces / Pour
		5
		

		

		Bottles Saved from Landfill
		The # of bottles saved by using kegs vs bottles. Each keg = 26 bottles you didn't have to throw away!
		
	
		Cost / Bottle Savings
		
		Assumption:
Savings tpyically range fom $.25 - $.75 per bottle
		0.25
		

		

		Return on Investment (in Months)
		The amount of time it will take to recoup your initial equipment & installation investment

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet roi calculator wine example restaurant specific information operator to input cost bottle price you charge per glass estimated of equipment amp installation glasses soldmonthly pours gained from eliminated loss and spoilage revenue increase decreased bottles saved landfill return on investment number months pinot grigio value house white noir red assumptions data calculations what do they mean current assumption tpyically ranges not lost waste cases sold year wines monthly dollars that hit your bottom line an increased due ounces pour the in alone by using kegs vs remember each keg don t have throw away savings range fom amount time it will take make initial costs back tap list purchased month chardonnay sauvignon blanc merlot cabernet malbec typically didn recoup...

Related files

Share

Help

	Restaurant Specific Information (Operator to Input)
	Restaurant Specific Information (Operator to Input)
	Cost / Bottle	Price you Charge Per Glass	Estimated Cost of Equipment & Installation	Glasses Sold/Monthly	Glass Pours Gained from Eliminated Bottle Loss and Spoilage	Revenue Increase from Decreased Spoilage	Bottles Saved from Landfill	Return on Investment (Number of Months)
Wine 1 (Pinot Grigio)	$7 (example)	$8.50	$4,000.00	60	5	$40.80	605	#VALUE!
Wine 2 (House White)	$4.5 (example)	$8.00		72	6	$46.08
Wine 3 Pinot Noir	$7.50	$9.00		48	4	$34.56
Wine 4 (House Red)	$4.50	$8.00		72	6	$46.08
					20	$167.52


		Assumptions:					Data Calculations: What do they Mean?
		Current % Spoilage			Assumption: Spoilage tpyically ranges from 5% - 10% 8%		Glass Pours Gained from Eliminated Loss & Spoilage		Glasses of wine NOT lost to bottle waste and spoilage.
		Cases sold per year (Wines 1 - 8)			50		Revenue Increase from Decreased Spoilage		(Monthly) revenue increase (dollars that hit your bottom line) from an increased number of glasses sold due to eliminated waste and spoilage.
		Ounces / Pour			5		Bottles Saved from Landfill		The number of bottles saved in your restaurant alone by using kegs vs. bottles. Remember, each keg = 26 bottles you don't have to throw away!
		Cost / Bottle Savings			Assumption: Savings tpyically range fom $.25 - $.75 per bottle 0.25		Return on Investment (in months)		The amount of time it will take to make your initial investment (equipment and installation costs) back.

					Wine On Tap ROI Calculator

	*Restaurant Specific Information (Operator to Input)*
	*Restaurant Specific Information (Operator to Input)*
Wine List (Example)	Cost per Bottle	Price you Charge Per Glass	Monthly Bottles Purchased	Estimated Cost of Equipment and Installation	# Glasses Sold per Month	Glass Pours Gained from Eliminated Wine Loss and Spoilage	Monthly Revenue Increase from Decreased Spoilage	Bottles Saved from Landfill	Return on Investment (Number of Months)
White Wine 1 (Pinot Grigio)	$7.00 (example)	$8.50	36	$7,500.00	144	12	$97.92	3,341	6.0
White Wine 2 (House Chardonnay)	4 (example)	$8.00	72		288	23	$184.32
White Wine 3 (Chardonnay)	$9.00	$11.00	24		96	8	$84.48
White Wine 4 (Sauvignon Blanc)	$8.00	$10.00	36		144	12	$115.20
Red Wine 5 (Pinot Noir)	$7.50	$9.00	48		192	15	$138.24
Red Wine 6 (Merlot)	$8.00	$8.50	24		96	8	$65.28
Red Wine 7 (House Cabernet)	$5.00	$8.00	72		288	23	$184.32
Red Wine 8 (Malbec)	$8.50	$10.00	36		144	12	$115.20
						111	$984.96


Assumptions:					Data Calculations: What do they Mean?
Current % Spoilage		Assumption: Spoilage typically ranges from 5% - 10% 8%			Glass Pours Gained from Eliminated Loss & Spoilage				Glasses of wine NOT lost to bottle waste and spoilage.
Cases sold per year (Wines 1 - 8)		278			Revenue increased from decreased spoilage.				Revenue increase from increased # of glasses sold due to eliminated waste and spoilage.
Ounces / Pour		5			Bottles Saved from Landfill				The # of bottles saved by using kegs vs bottles. Each keg = 26 bottles you didn't have to throw away!
Cost / Bottle Savings		Assumption: Savings tpyically range fom $.25 - $.75 per bottle 0.25			Return on Investment (in Months)				The amount of time it will take to recoup your initial equipment & installation investment

Related files

Share

Share to social media

Help

Login Area