...
7) Costing and pricing overview
This overview will create a profitability percentage per item while having the flexibility to change the report with the multiple buttons/options.
| Calculation | Explanation |
|---|---|
| Standard price per pack | Standard sales price used as starting cost for deducting all the other expenditures. This price is picked up from Pricelist 1 from Sage. |
Cost of material
| The two unit prices are displayed, while only using the Average Unit cost for the calculations. The Average Unit cost will be used to be deducted from the Standard price. |
Sales | |
8a) Performance overview - per SKU
8b) Performance overview - per channel
9) Budget overview
10) Sales & Production overview
11) Stock % per Line
Sales detail
This dashboard is made for reconciliation purposes. While the sales data is loaded group per day in the main dashboard, here it will be loaded per invoice, making it easier to trace inside Sage.
The matrix on the dashboard can be drilled down with the UI tools (right click or by using the drilldown menu) to show the data on invoice level.
Per month the following information is available: Litres sold, Sales, COGS,Discount.
These figure will correspond with the sales data from the Main dashboard.
By using the filter in the bottom right corner, the figures for FOC can be displayed and viewed (which are used for the FOC section in report 7 and 8)
TO DO
Check PCS on Production vs Packs on Logistics