Reporting

learn from your past to improve the future reporting helps you see how your production really worked, spot trends, and identify areas for improvement by comparing real historical data to your past production plan, you can know how effective your past decision was, make smarter decisions and keep your operations running smoothly what can you see in reporting? you’ll find all reports under the reports section in the main menu depending on your licenses, you can access a range of reports like true 330,331 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type organizing your reports you can group your reports into tabs on the start page for easier access click the plus (+) icon enter a name for your new tab add the reports you want to keep handy helpful features in reporting planeus makes it simple to customize and work with your reports here’s what you can do change time units click the gear icon to adjust how time units appear in your reports (minutes, hours, etc ) show sums click the sum icon to display a row of totals above your report list totals reflect whatever data is visible after applying filters export your reports click the export button in the upper right corner of any report export data as a csv file or save charts as png images pro tip for the best results when exporting to excel, make sure planeus, your operating system, and excel itself are set to the same language what kind of reports are there? here’s how some important reports calculate their results report daily resource availability shows where your resources have too much or too little capacity on each day to use this report, you need to first enable it for the resource under resource master data you also need to set a capacity factor for accurate calculations calculation \text{available capacity} = \bigl( \text{available min } \text{scheduled min } \bigr) \times \text{capacity factor} color codes negative times are shown in red red values over 10 hours are shown in green green for example available capacity 8 hours already scheduled 1 hour capacity factor 4 (8 1) \times 4 = 28 \quad \\\\\\\ \text{total capacity} = 8 \times 4 = 32 report schedule adherence (historical) helps track whether work was completed on time for order items measures the date an order was marked “completed” against its planned delivery date → if finished early, the deviation will be in 0 for work steps measures the completion date against the planned end date tolerance settings in docid\ mcscw6cemmikvg wspxzv , you can define a time tolerance (in hours) orders or work steps completed within this tolerance are marked “on time ” the deviation value remains unchanged, but green green = on time red red = late report process efficiency (historical) compares the total run time of all work steps with the total run time of the full production order report capacity utilization (historical) this report is based on the actual data collected from workbench in this report, there are three options to measure utilization 24 hour basis (default) compares actual hours worked each day against 24 hours for weeks, total hours divided by (24 x 7) available capacities uses each resource’s defined shift plans absolute hours shows raw hour totals instead of percentages for example true 330,331 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type using the different calculation methods, here’s how the values compare true 3 165,165,165,166center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type center unhandled content type for june 2 (shift plan = 12 hours) 10/24 = 41% utilization (24 hour method) 10/12 = 83% utilization (shift plan method) true 165,165,165,166 unhandled content type center unhandled content type center unhandled content type center unhandled content type unhandled content type center unhandled content type center unhandled content type center unhandled content type unhandled content type center unhandled content type center unhandled content type center unhandled content type unhandled content type center unhandled content type center unhandled content type center unhandled content type unhandled content type center unhandled content type center unhandled content type center unhandled content type the calculation for available capacity comes from the resource’s pre defined capacity plan (shift plan) if a resource has a 12 hour shift, that becomes the capacity baseline for percentage calculations the report shown in chart form available capacities overall equipment effectiveness (oee) oee ist immer eine historische betrachtung der daten oee = verfügbarkeitsfaktor x leistungsfaktor x qualitätsfaktor der verfügbarkeitsfaktor betrachtet die nutzung (zeit) der leistungsfaktor betrachtet die ausbringungsrate (menge) der qualitätsfaktor betrachtet die qualitätsgüte im menüpunkt docid\ mcscw6cemmikvg wspxzv können verschiedene optionen für die berechnung eingestellt werden overall equipment effectiveness (oee) oee (overall equipment effectiveness) is a way to analyze past performance and see how efficiently your machines or resources were used it’s calculated as oee = \text{availability factor} × \text{performance factor} × \text{quality factor} availability factor (time utilization) you can choose between two ways to calculate available capacity option 1 — gross available c apacity (24/7) assumes your resource is available 100% of the time , 24 hours a day, 7 days a week does not subtract downtime like gaps, holidays, or planned maintenance option 2 — net available capacity starts with the full 24 hours per day, then subtracts downtime from capacity plans public holidays non informative gaps (planned but minor downtimes) \textbf{availability factor} \= \dfrac{ \raisebox{5pt}{\text{operating time}} }{ \text{available capacity}\rule{0pt}{13pt} } where operating time = available capacity (from option 1 or 2) minus downtime from disruptions performance factor (speed of production) tells you how efficiently your resource was running in terms of speed and output calculation \begin{array}{r l} & \text{yield time} \\\\ \+ & \text{setup time} \\\\ \ & \text{downtime from disruptions} \\\\ \ & \text{time spent on scrap production} \\\ \hline & \text{effective time}\rule{0pt}{13pt} \end{array} then \textbf{performance factor} \= \dfrac{ \raisebox{5pt}{\text{effective time}} }{ \text{available capacity}\rule{0pt}{13pt} } quality factor (quality of products) shows what portion of your production was in good quality versus rejected scrap calculation \text{total quantity} = \text{yield quantity} + \text{scrap quantity} \textbf{quality factor} \= \dfrac{ \raisebox{5pt}{\text{yield quantity}} }{ \text{total quantity}\rule{0pt}{13pt} } putting it all together hence, the final oee score is calculated as oee = \textbf {availability factor} × \textbf{performance factor} × \textbf{quality factor} a high oee means your machines are running reliably, fast, and producing good quality products reporting plugin planeus also offers a reporting plugin that lets you create custom reports tailored to your needs—without waiting for a new software release from simple lists of feedback to complex charts like oee or capacity utilization, planeus reporting helps you analyze past performance and understand how your production really ran