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 2024
City 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%