HomeMy WebLinkAboutDocumentation_Regular_Tab 09_08/10/2017 DATE: JULY 17,2017
TO: CHRISTOPHER QUIRK, FINANCE DIRECTOR
CC: TATIANA RACANATI,ASSISTANT FINANCE DIRECTOR
FROM: MICHELLE GLOAD,ACCOUNTING MANAGER
RE: AUGUST 2017 AGENDA ITEM INCREASING REVENUES AND
EXPENDITURES TO RECOGNIZE THE FAIR MARKET VALUE OF
SERVICES RECEIVED FROM PALM BEACH COUNTY FIRE RESCUE
The attached agenda item recognizes the fair market value of repairs and maintenance performed by
Palm Beach County Fire Rescue for the third quarter of fiscal year ending 9/30/2017 and requests the Village
Council to increase the General Fund#001 budget by that amount.
7/17/179:57 AM
RESOLUTION NO.34-17
A RESOLUTION OF THE VILLAGE COUNCIL OF THE VILLAGE OF
TEQUESTA, FLORIDA, INCREASING REVENUES AND
EXPENDITURES IN THE GENERAL FUND #001 2016/2017 BUDGET IN
THE AMOUNT OF $14,012.00 RECOGNIZING THE FAIR MARKET
VALUE OF SERVICES RECEIVED FROM PALM BEACH COUNTY
FIRE RESCUE AS WELL AS RECOGNIZING RELATED VEHICLE
REPAIR AND MAINTENANCE EXPENDITURES AND AUTHORIZING
THE VILLAGE MANAGER TO PROCEED IN ACCORDANCE WITH
THE VILLAGE'S ADOPTED PROCEDURES; PROVIDING FOR
SEVERABILITY; PROVIDING AN EFFECTIVE DATE; AND FOR
OTHER PURPOSES.
WHEREAS, this is the Fiscal Year Ending 09/30/17 third quarter adjustment; and,
WHEREAS, the Village currently has an emergency services agreement for mutual
assistance, automatic aid, dispatch and fire vehicle maintenance and repair services with Palm
Beach County; and,
WHEREAS, Palm Beach County maintained and repaired vehicles for the Village during
the third quarter of Fiscal Year 2017 with the services having a fair market value of$14,012.00;
and,
WHEREAS, the Village incurred expenditures for the repair and maintenance of these
vehicles in the amount of$14,012.00;
NOW,THEREFORE,BE IT RESOLVED BY THE VILLAGE COUNCIL OF THE
VILLAGE OF TEQUESTA, PALM BEACH COUNTY,FLORIDA,AS FOLLOWS:
Section 1 Resolution No. 34-17 is hereby approved increasing revenues and
expenditures in the General Fund #001 2016/2017 Budget in the amount of $14,012.00
recognizing the fair market value of services received from Palm Beach County as well as the
related expenditures incurred;
Section 2 This Resolution shall become effective immediately upon passage.
PALM BEACH COUNTY FIRE-RESCUE
VILLAGE OF TEQUESTA
VEHICLE MAINTENANCE ACTIVITY SUMMARY
FISCAL YEAR 2017
Fiscal Calendar Calendar Monthly Total Monthly Invoice
Month Month Year Charge for Service Garage Liability Charges* Amount
1 OCTOBER 2016 $1.85 $69.92 $71.77 $0.00
2 NOVEMBER 2016 $2,113.98 $69.92 $2,183.90 $0.00
3 DECEMBER 2016 $8,523.95 $69.92 $8,593.87 $0.00
4 JANUARY 2017 $4,308.47 $69.92 $4,378.39 $0.00
5 FEBRUARY 2017 $2,203.51 $69.92 $2,273.43 $0.00
6 MARCH 2O17 $257.16 $69.92 $327.08 $0.00
7 APRIL 2017 $3,071.93 $69.92 $3,141.85 $0.00
8 MAY 2017 $8,216.11 $69.92 $8,286.03 $0.00
9 JUNE 2017 $2,513.21 $69.92 $2,583.13 $0.00
10 JULY 2017 $0.00 $0.00 $0.00 $0.00
11 AUGUST 2017 $0.00 $0.00 $0.00 $0.00
12 SEPTEMBER 2017 $0.00 $0.00 $0.00 $0.00
FISCAL YEAR-TO-DATE TOTALS: $31,210.17 $629.28 $31,839.45 $0.00
*In accordance with Interlocal Agreement there shall be no charge for the first S70,000 of vehicle repair and maintenance
iWork Order Summary by Department
'�9f use"
Department to Be Charged: (TEQ) TEQUESTA
WO Closed Dates from 05/26/2017 to 06/30/2017 *
Internal Commercial
Work Order Labor Labor Misc Work Order
Status Work Order ID Asset Hours Cost Parts Labor Parts Markup Cost Total Cost
CLOSED CSHOP-2017-3102 T5319 0.00 0.00 57.02 0.00 0.00 0.00 0.00 57.02
CLOSED CSHOP-2017-3398 T2502 0.00 0.00 0.00 0.00 1,331.60 66.58 0.00 1,398.18
CLOSED CSHOP-2017-3537 T5319 1.07 98.78 0.00 0.00 0.00 0.00 0.00 98.78
CLOSED CSHOP-2017-3541 T2040 1.17 108.01 2.70 0.00 0.00 0.00 0.00 110.71
CLOSED CSHOP-2017-3600 T5319 1.77 163.41 33.27 0.00 0.00 0.00 0.00 196.68
CLOSED CSHOP-2017-3647 T2502 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
CLOSED CSHOP-2017-3692 T2502 1.38 127.40 0.00 0.00 0.00 0.00 0.00 127.40
CLOSED CSHOP-2017-3753 T5319 3.50 323.13 201.31 0.00 0.00 0.00 0.00 524.44
DEPARTMENT Totals: 8.89 820.73 294.30 0.00 1,331.60 66.58 0.00 2,513.21
69_ -
� IS3. i
1 3
*The report shows only closed work orders, with closed dates in the date range selected.It includes all transactions on the work order,regardless of insert date. Page 1 of 1
Report Date: 7/3/2017
it,,,A. s,
Work Order Detail- Charges��
Work Order: CSHOP-2017-3102
WO Status: CLOSED Asset: (T5319) FIRE DEPARTMENT PUMPER NFPA COMPLIANT Date In: 5/26/2017 8:19AM
Job Type: REPAIR Department: TEQUESTA Date Due: 5/26/2017 4:19PM
Repair Reason: 09 Account: 1300-440-4211-4620-01 Downtime Estimated Completion:
Work Class: 4 License: Shop Hours: 0.00 Date WO Opened: 5/26/2017 8:19AM
Warranty: NO Serial: 1S9A1HND5D1003124 User Hours: 0.00 Date First Labor:
Contact: Meter l: 17,585 Meter 2: 2,303 Date Finished: 5/31/2017 10:35AM
Date WO Closed: 5/31/2017 10:35AM
Work Order Summary
Internal Commercial
Equipment Usage
Labor Parts Overhead Labor Parts Misc Tax/Markup Charges
$0.00 $57.02 $0.00 $0.00 $0.00 $0.00 $0.00 $ 0.00
Total Work Order Costs: $57.02
Work Order Details
Parts
Transaction Date Task Part Qty Issued Total Cost
5-26-2017 (022-027) DEF FLUID (NAF-DEF002-0) Naf; Blue Def 2.5 Gal 6 $57.02
Page 1 of 1
Report Date: 7/3/2017
gEACy c
•
. OG2
clr . , Work Order Detail - Charges
."4f REO
Work Order: CSHOP-2017-3398
WO Status: CLOSED Asset: (T2502) ADVANCED LIFE SUPPORT VEHICLE Date In: 6/8/2017 12:37PM
Job Type: REPAIR Department: TEQUESTA Date Due: 6/8/2017 8:37PM
Repair Reason: 09 Account: 1300-440-4211-4620-01 Downtime Estimated Completion:
Work Class: 2 License: Shop Hours: 0.00 Date WO Opened: 6/8/2017 12:37PM
Warranty: NO Serial: AP7206 User Hours: 0.00 Date First Labor:
Contact: Meter 1: 56,541 Meter 2: 0 Date Finished: 6/8/2017 12:42PM
Date WO Closed: 6/8/2017 12:42PM
Work Order Summary
Internal Commercial Equipment Usage
Labor Parts Overhead Labor Parts Misc Tax/Markup Charges
$0.00 50.00 $0.00 $0.00 S1,331.60 $0.00 $66.58 $ 0.00
Total Work Order Costs: $1,398.18
Work Order Details
Commercial
Transaction Date Task Vendor Labor Cost Parts Cost Mist Cost Tax/Markup Total Cost
6-8-2017 12:00AM (017-006) REAR TIRES (TIRE0007) ELPEX TIRE TIRESOLES $0.00 $1,331.60 $0.00 $66.58 $1,398.18
Page 1 of 1
Report Date: 7/3/2017
�eEAca Co
g. et ? Work Order Detail - Charges
A.)9F HEStJ'''
Work Order: CSHOP-2017-3537
WO Status: CLOSED Asset: (T5319) FIRE DEPARTMENT PUMPER NFPA COMPLIANT Date In: 6/15/2017 8:54AM E
Job Type: REPAIR Department: TEQUESTA Date Due: 6/15/2017 4:54PM
Repair Reason: 09 Account: 1300-440-4211-4620-01 Downtime Estimated Completion:
Work Class: 4 License: Shop Hours: 0.00 Date WO Opened: 6/15/2017 8:54AM
Warranty: NO Serial: 1S9A1HND5D1003124 User Hours: 0.00 Date First Labor: 6/15/2017 8:56AM
Contact: Meter 1: 17,585 Meter 2: 2,303 Date Finished: 6/15/2017 10:01AM
Date WO Closed: 6/19/2017 12:25AM
Work Order Summary
Internal Commercial Equipment Usage
Labor Parts Overhead Labor Parts Misc Tax/Markup Charges
$98.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $ 0.00
Total Work Order Costs: $98.78
Work Order Details
Labor
Transaction Date Task Employee Labor Hours Labor Cost
6-15-2017 10:00AM (030) ELECTRICAL (16167) Vasko John A.Iii 1.07 $98.78
Page 1 of 1
Report Date:7/3/2017
�oACH CO
. ^ GZ
li .
a � < Work Order Detail - Charges
kE RESO'''
Work Order: CSHOP-2017-3541 I
WO Status: CLOSED Asset: (T2040) FIRE DEPARTMENT PUMPER NFPA COMPLIANT Date In: 6/15/2017 9:58AM
Job Type: REPAIR Department: TEQUESTA Date Due: 6/15/2017 5:58PM
Repair Reason: 09 Account: 1300-440-4211-4620-01 Downtime Estimated Completion:
Work Class: 4 License: Shop Hours: 0.00 Date WO Opened: 6/15/2017 9:58AM
Warranty: NO Serial: 1S9AHLD731003014 User Hours: 0.00 Date First Labor: 6/15/2017 10:00AM
Contact: Meter 1: 41,569 Meter 2: 6,130 Date Finished: 6/21/2017 11:58AM
Date WO Closed: 6/21/2017 3:33PM
Work Order Summary
Internal Commercial Equipment Usage
Labor Parts Overhead Labor Parts Misc Tax/Markup Charges
$108.01 $2.70 $0.00 $0.00 $0.00 $0.00 $0.00
$ 0.00
Total Work Order Costs: $110.71
Work Order Details
Labor
Transaction Date Task Employee Labor Hours Labor Cost
6-15-2017 11:10AM (030) ELECTRICAL (16167) Vasko John A.Iii
1.17 $108.01
Parts
Transaction Date Task Part
QtY Issued Total Cost
6-15-2017 (030) ELECTRICAL (NW-784623-0) Nw; Fuse Holder
$2.70
Page 1 of 1
Report Date: 7/3/2017
OEACH„
c �Gy
r ' < Work Order Detail - Charges
14t RESS#
Work Order: CSHOP-2017-3600
WO Status: CLOSED Asset: (T5319) FIRE DEPARTMENT PUMPER NFPA COMPLIANT Date In: 6/19/2017 12:25AM
Job Type: REPAIR Department: TEQUESTA Date Due: 6/19/2017 8:25AM
Repair Reason: 09 Account: 1300-440-4211-4620-01 Downtime Estimated Completion:
Work Class: 4 License: Shop Hours: 0.00 Date WO Opened: 6/19/2017 12:25AM
Warranty: NO Serial: 1S9A1HND5D1003124 User Hours: 0.00 Date First Labor: 6/22/2017 7:28AM
Contact: Meter 1: 17,585 h1eter 2,303 Date Finished: 6/29/2017 11:47AM
Date WO Closed: 6/29/2017 1:31PM
Work Order Summary
Internal Commercial Equipment Usage
Labor Parts Overhead Labor Parts Misc Tax/Markup Charges
$163.41 $33.27 $0.00 $0.00 <0.00 $0.00 $0.00 $ 0.00
Total Work Order Costs: $196.68
Work Order Details
Labor
Transaction Date Task Employee Labor Hours Labor Cost
6-22-2017 8:18AM (TRV) TRAVEL TO BE CHARGED TO WORK ORDER (16167) Vasko John A.Iii 0.83 $76.63
6-22-2017 10:19AM (030) ELECTRICAL (16167) Vasko John A.Iii 0.27 $24.93
6-29-2017 11:46AM (034) LIGHTING SYSTEM (16167) Vasko John A.Iii 0.35 $32.31
6-22-2017 10:03AM (034) LIGHTING SYSTEM (16167) Vasko John A.Iii 0.32 $29.54
Parts
Transaction Date Task Part Qty Issued Total Cost
6-29-2017 (030) ELECTRICAL (8HD-785007301649-0) 8Hd;Angle Plug 1 $13.83
6-26-2017 (034) LIGHTING SYSTEM (LIT-21251Y-0) Lit;Led M C Lamp 1 $9.72
6-26-2017 (034) LIGHTING SYSTEM (LIT-21251Y-0) Lit;Led M C Lamp 1 $9.72
Page 1 of 1
Report Date:7/3/2017
�WU/co
Gy Work Order Detail - Charges
, <
•'>'9E RESt.4:
Work Order: CSHOP-2017-3647
WO Status: CLOSED Asset: (T2502) ADVANCED LIFE SUPPORT VEHICLE Date In: 6/20/2017 1:13PM
Job Type: REPAIR Department: TEQUESTA Date Due: 6/20/2017 9:13PM
Repair Reason: 08 Account: 1300-440-4211-4620-01 Downtime Estimated Completion:
Work Class: 1 License: Shop Hours: 0.08 Date WO Opened: 6/20/2017 1:13PM
Warranty: NO Serial: AP7206 User Hours: 0.00 Date First Labor: 6/20/2017 12:00AM
Contact: Meter 1: 56,541 Meter 2: 0 Date Finished: 6/20/2017 1:18PM
Date WO Closed: 6/21/2017 3:31PM
Work Order Summary
Internal Commercial Equipment Usage
Labor Parts Overhead Labor Parts Misc Tax/Markup Charges
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$ 0.00
Total Work Order Costs: $0.00
Work Order Details
Labor
Transaction Date Task Employee Labor Hours Labor Cost
6-20-2017 1:15PM (QUA) QUALITY CHECK-REPAIRS (24401) Herklotz Karl L. 0.02 $1.85
6-20-2017 1:15PM (QUA) QUALITY CHECK-REPAIRS (24401) Herklotz Karl L.
Page 1 of 1
Report Date:7/3/2017
e.ACH
Work Order Detail- Charges
Ite 8E5t#
Work Order: CSHOP-2017-3692 I
WO Status: CLOSED Asset: (T2502) ADVANCED LIFE SUPPORT VEHICLE Date In: 6/22/2017 8:17AM
Job Type: REPAIR Department: TEQUESTA Date Due: 6/22/2017 4:17PM
Repair Reason: 09 Account: 1300-440-4211-4620-01 Downtime Estimated Completion:
Work Class: 4 License: Shop Hours: 0.00 Date WO Opened: 6/22/2017 8:17AM
Warranty: NO Serial: AP7206 User Hours: 0.00 Date First Labor: 6/22/2017 8:18AM
Contact: Meter 1: 56,541 Meter 2: 0 Date Finished: 6/22/2017 9:42AM
Date WO Closed: 6/22/2017 10:37AM
Work Order Summary
Internal Commercial Equipment Usage
Labor Parts Overhead Labor Parts Misc Tax/Markup Charges
$127.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $ 0.00
Total Work Order Costs: $127.40
Work Order Details
Labor
Transaction Date Task Employee Labor Hours Labor Cost
6-22-2017 9:05AM (TRV) TRAVEL TO BE CHARGED TO WORK ORDER (16167) Vasko John A.Iii 0.78 $72.01
6-22-2017 9:41AM (175-048) STRETCHER (16167) Vasko John A.Iii 0.60 $55.39
Page 1 of 1
Report Date:7/3/2017
�OEAcii c,
v G
a Work Order Detail - Charges
"?9E NEO
Work Order: CSHOP-2017-3753 I
WO Status: CLOSED Asset: (T5319) FIRE DEPARTMENT PUMPER NFPA COMPLIANT Date In: 6/26/2017 8:28AM
Job Type: REPAIR Department: TEQUESTA Date Due: 6/26/2017 4:28PM
Repair Reason: 09 Account: 1300-440-4211-4620-01 Downtime Estimated Completion:
Work Class: 4 License: Shop Hours: 0.00 Date WO Opened: 6/26/2017 8:28AM
Warranty: NO Serial: 1S9A1HND5D1003124 User Hours: 0.00 Date First Labor: 6/28/2017 8:56AM
Contact: Meter 1: 17,585 Meter 2: 2,303 Date Finished: 6/29/2017 11:24AM
Date WO Closed: 6/29/2017 1:33PM
Work Order Summary
Internal Commercial Equipment Usage
Labor Parts Overhead Labor Parts Misc Tax/Markup Charges
$323.13 $201.31 $0.00 $0.00 $0.00 $0.00 $0.00 5 0.00
Total Work Order Costs: $524.44
Work Order Details
Labor
Transaction Date Task Employee Labor Hours Labor Cost
6-28-2017 9:12AM (TRV) TRAVEL TO BE CHARGED TO WORK ORDER (16167) Vasko John A.Iii 0.27 $24.93
6-28-2017 10:29AM (TRV) TRAVEL TO BE CHARGED TO WORK ORDER (16167) Vasko John A.Iii 0.08 $7.39
6-29-2017 9:25AM (TRV) TRAVEL TO BE CHARGED TO WORK ORDER (16167) Vasko John A.Iii 1.18 $108.94
6-29-2017 11:23AM (004-009) SEAT FRONT (16167) Vasko John A.Iii 1.97 $181.87
Parts
Transaction Date Task Part
Qty Issued Total Cost
6-29-2017 (004-009) SEAT FRONT (5SC-H0B8902116-0) 5Sc;Sensor 2 $201.31
Page 1 of 1
Report Date: 7/3/2017
oAcii co
4.�� ' Work Order Detail - Charges
-'9E HESOJ�
Work Order: RADIO-2017-296 I
t
WO Status: CLOSED Asset: (RADIO-LOCUTION TEQ) LOCUTION SYSTEM Date In: 6/2/2017 11:35AM
Job Type: REPAIR Department: TEQUESTA Date Due: 6/3/2017 11:35AM
Repair Reason: 24 Account: 1300-440-4211-4620-01 Downtime Estimated Completion:
Work Class: 4 License: Shop Hours: 0.00 Date WO Opened: 6/2/2017 11:35AM
Warranty: NO Serial: NATEQ User Hours: 0.00 Date First Labor: 6/2/2017 12:00AM
Contact: Meter 1: 0 Meter 2: 0 Date Finished: 6/2/2017 12:44PM
Date WO Closed: 6/2/2017 12:44PM
Work Order Summary
Internal Commercial Equipment Usage
Labor Parts Overhead Labor Parts Misc Tax/Markup Charges
$184.64 $0.00 $0.00 $0.00 $0.00 S0.00 $0.00 $ 0.00
Total Work Order Costs: $184.64 I
Work Order Details
Labor
Transaction Date Task Employee Labor Hours Labor Cost
6-2-2017 12:00AM (310-004) LOCUTION BAD (4594) Goad Michael S. 1.00 $92.32
6-2-2017 12:00AM (TRV) TRAVEL TO BE CHARGED TO WORK ORDER (4594) Goad Michael S. 1.00 $92.32
Page 1 of 1
Report Date: 7/3/2017