Loading...
HomeMy WebLinkAboutItem 4.06 Fin Report July 1992• . ~ 1 CITY OF DUBLIN AGENDA STATEMENT MEETING DATE: August 24, ~992 SUBJECT :Financial reports for July 31, 1992 ~ (Prepared by the Finance Director) EXHIBITS ATTACHED ~alance Sheets and Income Statements RECOMMENDATIONS ~:Accept and file the financial reports FINANCIAL STATEMENT :{See reports) DESCRIPTION: This is the first monthly financial report for Dublin for the 1992-93 fiscal year. It reflects the new year's budget amounts p)us the receipts and disbursements that occurred in Ju1y. Inclusive of recent adjustments, the 92-93 budgeted appropriations for all funds total $18,455,652, of which $2,376,425 (12.8~) is for capital improvements (CIP). The pie charts of the following page help to place the operating and CIP budgets summarized for a1l funds into perspective. Within the General Fund alone, the activities budgeted can also be compared to other parts of the General Fund budget by means of a pie chart. The chart below s~ows the percentaqe of the budget app7ied to each activity. ---------------------------------------------------------------------- COPIES T0: ITEM N0. ~~ C{TY CLERK FILE ~ .~ 3-~S~ ~E B UD G~ T ~~P~~~i Tu QPERATIONS Vs CIP PRC~JECTS 1992-93 budget CI P ~ k ~ ~ u~ ~ Operations ~ ~ ~ r' ~ ~ u,b,~l r~ ~ I ~~> ~~ ~' - <<=> ~-~ --~ ~ n. ~ (s~~['~ ~ ~ C~~~-~~~~ ~~ ~~l C~1~~ ~>f~~~~, ~;~~~ ~~ ~. percentage funded ~r~nspc>rt~tion C~_~I t~_irc~ o. L.~~-i~i Communi ty D~v~~;l CIP Public Safety ~ J J G~n~;ral Govf~;rnment H~;~~Ith ~' Welf~re CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF JULY 1992 Prepared by The Finance Department BGL102 CITY OF DUBLIN , 8/20/92 BALANCE SHEET ~ FOR THE PERIOD 7/92 THROUGH 7/92 GENERAL SPECIAL SPECIAL CAPIT.~L REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS FUNDS FUNDS FUNDS ASSETS CASH 1081673.77- 1260701.92 1035377.58 1004439.67- CA.SH WITH FISCAL AGENT 117500.00 ONA~(GRTIZED BOND DISCOUNT 937.50 INVESTHENTS AT COST 16313671.88 197528.00 1987972.00 RECEIVABLES:TAXES 38057.08- 534.88- ACCOUNTS (NET) 217326.52- 2579.21- 1278.52- INTEREST 205906.85- ASSESS~ENTS RENTS NOTES DUE FROH OTHERS 1122531.01 INVENTORY AT COST PREP~ID ITF.~IS 1938.67 FIYED ?SSETS A~lOC~NTS TO BE PROVIDED 2232500.00 TOT.~.L ASSETS 15896114.84 1258122.71 3582370.70 982253.81 LI?.B, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELP~T 21536.27 DEPOSITS FOR AB1600 FEES 132301.09- DEPOSITS OTHERS 156276.12- 3125.00- P~YA.BLES:ACCOUNTS 265353.58 154229.14 21758.20 218821.70 INTEREST PAYROLL 14579.42 DUE TO OTHERS 1121031.01- 1500.00- DEBT INSTRUMENTS PAYABLE 2900000.00- TOTAL LIABILTIES 145193.15 966801.87- 2876866.80- 86520.61 FGND BALANCES 16041307.99- 291320.84- 705503.90- 1068774.42- TOTAL FUND EQUITY 16041307.99- 291320.84- 705503.90- 1068774.42- TOT.AI, LI~B,FND BAL, RETD EARNS 15896114.84- 1258122.71- 3582370.70- 982253.81- PAGE 1 9.13.24 BGL102 8/20/92 ASSETS CASH CASH WITH FISCAL AGENT UNAHORTIZED BOND DISCOUNT INVESTHENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESS~iENTS RENTS NOTES DOE FROH OTHERS INBEHTORY AT COST PREP~ID ITEHS FIXED dSSETS A}lOGNTS TO BE PROVIDED TOT~L ASSETS LI~B, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPFINT DEPOSITS OTHERS PAY.~BLES : ACCO[RiTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUHD B~LANCE CONTRIBGTIONS INVESTMENTS IN FIXED ASSETS RET?INED EARNINGS TOTAL FUND EQUITY TOTAL LIAB,FND BAL, RETD EARNS CITY OF DUBLIN BALANCE SHEET ~ FOR THE ' PERIOD 7/92 THROUGH 7/92 INTERNAL ENTERPRISE FIXED ASSETS GENERAL IANG SERVICE FUNDS GROUP OF TERM DEBT FUND ACCOUNTS ACCOUNT GROUP 306522.03 599586.13- 1718575.90 64500.15 108.75 1724.03 182941.50 21892690.65 444274.67 2285000.00 489572.28 23077904.60 444274.67 2285000.00 830.90 16983728.08- 830.90 16983728.08- 374405.00- 991053.52- 115998.18- 5103123.00- 490403.18- 6094176.52- 489572.28- 23017904.60- 2285000.00- 2285000.00- 444274.67- 444274.67- 444274.67- 2285000.00- PAGE 1 9.13.55 BGL104 THE CITY OF DUBLIN STATEMENT SHOWING 8~20,/92 REVENtJES VERSUS EXPENDITORE .' FOR THE PERIOD 7/92 THROOGH 7/92 GENERAL REVENUE FUND CURREHT PERIOD BUDGET ACTUAL PERCENT VARIANCE ~*~****=REVENUES**~~~~~ PROPERTY TAXES 4035400.00- .00 4035400.00- SALES T~X 5400000.00- 147701.00- 2.7 5252299.00- REAL PROPERTY TRANSFERS 66000.00- .00 66000.00- TRANSIEHT OCCOPANCY TAX 96000.00- 22216.00- 23.1 73784.00- FR~NCHISE TAXES 451250.00- 7354.46- 1.6 443895.54- LICENSES ~ PEREIITS 225200.00- 17521.37- 7.8 207678.63- FINES 6 FORFEITURES 22000.00- 2159.14- 9.8 19840.86- USES OF HONEY AND PROPERTY 1008450.00- 26876.54- 2.7 981573.46- INTERHC-0VERN~IENTAL FRO~i STATE 880750.00- .00 880750.00- CEARGES FOR SERVICES 836136.00- 43397.00- 5.2 792739.00- OTHER SOURCES OF REVENUE 297205.00- 1039.89- .3 296165.11- TOT~.L REVENUE 13318391.00- 268265.40- 2.0 13050125.60- **~~***EXPENDITURES~*~**~* GENER~L GOVERN~IENT ACTIVITIES: NON-DEPARTMENTAL 87159.00 .00 87159.00 CITY COUNCIL 1010 102780.00 4289.81 4.2 98490.19 CITY t~ANAGER 1020 478477.00 28366.16 5.9 450110.84 CITY ATTORNEY 1030 174454.00 .00 174454.00 FINnttCE DEPARTbtENT 1090 241796.00 12100.03 5.0 229695.97 DATA PROCESSING (FIN) 1045 14850.00 .00 14850.00 BOILDING MANAGEMENT 1050 338187.00 2829.03 .8 335357.97 F~CILITY RENTAL 1050-719 1718970.00 .00 1718970.00 IHS(JRANCE COST CENTER 1060 152500.00 124958.65 81.9 27541.35 ELECTIONS COST CENTER 1070 4000.00 15.89 .4 3984.11 ACTIVITY TOTAL 3313173.00 172559.57 5.2 3140613.43 PC~BLIC SAFETY: POLICE 2010 2963006.00 17205.27 .6 2995800.73 CROSSING GUARDS COST 2020 35346.00 .00 35346.00 ANIHAL CONTROL 2030 86535.00 .00 86535.00 TRAFFIC SIGNALS 2040 63116.00 .00 63116.00 DISASTER PREAPREDNESS 2050 42312.00 1463.67 3.5 40848.33 FIRE SERVICES JPA 2060 2697625.00 .00 2697625.00 ACTIVITY TOTAL 5887940.00 18668.94 .3 5869271.06 TRANSPORTATION: P(TBLIC WORRS 3010 284700.00 11624.82 4.1 273075.18 STREET MAINTENANCE 3020 221180.00 .00 221180.00 STREET SWEEPING 3030 .00 .00 .00 STREET TREE MAINTENANCE 3090 60000.00 .00 60000.00 STREET LANDSCAPE HAINT. 3050 222880.00 .00 222880.00 P.~RATRANSIT SERVICES 3060 1500.00 .00 1500.00 ACTIVITY TOTAL 790260.00 11624.82 1.5 778635.18 HF,~LTH ~ WELFARE: VECTOR CONTROL 5010 .00 .00 .00 WASTE HANAGEMENT 5020 2620.00 .00 2620.00 ACTIVITY TOTAL 2620.00 .00 2620.00 CIILTiJRE ~ LEISURE SERVICES: LIBRARY SERVICES 8010 164870.00 .00 164870.00 PAGE 3.55.18 GL104 THE CITY OF DOBLIN STATEMENT SHO~ING ' 8/20/92 REVENUES VERSUS E XPENDITU RE FOR THE P ERIOD 7/92 THROOGH 7/92 GENERAL REVENUE FUND CURRENT PERIOD BODGET ACTOAL PERCENT VARIANCE COLTURAL ACTIVITIES 8011 8000.00 .00 8000.00 HERITAGE CENTER 8012 20390.00 .00 20390.00 PARR MAINTENANCE 8020 598910.00 .00 598910.OQ C01~lIIHITY CABLE TV 8030 49000.00 .00 49000.00 RECREATION ADMIN. 8040 171241.00 10478.02 6.1 160762.98 PLAYGROtINDS 8045 82692.00 5915.11 7.2 76776.89 SHAHNON CENTER 8050 113195.00 4823.82 4.3 108371.18 PRESCHOOL 8055 35590.00 1957.51 5.5 33632.49 TEENS PROGRAM 8060 27173.00 1057.84 3.9 26115.16 FIELD SCHEDULING 8065 112601.00 5214.15 4.6 107386.85 YOQTH SPORTS 8066 24879.00 1243.83 5.0 23635.17 SPECIAL EVENTS 8070 30040.00 911.86 3.0 29128.14 SENIOR CENTER 8080 104199.00 5761.26 5.5 98437.74 RECREATION INSTRUCTION 8090 87065.00 3932.73 4.5 83132.27 AQOATICS 8100 198787.00 24864.47 12.5 173922.53 ACTIVITY TOTAL 1828632.00 66160.60 3.6 1762471.40 C01~4{OHITY DEVELOPMENT: PLANHING 9010 739366.00 31790.53 4.3 702575.47 BOILDING SAFETY 9020 254801.00 3562.02 1.4 251238.98 ENGIHEERING 9030 302827.00 13763.19 4.5 289063.81 ECONOHIC DEVELOPHENT 9040 29300.00 .78 29299.22 ACTIVITY TOTAL 1321294.00 49116.52 3.7 1272177.48 CAPITAL IHPROVEMENT PROJ ECTS: GEHERAL CIP PROJECTS 93NN .00 .00 .00 C01~4~{(JNITY IMPROVEMENTS 94NN 67000.00 213.40 .3 66786.60 pARRS 95NN 20717.00 .00 20717.00 STREET CONSTRC/IMPROVMT 96NN 287861.00 702.79 .2 287158.21 ACTIVITY TOTAL 375578.00 916.19 .2 374661.81 T 0 T A L EXPENDITURES 13519497.00 319046.64 2.4 13200450.36 EXCESS <REVE2iiJE>EXPENDITIIRES 201106.00 50781.24 25.3 150324.76 TRANSFERS IN FROM OTHER FUNDS .00 26000.00- 26000.00 EXCESS <REVEHUE> EXPENDI TQRE 201106.00 24781.24 12.3 176324.76 PAGE 2 8.55.18 BGL104 THE CITY OF DUBLIN STATEMENT SHOW~ING g~Zb~9Z REVENUES VERSUS EXPENDITURE ~ FOR THE PERIOD 7/92 THROUGH 7/92 SPECIAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTOAL PERCENT VARIANCE *~~=**x=REVENUES*~~~~_* SALES TAX 108000.00- 7339.13- 6.8 100660.87- FINES & FORFEITDRES 34730.00- 2394.24- 6.9 32335.76- USES OF MONEY AND PROPERTY 12530.00- .00 12530.00- INTERNC-0VERNMENTAL FROM STATE 943659.00- .00 943659.00- INTERGOVERNMENTAL FROM FEDERAL 201109.00- .00 201109.00- CH~.RGES FOR SERVICES 144900.00- 364.88- .3 144535.12- OTHER SOURCES OF REVENUE 15000.00- 100.00- .7 14900.00- TGT.~L REVENiIE 1459928.00- 10198.25- .7 1449729.75- ~~~*=~~EXPENDITURES~*~~*~* GENERAL GOVERNHENT ACTIVITIES: CITY COUNCIL 2600.00 .00 2600.00 CITY HANAGER 24459.00 898.37 3.7 23560.63 ACTIVITY TOTAL 27059.00 898.37 3.3 26160.63 PIJBLIC SAFETY: POLICE 13942.00 .00 13942.00 TRb.FFIC SIGNALS 25084.00 .00 25084.00 ACTIVITY TOTAL 39026.00 .00 39026.00 TR~NSPORTATION: STREET MAINTENANCE 211500.00 .00 211500.00 STREET SWEEPING 67500.00 .00 67500.00 ACTIVITY TOTAL 279000.00 .00 279000.00 HE?LTH & WELFARE: W~STE t-lANAGEHENT 18870.00 .00 18870.00 CC~LTiJRE ~ LEISURE SERVICES: C01~4fIJNITY DEVELOPMENT: Et~GINEERING 129285.00 1327.96 1.0 127957.04 ACTIVITY TOTAL 129285.00 1327.96 1.0 127957.04 C?.PITAL I1dPR0VEMENT PROJECTS: GENERAL CIP PROJECTS 9700.00 .00 9700.00 COt~4I0NITY IHPROVEMENTS 164160.00 .00 164160.00 p~ 125150.00 .00 125150.00 STREET CONSTRUCTION/IMPROVMT 888590.00 3331.52 .4 885258.48 ACTIVITY TOTAL 1187600.00 3331.52 .3 1184268.48 T 0 T A L EXPENDITURES 1680840.00 5557.85 .3 1675282.15 EXCESS <REVENiIE>EXPENDITf1RE 220912.00 4640.40- 2.1- 225552.40 EXCESS <REVENUE> EXPENDITURE 220912.00 4640.40- 2.1- 225552.40 P~GE 1 3.57.49 BGL104 8/20/92 *~**~~**REVENDES*~*~~~~ THE CITY OF DUBLIH STATE}ttENT SHO~ING REVENUES VERSOS EXPENDITURE ' POR THE PERIOD 7/92 THROUGH 7/92 SPECIAL ASSESSMENT FUNDS CORREHT PERIOD BODGET ACTQAL PERCENT VARIANCE SPECIAL BENEFITS ASSESSMENTS 324228.00- .00 324228.00- OSES OF HONEY AND PROPERTY 14580.00- .00 14580.00- OTHER SOURCES OF REVENUE 4900.00- 1611.46- 32.9 3288.54- TOT?.L REVENUE 343708.00- 1611.46- .5 342046.54- ~*~=~~*EXPENDITORES~~~**~~ GENER.~L GOVERNt~fENT ACTIVITIES: NOH-DEPARTFIENTAL 97413.00 78237.50 80.3 19175.50 FINANCE DEPARTMENT 4500.00 .00 4500.00 ACTIVITY TOTAL 101913.00 78237.50 76.8 23675.50 PUBLIC SAFETY: TRFC SIGS/STREET LIGHTING 179190.00 750.00 .4 178440.00 ACTIVITY TOTAL 179Z90.00 750.00 .4 178440.00 TR~NSPORTATION: STREET TREE MAINTENANCE 10070.00 .00 10070.00 STREET LANDSCAPE MAINTENANCE 123240.00 .00 123240.00 ACTIVITY TOTAL 133310.00 .00 133310.00 HE.~.LTH ~ WELFARE: CULTORE & LEIStIRE SERVICES: COt~ifJNITY DEVELOPMENT: ENGINEERING 10964.00 .00 10964.00 ACTIVITY TOTAL 10964.00 .00 10964.00 C~PIT.~L Il~[PROVEbiENT PROJECTS: STREET CONSTRUCTION/IMPROVMT .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 T 0 T A L EXPENDITDRES 425377.00 78987.50 18.6 346389.50 EXCESS<REVENUE>EXPENDITORE 81669.00 77376.04 94.7 4292.96 EXCESS <REVENUE> EXPENDITURE 81669.00 77376.04 94.7 4292.96 PAGE 1 9.00.35 BGL104 THE CITY OF DUBLIN STATEMENT SHOWING 8f20/92 REVENUES VERSUS EXPENDITORE ' FOR THE PERIOD 7/92 THROOGH 7/92 CAPITAL IMPROVEMEHT FUND CORRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ~*~~x~*~REVENUES~~*~*~~ OSES OF MONEY AND PROPERTY 10290.00- .00 10290.00- OTHER SOORCES OF REVENUE 92713.00- .00 92713.00- TOTAL REVENUE 103003.00- .00 103003.00- ~~x~~~*EXPENDITURES~~~*~~~ GENERAI, GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 PUBLIC SAFETY: TR~2iSPORTATION : HEALTH & WELFARE: COLTQRE & LEISORE SERVICES: COl~4tQNITY DEVELOPMENT: CAPITAL I1~ItPROVEM@iT PROJECTS: p~ .00 .00 .00 STREET CONSTROCTION/IMPROVldT 791247.00 119.84 ?91127.16 ACTIVITY TOTAL 791247.00 119.84 791127.16 T 0 T A L EXPENDITURES 791247.00 119.84 791127.16 EXCESS<REVENUE>EXPENDITURE 688244.00 119.84 688124.16 EXCESS <REVENUE> EXPENDITURE 688244.00 119.89 688124.16 PAGE 1 9.10.01 BGL104 ..~E CITY OF DUBLIN STATEMENT SHOWING 8/20/92 REVENOES VERSUS EXPEHDITURE ,~ FOR THE PERIOD 7/92 THROUGH 7/92 INTERNAL SERVICE FUN~ CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE **~~*~*~REVENUES~~~*~*~ OSES OF NONEY AND PROPERTY 14250.00- .00 14250.00- CHARGES FOR SERVICES 143994.00- 12323.65- 8.6 131670.35- OTHER SOORCES OF REVENOE 3000.00- .00 3000.00- TOTAL REVENUE 161244.00- 12323.65- 7.6 198920.35- ~~*~~~*EXPENDITtIRES*~~***~ GENERAL GOVERNliENT ACTIVITIES: NON-DEPARTMENTAL 272041.00 ACTIVITY TOTAL 272041.00 PUBLIC SAFETY: POLICE .00 ACTIVITY TOTAL .00 TRANSPORTATION: HEALTH & WELFARE: COLTDRE & LEISORE SERVICES: COt~41UNITY DEVELOPMENT: CAPITAL I1~ROVEMENT PROJECTS: GENERAL CIP PROJECTS 22000.00 ACTIVITY TOTAL 22000.00 T 0 T A L EXPENDITORES 294041.00 EXCESS<REVENt]E>EXPENDITURE 132797.00 TRANSFERS OOT TO OTHER FUNDS .00 EXCESS <REVEN(JE> EXPENDITURE 132797.00 10551.25 3.9 261489.75 10551.25 3.9 261489.75 .00 .00 .00 .00 .00 22000.00 .00 22000.00 10551.25 3.6 283489.75 1772.40- 1.3- 134569.40 26000.00 26000.00- 24227.60 18.2 108569.40 PAGE 1 9.03.56 BGL104 8/20/92 .~E CITY OF DUBLIN STATEHENT SHOWING REVENUES VERSUS EXPENDITURE .' FOR THE PERIOD 7/92 THROUGH 7/92 ENTERPRISE FUilDS CURRENT PERIOD BUDGET ACTOAL PERCEt~T VARIANCE ~~~==*~~REVENUES~~**~~~ USES OF MONEY AND PROPERTY 1859697.00- TOTAL REVENiIE 1859697.00- ~*~*~~~EXPENDITURES~~~*~~* GENER~.I, GOVERNtdENT ACTIVITIES: NON-DEPARTMENTAL 1719025.00 CITY }dANAGER 3625.00 FIN.~NCE DEPARTMENT 8440.00 ACTIVITY TOTAL 1731090.00 PCBLIC SAFETY: DIS~STER PREAPREDNESS 1700.00 ACTIVITY TOTAL 1700.00 TRANSPORTATION: HEALTH & WELFARE: CULTCRE & LEISURE SERVICES: R~CREATION ADMINISTRATION 11360.00 SENIOR CENTER 500.00 ACTIVITY TOTAL 11860.00 C01~4ICNITY DEVELOPMENT: CAPIT.~L IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1744650.00 EXCESS<REVENUE>EXPENDITURES 115047.00- EXCESS <REVENUE> EXPENDITURE 115047.00- .00 1859697.00- .00 1859697.00- 552008.71 32.1 1167016.29 .00 3625.00 .00 8440.00 552008.71 31.9 1179081.29 .00 1700.00 .00 1700.00 .00 113b0.00 32.34 6.5 467.66 32.34 .3 11827.66 552041.05 31.6 1192608.95 552041.05 479.8- 667088.05- 552041.05 479.8- 667088.05- P~GE 1 9.06.52