| A | B | C | D | BE | BF | BG | BH | BJ | BK | BL | BM | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Actual | Actual | Actual | BUDGET | YTD | Projected | BUDGET | |||||
2 | 9/30/2020 | 9/31/2021 | 9/30/2022 | 9/30/2023 | 7/26/2023 | 9/30/2023 | 9/30/2024 | |||||
3 | Ordinary Income/Expense | |||||||||||
4 | Income | |||||||||||
5 | 01-4001 · Property Tax | $ 29,335.92 | $ 33,161.39 | $ 55,794.74 | $ 57,636.29 | $ 43,285.26 | $ 56,000.00 | $ 45,177.91 | ||||
7 | 01-4003 · Interest on Deliquents - A | $ 995.16 | $ 1,272.36 | $ 1,536.72 | $ 1,350.00 | $ 1,070.51 | $ 1,160.00 | $ 1,350.00 | ||||
8 | 01-4005 · Motor Vehicle Pro Rate - A | $ 703.14 | $ - | 940.24 | $ 400.00 | 984.46 | $ 984.46 | $ 900.00 | ||||
10 | 01-4007 · Homestead Exemption - A | $ 13,197.77 | $ 17,174.92 | $ 17,418.73 | $ 15,750.00 | $ 17,155.17 | $ 17,155.17 | $ - | ||||
14 | 01-4012 · Carline LB 1063 - A | $ 239.44 | $ 289.27 | $ 242.87 | $ 250.00 | $ 181.83 | $ 200.00 | $ 180.00 | ||||
15 | 01-4020 · Franchise Tax - A | $ 10,985.23 | $ 8,792.92 | $ 10,925.39 | $ 10,500.00 | $ 10,882.50 | $ 10,882.50 | $ 10,800.00 | ||||
16 | 01-4021 · Local Licenses & Fees - A | $ 3,776.18 | $ 2,550.00 | $ 2,329.00 | $ 4,000.00 | $ 3,576.38 | $ 3,576.38 | $ 3,300.00 | ||||
17 | 01-4022 - Telecommunications Rev. | $ 14,311.74 | $ 12,070.20 | $ 13,430.47 | $ 11,500.00 | $ 10,889.89 | $ 10,889.89 | $ 11,500.00 | ||||
19 | 01-4063 · Rental on Property - A | $ - | $ - | $ - | $ - | $ 24,103.85 | $ 24,103.85 | $ 10,550.00 | 6 | |||
20 | 01-4070 · Interest on Investments - A | $ 884.14 | $ 511.50 | $ 681.53 | $ 500.00 | $ 13,667.50 | $ 14,273.00 | $ 18,500.00 | 8 | |||
22 | 01-4080 · Miscellaneous - A | $ 2,055.70 | $ 1,364.01 | $ 123,916.11 | $ 8,000.00 | $ 3,728.38 | $ 3,728.38 | $ 19,300.00 | 5 | |||
23 | 01-4081 · Cable TV - A | $ 1,617.00 | $ 1,617.00 | $ - | $ 2,500.00 | $ 1,617.00 | $ 1,617.00 | $ 1,600.00 | ||||
24 | 01-4082 - Zoning Permit - A | $ - | $ - | $ - | $ - | $ 315.00 | $ 325.00 | $ 400.00 | ||||
25 | 01-4083 - Solicitors Permits - A | $ - | $ - | $ - | $ - | $ 600.00 | $ 600.00 | $ 300.00 | ||||
28 | 01-4096 - Municipal Equalization | $ 41,993.83 | $ 39,630.88 | $ 19,923.83 | $ 14,390.00 | $ 11,949.97 | $ 14,390.00 | $ 25,067.09 | ||||
31 | Total Income | $ 137,772.75 | $ 118,434.45 | $ 247,139.63 | $ 126,776.29 | $ 144,007.70 | $ 159,885.63 | $ 148,925.00 | ||||
32 | Expense | |||||||||||
33 | 01-5001 · Salary - A | $ 28,929.75 | $ 16,334.90 | $ 19,188.00 | $ 39,980.00 | $ 29,492.45 | $ 32,472.00 | $ 39,980.00 | 1 | |||
34 | 01-5002 · Unemployment - A | $ 60.67 | $ - | $ - | $ 100.00 | $ - | $ - | $ - | ||||
35 | 01-5003 · Social Security - FICA - A | $ 2,189.49 | $ 2,189.21 | $ 2,297.39 | $ 2,484.00 | $ 2,230.26 | $ 2,484.00 | $ 3,058.00 | ||||
36 | 01-5004 · Health Insurance - A | $ 6,104.19 | $ 3,609.00 | $ 3,289.04 | $ 3,096.00 | $ 3,096.00 | $ 3,096.00 | $ 5,039.00 | ||||
38 | 01-5006 · Simple IRA - A | $ 1,112.34 | $ - | $ 745.16 | $ 839.00 | $ 777.36 | $ 850.00 | $ 1,064.00 | ||||
39 | 01-5007 · Worker's Comp. | $ 1,182.72 | $ 754.26 | $ 630.34 | $ 500.00 | $ 754.42 | $ 754.42 | $ 800.00 | ||||
41 | 01-5010 · Legal Fees - A | $ 5,000.00 | $ 13,330.00 | $ 13,910.50 | $ 19,000.00 | $ 13,373.50 | $ 19,000.00 | $ 24,000.00 | 4 | |||
42 | 01-5011 · Telephone - A | $ 5,520.46 | $ 5,193.92 | $ 5,142.87 | $ 5,675.00 | $ 3,943.76 | $ 5,675.00 | $ 5,800.00 | ||||
43 | 01-5012 · Gas Utilities - A | $ 847.26 | $ 770.65 | $ 919.09 | $ 1,000.00 | $ 1,111.05 | $ 1,212.00 | $ 1,200.00 | ||||
44 | 01-5013 · Electric Utilities - A | $ 4,039.28 | $ 3,985.07 | $ 3,798.01 | $ 4,200.00 | $ 3,211.57 | $ 3,600.00 | $ 4,500.00 | ||||
45 | 01-5014 · Printing & Publishing & Mktg- A | $ 5,160.06 | $ 5,168.75 | $ 5,150.37 | $ 6,250.00 | $ 6,696.05 | $ 7,000.00 | $ 6,250.00 | ||||
46 | 01-5015 · Property Insurance - A | $ 732.58 | $ 821.34 | $ 1,065.92 | $ 900.00 | $ 1,616.44 | $ 2,500.00 | $ 2,500.00 | ||||
47 | 01-5016 · Schools & Training & Travel - A | $ 5,007.41 | $ 2,464.70 | $ 4,114.27 | $ 7,200.00 | $ 5,016.08 | $ 7,200.00 | $ 7,600.00 | ||||
48 | 01-5017 · Audit & Budget - A | $ 1,605.00 | $ 1,650.00 | $ 1,705.00 | $ 1,800.00 | $ 2,155.00 | $ 2,155.00 | $ 1,850.00 | ||||
49 | 01-5018 - Engineering | $ - | $ - | $ - | $ - | $ 162,387.75 | $ 175,000.00 | $ - | ||||
50 | 01-5019 · Dues - A | $ 4,983.12 | $ 6,592.76 | $ 6,490.00 | $ 6,600.00 | $ 7,074.00 | $ 7,074.00 | $ 6,700.00 | ||||
51 | 01-5020 - Internet Membership Tools | $ 1,034.99 | $ 227.95 | $ 2,219.86 | $ 2,500.00 | $ 1,420.00 | $ 1,420.00 | $ 2,200.00 | ||||
52 | 01-5021 · Office Supplies/Mach. Repairs A | $ 7,886.78 | $ 7,089.49 | $ 9,045.63 | $ 6,950.00 | $ 7,260.39 | $ 7,260.39 | $ 7,000.00 | ||||
53 | 01-5024 · Operating Supplies - A | $ 483.78 | $ 1,452.49 | $ 1,424.45 | $ 1,650.00 | $ 1,408.13 | $ 1,650.00 | $ 1,650.00 | ||||
55 | 01-5029 · Miscellaneous Exp. - A | $ 4,500.64 | $ 1,062.32 | $ 4,766.77 | $ 5,750.00 | $ 3,356.23 | $ 4,000.00 | $ 5,475.00 | ||||
57 | 01-5039 - Mowing- A | $ - | $ - | $ - | $ - | $ 1,290.00 | $ 1,350.00 | $ 1,200.00 | ||||
58 | 01-5040 - I.T. Support - Security | $ - | $ - | $ 845.87 | $ 2,000.00 | $ 1,340.15 | $ 1,340.15 | $ 1,000.00 | ||||
59 | 01-5051 · New Equipment - A | $ 509.00 | $ - | $ 2,811.50 | $ - | $ - | $ 2,500.00 | $ 2,450.00 | 2 | |||
60 | 01-5052 - Building R/M | $ 4,656.80 | $ 1,871.59 | $ 840.36 | $ 2,500.00 | $ 1,147.07 | $ 2,000.00 | $ 2,500.00 | ||||
62 | 01-5059 · Real Estate Taxes | $ - | $ - | $ - | $ - | $ - | $ - | $ 2,109.00 | 7 | |||
63 | 01-5060 · Zoning & Comm. Dev. - A | $ 7,193.25 | $ 13,909.61 | $ 1,221,834.62 | $ 13,310.00 | $ 7,990.64 | $ 13,000.00 | $ 13,000.00 | 3 | |||
65 | 01-5093 · Occupation Tax - A | $ - | $ - | $ 1,000.00 | $ - | $ - | $ - | $ - | ||||
66 | Total Expense | $ 98,870.57 | $ 89,507.23 | $ 1,315,812.93 | $ 134,284.00 | $ 268,148.30 | $ 304,592.96 | $ 148,925.00 | ||||
67 | Net Ordinary Income | $ 38,902.18 | $ 28,927.22 | $ (1,068,673.30) | $ (7,507.71) | $ (124,140.60) | $ (144,707.33) | $ - | ||||
69 | Other Income/Expense | |||||||||||
70 | Other Income | |||||||||||
71 | 01-4100 · Transfers In - A | $ 102,262.00 | $ - | $ 175,000.00 | $ - | |||||||
72 | Total Other Income | $ - | $ - | $ - | $ - | $ - | $ - | |||||
73 | Other Expense | |||||||||||
74 | 01-5071 · Transfer Out - to CDBG | $ - | $ - | $ - | $ - | $ - | $ - | |||||
75 | Total Other Expense | $ - | $ - | $ - | $ - | $ - | $ - | |||||
76 | Net Other Income | $ - | $ - | $ - | $ - | $ 175,000.00 | $ - | |||||
77 | Net Income | $ 38,902.18 | $ 28,927.22 | $ (966,411.30) | $ (7,507.71) | $ (124,140.60) | $ 30,292.67 | $ - | ||||
79 | 1. Salaries | |||||||||||
80 | City Admin. | $ 19,740.00 | Reserve: | |||||||||
81 | City Clerk | $ 14,540.00 | Community Development (150th) (2020-21) | $ 12,436.00 | ||||||||
82 | Deputy Clerk | $ 1,200.00 | ||||||||||
83 | Mayor/Council 50% | $ 4,500.00 | 5. MIsc Income | |||||||||
84 | $ 39,980.00 | General Fees: (permits, etc.) | $ 19,300.00 | |||||||||
86 | 2 New Equipment | |||||||||||
87 | Ipads (city council, clerk, CA) - ($350 x 7) | $ 2,450.00 | 6. Rental on Property | |||||||||
88 | Schwab Ground (1/2 of current rental rate) | $ 10,550.00 | ||||||||||
89 | 3) Community Development | |||||||||||
90 | General | $ 13,000.00 | 7. Property Tax - Schwab Ground (40 acres) | $ 2,809.00 | ||||||||
91 | Usage for Rental income - is taxed | |||||||||||
92 | 4 Legal Fees - Contracted Assistance | |||||||||||
93 | Svehla Law | $ 20,000.00 | 8: Interest Earned | $ 18,500.00 | ||||||||
95 | (Vacant Property) | $ 4,000.00 | (aver.4.5% - $410,000 - NPAIT) | |||||||||
96 | ||||||||||||
98 | $ 24,000.00 | |||||||||||
99 |