Overview
This article shows how the information on the Flash COS (Purchases) tab is displayed and calculated.
The Flash COS (Purchases) 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-hand side of the banner displays the 'Purchases' and 'Transfers' figures in monetary terms. In the centre, the cost of sales ('COS') is shown in monetary terms (calculated based on Purchases plus Transfers). This figure is used to calculate the COS percentage.
Cost of sales as a percentage ('COS%') is shown on the far right side, with 'Outlet Sales' revenue (all sales submitted by EPOS), displayed to its left.
Fig.2 – Figures in Banner at Top of Tab
Field Name | Description |
Purchases | Value of total purchases for the period |
Transfers | Net movements of transfers into/out of the Properties during the stock period. When all Properties in a Company are selected to display, the net 'Transfers' value should be zero. If particular Locations are filtered, 'Transfers' may be a negative or a positive value. |
Cost of Sales (COS) | Purchases plus transfers |
Outlet Sales | The 'Outlet Sales' value includes all sales submitted by EPOS (i.e. matched and unmatched PLUs) |
COS% | ('Purchases' + 'Transfers') ÷ 'Outlet Sales' value |
Example
During a period, in a particular Property, if there are total purchases of £81,436 and total transfers are £1,322 for all Cost Categories, then the Cost of Sales will be £82,758.
If the total Outlet Sales equals £264,739, the COS% will round to 31.26%.
Purchases | Transfers | COS | Outlet Sales Value | COS% |
£81,436 | £1,322 | £81,436 + £1,322 | £264,739 | to (£81,436 + £1,322) ÷ £264,739 |
£82,758 | 31.26% |
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 which 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 be 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 date period.
Fig.7 – Cumulative By Date COS%– Value Table
Usage % by Property – Value
This table displays the same transactions as in Fig.1 and categorises the data by Property (default listing in alphabetical order). The total figures are at the bottom of the table, which correspond to the figures in the banner at the top of the Flash COS (Purchases) tab (also Fig.1).
Fig.8 – Usage % by Property – Value Table
Usage % by Outlet – Value
This table displays the same metrics 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. This report shows 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 down by 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 Cost of Sales, 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.