Food Cost Analysis Spreadsheet


In this article we will teach you to apply the formula to calculate the cost of raw material most used by thousands of companies in the commercial sector and applied to the Gastronomic line: restaurants, cafeterias and food businesses regardless of their size


1.- Carry out an initial inventory before taxes of all your inputs, it is obtained by counting or weighing all your raw material that is in your warehouse and in your refrigerators including those that are in production process that have not registered the sale and multiplying it by the unit cost (you can use an Excel format to facilitate your work).

It is important to separate a FOOD inventory and another inventory of BEVERAGES in 2 areas …

2.- Registering all the Purchases keeps a very accurate record of all the merchandise or supplies that entered your restaurant at cost price and sum all the invoices that were purchased in the period of which you want to know the cost … Separates the 2 records one of Food and another of Beverages.

Note, at the end of the day you can add all the tickets or invoices that you entered as purchases.

3.- Available Supplies are obtained by adding what was (Initial Inventory) plus what was entered (Your purchases)

4.- Final inventory is what is left of supplies in your warehouse and refrigerators this inventory is obtained in the same way that you did the initial inventory, only

that you have to elaborate at the end of the period you chose to calculate your cost …

It is very important to take into account that the FINAL inventory will serve as INITIAL inventory for the next period to be monitored …

Note: you can use the same format of the initial inventory in the same order, remember that your inputs will generally be the same as long as you do not change the menu.

5.- Cost of Raw Material The equivalent of what is missing is obtained by adding what was there (initial inventory) plus what I enter (your purchases) and subtracting what was left (final inventory). What is missing (Cost of Raw Material) is composed of two items: Dishes sold (cash and credit if applicable) and differences to be clarified.

Note: Differences to be clarified are all the dishes from which the destination can be unknown and which probably did not register in the sale (leaks and thefts), were reductions that were not registered or deficiencies in the delivery of badly weighted goods or failures in the portion of the ingredients (it is served more in the saucers as estimated in the initial costing of Platillos).

Food Cost Analysis Spreadsheet

Food Cost Analysis Spreadsheet
Food Cost Analysis Spreadsheet

Gallery of Food Cost Analysis Spreadsheet

( Click Image to Enlarge )

See More!