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:

SeqGroupLineLevelCodeDescription

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.

Note: The Seq number assigned to each entry (automatically) only represents the order in which the entry was added to the grid; it does not control the order in which detail appears on budget reports, nor is it used in subtotals or 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.

 

PM Budget IDs