The Work Hour Analysis page in ProdSys is a powerful tool used to compare the actual consumption of work hours against the calculated or estimated hours for various orders, stations, products, and customers. This page helps you monitor efficiency, track time usage, and identify discrepancies between expected and actual work hours. It also supports grouping to allow for detailed breakdowns across different categories.
Step 1: Access the Work Hour Analysis Page
Log in to ProdSys: Begin by logging into your ProdSys account using your username and password.
Navigate to the Work Hour Analysis Page: From the main menu, go to "Calculation" and select "Work Hour Analysis." This will open a table that displays data on work hours associated with different orders, stations, products, or customers.
https://app.prodsys.com/#/calculations/post-calculation-analyze
Step 2: Set Filters and Grouping Options
Choose a Date Range: At the top of the page, select the date range for which you want to view the analysis. You can choose preset options such as "Last Month," "Last Year," or customize the date range by selecting the start and end dates.
Filter by Categories: Use the filter fields above the columns to narrow down the data by specific criteria such as Order Number, Customer, Category, or Station.
Group by Category: Drag the column header (e.g., Station, Product, Customer) into the “Group” section at the top of the table to group data. Grouping allows you to view summarized totals and breakdowns for each category, making it easier to analyze the data for specific areas.
Step 3: Analyze Work Hour Data
Understand Key Fields:
Order No: The specific order associated with the work hours.
Station: The workstation or department where the work was performed.
Customer: The customer associated with the order.
Estimated Hours: The number of work hours originally calculated for the order or task.
Actual Hours: The actual number of work hours logged by employees for the task.
Deviation Hours: The difference between the estimated and actual hours.
Deviation Percentage: The percentage difference between the estimated and actual work hours.
Compare Estimated vs Actual Hours:
Use the "Estimated Hours" and "Actual Hours" columns to see how well the tasks matched their original time estimates.
Deviation Hours and Deviation Percentage highlight areas where there was a significant over or underuse of time. This is crucial for identifying inefficiencies or better-than-expected performance.
Track Trends:
Look for tasks or stations that consistently show deviations. This will help you identify recurring issues in certain workstations, customers, or projects.
Pay attention to orders with major discrepancies in time usage, as this could indicate errors in estimation, process bottlenecks, or inefficiencies.
Step 4: Adjust Layout and Customize Columns
Column Chooser: Click on the column chooser icon in the action menu to add or remove columns based on the data you want to see. For example, you can add columns for "Estimated Hours per Qty" and "Actual Hours per Qty" to get a clearer understanding of time usage per unit.
Save Layouts: Once you have customized the layout and columns, you can save this layout for future use. This feature allows you to quickly return to your preferred view without having to reconfigure the settings each time.
Step 5: Group Data for Deeper Analysis
Group by Different Categories:
Drag and drop the columns such as "Customer," "Station," "Order No," or "Product" to the grouping section to analyze the work hours based on these categories.
For example, grouping by Station helps you evaluate how efficiently different workstations are performing, while grouping by Customer gives you insights into time consumption for each client.
Review Totals: When grouped, the form will display totals for "Estimated Hours," "Actual Hours," and deviations at the group level. This helps you quickly assess the overall performance within a group.
Step 6: Export Data for Reporting
Export to Excel or PDF: If you need to share the work hour analysis or perform further analysis outside of ProdSys, use the "Export" button in the action menu in the top right corner to download the data in Excel or CSV format.
Custom Reports: Use the exported data to create custom reports for meetings, audits, or project reviews. Grouped and filtered data will be reflected in the export, making it easy to present the insights to others.
Step 7: Take Action Based on Insights
Identify Underperforming Stations or Orders: Use the data to identify stations, tasks, or orders that consistently underperform or overuse work hours. Investigate these areas to understand the cause of the deviation and make necessary adjustments.
Adjust Time Estimates: For future projects, use the insights from the analysis to make more accurate time estimates. If certain types of tasks always require more time than estimated, adjust the planning process to reflect this.
Improve Time Management: Analyze time consumption to improve resource allocation, reduce overtime, and ensure balanced workloads across different departments.
Conclusion
The Work Hour Analysis page in ProdSys is a vital tool for tracking and analyzing time usage across various projects, customers, and stations. By comparing actual work hours to estimated hours, grouping data by relevant categories, and taking action based on insights, you can improve time management, increase efficiency, and better plan for future projects.