20230929IPC to Staff Supplemental 293 Attachment 1.pdf

VARI130001 - VARI Replace communications multiplex equipment
Variance Notes

CLRIS Budget ID Page (Description, Need, Consequence and notes)
VARI130001_CLRIS
VARI130001_Solution_CLRIS

Authorized to Spend = $14.4M
Actuals = $14.7M

2012
5/29/2012 (PN): Converted SRT-recommended Solution 4819 to Project/BudgetID per management
approval. Set Solution status to 'Completed'; 7/18/2012 (PN): $100k in 2012 to start work in 2012;
10/29/12 (Van Patten): As requested by Vern Porter and Ed Helms, this budget ID will be combined with
VARI130002 and VARI130003. Updated scope, need and increased 2013 and 2014 budgets to $7.05M
and $3.45M respectively to accommodate all work;
Budget Update Authorized to Spend

2013
4/9/13 (Van Patten): Increased 2015 budget from $0 to $450k and increased 2014 budget from $3.45M
to $5.1M to accommodate CIP work to be recast into this project. Changed in-service date to 2015;
5/21/2013 (PN): Increased 2013 budget from $7.05M to $7.15M, 2014 from $5.1M to $5.25M per PL,
Mgt, May PPC; 8/20/2013 (PN): Increased 2013 budget from $7.15M to $7.3M, increased 2014 from
$5.25M to $5.3M, per PL, August PPC; 10/24/2013 (PN): Incr 2014 budget from $5.3M to $5.7M per PL,
Oct PPC. . . . . 10/15/2013 (PN): Increased 2013 budget from $7.3M, to $8.5M, did not yet increase 2014
budget (to $5.7M), per PL, OSVP, October PPC; 12/17/2013 (PN): Reduced 2013 budget from $8.5M to
$7.85M, increased 2014 budget from $5.7M to $6.35M per PL, Dec PPC
Budget Update Authorized to Spend

2014
1/21/2014 (PN): 2014 budget from $6.35M to $6.38M per PL, January PPC; 5/20/2014 (PN): Reduced
2014 budget from $6.38M to $6.13M per PL, May PPC; 10/14/2014 (PN): Reduced 2014 budget from
$6.05M to $5.75M, increased 2015 frm $530k to $830k per PL, Oct PPPC
Budget Update Authorized to Spend

2015
6/17/2015 (PN): Increased 2015 budget from $830k to $865k per June PPC; 7/16/2015 (PN): Increased
2015 budget from $865k to $915k per PL, July PPPC
Budget Update Authorized to Spend

Microsoft Project Schedule Notes (PM managed schedules and routine variance notes)

5/2012
Project was identified and approved, thus no budget for 2012 work.
Current Year = $100,000
Total FAC= $ = $100,000

11/2012
Current Year =$254,716
Total FAC=$10,754,716
VARI130001, VARI130002 (Cisco Routers), and VARI130003 (NEC Microwave Radios) projects were
combined to one project (VARI130001). Updated scope and planned 2013 and 2014 forecasts to
accommodate all work (identified 2013 forecast as $5,200,000 but budget was not updated as the timing
was after the annual budget cycle).

4/2013
Current Year =$7,050,000
Total FAC= $12,854,716
Total FAC Change: $2.1M increase
Transferred forecast of $2,100,000 for the inclusion of Critical Infrastructure Protection (CIP).
Budget Update Authorized to Spend

5/2013
Current Year = $7,150,000
Total FAC= $13,104,716
Total FAC Change: $250k increase
Transfer $100k from VARISTAT for Webmon, $135k from TFSN110101, And increase 20k for Loaded rates
Budget Update Authorized to Spend

8/2013
Current Year =$7,300,000
Total FAC=$13,304,716
Total FAC Change: $200k increase
Transferred $132k from video project for for SNBK, increase of $68k for additional materials.

10/2013
Current Year =$8,500,000
Total FAC= $14,904,716
Total FAC Change: $1.6M
Spend was increased to account for training and additional materials
Budget Update Authorized to Spend

12/2013
Current Year =$7,850,000
Total FAC=14,904.716
Total FAC Change: no change

1/2014
Current Year =$6,380,000
Total FAC=$1,902,845
Total FAC Change: $(1,871)
5/2014
Current Year = $6,130,000
Total FAC= $14,652,845
Total FAC Change: $ (250,000)
Decrease of due to reestimate based on previous year performance, an increase was required for
replacement of Revenue and Power Quality meters needing ethernet connections
Budget Update Authorized to Spend

10/2014
Current Year = $5,750,000
Total FAC= Total FAC Change: $$14,652,845
Total FAC Change: no change
Due to resource availability constraints, additional work from 2014 transferred to 2015.
Budget Update Authorized to Spend