General discussion

Locked

Staff Size help

By trtjj ·
I am a fairly new IT director at this organization. I am designing a new infrastructure and I am adding services. I would like to know if anyone has references for IT department sizes. I had a proposal to hire a network admin and a Systems admin on top of the help desk person that I already have. The Executive staff is questioning my proposal and they feel all they need is another help desk person. They want me to manage all the services. We are an organization of 100 people. Our organization runs our own conferences and we are a membership based business. Besides the basic services of Email and Internet, we will be running Share point , communication server, Oracle, MS SQl for Great Plains, E-commerce, VoIP, Web conf and Wireless.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Under question

by boisjm In reply to Staff Size help

What are their concerns ? Have you already communicated the targeted benefits ? Is it possible to mesure those ? It seems that the most important thing for your Executive staff is the endusers benefits, do you have some problems on the part of this team ? Too ticket number are hold ? If the endusers benefits should be increased, find a solution to increase on that and don't forget other needs...

Collapse -

by alain.aucordier@any-mail In reply to Staff Size help

a good solution is to rely on Benchmarks. i personnaly used either Compass or Mercer in the past, but as your company is merely big enough, the answer won't be probably signficant (one figure answer). Size of development teams are unpredictable as too much business related, but infrastructure team can be reasonably sized.A template may assist (copy the XML below in Excel).
<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>Alain Aucordier</Author>
<LastAuthor>Alain Aucordier</LastAuthor>
<Created>2005-11-14T21:31:23Z</Created>
<LastSaved>2005-11-14T22:52:30Z</LastSaved>
<Company>Art Of Net</Company>
<Version>10.6735</Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
<DownloadComponents/>
<LocationOfComponents HRef="file:///\\"/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>8955</WindowHeight>
<WindowWidth>15195</WindowWidth>
<WindowTopX>0</WindowTopX>
<WindowTopY>15</WindowTopY>
<ActiveSheet>1</ActiveSheet>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s21">
<NumberFormat ss:Format="Fixed"/>
</Style>
<Style ss:ID="s22">
<Font x:Family="Swiss" ss:Bold="1"/>
</Style>
<Style ss:ID="s24">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
<Font x:Family="Swiss" ss:Bold="1"/>
</Style>
<Style ss:ID="s25">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
<Font x:Family="Swiss" ss:Bold="1"/>
<NumberFormat ss:Format="Fixed"/>
</Style>
<Style ss:ID="s26">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
</Style>
<Style ss:ID="s27">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
<Font x:Family="Swiss" ss:Bold="1"/>
<NumberFormat ss:Format="0"/>
</Style>
<Style ss:ID="s28">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
<NumberFormat ss:Format="0"/>
</Style>
<Style ss:ID="s30">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Font x:Family="Swiss" ss:Bold="1"/>
</Style>
<Style ss:ID="s31">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Font x:Family="Swiss" ss:Bold="1"/>
<NumberFormat ss:Format="Fixed"/>
</Style>
<Style ss:ID="s32">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<NumberFormat ss:Format="Fixed"/>
</Style>
<Style ss:ID="s33">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Font x:Family="Swiss" ss:Bold="1"/>
</Style>
<Style ss:ID="s34">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Font x:Family="Swiss" ss:Bold="1"/>
<NumberFormat ss:Format="Fixed"/>
</Style>
</Styles>
<Worksheet ss:Name="Parameters">
<Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="104" x:FullColumns="1"
x:FullRows="1">
<Column ss:Index="2" ss:Width="67.5"/>
<Column ss:Width="262.5"/>
<Column ss:StyleID="s26" ss:AutoFitWidth="0"/>
<Column ss:StyleID="s28" ss:AutoFitWidth="0"/>
<Column ss:StyleID="s21" ss:AutoFitWidth="0"/>
<Row ss:StyleID="s24">
<Cell><Data ss:Type="String">Category</Data></Cell>
<Cell><Data ss:Type="String">Key</Data></Cell>
<Cell><Data ss:Type="String">Question</Data></Cell>
<Cell><Data ss:Type="String">Answer</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="String">Proposal</Data></Cell>
<Cell ss:StyleID="s25"><Data ss:Type="String">FTEs</Data><Comment
ss:Author="Alain Aucordier"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
html:Size="8" html:Color="#000000">FTE: Full Time Equivalent Employee</Font></B><Font
html:Face="Tahoma" html:Size="8" html:Color="#000000">
</Font></ss:Data></Comment></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Desktop</Data></Cell>
<Cell><Data ss:Type="String">NWDSK</Data></Cell>
<Cell><Data ss:Type="String">Number of Windows Desktops</Data></Cell>
<Cell><Data ss:Type="Number">2000</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/120"><Data ss:Type="Number">16.666666666666668</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Desktop</Data></Cell>
<Cell><Data ss:Type="String">NWLAP</Data></Cell>
<Cell><Data ss:Type="String">Number of Windows Laptops</Data></Cell>
<Cell><Data ss:Type="Number">300</Data></Cell>
<Cell ss:Formula="=VLOOKUP("NWDSK",C[-3]:C[-1],3,FALSE)*15%"><Data
ss:Type="Number">300</Data></Cell>
<Cell ss:Formula="=RC[-2]/120*1.2"><Data ss:Type="Number">3</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Desktop</Data></Cell>
<Cell><Data ss:Type="String">NPDA</Data></Cell>
<Cell><Data ss:Type="String">Number of PDAs</Data></Cell>
<Cell><Data ss:Type="Number">80</Data></Cell>
<Cell ss:Formula="=VLOOKUP("NWLAP",C[-3]:C[-1],3,FALSE)*50%"><Data
ss:Type="Number">150</Data></Cell>
<Cell ss:Formula="=RC[-2]/120*1.3"><Data ss:Type="Number">0.8666666666666667</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Desktop</Data></Cell>
<Cell><Data ss:Type="String">NBUSAPP</Data></Cell>
<Cell><Data ss:Type="String">Number of Business Applications installed on the desktop</Data></Cell>
<Cell><Data ss:Type="Number">50</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=IF(RC[-2]>5,MIN(RC[-2]/10,1),0)"><Data ss:Type="Number">1</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Desktop</Data></Cell>
<Cell><Data ss:Type="String">NCOUNTRIES</Data></Cell>
<Cell><Data ss:Type="String">Number of Countries to Manage</Data></Cell>
<Cell><Data ss:Type="Number">14</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=IF(RC[-2]>1,MIN(RC[-2]/4,1),0)"><Data ss:Type="Number">1</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Desktop</Data></Cell>
<Cell><Data ss:Type="String">NBUILDINGS</Data></Cell>
<Cell><Data ss:Type="String">Number of Buildings to Manage</Data></Cell>
<Cell><Data ss:Type="Number">14</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=IF(RC[-2]>1,MIN(RC[-2]/R[-1]C[-2]/4,2),0)"><Data
ss:Type="Number">0.25</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Desktop</Data></Cell>
<Cell><Data ss:Type="String">NFLOORS</Data></Cell>
<Cell><Data ss:Type="String">Number of Floors to Manage</Data></Cell>
<Cell><Data ss:Type="Number">50</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=IF(RC[-2]>1,MIN(RC[-2]/R[-1]C[-2]/R[-2]C[-2]/6,1),0)"><Data
ss:Type="Number">4.2517006802721087E-2</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Windows</Data></Cell>
<Cell><Data ss:Type="String">NWINFRA</Data></Cell>
<Cell><Data ss:Type="String">Number Of Windows Infrastructure Servers</Data></Cell>
<Cell><Data ss:Type="Number">200</Data></Cell>
<Cell ss:Formula="=VLOOKUP("NWDSK",C[-3]:C[-1],3,FALSE)*10%"><Data
ss:Type="Number">200</Data></Cell>
<Cell ss:Formula="=RC[-2]/70"><Data ss:Type="Number">2.8571428571428572</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Windows</Data></Cell>
<Cell><Data ss:Type="String">NWMIDDLE</Data></Cell>
<Cell><Data ss:Type="String">Number Of Windows Middleware Servers</Data></Cell>
<Cell><Data ss:Type="Number">20</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/50"><Data ss:Type="Number">0.4</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Windows</Data></Cell>
<Cell><Data ss:Type="String">NWAPPS</Data></Cell>
<Cell><Data ss:Type="String">Number Of Windows Application Servers</Data></Cell>
<Cell><Data ss:Type="Number">80</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/100"><Data ss:Type="Number">0.8</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Windows</Data></Cell>
<Cell><Data ss:Type="String">NWDBS</Data></Cell>
<Cell><Data ss:Type="String">Number Of Windows Database Servers</Data></Cell>
<Cell><Data ss:Type="Number">12</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/50"><Data ss:Type="Number">0.24</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Unix</Data></Cell>
<Cell><Data ss:Type="String">NXINFRA</Data></Cell>
<Cell><Data ss:Type="String">Number Of Unix Infrastructure Servers</Data></Cell>
<Cell><Data ss:Type="Number">200</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/70"><Data ss:Type="Number">2.8571428571428572</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Unix</Data></Cell>
<Cell><Data ss:Type="String">NXMIDDLE</Data></Cell>
<Cell><Data ss:Type="String">Number Of Unix Middleware Servers</Data></Cell>
<Cell><Data ss:Type="Number">100</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/50"><Data ss:Type="Number">2</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Unix</Data></Cell>
<Cell><Data ss:Type="String">NXAPPS</Data></Cell>
<Cell><Data ss:Type="String">Number Of Unix Application Servers</Data></Cell>
<Cell><Data ss:Type="Number">80</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/100"><Data ss:Type="Number">0.8</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Unix</Data></Cell>
<Cell><Data ss:Type="String">NXDBS</Data></Cell>
<Cell><Data ss:Type="String">Number Of Unix Database Servers</Data></Cell>
<Cell><Data ss:Type="Number">80</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/100"><Data ss:Type="Number">0.8</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Legacy</Data></Cell>
<Cell><Data ss:Type="String">NOMIDDLE</Data></Cell>
<Cell><Data ss:Type="String">Number Of Legacy Middleware Servers</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/20"><Data ss:Type="Number">0</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Legacy</Data></Cell>
<Cell><Data ss:Type="String">NOAPPS</Data></Cell>
<Cell><Data ss:Type="String">Number Of Legacy Application Servers</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/20"><Data ss:Type="Number">0.5</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Legacy</Data></Cell>
<Cell><Data ss:Type="String">NODBS</Data></Cell>
<Cell><Data ss:Type="String">Number Of Legacy Database Servers</Data></Cell>
<Cell><Data ss:Type="Number">15</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/20"><Data ss:Type="Number">0.75</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Printers</Data></Cell>
<Cell><Data ss:Type="String">NNPRINT</Data></Cell>
<Cell><Data ss:Type="String">Number of Network Printers</Data></Cell>
<Cell><Data ss:Type="Number">200</Data></Cell>
<Cell ss:Formula="=VLOOKUP("NWDSK",C[-3]:C[-1],3,FALSE)*10%"><Data
ss:Type="Number">200</Data></Cell>
<Cell ss:Formula="=RC[-2]/200"><Data ss:Type="Number">1</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Printers</Data></Cell>
<Cell><Data ss:Type="String">NSPRINT</Data></Cell>
<Cell><Data ss:Type="String">Number of Standalone Printers</Data></Cell>
<Cell><Data ss:Type="Number">200</Data></Cell>
<Cell ss:Formula="=VLOOKUP("NWDSK",C[-3]:C[-1],3,FALSE)*10%"><Data
ss:Type="Number">200</Data></Cell>
<Cell ss:Formula="=RC[-2]/400"><Data ss:Type="Number">0.5</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Databases</Data></Cell>
<Cell><Data ss:Type="String">NPRDDB</Data></Cell>
<Cell><Data ss:Type="String">Number of Production Databases</Data></Cell>
<Cell><Data ss:Type="Number">50</Data></Cell>
<Cell
ss:Formula="=(VLOOKUP("NWAPPS",C[-3]:C[-1],3,FALSE)+VLOOKUP("NXAPPS",C[-3]:C[-1],3,FALSE)+VLOOKUP("NOAPPS",C[-3]:C[-1],3,FALSE))/3"><Data
ss:Type="Number">56.666666666666664</Data></Cell>
<Cell ss:Formula="=RC[-2]/50"><Data ss:Type="Number">1</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Databases</Data></Cell>
<Cell><Data ss:Type="String">NDEVDB</Data></Cell>
<Cell><Data ss:Type="String">Number of Development Databases</Data></Cell>
<Cell><Data ss:Type="Number">50</Data></Cell>
<Cell
ss:Formula="=(VLOOKUP("NWAPPS",C[-3]:C[-1],3,FALSE)+VLOOKUP("NXAPPS",C[-3]:C[-1],3,FALSE)+VLOOKUP("NOAPPS",C[-3]:C[-1],3,FALSE))/3"><Data
ss:Type="Number">56.666666666666664</Data></Cell>
<Cell ss:Formula="=RC[-2]/30"><Data ss:Type="Number">1.6666666666666667</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Databases</Data></Cell>
<Cell><Data ss:Type="String">NTSTDB</Data></Cell>
<Cell><Data ss:Type="String">Number of Test/Certification Databases</Data></Cell>
<Cell><Data ss:Type="Number">50</Data></Cell>
<Cell
ss:Formula="=(VLOOKUP("NWAPPS",C[-3]:C[-1],3,FALSE)+VLOOKUP("NXAPPS",C[-3]:C[-1],3,FALSE)+VLOOKUP("NOAPPS",C[-3]:C[-1],3,FALSE))/3"><Data
ss:Type="Number">56.666666666666664</Data></Cell>
<Cell ss:Formula="=RC[-2]/30"><Data ss:Type="Number">1.6666666666666667</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Network</Data></Cell>
<Cell><Data ss:Type="String">NLANPORT</Data></Cell>
<Cell><Data ss:Type="String">Number of LAN Ports</Data></Cell>
<Cell><Data ss:Type="Number">3500</Data></Cell>
<Cell
ss:Formula="=VLOOKUP("NWDSK",C[-3]:C[-1],3,FALSE)+VLOOKUP("NWLAP",C[-3]:C[-1],3,FALSE)+VLOOKUP("NNPRINT",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NWAPPS",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NXAPPS",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NOAPPS",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NWMIDDLE",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NXMIDDLE",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NOMIDDLE",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NWINFRA",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NXINFRA",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NWDBS",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NXDBS",C[-3]:C[-1],3,FALSE)+2*VLOOKUP("NODBS",C[-3]:C[-1],3,FALSE)"><Data
ss:Type="Number">4094</Data></Cell>
<Cell ss:Formula="=RC[-2]/1000"><Data ss:Type="Number">3.5</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Network</Data></Cell>
<Cell><Data ss:Type="String">NWANLINK</Data></Cell>
<Cell><Data ss:Type="String">Number of WAN Links</Data></Cell>
<Cell><Data ss:Type="Number">80</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell ss:Formula="=RC[-2]/30"><Data ss:Type="Number">2.6666666666666665</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Telephony</Data></Cell>
<Cell><Data ss:Type="String">NFPHONE</Data></Cell>
<Cell><Data ss:Type="String">Number of Fix Phones</Data></Cell>
<Cell><Data ss:Type="Number">1700</Data></Cell>
<Cell ss:Formula="=VLOOKUP("NWDSK",C[-3]:C[-1],3,FALSE)/1.2"><Data
ss:Type="Number">1666.6666666666667</Data></Cell>
<Cell ss:Formula="=RC[-2]/800"><Data ss:Type="Number">2.125</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Telephony</Data></Cell>
<Cell><Data ss:Type="String">NMPHONE</Data></Cell>
<Cell><Data ss:Type="String">Number of Mobile Phones</Data></Cell>
<Cell><Data ss:Type="Number">800</Data></Cell>
<Cell ss:Formula="=VLOOKUP("NFPHONE",C[-3]:C[-1],3,FALSE)*15%"><Data
ss:Type="Number">255</Data></Cell>
<Cell ss:Formula="=RC[-2]/800"><Data ss:Type="Number">1</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Datacenter</Data></Cell>
<Cell><Data ss:Type="String">NRACKS</Data></Cell>
<Cell><Data ss:Type="String">Number of Racks in Datacenter</Data></Cell>
<Cell><Data ss:Type="Number">200</Data></Cell>
<Cell ss:Index="6" ss:Formula="=RC[-2]/100"><Data ss:Type="Number">2</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Datacenter</Data></Cell>
<Cell><Data ss:Type="String">NBCPPOS</Data></Cell>
<Cell><Data ss:Type="String">Number of BCP/DRP Positions</Data></Cell>
<Cell><Data ss:Type="Number">100</Data></Cell>
<Cell ss:Index="6" ss:Formula="=RC[-2]/100"><Data ss:Type="Number">1</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Logistics</Data></Cell>
<Cell><Data ss:Type="String">NPURCHASE</Data></Cell>
<Cell><Data ss:Type="String">Number of Purchase Order per Year</Data></Cell>
<Cell><Data ss:Type="Number">4000</Data></Cell>
<Cell ss:Formula="=VLOOKUP("NWDSK",C[-3]:C[-1],3,FALSE)*2"><Data
ss:Type="Number">4000</Data></Cell>
<Cell ss:Formula="=RC[-1]/2200"><Data ss:Type="Number">1.8181818181818181</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Logistics</Data></Cell>
<Cell><Data ss:Type="String">NMOVES</Data></Cell>
<Cell><Data ss:Type="String">Number of Position Moves per Year</Data></Cell>
<Cell><Data ss:Type="Number">1500</Data></Cell>
<Cell ss:Formula="=VLOOKUP("NWDSK",C[-3]:C[-1],3,FALSE)/2"><Data
ss:Type="Number">1000</Data></Cell>
<Cell ss:Formula="=RC[-1]/1000"><Data ss:Type="Number">1</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Change</Data></Cell>
<Cell><Data ss:Type="String">NCHANGE</Data></Cell>
<Cell><Data ss:Type="String">Number of Application Rollout per Year</Data></Cell>
<Cell><Data ss:Type="Number">250</Data></Cell>
<Cell ss:Formula="=VLOOKUP("NBUSAPP",C[-3]:C[-1],3,FALSE)*3"><Data
ss:Type="Number">150</Data></Cell>
<Cell ss:Formula="=3*RC[-2]/200"><Data ss:Type="Number">3.75</Data></Cell>
</Row>
<Row ss:Index="104">
<Cell><Data ss:Type="String">Total</Data></Cell>
<Cell><Data ss:Type="String">Total</Data></Cell>
<Cell ss:Index="6" ss:Formula="=SUM(R[-102]C:R[-1]C)"><Data ss:Type="Number">59.523317872603577</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<Print>
<ValidPrinterInfo/>
<HorizontalResolution>-3</HorizontalResolution>
<VerticalResolution>0</VerticalResolution>
</Print>
<TopRowVisible>3</TopRowVisible>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>14</ActiveRow>
<ActiveCol>3</ActiveCol>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
<ConditionalFormatting xmlns="urn:schemas-microsoft-com:office:excel">
<Range>R2C5:R28C5,R31C5:R33C5</Range>
<Condition>
<Qualifier>Equal</Qualifier>
<Value1>0</Value1>
<Format Style='background:black'/>
</Condition>
</ConditionalFormatting>
</Worksheet>
<Worksheet ss:Name="FTEs">
<Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="21" x:FullColumns="1"
x:FullRows="1">
<Column ss:StyleID="s22" ss:Width="67.5"/>
<Column ss:StyleID="s22" ss:Width="130.5"/>
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Span="2"/>
<Row>
<Cell ss:StyleID="s33"><Data ss:Type="String">Category</Data></Cell>
<Cell ss:StyleID="s33"><Data ss:Type="String">Position</Data></Cell>
<Cell ss:StyleID="s34"><Data ss:Type="String">Low End</Data><Comment
ss:Author="Alain Aucordier"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
html:Size="8" html:Color="#000000">Low End Company: IT is a commodity. Processes can work without IT equipment for a while.</Font></B><Font
html:Face="Tahoma" html:Size="8" html:Color="#000000">
</Font></ss:Data></Comment></Cell>
<Cell ss:StyleID="s34"><Data ss:Type="String">Average</Data><Comment
ss:Author="Alain Aucordier"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
html:Size="8" html:Color="#000000">Average: Some Business processes rely on IT,but not the core ones.</Font></B><Font
html:Face="Tahoma" html:Size="8" html:Color="#000000">
</Font></ss:Data></Comment></Cell>
<Cell ss:StyleID="s34"><Data ss:Type="String">High End</Data><Comment
ss:Author="Alain Aucordier"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
html:Size="8" html:Color="#000000">High End: Core Business process heavily rely on IT availability.</Font></B><Font
html:Face="Tahoma" html:Size="8" html:Color="#000000">
</Font></ss:Data></Comment></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Desktop</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Desktop Support Level 0</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])*10%"><Data
ss:Type="Number">2.2825850340136058</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">2.5336693877551029</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">2.7870363265306133</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Desktop</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Desktop Support Level 1</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])*80%"><Data
ss:Type="Number">18.260680272108846</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">20.269355102040823</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">22.296290612244906</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Desktop</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Desktop Support Level 2</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])*10%"><Data
ss:Type="Number">2.2825850340136058</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">2.5336693877551029</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">2.7870363265306133</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Windows</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Windows System Ingeneer</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">4.2971428571428572</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">4.7698285714285715</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">5.2468114285714291</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Unix</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Unix System Engineer</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">6.4571428571428573</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">7.1674285714285721</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">7.8841714285714302</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Legacy</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Legacy System Engineer</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">1.25</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">1.3875000000000002</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">1.5262500000000003</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Databases</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Database Administrator</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">4.3333333333333339</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">4.8100000000000014</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">5.2910000000000021</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Network</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Network Administrator</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">6.1666666666666661</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">6.8449999999999998</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">7.5295000000000005</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Telephony</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Telephone Administrator</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">3.125</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">3.4687500000000004</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">3.8156250000000007</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Logistics</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Procurement Officer</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">2.8181818181818183</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">3.1281818181818188</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">3.4410000000000012</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Datacenter</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Datacenter Operators</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">3</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">3.33</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">3.6630000000000003</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Change</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Change Manager</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">3.75</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">4.1625000000000005</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">4.5787500000000012</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Datacenter</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Datacenter Operators</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">3</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">3.33</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">3.6630000000000003</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"/>
<Cell ss:StyleID="s30"/>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">0</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"/>
<Cell ss:StyleID="s30"/>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">0</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"/>
<Cell ss:StyleID="s30"/>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">0</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"/>
<Cell ss:StyleID="s30"/>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">0</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"/>
<Cell ss:StyleID="s30"/>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">0</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Management</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Infrastructure Manager</Data></Cell>
<Cell ss:StyleID="s32"
ss:Formula="=SUMIF(Parameters!C[-2],RC[-2],Parameters!C[3])"><Data
ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s32" ss:Formula="=IF(RC[-2]<>0,MAX(RC[-1]*1.1,1),0)"><Data
ss:Type="Number">0</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s30"><Data ss:Type="String">Total</Data></Cell>
<Cell ss:StyleID="s30"><Data ss:Type="String">Total</Data></Cell>
<Cell ss:StyleID="s31" ss:Formula="=SUM(R[-19]C:R[-1]C)"><Data ss:Type="Number">61.023317872603592</Data></Cell>
<Cell ss:StyleID="s31" ss:Formula="=RC[-1]*1.11"><Data ss:Type="Number">67.735882838589987</Data></Cell>
<Cell ss:StyleID="s31" ss:Formula="=SUM(R[-19]C:R[-1]C)"><Data ss:Type="Number">74.509471122448986</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<Selected/>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>14</ActiveRow>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>

Collapse -

staff Size

by aedward In reply to Staff Size help

In my humble Opinion , i do not think you need a network and a system administrator. A very good network administrator can work as a system administrator . If the network is properly set up with the right policies implemented at the server and firewall levels. the network admin can manage so many things remotely.
My fear is that you will need a database administrator for the MS SQL / ORACLE server .

suggestion : hire one network admin to do system adm , manage sharepoint, communication server E- commerce , voIP , web conf and wireless infrastructure .

If i can have the breakdown of the intended job funtions for the two people on your proposal , i can see how i can re-arrange to hire minimum number of personnel.

drop a mail to aedward@ecomarinegroup.com
i will be glad to help more.

Collapse -

extra staff

by rob mekel In reply to Staff Size help

As the company y're working for has just 100 employees, it won't be the number of users that will give you a headache. It will be more into the number of different servers and services that you run next to availability of these systems/services.

As long there is a 9 to 5 availability request it won't be much of a problem to run it with, to the max, 3 co-workers, being y're helpdesk person, yourself and one network/system admin. This is if you yourself can coop with the databases.

If availability shifts to a more wider range you will have to put in more personnel or outsource the non 9 to 5 tasks. Basics here are if it becomes a 24x7 availability then you will need for every person with a task of the 9 to 5 operations, at least, 3 extra persons, totaling 4 for every task, as days off (weekends) and other "vacation? like days have to be covered by this.
Then there is your own job. As it won't be a 24x7 job you still have to consider that there has to be an upscale emergency path to inform management when having trouble.

As you say that you are designing a new infrastructure I guess you don't have deep knowledge off databases. So you will have to consider hiring a DBA.

If needing some extra help or clearance please do mail me.

Rob

Back to IT Employment Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums