Loading...
HomeMy Public PortalAbout2014-05 Meeting - Revenue Model ReportREVENUE MODEL REPORT (SUMMARY) For Period Ending April 30, 2014 Data as of 5-02-14 for period ending 4-30-14 CFY 2014 YTD Actual Projected Over/ Description Budget As of 4-30-14 (Under) Budget Sales Tax and Use Tax $ 9,640,000 .00 $ 3,991, 732.69 ** $ 201,216.69 Intergovernmental Taxes $ 2,080,000.00 $ 506,674.38 $ 25,996.15 Other Taxes $ 120,000.00 $ 47,208.52 $ 5,085 .28 Franchise & Utility Tax $ 7,040,000.00 $ 3,216,264.75 $ 304,405 .28 Property Taxes $ 5,209,000.00 $ 5,082,138.74 $ (802.44) Intergovernmental $ 6,610.00 $ 6,610.00 $ Charges for Services $ 2,082,965.63 $ 1,647,984.33 $ (8,038.07) Fees, Licenses, & Permits $ 713,600.00 $ 334,422 .43 $ 7,328 .09 Fines & Forfeitures $ 1,009,980.00 $ 484,364.56 $ (40,562.23) Contributions/Donations $ 117,740.00 $ 78,550.11 $ Other Operating Revenues $ 44,000.00 $ 43 ,800.13 $ 18,907.33 Interest Income $ 65,000.00 $ 46,308.28 $ 6,590.07 Other Non Operating Revenue $ 20,000.00 $ $ (6,417.77) Operating Transfers In $ 21,940.00 $ 9,383.57 $ 558.76 Totals $ 28,170,835 .63 $ 15,495,442.49 $ 540,499.71 **Includes May 2014 actua l sales tax receipts amount NOTES for May Finance Meeting: No Changes in Budget Amounts from March to April; CFY2014 Revenue Model Report (Detail) For Period Ending April 30, 2014 Description Sales Tax and Use Tax 10-100-400010 10-1 00-400020 Sales Tax {Inc . Marc h Actua l) Sa les Tax Interest Intergovernmental Taxes 10-100-401030 10-100-403010 10-100-430080 Other Taxes 10-100-403020 Motor Vehicle Sales Tax Gasoline Tax Road & Bridge Ta x Cig Tax Start Month 2 2 2 0 1 Budget 9,640 ,000.00 0.00 9 ,640,000.00 430,000 .00 1 '1 00,000.00 550.000.00 2 ,080,000.00 Initial Estimated Revenue YTD Actual As of 4-30-14 9 ,640,000.00 3,991 ,732 .69 0 .00 3,991,732.69 450,469.49 1,095,781 .10 550,000.00 159,543.53 347,130.85 0.00 506,674.38 120,000.00 131,715.76 47.208.52 Remaining Estimated Revenues 5-14 thru 10-14 5,849 ,484.00 0.00 5,849,484.00 313 ,276.13 747,806.64 538.239.00 1,599 ,321. 77 Franchise & Utility Tax _________________ 1~2~0 ~0~00~-~00~------------------4~7~,2 ~08~.5~2 ____ __ 77,876.76 77 876.76 10-100-410020 Electric Utility Lie Tax 10-100-410030 Gas Utility License Ta x 10-100-41005 2 10-100-410053 10-100-410060 10-100-410061 Property Taxes 10-100-420010 10-100-420020 10-100-420040 10-10 0 -420050 10-100-420055 10-100-420060 10-100-420080 Telephon e Cell w/o audit mon ey Telecom Audit Cable Franchise Fee Cable Auidt Current Property Ta x Del Property Ta x Fin Institut ion Ta x Prop Tax lnt & Penalties Surtax Receipts-County Reimb Surtax Receipts Special Ta x Rev I nte rgovernme nta I 10-100-430100 State DNR Historic Pres 10-100-480020 NSP Rehab Sales 10-100-480025 HUD Program Income Charges for Services 0-100-440010 Admin Charge Backs 10-100-440050 10-100-440210 10-100-440910 10-100-440920 10-100-440930 10-100-450189 10-100-481020 10-100-481030 10-100-481040 10-100-481045 10-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 Co le Ct 911 Reimb R/1 1 1 1 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 $ 3,220,000.00 925,000.00 2,4 SO,OOO.OO 110,000.00 335,000.00 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.00 5,209,000.00 0 .00 0.00 6,610.00 6,610.00 1,225,559 .00 0 .00 25 ,000.00 0 .00 91,600.00 137,400.0 0 0.00 100,000.00 6,500.00 12,000.00 80,000.00 358,228 .63 3,422,802.04 908,060.23 2,383,173.00 337,942.30 4,570,217.73 64,812.15 16,519.75 29,246.15 54,399.28 471,744.89 27,359 .89 6,610.00 1,225,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 $ 1,336,510.18 745,760.47 945,712.25 4,717.84 179,564.01 2,282 ,224.24 306,470.02 1,3 70,2 15 .06 0.00 169,231.21 4,000.00 :::;.$ _____ _ 3,216,264.75 4,463,099. 73 28,674.17 41,534 .94 11,709.43 54,399.28 466,268.14 16.453.05 5,082,138. 74 0.00 0.00 6.610.00 6,6 10.00 1,225,559 .00 0.00 14,614.00 8,672.09 62,566.85 58,664.82 100.00 50,000.00 6,500.00 0.00 32,038.70 179,160.52 4,128,140 .53 61,861.13 28,534.45 1,175.25 17,374.59 0.00 6,331.05 10.782 .37 126,058.83 0 .00 0.00 0.00 0.00 0.00 0.00 12,390.00 0.00 44,801.50 67,489.55 o.oo 50,000.00 0.00 12 ,000.00 53,039.30 178,322.88 $ Actual & Estimated TOTAL Projected Over I Verification (Under ) Budget of Formulas 9 ,841,216.69 0.00 9,841,216.69 472 ,819.66 1,094,937.49 538.239.00 2,105,996.15 201 ,216 .69 0.00 201,216.69 42 ,819.66 (5,0 62.51) ( 11 , 761 .00) 25,996.1S 3,618, 734.42 398,734.42 1,052,230.49 127,230.49 2,315,927.31 (134 ,072 .69) 4,717 .84 (105 ,282 .16) 348,795.22 13,795.22 4,000.00 ;,:_$ __ ___:,4,~00::.::0::.::.0~0 7,344,405.28 304,405.28 4,524,960.86 57,208.62 42 ,710.19 29 ,084.02 54,399.28 472,599.19 27.235.42 5,208,197.57 0 .00 0 .00 6,610.00 6,610.00 1,225,559.00 o.oo 27,004.00 8,672.09 107,368.35 126,154.37 100.00 100,000.00 6,500.00 12,000.00 85,078.00 357,483.40 (75,039.14) 17,208.62 32,710.19 9,084.02 399.28 2,599.19 12,235 .42 (802.44) 0.00 0.00 0.00 o.oo 0.00 0.00 2,004 .00 8,672.09 15,768.35 (11,245.63) 100.00 0.00 0.00 0.00 5,078.00 (745 .23) 20 1,2 16.69 llQ!! 201 ,2 16.69 42,819.66 15,062.5 11 (11 ,761.00) 25,996.15 5 .085,28 5,085 .28 398,734.42 127,230.49 (134,072.691 (105,282.161 13,795.22 4,000.00 304,405.28 (75,039.14) 17,208.62 32,710.19 9,084.0 2 399.28 2,599.19 12.235 .4 2 (802 .44) 0.00 0.00 Q&Q 0.00 0.00 0.00 2,004.00 8,672.09 15,768.35 (11,245.63 100.00 0.00 0.00 0.00 5,078.00 (745.23) CFY2014 Revenue Model Report (Detail) For Period Ending April30, 2014 -1.-0--1--=o'""o--48-=-1-=o-=8"'0 --S-1 _f_De/scrlptlon a e 0 Maps gis Data 10-100-481085 Cole Cty Gis Joint Coop 10-100-481090 Cole Cty Sheriff-New World 10-100-481100 Sale Of Grave Sites 10-100-481110 Long & Short Fees, Licenses, & Permits 10-100-450010 Liquor Li ce nses 10-100-450020 10-100-450021 10-100-450030 10-100-450040 10-100-450041 10-100-4500 45 10-100-450050 10-100-450060 10-100-450070 10-100-450080 10-100-450090 10-100 -450091 10 -100-45009 2 10-100-450100 10-100-450110 10-100-450120 10-10 0 -450130 10-100-450150 10-100 -450160 10-100-450170 10-100-4501 80 10-100-450185 10-100-450186 10-100-450190 10-100-450230 10-100-450250 10-100-450260 Business Licenses Home Occupation Pe rm it Solicitors Lie Abandoned Bldg . Reg Abandoned Bldg . Admin Fee Bldg. Con str Fe es Elect rical Ce rt ifi ca tes Electrical Pe rmits Plumb ing Lice nse s Plumb ing Perm it s Oth er Lie & Pe rm its Day Care Inspectio n Fees Food 1 nspection Fees Curb Cut Perm its Board Of Adj Fees Sign Perm it s Demolition Permits Ace Rep Fees-police Accrpt/bla stg P-fire Animal Re demption Fees Anima l Va ccinations Fees Animal Crematio n Fees Animal Boarding Fee s 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 Jail Co st Recovery Alcohol Offense Cost Rec Pol Fines-traffic Pol Tickets-parking Pol fines -Other Dog Fines P & Code Violations Start Month Budget 0 ---0.00 15,000.00 28,678.00 3,000.00 0.00 2,082,965.63 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 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 8 8,000.00 1,500.00 1,200.00 4,000.00 500.00 1 2,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 Initial Estimated Revenue 0.00 15,000.00 0.00 3,000.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 YfD Actual Asof4-30-14 140.00 7,500.00 0.00 2,400.00 68.35 1,647,984.33 54,597.50 97,493.93 988 .00 0.00 44.00 4,408 .17 82,789.99 15 ,304.00 1,41 6.4 8 11,114.00 2,757 .25 2,4 60.78 3,375 .00 4 ,602.33 208.00 824.00 2,423.00 416.00 5 ,769.00 359.00 23,520.00 2,250.00 10,538.00 0.00 0 .00 390.00 5 ,284.00 1,090.00 334,422.43 35,870.82 437.38 5,712.44 5,496.99 4,213.50 397,977.68 0.00 0.00 0 .00 0.00 Remaining Estimated Revenues 5-14thru 10-14 0.00 7,5 00.00 0.00 1,400.00 0.00 426,943.23 19,671.25 122,064 .86 566.00 0.00 0.00 0.00 79 ,392 .23 2,45 3.00 2,939 .18 1,399.00 2,948.75 487.50 5,322.50 85,537.37 1,068.00 0 .00 3,450.00 566.00 6,392.03 532.00 27 ,962.50 2,862.50 12,470.00 0.00 450.00 215.00 7,016.00 740.00 386,505.66 41,115.24 970.06 6,591 .68 5,074.33 4,351.75 420,827.97 0.00 0 .00 0.00 0.00 Actual & Estimated TOTAL 140.00 15,000.00 0.00 3,800.00 68 .35 2,074,927 .56 74 ,268 .75 219 ,558 .79 1,554 .00 0.00 44 .00 4,408 .17 162,18 2.22 17,757 .00 4,355.66 12 ,513 .00 5,706 .00 2,9 48.28 8,697.50 90,139.70 1,276.00 824.00 5,873 .00 98 2.00 12,161.03 891.00 51,482.50 5,112.50 23,008.00 0.00 450.00 605.00 12,300.00 1,830.00 720,928.09 76,986.06 1,407.44 12,304.12 10,571.32 8,565.25 818,805 .65 0.00 0.00 0 .00 0 .00 Verification of Formulas 140.00 0.00 0.00 (2 8,678 .00) (28,678.00) 800 .0 0 800.00 68 .3S ~ (8,038 .07 ) (8,038.07) 9,268 .75 9,168.7S 14,558.79 14,558.79 54 .00 54.00 0.00 0.00 44 .00 44.00 4,408.17 4,408.17 (3 7,817. 78) (37,8 17.78) 1,757.00 1,757.00 1,8S5 .66 1,855.66 2,513.00 2,513.00 706.00 706.00 1,448.28 697.50 2,139.70 (224.00) (376 .00) 1,873 .00 482.00 161.03 391.00 (1 ,517.50) 612.50 3,008.00 0.00 (50.00) 205 .00 2,300.00 (1,170.00) 7,328 .09 (3 ,013.95) 107.44 224.12 571.32 (1,434.75 ) (31,194.35 ) (1,000.00) 0.00 0 .00 0.00 1,448.18 697.50 2,139.70 (224 .00) (376 .00) 1,873.00 482.00 161.03 391.00 (1,5 17.50) 611.50 3,008.00 0.00 (50.00) 205.00 2,300.00 11.170.00) 7,3 28.09 (3,013.95) 107.44 224.12 571.32 (1,434.7S) (31,194.35) (1,000.00) 0 .00 0.00 0.00 CFY2014 Revenue Model Report (Detail) For Period Ending April 30, 2014 10-100-460090 10-100-460100 Description Parking Fines Bankcard Charges Contri 6utions/ Donations 10-100-430055 10-100-480010 10-100-480015 10-100-480030 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 DARE Contri Citizen Participation Sidewalk Waiver Revenue Donations-Recycling Sober Driver Program JC Fire Museum Private Donations-Cultural Art Cultural Arts Community Proj ects Donations Dare Donations Police K-9 Donations AnimalS Donations Transfer Stn/Ping-Sid Wst Cntr Street Repair-Solid Waste Cntr Cemetery Donations Cap Contr-neighorhood Imp Pro Other Operating Revenues 10-1 00-450187 Spe cial Sn Program 10-100-450188 10-100-481070 10-100-481072 10-100-481077 10 -100-481078 Adoption Vo ucher Program Miscellaneous Tl F Prof Svcs Deposit Insurance Cla i ms Cafeteria Refunds 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 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 Initial Estimated Revenue 41,650.35 (13,843.12) YfD Actual Asof4-30-14 40,840.04 (6,184 .29) 484,364.56 0 .00 711 .93 0.00 0 .00 2,340.00 8,184.50 0 .00 0 .00 700.00 500.00 500.00 9,8 71.3 1 0 .00 55,579.57 0 .00 162.80 78,550.11 Remaining Estimated Revenues 5-14 thru 10-14 14,633.86 (8 ,511 .66) 485,053.22 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 Actual & Estimated Projected Over/ Verifica tion TOTAL (Under) Budget of Formulas 55,473.90 {3 ,126.11) (3 ,126.11 ) (14,695 .95) (1 ,695 .95) (1 ,695 .95 1 969,41_7 . ..;.7..;..8 ___ {40,562.23) (40,562.23) 0 .00 711.93 0 .00 0 .00 6,040.00 8,184.50 0.00 0.00 700.00 500.00 500.00 9,871.31 0 .00 117,302.03 0 .00 162.80 143,972.57 0.00 711.93 0.00 0.00 0.00 8,184.50 0 .00 0.00 0.00 0 .00 0.00 9,871.31 0.00 7,302 .03 0.00 162.80 26,232.57 0.00 711.93 0.00 0.00 0.00 8,184.50 0.00 0.00 0.00 0.00 0.00 9,871.3 1 0.00 7,302.03 0.00 ~ 26,232.5 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 .00 0.00 0.00 0.00 0.00 24,000.00 27 ,535.59 12,885 .82 16,504.41 29,390.23 5,390.23 5,390.23 0 .00 0 .00 0 .00 0 .00 0.00 0.00 20,000.00 12,098.45 30,914.31 2,602 .79 33 ,517.10 13,517.10 13,517.10 0.00 0.00 0.00 0 .00 0.00 .Q&!! ~~~---------------------------------4~4·,o~o~o~.o~o _____________________ 4~3 ~8oo~.1•3~------~1~9 •1•07~-~2o._ ________ _.6~2~9~o-7 •. 3~3 ------•1•8~,9-o.7._3_3 _______ 1~8,~9 o~7 .~33 1-::.-n~te~r~e~st~'lncome 10-100-4 70010 10-100-470051 Interest Unrealized Ga i ns and Losses Other Non Operating Revenue 10-100-485049 Cap Vhcl Equip sale of assets 10-100-485050 Sale Of Assets Operating Transfers In 10-100-490193 Trsfer From Grant Fund 10-100-490240 Trsfr From Lodging Tax 10-100-490260 Trsfr from Fireman's Spec Rev 10-100-490280 Trnf from Stone ridge TDD 10-100-490353 10-100-490600 10-100-490620 Transfer From Cit "e" Transfer from Water Fund Transfer from Parking Fund 0 0 0 0 0 0 0 0 0 0 0 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 65,000.00 20,000.00 19,930.23 46,308 .28 0.00 46,308.28 0 .00 0.00 0.00 0.00 9,383.57 0.00 0.00 0 .00 0 .00 0.00 9,383 .57 25,281.79 0.00 25,281.79 0.00 13,582.23 13,582.23 0 .00 13,115.19 0.00 0.00 0.00 0.00 0.00 13,115.19 71,590 .07 0.00 71 ,590.07 6,590.07 0 .00 6,590 .07 0.00 0.00 13,582.23 (6 ,41 7. 77 ) 13,582.23 __ __,(6;.:_,417.77) 0 .00 22,498.76 0.00 0.00 0.00 0.00 0.00 22,498 .76 0.00 558.76 0.00 0.00 0.00 0.00 0.00 558.76 6,590.07 0.00 6,590.07 0.00 (6,417 .771 (6.417.771 0.00 558.76 0.00 0.00 0.00 0.00 .Q&!! 558.76 CFY2014 Revenue Model Report (Detail) For Period Ending April 30, 2014 Description Start Month Budget 28,170,835 .63 Initial Estimated Revenue YTD Actual Asof4-30-14 15,495,442.49 Remaining Estimated Revenues 5-14 thru 10-14 13,215,892.85 Actual & Estimated TOTAL 28,711,335 .34 Projected Over I Verification (Und er) Budget of Formulas 540,499 .71 540,499.71