Rayyan - Costing overview

Introduction

The dashboarding will show the profitability per item per segment. Considering the overhead expenditure captured on the GL accounts inside Sage Evolution.

With the default reports inside Sage, you are able to quickly view the Gross profit per item, but it will not show you the nett profit per Item. This dashboards takes the expenditure from the various departments and allocates these accordingly to the items.

By entering settings on both Item UDF's and Account UDF's the dashboard will pick up both to display and use for calculations.

Dashboards

Two dashboards are available for viewing the profitability:

1) Costing overview 

Main dashboard that contains all the logic and calculations to display the profitability per item per segment.

2) Sales detail

Detail dashboard containing the individual invoices for reconciliation purposes. (Note that the sales data is also available in the Costing overview, however it is loaded consolidated to limit the amount of data)

Costing overview

Main dashboard that contains all the logic and calculations to display the profitability per item per segment.

To come to a net profit the following expenditures are included in the calculations:

1) Weighted average unit cost (Coming directly from Sage and is calculated and maintained in Sage)

2) Production expenses (expenditure that is not included in the Weighted average unit of Sage, these costs are booked to GL accounts)

3) Logistics expenses (expenditure that is not included in the Weighted average unit of Sage, these costs are booked to GL accounts)

4) Sales expenses (expenditure that is not included in the Weighted average unit of Sage, these costs are booked to GL accounts)

5) Sales rebates (rebates that are not included in the Weighted average unit of Sage, these costs are booked to GL accounts)

6) Marketing expenses (rebates that are not included in the Weighted average unit of Sage, these costs are booked to GL accounts)

7) IT & Administration expenses (rebates that are not included in the Weighted average unit of Sage, these costs are booked to GL accounts)

8) Discounts on sales  (Differences between the standard selling price and the actuals invoice unit price)

9) Free of charge (FOC) items  (Direct expenses due to FOC items on invoices)

By allocating all these costs a net profit % is calculated in the dashboard.

Sage configurations

In order for the report to pick up items and expenditure the following UDF's need to be filled in Sage

On Account

ulGLAccGroup

Determines in what section of expenditure the account should be included.

Options: Admin & IT; Catering; Logistics; Marketing; Production; Sales; Sales - Rebates

ulGLGroupType

Determines if the accounts is categorized as fixed or variable (Note that are no calculation differences based on this field, just grouping/categorisation.)

Options: Fixed; Variable

ulGLCriteria     

Determines how the expenditure should be allocated to the various segments.

Options: Budget; Direct; Litre; Packs; Pcs;

ucGLLineSegment

Determines how the balance for the ulGLCriteria option direct should be allocated.

Options: TEXT VALUE I.E.: L1-50;L2-50

Note that this field is ignored if the ulGLCriteria  is not direct.

ucGLChannelSegment

Determines how the balance for the ulGLCriteria option direct should be allocated.

Options: TEXT VALUE I.E.: KA-100

Note that this field is ignored if the ulGLCriteria  is not direct.

ulGLWarehouse

Determines how the balance for the ulGLCriteria option Litres/packs should be allocated.

Options: SDW; SDWII; both

Based on the selected option it includes/exclude sales made via the SDW or SDWII in the percentage of total litres/packs sold.

This field corresponds with the value SalesRep.Bank_Account on the invoice.

ulGLBudgetCalculationOption

Determines how the balance for the ulGLCriteria option budget should be allocated.

Options: Packs; Litres: Bottles; Value

The budgets are stored in the table called _as_RayyanBudgets. This table contains a per month per item budget for the indicated options

On Item

ulIIItemType

Determines they type of the item. If selected either of the 2 options below, the item will be includes in the report and in all calculations

Options: Rayyan; Private label

ufIIPACKLTR

Determines total litres in 1 pack

Options: Float number

uiIIPCSPERPACK

Determines the total pieces per pack

Options: Float number

On Manufactures

ulMANULineSegment

Determines the line for the specific manufacture

Options: Float number

On Invoice

SalesRep.Address3

All invoices are linked to a Salesrep. The Address3 field determines to what segment the sales is considered.

This value is needed to allocate the costs when the option Litre,Pc,Packs

SalesRep.Bank_Account

All invoices are linked to a Salesrep. The Address3 field determines to what segment the sales is considered.

Pages

1) Production expenses

2) Logistics expenses

3 - A) Sales expenses

3 - B) Sales expenses - Rebates

4) Marketing expenses

5) IT & administration

7) Costing and pricing overview

8a) Performance overview - per SKU

8b) Performance overview - per channel

9) Budget overview

10) Sales & Production overview

11) Stock % per Line

Sales detail

1) Sales detail

TO DO

Check PCS on Production vs Packs on Logistics