The URL can be used to link to this page

Home My WebLink AboutAgenda Report - October 7, 1992 (57)-4 OF I( --CITY OF LODI T4s of COUNCIL COMMUNICATION AGENDA TITLE: FY 1992-93 BUDGET APPROPRIATIONS MEETING DATE: October 7, 1992 PREPARED BY: Finance Director RECOMMENDED ACTION: That the City Council adopt the attached Resolution to appropriate funds in accordance with the 1992-93 Budget submitted July 1, 1992 and approve the recommended adjustments. BACKGROUND INFORMATION: On July 1, 1992, the City Council adopted Resolution No 92-117 appropriating revenues and authorizing expenditures for the conduct of City business (operations, maintenance, construction and procurement) beginning July 1, 1992 and ending June 30, 1993. Resolution No 92-117 appropriated revenues and expenditures for the General Fund, Electric Utility Fund, Sewer Fund, Water Fund, Library Fund and Community Center Fund. Not included in this Resolution was appropriation authority for the Utility Outlay Fund, Equipment Fund, Debt Service Funds, and Internal Service Funds which were also included in the Budget submitted to the City Council on July 1, 1992. APPROPRIATIONS At this time the Finance Director is requesting that the City Council appropriate all revenues and expenditures submitted to the City Council in the Budget on July 1, 1992, to appropriate expenditure authority for 'street projects" approved by Council September 2, 1992 and appropriate additional expenditure authority to adjust for the revenues and expenditures which were overlooked in the 1992-93 Budget. The adjustments requested include Revenues by Transfer and expenditures for interfund loans, debt service payments, encumbrances and work -in -progress carried forward from FY 1991-92. The attached Budget Summary includes schedules which summarize the appropriation of revenues, expenditures, interfund transfers and revenues by transfer included in the I992-93 Budget with required adjustments. The amended Resolution is necessary to allow the Finance Department to calculate the 1992-93 Appropriation Limitation required by Article XIIIA of the California Constitution. STATE BUDGET The Governor signed into law the 1992-93 Budget for the State of California on September 2, 1992. With the adoption of the State Budget, the City of Lodi loses 9% of the 1991-92 Property Tax (approximately $430,000) and all Cigarette. Tax. The 1992-93 Budget submitted to the City Council on July 1, 1992 was based on the elimination of Cigarette Tax revenues but not on the reduction of Property Tax revenues. Accordingly, further adjustments to revenues and expenditures will be submitted to the APPROVED -- - - - -- - - r - %io► T110MAS A PETE O rcru«n owr« City Manager CC I RESOLUTION NO. 92-166 A RESOLUTION OF THE LODI CITY COUNCIL ADOPTING SUPPLEMENTAL APPROPRIATIONS FOR FISCAL YEAR 1992-93 BY FUND, DEPARTMENT AND ACTIVITY �VITEREAS, the City Council adopted the FY 1992-93 budget appropriations for revenues and expenditures by Resolution Nb. 92-117 on July 1, 1992, znd WHEREAS, the City Council approved the 1992-93 Budget presented by the City Manager on July 1, 1992, with revenues, expenditures, and inter -fund transfers and WHEREAS , adjustments arc necessary to the adopted budget to account for additional revenues and expenditures not included in the 1992-93 Budget, and WHEREAS , the appropriation of revenues and expenditures is required to calculate the appropriation limitation in accordance with Article XIIIA of the California Constitution. NOW, THEREFORE, the City Council hereby adopts the budget presented on July 1, 1992 by Fund Group, Fund, and Object Code and appropriates the revenues, expenditures and interfund transfers included therein with tine adjustments recommended as follows: Expenditures Personnel Services Appropriation Appropriation Utilities and Communications July 1, 1992 October 7, 1992 Estimated Revenues 4,080,480 5,662,815 Taxes 11,082,740 11,836,617 Licenses, Fines, & Permits 863,680 518,340 Investment and Property Revenue 603,725 1,316,195 Intergovernmental Revenue 3,155,705 5,108,653 Charges for Services 45,296,295 52,063,910 Other revenues 317,020 1,447,235 Interfund Transfers 1,287,050 0 Total Estimated Revenues 62,606,215 72,290,950 Expenditures Personnel Services 21,954,330 22,567,410 Utilities and Communications 27,355,590 27,355,590 Supplies, Materials & Services 4,080,480 5,662,815 Depreciation 318,900 0 Equipment, Land and Structures 300,045 300,035 Special Payments 5,907,300 5,093,475 Credits -775,555 Capital Projects 1,342,245 Debt Service 1,187,695 Total Expenditures 59,916,645 62,733,720 Bcm revenues over (under) appropriations 2,689,570 9,557,230 Adjustments Revenues By Transfer 327,745 Int.erfund Loans 0 General Obligation Bonds 0 Ift Service - COP and Water 13mi Interest -1,498,289 Street Pmjects- Approved September 2, 1992 -1,712,000 Encumbrances -968,173 Work -In -Progress -6,366,832 Designated Balances 7SS,.b�d Tota' ,,djustments -26,473,173 PROJECTED FUND BALANCES June 30, 1992 June 30, 1993 General Fund 17,263 279,236 Inventory Fund 100,455 100,455 Refuse Surcharge Fund 55,930 74,500 Library Fund 817,452 346,912 Community Center Fund 25,240 15,805 Hotel/Motel fund 308,793 303,403 Total General Fund Group 1,325,133 1,120,338 Electric Utility Fund 6,489,228 1,120,935 Sewer Utility Fund 14,732,577 2,745,705 Water Utility Fund 641,559 256,633 Total Enterprise Fund Group 21,863,364 4,123,274 Asset Seizure Fund 122,624 43,429 Gas Tax Funds 685,970 164,742 Transportation Funds 1,070,857 1,226,699 Impact Fee Funds 602,082 6,429,785 Special Grant Funds -34,493 64,770 Total Special Revenue Funds 2,447,040 7,699,885 Equipment Fund 249,249 116,540 Library Capital Fund 289,139 305,139 Subdivision Reserve Fund 535,661 535,139 Subdivision Fund 181,433 0 Hutchins Street Fund 3,721 -48,420 Capital Outlay Fund 1,979,184 .-377,933 Ladd Lake Fund 88,890 71,000 Master D i ain Fund 625,772 566,795 Total Capital Outlay Funds 3,953,049 1,168,783 Debt Service Funds 233,065 214,681 Long -Term TIQUI Insurance Fund 176,712 0 MWe-A1lnsurance Fund 8,288 0 Finployee Benefits Fund F2,882 0 Liability Fund 9s , 814 477, 617 Worker's Compensation Fund 688,173 0 Total Internal Service Funds 1,898,869 477,617 4 Dated: October 7, 1992 I do hereby certify that Resolution No. 92-166 was passed and adopted by the City council of the City of Lodi in a regular meeting held October 7, 1992 by the following vote: AYES: Council Members - iiincYman, Pennino, Sieglock, Snider and Pinkerton (Mayor) NOES: Council Members - Mone ABSENT: Council Members - None Alice M. Reimche City Clerk ' �'" 1992-93 BUDGET SUMMARY CITY OF LORI FINANCE DEPARTMENT October 7,1992 4 TABLE OF CONTENTS Overview Schedules Appropriations and Changes in Fund Balance (FY 1992-93) - All Funds Combined 5 Changes in Fund Balance - Governmental Funds (Schedule A) 6 Changes in Fund Balance - Proprietary Funds (Schedule B) 7 Changes in Fund Balance - Special Revenue Funds (Schedule C) 8 Changes in Fund Balance - Capital Project Funds (Schedule D) 9 Changes in Fund Balance - Debt Service Funds (Schedule E) 10 Changes in Fund Balance - Internal Service Funds (Schedule F) 1 I Operating Transfers (Schedule G) 13 Revenues By Transfer (Schedule H) 15 Encumbrances Carried Forward (Schedule•l) 19 Work -In -Progress (Schedule J) 25 MEMORANDUM October 7, 1992 TO: City Council FROM: Dixon Flynn, Finance Director SUBJECT; 1992-93 BUDGET SUMMARY OVERVIEW The attached budget summaries have been prepared in accordance with the City's 1992-93 Budget approved by the City Council on July 1, 1992 and the Street Master Plan approved by Council September 2, 1992. Although the Council adopted Resolution No. 92-117 on July 1, 1992 appropriating revenue and expenditure authority for the conduct of City services, this Resolution did not include all revenues and expenditures provided in the 1992-93 Budget. Accordingly, Resolution No 92-117 should be amended to reflect the Budget as approved by Council on July 1, 1992 and the Street Master Plan on September 2, 1992. In addition, there are revenues and expenditures which were not included in the Budget which should be added at this time. BUDGET SCHEDULES Tlie Budget Summary is comprised of the 11 schedules described below: * Summary of Appropriations and Changes in Fund Balance (All Funds Combined) This schedule summarizes the results of Schedules A through J for the revenues, expenditures, and interfund transfers approved by the City Council on July 1, 1992: the expenditures approved by Council in the 1992-93 Street Master Plan cn September 2, 1992; encumbrances for FY 1991- 92; work -in -progress; and, adjustments. It does not include the adjustment for the 9 % reduction in Property Tax mandated in the State Budget. * (Governmental Funds) - Schedule A This schedule s- arize , the budget appropriations for the "general fund group". In total, expenditures exceed revenues by $6.5 million. The deficit revenues are offset by operating transfers of $6.6 million as listed in Schedule G. * (Proprietary Funds) - Schedule B This schedule summarizes the budget appropriations for the "enterprise fund group". In total, revenues exceed expenditures by $6.6 million. The surplus revenues of $6.0 million have been transferred to the General Fund for the cost of central support services. Adjustments in the amount of $1.0 million have been added to expenditure appropriations for the 1991 COP loan which was not included in the 1992-93 Budget and for interfund loans of $294,000 approved by Council in 1988 and 1990. (Special Revenue Funds) - Schedule C This schedule summarizes the budget appropriations for the " s lk c i a l revenue fund group". In total, revenues are $9.1 million. Prior year appropriations for work-in progress is $1.1 million, encumbrances amount to $162,848 and the City Council approved the Street Mister Plan on September 2, 1992 for $1.7 niillion. * (Capital Project Funds) - Schedule D This schedule summarizes the budget appropriations for "capital project fund group". In total, expenditures exceed revenues by $176,420 and are offset in part by the increase in operating transfers of $60,025. Two of the Capital Project Funds (Hutchins Street Square and Capital Outlay Funds) will have deficit balances on June 30, 1993 if additional revenues are not obtained cr if the City Council does not reduce the appropriations for projects approved in prior years. A list of these projects is included in Schedule J. * (Debt Service Fund) - Schedule E This schedule summarizes the budget appropriations for the "debt service fund group". The revenues of $411,702 should be appropriated to pay the $410,650 of principal and interest due bond holders. * (Internal Service Funds) - Schedule F This schedule summarizes the budget appropriations for the "internal service funds". Expenditures exceed revenues by $93,905 which are offset by the net gain in operating transfers of $187,515. * Schedule of Sources/Uses (Operating Transfers) - Schedule G This schedule summarizes all operating transfers which were listed in the 1992-93 Budget as "operating transfers" or "contributions from other funds/reserves". The net change to "total available funds" after transfers is zero. * Schedule of Interfund Transactions (Revenues/ Expenses By Transfer) -Schedule 11 This schedule summarizes revenue and expense transfers to and from the City's "proprietary funds", i.e., enterprise funds and internal service funds. The transfer of expenses as a revenue to "pro ' etary funds" is a standard accounting practice used by the City. GENERALLY ACCEPTED ACCOUNTING PRINCIPLES Ile attached Budget Schedules (Schedules A through H) have been prepared in accordance with Generally Accepted Accounting Principles with the following modification. Projected Fund Balances are the projected cash balances for each fund measured under the "modified accrual basis" of accounting. That is, revenues are recognized in the year in which they are earned and received, and accrued at the end of the year to the extent the cash earned on June 30 will be received within 60 days after the close of the fismlyear (June 30). Expenditures are recognized in the year paid and accrued at the end of the year only if they are to be paid from revenues earned during the current period. ADJUSTMENTS The following is a list and description of the adjustments included in the Budget Schedules. Revenues/ Expenses By Transfer Schedule H is a listing of the revenues by transfer. Under the City's current accounting practice, expenses for employee benefits and debt service are charged to the Operating funds of the Department in which the employee works and to the fund from which the debt is to be charged and transferred as revenue to either an Internal Service Fund (benefits)or the Debt Service Fund (debt service) for payment. This adjustment is to appropriate the revenues to the internal service funds and the debt service fund. Inter -Fund Loans The City Council approved two interfund loans for capital projects from the Electric Fund in 1988 and in 1990. One 5 year loan of $1,000,000 was made December 27, 1988 to the Water Fund for capital projects. Another 5 year loan of $250,000 was made May 3, 1990to the Capital Outlay Fund for the purchase of property at 217 West Elm Street. The principal and interest due the Electric Fund is $294,000, $233,000 from the Water Fund and $61,000 from the Capital Outlay Fund. Debt Service After review of debt service requirements for general obligation bonds, the 1988 COP, the 1991 COP, and the Stade Water Fund Loan, the Finance Department discovered that the amount included in the budget for debt service payments in FY 1992-93 were understated by $1,498,289. Capital Projects Under current City accounting practice, the Finance Department appropriates expenditure authority for proiects tentatively approved in the Street Master Plan. This year the amount approved by Council was $1,112,000. As discussed during the Council meeting September 2, 1992, the projects listed and approved in the street Master Plan for FY 1992-93 will be subsequently brought back to Council on a project by project basis for final approval before funds are obligated for expenditure. Encumbrances Schedule I is a list of contracts, agreements or purchase orders entered into during FY 1991-92 with appropriation authority from the 1991-92Budget. These contracts, agreementsor purchase orders will be paid with appropriation authority carried forward from FY 1991-92 and therefore reduce fund balance. The amount of carry forward encumbrances recorded in FY 1992-93 is $968,173. Work -in -Progress Schedule J is a list of capital projects or purchases approved and appropriated by Council in prior years. If the funds appropriated for these projects are spent as planned during FY 1992-93, the fund balance will be reduced as projected. The value of work -in -progress recorded in FY 1992-93 is $6,366,832. Designated Pesexves The amount cf 519,436 is restricted cash set aside as reserve in accordance with bond covenants for the United Downtown Improvement District. The amount of $1,624,180 is designated cash set aside by appropriation as operating reserves in the Internal Service Funds for contingencies. The amount of $2,121,706 is cash due and payable on June 30, 1992 for power purchases. The payment of this amount was made to NCPA on July 2, 1992. The amount of $2,826,446 is designated cash set aside for rate stabilization in the Electric Utility Fund. The amount of $9,667,156 is restricted cash with the City's t i scat agent for final nal payment of the 1988 Sewer COP. This account will be settled in August 1993. SUMMARY OF APPROPRIATIONS AND CHANGES IN FUND BALANCE (FY 1992-93) All Funds Combined Combined Governmental ropriefary_9pecial Revenue Capital ProJoct Debt Service Internal Service - Total Funds Funds Funds Funds Funds Funds Fund Balance - July -it. 1992 31,720,520__ 1,325,133 2-1,863,364 2,447,040 3,953,049 233,065 1,898,869 Total Estimated Revenues Appropriations Personnel Services (100) Utilities & Communications (200) Supplies, Materials& Services (300) Depreciation Equipment. Land & Structures (500) Special Payments (600) Credits (700) Capital Projects Debt Service Total Appropriations Excess revenues over (under) appropriations Other Sources/Uses Operating Transfers Total Other Sources/Uses Adjustments Estimated Revenues Revenues by Transfer Loans - Interfund Debt Service Appropriations General Obligation Bonds Encumbrances Debt Service - COP and Water Loan Capital Projects Work -In -Progress (Designated) Other Sources/Uses Designated Reserves Funds 140 and 22 Close Designated - Rate Stabilization Designated -Power Purchase Desianated - Sewer COP TOTAL ADJUSTMENTS 72,290,950 20,597,105 41,203,685 9,065,983 53,100 411,702 959,375 (22,567,410) (18,409,455) (3,980,955) 0 0 0 (177,000) (27,355,590) (1,063,940X26,291,650) 0 0 0 (5,662,815) (3,670,390) (1,216,145) 0 0 0 (77600) 0 0 0 0 0 0 (300,045) (139,090) (160,955) 0 0 0 (5,093,475) (4,458,380) (535,095) 0 0 0 (100,000) 775,555 775,555 0 0 0 0 (1,342,245) (1,112,725) 0 (229,520) 0 ___-(1,187,695) A177,235) (1,010,460) 0 0 0 (62,733,720) (27,142,935) (34,307,985) 0 (229,520) 0 (1,053,280) 9,557,230 (6,545,830) 6,895,700 9,065,983 (176,420) 411,702 (93,905) 0 6,636,075 6,044,015 (839,600) 60,025 0 187,515 _ 0 6,636,075 (6,044,015) (839,600) 60,025 0 187,515 327,745 205,500 122.245 0 61,000 (61,000) (176) (176) 176 176 (968,173) (56,738) (603,006) (162,848) (132,654) (12,927) (1,498,289) (1,087,815) (410,474) (1,712,000) (1,712,000) (6,366,832) (447.278) (2,346,647) (1,098,690) (2,474,217) (1,643,616) (19,436) (1,624,180) 3,300 3,300 (2,826,446) (2,826,446) (2,121,706) (2,121,706) Projected Fund Balance_ June 30. 1993 14,804,577 1,120,338 4,123,273 7,699,885 1.168,783 214.681 4777 FUND 17 CHANGES IN FUND BALANCE(FY 1992-931 Governmental Ptnrlc _ _ _ _ _ SCHEDULE A -- —�— -- Combined _-- General laveatory Relose Library Community Motel Total road read Sarcbarte Pond Center Motel (10) 4»Tw1ga (21) (120) (134)_ Fund Balance 'Jsl7 1, 1992 1,323,133 17263 100,455 55.930 817,45: 25,240 308,793 Estimated Revetees 205,500 205.500 Appropriations General OW4atioa Bonds Tam 11.103.555 10,009,865 (56,738) 888,885 Work –In–Progres, (Designated) 204.8(15 Licenses, Fiats R Permits 518,3!0 468,340 50,000 3,300 3,300 _ lasestmestand Property Revrsue 37905 505.915 31,170 42,000 laterjoveramcntal 3.155.705 3,106,705 49,000 CbarBtstor Services - 5,04SX6 4,874,720 142,600 28,000 Otber Revenge 195,100 195.100 ---1,019.055 Total Eatimated Revenues 20.597.105 19,160,645 0 142.600 7000 :04,805 Appropriations Persomeel Services Compeesatios – Regular (10.) (198) (11,780,175) (11,171.900) (441,785) (166,490) Compensation – Part/rime(103) (852,890) (T6,790) (76,170) (49,930) Overtime (IM) (5M.770) (578,470) (10,300) Allowances (105) (`9.4001 (25,200) (4.200) BcoeGts (5,158220) 14,939.210) (159.600) (59,410) _ Total(100) (18,409,455) (17.441.570) (677.555) 1290.330) UtititiesA Communications ('2001 (1,063,940) (923,245) (59205) (80,490) Supplies. MaterisbdtServices 1300) (3,670190) (3,3`'5,525) (237.685) (107.180) Depreciation 0 Equipment. tind A structures (SM) (139,090) (138,590) (500) Special Payment$ (600) (4.458,380) (4,386}05) (34,325) (37,750) Credits (70D) 775.555 775.55s Capital Projects 0 Debt Service (177,235) (177 2 -Ar,) TotalAppropriatioss (27,142,935) (25.617.915) 0 0 (1,008,770) (516.250) 0 Exec" revenues over(undcr) Appropriations (6,545$30) (6.457270) 0 142.600 10285 (446.250) 204.805 Otber Sourcea/Uses Operstin8Tranters–la 7,819,590 7,433,340 446 -SO Operating Transfer% -Out (I 43 St S) 07S770) (114 otn) 91.0) Total OtberSoorcea/Uses 6,636,075 6,557,570 0 (124.030) (38,910) 446250 (204.805) Adjustments Estimated Revenars Revenues by Transfer 205,500 205.500 Appropriations General OW4atioa Bonds 176 176 Encumbrances (56,738) (47,303) (9,435) Work –In–Progres, (Designated) (441278) (JJ1.915) (5,363) Otber Soorcea/Mes Fvuds 140 and 22 Close 3,300 3,300 _ Total Mjostaenu (295.040) 161,673 y 0 0 (441,945). (9,433) (5363) Pt,.jrrrrd "..A 11A.." - ).r 30, 1993 1,170,337! 779;!16 100.4SS 1000 344,^•? IS ROS 303,430 CHANGES IN FUND BALANCE (FY 1992-93) Prop rietary► Funds (1,047,815) SCHEDULE B Encumbrances Combined Filed ric Sewer Wager (2.346,647) TotalUtility 11.065.Osl) (969.667) Utility Utility — (16) _ -A17) Ala) (318,900) Depreciation toFund l7.Deprecialion to 17.2 318.900 318.900 Fund Balance - July I. 1992 21,693 ? 6,489,228 14.732,577 641.559 (2,826,446) (2,826,446) 1•itimated Revenues Designated - Sewer COP (9,667,156) --- (9,667,156) --'_(1,134,366) Taxes 183,9% (5.226.293) 16 ; yw Investment and Property Revenue 524.200 159,870 117,950 4b.380 Charger for Services 40,406,575 34,442,560 3,191,700 2,772.315 Other Revenues 88,920 79.920 _ _ 1,(" _ - _ _ 8,000 Told Estimated Revenues 41,20305 34,682,350 3,694,640 2,826.695 Appropriations Personnel Services Compensation- Regular(101)(198) (2,953,961) (1.841,570) (766,375) (346,016) Compensation -Partllime (103) (77.275) (17,880) (59,395) Overtime (102) (113,825) (65,320) (20,280) (28,225) Benefits (835,894) (461.650) _5279,070) (95.174) Total(100) (3.980,955) (2,368.540) (1,083,605) (528.810) Utilities ds Communications (200) (26,291,650) (25,535,935) (310,660) (445.055) Supplier. Materials & Services (300) (1,216,145) (741,240) (304,175) 4170.710) Depreciation (318,900) 018.900) ) Equipment.Land A Structures (SO) (160,955) (148,925) (10,790) (1.240) Special Payments (6W) (535,095) (513.770) (6,235) (15.09)) Capital Projects (1,112,725) (1.109.225) (1,750) (1,750) Debt Service (1,010,460) -_ (L010,460? _ Told Appropriations (34.626,885) (10.417.635) (3,046,575) (1.162.675) Excess revenues over (under) appropriatiors 6.576,800 4,264,715 648,065 1,664.020 Other Soureea Uses Operating Transfers -Out (6,044.015) (4,406.715) -_-LT-1 740) 914•160) Total OtberSourocWses (6,014,015) (4.406,715) (722,740) (914,560) Adjustsents Estimated Revenues Loan to Water Utility (pnnualPaymen!) 0 233.000 (233.OW) LoantoHutchins 45q(Annual Payment) 61,000 61010 Approprialioos Depreciation 318,900 318.910 Water Loan Interest do SinitingFund (40,OW) (40.000) 1991 COP (1,047,815) (1,047.615) Encumbrances (603,006) (260,211) (216.075) (124,720) Work - In- Progress (2.346,647) (311,930) 11.065.Osl) (969.667) Other SoureesA)sca Depreciation from Fund 17.0 (318.900) (318,900) Depreciation toFund l7.Deprecialion to 17.2 318.900 318.900 Designed for Power Purchaser (2.121.706) (2,121,706) Designated - Rate Stabilization (2,826,446) (2,826,446) Designated - Sewer COP (9,667,156) --- (9,667,156) --'_(1,134,366) TotalAdjuatmects (18,272,875) (5.226.293) (11,912.197) Projcacd I'tnod_-13abnce-- Iv!x 30 199}_—_ 4.12? .]+-- - - -_ 1.129?33 -- 2X33 '��-- -.__ :Won - - -- -- - I1)N1312 CHANGES IN FUND BALANCE (FY 1992--93) _ _ Funds - Special Revenuee Funds Combined Total SCHEDULE C Asset Gas Transportation special Grants i Seizure Ta: Ponds IMP Pat! Grant HUD -(23)--_------- -------------- (60)_ _ (44.3) (45) Pead Balance - July 1, 1992 2,441,040 122,624 695,970 1,070,857 602,082 11,36) (45.857) tiatinated Revesaes Taxes InWstment and Property Revenue Intergovernmental Charges for Services Total Fitissated Revenues hpproprbtiosa Personnel Services Compensation - Regular (101)(198) Compensation - Partaime (103) Overtime (102) Allowances (105) Benefits Total (100) Utilities& Communications (200) Supplier. Materials& Services (300) A Depreciation Equipment, Land& Structures (500) Special Payments (600) Credits (700) Capital Projects Debt Service Total Appropriations Excess revenuesover (under) appropriations Other Sourcca/Uses OperatingTransfers -Out Total Other Soarces/Uscs Adjustments Appropriations Capital Projects approved September 2, 1992 Encumbrances Work -la -Progress Other Soaroes/Uses 500,000 67,020 1,952,948 6,546,015 7,111 23,991 MEW 500,000 18,345 I.07I.618 46,(100 16,570 6,500,015 - -- 9,065,983 -- -L--- _ 7.114- -- - 406,321 _ 1,635,963 6.516,585 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 9,065,983 7,114 906,32I 1,635,963 6,516,585 0 0 (839,600) (454,835) (320,990) (16,145) 477,6 (839,600) 0 (454,835) (320,990) (16,145) 0 (47,630) (1.712,000) (601.000) (869.000) (24000) (162.838) (309) (19.420) (7.601) (93.643) (41.875) (1.098.690) (86.000) (352,294) (282.530) (337.094) (40.772) Total AdjaatsaeaIa (2,973,538) (86,309) (972.714) (1,159,131) (672,737) (82,647) � p 7.699 8, 5 _—_--43.429----- 16474 --_1.2 ,699 6A29�at 171M (914M. CHANGES IN FUND BALANCE (FY 1992-93) C.api#a! Project Funds - ..... --- Cossbued 1. (brary Si6divuios Total I;gaip Capital Reserve 81bdivisioa Pssd Balasce - July 1, 1992 3,953,049 249.249 289,139 535,661 181,433 Eativested Reverses Investment and Property Revenue Charges for Services Total Estimated Revesses Appropriations Petsonnel Services Compensation - Regular (101) (198) Compen%stion - Parv7ime (103) ONertime (102) Allowances (105) Benefits Total (100) Utilities&Communications (200) Supplies. Materials & Services (300) Depreciation Eg6pment, Land & Structures(500) Special Payments (600) Credits (700) Capital Projects Debt Service Total Appropriatioss Excess revenues over (under) appropriations Other Sosrces/Uses Operating Transfers -In Operating Tt ans (ers - Ou t Total Other Sosrees/Uses 27,100 8,000 26,000 — - - - 53.100 8.000 16. KA) 16.000 SCHEDULE_ D____ Ilsiclims Capital--ladi- — Master Street Outlay Lake Drain 3,721 1,979,184 1,979,184 88,890 625,772 3,110 0 26 t)Op 0 0 0 0 29.11(0 0 0 0 0 0 0 -- 0 0 0 0 0 0 0 (229,520) (229.520) 0 (229,520) (229.520) 0 0 0 0 0 0 0 (176,420) (221,520) 16,000 0 0 0 0 29,100 0 229,520 229,520 (169,495) 0 (169,495) 60,025 229.520 0 0 0 0 (169,495) 0 0 Adjsstuests Appropriatines Encumbrancer (132,634) (88.394) (43,862) (3") Other Sosrces/Uses Loan for Hutchins St Sq (Annual Payment) (61,000) (61,000) Work- In-Protress (2,474,21.7) (52.315) (181.133) (52,141) (2.082760) (46,591) a.9771 Tots -1 Adjsstmests (2,667,871) (140,709) 0 0 (181,433) (52,141) (2,187,622) (46,990) (38,971) Fro_jfcted Fs!d Ba(s8f9 - Jame 30.1993 ),168783 116.540 305.139 $35.661 0 (48.420) (317933) 71,000 566.79.5 FUND14 CHANGES IN FUND BALANCE (FY 1992-93) Debt Service Fund SCHEDULE E Combined Bosd Total Redcap UDID (41) (49) Food Balance — July 1.1992 233,06S 206,000 27.065 Estimated Revesses Taxes Investment and Property Revenue Otber Revenues Total Estimated Revenues Appropriations Person eel Services Compensation —Regular (101)(199) Compensation—Psrv'reme (103) Overtime (102) Allowances (105) Benefits Total (100) Utilities do Comm via kations (Zoo) Supplies, Materials & Services (300) Depreciation Equipment. Land R Structures (500) Special Payments (600) Credits (700) Capital Projects Debt Service Total Appropriations Excess revenues over (under) appropriations TotalOtber SoorceslUses Adjustments Estimated Reveaves 49,072 49.072 1,405 1.405 361,225 36I.225 411.702 361.225 50.477 a 0 0 0 0 0 0 0 0 0 (410.474) (361.401) (49.073) 0 0 _ (19,436) (19,436) 0 (430,086) (361.577) (68,509) 0 0 0 u 0 0 0 0 411.702 361.225 50.477 0 0 0 Debt Service (General Fund) (176) (176) Appropriations Debt Service (410.474) (361.401) (49.073) Otber Sources/Uses Restricted Casb — Loss Reserve _ (19,436) (19,436) Total Adjustment (430,086) (361.577) (68,509) J!Lo'ected Pend Balancs — Jsee 30 1943 214,6$1_ 20S 648 9.0 PUNDIS CHANGES IN FUND BALANCE (FY 1992-93) Internal Service Funds SCHEDULE F Combined LTD Medical Employee Worker's Total Sett—laser lassrasce Beit cCts PL&PD Comp (27) (29) (29) (30) (31) Peed Balance — July 1, 1992 1,898,869 176,712 B'288 82 882 942.914 6894173 Estimated Revcoaes Investment and PropertyRcvcauc s. Charges lirSersices Other Revenu a Total Estimated Revenues Appropriations Personnel Services Compensation — Regular (101) (198) Compensation — Part/Time (103) Overtime (102) Allowances (105) Benefits Total (100) Utilities & Commuaicatbes (200) Supplies. Materials & Services (300) Depreciation Equipment, Land 4e Structures (500) ~ Special Payments (600) Credits (700) Capital Projects Debt Service Total Appropriations Enceu revenues over (under) appropriations Other Sources/Uses Operating Traes(ers—la Operating Traai(ers —OuI Total Other Sosrces/Uses Adjeatments Estimated Rereeaes 117,385 1,080 24,600 4,920 50,000 36,785 10,000 0 (12.927) .40.000 (4.621,190) (19906) (5.173) (112.902) (544,137) (732.172) 801.990 50.010 0 191.500 75,000 485,450 959,375 51.13D 24AW 236,420 125,000 522.235 0 0 0 0 it 77 00o) 0 0 0 (177.000) (177.600) 0 0 0 (177.000) 0 (776,280) (30.000) ' (20.000) (203.280) (200.000) (323.000) 0 0 (100.000) (I00.ODO) 0 0 (1.053.''.80) (30.000) (20.000) (203,180) (300.000) (500.000) (93.9055) 21.13D 4.600 33.140 (175.000) 22,235 268.226 0 0 0 269.='5 0 (80,710) (13,5D (6745) 187.115 0 0 0 254.640 (67,125) ReveasabyTrassfer 122.21S 261 (7,4(31 26AN 102.SI6 Appropr)st)oas Escsmbraaees (12.927) (12.927) Self—losarssce Reserves (Adjusted) (4.621,190) (19906) (5.173) (112.902) (544,137) (732.172) Other Sources/Uses Total Adjustments (I.51402) (197.132) (12,119) (116.022) (S44.137)(613.783) P ►L t�llaJ•��slaas 921 a 477.617 0 0 0 477617 s=ue • egtft�ei OPERATING TRANSFERS 10 General Fund Operating Transfers — In 13 Refuse Surcharge 16 Electric Utility Fund 17 Sewer Utility Fund 18 Water Utility Fund 21 Library Fund 30 Public Liability & Insurance Fund 31 Worker's Compensation Fund 32 State Gas Tax , 45 Housing & Urban Development 60 Impact Fees 121 Capital Improvement Plan 124 Transportation Development Act 134 Hotel Motel Fund Operating Transfers — Out 12 Equipment Fund 30 Public Liability& Insurance Fund 120 Community Center Fund Total Operating Transfers' 12 Equipment Fund Operating Transfer— In 10 General Fund 13Refuse Surcharge Operating Transfer— Out 10 General Fund 16 Electric Utility Operating Transfer—Out 10 General Fund 30 Public Liability & Insurance Fund Total Operating Transfers 17 Sewer Utility Operating Transfer— Out 10 General Fund 30 Public Liability Insurance Fund Total Operating Transfers 18 Water Utility Operating Transfer— Out 10 General Fund 30 Public Liability Insunince Fund Total Operating Transfers i3TKANS3. WKS 13 Increase SCHEDULE G Net Decrease Change 229,520 200,000 446,250 7,433,340 875,770 6,557570 229,520 229,520 124,030 (124,030) 4,367,500 39,215 0 4,406,715 (4,406,715) 702,930 _ 19,810 0 722,740 (722,740) 905,360 9,200 _._..__914,560 (913,560) SCHEDULE OF SOURCES/USES OPERATING TRANSFERS WrRANS3. WKS 14 Net Increase Decrease Change 21 Library Fund Operating Transfer—Out 10 General Fund 38,910 (38,910) 30 Public Liability Insurance Fund Operating Transfer—In 10 General Fund 200,000 16 Electric Utility 39,215 17 Sewer Utility 19,810 18 Water Utility 9,200 Operating Transfer—Out 10 General Fund 13,585 Total Operating Transfers 266,225 13,585 254,640 31 Worker's Compensation Fund Operating T�. ansfer —Out 10 General Fu nd 67,125 (67,125) 32 State Gas Tax (2107) Operating Transfer—Out 10 General Fund 454,835 (454, 835) 45 Housing & Urban Development Operating Transfer—Out 10 General Fund 47,630 (47, 630) 60 Impact Fees Operating Transfer—Out 10 General Fund 16,145 (16,145) 120Community Center Operating Transfer— In 10 General Fund 446,250 446,250 121 Capital Improvement Plan Operating Transfer—Out 10 General Fund 169,495 (169,495) 124 Transportation Development Act Operating Transfer—Out 10 General Fund 320,990 (320,990) 134 Hotel Motel Operating Transfer— O u t 10 Generaf Fund 204,805 (204,805) WrRANS3. WKS 14 REVENUES/EXPENSES BY TRANSFER BTRANS4. W KS 15 _. SCHEDULE11 Nct Inctcasc Dcucasc Changc 10 General Fund Revenues By Transfer Equipment Maintenance (Object Code 333) Electric Utility 95,135 Sewer Utility 82,120 Water Utility 28,195 Library 50 Expense Transfers 27 Long—Term Disability Self—Insurance(128) 34,290 28 Employee Benefits (Chiropractic 129) 15,985 29 Employee Benefits (Dental Insurance 113) 147,300 29 Life Insurance (124) 21,785 31 Worker's Compensation (111) 475,195 41 Debt service 177,235 Total 205,500 871,790 (666,290). 16 Electric Utility Expense Transfers 10 General Fund (333) 95,135 27 Long—Term Disability Self—Insurance(128) 8,010 29 Employee Benefits (Dental Insurance 113) 19,160 29 Life Insurance (124) 3,010 31 Worker's Compensation (111) _ 26,830 Total 0 152,145 (152,145) 17 Sewer Utility Expense Transfers 10 General Fund (333) 82,120 27 Long—Term Disability Self—Insurance(128) 3,835 29 Employee Benefits (Dental Insurance 113) 10,450 29 Life Insurance (124) 1,555 31 Worker's Compensation (111) 28,515 41 Debt Service 17_6,652_ Total 0 303,127 (303,127) 18 Water Utility Expense Transfers 10 General Fund (333) 28,195 27 Long—Term Disability Self—Insurance (128) 1,189 29 Employee Benefits (Dental Insurance I 13) 3,254 29 Life Insurance (124) 506 31 Worker's compensation (111) _ _ _ 12,156 Total 0 45,300 (45,300) BTRANS4. W KS 15 SCHEDULE -01- INTERFMM TRANSACTIONS REVENUES/EXPENSES BY TRANSFER 21 Library Fund Expense Transfers 10 General Fund (333) 27-Long—Term Disability Self—Insurance(128) 28 Employee Benefits (Chiropractic 129) 29 Employee Benefits (Dental Insurance 113) 29 Life Insurance (124) 31 Worker's Compensation (111) Total 27 Long—Term Disability Fund (128) Revenues by Transfer 10 General Fund 16 Electric Utility Fund 17 Sewer Utility Fund 18 Water Utility Fund 21 Library Fund 120 Community Center Total 28 Chiropractic (129) Revenues by Transfer 10 General Fund 21 Library Fund 120 Community Center Total 29 Employee Benefits Revenues by Transfer 10 General Fund (113) 16 Electric Utility Fund (113) 17 Sewer Utility Fund (113) 18 Water Utility Fund (113) 21 Library Fund (113) 120 Community Center (113) 10 General Fund (124) 16 Electric Utility Fund (124) 17 Sewer Utiiity, fund (124) 18 Water Utility Fund (124) 21 Library Fund (124) 120 Community Center (124) Total BTRANS4. W KS 16 SCHEDULE H Incrcasc Dccrcasc 2,200 900 6,585 1,420 6,280 0 17,435 34,290 8,010 3,835 1,189 2,200 780 Nct Cha ngc (17,435) 50,304 0 50,304 15,985 900 300 17,185 0 17,185 147,300 19,160 10,450 3,254 6,585 2,655 21,785 3,010 1,555 506 1,420 _ 700 _ 218,380 0 218,380 REVENUES/EXPENSES BY TRANSFER SCHEDULER Net Increase Decrease Change. 31 Worker's Compensation Fund Revenues by Transfer 10 General Fund (111) 475,195 16 Electric Utility Fund (111) 26,830 17 Sewer Utility Fund (I 11) 28,515 18 Water Utility Fund (111) 12,156 21 Library Fund (111) 6,280 120 Community Center (11 l) 3,990 Total 552,966 0 552,966 41 Debt Service Fund Revenues by Transfer 10 General Fund 177,235 17 Sewer Fund 176,652 Total 353,887 0 353,887 120 Community Center Expense Transfers 27 Long—Term Disability Self—Insurance (128) 780 28 Chiropractic (129) 300 29 Employee Benefits (Dental Insurance 113) 2,655 29 Life Insurance (124) 700 30 Worker's Compensation (111) 3,990 Total Expenditure Transfers 0 8,425 (8,425) BTRANS4.WKS SCHEDULE OF ENCUMBRANCES CARRIED FORWARD (FY 1992-93) BY FUND SCHEDULE I TOTAL VENDOR PO ACCOUNT #_ AMOUNT BY FUND GENERAL FUND R L Polk & Co 6788 10.0-001.01-308 43.41 Multisonics Traconex 6600 10.0-015.01-506 377.13 ZeIle rach Paper Co 3476 10.0-024.01-302 9858 R L Polk & Cc 6788 10.0-096.01-308 43.43 Anzac Computer Equip 6907 10.0-030.01-501 499.99 Herman M]]Er Inc 6931 10.0-040.02-501 362.99 R L Polk & Co 6788 10.0-045.01-308 28.93 Jones & S t ock es C 279 10.0-6.01-323 3.858.67 Tab of Central Calif Inc 6895 10.0-045.02-307 238.13 R L Pblk & Co 6788 10.0-045.02-308 28.94 Ben Weese & Amos 4907 10.0-045.02-313 260.00 Computerland Infosystems 6922 3D.G-M.02--31.3 47052 Helmsman Printing 6855 10.0-060.01-301 602-32 CompuCom Systems 5688 10.0-060.01-313 3.169.66 Ba rla nd 5896 10.0-060.0!1-313 116.70 Computerland Infosystems 6922 10.0-060.01-515 52.97 Duncan Pj2ss 6904 10.0-050.02-301 99.13 M icrorim 6926 10.0-050.02-313 629.07 Watts Equip Cc Inc 4537 10.0-050.02-331 229.08 Hyster Co 5682 10.0-M.02-331 14052 Capital Cly 4490 10.0350.02-332 11.06 Computerland i n fos ys t e ms 6929 10.0-060.02-515 2.514.26 DD Business Machines 5779 10.0-060.03-332 100.00 Capital Office Systems 6459 10.050.013-332 320.00 Computerland I n f osys to ms 6929 10.0350.03--515 1,476.81 Block& Co 6891 10.0-050,04 -307 324.45 R L Polk & Co 6788 10.0-050.04-308 43.41 Intermic 6915 10.0-050.04-308 28.28 DD Business Machines 5779 10.0-060.013-332 100.00 Anzac Computer Equip 6830 10.0-0150.01-332 2,352.00 Nick's Guns Work 6455 10.0-050.04 -352 36851 Pitney Bowes 6900 10.0-050.04-51711. 9,794.48 I n t e rm i s 6915 10.0-050.04-515 1.75555 R L Polk & Co 6788 10.0-050.05-308 43.40 DD Business Machines 5779 10.0350.05-332 51.93 R L Polk & Co 6788 10.0- ]01.01- ;113 86.81 Pactel Cellular 9358 1o.0-imm-202 469.62 Xerox Corp 4331 10.0-303.01-302 761.00 Long's Ih'3 5724 10.0- 303.01-307 350.74 Richard Young Producets 6894 10.0-103.01 -307 121.22 R L Polk & Co 6788 10.0- 303.01-308 86.8! Lighting Powder Co 6928 10.0-103.01-308 138.42 Roy Al I e n Mfg 6890 10.0-403.01 -352 180.07 Roy Allen Mfg 6890 10.0-303.01-355 67.23 Jorgcnson & co 6868 10.0-103.01-356 138.~(1 IBM 6753 10.0-103.01-515 1.007.26 19 SCHEDULE OF ENCUMBRANCES CARRIED FORWARD (FY 1992-93) BY FUND SCHEDULE 1 _ TOTAL VENDOR PO # ACCOUNT # AMOUNT BY FUND Pactel Cellular 3103 10.0-103.05-617 50.00 Pactel Cellular 3104 10.0- 103.05 -517 53.00 En t e r1n ma nn -- R ovi n 9762 10.0-104.01-399 13.1.69 Pactel Cellular 9158 10.0-01.01 -202 302.62 R L Polk & Co 6788 10.0-01.01 -308 86.81 Motorola Communications 5171 10.0-01.01 -331 1,43550 Hi -Tech Emerg Vchick Scry 5449 10.0301.01331 NASD StateFire Marshalls Office 6484 10.001.01 358 66.80 R L Polk & C0 6788 10.0-301.01-308 28.93 Radiation Detection Co; 5872 10.0302.01 323 95.00 Engineering Supply 5889 10.0302.01 352 10.gb1 Computerland lnfosystems 6922 10.0-302.01-359 68.10 Harland Asociates 5898 10.0351.01 323 1,000.00 Nelson & Assoc 5899 10.0351.01 323 3,800.00 Contract Interiors 5848 10.0-351.01 -334 225.72 Zellerach Paper Co 3187 10.0-351.01353 71.30 Jorgenson & co 6643 10.0301.01 306 72.40 Woodbridge Mach & Welding 6515 10.0-501.01333 1.000.00 JE Bauer Co 6260 10.0-503.08- 352 609.66 SJ Co Mosquito Abatement 5266 10.0-503.09-335 400.00 Jorgenson & co 6868 10.0-551.01 356 15637 U n iso a rce Corp 3941 10.0701.01 -302 34.62 R L Polk & Co 6788 10.0-701.01 -308 86.81 Pd Sof twa re house 8785 10.0-701.01-313 14052 NRPA Pacific Regional Of Tice 5959 10.0751.01 315 545.00 Xerox Corp 4430 10.0-751.01 332 275.34 IBM 6304 10.0-751.01 332 178.76 Fisco 50/09 10.0752.02 359 59039 McGee Communications 4643 10.0-752.03-33 1 30.00 West -Lire Supply Co 6903 10.0-752.03-334 3233 Port- 0 - Let 4603 10.0-752.03-335 49.81 Hamnton Industrial 4691 10.0752.03 352 949.98 Associated Sound 5970 10.0-752.03-399 312.08 Polaroid Customer Service 68% 10.0- 752.08- 332 37.95 Delta Rubber 6835 10.0-753.01-331 69.85 Roberts Petroleum 6912 10.0-753.01 -351 374.97 Tifco Industries 5013 10.0-753.01-355 52.16 GENERAL FUND TOTAL ---47,101 18 SCHEDULE OF ENCUMBRANCES CARRIED FORWARD (FY 1992-93) BY FUND _. _ __ _ SCHEDULE 1 ELECTRIC UTILITY FUND R L Ralk & co 6788 16.0--601.01-308 TOTAL VENDOR _ PO #t ACCOUNT # AMOUNT BY FUND EQUIPMENTREPLACEMENT FUND 5081 16.0-001.01-313 113.68 Pactel 6463 12.0-013.19-517 210-18 ComputerDraffing 5887 12.0-013.69-313 100.00 800 software 5893 12.0-013.69-313 1,092.59 Hewlett-Packard 5897 12.0-013.69-313 52.80 Dovmkmn Ford 6462 12.0-013,72-503 45.000.00 Downtown Ford 6462 12.0-013.74-503 21,000.00 Downtown Ford 6462 12.0 - 013.75 -.W 7,%.26 River City Installations 5849 12.0-013.75-503 8-133.98 Downtown Ford 6462 12.0-013.75 -503 10,75755 Downtown Ford 6462 12.0-013.75-622 749.83 Idea Servcom 6778 12.0-013.83 -335 31020 TOTAL EQUIPMENT REPLACEMENT FUND 9312 -88,30.1x9 ELECTRIC UTILITY FUND R L Ralk & co 6788 16.0--601.01-308 86.81 M icro rim 6874 16,0-601 ,01 -_1W 69.65 Advanced Graphics 5081 16.0-001.01-313 113.68 Wencll Mattheis Bowe 4141 16.0-601.01-311 2 ,213.19 Computer Warehouse 6837 16.0-001.01-332 109.00 Morgan Equipment 1837 16.0-601.01 -333 2.000.00 Altce Industries 6728 16.0-001.01-333 3,034-32 Diversified Inspections 6950 16.0-001.01-333 2.400.00 M icrorim 6874 16.0-601,12-308 69.65 John Fluke Co 6869 16.0-602.02 - 331 225.00 Deco ut&ySupply 6410 16.0-602,02-519 102-12 Dcco 6748 16.0-602.02-519 21.12 USPCI Inc 5404 16.0-604,09-324 4.969.00 USPCI Inc 6704 16.0-604.09-324 2.104.10 No American Environmental Inc 9312 16.0--604.09-324 460.80 No American Environmental Inc 9435 16.0-604,09-324 375.00 No American Environmental I nc 9436 16.0-604.09-324 499.0 KahlerConcretc 1385 16.0-604,09-527 1l;+ 1 1 Osmose Wood Preserving 6881 16.0-6064.10-335 21919.50 Bill Henton Tools 5710 16.0 - 604,10 -35 9 21.44 Wesco Utilities 6408 16.0 -604 J 0 -359 412.74 Deco utility Supply 6410 16.0-005.10-519 263.12 Dcco UtilitySuppiy 6410 16.0-605.10-519 734-12 Kahler Concrete 5201 16.0-604.10- 527 95.00 Kahicr Concrete 5776 16.0-lioJ.10-527 28.(X) Port-O-Lct 5765 16.0-604.12-322 2.33.24 George EHonn Co 6812 16.0-604.12-355 215.11 Dodo 6795 16,0-(A'}412-519 1,194.20 Microhm N974 16.0 -604.13 -308 139.30 Stockton Blueprint 6397 16.1 -6.~0.47-335 58.50 Utility Vault (US 14 16.1-650.02 -519 572.(X) Ahce Construction 0854 16.1-650.02-520 2.7(X) W 21 SCHEDULE OF ENCUMBRANCES CARRIED FORWARD (r -Y 1992-93) BY FUND 6515 17.0-401.01 -333 1.000.00 SCHED11LE I 6616 17.0-401.01 333 11,391.65 Valley Industries TOTAL VENDCR POO ACCOUNT # AMOUNT 'BY FUND Western Utilities Transformer 6927 16.1-650.02-520 3,100.00 2-30.40 Ka h 1 e r Concrete 5776 16.1550.02-527 140.00 Mettler Instrument Corp Culver Co Customer Se ry 6749 16.1550.03-519 135 6517 Rochester Instrument Sys 6897 16.1-650,03-519 6,495.00 17.0-404.01-352 Valley Electric 3943 16.1-65013-513 30.47 121,145.48 Specialty Electrks Inc 6913 16.1-650.23-519 1,891,25 Wendell Matthci_s Bowe Diode Construction 6918 16.1-650.2,3-520 24,316.00 9645 Sa nco 6870 16.1-650,45-322 900.00 17.1-400.01-528 Sermr Inc 6323 16.1550.45-519 73.12 2„74.69 Wesw Utilities 6924 16.1550.45-519 7,576.66 Alder Construct ion Kahler Concrete 1843 16.1-680.19-509 3,907.86 4012 Airco 6783 16.1-680.40-519 12,313.37 172-410.75-331 N b e r Engineering 6376 16.1-6-90,43-519 12,909,53 X1$1933,29. Meehleis Modular 16.1-680,48-524 138.500.10 TOTALELECTRIC UTILITY FUND 259,982.60 SEWER UTILITY FUND Woodbridge Mach & Welding 6515 17.0-401.01 -333 1.000.00 Municipal Maintenance Equip 6616 17.0-401.01 333 11,391.65 Valley Industries 6617 17.0-401.01-333 126.80 BAY Alarm 4223 17.0-403.01 202 104.00 Anlab 6639 17.0-403.01 -323 2-30.40 USPCI Inc 6356 17.0-403.01-352 1.140.00 Mettler Instrument Corp 6530 17.0-403.01 399 115.00 Capital Abr 9ol 6517 17.0-404.01-352 78.72 Wcco Industries 6602 17.0-404.01-352 483.80 Flexible Video System 6850 17.1-012.34-519 121,145.48 Econonet 4144 17.1-013.69-323 17.28 Wendell Matthci_s Bowe 5805 17.1-350.95-323 896.25 Mors & Wenell 9645 17,1-350,95-323 2.893.65 Claude C Wood 5874 17.1-400.01-528 12.000.00 Whitley, Burchett & Assoc 4048 17.2-410.40-323 2„74.69 Central Valley Hardware 5878 1', .2 - 41 G.cO - 334 814.03 Alder Construct ion 17.2-410.00-520 32.503.00 Wenell M a t t h eis Rovee 4012 172-410.65-32.1 735.00 G!erlkh -Mitchell 6298 172-410.75-331 29,826.:5 TOTAL SEWER UTILITY FUND X1$1933,29. WATER UTILITY FUND R L Polk & Co 6788 18.0-451.03-352 43.41 Stockton Fence Co 5866 18.0-453.01 -331 2.0560) Layne -Western 6577 18,0-453.01 -331 10.5720) All Pure Chemical 6632 18.0-453.01-352 581.85 Kirby's Pump & Motor 18.0-453.01-520 2.938.50 Capita! Air TmI 6517 18.0-454.01-352 7S.71 Borland 58% 18.1-013.69-313 27.25 O GAS TAX FUNDS Borland 58% 32.0313.69-313 89.45 R L Polk & Co SCHEDULE OF ENCUMBRANCES CARRIED FORWARD (FY 1992-93) 43.40 BY FUND 4135 32.0-503.05-527 SCHEDULE I Cen-Cal Contractors 6039 32.0-503.05-527 320.00 TOTAL V]0� PO # ACCOUNT # AMOUNT BY FUND Wench Matthch Bowe 5805 18.1 -350.95 -?23 896.25 6283 Morris& Wenell %45 18.1-350.95-323 2,893.66 33.0-50033-515 Kahler Concrete 4133 18.1-402,10-529 70.00 19,420.49 Gcib Engineering 2747 18.1-45034-323 49,905.00 Brown & Caldwell 9699 18.1-450,40-323 390.00 WMI services 5882 18.1-450.44-524 165.15 Clark Well& Equip 5865 18.1-460.03-323 1,000.00 Wenell Mattheis Bowe 4066 18.1-460.1 1-323 955.15 Platt Electric Supply 3999 18.1-4,60.11-355 39.14 Brown & CadlweU 4104 18.1 -460.16-323 750.00 AU Phase Electric 5718 18.1-4-60.24-355 759 Brown & Caldwell 5832 1&1-460-10-323 51350.00 TOTAL WATER UTILITY FUND 124,719.66 ASSET SEIZURE FUND Pactel Cellular 3103 23.0-012.01-517 309.00 TOTAL ASSET SEIZURE FUND 309.00 WORKER'S COMPENSATION FUND American Natl Standards 6859 31.o-020.02-306 47.00 USPCI Inc 6785 31,0-020,02-335 12,880.00 TOTAL WCEUI ER' S COMPENSATION FUND 12,927.00 GAS TAX FUNDS Borland 58% 32.0313.69-313 89.45 R L Polk & Co 6788 32.0-503.02-352 43.40 Interlake 4135 32.0-503.05-527 2,26450 Cen-Cal Contractors 6039 32.0-503.05-527 320.00 United Ceramic Inc 5881 33.0-500,03-527 951.00 Western lFighwayProducts 6626 33.0-500.09-352 501.16 Multisonics/Traconez 6283 33.0-500.33 -506 14,50750 Computer Warehouse 6802 33.0-50033-515 743.48 TOTAL GAS TAX FUNDS 6929 (-t).8-302.05-515 19,420.49 SPECIAL GRANT FUNDS HMaxL,ce c387 44.3-760,12-524 41.875.00 TOTAL SPECIAL GRANT FUNDS 41,875.00 IMPACT MITIGATION FUND Rich Bramwell 6779 60.3-525.41-323 4,000.00 Rich Bramwell 59170 60.3-525.4.1-323 2.5(X)•()1) Nolte & Associates 5.859 60.8-'02.05-323 80,663.28 Geonex Cartwright 5861 M.8-302.05-323 4.934.84 Computer Warehouse 6902 60.8-302.05-515 1.486.95 Computerland Infosystems 6929 (-t).8-302.05-515 57.97 TOTAL IMPACT MITIGATION F;1ND 93 643.04 23 SCHEDULE OF ENCUMBRANCES CARRIED FORWARD (FY 1992-93) BY FUND SCHEDULE 1 TOTAL VENDOR PO ACCOUNT # AMOUNT BY FUND COMMUNITY CENTER FUND _ 9,434.88 11,074.74 R L Pbk & Co 6788 120.0-040.03-308 Boberg Hardwood Floors 5110 120.0-752.05 —334 Walters Carpet& Interiors 5113 IM.0-752.0E-334 Pat Sypnieski Fainting 5114 IM.0-752.05 —334 West— litcsupply Co 6903 1M.0-752.05 334 Westinghouse Elec supe 2557 120.0-752.05-359 Durst O f 11 Interiors 6943 1M.0-752.05 —519 RMH Equipment 6944 120.0-752.05-- 9 TOTAL COMMUNITY CENTER FUND CAPITALOUTLAY FOND Ramsey —Preszler Arch 9533 121.0-350.61-323 WendellMattheis Bowe 5812 121.0-350.62-323 li dA Bigler W 121.0-760.96-323 TOTAL CAPITAL OUTLAY FUND LODI LAKE CAPITAL FUND Gary's Signs 5955 122.0-76053-525 TOTAL LO D I LAKE CAPITAL FUND TRANSPORTATION FUNDS Chec Consultants 5840 124.0-500.80-323 Jer►y Heminger 9571 124.0--500.99-323 Ace ConcreteScrvice 5885 328.0-500.04 —527 TOTAL TRANSPORTATION FUNDS 24 86.81 4,975.00 978.00 1065 31.36 9.05 1,267.14 1,02251 _ 9,434.88 11,074.74 26,00250 4,284.88 X2,362.12 395.66 398.68 1,532.00 2.340.00 3,728.55 7,60055 GRAND TOTAL 965,445.19 SCHEDULE OF WORK Ilii PROGRESS BY FUND — — SCHEDULE J FUND Arr_mint Name S Amount Total Fund EQUIPMENT REPLACEMENT FUND 120 Misc Equip 52,315.02 TOTALEQUIPMENT REPLACEMENTFUND 52,315.02 ELECTRIC UTILITY FUND 16.1 MSC — Garage Expansion 73,000.00 Distribution System Improvements 81,092.13 Substation Construction 50,721.72 Ind Substation — Off Site Eng & Imp 74,453.73 Other projects 27,661.95 TOTAL ELECTRIC UTILITY FUND 311,929.53 SEWER UTILITY FUND 17.1 Wastewtr Main Rept—Cherokee/Fopular 150,687.85 MSC —Adtn Build 107,281.26 MSC — Covered Stcrage 120,000.00 MSC — Garage Expansion 61,365.78 Miscxllaneous Sanitary Sevmrs 89,395SO 17.2 White Slough — Eng.Admin/Irspection 127,344.43 Wastewater Main Replace — Alley/N Elm 170,604.92 WSWPCF —Irrigation System Exp Phase 2 137,000.00 White Slough —Construction Contracts 101,370.48 TOTAL SEWER LM L =1 FUN U 1,065,05052 WATER UTILITY FUND 18.1 MSC — Adm Build 55,000.00 MSC — Covered Storage 60,(110.00 MSC — Garage Expansion 60,866. iY well 11 229238.91 Well 24 125.72154 Well 24 — Pump & Motor 248,687.94 Other projects 190,151,41 TOTAL WATER UTILITY FUND 969,666.54 LIBRARY FUND 21.0 Library Property Acquisition 300,000.00 Library Computer Upgrade 141,915.02 TOTAL LIBRARY FUND 441,915.02 ASSET SEIZURE FUND 23.0 LPD — Detective Computers 26,000.00 LPD — Fircarms/Safcty Equip 60.(XX).00 TOTAL ASSET SEIZURE FUND 86.000•00 SCHEDULE OF WORK IN PROGRESS BY FUND FUND Account Name GAS TAX FUNDS 33.0 Church Signal Coordination Pavement R e h a m Stkn S t Cherokee/Kettleman ChurchSt OverlayVinc/Tokay/Chestn Other Proj-ects TOTAL GAS TAX FUNDS TRANSPORTATIONFUNDS 37.0 Cherokee Kettleman to Delores 124.0 Cherokee Kettleman to De l o r e s other projects 126.1 Stockton LodVl-ockford Overlay 128.0 Otherprojects TOTAL TRANSPORTATION FUNDS SPECIAL GRANT FUNDS 443 Lake Picnic Facilities TOTAL SPECIAL GRANT FUNDS IMPACT' MITIGATION FUNDS 60.1 Prelim We Site Design other p roje-cts 602 Kettleman Lane Lift Station 60.3 G Ba is n Fencing/Excavation Kettleman Lane Lift Station 60.4 Highway 12 Project Study R e po rt Kettleman Lane Lift Station TOTALIMPACT MITIGATION FUNDS HUTCHINS STREET CAPITAL, FUND 120.1 Auditorium Multi Purpose Complex TOTAL HUTCHINS STREET CAPITAL FUND CAPITAL OUTLAY FUND 121. Revenue Enhancement Survey City Hall Expansion & Remodel Stadium Upgrade Elec Sys Other projects TOTAL CAPITAL OUTLAY FUND LODI LAKE CAPITAL FUND 122.0 Other projects TOTAL LODI LAKE CAPITAL FUND S Amount 51,231.48 49,000.00 85,441.13 112,059.55 54561.91 21,260.00 74,744.44 22,483.89 163,642.66 398.92 40,772.40 50,000.00 103.10 27,570.00 102,932.98 43,657.76 92.000.00 20,829.80 52,141-13 56,0(6.79 1,807,145.74 133,908,00 85,699.22 46-591.32 SCHEDULE J Total Fund 352,294.07 282,529.91 40,77240 337,093.54 52,141.33 2,082,759.75 46,591.32 SCHEDULE OF WORK IN PROGRESS BY FUND SCHEDULE J FUND Account Name S Amount Total Fund MASTER DRAIN FUND 1230 Hutchins Walnut/Elm 58,977.49 TOTAL MASTER DRAIN FUND 58,977.49 HOTELIMOTEL FUND 134.0 Other projects 5,36335 TOTAL HOTEL/MOTEL FUND 5,363.35 TOTAL APPROPRIATIONS FOR WI P 08WM79