Manager Dashboards

Manager Menu

Precondition: To open the Manager dashboards menu select Manager from the main menu

The Manager dashboards menu is opened.

Figure 1: Manager dashboards

Deviation Overview

Precondition: To open the Deviations Overview dashboard select:

Main Menu/Manager/Deviations Overview
- The Deviations overview dashboard is opened

Purpose: Dashboard shows charts and graphics for different deviations related to orders, alarms, and machines OEE.

Figure 2: Deviation overview dashboard

Orders ending in selected period with OTD Deviations

The panel presents information about orders with OTD deviations and planned stop date in the selected time interval.

Figure 3: Deviation overview - Orders ending in selected period with OTD deviations

At the left is shown the number of Work Orders with Plan Stop date in the selected time interval with negative OTD deviations.

The list of work orders with Plan Stop date in the selected time interval and some deviations (positive or negative) shows: Work order number, Customer, Plan stop date, Actual Stop date, Closed (Y or N), OTD (as number of days), Pos With Delay(number of parts/positions with delay).

If OTD is colored in red means the number of days delayed, if OTD is colored in green means the number of days order finished before planned stop date.

Figure 4: Deviation overview - percentage of orders with OTD=N

Under the number of work orders with deviations is shown the percentage of work orders with deviations with formula – (Orders with OTD=N) / (Total orders planned to end in the period, including orders without deviations)

To Work orders OTD calculation

OTD percentage over 180 days

Figure 5: Deviation overview - OTD percentage over 180 days

The graphic shows min, max and average values of OTD percentage of work orders opened or closed during the week, grouped by weeks for the last 180 days.

Order parts with cost deviations

The panel presents information about order parts with positive cost deviation for the selected time interval (for example Last 7 days). Cost deviation is calculated as a deviation in hours multiplied by cost per hour.

To calculation of Parts Cost Deviations

At the left is shown the number of parts with positive cost deviation at the last day from the selected time period.

The upper graphic also shows the number of parts with positive cost deviation for the selected time interval. The values are per day.

The second graphic shows cost deviations by days and last values (NOK) for different orders with parts with cost deviations for the selected time interval. The values are per day.

Figure 6: Deviation overview - Order parts with cost deviation

In the table at the right of the graphics are shown the latest values of positive cost deviations for different parts and orders for the selected time interval. In the table are listed: Date, number of part, number of work order and deviation (like kr59.66K).

Order parts with negative cost deviations

The panel presents information about order parts with negatibve cost deviation for the selected time interval (for example Last 7 days). Cost deviation is calculated as a deviation in hours multiplied by 650 NOK per hour.

To calculation of Parts Cost Deviations

At the left is shown the number of parts with negative cost deviation at the last day from the selected time period.

The upper graphic also shows the number of parts with negative cost deviation for the selected time interval. The values are per day.

The second graphic shows cost deviations by days and last values (NOK) for different orders with parts with cost deviations for the selected time interval. The values are per day.

Figure 7: Deviation overview - Order parts with negative cost deviation

In the table at the right of the graphics are shown the latest values of negative cost deviations for different parts and orders for the selected time interval. In the table are listed: Date, number of work order, part number and deviation (like kr59.66K).

Orders with remaining work deviation

The panel presents information about orders with actual remaining work greater than the estimated remaining work.

To calculation of Order Actual remaining work

Figure 8: Deviation overview - Orders with remaining work deviation

At the left is shown the number of orders with more remaining work than estimated for the last day from the selected time period.

The top graphic also shows the number of orders with positive work deviation by days for the selected time period.

The bottom graphic shows percentage of work deviations (difference between actual and estimated remaining work) of orders by days for the selected time interval.

In the table at the right are listed the latest values for the selected time interval: date, order, and percentage of work deviation.

The remaining work deviation(difference between actual and estimated remaining work) equal to 100% means that the order end date passed, but still nothing is produced. The Remaining work deviation is calculated when the order stop date is passed.

Orders with part scrap above 10%

The panel presents information about orders with part scrap above 10% for the selected time interval.

To calculation of parts scrap percentage

Figure 9: Deviation overview - Orders with part scrap above 10%

At the left is shown the number of orders with part scrap above 10%. The number is for the last day of the selected period.

The top graphic shows the number of orders with part scrap above 10%. The values are per day.

The bottom graphic shows percentage of part scrap for orders greater than 10%. The values are per day.

In the table at the right are shown by dates, part number, work order and scrap parts percentage. The values are the last for the selected period.

Orders with OEE below 80%

The panel presents information about work orders with OEE below 80% for the selected time intervals.

To Work orders OEE definition and calculation

Figure 10: Deviation overview - Orders with OEE below 80%

At the left is shown the number of work orders with OEE below 80% at the last day from the selected time interval.

Top graphic shows the number of work orders with OEE below 80% by days for the selected time interval. The values are per day.

The bottom graphic shows work orders OEE percentages for the selected time interval. The values are per day.

In the table at right are listed by dates: order numbers and OEE percentage of the orders which are below 80%.

Active alarms

The panel presents the information for the number and list of current active alarms.

Figure 11: Deviation overview -Active alarms

At the left is shown the number of the current active alarms from all machines in the factory.

The top graphic presents the number of active alarms per day during the selected time interval.

The bottom graphic presents the number of alarms by machines and days from the selected time interval.

The table at right presents the list of the current active alarms by: Active since, Machine, Alarm.

To Alarms dashboard

Machines with OEE below 80%

The panel presents information about machines with OEE below 80% for the selected time interval.

To Machine OEE definition and calculation

Figure 12: Deviation overview - Machines with OEE below 80%

At the left is shown the number of machines with OEE below 80% ** on the last day** from the selected time interval.

The top graphics shows the number of machines with OEE below 80% per day for the selected time interval. The values are per day.

The bottom graphics shows for each machine OEE% per days for the selected time interval. The values are per day.

In the table at right are listed by dates: machine numbers and OEE percentage of the machines with OEE below 80%.

Factory OEE

Precondition: To open the Factory OEE dashboard select:

Manager/Factory OEE
- The Factory OEE dashboard is opened

Purpose: Factory OEE dashboard shows average machines OEE for the selected time interval. Machine OEE is calculated every hour.

Figure 13: Factory OEE dashboard

From the Factory OEE dashboard users can:

View each machine OEE for the selected time interval

Filter machines and check OEE by departments or type of machines or team

For each machine easily can open machine's OEE details dashboard

Filtering machines in the Factory OEE is possible by:

Department
Machine Type
Team

For selected machine is possible to open Machine OEE dashboard

Reports

Precondition: To open The Reports dashboard select:

Manager/Reports
- The Reports dashboard is opened

Purpose: Three types of reports are available. Data for the reports are imported from the EPR SAP Business 1.

Figure 14: Reports dashboard - paused reports

Preparing reports:

After opening the page, if service is Paused, click on the Start button. Information starts updating each 5 sec.

There is scheduled time (UTC) for pausing the service, if not click on the Stop button.

Figure 15: Reports dashboard - running reports

To open some report, there should be fulfilled both:

the Embedded Capacity : Running
Reports status: Completed

Then click to open some report.

Deliveries Report

Click on the Deliveries Report button:

The Deliveries according to plan report is opened

Using Deliveries Report user can receive the information for the selected time period:

The number of operations delayed from the plan by dates.

The number of operations delayed from the plan by departments and dates.

The pie chart with delayed operations and percentage by department.

The chart operations per dates - delayed oprerations by departments and dates.

Deliveries Report 1st page

This page of the report shows deliveries by departments for the selected time period.

Figure 16: Reports dashboard - Deliveries report - 1st page

By default data are loaded for the last 7 days (1). The period is possible to filter by:

Last, Next, This;
Enter the number;
Days, Weeks, Weeks (Calendar), Months, Months (Calendar), Years, Years(Calendar)

The column at the left shows by dates, the aggregated number of operations with delays for all departments.

The table with dates for the selected time period by departments. For each date and department is shown the number of delayed operations.

Pie chart Delay by Department shows the number of delayed operations and percentge by department. It is possible to filter by department.

Delayed operations time line.

For each department is presented line chart delayed operations per dates. It is possible to filter by department.

From Delayed operations time line by right-clicking on the line for department appears menu Drill through. Clicking on the menu appears menu Department Delayed Operations. Select the menu.

The second page of the report is opened

Deliveries Report 2nd page

Figure 17: Reports dashboard - Deliveries report - 2nd page

This page shows delayed operations for selected from page 1 department.

There is a filter by customer(s) and can filter the table for the selected customer(s
For the selected customer(s) or All are listed in the table Department delayed operations:
- Order number, Customer, Position, Part name, Part number,Delay(number of delayed operations).
At the top right for the selected customer(s)or All is displayed doughnut chart Delayed operations by Customer.
At the bottom right for the selected customer(s) or All is displayed doughnut chart Delayed Operation by Part.

OTD Report

Click on the OTD Report button:

The OTD Report is opened

Using OTD report user can receive the information for the selected time period:

The percentage of Work Orders by Customers.

Total OTD percentage - on time delivered orders to total orders with planned stop date in the selected period.

The number of Work order delivered on time.

The table with work orders and customers with planned stop in the selected time period with their OTD delays (positive or negative).

Selecting some customer and work order is possible to look at the details about the order positions(parts) OTD delays; total order OTD percentage.

OTD Report 1st page

This page of the report shows the work orders by customers and their OTD days and the total number of orders delivered on time for the selected time period.

Figure 18: Reports dashboard - OTD report - 1st page

On the left side:

There is a filter for the time period by selecting year, quarter, month, week, or day (1).
For the selected time period is shown а pie chart Work Orders by Customer (2). For each customer is shown the number of orders and percentage of work orders.
The pie chart OTD percentage (3) shows the on time delivered orders to all orders for the selected time period.

On the right side:

Total number of orders delivered on time (green number) (5)
Table with information for orders (4): customer, work order number, order planned stop, order actual stop, positions(number of positions in order), OTD (Yes/No), and OTD (days).
On time delivered order colored in green are with OTD (days) negative number or zero. It shows how many days before planned stop has finished the order.
The orders with actual stop date after the planned stop date have OTD (days) positive numbers colored in red.
There are filters (multiple select) by customer(s) and work order(s) for filtering the table.

Right clicking on the table appears menu Drill through menu. Click on the menu is opened Workorder OTD menu. Select the menu Workorder OTD.

The page 2 of the report for the selected work order and customer is opened.

Figure 19: Reports dashboard - OTD report - 1st page-drill through selected work order

OTD Report 2nd page

This page of OTD reports shows OTD information for all parts (positions) from the order. Customer name and work order number are listed as the top.

Figure 20: Reports dashboard - OTD report - 2nd page

In the table are listed on different rows for each position (part) of the order: WO(work order number), Position(number), part number, part name, part planned stop, part OTD (Yes or No), part OTD (days). The OTD(days) in red means delays in days for the part, negative number or zero in green means on time delivery before planned stop date for the part.
The pie chart Work order OTD shows Work order OTD percentage by parts = on time delivered parts to all parts.
The bar chart per position and OTD delays (days) for each position(part)

Sales Report

Click on the Sales Report button:

The Sales Report is opened

Using the Sales Report users can receive the information for the selected time period:

Top 5 grossing customers and top 10 grossing parts

Percentage of Sales vs Budget

Turnover value per customer; Turnover chart by dates

New registered sales per customer

Decomposition of a total price by years

Sales Report 1st page

This page of the report shows for the selected time period

Top 5 grossing customers.
Top 10 grossing parts.
Percentage of sales vs budget.

Figure 21: Reports dashboard - Sales report - 1st page

The Time period can be selected by Y (Years), Q(quarter), M(month) and W(week) and selecting in the slider and corresponding numbers.
Top Grossing Customer – on the top are listed 5 top-grossing customers by their names and sales (NOK kr)
Gauge shows percentage Sales vs Planned budget for the selected period. The budget value is taken from the Upkip Administration/Budget. configuration for the corresponding year and months.
Top 10 grossing parts – bar chart for 10 grossing parts (part name and part number) and sales (NOK kr)

Report 2nd page

This page of the report shows for the selected period:

Filter for changing the time period (1)

Figure 22: Reports dashboard - Sales report - 2nd page

Left table shows Turnover per customer in period: Number, customer, Turnover (NOK)
The right table shows New sales registered per customer in period: Number, customer, Turnover (NOK)

At the bottom of both tables are calculated the total of turnover or sales (NOK)

Report 3rd page

This page of the report shows a line chart for Turnover per Date, for the selected time period.

Figure 23: Reports dashboard - Sales report - 3rd page

Report 4th page

This page of the report is used for decomposition of Total Sales by years. Clicking on the plus sign could be selected – Customer, Quarter, Month, Day,Part Name, Part Number, Invoice Number, Part Name, and Number. When Customer has selected, then it can decompose by selected items. etc.

Figure 24: Reports dashboard - Sales report - 4th page

Operator Dashboard

Precondition: To open the Operator dashboard select:

Manager/Operator Dashboard
- The Operator Dashboard is opened

Purpose: The Operator Dashboard presents information about operator’s logged time per day, downtime per operator, and productivity coefficients. There is information for each operator and aggregated information for selected operators.

Data for the operators are imported from SAP Business 1 system into ConfigDB by adapter (sapb1) monitors for changes on each minute. Data are manipulated and presented by graphics and charts.

From Operator Dashboard users with role Manager can see:

For selected operator and selected time interval:
- Total logged time in hours
- Time per machine and downtime
- Logged time per day
- Coefficient Logged time (hours)/shift hours
For all selected operators aggregated information for the selected time interval about:
- Total logged time
- Total logged time per day
- Productivity coefficients for the last 180 days (chart), aggregated by weeks as min, max, and average graphic
- Total coefficient calculated as sum of logged hours divided by logged hours

Figure 31: Operator dashboard

There is possible to select an operator or many operators from the drop-down with numbers of all operators.

Figure 32: Operator dashboard - Operator panels

Total logged time for operator for the selected time interval as value in hours
Pie chart with time per machine in duration (hours/weeks) and percentage of the all logged time
Downtime pie chart
Operator logged time per day (chart)
Coefficient Logged hours/shift hours

At the top of the dashboard, there is a row with aggregated information for all selected operators for the selected time interval.

Figure 33: Operator dashboard - Aggregated information

Total logged time as a sum of all logged times (in hours) of all operators for the selected time interval
Total logged time per day for all days during the selected time interval are shown by bars number of operators and sum of logged hours per day
Productivity coefficients for the last 180 days sum of total logged hours divided by total shift hours for the selected operators, grouped by weeks. There are presented graphics with min, max, and average values for each aggregated point for the week.
Total productivity coefficient calculated as total logged hours for the selected operators divided by total shift hours

At the bottom is presented pie chart Downtime per operator.

Chart shows for all operators for the selected time period percentage of downtime time (only Untagged is included, OK and Unplanned are excluded).

Figure 34: Operator dashboard - Downtime per operator

On mouse over the pie chart are shown: operator number, duration of time, and percentage with downtime tag Untagged.

Operator Worktime

Precondition: To open the Operator Worktime dashboard select:

Manager/Operator Worktime
- The Operator Worktime dashboard is opened

Purpose: Operator Worktime dashboard is accessible only by users with role Manager. The dashboard presents information about selected operator for the selected time interval including some production parameters and KPIs as: logged time as hours, logged time per day, productivity coefficients, average order OEE, time per machine, work orders with OTD.

Data for the operators are imported from SAP Business 1 system into ConfigDB by adapter (sapb1) that monitors for changes on each min. Data are manipulated and presented in user-friendly way.

From Operator Worktime Dashboard users with role Manager can see: For the selected operator and selected time interval:

Total logged time (in hours)

Productivity coefficient calculated as Logged hours divided by shift hours

Average Order OEE (in %)

Time per machine (in duration and percent for each machine used in the selected interval)

List of work orders produced during the period with information for OTD and Closed/Active

Figure 35: Operator Worktime dashboard

Selecting operator is possible from the list with numbers of all operators

The dashboard is loaded with information for the selected operator and selected time interval

All operator parameters are calculated for the selected time interval.

Logged time – summary of logged time
Logged time / shift hours – Logged operator time divided by shift hours
Time per machine – for each machine on which has worked operator is presented as a duration of time and percentage of all logged time of the operator
Logged time per day (hours per day) – of operator for the selected time interval

Figure 36: Operator Worktime dashboard - Logged time per day for operator

Figure 37: Operator Worktime dashboard - Order deviations for operator and selected time interval

Order Deviations – a table with Work Orders list for operator. For each work order are presented information:
- Work Order Number – Clicking on the link with WO number is opened Work Order dashboard with detailed information for work order
- Customer Name - Customer name
- Plan Stop (date) and Actual Stop (date-time) – dates of the work order
- Closed – Y or N (if a work order is closed or not)
- OTD (On Time Delivery). With green or red colors are shown if the order has finished on time or before the planned stop date or has some days delay(red color).
- Pos with Delay – Number of parts(pos) which has delay

Figure 38: Operator Worktime dashboard - table with downtime untagged series data

Downtime – table with information from InfluxDB with time-series data for Downtime Untagged status excluding statuses OK and Unplanned.

Utilization

Precondition: To open the Utilization dashboard select:

As a user with role Manager: Main Menu/Manager/Utilization
As a user with role Supervisor: Main Menu/Supervisor/Utilization
- The Utilization dashboard is opened

Utilization is a percentage of time a machine is reporting an active state (counted statuses Active and Producing).

Downtime is a percentage of time a machine is down, reciprocal to utilization. Machine operators is possible to select a downtime reason that could be analyzed.

From the Utilization dashboard user can see:

The number of hours machines have been producing during a specific work hour and day

The number of hours the machines have been producing during a weekday and month

See the number of downtime events that occurred per department

Utilization chart with the number of hours machines worked per day by departments

Utilization chart with the number of hours machines worked for the last week

Using this dashboard supervisors or managers can make analyses about production in the factory. A utilization rate that consistently approaches 100% indicates that you’re overworking your staff, and it may be time to expand. A utilization rate that is consistently low means there isn’t enough work in the pipeline, too many hours are being wasted on non-billable administrative functions, or it might indicate that your company has too many freelancers on projects. Utilization rates that are consistently too high or too low aren’t good for your organization and typically indicate future risks.

When opening the Utilization dashboard and default time interval is “This week so far”

Figure 25: Utilization dashboard

The first heat map, Total Utilization (by day hours and weekdays) presents the number of hours the machines have been producing (counted Active and Production state) during the hours from the day (0-23) and days (Mon-Sun) of the week.

The darkest color block shows the biggest number of machine active hours. The lightest color block shows the lowest number of the machine hours. The user can look at hourly and weekly data simultaneously and make analyses.

Figure 26: Utilization dashboard - Utilization by hours of day and days of week

The second heat map chart, Total Utilization (by days of week and months of the year)
presents the number of hours the machines have been producing during the days of week and months of the year.

For example: when time interval is Last 1 year, with the darkest color (biggest number of machines hours) are Wednesday from May.

Figure 27: Utilization dashboard - Utilization by days of week and months of year

The 3rd heat map chart presents the number of downtime events per department. For Departments Turning, Milling and Welding user can analyze for which type downtime (related to Man, Machine, Method of work or Materials) there are more events and to do some related actions about production organization.

Figure 28: Utilization dashboard - Downtime events per department

Heatmap charts can be filtered by Team(s), selected from the teams list.

The next Utilization chart presents aggregated hours of active machines per day during the selected time interval (counted statuses Active and Producing).

Figure 29: Utilization dashboard - Aggregated hours of active machines per day

The Utilization (week) shows the number of active machines working at the same time per hour.

Figure 30: Utilization dashboard - number of active machines working at the same time per hour

Utilization by Shift

Precondition: To open the Utilization by shift dashboard select:

Manager/Utilization by shift
- The Utilization by shift dashboard is opened

Purpose: Dashboard shows machine utilization during the shifts for the selected time period (the last 7 days is default).

Machine utilization is a useful time of machine (e.g status Active or Producing) for the period.

For the selected time period user with role Manager can see:

Machine Utilization as a duration of time and percentage for Shift1 or Shift2 (Shifts are assigned to the machine in Upkip Administration Calendars).

Machine timeline chart with statuses, duration and percentage of each status during the shifts.

Machine pie chart with duration, and percentage of Active statuses vs all other statuses.

Summary aggregation pie charts of Utilization vs other statuses during the shifts for the selected team(s).

Figure 39: Utilization by shift dashboard

Filtering is possible by a team or by machine

Figure 40: Filtering by team and machine

For each machine, information is shown in expandable panels.

Figure 41: Timeline chart of machine statuses separated by shifts

For the selected time period for each machine are shown:

Timeline chart with machine statuses for Shift1 and Shift2 (assigned to machine)
For each status has a legend with name, duration, and percentage
Pie chart of Utilization vs all other machine statuses as a duration of time and percentage

Figure 42: Machine pie chart utilization

At the top are shown an aggregation pie chart of all filtered machines Utilization vs all other statuses.

Figure 43: Aggregated Utilization by shifts and teams