Loading...
HomeMy Public PortalAbout2014-07 Meeting - Revenue Model ReportREVENUE MODEL REPORT (SUMMARY) For Period Ending June 30, 2014 Data as of 7-03-14 for period ending 6-30-14 CFY 2014 YTD Actual Projected Over/ Description Budget As of 6-30-14 (Under) Budget Sales Tax and Use Tax $ 9,640,000.00 $ 5,906,417 .14 ** $ 220,450 .14 Intergovernmental Taxes $ $ $ Other Taxes $ Franchise & Utility Tax $ 7,040,000.00 $ 4,370,106.61 $ 457,814.57 Property Taxes $ 5,209,000.00 $ 5,128,372.43 $ (1,111 .88) Intergovernmental $ 6,610.00 $ 6,610.00 $ Charges for Services $ 2,082,965.63 $ 1, 767,347.26 $ Fees, Licenses, & Permits $ 713,600.00 $ 532,050.60 $ Fines & Forfeitures $ 1,009,980.00 $ 653,279.78 $ Contributions/Donations $ 117,740.00 $ 80,959.10 $ Other Operating Revenues $ 44,000.00 $ 87,091.36 $ Interest Income $ 65,000.00 $ 67,295.96 $ Other Non Operating Revenue $ 20,000.00 $ 23,414.00 $ Operating Transfers In $ 21,940.00 $ 15,216.73 $ Totals $ 28,170,835.63 $ 20,041,937.56 $ 828,283.52 **Includes July 2014 actual sales tax receipts amount NOTES for July Finance Meeting: No Changes in Budget Amounts from May to June CF¥2014 Revenue Model Report (Detail) For Period Ending June 30, 2014 Description Sales Tax and Use Tax 10-100-400010 10-100-400020 Sales Tax (Inc. March Actual} Sales Tax Interest Intergovernmental Taxes 10-100-401030 10-100-403010 10-100-430080 Motor Vehicle Sales Ta x Gasolin e Tax Road & Bri dg e Ta x CigTax Fr ancliise & Utility Tax 10-100-410020 10-10 0 -410030 10-100-410052 10-100-410053 10-100-410060 10-100-4100 61 Prope rty Taxes 10 -100-4 20010 10-100 -4 200 20 10-100-420040 10-100-420050 10-100-420055 10-100-420060 10-100-420080 El e ctric Utility Li e Ta x Gas Util ity Li ce n se Ta x Te le ph one Ce ll w/o a udit mon ey Te lecom Audi t Cable Fran chise Fee Ca ble Au idt Cur rent Property Tax De l Property Tax Fin Inst itution Tax Prop Tax lnt & Penalties Su rt ax Receipts -County Reimb Su rtax Rece ipts Sp ecia l Tax Rev Intergovernmental 10-100-430100 St ate DNR Hist oric Pres 10-100-480020 NSP Reha b Sa les 10-100-480025 HUD Program In come Charges for Services 1 0 -100-440010 Admin Ch arg e Backs tt0 -100-440050 Em t Re im bur sem e nt il 0-100-440210 Street Cuts il0-100-440910 Fuel Charge -bac ks !l,0-100-440920 Parts Charge backs !1.0-100-440930 Labor Charge backs Start Month Budget Initial Estimated Revenue YTD Actual As of6-30-14 Remaining Estimated Revenues 7-14 thru 10-14 Actual & Estimated TOTAL Projected Overj Ve rification (Unde r ) Budget of Formulas R/1 2 2 2 0 1 1 1 1 0 0 0 0 0 0 2 0 0 0 $ 9 ,64 0,000.00 0 .00 9,640,000.00 4 30,000.00 1 '1 00 ,000 .00 550.000.00 2,080 ,000.00 120,000.00 120 000.00 3,220,00 0 .00 9 25,000.00 2,4 50,000 .00 110,000.00 335 ,000.00 7,040,000.00 4,600,000.00 40,00 0.0 0 10,000.00 20 ,000.00 54,000.00 470,000 .00 15,0 00.0 0 5,2 09,000 .00 0.00 0.00 6.610.00 6,610.00 9,640,000.00 5,906,417.14 0.00 5,906,417.14 450,469.49 1,095 ,781 .10 550,000.00 131,715.76 3,422,802 .0 4 908,060.23 2,383,173 .00 337,9 42.30 252,751.45 530,896.56 550 .531.66 1,334,179 .67 69 .596.92 69 59 6.92 1,80 6,526 .18 893,582.67 1,304,971.61 164,4 01 .06 196,625 .09 3,954,033.00 0.00 3,954,033.00 22 9,487.83 565 ,448 .67 0.00 794,936 .4 9 54.838.4 0 54,838.40 1,813 ,952.02 177,786.42 966,738.3 1 0.00 169 ,2 31.21 $ 4,000 .00 0:,$ _____ _ 4,S7 0,217.73 64,812.15 16,519 .75 29,24 6.15 54,399.28 47 1,744.89 27,3 59 .89 6,610.00 4,370,106.61 4,491,2 18.05 36,597.46 41,53 4.94 17,482.48 54,399 .28 469,768 .93 17.37 1.29 5,1 28,372.43 0.00 0.00 6.610 .00 6,610.00 3,127,707 .9 6 37,727.51 18,028 .5 5 1,175.2 5 10,973.16 0.00 3,477.02 8,13 4.22 79,515 .70 0.00 0.00 0.00 0.00 $ 9,860,450.14 0.00 9,860,450.14 482,239 .28 1,096 ,345 .23 550 ,531.66 2,129 ,116 .16 124.435.32 124,435 .32 220,450.14 0 .00 220,450.14 52 ,239.28 (3,654 .77) 531.66 49 ,116.16 4 ,435 .32 4,435 .32 3,620,478.20 400,478 .20 1,071,369 .09 146,369 .09 2,271,709 .92 {1 78,290 .08) 164,401.06 54,4 01.06 365 ,856.30 30,85 6.3 0 4,000.00 o:_$ __ __,:,4•:.:;0.:.;00:.:.:.0:.::.0 7,497,814.57 457 ,8 14 .57 4,528,945.56 54,626.0 1 42,710.19 28,455 .64 54,399.28 473,245 .95 25 .505 .51 5,2 07 ,888.13 0.00 0.00 6.610.00 6,610.00 (71,054 .45) 14,626.01 32,710 .19 8,45 5.64 399.28 3,245.95 10,505.51 (1,111 .88 ) 0.00 o.oo 0.00 0.00 220,450.14 MQ 220,450.14 5 2,23 9.28 )3,654 .77) lllli 49,116.16 4,435 .32 4,435.32 400,478 .20 146,369.09 (178,290.081 54,401.06 30,85 6.30 4,000.00 45 7,814.57 (71,054.451 14,626.01 32,710.19 8,4S5.64 399.28 3,245 .9S 10,505.5 1 {1 ,111.88) 0.00 0.00 Q,QQ 0.00 0 1,225,559 .00 1,225,559 .00 1,225 ,559 .00 0.00 1,225,559 .00 0.00 0.00 0 o.oo o.oo 0.00 0.00 0.00 0.00 0 25,000.00 25,411.50 19,210.00 8,865 .00 28,075 .00 3,075.00 3,075.00 0 0.00 11,392.07 0.00 11,392.07 11,392 .07 11,392.07 0 91,600.00 84,442 .07 79 ,167.02 32,647.1 3 111,814.15 20,214.15 20,214.15 0 137,400.00 124,065.41 79,645 .52 46,498.78 126,144 .30 (11,255 .70) {11 ,255 .70 !1.0-100-450189 Animal5helter Bricks 0 0.00 200.00 0.00 200 .00 200 .00 200.00 1 0-100-481020 Cole Cty An imal Res cue 0 100,000.00 100,000.00 50,000.00 50,000.00 100,000.00 0.00 o.oo ~0 -100-481030 Rent City Hall/annex 0 6,500.00 6,500.00 6,500.00 0.00 6,500.00 0.00 o.oo tl0-100-481040 Rent Other 0 12 ,000.00 12,000.00 0.00 12,000.00 12 ,000.00 0.00 o.oo ~0 -100-481045 Rent -tow er Sites 1 80 ,000.00 80,000.00 43,646.49 49,717.75 93,364.24 13,364.24 13,364.24 cn~10 -~1~00~-~48~10~7~5~~Co~le~C~ty~9 ~1 1~R~e~im~b~----------~0~----~3~5~8~,2~28~.~63~------~35~8~,2~2~8~.6~3 ----~2~39~,~02~0~.3~0~----~1~1~8,~88~1~.9~2~--------~3~5~7~,9~0 2~.~22~-------(~3~26~.4~1._l ______ ~lo3~26~.4~1 CFY2014 Revenue Model Report (Detail) Remaining For Period Ending June 30,2014 Start Initial Estimated YfD Actual Estimated Revenu es Actual & Estimated Projected Over/ Verification Description Month Budget Revenue As of 6-30-14 7-14 thru 10-14 TOTAL (Under ) Budget of Formula s r.1~0--.:-1-;;0-::~0_-.48:;;-:-:10;:;8~0:-~Sa~le~O~f~M~a-p-.s/~gi""s ~oa_t_a -----~o ----;;_~o~.o~o~-----~o .~o~o ----~14~o~.o~o-----~o~.o~o,...------~1""'4o"".o'"'o,......;_ _ _;_ 140.00 14o.oo 10-100-481085 Cole Cty Gl s Joint Coop 0 15 ,000.00 15,000.00 10,000.00 5,000.00 15,000 .00 0.00 o.oo 10-100-481090 Cole Cty Sheriff-New World 0 28 ,678 .00 0.00 0.00 0.00 0.00 (28,678.00) {28,678.00 Sale Of Grave Sites Long & Short 0 3,000.00 3,000 .00 2,800.00 200.00 3,000.00 0.00 0 .00 0 0.00 0.00 66 .86 0.00 66 .8 6 66.86 ~ -~-----------....;;.2 ..-;0;:;;8 2""9;;.;6;.;5'-".6""3----------1~76;;.;7*'3'"'4.;..7 .;.;2,;;.6 ___ ....;;.3 :;;23;.~;8;.;1;.;0;.;.5.;;.8 ____ _;;2:,;;,0~9;:,1 ,;;.15;;.;7.;.;.8_4 ___ __.;::8,19 2.21 8,192.21 Fees, Licenses, & Permits . ....,=.;-~--.;:..;;;.;;;.;;;,o 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 So li citors 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 Fees Food Inspection Fees Curb Cut Permits Boa rd Of Adj Fees Sign Permits Demolition Permits Ace Rep Fees-police Accrpt/blastg P-fire Animal Redemption Fees Animal Vaccinations Fees Anim al Cremation Fees Animal Boarding Fees Taxi Permits Vacating Right Of Way Rezoning Request Non-refundable Plan s/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 Rest itutions Inmate Se curity Fund Jail Cost Recovery Alcohol Offense Cost Rec Pol Fines-traffic Pol Ti ckets-parking Pol fines-Other Dog Fin es P & Code Violations 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 61 ,727 .50 146,082 .10 1,040.00 0.00 88.00 5,528 .1 7 114,107.66 16,308 .00 2,871.81 11,217.00 3,347.25 2,460.78 3,375.00 87,789.33 364.00 1,442.00 3,116.00 572.00 7,636.00 379.00 33,370.00 3,330.00 16,531.00 0 .00 300.00 520.00 7,002.00 1,546.00 532,050.60 48,783.26 587.14 7,836.48 7,295.80 5,292.50 549,172.49 0 .00 0.00 0.00 0 .00 4,213.75 68,341.55 364 .00 0.00 0.00 0.00 36,881 .05 1,447.50 2,413.01 1,144.00 1,708.75 487 .50 5,322 .50 2,492.96 968.00 0.00 2,586.00 414.00 4,173 .83 325 .50 18,797.50 1,875 .00 8,523.50 0.00 150.00 215.00 5,047.00 477.50 168,369.39 28,700.67 870.11 4,575.03 3,004.30 2,747.00 294,547.71 0 .00 0.00 0 .00 0 .00 65,941.25 214,423.65 1,404.00 0.00 88.00 5,528.17 150,988 .71 17,755 .50 5,284.82 12,361.00 5,056.00 2,948 .28 8,697.50 90,282.29 1,332.00 1,442.00 5,702 .00 986.00 11,809.83 704.50 52,167.50 5,205.00 25,054.50 0.00 450.00 735.00 12,049.00 2,023.50 700,419.99 77,483 .93 1,457.25 12,411.51 10,300.10 8,039.50 843,720.20 0 .00 0.00 0 .00 0.00 941.25 9,423.65 (96.00) 0.00 88 .00 5,528 .17 (49,011.29) 1,755 .50 2,784.82 2,361.00 56.00 1,448 .28 697 .50 2,282 .29 (168.00) 242 .00 1,702.00 486 .00 (190.18) 204.50 (832.50) 705.00 5,054.50 0 .00 (50.00 ) 335 .00 2,049.00 (9 76.50) (13 ,180 .01 ) (2,5 16.08 ) 157.25 331.51 300.10 (1,960.50) (6,279.80 ) (1 ,000.00) 0.00 0.00 0.00 941.2S 9,423 .65 {96.00) 0.00 88.00 5,528.17 149,011.29) 1,7S5 .5 0 2,784.8 2 2,361.00 56.00 1,448.28 697.50 2,282.29 (168.00) 242.00 1,702.00 486.00 (190.17) 204.50 (832.50) 705 .00 5,054.50 0.00 (50.00) 335 .00 2,049.00 (976.50! (13,180.01) (2,516.08) 15 7.25 331.51 300.10 (1 ,960.50) (6,279.80) (1,000.00) 0.00 0.00 0.00 CFY2014 Revenue Model Report (Detail) For Period Ending june 30, 2014 10-100-460090 10-100-460100 10-100-480050 10-100-480055 10-100-480063 10-100-480065 10-100-480070 10-100-480080 10-100-480090 10-100-480165 10-100-481050 10-100-481055 10-100-481095 10-100-486070 10-100-450188 10-100-481070 10-100-481072 0-100-481077 0-100-481078 Description Park ing Fines Bankcard Charges DARE Contri Citizen Participation Sidewalk Waiver Revenue Donations-Recycling Sober Driver Program JC Fire Museum Private Donations-Cultural Art Cultural Arts Community Projects Donations Dare Donations Police K-9 Donations Animal S Donations Transfer Stn/Ping-Sid Wst Cntr Street Repa ir-Solid Wast e Cn tr Cemetery Donations Cap Contr-neighorhood Imp Pro Special Sn Program Adoption Voucher Program Miscellaneous TIF Prof Svcs Deposit Insurance Claims Cafeteria Refunds Interest Income 10-100-470010 10-100-470051 -~I n-t-er-est Unrealized Gains and Losses Other Non Operating Revenue 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 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 44,000 .00 65 ,000.00 0.00 65,000.00 10-100-485049 Cap Vhcl Equip s-a"'le-o-;f -a -ss-e""ts---o,..------~0-:.oo"'"" 10-100-485050 Sale Of Assets o 20,000.00 --------------20,000.00 Operating Transfers In 10-100-490193 Trsfer From Grant Fund 10-100-490240 Trsfr From Lodging Tax 10-100-490260 10-100-490280 10-100-490353 10-100-490600 10-100-490620 Trsfr from Fireman's Spec Rev Trnf from Stoneridge TDD Transfer From Cit "e" Transfer from Water Fund Transfer from Parking Fund 0 0 0 0 0 0 0 0.00 21,940.00 0.00 0 .00 0.00 0.00 0.00 21,940.00 Initial Estimated Revenue 41 ,650.35 (13,843 .12) 27,535.59 12,098.45 65 ,000.00 20,000.00 19,930.23 YTD Actual Asof6-30-14 45 ,154.94 (10,842.83) 653,279.78 0.00 711.93 0 .00 0.00 2,340 .00 9,384.50 0.00 800.00 700 .00 500.00 500.00 10,280.30 0 .00 55,579.57 0.00 162.80 80,959 .1 0 0.00 0.00 56,039.05 0.00 31,052.31 0 .00 87,091.36 67,295.96 0 .00 67,295 .96 17,000.00 6.414.00 23 414.00 0.00 15,216.73 0.00 0.00 0 .00 0.00 0.00 15,216.73 Remaining Estimated Revenues 7-14 thru 10-14 7,217.16 (5,005 .25) 336,656.72 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 14,943 .37 0.00 2,602 .79 0 .00 17,546.16 19,705 .92 0 .00 19,705 .92 0.00 7,168.23 7,168.23 0.00 7,470.60 0.00 0.00 0 .00 0.00 0.00 Actual & Estimated TOTAL 52,372.10 (15,848.08) 989,936.50 0 .00 711 .93 0.00 0 .00 6,040.00 9,384.50 0 .00 800.00 700.00 500.00 500.00 10,280.30 0.00 117,302.03 0 .00 162.80 146,381.56 0 .00 0 .00 70,982.42 0 .00 33,655 .10 0 .00 104,637.52 87,001.88 0 .00 87,001.88 17,000.00 13,582.23 30,582.23 0 .00 22,687 .33 0 .00 0.00 0.00 0 .00 0.00 7,470.60 ----22,687.33 Projected Over I Verification (Under) Budget o f Formulas (6,227 .90) (6,227.90) (2,848 .08) 12.848.081 (20,043.50) (20,043 .50) 0.00 711 .93 0 .00 0.00 0.00 9,384.50 0.00 800.00 0.00 0.00 0.00 10,280.30 0.00 7,302 .03 0.00 162.80 28,641.56 0.00 0.00 46,982.42 0.00 13,655 .10 @.00 60,637.52 22,001.88 0.00 22,001 .88 17,000.00 (6 ,4 17.77) 10,582 .23 0.00 747 .33 0.00 0.00 0.00 0.00 0.00 747.33 0.00 71 1.93 0.00 0.00 0.00 9,384.5 0 0.00 800.00 0.00 0.00 0.00 10,280.30 0.00 7,302.03 0.00 ill!Q 28,64 1.56 0.00 0.00 46,982.42 0.00 13 ,655.10 lL!!Q 60,637.5 2 22,001.88 lL!!Q 22,001.88 17,000.00 (6,417.771 10,582.23 0.00 74 7.33 0.00 0.00 0.00 0.00 lL!!Q 747.33 CFY2014 Revenue Model Report (Detail) For Period Ending June 30, 2014 Description Start Month Budget 28,170,835.63 Initial Estimated Revenue YTD Actual As of6-30-14 20,041,937.56 Remaining Estimated Revenues 7-14thru 10-14 8,957,181 .59 Actual & Estimated TOTAL 28,999,119.15 Projected Over I Verification (Under) Budget of Formulas 828,283.52 828,283.52