INSTRUCTIONS BEFORE USING THE ENCLOSED SCHEDULES, PLEASE COMPLETE THE FOLLOWING: Completing the steps below will populate the heading for each of the attached schedules. 1. Enter the City/Town Name: 2. Select the Budget Year CITY OF GLOBE 2017 Protection/Unprotection of File: Each spreadsheet within the file has been protected to prevent accidental deletion of formulas. When the sheet is protected you can move from one cell to the next using the Tab key. A password was not assigned, so the sheets may be unprotected to make minor formatting changes such as row height, column width, and font size. To unprotect an individual spreadsheet, select Protect/Unprotect Sheet from the menu. You may need to add lines to Schedules C through G to accommodate all funds or departments involved. Remember to check all formulas in the subtotals and totals to ensure that the additional lines are included, and make changes accordingly. Once changes have been made, the sheet should be re-protected by reversing the above process. Reprotecting the sheets will help ensure that formulas are not accidentally altered or deleted. Printing Tips: Schedule A can be printed on one page in landscape format with the "fit to 1 page wide by 1 page tall" option (Page Setup) selected. Schedules B through F can be printed in portrait format. Schedule G can be printed in landscape format. Schedules with multiple pages are formatted to print with the column headings on each page. 4/15 OFFICIAL BUDGET FORMS CITY OF GLOBE Fiscal Year 2017 4/15 CITY OF GLOBE TABLE OF CONTENTS Fiscal Year 2017 Resolution for the Adoption of the Budget Schedule A—Summary Schedule of Estimated Revenues and Expenditures/Expenses Schedule B—Tax Levy and Tax Rate Information Schedule C—Revenues Other Than Property Taxes Schedule D—Other Financing Sources/ and Interfund Transfers Schedule E—Expenditures/Expenses by Fund Schedule F—Expenditures/Expenses by Department (as applicable) Schedule G—Full-Time Employees and Personnel Compensation 4/15 CITY OF GLOBE Summary Schedule of Estimated Revenues and Expenditures/Expenses Fiscal Year 2017 FUNDS S c h Fiscal Year General Fund Special Revenue Fund Debt Service Fund Capital Projects Enterprise Fund Permanent Fund Funds Available Internal Service Funds Total All Funds 2016 Adopted/Adjusted Budgeted Expenditures/Expenses* E 11,469,668 4,008,102 0 0 43,459 8,767,077 0 24,288,306 2016 Actual Expenditures/Expenses** E 8,400,276 1,572,315 0 0 6,400 3,218,933 0 13,197,924 2017 Fund Balance/Net Position at July 1*** 2017 Primary Property Tax Levy B 2017 Secondary Property Tax Levy B 2017 Estimated Revenues Other than Property Taxes C 8,657,884 3,495,462 0 0 0 5,057,510 0 17,210,856 2017 Other Financing Sources D 0 0 0 0 0 0 0 0 2017 Other Financing (Uses) D 0 0 0 0 0 0 0 0 2017 Interfund Transfers In D 351,087 0 0 0 0 0 0 351,087 2017 Interfund Transfers (Out) D 339,087 0 0 0 0 0 0 339,087 2017 Reduction for Amounts Not Available: 0 490,010 490,010 0 LESS: Amounts for Future Debt Retirement: 0 0 0 0 2017 Total Financial Resources Available 2017 Budgeted Expenditures/Expenses E 9,159,894 3,495,462 0 0 0 5,057,510 0 17,712,866 13,383,109 3,846,549 0 0 37,424 9,559,002 0 26,826,084 EXPENDITURE LIMITATION COMPARISON 1. Budgeted expenditures/expenses 2. Add/subtract: estimated net reconciling items 3. Budgeted expenditures/expenses adjusted for reconciling items 4. Less: estimated exclusions 5. Amount subject to the expenditure limitation 6. EEC expenditure limitation $ 2016 24,288,306 $ 24,288,306 $ $ 24,288,306 2017 26,826,084 26,826,084 $ $ 26,826,084 The city/town does not levy property taxes and does not have special assessment districts for which property taxes are levied. Therefore, Schedule B has been omitted. * ** *** 4/15 Includes Expenditure/Expense Adjustments Approved in the current year from Schedule E. Includes actual amounts as of the date the proposed budget was prepared, adjusted for estimated activity for the remainder of the fiscal year. Amounts on this line represent Fund Balance/Net Position amounts except for amounts not in spendable form (e.g., prepaids and inventories) or legally or contractually required to be maintained intact (e.g., principal of a permanent fund). SCHEDULE A CITY OF GLOBE Tax Levy and Tax Rate Information Fiscal Year 2017 2016 1. Maximum allowable primary property tax levy. A.R.S. §42-17051(A) $ 2017 671,538 $ 711,024 $ 495,656 $ 490,010 $ 495,656 $ 490,010 $ 219,943 275,713 495,656 2. Amount received from primary property taxation in the current year in excess of the sum of that year's maximum allowable primary property tax levy. $ A.R.S. §42-17102(A)(18) 3. Property tax levy amounts A. Primary property taxes B. Secondary property taxes C. Total property tax levy amounts 4. Property taxes collected* A. Primary property taxes (1) Current year's levy (2) Prior years’ levies (3) Total primary property taxes B. Secondary property taxes (1) Current year's levy (2) Prior years’ levies (3) Total secondary property taxes C. Total property taxes collected $ $ $ $ 495,656 5. Property tax rates A. City/Town tax rate (1) Primary property tax rate 1.3200 1.3060 (2) Secondary property tax rate (3) Total city/town tax rate 1.3200 1.3060 Special assessment district tax rates B. Secondary property tax rates - As of the date the proposed budget was prepared, the city/town was operating special assessment districts for which secondary property taxes are levied. For information pertaining to these special assessment districts and their tax rates, please contact the city/town. * Includes actual property taxes collected as of the date the proposed budget was prepared, plus estimated property tax collections for the remainder of the fiscal year. 4/15 SCHEDULE B CITY OF GLOBE Revenues Other Than Property Taxes Fiscal Year 2017 ESTIMATED REVENUES 2016 SOURCE OF REVENUES ACTUAL REVENUES* 2016 ESTIMATED REVENUES 2017 GENERAL FUND Local taxes CITY SALES BED $ Licenses and permits FRANCHISE BUSINESS LICENSE BUILDING PERMITS AND FEES SWG CAPITAL EXPENDITURES 3,755,000 100,000 $ 3,614,792 181,134 $ 4,140,000 200,000 400,000 250,000 30,000 235,331 495,656 33,499 200,000 620,000 177,600 70,000 Intergovernmental STATE SALES URBAN REVENUE SHARING VEHICLE LICENSE 719,555 906,852 462,693 697,495 906,852 470,255 689,770 905,426 473,363 Charges for services SANITATION MUSEUM, RECREATION & CEMETERY FIRE, FLEET & RENT 615,000 93,600 95,000 610,031 85,171 135,382 619,725 77,500 294,500 3,000 78,500 1,985 129,100 11 1,000 140,000 4,000 4,913 4,000 15,000 15,000 48,557 8,509 30,000 15,000 Fines and forfeits MAGISTRATE POLICE FIRE Interest on investments In-lieu property taxes Contributions Voluntary contributions Miscellaneous MISCELLANEOUS AUCTION Total General Fund $ 7,543,200 $ 7,658,675 $ 8,657,884 * Includes actual revenues recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. 4/15 SCHEDULE C CITY OF GLOBE Revenues Other Than Property Taxes Fiscal Year 2017 ESTIMATED REVENUES 2016 SOURCE OF REVENUES ACTUAL REVENUES* 2016 ESTIMATED REVENUES 2017 SPECIAL REVENUE FUNDS HIGHWAY USER .5 CENT EXCISE LIBRARY GRANTS ACTIVE ADULT CENTER $ 752,692 348,000 $ 703,567 410,076 $ 769,033 465,057 $ 1,100,692 $ 1,113,644 $ 1,234,090 $ 125,760 2,500,000 100,000 $ 125,425 348,849 110,490 $ 125,760 2,000,000 135,612 $ 2,725,760 $ 584,764 $ 2,261,372 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total Special Revenue Funds $ 3,826,452 $ 1,698,408 $ 3,495,462 * Includes actual revenues recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. 4/15 SCHEDULE C CITY OF GLOBE Revenues Other Than Property Taxes Fiscal Year 2017 ESTIMATED REVENUES 2016 SOURCE OF REVENUES ACTUAL REVENUES* 2016 ESTIMATED REVENUES 2017 DEBT SERVICE FUNDS $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total Debt Service Funds $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total Capital Projects Funds $ $ $ CAPITAL PROJECTS FUNDS 4/15 SCHEDULE C CITY OF GLOBE Revenues Other Than Property Taxes Fiscal Year 2017 ESTIMATED REVENUES 2016 ESTIMATED REVENUES SOURCE OF REVENUES 2017 * Includes actual revenues recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. 4/15 SCHEDULE C ACTUAL REVENUES* 2016 CITY OF GLOBE Revenues Other Than Property Taxes Fiscal Year 2017 ESTIMATED REVENUES 2016 SOURCE OF REVENUES ACTUAL REVENUES* 2016 ESTIMATED REVENUES 2017 PERMANENT FUNDS VOLUNTEER FIRE PENSION $ 1,350 $ $ $ 1,350 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total Permanent Funds $ 1,350 $ $ 2,303,300 1,006,000 $ 2,299,508 986,685 $ 3,962,512 1,094,998 $ 3,309,300 $ 3,286,193 $ 5,057,510 ENTERPRISE FUNDS WATER WASTEWATER $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total Enterprise Funds $ 4/15 3,309,300 SCHEDULE C $ 3,286,193 $ 5,057,510 CITY OF GLOBE Revenues Other Than Property Taxes Fiscal Year 2017 ESTIMATED REVENUES 2016 ESTIMATED REVENUES SOURCE OF REVENUES 2017 * Includes actual revenues recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. 4/15 SCHEDULE C ACTUAL REVENUES* 2016 CITY OF GLOBE Revenues Other Than Property Taxes Fiscal Year 2017 ESTIMATED REVENUES 2016 SOURCE OF REVENUES ACTUAL REVENUES* 2016 ESTIMATED REVENUES 2017 INTERNAL SERVICE FUNDS $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total Internal Service Funds $ $ $ TOTAL ALL FUNDS $ 14,680,302 $ 12,643,276 $ 17,210,856 * Includes actual revenues recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. 4/15 SCHEDULE C CITY OF GLOBE Other Financing Sources/ and Interfund Transfers Fiscal Year 2017 OTHER FINANCING 2017 SOURCES FUND GENERAL FUND LIBRARY ACTIVE ADULT CENTER GENERAL FUND .5 EXCISE TAX $ $ INTERFUND TRANSFERS 2017 IN $ 60,117 70,027 $ 118,144 220,943 Total General Fund $ $ $ 351,087 $ $ $ $ $ Total Special Revenue Funds $ $ $ $ $ $ $ $ Total Debt Service Funds $ $ $ $ $ $ $ $ Total Capital Projects Funds $ $ $ $ $ $ $ $ Total Permanent Funds $ $ $ $ $ $ $ $ Total Enterprise Funds $ $ $ $ $ $ $ $ Total Internal Service Funds $ $ $ $ TOTAL ALL FUNDS $ $ $ 220,943 339,087 SPECIAL REVENUE FUNDS DEBT SERVICE FUNDS CAPITAL PROJECTS FUNDS PERMANENT FUNDS ENTERPRISE FUNDS INTERNAL SERVICE FUNDS 4/15 SCHEDULE D 351,087 $ 339,087 CITY OF GLOBE Expenditures/Expenses by Fund Fiscal Year 2017 ADOPTED BUDGETED EXPENDITURES/ EXPENSES 2016 FUND/DEPARTMENT EXPENDITURE/ EXPENSE ADJUSTMENTS APPROVED 2016 GENERAL FUND ADMINISTRATION $ COUNCIL COMMUNITY ORGANIZATIONS FIRE FLEET MAGISTRATE MUSEUM POLICE PUBLIC WORKS SANITATION 892,396 3,815,618 100,000 1,918,519 98,340 173,737 154,470 2,989,274 965,582 615,000 $ Total General Fund $ 11,722,936 $ 752,692 348,000 182,816 2,500,000 219,061 $ 4,002,569 $ SPECIAL REVENUE FUNDS HIGHWAY USER EXCISE LIBRARY GRANTS ACTIVE ADULT CENTER $ Total Special Revenue Funds $ ACTUAL EXPENDITURES/ EXPENSES* 2016 (62,000) $ (25,000) BUDGETED EXPENDITURES/ EXPENSES 2017 989,590 436,138 100,000 2,139,766 106,366 176,558 176,605 2,809,860 856,136 609,257 $ 905,963 3,453,257 200,000 2,694,637 183,391 202,857 217,876 3,887,995 1,637,133 (253,268) $ 8,400,276 $ 13,383,109 $ 752,692 348,000 126,572 181,693 163,358 $ 769,033 686,000 185,877 2,000,000 205,639 $ 1,572,315 $ 3,846,549 3,987 (49,884) (120,371) 5,533 5,533 DEBT SERVICE FUNDS $ $ $ $ Total Debt Service Funds $ $ $ $ $ $ $ $ Total Capital Projects Funds $ $ $ $ CAPITAL PROJECTS FUNDS PERMANENT FUNDS VOLUNTEER FIRE PENSION $ 43,459 $ $ 6,400 $ 37,424 Total Permanent Funds $ 43,459 $ $ 6,400 $ 37,424 $ 5,809,586 $ $ 2,106,237 $ 6,854,937 SEWER Total Enterprise Funds $ 2,957,491 8,767,077 $ $ 1,112,696 3,218,933 $ 2,704,065 9,559,002 $ $ $ $ Total Internal Service Funds $ TOTAL ALL FUNDS $ $ $ $ (247,735) $ $ $ ENTERPRISE FUNDS WATER INTERNAL SERVICE FUNDS 24,536,041 13,197,924 26,826,084 * Includes actual expenditures/expenses recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated expenditures/expenses for the remainder of the fiscal year. 4/15 SCHEDULE E CITY OF GLOBE Full-Time Employees and Personnel Compensation Fiscal Year 2017 FUND Full-Time Equivalent (FTE) 2017 Employee Salaries and Hourly Costs 2017 Retirement Costs 2017 Total Estimated Personnel Compensation 2017 Other Benefit Costs 2017 Healthcare Costs 2017 GENERAL FUND 75 $ 3,265,759 $ 2,699,381 $ 1,187,514 $ 126,019 $ 7,278,673 SPECIAL REVENUE FUNDS LIBRARY ACTIVE ADULT CENTER HIGHWAY USER Total Special Revenue Funds 3 3 7 13 $ 87,803 52,412 257,773 397,988 $ 9,355 5,584 27,465 42,405 $ 48,669 48,669 113,560 210,897 $ 228 784 24,808 25,820 $ 146,055 107,449 423,606 677,110 $ $ $ $ $ DEBT SERVICE FUNDS Total Debt Service Funds $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ CAPITAL PROJECTS FUNDS Total Capital Projects Funds PERMANENT FUNDS Total Permanent Funds ENTERPRISE FUNDS WATER SEWER Total Enterprise Funds 11 4 $ 495,306 204,116 $ 52,464 21,748 $ 193,052 79,492 $ 16,036 6,019 $ 756,858 311,375 15 $ 699,422 $ 74,212 $ 272,544 $ 22,055 $ 1,068,233 INTERNAL SERVICE FUND Total Internal Service Fund TOTAL ALL FUNDS 4/15 103 $ $ $ $ $ $ $ $ $ $ $ 4,363,169 $ 2,815,999 SCHEDULE G $ 1,670,955 $ 173,894 $ 9,024,016