Beverage Stock Take Template for Excel
Beverage Stocktaking in MS Excel
Excel Templates
Business Templates
Budget Templates
Financial Templates
Corporate Finance
Excel Tutorials & FAQs
Excel FAQs
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
 Screenshot 1 Screenshot 2 Screenshot 3 Screenshot 4 |
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 Calc.  |
Version: BST 1 File Type: .xls Size: ~1.20 MB Required: Microsoft Excel® Not Required: Installation Macros Cost: $0.00 Free for personal use License: View EULA |
|
Buy unlocked version of Beverage Stock Take Template risk free with 30 day full money-back guaranty!  Cost: $14.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 Template12 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. Mick Phillis |
||
|
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. Ricky Barr |
||
Other Small Business Templates and Spreadsheets for ExcelRestaurant 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 Recommendwww.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. www.gomsg.com - Start accepting credit cards and other electronic payments now. Merchant Service Group has a solution for every business. |
Books related to Restaurant Management |
Share Our Beverage Stock Take TemplateIf 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. |
Spreadsheet123. All rights reserved.
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. Spreadsheet123.com is not associated with Microsoft.
