Loading...
06.b Treasurer's Monthly Report 2024City of Scandiaaug Treasurer’sReport June 2, 2024 FUNDACCOUNTING Beginning CashBalance $ 2,941,459.635/1/2024 BeginningCheckingBalance$ 32,882.71 CheckingReceipts 571,821.55 Transfers toChecking TotalDeposits 571,821.55 Expenditures 472,236.49)CASHBALANCES6/2/2024 Payroll$ (42,299.50) TransferstoMoneyMarket$ - G101-10100GENERAL FUND$ 853,936.66 TotalPayments 514,535.99)G203-10100COVID-19RELIEF$466,422.00 G225-10100EDA$ 37,630.23 Ending CheckingBalance 90,168.27G226-10100CABLE TV$ 26,469.21 G230-10100GATEWAY TRAIL$ - Beginning MoneyMarketBalance 782,714.20 G 240-10100PUBLIC SAFETYAID$ 176,529.00 MoneyMarketReceipts 511.29 G313-101002013CERT$31,943.24 TransfertoChecking 500,000.00)G318-101002018CERT$19,808.68 TransferfromChecking G324-101002024ROADPROJECTS G401-10100CAPIMPR$ 756,525.76 EndingMoneyMarket Balance 283,225.49 G404-10100PARKDEV$ 70,033.40 G406-10100EQUIP REPLACE$ 76,503.68 BeginningInvestmentsBalance 2,131,406.39G 408-10100LRIF$ 3,799,526.93 Investments Receipts-Interest 6,333.81G 602-10100BLISS SEWER$ (13,117.34) 3,868,541.90G 612-10100UPTOWN SEWER$ 21,396.44BondProceeds EndingInvestmentsBalance$ 6,006,282.10G624-10100A-E SEWER$ 18,334.84 G801-10100$ 31,572.87ESCROW Outstanding Checks$ 6,373,515.606,160.26) 6/2/2024$ 6,373,515.60EndingCashBalance $ 6,373,515.60 CHECKING, MONEYMARKET & INVESTMENTCD's Checking *102$ 32,882.71BegBal Credits$ 571,821.55 Debits$ (514,535.99) ReceiptinTransit 90,168.27EndBal MoneyMarket *105 - Rate1.25%$ 782,714.20BegBal ratechangefrom .25% Credits 511.29 Debits 500,000.00) EndBal$ 283,225.49 Investments CD *4422 - Rate5.10% 12mo., 3/25/2025$ 330,758.31 CD *4424 - Rate4.50% 12mo., 7/27/2024 $ 467,924.54 CD *4425 - Rate5.10% 9mo., 9/28/2024$ 774,894.24 CD *4426 - Rate5.10% 9mo., 10/30/2024 557,829.30 BondProceeds 3,868,541.90 TotalInvestments$ 5,999,948.29 TotalBank & Investment Accounts 6,373,342.05 6,160.26) ChecksinTransit *3102 6,367,181.79TotalAdjustedUndesignatedFunds TotalFunds$ 6,367,181.79 CITY OF SCANDIA Revenue - Expenditure Summary MAY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$ 1,865,916 $ - $ - $ 1,865,916 0.00% Distributed July 1 and Dec. 1 R 101-41000-31040 Fiscal Disparities$ 107,857 $ - $ - $ 107,857 0.00% R 101-41000-31701 Gravel Taxes$ 20,000 $ - $ - $ 20,000 0.00% R 101-41000-31830 Solar Energy Production Tax$ 5,500 $ - $ - $ 5,500 0.00% R 101-41000-31900 Penalties & Interest Del Tax$ 1,000 $ - $ - $ 1,000 0.00% R 101-41000-32150 ROW Utility Permit$ 5,000 $ 2,100 $ 900 $ 2,900 42.00% R 101-41000-32180 Tobacco & Liquor Licenses$ 11,000 $ 1,150 $ 25 $ 9,850 10.45% R 101-41000-32190 Other City Permits$ 3,000 $ 769 $ 270 $ 2,231 25.63% R 101-41000-32210 Building Permits$ 160,000 $ 59,536 $ 12,071 $ 100,464 37.21% R 101-41000-32260 Gambling Permits$ 100 $ 115 $ - $ (15) 115.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid$ 7,000 $ - $ - $ 7,000 0.00% R 101-41000-33420 Fire Relief State PERA$ 40,474 $ - $ - $ 40,474 0.00% Fire Training Grants; $5k Street Sweeping R 101-41000-33422 Other State Grants & Aids$ 6,000 $ 11,600 $ - $ (5,600) 193.33%Grant R 101-41000-33428 PILOT$ 6,000 $ - $ - $ 6,000 0.00% 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,200 0.00% R 101-41000-34103 Zoning and Planning$ 5,000 $ 4,250 $ 300 $ 750 85.00% R 101-41000-34107 Assessment Search Fees$ 20 $ - $ - $ 20 0.00% R 101-41000-34109 Water Usage$ 100 $ - $ - $ 100 0.00% R 101-41000-34201 Impound Fees$ - $ - $ - $ - 0.00% R 101-41000-34202 Fire Protection Services$ 33,915 $ 35,816 $ 35,816 $ (1,901) 105.61%Town ofMay FireService Contract R 101-41000-34301 Damage Repairs$ - $ 3,070 $ 3,070 $ (3,070) 0.00% R 101-41000-34303 Dust Control$ 3,630 $ 286 $ 286 $ 3,344 7.89% R 101-41000-34304 Reimbursement for Services$ 1,000 $ 900 $ - $ 100 90.00% FLCC bookkeeping services $3,600/yr. R 101-41000-34305 Other Street Services$ - $ - $ - $ - 0.00% R 101-41000-34730 Ad Revenue$ 1,000 $ 300 $ 300 $ 700 30.00% R 101-41000-34750 Facilities Rental$ 7,400 $ 3,118 $ 1,134 $ 4,282 42.14% R 101-41000-34760 Cleaning Fees$ - $ - $ - $ - 0.00% R 101-41000-34790 Recreation Programs$ 1,500 $ 1,189 $ 54 $ 311 79.28% R 101-41000-35101 Fines & Forfeitures$ 7,000 $ 1,972 $ 637 $ 5,028 28.17% R 101-41000-36210 Interest Income$ 5,636 $ 32,081 $ 513 $ (26,445) 569.22% distributed among funds atEOY R 101-41000-36230 Donations$ 7,195 $ 1,352 $ - $ 5,843 18.79% Vinterfest button donations R 101-41000-36240 Insurance Dividend$ 4,000 $ - $ - $ 4,000 0.00% R 101-41000-36250 Misc. Refund$ 2,000 $ 142 $ - $ 1,858 7.08% Total General Fund Revenue$ 2,340,443 $ 178,140 $ 55,377 $ 2,162,303 7.61% Operating TransfersR 101-41000-39200 Interfund Operating Transfer$ - R 101-49000-39203 Transfer from Other Funds$ - $ 500,000 $ 500,000 $ (500,000) R 101-49000-39204 Money Market Transfer$ - $ 350,000 $ - $ (350,000) Total Operating Transfers$ 850,000 $ 500,000 $ (850,000) CITY OF SCANDIA Revenue - Expenditure Summary MAY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND ExpenditureADMINISTRATION & FINANCE E 101-41000-101 Regular Wages & Salaries$ 196,713 $ 61,624 $ 14,120 $ 135,089 31.33% E 101-41000-121 PERA Coord. Employer Contribu.$ 13,801 $ 5,259 $ 1,059 $ 8,542 38.10% E 101-41000-122 FICA Employer Contribution$ 12,196 $ 4,108 $ 845 $ 8,088 33.68% E 101-41000-126 MEDICARE Employer Contribution$ 2,852 $ 1,090 $ 198 $ 1,762 38.23% E 101-41000-131 Employer Paid Health$ 46,482 $ 18,080 $ 3,147 $ 28,402 38.90% E 101-41000-132 Dental Insurance$ 1,990 $ 767 $ 128 $ 1,223 38.56% E 101-41000-134 Employer Paid Life$ 643 $ 300 $ 99 $ 343 46.59% E 101-41000-135 Employer Paid Disability$ 960 $ 430 $ 72 $ 530 44.79% E 101-41000-151 Worker s Comp Insurance Prem$ 1,339 $ 1,837 $ - $ (498)137.19% E 101-41000-200 Office Supplies$ 1,133 $ 344 $ 78 $ 789 30.33% E 101-41000-203 Printed Forms & Papers$ 1,957 $ 1,874 $ - $ 83 95.78% E 101-41000-210 Operating Supplies$ 824 $ 219 $ 46 $ 605 26.59% E 101-41000-301 Auditing and Acct g Services$ 27,000 $ 32,050 $ 14,050 $ (5,050) 118.70% E 101-41000-303 Engineering Fees$ - $ (237) $ - $ 237 0.00% E 101-41000-304 Legal Services$ 65,000 $ 12,177 $ 3,001 $ 52,824 18.73% E 101-41000-306 Personal Testing & Recruit$ - $ - $ - $ -0.00% American Legal Web Fee & Ordinance E 101-41000-308 Other Professional Services$ 5,000 $ 1,747 $ - $ 3,253 34.94% Updates E 101-41000-309 Software Support & Maintenance$ 18,746 $ 6,974 $ 3,103 $ 11,772 37.21% E 101-41000-316 Conferences & Seminars$ 721 $ 20 $ - $ 701 2.77% E 101-41000-317 Employee Training$ 206 $ - $ - $ 206 0.00% E 101-41000-319 Other Services$ 700 $ 50 $ - $ 100 85.71% E 101-41000-321 Telephone$ 5,100 $ 2,142 $ 495 $ 2,958 42.00% E 101-41000-322 Postage$ 2,200 $ 1,233 $ 326 $ 967 56.07% E 101-41000-331 Travel Expenses$ 1,000 $ 148 $ - $ 852 14.77% E 101-41000-351 Legal Notices Publishing$ 1,500 $ 1,318 $ 57 $ 182 87.85% E 101-41000-361 Liability/Property Ins$ 11,516 $ 9,166 $ 9,166 $ 2,350 79.60% E 101-41000-365 Insurance Claims$ 1,000 $ - $ - $ 1,000 0.00% E 101-41000-381 Utilities-Electric & Gas$ 12,000 $ 2,228 $ 1,162 $ 9,772 18.57% E 101-41000-413 Equipment Rental$ 1,800 $ 684 $ 351 $ 1,116 38.00% E 101-41000-430 Recycling$ - $ 20 $ 20 $ (20) 0.00% E 101-41000-433 Dues and Subscriptions$ 5,000 $ 90 $ 45 $ 4,910 1.80% E 101-41000-434 Youth Service Bureau$ 5,500 $ - $ - $ 5,500 0.00% E 101-41000-435 Misc Expense$ - $ 7 $ - $ (7) 0.00% Annual website host & maintenance; ABDO E 101-41000-438 Misc. Contractual$ 4,120 $ 2,198 $ 80 $ 1,923 53.34%help E 101-41000-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-41000-560 Furniture and Fixtures$ - $ 233 $ - $ (233) 0.00% E 101-41000-570 Office Equipment$ 1,500 $ 34 $ - $ 1,466 2.27% Total Admin & Finance Dept. Expenditures$ 450,499 $ 168,214 $ 51,648 $ 281,73537.34% CITY OF SCANDIA Revenue - Expenditure Summary MAY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.CITY COUNCIL ExpendituresE 101-41110-101 Regular Wages & Salaries$ 20,772 $ 5,193 $ - $ 15,579 25.00% E 101-41110-122 FICA Employer Contribution$ 1,288 $ 123 $ - $ 1,165 9.55% E 101-41110-126 MEDICARE Employer Contribution$ 301 $ 23 $ - $ 278 7.72% E 101-41110-127 PERA Defined$ 703 $ 160 $ - $ 543 22.82% 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 $ - $ - $ 350 0.00% E 101-41110-331 Travel Expenses$ - $ - $ - $ - 0.00% E 101-41110-439 Refunds Issued$ - $ - $ - $ - 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 $ 5,552 $ - $ 17,962 23.61% ELECTIONS ExpendituresE 101-41410-199 Election Judge$ 5,400 $ 1,750 $ - $ 3,650 32.41% E 101-41410-200 Office Supplies$ 50 $ 28 $ - $ 22 55.70% E 101-41410-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-41410-210 Operating Supplies$ 750 $ 304 $ - $ 446 40.49% E 101-41410-351 Legal Notices Publishing$ 200 $ 15 $ - $ 185 7.72% E 101-41410-413 Equipment Rental$ 1,700 $ 1,672 $ - $ 28 98.35% Wash. Cty. Equip. Maintenance Fee Total Elections Dept. Expenditures$ 8,100 $ 3,769 $ - $ 4,331 46.53% PLANNING & BUILDING ExpendituresE 101-41910-101 Regular Wages & Salaries$ 60,010 $ 23,150 $ 4,489 $ 36,860 38.58% E 101-41910-121 PERA Coord. Employer Contribu.$ 4,263 $ 1,734 $ 337 $ 2,529 40.68% E 101-41910-122 FICA Employer Contribution$ 3,721 $ 1,352 $ 265 $ 2,369 36.34% E 101-41910-126 MEDICARE Employer Contribution$ 870 $ 341 $ 62 $ 529 39.14% E 101-41910-131 Employer Paid Health$ 17,353 $ 7,734 $ 1,345 $ 9,619 44.57% E 101-41910-132 Dental Insurance$ 724 $ 329 $ 55 $ 395 45.43% E 101-41910-134 Employer Paid Life$ 173 $ 86 $ 29 $ 87 49.94% E 101-41910-135 Employer Paid Disability$ 416 $ 208 $ 35 $ 208 49.95% E 101-41910-203 Printed Forms & Papers$ 100 $ - $ - $ 100 0.00% E 101-41910-311 Contract Permit Inspections$ 60,000 $ 18,994 $ 5,222 $ 41,006 31.66% E 101-41910-312 Planning Services$ 60,000 $ 5,901 $ - $ 54,099 9.84% E 101-41910-313 Committee & Commission Reimbur$ 5,200 $ 1,300 $ - $ 3,900 25.00% E 101-41910-316 Conferences & Seminars$ - $ 30 $ 30 $ (30)0.00% E 101-41910-319 Other Services$ - $ - $ - $ - 0.00% E 101-41910-361 Liability/Property Ins$ 5,563 $ 4,937 $ 4,937 $ 626 88.75% E 101-41910-438 Misc. Contractual$ 5,000 $ 1,006 $ 0 $ 3,994 20.12% E 101-41910-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-41910-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Planning & Building Dept. Expenditures$ 223,393 $ 67,103 $ 16,806 $ 156,290 30.04% ASSESSOR ExpendituresE 101-41960-300 Assessor$ 23,200 $ 9,200 $ 2,000 $ 14,000 39.66% POLICE ExpendituresE 101-42100-318 Police Contract$ 183,442 $ - $ - $ - 0.00% E 101-42100-319 Other Services$ 960 $ - $ - $ 960 0.00% 2023 Code RedSystem Total GF Police Dept. Expenditures$ 184,402 $ - $ - $ 960 0.00% CITY OF SCANDIA Revenue - Expenditure Summary MAY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.FIRE ExpendituresE 101-42200-101 Regular Wages & Salaries$ 160,554 $ 64,067 $ 14,574 $ 96,487 39.90% E 101-42200-121 PERA Coord. Employer Contribu.$ - $ - $ - $ 0.00% E 101-42200-122 FICA Employer Contribution$ 9,954 $ 4,268 $ 835 $ 5,686 42.88% E 101-42200-124 Police & Fire PERA$ 8,983 $ 3,900 $ 802 $ 5,083 43.41% E 101-42200-126 MEDICARE Employer Contribution$ 2,328 $ 559 $ 214 $ 1,769 24.01% E 101-42200-134 Employer Paid Life$ 192 $ 96 $ 32 $ 96 50.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 $ 6,249 $ 340 $ 5,751 52.08% E 101-42200-200 Office Supplies$ 200 $ 150 $ - $ 50 75.00% E 101-42200-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-42200-209 Medical Supplies$ 3,500 $ 133 $ - $ 3,367 3.80% E 101-42200-210 Operating Supplies$ 8,800 $ 736 $ 304 $ 8,064 8.36% E 101-42200-211 Cleaning Supplies$ 100 $ - $ - $ 100 0.00% E 101-42200-212 Fuel$ 4,000 $ 1,184 $ 256 $ 2,816 29.59% E 101-42200-217 Uniforms & Safety Equipment$ 10,000 $ 13,472 $ 1,407 $ (3,472) 134.72%new employee uniforms E 101-42200-221 Equipment Parts$ 1,500 $ - $ - $ 1,500 0.00% E 101-42200-222 Tires$ - $ - $ - $ - 0.00% E 101-42200-223 Structure Repair & Supplies$ 800 $ 6 $ - $ 794 0.81% E 101-42200-240 Small Tools and Minor Equip$ 22,195 $ 14,208 $ 372 $ 7,987 64.01% SCBA medical exams & flow testsE101-42200-305 Medical Services$ 5,600 $ 5,630 $ - $ (30) 100.54% E 101-42200-306 Personal Testing & Recruit$ 500 $ - $ - $ 500 0.00% E 101-42200-309 Software Support & Maintenance$ 17,000 $ 5,697 $ 3,465 $ 11,303 33.51% E 101-42200-310 Medical Training$ 2,000 $ 50 $ 50 $ 1,950 2.50% E 101-42200-316 Conferences & Seminars$ 250 $ - $ - $ 250 0.00% E 101-42200-317 Employee Training$ 12,000 $ 2,505 $ 1,405 $ 9,495 20.87% E 101-42200-319 Other Services$ 500 $ - $ - $ 500 0.00% E 101-42200-321 Telephone$ 7,000 $ 2,361 $ 534 $ 4,639 33.73% E 101-42200-322 Postage$ - $ 18 $ 18 $ (18) 0.00% E 101-42200-324 State of MN-Fire Relief$ 40,474 $ - $ - $ 40,474 0.00% E 101-42200-325 City Match-Fire Relief$ - $ - $ - $ - 0.00% E 101-42200-331 Travel Expenses$ 2,000 $ 1,818 $ 486 $ 182 90.91% Fire School travel costs MN Board ofFirefighter Training & E 101-42200-334 Licenses & Permits$ 500 $ - $ - $ 500 0.00%Education License E 101-42200-340 Advertising$ - $ - $ - $ - 0.00% E 101-42200-361 Liability/Property Ins$ 7,339 $ 7,208 $ 7,208 $ 131 98.21% E 101-42200-381 Utilities-Electric & Gas$ 8,000 $ 2,631 $ 327 $ 5,369 32.89% E 101-42200-384 Refuse/Garbage Disposal$ - $ - $ - $ - 0.00% E 101-42200-385 Sewer Pumping & Maintenance$ 550 $ 526 $ - $ 24 95.64% E 101-42200-401 Building Maintenance/Repairs$ 3,500 $ 830 $ 226 $ 2,670 23.73% E 101-42200-403 Improvements Other Than Bldgs$ - $ - $ - $ 0.00% E 101-42200-404 Repair Machinery/Equipment$ 8,500 $ 3,136 $ 142 $ 5,364 36.90% E 101-42200-407 Well Repair & Maintenance$ - $ - $ - $ - 0.00% E 101-42200-433 Dues and Subscriptions$ 3,200 $ 1,510 $ - $ 1,690 47.19% E 101-42200-438 Misc. Contractual$ 3,500 $ - $ - $ 3,500 0.00% E 101-42200-440 Events$ 1,000 $ - $ - $ 1,000 0.00% 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 $ - $ - $ 500 0.00% E 101-42200-570 Office Equipment$ 900 $ 179 $ - $ 721 19.89% Total Fire Dept Expenditures$ 369,919 $ 143,128 $ 32,996 $ 226,791 38.69% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$ 6,000 $ 2,289 $ 1,331 $ 3,711 38.15% CITY OF SCANDIA Revenue - Expenditure Summary MAY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PUBLIC WORKS ExpendituresE 101-43000-101 Regular Wages & Salaries$ 255,022 $ 107,956 $ 19,887 $ 147,066 42.33% E 101-43000-102 OT Regular Wages$ 5,014 $ 2,364 $ 416 $ 2,650 47.15% E 101-43000-104 Temporary Employee Wages$ 2,262 $ 338 $ - $ 1,924 14.93% E 101-43000-121 PERA Coord. Employer Contribu.$ 19,503 $ 7,613 $ 1,523 $ 11,890 39.04% E 101-43000-122 FICA Employer Contribution$ 16,262 $ 5,898 $ 1,195 $ 10,364 36.27% E 101-43000-126 MEDICARE Employer Contribution$ 3,803 $ 1,531 $ 280 $ 2,272 40.26% E 101-43000-131 Employer Paid Health$ 66,939 $ 29,347 $ 4,949 $ 37,592 43.84% E 101-43000-132 Dental Insurance$ 1,164 $ 532 $ 88 $ 632 45.72% E 101-43000-133 Union Training Center$ 1,872 $ 576 $ 144 $ 1,296 30.77% E 101-43000-134 Employer Paid Life$ 698 $ 356 $ 120 $ 342 50.95% E 101-43000-135 Employer Paid Disability$ 1,365 $ 690 $ 115 $ 675 50.57% 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 $ - $ - $ 50 0.00% E 101-43000-210 Operating Supplies$ 8,500 $ 3,992 $ 2,085 $ 4,508 46.96% E 101-43000-212 Fuel$ 25,000 $ 8,141 $ 1,174 $ 16,859 32.56% E 101-43000-217 Uniforms & Safety Equipment$ 2,300 $ 683 $ 13 $ 1,617 29.70% E 101-43000-221 Equipment Parts$ 17,000 $ 6,608 $ 502 $ 10,392 38.87% E 101-43000-222 Tires$ 7,500 $ - $ - $ 7,500 0.00% E 101-43000-223 Structure Repair & Supplies$ 2,000 $ - $ - $ 2,000 0.00% E 101-43000-224 Materials for Road Maintenance$ 7,000 $ 11,595 $ 6,456 $ (4,595)165.64% Cold Patch; New Streetlight Flags E 101-43000-226 Sign Replacement and Repair$ 750 $ - $ - $ 750 0.00% E 101-43000-228 Gravel$ 10,000 $ - $ - $ 10,000 0.00% E 101-43000-229 Salt$ 22,000 $ 5,052 $ 2,581 $ 16,948 22.96% E 101-43000-240 Small Tools and Minor Equip$ 8,000 $ 1,972 $ 396 $ 6,028 24.65% E 101-43000-302 Surveying$ - $ - $ - $ - 0.00% E 101-43000-303 Engineering Fees$ 10,500 $ 5,970 $ 1,854 $ 57 56.85% E 101-43000-304 Legal Services$ - $ - $ - $ - 0.00% E 101-43000-305 Medical Services$ 1,000 $ - $ - $ 1,000 0.00% E 101-43000-309 Software Support & Maintenance$ 6,000 $ - $ - $ 6,000 0.00% E 101-43000-317 Employee Training$ 1,500 $ 459 $ 289 $ 1,041 30.63% E 101-43000-319 Other Services$ 7,000 $ 524 $ 447 $ 6,476 7.49% E 101-43000-321 Telephone$ 4,000 $ 1,776 $ 356 $ 2,224 44.41% Travel toArborist workshop & Water E 101-43000-331 Travel Expenses$ 500 $ 291 $ - $ 209 58.14%School E 101-43000-334 Licenses & Permits$ 500 $ - $ - $ 500 0.00% E 101-43000-361 Liability/Property Ins$ 8,766 $ 9,713 $ 9,713 $ (947) 110.80% E 101-43000-365 Insurance Claims$ - $ - $ - $ - 0.00% E 101-43000-381 Utilities-Electric & Gas$ 6,000 $ 1,828 $ 238 $ 4,172 30.47% E 101-43000-384 Refuse/Garbage Disposal$ - $ - $ - $ - 0.00% holding tank & floor drainoil separator tank E 101-43000-385 Sewer Pumping & Maintenance$ 1,500 $ 2,285 $ 1,678 $ (785)152.35% pumping E 101-43000-387 Street Light Utilities$ 4,200 $ 1,486 $ 324 $ 2,714 35.38% E 101-43000-401 Building Maintenance/Repairs$ 6,000 $ 1,576 $ 274 $ 4,424 26.27% E 101-43000-403 Improvements Other Than Bldgs$ - $ - $ - $ 0.00% E 101-43000-404 Repair Machinery/Equipment$ 25,000 $ 3,349 $ - $ 21,651 13.40% E 101-43000-405 Contractual Road Maint/Repair$ 200,000 $ 29,489 $ 29,489 $ 170,511 14.74% E 101-43000-407 Well Repair & Maintenance$ 500 $ - $ - $ 500 0.00% E 101-43000-413 Equipment Rental$ 4,000 $ 26 $ 26 $ 3,974 0.65% E 101-43000-417 Uniform Rental$ 1,200 $ 356 $ 100 $ 844 29.67% E 101-43000-433 Dues and Subscriptions$ 200 $ - $ - $ 200 0.00% E 101-43000-438 Misc. Contractual$ 16,000 $ - $ - $ 16,000 0.00% 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$ - $ - $ - $ - 0.00% Total Public Works Dept. Expenditures$ 826,270 $ 277,475 $ 86,712 $ 544,321 33.58% CITY OF SCANDIA Revenue - Expenditure Summary MAY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$ 11,328 $ 4,215 $ 846 $ 7,113 37.21% E 101-45000-104 Temporary Employee Wages$ 39,985 $ 3,111 $ 1,420 $ 36,874 7.78% E 101-45000-121 PERA Coord. Employer Contribu.$ 850 $ 316 $ 63 $ 534 37.12% E 101-45000-122 FICA Employer Contribution$ 3,181 $ 436 $ 138 $ 2,745 13.71% E 101-45000-126 MEDICARE Employer Contribution$ 744 $ 109 $ 32 $ 635 14.59% E 101-45000-131 Employer Paid Health$ 2,562 $ 988 $ 189 $ 1,574 38.57% E 101-45000-132 Dental Insurance$ 42 $ 16 $ 3 $ 26 38.10% E 101-45000-134 Employer Paid Life$ 27 $ 13 $ 4 $ 14 49.78% E 101-45000-135 Employer Paid Disability$ 76 $ 27 $ 4 $ 49 35.37% E 101-45000-141 Unemployment Compensation$ - $ - $ - $ - 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 $ 287 $ 138 $ 713 28.69% E 101-45000-212 Fuel$ 1,000 $ 138 $ - $ 862 13.80% E 101-45000-221 Equipment Parts$ 2,500 $ 399 $ 122 $ 2,101 15.95% E 101-45000-223 Structure Repair & Supplies$ 2,500 $ 108 $ 35 $ 2,392 4.30% E 101-45000-240 Small Tools and Minor Equip$ 500 $ - $ - $ 500 0.00% E 101-45000-312 Planning Services$ - $ - $ - $ - 0.00% E 101-45000-313 Committee & Commission Reimbur$ - $ 240 $ - $ 240) 0.00% E 101-45000-319 Other Services$ 1,750 $ 551 $ - $ 1,199 31.50% 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 $ 5,333 $ (1,844) 152.86% E 101-45000-381 Utilities-Electric & Gas$ 6,500 $ 1,174 $ 332 $ 5,326 18.07% E 101-45000-384 Refuse/Garbage Disposal$ 5,000 $ 1,160 $ 589 $ 3,840 23.21% E 101-45000-385 Sewer Pumping & Maintenance$ 1,250 $ 191 $ - $ 1,059 15.31% Lighted ballfield fence repair - insurance E 101-45000-401 Building Maintenance/Repairs$ 6,000 $ 3,857 $ 3,353 $ 2,143 64.28% reimbursed E 101-45000-403 Improvements Other Than Bldgs$ 2,500 $ - $ - $ 2,500 0.00% E 101-45000-404 Repair Machinery/Equipment$ 1,000 $ 380 $ 380 $ 620 38.01% E 101-45000-406 Grounds Care$ 4,000 $ 71 $ 71 $ 3,929 1.78% E 101-45000-438 Misc. Contractual$ 8,000 $ 2,213 $ 2,213 $ 5,787 27.66% E 101-45000-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-45000-440 Events$ 7,000 $ 1,334 $ - $ 5,666 19.06% E 101-45000-490 Financial Assistance$ - $ - $ - $ - 0.00% E 101-45000-530 Capital Impr Other Than Bldgs$ 9,900 $ 1,800 $ 1,800 $ 8,100 18.18% E 101-45000-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Parks & Rec Dept. Expenditures$ 125,684 $ 30,994 $ 17,069 $ 94,690 24.66% CITY OF SCANDIA Revenue - Expenditure Summary MAY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$ 16,600 $ 6,191 $ 1,244 $ 10,409 37.29% E 101-45180-104 Temporary Employee Wages$ - $ - $ - $ - 0.00% E 101-45180-121 PERA Coord. Employer Contribu.$ 1,245 $ 463 $ 93 $ 782 37.23% E 101-45180-122 FICA Employer Contribution$ 1,029 $ 357 $ 73 $ 672 34.67% E 101-45180-126 MEDICARE Employer Contribution$ 241 $ 93 $ 17 $ 148 38.60% E 101-45180-131 Employer Paid Health$ 3,692 $ 1,318 $ 266 $ 2,374 35.69% E 101-45180-134 Employer Paid Life$ 43 $ 22 $ 7 $ 21 50.23% E 101-45180-135 Employer Paid Disability$ 95 $ 51 $ 8 $ 44 53.56% E 101-45180-151 Worker s Comp Insurance Prem$ - $ 152 $ - $ (152)0.00% E 101-45180-210 Operating Supplies$ 2,900 $ 628 $ 234 $ 2,272 21.66% E 101-45180-223 Structure Repair & Supplies$ 4,000 $ 236 $ - $ 3,764 5.91% E 101-45180-334 Licenses & Permits$ 1,000 $ 915 $ 140 $ 85 91.50% E 101-45180-361 Liability/Property Ins$ 835 $ 801 $ 801 $ 34 95.89% E 101-45180-381 Utilities-Electric & Gas$ 9,135 $ 3,171 $ 604 $ 5,964 34.71% E 101-45180-384 Refuse/Garbage Disposal$ - $ 124 $ 124 $ (124)0.00% E 101-45180-385 Sewer Pumping & Maintenance$ 4,000 $ 1,260 $ - $ 2,740 31.50% E 101-45180-401 Building Maintenance/Repairs$ 15,000 $ 4,627 $ 1,246 $ 10,373 30.85% E 101-45180-404 Repair Machinery/Equipment$ 5,000 $ 125 $ - $ 4,875 2.49% E 101-45180-406 Grounds Care$ 1,300 $ - $ - $ 1,300 0.00% E 101-45180-407 Well Repair & Maintenance$ 1,000 $ - $ - $ 1,000 0.00% Seasonal lightingE101-45180-438 Misc. Contractual$ 3,500 $ 1,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$ - $ - $ - $ 0.00% E 101-45180-570 Office Equipment$ - $ - $ - $ - 0.00% E 101-45180-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Community Center Dept. Expenditures$ 80,515 $ 22,033 $ 6,357 $ 58,482 27.37% TOTAL GENERAL FUND EXPENDITURES$ 2,321,496 $ 729,757 $ 214,919 $ 1,403,273 27.37% E 101-49000-421 Cash Over/Short Operating TransfersE 101-49000-720 Operating Transfers$ 850,000 $ 500,000 $ (850,000) 0.00% TOTAL GENERAL FUND EXPENDITURES W/TRANSFERS$ 2,321,496 $ 1,579,757 $ 714,919 $ 553,273 CITY OF SCANDIA Revenue - Expenditure Summary MAY 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 0.00% R 225-46500-33640 Other Grants$ - $ - $ - $ - 0.00% R 225-46500-34750 Facilities Rental$ - $ - $ - $ - 0.00% R 225-46500-36210 Interest Income$ 100 $ - $ - $ 100 0.00% R 225-46500-36230 Donations$ - $ 310 $ 60 $ (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$ 33,666$ 60 $ (28,266)623.45% 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 DuesE225-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 $ - $ - $ 1,500 0.00% E 225-46500-720 Operating Transfers$ - $ 33,356 $ - $ (33,356) 0.00% closed checking account Total EDA Fund Expenditures$ 4,603$ 33,743$ -$ (29,140)733.07% CABLE TV FUND RevenueR 226-41950-36210 Interest Income$ 100 $ - $ - $ 100 0.00% R 226-41950-36260 Sale of Equipment$ - $ - $ - $ - 0.00% R 226-41950-38050 Cable TV Franchise Rebates$ 16,700 $ 6,687 $ 1,724 $ 10,013 40.04% R 226-41950-38051 PEG Fees$ 4,400 $ 1,738 $ 433 $ 2,662 39.51% Total Cable TV Fund Revenue$ 21,200$ 8,425$ 2,158$ 12,775 39.74% ExpenditureE 226-41950-240 Small Tools and Minor Equip$ 300 $ - $ - $ 300 0.00% E 226-41950-309 Software Support & Maintenance$ 3,500 $ 2,024 $ 1,718 $ 1,476 57.84% E 226-41950-438 Misc. Contractual$ 7,750 $ 1,310 $ - $ 6,440 16.90% E 226-41950-570 Office Equipment$ - $ - $ - $ - 0.00% Total Cable TV Fund Expenditures$ 11,550$ 3,334$ 1,718$ 8,216 28.87% GATEWAY TRAIL FUND RevenueR 230-45000-36230 Donations$ - $ - $ - $ - 0.00% ExpenditureE 230-45000-308 Other Professional Services$ - $ - $ - $ 0.00% CITY OF SCANDIA Revenue - Expenditure Summary MAY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$ 345,634 $ - $ - $ 171,278 0.00% ExpenditureE 318-47000-601 Long Term Debt Principal$ 245,000 $ - $ - $ 245,000 0.00% E 318-47000-611 Long Term Debt Interest$ 84,175 $ 42,088 $ 42,088 $ 42,087 50.00% E 318-47000-620 Fiscal Agent s Fees$ 495 $ 1,045 $ 1,045 $ 550 211.11% Total 2018 Street Reconstruction Fund Expenditures$ 329,670 $ 43,133$ 43,133 $ 287,63713.08% 2024 STREET RECONSTRUCTION RevenueR 324-47000-31000 Washington Cty. Tax Settlement$ - $ -$ -$ 0% 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 0.00% R 401-48000-33422 Other State Grants & Aids$ - $ 7,101 $ 7,101 $ (7,101)0.00% R 401-48000-36210 Interest Income$ 3,000 $ - $ - $ 3,000 0.00% Total Capital Improvement Fund Revenue$ 238,000 $ 7,101$ 7,101$ 230,8992.98% ExpenditureE 401-41000-312 Planning Services$ - $ - $ - $ DIV/0! E 401-41000-520 Capital Improvements to Bldgs$ - $ - $ - $ DIV/0! E 401-41000-530 Capital Impr Other Than Bldgs$ 250,000 $ - $ - $ 250,000 0.00% E 401-42200-520 Capital Improvements to Bldgs$ - #DIV/0! E 401-45180-520 Capital Improvements to Bldgs$ 67,548 $ - $ - $ 67,548 0.00% E 401-48000-303 Engineering Fees$ - $ 23,327 $ 6,983 $ (23,327) 0.00% Gateway Trail Engineering E 401-48000-308 Other Professional Services$ - $ 2,400 $ - $ (2,400)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$ - $ - $ - $ DIV/0! E 401-48000-530 Capital Impr Other Than Bldgs$ 160,000 $ - $ - $ 160,000 0.00% 477,548 $ 25,727 $ 6,983 $ 451,821 5.39% PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$ 60,000 $ - $ - $ 60,000 0.00% R 404-48000-33422 Other State Grants & Aids$ - $ 101,250 $ 101,250 $ (101,250) 0.00%2023 Playground grant R 404-48000-34780 Park Dedication Fees$ - $ - $ - $ - 0.00%loan repayment toGen Capital Fund 401 R 404-48000-36210 Interest Income$ 66 $ - $ - $ 66 0.00% R 404-48000-36230 Donations$ - $ - $ - $ - 0.00% Total Park Development Fund Revenue$ 60,066$ 101,250 $ 101,250 $ (41,184)168.56% ExpenditureE 403-48000-312 Engineering Fees$ - $ 19,149 $ 14,289 $ (19,149) 0.00%Tennis court resurfacing E 404-48000-520 Capital Improvements to Bldgs$ - $ - $ - $ 0.00% E 404-48000-530 Capital Impr Other Than Bldgs$ 150,000 $ 2,686 $ - $ 147,314 1.79% E 404-48000-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Park Development Fund Expenditures$ 150,000 $ 21,834$ 14,289 $ 128,16614.56% EQUIPMENT REPLACEMENT RevenueR 406-48500-31000 Washington Cty. Tax Settlement$ 110,000 $ - $ - $ 110,000 0.00% R 406-48500-36210 Interest Income$ 1,045 $ - $ - $ 1,045 0.00% R 406-48500-36260 Sale of Equipment$ - $ - $ - $ - #DIV/0! R 406-48500-39350 Certificate of Indebtedness$ 350,000 $ - $ - $ 350,000 0.00% Total Equipment Replacement Fund Revenue$ 461,045 $ -$ -$ 461,0450.00% ExpenditureE 406-48500-540 Heavy Machinery Capital$ 867,000 $ - $ - $ 867,000 0.00% E 406-48500-550 Motor Vehicles Capital$ 84,356 $ 61,117 $ 61,117 $ 23,239 72.45% Total Equipment Replacement Fund Expenditures$ 951,356 $ 61,117$ 61,117 $ 890,2396.42% CITY OF SCANDIA Revenue - Expenditure Summary MAY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$ 375,000 $ - $ - $ 375,000 0.00% R 408-43100-33423 Other Local Grants & Aids$ 2,195 $ - $ - $ 2,195 0.00% R 408-43100-36210 Interest Income$ 10,705 $ 6,334$ 6,334$ (6,334)0.00% R 408-43100-39310 Proceeds-Gen Obligation Bond$ 4,000,000 $ 3,868,542$ 3,868,542$ (3,868,542) 0.00% Total LRIF Revenue$ 4,387,900$ 3,874,876$ 3,874,876$ (3,497,681) 88.31% ExpenditureE 408-43100-303 Engineering Fees$ 120,000 $ 86,333 $ 39,988 $ 33,668 71.94% E 408-43100-319 Other Services$ - $ 375 $ 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 $ 88,537 $ 88,169 $ 3,486,463 2.48% Total LRIF Expenditures$ 3,695,000 $ 175,304 $ 128,531 $ 3,519,696 4.74% BLISS SEWER RevenueR 602-43210-31951 Special Assessments Principal$ - $ - $ - $ 0.00% R 602-43210-31952 SA Penalties & Interest$ 420 $ - $ - $ 420 0.00% R 602-43210-33422 Other State Grants & Aids$ - $ - $ - $ -0.00% R 602-43210-34401 Sewer User Fees$ 125,230 $ 27,481 $ 1,648 $ 97,749 21.94% R 602-43210-34402 Sewer Connection Fee$ - $ - $ - $ - 0.00% R 602-43210-36100 Special Assessments$ - $ 47 $ - $ (47)0.00% R 602-43210-36102 Penalties and Interest$ - $ 40 $ 10 $ 40) 0.00% R 602-43210-36210 Interest Income$ 210 $ - $ - $ 210 0.00% Total BLISS Sewer Revenue$ 125,860 $ 27,568 $ 1,658 $ 98,292 21.90% ExpenditureE 602-43210-101 Regular Wages & Salaries$ 17,458 $ 7,698 $ 1,555 $ 9,760 44.09% E 602-43210-120 Pension Expense$ - $ - $ - $ - 0.00% E 602-43210-121 PERA Coord. Employer Contribu.$ 1,309 $ 576 $ 117 $ 733 44.01% E 602-43210-122 FICA Employer Contribution$ 1,082 $ 443 $ 92 $ 639 40.96% E 602-43210-126 MEDICARE Employer Contribution$ 253 $ 118 $ 21 $ 135 46.76% E 602-43210-131 Employer Paid Health$ - $ - $ - $ - 0.00% E 602-43210-151 Worker s Comp Insurance Prem$ 525 $ 783 $ - $ 258) 149.14% E 602-43210-200 Office Supplies$ 91 $ 102 $ - $ (11) 112.31% E 602-43210-210 Operating Supplies$ 700 $ 3 $ - $ 697 0.38% E 602-43210-240 Small Tools and Minor Equip$ 420 $ - $ - $ 420 0.00% E 602-43210-303 Engineering Fees$ 7,718 $ 60,953 $ 18,383 $ (53,235) 789.75% E 602-43210-304 Legal Services$ - $ - $ - $ - 0.00% E 602-43210-308 Other Professional Services$ 3,500 $ 13,091 $ 3,348 $ (9,591) 374.03%Monthly testing; Lobbying $7,200 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 $ 909 $ 104 $ 841 51.93% 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 $ 2,383 $ 152 93.99% E 602-43210-381 Utilities-Electric & Gas$ 2,100 $ 388 $ 126 $ 1,712 18.50% E 602-43210-385 Sewer Pumping & Maintenance$ 14,000 $ 1,245 $ 1,245 $ 12,755 8.89% E 602-43210-386 Operation & Maintenance$ 3,500 $ - $ - $ 3,500 0.00% E 602-43210-404 Repair Machinery/Equipment$ 11,200 $ 795 $ 726 $ 10,405 7.10% 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 $ 498 $ - $ 6,502 7.11% E 602-43210-439 Refunds Issued$ - $ - $ - $ - 0.00% E 602-43210-530 Capital Impr Other Than Bldgs$ 6,930 $ - $ - $ 6,930 0.00% 30% ofFund Balance moved tonew A-E E 602-43210-720 Operating Transfers$ - $ 17,584 $ - $ (17,584) 0.00% Fund 624 Total BLISS Sewer Expenditures$ 127,606 $ 17,584 $ - $ (17,584) 0.00% CITY OF SCANDIA Revenue - Expenditure Summary MAY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$ 22,400 $ 5,480 $ 4,632 $ 16,920 24.46% R 612-43210-36210 Interest Income$ 50 $ - $ - $ 50 0.00% Total Uptown Sewer Revenue$ 22,450$ 5,480$ 4,632$ 16,970 24.41% ExpenditureE 612-43210-101 Regular Wages & Salaries$ 10,725 $ 3,102 $ 635 $ 7,623 28.92% E 612-43210-120 Pension Expense$ - $ - $ - $ - 0.00% E 612-43210-121 PERA Coord. Employer Contribu.$ 804 $ 232 $ 48 $ 572 28.85% E 612-43210-122 FICA Employer Contribution$ 665 $ 178 $ 37 $ 487 26.78% E 612-43210-126 MEDICARE Employer Contribution$ 156 $ 48 $ 9 $ 108 30.74% E 612-43210-151 Worker s Comp Insurance Prem$ 300 $ 522 $ - $ 222) 174.00% E 612-43210-200 Office Supplies$ 100 $ - $ - $ 100 0.00% 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%Employee water training 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 $ 464 $ 464 $ 38 92.41% E 612-43210-381 Utilities-Electric & Gas$ 1,000 $ 218 $ 33 $ 782 21.84% E 612-43210-385 Sewer Pumping & Maintenance$ 1,500 $ - $ - $ 1,500 0.00% E 612-43210-386 Operation & Maintenance$ 1,000 $ - $ - $ 1,000 0.00% 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 $ 449 $ - $ 1,051 29.92% 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$ 6,891$ 1,225$ 35,635 16.21% A-E SEWER RevenueR 624-43210-36102 Penalties and Interest$ 180 $ 20 $ 20 $ 20) 0.00% R 624-43210-34401 Sewer User Fees$ 53,670 $ 11,909 $ 1,169 $ 41,761 22.19% 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 $ 29,513 $ 1,189 $ 24,247 54.71% ExpenditureE 624-43210-101 Regular Wages & Salaries$ 7,482 $ - $ - $ 7,482 0.00% E 624-43210-121 PERA Coord. Employer Contribu.$ 561 $ - $ - $ 561 0.00% E 624-43210-122 FICA Employer Contribution$ 464 $ - $ - $ 464 0.00% E 624-43210-126 MEDICARE Employer Contribution$ 108 $ - $ - $ 108 0.00% E 624-43210-131 Employer Paid Health$ - $ - $ - $ - 0.00% E 624-43210-151 Worker s Comp Insurance Prem$ 225 $ - $ - $ 225 0.00% E 624-43210-199 Election Judge$ - $ - $ - $ - 0.00% 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 $ 293 $ 133 $ 457 39.01% 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 $ 985 $ 101 90.74% E 624-43210-381 Utilities-Electric & Gas$ 900 $ 210 $ 40 $ 690 23.33% E 624-43210-385 Sewer Pumping & Maintenance$ 6,000 $ - $ - $ 6,000 0.00% E 624-43210-386 Operation & Maintenance$ 1,500 $ - $ - $ 1,500 0.00% E 624-43210-404 Repair Machinery/Equipment$ 4,800 $ 230 $ - $ 4,570 4.79% 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 $ 4,368 $ 3,744 $ (1,368) 145.60% Riser replacement E 624-43210-530 Capital Impr Other Than Bldgs$ 2,970 $ - $ - $ 2,970 0.00% Total A-E Sewer Expenditures$ 51,380$ 6,858$ 4,902$ 44,522 13.35%