PM Project Budgets Form
Use this form to create and maintain project budgets, which allow you further breakdown the revenue or costs associated with a change order.
You can define budget detail using budget IDs, by manually entering costs and markups, or a combination of both. For example, you can assign budget codes to those sequences that define the breakdown of revenue or costs, and then enter sequences without budget IDs that will be used to provide details, subtotals, and/or totals of the cost or revenue.
Example:
Seq | Group | Line | Level | Code | Description |
---|---|---|---|---|---|
1 |
1 |
1 | D - Detail | L1 | Laborer Type 1 |
2 |
1 |
2 | D - Detail | L1 | Laborer Type 1 |
3 |
1 |
3 | D - Detail | L2 | Laborer Type 2 |
4 |
1 |
4 | S - Subtotal |
| Total labor |
5 |
2 |
1 | D - Detail |
| Fill |
6 |
2 |
2 | D - Detail |
| Disposal Fees |
7 |
2 |
3 | S - Subtotal |
| Total Material |
8 |
3 |
1 | D - Detail |
| JD 410 Excavator |
9 |
3 |
2 | D - Detail |
| 10 CY Dump Truck |
10 |
3 |
3 | S - Subtotal |
| Total Equipment |
11 |
4 |
1 | D - Detail |
| Burden |
12 |
4 |
2 | S - Subtotal |
| Burden Subtotal |
13 |
5 |
4 | T - Total |
| Total |
Each sequence must be assigned a ‘group’ number. The group number is used to combine all lines within the group for subtotaling purposes. The group number is not used in ‘Total’ calculations.
A Line number must also be assigned to each entry. You can have multiple lines within a group (as shown in the example above) or use the line number as a sequential list of all entries. In the example above, this would mean assigning line number of 1 thru 13.
The line number controls the order in which the detail appears on budget reports, and is used in the subtotal and total calculations. When calculating subtotals, all sequences within a group where the line number is less than the subtotal line number will be included in the subtotal. In the example above, the subtotal for Labor (Seq 4) will include Lines 1, 2, and 3 (of Group 1), the subtotal for Material (Seq 7) will include Lines 1 and 2 (of Group 2), and the subtotal for Equipment (Seq 10) will include Lines 1 and 2 (of Group 3). When calculating totals, all lines to be included in the total must have a line number equal to or less than the total line number. In our example, each group has its own set of line numbers. So in order to ensure that all lines will be included, the total line number (Seq 13) must be equal to or greater than the highest line number of all groups; in this case, 4.
Once set up here, project budgets can then be assigned to change order items in PM Pending Change Orders or PM Approved Change Orders.