DBE Current Commitment Calc Procedures.xlsx

	A	B	C	D	F
1	DBE Current Commitment Calculations in PDBS:				Rev. 12/24
2				(see the DBE Commitment Change Order Instructions for directions on how to create the change order)
3		PIN =
4		Project Number =
5		Change Order Number =
6	A.	Prior to starting a DBE change order, fill in the yellow highlighted cells. Retrieve the amounts from the Item Payment Analysis in PDBS/Subsystems/Civil Rights/Reports. See screen shot below.
7	B.	No. 2 are the line item amounts that will need to have their commitments reduced in the change order.
8	C.	No. 6 will then calculate the amount of race neutral work needed to be changed to race conscious (highlighted red) to reach the goal. If No. 6 turns green then the overall goal is met already.
9	D.	When all yellow highlighted cells are filled in and No. 6 is red, then fill out No. 7 (highlighted blue), by entering only enough race neutral work to make up the amount in No. 6. The No. 7 amount can be taken from the positive values in the "+/-" column of the Item Payment Analysis. This column represents both un-committed race neutral work and overpaid committed work, which is also race neutral when it is an overage.
10	E.	When enough race neutral work is added to No. 7, then No. 6 will turn green and say "Goal is Met". This will also update the current commitment, No. 5, to match the goal.
11	F.	The amount in No. 7 must then be brought in to the change order by line item and each race neutral amount must then be changed to race conscious.
12	G.	If all yellow highlighted cells are filled in and No. 6 is green, Goal is met, and you still have an amount in No. 2, then you still need a change order to reduce the commitment of that item(s), but you do not need to bring in any race neutral work to make up the goal.
13	H.	So now that each commitment underrun is reduced by line item and the goal is made up by race neutral work being changed to race conscious, then you are now ready to start your change order.
14
15	No.	Description	Amounts
16	1	Total Commit Amt =
17
18	2	DBE Commitment underrun =		(negative amounts in "+/-" column)
19				(enter as positive numbers)
20	3	Base Contract Amount =
21
22	4	Project Goal =		(use project goal if only underruns/eliminated items,
23				use original commitment if otherwise.)
24	5	Current Commitment =	#DIV/0!
25		Should calculate to match the Item Payment Analysis, Race Conscious (RC)% in PDBS.
26
27	6	Amount RN needed to be changed to RC to reach goal =	#DIV/0!	(Will turn green if goal is met, due to rounding an extra penny may need to be added to reach the amount needed.)
28
29	7	Race Neutral work added to make up goal =		(taken from positive amounts in "+/-" column)
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100