2021-11-24 Budget Details

9:09 AM 11/22/21 Cash Basis Town of Grant Profit & Loss Budget vs. Actual with % of Budget January 1 through November 22, 2021 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B C D E F G H I J K L M 2022 Jan 1 - Nov. 22, 2021 Budget $ Over Budget % of Budget Proposed Budget Comments Income 41110 · General Property Taxes 41111 · Tax Collections 2,218,743.83 0.00 2,218,743.83 100.0% 41113 · PP Tax Collections 254.71 0.00 254.71 100.0% 41114 · PP Tax Charge Backs 265.96 0.00 265.96 100.0% 41115 · Lottery Credit Check 11,941.01 0.00 11,941.01 100.0% 41116 · August Tax Settlementt 91,915.11 0.00 91,915.11 100.0% 41120 · Tax Settlement (1,980,786.34) 0.00 (1,980,786.34) 100.0% 41125 · Prior Years Tax Refunded Cty 1,120.81 0.00 1,120.81 100.0% 41110 · General Property Taxes - Other 0.00 314,740.00 (314,740.00) 0.0% $317,931.00 $229,063. + $88,868.(loan pymts) Total 41110 · General Property Taxes 343,455.09 314,740.00 28,715.09 109.12% 43410 · Shared Revenue 36,655.12 36,630.07 25.05 100.07% $36,639.12 43411 · Personal Property State Aid 308.97 308.97 0.00 100.0% $308.97 43420 · Fire Insurance Tax(2%) 6,799.05 6,800.00 (0.95) 99.99% $6,800.00 43430 · Computer Aid 49.89 50.00 (0.11) 99.78% $50.00 43531 · General Transportation Aids 305,189.64 305,189.64 0.00 100.0% $311,344.53 43545 · State Aid for Recycling 0.00 2,300.00 (2,300.00) 0.0% $2,300.00 43620 · April PILT 2,715.48 2,800.00 (84.52) 96.98% $9,698.15 2,770.9 acres @ $3.50 acre 43640 · Severance/Yield/Withdrawal Aid 43641 · Severance/Withdrawal Aid Rcvd 906.51 0.00 906.51 100.0% 43642 · Severance/Withdrawal Payment (181.30) 0.00 (181.30) 100.0% Total 43640 · Severance/Yield/Withdrawal Aid 725.21 0.00 725.21 100.0% $0.00 43650 · MFL/PFC State Aid 43651 · Forest Crop/ MFL State Aid Rcvd 892.87 0.00 892.87 100.0% 43652 · Forest Crop Payment (178.57) 0.00 (178.57) 100.0% 43650 · MFL/PFC State Aid - Other 0.00 1,000.00 (1,000.00) 0.0% $1,000.00 Total 43650 · MFL/PFC State Aid 714.30 1,000.00 (285.70) 71.43% 43660 · January PILT 43661 · January PILT Received 13,048.34 0.00 13,048.34 100.0% 43662 · PILT Expense (11,534.99) 0.00 (11,534.99) 100.0% 43660 · January PILT - Other 0.00 1,500.00 (1,500.00) 0.0% $1,500.00 43660 · January PILT 1,513.35 1,500.00 13.35 100.89% 43690 · Other State Aids 103,232.69 0.00 103,232.69 100.0% $103,232.69 ARPA - second payment 2022 43710 · County Bridge Aid 0.00 25,000.00 (25,000.00) 0.0% $25,000.00 110th St. Culvert -4 Mile Creek 43791 · 1st Responders County Grant 10,555.42 5,000.00 5,555.42 211.11% $5,000.00 44101 · Operator License 760.00 800.00 (40.00) 95.0% $800.00 44102 · Cigarette Licenses 20.00 20.00 0.00 100.0% $20.00 44103 · Liquor Licenses 1,150.00 1,150.00 0.00 100.0% $1,150.00 44110 · Franchise Fee 2,897.75 6,000.00 (3,102.25) 48.3% $3,000.00 Decrease $3,000.00 44200 · Dog Licenses 254.62 425.00 (170.38) 59.91% $400.00 44300 · Building Permits & Fees 4,310.00 3,500.00 810.00 123.14% $4,000.00 Increase by $500.00 44400 · Fees-Hearing 600.00 300.00 300.00 200.0% $500.00 Increase by $200.00 46101 · Publication Notice 350.00 350.00 0.00 100.0% $350.00 46310 · Highway Public Charges 480.81 250.00 230.81 192.32% $250.00 46431 · Transfer Uses - Garbage 99,652.00 97,406.00 2,246.00 102.31% $97,180.00 854 parcels @ $113.00 48110 · Interest Income 48112 · Park Fund Interest 153.08 0.00 153.08 100.0% 48113 · Equipment Savings Acct Interest 29.60 0.00 29.60 100.0% 48114 · Am. Rescue Plan Acct. 10.84 0.00 10.84 100.0% 48110 · Interest Income - Other 1,218.90 1,500.00 (281.10) 81.26% $1,500.00 Total 48110 · Interest Income 1,412.42 1,500.00 (87.58) 94.16% 48307 · Sale of Recyclable Materials 8,189.30 6,000.00 2,189.30 136.49% $7,000.00 Increase by $1,000.00 48309 · Sale of Other Equip. & Property 1,862.55 200.00 1,662.55 931.28% $750.00 Increase by $550.00 48430 · Insurance Claim 2,009.03 0.00 2,009.03 100.0% $0.00 48900 · Misc Income 0.00 300.00 (300.00) 0.0% $295.54 48901 · Fuel Refund 989.11 1,000.00 (10.89) 98.91% $1,000.00 Total Income 936,851.80 820,519.68 116,332.12 114.18% $939,000.00 Page 1 of 2 9:09 AM 11/22/21 Cash Basis Town of Grant Profit & Loss Budget vs. Actual with % of Budget January 1 through November 22, 2021 1 2 3 A B C D E F G H I J K L M 2022 Jan 1 - Nov. 22, 2021 Budget $ Over Budget % of Budget Proposed Budget Comments 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 Expense 51100 · Legislative (Board Exp. & FICA) 1,419.20 3,300.00 (1,880.80) 43.01% $3,300.00 51101 · Chairman Wages 6,425.86 7,009.59 (583.73) 91.67% $7,009.59 51102 · Supervisors Wages 7,255.64 7,914.97 (659.33) 91.67% $7,914.97 51105 · Publication Notice Expense 493.77 1,500.00 (1,006.23) 32.92% $1,500.00 51111 · Legislative Committees & FICA 450.00 550.00 (100.00) 81.82% $550.00 51300 · Legal 130.00 2,500.00 (2,370.00) 5.2% $1,750.00 51401 · Clerk-Wages 15,209.06 16,769.00 (1,559.94) 90.7% $16,769.00 51402 · Clerk Expenses & FICA 3,391.45 3,100.00 291.45 109.4% $3,100.00 51405 · Website Mntnce-Wages 660.00 720.00 (60.00) 91.67% $720.00 51410 · Election 6,765.61 5,500.00 1,265.61 123.01% $9,000.00 51420 · Other General Administration 2,662.90 2,500.00 162.90 106.52% $4,500.00 Board Phones/Fleet Mgmt 2,000 51510 · Treasurer Wages 6,317.62 6,891.85 (574.23) 91.67% $6,891.85 51511 · Treasurer Expenses & FICA 11,226.13 9,500.00 1,726.13 118.17% $11,000.00 51520 · Assessor 9,500.00 9,500.00 0.00 100.0% $9,500.00 51600 · Hall 51601 · General Building-Wages 105.00 0.00 105.00 100.0% 51602 · Hall Expenses 2,090.94 0.00 2,090.94 100.0% 51600 · Hall - Other 0.00 1,500.00 (1,500.00) 0.0% $1,500.00 Total 51600 · Hall 2,195.94 1,500.00 695.94 146.4% 51938 · Insurance 6,613.00 6,000.00 613.00 110.22% $6,000.00 52201 · Fire Protection - GRVFD 106,540.53 106,542.00 (1.47) 100.0% $109,452.75 $103,468.75 + $5984 (2% Dues) 52202 · Fire Protection - PVFD 12,729.89 12,730.00 (0.11) 100.0% $13,063.00 $12,247.00 + $816 (2% Dues) 52301 · First Responders 52310 · 1st Responders Wages 2,357.93 0.00 2,357.93 100.0% 52301 · First Responders - Other 28.00 5,000.00 (4,972.00) 0.56% $5,000.00 Total 52301 · First Responders 2,385.93 5,000.00 (2,614.07) 47.72% Total 52302 · First Responders-Cty Grant 1,848.79 5,000.00 (3,151.21) 36.98% $5,000.00 52303 · Ambulance Contract Services 41,493.48 42,000.00 (506.52) 98.79% $42,000.00 53301 · Highway Safety Apparel 426.54 950.00 (523.46) 44.9% $950.00 53302 · Highway-Wages 40,503.26 59,549.00 (19,045.74) 68.02% $60,000.00 53303 · Highway Maintenance 10,218.80 60,000.00 (49,781.20) 17.03% $60,000.00 53304 · Hwy-Repair & Parts 15,110.77 10,000.00 5,110.77 151.11% $10,000.00 53305 · Highway Insurance 10,186.00 9,100.00 1,086.00 111.93% $10,200.00 Increase $1,100.00 53306 · Snowplowing-Wages 7,485.23 12,000.00 (4,514.77) 62.38% $12,000.00 53307 · Snowplowing Expenses 2,001.51 6,000.00 (3,998.49) 33.36% $6,000.00 53308 · Highway - Fuel 14,517.26 16,000.00 (1,482.74) 90.73% $16,000.00 53309 · Highway - Garage 3,843.07 3,500.00 343.07 109.8% $3,500.00 53310 · Highway - Other 2,515.88 1,500.00 1,015.88 167.73% $1,500.00 53315 · Highway Construction 8,506.73 120,000.00 (111,493.27) 7.09% $120,000.00 53420 · Street Lights 2,192.13 2,500.00 (307.87) 87.69% $2,500.00 53620 · Solid Waste 55,837.13 58,364.00 (2,526.87) 95.67% $60,000.00 53625 · Transfer Station Labor & FICA 53626 · Solid Waste-Wages 7,995.00 0.00 7,995.00 100.0% 53627 · Recycling-Wages 11,305.08 0.00 11,305.08 100.0% 53625 · Transfer Station Labor & FICA - Other 0.00 18,838.00 (18,838.00) 0.0% $20,000.00 Total 53625 · Transfer Station Labor & FICA 19,300.08 18,838.00 462.08 102.45% 53628 · Transfer Station Shed 0.00 500.00 (500.00) 0.0% $500.00 53635 · Recycling Expenditures 19,153.73 20,188.00 (1,034.27) 94.88% $20,200.00 54100 · Animal Control 910.26 800.00 110.26 113.78% $1,000.00 56901 · Zoning Administrator-Wages 3,776.64 4,120.00 (343.36) 91.67% $4,120.00 56902 · Zoning Admin. Expenses & FICA 837.39 750.00 87.39 111.65% $750.00 56910 · Planning Commission & FICA 2,780.00 4,000.00 (1,220.00) 69.5% $4,000.00 57190 · Other Government Outlay 0.00 500.00 (500.00) 0.0% $103,732.69 ARPA $103,232.69; $500 Misc. 57324 · Highway Equipment Outlay 10,000.00 10,000.00 0.00 100.0% $10,000.00 For Equipment Savings 57331 · LRIP - Highway & Street Outlay 2,167.46 1,000.00 1,167.46 216.75% $1,000.00 58100 · Debt Service-Principal 74,762.51 68,606.53 6,155.98 108.97% $76,574.99 *Dec 2021 Princ. Pymt $2,092.16 58200 · Debt Service-Interest 12,013.11 20,261.25 (8,248.14) 59.29% $12,292.79 58900 · Misc Expense 1,052.00 44,965.49 (43,913.49) 2.34% $46,158.37 Reserve $45,858.37; Misc $300 65600 · Town Share of FICA 8,876.81 10,500.00 (1,623.19) 84.54% $10,500.00 Total Expense 574,689.10 820,519.68 (245,830.58) 70.04% $939,000.00 Net Income 362,162.70 0.00 362,162.70 100.0% Page 2 of 2