Loading...
HomeMy Public PortalAbout2014-06 Meeting - Revenue Model ReportREVENUE MODEL REPORT {SUMMARY) For Period Ending May 31, 2014 Data as of 6-03-14 for period ending 5-31-14 CFY 2014 YTD Actual Projected Over/ Description Budget As of 5-31-14 (Under) Budget Sales Tax and Use Tax $ 9,640,000.00 $ 4,857,663 .14 ** $ 44,132 .14 Intergovernmental Taxes $ 2,080,000.00 $ 1,200,526.79 $ 51,434.87 Other Taxes $ 120,000.00 $ 58,117.92 $ 4,946.30 Franchise & Utility Tax $ 7,040,000.00 $ 3,847, 711.27 $ 419,096.23 Property Taxes $ 5,209,000.00 $ 5,108,071.77 $ 1,503.34 Intergovernmental $ 6,610.00 $ 6,610.00 $ Charges for Services $ 2,082,965.63 $ 1, 707' 324.42 $ 363.15 Fees, Licenses, & Permits $ 713,600.00 $ 459,913.45 $ (6,796 .02} Fines & Forfeitures $ 1,009,980.00 $ 570,194.49 $ (31,189 .69) Contributions/Donations $ 117,740.00 $ 79,716.10 $ 27,398.56 Other Operating Revenues $ 44,000.00 $ 86,255.30 $ 60,705.08 Interest Income $ 65,000.00 $ 58,676.27 $ 18,958.06 Other Non Operating Revenue $ 20,000.00 $ 23,414.00 $ 10,582.23 Operating Transfers In $ 21,940.00 $ 13,131.16 $ 662.21 Totals $ 28,170,835.63 $ 18,077,326.08 $ 601,796.46 **Includes June 2014 actual sales tax receipts amount NOTES for June Finance Meeting: No Changes in Budget Amounts from April to May CFV2014 Revenue Model Report (Detail) For Period Ending May 31, 2014 Description Sales Tax and Use Tax 10-100-400010 10-100-400020 Sales Tax (Inc. March Actual) Sales Tax In te rest Intergovernmental Taxes 10-100-401030 10-100-403010 10-100-430080 Other Taxes Motor Veh icle Sales Ta x Gasoline Tax Road & Bridge Tax CigTax Start Month 2 2 2 0 Electric Utility Lie Ta x 1 Gas Utility Li ce nse Tax 1 Te le phone Cell w/o audit mon ey 1 Telecom Audit Cab le Franchise Fee R/1 Budget 9,640,000.00 0.00 9,640,0 00.00 430,000.00 1 '1 00,000.00 550,000.00 2,080,000.00 120,000.00 120 000.00 3,220,000.00 925,000.00 2,450,000.00 110,000.00 335,000.00 10-100-410030 10-100-410052 10-100-410053 10-100-410060 10-100-410061 Cable Auidt :::.$ ______ _ Property Taxes 10-100-420010 10-100-420020 10-100-420040 10-100-420050 10-100-420055 10-100-420060 10-100-420080 Current Property Tax Del Prop e rty Tax Fin Institution Tax Prop Ta x ln t & Penalties Surtax Receipts-County Reimb Surtax Receipts Special Tax Re v Intergovernmental 10-100-430100 State DNR Historic Pres 10-100-480020 NSP Rehab Sales 10-100-480025 HU D Program Income Charges for Services 10-100-440010 Admin Charge Backs 10-1 00-440050 10-100-440210 10-100-440910 10-100-440920 0-100-440930 10-100-450189 10-100-481020 10-100-481030 10-100-481040 10-100-481045 0 -100-481075 Emt Reimbursement Street Cuts Fuel Charge -backs Parts Charge backs Labor Charge backs Animal Shelter Bricks Cole Cty Animal Rescue Rent City Hall/annex Rent Other Rent-tower Sites Cole Cty 911 Reimb 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 7,040,000.00 4,600,000 .00 40,000.00 10,000.00 20,000.00 54,000.00 470,000.00 15 ,000.0 0 5,209,000.00 0.00 0.00 6,610.00 6,610.00 1,225,559.00 o.oo 25,000.00 0 .00 91,600.00 137,400.00 0 .00 100,000.00 6,500.00 12,000.00 80,000.00 358 228.63 Initial Estimated Revenue YTD Actual As of 5-31-14 9,640,000 .00 4,857,663.14 0.00 4,857,663.14 450,469.49 1,095,781 .10 550,000.00 131,715.76 211,639 .70 438,355.43 550,531.66 1,200,526. 79 58.117.92 58,117.92 3,422,802.04 1,570,357.12 908,060.23 840,651.50 2,383,173 .00 1,125,264.61 119,401.06 337,942.30 188,036.98 Remaining Estimated Revenues 6-14 thru 10-14 4,826,469.00 0.00 4,826,469.00 274,458 .94 656,449.14 0 .00 930,908.08 66 .828.3 8 66 ,828.38 2,046,182.82 229,807.76 1,166,163.18 0.00 169,231.21 $ 4,000.00 ;:;_$ _____ _ 4,570,217.73 64,812.15 16,519.75 29,246 .15 54,399.28 471,744.89 27,3 59 .89 6,610.00 1,22 5,559 .00 25,411.50 84,442 .07 124,065.41 100,000.00 6,500.00 12,000.00 80,000.00 358,228.63 3,847,711.27 4,477,471.05 34,541.77 41,534.94 15,320.68 54,399.28 468,188.20 16.615.85 5,108,071. 77 0.00 0 .00 6.610.00 6,610.00 1,225,559.00 0.00 15,492.00 9,975.84 73,362 .00 71,386.92 200.00 50,000.00 6,500.00 o.oo 34,399.90 209,090.41 3,611,384.96 47,003 .61 24,835.21 1,175 .25 14,702.91 0.00 4,837.29 9.877.31 102,431.57 0.00 0.00 0.00 0.00 0.00 0.00 11,040.00 o.oo 39,618.35 56,375.87 0 .00 50,000.00 0.00 12,000.00 50,717.75 148,602.40 $ Actual & Estimated TOTAL Projected Over I Verification (Under ) Budget of Formulas 9,684,132.14 0 .00 9,684,132 .14 486,098.64 1,094,804.S7 S50.531 .66 2,131 ,434 .87 124 .946.3 0 124,946.30 44,132.14 0.00 44,132.14 56,098.64 (5,195.43) 531.66 51,434.8 7 4.946 .30 4,946.30 3,6 16,539 .94 396,539.94 1,070,459 .26 145,4S 9.26 2,291,427.79 (158,572.21) 119,401.06 9,401.06 357,268.19 22 ,268 .19 4,000.00 .::..$ -----"4,c:.OO::..:O:.:..:.O~O 7,459,096.23 419,096.23 4,524,474.67 59 ,376 .98 42,710.19 30,023 .S9 54,399.28 473,025.49 26.493.16 5,210,503.34 0.00 0.00 6.610.00 6,610.00 1,225,559 .00 o.oo 26 ,532.00 9,975.84 112,980.35 127,762 .79 200.00 100,000.00 6,500.00 12 ,000 .00 85,117.65 357,692.81 (75,525.34) 19,376.98 32,710.19 10,023.5 9 399.28 3,025.49 11.493.16 1,503.34 0.00 0.00 0.00 0.00 G.OO 0.00 1,532.00 9,975 .84 21,380.35 (9,637.21) 200.01!) 0.00 o.oo 0.00 5,117.65 44,132.14 Mil 44,13 2.14 56,098.64 15,195 .44) ~ 51,434 .86 4,946.30 4,946.30 396,539.94 145,459.26 (158,572.21) 9,401.06 22,268.19 4,000.00 419,096.23 175,525 .34) 19,376.98 32,710.19 10,023.59 399.28 3,025 .49 11,493.16 11503.34 0.00 0.00 QJlQ 0.00 0.00 0.00 1,532.00 9,975 .84 21,380.35 19,637.21) 200.00 0.00 0.00 0.00 5,117.65 535.82 CFY2014 Revenue Model Report (Detail) For Period Ending May 31, 2014 10-100-481080 10-100-481085 10-100-481090 10-100-481100 10-100-481110 Description Sale Of Maps/gis Data Cole Cty Gis Joint Coop Cole Cty Sheriff-New World Sale Of Grave Sites Long & Short Fees, licenses, & Perm1ts 10-100-450010 Liquor Licenses 10-100-450020 10-100-450021 10-100-450030 10-100-450040 10-100-450041 10-100-450045 10-100-450050 10-100-450060 10-100-450070 10-100-450080 10-100-450090 10-100-450091 10-100-450092 10-100-450100 10-100-450110 10-100-450120 10-100-450130 10-100-450150 10-100 -450160 10-100-450170 10-100-450180 10-100-450185 10-100-450186 10-100-450190 10-100-450230 10-100-450250 10-100-450260 Business Licenses Home Occupation Permit Solicitors Lie Abandoned Bldg . Reg Abandoned Bldg. Admin Fee Bldg . Constr Fees Electrical Certificates Electrical Permits Plumbing Licenses Plumbing Permits Other Lie & Permits Day Care Inspection Fe es Food Inspection Fees Curb Cu t Permits Board Of Adj Fees Sign Permits Demolition Permits Ace Rep Fees-police Accrpt/blastg P-fire Animal Redemption Fees Animal Vacc inations Fees Animal Cremation Fees Animal Boarding Fees Ta xi Permits Vacating Right Of Way Rezoning Request Non-refundable Plans/spec Fines & Forfeitures 10-100-460010 10-100-460015 10-100-460018 10-100-460020 10-100-460025 10-100-460030 10-100-460040 10-100-460050 10-100-460060 10-100-460070 Court Cost Court Restitutions Inmate Security Fund Ja il Cost Recovery Alcohol Offense Cost Rec Pol Fines-traffic Pol Tickets-parking Pol fines -Other Dog Fines P & Code Violations Start Month 0 0 0 0 0 Budget 0.00 15 ,000.00 28 ,678.00 3,000.00 0.00 Initial Estimated Revenue o.oo 15 ,000.00 0.00 3,000.00 0.00 Remaining YTD Actual Estimated Revenues AsofS-31-14 6 -14thru 10-14 140.00 o.oo 8, 750.00 6,250.00 0.00 0.00 2,400.00 1,400.00 §lU2 Q&.Q -----.:2:~.::•0:.:::8 ;;,2 ,:::.96~5:.w.6::::3._ ________ ...;;.,1, .... 70::u7'-!:,3::.:2;.;4,;,;.4:::,2 ____ 376,004.36 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 65,000.00 205 ,000.00 1,500.00 0.00 0.00 0.00 200 ,000.00 16,000.00 2,500 .00 10,000.00 5,000.00 1,500 .00 8,000.00 88,000.00 1,500.00 1,200.00 4,000.00 500.00 12,000.00 500.00 53,000.00 4,500.00 20,000.00 0.00 500.00 400.00 10,000.00 3,000.00 713,600.00 80,000.00 1,300.00 12,080.00 10,000.00 10,000.00 850,000.00 1,000.00 0.00 0 .00 0 .00 64,405.00 216,000.00 1,666.00 129 ,807.55 16,398.00 4,592 .37 10,384.00 5,937.50 2,597 .19 8,515 .00 86,739 .25 1,518.00 5,240.00 916.00 12,387.67 793.50 52,360.00 5,140.00 23,665 .00 0 .00 500.00 315 .00 11,651 .00 2,727.25 82,550.20 1,986.90 13,155.29 11,661 .07 9,810.00 836,162.54 59,112 .50 102,259 .35 1,040.00 0.00 44 .00 4,952.17 105 ,863.86 16,069 .00 2,445.21 11,217 .00 3,077.25 2,460 .78 3,375 .00 87,348.33 312.00 1,030.00 3,064.00 520.00 6,528.00 365 .00 27,590.00 2,800.00 10,538.00 0.00 0.00 390.00 6,112.00 1,400.00 459,913.45 42,047 .69 537.16 6,733.47 6,503.93 4,811.50 473,917.79 0 .00 0.00 0.00 0 .00 9,004.79 108,538 .85 466 .00 0.00 0.00 0.00 58,733.54 1,583 .00 2,758 .01 1,144.00 2,448.75 487.50 5,322.50 2,434.87 1,068.00 0 .00 3,170.00 516.00 5,287.73 329.50 23 ,577.50 2,487.50 10,274.00 0 .00 450.00 215 .00 6,086 .00 507.50 246,890.53 35,225.52 920.08 4,575.03 3,903.15 3,555.00 358,090.27 0 .00 0.00 0 .00 0.00 Actual & Estimated TOTAL 140.00 15,000.00 0.00 3,800.00 68.35 2,083,328.78 68 ,117.29 210,798.20 1,506.00 0.00 44 .00 4,952.17 164,597.40 17,652 .00 5,203 .22 12 ,361.00 5,526.00 2,948 .28 8,697 .50 89,783 .20 1,380.00 1,030.00 6,234.00 1,036.00 11,815.73 694.50 51,167.50 5,287.50 20,812.00 0.00 450.00 605 .00 12,198.00 1,907.50 706,803.98 77,273.21 1,457.24 11,308.50 10,407.08 8,366.50 832,008.06 0 .00 0 .00 0.00 0.00 Projected Over I Verification (Under) Budget of Formulas 140.00 0.00 (28,678.00) 800.00 68.35 363.15 3,117.29 5,798 .20 6.00 0.00 44.00 4,952 .17 (35,402.61) 1,652 .00 2,703 .22 2,361.00 526 .00 1,448.28 697.50 1,783 .20 (120.00) (170.00) 2,234.00 536.00 (184.28} 194.50 (1,832.50) 787.50 812.00 0.00 (50.00) 205.00 2,198.00 (1,092.50) (6, 796 .02) (2,726.80) 157.24 (771.51) 407.08 (1,633.50) (17,991.95) (1 ,000.00) 0 .00 0.00 0.00 14 0.00 0.00 800.00 §Jill 363.15 3,117.29 5,798.20 6.00 0.00 44.00 4,95 2.17 (35,402.61) 1,652.00 2,703.22 2,361.00 5 26.00 1,448.28 697.50 1,783.20 (120.00) (170.00) 2,234.00 536.00 (184.28) 194.50 (1,832.50) 78 7.50 812.00 0.00 (50.00) 205.00 2,198.00 (1 ,092.50} (6,796.02) (2 ,726.80) 157.24 (771.51) 407.08 (1,633.50) (17,991.95) (1,000.00) 0.00 0.00 0.00 CFY2014 Revenue Model Report (Detail) For Period Ending May 31, 2014 10-100-460090 10-100-460100 10-1 00-480010 10-100-480015 10-100-480030 10-100-480050 0-100-480055 10-100-480063 10-100-480065 10-100-480070 10-100-480080 10-100-480090 10-100 -48 0165 10-10 0 -481 050 10 -100-481 055 10-100-481095 10-100-486070 10-100-450188 10-100-481070 10-100-481072 10-100-481077 10-100-481078 10-100-470010 10-100-470051 10-100-485050 Description Parking Fin es Bankcard Charges DARE Contri Citizen Participation Sidewa l k Waiver Revenue Donations-Recycling Sober Driver Program JC Fire Museum Private Donations-Cultural Art Cultura l Arts Co mm unity Projects Do nations Dare Donations Poli ce K-9 Donations An i mal S Donati o ns Transfer Stn/Ping-Sid Wst Cnt r St reet Rep ai r-Solid Wa ste Cnt r Cemet ery Don ations Cap Co ntr-neighorhood Imp Pro Special Sn Program Adoption Voucher Program Miscellaneous TIF Prof Svcs Deposit Insurance Claims Cafeteria Refunds Interest Unrealized Ga i ns and Losses Cap Vhcl Equip sale of assets Sale Of Ass ets Operating Transfers In 10-100-490193 10-100-490240 10-100-490260 10-100-490280 10-100-490353 10-100-490600 10-100-490620 Tr5fer From Grant Fund Trsfr From Lodging Tax Trsfr from Fireman's Spec Rev Trnf from Stone ridge TDD Transfer From Cit "e" Transfer from Water Fund Transfer from Parking Fund Start Month 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Budget 58,600.00 (13,000 .00 ) 1,009,980.00 0 .00 0.00 0.00 0.00 6,040 .00 0.00 0 .00 0 .00 700.00 500.00 500.00 0.00 0.00 110,000 .00 0.00 0.00 117,740 .00 0.00 0.00 24,000.00 0.00 20,000.00 0.00 44000.00 65 ,000.00 0.00 65,000.00 0.00 20,000.00 20,000.00 0.00 21,940 .00 0.00 0.00 0.00 0.00 0.00 21 ,940.00 Initial Estimated Revenue 41,650.3 5 (13 ,843.1 2} 27,535.59 12,098.45 65,000.00 20,000.00 19,930.23 YTD Actual As of 5-31-14 43,311.04 (7,668.09) 570,194.49 0 .00 711.93 0.00 0.00 2,340 .00 8,834.50 0 .00 200.00 700.00 500.00 500.00 10,1 87 .30 0.00 55,579.57 0.00 162.80 79,716.10 0.00 0.00 55,202.99 0.00 31,052.31 0.00 86,255 .30 58,676.27 0.00 58,676.27 17,000.00 Remaining Estimated Revenues Actual & Estimated Projected Over/ Verification 6-14thru 10-14 TOTAL (Under) Budget of Formulas 9,584.86 52,895 .90 (5 ,704.11 ) (5,704.11) (7,258 .06) (14,926.15) (1 ,926.151 11.926.15) __ 4_o.8 ... 5_9_5._8_3 _____ 9_7_8.;., 7_9_o_.3_2 ___ .;.(3_1.;.,1_8..;..9.69} 131,189.691 0 .00 0 .00 0.00 0.00 3,700.00 0 .00 0.00 0.00 0.00 0 .00 0 .00 0.00 0.00 61,722.46 0.00 0.00 65,422 .46 0.00 0.00 15,846.99 0.00 2,602.79 0.00 18,449.78 25,281.79 0 .00 25 ,281 .79 0 .00 711 .93 0 .00 0.00 6,040.00 8,834.50 0 .00 200 .00 700 .00 500.00 500.00 10,1 87 .3 0 0 .00 117,302.03 0 .00 162.80 145,138.56 0.00 0.00 71,049.98 0.00 33,655 .10 0 .00 104,705.08 8 3,95 8.06 0 .00 83,958 .06 0.00 711.93 0.00 0.00 0.00 8,834.50 0.00 200 .00 0.00 0.00 0.00 10,187.30 0.0 0 7,302 .03 0.00 162.80 27,398.56 0.00 0.00 47,049.98 0.00 13,655.10 0.00 60,705.08 18,958.06 0.00 18,958.06 0.00 711 .93 0.00 0.00 0.00 8,834.50 0.00 200.00 0.00 0.00 0.00 10,187 .30 0.00 7,302.03 0.00 ill&Q 27,398.56 0.00 0.00 47,049.98 0.00 13,6S5.10 Q,QQ 60,705.08 18,958.06 Q,QQ 18,958.06 6,414.00 7,168.23 17,000.00 13,582.23 30,582.23 17,000.00 (6,417 .77) _2;;..;3.:...,4..;;1.;._4 . .;..00;...-___ 7,168.23 0.00 13,131.16 0.00 0.00 0.00 0.00 0.00 13 ,131 .16 0 .00 9,471.05 0 .00 0 .00 0.00 0.00 0.00 9,471.05 0 .00 22,602 .21 0.00 0 .00 0.00 0 .00 0 .00 22,602 .21 10,58;,.;;2,;.;.2;;;.3 ___ ,;,;;:,; __ -.. 0.00 662 .21 0.00 0.00 0.00 0.00 0.00 662.21 0.00 66 2.21 0.00 0.00 0.00 0.00 0.00 662.21 CFY2014 Revenue Model Report (Detail) For Period Ending May 31,2014 Description Start Month Budget 28,170,835.63 Initial Estimated Revenue YTD Actual As of 5-31-14 18,077,326.08 Remaining Estimated Revenues 6-14thru 10-14 10,695,306.01 Actual & Estimated TOTAL 28,772,632.09 Projected Over/ Verification (Un d er) Budget of Formulas 601,796.46 601,796.46