E-3 - Budget Report - Expense to Budget

Budget Report Tiffin, IA Group Summary For Fiscal: 2022-2023 Period Ending: 05/31/2023 Variance Original Current Period Fiscal Favorable Percent Fun… Total Budget Total Budget Activity Activity (Unfavorable) Remaining Function: 10 - PUBLIC SAFETY 001 - General Fund 769,272.00 769,272.00 1,071.99 897,429.09 -128,157.09 -16.66% 112 - Employee Benefit 83,112.00 83,112.00 0.00 57,412.41 25,699.59 30.92% 119 - Emergency Fund 29,525.00 29,525.00 0.00 15,002.14 14,522.86 49.19% 330 - Tiffin Firetruck 275,000.00 275,000.00 0.00 0.00 275,000.00 100.00% 345 - JOINT PUBLIC SAFETY BUILDING 0.00 0.00 0.00 292.50 -292.50 0.00% 346 - FIRE EQUIPMENT 0.00 0.00 0.00 123.75 -123.75 0.00% Function: 10 - PUBLIC SAFETY Total: 1,156,909.00 1,156,909.00 1,071.99 970,259.89 186,649.11 16.13% Function: 20 - PUBLIC WORKS 110 - Road Use Tax 442,026.00 442,026.00 5,823.67 415,244.14 26,781.86 6.06% 112 - Employee Benefit 73,995.00 73,995.00 0.00 56,983.07 17,011.93 22.99% 307 - Park Road Paving 0.00 0.00 0.00 165,753.83 -165,753.83 0.00% 335 - Forevergreen Rd Pjt 0.00 0.00 0.00 1,457.00 -1,457.00 0.00% 344 - PW - MOWERS 225,000.00 225,000.00 0.00 226,907.75 -1,907.75 -0.85% Function: 20 - PUBLIC WORKS Total: 741,021.00 741,021.00 5,823.67 866,345.79 -125,324.79 -16.91% Function: 40 - CULTURE & RECREATION 001 - General Fund 369,201.00 369,201.00 44,250.76 491,346.77 -122,145.77 -33.08% 112 - Employee Benefit 71,802.00 71,802.00 0.00 33,134.26 38,667.74 53.85% Function: 40 - CULTURE & RECREATION Total: 441,003.00 441,003.00 44,250.76 524,481.03 -83,478.03 -18.93% Function: 50 - COMMUNITY & ECONOMIC DEVELOPMENT 001 - General Fund 21,600.00 36,600.00 0.00 42,885.21 -6,285.21 -17.17% 112 - Employee Benefit 161.00 161.00 0.00 48.96 112.04 69.59% 125 - TIF 96,155.00 96,155.00 0.00 37,677.75 58,477.25 60.82% Function: 50 - COMMUNITY & ECONOMIC DEVELOPMENT Total: 117,916.00 132,916.00 0.00 80,611.92 52,304.08 39.35% Function: 60 - GENERAL GOVERNMENT 001 - General Fund 560,883.00 560,883.00 9,189.72 445,360.67 115,522.33 20.60% 112 - Employee Benefit 103,108.00 103,108.00 0.00 37,678.90 65,429.10 63.46% Function: 60 - GENERAL GOVERNMENT Total: 663,991.00 663,991.00 9,189.72 483,039.57 180,951.43 27.25% Function: 70 - DEBT SERVICE 125 - TIF 1,562,153.00 1,562,153.00 0.00 44,000.04 1,518,152.96 97.18% 200 - Debt Service 2,170,209.00 2,170,209.00 1,908,006.25 2,166,348.99 3,860.01 0.18% Function: 70 - DEBT SERVICE Total: 3,732,362.00 3,732,362.00 1,908,006.25 2,210,349.03 1,522,012.97 40.78% Function: 75 - CAPITAL PROJECTS 301 - DEVELOPER - ESCROW 0.00 0.00 0.00 285,582.00 -285,582.00 0.00% 310 - Trail Project 0.00 0.00 0.00 55,820.15 -55,820.15 0.00% 320 - Roundabout Park Rd 8,000.00 8,000.00 0.00 2,320.00 5,680.00 71.00% 321 - Original Town Urbanization 50,000.00 50,000.00 0.00 627,008.75 -577,008.75 -1,154.02% 326 - Town Center Land Purch 26,000.00 26,000.00 0.00 0.00 26,000.00 100.00% 329 - Deerview/HWY6 0.00 0.00 0.00 795.00 -795.00 0.00% 332 - Wtr Quality Sponsored PJT 0.00 0.00 0.00 3,810.00 -3,810.00 0.00% 335 - Forevergreen Rd Pjt 0.00 0.00 0.00 32,547.36 -32,547.36 0.00% 336 - Public Works Building 1,515,000.00 1,515,000.00 0.00 1,939,313.35 -424,313.35 -28.01% 339 - Original Town PH3 100,000.00 100,000.00 0.00 0.00 100,000.00 100.00% 341 - RFR Park 62,000.00 62,000.00 0.00 0.00 62,000.00 100.00% 343 - PERMEABLE PAVERS 0.00 0.00 0.00 115.00 -115.00 0.00% 607 - Second Well 50,000.00 50,000.00 0.00 794,842.57 -744,842.57 -1,489.69% Function: 75 - CAPITAL PROJECTS Total: 1,811,000.00 1,811,000.00 0.00 3,742,154.18 -1,931,154.18 -106.63% Function: 80 - BUSINESS TYPE ACTIVITIES 600 - Water 766,864.00 766,864.00 33,626.34 819,349.62 -52,485.62 -6.84% 601 - Water Sinking 22,440.00 22,440.00 22,247.50 22,440.00 0.00 0.00% 5/10/2023 11:22:27 AM Page 1 of 3