Loading...
HomeMy WebLinkAboutDocumentation_Regular_Tab 07_08/09/2018 �������� DATE: JULY 13,2018 TO: CHRISTOPHER QUIRK,FINANCE DIRECTOR CC: TATIANA RACANATI,ASSISTANT FINANCE DIRECTOR FROM: MICHELLE GLOAD,ACCOUNTING MANAGER RE: AUGUST 2018 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/2018 and requests the Village Council to increase the General Fund#001 budget by that amount. 7/13/1811:44 AM RESOLUTION NO. 28-18 A RESOLUTION OF THE VILLAGE COUNCIL OF THE VILLAGE OF TEQUESTA, FLORIDA, INCREASING REVENUES AND EXPENDITURES IN THE GENERAL FUND #001 2017/2018 BUDGET IN THE AMOUNT OF $26,739.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 third quarter adjustment for Fiscal Year Ending 09/30/18; 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 2018 with the services having a fair market value of$26,739.00; and, WHEREAS, the Village incurred expenditures for the repair and maintenance of these vehicles in the amount of$26,739.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. 28-18 is hereby approved increasing revenues and expenditures in the General Fund #001 2017/2018 Budget in the amount of $26,739.00.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 2018 Fiscal Calendar Calendar Monthly Total Monthly Invoice Month Month Year Charge for Service Garage Liability Charges* Amount 1 OCTOBER 2017 $1,404.41 $69.92 $1,474.33 $0.00 2 NOVEMBER 2017 $1,250.78 $69.92 $1,320.70 $0.00 3 DECEMBER 2017 $3,415.31 $69.92 $3,485.23 $0.00 4 1ANUARY 2018 $449.65 $69.92 $519.57 $0.00 5 FEBRUARY 2018 $6,340.41 $69.92 $6,410.33 $0.00 6 MARCH 2O18 $27,896.28 $69.92 $27,966.20 $0.00 7 APRIL 2018 $10,355.17 $69.92 $10,425.09 $0.00 8 MAY 2018 $14,128.44 $69.92 $14,198.36 $0.00 9 JUNE 2018 $2,045.12 $69.92 $2,115.04 $0.00 so JULY 2o1s So.00 $o.00 $o.00 $o.00 11 AUGUST 2018 $0.00 $0.00 $0.00 $0.00 12 SEPTEMBER 2018 $0.00 $0.00 $0.00 $0.00 FISCAL YEAR-TO-DATE TOTALS: $67,285.57 $629.28 $67,914.85 $0.00 *In accordance with Interlocal Aereement there shall be no char¢e for the first 570.000 of vehicle reaair and maintenance OEPCH� ,F.�-- o� y �����;� Work Order Summary by Department 9F AE9� Department to Be Charged:(TEQ) TEQUESTA WO Closed Dates from 6-2018 to 6-2018* � � _..r���„ ,,---_ ._ D: __ . __ .=�ae��tal' _ _ __I Work Order Labor labor I Misc Work Order Status Work OrderID Asset Hours Cost Parts Wbor Parts Markup Cost Total Cost CLOSED CSHOP-2018-1669 710280 0.00 0.00 0.00 0.00 0.00 D.00 0.00 0.00 CL05ED CSHOP-2018-2030 T2040 5.29 542.12 26.61 0.00 0.00 0.00 0.00 568.73 CLOSED CSHOP-2018-2032 T1028U 2.81 287.97 133.61 i 0.00 0.00 0.00' 0.00 421.58 CLOSED CSHOP-2018-2488 T5319 1.12 114.78 45.42 0.00 0.�0 0.00 0.00 160.20 CLOSED CSHOP-2018-2811 T10222 1.91 195.73 101,49 � 0.00 0.00 O.DO 0.00 2g7,2z CLOSED CSHOP-20183020 T5319 2.20 225.45 100.64 ' 0.00 0.00 0.00 0.00 326.09 CLOSED CSHOP-2018-3022 T10221 0.03 3.07 0.00 � 0.00 0.00 0.00 0.00 3.07 CLOSED CSHOP-2018-3267 T5319 0.47 48.17 40.70 0.00 0.00 0.00 0.00 gg,87 CLOSED CSHOP-2018-3330 T10221 0.00 0.00 0.00 � 66.43 28.27 4.73� 0.00 gg,43 CLOSED CSHOP-2018-955 T5319 0.78 79.93 0.00 j 0.00 0.00 0.00' 0.00 79.93 DEPARTMENT Totals: 14.61 1,497.22 448.47 I 66.43 28.27 4.73; 0.00 2,045.12 � ��R7- .�---' � a 1c � a�c t . ..�-- �- *The reportshows only dased xrork orders,w/th dvsed dates in the date range se%ted.It/nc/udes all transact/ons on the work order,regard/ess of Msert date. Page 1 of 1 Report Date:7/2/2018 BFPCH _ - I ��.+_,r;OG� . ,���: Work Order Detai/- Charges , �; 1��rr �F RES�J� h46rAC;:•,.0!IN IRr• Work Order: CSHOP-2018-1869 ��v ie�.� , i�; w0 Status: CLOSED Asset: (T10280) ADVANCED LIFE SUPPORT VEHICLE Date In: 4/3/2018 I1:52AM )ob Type: PM Departrnent: TEQUESTA Date Due: 4/3/2018 7:52PM Repair Reason: O8 Account: 1300-440-4211-4620-01 i Downtime Estimated Completion: Work Class: 1 License: ' Shop Hours: 0.00 Date WO Opened: 4/3/2018 11:52AM Warranty: NO Serial: IFVACWCT95HV19081 User Hours: 0.00 Date Flrst Labor: 4/3/2018 12:OOAM Contad: Meter 1: 48,192 Meter 2: 6,220 Date Finished: 6/28/2018 2:48PM j Date WO Closed: 6/28/2018 2:48PM Work Order Summary Internal Commerdaf - ------ ` - -.--- --_ -�Equipment Usage Labor Parts Overhead ' Labor Parts Misc Tax/Markup � Charges $0.00 $0.00 �0.00 j $0.00 �0.00 $0.00 ' $0.00 i $0.00 Total Work Order Costs: $0.00 Work Order Deqils Labor Transacction Date Task Employee Labor Hours Labor Cost 4-3-2018 1:D6PM (C-RESCUE) PM SERVICE C RESCUE (11317) Byrum Jeffrey].(7.J.) 0.50 $51.24 4-10-2018 5:17PM (C-RESCUE) PM SERVICE C RESCUE (11317) Byrum]effrey].(JJ.) p,q� $48.17 4-10-2018 5:17PM (C-RESCUE� PM SERVICE C RESCUE (11317) Byrum]effrey).(J.J.) (0.9� (g48.17) 4-3-2018 1:06PM (C-RESCUE) PM SERVICE C RESCUE (11317) Byn�m Jeffrey).(JJ.) (0.50) (�51.29} Page 1 of 1 Report Date:7/2/2018 OEACH �� COG� .�, . INork Order Detai/- Charges ��9F RES��� Work Order: CSHOP-2018-2030 WO Sqtus: CLOSED Psset: (T2040) FIRE DEPARTMENT PUMPER NFPA COMPLIANT Date In: 4/11/2018 3:36PM ]ob Type: REPAIR Departmen[: TEQUE57A Date Due: 4/17./2018 11:36PM Repair Reason: 09 Account: 1300-440-4211-4620-01 I Downtlme Estimated Compietion: Work Class: 4 License: Shop Hours: 0.00 Date WO Opened: 4/11/2018 3:36PM Warranty: NO Serial: iS9AHLD731003014 ( User Hours: 0.00 Date Flrst Labor: 4/12/2018 7:11AM Contad: Meter 1: 42,773 Mecer 2: 6,288 Date Fnished: 5/31/2018 12:i8PM Date WO Closed: 6/4/2018 10:15AM Work Order Summary _-- __-_ _. -- -•---- - - - __ - -- _ _ �' InEernal CommeralaF E uT mentUsa e - - — —- ------- - - --r-- -- - q—p----9 Labor Parts Overhead Labor Parts Misc Tax/Markup � Charges $542.12 $26.61 $0.00 � $0.00 $0.00 �0.00 �0.00 � �0.00 Total Work Order Costs: $568.73 Work Order Details Labor Transactbn Date Tasic Employee Labor Hours Labor Cost 4-12-2018 10:57AM (175) FIRE APPARATUS (16167) Vasko John A.Iil 5-31-2018 12:11PM (17� FIRE APPARATUS (16167) Vasko]ohn A.III z'�� , $276.70 4-12-2016 8:15AM (TRV) TRAVEL TO BE CHARGED TO WORK ORDER 1•5z �155.77 (1616� Vasko]ohn A.Ili 1.07 $109.65 Parts Transaction Date Task Part Qty Tssued Total Cost 4-23-2018 (175) FIRE APPARATUS (MMM-05220-0) Mmm;Marine Adh Fast Cure 2 $26.61 Page 1 of i Report Date:7/2/2018 �pEPCH� .���^�GZ � Work Order Detai/- Charges AF RES� Work Order: CSHOP-2018-2032 w0 Status: CLOSED Asset: (710280) ADVANCED LIFE SUPPORT VEHICLE Date In: 4/11/2018 3:38PM JobType: REPAIR DepartmenL• TEQUFSTA DateDue: 4/11/2018 11:38PM Repair Reason: 09 Account: 1300-440-4211-4620-OS ' Downtime Esdmated Completlon: Work Class: 4 License: ( Shop Hours: 0.00 Date WO Opened: 4/il/2018 3:38PM Warrenty: NO Seriai: iFVACWGT95HV19061 User Hours: 0.00 Date Flrst Labor: 4/12/2018 10:58AM Conbct: Meter 1: 48,192 Meter 2: 6,220 Date Finished: 5/31/2018 2:24PM Date WO posed: 6/4/2018 10:14AM Work Order Summary .__ . 3nternal Cofnmei'�ej. . •-'��- Equ�Ment Usage. --_ ----____ _._—._—-------—— ---- -- _ Labor Parts Overhead Labor Parts Misc Tax/Markup � Charges $287.97 $133.61 $0.00 i $0.00 $0.00 $0.00 $0.00 $0.00 � ' ' Total Work Order Costs: $421.58 Work Order Detaiis Labor Trensactbn Date Task Employee 4-12-2018 12:21PM (001) AIR CONDITIONING (16167) Vasko John A.Iil ��r Hours Labor Cost 5-31-2018 2:21PM (001) AIR CONDITIONING (16167) Vasko John A.Iii �'83 #85.06 4-12-2018 11:31AM (005-030) DOOR (16167) Vasko]ohn A.Ili 1.43 $146.55 0.55 $56,36 Pe s TransaCt(on Date Task Part 4-13-2018 (001) AIR CONDITIONING (2FL-A0694214000-0) 2FI;Hamess 4�Y Issued Total Cost 4-13-2018 (001) AIR CONDITIONING (2FL-VCCT77421A2C-0) 2Fl;Motor �22•19 1 $111.42 Page 1 of 1 ' Report Date:7/2/2018 �OFACH CO ��' Work Order Detai/- Charges � •��9E RES��• Work Order: CSHOP-201S-2488 WO Status: CLVSED Asset: (T5319) FIRE DEPARTMENT PUMPER NFPA COMPLIANT Date In: 5/7/2018 7:i8AM Job Type: REPAIR Department: TEQUESTA Date Due: 5/7/2018 3:18PM Repair Reason: 09 Acmunt: 1300-440-4211-4620-01 Downtlme Estimated Completlon: Work Class: 4 License: Shop Hours: 0.00 Date WO Opened: 5/7/2018 7:28AM Warranty: NO Serial: iS9A1HND5D1003124 User Nours: 0.00 Date First Labor: 5/31/2018 2:26PM Contad: Meter 1: 21,8Q9 Meter 2: 2,902 Date Finished: 6/14/2018 10:35AM Date WO Gosed: 6/18/2018 10:18AM Work Order Summary -_T_..-- _ _. -- - --_ _- Commer.cial _ _ InEennal _ -�-l-— ---- -- Bquipment Usage: — —'_ � ------- -- Labor Parts Overhead Labor Parts Misc Tax/Markup � Charges $114.78 $45.42 $0.00 ; $0.00 $0.00 $0.00 $0.00 ; $0.00 . � Total Work Order Costs: $160.20 Work Order Details or T2nsactlon Date Task Fmployee Labor Hours Labor Cost 5-31-ZO18 3:33PM (040-003) FAULT CODE (16167) Vasko John A.ni 0.72 $73.79 5-31-2018 2:50PM (175-015) EQUIPMENT MOUNTING BRACKETS (16167) Vasko]ohn A.III 0.40 $40.99 Parts Transaction Da[e Task Part 6-1-2018 (175-015) EQUIPMENT MOUNTING BRACKETS (9ME-LPVMS-0) 9Me;Small Mount Q��5 Zd To�l Cost $45.42 Page 1 of 1 Report Date:7/2/2018 ��J1Cy c� ' .��� Work Order Detai/- Charges ��9E RE GS J� � Work Order: CSHOP-2018-2811 wo Status: CLOSED AsseG (Ti0222) FULLSIZE 4X4 SUV Date In: 5/21/2018 11:29AM ]ob Type: REPAIR Department: TEQUESTA Date Due: 5/21/2016 7:29pM Repair Reason: 09 , Account: 1300-440-4211-4620-0! Downtime Estimated Completlon: Work Class: 4 License: 216917 I Shop Hours: 0.00 Date WO Opened: 5/21/2018 11:29AM Warranty: NO Serlal: 284HS48N62F163057 User Hours: U.00 Date Flrst Labor: 5/31/2018 8:35AM Contact: Meter 1: 66,537 Meter 2: 0 Date Flnished: 5/31/2018 10•36AM Date WO Closed: 6/4/2018 9:13AM Work Order Summary --- --------------. _ _ --- --- -_ _ _ _._,�,�.� _ _� _ ., _._. ._ . � I��^� Commerciat �_ Equtpi»ent�llsage - - . —- --- r � -- ------ - Labor Parts Overhead I Labor Parts Mlsc Tax/Markup i Charges $195.73 $101.49 $0.00 I $0.00 $0.00 $0.00 $0.00 $0.00 I � Total Work Order Costs: $297.22 Work Order Details Labor Transaction Date Task Empbyee Labor Hours Labor Cost 5-31-2018 9:43AM (TRV) TRAVEL TO BE CHARGED TO WORK ORDER (16167) Vasko John A.Iii 1.13 $115.80 5-31-2018 10:30AM (032-001) BATTERY (16167) Vasko John A.III 0.78 $79.93 P Transaction Date Tas1c Part Qty Issued Total Cost 5-29-2018 (032-001) BATfERY (1AD-M27MF-0) lAd;Battery 1 $101.49 Page 1 of 1 Report Date:7/2/2018 gEFCH �'�t�';i�4Y ��,;�::� Work Order Detai/- Charges ��9F flEBCS`" Work Order: CSHOP-2018-3020 WO Status: CLOSED Asset: (75319) FiRE DEPARTMENT PUMPER NFPA COMPLIANT Date In: 6/1/2018 7:11AM )ob Type: REPAIR Department: TEQUESTA Date Due: 6/1/2018 3:11PM Repair Reason: 09 Account: 1300-440-4211-4620-01 Downtime Estimated Completion: Work Class: 4 License: Shop Hours: 0.00 Date WO Opened: 6/1/2018 7:iSAM Warrenty: NO Serlal: 159A1HNDSD1003124 User Hours: 0.00 Date Flrst Labor: 6/14/2018 1:23PM Con�c[: Meter 1: 21,809 Meter 2: 2,902 Date Finished: 6/20/2018 1:24PM Date WO Cbsed: 6/21/2018 9:24AM Work Order Summary _ .__ - - - - - Idtet'naF ' - - -- � __' _ �Cor►mm�r¢1a1�•---- _ �� :Equ�pMeritUsage. � ___ _ Labor Parts Overhead i Labor Parts Misc Tax/Markup j Charges $225.45 �100.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total Work Order Costs: $326.09 Work Order Details La o Transactlon Date Task Employee Labor Hours Labor Cost 6-142018 2:31PM (TR� TRAVEL TO BE CHARGED TO WORK ORDER (16167) Vasko]ohn A.III 1.13 $115.80 6-142018 3:35PM (004-009) SEAT FRONT (16167) Vasko John A.Iil 1.07 �109.65 Parts Transaction Date Task Part Qty Issued Total Cost 6-142018 (004-009) SEAT FRONT (SSC-HOB8902116-0) SSc;Sensor 1 �100.64 Page 1 of 1 Report Date:7/2/2018 OEACy� 3�r( ��G� . ,,.,c�; , Work Order Detai/- Charges ��9E HES�J� Work Order: CSHOP-2018-3022 WO Status: CLOSED Asset: (T10221) SUPPORT VEHICLE Date In: 6J1/2018 8:t0AM Job Type: REPAIR Departrnent: TEQUESTA Date Due: 6/1/2018 4:10PM Repalr Reason: 09 Aaount: 1300-440-4211-4620-01 Downtlme Fstimated Completion: WorkClass: 4 License: ShopHours: 0.00 DateW00pened: 6/1/2018 8:10AM Warranty: NO Serlal: iGCHK33FOYF502871 � User Hours: 0.00 Date Flrst Labor; 6/21/2018 12:26PM Contac[: Meter 1: 49,761 Meter 2: 0 Date Flnished: 6/21/2018 12:28PM Date WO dosed: 6/21/2018 1:5.7PM Work Order Summary ,`_.. .------- ___ _-,.._ - -- __ __ , . __ _ -„- - - Inberriai Comruerci'al _;�qu�ment U6age -- -— -- -.__----' -- �...__.._ _�_�_� .-- Labor Parts Overhead I Labor Parts Mlsc Tax/Markup � Charges $3.07 $0.00 $0.00 � $0.00 $0.00 �0.00 � $0.00 � $0.00 i ' Total Work Order Costs: $3.07 Work Order Details Labor Transadlon Date Task Empbyee Labor Hours Labor Cost 6-21-2018 12:28PM (040) ENGINE AND ACCESSORIES (16167) Vasko John A.IH 0.03 $3.07 Page 1 of 1 Report Date:7/2/2018 �gEACN�� '�. s ��9F HES�V. Work Order Detai/- Charges Work Order: CSHOP-2018-3267 WO Status; CLOSED Job 7ype: REPAIR A�t' (T5319) FIRE DEPARTMENT PUMPER NFPA COMPLIpNT DePartment: TEQUESTA Repalr Reason: 09 Date In: 6/11/2018 4:11PM Work Class: q Account: 1300-440-4231-qgZp�l Wa�nry: �p License: Downtime Date Due: 6/12/2018 12:11AM �xy►�p, Serial: 1S9ASHNp5D1003124 Shop Hours: ���mated Completlon: 0.00 Date WO Opened: 6 �p}�fF Re ��:�00 USer HOUrS: 0.00 �11/2018 4:11PM Me��' �,pOZ Date First Labor: 6/14/2p18 3:38PM Work Order Summary Dafe Ffnished; --� �ec�wo��: .��g/3Ei� r�98� _T� _—_—-,Internal.— __ ___ _ _. _ _,. � •-- —— ,;; s .. - Labor _ �"" Labor �omR�er;�c�ajjr` �_ Parts �---_—� _- Overhead - - � _. $48.17 $40J0 I Parts — �E uf tneht Usa e $0.00 Mtsc ~ q p _9-- $0.00 $0.00 . ¢0.00 Tax/Markup . ges Char � #0.00 $0.00 Work Order Details Total Work Order Costs: Labor $88.87 Transaction Date Task 6-14-2018 4:06PM (030) ELECTRICqL Employee Pa� (16167) Vasko John A.III Labor Hours Transactlon Date 0.47 �bO��st 6-11-2018 Task $48.17 ��ZZ-027) DEF FLUID Part (NAF-DEF002-0) Naf;Bluedef25Gal Q�Y Issued 4 Total Cost $40.�0 Page 1 oF 1 Report Date:7/2/2018 �eEACH�,� ��� Work D�der D /qF AEg�V�t. etai/- Charges Work Order: CSHOP-2018-3330 WO Status: CLOSED Asset: ]ob 1ype: REPAIR (T10221) SUPPORT VEHICLE Department: TEQUESTA Date In: 6/14/2038 9;27AM Repafr Reason: 09 Account: 1300-440-4211-4620-01 Date Due; Work Gass: 2 Downtime 6/14/2018 5:27PM �i�ense: I Estimated Completion: Walranty: NO Serial: 1GCHK33FOYF502871 Shop Hours: 0.00 Date WO �n��� User Hours: 0.00 �ned: 6/14/2018 9:27AM Meter 1: 49,761 Meter 2; p Date Flrst Labor; Date Finished: 6/14/2018 9;37AM Work Order Summary �ate wo aosed: 6/ia/zois 9:37AM ,Teternal� • --__ ._.._... _ Labor Parks , __ CotnmeYdall; . . .�, Overhead , Labor -- ---- _�EquJpm'ent�Usa e $0.00 $0.00 $0.00 I $66.43 Pa� Mlac Tax/Markup j Charges � #28.27 ¢0.00 $4.73 ! $0.00 Work Order Details Total Work Order Costs; Commer ial �99.43 T2nsactlon Date Task 6-14-2018 12:OOAM (pq4) ��gy�FM Vendor (ALPA0001) AL PACKER Labor Cost Parts Cost Mix Cost Tax/Markup Total Cost $66.43 �28.27 $0.00 $4.73 $99.43 Page 1 of 1 Report Date:7/2/2018 efACH C � o� . •�,��` Work Order Detai/- Charges 9F flES� Work Order: CSHOP-2018-955 wo status: CLOSED Asset: (T5319) FIRE DEPARTMENT PUMPER NFPA COMPLiANT ]ob Type: REPAIR Department: TEQUE51'A �a�I�� 2/14/2018 7:O3AM Repair Reason: 09 Account: 1300-440-�4211-4620-01 Date Due: 2/14/2018 3;01PM Wo���: 4 � Downtime Estimated Completion: License: Shop Hours: 0.00 Date WO Opened: 2/14/2018 7:OlAM Warranty: NO Serlal; 1S9A1HND5D1003124 I User Hours: 0.00 Date Flrst Labor: 3/19/2018 4:49PM �On��: Meter 1: 21,809 Meter 2: 2,902 Date Flnished: 6/21/2018 8;57AM Date WO Closed: 6/21/2018 9:23AM Work Order Summary ,._._ __. _. - -. . ._. -- __ T parts __ . Misc --�.T� Marku •_._.t � ,.,, . -nternal Commel;cl�if� Labor Parks Overhead I Labor � �Q��p�e�nt;Usage� _ $79.93 $0.00 $0.00 I $0.00 $0.00 � p � Charges - - � $0.00 $0.00 ; $0.00 I � i ' Total Work Order Costs: $79,g3 Work Order Details Labor Transaction Date Task Employee 3-19-2018 5:36PM (040-045) OIL (30688) Rhoden Norrls A. Labor Hours Labor Cos[ 0.78 $79.93 Page,l of 1 Report Date:7/2/2018