Please enable JavaScript.

Coggle requires JavaScript to display documents.

Enterprise: IT Security = 10,530,683/14,009.99 FTE's = $751.66 per FTE…

- - - - This includes Services Repair Maintenance IT Equip, approximately $1.4 million, Misc Service Charges, approximately $205K, and TT ITS costs, approximately $737K. allocated to Security. The Services Repair Maintenance costs come from Enterprise K114 and L114, the Misc Service Charges reference to a variety of line items that are plug #'s that appear to be from cut and pasting a budget file.
        
        K114 and L114 costs for 2019 and 2020, and are subsets of a long list of IT equipment related to security. The lists is based on plug#s for 2017, inflated bu 2.5% to 2018, 3.1% for 2019, and 3.1% for 2020.
    - - Consolidated Detail!M56 = $177,687 = the cost of Security & Certificate Services under Ent Application and Platform services = Labor Costs = Labor Cost!K17 + K18 plus software = Sum(Software!G29:H29)/2
        
        Labor Costs! K17 and K18 include salary and benefits for a fraction of two staff (eventually sourced back to FTE by Group file and include the Tools and Auto OH rate and also include PM and Admin/Management,
      - Consolidated Detail M26 = $325,374 = Labor costs of Server Product Package (Compute) = Labor Cost!L17 + L18
        
        Labor Costs! L17 and L18 include salary and benefits for a fraction of two staff (eventually sourced back to FTE by Group file) plus the Tools and Auto OH rate
      - Consolidated Detail!M17 = $201,987 = Labor and IT to IT Costs under Tools and Automation - Products. The labor costs come from Labor!M17+M18 and the IT to IT costs come from IT to IT!E10
        
        Labor Costs! M17 and M18 include salary and benefits for a fraction of two staff (eventually sourced back to FTE by Group file), plus the Tools and Auto OH rate
        
        IT to IT E10 = the cost of security for servers = $39,300 = Compute!G17 = a rate of 6550 per server X 6 servers, both of which are plug numbers.
    - - This includes labor, 5 FTEs =$1,881,796 (from FTE by Group file), Pus $21,000/FTE/yr IT Support + Non-Labor Costs = $3,584,766 = [Proposed Additional Budget_Feb2018v2]Non-BSS and UC!C39
        
        Note: Staff Support Costs = $210,000 are calculated as a per FTE cost of $21,000 which is comprised of Facilities, Supplies/Copier/Cellphones. Workstations, Training, and Misc. I wonder whether this $21,000 for staff support is applied consistently across all FTEs and all rates.
        
        NonLabor costs = $3,584,766 = [Proposed Additional Budget_Feb2018v2]Non-BSS and UC!39 adds a lot of plug#s for new software and services that appear to be security-related.
        
        Staff salaries and benefits for 5 FTE's from FTE by Group file