| The Earned Value Management Macros | 
Example 9.2: Construction Project
This example illustrates a home building multiproject. 
 The cost structure of the multiproject consists of both rates and 
 fixed costs.  This example also demonstrates how to accommodate multiple status dates. 
 The initial schedule is shown in Figure 9.2.1.
 
Output 9.2.1: Initial Schedule GBSCHED 
| 
 
| Build House | 0 | 1 | 04SEP04 | 12OCT04 |  
| Landscaping | 0.00 | 1 | 29SEP04 | 10OCT04 |  
| Finish Grading | 0.00.0 | 2 | 29SEP04 | 30SEP04 |  
| Walks & Landscape | 0.00.1 | 5 | 06OCT04 | 10OCT04 |  
| Drainage | 0.01 | 1 | 28SEP04 | 29SEP04 |  
| Gutters & Downspouts | 0.01.0 | 1 | 28SEP04 | 28SEP04 |  
| Storm Drains | 0.01.1 | 1 | 29SEP04 | 29SEP04 |  
| Wiring | 0.02 | 1 | 14SEP04 | 05OCT04 |  
| Initial Wiring | 0.02.0 | 2 | 14SEP04 | 15SEP04 |  
| Kitchen Fixtures | 0.02.1 | 1 | 03OCT04 | 03OCT04 |  
| Finish Electrical | 0.02.2 | 1 | 04OCT04 | 04OCT04 |  
| Finish Carpentry | 0.02.3 | 3 | 03OCT04 | 05OCT04 |  
| Plumbing | 0.03 | 1 | 10SEP04 | 04OCT04 |  
| Rough Plumbing | 0.03.0 | 3 | 11SEP04 | 13SEP04 |  
| Basement Plumbing | 0.03.1 | 1 | 10SEP04 | 10SEP04 |  
| Finish Plumbing | 0.03.2 | 2 | 03OCT04 | 04OCT04 |  
| Foundation | 0.04 | 1 | 04SEP04 | 15SEP04 |  
| Excavate & Footers | 0.04.0 | 4 | 04SEP04 | 07SEP04 |  
| Pour Foundation | 0.04.1 | 2 | 08SEP04 | 09SEP04 |  
| Pour Basement | 0.04.2 | 2 | 14SEP04 | 15SEP04 |  
| Roofing | 0.05 | 1 | 10SEP04 | 27SEP04 |  
| Finish Roof | 0.05.0 | 2 | 26SEP04 | 27SEP04 |  
| Frame & Roof | 0.05.1 | 4 | 10SEP04 | 13SEP04 |  
| Flooring | 0.06 | 1 | 30SEP04 | 12OCT04 |  
| Varnish Floor | 0.06.0 | 2 | 11OCT04 | 12OCT04 |  
| Finish Flooring | 0.06.1 | 3 | 30SEP04 | 02OCT04 |  
| Heat & Ventilation | 0.07 | 4 | 16SEP04 | 19SEP04 |  
| Plaster | 0.08 | 10 | 20SEP04 | 29SEP04 |  
| Brickwork | 0.09 | 6 | 20SEP04 | 25SEP04 |  
| Paint | 0.10 | 3 | 06OCT04 | 08OCT04 |  | 
 
 The Work Breakdown Structure for the project is given in Figure 9.2.2; this 
 chart was created using the %EVG_WBS_CHART macro.
 
    %evg_wbs_chart(
     structure=gbsched,
     activity=activity,
     project=project,
     id=wbs_code id,
     rotate=N,
     rotatetext=N,
     defid=N
    );
 
Output 9.2.2: %EVG_WBS_CHART: Work Breakdown Structure 
Figure 9.2.3 lists the budgeted costs for each task.
 
Output 9.2.3: Budgeted Cost Rates GBASE 
| 
 
| Build House | 0 | 0 | 0 |  
| Landscaping | 0 | 0 | 0 |  
| Drainage | 0 | 0 | 0 |  
| Wiring | 0 | 0 | 0 |  
| Plumbing | 0 | 0 | 0 |  
| Foundation | 0 | 0 | 0 |  
| Roofing | 0 | 0 | 0 |  
| Flooring | 0 | 0 | 0 |  
| Heat & Ventilation | 325 | 50 | 40 |  
| Plaster | 14500 | 1,2,3,4 | 20 |  
| Brickwork | 9500 | 1,2,3 | 45 |  
| Paint | 3250 | 50 | 30 |  
| Finish Grading | 425 | 25 | 25 |  
| Walks & Landscape | 2475 | 25 | 25 |  
| Gutters & Downspouts | 1200 | 50 | 15 |  
| Storm Drains | 150 | 25 | 15 |  
| Initial Wiring | 575 | 25 | 45 |  
| Kitchen Fixtures | 375 | 25 | 25 |  
| Finish Electrical | 550 | 25 | 50 |  
| Finish Carpentry | 1450 | 25 | 20 |  
| Rough Plumbing | 1025 | 25 | 30 |  
| Basement Plumbing | 1000 | 25 | 50 |  
| Finish Plumbing | 350 | 25 | 20 |  
| Excavate & Footers | 5250 | 50 | 20 |  
| Pour Foundation | 1500 | 25 | 15 |  
| Pour Basement | 950 | 50 | 20 |  
| Finish Roof | 725 | 50 | 40 |  
| Frame & Roof | 9500 | 25 | 35 |  
| Varnish Floor | 750 | 25 | 15 |  
| Finish Flooring | 425 | 50 | 25 |  | 
Note that the "Storm Drains" task, in the sixteenth observation, 
 costs one quarter (25%) of 
 $150 upon initiation and continues at a rate of $15/day.  When complete, 
 the balance (75%) of the $150 is charged. 
 
 
 Weighted milestones are 
 specified for the "Plaster" activity, given in Observation 10. 
 At the start, one tenth 
  of $14,500, or $1,450, is incurred. 
 The rate is $20/day.  When the task is 
 one third complete, another fifth
 of $14,500, or $1,450, is incurred. 
 The rate is $20/day.  When the task is 
 one third complete, another fifth  of $14,500, or $2,900, is incurred.  At completion, the cost is two fifths
 
 of $14,500, or $2,900, is incurred.  At completion, the cost is two fifths 
  of $14,500, or $5,800.
 of $14,500, or $5,800.
 
The %EVA_PLANNED_VALUE macro is next invoked to compute the periodic planned value.
 
    %eva_planned_value(
        plansched=gbsched,
        activity=activity,
        start=start,
        finish=finish,
        budgetcost=gbase,
        rate=rate,
        cost=cost,
        spct=spct,
        taskpv=bout,
        pv=gbcost
    );
 
The periodic planned value data set is shown in Figure 9.2.4.
 
Output 9.2.4: %EVA_PLANNED_VALUE: Periodic Data Set 
| 
 
| 04SEP04 | 2645.00 |  
| 05SEP04 | 20.00 |  
| 06SEP04 | 20.00 |  
| 07SEP04 | 2645.00 |  
| 08SEP04 | 390.00 |  
| 09SEP04 | 1140.00 |  
| 10SEP04 | 3460.00 |  
| 11SEP04 | 321.25 |  
| 12SEP04 | 65.00 |  
| 13SEP04 | 7958.75 |  
| 14SEP04 | 683.75 |  
| 15SEP04 | 971.25 |  
| 16SEP04 | 202.50 |  
| 17SEP04 | 40.00 |  
| 18SEP04 | 40.00 |  
| 19SEP04 | 202.50 |  
| 20SEP04 | 3098.33 |  
| 21SEP04 | 65.00 |  
| 22SEP04 | 3231.67 |  
| 23SEP04 | 2965.00 |  
| 24SEP04 | 65.00 |  
| 25SEP04 | 4815.00 |  
| 26SEP04 | 4772.50 |  
| 27SEP04 | 422.50 |  
| 28SEP04 | 1235.00 |  
| 29SEP04 | 6116.25 |  
| 30SEP04 | 581.25 |  
| 01OCT04 | 25.00 |  
| 02OCT04 | 237.50 |  
| 03OCT04 | 890.00 |  
| 04OCT04 | 902.50 |  
| 05OCT04 | 1107.50 |  
| 06OCT04 | 2298.75 |  
| 07OCT04 | 55.00 |  
| 08OCT04 | 1680.00 |  
| 09OCT04 | 25.00 |  
| 10OCT04 | 1881.25 |  
| 11OCT04 | 202.50 |  
| 12OCT04 | 577.50 |  | 
Notice that the TASKPV= parameter has been used to ultimately pass the planned 
 activity duration and costs to %EVA_EARNED_VALUE.  Assume that the schedule has been 
 updated to reflect actual start and 
 finish times, as of the status date September 15, 2004.  The updated schedule is 
 shown in Figure 9.2.5.
 
Output 9.2.5: Updated Schedule GASCHED 
| 
 
| Build House | 0 | 1 | 04SEP04 | 17OCT04 |  
| Landscaping | 0.00 | 1 | 04OCT04 | 15OCT04 |  
| Drainage | 0.01 | 1 | 03OCT04 | 04OCT04 |  
| Wiring | 0.02 | 1 | 19SEP04 | 10OCT04 |  
| Plumbing | 0.03 | 1 | 15SEP04 | 09OCT04 |  
| Foundation | 0.04 | 1 | 04SEP04 | 20SEP04 |  
| Roofing | 0.05 | 1 | 15SEP04 | 02OCT04 |  
| Flooring | 0.06 | 1 | 05OCT04 | 17OCT04 |  
| Heat & Ventilation | 0.07 | 4 | 21SEP04 | 24SEP04 |  
| Plaster | 0.08 | 10 | 25SEP04 | 04OCT04 |  
| Brickwork | 0.09 | 6 | 25SEP04 | 30SEP04 |  
| Paint | 0.10 | 3 | 11OCT04 | 13OCT04 |  
| Finish Grading | 0.00.0 | 2 | 04OCT04 | 05OCT04 |  
| Walks & Landscape | 0.00.1 | 5 | 11OCT04 | 15OCT04 |  
| Gutters & Downspouts | 0.01.0 | 1 | 03OCT04 | 03OCT04 |  
| Storm Drains | 0.01.1 | 1 | 04OCT04 | 04OCT04 |  
| Initial Wiring | 0.02.0 | 2 | 19SEP04 | 20SEP04 |  
| Kitchen Fixtures | 0.02.1 | 1 | 08OCT04 | 08OCT04 |  
| Finish Electrical | 0.02.2 | 1 | 09OCT04 | 09OCT04 |  
| Finish Carpentry | 0.02.3 | 3 | 08OCT04 | 10OCT04 |  
| Rough Plumbing | 0.03.0 | 3 | 16SEP04 | 18SEP04 |  
| Basement Plumbing | 0.03.1 | 1 | 15SEP04 | 15SEP04 |  
| Finish Plumbing | 0.03.2 | 2 | 08OCT04 | 09OCT04 |  
| Excavate & Footers | 0.04.0 | 4 | 04SEP04 | 11SEP04 |  
| Pour Foundation | 0.04.1 | 2 | 12SEP04 | 14SEP04 |  
| Pour Basement | 0.04.2 | 2 | 19SEP04 | 20SEP04 |  
| Finish Roof | 0.05.0 | 2 | 01OCT04 | 02OCT04 |  
| Frame & Roof | 0.05.1 | 4 | 15SEP04 | 18SEP04 |  
| Varnish Floor | 0.06.0 | 2 | 16OCT04 | 17OCT04 |  
| Finish Flooring | 0.06.1 | 3 | 05OCT04 | 07OCT04 |  | 
The updated cost rates are given in Figure 9.2.6.
 
Output 9.2.6: Updated Cost Rates GACT 
| 
 
| Build House | 0 | 0 | 0 |  
| Landscaping | 0 | 0 | 0 |  
| Drainage | 0 | 0 | 0 |  
| Wiring | 0 | 0 | 0 |  
| Plumbing | 0 | 0 | 0 |  
| Foundation | 0 | 0 | 0 |  
| Roofing | 0 | 0 | 0 |  
| Flooring | 0 | 0 | 0 |  
| Heat & Ventilation | 40 | 325 | 50 |  
| Plaster | 20 | 14500 | 1,2,3,4 |  
| Brickwork | 45 | 9500 | 1,2,3 |  
| Paint | 30 | 3250 | 50 |  
| Finish Grading | 25 | 425 | 25 |  
| Walks & Landscape | 25 | 2475 | 25 |  
| Gutters & Downspouts | 15 | 1200 | 50 |  
| Storm Drains | 15 | 150 | 25 |  
| Initial Wiring | 45 | 575 | 25 |  
| Kitchen Fixtures | 25 | 375 | 25 |  
| Finish Electrical | 50 | 550 | 25 |  
| Finish Carpentry | 20 | 1450 | 25 |  
| Rough Plumbing | 30 | 1025 | 25 |  
| Basement Plumbing | 50 | 1000 | 25 |  
| Finish Plumbing | 20 | 350 | 25 |  
| Excavate & Footers | 30 | 6350 | 50 |  
| Pour Foundation | 30 | 2700 | 25 |  
| Pour Basement | 20 | 950 | 50 |  
| Finish Roof | 40 | 725 | 50 |  
| Frame & Roof | 35 | 9500 | 25 |  
| Varnish Floor | 15 | 750 | 25 |  
| Finish Flooring | 25 | 425 | 50 |  | 
The %EVA_EARNED_VALUE macro can then be called as follows:
 
    %eva_earned_value(
        revisesched=gasched,
        activity=activity,
        start=start,
        finish=finish,
        actualcost=gact,
        rate=rate,
        cost=cost,
        spct=spct,
        taskpv=bout,
        ev=gacost
    );
 
The periodic earned value data set 
 that is generated by %EVA_EARNED_VALUE is shown in Figure 9.2.7.
 
Output 9.2.7: %EVA_EARNED_VALUE: Periodic Data Set 
| 
 
| 04SEP04 | 2635.00 | 3205.00 |  
| 05SEP04 | 10.00 | 30.00 |  
| 06SEP04 | 10.00 | 30.00 |  
| 07SEP04 | 10.00 | 30.00 |  
| 08SEP04 | 10.00 | 30.00 |  
| 09SEP04 | 10.00 | 30.00 |  
| 10SEP04 | 10.00 | 30.00 |  
| 11SEP04 | 2635.00 | 3205.00 |  
| 12SEP04 | 385.00 | 705.00 |  
| 13SEP04 | 10.00 | 30.00 |  
| 14SEP04 | 1135.00 | 2055.00 |  
| 15SEP04 | 3460.00 | 3460.00 |  
| 16SEP04 | 321.25 | 321.25 |  
| 17SEP04 | 65.00 | 65.00 |  
| 18SEP04 | 7958.75 | 7958.75 |  
| 19SEP04 | 683.75 | 683.75 |  
| 20SEP04 | 971.25 | 971.25 |  
| 21SEP04 | 202.50 | 202.50 |  
| 22SEP04 | 40.00 | 40.00 |  
| 23SEP04 | 40.00 | 40.00 |  
| 24SEP04 | 202.50 | 202.50 |  
| 25SEP04 | 3098.33 | 3098.33 |  
| 26SEP04 | 65.00 | 65.00 |  
| 27SEP04 | 3231.67 | 3231.67 |  
| 28SEP04 | 2965.00 | 2965.00 |  
| 29SEP04 | 65.00 | 65.00 |  
| 30SEP04 | 4815.00 | 4815.00 |  
| 01OCT04 | 4772.50 | 4772.50 |  
| 02OCT04 | 422.50 | 422.50 |  
| 03OCT04 | 1235.00 | 1235.00 |  
| 04OCT04 | 6116.25 | 6116.25 |  
| 05OCT04 | 581.25 | 581.25 |  
| 06OCT04 | 25.00 | 25.00 |  
| 07OCT04 | 237.50 | 237.50 |  
| 08OCT04 | 890.00 | 890.00 |  
| 09OCT04 | 902.50 | 902.50 |  
| 10OCT04 | 1107.50 | 1107.50 |  
| 11OCT04 | 2298.75 | 2298.75 |  
| 12OCT04 | 55.00 | 55.00 |  
| 13OCT04 | 1680.00 | 1680.00 |  
| 14OCT04 | 25.00 | 25.00 |  
| 15OCT04 | 1881.25 | 1881.25 |  
| 16OCT04 | 202.50 | 202.50 |  
| 17OCT04 | 577.50 | 577.50 |  | 
The BUDGETCOST= parameter has been employed to capture the planned duration 
 and costs for each activity.  Next, the %EVA_METRICS macro is used to 
 produce statistics for the entire project.  For illustrative purposes, 
 a range of times from the start of the project to the revised 
 projected end date is used.  Typically, only actual status dates 
 would be used; in this case, perhaps September 4, 2004 and September 
 15, 2004.  Unless otherwise noted, the latter is the assumption for 
 the remainder of the macros in this example.
 
    %eva_metrics(
        pv=gbcost,
        ev=gacost,
        timenow='04SEP04'd '15SEP04'd '01OCT04'd '17OCT04'd
    );
 
The output listing is given in Figure 9.2.8.
 
Output 9.2.8: %EVA_METRICS: Summary Statistics
| 
 
| 4.54 | 17.78 | 68.59 | 100.00 |  
| 2645.00 | 20320.00 | 48197.50 | 58055.00 |  
| 2635.00 | 10320.00 | 39817.50 | 58055.00 |  
| 3205.00 | 12840.00 | 42337.50 | 60575.00 |  
| -570.00 | -2520.00 | -2520.00 | -2520.00 |  
| -21.63 | -24.42 | -6.33 | -4.34 |  
| -10.00 | -10000.00 | -8380.00 | 0.00 |  
| -0.38 | -49.21 | -17.39 | 0.00 |  
| 0.82 | 0.80 | 0.94 | 0.96 |  
| 1.00 | 0.51 | 0.83 | 1.00 |  
| 58055.00 | 58055.00 | 58055.00 | 58055.00 |  
| 60575.00 | 60575.00 | 60575.00 | 60575.00 |  
| 58625.00 | 60575.00 | 60575.00 | 60575.00 |  
| 70613.39 | 72231.22 | 61729.23 | 60575.00 |  
| 70869.21 | 129780.85 | 65810.42 | 60575.00 |  
| 67408.39 | 59391.22 | 19391.73 | 0.00 |  
| -12558.39 | -14176.22 | -3674.23 | -2520.00 |  
| -21.63 | -24.42 | -6.33 | -4.34 |  
| 1.01 | 1.06 | 1.16 | 0.00 |  
| 0.82 | 0.80 | 0.94 | 0.94 |  | 
 
 Observe that the Estimate To Complete (ETC) and Schedule 
 Performance Index (SPI) converge to 0 and 1, respectively, over time. 
 Also, the Actual Cost (AC) agrees with the various Estimates 
 At Completion (EAC's) at the projected completion date.
 
Next, the %EVA_TASK_METRICS macro is used to show an activity-level view of the progress of the project.
 
    %eva_task_metrics(
        activity=id,
        plansched=gbsched,
        revisesched=gasched,
        start=start,
        finish=finish,
        budgetcost=gbase,
        actualcost=gact,
        cost=cost,
        spct=spct,
        rate=rate,
        timenow='15SEP04'd,
        aggregate=Y
    );
 
The AGGREGATE= parameter is specified in order to roll up the values 
 with respect to the project hierarchy.  The output from this macro is shown in 
 Figure 9.2.9.
 
Output 9.2.9: %EVA_TASK_METRICS: Metrics by Activity
| 
 
| Build House | 0 | 20320.00 | 10320.00 | 12840.00 | -2520.00 | -24.42 | -10000.00 | -49.21 | 0.80 | 0.51 |  
| Landscaping | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Drainage | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Wiring | 0.02 | 665.00 | 0.00 | 0.00 | 0.00 | 0.00 | -665.00 | -100.00 | . | 0.00 |  
| Plumbing | 0.03 | 2165.00 | 1050.00 | 1050.00 | 0.00 | 0.00 | -1115.00 | -51.50 | 1.00 | 0.48 |  
| Foundation | 0.04 | 7850.00 | 6860.00 | 9380.00 | -2520.00 | -36.73 | -990.00 | -12.61 | 0.73 | 0.87 |  
| Roofing | 0.05 | 9640.00 | 2410.00 | 2410.00 | 0.00 | 0.00 | -7230.00 | -75.00 | 1.00 | 0.25 |  
| Flooring | 0.06 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Heat & Ventilation | 0.07 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Plaster | 0.08 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Brickwork | 0.09 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Paint | 0.10 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Finish Grading | 0.00.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Walks & Landscape | 0.00.1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Gutters & Downspouts | 0.01.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Storm Drains | 0.01.1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Initial Wiring | 0.02.0 | 665.00 | 0.00 | 0.00 | 0.00 | 0.00 | -665.00 | -100.00 | . | 0.00 |  
| Kitchen Fixtures | 0.02.1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Finish Electrical | 0.02.2 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Finish Carpentry | 0.02.3 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Rough Plumbing | 0.03.0 | 1115.00 | 0.00 | 0.00 | 0.00 | 0.00 | -1115.00 | -100.00 | . | 0.00 |  
| Basement Plumbing | 0.03.1 | 1050.00 | 1050.00 | 1050.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 |  
| Finish Plumbing | 0.03.2 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Excavate & Footers | 0.04.0 | 5330.00 | 5330.00 | 6590.00 | -1260.00 | -23.64 | 0.00 | 0.00 | 0.81 | 1.00 |  
| Pour Foundation | 0.04.1 | 1530.00 | 1530.00 | 2790.00 | -1260.00 | -82.35 | 0.00 | 0.00 | 0.55 | 1.00 |  
| Pour Basement | 0.04.2 | 990.00 | 0.00 | 0.00 | 0.00 | 0.00 | -990.00 | -100.00 | . | 0.00 |  
| Finish Roof | 0.05.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Frame & Roof | 0.05.1 | 9640.00 | 2410.00 | 2410.00 | 0.00 | 0.00 | -7230.00 | -75.00 | 1.00 | 0.25 |  
| Varnish Floor | 0.06.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Finish Flooring | 0.06.1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  | 
Output 9.2.10: %EVA_TASK_METRICS: Metrics by Activity (Continued)
| 
 
| Build House | 0 | 20320.00 | 10320.00 | 12840.00 | -2520.00 | -24.42 | -10000.00 | -49.21 | 0.80 | 0.51 |  
| Landscaping | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Drainage | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Wiring | 0.02 | 665.00 | 0.00 | 0.00 | 0.00 | 0.00 | -665.00 | -100.00 | . | 0.00 |  
| Plumbing | 0.03 | 2165.00 | 1050.00 | 1050.00 | 0.00 | 0.00 | -1115.00 | -51.50 | 1.00 | 0.48 |  
| Foundation | 0.04 | 7850.00 | 6860.00 | 9380.00 | -2520.00 | -36.73 | -990.00 | -12.61 | 0.73 | 0.87 |  
| Roofing | 0.05 | 9640.00 | 2410.00 | 2410.00 | 0.00 | 0.00 | -7230.00 | -75.00 | 1.00 | 0.25 |  
| Flooring | 0.06 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Heat & Ventilation | 0.07 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Plaster | 0.08 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Brickwork | 0.09 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Paint | 0.10 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Finish Grading | 0.00.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Walks & Landscape | 0.00.1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Gutters & Downspouts | 0.01.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Storm Drains | 0.01.1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Initial Wiring | 0.02.0 | 665.00 | 0.00 | 0.00 | 0.00 | 0.00 | -665.00 | -100.00 | . | 0.00 |  
| Kitchen Fixtures | 0.02.1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Finish Electrical | 0.02.2 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Finish Carpentry | 0.02.3 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Rough Plumbing | 0.03.0 | 1115.00 | 0.00 | 0.00 | 0.00 | 0.00 | -1115.00 | -100.00 | . | 0.00 |  
| Basement Plumbing | 0.03.1 | 1050.00 | 1050.00 | 1050.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 |  
| Finish Plumbing | 0.03.2 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Excavate & Footers | 0.04.0 | 5330.00 | 5330.00 | 6590.00 | -1260.00 | -23.64 | 0.00 | 0.00 | 0.81 | 1.00 |  
| Pour Foundation | 0.04.1 | 1530.00 | 1530.00 | 2790.00 | -1260.00 | -82.35 | 0.00 | 0.00 | 0.55 | 1.00 |  
| Pour Basement | 0.04.2 | 990.00 | 0.00 | 0.00 | 0.00 | 0.00 | -990.00 | -100.00 | . | 0.00 |  
| Finish Roof | 0.05.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Frame & Roof | 0.05.1 | 9640.00 | 2410.00 | 2410.00 | 0.00 | 0.00 | -7230.00 | -75.00 | 1.00 | 0.25 |  
| Varnish Floor | 0.06.0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  
| Finish Flooring | 0.06.1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | . | . |  | 
Next, the %EVG_COST_PLOT macro is called to show the 
 Planned Value (PV), Earned Value (EV), Actual Cost (AC), and revised 
 cost plots.
 
    %evg_cost_plot;
 
The plot is shown in Figure 9.2.11.
 
Output 9.2.11: %EVG_COST_PLOT,PV,EV,AC and Revised Cost 
The %EVG_SCHEDULE_PLOT macro is used to show different estimates of the project completion date.
 
    %evg_schedule_plot;
 
The plot is shown in Figure 9.2.12.
 
Output 9.2.12: %EVG_SCHEDULE_PLOT: Estimated Completion Dates 
The %EVG_INDEX_PLOT macro is used to graphically display the performance indices for the project.
 
    %evg_index_plot;
 
The plot is shown in Figure 9.2.13.  As in the previous 
 example, the cost performance needs to increase from 0.8 to 
 1.06 in order to stay within the budget.
 
Output 9.2.13: %EVG_INDEX_PLOT: CPI,SPI,and TCPI 
The Cost and Schedule Variance for the project is shown in Figure 9.2.14 
 using the following call to the %EVG_VARIANCE_PLOT macro:
 
    %evg_variance_plot;
 
Output 9.2.14: %EVG_VARIANCE_PLOT: Cost and Schedule Variance 
While the Cost Variance is just outside the 10% threshold, the 
 Schedule Variance is significantly outside and should be a warning 
 signal that the project is slipping significantly.  The plan 
 called for $20,320 of work to be completed, but only $10,320 
 has been accomplished so far (roughly 50% of the goal).
 
Finally, the %EVG_GANTT_CHART macro is used to show a Gantt view of the 
 project along with some metrics by task.  In this case, only 
 the Work Breakdown Structure code and Cost Variance (CV) and 
 Schedule Variance (SV) are selected.
 
    %evg_gantt_chart(
        activity=id,
        plansched=gbsched,
        revisesched=gasched,
        start=start,
        finish=finish,
        timenow='15SEP04'd,
        id=wbs cv sv,
        height=3,
        scale=20
    );
 
The resulting Gantt chart is shown in Figure 9.2.15.
 
Output 9.2.15: %EVG_GANTT_CHART: Cost and Schedule Variance by Task