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