This incredible tool helps you track your sales by item and your ideal costs for food, liquor, beer and tobacco!
This incredible tool helps you track your sales by item and your ideal costs for food, liquor, beer and tobacco! It is one of the most powerful management tools you can use. If you are only tracking your actual costs by taking inventory, you're only getting half the information you need to control your costs. Only by comparing your actual food and alcoholic beverage costs to ideal costs can you know if you have a problem with theft or waste.
These spreadsheets let you enter your daily sales by item and recipe costs, then calculate how much the food you sold should have cost you to sell. This is your ideal cost. The spreadsheet then allows you to enter your actual cost from your inventory to calculate a variance. This variance lets you know if you have a theft or waste problem. Use our Recipe Costing Spreadsheet in conjunction with this tool and the Food Inventory Workbook to create the ultimate food and alcoholic beverage cost control system.
You can contact Brandon O'Dell with O'Dell Restaurant Consulting to help you set your Ideal Cost Tracking Spreadsheets up by calling 1-888-571-9068. The spreadsheets contain some examples to help you.
Product Format: Download - Excel Spreadsheets