Overview
This article shows how the information on the Flash COS (Usage) tab is displayed and calculated.
The Flash COS (Usage) tab can be found in the Inventory and Requisition dashboard and is populated with data only if the core Purchasing & Inventory solution (Adaco) has an itemised sales feed from the EPOS system, and Recipes are linked to PLUs to register individual menu item sales.
If all recipes are not linked to PLUs, the tab will display incomplete data.
Filters
Fig.1 – Filters at the top of the tab
Top Banner Figures
The left side of the banner displays the 'Inventory Adjustment' and the 'Usage' figures in monetary terms. In the centre, the cost of sales ('COS') is displayed (calculated based on Usage less Inventory). This figure is used to calculate the actual COS percentage.
'COS%' is shown on the far right side of the banner as a percentage of 'Outlet Sales' revenue (all sales submitted by EPOS), which is displayed to its left.
Fig.2 – Figures in 'Summary' banner at top of the tab
Field Name | Description |
Inventory Adjustment | Value of Inventory wastage for the period |
Usage | Value of cost of all products used in the stock period |
Cost of Sales (COS) | Usage less Inventory Adjustment |
Outlet Sales | Outlet Sales Value includes all sales submitted by EPOS (i.e. Matched and Unmatched PLUs) |
COS% | (Actual Usage less Inventory Adjustment) ÷ Outlet Sales Value |
Example
During a period, you start with 500 bottles of Coca-Cola, have 300 more delivered, and finish with 690 because 100 were sold and 10 were transferred to wastage.
The recipe for a bottle of Coca-Cola has a recipe cost price of £1 and a recipe selling price of £4 (with a PLU linked to the EPOS system).
However, there is a promotion offering a 10% discount on the selling price, so Coca-Cola is being sold at 90% of the normal recipe selling price.
The COS summary would be as follows:
Opening Stock | Closing Stock | Actual Usage | Outlet Sales | Actual COGS% |
500 x £1 | 690 x £1 | (500 + 300 - 690) x £1 | 100 x (£4 x 90%) | £110 ÷ £360 x 100(%) |
£500 | £690 | £110 | £360 | 30.55% |
COS% vs Cumulative COS%
This graph displays COS% for the chosen date period by date against the Cumulative COS% for the same date period.
Fig.3 – COS% vs Cumulative COS%
There is a pop-up report on the right side of the graph that displays the COS value against the Cumulative COS value for the filtered date period.
Fig.4 – COS vs Cumulative COS
Cumulative Week-To-Date COS%
This report shows the cumulative week-to-date values of the metrics from Fig.1 for the chosen date period. It is hard-coded to display the current week.
Fig.5 – Cumulative Week-To-Date COS% – Value Table
There is also a pop-up report that displays the cumulative week-to-month values of the same metrics.
Fig.6 – Cumulative Week-To-Month COS% – Value Table
Cumulative By Date COS%
This report shows the cumulative-by-date values of the metrics from Fig.1 for the chosen time period. It is based on the filtered date range.
Fig.7 – Cumulative By Date COS% – Value Table
Usage % by Property – Value
This table displays the same transactions as Fig.1 and categorises data by Property (default listing in alphabetical order). The total figures are at the bottom of the table, which should correspond to the figures in the banner at the top of the Cost of Sales tab (Fig.1).
Fig.8 – Usage % by Property – Value Table
Usage % by Outlet – Value
This table displays the same transactions as the above table but categorises the results by 'Cost Category' and 'Outlet' (default listing in alphabetical order).
Fig.9 – Usage % by Outlet – Value Table
There is a pop-up report at the top right side of the table, showing the 10 Outlets with the highest COS% for the chosen date period.
Fig.10 – Top 10 Outlets by COS% – Value Graph
Usage % by Cost Category - Value
This table displays the same transactions as the table above, but instead categorises the results by Cost Category (default listing in alphabetical order).
Fig.11 – Usage % by Cost Category – Value Table
Further drilling through 'Date' is available if Property or Cost Category is selected.
Fig.12 – Drill through Date in Usage % by Cost Category – Value Table
This example scenario outlines how to understand which Outlets have the highest COS, and where there may be opportunities to improve this in terms of stock management using the graphs and dashboards outlined above.
- Select the required date period using the Date Dimension (BusinessDay) filter
- Within the 'Property Details' filters, set the Property or Outlet filter(s) as required
- Review the COS% headline figure on the top left of the tab to understand the total figure for the Properties/Outlets being viewed
- If viewing more than one Property, Outlets can be compared to their respective Property totals using the 'Usage % by Property – Value' table
- Use the 'Usage % by Outlet – Value' tables to understand if any stock adjustments in particular Outlets may be contributing to the higher COS
- From the 'Top 10 Outlets by COS% – Value', note those which are the worst performers
- Use the 'Usage % by Cost Category – Value' table to drill down further by cost category and see values for a cost category by date
Comments
0 comments
Please sign in to leave a comment.