Please enable JavaScript.

Coggle requires JavaScript to display documents.

Enterprise: Egovernment = $7,234,063 / 14,099.99 FTE's = $516.35 per…

- - - - [Enterprise Rates] Egov!I19 = $6,524,513 = I17 + I18
        
        I17=$4,103,685 = Sum(I15:I16)
        
        I15 = $1,920,335 = Sum (I11:I14)
        
        I11 = $1,671,009 = Sum(I6:I10) = sum of salary and benefit costs for 5FTEs sourced from the FTE by Group file
        
        I12 = $20,000 = "Software/tools" = 2,000 (plug#) X 5 FTE's X 2
        
        I14 = $210,000 = "IT Support" = 5 FTE's X 2 X IT Support!E18
        
        IT Support!E18 = the $21,000/FTE/Year charge for staff support we have traced out on other sheets.
        
        I13 = $1932.50/FTE/Yr = "Support/PM/BA OH Rate
        
        I16 = $2,183,350 = "Non Labor" = [Proposed Additional Budget_Feb2018v2]Non-BSS and UC!C54 (We don't have this file)
        
        I18 = $2,420,827 = PaaS = [Platform Budget & Rates]Rates 2019-2020!B16 X 2
        
        B16 = $1,210,414.43 = Sum(PaaS-DCE!B5:B63)
        
        B5 = $941,098 = "Labor" = 4 FTE's X $235,275 = avg. cost per FTE for 8.8 FTE's in the Platform Group. Salaries and benefits come from the FTE by Group file.
        
        B6:B10 are a series of plug#s for Licenses
        
        B16:B49 are unit costs for individual servers that are based on plug#s
        
        B52 = 2.3TB X cost per TB of storage (plug#s)
        
        B53 adds an incrmental storage cost by assuming the cost per TB inflates by 15% for both 2019 and 2020
        
        B57 = 4 FTE's X a Tools and Auto rate per FTE which is based on a plug# that is based on a Quote from T&A
      - [Tools and Auto]Consolidated Detail!M66 = $219,060 = Sum(M61:M64)
        
        M64 = Certificate Services = $177,688 = I64 + K64
        
        K64 =SUM(Labor Cost!O17:O18
        
        Labor Cost! O17 and O18 = $81,344 + $81,344 Allocates a portion of Tools & Automation Support staff costs for 2 FTEs to eGov. This includes salaries and benefits costs sourced from the FTE by Group file, plus the Tools and Auto OH Rate.
        
        I64 = $15,000 = "Software" =SUM(Software!G29:H29 / 2
        
        Software!G29:H29 = $15,000 + $15,000 = "Web Server Certificates". Plug numbers. A note says this cost is charged to BSS/eGov, so presumably this cost is split 50/50 between the two since the formula above divides this cost by 2.
        
        M61 = $41,373 = Labor Costs!O20 + Labor Costs!O5
        
        Labor Costs!O5 = $41,373 = "Tools & Automation Support to eGov" = the allocation of a portion of 1FTE's salary and benefit costs and other support costs to eGov. The salary and benefit costs come from the FTE by Group file plus the Tools and Auto OH Rate
        
        LaborCosts!O20 = blank
        
        M62 and M63 are blank