Running a Restaurant Business requires consistent control and monitoring of its primary product Food and Beverage. By control I mean food cost control, revenue budget control,
food loss and wastage control, stock and deliveries control,
labour rotation and cost control and so on.
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 Food Stock Take Template contains five main stocktaking sheets for each week of the entire month that can help to record weekly stock
deliveries and count your stock left on the shelf at the end of the current week.
Food Stock Take Spreadsheet is also equipped with Food Growth Profit Margin calculator tool that can calculate your weekly and monthly food margin
In the Brand Restaurants food GP margin is usually running at 70% - 75% when in the small restaurants it can run at 60% - 65%
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 Beverage Stock Take Template
Food Stock Take Template for Excel with Growth Profit (Margin) calculator, contains five weekly stock take templates combined
together for more accurate monthly stock take result. The spreadsheet allows you to record weekly food
deliveries (up to three deliveries per week) and also count your stock at the and of the week. By counting your stock weekly you have a better chance to act on arising problems.
Instructions are simple, just enter the amounts from you POS and Delivery Notes in to the green cells and this is really all you have to do.
The Food Stock Take Template can be customised to suit your business requirements.
>> Download Now
File Type: .xls
Size: ~579.0 KB
2002(XP), 2003, 2007
Free for personal use
Other Small Business Templates and Spreadsheets for Excel
Restaurant Menu and Recipe Cost Template - Prepare an accurate costing for all of the menu items.
Beverage Stock Take Template for Excel - Easy in house beverage stocktaking solution 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 Food 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 Food Stock Take
spreadsheet resources. Please copy and paste the HTML code below.