Maintaining an accurate count on how much your food inventory costs each month is necessary to running a successful restaurant. Being able to use a spreadsheet will make monitoring individual items much easier. These can be broken up into separate sheets, so that all the food isn't piled onto one single page. These can take quite some time to set up, especially if you are going through and putting everything in by hand. There is a lot to write down when you have a large restaurant. Finding a free master costing spreadsheet that has already been created is the key to getting this all organized much faster.
A great site to use for such a spreadsheet is freerestaurantforms.com. These are completely free and can be downloaded quickly to your computer. The format is very easy to follow and can be altered to fit the inventory you have, there will be menu items that need to be added to or omitted from the list. This spreadsheet is et up into three different worksheets; appetizers, main dishes, and desserts.
The appetizer page lists all items in the left column, then to the right are individual columns for; cost, sell price, percent cost, suggested 35 percent max, and percent at 10.00. The next two worksheets are set up in exactly the same manner.
This free master costing spreadsheet allows all pricing to be looked at in a matter of minutes. These spreadsheets are easy to change when items drop from the menu or are added to it. Being able to quickly alter the pricing is simple process as well.
The calculations that are figured into the spreadsheet make it possible to have accurate amounts immediately shown, instead of wondering if all your calculations are correct. These worksheets take a lot of the extra effort out of maintaining proper cost amounts, where this energy can be focused on other aspect of running the restaurant.
