Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Documentation_Regular_Tab 22_09/13/2012
VILLAGE CLERK'S OFFICE AGENDA ITEM TRANSMITTAL FORM Meeting Date: Meeting Type: Regular Ordinance #: N/A 09/13/12 Consent Agenda: No Resolution #: 25-12 Originating Department: Finance AGENDA ITEM TITLE; (Wording form the SUBJECT Fine of your staff report) Appropriating Fund Balance and increasing the 2011/2012 Water Utility Fund Budget $168,504 to fund additional water administration management fees. BUDGET / FINANCIAL IM.PACT: Account #: Amount of this item: $168,504.00 001-000-341.401 001-990-399.999 401-990-399.999 401-241-549.301 Current Budgeted Amount Available: Amount Remaining after item: N/A N/A Budget Transfer Required: Yes Appropriate Fund Balance: Yes EXECUT�VE SUMMARY OF MAJOR ISSUES: (This is a snap shot description of the agenda item) Appropriating Fund Balance and increasing the 2011/2012 Water Utility Fund Budget $168,504 to fund additional water administration management fees. APPROVALS: SIGNATURE: Department Head - Finance Director / Reviewed for Financial Sufficiency Q t No Financial Impact ❑ Attorney: (for legal sufficiency) Village Manager: Submit for Council Discussion: ❑ Approve Item: ❑ Deny Item: � SPECIAL INSTRUCTIO�NS FOR CLERK: (if you wish to have agreeme:nts signed, be su:re to include the number ofi copies you want sig;ned and place "Sign Here" sticker on them) - Form Amended: 10/20/11 FISCAL YEAR Zo�2 Villaqe of Tequesta Ba # Budqet Amendment Request JE # �Ir�crease� Department: Intragovernmental Revenue Account: Water Admin Fees Account #: 001-000-341.401 Original Budget Balance Available Transfer Amount New Balance Available $ 305,700.00 $ 26,394:00 $ 168,504.00 $ 194,898.00 Justification / Comments: Increasing water administration fees based on a study done by Public Resources Management Group. Department: Account: Account #: Original Budget Balance Available Transfer Amount New Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: Department: Account: Account #: Original Budget Balance Available Transfer Amount New Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: Department: Account: Account #: Original Budget Balance Available Transfer Amount New Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: ,,,; - - _�- • _. � ., - - �: - -.,�:>�. D�crease: � .. " _ _ .: Department: Other/Reserves/Conting Account: Appropriate Fund Balance Account #: 001-990-399.999 Original Appropriation Appropriated to Date Appropriation Request New Appropriation to Date $ 338,260.00 $ 476,661.00 $ -168,504.00 $ 308,157.00 Justification / Comments: Increasing water administration fees based on a study done by Public Resources Management Group. Department: Account: Account #: Original Budget Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: Department: Account: Account #: Original Budget Balance Available Transfer Amount New Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification i Comments: Department: Account: Account #: Original Budget Balance Available Transfer Amount New Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: �Approvals _ _ _ _ . Department Head: Da Budget Officer: Da Village Manager Approval: Da Village Council Approval: Resolution Number Da FISCAL YEAR Zo�2 Villaqe of Tequesta Ba # Budqet Amendment Request JE # Increase� . . _ _ .. _ Department: Other/Reserves/Conting Account: Appropriate Fund Balance Account #: 401-990-399.999 Original Appropriation Appropriated to Date Appropriation Request New Appropriation to Date $ 0.00 $ 292,537.00 $ 168,504.00 $ 461,041.00 Justification / Comments: Increasin water administration fees based on a stud done b Public Resources Mana ement Group. Department: Account: Account #: Original Budget Balance Available Transfer Amount New Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: Department: Account: Account #: Original Budget Balance Available Transfer Amount New Balance Avaitable $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: Department: Account: Account #: Original Budget Balance Available Transfer Amount New Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: �Fr�rease::� . _ _ _ , _ , , __ _ ;: �:� Department: Water Administration Account: Water Admin Fees Account #: 401-241-549.301 Original Budget Balance Available $ 316,730.00 $ 26,399.00 $ 168,504.00 $ 194,903.00 Justification / Comments: Increasing water administration fees based on a study done by Public Resources Management Group. Department: Account: Account #: Original Budget Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: Department: Account: Account #: Original Budget Balance Available Transfer Amount New Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: Department: Account: Account #: Originai Budget Balance Available Transfer Amount New Balance Available $ 0.00 $ 0.00 $ 0.00 $ 0.00 Justification / Comments: �A�aro�als: �. . _ � � _ � Department Head: Date: Budget Officer: Date: Village Manager Approval: Date: Village Council Approval: Resolution Number Date: RESOLUTION NO. 25-12 A RESOLUTION OF THE VILLAGE COUNCIL OF THE VILLAGE OF TEQUESTA, FLORIDA, APPROPRIATING FUND BALANCE AND INCREASING THE WATER UTILITY FUND #401 2011-2012 BUDGET IN THE AMOUNT OF $168,504.00 TO FUND THE PAYMENT OF ADDITIONAL ADMINISTRATIVE MANAGEMENT FEES AND AUTHORIZING THE VILLAGE MANAGER TO PROCEED ON BEHALF OF THE VILLAGE, PROVIDING FOR SEVERABILITY; PROVIDING AN EFFECTIVE DATE; AND FOR OTHER PURPOSES. WHEREAS, an analysis performed by Public Resources Management Group, Inc. identified indirect costs that should be allocated to the Water Utility Fund #401 and paid to the General Fund #001 as administrative management fees in the amount of $485,229.00; and WHEREAS, the current administrative management fees paid to the General Fund #001 is $168,504.00 less than the amount identified in the analysis; and WHEREAS, the increase in revenues in the General Fund #001 as a result of the increase in administrative management fees will be used to reduce the amount of appropriate fund balance required to balance the 2011-2012 budget in the General Fund; NOW, THEREFORE, BE IT RESOLVED BY THE VILLAGE COUNCIL OF THE VILLAGE OF TEQUESTA, PALM BEACH COUNTY, FLORIDA, AS FOLLOWS: Section 1 Resolution No. 25-12 appropriating Fund Balance and increasing the Water Utility Fund #401 2011-2012 Budget in the amount of $168,504.00 to fund additional water administrative management fees and authorizing the Village Manager to proceed on behalf of the Village providing for severability; providing and effective date; and for ofiher purposes is hereby approved, Section 2 This Resolution shall become effe�tive immediately upon passage. DRAFT Village of Tequesta, Florida Water Utilities Division Analysis of Annual Indirect Cost Reimbursement to Village's General Fund FISCAL YEAR 2013 INDEX OF TABLES Page Table No. Table Title No. Table ES Summary of Allocation of Budgeted General Fund Expenditures to 1 Utilities Division Table 1 Allocation of Budgeted General Fund Expenditures to Utilities 2 Division Table 2 Allocation Factors - Expenditures 16 Table 3 Development of Specific Allocation Factors 20 Table ES DRAFT Village of Tequesta, Florida Water Utilities Division Analysis of Annual Indirect Cost Reimbursement to Village's General Fund Summarv of Allocation of Budgeted General Fund Exuenditures to Utilities Division f ll Total Budgeted Line Department / Expenditures Allocated Allocation No. PROGRAM - Department / Division D ivision Numb (As Adjusted) Expenditures Percentage GENERAL FUND 1 Council 100 $ 28,450 $ 9,399 33.04% 2 Manager 110 196,480 43,099 21.94% 3 Human Resources 111 156,890 32,660 20.82% 4 Village Clerk 120 211,675 50,383 23.80% 5 Finance 130 387,040 113,163 29.24°l0 6 I.egal 140 114,000 23,370 20.50% 7 Comprehensive Planning 150 149,580 4,100 2.74% 8 General Government 160 274,360 41,230 15.03% 9 Police 171 - - 0.00% 10 Police Department 175 2,847,410 105,035 3.69% 11 Building & Zoning 180 339,940 - 0.00°l0 12 Civil Preparation 191 - - 0.00°Io 13 Fire Control 192 2,902,265 - 0.00% 14 Public Works 210 773,890 62,789 8.11% 15 Leisure Services 230 578,160 - 0.00% 16 Debt Service 700 431,060 - 0.00% 17 Other Financing Sources & Uses 910 - - 0.00% 18 Other Nonoperating 950 16,000 - 0.00% 19 Other Reserves and Contingency 990 - - 0.00% 20 Capital Improvement Fund 301 - - 0.00% 21 Capital Projects Fund 0 112,000 - 0.00% 22 TOTAL $ 9�519�200 $ 485�229 5.10% Footnotes: [ 1] Derived from Table 1. 1 Table 3 Village of Tequesta, Florida Water Utilities Division Analysis of Annual Indirect Cost Reimbursement to Village's General Fund Development of Specific Allocation Factors Allocation Percentages Line Allocation Water Utilitie� Other Division(s) / No. Ref. Description Basis Total Expenditure Division Department(s) Departments Allocated A Total Village Expenses Council 1 General Fund $ 9,S 19,200 $ 485,229 $ 9,033,971 Transfer To General Fund 2 Water Utility Fund 4,2,69,600 4,269,600 - 3 Refuse and Recycling Fund �a 85,180 - 485,180 4 Stormwater Fund ( 18,570 - 118,570 5 Tota1 Village Expenses $ 14,392,550 $ 4,754,829 $ 9,637,721 6 Percent of Total 100.000% 33.037% 66.963% B Village Manager Personnel - After Village Allocation to Utilities Village Manager Personnel 7 Village Manager Salary D'uect General Fund � I 14,922 `� $ ll4,922 8 Administration Same % to Utility as Manager 70,49�, 35,248 35,248 9 Total Village Manager Personnel Allocation - Net $ 185,418 $ 35,248 $ 150,170 10 Percent of Total 100.000% 19.010% 80.990% C Village Manager Personnel - Before �Iillage Allocation to Utilitie� Village Manager Personnel 11 Village Manager Salary Direct General Fund $ 114,922 $ 114,922 Village Manager Salary Direct Utility J I�.��?? 114,��22 - 12 Administration Same % to Utility as Manager 70,496 35,248 35,248 13 Total V illage Manager Personnel Allocation - Gross $ 300,340 $ 150,170 $ 150,170 14 Percent of Total 100.000% 50.000% 50.000% D Personnel - Total Labor Cost Human Resources General Government Personnel Costs - w/o Human Resources 15 M anager 4 I)1,580 $ 40,649 $ 150,931 16 Village Clerk 149,340 30,61_5 118,725 17 I�inance 337,590 104,980 232,610 18 Legal - - 19 Comprehensive Planning 149,580 4,100 145,480 20 Ueneral Government 92,930 - 92,930 21 Police - - 22 Police-Communication - - 23 Police Department 2,431,200 94,844 2,336,356 24 Building & Zoning 188,540 188,540 25 Civil Preparation - - 26 Fire Controi 2,584,785 - 2,584,785 27 Public Works 292,970 42,536 250,434 28 Parks - - - 29 Leisure Services 325,770 325,770 Water Utility Personnel Costs 30 Water Administration I 91,910 191,910 - 31 Water Production 563,23Q 563,230 - 32 Water Distribution 631,410 631,410 - 33 Refuse and Recycling Personnel Costs - Stormwater Utility Costs 34 Total Stormwater Utility 55,990 55,990 35 Total Personnel Costs $ 8,186,825 $ 1,704,275 $ 6,482,550 36 Percent of Total 100.000% 20.817% 79.183% E Village Clerk Personnel Clerk Personnel 37 Total Personnel Costs � 149,341) � >[1,(, I� $ 118,725 38 Contract Services - Recording Secretary 7,350 I,��)7 5,843 � 39 Total Personnel Costs $ 156,690 $ 32,121 $ 124,569 40 Percent of Total 100.000% 20.500% 79.500% F Finance Department Personnel - After Village Allocation to Utilities Finance Director Personnel 41 Finance Director Salary D'uect General Fund � �12,023 � - $ 92,023 42 Assistant Director Salary Personnel Related Component ? 1,423 4,460 16,964 43 Assistant Director Salary All Other Costs - Primarily Budget liS,096 22,497 45,599 44 All Other Personnel Based on Total Expenditures I 56,045 78,024 78,024 45 Total Finance Department Personnel Allocation - Net $ 337,590 $ 104,981 $ 232,609 46 Percent of Total 100.000% 31.097% 68.903% G Total Finance Department Personnel - Before Village Allocation to Utilities Finance Director Personnel 47 Finance D'uector Salary D'uect General Fund $ 92,023 � $ 92,023 48 Finance Director Salary D'uect Utility Fund l��.�� 1 49,551 - 49 Assistant Director Salary Personnel Related Component 21,423 4,460 16,964 50 Assistant Director Salary All Other Costs - Primarily Budget 68,096 22,497 45,599 51 All Other Personnel Based on Total Expenditures 156,048 78,024 78,024 52 Total Finance Department Personnel Allocation - Net $ 387,141 $ 154,531 $ 232,609 53 Percent of Tota] 100.000% 39.916% 60.084% H Police Personnel Dispatch for Safety Monitoring 54 Dispatch Component 50% of time Monitoring Cameras � 172,70R 6Q448 112,260 55 Remaining Personnel Allocated all to General Fund 2,25�,492 - 2,258,492 56 Total Personne] Costs $ 2,431,200 $ 60,448 $ 2,370,752 57 Percent of Total 100.000% 2.486% 97.514% 58 Dispatch Only - Personnel $ 172,708 60,448 112,260 59 Percent of Total 100.000% 35.000% 65.000% No. of Cameras Monitored 24 hours per day 60 Water Department t, 6 0 61 License Plate Recognition � 0 4 62 Leisure Services (Parks) a 0 4 63 Public Safety a 0 4 64 Village Ha11(allocate 50/50) ' 1 1 65 Public Works (� 0 0 66 Total No. of Cameras Monitored 20 7 13 67 Percent of Total 100.000% 35.000% 65.000% I Village Hall Square Foot Allocation 68 Village Manager Office Same % to Utility as Manager 520.0 260.0 260.0 69 Human Resources Same as HR Fersonnel 160.0 33.3 126.7 70 Clerk's Office Same as Clerk Personnel 160.0 32.8 127.2 71 Front Entrance (Bill Collection) Assume 75% to Utilities - 25% to GF 300.0 225.0 75.0 72 Finance Department Same as Finance Personnel - Gross 1,560.0 622.7 937.3 73 Remainder of Building less 25% Common Spa Direct General Fund 5,244.0 - 5,244.0 74 Subtotal 7,944.0 1,173.8 6,770.2 75 Percent of Total 100.00% 14.78% 85.22% 76 Allowance for Common Area Assume 30% of Building 2,648.0 391.3 2,256.7 77 Total Village Hall Allocation Recognized 10,592.0 1,565.1 9,026.9 78 Percent of Total 100.00% 14.78% 85.22% J General Government - Other Contractual Services Gen. Govt - Contractual Services 79 Alarm for Building at $400/quarterly Village Hall Square Footage � I.t,� u i $ 236 $ 1,364 80 Lobbyist Equal per Village Manager I�,400 9,200 9,200 81 Total Expenses $ 20,000 $ 9,436 $ 10,564 82 Percent of Total 100.000% 47.182% 52.818% K Village Hall Personnel 83 Village Manager Office Same % to Utility as Manager �.�� 1.0 1.0 Certain General Government Exp. 84 Human Resources Same as HR Personnel 2.( � 0.4 1.6 85 Clerk's Office Same as Clerk Personnel 3.� � 0.6 2.4 86 Finance Department Same as Finance Personnel - Gross �.0 2.0 3.0 87 Legal Activity Same as Clerk U.0 0.O 0.0 88 Comprehensive Planning No Allocation to Water Utilities U.�) 0.0 0.0 89 General Government Same % to Utility as TT Director 1.O 0.2 0.8 90 Building and Zoning No Allocation to Water Utilities 3.0 0.(� 3.0 91 L,eisure Services No Allocation to Water Utilities 6.0 U.0 6.0 92 Stormwater No Allocation to Water Utilities I.0 �.0 1.0 93 Total Village Hall Personnel 23.0 4.2 18.8 94 Percent of Total 100.000% 18.261% 81.739% Tota1 Village Hall Personnel without Finance (Allocated) 18.0 2.2 15.8 Percent of Total 100.000% 12.222% 87.778% L Village Hall Operating Leases 95 Clerk's Office Primarily Copy Facil. - 80% Clerk ti 4,�4�)6 $ 922 $ 3,574 Certain General Government Exp. 96 All Other Village Hall Personnel w/o Clerk (,124 202 922 97 Total Expenses $ 5,620 $ 1,124 $ 4,496 98 Percent of Total 100.000% 20.000% 80.000% M Public Safety Building - Utilities 99 Police Personnel Dispatch (8 employees) At 35% 33.t) 2.8 29.2 Certain General Government Exp. 100 Fire Personnel ?��.0 0 26.0 101 Total Expenses $ 58 $ 3 $ 55 102 Percent of Total 100.000% 4.828% 95.172% N Public Works - Personnel 103 M. McClintock Direct General Fund 5 t�,O4�, 5 � $ 9,048 Public Works Personnel 104 All Other Personnel 15% per PW Director - Maintain Wells and WTP Z7 �,36U 41,004 232,356 105 Total Finance Department Personnel Allocation - Net $ 282,408 $ 41,004 $ 241,404 106 Percent of Total 100.000% 14.519% 85.481% i G I I Comments - Allocated on Basis of Total Expenditures - Set Policy for Village - Total Expenditures Equate to Revenue Availability Which Links to Contribution - Village Manager D'uectly Allocated; Office Assistant (Support) is not - Only Village Manager Salary Directly Allocated; Allocated Other Department Costs - Personnel Costs Allocated on Total Personnel of Village i i i 1 j i - Based on Tune Spent on Activities (20.5%) as Discussed with Clerk - Finance Director Directly Allocated; Other Department Employees are not - Assumed Total Expenses since staff provides budget and accounting functions (transactions) - Finance D'uector Directly Allocated; Other Department Employees are not - Assumed Total Expenses since staff provides budget and accounting functions (transactions) Comments - Allocated on Basis of Total Expenditures - Set Policy for Village - Total Expenditures Equate to Revenue Availability Which Links to Contribution - Village Manager Directly Allocated; Office Assistant (Support) is not - Only Village Manager Salary Directly Allocated; Allocated Other Department Costs - Personnel Costs Allocated on Total Personnel of Village ' - Based on Time Spent on Activities (20.5%) as Discussed with Clerk - Finance Director Directly Allocated; Other Department Employees are not � - Assumed Tota1 Expenses since staff provides budget and accounting functions (transactions) - Finance Director Directly Allocated; Other Department Employees are not ' - Assumed Total Expenses since staff provides budget and accounting functions (transactions) - Allocated based on cameras monitored at 50% of time allocated per Police Chief � For Use of Facilities at Village Hall that benefits all departments For Use of Facilities at Village Hall that benefits all departments For Use of Facilities at Village Hall that benefits all departments Table I Village of Tequafa, F9orida Water Udli6es Division DRAFT Analysis oF Amual Indirect Cost Reimbursement to Village's Ge�ral Fund Alloradon of Budeeted General FY�nd Exoenditures to UtiliBes Division Depart✓ Comcil AllocaflanPerceMaRCS AllocaGonAmounfs I.lne Dlvisim Expeose FY2013 Allocatlon WaterUtilities OtherDivision(s)/ WaterUtilities OtherDivisian(s)\ No. Number Cade Description Budget Basis [1] Division Deparhment(s) Division Deparlment(s) 100 Comcil 530 Ooera[ine Expeoses I 531311 Cou¢c0 Fees - A�eua $ 3,000 To�alEzp 33.04� 66.969u S 991 S 2,009 2 53 L312 Comctl Fees - Tumquat - ToialEzp 33.04% 66.96 Yo - - 3 531313 Council fees - T. Patemo 3,000 TotalExp 33.04 R 66.96� 991 2,009 4 531314 Comcil fees - F. D'Ambra 3,000 TotalExp 33.0496 66.96% 991 2,009 5 531315 Comcil Feu - Humpage - TotalExp 33.0456 66.96 % - - 6 531316 Comcil fees - S. Okuu 3,000 TotalEzp 33.04� 66.96� 991 2,009 7 531317 Comctl Fces - Brenuau 3,000 ToialEzp 33.04% 66.96% 991 2,009 8 540301 Council Expenses - Arena 1,500 ToialExp 33.04% 66.96 % 496 1,004 9 540.302 Council Ezpenses -15unquest - TotalExp 33.04% 66.9696 - - 10 540304 Comcil Expeuse - F. D'Ambca I,500 TotalExp 33.04� 66.96� 496 1,004 I I 540.305 Comcil Expenses - Humpage - TotalExp 33.04^ro 66.96% - - 12 540306 CouncilExpense-S.Okuu 1,500 TofalExp 33.04^a 66.96°k 496 1,004 13 540307 Council Ezpensu - Breuneu 1,500 To�alExp 33.04% 66.96% 496 1,004 14 540308 CouncilExpensu- Patemo I,500 To�alExp 33.04% 66.96& 496 1,004 15 549300 Other Misc Chgs & Obligations 1,000 TotalExp 33.04% 66.9690 330 670 16 549350 VolunteerApprecietion 800 TotalExp 33.04Yo 66.96% 264 536 17 552302 Small Tools and Equipment 750 TotalExp 33.04 % 66.96% 248 502 l8 554300 Books, Publ, Subs & Membe�hip 3,400 TotalExp 33.04:5 66.969a 1,123 2,277 19 582.800 Aid ro Commmity Orgauiza[ions - TotalEzp 33.04% 66.96% - - 20 582.801 Aid to Com.Org - Areua - TotalExp 33.04% 66.96% - - 21 582.802 Aid ro Com.Org - Tumquest - TotalExp 33.04% 66.96% - - 22 582.805 Aid to Com. Org - Humpage - TotalEzp 33.04% 66.9696 - - 23 582.807 Aid to Com. Org. - Bieman - TotalExp 33.04 Yo 66.96% - - 24 582.808 Aid to Com. Ocg. - Patemo - TotalExp 33.04 % 66.9696 - - 25 Total Department 100 Expensu S 28,450 $ 9,399 $ 19,051 26 TotalDepartnent100E�enses 5 28,450 $ 9,399 $ 19,OS1 110 1Nanager 510 Personal Services 27 512.100 RegutarSalazies&Wages S 129,600 MmagerPerNe[ 19.0190 80.99% S 24,637 $ 104,963 28 515.103 Bonus Pay Plan - ManagerPerNet 19.01 % 80.99 % - - 29 515.104 SickLeaveCouversionPay - ManagerPerNet 19.0196 80.99% - - 30 515.108 Auto Allowance 3,000 Equal 50.00% 50.00% I,500 1,500 31 516.100 CompensatedAbsences 4,500 ManagerPe�Ne� 19.01% 80.99% 855 3,645 32 521.101 F1CATases 6,500 ManagecPecNet 19A1% 80.99% 1,236 5,264 33 521.102 MedicareTaces 2,000 MauagerPeeNet 19A1% 80.99% 380 I,620 34 522.102 VOTPeasionCoutribu[ions 12,200 ManagaPerNet 19.01% 80.99% 2,319 9,881 35 523.101 Life/HealW lusurance 22,800 MeueguPuNet 19.019a 80.99� 4,334 15,466 36 524.100 Workers' Comp Insucance 330 ManeguPerNet 19.019a 80.99% 63 267 37 526.104 ICMA-DeFCompPlan 9,900 Equal SO.OD9u 50.00% 4.950 4,950 38 554.3�1 PecsonnelTxaining 750 Equal 50.00% 50.00% 375 375 39 Total 510 Personal Services Ezpeuses 191,580 4Q649 150,931 530 Ooe�atiue Exceuses 40 540300 Travel&PaDiem I,500 Equal 50.00& SO.00Sb 750 750 41 546320 Computer system maint & suppli 500 Equal SO.W % SO.00:b 250 250 42 549300 Other Misc CLgs & Obligations 250 Equal 50.0056 50.00% 125 125 43 554300 Books, Publ, Subs & Membership 2,650 Equal 50.00 % 50.009 1,325 1,325 44 Total 530 Operating Expeus c Expenses 4,900 2,450 2,450 600 Caoi�al Outlav 45 664.601 ComputerEquipment - Equat 50.00% 50.00% - - 46 Total600Capital0utlayEzpenses - - - 47 Tofal Depar6men[ ll0 Ercpenses S I96,480 $ 43,099 S 153,381 111 Humau Resources 510 Personal Services 48 512.100 Regular Salaziu & Wages $ 79,800 Pasounel 20.82% 79.18% S 16,612 $ 63,188 49 515.107 Pa[t-timeSalazies 30,300 Pasonne] 20.82% 79.18:R 6,308 23,992 50 516.100 CompensatedAbsences 2,000 Persomel 20.82% 79.18% 416 1,584 51 521.101 FICA Taxes 7,000 Personuel 20.82 % 79.18 & I,457 5,543 52 521.102 MedicareTazes 1,700 Personuel 20.82% 79.18% 354 1,346 53 522.102 VOTPensionContributions 7,600 Pe�ome] 20.82% 79.18% 1,582 6,018 2 Table 1 Village of Tequesta, Florida Water Utilitles Division ORAFT Aoalysis of Annual Indirect Cost Reimbu'sement to Viliage's General Fund Allocallon of Bud¢eted General NLnd Exoenditures to Utilides Division DepaN Council Allocatlon Perceutages AllocaHon Amounts Lice Division Expense FY2013 Allocatiou Water[7titiNes O[herDivision(s)/ WaterUtiliBes O[herDivision(s)\ No. Number Code Description Budqe[ Bas(s [1] Dicision Deparhmen[(s) Division Deparunent(s) 54 523.I01 Life/Hea1W lusurance 7,200 Pecsonnel 20.8296 79.I8 Yo 1,499 5,701 55 524.100 Wockeis' Comp Insurance 290 Persome] 20.8290 79.18:8 60 230 56 526.101 Emplo}seRecoguitiouRogram 5,500 Personuel 20.82� 79.18% 1,145 4.355 57 526.102 EmployeeAssistmceProgram 3,800 Personcel 20.82%a 79.18% 791 3,009 58 554301 Pecsonnel Traiuing 3,000 Pecsomel 20.82°k 79.18°h 625 2,375 59 554310 EmployEeDevelopment 2,000 Persome] 20.82% 79.IS:b 416 1,584 60 To�a1510 Persoual Services Expenses 15Q190 31,265 118,925 3 Tabie 1 �Ilage of Tequesta, Florida Water Utilities Division DRAFT Analysis oP Annual ludirect Cost Reimbucsement [o Village's General NWd AllocaUon of Budeeted General Fund Excendimres to Udlides Division Departl Council AllocaHonPercenfaKes AllocationAmounts Line Divisfon Expense FY 2013 Allocation Water UdliHes O[her Division(s)/ Water U8litles Other Division(s)\ No. Number Code Description Bud�et Basis [I] Division Deparhment(s) Division Department(s) 530 Ocecatiu¢ Exoenses 61 534300 OthecContracNalServices - Pusonne] 20.82% '79.18% - - 62 5403Q0 Tcavel&PerDiem 1,500 Pexsonnel 20.82% 79.18% 312 1,188 63 546320 Computer sys[em maint & suppli 1,700 Personnel 20.82% 79.18% 354 1,346 64 547300 Printing&,Binding 1,500 Persomel 20.82% 79.18Nb 312 1,188 65 549300 OtherMiscChgs&Obliga[ions 500 Puaonnel 20.8296 79.18% ]04 396 66 549.401 Recxuitmeu�expeusu 500 Pexaonne] 20.82� 79.18% 104 396 67 552302 Smetl Tools aud Equipment 500 Personnel 20.8296 79.18% 104 396 68 554300 Books, Publ, Subs & Membership 500 Persomel 20.829a 79.18 % 104 396 69 Tota1530 Opecating Expeuses Expenses 6,700 1,395 5,305 600 Caoital Outlav 70 664.601 ComputerEquipment - Personnel 20.82°!0 7R18& - - 7t To�a1600CapitalOutlayExpeuses - - - 72 Total Deparlroent 111 Expenses $ 156,890 S 32,660 8 124,230 120 Village Clerk 510 Personal Services 73 512.100 Regular Salaries & Wages $ 109,800 CleckPe�omel 20.509a 79.50% $ 22,509 3 87,291 74 515.120 Cell phoue allowance - ClerkPersounel 20.5090 79.509G - - 75 521.101 ETCATaxes 6,800 ClerkPersomel 20.5070 79.50% 1,394 5,406 76 52LIO2 MedicareTaxes 1,600 ClerkPersonuel 20.50➢0 79.50% 328 1,272 77 522.102 VOTPensionContributions 10,400 C1erkPersonuel 20.50� 79.50% 2,132 8,268 78 523.101 Life/Healthlnsureuce 18,200 ClukPecsonnel 20.50� 79.50% 3,731 IQ469 79 524.100 Workecs' Comp Inswauce 280 GerkPecsonuel 20.50% 79.5090 57 223 80 554301 PersonnelTrai¢iug 2,260 ClerkPersonnel 20.50% 79.50% 463 1,797 81 Tota1510 Persoual Services Ezpeuses 149,340 30,615 118,725 530 Ooeratiue Exoenses 82 531303 Cod�ca[ionServices 7,650 Equal 50.00% 50.00% 3,825 3,825 83 531304 RecordingSecyService 7,350 C1erkPersonnel 20.5090 79.50% 1,507 5,843 84 534301 ElectionExpense 14,400 DuectGF 0.00% ]00.0090 - 14,400 85 534.3�2 Legal Advectising 19,000 Equal 50.00'& 50.0090 9,500 9,500 86 540.300 Travel&PerDiem 4,000 ClerkPersonnel 20.50% 79.50°k 820 3,180 87 541.300 Communication5ervices 1,250 Equal 50.00% SO.00io 625 625 88 546320 Computer system maiut & suppli 2,000 CleckPe�omel 20.SO l0 79.50 k 410 1,590 89 549.100 Miscellaueousfuchival 2,500 Equal 50.00& 50.00% 1,250 1,250 90 549201 Advertising&Promotiou I,000 Equal 50.009 50.00°6 500 500 91 549.300 OWer Misc Chgs & Obligations 1,800 Equal 50.00% 50.00% 900 900 92 552.302 Small Tools and Equipment 500 Equal 50.0090 50.00°h 250 250 93 552306 Uniforms 25 ClerkPecsouue] 20.50% 79.SOR 5 20 94 554300 Books, Publ, Subs & Membecship 860 ClerkPersonnel 20.50% 79.509 176 684 95 Tota1530 Operating Ezpenses Expeuses 62,335 19,768 A2,567 600 Caoital Outlev 96 664.601 ComputerEquipment - Equal 50.00% 50.00%a - - 97 Tota1600CapitalOupayExpenses - - - 98 Total Department 1TA E�enses $ 211,675 $ 50,383 S 161,292 130 Finance 510 Peisonal Services 99 512.100 Regulaz Salariu & Wages $ 242,500 FinancePecNet 31.10 % 68.90:5 S 75,410 S 167,090 100 515.107 Pazt-timeSalaries - FinancePerNet 31.1096 68.90% - - 101 SI6.100 CompeusetedAbseuces 3,000 FinancePuNet 31.10� 68.90% 933 2,067 102 521.101 FiCATazes 14,900 FivancePerNet 31.10% 68.90% 4,633 10,267 103 52LIO2 MedicazeTexes 3,500 FivaucePecNet 31.10� 68.90% 1,088 2,412 104 522.102 VOTPensionContributions 22,900 FivancePecNet 31109b 68.90% 7,121 15,779 ]OS 523.101 Life/Healthlnsurance 45,500 FinmmcePuNet 31.10°k 68.90Yo 14,149 31,351 106 524.100 Workecs' Comp Insurauce 690 FinancePerNet 31.10 % 68.90% 215 475 107 554301 PersonnelTrainiug 4,600 FivaucePecNet 31.10% 68.90% 1,430 3,170 ]08 Total 510 Personel Services Expeuses 337,590 104,980 232,6I0 4 Table 1 V Wage of Tequesta, F7orida Water Udlities Divisiou DRAPT Aualysis ofAnoual Indirect Cost Reimbursement to Village's General Ftind Allocadon of Budeeted Ceneral Fund Eamenditures ta UWitles Division DepartJ Comcil AllontionPercenta�es AllocadonAmomis Line Division Er.pense FY2013 Allocation WaterUtilities OtherDivision(s)/ WaterUdlities OtherDivision(s)\ No. Number Code Description Budge[ Basis [Ij Division Deparhneot(s) Division Department(s) 530 Ooeratiue Excenses 109 532300 Accouutiug & Auditmg Services 28,950 Direc� GF 0.00°k 100.00% - 28,950 110 540.300 Travel&PaDiem 1,300 Fina¢cePerGross 39.92% 60.08% 519 781 111 546.301 Office Equip/Repair & Meint 800 FiueucePeiGross 39.92�% 60.08% 319 481 112 546.320 Compu[ersystemmaint&suppli 8,500 FinancePeiGcoss 39.92% 60.089b 3,393 5,107 113 547.300 Printiug&Biuding 3,000 FinaucePaGross 39.92% 60.08% 1,197 1,803 I14 549300 O�her Misc Chgs & Obligations I,000 FinancePe�Gross 39.92% 60.08% 399 601 I15 551300 OfficeSupplies&Equipment Q000 FinencePe�Gross 39,92% 60.06% 1,597 2,403 116 5513I0 Fire Pceventio¢ Fducatiou - FinancePeiCiross 39.92% 60.08%o - - 117 552302 Swall Tools and Equipm�t 500 FivancePeiGross 39.92 Yo 60.08 % 200 300 118 554300 Books, Publ, Subs & Membexship 1,400 FinancePe�Gross 39.92:b 60.0890 559 841 119 Tota15300pera[iugExpeusesExpenses 49,450 8,183 41,267 I20 Tofal Deparlment 130 Eapenses $ 387,040 $ 113,163 $ 273,877 5 Table 1 Village of Tequesfa, Florida Water UdliOes Division DRAFT Analgsis of Annual Indirect Cost Reimbursement [o Village's General Flmd Alloration of Budee[ed General F4nd ExDenditures ta U[ilities Division Depar[./ Council Allaation Percentages AllocaUon Amounts Line Division Expense FY 7A13 Allacation Waler U61iUes O[her Division(s)/ Water Uh118es O[her Division(s)\ No. Number Code Descriptlon Budget Basis [17 Diviaion Deparlment(s) Division Departrneut(s) 140 Legal 530 Ooe=aliue Exoenses l21 531301 Legal Services $ 94,000 ClerkPersonuel 20.50% 79.50% 19,270 74,730 122 531.308 Legal fees - Pecsonnel 20,000 C1erkPecsonnel 20.50% 79.50% 4,100 15,900 123 Tota15300peratingExpensesExpenses 1I4,000 23,370 9Q630 124 TotalDeparlment140Eacpenses $ ll4,000 S 23,370 S 9Q630 I50 Comprehensive Planning 530 Oouatine Ezcenses 125 531301 LegalServices $ 20,000 ClerkPecsonnel 20.50% 79.50% S 4,100 $ 15,900 126 531321 MappingServices 2,500 DireciGF O.00Yo 100.00°k - 2,500 127 531322 Misc Planning Service 106,080 Direct GF 0.00% 100.00% - 106,080 128 531331 BoardofAdjustment 500 DirutGF 0.00% IOO.00h - 500 129 531332 Planning md Zouing Board 2,500 Diru[ GF 0.00% 100.00% - 2,500 130 531.405 Legal - An¢ezatiou - Direct GF 0.00% 100.00� - - 131 534300 OWerConhactualServices 5,000 DirectGF 0.00% ]00.00°k - 5,000 l32 534302 Legal Advertising I2,000 Direa GF 0.00% ]00.00% - 12,000 133 534.420 LegalAdvertisiug-Aunexation - D"¢ectGF 0.00% 100.00% - - 134 546320 Computer system maint & suppli - D"¢ect GF 0.0090 IOO.00 Yo - - 135 547.300 Priuting & Bindiug 500 Direct GF 0.00% 100.00 % - 500 136 549300 O[her Misc Chgs & Obligations 500 D"uect GF 0.009c 100.00% - 500 � 137 Total 530 Opuating Ezpeusec Expensu 149,580 4,100 145,480 600 Caoital Ou[lav 138 664.601 ComputerEquipmeut - DirectGF 0.00% 100.00� - - 139 Tota1600CapitalOu[IayExpeuses - - - 140 Total Deparlment 150 Erzpenses $ 149,580 $ 4,100 S I45,480 160 Geueral Goserument 510 Pe�soml Services l41 512.100 RegularSalartu&Wagu $ 69,800 DirectGF O.00k 100.00°b $ - 5 69,800 142 521.101 FTCA Tarzes 4,400 Direct GF 0.00% 100.00 & - 4,400 143 521.102 MedicareTaces 1,100 DirectGF 0.00% ]00.00� - I,100 144 522.102 VOTPensiouContributions 6,600 D"uectGF 0.0090 ]00.00% - 6,600 145 523.101 Life/Healthiusurance 5,800 D"¢ectGF 0.0090 100.00% - 5,800 146 524.100 Workecs' Comp Insurance 230 Direct GF 0.00 % 100.00% - 230 147 554.301 Personcel Tcaining 5,000 Direct GF 0.00% 100.00% - 5,000 148 Total 510 Personal Services Expenses 92,930 - 92,930 530 Ooeratin¢ Exoenses 149 534300 OWerContracmalServices 20,000 GGConhac[ 47.18% 52.8256 9,436 1Q564 I50 534303 Speciel Eveuts 10,000 Direc[ GF 0.00% 100.00% - 10,000 151 540300 Travel&PerDiem 2,000 IT 20.00% 80.00% 400 1,600 152 541300 CommuuicatiouServices 11,200 VFIEmpI 18.26% 81.74� 2,045 9.155 154 541.305 WebsiteMaiut�ance 7,750 Equal 50.00% 50.0090 3,875 3,875 I55 543300 UlilityServices 14,000 VHSqFt 149856 85.22% 2,069 11,931 156 544301 OperatingI.easu 5,620 VHOpl.ease 20.00% 80.00% 1,124 4,496 157 545300 Iusucance 50,310 VFIEmp] I8.26% 81.74Yo 9,187 41,123 158 546301 OfficeEquip/Repaa&Maint 2,000 VHOpLease 20.00% 80.00� 400 1,600 159 546302 Ve6icle Repaa & Mainteuauce - IT 20.0090 80.0090 - - 160 546303 Building Repair & Maint - VFIEmpI 18.26% 8194 % - - 16l 546310 EquipmeutRepa'v&Maiut 1,000 VHEmpI 1826% 81.74% 183 817 l62 546320 Computersys[emmaiut&suppli 13,300 DimctGF 0.00% ]00.00% - 13,300 163 547300 Prin[ing&Biudiug 1,000 VI-IEmpl 18.26� 81J4°k 183 817 164 549300 OWaMiscChgs&Obliga[ions 8,000 VHEmpI 18.26% 8194% 1,461 6,539 165 549302 VtllageNewsletter 18,200 Equal 50.00°h 50.00� 9,100 9,100 166 549304 Liceuses, Fea & Permi[s 2,650 D"uect GF 0.00 % 100.00% - 2,650 167 549366 Donations - Memorials - Direc[ GF 0.00% 100.00� - - 168 551300 Office Supplies & Equipment 4,000 VF�mpINet 12.22%r 87.7890 489 3,511 169 552.160 Jauirorial Suppliu 400 VHEmp] 18.26 & 81.74% 73 327 170 552301 Gas&Oil 600 VHEmpI I8.26% 819490 110 490 17l 552302 Small Tools and Equipment 1,500 VFIEmpI 18.2656 5194% 274 1,226 172 554300 Baoks, Publ, Subs & Membership 4,500 VHEmpI 18.26 k 819490 822 3,678 173 To�al 530 Operating Expeuses Expeusu 181,430 41,230 140,200 6 Table 1 Village oFTequesta, Florida Water Utilitles Division DRAFT Analysis oFAunual Indirect Cost Reimbursement to Village's Geneial Fund Allocatlon oPBUdeeted Geueral Fund Emeuditures w Utilities Division DepartJ Comcil Allo�adon Percenfaqes Allocatlon Amounfs Line Division ExPense FY 2013 Allocation Water Udlides Other Division(s)/ Water UUlities Other Division(s)\ No. Number Code Descriptiou Budget Basis [1] Division DeparUnent(s) Division Department(s) 600 Caoital Ou[lav 174 664.600 Mach/Equipment - VHEmpI 18.2690 81.74% - - 175 664.601 ComputerEquipment - VFIEmp] 1826�k 81.74% - - 176 664.602 Vehicles - VHEmpI 18.2696 81.74% - - 177 Tota1600 Capi[al Outlay Ezpenses - - - 178 TotalDepartrnent160Expenses S 274,360 3 41,230 $ 233,130 7 Table 1 Village of Tequesfa, Florida Water Utilifies Division OR1FT Analysis of Annual I�direct Cos[ Reimbursement to Village's General Ftind Allocadon of Budeeted Generai Fund Excendltures to Utilides Division DepaN Council Allocatiou Percentages Allocatlon Amomts � Line Division Expeose FY2013 Allocatlon WaterUtilities OtherDivision(s)/ WaterUWitles OtherDivision(s)\ No. Number Code Descripdon Budget Basis [S] Division Depardnent(s) Division Deparhnent(s) 171 Police 510 Personal Services 179 512.100 Regular Salaries & Wages $ - PolicePersomel 2.49 % 97.51% $ - S - 180 514.100 Overtime - PolicePersonnel 2.49°6 97.51% - - 181 A5.106 ClofLing & Boot ARowauce - Direct GF 0.00% 100.009a - - 182 516.100 Compensa[edAbsences - Po]icePecson¢el 2.49� 97.51°h - - 183 521101 FICA Taxes - PolicePersomel 2.49 % 97.51% - - 184 521.102 MeAicaze Taxes - PolicePersonnel 2.499G 97.51 k - - 185 522.101 FRS Cont�ibutioos - PolicePeisonnel 2.49% 97.51% - - 186 522.102 VOTPeusionCoutribu[ions - DirectGF 0.00% ]00.00% - - - 187 522.110 O[herPensionContributions - PolicePersomel 2.49% 97.51°/a - - 188 523.101 Life/Healthlnswmce - PolicePe�omel 2.49% 97.51% - - 189 524.100 Workers'CompInsurance - PolicePe�omel 2.49% 97.S1% - - I90 526.101 Emplo}ee Recogui[ion P�ogram - Direc[ GF 0.00% 100.00 % - - 191 526.103 Fducatiou Reimbursement Prgm - Direct GF 0.00% 100.00% - - 192 526.105 EmployeePhysicaVPsycobgical - D"uwtGF 0.0090 100.00:b - - 193 554301 Peisonnel Trainiug - Direct GF 0.00% 100.00°k - - 194 To[al 510 Personal Services Expensu - - - 530 Ooeratiue Exoenses 195 540300 Travel & Per Diem - Direct GF 0.0096 100.00% - - 196 541300 CommuuicationServices - DirectGF 0.00% ]00.00'Yo - - 197 541301 Postage - Dirut GF 0.00'Ya 100.00% - - 198 543.300 U[ility Services - Direc[ GF 0.00 & 100.00% - - - 199 544.301 OQeratiug Leases - Dicect GP 0.00% 100.00%a - - 200 545300 Insurmce - DirectGF 0.00% ]00.00& - - 201 546301 Office Equip/Repair & Maint - D"uect GF 0.00%> 100.00°k - - 202 54(303 BuildingRepa"u&Maint - DuectGF O.00:b 100.00� - - 203 546310 Equipmeut Repair & Maiu� - D'¢ect GF 0.00% 100.00% - - 204 546320 Computer system maiu[ & suppli - Direct GF 0.0096 100.00� - - 205 547300 Priu[iug&Bindiug - D'vectGF 0.0090 ]00.00°k - - 206 549300 OtLer Misc Chgs & Obligations - Direc[ GF O.00 lc 100.00% - - 207 549.304 Licenses, Fees & Pe�mits - Direc[ GF 0.00 & 100.00 % - - 208 551.300 Office Supplies & Equipmeut - Direc[ GF 0.00% 100.00°h - - 209 551301 Ccime Preveution Supplies - D"uect GF 0.00% 100.0090 - - 210 552302 SmatlToolsaudEquipment - D"urc�GF 0.00% 100.00& - - 211 552305 U¢iforms - D"uectGF O.00:b 100.00% - - 212 554300 Books, Publ, Subs & Membe�hip - D"¢ect GF 0.00 % 100.00%a - - 2l3 Tota1530 Operatiug Expensu Expenses - - - 600 Caoital Outlav 214 664.600 MacL/Equipment - DirectGF 0.00% ]00.00%a - - 215 Total 600 Capital Ou[lay Expenses - - - 216 Totai Deparhment 171 Ez7renses $ - $ - $ - 172 Police-Communication 510 Personal Services 217 512.100 Regulaz Salaries & Wages $ - Direct GF 0.0090 100.00'Yo S - 5 - 218 514.100 Overtime - Direct GF 0.00% 100.00% - - 219 515.101 HolidayPay - D"¢ectGF 0.0090 ]00.00% - - 220 515.103 BonusPayPlau - D"uectGF O.00Yo 100.00% - - 221 515.106 CloWing & Boot Allowauce - Direct GF 0.005b 100.Q0% - - 222 515.107 Pert-[imeSalaries - D"vectGF 0.00% 100.00:°a - - 223 516.100 CompensateAAbsences - DirectGF 0.0090 100.00% - - 224 521.101 FICATa4u - D"uectGF 0.00� ]00.0090 - - 225 521.102 Medicare Taxes - Direct GF O.00:b 100.00% - - 226 522.101 FRS Contributious - Direct GF 0.00 % 100.00% - - 227 522.102 VOTPensiouContributions - D"vectGF 0.00% 100.00% - - 228 523.101 Life/I-Iealthlnsucance - D"uec[GF 0.00% ]00.00% - - 229 524.100 Worke�' Comp lusucance - Direct GF 0.00:� 100.00% - - 230 554301 Pe�onuel Traiuiug - D"¢ec[ GF 0.0090 100.00% - - 231 Tota1510 Persoual Services Ezpenses - - - 530 Onaatiue Exoeuses 232 540300 Tcavet & Per Diem - D"¢u� GF 0.00% 100.00 &- - - 233 546301 Office Equip/Repair & Maiut - Direct GF 0.00% 100.00:Y - - 8 Table 1 Village oPTequesfa, F7orida Water Udlities Division DRAFT . Analysis of Annual Indirect Cost Reimbursement to Village's General FLnd Allocadon oFBudeeted General Ntind Ezoenditures to UhliBes Division Depart! Comcil Allocation Percentaqes Allocadon Amounts Line Division Exyense FY2013 Allocafion WaterUtilities OlherDivisiou(s)/ WaterUti6ties OfherDivision(s)\ No. Number Code Description Budget Basis [1] Division Deparhment(s) Division Department(s) 234 546304 Communication Equip Maint - PolicePersonnel 2.4990 97.5196 - - 235 549300 Other Misc Chgs & ObligaGons - Duect GF 0.00% 100.00% - - 236 552.302 SmallToolsandEquipment - D"vectGF 0.00% t00.00% - - 237 552305 Uniforms - D"vec�GF 0.00% 100.00% - - 238 554300 Books, Publ, Subs & Membe�6ip - D"¢wt GF 0.00% ]00.00°k - - 239 Tota1530 Opecating Expeuses Expeuses - - - 600 Caoital Outlav 240 664.600 Mach/Equipmeut - D"uectGF 0.00% ]00.00% - - 241 Tota1600Capi[alOutlayExpenses - - - 242 Tofal Department 172 Expenses 3 - $ - S - 9 Table 1 Village of Tequesta, F7orida Water Utilities Division DRAPT Analysis of Aunual Indirect Cost Reimbursement to Village's General Ntind Allorallon of Bud¢eted General N�nd Excenditures to Utilifies Division DepaN Counal AllocaUouPercentages AllocadonAmounu Line Division Eryense FY2013 Allocadon WaterUtilihes OtherDivision(s)/ WaterUtilities OtherDivision(s)\ No. Number Code Descripdon Budget Basis [1] Division Departmeut(s) Division Departnent(s) 175 Police Departnent 510 Personal Services 243 512.100 RegularSalazies&Wages $ - D"uectGF 0.00& 100.0090 S - $ - 244 512.171 SaI&Wages-Admiast�ation I80,500 PolicePersounel 2.4996 97.51°k 4,487 176,013 245 S 12.172 Reg Sal & Wages - Commmicatio 199,200 Dispa�ch 35.005b 65.0090 69,720 129,480 246 512.175 Reg Sal & Wages - Opecations 1,027,900 D"vect GF 0.00% 100.009 - 1,027,900 247 514.100 Overlime - D"vectGF 0.00� 100.009a - - 248 514.172 Overlime-Communications 17,000 DispatcL 35.00% 65.0090 5,950 11,050 249 514.175 Overtime-Operations 70,000 D"ueclGF 0.00% 100.00� - 70,000 250 514.325 Overtime-DEA - DirectGF 0.00'Yo 100.00� - - 251 515.101 HolidayPay 48,900 D"¢ectGF 0.00% 100.00:5 - 48,900 252 515.103 Bonus PayPlen 8,250 Direct GF 0.00� 100.00% - 8,250 253 SIS.I04 SickLeaveConversionPay - DirectGF 0.0090 ]00.00% - - 254 515.106 ClotLing & Boot Allowance 16,500 D"uect GF 0.00% 100.00°h - 16,500 255 515107 Pan-time Selaries - Direct GF 0.00� 100.00% - - 256 515.172 PIl'Selary-Commmications 6,200 Dispatc6 35.00�/0 65.00% 2,170 4,030 257 515.175 P/I'Salary-Operations ]00,400 D'¢ectGF 0.00% 100.00% - 100,400 258 516.100 Compeusated Abseuces 8,000 PolicePersome] 2.49 % 97.51 b 199 7,801 259 521.101 FTCATaxu 102,200 PolicePersounel 2.49Mc 97.51�5 2,541 99,659 260 521.102 Medicare Tazes 23,900 PolicePersomel 2.49 % 97.5190 594 23,306 261 522.101 FRS Contributious 46,500 PolicePersonnel 2.4990 97.51 k 1,156 45,344 262 522.102 VOTPeusionCon�ibulions 178,900 D"¢ectGF 0.00% I00.0056 - 178,900 263 522.110 Other Pension Contributions 56,470 D"vect GF 0.00 & 100.009 - 56,470 264 523.101 LifelHeelthlnsucauce 287,700 PolicePersomel 2.499a 97.Slhb 7,152 280,548 265 524100 Workecs'Compinsucaace 35,180 PolicePersonnel 2.49R 97.5196 875 34,305 266 526.101 Employxe Recognition Program 1,000 Direct GF 0.00% 100.00% - I,000 267 526.105 EmployeeP6ysicaVPsycological 6,000 Di�ec[GF 0.00°b 100.00% - 6,000 268 554301 Pe�omel Training 1Q500 Direct GF 0.0096 100.00% - 10,500 269 Total 510 Pecsoual Services Expenees 2,431,200 94,844 2,336,356 530 Ooeratine Exoenses 270 531.301 Legal Services 15,000 Direct GF 0.00% 100.00% - 15.000 271 531320 CodeEnforcemrntService 4,000 DirectGF O.00Yo 100.00� - 4,000 272 540300 Travel & Per Diem 9,650 D'¢ect GF 0.00 & 100.00�% - 9,650 273 541300 Commuuication Services 25,000 Dispatch 35.00% 65.00% 8,750 16,250 274 541301 Pos[age 2,000 Direct GF 0.00% 100.00% - 2,000 275 543300 UfilityServices 26,000 Safetyiltil 4.8396 95.17%a 1,255 24,745 276 544301 OperatingLeases 2,500 PolicePeisonuel 2.49% 97.51% 62 2,438 277 545300 lusurauce 45,410 DirectGF 0.00% 100.00% - 45,410 278 546301 OfficeEquip/Repa"u&Maint I,000 DirectGF 0.00% 100.00% - 1,000 279 546302 VehicleRepair&Maintenauce 35,000 D"uectGF 0.00% 100.0070 - 35,000 280 546.303 BuildiugRepart&Maint 15,OD0 DuectGF 0.00% 100.00% - 15,000 281 546304 Communication Equip Mainl 16,000 Direct GF 0.00% 100.00% - 16,000 282 546310 Equipmeut Repa'v & Maint 7,700 D'¢ect GF 0.00% IOO.00 Yo - 7,700 283 546320 Computer system meiut & suppli 52,800 Direct GF O.00 Yo 100.0090 - 52,800 284 547300 Printing & Bindiug 2,500 Duect GF 0.00� ]00.0096 - 2,500 285 549300 OWu Misc Chgs & Obligations 5,500 Direct GF 0.00% ]00.00 % - 5,500 286 549303 InvutigativeExpenses 1,100 DirectGF 0.0096 100.00% - 1,100 287 549304 Licenses, Feac & Pefmi[s 1,500 Direct GF 0.00� 100.00% - 1,500 288 5493ll Mazine Unit Opera[ious 3,000 Dimct GF 0.00% 100.00% - 3,000 289 549314 K.E.Y.S. Program 2,500 Di�ect GF 0.00� I00.00% - 2,500 290 551300 Office Supplies & Equipment 5,000 PolicePe�omel 2.495b 97.51% 124 4,876 291 551901 Crime Preveution Supplies 4,000 D'uect GF 0.0096 ]00.00� - 4,000 292 552301 Gas&Oil 6Q000 DirectGF 0.00% 100.00% - 60,000 293 552302 Small Tools aud Equipment 9,050 Di�ec[ GF 0.00% 100.00% - 9,050 294 552305 Unifoxms 20,500 D'¢ecIGF 0.00% � 100.00Yo - 20,500 295 554300 Books, Publ, Subs & Membership 4,500 Direc[ GF 0.00 % 100.00%a - 4,500 296 To�al 530 Operatiog Expenses Expenses 376,210 10,192 366,018 600 Canital Outlav 297 664.600 Mac6/Equipmeu[ - DirectGF O.00W 100.00%a - - 298 664.601 ComputerEquipment - Direc[GF 0.00%a 100.00� - - 299 664.602 Vehicles 4Q000 Direc�GF 0.00% ]00.00% - 40,000 300 664.620 lu[augible - Software - Direct GF 0.00% 100.00% - - 301 Tota1600CapitalOutlayExpeuses 4Q000 - 4Q000 302 Total Department 195 Expeoses 5 2,847,410 $ 105,035 $ 2,742,375 10 Table 1 Village of Tequesta, Florida WaterUtilides Division DRAFT Analysis of Annual Indirect Cost Reimbursement to Village's General Ntind Allocaaon of Bud¢eted General PLnd Excenditures to Utilitles Division DepartJ Council Aliocabon Percenfaqes Allocation Amounts Line Division Expense FY 2013 Allaation Water Utilities Ofher Division(s)/ Water Utilities Other Division(s)\ No. Number Cale DescripBou BndR� Basis [1] Division Deparfinent(s) Division Deparhnent(s) 180 Building & Zoning 510 Pecsonai Services 303 512.100 Regulaz Salazies & Wages $ 123,200 Direct GF 0.00:°0 100.00% $ - S 123,200 304 515.104 Sick Leave Conversiou Pay - Duect GF 0.00 h 100.00% - - 305 515.107 Pan-time Saleries 29,300 Direct GF 0.00% 100.00% - 29,300 306 515.120 Cell pLone allowauce - D"¢ect GF 0.00% 100.00% - - 307 516.100 Compensated Absences - Direct GF 0.00% 100.0070 - - 308 521.101 FICATaxes 9,500 D"uectGF 0.00°h 100.00% - 9,500 309 521.102 Medicare Taxes 2,300 D"uect GF 0.00% 100.00°k - 2,300 310 522.101 FRSContributions 4,I00 D"¢ectGF 0.00% 100.00:°0 - 4,100 311 522102 VOTPeusionCantnbutions 4,300 DirectGF 0.00% 100.009a - 4,300 312 523.101 Life/HealthIusurauce 14,200 D"uectGF 0.00% ]00.00% - 14,200 3l3 524100 Workers' Comp Inswance 140 Direct GF 0.00`k 100.00% - 140 314 525.100 Unemploymeut Compeusa[ion - Direct GF 0.0090 100.00% - - 315 554301 Pe�onuel Training I,500 Di�ect GF 0.00% 100.0090 - 1,500 316 Total 510 Personal Services Expenses 188,540 - 188,540 I1 Table 1 VJlage of Tequesta, Flodda Water Udlities Division DRAFT Analysis of Annual Indirect Cost Reimbucsement to Village's General Fund Allacallon ofBudeeted General Fund Eacoenditures to Udlities Division Depart! Council Allocatlon Percentages Allocation Amomts Line Division Eapense FY 2013 Allocation Water UtiliBes O[her Division(s)/ Water Utllities Of6er Division(s)\ No. Number Code Descriptlon Budge[ Basis [1] Division Department(s) Division Departmen[(s) 530 Ooecat e Exoensu 317 531325 Inspection Services 113,000 Di�ect GF �.0�% 10�.00� - 113,000 318 534300 OWerContracNalServices 11,500 DirectGF 0.00% 100.00% - I1,500 319 540.300 Travel&PerDiem 2,240 DirectGF O.00Io ]00.00% - 2,240 320 541.300 Communication Services 3,240 Direct GF 0.009a IOO.00Hu - 3,240 321 541.301 Postage 1,020 Di�ect GF 0.009a 100.00% - 1,020 322 543300 UtilityServices 5,500 DirectGF 0.00% 100.00`� - 5,500 323 544301 Operatingl.eases 1,910 DirectGF 0.00% ]00.0090 - 1,910 324 546301 Office Equip/Repa"v & Maint I,000 D'uect GF 0.00% 100.00°k - 1,000 325 546303 Building Repair & Maint - D'¢ect GF 0.00% 100.00� - - 326 546320 Computa system main� & suppli 5,200 Direct GF 0.00% 100.00q - 5,200 327 547300 Printing & Binding 1,000 Direct GF 0.00% 100.00 % - I,000 328 549300 Otha Misc Chgs & Obligations 600 D'uect GF 0.0090 ]00.00% - 600 329 549304 Liceusu, Fees & Permits 1,400 Direct GF O.00�k 100.00% - 1,400 33a 551300 Office Supplies &Equipmeut 2,540 D¢ect GF 0.0090 100.00% - 2,540 331 554300 Boolcs, Publ, Subs & Membe�6ip 1,250 Direct GF 0.00 % 100.00 7a - 1,250 332 Total 530 Operatiug Expensu Expenses 1A,400 - 151,400 600 Caoital Outlav 333 664.600 Mach/Equipmeut - Direct GF 0.00% 100.00 fo - - 334 664.601 ComputuEquipmeut - DirectGF 0.00% ]00.00� - - 335 Tota1600Capi�alOutlayExpeuses - - - 336 Total Depar[ment 1S0 E�enses 5 339,940 S - 5 339,940 191 C7vi1 Preparedon 510 Personal Services 337 554.301 Pecsonnel Traiuing $ - Direct GF 0.00% 1 W.00 Ya S - S - 338 To�a1510 Personal Services Expensu - - - 530 Ooera(ine Exceuses 339 540300 Trave] & Per Diem - Direct GF 0.00% 100.00� - - 340 541300 Commmica[ion Services - Direct GF 0.0090 100.00� - - 341 546320 Computer system maint & suppli - D"¢ect GF 0.00 % 100.00% - - 342 549.900 DisasterRefiet&InitialRup - D"vectGF 0.00% 100.00% - - 343 552308 Uniforms - D"uectGF 0.00°k 100.00% - - 344 552.309 Unifamos - Direct GF O.00H6 100.00% - - 345 5523I0 Unifomu - Di�ect GF 0.009a 100.00� - - 346 Total 530 Operatiug Expenses Ezpeuses - - - 347 Total Depardnent 191 Expeases S - S - S - 192 Flre Control 510 Pexsonal Services 348 512.100 Regular Salaries & Wages $ 1,430,900 Direct GF 0.00% 100.00% S - S 1,A30.900 349 514.100 Overtime 50,000 DirectGF 0.00°b ]00.00% - 5Q000 350 514300 OveRime-Training 19,890 D"vectGF 0.0090 100.00% - 19,890 351 515.101 HolidayPay 49,800 Di�ectGF 0.00% 1�0.0690 - 49,800 352 515.103 BonusPayPlan - D"uectGF 0.009 100.00% - - 353 A5.104 SickLeaveConversionPay - DirectGF 0.00% 100.0090 - - 354 515.106 Clothiug & Boot Nlowauce - D"¢ect GF 0.005b 100.00% - - 355 515.107 Part-timeSalazies 49,800 DirectGF 0.00% IOO.Wro - 49,800 356 515.1 IO Iutem Fire Fighter Pay 72,100 D"uect GF 0.0046 100.00% - 72,100 357 515.120 Cell phone allowance 1,200 Duect GF 0.00% 100.00 b - 1,200 358 516.100 Compensated Absences 3,600 D"¢ect GF 0.00 % 100.00% - 3,600 359 521.101 FICATaxes 102,800 D"vectGF 0.003'c 100.0090 - 102,800 360 521.IO2 MedicareTaxes 24,100 D"vec�GF 0.00% 100.00% - 24,100 36l 522.101 FRS Con�ibuuons - Duect GF 0.00°h I00.00% - - 362 522.102 VOTPensio¢Con�ibutious 337,900 DirectGF 0.00% 100.00% - 337,900 363 522.110 OtherPensionContributions 137,000 DirectGF 0.00`% ]00.00% - 137,000 364 523.101 Life/I-Sealihlasucance 226,700 DirectGF 0.00% 100.00% - 226,700 365 524.100 Workers' Comp lusurance 48,450 D"uect GF 0.0090 100.00% - 48,450 366 525.100 Unemployment Compeusa[io¢ - Direct GF 0.00% 100.00% - - 367 526.101 Emplo}ce Recognition Progrem 1,605 D"¢ect GF 0.00 % 100.00 90 - 1,605 368 526.103 Fduca[ion Reimbucsement Prgm 10,000 Direc� GF 0.00 % 100.00°6 - 1Q000 369 526.105 EmployeePhysicaVPsycological 9,870 D"uectGF 0.00� 100.00% - 9,870 370 554.301 Persounel Training 9,070 Direct GF 0.00% 100.00� - 9,070 l2 Table 1 Village oPTequesta, Florida Water UHlides Division DAAPT Analysis of Annnallndirect Cost Reimbursemeut ro Village's General N�nd Alloca8ou of Budzeted Ceneral Fund ErcoendiNres to Ulilities Division Depart✓ Council Allocation PercentaRes Allocadon Amounts Line Dlvision Eapense FY 2013 Allocation Water Utilides Other Division(s)/ Water Udlides Other Divisiou(s)\ No. Number Code Descdptlon Budget Basis [1] Division Deparhment(s) Division Department(s) 371 Total 510 Pecsonel Services Ezpenses 2,584,785 - 2,584,785 13 F R O d� ° 4. ° c �� �� �° o^� c ' �°o � o� v oS� oc°�S°oog8°c°o°o S a o o � � ,� ° `° � c� N c� c� .. �" � „' �' N � N N M N r r � � M � o .-. .r �o o ,.; a � ,.� _ ; Q � .. � CO � `i' vi a � � � � , � � , � � � � � � � � � � � � � � � , � � � � � � � � � v � � rn � a S o M g °o � � , � � g � _ � g ., � „ �- <a.5 N .. �Q 3 �, � •� y e b� G b S C48� Be6EGF�8� 0 821� �6 64gC8Q 8�°o0F 6� b 8£��CYBeBI' � 6�°0�°bE6e6F6�o�o0e�°gegY6eoo �;_� ° 0, ° 0,8 ° 0 ° 0, ° 0,80 ° 0, ° 0,8 ° 0 ° 0 ° 0,80 ° 0,08 ° 00 ° 0,8 ° 00 ° 0,8 ° o, aah���a��a ° 0,800 ° 0, 008 0 ° 0, ° 0,000 � Q.v �� o S o 0 0 0 0 0 0 0 0 0 0 8 0 0 o g o 0 0 0 8 0 0 0 8 0 ����������� ����� 8 0 o 0 8 0� o 0 � � � a 0 "' . � ° � �� g �aea% spaae��NN����a�'� aeaeseaYa� ae � '> Q "��•> oo ° 08 ° 0 '�'��+�v+�+�+��+ ° o ° o ° o ° og ° o ° o ° 08 ° 0� ° 0 ° 0 � 'p �Q o0000000000c000000000000000 000 ,�° �'?','?, � „����„� ,r,�,,,,,_,�000000,'^oo � a 3 d •a � a - s z � � a� wwwu.wwav,wwan.wwwu,wwv.�cwwaaww�. au,w ��--�"- - e s � a� c�c��c�c�c��c�c�c�c�c�c�c��c�c�c��c�c�c��c�c�c�� �c�c� ��'� � 2'� e���� 8 8 8 8 8 ������ x�� � P � ° � � �.�.� .��.�.� 5 .��.�.�.�.�.�.� �.�.� �.�.�.�.� � �.�.� 5 �.�.� p � . p � . p � . p � . � p �S . p � . E d � p d . p 33333 � � � � � �3 � � 5 L1 � �� Q Q L1 G1 G1 p L G1 G1 �C7L1G1GGGG1 G G L1 L1 C C7G1G1G0 L1G10 3355 �355�33 aaaaa�.1L1L1L1i��aqq � � a o w aawaaaa.aaaa � a c_,� ° E e"7 p� �' o o '." , �3U �•a.`�'.v ��° NNOO � g �� S oo yo yo ° o °000 80��0o��°oNBo � ,e'eV,o °°�N NN.., r�i"� vic� NN o �^ ria'rn� ri�i oo....... 2 � U G+ °� o d � b � m o � Pa a � � a • � � " � w � � � '`� ,- °' � % W � � ' ° � � W � � .� �y eu � a " 8 w � e � '` g o � .� � �s � 9��,� '0'�0�3 � � 'g e ° v oo p � � � � � ��'� �eo8 �i �' � @!a •a W c ,a��°'S a � �� v �¢ e ��` ° � �`n �, 'a�� °� �n �di.m 6.9 �dSk� W c °� .. 8 0 � � .. fi � W � G1 ° o_ c � � �� 'a Pi' =% 9 c��' ffi o � ( ' n v' o O 8 a U a �� °0 8 � °� 'g U � g 0. W m 2 q ° � _' �' �'� � � e .9 � 0 . ' . � � c4 �. a1 V � ._ a v e ^ ,m = W ° o� C Y a � � � '3 '� a ° � ° .9 � o p � � .� ° o, �, •W ' "$af �.s� a�'�,v''og� °a 3 a ,atN�F'&°au a3���v ;�_E �,� s- �� H ����� .� �=� � � ��� � °a�� � � � �y a�r �� �� d�� � � �c a'�..5 ga"�-'� o �•'�i,� F v F H w °�;� a�c' [-° o.S v�'�'=��ma � � 3 � � �� �;� sa���,.��� `�`�4'�'��8 ��'� o ��� ��$ o � ���a���3�� �>HUaao�>mwu�Co:a owc��,ua���oi,.r� �,�u> �xo�,uw���>a3 �u�oHUa�&'�',�ao>raa � � ° --� ° 080 ° 00000°NOOOMOOOOOOO°��c ° o Soo 3 ° 08�00000�00 08 w� h�,r�,h�°hr°���°��������h���� �e� a ��,�,h�,�,�,���� � �„�` h � h� h� �� a ����������� � �.`°� 6 '� ti �4z N �, ZI m M M m m i�+f M m m c� m m m M m n M M m M c� m m c� �n m t+i m p a V R V � p er � q Q� �� y � � � N N N N� ��� a V V C� C V C V V C V V V< V V C V Table 1 Village of Tequesta, Florida W ater Utilides Division DRAFT Analysis of Annual Indirect Cost Reimbursement to Village's General Fund Alloca8on of Bud¢eted General Fund Exoenditures to Otllides Division DepartJ Council Allocation Percentages Allocatlou Amounfs Line Division Eapense FY 2013 Allocatiou Water Utilities O[her Division(s)/ Water UtiliBes Olher Division(s)\ No. Number Code Descripdon Budge[ Basis [1] Division Department(s) Division Depar[ment(s) 43l 546306 GeueralMaintenance 30,000 DirectGF 0.00% ]00.00% - 3Q000 � 432 546309 Laudscape & Iaigation Maiut 130,000 Direct GF 0.009 100.00 io - 13Q000 433 546310 EquipmeutRepair&Maint 6,000 PWAlloc 15.00� 85.00% 900 5,100 434 546320 Computa system maint & suppli 1,020 PWAlloc 15.00 b 85.0096 153 867 435 546.350 R& M- Roads 20,000 D"uect GF 0.00% 100.00 % - 20,000 436 549300 Other Misc Chgs & Obligations 1,800 PWAlloc 15.00� 85.00% 270 I,530 437 549304 Licensu, Fees & Pem�its 4,500 PWAtloc 15.00% 85.00% 675 3,825 438 551300 OfiiceSupplies&Equipmeut 450 PWAlloc 15.00�90 85.00% 68 383 439 551.400 Janitorial Supplies 4,500 PWAlloc I5.00� 85.009b 675 3,825 440 552301 Gas&Oil 6,000 PWAlloc I5.00% 85.00% 900 5,100 441 552302 Small Tools end Equipmeut 1,500 PWAIIce 15.00% 85.00% 225 1,275 442 552.305 Unifoims 2,000 PWNIac 15.00% 85.00� 300 1,700 443 553.301 RoadSigus 2,000 D'¢ectGF O.00N6 100.00� - 2,000 444 563.600 PublicEducatiouRogcam 5,000 PWAlloc 15.00% 85.009a 750 4,250 445 563.601 St�eetscape Trees 2,000 Direct GF 0.0096 100.00% - 2,000 446 Total 530 Operatiug Expeuses Expenses 480,920 20,253 460,667 600 Caoital Outlav 447 663.600 ImprovemenLSOther�hanBldgs - PWAlloc 15.00% 85.00% - - 448 664.600 MacLBquipmeut - PWAIIce 15.00°k 85.00% - - 449 664.602 Vehiclu - PWAlloc 15.00% 85.00% - - 450 To�a1600CapitalOutlayExpeoses - - - 451 TotalDepartment Expenses S 773,890 S 62,789 5 711,101 15 � � 0 �� � . '°-�oo��oSoy�og o���o��$so�oogS000�oag , � _ ;� ° ❑ �.ior .. ' � � � v M .., .. "' c „' .., ... ci r, °` '^ M ,..,, v�, ,., .. N � o � Q w E e � �^ d, a � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � a o d a ,� R� 3 a� �Q� o �0000��€a�a��s�s�ss��e�s� a�ooe�s�ae�a�a�a�a�a�e�a�s�s�000�go u� e�Soo 0008 800 o S ° o 0 8 0000008000008000 ooS0000 � S ��CX 0. � e • Ys �?� �= a° s�e�a�a�ae���s�eeeea�e�a�ae� see��aea�ass�o��s�eeoaea%eeu�a�eea�u�e� s a�a°s�s� � '' ��•' °o °O ° o ° 0 0 ° 0 0 8 ° 0 ° 0 ° 0 0 0 0 8 ° 0 ° 0 ° 0 0 0 0 S ° o ° o ° 0 0 ° 0 0 8 ° o O° � fa �'q o 00 0 000 0 'co 00 'co 000 0 0000 a 3 m ................ ... ....... ....... oo.. v �a R � 3 D e g � o� w w�cwwaav,wwawu,wwwa n.wu,wwav.u.wwwwu,www�.�cu,ww� n, ww�v. � e � ary c7 c7c7c�c7c c c . c7C w ;� E a E � � � .� .� � .9 .9 y .� .5 ..�� .5 .� � .� .� .5 5 .� � 5 .4 .9 .� 5 .� ..�� .5 .� 7 � .4 .5 .� � .5 .� .B .9 9 � .5 y ..�� � ffi��, w Q� G L1CaCaC.1CaC]CaCaCaCaC�OGCaCaf] GOCaCaCICaG�CaCaCaGOGCaCaL1CCaCaCaCa (a CaCaGICl � a� .� ° F ea � o ... �3v � •�S". d � c� °o� NN � So�'��^....m�8°..,,o°,oSo^°ooySS � ' � �no �Q �am �^�� -N� N N .-' N O r i � '� V Fy P7 0 , � v' � — e e' � a ° ° � .� •a � ry� � � � � d � W - a � � � �. o � � � a o �. T ��, � � � � � e� � o a� �� � o .9 ,�y o ,w y a � o � � w 7 pj � g 6 S a $ 3 3 °� ' � � q � ,°�� .W 'm � .9 .-� a � W � ° � ,'F, � O e w � .9 � � � � � ��` � �a ° �� �� � � � � �� �� �&�� ���� w `� ; � a � �aF �u N o' � a y ° " S���� � e e��� o 0 0 � .�'W �g �, °° Q 60 � N O y 6 O a g � � ° o .� W Fl C� v� � y� � � O A .. .� Q�i " ��i 'm 0. � S�n'• �� F� '� � M � O O N 0. N p � 3 � a �ic-.. �� �a.H YWa � aa� p.5 n ' g � ad� 8 ,., a�- � � �w � � •c < � o v��,� .�ag�H�� �a�� o ���r�-ga�a �� a,`� �F�� � � � B y�g�u � r� �� F E 0.�,oN��¢��'�Bo�oe�.� F °a��o ; a���dcoa5���y;���48 F U F F Q 0. �g.@ F ��x w �c���>.a3�wa. �. °.o� <aa.ww •� � � a °� �' o 0 0� o 0 o g o o y o 0 0� o � o o 0 0 0 0 0�°° N o o�� S� o 0 o S g � $°"^ N W s�e'C7 � y - M`�"hhh c`v �: ���h g'"�i � � a � �,�,�,�,�hh�,�h��,�, h� � & ���� � = a a•> E � � $ � 'c, z' • "���o�mrno o,..N v��c�corno... rv n o °oo � � �� �nmm0000aomoowoomrnrnaa ;a Z v v v a e e e o v v v c v v v e v e v v v v v o e v v v v v v v v v v v v e o v v v e v o v v v�n �n Table 1 Village of Tequesfa, Florida Water Utilities Division DRAFT Analysis oFAnuual Indirect Cost Reimbursement tn Village's General EY�nd Alloca8on of Bud¢e[ed General Fmd Exvenditures tn Utilities Division DepaN Couucil Alloca8on PercentaQes elllocadon Amounts Line Division Erzpease FY7A13 Allocadon WaterUHliNes O[herDivision(s)/ WaterUdlides OlherDivision(s)\ No. Nurober Code Descrip0on Budget Basis [1] Division Depar6meut(s) Division Deparhment(s) 472 D/S - Intecest 503 572.706 P/S-Int.BOA-P.S Bldg 124,700 DirectGF O.00�Ya 100.00� - 124,700 504 572.708 P/S - SunTrust - Pumper � - Direct GF 0.00% I00.0090 - - 505 572.725 Int. 2012 Focd Fceus - Admin 365 D"uect GF 0.00'Yo I OO.00 Yo - 365 506 Total Total 471 D/S - Principa! Expeuses Expc 3 125,065 3 - $ 125,065 507 Total Deparlment 700 Erzpenses S 431,060 S - $ 431,060 900 InterFund Trens[ers Out 591 Interfuud Traosfecs Out 508 591301 Trsf to Capitel Imp Fund S - Direct GF 0.00% 100.00% - - 509 Tota1591 Interfnnd Transfers Out Expenses - - - 510 TotalDeparhnent Expenses 3 - S - $ - 910 O[her Ftinancing Sources & Uses 590 OWer Finmcine Sources & Ustt 511 56Z 100 Unrealized Loss ou Investmen�s $ - Direct GF 0.00 % 100.00% - - 512 Total 590 OWer Financiug Soucces & Uses Ex - - - 513 Total Deparhment 910 E�enses 8 - S - S - 17 Table 1 Village of Tequesfa, Florida Water Udlides Division DRAFT Analysis of Annual Indirect Cost Reimbursement to Village's General Fuud Allocalion of Budeeted General FLud Emenditures [o Udlifies Divis�on Depart✓ Council Allocation Percenfages Allocation Amomts Line Division Ezpense FY2013 Allocation WaterUtilities OtherDivision(s)/ WalerUtillties OtherDivision(s)\ No. Number Code Descrip8ou � Budget Basis [1] Division Department(s) Division Departmeut(s) 950 Other Nanoperattng 590 OWa Financine Soucces & Uses 514 549391 BaukCdarges $ 12,000 DimctGF 0.00°o IOO.00H S - S 12,000 515 549.395 Credit Card Fees aud Chazges 4,000 D'uect GF 0.00� 100.00% - 4,000 516 590.001 elllocate to Fund Balauce - Direct GF 0.0090 100.00% - - 517 999.001 Suspeuse - Direct GF 0.0090 100.00% - - 518 999.002 Suspense - Payroll - D'¢ect GF 0.00� 100.00% - - 519 999.200 Suspense-A/P - Direc[GF 0.0090 100.0090 - - 520 Total 590 OWer Fiueucing Sowces & Uses Ex 16,000 - 16,000 521 Tofal Department 950 E�enses $ 16,000 S - S 16,000 990 Olher Reserves and ConNngency 590 OWer Finencine Sources & Uses 522 599.902 Reserves - Contingwcy 3 - TotalEzp 33.04 % 66.96� 3 - $ - 523 To�al 590 Otha Fivancing Sources & Uses Ex - - - 524 Total Deparhment 990 Expeoses $ - 3 - 3 - 301 Capital Improvement Fund 600 Caoi�al Outlav 525 653.601 Road Improvements $ - Direct GF O.00Ro 100.0090 S - $ - S26 515.104 Dept: 315 TequestaDriveBridge) - D'uectGF 0.00% 100.00% - - 527 662.632 Arcltitect & Engeuiug - Direct GF 0.0096 100.00% - - 528 662.633 Cous�uction-Other - D"uectGF 0.00% ]00.00% - - 529 663301 Cous�mcfiou-Bridge - DirectGF 0.0096 100.00:Y - - 530 515.109 Depc 399 Misc Proj-Genecal - D"¢ect GF 0.00 % 100.00 & - - 531 663.655 Laudscaping - DirectGF 0.00� 100.00& - - 532 Tota1600CapitalOuUayExpenses - - - 900IuterL�nd Tiausfecs 533 591.001 TransfertoGenualFmd - D"uectGF 0.00% ]00.00% $ - S - 534 Tota1900 Intedi�ud Transfers Ezpenses $ - 3 - 5 - 535 Total Deparhment 301 Eapeases $ - S - 3 - SAA52590 2806 303 Capital ProJects Fund 600 Cavi�al Outlav 536 663.652 Pat6way/Sidewalk Improvemeuts $ - Direct GF 0.00 & 100.009v S - 5 - 537 Tota1600Cepital0utlayExpenses $ - $ - S - 900lnterfund Treosfe� 538 591.001 Tcansfec to Geueral Fund 112,000 dicect gf 0.00% 100.00% S - $ 112,000 539 Total 9001ntedund Trausfeis Expenses $ 112,000 $ - S 112,000 540 Total Deparhment 303 Expenses $ 112,000 $ - $ 112,000 541 TOTAL GENERAI. FOND EXPENDITURES $ 9,519,200 $ 485,229 S 9,033,971 542 PERCENT OF TOTAL EXPENDITURES 5.10% 94.90% 18