System Generated Report Estimates

A number of Unanet reports include values such as % Complete, Estimate to Complete, Estimated Totals, and Over/Under Budget amounts.  Many of these values can be optionally entered either at the project level on the Project Profile Budget tab, or at the task level on the Task Edit > Budget tab.  Depending on which values have been supplied, the reports may or may not need to generate an estimated amount for each value.

This page attempts to provide some insight into how the estimated values are calculated, that is, given the presences of particular combinations of data entry, how will the remaining fields be populated.  

 

Topics covered on this help page include:


Estimation Rules

In the table below, the "v" indicates a value is supplied for that particular field, a "-" (hyphen) indicates no value was supplied.

Note: The information below applies to the calculation rules as they apply to estimating amounts relating to "hours".  

Several Labor Dollar and Expense Dollar calculations are based on the % Complete value, which if not provided is derived based on "hours" information.

 

Case# %Comp Budget Actual ETC Est. Total   %Comp' Budget' Actual' ETC' Est. Total' Under (Over) Budget

1

v

v

v

v

v

 

%Comp

Budget

Actual

Est. Total' - Actual'

Max(Est. Total, Actual')

Budget - Est. Total'

2

v

v

v

v

-

 

%Comp

Budget

Actual

ETC

ETC' + Actual'

Budget - Est. Total

3

v

v

v

-

v

 

%Comp

Budget

Actual

Est. Total' - Actual'

Max(Est. Total, Actual')

Budget - Est. Total'

4

v

v

v

-

-

 

%Comp

Budget

Actual

Est. Total' - Actual'

Actual/%Comp

Budget - Est. Total'

5

v

v

-

v

v

 

%Comp

Budget

-

Est. Total' - Actual'

Max(Est. Total, Actual')

Budget - Est. Total'

6

v

v

-

v

-

 

%Comp

Budget

-

ETC

ETC' + Actual'

Budget - Est. Total'

7

v

v

-

-

v

 

%Comp

Budget

-

Est. Total' - Actual'

Max(Est. Total, Actual')

Budget - Est. Total'

8

v

v

-

-

-

 

%Comp

Budget

-

Est. Total' - Actual'

Max(Budget', Actual')

Budget - Est. Total'

9

v

-

v

v

v

 

%Comp

-

Actual

Est. Total' - Actual'

Max(Est. Total, Actual')

0 - Est. Total'

10

v

-

v

v

-

 

%Comp

-

Actual

ETC

ETC' + Actual'

0 - Est. Total'

11

v

-

v

-

v

 

%Comp

-

Actual

Est. Total' - Actual'

Max(Est. Total, Actual')

0 - Est. Total'

12

v

-

v

-

-

 

%Comp

-

Actual

Est. Total' - Actual'

ETC' + Actual'

0 - Est. Total'

13

v

-

-

v

v

 

%Comp

-

-

Est. Total' - Actual'

Max(Est. Total, Actual')

0 - Est. Total'

14

v

-

-

v

-

 

%Comp

-

-

ETC

ETC' + Actual'

0 - Est. Total'

15

v

-

-

-

v

 

%Comp

-

-

Est. Total' - Actual'

Max(Est. Total, Actual')

0 - Est. Total'

16

v

-

-

-

-

 

%Comp

-

-

-

-

0 - Est. Total'

17

-

v

v

v

v

 

Actual'/Est. Total'

Budget

Actual

Est. Total' - Actual'

Max(Est. Total, Actual')

Budget - Est. Total'

18

-

v

v

v

-

 

Actual'/Est. Total'

Budget

Actual

ETC

ETC' + Actual'

Budget - Est. Total'

19

-

v

v

-

v

 

Actual'/Est. Total'

Budget

Actual

Est. Total' - Actual'

Max(Est. Total, Actual')

Budget - Est. Total'

20

-

v

v

-

-

 

Actual'/Est. Total'

Budget

Actual

Est. Total' - Actual'

Max(Budget', Actual')

Budget - Est. Total'

21

-

v

-

v

v

 

0

Budget

-

Est. Total' - Actual'

Max(Est. Total, Actual')

Budget - Est. Total'

22

-

v

-

v

-

 

0

Budget

-

ETC

ETC' + Actual'

Budget - Est. Total'

23

-

v

-

-

v

 

0

Budget

-

Est. Total' - Actual'

Max(Est. Total, Actual')

Budget - Est. Total'

24

-

v

-

-

-

 

0

Budget

-

Est. Total' - Actual'

Max(Budget', Actual')

Budget - Est. Total'

25

-

-

v

v

v

 

Actual'/Est. Total'

-

Actual

Est. Total' - Actual'

Max(Est. Total, Actual')

0 - Est. Total'

26

-

-

v

v

-

 

Actual'/Est. Total'

-

Actual

ETC

ETC' + Actual'

0 - Est. Total'

27

-

-

v

-

v

 

Actual'/Est. Total'

-

Actual

Est. Total' - Actual'

Max(Est. Total, Actual')

0 - Est. Total'

28

-

-

v

-

-

 

Actual'/Est. Total'

-

Actual

Max(Est. Total, Actual')

Max(Est. Total, Actual')

0 - Est. Total'

29

-

-

-

v

v

 

0

-

-

Est. Total' - Actual'

Max(Est. Total, Actual')

0 - Est. Total'

30

-

-

-

v

-

 

0

-

-

ETC

ETC' + Actual'

0 - Est. Total'

31

-

-

-

-

v

 

0

-

-

Est. Total' - Actual'

Max(Est. Total, Actual')

0 - Est. Total'

32

-

-

-

-

-

 

0

-

-

Max(Est. Total, Actual')

Max(Budget', Actual')

0 - Est. Total'

Case# 8: Provided %Comp has no affect on the estimated total when there are no actuals present. The estimated total in this case will always be the Budget.

Case# 4: If %Comp is provided and %0.00, the result of the calculation should change to prevent DIV/0 error. The ETC should become Budget and the Est. Total should become Budget + Actual.

 

 


Examples (corresponding to formulas above)

The table below provides actual examples corresponding to the Rules stated in the table above.

Case# %Comp Budget Actual ETC Est. Total   %Comp' Budget' Actual' ETC' Est. Total' Under (Over) Budget  

1

10.00%

80

24

32

120

 

10.00%

80.00

24.00

96.00

120.00

(40.00)

 

2

10.00%

80

20

60

 

 

10.00%

80.00

20.00

60.00

80.00

0.00

 

3

10.00%

80

20

 

80

 

10.00%

80.00

20.00

60.00

80.00

0.00

 

4

0.00%

80

20

 

 

 

0.00%

80.00

20.00

80.00

100.00

(20.00)

%Comp = 0

4

10.00%

80

20

 

 

 

10.00%

80.00

20.00

180.00

200.00

(120.00)

%Comp > 0

5

10.00%

80

 

32

56

 

10.00%

80.00

0.00

56.00

56.00

24.00

 

6

10.00%

80

 

56

 

 

10.00%

80.00

0.00

56.00

56.00

24.00

 

7

10.00%

80

 

 

56

 

10.00%

80.00

0.00

56.00

56.00

24.00

 

8

10.00%

80

 

 

 

 

10.00%

80.00

0.00

80.00

80.00

0.00

 

9

10.00%

 

8

32

56

 

10.00%

---

8.00

48.00

56.00

(56.00)

 

10

10.00%

 

8

 

 

 

10.00%

---

8.00

48.00

56.00

(56.00)

 

11

10.00%

 

8

 

56

 

10.00%

---

8.00

48.00

56.00

(56.00)

 

12

10.00%

 

8

 

 

 

10.00%

---

8.00

72.00

80.00

(80.00)

 

13

10.00%

 

 

32

80

 

10.00%

---

0.00

80.00

80.00

(80.00)

 

14

10.00%

 

 

80

 

 

10.00%

---

0.00

80.00

80.00

(80.00)

 

15

10.00%

 

 

 

80

 

10.00%

---

0.00

80.00

80.00

(80.00)

 

16

10.00%

 

 

 

 

 

10.00%

---

0.00

---

0.00

0.00

 

17

 

80

24

8

56

 

42.86%

80.00

24.00

32.00

56.00

24.00

 

18

 

80

24

32

 

 

42.86%

80.00

24.00

32.00

56.00

24.00

 

19

 

80

24

 

56

 

42.86%

80.00

24.00

32.00

56.00

24.00

 

20

 

24

80

 

 

 

100.00%

24.00

80.00

0.00

80.00

(56.00)

Budget < Actuals

20

 

80

24

 

 

 

30.00%

80.00

24.00

56.00

80.00

0.00

Budget > Actuals

21

 

80

 

24

40

 

0.00%

80.00

0.00

40.00

40.00

40.00

 

22

 

80

 

56

 

 

0.00%

80.00

0.00

56.00

56.00

24.00

 

23

 

80

 

 

56

 

0.00%

80.00

0.00

56.00

56.00

24.00

 

24

 

80

 

 

 

 

0.00%

80.00

0.00

80.00

80.00

0.00

 

25

 

 

80

8

24

 

100.00%

---

80.00

0.00

80.00

(80.00)

Actual > Est. Total

25

 

 

24

8

80

 

30.00%

---

24.00

56.00

80.00

(80.00)

Actual < Est. Total

26

 

 

24

 

 

 

30.00%

---

24.00

56.00

80.00

(80.00)

 

27

 

 

80

56

24

 

100.00%

---

80.00

0.00

80.00

(80.00)

Actual > Est. Total

27

 

 

24

 

80

 

30.00%

---

24.00

56.00

80.00

(80.00)

Actual < Est. Total

28

 

 

24

 

 

 

100.00%

---

24.00

---

24.00

(24.00)

 

29

 

 

 

40

80

 

0.00%

---

0.00

80.00

80.00

(80.00)

 

30

 

 

 

80

 

 

0.00%

---

0.00

80.00

80.00

(80.00)

 

31

 

 

 

 

80

 

0.00%

---

0.00

80.00

80.00

(80.00)

 

32

 

 

 

 

 

 

0.00%

---

0.00

---

0.00

0.00

 

 


Put another way...

The following states rules for estimating project performance numbers.  Project Status, Project Earned Value, Revenue Recognition reports and Project Alerts and Performance Tracking all use this logic.

 

% Complete calculations

 

If %Complete was provided, use it:

   Final %Complete = user-specified %Complete (as provided)

   

If %Complete was NOT provided and should be estimated from Hours:

   Calculate Hours Est. Total using Est. Total calculations (see below)

   Final %Complete = Hours Actuals / Hours Est. Total

 

If %Complete was NOT provided and should be estimated from Labor Cost:

   Calculate Labor Cost Est. Total using Est. Total calculations (see below)

   Final %Complete = Labor Cost Actuals / Labor Cost Est. Total

 

If %Complete was NOT provided and should be estimated from Total Cost:

   Calculate Total Cost Est. Total using Est. Total calculations -- Labor & Expense values determined independently then combined (see below)  

   Final %Complete = (Labor + Expense Cost Actuals) / (Labor + Expense Total Cost Est. Total)

 

Note that when the Project Budget tab >> Estimate from value is set to Total Cost, the estimated total used in the calculation is calculated by first determining the "estimated total" of the Labor Cost and then the Expense Cost separately.  You might expect different results if you assume they are first combined.

For example, if you were to set up a $1,000 labor cost budget but no expense cost budget, and then enter only $500 of expense cost actuals you might expect the system to declare the project 50% complete ($500/$1000).  However, we would instead calculate the Estimated Completed Percent as 33%.   Because we calculate the piece parts separately we would adjust the total budget to $1500 (the $1000 for labor cost plus the missing expense cost budget would be defaulted to $500 -- as the budget is determined to be equal to the actuals when no budget is provided).  Given that, the Estimated Completed Percent would be calculated as Actuals of $500 / Estimated total of $1,500 = 33%.

 

 

Est. Total calculations

If you have NO Actuals:

   Default Actuals to 0

 

If you have NO Budget:

   Default Budget to 0

 

When Est. Total is provided:

   If Est. Total was provided and it is greater than Actuals, use it:

      Est. Total = user-specified Est. Total (as provided)

      ETC = Est. Total - Actuals

 

   If Est. Total was provided but it is less than Actuals, use Actuals instead:

      Est. Total = Actuals

      ETC = Est. Total - Actuals (becomes 0)

   

When Est. Total is NOT provided:

   If ETC was provided, then use it to calculate Est. Total:

      Est. Total = Actuals + ETC

      ETC = user-specified ETC (as provided)

 

Est. Total and ETC were NOT provided but you have Actuals and %Complete:

   If %Complete is 0:

      Est. Total = Actuals + Budget

      ETC = Est. Total - Actuals

   

   If %Complete is not 0:

      Est. Total = Actuals / %Complete

      ETC = Est. Total - Actuals

 

Est. Total and ETC were NOT provided and have NO Actuals and/or NO %Complete:

   If Actuals are greater than Budget:

      Est. Total = Actuals

      ETC = Est. Total - Actuals

   

   If Actuals are less than Budget:

      Est. Total = Budget

      ETC = Est. Total - Actuals


Project vs Task Discrepancies

Note that when calculating metrics from project values vs. task level values, you may get different results for seemingly similar data.

As an example, on the Project Status Report, when we “use the task budgets for project metrics”, we collect actuals, estimate % complete, and then derive Estimated Total for each task.  We then add up the results of each task’s calculations to come up with the project’s totals.  Likewise, when we “use the project budgets for project metrics”, we collect all actuals reported for the project and compare all of the actuals to the project’s budget to derive the % complete, and from that, the Estimated Total. 

To illustrate how this may yield different results, consider the following example:

  1. Task 1 – 50% completed, with budget of $100, and actuals of $50, would have an estimated total of $100. 
  2. Task 2 – 100% completed, with budget of $50, and actuals of $100, would have an estimated total of $100 (as the estimated total cannot be less the already incurred actuals).
  3. The sum of estimated totals for the 2 tasks is $200.
  4. Project with total budget of $150 and total actuals of $150.  % complete for this project will be calculated as all actuals over project’s budget: 150 / 150 = 100%.  In this case, the Estimated Total for the project is still $150.

 

The sum of the parts does not always equal the whole.

 

          Related Topics