The Work Order Budget page shows budgeted amounts, posted costs, planned and ordered costs as well as values calculated from them side by side. This article describes what each column is calculated from. Many columns are hidden by default; you show them using personalization. Adapt the columns to your planning: if, for example, you only plan with total amounts, you do not need the columns per cost type.
Period and lines
All amounts refer to the period you set with View by, View as and Date Filter. Depending on the column, a different date is decisive:
| Columns | Decisive date |
| Budgeted amounts, Expected Costs | Date of the work order budget entries |
| Cost columns | Posting date of the work order value entries |
| Columns with the suffix (Planning) | Execution Date of the work order line |
| Ordered External Service | Order Date of the purchase order line |
- If only valid lines is switched on (always the case when the page is opened), maintool only shows lines whose period from Valid from and Valid until overlaps the period set. Lines without these details are always shown.
- With Rounding Factor, you show all amounts in thousands, for example.
Budgeted amounts
| Column | Calculation |
| Total Budgeted Amount | Sum of all budget entries of the amount types (blank), Material, Ressource and External Service. Amounts you enter per cost type are therefore included in the total amount. |
| Material Budgeted Amount, Resource Budgeted Amount, External Service Budgeted Amount | Sum of the budget entries of the respective amount type |
| Expected Costs | Amount you enter in this column yourself (budget entries of the amount type Expected Costs). It is deducted from Available but not counted in the total amount. |
How to enter and change these amounts is described in Enter and change budgeted amounts.
Posted costs
The cost columns add up the work order value entries of the work orders assigned to the budget position. maintool always calculates them automatically. Click an amount to see the underlying work order value entries.
Each cost column exists in four variants:
| Variant (example total) | Field in the work order value entry | Overhead | Work order entry type |
| Total Costs | Cost Amount (Actual) | no, direct costs only | Consumption and Purchase |
| Total Costs incl. OR | Cost Amount (Actual) | yes, direct costs and overhead | Consumption and Purchase |
| Total Costs (Cost Amount) | Cost Amount (Expected) | no, direct costs only | Consumption |
| Total Costs incl. OR (Cost Amount) | Cost Amount (Expected) | yes, direct costs and overhead | Consumption |
The columns per cost type additionally filter on the Cost Type of the value entry:
| Columns | Cost types |
| Total Costs and variants | all |
| Material Costs, Material Costs incl. OR, Material Costs (Cost Amount), Material Costs incl. OR (Cost Amount) | Material |
| Resource Cost, Resource Cost incl. OR, Resource Cost (Cost Amount), Resource Cost incl. OR (Cost Amount) | Resource (Person), Resource (Machine); for the actual amounts, work order entry type Consumption only |
| External Service Costs, External Service Costs (Cost Amount), External Service Costs incl. OR (Cost Amount) | External Service, External Material, External Resource |
Planned and ordered costs
maintool fills these columns with Calculate planned Work Order Lines or Calculate ordered External Service, or automatically if this is switched on for the budget, see Assign a work order to a budget and calculate costs. Lines of the type Headline show no values here.
| Column | Calculation |
| Total Costs (Planning) | Sum of the Outstanding Amounts of all planned work order lines |
| Material Costs (Planning) | Outstanding amounts of the lines of the type Item |
| Resource Costs (Planning) | Outstanding amounts of the lines of the type Resource |
| Resource Group Costs (Planning) | Outstanding amounts of the lines of the type Resource Group |
| External Service Costs (Planning) | Outstanding amounts of the lines of the type External Service |
| Ordered External Service | Sum over the purchase order lines with external service items: quantity not yet invoiced × Unit Cost (LCY) |
| Total Costs + Ordered External Service | Total Costs + Ordered External Service |
| Total Costs incl. OR + Ordered External Service | Total Costs incl. OR + Ordered External Service |
| Total Costs (Cost Amount) + Ordered External Service | Total Costs (Cost Amount) + Ordered External Service |
| Total Costs incl. OR (Cost Amount) + Ordered External Service | Total Costs incl. OR (Cost Amount) + Ordered External Service |
Outstanding quantity and outstanding amount
The columns with the suffix (Planning) only count the part of each work order line that is still open. On the Planned Work Order Lines page, you see two columns for this:
- Outstanding Quantity: Quantity minus reported quantity, never less than 0, see Enter planning lines.
- Outstanding Amount: Line Amount × Outstanding Quantity / Quantity. The Line Amount is Quantity × Unit Cost.
Example: A line for 10 hours at 50.00 has the line amount 500.00. If 4 hours have been reported, the outstanding quantity is 6 and the outstanding amount 300.00. The 4 posted hours appear in the cost columns.
Difference and available
maintool calculates these columns from the other columns. All variants start from the Total Budgeted Amount.
| Column | Formula |
| Difference | Total Budgeted Amount − Total Costs − Ordered External Service |
| Diffrence incl. OR | Total Budgeted Amount − Total Costs incl. OR − Ordered External Service |
| Difference (Cost Amount) | Total Budgeted Amount − Total Costs (Cost Amount) − Ordered External Service |
| Diffrence incl. OR (Cost Amount) | Total Budgeted Amount − Total Costs incl. OR (Cost Amount) − Ordered External Service |
| Available | Difference − Expected Costs |
| Available incl. OR | Diffrence incl. OR − Expected Costs |
| Available (Cost Amount) | Difference (Cost Amount) − Expected Costs |
| Available incl. OR (Cost Amount) | Diffrence incl. OR (Cost Amount) − Expected Costs |
| Available (Planning) | Difference − Total Costs (Planning) − Expected Costs |
Ordered External Service and the columns with the suffix (Planning) are only included if they have been calculated. Otherwise they count as 0.
Automatic calculation
maintool always calculates the budgeted amounts, the cost columns, Difference and Available. maintool only calculates Ordered External Service and the columns with the suffix (Planning) on request or if Ordered External Services automaticly calculate or Planned Work Order Lines automaticly calculate is switched on for the budget on the Work Order Budgets page. maintool then calculates each time the budget is opened and each time the Budget Name is changed on the budget page.
Related articles
- Budgets – overview
- Enter and change budgeted amounts
- Assign a work order to a budget and calculate costs
Related to