Budget Presentation - Additional Information


TO:

 

HONORABLE ELI BEBOUT

HONORABLE STEVE HARSHMAN


FROM:

Flint Waters, State Chief Information Officer

 

SUBJECT:

 

Budget Presentation - Additional Information

 

DATE:

 

December 12, 2013

 

CC:

 

Tony Young, Deputy Chief of Staff, Office of the Governor


EXECUTIVE SUMMARY:

On December 10, 2013, the Department of Enterprise Technology Services (ETS) presented its proposed budget to the Joint Appropriations Committee (JAC). During the presentation, additional information was requested.


Specifically, the committee asked for methods that would help document the impact of creating ETS and moving to a zero-based budget. It is a very challenging question to accurately calculate comparisons, so please consider:


In areas like office supplies or travel it is possible to break down the budgeted costs per employee for a presumptive comparison.

  • BFY 2009-2010 ITD/CIO budget - 130 FTE count

    • Travel = $3,069 per FTE

    • Office Supplies = $4,410 per FTE

  • BFY 2011-2012 ITD/CIO budget - 132 FTE count

    • Travel = $2,893 per FTE

    • Office Supplies = $4,538 per FTE

  • BFY 2013-2014 ETS budget - 286 FTE count

    • Travel = $2,129 per FTE

    • Office Supplies = $2,735 per FTE

  • BFY 2015-2016 ETS budget request - 290 FTE count

    • Travel = $2,128 per FTE

    • Office Supplies = $958 per FTE


If you took a similar approach in consideration of the Agency as a whole, you would see interesting shifts.

  • In 2009-2010, the combined funding for ITD/CIO was $62,956,696 with 130 FTEs.

  • In 2011-2012, the combined funding for ITD/CIO was $67,343,593 with 132 FTEs.

  • In 2013-2014, the combined funding for ETS was $109,604,409* with 286 FTEs.

  • The requested 2015-2016 ETS funding request is $131,129,138 with 290 FTEs.

    • This includes $15.8 million, a one time ask for the Unified Network and $2 million, a one time ask for power upgrade.

    • BFY 2013-2014 includes all money moved to ETS during consolidation and assumption of the Unified Network which significantly impacts per employee calculation.


Following the same comparison approach:

  • For budget 2011 to 2015, the Agency FTE count increased by 220%

  • For budget 2011 to 2015, the Agency budget increased by 195%

If you remove the Unified Network enhancement and capcon electrical upgrade one time asks:

  • For budget 2011 to 2015, the Agency budget increased by 168%

    • These reductions are occurring during a period of increased responsibility for the Agency in support of over 400 education sites with significant impact to our help desk and other services.


DETAILS REQUESTED:

  • Breakdown of employee training and professional development dollars

    • Total amount for 225 FTEs = $726,500.00

      • $1,614.44 per FTE annually

    • Total amount for 65 Direct Bill FTEs = $264,000.00

      • $2,030.77 per FTE annually


  • Total travel (in and out of state) dollars

    • Total amount for 225 FTEs = $269,396.00

      • $598.66 per FTE annually

    • Total amount for 65 Direct Bill FTEs = $272,756.00

      • $2,098.12 per FTE annually


  • Breakdown of cellular device types and counts by agency

    • Total cellular devices = 3,697

    • Breakout of types and counts by agency is included in Attachment A


  • Number of servers by agency

    • Total Servers = 1,934

      • 878 physical servers

      • 1,056 virtual servers

        • 573 within agency virtual environments

        • 483 within the Wyoming Government Cloud

    • Detailed breakdown is included in Attachment B


  • Agency perspective of server savings

    • We would recommend an objective review directly with the Directors from Geological Survey, the Department of Environmental Quality (DEQ), State Archives as well as the State Librarian


  • Documentation of the DEQ server-to-service move and increased 0400 series request

    • Total Servers 95

    • Physical Servers 12

    • Virtual Servers 83

    • DEQ has been very forward thinking in moving 75 of their 83 virtual servers into the Wyoming cloud. This represents the increase in 0400 series requests as these servers would have previously shown up as periodic requests in 0242.


  • Best estimate of budget BFY 2013-14 to BFY 2015-16 comparison as presented.

    Source

    BFY13-14 Totals

    BFY15-16 Budget

    BFY15-16

    New Items

    Amount

    BFY15-16 Without New Items

    Difference Without New Items

    General Fund

    41,062,282

    53,916,016


    11,799,246

    41,816,770

    754,488




    Unified Network  (State) Build

    9,799,246






    Capital Construction

    2,000,000










    Internal Service Fund

    50,299,857

    52,221,588


    2,383,442

    49,838,146

    -461,711




    Cloud Use Increase

    1,123,407






    SWICAP Increase

    1,260,035










    School Foundation Fund

    18,242,270

    24,991,534


    11,076,271

    13,915,263

    -4,327,007




    Unified Network (WEN) Build

    5,892,271






    SLDS Build

    5,184,000



    TOTALS

    $109,604,409*

    $131,129,138


    $25,258,959

    $105,570,179

    $-4,034,230


    *The $109,604,409 amount is the combination of funds received for the 2013-2014 budget plus the supplemental for FY 2014 and funding transferred from agencies during the phases of IT consolidation. Additionally, a dollar amount was calculated for the funding which resided in other agency budgets during FY 2013 to pay for what are now ETS employees and included to reflect a more comprehensive, holistic BFY 2013-2014 budget.