Work Orders List

The data model includes measures such as the ratio of planned time to actual quantity and planned quantity to actual quantity for work orders. It also covers metrics like the quantity of rejected, completed, and checked items, along with measures related to run time and setup time—both actual and expected. Views provide insights into materials breakdown, operations performed, and products involved in the work order process, aiming at performance evaluation through aggregated quantities and operational metrics per work order.

Benefits of This Data Model

• Enhanced Performance Evaluation: The data model provides insights into work order performance through metrics such as the ratio of planned time to actual quantity and planned quantity to actual quantity, allowing for a more in-depth evaluation of operational efficiency.
• Cost Analysis Optimization: By offering a breakdown of materials used in work orders and their associated costs, the model enables more accurate cost analysis and optimization strategies.
• Operational Efficiency Tracking: With metrics on run time and setup time—both actual and expected—operations can be closely monitored and optimized for improved efficiency.
• Detailed Work Order Management: The model includes detailed information on work orders, such as quantity of rejected, completed, and checked items, enabling precise tracking and management for better decision-making.

Key Performance Indicators (KPIs)

• Quantity Rejected: The total quantity of items or products rejected during the work order process.
• WO Planned Time / Actual Quantity: Ratio of planned time to actual quantity for the work order.
• WO Planned Quantity / Actual Quantity: Ratio of planned quantity to actual quantity for the work order.
• Quantity Planned: The total quantity of items or products planned for the work order.
• Quantity Completed: The total quantity of items or products completed during the work order.
• Quantity Checked: The total quantity of items or products checked or inspected during the work order.
• Run Time Actual: The actual run time taken to complete the work order.
• Setup Time Actual: The actual setup time taken before starting the work order.
• Run Time Expected: The expected or planned run time for the work order.
• Setup Time Expected: The expected or planned setup time before starting the work order.
• Number Items: Total number of unique items involved in the work order process.
• Number Operations: Total number of operations required to complete the work order.
• Number Materials: Total number of unique materials used in the work order.

Available Visualizations

View Name	Description
3 - Materials	Provides a breakdown of materials used in work orders for cost analysis.
4 - Operations	Displays the various operations performed in work orders with time metrics.
2 - Products	Shows the products involved in work orders and their performance metrics.
Quantity by Company	Aggregates work order quantities by company for performance evaluation.
Number of Op, account, mat	Analyzes the number of operations, accounts, and materials per work order.
1 - Work Orders	Lists all work orders with details for tracking and management purposes.