This dashboard is designed to give you a week-by-week snapshot of your Cost of Goods Sold (COGS), helping you track how your inventory is being used and its impact on your sales and profitability.
At the top of the page, you can switch between tabs to change what data you see.
Top Tabs: Switch between the different report views ("Flash Report" or "Line Level COGS") to dive deeper into specific data.
Date Selector: Choose the day or range you want to review.
Location Selector: View data for a specific site, or look at all your sites together.
Warning Alerts - A warning may alert you to any potential data discrepancies - such as significant differences between the opening and closing stocktakes. These discrepancies may be impacting the accuracy of the calculations, and should be reviewed.
Weekly COGs Metrics
This section provides a quick summary of your most important metrics (Note - The time frame section will tell you from what dates the following data is from):
Total Net Sales (£): The total revenue generated during the selected period.
Actual COGS: The real cost of goods sold, based on your stocktake and purchases.
-Beginning Inventory: The value of stock at the start of the period.
-Purchases: Additional inventory bought during the week.
-Transfers: Any stock moved between locations.
-Ending Inventory: The value of stock remaining at the end of the period.
Theoretical COGS: The expected COGS based on sales data and standard recipes
If you see a large % Variance: A large gap between the theoretical and actual COGS may indicate issues with stock usage, waste, or recording errors.
Category COGS Breakdown & Variance
On the bottom section, you can switch between Category Level COGS and COGs Variance using the horizontal tab menu. These following tables will help you to understand and dig into reasons for the overall COGs variances for your selected time period
Category COGS Breakdown
The table beneath the topline summary provides a detailed view of how your COGS is broken down by category:
Product Class: Categories - ie. Beverage, Food, Retail, and Other.
Opening Stocktake: The starting stock value for the category.
Purchases & Transfers: New stock value added during the week.
Closing Stocktake: The remaining stock value at the end of the week.
COGS (£): The calculated cost of goods sold for the category.
COGS (%): The cost of goods sold as a percentage of net sales for the category.
Gross Margin (%): The profitability of the category.
Sales: The total revenue generated by the category.
COGs Variance
This table allows you to view COGs performance at a product level. Sometimes products may be used more or less than planned, so this is where you can view those variances and use that information to highlight areas for improvement to increase your cost savings.
Product Name: The item being analysed, such as "2L Whole Milk" or "Roasted Coffee Beans."
Product Class: Indicates whether the item falls into Food, Beverage, or another category.
Pack Type: The type of packaging the product comes in (ie. bottle, carton, case)
Theoretical Usage: The amount of the product that should have been used based on sales data.
Theoretical Cost: The expected cost of the theoretical usage
Waste: The amount of the product that was discarded or spoiled during the period.
Transfers: Tracks any stock that was moved to another site.
Purchases: The amount of the product ordered and received during the reporting period.
Inventory Start: The quantity of the product in stock at the beginning of the period.
Inventory End: The quantity of the product remaining in stock at the end of the period.
Inventory Change (%): The difference between opening and closing stock levels.
Actual Usage: The amount of the product that was actually used during the period.
Actual Cost: The real cost incurred based on the actual usage.
Variance: The difference between theoretical and actual usage. A positive variance (+%) indicates overuse (possibly due to waste, spillages, or over-portioning). A negative variance (-%) suggests underuse (potentially due to stocktaking errors or missed sales).
Variance Cost (£): This outlines the financial impact of the variance, showing how much extra the overuse or underuse has cost you.