Budget columns and calculations

  • Updated

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

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request