Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: Server Systems Management Software Implementation Project ID: T60186SS
Form Rev. 04/17/2006
Page 1
Project Rev.8/24/10
Leadership Group: Information Technology
Department: Information Technology Division: Technical Systems and Networking
Project Sponsor: Kevin Bertram Date Requested: 7/17/08 PM Customer No. 186
Request Type: New Development
IT Team Name: Server Administration IT Team No: 6
Project Manager/Leader: Mahesh Parab Account Number: 17030 Account Description:
Technical Systems and Networking
Customer Name:
Information Technology
Grant Funded? No Mandate? No
Mandate Source:
Project Goal
To evaluate and implement Systems Management Software strategy in the server environment
so that server software deployment efficiencies are achieved.
1. Design of proposed solution;
Business Objective
Evaluate Microsoft System Center Configuration Manager (SCCM) 2007 in a test environment
as a replacement for MS WSUS for patch deployment, and to provide server software package
deployment.
Major Deliverables
2. Tested SCCM 2007 test environment;
3. Recommendations document for production deployment.
Approach
• Research SCCM 2007 product and identify all the functionalities that are relevant for
current IT environment and based on feasibility finalize the functionalities to be
deployed
• Design document to list the functionalities and configuration of the hardware/software
components;
• Develop test plan;
• Test and document test results for server level testing of SCCM 2007; and
• Develop recommendations document that outlines the next logical project steps.
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: Server Systems Management Software Implementation Project ID: T60186SS
Form Rev. 04/17/2006
Page 2
Project Rev.8/24/10
1. Deployment of SCCM 2007 in Production (Server Environment)
Business Objective
Deploy SCCM 2007 in production environment to facilitate system deployment, task automation,
compliance management, and policy based security management on Servers.
Major Deliverables
Approach
• Design and approve production environment configuration with SCCM 2007
Components for deployment;
• Change control implemented;
• Agent deployment and verification; and
• Post deployment support.
1. Analysis document with decommissioning strategy
Business Objective
To decommission existing MS WSUS from Server Setup
Major Deliverables
2. MS WSUS decommissioned
Approach
• Analysis done to develop proposed plan to decommission the software referenced
above;
• Develop detailed instructions to server team for decommissioning the software; and
• Decommissioning of the current software by server team.
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: Server Systems Management Software Implementation Project ID: T60186SS
Form Rev. 04/17/2006
Page 3
Project Rev.8/24/10
Benefits
See Return on Investment (ROI) Analysis Document
Impact
Number of Users
All
Divisions
Information Technology
Leadership Groups Information Technology Steering Committee
Risk
Business Environment
Low
Little or no impact to existing business processes.
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: Server Systems Management Software Implementation Project ID: T60186SS
Form Rev. 04/17/2006
Page 4
Project Rev.8/24/10
Assumptions
Staffing -
IT staffing: resources will be available for the hours indicated per the attached
project plan.
Other Staffing: additional staffing will be available as follows:
Name
Role:
Hours per Day
Project Sponsor:
Kevin Bertram
As Needed
Facilities
• IT Building – Server Rooms.
Technical
• New products will integrate into the current environment within County standards; and
• The SCCM environment will be setup using virtual servers for site & distribution server
and SCCM database will be installed on consolidated database server in Test
environment.
Funding
• Information Technology
Other
•
Priority
TBD
Constraints
• None identified.
Exclusions
•
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: Server Systems Management Software Implementation Project ID: T60186SS
Form Rev. 04/17/2006
Page 5
Project Rev.8/24/10
PROJECT PHASE AUTHORIZATION Phase(s): All
Total Estimated Application Services Hours: Cost:
Total Estimated Technical Systems Hours:867 Cost: $47,031
Total Estimated CLEMIS Hours: Cost:
Total Estimated Internal Services Hours: Cost:
IT Application Services Division Manager Approval: Date:
IT Technical Systems Division Manager Approval: Date:
IT CLEMIS Division Manager Approval: Date:
IT Internal Services Division Manager Approval: Date:
IT Management Approval:
Approved: Yes No Date:
Reason:
Project Sponsor Approval:
Title: Date:
PROJECT SUMMARY
Authorized Development (see above) Hours:867 Cost: $47,031
Preliminary Estimated Development for Future Phases Hours: Cost:
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: Server Systems Management Software Implementation Project ID: T60186SS
Form Rev. 04/17/2006
Page 6
Project Rev.8/24/10
PROJECT COMPLETION AUTHORIZATION Customer Acceptance of Product:
Title: Date:
3.1.1 - Increase application integration through web services
3.1.2 - Research and develop a Constituent Relationship Management (CRM) strategy
3.1.5 - Improve the quality, reliability and availability of all applications
3.1.3 - Promote mobility and location integration in business applications
3.1.4 - Utilize ecommerce platform to offset costs and expand product offerings to customers
3.1.6 - Increase the agility and responsiveness of business units by expanding customer analytics
3.1.7 - Leverage the County's Internet presence and portal as a branded consolidated point of access to all County information and services through a web browser
3.1.8 - Centralize identity and access management for all applications and content
3.1 - Provide an Enhanced Application Service Offering
3.2 - Enhance ability to provide effective and timely customer (County departments and CVTs) service
3.2.1 - Implement a centralized service center strategy to provide a single point of contact for service delivery
3.2.2 - Implement the IT Infrastructure Library (ITIL) best practice framework for IT Service Management
3.2.4 - Provide a high-quality training program to empower employees through technology
3.2.3 - Define a service and support strategy that clearly identifies the IT service provided
3.2.5 - Develop a formalized customer communication plan
3.2.6 - Build IT Staff expertise through professional development
3.2.7 - Expand capacity through ongoing organizational review and selective outsourcing
3.3 - Implement a Standardized Infrastructure Strategy
3.3.1 - Deliver services using a shared technology infrastructure wherever possible
3.3.2 - Implement a Microsoft infrastructure strategy
3.3.5 - Establish support cost model and SLA for all offerings outside 3.3.4
3.3.3 - Implement a consolidated security strategy
3.3.4 - Establish a standard personal computing hardware and software product suite, SLA, and replacement schedule for all County personal computers
3.3.6 - Improve service availability through network design and management strategies
3.3.7 - Establish enhanced capacity planning and recovery management strategies
X
X
X
T60186SS - Server Systems Management Software Implementation
1 of 1 Page
Run Date 7/6/2010
T60186SS
Oakland County -- Server Systems Management Software Implementation
Return on Investment AnalysisProject Summary
As Of: 8/24/2010
Description Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total
Benefits/Savings:
0 0 0 0 0 0 0 0 0 0 0 0 0 0 Costs:
Development Services Subtotal: 82,719 5,600 5,600 5,600 5,600 5,600 110,719
Hardware Subtotal: 4,600 4,600 4,600 4,600 4,600 4,600 27,600 Software Subtotal: 30,646 30,646 30,646 10,215 10,215 10,215 122,582 Infrastructure Subtotal 0 0 0 0 0 0 0 Training Subtotal: 0 0 0 0 0 0 0 Other Subtotal: 0 0 0 0 0 0 0 Annual Statistics:
Annual Total Savings 0 0 0 0 0 0 0
Annual Total Costs 117,964 40,846 40,846 20,415 20,415 20,415 260,901
Annual Return on Investment (117,964) (40,846) (40,846) (20,415) (20,415) (20,415) (260,901)
Annual Costs/Savings Ratio 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Project Cumulative Statistics:
Cumulative Total Savings 0 0 0 0 0 0 0
Cumulative Total Costs 117,964 158,810 199,655 220,070 240,485 260,901 260,901
Cumulative Return on Investment (117,964) (158,810) (199,655) (220,070) (240,485) (260,901) (260,901)
Cumulative Cost/Savings Ratio 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Year Positive Payback Achieved NO PAYBACK
State or Federal Mandate? Signatures:
Benefits Reviewed By Project Sponsor Date:
Costs (including IT Resources) Reviewed By Information Technology Project Manager Date:
T60186SS.xls/Project Summary Date Printed: 8/24/2010
T60186SS Oakland County -- Server Systems Management Software Implementation
Return on Investment Analysis
Savings Detail
As Of: 8/24/2010
Benefit/Savings Description
Project Savings
Category Budget Category/Funding Source
Unit
Desc Units
Rate per
Unit Total Savings
Annual Multiplier
Improved license management - Potential avoidance of license breach at
150K per breach Intangible Benefit
Reduced Incident resolution time through Improved software asset
management. Intangible Benefit
T60186SS.xls/Savings Detail Date Printed: 8/24/2010
T60186SS Oakland County -- Server Systems Management Software Implementation
Return on Investment Analysis
Savings Detail
As Of: 8/24/2010
Benefit/Savings Description
Project Savings Category
Improved license management - Potential avoidance of license breach at
150K per breach Intangible Benefit
Reduced Incident resolution time through Improved software asset
management. Intangible Benefit
Affects Project ROI? Potential Savings Extensions
Y1 Y2 Y3 Y4 Y5 Y6 Y1 Y2 Y3 Y4 Y5 Y6
T60186SS.xls/Savings Detail Date Printed: 8/24/2010
T60186SS
Oakland County -- Server Systems Management Software Implementation
Return on Investment AnalysisSavings Summary
As Of: 8/24/2010
Benefit/Savings Description Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total
Tangible Benefit:
Tangible Benefits Subtotal:
Cost Avoidance:
Cost Avoidance Subtotal:
Intangible Benefit:
Improved license management - Potential avoidance of license breach at 150K per breach
Reduced Incident resolution time through Improved software asset management.
T60186SS.xls/Savings Summary Date Printed: 8/24/2010
T60186SS
Oakland County -- Server Systems Management Software Implementation
Return on Investment AnalysisCost Detail
As Of: 8/24/2010
Affects Projec Cost Description
Project Cost
Category Budget Category/Funding Source
Unit
Desc Units
Rate per
Unit Total Cost
Annual
Multiplier Y1 Y2 Y3 Y4 IT Hours - New Development Development Svcs
17030 - Technical Systems and
Networking HR 867 89 77,119 x
IT Hours - System Maintenance Development Svcs
17030 - Technical Systems and
Networking HR 50 56 2,800 x x x x
IT Hours - Planned Maintenance Development Svcs
17030 - Technical Systems and
Networking HR 50 56 2,800 x x x x
IT Hours - Customer Support Development Svcs
17030 - Technical Systems and
Networking 0 56 0 x x x x
SCCM Servers - Configuration
management & Distribution Server Hardware
17030 - Technical Systems and
Networking EA 2 1,350 2,700 x x x x
SCCM Database Server - SQL 2005 Hardware
17030 - Technical Systems and
Networking EA 1 1,900 1,900 x x x x
SCCM Datacenter License to manage 17030 Technical Systems and
SCCM Datacenter License to manage
150 Physical Servers Year 1-3 Software
17030 - Technical Systems and
Networking EA 150 164 24,566 x x x
SCCM Datacenter License to manage 16 VM Hypervisor server, 2 processor
each server Year 1-3 Software
17030 - Technical Systems and
Networking EA 32 190 6,080 X X X
SCCM Datacenter License to manage
150 Physical Servers Year 4-6 Software
17030 - Technical Systems and
Networking EA 150 55 8,189 x
SCCM Datacenter License to manage 16 VM Hypervisor server, 2 processor
each server Year 4-6 Software
17030 - Technical Systems and
Networking EA 32 63 2,027 x
Server Rack Mount Infrastructure
17030 - Technical Systems and
Networking 0 500 0 x
SSL Certificate Infrastructure 845 0
Internet Access Infrastructure 180 0
Project Staff Training Training 0
User Training Training 0
T60186SS.xls/Cost Detail Date Printed: 8/24/2010
T60186SS
Oakland County -- Server Systems Management Software Implementation
Return on Investment AnalysisCost Detail
As Of: 8/24/2010
Cost Description
Project Cost Category IT Hours - New Development Development Svcs IT Hours - System Maintenance Development Svcs IT Hours - Planned Maintenance Development Svcs IT Hours - Customer Support Development Svcs SCCM Servers - Configuration
management & Distribution Server Hardware SCCM Database Server - SQL 2005 Hardware SCCM Datacenter License to manage
ct ROI? Potential Cost Extensions
Y5 Y6 Y1 Y2 Y3 Y4 Y5 Y6 77,118.50 x x 2,800.00 2,800.00 2,800.00 2,800.00 2,800.00 2,800.00 x x 2,800.00 2,800.00 2,800.00 2,800.00 2,800.00 2,800.00 x x 0.00 0.00 0.00 0.00 0.00 0.00 x x 2,700.00 2,700.00 2,700.00 2,700.00 2,700.00 2,700.00 x x 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00
SCCM Datacenter License to manage
150 Physical Servers Year 1-3 Software SCCM Datacenter License to manage
16 VM Hypervisor server, 2 processor
each server Year 1-3 Software
SCCM Datacenter License to manage
150 Physical Servers Year 4-6 Software SCCM Datacenter License to manage
16 VM Hypervisor server, 2 processor
each server Year 4-6 Software
Server Rack Mount Infrastructure
SSL Certificate Infrastructure
Internet Access Infrastructure
Project Staff Training Training
User Training Training
24,565.50 24,565.50 24,565.50 6,080.00 6,080.00 6,080.00 X X 8,188.50 8,188.50 8,188.50 x x 2,026.67 2,026.67 2,026.67 0.00 T60186SS.xls/Cost Detail Date Printed: 8/24/2010
T60186SS Oakland County -- Server Systems Management Software Implementation Return on Investment Analysis
Cost Summary
As Of: 8/24/2010
Cost Description Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total Development Services:
IT Hours - New Development 77,119 77,119
IT Hours - System Maintenance 2,800 2,800 2,800 2,800 2,800 2,800 16,800
IT Hours - Planned Maintenance 2,800 2,800 2,800 2,800 2,800 2,800 16,800
IT Hours - Customer Support 0 0 0 0 0 0
Development Services Subtotal: 82,719 5,600 5,600 5,600 5,600 5,600 110,719
Hardware:
SCCM Servers - Configuration management
& Distribution Server 2,700 2,700 2,700 2,700 2,700 2,700 16,200
SCCM Database Server - SQL 2005 1,900 1,900 1,900 1,900 1,900 1,900 11,400
Hardware Subtotal: 4,600 4,600 4,600 4,600 4,600 4,600 27,600
Software:
SCCM Datacenter License to manage 150
Physical Servers Year 1-3 24,566 24,566 24,566 73,697
SCCM Datacenter License to manage 16 VM Hypervisor server, 2 processor each server
Year 1-3 6,080 6,080 6,080 18,240
SCCM Datacenter License to manage 150
Physical Servers Year 4-6 8,189 8,189 8,189 24,566
SCCM Datacenter License to manage 16 VM Hypervisor server, 2 processor each server
Year 4-6 2,027 2,027 2,027 6,080 Software Subtotal: 30,646 30,646 30,646 10,215 10,215 10,215 122,582 Infrastructure: Infrastructure Subtotal Training: Training Subtotal: Other: Other Subtotal: Costs Total: 117,964 40,846 40,846 20,415 20,415 20,415 260,901 T60186SS.xls/Cost Summary Date Printed: 8/24/2010
T60186SS Oakland County -- Server Systems Management Software Implementation
Return on Investment Analysis
Assumptions
As Of: 8/24/2010
Date Assumption Description
23-Jun-10 Cost Detail - Line 3 -- 867 hours from the Workbench WBS and includes Scope, Contingency and PM, blended rate of $89.
23-Jun-10
Cost Detail - Line 28 -- Implementation Assumes Use of Virtualized environment for site/distribution servers (1350 USD annually per component, includes server software and maintenance costs)
23-Jun-10
Cost Detail - Line 29 -- Implementation having dedicated instance on shared consolidated Database Server (1900 USD Annual usage charge includes server license cost)
30-Jun-10 Cost Detail - Line 30 -- Year 1-3 SCCM Datacenter License cost to manage 150 Physical Servers
30-Jun-10 Cost Detail - Line 31 -- Year 1-3 SCCM Datacenter License cost to manage 16 VMhypervisor servers Dual Processor 30-Jun-10 Cost Detail - Line 32 -- Year 4-6 SCCM Datacenter License cost to manage 150 Physical Servers
30-Jun-10 Cost Detail - Line 33 -- Year 4-6 SCCM Datacenter License cost to manage 16 VMhypervisor servers Dual Processor
Savings Assumptions
12-Aug-08 Savings Detail Line Item 03 - Fines for corporations can reach $150,000 for each illegally installed copy of software.
12-Aug-08
Savings Detail Line Item 04 - Currently Server Management team spend on an every one hour for incident remediation. Implementing SCCM 2007 reduces the resolution time and results in savings on labor cost ( 56 $ per hr)
T60186SS.xls/Assumptions Date Printed: 8/24/2010