What and where is the Cost of Goods Sold (COGS) report?

This article shows users where to find the Cost of Goods Sold (COGS) report and what information is gathered.

Overview

Cost of Goods Sold (COGS) refers to the total amount of costs, in dollars and percentages, your store has paid to produce sales. Decision Logic breaks those costs down into Account Categories for stores to view where their costs will help managers address areas with high costs, such as food costs. Users can dive deeper into costs by expanding an Account Category on the Cost of Goods Sold report to see individual ingredients and how much they contribute to costs.

Inventory, Ordering and Receiving, and the Daily Sales Report (DSR) impact and appear on the Cost of Goods Sold report.

Inventories posted through Inventory Home on the web platform and the Digital Manager mobile app are used as the Beginning and Ending Inventory.
Orders entered and Manual Receives posted through Ordering Home and Digital Manager (for electronically integrated distributors) appear as Purchases.
- Orders must be received the same week they arrive at the store to display a correct COGS report.
Decision Logic Administrators can see COGS on the Shelf Extensions page.

View COGS Report

Begin by navigating to:

Reports > Cost and Variance > Cost of Goods Sold

Select the Company, Region, Area, or Store.
Click View X Store.
Select a Date Range.
1. The green dot under a date represent an inventory cycle and will default to the current week.
2. Period Start is the beginning of that store’s period.
Click Apply.

The % Sales for each category shows you the percentage of cost for that category. For example, the store’s food cost appears in the rollup for “Food.”

Total % Sales is the overall food cost.

Example report

Calculations

Metric	Calculation / Definitions
COGS (Usage $)	Beginning Inventory $ + Purchases $ - Ending Inventory $
Begin Qty	Beginning inventory count converted into inventory measurement.
Begin $	Dollar value of the beginning inventory quantity.
Purchase Qty	Purchase quantities converted into inventory measurement.
Purchase $	Dollar value of purchases.
End Qty	Ending inventory count converted into inventory measurement.
End $	Dollar value of the ending inventory quantity.
Usage Qty	Begin Qty + Purchase Qty - End Qty
Usage $	Begin $ + Purchase $ - End $
Total Sales	Total department sales mapped to the Account Category.
% Sales	Usage $ / Total Sales

Product Detail

Users can click on an individual item to display the product’s detail when one store is selected. When multiple stores are selected to view an individual product, the Beginning Inventory for each store is listed first, followed by purchases for each store, and ending inventory for each store.

Individual Store View

Multiple Store View

Metric	Calculation / Definition
Inv Units	Quantity of product report in inventor measurements posted from counting inventory.
Inv Mx	Quantity or pounds in a single container of the item received based on the bid file from the distributor.
Quantity	Inv Units / Inv Mx
Price	Individual pricing for the item based on the bid file received from the distributor.
Ext Price	Quantity X Price

Researching Variance Issues

Below are some suggestions on how users can research variance issues on the COGS report.

Locate the high variance items using the COGS report.
Confirm beginning and ending inventory values are correct.
Confirm all orders (purchases) were received in Decision Logic’s platform and that the quantities and pricing are correct.
Confirm Ideal Usage is depleting at the correct quantities. Users can look for over/under portioning, theft, or waste.

If data is missing from the COGS report, please reach out to your Decision Logic Administrator.

Table of Contents

1 Overview
2 View COGS Report
3 Calculations
4 Product Detail
5 Researching Variance Issues

For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.

Unable to access this feature in the Decision Logic platform?

Contact your Decision Logic Administrator to make Scope and Security adjustments to your user profile or add new features.
Some features are client-specific.

Check out these helpful links.

What and where is the Beverage IvA report?

What and where is the All Food IvA report?

What and where is the Negative Food IvA report?

What and where is the Non-IvA Usage report?

What and where is the Cost and Variance report, and how do I customize or export it?

What and where is the Payroll Report?

What and where is the Top 20 Food IvA report?

What and where is the TvA Store Summary report?