05/17/2022 - PacketPort Orchard
Council Finance Committee
May 17, 2022
5:00 pm
Join Zoom Meeting
hftps://us02web.zoom.us/m/82620826143
Webinar ID: 826 2082 6143
+12532158782„ 82620826143# US (Tacoma)
1) Finance Report
a. Sales Tax Revenue Report
b. Fund Balances
c. Monthly Budget Report
2) IT Projects -Server replacement
Finance Director, Noah Crocker
Network Administrator, Steve Havert
3) Personnel Mayor, Rob Putaansuu
a. Hiring Incentive Lateral Officer
b. Parking Enforcement
Other Items to come before the Committee.
Schedule Next Meeting Date
Role of the Finance Committee
The finance committee provides oversight of city budgeting, financial planning, and financial reporting. The committee recommends long-range
financial goals along with funding strategies for the operating and capital budgets. Human resource issues requiring policy direction are brought
before the committee. The committee serves as the advisory forum for transportation and street maintenance funding, and funding relating to the
transportation benefit district.
Sales Tax Collections
Population
Summary of Budget to
Actuals
21Biennial
Budget
Actual
6,735,000k:2022�
5,340,000
12,075,000
6,801,337 2,242,486
9,043,823
Over/Under
$ 66,337 $
(3,097,514)
$ (3,031,177)
Actuals
2022
Biennial
January
February
March
April
May
June
July
August
September
October
November
December
$ 502,448 $
625,058
481,233
456,673
603,566
590,896
605,455
621,368
603,523
$ 572,116
598,570
540,431
543,145
626,678
524,545
548,118
$ 1,045,593
$ 1,251,736
$ 1,005,778
$ 1,004,791
$ 603,566
$ 590,896
$ 605,455
$ 621,368
$ 603,523
$ 572,116
$ 598,570
$ 540,431
Total
$ 6,801,337 $
2,242,486
$ 9,043,823
Percentage of Biennial
Budget Received
75%
Actuals
Year over Year
%
Change
Change
$ 40,697
8.10%
$ 1,621
0.26%
$ 43,311
9.00%
$ 91,445
20.02%
$ 177,074
Real Estate Excise Tax (REET) Collections
Summary of Budget to
Actuals
2021sm
Biennial
Budget
Actual
$ 1,550,000 $
2,049,121
700,000
579,319
$ 2,250,000
2,628,439
Over/Under
$ 499,121 1 $
(120,681)l
$ 378,439
132% 83%
Actuals
2021
2022
Biennial
January
February
March
April
May
June
July
August
September
October
November
December
$
$
$
$
$
$
$
$
$
$
$
$
73,375 $
220,864
167,145
178,846
112,705
144,431
505,628
141,915
221,545
89,233
96,061
97,373
82,213
166,226
204,469
126,410
$ 155,589
$ 387,090
$ 371,615
$ 305,255
$ 112,705
$ 144,431
$ 505,628
$ 141,915
$ 221,545
$ 89,233
$ 96,061
$ 97,373
Total
$
2,049,121 $
579,319
$ 2,628,439
Percentage of Biennial
Budget Received
117%
Actuals
Year over Year
%
Change
Change
$ 8,838
12.05%
$ (54,637)
-24.74%
$ 37,324
22.33%
$ (52,436)
-29.32%
$ (60,911)
-9.51 %
Budget
2022 estimated
Budget vs Actual
%
based on 5yr avg
(Over/Under)
Over/Under
$ 406,968
$ 136,177
33.5%
$ 502,112
$ 124,566
24.8%
$ 373,269
$ 151,276
40.5%
$ 354,303
$ 193,815
54.7%
$ 437,214
#VALUE!
$ 426,421
#VALUE!
$ 475,696
#VALUE!
$ 496,582
#VALUE!
$ 471,982
#VALUE!
$ 469,230
#VALUE!
$ 483,873
#VALUE!
$ 442,349
#VALUE!
$ 5,340,000
$ 605,834
37.02%
Budget
2022 estimated
Budget vs Actual
%
based on 5yr avg
(Over/Under)
Over/Under
$ 31,470
$ 50,743
161.2%
$ 46,256
$ 119,970
259.4%
$ 73,672
$ 130,797
177.5%
$ 51,067
$ 75,343
147.5%
$ 44,319
#VALUE!
$ 56,273
#VALUE!
$ 96,186
#VALUE!
$ 55,941
#VALUE!
$ 71,062
#VALUE!
$ 58,905
#VALUE!
$ 42,640
#VALUE!
$ 72,210
#VALUE!
$ 700,000
$ 376,853
186%
Detail Report
Fund
Beginning Balance
Total Activity
Ending Balance
001 - Current Expense
11,012,059.63
1,111,997.16
12,124,056.79
002 - City Street Fund
2,449,601.95
291,061.11
2,740,663.06
003 - Stabilization Fund
2,697,042.28
893.70
2,697,935.98
103 - Criminal Justice
631,269.30
31,603.80
662,873.10
104 - Special Investigative Unit
97,047.15
33.68
97,080.83
107 - Community Events
295,811.74
4,490.08
300,301.82
108 - Paths & Trails
12,608.80
90.91
12,699.71
109 - Real Estate Excise Tax
5,679,904.54
-83,693.20
5,596,211.34
111 - Impact Mitigation Fee
4,026,514.31
126,182.84
4,152,697.15
206 - Bond Redemption Fund
0.00
0.00
0.00
302 - Capital Construction
218,326.86
-204.98
218,121.88
304 - Street Capital Projects
750,989.33
970,537.75
1,721,527.08
401- Water -Sewer Utilities
0.00
0.00
0.00
403 - Water -Sewer Cumulative Reserve
0.00
0.00
0.00
411 - Water Operating
3,826,332.46
-9,752.66
3,816,579.80
412 -Water Stabilization
729,907.02
24,805.31
754,712.33
413 - Water Capital
6,842,344.93
-26,764.85
6,815,580.08
414 - Water Debt Service
0.00
0.00
0.00
421 - Storm Drainage Utility
2,240,849.63
29,059.74
2,269,909.37
422 - Storm Drainage Stabilization
391,213.11
16,030.44
407,243.55
423 - Storm Drainage Capital Facil
94,047.53
31.32
94,078.85
424 - Storm Drainage Debt Service
0.00
0.00
0.00
431 - Sewer Operating
4,437,780.47
197,140.50
4,634,920.97
432 - Sewer Stabilization
1,096,715.23
36,637.58
1,133,352.81
433 - Sewer Capital
4,215,682.71
-16,174.04
4,199,508.67
434 - Sewer Debt Service
275,097.51
91.58
275,189.09
500 - Equipment Rental and Revolving
3,519,518.97
28,201.06
3,547,720.03
631 - Trust and Agency
9,719.00
299.87
10,018.87
632 - Wastewater Treatment Facil Fee
4,490,161.87
50,855.60
4,541,017.47
Grand Total:
60,040,546.33
2,783,454.30
62,824,000.63
5/16/2022 8:40:36 AM
Date Range: 04/01/2022 - 04/30/2022
Fund Summary
Page 5 of 5
Server Replacement Proposal
IT Projects -Server replacement
Key Points
• Existing Dell servers are six years old; expected life span is seven years
• City has maxed out our disk storage; temporary measures are in place
• Our data storage device, a Dell PowerVault MD3420, is not compatible with the latest version of
VMWare, our server virtualization software
• New technologies are available that better leverage hardware investment
Nutanix Virtual Environment
• Used by many other cities and counties in WA state
o Seattle
o Tacoma
o Spokane
o Redmond
o Pierce County
• Will consist of three nodes which will provide full redundancy and automatic failover
• Represents a significant increase in compute resources
o CPU — 125% increase
o Memory (RAM) — 88% increase
o Storage - 50% increase
Cost
Server Replacement Proposal
Item
Cost
NX1175S-G8 Node
$12,875.85
DDR$ 64 GB DIMM
$4,992.00
6TB 3.5" hard drive
$1,320.00
1.92 TB SS drive
$2,508.00
10 Gigabit SFP Expansion Module
$1,767.00
60OW Power Supply
$1,272.00
Power Cables
$90.00
Network Switch and cables
$24,840.00
Total Hardware
$49,664.85
Support Option 1 - 5 year
Software License and Support (5 year) $54,288.00
Hardware Support (5 year) $2,802.96
Total Software & Support $57,090.96
Support Option 2 - 3 year
Software License and Support (5 year) $37,093.92
Hardware Support (5 year) $1,800.00
Total Software & Support $38,893.92
Implementation & Training Services $11,860.00
Total $157,509.73