< back to Blog home
By
Sarah Ward

How to Calculate Cost of Goods Sold: Formula & Information

Table of Contents
Thank you! Check your inbox for details.
Oops! Something went wrong while submitting the form.
liquor inventory app, cogs formula, cost of goods sold

Do you know your restaurant's cost of goods sold? How about how much do bars make in relation to the COGS? You should. It'll help you manage restaurant risk assessment.

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 liquor cost. These two numbers show the total percentage of a restaurant's expenses that are dedicated to food and beverage inventory. It's important to learn how to manage cost for restaurant business. Without these measurements, running a successful business is nearly impossible and you'll end up a part of the restaurant failure rate.

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 expenses. 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

Frequently Asked Questions About The Cost of Goods Sold

Beyond that dive into what cost of goods sold is, there are a few other things you should know. From the COGS formula, to calculating the total cost of goods sold, to a cost of goods sold example. Beyond the question of "what is cost of goods sold?" these following questions and examples will help you on your way to understanding the cost of goods sold and why it's important for a restaurant or bar owner.

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, or COGS 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. You can also invest in restaurant accounting software to further streamline the process.

boosting bar profit margin ebook

What Is a 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 cost of goods sold 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 in the COGS formula.

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 and knowing how to price a menu. It also impacts your restaurant balance sheet, so stay on top of it to avoid losses.

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 recipe costing, beer pricing, and alcohol pricing. It can even help you adjust the individual price per glass of wine and wine price. It truly is a major factor in all business decisions.

Book a Demo
Reduce inventory counting time by as much as 85%. Schedule a demo now:
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.