Please enable JavaScript.

Coggle requires JavaScript to display documents.

Application Compute Cost Map $32,364,018 = Support Ops Maint!E11 (Support…

- - - - J24 = $99,969 = IT to IT = IT to IT!E5 X Service and Customers!C5
        
        IT to IT!E5 = $132,292 = "Automation" = Sum(B5:D5)
        
        C5 = $30,144 = "Database Automation" = Compute!H12
        
        Compute!G12, H12, and I12 are allocating server costs to Tools and Auto - Automation. G12 allocates 11 Servers to Automation at a cost of $6,550 per server. H12 allocates 12 servers to Automation-DB at a cost of $2,512 per server. I12 allocates a plug# of $31,098 to storage. The number of servers and the cost per server are all plug numbers. Question: is the cost per server an annual or biennial cost?
        
        D5 = $31,098 = "Storage Automation" = Compute!I12
        
        B5 = $72,050 = "Server Automation" = Compute!G12
        
        Service and Customers!C5 = % of Automation Costs Allocated to Prod Ops Compute = 75%
      - K24 = $299,502.95 = Labor Cost = Labor Cost!L6 = J6 X Service and Customers C5 This is allocated a % of 1 FTE with salaries and benefits from FTE by Group file and the Tools and Auto OH Rate
    - - K23 = $111,503.77 = "Labor Cost" = Labor Cost!L11 = Service and Customers!C7 X J11
        
        Service and Customers!C7 = 30%
        
        J11 = $371,679 = Salary and benefits for 1 FTE sourced from the FTE by Group file + Overhead costs at the Tools and Auto rate
      - J23 = $66749.70 = "IT to IT" = IT to IT!E7 X Service and Customers!C7
        
        IT to IT E7 = $222,469 = Sum(B7:D7)
        
        Service and Customers!C7 = % of Monitoring Costs allocated to Prod Ops Compute = 30%
    - - Software!G26 + H26 = $172,252 + $172,252 = 2019 & 2020 Costs of "Log Analysis and Monitoring(SPLUNK) = [SplunkCost19_20]Sheet1L43/2 (We don't have this file)
      - Service and Customers!C7 = % of Monitoring Costs allocated to Prod Ops Compute = 30%.
  - - - IT to IT!E7 = $222,469 = "Monitoring" = Sum(B7:D7)
        
        Note: SumB7:D7 reference the Compute file where the cost a number of servers and cost of servers are devoted to this function and these are all plug#s.
      - Service and Customers!D7 = 20%
    - - Service and Customers! D7 = 20%
      - Sum(Software!G26:H26) = $172,000 + $172,000 = Log Analysis and Alerting (SPLUNK) = [SplunkCost19_20]Sheet1L43 / 2 (Series of detailed plug#s describing the cost of SPlunk)
    - - LaborCost!J11 = $371,679 = salary and benefit costs for 1 FTE sourced from the FTE by Group file, + Overhead costs at the Tools and Auto rate.
      - Service and Customers!D7 = 20%
  - - - M50 = $165,490.42 = Labor Cost of .4 of Katie Suvlu = Labor Cost!K5 + Labor Cost!K19 Salary and benefits from FTE by Group folder, + Tools and Auto OH amount, X 40% (Service and Customers % Allocated to Prod Ops Compute)
      - M56 = $177,687.15 = "Security and Certificate Services = I56 + K56
        
        I56 = $15,000 = "Software" = Sum(Software!G29:H29) / 2 (Note: Software G29 & H29 are plug#s of $15,000 per year for Web Server Certificates. Don't know why these annual costs would be divided by 2.
        
        K56 = $162.687.15 = "Labor Cost" = Sum(Labor Cost!K17:K18) Labor Cost!K17 & K18 allocate 20% of 2 FTE's to Security for BSS. Salary and benefits for these two FTEs are sourced from the FTE by Group file, and the Tools and Auto overhead rate is added.
      - M51 = $66,740.70 = IT to IT Costs = IT to IT!E7 X Service and Customers!H7 (40% of $222,469 of "Monitoring" costs are allocated to "BSS" (Service and Customers H7) These costs are sourced from the "Compute" tab where plus#s for servers and cost per server are identified.
      - M55 = $24,000 = "SPO - group file storage" = I55 = Sum(Software!G14:H14) = $24,000 (plug#)
      - M52 = $214,854.75 = "Log Analysis and Analytics (Splunk) = I52 + K52
        
        I52 = $103,350.99 = "Software" = Software!(G26:H26) X Service and Customers!H7
        
        K52 = $111,503.77 = "Labor Cost" = Labor Cost!K11
      - M54 = $0
      - M53 = $389,892.36 = "CRM Online Platform" = J53 + L53
        
        J53 = $73,158 = "IT to IT" = IT to IT!E9 (These costs are sourced from the "Compute" tab where plug#s for servers and cost per server are identified
        
        L53 = $316,734.36 = "Labor Costs" = Sum(Labor Cost!K12:K16) (This is allocated 20% of 4 people's time to "Tools and Automation Support to BSS". Salary and benefits from FTE by Group file + Tools and Auto Overhead rate
      - M57 = $175,000 = "Automation" = I57 = Software!F51 = plug number labeled as a price estimate for Application Performance Mnagement software