Excel Restaurant Menu & Recipe Cost Spreadsheet Template

Preparation of any product in any size business involves costs of additional products or items used to manufacture the final products. Calculation of the cost of your product is absolutely necessary, especially in a small or medium business. Knowing costs of your product mean successes of your business.

Calculating Menu Food Cost

Calculating Food Cost is a must for every restaurants serious about making profit. Costing your menu food items will help to achieve certain sales goals as well as cost targets. Effective food cost control allows managers to establish correct selling prices, gross profit targets on every menu item, dish of the day sales, items that are making or not making the desired gross profit.

Restaurant managers should know what their actual gross profit margins are on each food item they are selling - this in turn will allow the establishment to charge the correct selling price and hit specific food cost targets.

Menu Costing Template is a really simple spreadsheet that can help when calculating cost of your product (Menu Item) as well as profitability. I would also recommend you to take a look at Restaurant Profit and Loss Template, Beverage Stock Take Template and Food Stock Take Template

Screenshot

Restaurant Menu & Recipe Cost Spreadsheet designed to help you prepare an accurate costing for all of the menu food items. You only have to enter current purchase prices for ingredients you buy for preparation of single portion, then watch as each recipe and menu item is automatically updated with current costs Spreadsheet also designed to show you profitability of the Menu & Recipe as well as cost margin and generated profit to help you achieve your certain cost targets as well as specific sales goals.

>> Download Now File Type: .xls Size: ~60.5 KB Required: Microsoft Excel® 2002(XP), 2003, 2007 OpenOffice Google Docs Not Required: Installation Macros Cost: Free for personal use