Search

To:

From:

Re:

A. Motion:

Attachments:

Discussion:

City of Nashua, Public Works Division

Board of Public Works Meeting Date: August 23, 2018

Jon Ibarra Superintendent
Street Department

Purchase of one Johnson VT651 Vacuum Air Sweeper

To approve the purchase of one Johnson Vacuum Air Sweeper from Sanitary
Equipment Company Inc, Stoughton MA for a price of $274,100 pursuant to
HGAC Contract #8W04-18. Funding will be through Department: 161 Street;
Fund: Trust; Activity: CERF.

Sanitary Equipment Quote

The Street Department contacted several vendors to demonstrate sweepers for the
planned CERF replacement of street sweeper #48 in FY18. After road testing the
sweepers and talking with the operators, it was determined that a vacuum sweeper
would work best for our road condition and debris level.

Sanitary Equipment has offered a Johnson VT651 Vacuum Sweeper that comes
on a 2019 Freightliner Chassis. The sweeper comes fully equipped with warning
lights, an arrow board, and everything needed to go to work. The sweeper comes
with a 24 month 2000 hour warranty.

To be traded is old Sweeper #47 which a 2001 Johnson VT605 Sweeper with
67786 miles and 7382 hours on it. Repairs are frequent and parts availability is a
problem due to its age.

HGACBuy CONTRACT PRICING WORKSHEET Contract wing ig Date 4/16/2018
For Standard Equipment Purchases No.: Prepared:

Buying City of Nashua, New Hampshire Contractor: hnston North America

Contact Prepared
Person:

Phone: Phone: 704-658-1333

‘odd Parsons

Fax: Fax: 704-658-1377

Email: Email: todd.parsons@johnstonnorthamerica,com

PRanEy SW04-18 Description: i Johnston VT651 Vacuum Sweeper

Product Item Base Unit Price Per Contractor's H-GAC Contract:
Published Options - Itemize below - Attach additional sheet if necessary - Include Option Code in description if applicable
ote: Published Options are options which were submitted and priced in Contractor's bid.)
Description Cost Description

51-24 - 125HP JCB Aux. Engine 15800

51-36 - Gutter Broom Dual Tilt 4100

51-40 - Gutter Broom Lateral Control 2100

51-48 - Bonded Ducts Dual 2800
651-50 - Screen Vibrators 2000

51-52 - Hopper Flush Out 1500
651-18 - Supa-wash, Wash Down Syst. w/Spray Bars 9800

51-20 - Service Platform 725
651-32 - Gutter Broom Down Pressure

51-01 - Camera, Single 1 Subtotal From Additional Sheet(s):

VT651 - 2019 Freightliner M2 Chassis 95000 Subtotal B:

. Unpublished Options - Itemize below - Attach additional sheet if necessary
ote: Unpublished options are items which were not submitted and priced in Contractor's bid.)

Description Cost Description
68955 - Stainless Steel Engine Cowling 3700
186 - Arrow Stick 1600
153 - Work Lights Rear, (2) 775

Subtotal From Additional Sheet(s):
Subtotal C:

Check: Total cost of Unpublished Options (C) cannot exceed 25% of the total of the Base

Unit Price plus Published Options (A+B). For this transaction the percentage is:

Total Cost before any other Charges, Trade-Ins, Allowances, Discounts, Etc. (A+B+C)
Quantity Ordered: 1 X Subtotal of A+B+C: 297600 Subtotal D:
Other Charges, Trade-Ins, Allowances, Discounts, Etc.
Description Cost Description
rade-In Allowance -5000|Factory Freight
Customer Discount -22000 & Make-Ready
Delivery to Nashua
Subtotal E:

Delivery Date: 11/19/201 F. Total Purchase Price (D+E):

Company 0010 - CITY OF NASHUA

Requesting Location C-352 - STREET
DEPARTMENT

Requisition 50528 - Unreleased

23035 - SANITARY
EQUIPMENT CO ING

Requisition Description

Cost Default Vendor

Requester berubek - KATHIE BERUBE

Purchase From Deliver To
Buyer

PENDING APPROVAL BPW MEETING OF 8/23/18

QUOTE SW04-18 7/16/18 ATTACHED
item item Type Quantity UOM Unit Cost Extended Distributions Activity / Distribution Requested Sourcing

Ordered Cast Account Allocation Delivery Date Event
Category Required
JOHNSON Special 1.00 EA 274100.00 274100.00 TF18.7026-081500- CERF61.18 400.0% No
VT651 0000 81500
VACUUM AIR
SWEEPER
JOHNSON VT651 VACUUM AIR SWEEP
Vendor : SANITARY EQUIPMENT CO INC
JOHNSON VT651 VACUUM AIR SWEEPER
Totals: 1 Lines 1.00 274100.00
USD

Page: 1 Requisition: 60528 Status: Unreleased Printed: Aug 16, 2018 4:07:26 PM

DPW FLEET MAINTENANCE CITY OF NASHUA, NH ees

DATE: 07/16/2018 11:37 a.m.
VEHICLE REPAIR HISTORY REPORT

FACILITY: 00002

STARTING VMRS CODE: 000-000-000 DATE: FIRST VEHICLE: 047
ENDING VMRS CODE: 999-999-999 DATE: LAST VEHICLE: 047

LF MTR: 65841.0 CUR MTR: 65841.0 YR: 01 | MAKE: STERL DEPT: STREETS SIZE: M_ CLASS: SWEEPER FUEL: D

LF-MILS ODOM WORK DESCRIPTION PARTS LABOR sehr NS Ole So m= Cia ra Nes CC RC WA
002 TITLE > CAB/SHEET METALS
002-001-000 06132014 0004516 60260 60259 WIPER BLADES 50.02 12.49 62.51 0.50 JOEA 1 4 3
002-009-000 03312014 0004279 60180 60177 MIRROR 18.07 37.47 55.54 1.50 JOEA 1 4 3
002-014-000 07032014 0004582 60260 60259 LEFT DOOR 0.00 149.88 149.88 6.00 JOES 1 4 3
002-039-000 04222008 708903 49610 49606 SEAT CUSHION UPPER 71.28 0.00 71.28 0.00 02 8 #13
002-044-000 07032014 0004582 60260 60259 WINDOW REGULATOR 200.04 99.92 299.96 4.00 JOEA 1 4 3
002 TOTAL > CAB/SHEET METALS 339.41 299.76 639.17
013 TITLE > BRAKES
013-000-000 08062008 809106 48920 48920 BRAKES 205.16 139.92 345.08 6.00 TOMK 02 8 #13
013-057-000 09122017 0008363 65840 65841 AIR LINES AND FITT 75.75 81.24 156.99 3.00 DARYL 1 4 3
013 TOTAL > BRAKES 280.91 221.16 502.07
014 TITLE > FRAME
014-000-000 07072014 0004582 60260 60259 FRAME 0.00 1186.08 1186.08 48.00 CHRIS 14 4
014 TOTAL > FRAME 0.00 1186.08 1186.08
017 TITLE > TIRES
017-000-000 04142011 1112802 52970 52966 TIRES 815.99 43.90 859.89 2.00 RALPH 025 6
017-000-000 07252008 80974 48920 48920 TIRES 270.50 19.99 290.49 1.00 JOEA 02 8 #13
017-006-000 04232015 0005671 60650 60652 2 TIRES 0.00 34.55 34.55 1.50 Daryl 1 4 3
017 TOTAL > TIRES 1086.49 98.44 1184.93
026 TITLE > TRANSMISSION MANUAL
026-000-000 07072008 80911 48920 48920 TRANSMISSION MANUA 2649.17 279.84 2929.01 12.00 TED 02 8 #13
026 TOTAL > TRANSMISSION MANUAL 2649.17 279.84 2929.01
032 TITLE > CRANKING SYSTEM
032-000-000 07142008 80911 48860 48860 CRANKING SYSTEM 435.11 0.00 435.11 0.00 02 8 #13
032-001-000 10142016 0007381 62390 62388 BATTERIES 96.90 214.24 311.14 8.00 TOMK 1 4 3
032-002-000 05142013 0003304 58560 58560 STARTER 197.35 97.72 295.07 4.00 JOEA 1 4 «13
032-003-000 08062014 0004735 60270 60274 BATTERY CABLE 20.96 24.98 45.94 1.00 ED 1 4 3
032 TOTAL > CRANKING SYSTEM 750.32 336.94 1087.26
034 TITLE > LIGHTING SYSTEM
034-000-000 05142013 0003304 58560 58560 LIGHTING SYSTEM 0.00 73.29 73.29 3.00 JOEA 1 4 = «13
034-000-000 05092012 0121007 56810 56807 LIGHTING SYSTEM 10.76 24.43 35.19 1.00 ED 1 4 «18

1-32/RRV
DATE: 07/16/2018 11:37 a.m.

PAGE: 2

DPW FLEET MAINTENANCE CITY OF NASHUA, NH

VEHICLE REPAIR HISTORY REPORT
FACILITY: 00002

STARTING VMRS CODE: 000-000-000 DATE: FIRST VEHICLE:: 047

ENDING —VMRS CODE: 999-999-999 DATE: LAST VEHICLE: 047
UNIT: 047 LF MTR: 65841.0 CUR MTR: 65841.0 YR: 01 | MAKE: STERL DEPT: STREETS SIZE: M_ CLASS: SWEEPER FUEL: D

LF-MILS WORK DESCRIPTION OUT PARTS rely S HOURS MECHANIC Cc

034-001-000 09122017 0008363 65840 65841 HEADLAMP. 7.10 8.12 15.23 0.30 DARYL 1 4 3
034-001-000 04232015 0005671 60650 60652 HEADLAMP. 8.92 7.58 16.50 0.30 Rick 1 4 4
034-006-000 07032014 0004582 60260 60259 TURN SIGNAL SWITCH 0.00 74.94 74.94 3.00 JOEA 1 4 3
034-017-000 07162015 0005989 60950 60952 BRAKE LIGHTS 8.54 23.63 32.17 1.00 DARYL 1 4 3
034-018-000 09182013 0003552 59840 59840 BRAKE LIGHT SWITCH 13.08 24.98 38.06 1.00 JOES 1 4 3
034-018-000 06032013 0003337 59160 59164 BRAKE LIGHT SWITCH 13.08 7.46 20.54 0.30 DAVE 1 4 15
034-029-000 06232010 9101191 50910 50914 INTERIOR LIGHTS 9.23 23.32 32.55 1.00 TOMK 02 8 #13
034 TOTAL > LIGHTING SYSTEM 70.71 267.75 338.46
042 TITLE > COOLING SYSTEM
042-004-000 08152012 0002870 58560 58560 FAN BLADE 1271.75 12.07 1283.82 0.50 GUS 1 11 16
042-045-000 08152012 0002870 58560 58560 0.00 0.00 0.00 0.00 1 11 13
042 TOTAL > COOLING SYSTEM 1271.75 12.07 1283.82
046 TITLE > ELECTRIC PROPULSION
046-000-000 02292012 0012803 56190 56190 ELECTRIC PROPULSIO 173.90 24.13 198.03 1.00 TOMK 1 8 13
046 TOTAL > ELECTRIC PROPULSION 173.90 24.13 198.03
052 TITLE > ELECTRICAL ACCESSRES
052-000-000 05072018 0009151 65840 65841 ELECTRICAL ACCESSR 5.92 27.31 33.23 1.00 MIKE 14 4
052 TOTAL > ELECTRICAL ACCESSRES 5.92 27.31 33.23
053 TITLE > EXPENDABLE ITEMS
053-000-000 04132011 1112841 53050 53052 EXPENDABLE ITEMS 110.90 144.18 255.08 6.00 DAVE 1 $1 = «13
053 TOTAL > EXPENDABLE ITEMS 110.90 144.18 255.08
065 TITLE > HYDRAULIC
065-000-000 07152009 91038 48920 48920 HYDRAULIC 170.10 69.81 239.91 3.00 DAVE 02 8 #13
065 TOTAL > HYDRAULIC 170.10 69.81 239.91
066 TITLE > PREVENTIVE MAINT.
066-000-000 06032009 8091212 48920 48920 PREVENTIVE MAINT. 4584.55 466.40 5050.95 20.00 TED 02 8 #13
066-000-000 10012009 910302 48920 48920 PREVENTIVE MAINT. 614.26 0.00 614.26 0.00 XX 8 1
066-000-000 09282009 910283 48820 48824 PREVENTIVE MAINT. 85.00 0.00 85.00 0.00 XX 8 1
066-000-000 09252009 910291 48820 48824 PREVENTIVE MAINT. 300.78 0.00 300.78 6.00 JOEA XX 8 7
066-000-000 09212009 910185 48750 48752 PREVENTIVE MAINT. 841.95 0.00 841.95 0.00 XxX 8 6
066-001-000 07162015 0005989 60950 60952 PM AINSPECTION 10.00 47.26 57.26 2.00 DARYL 14 °5
066-001-000 05222015 0005819 60860 60861 PM AINSPECTION 10.00 70.98 80.98 3.00 Daryl 14 °5

DPW FLEET MAINTENANCE CITY OF NASHUA, NH ier ead

DATE: 07/16/2018 11:37 a.m.
VEHICLE REPAIR HISTORY REPORT

FACILITY: 00002

STARTING VMRS CODE: 000-000-000 DATE: FIRST VEHICLE:: 047

ENDING VMRS CODE: 999-999-999 DATE: LAST VEHICLE: 047
UNIT: 047 LF MTR: 65841.0 CUR MTR: 65841.0 YR: 01 | MAKE: STERL DEPT: STREETS SIZE: M_ CLASS: SWEEPER FUEL: D

LF-MILS WORK DESCRIPTION PARTS sehr NS HOURS MECHANIC Cc

066-002-000 06012016 0006971 62390 62388 PM B INSPECTION 164.54 144.06 308.60 6.00 DARYL 14 6
066-002-000 07032014 0004582 60260 60259 PM B INSPECTION 20.00 137.34 157.34 6.00 Rick 1 4 6
066-002-000 07242013 0003443 59480 59475 PM B INSPECTION 19.50 68.67 88.17 3.00 Rick 14°55
066-002-000 07172012 0121339 58490 58491 PM B INSPECTION 0.00 65.85 65.85 3.00 CHAD 1 8 13
066-002-000 07172012 0121339 58490 58491 PM B INSPECTION 0.00 43.90 43.90 2.00 RALPH 1 8 13
066-002-000 04242012 0012963 56810 56807 PM B INSPECTION 201.86 131.70 333.56 6.00 RALPH 1 8 7
066-002-000 04192011 1112833 53050 53052 PM B INSPECTION 196.52 131.70 328.22 6.00 RALPH 18 7
066-002-000 05112010 9101097 50200 50195 PM B INSPECTION 202.76 99.95 302.71 5.00 JOEA 026 7
066-002-000 08102007 708120 37270 37266 PM B INSPECTION 148.77 79.96 228.73 4.00 JOEA 02 8 #13
066-002-000 03202009 809926 45290 45288 PM B INSPECTION 187.70 119.94 307.64 6.00 JOEA 02 8 13
066 TOTAL > PREVENTIVE MAINT. 7588.19 1607.71 9195.90
093 TITLE > ENGINE (AUXILARY)
093-000-000 05192010 9101110 50200 50195 ENGINE (AUXILARY) 26.96 467.94 494.90 21.00 RALPH 02 1 «13
093-000-000 04132010 910914 49610 49606 ENGINE (AUXILARY) 11989. 11 699.60 12688.71 30.00 TED 02 1 «13
093 TOTAL > ENGINE (AUXILARY) 12016.07 1167.54 13183.61
106 TITLE > SWEEPER BODY
106-000-000 10292014 0005028 60410 60410 SWEEPER BODY 87.91 0.00 87.91 0.00 1 4 3
106-003-000 04082016 0006797 60950 60952 WATER PUMP 1098.50 321.36 1419.86 12.00 TOMK 1 4 3
106 TOTAL > SWEEPER BODY 1186.41 321.36 1507.77
107 TITLE > GUTTER BROOM
107-000-000 07032017 0008233 64930 64925 GUTTER BROOM 110.00 0.00 110.00 0.00 1 4 3
107-000-000 11022016 0007425 63070 63071 GUTTER BROOM 110.00 0.00 110.00 0.00 1 4 3
107-000-000 06222012 0121105 57980 57979 GUTTER BROOM 0.00 0.00 0.00 0.00 1 4 «13
107-000-000 05222012 0121035 57370 57367 GUTTER BROOM 79.00 0.00 79.00 0.00 1 4 #83
107-000-000 04172012 0012920 56530 56529 GUTTER BROOM 0.00 0.00 0.00 0.00 1 1 83
107-000-000 08242011 1112161 55650 55653 GUTTER BROOM 79.00 0.00 79.00 0.00 1 $1 = «13
107-000-000 06242011 0111013 54640 54643 GUTTER BROOM 85.00 0.00 85.00 0.00 1 4 «13
107-000-000 06072011 1112949 53470 53467 GUTTER BROOM 1116.45 486.16 1602.61 20.00 DAVE 1 $1 =«=13
107-000-000 05042011 1112875 53470 53467 GUTTER BROOM 85.00 0.00 85.00 0.00 1 8 13
107-000-000 09172010 1011217 52540 52537 GUTTER BROOM 371.67 0.00 371.67 0.00 02 8 #13
107-000-000 08062010 1011-90 51780 51784 GUTTER BROOM 85.00 0.00 85.00 0.00 02 4 «13
107-000-000 07012010 1011-3 51270 51272 GUTTER BROOM 85.00 0.00 85.00 0.00 02 1 = «13
107-000-000 06212010 9101214 50910 50914 GUTTER BROOM 286.67 0.00 286.67 0.00 02 8 #13
107-000-000 06102010 9101188 50710 50714 GUTTER BROOM 0.00 0.00 0.00 0.00 02 8 #13
107-000-000 05242010 9101133 50290 50290 GUTTER BROOM 85.00 0.00 85.00 0.00 02 8 #13

DPW FLEET MAINTENANCE CITY OF NASHUA, NH a eee

DATE: 07/16/2018 11:37 a.m.
VEHICLE REPAIR HISTORY REPORT

FACILITY: 00002

STARTING VMRS CODE: 000-000-000 DATE: FIRST VEHICLE:: 047

ENDING —VMRS CODE: 999-999-999 DATE: LAST VEHICLE: 047
UNIT: 047 LF MTR: 65841.0 CUR MTR: 65841.0 YR: 01 |_| MAKE: STERL DEPT: STREETS SIZE: M CLASS: SWEEPER FUEL: D

LF-MILS WORK DESCRIPTION PARTS TOTAL HOURS MECHANIC CC RC WA

107-000-000 04232010 9101042 49700 49695 GUTTER BROOM 508.16 0.00 508.16 0.00 02 4 «13
107-000-000 05202008 708989 49610 49606 GUTTER BROOM 85.00 0.00 85.00 0.00 02 8 13
107-000-000 05052008 708940 49610 49606 GUTTER BROOM 85.00 0.00 85.00 0.00 02 8 13
107-000-000 04162008 708889 49610 49606 GUTTER BROOM 85.00 0.00 85.00 0.00 02 8 13
107-000-000 04042008 708844 49610 49606 GUTTER BROOM 371.67 0.00 371.67 0.00 02 8 #13
107-000-000 10102007 708288 49610 49606 GUTTER BROOM 85.00 0.00 85.00 0.00 02 8 #13
107-000-000 08232007 708150 49610 49606 GUTTER BROOM 85.00 0.00 85.00 0.00 02 8 #13
107-000-000 06032008 7081015 49610 49606 GUTTER BROOM 85.00 0.00 85.00 0.00 02 8 #13
107-000-000 06012009 8091231 46950 46954 GUTTER BROOM 371.67 0.00 371.67 0.00 02 8 #13
107-000-000 04202009 8091004 45750 45751 GUTTER BROOM 371.67 0.00 371.67 0.00 02 8 #13
107-000-000 03172009 809907 45230 45230 GUTTER BROOM 85.00 0.00 85.00 0.00 02 8 #13
107-000-000 09262008 809311 44330 44325 GUTTER BROOM 85.00 0.00 85.00 0.00 02 8 #13
107-000-000 09222008 809299 48920 48920 GUTTER BROOM 7.14 0.00 7.14 0.00 02 8 13
107-000-000 08062008 809106 43120 43118 GUTTER BROOM 85.00 0.00 85.00 0.00 02 8 #13
107 TOTAL > GUTTER BROOM 4973.10 486.16 5459.26
108 TITLE > MAIN BROOM
108-000-000 06032013 0003337 59160 59164 MAIN BROOM 305.00 0.00 305.00 0.00 1 4 #13
108-000-000 06222012 0121105 57980 57979 MAIN BROOM 365.67 0.00 365.67 0.00 1 4 #13
108-000-000 04172012 0012920 56530 56529 MAIN BROOM 0.00 0.00 0.00 0.00 1 1 = «13
108-000-000 04172012 0012920 56530 56529 MAIN BROOM 1383.73 48.06 1431.79 2.00 DAVE 1 1 #13
108-000-000 08272010 1011175 52340 52337 MAIN BROOM 286.67 0.00 286.67 0.00 02 8 13
108-000-000 07232010 1010-24 51580 51583 MAIN BROOM 1435.69 587.25 2022.94 25.00 DAVE 02 1 = «13
108-000-000 06102010 9101188 50710 50714 MAIN BROOM 371.67 0.00 371.67 0.00 02 8 #13
108-000-000 04282010 9101065 49890 49888 MAIN BROOM 286.67 0.00 286.67 0.00 02 8 #13
108-000-000 05082008 708963 49610 49606 MAIN BROOM 286.67 0.00 286.67 0.00 02 8 #13
108-000-000 04292008 708929 49610 49606 MAIN BROOM 371.67 0.00 371.67 0.00 02 8 #13
108-000-000 10242007 708322 49610 49606 MAIN BROOM 286.67 0.00 286.67 0.00 02 8 13
108-000-000 08082007 708108 49610 49606 MAIN BROOM 286.67 0.00 286.67 0.00 02 8 13
108-000-000 05292008 7081005 49610 49606 MAIN BROOM 286.67 0.00 286.67 0.00 02 8 #13
108-000-000 05042009 8091004 46420 46421 MAIN BROOM 371.67 0.00 371.67 0.00 02 8 13
108-000-000 11052008 809430 44980 44979 MAIN BROOM 286.67 0.00 286.67 0.00 02 8 13
108-000-000 08262008 809195 43630 43631 MAIN BROOM 371.67 0.00 371.67 0.00 02 8 #13
108-000-000 07242008 80968 42830 42826 MAIN BROOM 1422.44 0.00 1422.44 0.00 02 8 #13
108 TOTAL > MAIN BROOM 8405.90 635.31 9041.21
113 TITLE > TOWING JOB

113-000-000 07112008 80911 48920 48920 TOWING JOB 300.00 0.00 300.00 0.00 02 8 20

1-32/RRV PAGE: 5
DATE: 07/16/2018 11:37 a.m.

DPW FLEET MAINTENANCE CITY OF NASHUA, NH

VEHICLE REPAIR HISTORY REPORT
FACILITY: 00002

DATE: FIRST
DATE: LAST

VEHICLE:: 047
VEHICLE: 047

STARTING VMRS CODE: 000-000-000
ENDING —VMRS CODE: 999-999-999

DEPT: STREETS
LABOR

SIZE: M_ CLASS: SWEEPER
TOTAL HOURS MECHANIC

FUEL: D
CC RC WA

CUR MTR: 65841.0
LF-MILS ODOM

YR: 01 | MAKE: STERL
WORK DESCRIPTION

UNIT: 047

LF MTR: 65841.0
OR SIE

PARTS

113 TOTAL > TOWING JOB 300.00 0.00 300.00

114 TITLE > AUTOMATED ARM

114-000-000 08312011 1112178 55650 55653 AUTOMATED ARM 216.46 0.00 216.46 0.00 1 1 13
114-000-000 09082010 1011192 52340 52337 AUTOMATED ARM 359.00 0.00 359.00 0.00 02 9 13
114-000-000 05272010 9101158 50290 50290 AUTOMATED ARM 32.75 93.08 125.83 4.00 DAVE 02 1° «13
114-000-000 08312007 708176 49610 49606 AUTOMATED ARM 176.55 0.00 176.55 0.00 02 8 #13
114 TOTAL > AUTOMATED ARM 784.76 93.08 877.84

117 TITLE > CHIPPER

117-000-000 06062008 7081027 49610 49606 CHIPPER 19.19 46.64 65.83 2.00 TED 02 8 13
117 TOTAL > CHIPPER 19.19 46.64 65.83

123 TITLE > STATE INSPECTION

123-000-000 09122017 0008363 65840 65841 STATE INSPECTION 0.00 81.24 81.24 3.00 DARYL 1 4 3
123-000-000 06012016 0006971 62390 62388 STATE INSPECTION 0.00 24.01 24.01 1.00 DARYL 1 4 10
123-000-000 07162015 0005989 60950 60952 STATE INSPECTION 0.00 47.26 47.26 2.00 DARYL 14°41
123-000-000 04232015 0005671 60650 60652 STATE INSPECTION 0.00 164.32 164.32 6.50 Rick 1 4 10
123-000-000 07032014 0004582 60260 60259 STATE INSPECTION 0.00 49.96 49.96 2.00 JOEA 14 °1
123-000-000 08152012 0002870 58560 58560 STATE INSPECTION 0.00 361.95 361.95 15.00 GUS 1 11 13
123-000-000 03192012 0012849 56190 56190 STATE INSPECTION 377.71 96.12 473.83 4.00 DAVE 1 5 6
123-000-000 08192011 1112140 55580 55577 STATE INSPECTION 9.90 96.12 106.02 4.00 DAVE 1 6 6
123-000-000 04142011 1112802 52970 52966 STATE INSPECTION 0.00 144.18 144.18 6.00 DAVE 02 5 6
123-000-000 04072010 708818 49610 49606 STATE INSPECTION 0.00 0.00 0.00 0.00 02 8 16
123-000-000 12282010 708818 52540 52537 STATE INSPECTION 73.58 94.60 168.18 4.00 DAVE 02 8 #13
123-000-000 09262007 708250 49610 49606 STATE INSPECTION 376.72 78.76 455.48 4.00 TOML 02 8 13
123-000-000 03172010 910854 49610 49606 STATE INSPECTION 0.00 23.32 23.32 1.00 TOMK 025 6
123-000-000 02032010 809907 48920 48920 STATE INSPECTION 143.62 69.96 213.58 3.00 REN 02 8 13
123-000-000 08272008 809215 43660 43662 STATE INSPECTION 0.00 93.28 93.28 4.00 TOMK 02 5 13
123 TOTAL > STATE INSPECTION 981.53 1425.08 2406.61

130 TITLE > KEK EKER EK EEE EERE ER

130-000-000 09052013 0003530 59840 59840 — 96.60 74.94 171.54 3.00 ED 1 4 3
130 TOTAL > O_o 96.60 74.94 171.54

142 TITLE > BELTS

142-119-000 07172012 0121339 58490 58491 ENGINE BELT 0.00 0.00 0.00 0.00 1 8 13
142-119-000 07172012 0121339 58490 58491 ENGINE BELT 267.08 43.90 310.98 2.00 CHAD 1 8 7

OPEB Expense and Deferred Outflows of Resources and Deferred (Inflows) of Resources
Related to OPEB

For the year ended June 30, 2021, the City recognized an OPEB expense of $4,694,079. At
June 30, 2021, the City reported deferred outflows and (inflows) of resources related to OPEB
from the following sources:

Deferred Deferred
Outflows of (Inflows) of
Resources Resources
Differences between expected and actual
experience $ 667,879 $ (5,639,344)
Changes of assumptions 5,496,932 -
Total $ 6,164,811 $ (5,639,344)

Amounts reported as deferred outflows and (inflows) of resources related to OPEB will be
recognized in OPEB expense as follows:

Fiscal Year Ended

2022 $ 20,399
2023 20,399
2024 20,400
2025 349,443
2026 349,444
Thereafter (234,618)
Total $ 525,467

Consolidation of Total/Net OPEB Liabilities and Related Deferred Outflows and (Inflows)
Below is a summary of all OPEB related items in the aggregate as of at June 30, 2021.
Details related to these items are presented separately for each plan on the previous pages.

Total Total
Total Deferred Deferred Total
OPEB Outflows of (Inflows) of OPEB
Liability Resources Resources Expense
City OPEB Plan $ 55,008,094 $ 6,164.81] §$ (5,639,344) $ 4,694,079
Proportionate share of
NHRS Medical Subsidy Plan 23,435,551 2,987,798 (223,423) 1,903,474
Total $ 78,443,645 $ 9,152,609 $ (5,862,767) $ 6,597,553

The City reports a net OPEB liability in governmental activities as these respective
employees are members of the NHRS, while Business-Type activities reports a total OPEB

o4

DPW FLEET MAINTENANCE CITY OF NASHUA, NH eae

DATE: 07/16/2018 11:37 a.m.
VEHICLE REPAIR HISTORY REPORT
FACILITY: 00002

STARTING VMRS CODE: 000-000-000

DATE: FIRST VEHICLE:: 047
ENDING VMRS CODE: 999-999-999 DATE: LAST VEHICLE: 047
UNIT: 047 LF MTR: 65841.0 CUR MTR: 65841.0 YR: 01 | MAKE: STERL DEPT: STREETS SIZE: M_ CLASS: SWEEPER FUEL: D
WO NUM LF-MILS ODOM WORK DESCRIPTION PARTS LABOR sehr S HOURS MECHANIC CC RC WA
142 TOTAL > BELTS 267.08 43.90 310.98
147 TITLE > VACTOR PARTS
147-004-000 05152017 0008103 63980 63975 REAR WATER PUMP 273.75 216.64 490.39 8.00 Rick 1 4 3
147 TOTAL > VACTOR PARTS

273.75 216.64 490.39