Analyzing work order costs

  • Updated

Five reports analyze the costs of work orders: per work order comparing plan and actual, per technical object across all levels, as a list of entries, by account or dimension, and per budget. This article describes which report suits which purpose, which options it has and where the amounts come from.

Which report for what

Report Purpose Location in the Maintenance Role Center
Work Order Statistics Compare planned, actual, expected, posted and sales amounts per work order; proprietary and external service; planned and reported times Planning > Reports
Cost Consolidation (Technical Object) Costs per technical object including all subordinate objects Planning > Reports
Work Order Movements All consumption and purchase entries of a work order with unit cost and overhead costs Execution > Reports
Work Order Posting List Costs per account or per value of global dimension 1, split by work order or budget position Execution > Reports
Work Order Budget Budgeted amounts, costs, ordered external services and available amounts per budget line Planning > Reports (entries Work Order Budget and Work Order Budgets)

You can also find all reports using search (Alt+Q). The amounts are in local currency and come from the work order ledger entries and work order value entries.

Work Order Statistics

For each work order, the report compares two series of values and shows the difference. Each work order ends with Total Work Order, and the report ends with Total over all Work Orders. You select the work orders on the Work Order tab; the suggested filter is No.

Option Effect
Type of Analysis
  • Planned Cost contra Feedback Cost: planned amount against actual amount, plus sales.
  • Planned Cost contra expected Cost: planned amount against expected amount, plus sales.
  • Feedback values contra Posted to G/L: actual amount against the amount posted to the general ledger.
  • Proprietary Service to External Service: material and resources from own work against external material and external resources.
  • Expected durations to feedback durations: Work Order Duration and Standstill Duration of the work order against the total of the posted work order feedbacks, in hours.
Split by Cost Type Shows the amounts per cost type: Material, Resource (Person), Resource (Machine), External Service, External Material, External Resource, G/L Account and Std.-Invoice Text.
Split by Type in Lines Shows subtotals per group: Material subtotal, Resources subtotal, External subtotal and Others subtotal.

For Proprietary Service to External Service and Expected durations to feedback durations, maintool switches off both splits.

This is how the amounts are calculated:

  • Planned: unit cost (LCY) times quantity of the planned work order lines. Unscheduled lines and item lines with direct material are not included. There is no planned value for G/L accounts and standard invoice texts.
  • Actual: actual costs from consumption and purchase. For work orders with Capitalization including overhead costs, otherwise direct costs only.
  • Expected: expected costs of the consumption entries, for work orders with Capitalization including overhead costs.
  • Posted: the part of it already posted to the general ledger, for work orders with Capitalization including overhead costs.
  • Sale: sales amount of the value entries for sales.

Cost Consolidation (Technical Object)

The report shows the costs of technical objects within their structure. For a component address, for example, the subordinate component addresses with their mounting positions and technical components appear below it, indented by level and with totals. For each object, the report totals the actual costs of the work order value entries assigned to that object.

Option Effect
Reference Object Kind of objects the analysis starts with: Component Address, Mounting Position, Technical Component or Vehicle.
Detail No. Filter on the numbers of the starting objects; you can select an object from the list. If there is no matching object, the message There is not detail in the choosen range of the field Detail No. (…)! appears.
Level For component addresses and technical components: level at which the analysis starts. If Detail No. and Level are empty, it starts at level 1 for component addresses.
From Date, To Date Only value entries whose posting date is within the period are included. Empty means: no limit.

On the Component Address, Mounting Position, Vehicle and Technical Component tabs, you can additionally filter by number. Result: for each object No., Type, Description and amount; for component addresses with the component address group and a total per group.

Work Order Movements

The report lists the posted entries of each work order, grouped by cost type. Work orders without matching entries do not appear. On the Work Order tab, the No. filter is suggested; you set the period by adding the Date Filter filter there (posting date of the entries). There are no options.

The report includes:

  • Consumption: items (without direct material), resources, and G/L accounts posted to the work order from the general journal.
  • Purchase: external services, direct material and G/L accounts.

For each entry, it shows No., Description, Document No., Document Date, Quantity, Unit of Measure, Unit Cost, Cost Amount, the overhead costs and the Cost Amount incl. OR. The header of each work order shows the dimension values of the two global dimensions and the planned amount; at the end, the resource hours and the total cost.

Work Order Posting List

The report totals the work order value entries of a period per account or per value of global dimension 1 and splits them by work order or by budget position. For each line, it shows costs and overhead costs for material, resources and external services, and the total.

Option Effect
From Date, To Date (group Date limitation) Mandatory: posting date of the value entries. The default is the start of the current year to today. If a date is missing, the message You have to make a Date Restriction! appears.
ACCOUNT or dimension 1 (group Analysis) What to group by: the Account No. of the value entries or the value of global dimension 1 (default). The field for the dimension carries the name of your global dimension 1. Exactly one of the two is always switched on.
Analysisfilter Filter on the account numbers or dimension values. Empty: all value entries in which the account or dimension value is filled in.
Analysis Feedback Amount: expected costs of the consumption entries. Invoiced Amount: actual costs from consumption and purchase.
Work Order or Budget Plan Position (group Analysis over) Split within an account or dimension value: per work order (default, with work order status and capitalization indicator) or per budget position.
Only Totals Outputs only the totals.
Only Capitalized Includes only value entries of capitalized work orders.

Work Order Budget

The report prints the lines of a work order budget with budgeted amounts and costs. On the Work Order Budget Line tab, the Budget Name and Date Filter filters are suggested.

Option Effect
only valid lines Shows only budget lines whose period from Valid from and Valid until overlaps with the Date Filter. This requires a Date Filter; otherwise the message Please specify a date filter. appears.
Calculate Ordered External Service Calculates the ordered external services that have not yet been posted and shows them in separate columns. Switched on when the request page opens.

For each budget line, the report shows the budgeted amounts and the costs for material, resources and external service and in total, the ordered external services, the sum of costs and ordered external services, the Difference to the budgeted amount and the Available amount, from which the expected costs are also deducted. How the individual amounts are calculated is described in Budget columns and calculations.

Notes and limitations

  • Unscheduled work order lines are not included in the planned amount.
  • Which costs are already in the general ledger and how to post open costs is described in Post work order cost to G/L.

Related articles

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request