< back to resources

Cost of Goods Sold: Formula & How to Calculate

September 24, 2020
|
Joshua Weatherwax
liquor inventory app

Do you know your restaurant's cost of goods sold? You should.

Running a successful restaurant or bar requires a thorough grasp of accounting principles. Cost of goods sold, or COGS, is an integral measurement that helps a restaurateur increase restaurant sales and ensure restaurant or bar profitability.

Calculating COGS is also a vital step in finding a restaurant's food cost and pour cost. These two numbers show the total percentage of a restaurant's expenses that are dedicated to food and beverage inventory. Without these measurements, running a successful business is nearly impossible.

We'll run you through the cost of goods sold, how to measure it, and give you the tools to succeed on your own.

What Is Cost of Goods Sold?

Cost of goods sold is the total cost of all materials or ingredients used to produce an item. COGS does not include other operating expenses like utilities, wages, or other overhead. These costs are measured separately and are used in conjunction with COGS to find the prime cost of a restaurant and other important metrics. Measuring COGS allows restaurateurs to track their spending on ingredients and adjust purchasing or pricing as needed.

What Is Cost of Goods Sold in a Restaurant?

Cost of goods sold in a restaurant is the cost to make all the drinks and food sold during a given time period. COGS is not measured for each individual dish or drink sold. This would be too difficult and time-consuming. Instead, total inventory count is used to calculate COGS.

Average Cost of Goods Sold Restaurant: Industry Average

The average cost of goods sold in the restaurant industry varies, but the cost of goods sold percentage is between 28% and 32% of revenue. This range primarily depends on two factors. 

  1. Size of a business. Since smaller businesses cannot buy and store supplies in bulk, they can't take advantage of volume discounts. Furthermore, smaller businesses can’t pass these higher costs on to their customers in the form of higher prices. 
  2. Value of the food. If you sell dishes for a high price, you likely use ingredients that are expensive, resulting in a higher COGS. This isn't always a bad thing as the total revenue and profit from these dishes are also higher than less expensive ones. That's why it's important to train your staff on how to upsell

How to Calculate Cost of Goods Sold

To calculate the cost of goods sold for restaurants, you need to know how to take inventory. You'll be taking inventory twice when measuring COGS. Once at the start of the inventory period period (also known as starting inventory) and once at the end (ending inventory). You'll also have to factor in any inventory ordered during that time (received inventory). Plugging these numbers into the formula below will let you know the amount of inventory used.

Cost of Goods Sold Formula

The cost of goods sold formula is:

Beginning Inventory + Received Inventory- Ending Inventory = COGS

Restaurant Cost of Goods Sold Spreadsheet

You can also calculate your restaurant's cost of goods sold using this free downloadable cost of goods sold spreadsheet.

Once you download it, you can edit the cells and it'll do the calculations for you. Input the products on hand from your starting and ending inventory as well as all inventory received that month. You’ll see an example of a diner's inventory for reference. Once you understand how it works, try entering your own stock levels.

boosting bar profit margin ebook

Cost of Goods Sold Example

All of these formulas and spreadsheets may be a bit confusing, so let's plug in some numbers to clarify. We'll start with a general example and use a more industry-specific one below.

If a vineyard in California wants to know their cost of goods sold, they need to look at their inventory levels. Let's say they started the month with $15,000 worth of inventory. They purchased an additional $3,000 of inventory and ended the month with $8,000.

Variable Breakdown:

  • Beginning Inventory: $15,000
  • Received Inventory: $3,000
  • Ending Inventory: $8,000

All we have to do now is plug those numbers into our handy formula to find the vineyard's COGS.

Cost of Goods Sold= $15,000 + 3,000 - $8,000
Cost of Goods Sold = $10,000

The amount of money spent on the grapes and other ingredients used in the wine sold by the vineyard totals $10,000. Now that they know that number, they can use it when determining their wine markup.

Cost of Goods Sold Restaurant Example

Let's get more specific and use an example more relevant to a restaurant or bar.

In this scenario, you'd like to better understand your inventory use last month. On the first day of the month you had $5,000 of leftover inventory, including meat, vegetables, spices, and other ingredients. Everything needed to make a meal or drink.

During the month, you ordered an additional $2,500 of inventory and ended the month with $2,100 worth of inventory left over.

Variable Breakdown:

  • Beginning Inventory: $5,000
  • Received Inventory: $2,500
  • Ending Inventory: $2,100

Back into the formula we go.

Cost of Goods Sold= $5,000 + 2,500 - $2,100
Cost of Goods Sold = $5,400

We find that last month your restaurant's cost of goods sold was $5,400. This means you used $5,400 worth of meat, vegetables, and other ingredients in the dishes and beverages you sold last month. Comparing this against revenue will allow you to understand your profit margin and make better decisions. You can often lower your COGS by embracing menu engineering.

liquor inventory app

That's Some Good Accounting

Now that you know how to calculate the cost of goods sold, you can use that information to make better decisions. COGS is also a major part of prime cost, which is one of the most important metrics used in determining your business plans.

Maintaining a profitable business means setting goals and adjusting plans and prices as necessary. For example, if you sell alcoholic beverages, you can use your cost of goods sold to determine beer pricing and alcohol pricing. It can even help you adjust the individual price per glass of wine and price per wine bottle. It truly is a major factor in all business decisions.