Food Stock Take Template for Excel

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

Screenshot

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 Required: Microsoft Excel® 2002(XP), 2003, 2007 OpenOffice Google Docs Not Required: Installation Macros Cost: Free for personal use