Search our Help.

BI Foundation

Follow
ON THIS PAGE

Purchases
Inventory
Production/Assemblies
Sales
Customers

 

BI Foundation is the free version of the Business Intelligence (BI) module available to all subscribers and provides key KPIs with time comparison charts on the Production, Sales and Customer pages.

Purchases

The Purchases context page provides you with 6 KPIs and 3 visualizations related to Purchases. On this page we do not compare values over 2 periods and also do not have any change panels as the main focus is on the current status of purchase orders. We, however, do have the easy date buttons to enable you to easily check the values for Month to Date (Default), Quarter to date, Year to date, Last month, and Last quarter.  The 6 KPI tiles at the top of the page are:

  • Created purchase order value with the count of the number of transactions.
  • Open purchase order value with the count of the number of transactions.
  • Completed purchase order value with the count of the number of transactions.
  • Order cost and cost to order ratio.
  • Average delivery duration in days. (Calculating the number of days between date order was placed and the date the product/order was receipted/completed. For example, we placed the order on the 16th of the month and received the product/order on the 20th, so the duration is 4 days)
  • Supplier return value with the count of the number of return transactions.

The "Explore more >" links below each KPI will take you to BI Vision for Purchases if you subscribe to BI Vision.

Underneath these KPIs, you will find a timeline chart showing you the Value of purchase orders created for the period selected, with an indication of the current status. Hovering over the bar you can see the value of orders created on the specific day/month. (Tip: remember the grid view is available on all visualisation if you want to see the list of values per day/month.)

 

You can also toggle labels on or off for this graph to only show PO values linked to selected statuses only.

 

Below this timeline chart, we are looking at the most important status for Purchase orders "Open". This "Open order value by status" view, will display the value of all orders per open status which includes "Costed", "Parked", "Placed", "Receipted" and "Unapproved".  We also provide a table grouping these open purchase orders into age groups indicating the number of days they are in an open status. 

  1. How many orders were created last month and what is the value of them
  2. How many orders are Open and what is the value and status of all those Open purchase orders in my account?
  3. Do I have any purchase orders open for more than 90 days and what is the value of them?
  4. On average what is the expected delivery duration/lead time for all of my products receipted?

Inventory

The Inventory page shows your KPIs related to stock, including costs and average days to sell. The Inventory context page has 5 KPI tiles showing the current (now) values for:

  • Stock on Hand value. 
  • Allocated Stock value.
  • Available Stock value.
  • Open Purchase Order Cost. (Landed Cost value where PO status = Placed)
  • Average Days to Sell.  

Underneath these 5 KPI tiles, we also provide you with one, time series chart showing Stock on hand value per day (if we only have data for the last 3 months) and Monthly values up to 12 months if we have more than 3 months of data. (Blow example is an account with more than 12 months of SOH data so we display the values as at the 1st of each month with the latest value based on the last Stock transaction recorded 7/09/2020 as at 14/09/2020.)

With these KPIs, you will be able to easily answer Inventory-related questions such as: 

  • What is the current value of my Inventory/stock on hand and how did it change over the last few months?
  • What is the value of my stock currently allocated (to open sales orders, assemblies or stock transfers)?
  • What is my available stock to sell (not allocated to any transactions.)
  • What is the value of my stock on order, still to be received?
  • Based on prior sales and inventory history, what are the estimated average days to sell my current inventory?

 

(Remember the zoom-in feature available to select a specific date range on the time series charts to look at SOH values at a specific point in time)

Selecting Explore more> or clicking on the Vision tab will take you to more visuals related to Inventory but only if you subscribed to BI Vision. (For beta testing this will be included at no charge.)

 

Production/Assemblies

With BI Production we display KPIs related to Completed Assemblies only. Similar to the design and layout of BI Sales and BI Customers we give you comparison tiles/cards and timeline charts below each of them.

These KPIs and values are for Assemblies only, therefore, exclude Disassemblies.

The default date selection for this page is Month to Date, similar to the other contexts with date selection available.

mceclip0.png

The KPIs and change panels (comparing Current and Prior periods) for Production are:

  1. Total Assembly Cost (The sum of the cost of the assemblies plus any additional supplier costs for the period.)
  2. Completed Assemblies (Number of Assemblies completed for the period selected.)
  3. Avg. Cost per Assembly (For the period selected this is the average cost per assembly including additional supplier costs.)
  4. On-time Assembly. (Calculating the average days between Assemble By Date and Assembly Date for all assemblies completed in the period to determine if assemblies were on average completed Early, On-time, or Late. If, on average assemblies were done before the Assemble by date then the value in days will display negative days on the timeline chart.)
  5. Wastage as % of Assemblies (Cost of waste / the cost of completed assemblies.)

The timeline charts are comparing Current period values with Prior period values, they are:

  1. Total Assembly Cost: Comparing the total cost of assemblies completed over 2 periods based on the date selection.
  2. Completed Assemblies: Comparing the number of assemblies completed over 2 periods based on the date selection.
  3. Avg. Cost per Assembly: Comparing the average cost per assembly completed over 2 periods based on the date selection.
  4. On-time Assembly: Comparing the average days late or early over 2 periods.
  5. Wastage as % of Assembly Value: Comparing the cost of wastage as a percentage of total assembly cost over 2 periods.

Navigating to BI Vision using the “Explore more >” link under any of the 10 visualizations or by clicking on the Vision tab.

Sales

The Sales context page shows you KPIs which compares the current sales figures with prior sales. The default view for all KPIs is the current month-to-date sales figures compared with the same period of the prior month.

 

Sales revenue values are calculated as follow and are exclusive of tax:
 

Sum of Invoiced only or Invoiced and completed Sales orders, including charges, for the period selected minus credits(Credits linked to Sales Invoices and Free Credits)

Eg. Invoiced Sales Revenue including charges minus credits displayed on the KPI tile = 394 000, the calculation of this value:

Sum of invoiced sales orders, using invoiced date: 444 000 + Order Charges: 5 000 - Sales credits: 55 000

Sales Revenue = (Completed Invoices + Order Charges - All Credits) 

NOTE: On the Classic dashboard, we also display a value for Sales Revenue which will be different from Sales Revenue in BI. This value is the sum of all Sales orders Completed for the period including charges and does not take credits into account.

The KPI tiles available for BI Sales are: Sales revenue; Gross profit; Gross profit %; Sales order count and Average revenue per sales order.

With these KPIs, you will be able to easily answer sales-related questions such as:

  1. What was my sales revenue and gross profit for:
    • Last completed month compared to the prior completed month? (Using "Last Month" date selection.)
    • Last completed quarter compared to the prior completed quarter? (Using "Last quarter" date selection.)
    • Last completed financial year compared to the year before? (Using "Last Year" date selection.)
    • The current month to date compared to the prior month?
    • The current quarter to date compared with the prior quarter?
    • The current financial year to date compared to the prior fiscal year?
  2. What is/was my gross profit % compare to prior periods?
  3. What is/was the number of sales orders for the selected period compared to the prior period.
  4. What is/was my average revenue per Sales order.

Customers

The Customers context page shows your KPIs related to your customers. These are:

  • Total Customers
  • New Customers
  • Active Customers
  • Average orders per customer
  • Average revenue per customer

With these KPIs, you will be able to easily answer Customer-related questions such as:

  1. How many customers (not obsolete) do I have in Unleashed?
  2. How many of them are new for the period selected?
  3. How many customers have placed sales orders for the period selected?
    1. What are the average orders per active customer and
    2. What is the average sales revenue per active customer for the period selected?

 

Follow this link to view BI KPIs with tooltips and calculations. BI KPIs with tooltips and calculations

 

Take me to: BI Vision (pay-to-use module)

 

Was this article helpful?
0 out of 0 found this helpful