HomeMy WebLinkAboutCity of Tamarac Resolution R-81-1501
2
3
5
6
7
8
9
10
11
12
13
14
15
16
s 16
19
20
21
22
23
24
25
26
27
29
J
31
32
33
34
35
36
Introduced by:� — Temp. #1921
Rev. 5/13/81
CITY OF TAMARAC, FLORIDA
RESOLUTION NO. 1---5/--/�y
A RESOLUTION AUTHORIZING ENGAGEMENT OF MUNICIPAL MANAGEMENT
SYSTEMS, INC (MMS) TO PROVIDE A COMPUTER APPLICATION
SOFTWARE PACKAGE TO THE CITY OF TAMARAC FOR USE WITH THE
MICRODATA R-8000 SERIES COMPUTER TO BE ACQUIRED BY THE
CITY.
WHEREAS, the City has gone through a long and detailed review of
proposals for Computer hardware and software; and
WHEREAS, the City has engaged consultants to assist in evaluation of
proposals; and
WHEREAS, a determination has been made by the City Council that the
Microdata R-8000 Series Computer will best serve the needs of the City, and
the Microdata's bid was accordingly the most responsive and responsible; and
WHEREAS, Municipal Management Services, Inc. (MMS) has prepared a
software package which will have to be modified to meet the needs of tYt, City;
and
WHEREAS, the City has been advised by its consultants that no other
software company can provide a software package compatible with the Microdata
hardware that would meet the City's needs.
NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF
TAMARAC, FLORIDA:
SECTION 1: That the recitations set forth above are true and
correct.
SECTION 2: That the provision of the software package is a highly
complex area, requiring special expertise and is found to be professional
services.
SECTION 3: That MMS is determined to be the -sole source supplier of
an existing municipal software package compatible with the Microdata R-8000
Series Computer.
SECTION 4: That MMS is awarded a contract to supply the professional
services at those prices set forth in Exhibit A incorporated
1
2
3
4
6',
8
1U
11
12
13
14
15
16
17
:3
t9
j
21
22
23
24
25
2(
�8
-,9
30
'1
..)2
33
34
35
36
herein and attached hereto. However, this award is subject to the City
entering into a contract with Microdata for the R-8000 Series Computer
hardware, and the entry into a contract with MMS in a form satisfactory to the
City Attorney and in accordance with the material submitted with a cover
letter dated March 30, 1981.
SECTION 5: This Resolution shall be effective upon adoption.
PASSED, ADOPTED AND APPROVED this 2O?,day of , 1981.
ATTEST:
I HEREBY CERTIFY that I have
approved the form and correctness
of this RESOLUTION
CITY ATTORNEY
MAYORt
DISTRICT
DISTRICT
DISTRICT
DISTRICT
RECORD OF COUNCIL VOTE
SOFTWARE LICENSING AGREEMENT
THIS SOFTWARE LICENSING ,AGREEMENT (this "Agreement") is made and entered
into as of the cC t't by and between MUNICIPAL
MANAGEMENT SYSTE ., a Romp c a i erei after "MMS"), and CITY OF
TAMARAC, a municipal corporation f the State of Florida (hereinafter
"TAMARAC").
In consideration for the mutual covenants and agreements contained
herein, MMS and TAMARAC hereby agree as follows:
1. GRANT:
MMS hereby grants to TAMARAC, a non-exclusive right and license to
use the software programs and packages described on Schedule "A" attached and
made a part of this Agreement (hereinafter "Software Packages"). Except as
hereinafter provided, TAMARAC shall have the right and license to use the
Software Packages only on the central processing unit and other equipment
described on Schedule "B" attached to and made part of this Agreement
(hereinafter "Equipment"). In the event of the breakdown or failure of any of
the Equipment, TAMARAC shall have the right to use the Software Packages on a
temporary basis on such emergency back-up equipment as TAMARAC may deem
appropriate until the Equipment can be repaired or replaced. In the event
TAMARAC desires to change or replace any of the Equipment, TAMARAC may request
permission from MMS to use the Software packages on such new or replaced
equipment. MMS agrees that it will not unreasonably withhold its approval of
any such request from TAMARAC.
TAMARAC shall not have the right to transfer or assign this license
without the prior written approval of MMS.
2. SOFTWARE PACKAGES:
The Software Packages shall consist of an object module and source
module and the basic and related materials and documents pertinent thereto, in
machine readable or printed form, and any updated program or portion thereof
hereinafter furnished by MMS to TAMARAC. The Software Packages shall meet the
specifications set forth on Schedule "A" attached hereto.
Documentation shall include source program listings, program index,
file layouts and system flow charts in addition to the user manuals described on
Schedule "A" attached hereto.
3. WARRANTIES OF MMS:
MMS represents and warrants to TAMARAC as follows:
A. MMS has the full right, power and authority to grant the
rights and privileges herein granted to TAMARAC.
B. TAMARAC shall have the right to use the Software Packages as
herein provided until termination of this Agreement by MMS or TAMARAC as
provided in Section 10 below.
C. The Software Packages do not infringe upon any patents or
copyrights heretofore issued in the United States or any foreign country or upon
any application therefore or upon any other proprietary rights of others. MMS
shall defend at its own expense any action or suit brought against TAMARAC
IQ alleging that the Software or any part thereof infringes upon a United States
Patent, and MMS shall pay all costs and damages finally awarded against TAMARAC
in any such suit; provided, however, that MMS shall be notified promptly in
writing of any such claim and suit and shall be given full and complete
authority, information, and assistance for the defense of such suit. MMS shall
not be responsible for any compromise or settlement of such claim or suit made
without its consent. The foregoing indemnification shall not apply if the
_infringment arises from modification or misuse of the Software which is the
subject matter of this Agreement.
2.
D. MMS warrants that the Software shall be free from defects in
material and workmanship and that the same meets the specifications of the
E.D.P. user requirements included in Schedule "A", for a period of ninety (90)
days after TAMARAC has notified MMS of the satisfactory completion of diagnostic
testing as hereinafter set forth in section 4.
4. INSTALLATION AND ACCEPTANCE:
The Software Packages shall be installed on the Equipment by MMS at
the sole cost and expense of MMS. After such installation, TAMARAC shall test
the Software Packages to verify by such testing that the Software Packages
comply with the specifications set forth on Schedule "A" attached hereto. Such
testing shall be completed no later than ninety (90) days after the Software
Packages have been installed for use on the Equipment. In the event such
testing reveals that the Software Packages do not meet the specifications set
forth on Schedule "A" attached hereto, then MMS agrees that upon being notified
in writing of any such defects within the said ninety (90) day period, MMS at
its option and cost, shall either repair or replace the defective items or cause
same to be revised or modified to meet TAMARAC's requirements (the
specifications and standards set forth in Schedule "A" attached hereto).
TAMARAC shall notify MMS in writing of the satisfactory completion of the
diagnositc testing (upon MMS making any necessary replacements, repairs,
modifications, etc., if same are required) and the date thereof shall constitute
the date of acceptance by TAMARAC.
5. PERFORMANCE GUARANTEE:
MMS agrees to install the source code on the computer of Microdata
Corporation at its branch office in Miami and deliver to Microdata the user
documents of all subsystems. Thereafter, immediately upon delivery of written
notification that the same has been accomplished, TAMARAC shall pay to Municipal
Management Systems, Inc. the first of three (3) equal installments. The second
installment shall be due and payable on delivery of the Hardware, operating
systems Software and source codes along with the user documents of all systems
to TAMARAC. The third installment shall be due upon the full performance by MMS
of the terms and conditions of the herein licensing agreement. Furthermore, the
parties agree that in the event MMS does not install the source code and deliver
the user documents for all subsystems to Microdata Corporation on or by thirty
(30) days from the execution of this agreement then, and in that event, the
parties agree that this agreement is null and void and no payments are due from
the TAMARAC to MMS.
6. COMPENSATION:
TAMARAC shall pay to MMS the payments set forth on Schedule "C"
attached to and made a part of this Agreement for the right to use the Software
Packages as provided by this Agreement. TAMARAC is tax exempt and shall provide
MMS with tax number at time of execution of this Agreement.
7. PROPRIETARY RIGHTS:
TAMARAC acknowledges that the Software Packages are the property
of MMS or of some owner or owners who have licensed MMS, and TAMARAC further
acknowledges that the Software Packages are being made available to TAMARAC in
confidence and solely on the basis of TAMARAC's confidential relationship to MMS
and for use by TAMARAC as provided in this Agreement. TAMARAC agrees that it
will not provide or otherwise make available to any third party or parties
(except as permitted by Section 1 and elsewhere in Section 7 of this Agreement)
any portion of any original or modified Software Package or related materials.
TAMARAC further agrees that it will not print or copy any portion of an original
or modified Software Package or related materials except for its own use.
The parties hereto recognize, however, that the City of TAMARAC is a
public entity subject to the Florida Statutes relating to public documents.
Accordingly, the parties agree that if demand is made upon the City pursuant to
the present or future law with regard to public documents in a manner so that
i
I
1
1
3.
the City, based upon its own determination conclude that it is legally bound to
make a disclosure, then and in that event, the City agrees to notify MMS in
writing of the then existing facts and circumstances, and MMS within ten (10)
days of the receipt of said notice could, if it chose to do so, undertake at its
own expense whatever legal action would be required to prevent said disclosure
by TAMARAC. If MMS did not undertake said legal action within ten (10) days
from receipt of said notice, then and in that event, the City would be free to
make said disclosure.
8. PROPRIETARY NOTICES:
Any and all copyrights
notices of ownership on the Software
Packages or related documentation.
9. SERVICES:
notices, proprietary notices, or other
Packages shall be retained on the Software
MMS shall provide to TAMARAC as a minimum, the number of man hours
specified on Schedule "A" attached hereto for program installations, program
modifications, data conversions and user training. The parties agree, however,
that the limitations set forth in this paragraph shall not apply to the
requirements and obligations undertaken by MMS as set forth in paragraph 4
above.
10. TERN AND TERMINATION:
This Agreement shall continue in full force and effect from the
date hereof until termination by TAMARAC or MMS as provided below.
This Agreement and the license provided for herein may be
terminated by TAMARAC at any time by giving written notice of termination to
MMS.
This Agreement and the
terminated by MMS only in the event (i)
to be made to MMS hereunder within
become due and payable as provided
TAMARAC fails to observe, perform or
hereunder and refuses or is unable to cu
after written notice of such failure has
license provided for herein may be
TAMARAC fails to make payment required
thirty (30) days after such payment has
on Schedule "C" attached hereto or (ii)
comply with any of its obligations
re such failure within thirty (30) days
been provided by MMS to TAMARAC.
Upon termination of this Agreement by either MMS or TAMARAC,
TAMARAC shall deliver to MMS within five working (5) days after receipt of
written demand the original and all copies of all or any portion of the Software
Packages and related materials then in TAMARAC's possession.
11. OMNERS OTHER THAN MMS:
This Agreement is made for the specific benefit of MMS and of any
person, firm or corporation other than MMS that hereafter becomes the owner of
the Software Packages. In this regard, TAMARAC agrees that it will perform its
obligations pursuant to this Agreement in the event that any such person, firm
or corporation other than MMS becomes the owner thereof. TAMARAC further agrees
that such other owner or owners may enforce this Agreement in their own name or
names directly against TAMARAC. MMS agrees that in the event another person,
firm or corporation becomes the owner or owners of this Agreement or Software
Packages or both that any such sale, transfer or assignment shall by its terms
be subject to this Agreement and said person, firm or corporation shall assume
all of the duties and obligations of MMS as set forth in this Agreement.
12. LIABILITY:
Other than is set forth in this Agreement, MMS shall in no instance
or event be liable to TAMARAC for any loss due to failure or inadequacy of
TAMARAC's hardware or supporting systems or both.
4.
13. NODIFICATIONS:
TAMARAC shall have the right to modify the Software Packages or to
cause the Software Packages to be modified to the extent deemed necessary or
appropriate by TAMARAC. MMS, however, shall not be responsible for any
modifications made by TAMARAC to the Software Packages without the express
written approval of MMS. If any such modifications are made without MMS'
approval, then MMS shall be free from any and all liabilities arising from such
modifications. Any modifications made to any Software Packages provided for by
this Agreement will be the property of MMS.
14. CONFIDENTIALITY:
TAMARAC recognizes that it may receive from MMS in connection with
this Agreement information, data and material of a confidential, and proprietary
nature relating to MMS or the Software Packages., TAMARAC acknowledges that
disclosure of such information to third parties would be damaging to MMS.
TAMARAC, therefore, agrees to hold such information in strictest confidence, not
to make use thereof outside the performance of its duties in connection with
this Agreement, and to release such information only to employees of TAMARAC
requiring such information in the performance of their duties hereunder.
TAMARAC further agrees not to disclose or release such information to any other
party except as may be required by applicable Public Records or other Public
Information Laws.
MMS recognizes that it may receive from TAMARAC in connection with
this Agreement information, data and material of a confidential and proprietary
nature relating to TAMARAC or TAMARAC's business. MMS acknowledges that
disclosure of such information to third parties would be damaging to TAMARAC.
MMS, therefore, agrees to hold such information in strictest confidence, not to
make use thereof outside the performance of its duties in connection with this
Agreement, and to release such information only to employees of MMS requiring
such information in the performance of their duties hereunder or to employees of
the subcontractor or agent retained by MMS pursuant to Section 4 hereof. MMS
further agrees not to disclose or release such information to any other party.
15. WARRANTY OF CITY:
MMI MANAGEMENT SYSTEMS ("MMI") and MMS grant to the CITY OF TAMARAC
and the CITY OF TAMARAC accepts a non-exclusive and non-transferrable license to
install and use the Software Packages listed below on the equipment. Such
license does not include the right to sublicense the Software Packages to
others. A Software Package may not be reproduced or published without MMI's and
MMS' written consent. The CITY OF TAMARAC agrees that the Software Packages are
the property of and proprietary to MMI and the CITY OF TAMARAC further agrees to
keep confidential and to utilize its best efforts to prevent and protect the
Software Package against unauthorized use or disclosure. All copies will
include the same copyright identification in the form and location as in the
original and shall as between the parties, be MMI's sole property.
16. MISCELLANEOUS:
This Agreement shall supersede all prior agreements and
understandings between the parties respecting the subject matter hereof.
No modification or waiver of this Agreement shall be valid or
binding on either party unless in writing signed by both parties. Titles to
sections contained herein are for identification purpses only and are not to be
construed as part of this Agreement.
17. NOTICES:
Any notice or communication required or permitted under this
Agreement shall be given by certified return receipt, postage prepaid, U.S.
Mail, to the following addresses:
5.
FOR TAMARAC: The City Manager
City of Tamarac
5811 Northwest 88th Avenue
Tamarac, Florida 33321
FOR MMS: Municipal Management Systems, Inc.
5951 N.W. 151 Street, Suite 108
Miami Lakes, Florida 33014
Any such notice or communication may also be personally delivered to either
party at the above addresses, or any such notice or communication whether by
certified mail or personal delivery, may be delivered to such other address or
in care of such other person as shall be designated hereafter in writing by
either party to the other and delivered in the same fashion as notices are
provided to be delivered herein. Any such notice shall be deemed to have been
given as of the date personally served, or as of the date received, if sent by
certified mail, return receipt requested, whichever event first occurs;
provided, however, in the event that either party shall refuse to accept the
delivery of certified mail, then it shall be deemed that such notice was
received as of the date on which it was delivered to the United States Mails,
postage prepaid.
MMS
MUNICIPAL MANAGEMENT SYSTEMS, INC.
11
BY:; f (Title)
BYA
Attested by:
-�/'; ZZ -- Z" & a, -, -, -
c etary
Dated this �' day of 1981.
ATTEST:
/ 1liW-e'
ATTEST:
CITY OF TAMARAC
By
Th
By <
CITY MANr
This--�,Aday o 198 1
SCHEDULE "A"
CITY OF TAMARAC
APPLICATION SOFTWARE SPECIFICATIONS
The requirements of the City have been defined into several
functional areas. These areas and their priority are:
• Utility Billing
• General Ledger/Financial Reporting
• Vehicle Maintenance
• Inventory
• Purchasing
• Fixed Assets
• Occupational Licenses
• Payroll/Personnel
• Accounts Payable
Cash Receipts
• Police and Fire Department
The above areas are not all inclusive. If the vendor has
additional software that could be implemented on the hardware,
that software will be considered.
Most of the subsystems will be a combination of on-line and
batch mode. The application software must be capable of
supporting on-line data entry. The data would be entered
during prime time through terminals.
If the bidder believes they have additional features in their
subsystems that the City should consider, it would be in the
best interest of both parties to discuss those features.
Additionally, if any of the requirements are not met, the
bidder may present the City with alternatives feature.
1
U^ILITY BILLING
OBJECTIVES:
• To record and bill customers .for the usage of water
and sewer services
• To maintain historical records of billings, payments
and consumption
• To maintain records of equipment.in use and location
of that equipment.
• To print the following:
• Bills
• Meter Reading Sheets
• Service Orders
• Delinquency Notices
• Statistical Reports
NARRATIVE DESCRIPTION:
The City of ,amarac operates two utility systems for water and
sewage. This subsystem should be able to maintain the
separation between the two utilities and still prepare
consolidated reports. Since there are two utilities their
billing structure as well as some of their operating
characteractics may differ slightly. The subsystem should be
able to accommodate this situation. The ordinance specifying
charges and requirements related to utility billing are
enclosed in Appendix A. Briefly, the inputs to the system are:
• Meter Readings
• Meter Changes
• Deposits
• Adjustments
• New Customers
The bills are generated in four cycles.
The subsystem is expected to have on-line inquiry to support
the customer relation activities. The system will maintain at
least thirteen months of account history retrievable by account
number name or address.
It is expected that the utility subsystem will interface with
the general ledger, licencing, cash receipts and police
reporting subsystem.
REPOP:'ING R£QUIREMEr S:
• Customer Master File Printout
• Billing register
• Accounts receivable subsidiary ledger
-Z-
M
i.-
0 Deliquency notices
_ • Cutoff notices
• Consolidated deliquency report listing
• Bad check listing
• Statistical reports:
• Consumption analysis
• Work order analysis
• Customer breakdown by type
• Utilization summarize by customer type
• Others
• Deposit ledger
• List of meters by sizes and addresses and type of
customers
• Aging of account receivable
• Meter readings edit run (high and low consumption
warnings)
• Customer master file updates
• Payments and receipts summary
• Daily charges and adjustments
• Year to date reports
MISCELLANEOUS DATA:
The utility systems currently service 17,000 customers.
Approximately, 12,O00 bills are required on a monthly basis.
This volume may increase by F08 in the next two to three
years. The syster. currently has 92 route meter reading books.
-3_
GENERAL LEDGER/FINANCIAL PEPOPTING
GBJECTIV£St
• To maintain appropriations, funds and general ledger t
account balances
• To prepare financial reports
• To provide budgetary reports
• To maintain subsidiary ledgers
• To aid in general City management
NAPPATIVE DESCRIPTION:
The General Ledger/Financial Reporting subsystem may be a batch
system. All entries to this subsystem must be self balancing
and appear on an audit trail that identifies the origin of the
transactions, the date entered, date posted, voucher or control
number used, the amounts involved, the budgetary information
associated with the transaction (if any), and any clarifying
comments that the user may add to it. The subsystem must be
able to accept either manual or automatic transactions from
other subsystems. This subsystem is expected tos
• Meet currently prescribed legally and generally
f accepted accounting principles
• Be compatible with the State of Florida Chart of
Accounts
• Be able to produce the financial statements specified
in the Governmental Accounting Auditing and Financial
Reporting Guideline
• Be able to provide daily, weekly, monthly summaries of
revenues, expenditures, encumbrances and account
balances
• Be able to provide the following reports:
• Detail for audit trail purposes
• Summary to aid management
• Budgetary status with variances
REPORTING REQUIPEMEN"rS:
• Balance sheet
• Statement of revenues and expenditures
• Changes in fund balance
-4-
• Complete general ledger printout
• Trial balance
• Budgetary status with variances
• Subsidiary ledgers (Accounts Receivable, Accounts
Payable, Encumbrances, etc.)
MISCELLANEOUS DATA:
• Capable of posting at least 3,000 entries per month
• Should maintain three years of historical information
on monthly basis
• It would be desirable to have a report generator
1
-5-
i
PURCHASING
OBJECTIVES:
• To print and prepare purchase orders
• To keep track of purchases
• t10 encumber funds and maintain a file of encumbrances
• To aid in projecting cash requirements
• To maintain a vendor file
14APRATIVE DESCRIPTION:
This subsystem may be a batch subsystem. It would be desirable
to have on-line inquiry but this need may be adequately
provided for with timely reports. This subsystem should be
able to print purchase orders and maintain control over the
same. Provisions should exist to facilitate the recording of
manually prepared purchase orders. The subsystem should verify
the availability of funds when a purchase is recorded and funds
encumbered. It would be desirable to have the software inform
management of receipts in excess of encumbered amounts.
REPORTING REQUIREMENTS:
• Purchase order register
• Aging of open purchase orders
• Vendor listing
• Receiving report summary
• Encumbrance register
• List of receipts in excess of encumbered amount
• Accounting summary
• Purchases by department
• Purchases by vendor
• Encumbrance adjustment register
MISCMA-VE.OUS DATA:
• The City issues approximately 4,000 purchase orders
per year
• It is very likely to have 1.000 purchase orders
outstanding on any given moment
• The system should be able to handle up to 50C
transactions per year
1
M
PAYROLL/PERSONNEL
OBJECTIVESs
• To eorpute wages and deductions
• ^o properly maintain employee files as to wage rate
history, changes in status, deduction authorizations,
leave, and over -time worked
• To print employee pay checks
• To aid in determining staffing requirements of the City
MPRATIV£ DESCRIPTION:
,his subsystem does not need to be an on-line application, but
data entry for the system should be on-line and the data
validated on-line. Payroll in the City of Tamarac is prepared
on bi-weekly basis. The main source of data entry will be a
document from each department head containing the hours to be
entered for an employee. In addition, the system should be
capable of supporting salaried employees rather than hourly
employees.
The personnel portion of this subsystem would be expected to
maintain information on evaluations, emergency contacts,
vacation time, personal time taken, vacation accrued, absences,
and comp time accrued. It will also provide support to the
police and fire department in keeping track of hours by type.
This subsystem would also be expected to print available
positions that have not been filled, but remain open, as well
as provide staffing breakdowns by title and department.
REPOr7ING REOUIREMENTS:
0 Employee Register
0 Hours worked by employees
• Changes in employee status
e payroll register
• Management payroll summaries
• Position control
• Bi-weekly payroll analysis
• Monthly payroll analysis
• Monthly retirement report
0 Monthly health insurance report
• Credit union report
0 Union dues report
0 Employee earnings record
0 Quarterly state monies report
• Deduction register, employee roster
• Emergency contact report
• Checks
• W-2's
1
MISCELLANEOUS DATA:
• ^'here are approximately 260 employees
• There are 20 hires and fires per month
• There are 260 checks issued bi-weekly
e The system will provide audit trails, transaction
listings, journal entry listing, check register
i
ACCOUNTS PAYABLE.
OBJECTIVES:
•
To
maintain a history of all payable by payee and age
accounts payable
•
To
maintain file on vendors
•
To
print checks
•
To
help determine cash requirements
•
To
record expenditures on an accrual basis
NAF.RATIVE DESCRIPTION:
This system may be a batch system. Data entry for this system
should be on-line and the data validated on-line. This system
should be able to combine invoices or vouchers (if a voucher
system is used) when making payments. In the event that
invoices or vouchers are combined a suitable transmittal is to
be prepared indicating the payments being made on the check.
In addition, free text messages are to be printed on the
check. This subsystem should have the ability to enter check
requisitions, manually written checks, credit or debit memos
and adjustments.
FTPOFTING PXOCIPXFFNTAS:
• Accounts payable register
• Vendor activity report
• Cash disbursement register
• Check register
• Reconciliation of checks
• Aging of accounts payables
MISCELLAA'EOUS DATA:
• The system will generate approximately 700 checks per
month
• Should have the ability to support a voucher system
• Automatic interface to general ledger
• Have an audit trail of all entries made, time and
date, person entering it and other detail in the
transaction.
9. �
• SCHEDULE "A"
Utility Billing System
City of Tamarac
REPORT, PROGRAM, FILE
Utility Master File Update Account Number changed. 3.00
Remove Sanitation Code 1.00
Dumpster Size
Dumpster Deposit
Dumpster Receipt
Penalty (Y/N)
# Pickups
A/R Master File Add Surcharge Column. 1.00
Remove Penalty Column.
Meter Readings Service Code to read file. 1.00
Service Report. 2.00
Service Notices. 3.00
Notes and Sewer Rate Add rate calculation to be used to calcu- 4.00
Calculations late water and sewer charge for Main
Utility.
Add rate calculation to be used to calcu-
late water and sewer charge for sub -utility. 4.00
Water & Sewer Update Screens for main 1.00
utility company.
Water & Sewer update screen for sub -utility 1.00
company.
Water & Sewer rate report for main utility 1.00
company.
Water & Sewer rate report for sub -utility 1.00
company.
Adjustment Codes Add new codes for adjustments. 1.00
Billing Register Report Format with new columns. 2.00
Utility Bills New format. 6.00
Closing Bills Change Account Number. 1.00
Change Status of new account to Inactive. .50
Refund Checks Change Print Format. 4.00
elinquent Notices Change format. 4.00
Collection Process Change Pending File. 2.00
Change Report. 1.50
Service Analysis Report Create Report. 6.00
M
SCHEDULE 'A'
MODIFICATION TIMES
THE FOLLOWING TIME WILL BE PROVIDED TO TAMARAC FOR MODIFICATION, AND
USER TRAINING.
1) PAYROLL SYSTEM 50 HOURS
2) FUND MANAGEMENT 118 HOURS
3) UTILITY BILLING 97 HOURS
i
Payroll/Personnel System
City of Tamarac
REPORT, PROGRI,M, FILE
Payroll Master File
Payroll Personnel File
Personnel Report
Payroll Summary File
Payroll Check Entry
Payroll Checks
Employee Timesheets
Monthly Social Security
Report (Tape)
Payroll Earnings Estimation
Report
General Ledger Interface
Manual Checks
End -of -Period Close -Out
Training
t
MODIFICATIONS REQUIRED
Add types for other earnings, add deductions
for Dental Insurance, United Way, Disability
Insurance, Cancer Insurance, and Fireman.
Add earnings type for sick leave without FICA
deduction. Add Accumulation for Personnel &
Holiday Pays.
Allow for entry of EEO Class, Race, Handicap,
Veteran, Position #, Position Title.
Print Information contained in Personnel File.
Add columns for earnings and deductions listed
in changes to Payroll Master File.
Allow for automatic entry of hours for each
employee. Allow for entry of new types of
earnings. Allow for new deductions.
Change format for use at the City of Tamarac.
Format Timesheets for use at City of Tamarac.
Set up report to print on tape to Social
Security Department.
Design report to print Estimated Payroll
report.
Adapt G/L interface to Tamarac accounts.
Change report to include new types earnings
and deductions.
Change program to close out new earnings and
deductions totals.
TIME
3.00
3.00
3.00
3.00
5.00
3.00
2.00
4.00
3.00
1.00
4.00
1.00
15.00
50.00
Utility Billing System Con't.
Books Pages
Interface to G/L
Training
Format Pages for use at Tamarac
Set accounts.
2.00
2.00
40.00
97.00
# I
Mi
4
SCHEDULE "B"
•.a- YYANTiT1/
O1 01
02
04
OS
R8750
O1 1 1933-36
12 5420
O1
O1
5331
5817
1
1N4T PYRCMAas PRICK I rmu PYRCF 6 PRICK
Reality System, Model 8750
Performance Enhanced Processor
MOS Memory Subsystem (256K)
Magnetic Tape Subsystem (45IPS/1600BPI)
Reflex Disc Subsystem (128.7MB)
Line Printer Subsystem (300LPM) & Stand
(2) Prism Terminals with Ports and
One (1) Open Port
Substitute Line Printer Subsystem (600L
for Line Printer Subsystem (300LPM)
Prism II Terminal and Open Port
- Includes Cable to Port
Line Printer (300LPM, parallel)
Printer Stand for 150, 3D0, or 600LPM
Printer
GROSS TOTAL SELLING PRICE
Less 10% Discount (except on tern
NET TOTAL SELLING PRICE
WOML AND DRSCRI►nON
$ 84,975.00 1$ 84,975.00
$ 4,700,00 1$ 4,700.00
S 1,900.00 S 22,800.00
$ llt200.00 $ 11,200.00
S 175.00 $ 175.00
$123,850.00
ils) 10,105.00
$113,745.00
Fund Management System
City of Tamarac
REPORT, PROGRAM, FILE
Account Number
Fund Title Update
Object Title Update
Budget Worksheet
Balance Sheet Report
Revenue & Expenditure Report
Purchase Orders
Purchase Order File
Vendor Master File
Purchase Order Entry
Purchase Order Changes
Purchase Order Closing
Print Purchase Orders
Purchase Order Reports
Invoice Entry
Manual Invoice
Accounts Payable Checks
Miscellaneous
Training
MODIFICATIONS REQUIRED TIME
Increase size of Fund Number, by 1 digit, 5.00
decrease Object Number to three digits.
Allow for three digit Fund Number. .50
Allow for three digit Object Number. .50
Add three columns to report as per Steve 2.00
Wood.
Report Format to be changed. 3.00
Report Format to be changed.
Add quantity, unit price, terms, ship via, 5.00
and shipping address as P/O file.
Add number of invoices, year-to-date, and 6.50
last year-to-date, invoices -to -date, gross
balance last year-to-date, and current
balance.
Add quantity, unit price, terms, ship via, 4.00
and shipping address to P.0 Entry.
Add on for changes to quantity, unit price, 4.00
terms, ship via, and shipping address.
Change program to allow for above additions 2.00
to P/O File.
Create printing process for Purchase Orders, 10.00
including forms design, and special program
to print Orders.
Allow for addition of quantity unit price, 4.00
terms, ship via, and shipping address.
Allow for entry of quantity, and unit price. 4.00
Allow for entry of quantity and unit price. 4.00
Allow for changing of format for A/P checks. 3.50
20.00
40.00
118.00
t' I
SCHEDULE 'C'
PAYMENTS AND TERMS
SYSTEM PRICE
1) PAYROLL $ 3,000.00
2) FUND MANAGEMENT $ 9,000.00
3) UTILITY BILLING $ 6,000.00
TOTAL PRICE =--------- $18,000.00
TERMS
PAYMENTS SHALL BE MADE TO MMS IN THREE INSTALLMENTS, WITH THE
FIRST PAYMENT DUE UPON CONTRACT SIGNING, THE SECOND PAYMENT DUE UPON
DELIVERY OF WRITTEN DOCUMENTATION TO TAMARAC AND SOFTWARE INSTALLED ON
A TEST BASIS AT THE MICRODATA COMPUTER CENTER IN MIAMI, AND THE FINAL
PAYMENT IS DUE UPON DELIVERY OF THE FINAL USER AND SYSTEM DOCUMENTATION
TO TAMARAC. EACH PAYMENT WILL EQUAL ONE THIRD OF THE TOTAL PURCHASE
PRICE.
i