The URL can be used to link to this page

Home My WebLink About(0033) 03FY2020_WINDUP_Funds_Avail.pg.pdfFunds available as of 9-10-20 Recommendation 1&3 $4.1M has already been moved ji Budget PeriDd 2020 v Fund 10100 General Fund Parent Department 090 - N and epa rtme ntal Rollup " Department 09CI4600 - Nondept Tuition Reim6ursei " 14 < 0 of 1 ? Export Detail Data ❑+ 090 Nondepartmental Rollup ❑+ Salary & Benefits EiGeneral Oper & Maint pTransfers & Other the 2.9M and the 362K left to move 10095 V LoJ `� ■ Total Revenues : Total Expenditures Recommendation 2 79K moving to 25011 FUND ' FundDescr(-,]PROJECT I-' Project D�ACCOUNT ' Descr I'IDEPT 930100 oGeneralCapi aP00110 oBotanricGa 0492500oTransfer 80800450 30100 Gen era I api P00110 BotanicGa =4925011 eTransfer a09OM50 30100 General Cap! P00110 BotanlcGa 41325011 Transfer 0800450 30100 General Cap! P00110 BotanlcGa 4la25011 Transfer 0800450 30100 General Cap! P00110 BotanlcGa 4925011 Transfer 0900450 i 30100 General Cap! P00110 BotanlcGa Expense - None - 0800450 30100 General Capi P00110 BotanlcGa Expense None 0800450 30100 Generalfapi P00110 BotankGa Expense None 0800450 30100 Tota l Grand Total Find I Next $0_00 $0.00 $99,195.83 $88195.83 $883195.83 0.00 $03,195.03 0.00 $3,627,151_DD 50.00 $0.00 $O.OD $3,627,151.00 0.00 $1,420,141.00 30.00 31,000:000.00 $0.00 $420,141.00 70.42 $1,145,000.00 30.00 $0.00 $1,145,000.00 $0.00 100.00 $6,192,292.00 50.00 $1,004,400.04 $1,1451004.00 S4,047,292.00 34.64 CFI - Active - j Bum CF2 L o PGMABL 09999 None zi None -) 2019 None None :j2020None None 09999 None = PGMABL 09999 None = None �j2019 None None �j 2020 None None 09999 None etProjRev GL_Revenue Rev Variance Budget Proj Exp GL_Expense ExpVariance 0.00 0.00 0.00 0.00 (85,795.25) (85,7%.25) 0.00 0.00 179,027.19 179,027.19 0.00 0.00 191,980.00 191,980.00 0.00 0.00 (348,673.05)� (348,573.05) 0.00 0.00 0.00 0.00 (105,905.25) (105,905.25) 0.00 0.00 179,027.19 179,027.19 0.00 0.00 191,980.00 191,980.00 295,210.94 (348,673.05) (63,4452.11) 265,201.94 0.00 265,201.94 2,85,210.94 (348,673.05) 163,4452.11) 265,201.94 0.00 265,201.94 Recommendation 4 Budget Period 12020 v Fund I25011 Botanic Gardens SpecI Revenue Parent Department 060 - PACs Department Rollup " Department 0807011 - PAR Contract Ma nag ement,l " < RL —� of 1 > > Find j Next EE1060 PACS Department Rollup $6,573,665.00 $4,766,820.85 ($1,807,044.15) 72.51 Total Revenues: $6,573.865.00 $4,766,020.65 ($1,807,044.13) 72.51 HiSalary & Benefits $3,79E,792.00 30.00 $0.00 $3,130,733.25 3663,008.75 82.42 pGeneral Oper & Maint $2,287,312.00 $53,061.00 $25.290.08 $1,753,125.87 $455,335.05 80.07 alTransfers & Other $437,761.00 S0.00 $0.00 $340,434.00 $147,327.00 69_a0 Total Expenditures : $6,573,865.00 S53,061.00 525,290.0E $5,2241343.12 $1,271,170.80 80.66 Fiscal Year 2020 AccoUnti ng Period 17 - CAFR Publication Entries Fund 25011 - Botanic Gardens Spec) R-evenue Ledger ACTUALS *' 0 of 6 > 100 Find Next I Mat Fund BalancefNet Position Calculation 5011 3010000 Fund Balance ($262,195.34) $0.00 ($4,766,820.85) $5,224,343.12 $195,326.93 Recommendation 5 Budget Period 2020 v Fund 154501 Municipal Parking Parent Department 020 - TPW Department Rollup Department 0201000 - TPW Organizational MangE Q [ F1 —1 of 1 > 10495 V Find Next EE1020 TPW Department Rollup $7,836,539.00 $4.508,803.53 ($3,327,835.47) 57.53 Total Revenues : $7,836.639.00 $4,5081803.53 ($3,327,835A7) 57.53 pSalary & Benefits $1,219,092-00 S0.00 $0.00 $1,084,125-21 $133,966.79 89-00 OGeneral Oper & Malnt $3,166,694 00 $169.165.89 S131,945.51 $1,549,514-77 $1,016,06T.53 67-91 pTransfers & Other $3,451,053.00 30.00 $0.00 $3,421,934.00 $29.919.00 99.13 Total Expenditures : $7,836,639.00 $169,165.89 $131,945.31 $6,355,573.98 $1,119,953.32 84.94 Fiscal Year 12020 v I Accounting Penod 117 - CAFR Publication Entries vl Fund VI Ledger ACTUALS **. 154501 - Municipal Parking 14 <10 of 10 > > 1W% Find I Next i utai Fund Balance/Net Position Calculation 54501 3050000 Net Position ($3,270,750.28) $0.00 ($4,508,803.53) $6,355,063_98 ($1,424,489.83) Recommendation 6 Budget Period 2020 Fund 160101 Fleet & Equipment yen+ Parent Department 021 - Property Mgmt Dept Rallup " Department 0212010 - PM Administration,0212011 ii 14 < 0 1 r ( 10046 V Find I Next ■, WM� ❑+ 021 Property Mgmt Dept Rollup $29,380,560-00 $24,199,125-97 {$5,182,434.03) 92-36 Total Revenues: $29,360,560.00 $24,198125.97 ($5,192,434.03) 02.36 F] Salary &Benefiits 510,006,126.00 30.00 $0.00 $3,706,874.81 $1,299.251.19 87.02 pGeneral Oper & Maint S19,360,362-04 ($3,625.28) $1,472.905.83 $15,449,945.52 32,441,135.93 97-39 pTransfers & Other $14,072-00 S0.00 $0.00 314,072-00 $0.00 100-00 Total Expenditures : S29,380,560.00 ($3,625.28) S1,472,905.83 $24,1701892.33 $3,740,387.12 87.27 Fiscal Year 2020 Accounting Period 117 - CAFR Publication Entries Fund 60101 - Fleet & Equipment Sery Ledger ACTUALS *' 14 of 14 > 100 Find I Next I oiai Fund Balance/Net Position Calculation 60101 3050000 Net Position ($3,345,919.47) $0.00 ($24,198,125.97) $24,171,630.20 ($3,372,415.24) Recommendation 7 the 17K is already in the fund Budget Period 2020 v Fund 56001 Water & Sewer Parent Department 913 - FMS Department Rollup,060 - Wr " Department 0132000 FM Accounting Division,46i " ' Q `w 1= of 1 } b FORT WORTH,, 10096 E - a Find I Next GLD019-03 - Operating Dept Ru nTime: 0911012020 11:28 AM Export Summary Qata Expand All Collapse All Export Detail Data El013 FM5 Department Rollup $650,000.00 $667,643.31 $17,643.31 102.71 El 56001 Water & Sewer 5650,000.00 $667,643.31 517,643.31 102.71 4905428 Proceeds frm WSS Rev Bnd 2020A $650,000.04 $667,643.31 317,643.31 102.71 ❑+ 0ti0 Water Department Rollup $277,796,497.00 $258.113.900.61 ($19,682,596.39) 92.91 El07-0 Wastewater Dept Rollup $197,602,813.14 318fi,617,568.82 ($10,985,249.32) 94.44 Total Revenues : $476,049,315.14 $445,399,112.74 ($30,650,202A0) 93.56 Recommendation 8, up to 9.03M will be moved to Transfer Out and transferred to 56002 Budget Period 2020 V Fund 56001 Water & Sewer Parent Department 060 - Water Department Rollup " Department 0601000 - Water Administration & Fiw " 1.1 < 1= of 1 ] RI 0 10096 V H " E5 I Find I Next EI Salary & Benefits $42,707,733.00 30.00 $0.00 $37,993,257.60 34:724,475.40 88.94 t7General Oper & Maint $137,720,816.00 $9,466,991.54 34,277:697.03 3113,526,650.04 510,44%447.39 92.41 EiDebt Service $13.750.00 50.00 $0.00 $12,850.00 $900.00 93.45 pTransfers & Other 397,354,198.00 30.00 $0.00 $92,228,290.00 $5,125,908.00 94.73 Total Expenditures : $277,796r497.00 $9,466.991.54 54,277,697,03 $243,7511077.64 $20,300,730.79 92.69 Recommendation 9 and 10 this 120K of this will be moved to 30100 Budget Period 2020 U Fund �10100 General Fund V Parent Department 006 - Development Services Dept Roll -j Department 0061000 - Development Services Admi " 14 [ F—I of 1 Find Next 4956001 Transfer From Waterl5ewer 900,712.00 $600,712.00 $0.00 100.00 Total Revenues : $18,991,442.00 $17,720,216.32 ($1,263,223.68) 93.35 ElSalary & Benefits $13,327.497.06 50.00 $0.00 $11,945,816.45 $1,381,660.63 89.63 pGeneral Oper & Maint $4,633,843.92 S20,515.05 $98,832.91 $4,368,376.55 $146,119.51 96_35 pTransfers & Other $217,437.00 30.00 $0.00 $0.00 $217,487.00 0.00 Total Expenditures : 518,178,825.00 520,515.05 $98,832.31 $16,314,193.00 $1,745,287.14 90.40