Running a business is not only about making profit, but also consistent control and monitoring of how this profit is being made, the amount of costs involved and so on.
Small Businesses like Restaurants, Bars, Public Houses with beverage as their primary product usually have to
concentrate on the stock and cost control as on the other hand on their budget and effective profitability.
Controlling stock is a must for every restaurant that is serious about making a profit and not only at the end of the month, but at the end of each week.
The Beverage Stock Take Template contains five Liquor Stock Take worksheet for every week of the month along with Beverage Key Line Check and
Budget Forecasting Tool that can allocate your forecasted budget and calculate your weekly spending allowance for the set Beverage Growth Profit Margin.
Beverage Key Line Check is a simple tool that follows your beverage line and can help to
indentify the product that your restaurant may be loosing on.
Beverage Growth Profit Margin is a share of the revenue generated by your product that runs at around 70% to 74% when
the rest 26% to 30% is a cost of the product.
If you run a restaurant, I will also recommend you to take a look at Menu and Recipe Cost Template,
Restaurant Profit and Loss Template and Food Stock Take Template
Beverage Stock Take Template for Excel that contains five
weekly stock take reports can be a real help when counting your liquor stock at the end of each week or a month.
The integrated Budget Forecasting Tool allocates your estimated revenue and spending allowance for each week and helps to
compare to the actual cost of sales for every week of the month.
Instructions are simple, just enter the amounts from you POS in to the blue cells and this is really all you have to do.
The Beverage Stock Take Template can be customised to suit your business requirements.
You can download and use or free beverage stock take template only for your personal use.
Read our Limitation of Use Policy that are applicable to both free and unlocked version of this Beverage Stock Take Template.
If you need to download this template for commercial use, then you may need to purchase unlocked version of the Beverage Stock Take spreadsheet, that
will also allow you to customize this spreadsheet to your company specific requirements.
You can also download Beverage Stock Take Template that works in OpenOffice.org Calc.
>> Download Now
Version: BST 1
File Type: .xls
Size: ~1.20 MB
2002(XP), 2003, 2007
Free for personal use
License: View EULA
Buy unlocked version of Beverage Stock Take Template risk free with 60 day full money-back guaranty!
Cost: $24.95USD Download will start after your payment is processed.
Disclaimer: This template and the information on this page is for educational purposes only. We do not guarantee the results. Use this template at your own risk.
You should seek the advice of qualified professionals regarding financial decisions.
Visitor Comments about Beverage Stock Take Template
12 August 2009
I purchased your excellent Beverage Stock Take Template on 11 August 09.
I have to say, what a great piece of work it is, after
30 years as a licensee and many different ways of counting stock and getting
results how simple and effective I think your template is.
("Kings Arms" Brighton England)
22 June 2009
Just wanted to offer my sincere thanks and gratitude for offering
these spreadsheets online.
I am a small business owner struggling to get on my feet and have found a wealth of spreadsheets and information on your site that have greatly improved how I run my business.
Applause to your new Beverage/Alcohol Inventory spreadsheet. Have been trying for weeks to create a spreadsheet like it in excel with very little progress.
The one that was created and shared here is exactly what I needed.
Thanks to the creator and to your website!! Just what we need in
these trying economic times.
("The Lighthouse Pub" Barbados)
Other Small Business Templates and Spreadsheets for Excel
Restaurant Menu and Recipe Cost Template - Prepare an accurate costing for all of the menu items.
Restaurant or Bar Stock Take (Food) - In house food stock monitoring and control template for excel.
Restaurant P&L Statement Template - with Budget Tool to calculate you monthly and weekly profit and costs.
Links to other Excel or Restaurant Software Related Sites we Recommend
www.hotelsmartsuite.com - this site does offer a very well designed software
and few services related to Hotel Business including Front Desk, Back Office,
Online Booking, Marketing and many more.
- Start accepting credit cards and other electronic payments now. Merchant
Service Group has a solution for every business.
Share Our Beverage Stock Take Template
If you have a web site or blog related to Excel, Restaurant or Hotel
Software please link to this page to spread the word about our free Beverage Stock Take
spreadsheet resources. Please copy and paste the HTML code below.