Loading...
HomeMy Public PortalAbout2015-10 Meeting - Revenue Model ReportRevenue Model Report For Period Ending September 30, 2015 Data as of October 5, 2015 for period ending September 30, 2015 ** Includes August actual sales tax receipts amount CFY 2015 YTD Actual Projected Over/ Description Budget As of 9/30/2015 (Under) Budget Sales Tax and Use Tax $ 9,772,509.00 $ 9,118,814.04 ** $ 1,012,706.86 Intergovernmental Taxes $ 2,130,000.00 $ 1,812,989.49 $ 100,240.70 Other Taxes $ 120,000.00 $ 99,977.80 $ 229.60 Franchise & Utility Tax $ 7,225,000.00 $ 6,075,705.70 $ 11,351.57 Property Taxes $ 5,249,399.00 $ 5,253,634.95 $ 13,284.93 Intergovernmental $ 1,057,136.48 $ 5,000.00 $ 5,000.00 Charges for Services - $ 2,448,744.80 $ 2,444,822.10 $ 121,228.63 Fees, Licenses, & Permits $ 658,300.00 $ 699,759.36 $ 73,416.88 Fines & Forfeitures $ 992,380.00 $ 909,853.13 $ 13,022.04 Contributions/Donations $ 122,685.53 $ 133,863.53 $ 40,090.85 Other Operating Revenues $ 84,313.00 $ 194,059.31 $ 122,865.73 Interest Income $ 90,000.00 $ 105,711.56 $ 19,494.84 Other Non Operating Revenue $ 25,000.00 $ 17,306.00 $ - Operating Transfers In $ 34,100.00 $ 29,268.03 $ (1,169.35) Totals $ 30,009,567.81 $ 26,900,765.00 $ 1,531,763.28 ** Includes August actual sales tax receipts amount CFY2015 Revenue Model Report (Detail) Remaining For Period Ending September 30, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification Description Month Budget As of9/30/2015 15 -Oct TOTAL (Under)Budget of Formulas Sales Tax and Use Tax 10-100400010 Sales Tax 2 9,772,509.00 9,118,814.04 1,666,401.82 10,785,215.86 1,012,706.86 1,012,706.86 10.100.400020 Sales Tax Interest 9M Q,QO Q,QO Q.OQ 0.00 lim 9,772,509.00 9,116,814.04 1,666,401.82 10,785,215.86 1,012,706.86 1,012,706.86 Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax 2 480,000.00 406,035.94 125,551.00 531,586.94 51,586.94 51,586.94 10-100403010 Gasoline Tax 2 1,100,000A0 857,335.15 291,700.21 1,149,035.36 49,035.36 49,035.36 10-10D-430080 Road &Bridge Tax 0 550.000.00 549.618.40 0.Q0 549.618.40 381.60 81.60 2,130,000.00 1,812,989.49 417,251.21 2,230,240.70 100,240.70 100,240.70 Other Taxes 10-100-403020 Cig Tax 1 120.000.00 99.977.80 20.251.80 120.229.60 229.60 229.60 120,000.00 99,977.80 20,251.80 120,229.60 229.60 229.60 Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax 1 3,580,000.00 3,131,630.49 632,129.31 3,763,759.80 183,759.80 183,759.80 30-100410030 Gas Utility License Tax 1 990,000.00 889,439.18 73,503.46 962,942.64 (27,057.36) (27,057.36) 10.100410052 Telephone Cell w/o audit money 1 2,250,000.00 1,738,382.14 362,248.95 2,100,631.09 (149,368.91) (149,368.91) 30-100410053 Telecom Audit 0.00 (17,21020) 0.00 (17,210.20) (17,210.20) (17,210.20) 10400310060 Cable Franchise Fee R/1 405,000.00 333,464.09 92,764.15 426,228.24 21,228.24 21,228.24 10-100310061 Cable Utility Audit $ 1 $ $ $ $ 7,225,000.00 6,075,705.70 1,160,645.87 7,236,351.57 11,351.57 11,351.57 Property Taxes 10-100.420010 Current Property Tax 0 4,600,000.00 4,554,687.25 3,621.75 4,558,309.00 (41,69100) (41,691.00) 30-100320020 Del Property Tax 0 55,000.00 49,627.72 1,253.08 50,880.80 (4,11920) (4,119.20) 30-100320040 nn Institution Tax 0 20,000.00 43,692.38 0.00 43,692.38 23,692.38 23,692.38 10-100320050 Prop Tax Int & Penalties 0 30,000.00 25,173.11 1,257.64 26,430.75 (3,569.25) (3,569.25) 10-100320055 Surtax Receipts - County Reimb 0 54,399.00 54,399.28 0.00 54,399.28 0.28 0.28 10-100320060 Surtax Receipts 0 470,000.00 463,430.34 410.84 463,841.18 (6,158.82) (6,158.82) 10-100320080 Special Tax Rev 2 2090O.Do 6262 6f�4.87 2.505.68 65.130.55 45130.55 . 45.130.55 5,249,399.00 5,253,634.95 9,048.98 5,262,683.93 13,284.93 13,284.93 Intergovernmental 30-100330010 Federal Grant 0 1,057,136.48 0.00 1,057,136.48 1,057,136.48 0.00 0.00 10-100330100 state DNR Historic Pres 0 0.00 0.00 0.00 0.00 0.00 0.00 10-IOOAB0020 NSP Rehab Sales 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100380025 HUD Program Income 0 000 5000.00 0.00 5.000.00 5.000.00 5.000.00 1,057,136.48 5,000.00 1,057,136.48 1,062,136.48 5,000.00 5,000.00 Charges for Services 10-100340010 Admin Charge Backs 0 1,527,9S8.00 1,527,957.00 0.00 1,527,957.00 (1.00) (1.001 10-100340050 Emt Reimbursement 0 25,000.00 25,000.00 0.00 25,000.00 0.00 0.00 10-100340210 Street Cuts 0 25,000.00 22,687.00 2,064.00 24,751.00 (249.00) (249.00) 10-100340910 Fuel Charge - backs 0 18,000.00 9,642.00 1,500.00 11,142.00 (6,858.00) (6,858.00) 10-100340920 Parts Charge backs 0 95,000.00 147,166.68 15,833.33 163,000.01 68,000.01 68,000.01 10-100440930 Labor Charge backs 0 125,000.00 148,462.95 24,558.55 173,021.50 48,021.50 48,021.50 10.100350189 Animal Shelter Bricks 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100481020 Cole Cry Animal Rescue 0 100,000.00 77,025.65 25,000.00 102,025.65 2,025.65 2,025.65 10-100381030 Rent City Hall/annex 0 6,500.00 6,500.00 0.00 6,500.00 0.00 0.00 30-100-481039 Rent -Hyde Park Facility 0.00 100.00 0.00 100.00 100.00 100.00 10-100381040 Rent Other 0 12,000.00 0.00 12,000.00 12,000.00 0.00 0.00 CFY2015 Revenue Model Report (Detail) Remaining For Period Ending September 30, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification Description Month Budget Asof9/30/2015 15 -Oct TOTAL (Under)Budget of Formulas 10-100.481045 Rent -tower Sites 1 115,000.00 107,341.78 13,421.55 120,763.33 5,763.33 5,763.33 10-100-481065 Parking Spot Maintenance 25,000.00 25,000.00 0.00 25,000.00 0.00 0.00 10-100.481075 Cole Cry 911 Reimb 0 348,556.80 321,974.88 29,123.90 351,098.78 2,541.98 2,541.98 10-100.481080 Sale Of Maps/gis Data 0 0.00 55.00 0.00 55.00 55.00 55.00 10-100481085 COTe Cry Gis Joint Coop 0 15,000.00 13,750.00 1,250.00 15,000.00 0.00 0.00 10-100-481090 Cole Cry Sheriff -New World 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100481100 Sale Of Grave Sites 0 3,000.00 4,416.00 400.00 4,816.00 1,816.00 11816.00 10-100-481105 TIF Administration Fee 7,730.00 7,730.00 0.00 7,730.00 0.00 0.00 10-100-481110 Long &Short 0 0.00 13_16 0.00 13_16 13_16 13_16 2,448,744.80 2,444,822.10 125,151.33 2,569,973.43 121,228.63 121,228.63 Fees, Licenses, & Permits 10-100350010 Liquor Licenses 0 65,000.00 65,761.40 1,239.85 67,001.25 2,001.25 2,001.25 10-100350020 Business Licenses 0 215,000.00 210,340.07 4,139.90 214,479.97 (520.03) (520.03) 10-100.450021 Home Occupation Permit 0 1,500.00 1,412.00 208.00 1,620.00 120.00 120.00 10-100-450030 Solicitors Uc 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg. Reg 0 0.00 546.00 0.00 546.00 546.00 546.00 10-100350041 Abandoned Bldg. Admin Fee 0 5,500.00 16,583.17 0.00 16,583.17 11,083.17 11,083.17 10-100350045 Bldg. Constr Fees 0 125,000.00 158,737.39 10,416.67 169,154.06 44,154.06 44,154.06 10-100450050 Electrical Certificates 0 16,000.00 19,152.00 325.50 19,477.50 3,477.50 3,477.50 10-00350060 Electrical Permits 0 2,500.00 2,509.98 932.85 3,442.83 942.83 942.83 10.100350070 Plumbing Licenses 0 10,000.00 10,646.00 154.50 10,800.50 600.50 800.50 10.100350080 Plumbing Permits 0 5,000.00 3,580.00 450.00 4,030.00 1970.00) (970.00) 10-100350090 Other Be & Permits 0 2,000.00 1,065.00 728.00 1,793.00 (207.00) (207.00) 10-100350091 Day Care Inspection Fees 0 8,000.00 6,730.00 1,242.50 7,972.50 (27.50) (27.50) 10-100450092 Food Inspection Fees 0 88,000.00 85,737.15 395.46 86,132.61 (1,867.39) (1,867.39) 30-100450100 Curb Cut Permits 0 1,500.00 940.00 156.00 1,096.00 (404.00) (404.00) 10.100-450110 Board Of Adj Fees 0 1,200.00 618.00 0.00 618.00 (582.00) (582.00) 10-100450120 Sign Permits 0 5,000.00 4,276.00 274.00 4,550.00 (450.00) (450.00) 10-100-450130 Demolition Permits 0 500.00 885.00 52.00 937.00 437.00 437.00 30-100-450150 Ace Rep Fees -pollee 0 12,000.00 10,457.20 1,182.30 11,639.50 (360.50) (360.50) 10-100350160 Accrpt/blast; P -fire 0 750.00 287.00 6.00 293.00 (457.00) (457.00) 30-100-450170 Animal Redemption Fees 0 52,000.00 52,165.00 5,785.00 57,950.00 5,950.00 5,950.00 30-100350180 Animal Vaccinations Fees 0 5,000.00 4,025.00 475.00 4,500.00 (500.00) (500.00) 10-100.450185 Animal Cremation Fees 0 24,000.00 27,621.00 2,298.50 29,919.50 5,919.50 51919.50 10-100-450186 Animal Boarding Fees 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100350190 Taxi Permits 0 450.00 604.00 0.00 604.00 154.00 154.00 10-100-450230 Vacating Right Of Way 0 400.00 523.00 130.00 653.00 253.00 253.00 10-100-450250 Rezoning Request 0 10,000.00 11,304.00 1,278.00 12,582.00 2,582.00 2,582.00 10-100350255 Planning & Zoning Review Fees 0.00 1,381.00 0.00 1,381.00 1,381.00 1,381.00 10-100350260 Non-refundable Plans/spec 0 2.000.00 1,873.00 87_50 1960.50 139.501 (39.50) 658,300.00 699,759.36 31,957.52 731,716.88 73,416.88 73,416.88 Fines & Forfeitures 10.100460010 Court Cost 0 80,000.00 64,572.22 7,053.85 71,626.07 (8,373.93) (8,373.93) 30-100360015 Court Restitutions 0 1,300.00 1,984.37 0.00 1,994.37 684.37 684.37 10.100360018 Inmate Security Fund 0 12,080.00 11,110.27 1,108.68 12,218.95 138.95 138.95 10-100460020 Jail Cost Recovery 0 10,000.00 4,163.52 481.56 4,645.08 (5,354.93) (5,354.93) 10.100460025 Alcohol Offense Cost Bar 0 81000.00 8,919.50 809.25 9,728.75 1,728.75 1,728.75 (d3�itF_Fi Revenue Model Report (Detail) Remaining For Period Ending September 30, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification Description Month Budget Asaf9/30/2015 15 -Oct TOTAL (Under)Budget of Formulas 10100+160030 Pol Fires -traffic 0 835,000.00 775,180.03 80,718.04 855,898.07 20,898.07 20,898.07 10-100.460040 Pol rickets -parking 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-460050 Pal fines - Other 0 0.00 0.00 0.00 0.00 0.00 0.00 10400460060 Dog Fines 0 O.DD 0.00 0.00 0.00 0.00 0.00 10-100460070 P& Code Violations 0 0.00 0.00 0.00 0.00 0.00 0.00 30-300460090 Parking Fines 0 53,000.00 47,335.06 6,544.21 53,879.27 879.26 879.26 10-100-460100 Bankcard Charges 0 ]000.00 3411.A4 1 166 67) (4,578,Sll 2,421A9 24. 21.49 992,380.00 909,853.13 95,54891 1,005,402.04 13,022.04 13,022.04 Contributions/Donations 10-100-430055 DARE Contri 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100.480010 Citizen Participation 0 0.00 0.00 0.00 0.00 0.00 D.DO 10-100480015 Sidewalk Waiver Revenue 0 0.00 0.00 0.00 0.00 0.00 _ 0.00 10-100480030 Donations -Recycling 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100.480050 Sober Driver Program 0 2,930.00 2,930.00 0.00 2,930.00 0.00 0.00 10-100480055 JC Fire Museum 0 0.00 3,551.00 0.00 3,551.00 3,551.00 3,551.00 10-100-480063 Private Donation -Cultural Art 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100480065 Cultural Arts 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100480070 Community Projects Donations 0 7,255.53 7,255.53 0.00 7,255.53 0.00 0.00 30-100480080 Dare Donations 0 0.00 500.00 0.00 500.00 500.00 500.00 10-100480090 Police K-9 Donations 0 500.00 500.00 0.00 500.00 0.00 0.00 10.100480165 Animal s Donations 0 0.00 7,634.21 0.00 7,634.21 7,634.21 7,634.21 30-100481050 Transfer sm/Ping-sld WA Cntr 0 0.00 0.00 0.00 0.00 0.00 0.00 30-100481055 Street Repair -Solid Waste Cntr 0 112,000.00 111,492.79 28,912.85 140,405.64 28.405.&1 28,405.64 10-100-481095 Cemetery Donations 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100486070 Cap Comr-neighorhood Imp Pro 0 0.00 COQ QM 004 000 0.00 122,685.53 133,863.53 28,912.85 162,776.38 40,090.85 40,090.85 Other Operating Revenues 10-100450187 Special sn Program 0 0.00 0.00 0.00 0.00 0.00 0.00 30-100450188 Adoption Voucher Program 0 0.00 0.00 0.00 0.00 0.00 0.00 10.100480011 Police Evidence Funds 0.00 17,042.69 0.00 17,042.09 17,042.09 17,042.09 10-100.481069 Utility Audit Revenue 0.00 301.91 0.00 301.91 301.91 301.91 10-100481070 Miscellaneous 0 31,716.00 137,829.68 2,500.00 140,329.68 108,613.68 108,613.68 30.100.481072 TIF Prof Svu Deposit 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481074 Revenue Share -Purchasing Card 0.00 5,101.51 0.00 5,101.51 51101.51 5,101.51 10-100481077 Insurance Claims 0 42,597.00 33,784.12 619.42 34,403.54 (8,193.46) (8,193.46) 10-100481078 Cafeteria Refunds 0 30.000.00 0.00 10.000.00 300 00.00 0.00 0.00 84,313.00 194,059.31 13,119.42 207,178.73 122,865.73 122,865.73 Interest Income 10-100470010 Interest 0 901000.00 105,711.56 3,783.28 109,494.84 19,494.84 19,494.84 10-100470051 Unrealized Gains and Losses 0 0.00 000 0.00 0.00 0.00 0.00 90,000.00 305,711.56 3,783.28 109,494.84 19,494.84 19,494.84 Other Non Operating Revenue 10.100-485049 Cap Vhcl Equip sale of assets 0 O.OD 0.00 0.00 0.00 0.00 0.00 10-100.485050 Sale Of Assets 0 25.000.00 1]3. 06.00 7.694.00 25.000.00 Q,QQ 0Q0 25,000.00 17,306.00 7,694.00 25,000.00 0.00 0.00 Operating Transfers In CFr2015 Revenue Model Report (Detail) For Period Ending September 30, 2015 Description 10-100490193 Trsfer From Grant Fund 10-300-490240 Tmfr From lodging Tax 10-100490260 Trsfr from Fireman's Spec Rev 10-100490280 Trnffrom Stoneridge TDD 10-100490353 Transfer From Cit "e" 10-100.490600 Transfer from Water Fund 10-100390620 Transfer from Parking Fund Remaining Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification Month Budget As of9/30/2015 15 -Oct TOTAL (Under)Budget of Formulas 0 0.00 0.00 0.00 0.00 0.00 0.00 0 24,100.00 19,268.03 3,662.62 22,930.65 (1,169.35) (1,169.35) 0 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0 10,9.44,00 19,444,09. 9.44 14.444:44 4,44 2-M 34,100.00 29,268.03 3,662.62 32,930.65 (1,169.35) (1,169.35) 30,009,567.81 26,900,765.00 4,640,566.09 31,541,331.09 1,531,763.28 1,531,763.28