Production gauges

Beas dashboards > Using the dashboards > Production Planning dashboard > Production gauges

Top  Previous  Next

On time for shipping in the last 30 days

DASHBO~1_img12

This gauge shows the percentage of work orders which have been finished before or on the end date. This indicator includes only closed work orders by default, and the data range is the last 30 days. This can be changed in the query described in the Positions area.

Data items used

Description

View/Table field

Work orders on time

Count of the closed work orders that have been finished before or on the end date.

Calculated field in dashboard editor:

CountDistinct(Iif([Latest receipt date] <= [End Date], [Work Order], null))

Work Order

Distinct count of all the closed work.

View: BEASV_WORKORDER_POS. [DocEntry]

End date

Scheduled end date of the work orders

View: BEASV_WORKORDER_POS.[EndDate]

Last receipt date

Compares the Last material receipt date and the Last work receipt date and chooses the most recent one.

CASE
            WHEN COALESCE("LastMaterialReceiptDate", "LastWorkReceiptDate") > COALESCE("LastWorkReceiptDate", "LastMaterialReceiptDate")
            THEN COALESCE("LastMaterialReceiptDate","LastWorkReceiptDate")
            ELSE COALESCE("LastWorkReceiptDate","LastMaterialReceiptDate")
        END AS "Latest receipt date"
FROM "BEASV_WORKORDER_POS

Last material receipt date

Last date when a material was received.

View: BEASV_WORKORDER_POS.LastMaterialReceiptDate

Last work receipt date

Last date when work was received.

View: BEASV_WORKORDER_POS.LastWorkReceiptDate

Note: The percentage is calculated setting the value type to percent of target in the gauge. The default conditions for the data range are set in the query.

 

Productivity in the last 30 days

DASHBO~1_img13

This gauge shows the percentage of the actual total work time compared to the total planned work time. This indicator includes only closed work orders and a data range of the last 30 days by default. This can be changed in the query described in the Positions area.

Data items used

Description

View/Table field

Planned Time

Total of the planned time for work in minutes.

View: BEASV_WORKORDER_ ROUTING.PlannedTime

Actual Time

Total of the reported time in minutes.

View: BEASV_WORKORDER_ ROUTING.WORKTIME

Note: The percentage is calculated setting the value type to percent of target in the gauge. The default conditions for the data range are set in the query.

 

Scrap overall in the last 30 days

DASHBO~1_img14

This gauge shows the percentage of the scrap quantity, produced during the operations, compared to the total produced quantity (scrap quantity + yield quantity). This indicator includes only closed work orders and a data range of the last 30 days by default. This can be changed in the query described in Positions area.

Data items used

Description

View/Table field

Total Quantity Produced

Sum of the yield and scrap quantities.

Calculated field in dashboard editor:

[YieldQuantity] + [ScrapQuantity]

Yield Quantity

Sum of the received goods quantity (in BOM unit).

View: BEASV_WORKORDER_ROUTING.QUANTITYGOOD

Scrap Quantity

Sum of the scrap quantity (in BOM unit).

View: BEASV_WORKORDER_ROUTING.QUANTITYSCRAP

Note: The percentage is calculated setting the value type to percent of target in the gauge. The default conditions for the data range are set in the query.


Help URL: https://help.beascloud.com/beas202106/index.html?production_gauges.htm