Full Text
Page 1 of 3 Ogden City Council Work Session: May 9, 2017 OGDEN CITY QUARTERLY FINANCIAL REPORT Purpose of Work Session: To review and discuss the FY2017 Third Quarter Financial Report. Executive Summary The City Council will receive a presentation of the FY2017 Third Quarter Financial Report ending March 31, 2017. This report summarizes various fund expenditures, revenues and general financial information. Background Financial Quarterly Report State law requires that quarterly financial reports are presented and provided to the City Council. This report is provided for the first, second and third quarters, but is not required for the fourth quarter because the Comprehensive Annual Financial Report (CAFR) satisfies this need. Utah Code Ann. § 10-6-147 – Quarterly Financial Reports The city auditor in cities of the first and second class shall prepare and present to the governing body appropriate quarterly financial reports. Financial Principles for FY2017 The City Council and Administration jointly adopt financial principles each year. The principles for FY2017 were adopted on March 8, 2016. The section relating to quarterly financial reports is summarized below. FY 2017 Financial Principles – Quarterly Reports Not later than 45 days after the end of each quarter, the Administration shall provide quarterly financial reports to the City Council that include the following: a) Actuals to budgeted revenues and expenditures b) Balance sheet for governmental funds c) Fund balance analysis for governmental funds d) Cash balance analysis for proprietary funds These reports are not required to contain notes to the financial statements. Estimates can be included as appropriate. ---PAGE BREAK--- Page 2 of 3 Ogden City Council Work Session: May 9, 2017 Discussion The quarterly report includes a status of city accounts relative to revenues and expenditures, as well as other financial information. Overall, the city funds appear to be tracking with the FY2017 adopted budget. General Highlights: Revenues and Expenditures Revenues in the General Fund are projected to come in at about $3.6 million above the expenditures; The Capital Improvements, Water Utility and Sanitary Sewer funds have greater expenditures than revenue but still maintain healthy overall budgets; The Property Management Fund at BDO has about $11.3 million more in expenditures than revenue; and The Redevelopment Agency has about $5.9 million more in revenue than expenditures. The total for all funds is nearly a $9.5 million deficit in revenue, but still retains fiscal health with an overall account balance near $137 million in revenue and $127.6 million in expenditures. General Fund Revenue Telecommunication taxes are expected to come in under budget by approximately $100,000; and It is anticipated that parking violations may be $95,000 short in revenues. Other Funds The total for General Fund expenditures is approximately $38.8 million for the third quarter mark, or 66% of the total budgeted for FY2017; A payment from Dinosaur Park of $37,500 is anticipated to be used for trails. A budget opening to recognize this revenue is needed for FY2017; The Water Utility fund has a $2.5 million reduction in net assets, with $2.2 million expended on capital improvements; and The Refuse fund is anticipated to have $25,749 in additional revenue. ---PAGE BREAK--- Page 3 of 3 Ogden City Council Work Session: May 9, 2017 Questions 1. Please provide an overview of the Third Quarter Budget Report. Attachments 1. Administrative Transmittal 2. Quarterly Financial Report 3. Joint Resolution 2016-8 I FY2017 Financial Principles Administrative M Administrative Contact: Lisa Stout, City Comptroller, [PHONE REDACTED] Council Staff Contact: Amy Sue Mabey, (801)629-8629 ---PAGE BREAK--- ---PAGE BREAK--- Ogden City Financial Quarterly Report Period Ending 3/31/2017 Unaudited ---PAGE BREAK--- BUDGET ACTUAL PERCENT BALANCE GENERAL FUND REVENUE 59,109,503 42,472,651 72% 16,636,852 EXPENDITURES 59,109,503 38,834,205 66% 20,275,298 ‐ 3,638,446 SPECIAL ASSESSMENT FUNDS REVENUE 276,750 296,983 107% (20,233) EXPENDITURES 276,750 167,493 61% 109,257 ‐ 129,490 CAPITAL IMPROVEMENTS FUND REVENUE 26,085,747 4,362,627 17% 21,723,120 EXPENDITURES 26,085,747 8,492,694 33% 17,593,053 ‐ (4,130,068) WATER UTILITY FUND REVENUE 46,307,240 16,449,112 36% 29,858,128 EXPENDITURES 46,307,240 18,823,199 41% 27,484,041 ‐ (2,374,087) SANITARY SEWER UTILITY FUND REVENUE 18,455,582 8,336,643 45% 10,118,939 EXPENDITURES 18,455,582 9,265,722 50% 9,189,860 ‐ (929,079) REFUSE UTILITY FUND REVENUE 5,525,400 4,173,337 76% 1,352,063 EXPENDITURES 5,525,400 3,567,037 65% 1,958,363 ‐ 606,300 HINCKLEY AIRPORT FUND REVENUE 5,487,086 2,321,308 42% 3,165,778 EXPENDITURES 5,487,086 2,158,573 39% 3,328,513 ‐ 162,735 GOLF FUND REVENUE 1,693,770 784,660 46% 909,110 EXPENDITURES 1,693,770 1,005,244 59% 688,526 ‐ (220,584) RECREATION ENTERPRISE FUND REVENUE 273,350 168,229 62% 105,121 EXPENDITURES 273,350 192,239 70% 81,111 ‐ (24,010) PROPERTY MANAGEMENT FUND ‐ BDO REVENUE 20,132,950 3,169,000 16% 16,963,950 EXPENDITURES 20,132,950 14,449,079 72% 5,683,871 ‐ (11,280,079) OGDEN CITY FUND REVENUE & EXPENDITURE SUMMARY As of March 31, 2017 1 of 2 ---PAGE BREAK--- BUDGET ACTUAL PERCENT BALANCE OGDEN CITY FUND REVENUE & EXPENDITURE SUMMARY As of March 31, 2017 STORM SEWER FUND REVENUE 12,352,754 3,498,995 28% 8,853,759 EXPENDITURES 12,352,754 2,903,950 24% 9,448,804 ‐ 595,045 MEDICAL FUND REVENUE 7,799,425 5,097,482 65% 2,701,943 EXPENDITURES 7,799,425 4,600,164 59% 3,199,261 ‐ 497,318 FACILITIES/FLEET/STORES FUND REVENUE 13,137,713 7,344,955 56% 5,792,758 EXPENDITURES 13,137,713 8,837,204 67% 4,300,509 ‐ (1,492,249) MANAGEMENT INFORMATION SYSTEMS FUND REVENUE 6,140,546 4,048,998 66% 2,091,548 EXPENDITURES 6,140,546 4,070,525 66% 2,070,021 ‐ (21,527) RISK MANAGEMENT FUND REVENUE 1,604,500 1,291,856 81% 312,644 EXPENDITURES 1,604,500 1,198,278 75% 406,222 ‐ 93,578 NICHOLAS & CEMETERY TRUST FUNDS REVENUE 194,350 16,376 8% 177,974 EXPENDITURES 194,350 3,069 2% 191,281 ‐ 13,307 MISCELLANEOUS GRANTS & DONATIONS FUND REVENUE 569,571 (140,434) ‐25% 710,005 EXPENDITURES 569,571 165,219 29% 404,352 ‐ (305,653) MAJOR GRANTS FUND REVENUE 11,227,310 5,481,588 49% 5,745,722 EXPENDITURES 11,227,310 5,715,881 51% 5,511,429 ‐ (234,293) REDEVELOPMENT AGENCY REVENUE 27,168,935 17,367,183 64% 9,801,752 EXPENDITURES 27,168,935 11,467,542 42% 15,701,393 ‐ 5,899,641 MUNICIPAL BUILDING AUTHORITY REVENUE 550,475 409,797 74% 140,678 EXPENDITURES 550,475 509,582 93% 40,893 ‐ (99,785) TOTAL ALL FUNDS AND AGENCIES REVENUE 264,092,957 $ 126,951,346 $ 48% 137,141,611 $ EXPENDITURES 264,092,957 $ 136,426,900 $ 52% 127,666,057 $ $0 ($9,475,554) 2 of 2 ---PAGE BREAK--- TAXES 1 BUDGET RECEIVED PERCENT BALANCE $36,791,500 $27,004,626 73% $9,786,874 $9,686,874 ($100,000) LICENSES AND PERMITS 2 BUDGET RECEIVED PERCENT BALANCE $2,529,775 $2,083,112 82% $446,663 $446,663 $0 INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $5,547,215 $3,724,136 67% $1,823,079 $1,823,079 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $3,853,100 $3,090,918 80% $762,182 $762,182 $0 FINES AND FORFEITURES 5 BUDGET RECEIVED PERCENT BALANCE $2,299,875 $1,703,927 74% $595,948 $500,948 ($95,000) OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE 8,088,038 4,865,932 60% $3,222,106 $3,222,107 $0 FUND TOTALS $59,109,503 $42,472,651 72% $16,636,852 $16,441,853 ANTICIPATED NET GENERAL FUND REVENUES OVER (SHORT) of BUDGET ($195,000) EXCESS (SHORTAGE) PROJECTED RECEIPTS The majority of business license revenue is received during November through February. It is anticipated the revenue accounted for as licenses and permits will meet budgeted expectations. At this time, it is anticipated that Parking Violations could be $95,000 short. Revenue projections are expected to be met. PROJECTED RECEIPTS EXCESS (SHORTAGE) OGDEN CITY GENERAL FUND REVENUE SUMMARY As of March 31, 2017 PROJECTED RECEIPTS EXCESS (SHORTAGE) GENERAL FUND ‐ 1000 PROJECTED RECEIPTS PROJECTED RECEIPTS PROJECTED RECEIPTS Telecommunication taxes are expected to come in under budget by approximately $100,000. Most grants require reports of actual expenditures before reimbursement. B&C road fund and active transportation funds are included in this category and make up the majority of this revenue class. Class B&C Road Funds are received quarterly, active transportation tax is received and beer tax is received in November. The receipt of this revenue lags behind and is anticipated to meet budget expectations. EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) ---PAGE BREAK--- GENERAL FUND MAYOR BUDGET EXPENDED PERCENT BALANCE 100 PERSONNEL SERVICES 570,525 399,015 70% 171,510 SUPPLIES 16,975 9,340 55% 7,635 CHARGES FOR SERVICES 41,750 27,064 65% 14,686 OTHER OPER EXPENSES 16,575 1,240 7% 15,335 TOTAL 645,825 $ 436,659 $ 68% 209,166 $ COUNCIL BUDGET EXPENDED PERCENT BALANCE 150 PERSONNEL SERVICES 904,500 705,715 78% 198,785 SUPPLIES 5,550 2,009 36% 3,541 CHARGES FOR SERVICES 263,225 99,718 38% 163,507 OTHER OPER EXPENSES 53,300 37,585 71% 15,715 TOTAL 1,226,575 $ 845,027 $ 69% 381,548 $ MANAGEMENT SERVICES BUDGET EXPENDED PERCENT BALANCE 200 PERSONNEL SERVICES 3,597,100 2,565,216 71% 1,031,884 SUPPLIES 103,825 54,486 52% 49,339 CHARGES FOR SERVICES 783,725 482,748 62% 300,977 OTHER OPER EXPENSES 114,100 51,688 45% 62,412 CAPITAL OUTLAY 3,015 9,650 320% (6,635) TOTAL 4,601,765 $ 3,163,787 $ 69% 1,437,978 $ CITY ATTORNEY BUDGET EXPENDED PERCENT BALANCE 250 PERSONNEL SERVICES 1,150,250 855,432 74% 294,818 SUPPLIES 14,325 9,623 67% 4,702 CHARGES FOR SERVICES 115,715 34,936 30% 80,779 OTHER OPER EXPENSES 11,525 7,142 62% 4,383 TOTAL 1,291,815 $ 907,133 $ 70% 384,682 $ NON DEPARTMENTAL BUDGET EXPENDED PERCENT BALANCE 300 PERSONNEL SERVICES 200,000 ‐ 0% 200,000 CHARGES FOR SERVICES 1,873,400 919,187 49% 954,213 OTHER OPER EXPENSES 1,427,700 900,532 63% 527,168 DATA PROCESSING 1,741,775 1,306,325 75% 435,450 DEBT SERVICE 247,325 113,327 46% 133,998 CAPITAL OUTLAY 161,800 136,049 84% 25,751 INTERFUND TRANSFERS 1,920,350 1,408,325 73% 512,025 TOTAL 7,572,350 $ 4,783,746 $ 63% 2,788,604 $ POLICE BUDGET EXPENDED PERCENT BALANCE 350 PERSONNEL SERVICES 17,558,650 12,044,586 69% 5,514,064 SUPPLIES 875,845 484,986 55% 390,859 CHARGES FOR SERVICES 1,147,175 423,442 37% 723,733 OTHER OPER EXPENSES 924,925 650,494 70% 274,431 TOTAL 20,506,595 $ 13,603,508 $ 66% 6,903,087 $ OGDEN CITY GENERAL FUND DEPARTMENTAL EXPENDITURE SUMMARY As of March 31, 2017 As a reminder, the $200,000 in Personnel in Non‐Departmental is the Contingency for vacation buy‐back. Debt service is not paid evenly throughout the fiscal year. 1 of 3 ---PAGE BREAK--- GENERAL FUND OGDEN CITY GENERAL FUND DEPARTMENTAL EXPENDITURE SUMMARY As of March 31, 2017 FIRE BUDGET EXPENDED PERCENT BALANCE 400 PERSONNEL SERVICES 7,371,350 5,352,524 73% 2,018,826 SUPPLIES 187,638 71,661 38% 115,977 CHARGES FOR SERVICES 79,900 43,774 55% 36,126 OTHER OPER EXPENSES 313,656 256,168 82% 57,488 CAPITAL OUTLAY 29,000 16,794 58% 12,206 TOTAL 7,981,544 $ 5,740,920 $ 72% 2,240,624 $ PUBLIC SERVICES PUBLIC SERVICES ADMIN BUDGET EXPENDED PERCENT BALANCE 850100 PERSONNEL SERVICES 464,200 243,181 52% 221,019 SUPPLIES 94,050 14,545 15% 79,505 CHARGES FOR SERVICES 13,525 6,577 49% 6,948 OTHER OPER EXPENSES 47,125 33,841 72% 13,284 TOTAL 618,900 $ 298,145 $ 48% 320,755 $ PARKS/CEMETERY BUDGET EXPENDED PERCENT BALANCE 850200 PERSONNEL SERVICES 1,922,450 1,270,090 66% 652,360 SUPPLIES 244,055 119,642 49% 124,413 CHARGES FOR SERVICES 612,600 506,427 83% 106,173 OTHER OPER EXPENSES 435,950 282,196 65% 153,754 TOTAL 3,215,055 $ 2,178,355 $ 68% 1,036,700 $ RECREATION BUDGET EXPENDED PERCENT BALANCE 850400 PERSONNEL SERVICES 910,000 687,827 76% 222,173 SUPPLIES 111,475 58,520 52% 52,955 CHARGES FOR SERVICES 439,675 191,709 44% 247,966 OTHER OPER EXPENSES 95,125 51,185 54% 43,940 DATA PROCESSING 11,050 6,114 55% 4,936 TOTAL 1,567,325 $ 995,355 $ 64% 571,970 $ CHRISTMAS VILLAGE & AMPHITHEATRE BUDGET EXPENDED PERCENT BALANCE 850800 PERSONNEL SERVICES 140,475 129,890 92% 10,585 SUPPLIES 34,500 35,595 103% (1,095) CHARGES FOR SERVICES 10,000 9,025 90% 975 OTHER OPER EXPENSES 64,500 44,858 70% 19,642 TOTAL 249,475 $ 219,368 $ 88% 30,107 $ STREETS BUDGET EXPENDED PERCENT BALANCE 855200 PERSONNEL SERVICES 1,234,550 951,407 77% 283,143 SUPPLIES 173,850 62,393 36% 111,457 CHARGES FOR SERVICES 541,775 347,985 64% 193,790 OTHER OPER EXPENSES 1,321,275 760,347 58% 560,928 TOTAL 3,271,450 $ 2,122,132 $ 65% 1,149,318 $ Christmas Village is a seasonal activity, it is epected that the expenditures are primarily during the 2nd quarter of the year. 2 of 3 ---PAGE BREAK--- GENERAL FUND OGDEN CITY GENERAL FUND DEPARTMENTAL EXPENDITURE SUMMARY As of March 31, 2017 ENGINEERING BUDGET EXPENDED PERCENT BALANCE 855300 PERSONNEL SERVICES 961,075 747,487 78% 213,588 SUPPLIES 13,700 4,875 36% 8,825 CHARGES FOR SERVICES 516,675 (473,534) ‐92% 990,209 OTHER OPER EXPENSES 49,004 26,436 54% 22,568 TOTAL 1,540,454 $ 305,265 $ 20% 1,235,189 $ COMMUNITY & ECONOMIC DEVELOPMENT BUDGET EXPENDED PERCENT BALANCE 550 PERSONNEL SERVICES 3,734,875 2,638,521 71% 1,096,354 SUPPLIES 77,650 52,471 68% 25,179 CHARGES FOR SERVICES 343,000 246,341 72% 96,659 OTHER OPER EXPENSES 573,700 214,019 37% 359,681 DATA PROCESSING ‐ 100 (100) CAPITAL OUTLAY 91,150 83,353 91% 7,797 TOTAL 4,820,375 $ 3,234,806 $ 67% 1,585,569 $ GENERAL FUND TOTALS 59,109,503 38,834,205 66% 20,275,298 Charges for services budget and expenses are negative due to a reclassification of expenses to the Utility Funds. 3 of 3 ---PAGE BREAK--- SPECIAL ASSESSMENTS FUNDS ‐ 2100 & 3100 REVENUE TAXES 1 BUDGET RECEIVED PERCENT BALANCE $275,000 $292,876 107% ‐$17,876 $0 $17,876 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $1,750 $4,107 235% ($2,357) $0 $2,357 FUND TOTALS $276,750 $296,983 107% ($20,233) $0 ANTICIPATED NET SPEC REVENUE FDS REV OVER (SHORT) of BUDGET $20,233 EXPENDITURES SPECIAL ASSESSMENTS BUDGET EXPENDED PERCENT BALANCE CHARGES FOR SERVICES $149,250 $96,722 65% $52,528 OTHER OPER EXPENSES $70,000 $70,000 100% $0 OTHER FINANCING USES $57,500 $771 1% $56,729 TOTAL $276,750 $168,264 61% $108,486 PROJECTED RECEIPTS EXCESS (SHORTAGE) PROJECTED RECEIPTS EXCESS (SHORTAGE) Includes transient room taxes and the downtown special assessment levy. The special assessment levy is being billed by the County and the revenue estimated was received in December, when property taxes are collected. OGDEN CITY SPECIAL ASSESSMMENT FUNDS REVENUE & EXPENSE SUMMARY As of March 31, 2017 Interest income is the revenue source accounted for as other revenue in these funds ---PAGE BREAK--- CAPITAL IMPROVEMENT FUND ‐ 4100 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $83,000 $549,033 661% ($466,033) $0 $466,033 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $0 $37,500 ($37,500) $0 $37,500 Payment from Dino Park to be used for Trails. A budget opening to recognize this revenue is need for FY17 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $26,002,747 $3,776,094 15% $22,226,653 $21,760,620 ($466,033) FUND TOTALS $26,085,747 $4,362,627 17% $21,723,120 $21,760,620 ANTICIPATED NET CIP FUND REVENUES OVER (SHORT) of BUDGET $37,500 EXPENDITURES CAPITAL IMPROVEMENTS BUDGET EXPENDED PERCENT BALANCE MANAGEMENT SERVICES $916,841 $82,935 9% $833,906 NON DEPARTMENTAL $1,435,734 $326,089 23% $1,109,645 FIRE $104,134 $7,177 7% $96,957 PUBLIC SERVICES $23,346,046 $8,076,493 35% $15,269,553 TOTAL $26,085,747 $8,492,694 33% $17,593,053 Detail expenditures by project are provided in the CIP quarterly report Revenue accounted for as other revenue includes a road funds and active transportation funds transfer from the general fund, a transfer from the BDO fund, a transfer from the Gomer Nicholas Endowment Fund for parks and interest income. The CIP projects carryovers from FY 2016 is also included in this revenue category. PROJECTED RECEIPTS PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS EXCESS (SHORTAGE) OGDEN CITY CAPITAL IMPROVEMENT FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 RAMP funds are included in this category. A budget for WACOG funds had been appropriated in FY2016. The current revenue in excess of the budget is from carry forward WACOG revenue and is represented in the other reveue category. ---PAGE BREAK--- WATER UTILITY FUND ‐ 5100 REVENUE TAXES 1 BUDGET RECEIVED PERCENT BALANCE $864,600 $0 0% $864,600 $864,600 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $19,140,975 $15,590,987 81% $3,549,988 $3,549,988 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $26,301,665 $47,622 0% $26,254,043 $26,254,043 $0 FUND TOTALS $46,307,240 $16,449,112 36% $29,858,128 $29,858,128 ANTICIPATED NET WATER FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES WATER UTILITY BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $4,034,100 $2,864,833 71% $1,169,267 SUPPLIES $1,086,850 $839,509 77% $247,341 CHARGES FOR SERVICES $1,996,675 $1,164,984 58% $831,691 OTHER OPER EXPENSES $5,008,125 $3,261,633 65% $1,746,492 DATA PROCESSING $526,125 $316,519 60% $209,606 NON OPERATING EXPENSE $7,406,200 $6,827,740 92% $578,460 CAPITAL OUTLAY $26,209,165 $3,507,983 13% $22,701,182 OTHER FINANCING USES $40,000 $40,000 100% $0 TOTAL $46,307,240 $18,823,199 41% $27,484,041 Other Financing Uses is a transfer for percent for arts Profit/(Loss) to date (encumbrances not included) ($2,374,087) Cash in Bank December 31, 2016 $10,986,168 Cash in Bank March 31, 2017 $9,949,659 This is a budget to for a end of year adjustments. It is to recognize Weber Basin Water District tax revenue collect directly by Weber Basin to provide for Ogden City costs. At this time, it is expected revenue will meet projections As of March 31, 2017 EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) Includes bond proceeds of $17,000,000 and use of retained earnings for capital outlay PROJECTED RECEIPTS PROJECTED RECEIPTS PROJECTED RECEIPTS OGDEN CITY WATER FUND REVENUE & EXPENSE SUMMARY ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH WATER FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 18,284,575 $ 6,953,815 $ 4,178,399 3,816,448 $ 14,948,662 81.8% Special district taxes 864,600 - - - - 0.0% Accounting charges 856,400 214,025 214,178 214,125 642,328 75.0% Grants and donations - - - 810,503 810,503 0.0% Miscellaneous income 17,007,500 11 20 1,192 1,223 0.0% Total revenue 37,013,075 7,167,851 4,392,597 4,842,268 16,402,716 44.3% OPERATING EXPENSES: Personal services: Salaries and wages 2,614,550 590,481 582,708 691,141 1,864,330 71.3% Benefits 1,422,700 318,819 317,766 365,581 1,002,166 70.4% Supplies: Office supplies 241,600 35,203 54,587 47,287 137,077 56.7% Operating supplies 592,450 177,738 213,145 64,467 455,350 76.9% Repair and maintenance supplies 274,150 130,246 88,604 100,907 319,757 116.6% Charges for services: Public utility services 648,600 119,524 148,676 138,208 406,408 62.7% Travel and education 71,000 12,300 11,756 42,216 66,272 93.3% Contracted agreements 1,408,925 150,836 138,669 672,013 961,518 68.2% Other operating expenses: Rental charges 114,550 28,600 28,650 28,650 85,900 75.0% Fiscal charges 3,104,300 776,225 776,025 776,025 2,328,275 75.0% Depreciation 2,000,000 - 1,405,947 702,974 2,108,921 105.4% Data processing and computer equipment 526,125 106,375 105,250 104,894 316,519 60.2% Maintenance and repair 755,925 85,121 81,489 55,848 222,458 29.4% Vehicle operating expenses 479,575 106,494 101,042 109,361 316,897 66.1% Water purchase 1,013,125 - - 2,718 2,718 0.3% Miscellaneous 488,600 47,008 75,970 58,208 181,186 37.1% Total operating expenses 15,756,175 2,684,970 4,130,284 3,960,498 10,775,752 68.4% Operating income (loss) 21,256,900 4,482,881 262,313 881,770 5,626,964 26.5% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 50,000 1,359 - 19,404 20,763 41.5% Gain on sale of assets 35,000 9,021 12,381 4,231 25,633 73.2% Expenses: Capital improvements (26,209,165) (403,331) (842,452) (2,262,200) (3,507,983) 13.4% Debt service - principal (1,913,800) (712,263) (760,247) (583,977) (2,056,487) 107.5% Interest expense (2,388,100) (655,462) (1,161,634) (625,881) (2,442,977) 102.3% Total non-operating revenues (expenses) (30,426,065) (1,760,676) (2,751,952) (3,448,423) (7,961,051) 26.2% Income before operating transfers (9,169,165) 2,722,205 (2,489,639) (2,566,653) (2,334,087) 25.5% Transfers in (use of fund balance) 9,209,165 - - - - 0.0% Transfers out (40,000) (40,000) - - (40,000) 100.0% Change in net assets - 2,682,205 $ (2,489,639) (2,566,653) (2,374,087) Cash Summary: Cash, Beginning of quarter $ 9,189,593 $ 11,228,975 $ 10,986,168 Cash, End of quarter $ 11,228,975 $ 10,986,168 $ 9,949,659 ---PAGE BREAK--- SANITARY SEWER UTILITY FUND ‐ 5110 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $10,946,775 $8,311,185 76% $2,635,590 $2,635,591 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $7,508,807 $25,458 0% $7,483,349 $7,483,349 $0 FUND TOTALS $18,455,582 $8,336,643 45% $10,118,939 $10,118,940 ANTICIPATED NET SEWER FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES SANITARY SEWER UTILITY BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $903,025 $538,630 60% $364,395 SUPPLIES $77,675 $43,182 56% $34,493 CHARGES FOR SERVICES $870,525 $659,861 76% $210,664 OTHER OPER EXPENSES $6,084,950 $4,553,320 75% $1,531,630 DATA PROCESSING $83,125 $62,275 75% $20,850 NON OPERATING EXPENSE $2,454,475 $1,974,375 80% $480,100 CAPITAL OUTLAY $6,613,957 $507,079 8% $6,106,878 OTHER FINANCING USES $1,367,850 $927,000 68% $440,850 TOTAL $18,455,582 $9,265,722 50% $9,189,860 Other Financing Uses is budgeted profit from operations Profit/(Loss) to date (encumbrances not included) ‐$929,079 Cash in Bank December 31, 2016 $14,186,942 Cash in Bank March 31, 2017 $14,564,318 At this time, it is expected revenue will meet projections EXCESS (SHORTAGE) EXCESS (SHORTAGE) SANITARY SEWER FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 PROJECTED RECEIPTS OGDEN CITY Includes use of retained earnings for capital outlay PROJECTED RECEIPTS ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH SANITARY SEWER FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 10,946,775 $ 2,882,028 $ 2,734,376 2,694,781 8,311,185 75.9% Miscellaneous income 12,150 230 300 360 890 7.3% Total revenue 10,958,925 2,882,258 2,734,676 2,695,141 8,312,075 75.8% OPERATING EXPENSES: Personal services: Salaries and wages 594,300 113,498 114,059 139,170 366,727 61.7% Benefits 309,025 52,851 51,858 67,358 172,067 55.7% Supplies: Office supplies 725 107 - - 107 14.8% Operating supplies 66,950 7,853 15,384 13,003 36,240 54.1% Repair and maintenance supplies 4,175 225 150 418 793 19.0% Charges for services: Sewer district charges 4,991,150 1,259,020 1,247,788 1,270,772 3,777,580 75.7% Public utility services 3,075 828 753 753 2,334 75.9% Travel and education 4,000 - 144 741 885 22.1% Contracted agreements 728,475 146,925 160,182 214,696 521,803 71.6% Other operating expenses: Rental charges 47,475 11,925 11,850 11,850 35,625 75.0% Fiscal charges 1,884,950 471,050 471,300 471,300 1,413,650 75.0% Depreciation 450,000 - 290,437 143,378 433,815 96.4% Data processing and computer equipment 83,125 20,575 20,850 20,850 62,275 74.9% Maintenance and repair 539,975 198,103 65,884 60,764 324,751 60.1% Vehicle operating expenses 155,600 60,108 30,377 31,391 121,876 78.3% Miscellaneous 41,250 - 348 43 391 0.9% Total operating expenses 9,904,250 2,343,068 2,481,364 2,446,487 7,270,919 73.4% Operating income (loss) 1,054,675 539,190 253,312 248,654 1,041,156 98.7% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 143,000 984 - 23,585 24,569 17.2% Expenses: Other (return to fund balance) (440,850) - - - - 0.0% Capital improvements (6,613,957) - (466,580) (40,499) (507,079) 7.7% Debt service - Principal (260,200) (99,988) (106,808) (80,800) (287,596) 110.5% Interest expense (309,325) (77,988) (133,950) (61,191) (273,129) 88.3% Total non-operating revenues (expenses) (7,481,332) (176,992) (707,338) (158,905) (1,043,235) 13.9% Income before operating transfers (6,426,657) 362,198 (454,026) 89,749 (2,079) 0.0% Transfers in (use of fund balance) 7,353,657 - - - - 0.0% Transfers out (927,000) (15,000) (912,000) - (927,000) 100.0% Change in net assets - 377,198 $ (1,366,026) 89,749 (929,079) Cash Summary: Cash, Beginning of quarter $ 14,709,182 $ 14,834,937 14,186,942 Cash, End of quarter $ 14,834,937 $ 14,186,942 14,564,318 ---PAGE BREAK--- REFUSE FUND ‐ 5120 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $5,521,400 $4,143,589 75% $1,377,811 $1,377,811 $0 OTHER REVENUE CATEGORIES PROJECTED 6,7,&8 BUDGET RECEIVED PERCENT BALANCE RECEIPTS $4,000 $29,749 744% ($25,749) $0 $25,749 FUND TOTALS $5,525,400 $4,173,337 76% $1,352,063 $1,377,811 ANTICIPATED NET REFUSE FUND REVENUES OVER (SHORT) of BUDGET $25,749 EXPENDITURES REFUSE BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $1,118,050 $775,324 69% $342,726 SUPPLIES $196,075 $73,042 37% $123,033 CHARGES FOR SERVICES $1,360,200 $778,893 57% $581,307 OTHER OPER EXPENSES $1,159,625 $1,105,381 95% $54,244 DATA PROCESSING $61,075 $45,775 75% $15,300 NON OPERATING EXPENSE $978,650 $734,000 75% $244,650 CAPITAL OUTLAY $75,000 $54,622 73% $20,378 OTHER FINANCING USES $576,725 $0 0% $576,725 TOTAL $5,525,400 $3,567,037 65% $1,958,363 Other Financing Uses is budgeted profit from operations Profit/(Loss) to date (encumbrances not included) $606,300 Cash in Bank December 31, 2016 $2,848,214 Cash in Bank March 31, 2017 $3,151,172 EXCESS (SHORTAGE) EXCESS (SHORTAGE) At this time, it is expected revenue will meet projections PROJECTED RECEIPTS OGDEN CITY REFUSE FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH REFUSE FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 5,521,400 $ 1,380,730 $ 1,384,120 1,378,738 4,143,588 75.0% Miscellaneous income 3,000 - - - - 0.0% Total revenue 5,524,400 1,380,730 1,384,120 1,378,738 4,143,588 75.0% OPERATING EXPENSES: Personal services: Salaries and wages 761,225 174,279 184,021 168,379 526,679 69.2% Benefits 357,450 81,786 81,867 85,484 249,137 69.7% Supplies: Office supplies 1,700 309 212 334 855 50.3% Operating supplies 18,275 4,817 10,113 738 15,668 85.7% Repair and maintenance supplies 2,900 500 450 450 1,400 48.3% Charges for services: Disposal charges 1,075,300 118,620 308,708 165,869 593,197 55.2% Public utility services 2,475 675 600 600 1,875 75.8% Travel and education 6,725 66 - 1,684 1,750 26.0% Contracted agreements 149,950 12,837 13,033 54,109 79,979 53.3% Other operating expenses: Rental charges 64,275 16,125 16,050 16,050 48,225 75.0% Fiscal charges 1,144,300 286,150 286,050 286,050 858,250 75.0% Depreciation 45,000 - 21,059 10,529 31,588 70.2% Data processing and computer equipment 61,075 15,175 15,300 15,300 45,775 74.9% Maintenance and repair 122,500 19,201 31,990 37,950 89,141 72.8% Vehicle operating expenses 880,400 295,873 350,298 324,410 970,581 110.2% Miscellaneous 255,125 14,334 15,578 23,025 52,937 20.7% Total operating expenses 4,948,675 1,040,747 1,335,329 1,190,961 3,567,037 72.1% Operating income (loss) 575,725 339,983 48,791 187,777 576,551 100.1% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 1,000 25,014 - 4,735 29,749 2974.9% Expenses: Other - - - - - 0.0% Total non-operating revenues (expenses) 1,000 25,014 - 4,735 29,749 2974.9% Income before operating transfers 576,725 364,997 48,791 192,512 606,300 0.0% Transfers out (return to retained earnings) (576,725) - - - - 0.0% Change in net assets - 364,997 $ 48,791 192,512 606,300 Cash Summary: Cash, Beginning of quarter $ 1,884,529 $ 2,783,660 2,848,214 Cash, End of quarter $ 2,783,660 $ 2,848,214 3,151,172 ---PAGE BREAK--- HINCKLEY AIRPORT FUND ‐ 5130 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $1,000,000 $173,687 17% $826,313 $826,313 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $496,500 $372,367 75% $124,133 $124,133 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $3,990,586 $1,775,254 44% $2,215,332 $2,215,332 $0 FUND TOTALS $5,487,086 $2,321,308 42% $3,165,778 $3,165,778 ANTICIPATED NET AIRPORT FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES AIRPORT BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $608,475 $360,934 59% $247,541 SUPPLIES $40,600 $28,461 70% $12,139 CHARGES FOR SERVICES $135,454 $85,673 63% $49,781 OTHER OPER EXPENSES $2,454,750 $1,167,160 48% $1,287,590 DATA PROCESSING $17,300 $13,300 77% $4,000 DEBT SERVICE $115,425 $86,550 75% $28,875 CAPITAL OUTLAY $2,115,082 $416,496 20% $1,698,586 TOTAL $5,487,086 $2,158,573 39% $3,328,513 Capital outlay expense is related to FAA grants. Profit/(Loss) to date (encumbrances not included) $162,735 Cash in Bank December 31, 2016 ($567,155) Cash in Bank March 31, 2017 $1,013,495 EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) The major item in this category is land rental which is received in January PROJECTED RECEIPTS PROJECTED RECEIPTS PROJECTED RECEIPTS OGDEN CITY AIRPORT FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 Intergovernmental revenue generally requires the Airport fund to incure the expenses before reimbursements are drawn down. Generally federal funding is related to taxiway maintenance. Includes use of retained earnings, the majority of which represents depreciation the airport fund will have during FY17 and contribution from the General Fund. Additionally, during March a budget opening for airline subsidy support and an interfund loan from the BDO fund were appropriated and included in this category. ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH AIRPORT FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 501,500 $ 45,365 $ 73,211 $ 255,708 374,284 74.6% Grants and donations 1,000,000 (243,936) (2,095) 419,718 173,687 17.4% Miscellaneous income 21,000 5,410 15,340 630 21,380 101.8% Total revenue 1,522,500 (193,161) 86,456 676,056 569,351 37.4% OPERATING EXPENSES: Personal services: Salaries and wages 477,625 79,644 79,242 98,406 257,292 53.9% Benefits 130,850 32,286 32,341 39,015 103,642 79.2% Supplies: Office supplies 3,850 623 700 120 1,443 37.5% Operating supplies 30,175 1,599 8,549 11,082 21,230 70.4% Repair and maintenance supplies 11,825 4,527 1,842 3,318 9,687 81.9% Charges for services: Public utility services 70,775 6,792 16,508 19,142 42,442 60.0% Travel and education 19,000 557 8,209 5,028 13,794 72.6% Contracted agreements 1,220,679 17,146 11,420 13,621 42,187 3.5% Other operating expenses: Rental charges 2,550 525 675 675 1,875 73.5% Depreciation 1,100,000 - 673,327 336,664 1,009,991 91.8% Data processing and computer equipment 17,300 4,390 4,420 4,490 13,300 76.9% Maintenance and repair 134,850 6,928 18,708 85,080 110,716 82.1% Vehicle operating expenses 95,700 688 13,651 11,358 25,697 26.9% Miscellaneous 16,400 826 655 750 2,231 13.6% Total operating expenses 3,331,579 156,531 870,247 628,749 1,655,527 49.7% Operating income (loss) (1,809,079) (349,692) (783,791) 47,307 (1,086,176) 60.0% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 500 - - (943) (943) -188.6% Loans from other funds 50,000 - - 50,000 50,000 100.0% Expenses: Capital Improvements (2,040,082) (68,500) (216,004) (131,992) (416,496) 20.4% Debt Service - Principal (115,425) (28,800) (28,875) (28,875) (86,550) 75.0% Total non-operating revenues (expenses) (2,105,007) (97,300) (244,879) (111,810) (453,989) 21.6% Income before operating transfers (3,914,086) (446,992) (1,028,670) (64,503) (1,540,165) 39.3% Transfers in (or use of retained earnings) 3,914,086 278,500 142,200 1,282,200 1,702,900 43.5% Change in net assets - (168,492) $ (886,470) 1,217,697 162,735 Cash Summary: Cash, Beginning of quarter $ (385,490) $ (340,430) $ (567,155) Cash, End of quarter $ (340,430) $ (567,155) $ 1,013,495 ---PAGE BREAK--- GOLF FUND ‐ 5150 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $1,096,000 $550,853 50% $545,147 $545,147 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $597,770 $233,807 39% $363,963 $363,963 $0 FUND TOTALS $1,693,770 $784,660 46% $909,110 $909,110 ANTICIPATED NET GOLF FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES GOLF COURSES BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $629,450 $424,345 67% $205,105 SUPPLIES $80,625 $24,875 31% $55,750 CHARGES FOR SERVICES $138,300 $89,680 65% $48,620 OTHER OPER EXPENSES $423,800 $332,980 79% $90,820 DATA PROCESSING $11,200 $8,350 75% $2,850 NON OPERATING EXPENSE $133,650 $100,200 75% $33,450 CAPITAL OUTLAY $276,745 $24,815 9% $251,930 TOTAL $1,693,770 $1,005,244 59% $688,526 Profit/(Loss) to date (encumbrances not included) ($220,584) Cash in Bank December 31, 2016 $21,298 Cash in Bank March 31, 2017 ‐$186,955 OGDEN CITY GOLF FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 Includes a transfer for the sprinkler system CIP and use of retained earnings PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH GOLF FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 1,096,000 $ 374,872 $ 114,154 61,827 550,853 50.3% Miscellaneous income 6,000 1,354 1,005 4,161 6,520 108.7% Total revenue 1,102,000 376,226 115,159 65,988 557,373 50.6% OPERATING EXPENSES: Cost of materials and parts 143,400 23,127 10,947 40,730 74,804 52.2% Personal services: Salaries and wages 490,900 151,257 95,587 73,322 320,166 65.2% Benefits 138,550 37,903 32,694 33,579 104,176 75.2% Supplies: Office supplies 2,900 437 462 138 1,037 35.8% Operating supplies 47,150 4,008 3,993 5,920 13,921 29.5% Repair and maintenance supplies 1,000 93 - 137 230 23.0% Charges for services: Public utility services 89,225 27,617 17,614 7,889 53,120 59.5% Travel and education 3,325 - - 1,119 1,119 33.7% Contracted agreements 55,575 60 - 35,377 35,437 63.8% Other operating expenses: Depreciation 55,000 - 73,604 36,802 110,406 200.7% Data processing and computer equipment 11,200 2,650 2,850 2,850 8,350 74.6% Maintenance and repair 16,050 5,645 5,782 (12,773) (1,346) -8.4% Vehicle operating expenses 197,350 38,142 42,430 51,486 132,058 66.9% Miscellaneous 34,250 2,297 23,350 1,104 26,751 78.1% Total operating expenses 1,285,875 293,236 309,313 277,680 880,229 68.5% Operating income (loss) (183,875) 82,990 (194,154) (211,692) (322,856) 175.6% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 1,000 - - 37 37 0.0% Gain on sale of assets - - - - - 0.0% Expenses: Capital improvements (274,245) (13,935) (10,285) (595) (24,815) 9.0% Debt service - principal (133,650) (33,300) (33,450) (33,450) (100,200) 75.0% Interest expense - - - - - Total non-operating revenues (expenses) (406,895) (47,235) (43,735) (34,008) (124,978) 30.7% Income before operating transfers (590,770) 35,755 (237,889) (245,700) (447,834) 75.8% Transfers in (use of fund balance) 590,770 227,250 - - 227,250 38.5% Change in net assets - 263,005 $ (237,889) (245,700) (220,584) Cash Summary: Cash, Beginning of Quarter $ (28,535) $ 184,218 $ 21,298 Cash, Ending of Quarter $ 184,218 $ 21,298 $ (186,955) ---PAGE BREAK--- RECREATION ENTERPRISE FUND ‐ 5160 REVENUE CHAREGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $230,525 $168,233 73% $62,292 $62,292 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $42,825 0% $42,829 $42,829 $0 FUND TOTALS $273,350 $168,229 62% $105,121 $105,121 ANTICIPATED NET RECREATION FUND REV OVER (SHORT) of BUDGET $0 EXPENDITURES RECREATION ENTERPRISE BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $65,100 $18,405 28% $46,695 SUPPLIES $50,325 $52,570 104% ($2,245) CHARGES FOR SERVICES $99,850 $79,707 80% $20,143 OTHER OPER EXPENSES $46,550 $32,883 71% $13,667 NON OPERATING EXPENSE $11,525 $8,675 75% $2,850 TOTAL $273,350 $192,239 70% $81,111 Profit/(Loss) to date (encumbrances not included) ($24,010) Cash in Bank December 31, 2016 ‐$2,687 Cash in Bank March 31, 2017 $49,566 OGDEN CITY RECREATION FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 PROJECTED RECEIPTS Includes interest revenue and use of retained earnings PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) ---PAGE BREAK--- OGDEN CITY COUNCIL TRANSMITTAL Date: May 1, 2017 To: Ogden City Council From: Lisa Stout, Comptroller RE: Financial Quarterly Report Staff Contact: Lisa Stout, Comptroller, extension 8713 Recommendation: Accept for review Document(s): Ogden City Financial Quarterly Report Executive Summary The attached Financial Quarterly Report for the quarter ended March 31st, includes the following: Fund Revenue & Expenditure Summary General Fund Revenue Summary General Fund Departmental Expenditure Summary Special Assessment Funds Revenue & Expenditure Summary Capital Improvement Fund Revenue & Expenditure Summary Enterprise Funds Revenue & Expenditure Summary with Statement of Revenues, Expenses, & Cash Statement Internal Service Funds Revenue & Expenditure Summary Trust Funds Financial Information Grant Funds Financial Information RDA Fund Financial Information MBA Fund Financial Information Background Please note the following: The data used to create this report is unaudited Proposal Accept for review and discussion at a work session as needed. Fiscal Impact No fiscal impact. ---PAGE BREAK--- BUDGET ACTUAL PERCENT BALANCE GENERAL FUND REVENUE 59,109,503 42,472,651 72% 16,636,852 EXPENDITURES 59,109,503 38,834,205 66% 20,275,298 ‐ 3,638,446 SPECIAL ASSESSMENT FUNDS REVENUE 276,750 296,983 107% (20,233) EXPENDITURES 276,750 167,493 61% 109,257 ‐ 129,490 CAPITAL IMPROVEMENTS FUND REVENUE 26,085,747 4,362,627 17% 21,723,120 EXPENDITURES 26,085,747 8,492,694 33% 17,593,053 ‐ (4,130,068) WATER UTILITY FUND REVENUE 46,307,240 16,449,112 36% 29,858,128 EXPENDITURES 46,307,240 18,823,199 41% 27,484,041 ‐ (2,374,087) SANITARY SEWER UTILITY FUND REVENUE 18,455,582 8,336,643 45% 10,118,939 EXPENDITURES 18,455,582 9,265,722 50% 9,189,860 ‐ (929,079) REFUSE UTILITY FUND REVENUE 5,525,400 4,173,337 76% 1,352,063 EXPENDITURES 5,525,400 3,567,037 65% 1,958,363 ‐ 606,300 HINCKLEY AIRPORT FUND REVENUE 5,487,086 2,321,308 42% 3,165,778 EXPENDITURES 5,487,086 2,158,573 39% 3,328,513 ‐ 162,735 GOLF FUND REVENUE 1,693,770 784,660 46% 909,110 EXPENDITURES 1,693,770 1,005,244 59% 688,526 ‐ (220,584) RECREATION ENTERPRISE FUND REVENUE 273,350 168,229 62% 105,121 EXPENDITURES 273,350 192,239 70% 81,111 ‐ (24,010) PROPERTY MANAGEMENT FUND ‐ BDO REVENUE 20,132,950 3,169,000 16% 16,963,950 EXPENDITURES 20,132,950 14,449,079 72% 5,683,871 ‐ (11,280,079) OGDEN CITY FUND REVENUE & EXPENDITURE SUMMARY As of March 31, 2017 1 of 2 ---PAGE BREAK--- BUDGET ACTUAL PERCENT BALANCE OGDEN CITY FUND REVENUE & EXPENDITURE SUMMARY As of March 31, 2017 STORM SEWER FUND REVENUE 12,352,754 3,498,995 28% 8,853,759 EXPENDITURES 12,352,754 2,903,950 24% 9,448,804 ‐ 595,045 MEDICAL FUND REVENUE 7,799,425 5,097,482 65% 2,701,943 EXPENDITURES 7,799,425 4,600,164 59% 3,199,261 ‐ 497,318 FACILITIES/FLEET/STORES FUND REVENUE 13,137,713 7,344,955 56% 5,792,758 EXPENDITURES 13,137,713 8,837,204 67% 4,300,509 ‐ (1,492,249) MANAGEMENT INFORMATION SYSTEMS FUND REVENUE 6,140,546 4,048,998 66% 2,091,548 EXPENDITURES 6,140,546 4,070,525 66% 2,070,021 ‐ (21,527) RISK MANAGEMENT FUND REVENUE 1,604,500 1,291,856 81% 312,644 EXPENDITURES 1,604,500 1,198,278 75% 406,222 ‐ 93,578 NICHOLAS & CEMETERY TRUST FUNDS REVENUE 194,350 16,376 8% 177,974 EXPENDITURES 194,350 3,069 2% 191,281 ‐ 13,307 MISCELLANEOUS GRANTS & DONATIONS FUND REVENUE 569,571 (140,434) ‐25% 710,005 EXPENDITURES 569,571 165,219 29% 404,352 ‐ (305,653) MAJOR GRANTS FUND REVENUE 11,227,310 5,481,588 49% 5,745,722 EXPENDITURES 11,227,310 5,715,881 51% 5,511,429 ‐ (234,293) REDEVELOPMENT AGENCY REVENUE 27,168,935 17,367,183 64% 9,801,752 EXPENDITURES 27,168,935 11,467,542 42% 15,701,393 ‐ 5,899,641 MUNICIPAL BUILDING AUTHORITY REVENUE 550,475 409,797 74% 140,678 EXPENDITURES 550,475 509,582 93% 40,893 ‐ (99,785) TOTAL ALL FUNDS AND AGENCIES REVENUE 264,092,957 $ 126,951,346 $ 48% 137,141,611 $ EXPENDITURES 264,092,957 $ 136,426,900 $ 52% 127,666,057 $ $0 ($9,475,554) 2 of 2 ---PAGE BREAK--- TAXES 1 BUDGET RECEIVED PERCENT BALANCE $36,791,500 $27,004,626 73% $9,786,874 $9,686,874 ($100,000) LICENSES AND PERMITS 2 BUDGET RECEIVED PERCENT BALANCE $2,529,775 $2,083,112 82% $446,663 $446,663 $0 INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $5,547,215 $3,724,136 67% $1,823,079 $1,823,079 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $3,853,100 $3,090,918 80% $762,182 $762,182 $0 FINES AND FORFEITURES 5 BUDGET RECEIVED PERCENT BALANCE $2,299,875 $1,703,927 74% $595,948 $500,948 ($95,000) OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE 8,088,038 4,865,932 60% $3,222,106 $3,222,107 $0 FUND TOTALS $59,109,503 $42,472,651 72% $16,636,852 $16,441,853 ANTICIPATED NET GENERAL FUND REVENUES OVER (SHORT) of BUDGET ($195,000) EXCESS (SHORTAGE) PROJECTED RECEIPTS The majority of business license revenue is received during November through February. It is anticipated the revenue accounted for as licenses and permits will meet budgeted expectations. At this time, it is anticipated that Parking Violations could be $95,000 short. Revenue projections are expected to be met. PROJECTED RECEIPTS EXCESS (SHORTAGE) OGDEN CITY GENERAL FUND REVENUE SUMMARY As of March 31, 2017 PROJECTED RECEIPTS EXCESS (SHORTAGE) GENERAL FUND ‐ 1000 PROJECTED RECEIPTS PROJECTED RECEIPTS PROJECTED RECEIPTS Telecommunication taxes are expected to come in under budget by approximately $100,000. Most grants require reports of actual expenditures before reimbursement. B&C road fund and active transportation funds are included in this category and make up the majority of this revenue class. Class B&C Road Funds are received quarterly, active transportation tax is received and beer tax is received in November. The receipt of this revenue lags behind and is anticipated to meet budget expectations. EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) ---PAGE BREAK--- GENERAL FUND MAYOR BUDGET EXPENDED PERCENT BALANCE 100 PERSONNEL SERVICES 570,525 399,015 70% 171,510 SUPPLIES 16,975 9,340 55% 7,635 CHARGES FOR SERVICES 41,750 27,064 65% 14,686 OTHER OPER EXPENSES 16,575 1,240 7% 15,335 TOTAL 645,825 $ 436,659 $ 68% 209,166 $ COUNCIL BUDGET EXPENDED PERCENT BALANCE 150 PERSONNEL SERVICES 904,500 705,715 78% 198,785 SUPPLIES 5,550 2,009 36% 3,541 CHARGES FOR SERVICES 263,225 99,718 38% 163,507 OTHER OPER EXPENSES 53,300 37,585 71% 15,715 TOTAL 1,226,575 $ 845,027 $ 69% 381,548 $ MANAGEMENT SERVICES BUDGET EXPENDED PERCENT BALANCE 200 PERSONNEL SERVICES 3,597,100 2,565,216 71% 1,031,884 SUPPLIES 103,825 54,486 52% 49,339 CHARGES FOR SERVICES 783,725 482,748 62% 300,977 OTHER OPER EXPENSES 114,100 51,688 45% 62,412 CAPITAL OUTLAY 3,015 9,650 320% (6,635) TOTAL 4,601,765 $ 3,163,787 $ 69% 1,437,978 $ CITY ATTORNEY BUDGET EXPENDED PERCENT BALANCE 250 PERSONNEL SERVICES 1,150,250 855,432 74% 294,818 SUPPLIES 14,325 9,623 67% 4,702 CHARGES FOR SERVICES 115,715 34,936 30% 80,779 OTHER OPER EXPENSES 11,525 7,142 62% 4,383 TOTAL 1,291,815 $ 907,133 $ 70% 384,682 $ NON DEPARTMENTAL BUDGET EXPENDED PERCENT BALANCE 300 PERSONNEL SERVICES 200,000 ‐ 0% 200,000 CHARGES FOR SERVICES 1,873,400 919,187 49% 954,213 OTHER OPER EXPENSES 1,427,700 900,532 63% 527,168 DATA PROCESSING 1,741,775 1,306,325 75% 435,450 DEBT SERVICE 247,325 113,327 46% 133,998 CAPITAL OUTLAY 161,800 136,049 84% 25,751 INTERFUND TRANSFERS 1,920,350 1,408,325 73% 512,025 TOTAL 7,572,350 $ 4,783,746 $ 63% 2,788,604 $ POLICE BUDGET EXPENDED PERCENT BALANCE 350 PERSONNEL SERVICES 17,558,650 12,044,586 69% 5,514,064 SUPPLIES 875,845 484,986 55% 390,859 CHARGES FOR SERVICES 1,147,175 423,442 37% 723,733 OTHER OPER EXPENSES 924,925 650,494 70% 274,431 TOTAL 20,506,595 $ 13,603,508 $ 66% 6,903,087 $ OGDEN CITY GENERAL FUND DEPARTMENTAL EXPENDITURE SUMMARY As of March 31, 2017 As a reminder, the $200,000 in Personnel in Non‐Departmental is the Contingency for vacation buy‐back. Debt service is not paid evenly throughout the fiscal year. 1 of 3 ---PAGE BREAK--- GENERAL FUND OGDEN CITY GENERAL FUND DEPARTMENTAL EXPENDITURE SUMMARY As of March 31, 2017 FIRE BUDGET EXPENDED PERCENT BALANCE 400 PERSONNEL SERVICES 7,371,350 5,352,524 73% 2,018,826 SUPPLIES 187,638 71,661 38% 115,977 CHARGES FOR SERVICES 79,900 43,774 55% 36,126 OTHER OPER EXPENSES 313,656 256,168 82% 57,488 CAPITAL OUTLAY 29,000 16,794 58% 12,206 TOTAL 7,981,544 $ 5,740,920 $ 72% 2,240,624 $ PUBLIC SERVICES PUBLIC SERVICES ADMIN BUDGET EXPENDED PERCENT BALANCE 850100 PERSONNEL SERVICES 464,200 243,181 52% 221,019 SUPPLIES 94,050 14,545 15% 79,505 CHARGES FOR SERVICES 13,525 6,577 49% 6,948 OTHER OPER EXPENSES 47,125 33,841 72% 13,284 TOTAL 618,900 $ 298,145 $ 48% 320,755 $ PARKS/CEMETERY BUDGET EXPENDED PERCENT BALANCE 850200 PERSONNEL SERVICES 1,922,450 1,270,090 66% 652,360 SUPPLIES 244,055 119,642 49% 124,413 CHARGES FOR SERVICES 612,600 506,427 83% 106,173 OTHER OPER EXPENSES 435,950 282,196 65% 153,754 TOTAL 3,215,055 $ 2,178,355 $ 68% 1,036,700 $ RECREATION BUDGET EXPENDED PERCENT BALANCE 850400 PERSONNEL SERVICES 910,000 687,827 76% 222,173 SUPPLIES 111,475 58,520 52% 52,955 CHARGES FOR SERVICES 439,675 191,709 44% 247,966 OTHER OPER EXPENSES 95,125 51,185 54% 43,940 DATA PROCESSING 11,050 6,114 55% 4,936 TOTAL 1,567,325 $ 995,355 $ 64% 571,970 $ CHRISTMAS VILLAGE & AMPHITHEATRE BUDGET EXPENDED PERCENT BALANCE 850800 PERSONNEL SERVICES 140,475 129,890 92% 10,585 SUPPLIES 34,500 35,595 103% (1,095) CHARGES FOR SERVICES 10,000 9,025 90% 975 OTHER OPER EXPENSES 64,500 44,858 70% 19,642 TOTAL 249,475 $ 219,368 $ 88% 30,107 $ STREETS BUDGET EXPENDED PERCENT BALANCE 855200 PERSONNEL SERVICES 1,234,550 951,407 77% 283,143 SUPPLIES 173,850 62,393 36% 111,457 CHARGES FOR SERVICES 541,775 347,985 64% 193,790 OTHER OPER EXPENSES 1,321,275 760,347 58% 560,928 TOTAL 3,271,450 $ 2,122,132 $ 65% 1,149,318 $ Christmas Village is a seasonal activity, it is epected that the expenditures are primarily during the 2nd quarter of the year. 2 of 3 ---PAGE BREAK--- GENERAL FUND OGDEN CITY GENERAL FUND DEPARTMENTAL EXPENDITURE SUMMARY As of March 31, 2017 ENGINEERING BUDGET EXPENDED PERCENT BALANCE 855300 PERSONNEL SERVICES 961,075 747,487 78% 213,588 SUPPLIES 13,700 4,875 36% 8,825 CHARGES FOR SERVICES 516,675 (473,534) ‐92% 990,209 OTHER OPER EXPENSES 49,004 26,436 54% 22,568 TOTAL 1,540,454 $ 305,265 $ 20% 1,235,189 $ COMMUNITY & ECONOMIC DEVELOPMENT BUDGET EXPENDED PERCENT BALANCE 550 PERSONNEL SERVICES 3,734,875 2,638,521 71% 1,096,354 SUPPLIES 77,650 52,471 68% 25,179 CHARGES FOR SERVICES 343,000 246,341 72% 96,659 OTHER OPER EXPENSES 573,700 214,019 37% 359,681 DATA PROCESSING ‐ 100 (100) CAPITAL OUTLAY 91,150 83,353 91% 7,797 TOTAL 4,820,375 $ 3,234,806 $ 67% 1,585,569 $ GENERAL FUND TOTALS 59,109,503 38,834,205 66% 20,275,298 Charges for services budget and expenses are negative due to a reclassification of expenses to the Utility Funds. 3 of 3 ---PAGE BREAK--- SPECIAL ASSESSMENTS FUNDS ‐ 2100 & 3100 REVENUE TAXES 1 BUDGET RECEIVED PERCENT BALANCE $275,000 $292,876 107% ‐$17,876 $0 $17,876 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $1,750 $4,107 235% ($2,357) $0 $2,357 FUND TOTALS $276,750 $296,983 107% ($20,233) $0 ANTICIPATED NET SPEC REVENUE FDS REV OVER (SHORT) of BUDGET $20,233 EXPENDITURES SPECIAL ASSESSMENTS BUDGET EXPENDED PERCENT BALANCE CHARGES FOR SERVICES $149,250 $96,722 65% $52,528 OTHER OPER EXPENSES $70,000 $70,000 100% $0 OTHER FINANCING USES $57,500 $771 1% $56,729 TOTAL $276,750 $168,264 61% $108,486 PROJECTED RECEIPTS EXCESS (SHORTAGE) PROJECTED RECEIPTS EXCESS (SHORTAGE) Includes transient room taxes and the downtown special assessment levy. The special assessment levy is being billed by the County and the revenue estimated was received in December, when property taxes are collected. OGDEN CITY SPECIAL ASSESSMMENT FUNDS REVENUE & EXPENSE SUMMARY As of March 31, 2017 Interest income is the revenue source accounted for as other revenue in these funds ---PAGE BREAK--- CAPITAL IMPROVEMENT FUND ‐ 4100 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $83,000 $549,033 661% ($466,033) $0 $466,033 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $0 $37,500 ($37,500) $0 $37,500 Payment from Dino Park to be used for Trails. A budget opening to recognize this revenue is need for FY17 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $26,002,747 $3,776,094 15% $22,226,653 $21,760,620 ($466,033) FUND TOTALS $26,085,747 $4,362,627 17% $21,723,120 $21,760,620 ANTICIPATED NET CIP FUND REVENUES OVER (SHORT) of BUDGET $37,500 EXPENDITURES CAPITAL IMPROVEMENTS BUDGET EXPENDED PERCENT BALANCE MANAGEMENT SERVICES $916,841 $82,935 9% $833,906 NON DEPARTMENTAL $1,435,734 $326,089 23% $1,109,645 FIRE $104,134 $7,177 7% $96,957 PUBLIC SERVICES $23,346,046 $8,076,493 35% $15,269,553 TOTAL $26,085,747 $8,492,694 33% $17,593,053 Detail expenditures by project are provided in the CIP quarterly report Revenue accounted for as other revenue includes a road funds and active transportation funds transfer from the general fund, a transfer from the BDO fund, a transfer from the Gomer Nicholas Endowment Fund for parks and interest income. The CIP projects carryovers from FY 2016 is also included in this revenue category. PROJECTED RECEIPTS PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS EXCESS (SHORTAGE) OGDEN CITY CAPITAL IMPROVEMENT FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 RAMP funds are included in this category. A budget for WACOG funds had been appropriated in FY2016. The current revenue in excess of the budget is from carry forward WACOG revenue and is represented in the other reveue category. ---PAGE BREAK--- WATER UTILITY FUND ‐ 5100 REVENUE TAXES 1 BUDGET RECEIVED PERCENT BALANCE $864,600 $0 0% $864,600 $864,600 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $19,140,975 $15,590,987 81% $3,549,988 $3,549,988 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $26,301,665 $47,622 0% $26,254,043 $26,254,043 $0 FUND TOTALS $46,307,240 $16,449,112 36% $29,858,128 $29,858,128 ANTICIPATED NET WATER FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES WATER UTILITY BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $4,034,100 $2,864,833 71% $1,169,267 SUPPLIES $1,086,850 $839,509 77% $247,341 CHARGES FOR SERVICES $1,996,675 $1,164,984 58% $831,691 OTHER OPER EXPENSES $5,008,125 $3,261,633 65% $1,746,492 DATA PROCESSING $526,125 $316,519 60% $209,606 NON OPERATING EXPENSE $7,406,200 $6,827,740 92% $578,460 CAPITAL OUTLAY $26,209,165 $3,507,983 13% $22,701,182 OTHER FINANCING USES $40,000 $40,000 100% $0 TOTAL $46,307,240 $18,823,199 41% $27,484,041 Other Financing Uses is a transfer for percent for arts Profit/(Loss) to date (encumbrances not included) ($2,374,087) Cash in Bank December 31, 2016 $10,986,168 Cash in Bank March 31, 2017 $9,949,659 This is a budget to for a end of year adjustments. It is to recognize Weber Basin Water District tax revenue collect directly by Weber Basin to provide for Ogden City costs. At this time, it is expected revenue will meet projections As of March 31, 2017 EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) Includes bond proceeds of $17,000,000 and use of retained earnings for capital outlay PROJECTED RECEIPTS PROJECTED RECEIPTS PROJECTED RECEIPTS OGDEN CITY WATER FUND REVENUE & EXPENSE SUMMARY ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH WATER FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 18,284,575 $ 6,953,815 $ 4,178,399 3,816,448 $ 14,948,662 81.8% Special district taxes 864,600 - - - - 0.0% Accounting charges 856,400 214,025 214,178 214,125 642,328 75.0% Grants and donations - - - 810,503 810,503 0.0% Miscellaneous income 17,007,500 11 20 1,192 1,223 0.0% Total revenue 37,013,075 7,167,851 4,392,597 4,842,268 16,402,716 44.3% OPERATING EXPENSES: Personal services: Salaries and wages 2,614,550 590,481 582,708 691,141 1,864,330 71.3% Benefits 1,422,700 318,819 317,766 365,581 1,002,166 70.4% Supplies: Office supplies 241,600 35,203 54,587 47,287 137,077 56.7% Operating supplies 592,450 177,738 213,145 64,467 455,350 76.9% Repair and maintenance supplies 274,150 130,246 88,604 100,907 319,757 116.6% Charges for services: Public utility services 648,600 119,524 148,676 138,208 406,408 62.7% Travel and education 71,000 12,300 11,756 42,216 66,272 93.3% Contracted agreements 1,408,925 150,836 138,669 672,013 961,518 68.2% Other operating expenses: Rental charges 114,550 28,600 28,650 28,650 85,900 75.0% Fiscal charges 3,104,300 776,225 776,025 776,025 2,328,275 75.0% Depreciation 2,000,000 - 1,405,947 702,974 2,108,921 105.4% Data processing and computer equipment 526,125 106,375 105,250 104,894 316,519 60.2% Maintenance and repair 755,925 85,121 81,489 55,848 222,458 29.4% Vehicle operating expenses 479,575 106,494 101,042 109,361 316,897 66.1% Water purchase 1,013,125 - - 2,718 2,718 0.3% Miscellaneous 488,600 47,008 75,970 58,208 181,186 37.1% Total operating expenses 15,756,175 2,684,970 4,130,284 3,960,498 10,775,752 68.4% Operating income (loss) 21,256,900 4,482,881 262,313 881,770 5,626,964 26.5% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 50,000 1,359 - 19,404 20,763 41.5% Gain on sale of assets 35,000 9,021 12,381 4,231 25,633 73.2% Expenses: Capital improvements (26,209,165) (403,331) (842,452) (2,262,200) (3,507,983) 13.4% Debt service - principal (1,913,800) (712,263) (760,247) (583,977) (2,056,487) 107.5% Interest expense (2,388,100) (655,462) (1,161,634) (625,881) (2,442,977) 102.3% Total non-operating revenues (expenses) (30,426,065) (1,760,676) (2,751,952) (3,448,423) (7,961,051) 26.2% Income before operating transfers (9,169,165) 2,722,205 (2,489,639) (2,566,653) (2,334,087) 25.5% Transfers in (use of fund balance) 9,209,165 - - - - 0.0% Transfers out (40,000) (40,000) - - (40,000) 100.0% Change in net assets - 2,682,205 $ (2,489,639) (2,566,653) (2,374,087) Cash Summary: Cash, Beginning of quarter $ 9,189,593 $ 11,228,975 $ 10,986,168 Cash, End of quarter $ 11,228,975 $ 10,986,168 $ 9,949,659 ---PAGE BREAK--- SANITARY SEWER UTILITY FUND ‐ 5110 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $10,946,775 $8,311,185 76% $2,635,590 $2,635,591 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $7,508,807 $25,458 0% $7,483,349 $7,483,349 $0 FUND TOTALS $18,455,582 $8,336,643 45% $10,118,939 $10,118,940 ANTICIPATED NET SEWER FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES SANITARY SEWER UTILITY BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $903,025 $538,630 60% $364,395 SUPPLIES $77,675 $43,182 56% $34,493 CHARGES FOR SERVICES $870,525 $659,861 76% $210,664 OTHER OPER EXPENSES $6,084,950 $4,553,320 75% $1,531,630 DATA PROCESSING $83,125 $62,275 75% $20,850 NON OPERATING EXPENSE $2,454,475 $1,974,375 80% $480,100 CAPITAL OUTLAY $6,613,957 $507,079 8% $6,106,878 OTHER FINANCING USES $1,367,850 $927,000 68% $440,850 TOTAL $18,455,582 $9,265,722 50% $9,189,860 Other Financing Uses is budgeted profit from operations Profit/(Loss) to date (encumbrances not included) ‐$929,079 Cash in Bank December 31, 2016 $14,186,942 Cash in Bank March 31, 2017 $14,564,318 At this time, it is expected revenue will meet projections EXCESS (SHORTAGE) EXCESS (SHORTAGE) SANITARY SEWER FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 PROJECTED RECEIPTS OGDEN CITY Includes use of retained earnings for capital outlay PROJECTED RECEIPTS ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH SANITARY SEWER FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 10,946,775 $ 2,882,028 $ 2,734,376 2,694,781 8,311,185 75.9% Miscellaneous income 12,150 230 300 360 890 7.3% Total revenue 10,958,925 2,882,258 2,734,676 2,695,141 8,312,075 75.8% OPERATING EXPENSES: Personal services: Salaries and wages 594,300 113,498 114,059 139,170 366,727 61.7% Benefits 309,025 52,851 51,858 67,358 172,067 55.7% Supplies: Office supplies 725 107 - - 107 14.8% Operating supplies 66,950 7,853 15,384 13,003 36,240 54.1% Repair and maintenance supplies 4,175 225 150 418 793 19.0% Charges for services: Sewer district charges 4,991,150 1,259,020 1,247,788 1,270,772 3,777,580 75.7% Public utility services 3,075 828 753 753 2,334 75.9% Travel and education 4,000 - 144 741 885 22.1% Contracted agreements 728,475 146,925 160,182 214,696 521,803 71.6% Other operating expenses: Rental charges 47,475 11,925 11,850 11,850 35,625 75.0% Fiscal charges 1,884,950 471,050 471,300 471,300 1,413,650 75.0% Depreciation 450,000 - 290,437 143,378 433,815 96.4% Data processing and computer equipment 83,125 20,575 20,850 20,850 62,275 74.9% Maintenance and repair 539,975 198,103 65,884 60,764 324,751 60.1% Vehicle operating expenses 155,600 60,108 30,377 31,391 121,876 78.3% Miscellaneous 41,250 - 348 43 391 0.9% Total operating expenses 9,904,250 2,343,068 2,481,364 2,446,487 7,270,919 73.4% Operating income (loss) 1,054,675 539,190 253,312 248,654 1,041,156 98.7% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 143,000 984 - 23,585 24,569 17.2% Expenses: Other (return to fund balance) (440,850) - - - - 0.0% Capital improvements (6,613,957) - (466,580) (40,499) (507,079) 7.7% Debt service - Principal (260,200) (99,988) (106,808) (80,800) (287,596) 110.5% Interest expense (309,325) (77,988) (133,950) (61,191) (273,129) 88.3% Total non-operating revenues (expenses) (7,481,332) (176,992) (707,338) (158,905) (1,043,235) 13.9% Income before operating transfers (6,426,657) 362,198 (454,026) 89,749 (2,079) 0.0% Transfers in (use of fund balance) 7,353,657 - - - - 0.0% Transfers out (927,000) (15,000) (912,000) - (927,000) 100.0% Change in net assets - 377,198 $ (1,366,026) 89,749 (929,079) Cash Summary: Cash, Beginning of quarter $ 14,709,182 $ 14,834,937 14,186,942 Cash, End of quarter $ 14,834,937 $ 14,186,942 14,564,318 ---PAGE BREAK--- REFUSE FUND ‐ 5120 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $5,521,400 $4,143,589 75% $1,377,811 $1,377,811 $0 OTHER REVENUE CATEGORIES PROJECTED 6,7,&8 BUDGET RECEIVED PERCENT BALANCE RECEIPTS $4,000 $29,749 744% ($25,749) $0 $25,749 FUND TOTALS $5,525,400 $4,173,337 76% $1,352,063 $1,377,811 ANTICIPATED NET REFUSE FUND REVENUES OVER (SHORT) of BUDGET $25,749 EXPENDITURES REFUSE BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $1,118,050 $775,324 69% $342,726 SUPPLIES $196,075 $73,042 37% $123,033 CHARGES FOR SERVICES $1,360,200 $778,893 57% $581,307 OTHER OPER EXPENSES $1,159,625 $1,105,381 95% $54,244 DATA PROCESSING $61,075 $45,775 75% $15,300 NON OPERATING EXPENSE $978,650 $734,000 75% $244,650 CAPITAL OUTLAY $75,000 $54,622 73% $20,378 OTHER FINANCING USES $576,725 $0 0% $576,725 TOTAL $5,525,400 $3,567,037 65% $1,958,363 Other Financing Uses is budgeted profit from operations Profit/(Loss) to date (encumbrances not included) $606,300 Cash in Bank December 31, 2016 $2,848,214 Cash in Bank March 31, 2017 $3,151,172 EXCESS (SHORTAGE) EXCESS (SHORTAGE) At this time, it is expected revenue will meet projections PROJECTED RECEIPTS OGDEN CITY REFUSE FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH REFUSE FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 5,521,400 $ 1,380,730 $ 1,384,120 1,378,738 4,143,588 75.0% Miscellaneous income 3,000 - - - - 0.0% Total revenue 5,524,400 1,380,730 1,384,120 1,378,738 4,143,588 75.0% OPERATING EXPENSES: Personal services: Salaries and wages 761,225 174,279 184,021 168,379 526,679 69.2% Benefits 357,450 81,786 81,867 85,484 249,137 69.7% Supplies: Office supplies 1,700 309 212 334 855 50.3% Operating supplies 18,275 4,817 10,113 738 15,668 85.7% Repair and maintenance supplies 2,900 500 450 450 1,400 48.3% Charges for services: Disposal charges 1,075,300 118,620 308,708 165,869 593,197 55.2% Public utility services 2,475 675 600 600 1,875 75.8% Travel and education 6,725 66 - 1,684 1,750 26.0% Contracted agreements 149,950 12,837 13,033 54,109 79,979 53.3% Other operating expenses: Rental charges 64,275 16,125 16,050 16,050 48,225 75.0% Fiscal charges 1,144,300 286,150 286,050 286,050 858,250 75.0% Depreciation 45,000 - 21,059 10,529 31,588 70.2% Data processing and computer equipment 61,075 15,175 15,300 15,300 45,775 74.9% Maintenance and repair 122,500 19,201 31,990 37,950 89,141 72.8% Vehicle operating expenses 880,400 295,873 350,298 324,410 970,581 110.2% Miscellaneous 255,125 14,334 15,578 23,025 52,937 20.7% Total operating expenses 4,948,675 1,040,747 1,335,329 1,190,961 3,567,037 72.1% Operating income (loss) 575,725 339,983 48,791 187,777 576,551 100.1% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 1,000 25,014 - 4,735 29,749 2974.9% Expenses: Other - - - - - 0.0% Total non-operating revenues (expenses) 1,000 25,014 - 4,735 29,749 2974.9% Income before operating transfers 576,725 364,997 48,791 192,512 606,300 0.0% Transfers out (return to retained earnings) (576,725) - - - - 0.0% Change in net assets - 364,997 $ 48,791 192,512 606,300 Cash Summary: Cash, Beginning of quarter $ 1,884,529 $ 2,783,660 2,848,214 Cash, End of quarter $ 2,783,660 $ 2,848,214 3,151,172 ---PAGE BREAK--- HINCKLEY AIRPORT FUND ‐ 5130 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $1,000,000 $173,687 17% $826,313 $826,313 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $496,500 $372,367 75% $124,133 $124,133 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $3,990,586 $1,775,254 44% $2,215,332 $2,215,332 $0 FUND TOTALS $5,487,086 $2,321,308 42% $3,165,778 $3,165,778 ANTICIPATED NET AIRPORT FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES AIRPORT BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $608,475 $360,934 59% $247,541 SUPPLIES $40,600 $28,461 70% $12,139 CHARGES FOR SERVICES $135,454 $85,673 63% $49,781 OTHER OPER EXPENSES $2,454,750 $1,167,160 48% $1,287,590 DATA PROCESSING $17,300 $13,300 77% $4,000 DEBT SERVICE $115,425 $86,550 75% $28,875 CAPITAL OUTLAY $2,115,082 $416,496 20% $1,698,586 TOTAL $5,487,086 $2,158,573 39% $3,328,513 Capital outlay expense is related to FAA grants. Profit/(Loss) to date (encumbrances not included) $162,735 Cash in Bank December 31, 2016 ($567,155) Cash in Bank March 31, 2017 $1,013,495 EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) The major item in this category is land rental which is received in January PROJECTED RECEIPTS PROJECTED RECEIPTS PROJECTED RECEIPTS OGDEN CITY AIRPORT FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 Intergovernmental revenue generally requires the Airport fund to incure the expenses before reimbursements are drawn down. Generally federal funding is related to taxiway maintenance. Includes use of retained earnings, the majority of which represents depreciation the airport fund will have during FY17 and contribution from the General Fund. Additionally, during March a budget opening for airline subsidy support and an interfund loan from the BDO fund were appropriated and included in this category. ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH AIRPORT FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 501,500 $ 45,365 $ 73,211 $ 255,708 374,284 74.6% Grants and donations 1,000,000 (243,936) (2,095) 419,718 173,687 17.4% Miscellaneous income 21,000 5,410 15,340 630 21,380 101.8% Total revenue 1,522,500 (193,161) 86,456 676,056 569,351 37.4% OPERATING EXPENSES: Personal services: Salaries and wages 477,625 79,644 79,242 98,406 257,292 53.9% Benefits 130,850 32,286 32,341 39,015 103,642 79.2% Supplies: Office supplies 3,850 623 700 120 1,443 37.5% Operating supplies 30,175 1,599 8,549 11,082 21,230 70.4% Repair and maintenance supplies 11,825 4,527 1,842 3,318 9,687 81.9% Charges for services: Public utility services 70,775 6,792 16,508 19,142 42,442 60.0% Travel and education 19,000 557 8,209 5,028 13,794 72.6% Contracted agreements 1,220,679 17,146 11,420 13,621 42,187 3.5% Other operating expenses: Rental charges 2,550 525 675 675 1,875 73.5% Depreciation 1,100,000 - 673,327 336,664 1,009,991 91.8% Data processing and computer equipment 17,300 4,390 4,420 4,490 13,300 76.9% Maintenance and repair 134,850 6,928 18,708 85,080 110,716 82.1% Vehicle operating expenses 95,700 688 13,651 11,358 25,697 26.9% Miscellaneous 16,400 826 655 750 2,231 13.6% Total operating expenses 3,331,579 156,531 870,247 628,749 1,655,527 49.7% Operating income (loss) (1,809,079) (349,692) (783,791) 47,307 (1,086,176) 60.0% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 500 - - (943) (943) -188.6% Loans from other funds 50,000 - - 50,000 50,000 100.0% Expenses: Capital Improvements (2,040,082) (68,500) (216,004) (131,992) (416,496) 20.4% Debt Service - Principal (115,425) (28,800) (28,875) (28,875) (86,550) 75.0% Total non-operating revenues (expenses) (2,105,007) (97,300) (244,879) (111,810) (453,989) 21.6% Income before operating transfers (3,914,086) (446,992) (1,028,670) (64,503) (1,540,165) 39.3% Transfers in (or use of retained earnings) 3,914,086 278,500 142,200 1,282,200 1,702,900 43.5% Change in net assets - (168,492) $ (886,470) 1,217,697 162,735 Cash Summary: Cash, Beginning of quarter $ (385,490) $ (340,430) $ (567,155) Cash, End of quarter $ (340,430) $ (567,155) $ 1,013,495 ---PAGE BREAK--- GOLF FUND ‐ 5150 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $1,096,000 $550,853 50% $545,147 $545,147 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $597,770 $233,807 39% $363,963 $363,963 $0 FUND TOTALS $1,693,770 $784,660 46% $909,110 $909,110 ANTICIPATED NET GOLF FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES GOLF COURSES BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $629,450 $424,345 67% $205,105 SUPPLIES $80,625 $24,875 31% $55,750 CHARGES FOR SERVICES $138,300 $89,680 65% $48,620 OTHER OPER EXPENSES $423,800 $332,980 79% $90,820 DATA PROCESSING $11,200 $8,350 75% $2,850 NON OPERATING EXPENSE $133,650 $100,200 75% $33,450 CAPITAL OUTLAY $276,745 $24,815 9% $251,930 TOTAL $1,693,770 $1,005,244 59% $688,526 Profit/(Loss) to date (encumbrances not included) ($220,584) Cash in Bank December 31, 2016 $21,298 Cash in Bank March 31, 2017 ‐$186,955 OGDEN CITY GOLF FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 Includes a transfer for the sprinkler system CIP and use of retained earnings PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH GOLF FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 1,096,000 $ 374,872 $ 114,154 61,827 550,853 50.3% Miscellaneous income 6,000 1,354 1,005 4,161 6,520 108.7% Total revenue 1,102,000 376,226 115,159 65,988 557,373 50.6% OPERATING EXPENSES: Cost of materials and parts 143,400 23,127 10,947 40,730 74,804 52.2% Personal services: Salaries and wages 490,900 151,257 95,587 73,322 320,166 65.2% Benefits 138,550 37,903 32,694 33,579 104,176 75.2% Supplies: Office supplies 2,900 437 462 138 1,037 35.8% Operating supplies 47,150 4,008 3,993 5,920 13,921 29.5% Repair and maintenance supplies 1,000 93 - 137 230 23.0% Charges for services: Public utility services 89,225 27,617 17,614 7,889 53,120 59.5% Travel and education 3,325 - - 1,119 1,119 33.7% Contracted agreements 55,575 60 - 35,377 35,437 63.8% Other operating expenses: Depreciation 55,000 - 73,604 36,802 110,406 200.7% Data processing and computer equipment 11,200 2,650 2,850 2,850 8,350 74.6% Maintenance and repair 16,050 5,645 5,782 (12,773) (1,346) -8.4% Vehicle operating expenses 197,350 38,142 42,430 51,486 132,058 66.9% Miscellaneous 34,250 2,297 23,350 1,104 26,751 78.1% Total operating expenses 1,285,875 293,236 309,313 277,680 880,229 68.5% Operating income (loss) (183,875) 82,990 (194,154) (211,692) (322,856) 175.6% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 1,000 - - 37 37 0.0% Gain on sale of assets - - - - - 0.0% Expenses: Capital improvements (274,245) (13,935) (10,285) (595) (24,815) 9.0% Debt service - principal (133,650) (33,300) (33,450) (33,450) (100,200) 75.0% Interest expense - - - - - Total non-operating revenues (expenses) (406,895) (47,235) (43,735) (34,008) (124,978) 30.7% Income before operating transfers (590,770) 35,755 (237,889) (245,700) (447,834) 75.8% Transfers in (use of fund balance) 590,770 227,250 - - 227,250 38.5% Change in net assets - 263,005 $ (237,889) (245,700) (220,584) Cash Summary: Cash, Beginning of Quarter $ (28,535) $ 184,218 $ 21,298 Cash, Ending of Quarter $ 184,218 $ 21,298 $ (186,955) ---PAGE BREAK--- RECREATION ENTERPRISE FUND ‐ 5160 REVENUE CHAREGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $230,525 $168,233 73% $62,292 $62,292 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $42,825 0% $42,829 $42,829 $0 FUND TOTALS $273,350 $168,229 62% $105,121 $105,121 ANTICIPATED NET RECREATION FUND REV OVER (SHORT) of BUDGET $0 EXPENDITURES RECREATION ENTERPRISE BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $65,100 $18,405 28% $46,695 SUPPLIES $50,325 $52,570 104% ($2,245) CHARGES FOR SERVICES $99,850 $79,707 80% $20,143 OTHER OPER EXPENSES $46,550 $32,883 71% $13,667 NON OPERATING EXPENSE $11,525 $8,675 75% $2,850 TOTAL $273,350 $192,239 70% $81,111 Profit/(Loss) to date (encumbrances not included) ($24,010) Cash in Bank December 31, 2016 ‐$2,687 Cash in Bank March 31, 2017 $49,566 OGDEN CITY RECREATION FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 PROJECTED RECEIPTS Includes interest revenue and use of retained earnings PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH RECREATION FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 230,525 $ 56,277 $ 36,238 75,718 $ 168,233 73.0% Total revenue 230,525 56,277 36,238 75,718 168,233 73.0% OPERATING EXPENSES: Cost of materials and parts 21,000 2,474 1,603 - 4,077 19.4% Personal services: Salaries and wages 55,525 8,549 5,945 2,275 16,769 30.2% Benefits 9,575 859 554 223 1,636 17.1% Supplies: Office supplies 2,550 - - 250 250 9.8% Operating supplies 47,775 10,579 51,205 (9,464) 52,320 109.5% Repair and maintenance supplies 650 200 150 150 500 76.9% Charges for services: Public utility services 9,500 377 5,532 111 6,020 63.4% Contracted agreements 90,350 32,212 25,249 16,226 73,687 81.6% Other operating expenses: Rental charges 11,000 - - - - 0.0% Fiscal charges 11,525 2,975 2,850 2,850 8,675 75.3% Depreciation 1,000 - 16,672 8,336 25,008 2500.8% Maintenance and repair 2,825 - - 736 736 26.1% Miscellaneous 10,075 419 1,466 676 2,561 25.4% Total operating expenses 273,350 58,644 111,226 22,369 192,239 70.3% Operating income (loss) (42,825) (2,367) (74,988) 53,349 (24,006) 56.1% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 1,000 - - -0.4% Total non-operating revenues (expenses) 1,000 - - -0.4% Income before operating transfers (41,825) (2,367) (74,988) 53,345 (24,010) 57.4% Transfers in (use of fund balance) 41,825 - - - - 0.0% Change in net assets - (2,367) $ (74,988) 53,345 (24,010) Cash Summary: Cash, Beginning of quarter $ 88,193 $ 46,992 $ (2,687) Cash, End of quarter $ 46,992 $ (2,687) $ 49,566 ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH RECREATION FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 230,525 $ 56,277 $ 36,238 75,718 $ 168,233 73.0% Total revenue 230,525 56,277 36,238 75,718 168,233 73.0% OPERATING EXPENSES: Cost of materials and parts 21,000 2,474 1,603 - 4,077 19.4% Personal services: Salaries and wages 55,525 8,549 5,945 2,275 16,769 30.2% Benefits 9,575 859 554 223 1,636 17.1% Supplies: Office supplies 2,550 - - 250 250 9.8% Operating supplies 47,775 10,579 51,205 (9,464) 52,320 109.5% Repair and maintenance supplies 650 200 150 150 500 76.9% Charges for services: Public utility services 9,500 377 5,532 111 6,020 63.4% Contracted agreements 90,350 32,212 25,249 16,226 73,687 81.6% Other operating expenses: Rental charges 11,000 - - - - 0.0% Fiscal charges 11,525 2,975 2,850 2,850 8,675 75.3% Depreciation 1,000 - 16,672 8,336 25,008 2500.8% Maintenance and repair 2,825 - - 736 736 26.1% Miscellaneous 10,075 419 1,466 676 2,561 25.4% Total operating expenses 273,350 58,644 111,226 22,369 192,239 70.3% Operating income (loss) (42,825) (2,367) (74,988) 53,349 (24,006) 56.1% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 1,000 - - -0.4% Total non-operating revenues (expenses) 1,000 - - -0.4% Income before operating transfers (41,825) (2,367) (74,988) 53,345 (24,010) 57.4% Transfers in (use of fund balance) 41,825 - - - - 0.0% Change in net assets - (2,367) $ (74,988) 53,345 (24,010) Cash Summary: Cash, Beginning of quarter $ 88,193 $ 46,992 $ (2,687) Cash, End of quarter $ 46,992 $ (2,687) $ 49,566 ---PAGE BREAK--- PROPERTY MANAGEMENT FUND ‐ BDO ‐ 5180 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $5,150,000 $3,150,101 61% $1,999,899 $1,999,899 $0 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $14,982,950 $18,899 0% $14,964,051 $14,964,051 $0 FUND TOTALS $20,132,950 $3,169,000 16% $16,963,950 $16,963,950 ANTICIPATED NET PROP MGT FUND REV OVER (SHORT) of BUDGET $0 EXPENDITURES PROPERTY MANAGEMENT ‐ BDO REUSE BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $63,000 $46,421 74% $16,579 CHARGES FOR SERVICES $400,000 $186,912 47% $213,088 OTHER OPER EXPENSES $4,077,000 $3,041,741 75% $1,035,259 CAPITAL OUTLAY $2,500,000 $3,881,255 155% ($1,381,255) OTHER FINANCING USES $13,092,950 $7,292,750 56% $5,800,200 TOTAL $20,132,950 $14,449,079 72% $5,683,871 Profit/(Loss) to date (encumbrances not included) ($11,280,079) Cash in Bank December 31, 2016 $11,368,407 Cash in Bank March 31, 2017 $9,668,974 The main revenue item here is the transfer of tax increment from the BDO Tax Increment District, which is transferred as part of the year end closing, and carry over from the previous year for used in projects as approved in the budget. PROJECTED RECEIPTS EXCESS (SHORTAGE) PROJECTED RECEIPTS OGDEN CITY PROPERTY MANAGEMENT FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 Revenue generated from leases at BDO, which is collected quarterly EXCESS (SHORTAGE) ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH BUSINESS DEPOT OGDEN (BDO) FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 5,150,000 $ - $ 1,465,947 1,684,154 $ 3,150,101 61.2% Total revenue 5,150,000 - 1,465,947 1,684,154 3,150,101 61.2% OPERATING EXPENSES: Personal services: Salaries and wages 41,675 9,668 9,517 11,102 30,287 72.7% Benefits 21,325 5,192 5,095 5,915 16,202 76.0% Charges for services: Contracted agreements 400,000 - 132,037 54,807 186,844 46.7% Other operating expenses: Depreciation 4,050,000 - 2,027,828 1,013,913 3,041,741 75.1% Miscellaneous 2,000 - - - - 0.0% Total operating expenses 4,515,000 14,860 2,174,477 1,085,737 3,275,074 72.5% Operating income (loss) 635,000 (14,860) (708,530) 598,417 (124,973) -19.7% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 45,000 - - 18,899 18,899 42.0% Expenses: Capital improvements (2,500,000) (1,308,607) (1,572,186) (1,000,462) (3,881,255) 155.3% Loans to other funds (50,000) - - (50,000) (50,000) 100.0% Total non-operating revenues (expenses) (2,505,000) (1,308,607) (1,572,186) (1,031,563) (3,912,356) 156.2% Income before operating transfers (1,870,000) (1,323,467) (2,280,716) (433,146) (4,037,329) 215.9% Transfers in (use of fund balance) 14,937,950 - - - - 0.0% Transfers out (return to fund balance) (13,067,950) (4,187,350) (775,200) (2,280,200) (7,242,750) 55.4% Change in net assets - (5,510,817) $ (3,055,916) (2,713,346) (11,280,079) Cash Summary: Cash, Beginning of quarter $ 16,215,844 $ 12,576,495 11,368,407 Cash, End of quarter $ 12,576,495 $ 11,368,407 9,668,974 ---PAGE BREAK--- STORM SEWER FUND ‐ 5190 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $4,780,575 $3,489,684 73% $1,290,891 $1,290,891 $0 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $7,572,179 $9,311 0% $7,562,868 $7,562,868 $0 FUND TOTALS $12,352,754 $3,498,995 28% $8,853,759 $8,853,759 ANTICIPATED NET PROP MGT FUND REV OVER (SHORT) of BUDGET $0 EXPENDITURES STORM SEWER FUND ‐ 5190 BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $833,725 $472,960 57% $360,765 SUPPLIES $66,700 $34,542 52% $32,158 CHARGES FOR SERVICES $826,350 $381,202 46% $445,148 OTHER OPER EXPENSES $779,500 $756,908 97% $22,592 DATA PROCESSING $42,850 $32,125 75% $10,725 NON OPERATING EXPENSE $1,399,900 $723,645 52% $676,255 CAPITAL OUTLAY $7,594,479 $492,568 6% $7,101,911 OTHER FINANCING USES $809,250 $10,000 1% $799,250 TOTAL $12,352,754 $2,903,950 24% $9,448,804 Profit/(Loss) to date (encumbrances not included) $595,045 Cash in Bank December 31, 2016 $5,600,852 Cash in Bank March 31, 2017 $6,145,849 STORM SEWER FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 OGDEN CITY PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) Includes use of retained earnings for capital outlay PROJECTED RECEIPTS ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH STORM SEWER FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 4,780,575 $ 1,167,833 $ 1,162,336 1,159,515 $ 3,489,684 73.0% Total revenue 4,781,575 1,167,833 1,162,336 $ 1,159,515 3,489,684 73.0% OPERATING EXPENSES: Personal services: Salaries and wages 551,675 113,354 104,478 106,786 324,618 58.8% Benefits 282,200 48,242 46,446 53,888 148,576 52.6% Supplies: Office supplies 450 - 406 - 406 90.2% Operating supplies 30,150 3,723 3,796 1,658 9,177 30.4% Repair and maintenance supplies 10,275 - - 794 794 7.7% Charges for services: Public utility services 1,675 325 450 450 1,225 73.1% Travel and education 5,700 107 2,399 1,221 3,727 65.4% Contracted agreements 618,900 103,349 101,289 128,851 333,489 53.9% Other operating expenses: Rental charges 15,025 3,775 3,750 3,750 11,275 75.0% Fiscal charges 828,700 207,250 207,150 207,150 621,550 75.0% Depreciation 180,000 - 235,487 117,743 353,230 196.2% Data processing and computer equipment 42,850 10,675 10,725 10,725 32,125 75.0% Maintenance and repair 456,525 32,925 32,850 185,327 251,102 55.0% Vehicle operating expenses 353,700 87,490 58,339 62,164 207,993 58.8% Total operating expenses 3,377,825 611,215 807,565 880,507 2,299,287 68.1% Operating income (loss) 1,403,750 556,618 354,771 279,008 1,190,397 84.8% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 10,000 - - 9,311 9,311 93.1% Expenses: Capital improvements (7,594,479) (244,413) (208,989) (39,166) (492,568) 6.5% Debt service - Principal (349,000) - - - - 0.0% Interest expense (222,200) - (184,813) 82,718 (102,095) 45.9% Total non-operating revenues (expenses) (8,155,679) (244,413) (393,802) 52,863 (585,352) 7.2% Income before operating transfers (6,751,929) 312,205 (39,031) 331,871 605,045 -9.0% Transfers in (or use of fund balance) 7,561,179 - - - - 0.0% Transfers out (return to fund balance) (809,250) (10,000) - - (10,000) 1.2% Change in net assets - 302,205 $ (39,031) 331,871 595,045 Cash Summary: Cash, Beginning of quarter $ 5,326,310 $ 5,388,873 $ 5,600,852 Cash, End of quarter $ 5,388,873 $ 5,600,852 $ 6,145,849 ---PAGE BREAK--- MEDICAL SERVICES FUND ‐ 5200 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $1,349,675 $997,630 74% $352,045 $352,045 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $5,889,750 $4,040,673 69% $1,849,077 $1,849,078 $0 OTHER REVENUE CATEGORIES 6,7&8 BUDGET RECEIVED PERCENT BALANCE $560,000 $59,179 11% $500,821 $500,821 $0 FUND TOTALS $7,799,425 $5,097,482 65% $2,701,943 $2,701,944 ANTICIPATED NET MEDICAL FUND REVENUE OVER (SHORT) of BUDGET $0 EXPENDITURES MEDICAL SERVICES BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $3,571,425 $2,624,425 73% $947,000 SUPPLIES $296,425 $146,438 49% $149,987 CHARGES FOR SERVICES $856,030 $527,981 62% $328,049 OTHER OPER EXPENSES $552,770 $291,181 53% $261,589 DATA PROCESSING $78,875 $59,150 75% $19,725 NON OPERATING EXPENSE $560,000 $419,975 75% $140,025 CAPITAL OUTLAY $61,500 $31,014 50% $30,486 OTHER FINANCING USES $1,822,400 $500,000 27% $1,322,400 TOTAL $7,799,425 $4,600,164 59% $3,199,261 Other financing uses includes a return to retained earnings from operations Profit/(Loss) to date (encumbrances not included) $497,318 Cash in Bank December 31, 2016 $1,616,557 Cash in Bank March 31, 2017 $1,548,720 PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) OGDEN CITY MEDICAL SERVICES FUND REVENUE & EXPENSE SUMMARY As of March 31, 2017 PROJECTED RECEIPTS PROJECTED RECEIPTS ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH MEDICAL FUND Quarter Ended March 31, 2017 YTD % of Budget Annual 1st Quarter 2nd Quarter 3rd Quarter YTD Received / Budget Actual Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 5,889,750 $ 1,659,847 $ 1,187,094 1,193,732 $ 4,040,673 68.6% Grants and donations 1,349,675 221,696 443,391 332,543 997,630 73.9% Miscellaneous income 10,000 - - - - 0.0% Total revenue 7,249,425 1,881,543 1,630,485 1,526,275 5,038,303 69.5% OPERATING EXPENSES: Personal services: Salaries and wages 2,480,050 599,175 560,709 647,836 1,807,720 72.9% Benefits 1,095,375 259,578 257,725 306,662 823,965 75.2% Supplies: Office supplies 5,050 645 1,044 755 2,444 48.4% Operating supplies 279,375 43,449 45,125 47,786 136,360 48.8% Repair and maintenance supplies 12,000 455 157 7,022 7,634 63.6% Charges for services: Public utility services 94,875 12,428 22,028 26,520 60,976 64.3% Travel and education 101,605 6,717 2,193 9,351 18,261 18.0% Contracted agreements 497,550 92,459 95,454 142,178 330,091 66.3% Other operating expenses: Rental charges 5,575 1,300 1,425 1,425 4,150 74.4% Fiscal charges 560,000 139,925 140,025 140,025 419,975 75.0% Depreciation 65,000 - 32,952 16,099 49,051 75.5% Data processing and computer equipment 78,875 19,700 19,725 19,725 59,150 75.0% Maintenance and repair 132,245 11,724 12,481 51,006 75,211 56.9% Vehicle operating expenses 270,150 58,853 65,490 62,438 186,781 69.1% Miscellaneous 1,621,700 4,053 50,109 64,233 118,395 7.3% Total operating expenses 7,299,425 1,250,461 1,306,642 1,543,061 4,100,164 56.2% Operating income (loss) (50,000) 631,082 323,843 (16,786) 938,139 -1876.3% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 50,000 17,324 21,529 20,326 59,179 118.4% Total non-operating revenues (expenses) 50,000 17,324 21,529 20,326 59,179 118.4% Income before operating transfers - 648,406 345,372 3,540 997,318 0.0% Transfers in (or use of fund balance) 500,000 - - - - 0.0% Transfers out (500,000) - (500,000) - (500,000) 100.0% Change in net assets - 648,406 (154,628) 3,540 497,318 Cash Summary: Cash, Beginning of quarter $ 1,255,725 $ 1,616,557 $ 1,548,720 Cash, End of quarter $ 1,616,557 $ 1,548,720 $ 1,899,548 ---PAGE BREAK--- FACILITIES/FLEET/STORES ‐ 6100 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $7,965,450 $6,409,375 80% $1,556,075 $1,556,075 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $5,172,263 $935,580 18% $4,236,683 $4,236,683 $0 FUND TOTALS $13,137,713 $7,344,955 56% $5,792,758 $5,792,758 ANTICIPATED NET FLEET FUND REVENUE OVER (SHORT) of BUDGET $0 EXPENDITURES FLEET/FACILITIES/STORES BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $1,436,125 $959,956 67% $476,169 SUPPLIES $172,063 $222,767 129% ($50,704) CHARGES FOR SERVICES $1,828,637 $1,413,086 77% $415,551 OTHER OPER EXPENSES $5,247,225 $3,690,419 70% $1,556,806 DATA PROCESSING $114,850 $86,125 75% $28,725 DEBT SERVICE $956,050 $728,795 76% $227,255 CAPITAL OUTLAY $3,382,763 $1,736,057 51% $1,646,706 TOTAL $13,137,713 $8,837,204 67% $4,300,509 Profit/(Loss) to date (encumbrances not included) $7,344,955 Cash in Bank December 31, 2016 ($897) Cash in Bank March 31, 2017 $779,719 EXCESS (SHORTAGE) EXCESS (SHORTAGE) FACILITIES/FLEET/STORES REVENUE & EXPENSE SUMMARY OGDEN CITY As of March 31, 2017 Includes use of retained earnings for vehicle replacements, etc PROJECTED RECEIPTS PROJECTED RECEIPTS ---PAGE BREAK--- INFORMATION TECHNOLOGY ‐ 6120 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $3,504,200 $3,187,592 91% $316,608 $316,608 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $2,636,346 $861,406 33% $1,774,940 $1,774,940 $0 FUND TOTALS $6,140,546 $4,048,998 66% $2,091,548 $2,091,548 ANTICIPATED NET MIS FUND REVENUE OVER (SHORT) of BUDGET $0 EXPENDITURES INFORMATION TECHNOLOGY BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $1,992,150 $1,255,289 63% $736,861 SUPPLIES $21,750 $10,999 51% $10,751 CHARGES FOR SERVICES $1,421,125 $899,836 63% $521,289 OTHER OPER EXPENSES $223,400 $93,079 42% $130,321 DEBT SERVICE $241,575 $157,749 65% $83,826 CAPITAL OUTLAY $2,095,696 $1,653,572 79% $442,124 OTHER FUNDING USES $144,850 $0 0% $144,850 TOTAL $6,140,546 $4,070,525 66% $2,070,021 Profit/(Loss) to date (encumbrances not included) ($21,527) Cash in Bank December 31, 2016 $1,871,588 Cash in Bank March 31, 2017 $1,657,926 EXCESS (SHORTAGE) EXCESS (SHORTAGE) OGDEN CITY INFORMATION TECHNOLOGY REVENUE & EXPENSE SUMMARY As of March 31, 2017 Capital outlay includes expenditures for equipment purchases above what had been planned for, examples include grant funded purchases of laptops for police and fire. Divisions are then charged to reimburse IT for the expenditure. This category includes transfers from other funds and a use of retained earnings Charges for services revenue includes charges to divisions for equipment purchases above what had been planned for, examples include grant funded purchases of laptops for police and fire. PROJECTED RECEIPTS PROJECTED RECEIPTS ---PAGE BREAK--- RISK MANAGEMENT FUND ‐ 6130 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $1,601,500 $1,289,125 80% $312,375 $312,375 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $3,000 $2,732 91% $268 $268 $0 FUND TOTALS $1,604,500 $1,291,856 81% $312,644 $312,644 ANTICIPATED NET RISK MGT FUND REVENUE OVER (SHORT) of BUDGET $0 EXPENDITURES RISK MANAGEMENT BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $64,550 $47,396 73% $17,154 SUPPLIES $12,000 $2,436 20% $9,564 CHARGES FOR SERVICES $369,025 $450,554 122% ($81,529) OTHER OPER EXPENSES $1,007,875 $679,368 67% $328,507 DATA PROCESSING $24,750 $18,525 75% $6,225 OTHER FUNDING USES $126,300 $0 0% $126,300 TOTAL $1,604,500 $1,198,278 75% $406,222 Profit/(Loss) to date (encumbrances not included) $93,578 Cash in Bank December 31, 2016 $1,398,231 Cash in Bank March 31, 2017 $1,643,331 As of March 31, 2017 This includes interest income and miscellaneous income. EXCESS (SHORTAGE) EXCESS (SHORTAGE) Charges for Services is higher than would be expected due to the payment of insurance premiums due at the beginning of the fiscal year. Other funding uses, is a planned return to fund balance. RISK MANAGEMENT REVENUE & EXPENSE SUMMARY OGDEN CITY PROJECTED RECEIPTS Charges to other City funds for Workman's Comp and Unemployment coverage. PROJECTED RECEIPTS ---PAGE BREAK--- TRUST FUNDS ‐ 7100 & 7110 REVENUE GOMER NICHOLAS TRUST FUND ‐ 7100 OTHER REVENUE CATEGORIES 6 BUDGET RECEIVED PERCENT BALANCE $1,500 $3,093 206% ($1,593) $0 $1,593 REVENUE CEMETERY PERPETUAL CARE FUND ‐ 7110 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $9,250 $11,196 121% ($1,946) $0 $1,946 OTHER REVENUE CATEGORIES 6,8 BUDGET RECEIVED PERCENT BALANCE $183,600 $2,086 1% $181,514 $181,514 $0 FUND TOTALS $194,350 $16,376 8% $177,974 $181,514 ANTICIPATED NET TRUST FUNDS REVENUE OVER (SHORT) of BUDGET $3,540 EXPENDITURES G. NICHOLAS TRUST BUDGET EXPENDED PERCENT BALANCE INTERFUND TRANSFERS $1,500 $2,751 183% ($1,251) TOTAL $1,500 $2,751 183% ($1,251) CEMETERY PERP. CARE BUDGET EXPENDED PERCENT BALANCE OTHER OPER EXPENSES $21,250 $318 1% $20,932 CAPITAL OUTLAY $171,600 $0 0% $171,600 TOTAL $192,850 $318 0% $192,532 TOTAL TRUST FUNDS $194,350 $3,069 2% $191,281 A portion of each lot sale is credited to perpetual care. This is interest earned from the investment and a use of fund balance OGDEN CITY Other Operating Expenses is due to reimbursement from outside entities for higher cost associated with different types of headstones. Additionally, a use of fund balance has been appropriated to sprinkler improvements as capital outlay. EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS PROJECTED RECEIPTS This is interest earnings. PROJECTED RECEIPTS EXCESS (SHORTAGE) TRUST FUND FINANCIAL INFORMATION As of March 31, 2017 ---PAGE BREAK--- MISCELLANEOUS GRANTS & DONATIONS FUND ‐ 7120 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $247,317 ($142,632) ‐58% $389,949 $389,949 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $3,000 ($127) $3,127 $3,127 $0 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $319,254 $2,324 1% $316,930 $316,930 $0 FUND TOTALS $569,571 ($140,434) ‐25% $710,005 $710,006 ANTICIPATED NET MISC GRANTS FD REV OVER (SHORT) of BUDGET $0 EXPENDITURES MISC GRANTS & DONATIONS BUDGET EXPENDED PERCENT BALANCE OTHER OPER EXPENSES $542,317 $155,333 29% $386,984 TOTAL $569,571 $165,219 29% $404,352 PROJECTED RECEIPTS PROJECTED RECEIPTS OGDEN CITY MISC. GRANTS/DONATIONS FUND FINANCIAL INFORMATION As of March 31, 2017 Donations and miscellaneous grants are activities in this category. EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS Intergovernmental revenue had a negative balance due to grant revenue receivable accrued to FY16,. The City had not received the payment as of March 31st. It is expected the City will receive this payment during the next quarter, which corrects the negative revenue reported here. EXCESS (SHORTAGE) ---PAGE BREAK--- MAJOR GRANTS FUND ‐ 7130 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $3,042,790 $933,849 31% $2,108,941 $2,108,941 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $5,075,633 $3,340,452 66% $1,735,181 $1,735,181 $0 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $3,108,887.00 $1,207,287.18 39% $1,901,600 $1,901,600 $0 FUND TOTALS $11,227,310 $5,481,588 49% $5,745,722 $5,745,723 ANTICIPATED NET MAJOR GRANTS FD REV OVER (SHORT) of BUDGET $0 EXPENDITURES MAJOR GRANTS BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $616,925 $489,455 79% $127,470 SUPPLIES $8,000 $4,564 57% $3,436 CHARGES FOR SERVICES $48,291 $26,944 56% $21,347 OTHER OPER EXPENSES $9,316,269 $4,158,968 45% $5,157,301 DATA PROCESSING $47,825 $35,950 75% $11,875 NON CLASSIFIED OPERATING E $190,000 $0 0% $190,000 OTHER FUNDING USES $1,000,000 $1,000,000 100% $0 TOTAL $10,227,310 $4,715,881 46% $5,511,429 OGDEN CITY MAJOR GRANTS FUND FINANCIAL INFORMATION EXCESS (SHORTAGE) PROJECTED RECEIPTS EXCESS (SHORTAGE) PROJECTED RECEIPTS These are major grants that if not received are available when needed and will carry over if not drawn. In most cases, they are reimbursable grants. Other operating expenses include the use of federal grant funds As of March 31, 2017 PROJECTED RECEIPTS These funds are program income generated by repayment of prior use of federal grant funds. They are used prior to drawing down additional funds from federal grants. Additionally the charges for services revenue includes the asset control area program. Other revenue is primarily transfers from other funds and program income, generated by repayment of prior use of federal grant funds and recognized for use in the current year. EXCESS (SHORTAGE) ---PAGE BREAK--- REDEVELOPMENT AGENCY ‐ GENERAL REVENUE GENERAL ACTIVITY ‐ 3120 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $829,900 $88,010 11% $741,890 $741,890 $0 FUND TOTALS $829,900 $88,010 11% $741,890 $741,890 ANTICIPATED NET RDA FD DISTRICTS REV OVER (SHORT) of BUDGET $0 EXPENDITURES REDEVELOPMENT AGENCY‐‐GENERAL RDA GENERAL BUDGET EXPENDED PERCENT BALANCE CHARGES FOR SERVICES $744,900 $566,793 76% $178,107 CAPITAL OUTLAY $85,000 $175,275 206% ($90,275) TOTAL $829,900 $742,068 89% $87,832 REDEVELOPMENT AGENCY ‐ HOUSING REVENUE GENERAL ACTIVITY ‐ 3900 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $6,142,875 $1,000,000 16% $5,142,875 $5,142,875 $0 FUND TOTALS $6,142,875 $1,000,000 16% $5,142,875 $5,142,875 ANTICIPATED NET RDA HOUSING DISTRICTS REV OVER (SHORT) of BUDGET $0 EXPENDITURES REDEVELOPMENT AGENCY‐‐HOUSING RDA HOUSING BUDGET EXPENDED PERCENT BALANCE CHARGES FOR SERVICES $246,304 $246,304 100% CAPITAL OUTLAY $5,004,571 $2,118,879 42% $2,885,692 TOTAL $5,592,875 $2,365,183 42% $3,227,692 EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS OGDEN CITY REDEVELOPMENT AGENCY FUND FINANCIAL INFORMATION As of March 31, 2017 OGDEN CITY REDEVELOPMENT AGENCY FUND FINANCIAL INFORMATION As of March 31, 2017 This category is mostly transfers from the districts to cover general expenses. The actual amounts are determined at the end of the year. This category is transfers from the districts for housing and the appropriation of loan proceeds. The actual amounts are determined at the end of the year PROJECTED RECEIPTS ---PAGE BREAK--- REDEVELOPMENT AGENCY ‐ ENTITY 2 REVENUE TAX INCREMENT DISTRICTS TAXES 1 BUDGET RECEIVED PERCENT BALANCE $11,969,225 $11,447,292 96% $521,933 $521,934 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $764,800 $480,478 63% $284,322 $284,322 $0 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $7,462,135 $4,353,031 58% $3,109,104 $3,109,104 $0 FUND TOTALS $20,196,160 $16,280,800 81% $3,915,360 $3,915,360 ANTICIPATED NET RDA FD DISTRICTS REV OVER (SHORT) of BUDGET $0 RDA TOTALS $27,168,935 $17,368,810 64% $9,800,125 $9,800,125 EXPENDITURES REDEVELOPMENT AGENCY‐‐Tax Increment Districts RDA DISTRICTS BUDGET EXPENDED PERCENT BALANCE CHARGES FOR SERVICES $560,250 $320,116 57% $240,134 OTHER OPER EXPENSES $2,497,475 $506,462 20% $1,991,013 NON OPERATING EXPENSE $5,665,625 $4,368,471 77% $1,297,154 CAPITAL OUTLAY $3,050,000 $2,027,242 66% $1,022,758 INTERFUND TRANSFERS $2,234,810 $0 0% $2,234,810 OTHER FUNDING USES $6,188,000 $1,138,000 18% $5,050,000 TOTAL $20,196,160 $8,360,291 41% $11,835,869 Total RDA $26,618,935 $11,467,542 43% $15,151,393 EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) The majority of property tax is received after property taxes are collected This is mostly Rec Center lease revenue. PROJECTED RECEIPTS PROJECTED RECEIPTS This category is sale of property and miscellaneous interest income. However the major items in this category are interfund transfers, bond proceeds and use of prior year's fund balance, most of which are not posted until end of year. OGDEN CITY REDEVELOPMENT AGENCY FUND FINANCIAL INFORMATION As of March 31, 2017 PROJECTED RECEIPTS ---PAGE BREAK--- MUNICIPAL BUILDING AUTHORITY ‐ ENTITY 3 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $545,475 $409,125 75% $136,350 $136,350 $0 OTHER REVENUE CATEGORIES 6,7&8 BUDGET RECEIVED PERCENT BALANCE $5,000 $672 13% $4,328 $4,329 $0 FUND TOTALS $550,475 $409,797 74% $140,678 $140,679 ANTICIPATED NET MBA FUND REV OVER (SHORT) of BUDGET $0 EXPENDITURES MBA BUDGET EXPENDED PERCENT BALANCE OTHER OPER EXPENSES $1,200 $1,152 96% $48 NON OPERATING EXPENSE $549,275 $508,429 93% $40,846 TOTAL $550,475 $509,582 93% $40,893 Non operating expenses are debt service related. EXCESS (SHORTAGE) EXCESS (SHORTAGE) As of March 31, 2017 PROJECTED RECEIPTS PROJECTED RECEIPTS This is the lease revenue from the City's General Fund. There are estimated transfers that are reconciled as part of the year‐end process. Interest and miscellaneous income. OGDEN CITY MUNICIPAL BUILDING AUTHORITY FUND FINANCIAL INFORMATION ---PAGE BREAK--- ---PAGE BREAK--- ---PAGE BREAK--- ---PAGE BREAK--- ---PAGE BREAK--- ---PAGE BREAK--- ---PAGE BREAK---