Description
Oakland County Department of Information Technology Project Scope and Approach
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 1 Project Rev.4/26/2007
Leadership Group: Courts
Department: Circuit Court
Division: Court Administration
Project Sponsor: John Cooperrider
Date Requested: 4/12/2006
PM Customer No.
Request Type: New Development Enhancement Customer Support
Planned System Maintenance or Upgrade
IT Team Name: eGovernment App Svcs
IT Team No:
Project Manager/Leader:
Account
Number:
TBD
Account
Description:
TBD
Customer
Name:
Circuit Court
Grant Funded? Yes No
Mandate? Yes No
Mandate Source:
Project Goal
To enhance the Criminal J ustice Data Warehouse so that authorized personnel from the Courts,
Sheriff’s department, and Community Corrections will be able to develop additional reporting for
use by the Criminal J ustice Coordinating Council (CJ CC) and for the purpose of inmate
population management using the Business Objects tool suite thereby providing decision
support by September 30, 2006.
Business Objective
This scope includes but is not limited to these objectives:
• To define and implement enhancements to the current Local Administrative Order (LAO)
report. The LAO is considered a mandate pursuant to a local governing policy (LAO 06-
06 J ail Population Reduction Measures).
• To enhance the current Criminal J ustice Data Warehouse infrastructure to include Next
Event Date & Type and Last Event Date & Type from the Circuit Court and the 52
nd
District Courts.
• To define and implement additional reports for the purpose of managing the jail inmate
population.
• To enhance the current Criminal J ustice Data Warehouse infrastructure to include the
Prosecutor’s Name for Circuit Court cases.
• To enhance the Criminal J ustice Data Warehouse infrastructure to include data from the
State J IS system.
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 2 Project Rev.4/26/2007
Major Deliverables
Discovery Document
Updated Data Warehouse data model
Source to target mapping documentation
New or updated Informatica mappings (if necessary)
New or updated Business Objects universes
Revised Local Administrative Order (LAO) report
New Case Age report
New report(s) showing adjournments
Add pertinent functionality to the CJ DW system where necessary to enhance the
application for decision support
Approach
• Amend the data warehouse data structures per user reporting
requirements.
• Amend programs to move data from sources identified in the Discovery
Document
• Amend if needed operational batch scheduling
• Amend the physical data warehouse data structures
• Enhance and test data movement programs
• Enhance and verify BusinessObjects Universes
• Enhance and test operational batch schedules
• Implement all components in a production environment
• As enhancements are identified and the estimated number of hours
determined for additional functionality to enhance the CJ DW system,
detailed tasks and hours will be added to the project plan and the budget
task decremented.
Benefits
See Return on Investment (ROI) Analysis Document
Intangible Benefits
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 3 Project Rev.4/26/2007
• Continue to contribute to a reduction in pending criminal dockets in Circuit Court
(currently 38.8%)
• Provide additional reporting capabilities during jail over-crowding emergencies to
the Circuit and District Courts
• Provide support to the Criminal J ustice Coordinating Council
• Continue to use to support better population management
• Providing reporting regarding excessive adjournments can assist in expediting
cases
• Increase Courts’ staff productivity by eliminating the need for manual reporting as
it relates to jail population and case management
Impact
Number of Users 7 Business Objects Users and 34 Report Consumers
Divisions Circuit Court Administration, 10 District Courts, Case Management Office,
Community Corrections, State of Michigan Supreme Court Administration Office
(SCAO)
Leadership Groups Courts
Risk
Business Environment
Low – little or no impact to existing business processes
Technical Environment
Low – proven and previously implemented technologies
Assumptions
Staffing IT Staffing: resources will be available for the hours indicated per the attached
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 4 Project Rev.4/26/2007
project plan.
Other Staffing: additional staffing will be available as follows:
Role: Name Hours per Day
Project Sponsor: J ohn Cooperrider As needed
Facilities
• Conference rooms will be available as needed
Technical
• The customer will be available to assisting with reporting requirements.
• Applications Services will be available to add data elements to the current extracts, if
necessary.
• The non-52
nd
District Courts will allow us access to their J IS data and the State will
agree to provide the necessary flat file dump(s).
Funding
• Fund Equity of the General Fund
Other
•
Priority
Constraints
• Decision support software will be Business Objects
Exclusions
•
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 5 Project Rev.4/26/2007
PROJECT PHASE AUTHORIZATION
Phase(s):
Total Estimated Application Services Hours: 30 Cost: $ 3,240
Total Estimated Technical Systems Hours: Cost:
Total Estimated eGovernment Services Hours: 588 Cost: $71,736
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 eGovernment Services Division Manager Approval:
Date:
IT CLEMIS Division Manager Approval:
Date:
IT Internal Services Division Manager Approval:
Date:
IT Resource Manager Approval:
Date:
IT Resource Manager Approval:
Date:
IT Resource Manager Approval:
Date:
IT Resource Manager Approval:
Date:
IT Resource Manager Approval:
Date:
IT Management Approval:
Approved: Yes No
Date:
Reason:
Project Sponsor Approval:
Title:
Date:
PROJECT SUMMARY
Authorized Development (see above) Hours: 618 Cost: $74,976
Preliminary Estimated Development for Future Phases Hours: Cost:
Grand Total Estimated Development Hours: 618 Cost: $74,976
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 6 Project Rev.4/26/2007
PROJECT COMPLETION AUTHORIZATION
Customer Acceptance of Product:
Title:
Date:
Project Office Review:
Date:
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 7 Project Rev.4/26/2007
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Project Summary
As Of: 4/26/2007
Description Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total
Benefits/Savings:
Tangible Benefits Subtotal: 0 0 0 0 0 0 0
Cost Avoidance Subtotal: 195,216 195,216 195,216 195,216 195,216 195,216 1,171,296
Costs:
Development Services Subtotal: 74,976 0 0 0 0 0 74,976
Hardware Subtotal: 0 0 0 0 0 0 0
Software Subtotal: 0 0 0 0 0 0 0
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 195,216 195,216 195,216 195,216 195,216 195,216 1,171,296
Annual Total Costs 74,976 0 0 0 0 0 74,976
Annual Return on Investment 120,240 195,216 195,216 195,216 195,216 195,216 1,096,320
Annual Costs/Savings Ratio 38.41% 0.00% 0.00% 0.00% 0.00% 0.00%
Project Cumulative Statistics:
Cumulative Total Savings 195,216 390,432 585,648 780,864 976,080 1,171,296 1,171,296
Cumulative Total Costs 74,976 74,976 74,976 74,976 74,976 74,976 74,976
Cumulative Return on Investment 120,240 315,456 510,672 705,888 901,104 1,096,320 1,096,320
Cumulative Cost/Savings Ratio 38.41% 19.20% 12.80% 9.60% 7.68% 6.40% 6.40%
Year Positive Payback Achieved Year 1 Year 1
State or Federal Mandate?
Signatures:
Benefits Reviewed By Project Sponsor Date:
Costs (including IT Resources) Reviewed By
Information Technology Project Manager Date:
Costs (including IT Resources) Reviewed By
Technical Services Manager Date:
cjcc_business_intelligence.xls/Project Summary
Date Printed: 4/26/2007
Page 1 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Savings Detail
As Of: 4/26/2007
Benefit/Savings Description
Project Savings
Category Budget Category/Funding Source
Unit
Desc Units
Rate per
Unit Total Savings
Annual
Multiplier
Reduce length of stay for pretrial
inmates in Circuit Court Cost Avoidance ANN 2,352 83 195,216
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
cjcc_business_intelligence.xls/Savings Detail
Date Printed: 4/26/2007
Page 2 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Savings Detail
As Of: 4/26/2007
Benefit/Savings Description
Project Savings
Category
Reduce length of stay for pretrial
inmates in Circuit Court Cost Avoidance
Affects Project ROI? Potential Savings Extensions
Y1 Y2 Y3 Y4 Y5 Y6 Y1 Y2 Y3 Y4 Y5 Y6
x x x x x x 195,216 195,216 195,216 195,216 195,216 195,216
cjcc_business_intelligence.xls/Savings Detail
Date Printed: 4/26/2007
Page 3 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Savings Summary
As Of: 4/26/2007
Benefit/Savings Description Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total
Tangible Benefit:
Tangible Benefits Subtotal:
Cost Avoidance:
Reduce length of stay for pretrial inmates in
Circuit Court 195,216 195,216 195,216 195,216 195,216 195,216 1,171,296
Cost Avoidance Subtotal: 195,216 195,216 195,216 195,216 195,216 195,216 1,171,296
Savings Total: 195,216 195,216 195,216 195,216 195,216 195,216 1,171,296
cjcc_business_intelligence.xls/Savings Summary
Date Printed: 4/26/2007
Page 4 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Cost Detail
As Of: 4/26/2007
Cost Description Project Cost Category Budget Category/Funding Source
Unit
Desc Units
Rate per
Unit Total Cost
Annual
Multiplier
IT Hours - New Development
(Enhancements) Development Svcs Fund Equity of the General Fund HR 30 108 3,240
IT Hours - System Maintenance Development Svcs HR 0 122 0 0.000
eGovernment - New Development
(Enhancements) Development Svcs Fund Equity of the General Fund HR 588 122 71,736
User Hours - PTNE/OT Development Svcs 0
Contractor Professional Services Development Svcs hr 0 122 0
PC System - Acquisition Hardware 0
PC System - Maintenance Hardware 2,304 0
Notebook - Acquisition Hardware 0
Notebook - Maintenance Hardware 2,372 0
Mini Notebook - Acquisition Hardware 0
Mini Notebook - Maintenance Hardware 2,196 0
Laserprinter 1 - Acquisition Hardware 0
Laserprinter 1 - Maintenance Hardware 1,104 0
Laserprinter 2 - Acquisition Hardware 0
Laserprinter 2 - Maintenance Hardware 1,208 0
Laserprinter 3 - Acquisition Hardware 0
Laserprinter 3 - Maintenance Hardware 1,860 0
Image Workstations - Acquisition Hardware 0
Image Workstations - Maintenance Hardware 3,496 0
Terminals - Acquisition Hardware 0
Terminals - Maintenance Hardware 644 0
PRTR w/TERM ID - Acquisition Hardware 0
PRTR w/TERM ID - Maintenance Hardware 1,072 0
PRTR w/o TERM ID - Acquisition Hardware 0
PRTR w/o TERM ID - Maintenance Hardware 1,072 0
PC Maintenance User Owned Hardware 2,304 0
Printer Maintenance User Owned Hardware 1,072 0
Package Software - Acquisition Software 0
Package Software - Maintenance Software 0
Business Objects Access Software 0
Term Emulation SFTW-Acquisition Software 0
cjcc_business_intelligence.xls/Cost Detail
Date Printed: 4/26/2007
Page 5 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Cost Detail
As Of: 4/26/2007
Cost Description Project Cost Category Budget Category/Funding Source
Unit
Desc Units
Rate per
Unit Total Cost
Annual
Multiplier
Term Emulation SFTW-Maintenance Software 0
Server - Acquisition/Upgrade Infrastructure 0
Server - Maintenance Infrastructure 0
Server Sftwre - Acquisition/Upgrade Infrastructure 0
Server Sftwre - Maintenance Infrastructure 0
TBD Infrastructure 0
TBD Infrastructure 0
TBD Infrastructure 0
TBD Infrastructure 0
Internet Access Infrastructure 180 0
Project Staff Training Training 0
User Training Training 0
0
0
0
0
0
cjcc_business_intelligence.xls/Cost Detail
Date Printed: 4/26/2007
Page 6 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Cost Detail
As Of: 4/26/2007
Cost Description Project Cost Category
IT Hours - New Development
(Enhancements) Development Svcs
IT Hours - System Maintenance Development Svcs
eGovernment - New Development
(Enhancements) Development Svcs
User Hours - PTNE/OT Development Svcs
Contractor Professional Services Development Svcs
PC System - Acquisition Hardware
PC System - Maintenance Hardware
Notebook - Acquisition Hardware
Notebook - Maintenance Hardware
Mini Notebook - Acquisition Hardware
Mini Notebook - Maintenance Hardware
Laserprinter 1 - Acquisition Hardware
Laserprinter 1 - Maintenance Hardware
Laserprinter 2 - Acquisition Hardware
Laserprinter 2 - Maintenance Hardware
Laserprinter 3 - Acquisition Hardware
Laserprinter 3 - Maintenance Hardware
Image Workstations - Acquisition Hardware
Image Workstations - Maintenance Hardware
Terminals - Acquisition Hardware
Terminals - Maintenance Hardware
PRTR w/TERM ID - Acquisition Hardware
PRTR w/TERM ID - Maintenance Hardware
PRTR w/o TERM ID - Acquisition Hardware
PRTR w/o TERM ID - Maintenance Hardware
PC Maintenance User Owned Hardware
Printer Maintenance User Owned Hardware
Package Software - Acquisition Software
Package Software - Maintenance Software
Business Objects Access Software
Term Emulation SFTW-Acquisition Software
Affects Project ROI? Potential Cost Extensions
Y1 Y2 Y3 Y4 Y5 Y6 Y1 Y2 Y3 Y4 Y5 Y6
x 3,240
x x x x x 0 0 0 0 0
x 71,736
x 0
cjcc_business_intelligence.xls/Cost Detail
Date Printed: 4/26/2007
Page 7 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Cost Detail
As Of: 4/26/2007
Cost Description Project Cost Category
Term Emulation SFTW-Maintenance Software
Server - Acquisition/Upgrade Infrastructure
Server - Maintenance Infrastructure
Server Sftwre - Acquisition/Upgrade Infrastructure
Server Sftwre - Maintenance Infrastructure
TBD Infrastructure
TBD Infrastructure
TBD Infrastructure
TBD Infrastructure
Internet Access Infrastructure
Project Staff Training Training
User Training Training
Affects Project ROI? Potential Cost Extensions
Y1 Y2 Y3 Y4 Y5 Y6 Y1 Y2 Y3 Y4 Y5 Y6
cjcc_business_intelligence.xls/Cost Detail
Date Printed: 4/26/2007
Page 8 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Cost Summary
As Of: 4/26/2007
Cost Description Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total
Development Services:
IT Hours - New Development
(Enhancements) 3,240 3,240
IT Hours - System Maintenance 0 0 0 0 0
eGovernment - New Development
(Enhancements) 71,736 71,736
User Hours - PTNE/OT
Contractor Professional Services 0
Development Services Subtotal: 74,976 74,976
Hardware:
Hardware Subtotal:
Software:
Software Subtotal:
Infrastructure:
Infrastructure Subtotal
Training:
Training Subtotal:
Other:
Other Subtotal:
Costs Total: 74,976 74,976
cjcc_business_intelligence.xls/Cost Summary
Date Printed: 4/26/2007
Page 9
REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Assumptions
As Of: 4/26/2007
Date
Assumption Description
cjcc_business_intelligence.xls/Assumptions
Date Printed: 4/26/2007
Page 10 REV: September 5, 2003
doc_909763387.pdf
Oakland County Department of Information Technology Project Scope and Approach
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 1 Project Rev.4/26/2007
Leadership Group: Courts
Department: Circuit Court
Division: Court Administration
Project Sponsor: John Cooperrider
Date Requested: 4/12/2006
PM Customer No.
Request Type: New Development Enhancement Customer Support
Planned System Maintenance or Upgrade
IT Team Name: eGovernment App Svcs
IT Team No:
Project Manager/Leader:
Account
Number:
TBD
Account
Description:
TBD
Customer
Name:
Circuit Court
Grant Funded? Yes No
Mandate? Yes No
Mandate Source:
Project Goal
To enhance the Criminal J ustice Data Warehouse so that authorized personnel from the Courts,
Sheriff’s department, and Community Corrections will be able to develop additional reporting for
use by the Criminal J ustice Coordinating Council (CJ CC) and for the purpose of inmate
population management using the Business Objects tool suite thereby providing decision
support by September 30, 2006.
Business Objective
This scope includes but is not limited to these objectives:
• To define and implement enhancements to the current Local Administrative Order (LAO)
report. The LAO is considered a mandate pursuant to a local governing policy (LAO 06-
06 J ail Population Reduction Measures).
• To enhance the current Criminal J ustice Data Warehouse infrastructure to include Next
Event Date & Type and Last Event Date & Type from the Circuit Court and the 52
nd
District Courts.
• To define and implement additional reports for the purpose of managing the jail inmate
population.
• To enhance the current Criminal J ustice Data Warehouse infrastructure to include the
Prosecutor’s Name for Circuit Court cases.
• To enhance the Criminal J ustice Data Warehouse infrastructure to include data from the
State J IS system.
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 2 Project Rev.4/26/2007
Major Deliverables
Discovery Document
Updated Data Warehouse data model
Source to target mapping documentation
New or updated Informatica mappings (if necessary)
New or updated Business Objects universes
Revised Local Administrative Order (LAO) report
New Case Age report
New report(s) showing adjournments
Add pertinent functionality to the CJ DW system where necessary to enhance the
application for decision support
Approach
• Amend the data warehouse data structures per user reporting
requirements.
• Amend programs to move data from sources identified in the Discovery
Document
• Amend if needed operational batch scheduling
• Amend the physical data warehouse data structures
• Enhance and test data movement programs
• Enhance and verify BusinessObjects Universes
• Enhance and test operational batch schedules
• Implement all components in a production environment
• As enhancements are identified and the estimated number of hours
determined for additional functionality to enhance the CJ DW system,
detailed tasks and hours will be added to the project plan and the budget
task decremented.
Benefits
See Return on Investment (ROI) Analysis Document
Intangible Benefits
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 3 Project Rev.4/26/2007
• Continue to contribute to a reduction in pending criminal dockets in Circuit Court
(currently 38.8%)
• Provide additional reporting capabilities during jail over-crowding emergencies to
the Circuit and District Courts
• Provide support to the Criminal J ustice Coordinating Council
• Continue to use to support better population management
• Providing reporting regarding excessive adjournments can assist in expediting
cases
• Increase Courts’ staff productivity by eliminating the need for manual reporting as
it relates to jail population and case management
Impact
Number of Users 7 Business Objects Users and 34 Report Consumers
Divisions Circuit Court Administration, 10 District Courts, Case Management Office,
Community Corrections, State of Michigan Supreme Court Administration Office
(SCAO)
Leadership Groups Courts
Risk
Business Environment
Low – little or no impact to existing business processes
Technical Environment
Low – proven and previously implemented technologies
Assumptions
Staffing IT Staffing: resources will be available for the hours indicated per the attached
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 4 Project Rev.4/26/2007
project plan.
Other Staffing: additional staffing will be available as follows:
Role: Name Hours per Day
Project Sponsor: J ohn Cooperrider As needed
Facilities
• Conference rooms will be available as needed
Technical
• The customer will be available to assisting with reporting requirements.
• Applications Services will be available to add data elements to the current extracts, if
necessary.
• The non-52
nd
District Courts will allow us access to their J IS data and the State will
agree to provide the necessary flat file dump(s).
Funding
• Fund Equity of the General Fund
Other
•
Priority
Constraints
• Decision support software will be Business Objects
Exclusions
•
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 5 Project Rev.4/26/2007
PROJECT PHASE AUTHORIZATION
Phase(s):
Total Estimated Application Services Hours: 30 Cost: $ 3,240
Total Estimated Technical Systems Hours: Cost:
Total Estimated eGovernment Services Hours: 588 Cost: $71,736
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 eGovernment Services Division Manager Approval:
Date:
IT CLEMIS Division Manager Approval:
Date:
IT Internal Services Division Manager Approval:
Date:
IT Resource Manager Approval:
Date:
IT Resource Manager Approval:
Date:
IT Resource Manager Approval:
Date:
IT Resource Manager Approval:
Date:
IT Resource Manager Approval:
Date:
IT Management Approval:
Approved: Yes No
Date:
Reason:
Project Sponsor Approval:
Title:
Date:
PROJECT SUMMARY
Authorized Development (see above) Hours: 618 Cost: $74,976
Preliminary Estimated Development for Future Phases Hours: Cost:
Grand Total Estimated Development Hours: 618 Cost: $74,976
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 6 Project Rev.4/26/2007
PROJECT COMPLETION AUTHORIZATION
Customer Acceptance of Product:
Title:
Date:
Project Office Review:
Date:
Oakland County
Department of Information Technology
Project Scope and Approach
Project Name: CJCC Business Intelligence Project ID: DJ6351BI
Form Rev. 4/25/2007 2:53 PM Page 7 Project Rev.4/26/2007
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Project Summary
As Of: 4/26/2007
Description Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total
Benefits/Savings:
Tangible Benefits Subtotal: 0 0 0 0 0 0 0
Cost Avoidance Subtotal: 195,216 195,216 195,216 195,216 195,216 195,216 1,171,296
Costs:
Development Services Subtotal: 74,976 0 0 0 0 0 74,976
Hardware Subtotal: 0 0 0 0 0 0 0
Software Subtotal: 0 0 0 0 0 0 0
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 195,216 195,216 195,216 195,216 195,216 195,216 1,171,296
Annual Total Costs 74,976 0 0 0 0 0 74,976
Annual Return on Investment 120,240 195,216 195,216 195,216 195,216 195,216 1,096,320
Annual Costs/Savings Ratio 38.41% 0.00% 0.00% 0.00% 0.00% 0.00%
Project Cumulative Statistics:
Cumulative Total Savings 195,216 390,432 585,648 780,864 976,080 1,171,296 1,171,296
Cumulative Total Costs 74,976 74,976 74,976 74,976 74,976 74,976 74,976
Cumulative Return on Investment 120,240 315,456 510,672 705,888 901,104 1,096,320 1,096,320
Cumulative Cost/Savings Ratio 38.41% 19.20% 12.80% 9.60% 7.68% 6.40% 6.40%
Year Positive Payback Achieved Year 1 Year 1
State or Federal Mandate?
Signatures:
Benefits Reviewed By Project Sponsor Date:
Costs (including IT Resources) Reviewed By
Information Technology Project Manager Date:
Costs (including IT Resources) Reviewed By
Technical Services Manager Date:
cjcc_business_intelligence.xls/Project Summary
Date Printed: 4/26/2007
Page 1 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Savings Detail
As Of: 4/26/2007
Benefit/Savings Description
Project Savings
Category Budget Category/Funding Source
Unit
Desc Units
Rate per
Unit Total Savings
Annual
Multiplier
Reduce length of stay for pretrial
inmates in Circuit Court Cost Avoidance ANN 2,352 83 195,216
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
cjcc_business_intelligence.xls/Savings Detail
Date Printed: 4/26/2007
Page 2 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Savings Detail
As Of: 4/26/2007
Benefit/Savings Description
Project Savings
Category
Reduce length of stay for pretrial
inmates in Circuit Court Cost Avoidance
Affects Project ROI? Potential Savings Extensions
Y1 Y2 Y3 Y4 Y5 Y6 Y1 Y2 Y3 Y4 Y5 Y6
x x x x x x 195,216 195,216 195,216 195,216 195,216 195,216
cjcc_business_intelligence.xls/Savings Detail
Date Printed: 4/26/2007
Page 3 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Savings Summary
As Of: 4/26/2007
Benefit/Savings Description Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total
Tangible Benefit:
Tangible Benefits Subtotal:
Cost Avoidance:
Reduce length of stay for pretrial inmates in
Circuit Court 195,216 195,216 195,216 195,216 195,216 195,216 1,171,296
Cost Avoidance Subtotal: 195,216 195,216 195,216 195,216 195,216 195,216 1,171,296
Savings Total: 195,216 195,216 195,216 195,216 195,216 195,216 1,171,296
cjcc_business_intelligence.xls/Savings Summary
Date Printed: 4/26/2007
Page 4 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Cost Detail
As Of: 4/26/2007
Cost Description Project Cost Category Budget Category/Funding Source
Unit
Desc Units
Rate per
Unit Total Cost
Annual
Multiplier
IT Hours - New Development
(Enhancements) Development Svcs Fund Equity of the General Fund HR 30 108 3,240
IT Hours - System Maintenance Development Svcs HR 0 122 0 0.000
eGovernment - New Development
(Enhancements) Development Svcs Fund Equity of the General Fund HR 588 122 71,736
User Hours - PTNE/OT Development Svcs 0
Contractor Professional Services Development Svcs hr 0 122 0
PC System - Acquisition Hardware 0
PC System - Maintenance Hardware 2,304 0
Notebook - Acquisition Hardware 0
Notebook - Maintenance Hardware 2,372 0
Mini Notebook - Acquisition Hardware 0
Mini Notebook - Maintenance Hardware 2,196 0
Laserprinter 1 - Acquisition Hardware 0
Laserprinter 1 - Maintenance Hardware 1,104 0
Laserprinter 2 - Acquisition Hardware 0
Laserprinter 2 - Maintenance Hardware 1,208 0
Laserprinter 3 - Acquisition Hardware 0
Laserprinter 3 - Maintenance Hardware 1,860 0
Image Workstations - Acquisition Hardware 0
Image Workstations - Maintenance Hardware 3,496 0
Terminals - Acquisition Hardware 0
Terminals - Maintenance Hardware 644 0
PRTR w/TERM ID - Acquisition Hardware 0
PRTR w/TERM ID - Maintenance Hardware 1,072 0
PRTR w/o TERM ID - Acquisition Hardware 0
PRTR w/o TERM ID - Maintenance Hardware 1,072 0
PC Maintenance User Owned Hardware 2,304 0
Printer Maintenance User Owned Hardware 1,072 0
Package Software - Acquisition Software 0
Package Software - Maintenance Software 0
Business Objects Access Software 0
Term Emulation SFTW-Acquisition Software 0
cjcc_business_intelligence.xls/Cost Detail
Date Printed: 4/26/2007
Page 5 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Cost Detail
As Of: 4/26/2007
Cost Description Project Cost Category Budget Category/Funding Source
Unit
Desc Units
Rate per
Unit Total Cost
Annual
Multiplier
Term Emulation SFTW-Maintenance Software 0
Server - Acquisition/Upgrade Infrastructure 0
Server - Maintenance Infrastructure 0
Server Sftwre - Acquisition/Upgrade Infrastructure 0
Server Sftwre - Maintenance Infrastructure 0
TBD Infrastructure 0
TBD Infrastructure 0
TBD Infrastructure 0
TBD Infrastructure 0
Internet Access Infrastructure 180 0
Project Staff Training Training 0
User Training Training 0
0
0
0
0
0
cjcc_business_intelligence.xls/Cost Detail
Date Printed: 4/26/2007
Page 6 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Cost Detail
As Of: 4/26/2007
Cost Description Project Cost Category
IT Hours - New Development
(Enhancements) Development Svcs
IT Hours - System Maintenance Development Svcs
eGovernment - New Development
(Enhancements) Development Svcs
User Hours - PTNE/OT Development Svcs
Contractor Professional Services Development Svcs
PC System - Acquisition Hardware
PC System - Maintenance Hardware
Notebook - Acquisition Hardware
Notebook - Maintenance Hardware
Mini Notebook - Acquisition Hardware
Mini Notebook - Maintenance Hardware
Laserprinter 1 - Acquisition Hardware
Laserprinter 1 - Maintenance Hardware
Laserprinter 2 - Acquisition Hardware
Laserprinter 2 - Maintenance Hardware
Laserprinter 3 - Acquisition Hardware
Laserprinter 3 - Maintenance Hardware
Image Workstations - Acquisition Hardware
Image Workstations - Maintenance Hardware
Terminals - Acquisition Hardware
Terminals - Maintenance Hardware
PRTR w/TERM ID - Acquisition Hardware
PRTR w/TERM ID - Maintenance Hardware
PRTR w/o TERM ID - Acquisition Hardware
PRTR w/o TERM ID - Maintenance Hardware
PC Maintenance User Owned Hardware
Printer Maintenance User Owned Hardware
Package Software - Acquisition Software
Package Software - Maintenance Software
Business Objects Access Software
Term Emulation SFTW-Acquisition Software
Affects Project ROI? Potential Cost Extensions
Y1 Y2 Y3 Y4 Y5 Y6 Y1 Y2 Y3 Y4 Y5 Y6
x 3,240
x x x x x 0 0 0 0 0
x 71,736
x 0
cjcc_business_intelligence.xls/Cost Detail
Date Printed: 4/26/2007
Page 7 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Cost Detail
As Of: 4/26/2007
Cost Description Project Cost Category
Term Emulation SFTW-Maintenance Software
Server - Acquisition/Upgrade Infrastructure
Server - Maintenance Infrastructure
Server Sftwre - Acquisition/Upgrade Infrastructure
Server Sftwre - Maintenance Infrastructure
TBD Infrastructure
TBD Infrastructure
TBD Infrastructure
TBD Infrastructure
Internet Access Infrastructure
Project Staff Training Training
User Training Training
Affects Project ROI? Potential Cost Extensions
Y1 Y2 Y3 Y4 Y5 Y6 Y1 Y2 Y3 Y4 Y5 Y6
cjcc_business_intelligence.xls/Cost Detail
Date Printed: 4/26/2007
Page 8 REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Cost Summary
As Of: 4/26/2007
Cost Description Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total
Development Services:
IT Hours - New Development
(Enhancements) 3,240 3,240
IT Hours - System Maintenance 0 0 0 0 0
eGovernment - New Development
(Enhancements) 71,736 71,736
User Hours - PTNE/OT
Contractor Professional Services 0
Development Services Subtotal: 74,976 74,976
Hardware:
Hardware Subtotal:
Software:
Software Subtotal:
Infrastructure:
Infrastructure Subtotal
Training:
Training Subtotal:
Other:
Other Subtotal:
Costs Total: 74,976 74,976
cjcc_business_intelligence.xls/Cost Summary
Date Printed: 4/26/2007
Page 9
REV: September 5, 2003
DJ 6351BI
Oakland County -- CJCC Business Intelligence
Return on Investment Analysis
Assumptions
As Of: 4/26/2007
Date
Assumption Description
cjcc_business_intelligence.xls/Assumptions
Date Printed: 4/26/2007
Page 10 REV: September 5, 2003
doc_909763387.pdf