HomeMy WebLinkAbout1835 RESOLUTION NO. 1835
A RESOLUTION creating a Central Data Processing
rate structure.
WHEREAS, the City's Central Data Processing Fund (502) exists
to recover cost for the Computer Processing and to provide informatlon for the
continuing cost justification for the City's computer installation.
WHEREAS for the recovery cost to the Data ProceSsing Department,
Attachment A breaks do~ in detail the rate structure for 1980.
WHEREAS this rate structure is based on Burrough's Time
Analysis and Billing System (TABS) for B1800/B1700 of March 1979. This system is
now installed on our B-1835. The structure consists of variable rates to each user
based on the actual cost of the computer, its peripheral equipment, labor, and
supplies as budgeted for the Data Processing Department. The rates may go up and
down based on actual usage, except for users presently with contracts with fixed
rates, and these contracts, if found not recovering our cost, will be renegotiated
for 1981.
PASSED AND APPROVED by the City Commissioners of the City of
Bremerton, signed by the Mayor and attested to by the City Clerk in authentication
of such passage this 11th day of December, 1979.
GLENN K. JARSTAD, MAYOR
ATTEST:
KATHLEEN L. MANDIO, CITY CLERK
CENTRAL DATA PROCESSING
MONTHLY RATE STRUCTURE FOR 198~
I. Machine Costs
A. Central Processing Unit Fixed Charges
1. ELAP = Elapsed Time Charge = $ 954.51
2. MEM = Memory Charge = 773.60
3. PROC = Processor Time Charge = 954.51
Per Month $2,682.62
B. Central Processing_Unit ChaK&e~ Justif~cat~on
1. MEM:
a. Lease for 524KB Memory $ 397.28
b. Maintenance for 524KB Memory 376.32
Per Month $ 773.60
2. ELAP and PROC:
a. Lease for B-1835 (Less Memory) $ 910.11
b. Maintenance for B-1835 (Less Memory) 181.92
c. Maintenance for Burster 22.92
d. TCSII Software 600.00
eo TABS Software 50.00
f. Undistributed Cost 144.06
Per Month $1,909.02
Divided By 2 954.51
3. Definitions of MEM, ELAP, PROC Charge Formulas.
a. MEM Charge Unit =
(((CPU Time in Seconds) X (Total Memory)) ~ 10000) + (Data Overlays).
b. ELAP Time Charge Unit = Elapsed t~me in tenths of seconds from
beginning of job (BOJ) to end of job (EOJ).
c. PROC Time Charge Unit = Processor time In tenths of seconds.
II. Hardware Costs
A. Disk Pack Fixed C._ha~rrge. $1,422.66 a month. Unit charge = physical i/o,
each block read and written
B. Disk Pack Charge Justification.
1. Lease for Disk Pack and Controller $ 652.74
2. Lease for Dnal Density 300.00
3. Maintenance for Disk Pack 404.40
4. Maintenance for Disk Pack Controller 65.52
Per Month $1,422.66
C. Mini-Disk E~!ij~ment Fixed Charge. Per Month $ 243.53
Unit charge = Logical i/o, each record read and written.
D. Mini-Disk Equipment Charge Justification.
1. Lease for Mini-Disk Drive and Controller $ 115.25
2. Maintenance for Mini-Disk Drive 26.52
3. Maintenance for Mini-Disk Controller 14.76
4. Maintenance for iBM 3741-1 Min~-Disk Audit Entry Device 43.50
5. Maintenance for IBM 3741-1 Mini-D~sk Andit Entry Device 43.50
Per Month $ 243.53
E. Line Printer Fixed Cba~r~g_e~._ Per Month $ 662.56
Unit charge = Logical i/o, each l~ne printed.
F. Line Printer Charge Justification.
1. Lease for 400LPM Chain Printer and Controller $ 396.32
2. Maintenance for 400LPM Chain Printer 240.00
3. Maintenance for Printer Controller 26.24
Per Month $ 662.56
G. Tape Drives Fixed C!~_a_rge. Per Month $ 425.83
Unit charge = Logical i/o, each record read and written.
H. .Tape Drives_C_h_ar~
1. Lease for both Tape Drives and Controller $ 293.83
2. Maintenance for Tape Controller 53.52
3. Maintenance for Tape Drive A 39.24
4. Maintenance for Tape Drive B 39.24
$ 425.83
I. Remote Fixed Charge. Per Month $ 812.80
Unit charge = Control time, time a device is controller by a user
and thus unavailable to the other users.
J. Re~mote Charge Justification.
1. Lease for six TD-832's (CRT's) $ 300.00
2. Lease for B]056 Expansion Cabinet ($233.94)
3. Lease for 4-line multi-line control ($]03.85)
4. Lease for Direct Connect ($32.09)
5. True lease for 2, 3, and 4 above 177.06
6. Maintenace for six TD-832's (CRT's) 212.50
7. Maintenance for 4-line multi-line control 37.80
8. Maintenance for Direct Connect 22.44
9. Maintenance for B1056 Expansion Cabinet 63.00
Per Month $ 812.80
III. Special Cost
A. Overhead Charge. Per Month $4,833.34
~,is overhead is distributed to all users based on percentage of
overall usage during a given n~onth.
B. Overhead Charge Justification.
1. Staff Programmer/Salary $13,992.00
2. Two Keypunch Ill Salaries 24,743.00
3. Employee Benefits-25% 9,684.00
4. Total Supplies 6,000.00
5. Transportation 2,000.00
6. Training 1,250.00
7. CRT Cables 331.00
Per Year $58,000.00
Per Month 4,833.23
IV. Da. ta Pr~c~s_s_~ng Contracts.
A. Contracts With Variable Rates.
In the future all contracts will be based on actual cost. Actual cost
as determined by the Time Analysis and Billing System (Burrough's TABS
B1800/B1700 Reference Manual of March 1979). TABS also determines the
actual cost and bills our own City Departments. Example, if TA~S
determines $300.00 should be billed for a given month, then $300.00 is
billed. If a month later TABS determines only $275.00 should be billed,
then $275.00 ~s billed.
B. Contracts With Fixed Rates.
In the past the City negotiated F~xed Billing Amounts such as with the
Public Utility D~strict One, Port Orchard Police Department, and Kitsap
County Health Department. These fixed amounts will reduce the overhead
charge (see Ill.A) to all otber users. These Pre-1980 contracts will be
closely watched during 1980, and if it ~s found that the Central Data
Processing Department is not recovering its cost, then new contracts will
be executed for 1981.
V. SpeCial In-House Labor Charge.
Analyzing, Programming, Testing, Documenting, or Implementing of a program (s)
by the Data Processing Manager or Staff Programmer, for a User, that User will
be charged $5.00 per fifteen minutes with fractions rounded up to the next
fifteen minute increment. Example, the Data Processing Manager programs for
fifty minutes for a user, that user will be charges $20.00 for one hour.
Justification: To recover the cost of the Data Processing Manager's salary
and benefits.
A. Salary $20,000
B. Benefits-20% Per Year 4~0~0
$24,000
The DPM's salary and benefits should not be added to overhead (see III).
Time spent programming for example, especially for a user who monopolizes
time available for programming in-house should pay for it, not all the users
who may receive little or no programming dnrtng a given month.
VI. Over-t~me and Com~-time Char~e~.
Any user requiring over-time or comp-t~me of any Central Data Processing
employee, will be charged for it.
Justification: Due to the fact that no over-t~me or comp-tfme has been
budgeted for in the Central Data Processing Fnnd, th~s additional cost must
be covered.
VII. .~tor~a~ Cost and Back-UE Tapes__.
For the sake of simplicity, storage and back-up tapes should be fixed to the
cost of buying the tape. For example, ~f the Equipment Rental System
required back-up and storage tapes, ]et's say ten (10) were required, then a
one time charge of $100.00 woul~ be assessed if the current purchase cost per
tape was $10.00.
Justification: Small tape users should not have to pay high overhead cost due
to large tape users.
Any tapes purchased and charged during a given month, that amount charged will
be reduced from overhead (see III.A) for that month to all users.
NOTE: Storage tapes are stored in-house. Back-up tapes are temporarily
stored off-site in a bank vault or on-site in our present fire-proof safe.
Any other special provisions may require further charges, as deemed necessary
by the Data Processing Manager.
VIII. ~pJ_~jal ~u~plies
Anytime special s~pp]ies are ordered for a user, that user w~ll be charged
for the cost of the supplies.
This cost will be reduced from overhead (see Ill.A) for that month to all