Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06.b Treasurer's Monthly Report
aug FUND ACCOUNTING Beginning Cash Balance 11/1/2024 3,972,997.79$ Beginning Checking Balance 210,641.03$ Checking Receipts 1,340,866.65$ Transfers to Checking 698,193.85$ Total Deposits 2,039,060.50$ Expenditures (704,224.80)$ 6/30/2024 CASH BALANCES Payroll (45,452.22)$ Transfers to Money Market G 101-10100 GENERAL FUND 2,268,945.00$ Total Payments (749,677.02)$ G 203-10100 COVID-19 RELIEF $466,422.00 G 225-10100 EDA $42,834.55 Ending Checking Balance 1,500,024.51$ G 226-10100 CABLE TV 29,797.08$ G 230-10100 GATEWAY TRAIL -$ Beginning Money Market Balance 762,593.95$ G 240-10100 PUBLIC SAFETY AID 176,529.00$ Money Market Receipts 351.10$ G 313-10100 2013 EQUIP CERT 31,943.24$ Transfer to Checking (600,000.00)$ G 318-10100 2018 EQUIP CERT 77,805.17$ Transfer from Checking G 324-10100 2024 ROAD PROJECTS (339,940.54)$ G 401-10100 CAPITAL IMPROVEMENT 722,599.12$ Ending Money Market Balance 162,945.05$ G 404-10100 PARK DEVELOPMENT (51,026.76)$ G 406-10100 EQUIPMENT REPLACE (149,562.32)$ Beginning Investments Balance 3,029,816.90$ G 408-10100 LRIF 1,258,940.62$ Investments Receipts-Interest 3,326.36$ G 602-10100 BLISS SEWER (1,422.92)$ Transfer from Checking G 612-10100 UPTOWN SEWER 24,409.15$ Transfers to Checking (98,193.85)$ G 624-10100 A-E SEWER 26,899.12$ Ending Investments Balance 2,934,949.41$ G 801-10100 ESCROW 7,799.64$ 4,592,971.15$ Outstanding Checks (4,947.82)$ -$ Ending Cash Balance 11/30/2024 4,592,971.15$ Total of Funds 324 + 408 919,000.08$ CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102 Beg Bal 210,641.03$ Credits 2,039,060.50$ Debits (749,677.02)$ Receipt in Transit -$ End Bal 1,500,024.51$ Money Market *105 - Rate 1.25%Beg Bal 762,593.95$ rate change from .25% Credits 351.10$ Debits (600,000.00)$ End Bal 162,945.05$ Investments CD *4422 - Rate 5.10% 12 mo., 3/25/2025 339,230.35$ CD *4424 - Rate 5.00% 12 mo., 7/27/2025 479,018.30$ CD *4428 - Rate 5.10% 7 mo., 05/01/25 794,944.50$ CD *4427 - Rate 4.50% 9 mo., 07/30/25 579,185.76$ Bond Proceeds 742,570.50$ Total Investments 2,934,949.41$ Total Bank & Investment Accounts 4,597,918.97$ Checks in Transit *3102 (4,947.82)$ Total Funds 4,592,971.15$ -$ Submitted by: Colleen Firkus, Treasurer City of Scandia Treasurer’s Report November 30, 2024 CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$ 1,865,916 $ 1,678,931 $ 675,825 $ 186,985 89.98% Distributed July 1 and Dec. 1 R 101-41000-31040 Fiscal Disparities$ 107,857 $ 103,218 $ 27,200 $ 4,639 95.70% R 101-41000-31701 Gravel Taxes$ 20,000 $ 5,565 $ - $ 14,435 27.83% R 101-41000-31830 Solar Energy Production Tax$ 5,500 $ 5,763 $ 3,763 $ (263) 104.78% R 101-41000-31900 Penalties & Interest Del Tax$ 1,000 $ - $ - $ 1,000 0.00% R 101-41000-32150 ROW Utility Permit$ 5,000 $ 5,100 $ 1,050 $ (100) 102.00% R 101-41000-32180 Tobacco & Liquor Licenses$ 11,000 $ 6,491 $ 2,472 $ 4,509 59.01% R 101-41000-32190 Other City Permits$ 3,000 $ 2,531 $ 362 $ 469 84.37% R 101-41000-32210 Building Permits$ 160,000 $ 205,879 $ 28,590 $ (45,879) 128.67% R 101-41000-32260 Gambling Permits$ 100 $ 145 $ - $ (45) 145.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid$ 7,000 $ 7,203 $ - $ (203) 102.89% R 101-41000-33420 Fire Relief State PERA$ 52,719 $ - $ - $ 52,719 0.00% Fire Training Grants; $5k Street R 101-41000-33422 Other State Grants & Aids$ 6,000 $ 19,324 $ - $ (13,324) 322.06% Sweeping Grant R 101-41000-33428 PILOT$ 6,000 $ 6,585 $ 3,283 $ (585) 109.75% R 101-41000-33620 Recycling Grant$ 11,000 $ 8,164 $ - $ 2,836 74.22% R 101-41000-33630 Local Govt Grants & Aids$ 10,000 $ 10,228 $ - $ (228) 102.28% Washington County Dive Gear Grant R 101-41000-33640 Other Grants$ 1,200 $ 1,900 $ - $ (700) 158.33% R 101-41000-34103 Zoning and Planning$ 5,000 $ 6,263 $ 392 $ (1,263) 125.26% R 101-41000-34107 Assessment Search Fees$ 20 $ - $ - $ 20 0.00% R 101-41000-34109 Water Usage$ 100 $ - $ - $ 100 0.00% R 101-41000-34202 Fire Protection Services$ 33,915 $ 35,816 $ - $ (1,901) 105.61% Town of May Fire Service Contract R 101-41000-34301 Damage Repairs$ - $ 3,070 $ - $ (3,070) 0.00% R 101-41000-34303 Dust Control$ 3,630 $ 2,673 $ - $ 957 73.63% R 101-41000-34304 Reimbursement for Services$ 1,000 $ 2,700 $ - $ (1,700) 270.00% FLCC bookkeeping services $3,600/yr. R 101-41000-34305 Other Street Services$ - $ - $ - $ - 0.00% R 101-41000-34730 Ad Revenue$ 1,000 $ 450 $ - $ 550 45.00% R 101-41000-34750 Facilities Rental$ 7,400 $ 9,511 $ 664 $ (2,111) 128.53% R 101-41000-34760 Cleaning Fees$ - $ - $ - $ - 0.00% R 101-41000-34790 Recreation Programs$ 1,500 $ 1,924 $ 495 $ (424) 128.28% R 101-41000-35101 Fines & Forfeitures$ 7,000 $ 4,676 $ 800 $ 2,324 66.80% R 101-41000-36210 Interest Income$ 5,636 $ 97,797 $ 355 $ (92,161) 1735.22% distributed among funds at EOY R 101-41000-36230 Donations$ 7,195 $ 2,886 $ - $ 4,309 40.11% Vinterfest button donations R 101-41000-36240 Insurance Dividend$ 4,000 $ 2 $ - $ 3,998 0.05% R 101-41000-36250 Misc. Refund$ 2,000 $ 880 $ - $ 1,120 44.01% Total General Fund Revenue$ 2,352,688 $ 2,235,675 $ 745,250 $ 117,012 95.03% Operating TransfersR 101-41000-39200 Interfund Operating Transfer$ - $2,678,366$98,194($2,678,366) R 101-49000-39203 Transfer from Other Funds$ - $6,073,697$600,000($6,073,697) R 101-49000-39204 Money Market Transfer$ - Total Operating Transfers$ 8,752,063$ 698,194 $ (8,752,063) CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND ExpenditureADMINISTRATION & FINANCE E 101-41000-101 Regular Wages & Salaries$ 196,713.00 $ 152,130.42 $ 14,146.02 $ 44,582.58 77.34% E 101-41000-121 PERA Coord. Employer Contribu.$ 13,801.00 $ 12,046.69 $ 1,060.94 $ 1,754.31 87.29% E 101-41000-122 FICA Employer Contribution$ 12,196.00 $ 9,536.88 $ 846.63 $ 2,659.12 78.20% E 101-41000-126 MEDICARE Employer Contribution$ 2,852.00 $ 2,360.14 $ 198.01 $ 491.86 82.75% E 101-41000-131 Employer Paid Health$ 46,482.00 $ 36,963.60 $ 3,147.30 $ 9,518.40 79.52% E 101-41000-132 Dental Insurance$ 1,990.00 $ 1,534.80 $ 127.90 $ 455.20 77.13% E 101-41000-134 Employer Paid Life$ 643.00 $ 597.20 $ 49.60 $ 45.80 92.88% E 101-41000-135 Employer Paid Disability$ 960.00 $ 860.04 $ 71.67 $ 99.96 89.59% E 101-41000-151 Worker s Comp Insurance Prem$ 1,339.00 $ 1,837.00 $ - $ (498.00) 137.19% E 101-41000-200 Office Supplies$ 1,133.00 $ 793.01 $ 266.65 $ 339.99 69.99% E 101-41000-203 Printed Forms & Papers$ 1,957.00 $ 3,567.85 $ - $ (1,610.85) 182.31% E 101-41000-210 Operating Supplies$ 824.00 $ 682.62 $ 101.52 $ 141.38 82.84% E 101-41000-301 Auditing and Acct g Services$ 27,000.00 $ 32,050.00 $ - $ (5,050.00) 118.70% E 101-41000-303 Engineering Fees$ - $ - $ - $ - 0.00% E 101-41000-304 Legal Services$ 65,000.00 $ 32,071.80 $ 3,273.50 $ 32,928.20 49.34% E 101-41000-306 Personal Testing & Recruit$ - $ - $ - $ - 0.00% American Legal Web Fee & Ordinance E 101-41000-308 Other Professional Services$ 5,000.00 $ 1,746.90 $ - $ 3,253.10 34.94% Updates E 101-41000-309 Software Support & Maintenance$ 18,746.00 $ 17,174.82 $ 489.00 $ 1,571.18 91.62% E 101-41000-316 Conferences & Seminars$ 721.00 $ 50.00 $ 30.00 $ 671.00 6.93% E 101-41000-317 Employee Training$ 206.00 $ - $ - $ 206.00 0.00% E 101-41000-319 Other Services$ 700.00 $ 408.00 $ 46.00 $ 292.00 58.29% E 101-41000-321 Telephone$ 5,100.00 $ 5,062.54 $ 477.62 $ 37.46 99.27% E 101-41000-322 Postage$ 2,200.00 $ 2,543.07 $ 300.00 $ (343.07) 115.59% E 101-41000-331 Travel Expenses$ 1,000.00 $ 622.07 $ - $ 377.93 62.21% E 101-41000-351 Legal Notices Publishing$ 1,500.00 $ 1,506.62 $ 62.95 $ (6.62) 100.44% E 101-41000-361 Liability/Property Ins$ 11,516.00 $ 9,166.37 $ - $ 2,349.63 79.60% E 101-41000-365 Insurance Claims$ 1,000.00 $ - $ - $ 1,000.00 0.00% E 101-41000-381 Utilities-Electric & Gas$ 12,000.00 $ 11,130.25 $ 2,298.24 $ 869.75 92.75% E 101-41000-413 Equipment Rental$ 1,800.00 $ 1,601.69 $ 348.32 $ 198.31 88.98% E 101-41000-430 Recycling$ - $ 80.00 $ 30.00 $ (80.00) 0.00% E 101-41000-433 Dues and Subscriptions$ 5,000.00 $ 1,877.00 $ - $ 3,123.00 37.54% E 101-41000-434 Youth Service Bureau$ 5,500.00 $ 5,500.00 $ - $ - 100.00% E 101-41000-435 Misc Expense$ - $ 14.00 $ - $ (14.00) 0.00% Annual website host & maintenance; E 101-41000-438 Misc. Contractual$ 4,120.00 $ 2,197.50 $ - $ 1,922.50 53.34% ABDO help E 101-41000-439 Refunds Issued$ - $ 601.10 $ - $ (601.10) 0.00% E 101-41000-560 Furniture and Fixtures$ - $ 233.19 $ - $ (233.19) 0.00% E 101-41000-570 Office Equipment$ 1,500.00 $ 122.30 $ - $ 1,377.70 8.15% Total Admin & Finance Dept. Expenditures$ 450,499 $ 348,669 $ 27,372 $ 101,830 77.40% CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.CITY COUNCIL ExpendituresE 101-41110-101 Regular Wages & Salaries$ 20,772 $ 15,579 $ - $ 5,193 75.00% E 101-41110-122 FICA Employer Contribution$ 1,288 $ 246 $ - $ 1,042 19.11% E 101-41110-126 MEDICARE Employer Contribution$ 301 $ 174 $ - $ 127 57.76% E 101-41110-127 PERA Defined$ 703 $ 580 $ - $ 123 82.56% E 101-41110-151 Worker s Comp Insurance Prem$ 100 $ 52 $ - $ 48 52.00% E 101-41110-308 Other Professional Services$ - $ - $ - $ - 0.00% E 101-41110-316 Conferences & Seminars$ 350 $ 30 $ - $ 320 8.57% E 101-41110-331 Travel Expenses$ - $ - $ - $ - 0.00% E 101-41110-560 Furniture and Fixtures$ - $ - $ - $ - 0.00% E 101-41110-570 Office Equipment$ - $ - $ - $ - 0.00% Total City Council Dept. Expenditures$ 23,514 $ 16,661 $ - $ 6,853 70.86% ELECTIONS ExpendituresE 101-41410-199 Election Judge$ 5,400.00 $ 6,533.02 $ 2,654.42 $ (1,133.02) 120.98% E 101-41410-200 Office Supplies$ 50.00 $ 54.04 $ 8.94 $ (4.04) 108.08% E 101-41410-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-41410-210 Operating Supplies$ 750.00 $ 1,179.94 $ 587.97 $ (429.94) 157.33% E 101-41410-351 Legal Notices Publishing$ 200.00 $ 102.14 $ 46.32 $ 97.86 51.07% E 101-41410-413 Equipment Rental$ 1,700.00 $ 1,672.00 $ - $ 28.00 98.35% Wash. Cty. Equip. Maintenance Fee Total Elections Dept. Expenditures$ 8,100 $ 9,541 $ 3,298 $ (1,441) 117.79% PLANNING & BUILDING ExpendituresE 101-41910-101 Regular Wages & Salaries$ 60,010.00 $ 52,340.60 $ 4,488.76 $ 7,669.40 87.22% E 101-41910-121 PERA Coord. Employer Contribu.$ 4,263.00 $ 3,923.49 $ 336.66 $ 339.51 92.04% E 101-41910-122 FICA Employer Contribution$ 3,721.00 $ 3,083.60 $ 265.26 $ 637.40 82.87% E 101-41910-126 MEDICARE Employer Contribution$ 870.00 $ 745.54 $ 62.04 $ 124.46 85.69% E 101-41910-131 Employer Paid Health$ 17,353.00 $ 15,806.22 $ 1,345.31 $ 1,546.78 91.09% E 101-41910-132 Dental Insurance$ 724.00 $ 657.84 $ 54.82 $ 66.16 90.86% E 101-41910-134 Employer Paid Life$ 173.00 $ 172.80 $ 14.40 $ 0.20 99.88% E 101-41910-135 Employer Paid Disability$ 416.00 $ 415.56 $ 34.63 $ 0.44 99.89% E 101-41910-203 Printed Forms & Papers$ 100.00 $ - $ - $ 100.00 0.00% E 101-41910-311 Contract Permit Inspections$ 60,000.00 $ 70,083.87 $ 10,560.47 $ (10,083.87) 116.81% E 101-41910-312 Planning Services$ 60,000.00 $ 44,026.50 $ 2,264.00 $ 15,973.50 73.38% E 101-41910-313 Committee & Commission Reimbur$ 5,200.00 $ 4,150.00 $ 250.00 $ 1,050.00 79.81% E 101-41910-316 Conferences & Seminars$ - $ 30.00 $ - $ (30.00) 0.00% E 101-41910-319 Other Services$ - $ - $ - $ - 0.00% E 101-41910-361 Liability/Property Ins$ 5,563.00 $ 4,937.40 $ - $ 625.60 88.75% E 101-41910-438 Misc. Contractual$ 5,000.00 $ 3,624.43 $ - $ 1,375.57 72.49% E 101-41910-439 Refunds Issued$ - $ 169.00 $ 169.00 $ (169.00) 0.00% E 101-41910-720 Operating Transfers$ - Total Planning & Building Dept. Expenditures$ 223,393 $ 204,167 $ 19,845 $ 19,226 91.39% ASSESSOR ExpendituresE 101-41960-300 Assessor$ 23,200 $ 21,260 $ 2,000 $ 1,940 91.64% POLICE ExpendituresE 101-42100-318 Police Contract$ 183,442 $ 91,721 $ - $ 91,721 50.00% $309 Code Red System; E 101-42100-319 Other Services$ 960 $ 1,189 $ - $ (229) 123.89% $880 Taco Daze Total GF Police Dept. Expenditures$ 184,402 $ 92,910 $ - $ 91,492 50.38% CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.FIRE ExpendituresE 101-42200-101 Regular Wages & Salaries$ 160,554.00 $ 172,324.33 $ 19,737.48 $ (11,770.33) 107.33% E 101-42200-121 PERA Coord. Employer Contribu.$ - $ - $ - $ - 0.00% E 101-42200-122 FICA Employer Contribution$ 9,954.00 $ 10,478.04 $ 1,160.76 $ (524.04) 105.26% E 101-42200-124 Police & Fire PERA$ 8,983.00 $ 8,971.23 $ 786.06 $ 11.77 99.87% E 101-42200-126 MEDICARE Employer Contribution$ 2,328.00 $ 2,146.26 $ 289.12 $ 181.74 92.19% E 101-42200-134 Employer Paid Life$ 192.00 $ 192.00 $ 16.00 $ - 100.00% E 101-42200-135 Employer Paid Disability$ - $ - $ - $ - 0.00% E 101-42200-141 Unemployment Compensation$ - $ - $ - $ - 0.00% E 101-42200-151 Worker s Comp Insurance Prem$ 12,000.00 $ 6,249.00 $ - $ 5,751.00 52.08% E 101-42200-200 Office Supplies$ 200.00 $ 149.99 $ - $ 50.01 75.00% E 101-42200-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-42200-209 Medical Supplies$ 3,500.00 $ 784.51 $ 121.53 $ 2,715.49 22.41% E 101-42200-210 Operating Supplies$ 8,800.00 $ 6,417.12 $ 278.36 $ 2,382.88 72.92% E 101-42200-211 Cleaning Supplies$ 100.00 $ - $ - $ 100.00 0.00% E 101-42200-212 Fuel$ 4,000.00 $ 4,389.62 $ 319.70 $ (389.62) 109.74% E 101-42200-217 Uniforms & Safety Equipment$ 10,000.00 $ 18,108.28 $ - $ (8,108.28) 181.08% new employee uniforms E 101-42200-221 Equipment Parts$ 1,500.00 $ - $ - $ 1,500.00 0.00% E 101-42200-222 Tires$ - $ - $ - $ - 0.00% E 101-42200-223 Structure Repair & Supplies$ 800.00 $ 48.84 $ 42.40 $ 751.16 6.11% E 101-42200-240 Small Tools and Minor Equip$ 22,195.00 $ 16,654.62 $ 236.16 $ 5,540.38 75.04% SCBA medical exams & flow tests E 101-42200-305 Medical Services$ 5,600.00 $ 5,630.00 $ - $ (30.00) 100.54% E 101-42200-306 Personal Testing & Recruit$ 500.00 $ - $ - $ 500.00 0.00% E 101-42200-309 Software Support & Maintenance$ 17,000.00 $ 15,025.70 $ 528.00 $ 1,974.30 88.39% E 101-42200-310 Medical Training$ 2,000.00 $ 50.00 $ - $ 1,950.00 2.50% E 101-42200-316 Conferences & Seminars$ 250.00 $ - $ - $ 250.00 0.00% E 101-42200-317 Employee Training$ 12,000.00 $ 2,504.85 $ - $ 9,495.15 20.87% E 101-42200-319 Other Services$ 500.00 $ 105.00 $ - $ 395.00 21.00% E 101-42200-321 Telephone$ 7,000.00 $ 5,570.10 $ 535.49 $ 1,429.90 79.57% E 101-42200-322 Postage$ - $ 18.40 $ - $ (18.40) 0.00% E 101-42200-324 State of MN-Fire Relief$ 52,718.58 $ - $ - $ 52,718.58 0.00% E 101-42200-325 City Match-Fire Relief$ - $ - $ - $ - 0.00% E 101-42200-331 Travel Expenses$ 2,000.00 $ 1,818.13 $ - $ 181.87 90.91% Fire School travel costs MN Board of Firefighter Training & E 101-42200-334 Licenses & Permits$ 500.00 $ 367.50 $ - $ 132.50 73.50% Education License E 101-42200-340 Advertising$ - $ - $ - $ - 0.00% E 101-42200-361 Liability/Property Ins$ 7,339.00 $ 7,207.65 $ - $ 131.35 98.21% E 101-42200-381 Utilities-Electric & Gas$ 8,000.00 $ 2,519.08 $ 96.44 $ 5,480.92 31.49% E 101-42200-384 Refuse/Garbage Disposal$ - $ 72.00 $ - $ (72.00) 0.00% E 101-42200-385 Sewer Pumping & Maintenance$ 550.00 $ 526.00 $ - $ 24.00 95.64% E 101-42200-401 Building Maintenance/Repairs$ 3,500.00 $ 2,198.20 $ 266.17 $ 1,301.80 62.81% E 101-42200-403 Improvements Other Than Bldgs$ - $ - $ - $ - 0.00% E 101-42200-404 Repair Machinery/Equipment$ 8,500.00 $ 12,901.52 $ 884.00 $ (4,401.52) 151.78% E 101-42200-407 Well Repair & Maintenance$ - $ - $ - $ - 0.00% E 101-42200-433 Dues and Subscriptions$ 3,200.00 $ 3,245.39 $ - $ (45.39) 101.42% E 101-42200-438 Misc. Contractual$ 3,500.00 $ 1,440.00 $ - $ 2,060.00 41.14% E 101-42200-440 Events$ 1,000.00 $ 509.15 $ 124.82 $ 490.85 50.92% E 101-42200-520 Capital Improvements to Bldgs$ - $ - $ - $ - 0.00% E 101-42200-530 Capital Impr Other Than Bldgs$ - $ - $ - $ - 0.00% E 101-42200-540 Heavy Machinery Capital$ - $ - $ - $ - 0.00% E 101-42200-560 Furniture and Fixtures$ 500.00 $ 50.91 $ - $ 449.09 10.18% E 101-42200-570 Office Equipment$ 900.00 $ 1,078.27 $ - $ (178.27) 119.81% Total Fire Dept Expenditures$ 382,164 $ 309,752 $ 25,422 $ 72,412 81.05% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$ 6,000 $ 6,069 $ 417 $ (69) 101.16% CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PUBLIC WORKS ExpendituresE 101-43000-101 Regular Wages & Salaries$ 255,022 $ 237,900 $ 19,416 $ 17,122 93.29% E 101-43000-102 OT Regular Wages$ 5,014 $ 3,092 $ 208 $ 1,922 61.66% E 101-43000-104 Temporary Employee Wages$ 2,262 $ 338 $ - $ 1,924 14.93% E 101-43000-121 PERA Coord. Employer Contribu.$ 19,503 $ 17,414 $ 1,472 $ 2,089 89.29% E 101-43000-122 FICA Employer Contribution$ 16,262 $ 13,622 $ 1,155 $ 2,640 83.76% E 101-43000-126 MEDICARE Employer Contribution$ 3,803 $ 3,337 $ 270 $ 466 87.75% E 101-43000-131 Employer Paid Health$ 66,939 $ 59,043 $ 4,949 $ 7,896 88.20% E 101-43000-132 Dental Insurance$ 1,164 $ 1,061 $ 88 $ 103 91.16% E 101-43000-133 Union Training Center$ 1,872 $ 1,512 $ 144 $ 360 80.77% E 101-43000-134 Employer Paid Life$ 698 $ 717 $ 62 $ (19) 102.67% E 101-43000-135 Employer Paid Disability$ 1,365 $ 1,408 $ 120 $ (43) 103.17% E 101-43000-141 Unemployment Compensation$ - $ - $ - $ - 0.00% E 101-43000-151 Worker s Comp Insurance Prem$ 27,000 $ 22,615 $ - $ 4,385 83.76% E 101-43000-200 Office Supplies$ 50 $ 58 $ 58 $ (8) 116.66% E 101-43000-210 Operating Supplies$ 8,500 $ 3,952 $ (928) $ 4,548 46.50% E 101-43000-212 Fuel$ 25,000 $ 23,133 $ 2,651 $ 1,867 92.53% E 101-43000-217 Uniforms & Safety Equipment$ 2,300 $ 1,218 $ - $ 1,082 52.95% E 101-43000-221 Equipment Parts$ 17,000 $ 12,527 $ 3,548 $ 4,473 73.69% E 101-43000-222 Tires$ 7,500 $ 4,754 $ - $ 2,746 63.39% E 101-43000-223 Structure Repair & Supplies$ 2,000 $ - $ - $ 2,000 0.00% E 101-43000-224 Materials for Road Maintenance$ 7,000 $ 16,849 $ 54 $ (9,849) 240.70% Cold Patch; New Streetlight Flags E 101-43000-226 Sign Replacement and Repair$ 750 $ 494 $ - $ 256 65.93% E 101-43000-228 Gravel$ 10,000 $ 330 $ - $ 9,670 3.30% E 101-43000-229 Salt$ 22,000 $ 12,375 $ - $ 9,625 56.25% E 101-43000-240 Small Tools and Minor Equip$ 8,000 $ 8,121 $ - $ (121) 101.51% E 101-43000-302 Surveying$ - $ - $ - $ - 0.00% E 101-43000-303 Engineering Fees$ 10,500 $ 8,980 $ 632 $ 1,521 85.52% E 101-43000-304 Legal Services$ - $ - $ - $ - 0.00% E 101-43000-305 Medical Services$ 1,000 $ 65 $ 12 $ 935 6.52% E 101-43000-309 Software Support & Maintenance$ 6,000 $ 331 $ - $ 5,669 5.51% E 101-43000-317 Employee Training$ 1,500 $ 579 $ - $ 921 38.63% E 101-43000-319 Other Services$ 7,000 $ 4,215 $ 23 $ 2,785 60.21% E 101-43000-321 Telephone$ 4,000 $ 3,896 $ 358 $ 104 97.41% Travel to Arborist workshop & Water E 101-43000-331 Travel Expenses$ 500 $ 291 $ - $ 209 58.14% School E 101-43000-334 Licenses & Permits$ 500 $ 10 $ - $ 490 2.00% E 101-43000-361 Liability/Property Ins$ 8,766 $ 9,713 $ - $ (947) 110.80% E 101-43000-365 Insurance Claims$ - $ - $ - $ - 0.00% E 101-43000-381 Utilities-Electric & Gas$ 6,000 $ 1,918 $ 95 $ 4,082 31.96% E 101-43000-384 Refuse/Garbage Disposal$ - $ 120 $ - $ (120) 0.00% holding tank & floor drainoil separator E 101-43000-385 Sewer Pumping & Maintenance$ 1,500 $ 2,285 $ - $ (785) 152.35% tank pumping E 101-43000-387 Street Light Utilities$ 4,200 $ 3,945 $ 1,076 $ 255 93.92% E 101-43000-401 Building Maintenance/Repairs$ 6,000 $ 3,539 $ 249 $ 2,461 58.98% E 101-43000-403 Improvements Other Than Bldgs$ - $ - $ - $ - 0.00% E 101-43000-404 Repair Machinery/Equipment$ 25,000 $ 9,763 $ - $ 15,237 39.05% E 101-43000-405 Contractual Road Maint/Repair$ 200,000 $ 131,264 $ 9,100 $ 68,736 65.63% E 101-43000-407 Well Repair & Maintenance$ 500 $ - $ - $ 500 0.00% E 101-43000-413 Equipment Rental$ 4,000 $ 169 $ - $ 3,831 4.23% E 101-43000-417 Uniform Rental$ 1,200 $ 883 $ 80 $ 317 73.54% E 101-43000-433 Dues and Subscriptions$ 200 $ - $ - $ 200 0.00% E 101-43000-438 Misc. Contractual$ 16,000 $ 9,059 $ - $ 6,941 56.62% E 101-43000-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-43000-530 Capital Impr Other Than Bldgs$ 9,900 $ - $ - $ 9,900 0.00% E 101-43000-550 Motor Vehicles Capital$ - $ - $ - $ - 0.00% E 101-43000-560 Furniture and Fixtures$ 1,000 $ - $ - $ 1,000 0.00% E 101-43000-570 Office Equipment$ - $ 487 $ - $ (487) 0.00% E 101-43000-720 Operating Transfers$ - Total Public Works Dept. Expenditures$ 826,270 $ 637,380 $ 44,892 $ 188,890 77.14% CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$ 11,328 $ 9,713 $ 846 $ 1,615 85.74% E 101-45000-104 Temporary Employee Wages$ 39,985 $ 18,994 $ 560 $ 20,991 47.50% E 101-45000-121 PERA Coord. Employer Contribu.$ 850 $ 728 $ 63 $ 122 85.62% E 101-45000-122 FICA Employer Contribution$ 3,181 $ 1,746 $ 84 $ 1,435 54.88% E 101-45000-126 MEDICARE Employer Contribution$ 744 $ 415 $ 20 $ 329 55.75% E 101-45000-131 Employer Paid Health$ 2,562 $ 2,122 $ 189 $ 440 82.84% E 101-45000-132 Dental Insurance$ 42 $ 35 $ 3 $ 7 83.81% E 101-45000-134 Employer Paid Life$ 27 $ 27 $ 2 $ 0 99.56% E 101-45000-135 Employer Paid Disability$ 76 $ 55 $ 5 $ 21 72.16% E 101-45000-141 Unemployment Compensation$ - $ 16 $ - $ (16) 0.00% E 101-45000-151 Worker s Comp Insurance Prem$ 2,700 $ 2,251 $ - $ 449 83.37% E 101-45000-200 Office Supplies$ 100 $ - $ - $ 100 0.00% E 101-45000-203 Printed Forms & Papers$ 200 $ - $ - $ 200 0.00% E 101-45000-210 Operating Supplies$ 1,000 $ 822 $ 20 $ 178 82.18% E 101-45000-212 Fuel$ 1,000 $ 138 $ - $ 862 13.80% E 101-45000-221 Equipment Parts$ 2,500 $ 1,148 $ 472 $ 1,352 45.92% E 101-45000-223 Structure Repair & Supplies$ 2,500 $ 138 $ - $ 2,362 5.52% E 101-45000-240 Small Tools and Minor Equip$ 500 $ 148 $ 148 $ 352 29.64% E 101-45000-312 Planning Services$ - $ - $ - $ - 0.00% E 101-45000-313 Committee & Commission Reimbur$ - $ 720 $ - $ (720) 0.00% E 101-45000-319 Other Services$ 1,750 $ 1,464 $ - $ 286 83.68% E 101-45000-322 Postage$ - $ - $ - $ - 0.00% E 101-45000-340 Advertising$ - $ 275 $ - $ (275) 0.00% E 101-45000-353 Sales& Use Tax$ - $ - $ - $ - 0.00% E 101-45000-361 Liability/Property Ins$ 3,489 $ 5,333 $ - $ (1,844) 152.86% E 101-45000-381 Utilities-Electric & Gas$ 6,500 $ 2,936 $ 16 $ 3,564 45.16% E 101-45000-384 Refuse/Garbage Disposal$ 5,000 $ 3,904 $ 124 $ 1,096 78.09% E 101-45000-385 Sewer Pumping & Maintenance$ 1,250 $ 1,260 $ 405 $ (10) 100.78% Lighted ballfield fence repair - insurance E 101-45000-401 Building Maintenance/Repairs$ 6,000 $ 4,708 $ 227 $ 1,292 78.46% reimbursed E 101-45000-403 Improvements Other Than Bldgs$ 2,500 $ 716 $ - $ 1,784 28.63% E 101-45000-404 Repair Machinery/Equipment$ 1,000 $ 507 $ - $ 493 50.67% E 101-45000-406 Grounds Care$ 4,000 $ 2,535 $ 1,270 $ 1,465 63.37% E 101-45000-438 Misc. Contractual$ 8,000 $ 8,458 $ 1,250 $ (458) 105.72% E 101-45000-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-45000-440 Events$ 7,000 $ 3,092 $ 200 $ 3,908 44.17% E 101-45000-490 Financial Assistance$ - $ - $ - $ - 0.00% E 101-45000-530 Capital Impr Other Than Bldgs$ 9,900 $ 4,214 $ - $ 5,686 42.57% E 101-45000-720 Operating Transfers$ - Total Parks & Rec Dept. Expenditures$ 125,684 $ 78,617 $ 5,905 $ 47,067 62.55% CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$ 16,600 $ 14,637 $ 1,364 $ 1,963 88.17% E 101-45180-104 Temporary Employee Wages$ - $ - $ - $ - 0.00% E 101-45180-121 PERA Coord. Employer Contribu.$ 1,245 $ 1,070 $ 93 $ 175 85.95% E 101-45180-122 FICA Employer Contribution$ 1,029 $ 856 $ 81 $ 173 83.20% E 101-45180-126 MEDICARE Employer Contribution$ 241 $ 210 $ 19 $ 31 87.07% E 101-45180-131 Employer Paid Health$ 3,692 $ 2,911 $ 266 $ 781 78.84% E 101-45180-134 Employer Paid Life$ 43 $ 43 $ 4 $ (0) 100.47% E 101-45180-135 Employer Paid Disability$ 95 $ 104 $ 9 $ (9) 109.58% E 101-45180-151 Worker s Comp Insurance Prem$ - $ 152 $ - $ (152) 0.00% E 101-45180-210 Operating Supplies$ 2,900 $ 3,594 $ 2,230 $ (694) 123.94% E 101-45180-223 Structure Repair & Supplies$ 4,000 $ 335 $ 98 $ 3,665 8.37% E 101-45180-321 Telephone$ - $ 532 $ - $ (532) 0.00%Annex internet paid by Lions E 101-45180-334 Licenses & Permits$ 1,000 $ 955 $ - $ 45 95.50% E 101-45180-361 Liability/Property Ins$ 835 $ 801 $ - $ 34 95.89% E 101-45180-381 Utilities-Electric & Gas$ 9,135 $ 4,944 $ - $ 4,191 54.12% E 101-45180-384 Refuse/Garbage Disposal$ - $ 156 $ - $ (156) 0.00% E 101-45180-385 Sewer Pumping & Maintenance$ 4,000 $ 3,233 $ - $ 767 80.84% E 101-45180-401 Building Maintenance/Repairs$ 15,000 $ 14,811 $ 839 $ 189 98.74% E 101-45180-404 Repair Machinery/Equipment$ 5,000 $ 355 $ 230 $ 4,645 7.09% E 101-45180-406 Grounds Care$ 1,300 $ 117 $ - $ 1,183 9.00% E 101-45180-407 Well Repair & Maintenance$ 1,000 $ - $ - $ 1,000 0.00% Seasonal lighting E 101-45180-438 Misc. Contractual$ 3,500 $ 1,500 $ - $ 2,000 42.86% E 101-45180-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-45180-520 Capital Improvements to Bldgs$ 9,900 $ - $ - $ 9,900 0.00% E 101-45180-530 Capital Impr Other Than Bldgs$ - $ - $ - $ - $ - E 101-45180-570 Office Equipment$ - $ - $ - $ - $ - E 101-45180-720 Operating Transfers$ - $ - $ - $ - $ - Total Community Center Dept. Expenditures$ 80,515 $ 51,315 $ 5,232 $ 29,200 63.73% TOTAL GENERAL FUND EXPENDITURES$ 2,333,741 $ 1,776,343 $ 134,384 $ 557,398 63.73% E 101-49000-421 Cash Over/Short Operating TransfersE 101-49000-720 Operating Transfers$ 8,361,031 $ 600,000 $ (8,361,031) 0.00% TOTAL GENERAL FUND EXPENDITURES W/TRANSFERS$ 2,333,741 $ 10,137,373 $ 734,384 $ (7,803,633) CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments COVID RELIEF FUND RevenueR 203-46200-33150 Federal Grant$ - $ - $ - $ - 0.00% ExpendituresE 203-49000-720 Operating Transfers$ - $ - $ - $ - EDA FUND RevenueR 225-46500-31000 Washington Cty. Tax Settlement$ 5,300 $ 5,300 $ 2,650 $ - 0.00% R 225-46500-33640 Other Grants$ - $ - $ - $ - 0.00% R 225-46500-34750 Facilities Rental$ - $ 750 $ 200 $ (750) 0.00% R 225-46500-36210 Interest Income$ 100 $ - $ - $ 100 0.00% R 225-46500-36230 Donations$ - $ 310 $ - $ (310) 0.00% R 225-46500-39200 Interfund Operating Transfer$ - $ 33,356 $ - $ (33,356) 0.00% closed checking account Total EDA Fund Revenue$ 5,400$ 39,716$ 2,850$ (34,316)735.48% ExpenditureE 225-46500-210 Operating Supplies$ 300 $ 23 $ - $ 277 7.74% E 225-46500-303 Engineering Fees$ - $ - $ - $ - 0.00% E 225-46500-304 Legal Services$ - $ - $ - $ - 0.00% E 225-46500-308 Other Professional Services$ 100 $ - $ - $ 100 0.00% EDAM Membership; Sister City Dues E 225-46500-340 Advertising$ 1,500 $ - $ - $ 1,500 0.00% E 225-46500-433 Dues and Subscriptions$ 1,203 $ 364 $ - $ 839 30.26% E 225-46500-440 Events$ 1,500 $ 846 $ 536 $ 654 56.38% E 225-46500-720 Operating Transfers$ - $ 33,356 $ - $ (33,356) 0.00% closed checking account Total EDA Fund Expenditures$ 4,603$ 34,566$ 536$ (29,986)750.94% CABLE TV FUND RevenueR 226-41950-36210 Interest Income$ 100.00 $ - $ - $ 100.00 0.00% R 226-41950-36260 Sale of Equipment$ - $ - $ - $ - 0.00% R 226-41950-38050 Cable TV Franchise Rebates$ 16,700.00 $ 15,317.25 $ - $ 1,382.75 91.72% R 226-41950-38051 PEG Fees$ 4,400.00 $ 5,498.40 $ 2,075.25 $ (1,098.40) 124.96% Total Cable TV Fund Revenue$ 21,200$ 20,816$ 2,075$ 38498.19% ExpenditureE 226-41950-240 Small Tools and Minor Equip$ 300 $ - $ - $ 300 0.00% E 226-41950-309 Software Support & Maintenance$ 3,500 $ 3,279 $ 400 $ 221 93.69% E 226-41950-438 Misc. Contractual$ 7,750 $ 9,118 $ - $ (1,368) 117.65% E 226-41950-570 Office Equipment$ - $ - $ - $ - 0.00% Total Cable TV Fund Expenditures$ 11,550$ 12,397$ 400$ (847) 107.33% CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GATEWAY TRAIL FUND RevenueR 230-45000-36230 Donations$ - $ - $ - $ - 0.00% ExpenditureE 230-45000-308 Other Professional Services$ - $ - $ - $ - 0.00% 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$ 345,634 $ 345,634 $ 172,817 $ - 100.00% ExpenditureE 318-47000-601 Long Term Debt Principal$ 245,000 $ 245,000 $ 245,000 $ - 100.00% E 318-47000-611 Long Term Debt Interest$ 84,175 $ 84,175 $ 42,088 $ (0) 100.00% E 318-47000-620 Fiscal Agent s Fees$ 495 $ 1,045 $ - $ (550) 211.11% Total 2018 Street Reconstruction Fund Expenditures$ 329,670 $ 330,220 $ 287,088 $ (550) 100.17% 2024 STREET RECONSTRUCTION RevenueR 324-47000-31000 Washington Cty. Tax Settlement$ - $ - $ - $ - 0.00% R 324-47000-36210 Interest Income$ - $ 51,092 $ 3,326 $ (51,092) 0.00% Total 2024 Street Reconstruction Fund Revenue$ -$ 51,092$ 3,326$ (51,092)0.00% ExpenditureE 324-47000-601 Long Term Debt Principal$ - $ - 0.00% E 324-47000-611 Long Term Debt Interest$ - 0.00% E 324-47000-620 Fiscal Agent s Fees$ 495 $ - $ 495 0.00% Total 2024 Street Reconstruction Fund Expenditures$ 495 $ -$ -$ 4950.00% CAPITAL IMPROVEMENTS RevenueR 401-48000-31000 Washington Cty. Tax Settlement$ 235,000 $ 235,000 $ 117,500 $ - 100.00% R 401-48000-33422 Other State Grants & Aids$ - $ 34,110 $ - $ (34,110) 0.00% Cty Gateway Tr.Grant; CMSWD R 401-48000-33640 Other Grants$ - $ 21,750 $ - $ (21,750) 0.00% Stormwater Quality Grant R 401-48000-36210 Interest Income$ 3,000 $ - $ - $ 3,000 0.00% Total Capital Improvement Fund Revenue$ 238,000 $ 290,860 $ 117,500 $ (52,860)122.21% ExpenditureE 401-41000-312 Planning Services$ - $ - $ - $ - 0.00% E 401-41000-520 Capital Improvements to Bldgs$ - $ - $ - $ - 0.00% E 401-41000-530 Capital Impr Other Than Bldgs$ 250,000 $ - $ - $ 250,000 0.00% E 401-42200-520 Capital Improvements to Bldgs$ - $ 17,000 $ 17,000 $ (17,000) 0.00%Cold Storage Building E 401-43000-520 Capital Improvements to Bldgs$ - $ 51,000 $ 51,000 $ (51,000) 0.00%Cold Storage Building E 401-45180-520 Capital Improvements to Bldgs$ 67,548 $ - $ - $ 67,548 0.00% E 401-48000-303 Engineering Fees$ - $ 76,307 $ 19,016 $ (76,307) 0.00%Gateway Trail Engineering E 401-48000-308 Other Professional Services$ - $ 4,800 $ - $ 4,800 0.00%Gateway Trail Lobbying E 401-48000-435 Misc Expense$ - $ - $ - $ - 0.00% E 401-48000-438 Misc. Contractual$ - $ - $ - $ - 0.00% E 401-48000-520 Capital Improvements to Bldgs$ - $ - $ - $ - 0.00% E 401-48000-530 Capital Impr Other Than Bldgs$ 160,000 $ - $ - $ 160,000 0.00% Tranfer to Park Cap Fund Courts E 401-48000-720 Operating Transfers$ - $ 150,000 $ - $ (150,000) 0.00% $ 477,548 $ 299,107 $ 87,016 $ 188,041 62.63% CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$ 60,000 $ 60,000 $ 30,000 $ - 100.00% R 404-48000-33422 Other State Grants & Aids$ - $ 101,250 $ - $ (101,250) 0.00% 2023 Playground grant R 404-48000-34780 Park Dedication Fees$ - $ - $ - $ - 0.00% R 404-48000-36210 Interest Income$ 66 $ - $ - $ 66 0.00% R 404-48000-36230 Donations$ - $ - $ - $ - 0.00% R 404-48000-39203 Transfer from Other Funds$ - $ 150,000 $ - $ (150,000) 0.00% Total Park Development Fund Revenue$ 60,066$ 311,250 $ 30,000 $ (251,184)518.18% ExpenditureE 404-48000-312 Planning Services$ - $ - $ - $ - 0.00% E 404-48000-303 Engineering Fees$ - $ 59,488 $ 5,018 $ (59,488) 0.00%Courts E 404-48000-308 Other Professional Services$ - $ 410 $ - $ (410) 0.00% E 404-48000-520 Capital Improvements to Bldgs$ - $ - $ - $ - 0.00% E 404-48000-530 Capital Impr Other Than Bldgs$ 150,000 $ 292,997 $ 87,314 $ (142,997) 195.33%Courts E 404-48000-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Park Development Fund Expenditures$ 150,000 $ 352,895 $ 92,332 $ (202,895)235.26% EQUIPMENT REPLACEMENT RevenueR 406-48500-31000 Washington Cty. Tax Settlement$ 110,000 $ 110,000 $ 55,000 $ - 0.00% R 406-48500-36210 Interest Income$ 1,045 $ - $ - $ 1,045 0.00% R 406-48500-36260 Sale of Equipment$ - $ 28,550 $ - $ (28,550) #DIV/0! R 406-48500-39350 Certificate of Indebtedness$ 350,000 $ - $ - $ 350,000 0.00% Total Equipment Replacement Fund Revenue$ 461,045 $ 138,550 $ 55,000 $ 322,49530.05% FD Pumper & Rescue Boat; Drum ExpenditureE 406-48500-540 Heavy Machinery Capital$ 867,000 $ 264,304 $ - $ 602,696 30.48% Mulcher & Skit Steer E 406-48500-550 Motor Vehicles Capital$ 84,356 $ 161,429 $ - $ (77,073) 191.37% FD Utility Truck; PW F-550 Truck Total Equipment Replacement Fund Expenditures$ 951,356 $ 425,733 $ -$ 525,62344.75% LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$ 375,000 $ 375,000 $ 187,500 $ - 0.00% R 408-43100-33422 Other State Grants & Aids$ - $ - $ - $ - #DIV/0! Deferred SA Paid Off R 408-43100-36100 Special Assessments$ - $ 7,560 $ 7,560 $ (7,560) 0.00% R 408-43100-36210 Interest Income$ 10,705 $ - $ - $ 10,705 0.00% R 408-43100-39310 Proceeds-Gen Obligation Bond$4,000,000.00$3,868,541.90$0.00$131,458.1096.71% Total LRIF Revenue$ 4,385,705$ 4,251,102$ 195,060 $ 134,60396.93% ExpenditureE 408-43100-303 Engineering Fees$ 120,000 $ 340,060 $ 21,722 $ (220,060) 0.00% E 408-43100-319 Other Services$ - $ 375 $ - $ (375) 0.00% E 408-43100-351 Legal Notices Publishing$ - $ 59 $ - $ (59) 0.00% E 408-43100-530 Capital Impr Other Than Bldgs$ 3,575,000 $ 2,814,847 $ 54,750 $ 760,153 78.74% Total LRIF Expenditures$ 3,695,000 $ 3,155,341 $ 76,472 $ 539,659 85.39% CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments BLISS SEWER RevenueR 602-43210-31951 Special Assessments Principal$0.00$2,982.55$330.98($2,982.55)0.00% R 602-43210-31952 SA Penalties & Interest$420.00$477.36$159.18($57.36)113.66% R 602-43210-33422 Other State Grants & Aids$ - $ - $ - $ - 0.00% R 602-43210-34401 Sewer User Fees$125,230.00$87,447.83$3,911.18$37,782.1769.83% R 602-43210-34402 Sewer Connection Fee$ - $ - $ - $ - 0.00% R 602-43210-36100 Special Assessments$ - $46.83$0.00($46.83)0.00% R 602-43210-36102 Penalties and Interest$ - $332.27$109.98($332.27)0.00% R 602-43210-36210 Interest Income$ 210 $ - $ - $ 210 0.00% Total BLISS Sewer Revenue$ 125,860 $ 91,287 $ 4,511 $ 34,573 72.53% ExpenditureE 602-43210-101 Regular Wages & Salaries$ 17,458 $ 13,120 $ 1,644 $ 4,338 75.15% E 602-43210-120 Pension Expense$ - $ - $ - $ - 0.00% E 602-43210-121 PERA Coord. Employer Contribu.$ 1,309 $ 983 $ 123 $ 326 75.07% E 602-43210-122 FICA Employer Contribution$ 1,082 $ 768 $ 97 $ 314 70.96% E 602-43210-126 MEDICARE Employer Contribution$ 253 $ 230 $ 23 $ 23 90.75% E 602-43210-131 Employer Paid Health$ - $ - $ - $ - 0.00% E 602-43210-151 Worker s Comp Insurance Prem$ 525 $ 716 $ - $ (191) 136.38% E 602-43210-200 Office Supplies$ 91 $ 102 $ - $ (11) 112.31% E 602-43210-210 Operating Supplies$ 700 $ 41 $ 10 $ 659 5.90% E 602-43210-240 Small Tools and Minor Equip$ 420 $ - $ - $ 420 0.00% E 602-43210-303 Engineering Fees$ 7,718 $ 77,796 $ 415 $ (70,078) 1007.98% E 602-43210-304 Legal Services$ - $ - $ - $ - 0.00% E 602-43210-308 Other Professional Services$ 3,500 $ 20,517 $ 4,202 $ (17,017) 586.20% E 602-43210-309 Software Support & Maintenance$ 910 $ - $ - $ 910 0.00% E 602-43210-317 Employee Training$ 980 $ 598 $ - $ 382 61.05% E 602-43210-321 Telephone$ 1,750 $ 1,649 $ 89 $ 101 94.22% E 602-43210-322 Postage$ 420 $ - $ - $ 420 0.00% E 602-43210-331 Travel Expenses$ 525 $ 78 $ - $ 447 14.93% E 602-43210-334 Licenses & Permits$ 1,400 $ 505 $ - $ 895 36.07% E 602-43210-361 Liability/Property Ins$ 2,535 $ 2,383 $ - $ 152 93.99% E 602-43210-381 Utilities-Electric & Gas$ 2,100 $ 1,051 $ - $ 1,049 50.06% E 602-43210-385 Sewer Pumping & Maintenance$ 14,000 $ 17,075 $ 5,760 $ (3,075) 121.96% E 602-43210-386 Operation & Maintenance$ 3,500 $ 1,032 $ - $ 2,468 29.49% E 602-43210-404 Repair Machinery/Equipment$ 11,200 $ 2,611 $ - $ 8,589 23.31% E 602-43210-413 Equipment Rental$ 700 $ - $ - $ 700 0.00% E 602-43210-420 Depreciation Expense$ 40,600 $ - $ - $ 40,600 0.00% E 602-43210-438 Misc. Contractual$ 7,000 $ 3,170 $ 1,700 $ 3,830 45.29% E 602-43210-439 Refunds Issued$ - $ - $ - $ - 0.00% E 602-43210-530 Capital Impr Other Than Bldgs$ 6,930 $ - $ - $ 6,930 0.00% 30% of Fund Balance moved to new A-E E 602-43210-720 Operating Transfers$ - $ 17,584 $ - $ (17,584) 0.00% Fund 624 Total BLISS Sewer Expenditures$ 127,606 $ 162,009 $ 14,062 $ (34,403)126.96% CITY OF SCANDIA Revenue - Expenditure Summary NOVEMBER 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$ 22,400 $ 19,380 $ 7,651 $ 3,020 86.52% R 612-43210-36210 Interest Income$ 50 $ - $ - $ 50 0.00% Total Uptown Sewer Revenue$ 22,450$ 19,380$ 7,651$ 3,070 86.32% ExpenditureE 612-43210-101 Regular Wages & Salaries$ 10,725 $ 7,406 $ 801 $ 3,319 69.05% E 612-43210-120 Pension Expense$ - $ - $ - $ - 0.00% E 612-43210-121 PERA Coord. Employer Contribu.$ 804 $ 555 $ 60 $ 249 68.98% E 612-43210-122 FICA Employer Contribution$ 665 $ 433 $ 47 $ 232 65.07% E 612-43210-126 MEDICARE Employer Contribution$ 156 $ 107 $ 11 $ 49 68.90% E 612-43210-151 Worker s Comp Insurance Prem$ 300 $ 522 $ - $ (222) 174.00% E 612-43210-200 Office Supplies$ 100 $ 35 $ - $ 65 34.64% E 612-43210-210 Operating Supplies$ 500 $ - $ - $ 500 0.00% E 612-43210-221 Equipment Parts$ 500 $ - $ - $ 500 0.00% E 612-43210-303 Engineering Fees$ 1,050 $ - $ - $ 1,050 0.00% E 612-43210-308 Other Professional Services$ 750 $ 310 $ - $ 441 41.27% E 612-43210-309 Software Support & Maintenance$ 84 $ - $ - $ 84 0.00% E 612-43210-317 Employee Training$ 200 $ 1,138 $ - $ (938) 568.82% E 612-43210-319 Other Services$ 1,500 $ - $ - $ 1,500 0.00% E 612-43210-322 Postage$ - $ - $ - $ - 0.00% E 612-43210-334 Licenses & Permits$ 250 $ 231 $ - $ 19 92.40% E 612-43210-361 Liability/Property Ins$ 502 $ 1,464 $ 1,000 $ (962) 291.61% E 612-43210-381 Utilities-Electric & Gas$ 1,000 $ 321 $ - $ 679 32.11% E 612-43210-385 Sewer Pumping & Maintenance$ 1,500 $ 1,484 $ - $ 17 98.90% E 612-43210-386 Operation & Maintenance$ 1,000 $ 546 $ - $ 454 54.59% E 612-43210-404 Repair Machinery/Equipment$ 2,000 $ - $ - $ 2,000 0.00% E 612-43210-420 Depreciation Expense$ 4,900 $ - $ - $ 4,900 0.00% E 612-43210-438 Misc. Contractual$ 1,500 $ 589 $ - $ 911 39.26% E 612-43210-530 Capital Impr Other Than Bldgs$ 9,900 $ - $ - $ 9,900 0.00% $ 2,640 $ - $ - $ 2,640 0.00% E 612-43210-720 Operating Transfers Total Uptown Sewer Expenditures$ 42,526$ 15,139$ 1,919$ 27,387 35.60% A-E SEWER RevenueR 624-43210-31952 SA Penalties & Interest$ 180 $ - $ - $ 180 0.00% R 624-43210-34401 Sewer User Fees$ 53,670 $ 35,542 $ 771 $ 18,128 66.22% R 624-43210-36102 Penalties and Interest$ - $ 70 $ 20 $ (70) 0.00% R 624-43210-36210 Interest Income$ 90 $ - $ - $ 90 0.00% R 624-43210-39200 Interfund Operating Transfer$ - $ 17,584 $ - $ (17,584) 0.00% Total A-E Sewer Revenue$ 53,940 $ 53,196 $ 791 $ 744 98.62% ExpenditureE 624-43210-101 Regular Wages & Salaries$ 7,482 $ 5,134 $ 216 $ 2,348 68.61% E 624-43210-121 PERA Coord. Employer Contribu.$ 561 $ 385 $ 16 $ 176 68.66% E 624-43210-122 FICA Employer Contribution$ 464 $ 301 $ 13 $ 163 64.80% E 624-43210-126 MEDICARE Employer Contribution$ 108 $ 35 $ 3 $ 73 32.37% E 624-43210-131 Employer Paid Health$ - $ - $ - $ - 0.00% E 624-43210-151 Worker s Comp Insurance Prem$ 225 $ 67 $ - $ 158 29.78% E 624-43210-200 Office Supplies$ 39 $ 44 $ - $ (5) 112.31% E 624-43210-210 Operating Supplies$ 300 $ - $ - $ 300 0.00% E 624-43210-240 Small Tools and Minor Equip$ 180 $ - $ - $ 180 0.00% E 624-43210-303 Engineering Fees$ - $ - $ - $ - 0.00% E 624-43210-308 Other Professional Services$ 1,500 $ 310 $ - $ 1,191 20.63% E 624-43210-309 Software Support & Maintenance$ 390 $ - $ - $ 390 0.00% E 624-43210-317 Employee Training$ 420 $ 109 $ - $ 311 25.99% E 624-43210-321 Telephone$ 750 $ 851 $ - $ (101) 113.46% E 624-43210-322 Postage$ 180 $ - $ - $ 180 0.00% E 624-43210-331 Travel Expenses$ 225 $ 78 $ - $ 147 34.84% E 624-43210-334 Licenses & Permits$ 600 $ 231 $ - $ 369 38.50% E 624-43210-361 Liability/Property Ins$ 1,086 $ 985 $ - $ 101 90.74% E 624-43210-381 Utilities-Electric & Gas$ 900 $ 428 $ 37 $ 472 47.51% E 624-43210-385 Sewer Pumping & Maintenance$ 6,000 $ 3,690 $ 900 $ 2,310 61.50% E 624-43210-386 Operation & Maintenance$ 1,500 $ 1,032 $ - $ 468 68.80% E 624-43210-404 Repair Machinery/Equipment$ 4,800 $ 3,289 $ 2,000 $ 1,511 68.53% E 624-43210-413 Equipment Rental$ 300 $ - $ - $ 300 0.00% E 624-43210-420 Depreciation Expense$ 17,400 $ - $ - $ 17,400 0.00% E 624-43210-438 Misc. Contractual$ 3,000 $ 5,008 $ 500 $ (2,008) 166.94% E 624-43210-530 Capital Impr Other Than Bldgs$ 2,970 $ - $ - $ 2,970 0.00% Total A-E Sewer Expenditures$ 51,380$ 21,977$ 3,684$ 29,403 42.77%