HomeMy WebLinkAbout2013-09-23-Meeting Agendawww.augustaga.gov
Public Safety Committee Meeting Commission Chamber- 9/23/2013- 12:45 PM
PUBLIC SAFETY
1. Motion to approve the award of a 2013 Emergency
Management Performance Grant (EMPG) for the Augusta EMA
Department in the amount of $60,165.00.
Attachments
2. Motion to approve acceptance of an Augusta Judicial Circuit
Felony Drug Court Federal Grant in the amount of $200,000 for
24 months from the Office of Justice Programs at the
Department of Justice.
Attachments
3. Presentation by Mr. Brian Green regarding the offering of a
county initiative to help curb youth violence now.
Attachments
4. Motion to approve the minutes of the Public Safety Committee
held on September 9, 2013.
Attachments
5. Presentation by Motorola for a camera and radio system.
(Requested by Commissioner D. Smith)
Attachments
6. Approve Upgrade of Sungard IFAS Product to OneSolution.
Attachments
Public Safety Committee Meeting
9/23/2013 12:45 PM
2013 Emergency Management Performance Grant
Department:EMA
Caption:Motion to approve the award of a 2013 Emergency Management
Performance Grant (EMPG) for the Augusta EMA Department in
the amount of $60,165.00.
Background:The purpose of this grant program is to provide assistance to state,
local, tribal and territorial governments in preparing for all
hazards as authorized by the Robert T. Stafford Disaster Relief
and Emergency Assistance Act (42 U.S.C 5121 et seq.) Title VI of
the Stafford Act authorizes FEMA to make grants for the purpose
of providing a system of emergency preparedness for the
protection of life and property in the United States from hazards
and to vest responsibility for emergency preparedness jointly in
the federal and the states and their political subdivisions. The
federal, through the EMPG, provides necessary direction,
coordination, guidance, and provides necessary assistance, as, in
this title so that a comprehensive emergency preparedness system
exists for all hazards.
Analysis:This grant will help fund the Augusta EMA Department. They are
permitted to use these funds for salaries and/or equipment.
Financial Impact:The EMA budget is very small in comparisson to most other
public safety departments. The approved budget for 2013
including salaries and benefits is $210,010. This grant would add
$60,165 to off set the costs of operations.
Alternatives:Currently there are no available alternatives to supplement the
Augusta EMA budget.
Recommendation:To apply and accept the 2013 Emergency Management
Performance Grant (EMPG).
Funds are Available
in the Following The award is for $60,165 with matching funds of $60,165.
Matching funds will come from in kind match and the EMA
Cover Memo
Item # 1
Accounts:budget. Funds are available in account #10139210.
REVIEWED AND APPROVED BY:
Finance.
Law.
Administrator.
Clerk of Commission
Cover Memo
Item # 1
Attachment number 1 \nPage 1 of 1
Item # 1
Attachment number 2 \nPage 1 of 1
Item # 1
Public Safety Committee Meeting
9/23/2013 12:45 PM
AJC Felony Drug Court Federal Grant Acceptance
Department:Superior Court
Caption:Motion to approve acceptance of an Augusta Judicial Circuit
Felony Drug Court Federal Grant in the amount of $200,000 for
24 months from the Office of Justice Programs at the Department
of Justice.
Background:Augusta Judicial Circuit Drug Court has been awarded a $200,000
grant for 24 months from the Office of Justice Programs at the
Department of Justice. The AJCDC plans to expand its
participant levels and services. The current program supports a
maximum of 100 participants. This grant will increase services to
support up to 125 participants. Over the 24 months of the grant,
an estimated 150-175 participants will be served. The target
population consists of adults primarily with drug and/or property
offenses or violations of probation and who are designated as
medium to high risk/needs based on assessments including the
LSI-R. The LSI-R is a quantitative survey of offenders relevant to
level of supervision and treatment decisions. The intent of the
AJCDC grant will be to increase the number of participants, to
modify existing drug testing procedures and frequencies, to
enhance court operations by having the program evaluated and to
attend training programs, and to expand offender management
services by improving the overall quality of case management and
community supervision. This will be accomplished by expanding
the frequency of offender home and employment visits,
enchancing drug testing and frequency, conducting an unbiased
evaluation of the court to measure the achievement of program
goals and effectiveness, forgoing partnerships for community-
based education and services with the local technical college and
other community organizations to improve program effectiveness,
and lastly through continuing interdisciplinary education to
promote effective drug court planning and opertions.
Analysis:
Financial Impact:Budget Summary Augusta Judicial Circuit Drug Court Total
Years 1 & 2 Costs Federal Local Match Total Personnel $34,000
Cover Memo
Item # 2
$66,666 $100,666 Fringe Benefits $2,610 $0 $2,610 Travel
$32,790 $0 $32,790 Equipment $0 $0 $0 Supplies $67,500 $0
$67,500 Construction $0 $0 $0 Consultants/Contracts $10,000 $0
$10,000 Other Costs $53,100 $0 $53,100 Indirect Costs $0 $0 $0
Total Project Costs: $200,000 $66,666 $266,666 Budget Narrative
Years 1 & 2 The following budget is identical for Year 1 and Year
2. A total project summary is provided. Personnel/Fringe Benefits
Ms. Ted Wiggins is the Coordinator for the Augusta Judicial
Circuit Drug Court. He will be spending approximately 50 percent
(50%) of her time implementing and managing the enhancements
if awarded this grant. Mr. Wiggins’ salary is paid by local funds.
The AJCDC is seeking additional enforcement officers to provide
community supervision. The AJCDC estimates that each officer
will dedicate five to ten hours per/week of their time, in addition
to their regular law enforcement duties, to conduct home and
employment checks to enhance our community supervision
element of the Drug Court. The AJCDC is seeking the overtime
funds needed as compensation for the officer in the total amount
of $12,000 each to be paid out of grant funds. Please note that
multiple officers may provide this service. Officers are paid an
average overtime rate of $26/hour. The AJCDC seeks funds to
expand the hours of the drug lab technician by approximately 10
hours per week at a cost of $10/hour. Fringe benefits for the
officers and part-time lab technician are calculated for FICA
(social security) at 6.2% of salary and Medicaid at 1.45% of
salary. Travel The AJCDC are seeking funds to allow up to seven
(7) team members to attend the mandatory BJA training. The
AJCDC are seeking for this to be paid out of grant funds. The
location is unknown at this time but it is anticipated that both
trainings will be the annual National Association for Drug Court
Professional conference. For budget purposes, Washington DC
was chosen as the location. The total costs are estimated to be
$16,395 per year. Costs for training for each team member
includes airfare ($500), lodging ($175/night), meals and
incidentals ($58/day), conference registration ($650) and misc.
mileage and related ($190 total). Supplies Drug Testing Supplies -
In the anticipation of expanding the in-house drug testing lab, The
AJCDC seeks for funds drug testing reagents and related supplies.
The AJCDC anticipate increasing drug testing by 2-3 tests per
month per participant. The costs in the budget reflect the average
costs for each reagent (cocaine, THC, amphetamine, etc). One test
may use one reagent or as many 10-12 depending on the drugs
being tested for. Estimated yearly costs are $20,000. Special Drug
Testing Supplies - Exotic and designer trusts such as Fentanyl,
spice, bath salts, etc can only be tested in an external lab. Costs for
such tests average $35/each. The AJCDC anticipates
approximately 200 of such tests per year for a yearly total of
$7,000. General Education Development Supplies - To assist our
Drug Court participants in obtaining their General Equivalency
Diploma and for use materials (workbooks, etc) to be used in
treatment, the AJCDC seeks funds to purchase the necessary
Cover Memo
Item # 2
curriculum, work books, writing utensils, and any other necessary
supplies that will be needed. Costs are estimated at $20 per
participant for a yearly total of $2,500. Transit Passes - The
AJCDC seeks funds for transit passes for participants. Passes
enable participants to attend treatment, court sessions, community
service and other program required attendance. Costs are
estimated at $1.25/pass for 1,000 passes per year for a total of
$1,250 per year. YMCA/Community Partners - The AJCDC seeks
funds for “day” passes for participants. Passes enable participants
to attend recreation and exercise sessions, group and family
activities and related social and wellness events and activities.
Costs are estimated at $10/pass for 300 passes per year for a total
of $3,000 per year. Consultants/Contracts Program Evaluation - A
qualified Evaluator will be selected to conduct am evaluation for
our program both years. The Evaluator will have extensive drug
court knowledge and have conducted similar evaluations in the
past. The evaluation costs will be paid out of grant funds at a cost
of $5,000 per year. Other Costs General Equivalency Diploma
Test Fees - To assist our Drug Court participants in obtaining their
General Equivalency Diploma the AJCDC is seeking funds for the
associated testing fees. Augusta Technical College charges a
$95.00 fee for each test. The AJCDC are seeking that the funds for
testing to be paid out of grant funds for up to 10 tests/year for a
total of $950 per year. Residential Treatment - Costs for assisting
participants for attending a short-term residential treatment
program are estimated at up to $5,000/year. The AJCDC will seek
to help participants on a sliding scale to maximize the use of these
funds to support multiple participants. Family Counseling - In
order to provide better treatment outcomes, the Treatment
Provider has offered to conduct family support counseling
sessions for participants who seek to have their families support
their recovery efforts. Costs are estimated at $200 per group
session that will include multiple participants and their family.
The Treatment Provider will conduct two (2) group family
counseling sessions per month for a total of $4,800 per year.
Vocational Rehabilitation - The AJCDC will establish a
vocational rehabilitation program based on the Workforce
Enhancement Reentry Curriculum (WERK). Three to six 8-week
sessions will be offered each year for up to 10-12 participants in
each session. WERK allows participants to meet and hear from
local area employers about what they look for in an employee, put
together a resume packet that will make the attractive to
employers, work closely for eight weeks with an organization that
is willing to fully support their efforts to achieve mastery of the
WERC curriculum and provide training in basic job skills. Costs
per session are estimated at $100 to include the time for the
session leader and all materials. Total costs are estimated at
$4,800 per year. Transitional Housing - Funding from the grant
will provide transitional housing unit for up to four (4)
participants at any given time. Through the local housing authority
provider, the transitional housing would be available for short-
Cover Memo
Item # 2
term stays of 3-6 months allowing the AJCDC to utilize the unit
for as many as 12-15 participants per year. Total costs are
estimated at $500/month for a single 4-person housing unit.
Individual Treatment/Counseling - In order to provide better
treatment outcomes, the Treatment Provider has offered to
conduct individual counseling sessions for participants who seek
to address specified individual treatment needs. Costs are
estimated at $50 per 30-minute session. The Treatment Provider
will conduct up to 100 counseling sessions per year for a total of
$5,000 per year.
Alternatives:
Recommendation:
Funds are Available
in the Following
Accounts:
REVIEWED AND APPROVED BY:
Finance.
Superior Court
Finance.
Law.
Administrator.
Clerk of Commission
Cover Memo
Item # 2
Public Safety Committee Meeting
9/23/2013 12:45 PM
Brian Green
Department:Clerk of Commission
Caption:Presentation by Mr. Brian Green regarding the offering of a
county initiative to help curb youth violence now.
Background:
Analysis:
Financial Impact:
Alternatives:
Recommendation:
Funds are Available
in the Following
Accounts:
REVIEWED AND APPROVED BY:
Cover Memo
Item # 3
Attachment number 1 \nPage 1 of 1
Item # 3
Public Safety Committee Meeting
9/23/2013 12:45 PM
Minutes
Department:Clerk of Commission
Caption:Motion to approve the minutes of the Public Safety Committee
held on September 9, 2013.
Background:
Analysis:
Financial Impact:
Alternatives:
Recommendation:
Funds are Available
in the Following
Accounts:
REVIEWED AND APPROVED BY:
Cover Memo
Item # 4
Attachment number 1 \nPage 1 of 2
Item # 4
Attachment number 1 \nPage 2 of 2
Item # 4
Public Safety Committee Meeting
9/23/2013 12:45 PM
Motorola
Department:Clerk of Commission
Caption:Presentation by Motorola for a camera and radio system.
(Requested by Commissioner D. Smith)
Background:
Analysis:
Financial Impact:
Alternatives:
Recommendation:
Funds are Available
in the Following
Accounts:
REVIEWED AND APPROVED BY:
Cover Memo
Item # 5
Public Safety Committee Meeting
9/23/2013 12:45 PM
Sungard IFAS to OneSolution Upgrade
Department:Information Technology
Caption:Approve Upgrade of Sungard IFAS Product to OneSolution.
Background:Augusta originally contracted with Bi-Tech, Inc. in 1997 to supply
Enterprise Resource Planning (ERP) software, which manages all
the financial, procurement, and human resources processes in the
city. Over the years, additional modules have been added to the
software through various addendums which have been approved
by the Augusta Commission. Sungard is a growing company and
has consolidated products that it has acquired and updated them to
modern architecture and appearance. The new product is called
“OneSolution”, and it replaces the IFAS suite of products that
Augusta currently uses. Additionally, the IFAS software has used
a database called Oracle for several years. Due to consolidation
within the hardware and database industry, Oracle will no longer
be available on a hardware/database platform that Augusta
operates. Part of this project will be to convert the IFAS database
from Oracle to Microsoft SQL Server.
Analysis:The attached proposals include several major changes related to
the IFAS / OneSolution transition. Database Change: Augusta is
moving from an Oracle database to a SQL Server database. This
moves one of our major platforms to an easier-to-maintain
database architecture and permits us to take advantage of a more
diverse set of technological tools (through Microsoft). This change
satisfies part of IT’s goal of consolidating applications and
databases to a smaller number of platforms. The move to
OneSolution permits Augusta to take advantage of the additional
HR features that are available in OneSolution (such as automated
Requests for Personnel Action), Professional Development, and
enhanced reporting capabilities for the entire system. The change
to OneSolution permits Augusta to put funding into a hardware &
software platform (Microsoft) that is not proprietary and can be
easily linked with other systems. Oracle’s development path is
projected to be more costly and will actually require the purchase
of new, large-scale equipment on a different operating system than
we currently use for any other application. The contract includes
training for the new OneSolution application, which will permit
Cover Memo
Item # 6
Augusta to refresh the knowledge base for all employees that
utilize the system and bring everyone to a common level of
understanding on the software and its capabilities. The existing
Augusta contract with Sungard was re-worked in 2013 to include
current Procurement language as approved by the commission.
Financial Impact:The cost of this upgrade is approximately $320,000. Please see the
attached documentation for a module-by-module breakdown of
the hardware, software, and licensing costs.
Alternatives:No practical alternatives from a technological or financial
perspective.
Recommendation:Approve Upgrade of Sungard IFAS Product to OneSolution
Funds are Available
in the Following
Accounts:
The cost will be funded through IT’s SPLOST VI Application
Consolidation funds, which are available in GL 328-01-2110 / JL
212925102. The predominant object codes for this purchase will
be 5424210 (servers) and 5424220 (server software).
REVIEWED AND APPROVED BY:
Finance.
Law.
Administrator.
Clerk of Commission
Cover Memo
Item # 6
Attachment number 1 \nPage 1 of 15
Item # 6
Attachment number 1 \nPage 2 of 15
Item # 6
Attachment number 1 \nPage 3 of 15
Item # 6
Attachment number 1 \nPage 4 of 15
Item # 6
Attachment number 1 \nPage 5 of 15
Item # 6
Attachment number 1 \nPage 6 of 15
Item # 6
Attachment number 1 \nPage 7 of 15
Item # 6
Attachment number 1 \nPage 8 of 15
Item # 6
Attachment number 1 \nPage 9 of 15
Item # 6
Attachment number 1 \nPage 10 of 15
Item # 6
Attachment number 1 \nPage 11 of 15
Item # 6
Attachment number 1 \nPage 12 of 15
Item # 6
Attachment number 1 \nPage 13 of 15
Item # 6
Attachment number 1 \nPage 14 of 15
Item # 6
Attachment number 1 \nPage 15 of 15
Item # 6
Attachment number 2 \nPage 1 of 6
Item # 6
Attachment number 2 \nPage 2 of 6
Item # 6
Attachment number 2 \nPage 3 of 6
Item # 6
Attachment number 2 \nPage 4 of 6
Item # 6
Attachment number 2 \nPage 5 of 6
Item # 6
Attachment number 2 \nPage 6 of 6
Item # 6
NEW OneSolution Modules
ONESolution Professional Development
Product Name Service Type Qty Extended Price Net Price Maintenance
OS-FIN-PD ONESolution Professional Development License Fee 1 15,800.00$ 15,800.00$ 2,530.00$
ONESolution Professional Development Discount 0 -$ -$
OS-FIN-PD ONESolution Professional Development Auditing 1 1,280.00$ 1,280.00$
OS-FIN-PD ONESolution Professional Development Configuration Mapping 1 1,280.00$ 1,280.00$
PS-IN ONESolution Professional Development Installation 1 2,800.00$ 2,800.00$
OS-FIN-PD ONESolution Professional Development Project Management 1 640.00$ 640.00$
OS-FIN-PD ONESolution Professional Development Training 1 1,280.00$ 1,280.00$
Project Total 23,080.00$ 2,530.00$
ONESolution Personnel Action Forms
Product Name Service Type Qty Extended Price Net Price Maintenance
OS-FIN-PAF OneSolution Personnel Action Forms License Fee 1 19,350.00$ 19,350.00$ 3,100.00$
OneSolution Personnel Action Forms Discount 1 (5,805.00)$ (5,805.00)$
OS-FIN-PAF OneSolution Personnel Action Forms Project Management 1 1,280.00$ 1,280.00$
OS-FIN-PAF OneSolution Personnel Action Forms Training 1 1,280.00$ 1,280.00$
OS-FIN-PAF OneSolution Personnel Action Forms Workflow Development 1 1,600.00$ 1,600.00$
Project Total 17,705.00$ 3,100.00$
ONESolution Employee Online
Product Code Product Name Service Type Qty Extended Price Net Price Maintenance
Employee Online (EO)License Fee 1 13,200.00$ 13,200.00$ 2,110.00$
Employee Online (EO) Software Installation 1 2,800.00$ 2,800.00$
Employee Online (EO) Development 1 7,200.00$ 7,200.00$
Employee Online (EO) Training 1 5,760.00$ 5,760.00$
Employee Online (EO) Remote Project Mgt 1 2,364.00$ 2,364.00$
Project Total 31,324.00$ 2,110.00$
At
t
a
c
h
m
e
n
t
n
u
m
b
e
r
3
\
n
P
a
g
e
1
o
f
3
It
e
m
#
6
ONESolution Upgrade
Product Code Product / Service Service Type Qty Extended Price Net Price Maintenance
License Fees
OS-CRCPT One Solution Cash Receipts N/A 1 -$ 2,430.00$
Total License Fees -$ 2,430.00$
Professional Services
Product Code Product Name Service Type Qty Extended Price Net Price Maintenance
PS-CD Prof Svc-Custom Development Fee Custom development 1 8,000.00$ 8,000.00$ -$
OS-UPGR-7.9-11.X ONESolution 7.9 Unix to SQL Migration 11.x upgrade Installation 1 27,300.00$ 27,300.00$ -$
PS-WU Prof Svc-weekend Uplift Fee Installation 1 1,750.00$ 1,750.00$ -$
OS-UPGR 7.9-11.x ONESolution 7.9 Unix to SQL Migration 11.x upgrade Project Management 1 12,160.00$ 12,160.00$ -$
OS-UPGR 7.9-11.x ONESolution 7.9 Unix to SQL Migration 11.x upgrade Training 1 23,680.00$ 23,680.00$ -$
PS-TR Prof Svc-Training Fee Training 1 3,200.00$ 3,200.00$ -$
OS-UPGR 7.9-11.x ONESolution 7.9 Unix to SQL Migration 11.x upgrade Workflow Development 1 12,800.00$ 12,800.00$ -$
Total Professional Services 88,890.00$ -$
Third Party
Product Code Product Name Service Type Qty Extended Price Net Price Maintenance
OS-FCOREIF ONESolution Financials Core-IFAS License Fee 1 18,550.00$ 18,550.00$
OS-GCOREIF ONESolution Global Core-IFAS License Fee 1 2,076.00$ 2,076.00$
COGNOS-AB5 Cognos BI: Adv Business Author Bundle License Fee 1 6,240.00$ 6,240.00$
COGNOS-C Cognos BI: Café (Analysis for Excel) License Fee 1 1,500.00$ 1,500.00$
BICORE COGNOS BI: Base Bundle License Fee 1 17,100.00$ 17,100.00$
OS-FCOREIF ONESolution Financials Core-IFAS Maintenance 1 -$ -$ 2,970.00$
OS-GCOREIF ONESolution Global Core-IFAS Maintenance 1 -$ -$ 330.00$
COGNOS-AB5 Cognos BI: Adv Business Author Bundle Maintenance 1 -$ -$ 1,200.00$
COGNOS-C Cognos BI: Café (Analysis for Excel) Maintenance 1 -$ -$ 240.00$
BICORE COGNOS BI: Base Bundle Maintenance 1 -$ -$ 2,740.00$
BICORE COGNOS BI: Base Bundle Prof Svc - Installation 1 1,400.00$ 1,400.00$
BICORE COGNOS BI: Base Bundle Prof Svc - Project Mgt 1 640.00$ 640.00$
COGNOS-TRAIN-ADMIN Cognos BI: Administrator ONLY online Training Package Prof Svc - Training 1 960.00$ 960.00$
COGNOS-TRAIN-MAX Cognos BI: Onsite Training Package Bundle (MAX) Prof Svc - Training 1 12,600.00$ 12,600.00$
Total Third Party 61,066.00$ 7,480.00$
Total OneSolution Upgrade 149,956.00$ 9,910.00$
Project Software Total (New Modules + Upgrade of Existing Modules)222,065.00$ 17,650.00$
At
t
a
c
h
m
e
n
t
n
u
m
b
e
r
3
\
n
P
a
g
e
2
o
f
3
It
e
m
#
6
Overall ONESolution Project Summary Cost
Project Capital Cost Add'l Maintenance
Cost
ONESolution Professional Development 23,080.00$ 2,530.00$
ONESolution Personnel Action Forms 17,705.00$ 3,100.00$
ONESolution Employee Online 31,324.00$ 2,110.00$
ONESolution Upgrade 149,956.00$ 9,910.00$
Total 222,065.00$ 17,650.00$
Hardware and Licensing Cost (Projected)
Project Capital Cost Add'l Maintenance
Cost
Server(s) for OneSolution 50,000.00$
MS Windows Server, SQL Server, and other Licenses 15,000.00$
Server for Employee Online (EO)7,000.00$
Total 72,000.00$ -$
Total Project Summary
Project Capital Cost
OneSolution from Sungard 222,065.00$
Hardware and Licensing 72,000.00$
Potential Other Licensing, Hardware, and Training*25,000.00$
Total 319,065.00$ -$
See Note below
Quote from Dell
Quote from HP
Notes
Total from Above
Total from Above
*This line item includes additional unforseen needs that may be identified as the product(s) are implemented, such as extra training,
hardware (dependent on performance and need) and supplemental software licenses that may be required or may be to Augusta's
advantage to implement).
These costs are projected/tentative, and the amounts have been modified slightly to account for potential changes. Hardware and
Licensing costs are subject to changes due to advances in technology, system availability, sales / incentives / other discounts that
may be available at the time of ordering vs. the time at which the equipment was quoted.
Notes
Quote from Sungard
Quote from Sungard
Quote from Sungard
Quote from Sungard
Notes
Quote from HP
At
t
a
c
h
m
e
n
t
n
u
m
b
e
r
3
\
n
P
a
g
e
3
o
f
3
It
e
m
#
6
Sungard Ongoing Annual Maintenance
Application Term Qty Fee Maintenance Per Year
EXISTING
OS Support 12 1 81,539.35$ 2013 2014 2015
OS - General Ledger 12 1 -$ 2013 2014 2015
OS - Accounts Payable/Encumbrances 12 1 -$ 2013 2014 2015
OS - Accounts Receivable/Cash Receipts 12 1 -$ 2013 2014 2015
OS - Check Management 12 1 -$ 2013 2014 2015
OS - Person/Entity Database 12 1 -$ 2013 2014 2015
OS - Fixed Assets 12 1 -$ 2013 2014 2015
OS - AdHoc Report Writer 12 1 -$ 2013 2014 2015
OS - Job Project Ledger 12 1 -$ 2013 2014 2015
OS - Budget Item Detail 12 1 -$ 2013 2014 2015
OS - Purchasing 12 1 -$ 2013 2014 2015
OS - Bid Management 12 1 -$ 2013 2014 2015
OS - Payroll 12 1 -$ 2013 2014 2015
OS - Human Resources 12 1 -$ 2013 2014 2015
OS - Position Budgeting 12 1 -$ 2013 2014 2015
OS - TRIAD 12 1 -$ 2013 2014 2015
OS - Contract Management 12 1 -$ 2013 2014 2015
OS - Easy Laser Forms 12 1 -$ 2013 2014 2015
OS - Stores Inventory 12 1 -$ 2013 2014 2015
OS - Image Enabler 12 1 -$ 2013 2014 2015
OS - Click, Drag, & Drill (Report Writer) 12 1 -$ 2013 2014 2015
OS - Insight 12 1 -$ 2013 2014 2015
OS - 7i 12 1 -$ 2013 2014 2015
OS - Update Services Support (One Account) 12 1 -$ 2013 2014 2015
OS - Open Link 12 1 4,413.65$ 2013
OS - MicroFocus Development -110000289178 12 1 779.76$ 2013
OS- MicroFocus Runtime-110000271825 12 6 1,845.96$ 2013
OS- MicroFocus Development - Server Express Compiler -
Maintenance 600000340508AE 12 1 779.76$ 2013
OS - Microfocus Net Express Runtime Bundles - Maintenance
600000340509AE 12 2 615.32$ 2013
OS - Grant Management 12 1 1,340.00$ 2013 2014 2015
OS - Microfocus Net Express Runtime Bundles-600000418962 12 1 330.00$ 2013
NEW
ONESolution Financials Core-IFAS 1 2,970.00$ 2015
ONESolution Global Core-IFAS 1 330.00$ 2015
Cognos BI: Adv Business Author Bundle 1 1,200.00$ 2015
Cognos BI: Café (Analysis for Excel)1 240.00$ 2015
COGNOS BI: Base Bundle 1 2,740.00$ 2015
One Solution Cash Receipts 1 2,430.00$ 2015
ONESolution Professional Development 1 2,530.00$ 2015
OneSolution Personnel Action Forms 1 3,100.00$ 2015
Employee Online (EO)1 2,110.00$ 2015
TOTAL MAINTENANCE COST PER YEAR 91,643.80$ 82,879.35$ 100,529.35$
Maintenance Value of Discontinued Modules 8,764.45$
Maintenance Value of NEW Modules 17,650.00$
Discontinued in SQL Server Version
Attachment number 4 \nPage 1 of 1
Item # 6
Attachment number 5 \nPage 1 of 5
Item # 6
Attachment number 5 \nPage 2 of 5
Item # 6
• Install and Initial Data Migration
• Post Inst
• SA/DBA Training
• Update Load Asst.
• Mock Data Roll
• Final Data Roll and Go Live
• Test Account Creation
• Project Management
–
–
–
• Total Training
Attachment number 5 \nPage 3 of 5
Item # 6
“”
“”“”
“”“”
The date of delivery is the date on which SunGard Public Sector delivers, F.O.B. SunGard Public Sector’
Attachment number 5 \nPage 4 of 5
Item # 6
materials basis at hourly rates equal to SunGard Public Sector’s then
Attachment number 5 \nPage 5 of 5
Item # 6
Attachment number 6 \nPage 1 of 4
Item # 6
“”
“”“”
Attachment number 6 \nPage 2 of 4
Item # 6
“”“”
rd Public Sector’s place of shipment, the
materials basis at hourly rates equal to SunGard Public Sector’s then
Attachment number 6 \nPage 3 of 4
Item # 6
Attachment number 6 \nPage 4 of 4
Item # 6
Attachment number 7 \nPage 1 of 4
Item # 6
Attachment number 7 \nPage 2 of 4
Item # 6
“”
“”“”
“”“”
te of delivery is the date on which SunGard Public Sector delivers, F.O.B. SunGard Public Sector’s place of shipment, the
ctor’s then
Attachment number 7 \nPage 3 of 4
Item # 6
Attachment number 7 \nPage 4 of 4
Item # 6