No preview available
06.b Treasurer's ReportCity of Scandiaaug Treasurer’sReport January 31, 2024 FUNDACCOUNTING Beginning CashBalance $ 3,559,685.061/1/2024 BeginningCheckingBalance$ 303,425.97 CheckingReceipts 88,357.53 Transfers toChecking 350,000.00 TotalDeposits 438,357.53 Expenditures 337,722.87) Payroll$ (70,559.14) TransferstoMoneyMarket$ - TotalPayments 408,282.01) Ending CheckingBalance 333,501.49 Beginning MoneyMarketBalance 1,129,409.02 MoneyMarketReceipts 897.66 TransfertoChecking 350,000.00) TransferfromChecking EndingMoneyMarket Balance 780,306.68 BeginningInvestmentsBalance 2,103,152.07 InvestmentsReceipts 10,067.76 EndingInvestmentsBalance$ 2,113,219.83 Beginning EDABalance$ 33,356.07 EDAReceipts EDAExpenditures EDADe;positinTransit EDATransfers fromChecking EndingEDABalance$ 33,356.07 Outstanding Checks 5,451.19) 1/31/2024EndingCashBalance $ 3,254,932.88 CHECKING, MONEYMARKET & INVESTMENTCD's Checking *102$ 303,425.97BegBal Credits$ 438,357.53 Debits$ (408,282.01) Transfer inTransit 333,501.49EndBal MoneyMarket *105 - Rate1.25%$ 1,129,409.02BegBal ratechangefrom .25% Credits 897.66 Debits 350,000.00) EndBal$ 780,306.68 Investments CD *4422 - Rate4.00% 12mo., 3/25/2024 $ 327,492.36 CD *4424 - Rate4.50% 12mo., 7/27/2024 $ 462,733.06 CD *4425 - Rate5.10% 12mo., 9/28/2024$ 765,165.11 CD *4426 - Rate5.10% 9mo., 10/30/2024 557,829.30 TotalInvestments$ 2,113,219.83 TotalBank & Investment Accounts 3,227,028.00 5,451.19) ChecksinTransit *3102 TransfertoEDAinTransit Depositintransitmoneymarket 3,221,576.81TotalAdjustedUndesignatedFunds ScandiaEDA *6301 $ 33,356.07 Receipts Expenditures ChecksinTransit DepositinTransit TotalDesignated EDAFunds$ 33,356.07 TotalFunds$ 3,254,932.88 Submitted by: ColleenFirkus, Treasurer 2024 CASH BALANCES END OF MONTH FUNDJANUARY 101 GENERAL$1,379,620 203 COVID-19 RELIEF$456,363 226 CABLE TV$21,223 230 GATEWAY TRAIL$0 240 PUBIC SAFETY AID$176,529 313 EQUIPMENT CERTIFICATES$31,943 318 BLACKTOP PROJECT$61,100 401 CAPITAL IMPR$757,508 404 PARK CAP IMPR-$15,577 406 EQUIPMENT REPLACEMENT$133,663 408 LOCAL ROAD IMPROVEMENT$120,442 602 BIG MARINE SEWER$65,723 612 UPTOWN SEWER$15,868 801 ESCROW$17,172 SUBTOTAL$3,221,577 225 EDA$33,356 TOTAL$3,254,933 CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$ 1,865,916 $ 36,655 $ 36,655 $ 1,829,261 1.96% R 101-41000-31040 Fiscal Disparities$ 107,857 $ 557 $ 557 $ 107,300 0.52% 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 $ - $ - $ 5,000 0.00% R 101-41000-32180 Tobacco & Liquor Licenses$ 11,000 $ 3,725 $ 3,725 $ 7,275 33.86% R 101-41000-32190 Other City Permits$ 3,000 $ - $ - $ 3,000 0.00% R 101-41000-32210 Building Permits$ 160,000 $ 13,726 $ 13,726 $ 146,274 8.58% R 101-41000-32260 Gambling Permits$ 100 $ - $ - $ 100 0.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid$ 7,000 $ 286 $ 286 $ 6,714 4.08% R 101-41000-33420 Fire Relief State PERA$ 40,474 $ - $ - $ 40,474 0.00% R 101-41000-33422 Other State Grants & Aids$ 6,000 $ 6,600 $ 6,600 $ (600) 110.00%Fire Training grants R 101-41000-33428 PILOT$ 6,000 $ 44 $ 44 $ 5,956 0.74% R 101-41000-33620 Recycling Grant$ 11,000 $ - $ - $ 11,000 0.00% R 101-41000-33630 Local Govt Grants & Aids$ - $ - $ - $ - 0.00% R 101-41000-33640 Other Grants$ 1,200 $ - $ - $ 1,200 0.00% R 101-41000-34103 Zoning and Planning$ 5,000 $ 700 $ 700 $ 4,300 14.00% R 101-41000-34106 Engineering Fees$ - $ - $ - $ - 0.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 $ - $ - $ 33,915 0.00% R 101-41000-34301 Damage Repairs$ - $ - $ - $ - 0.00% R 101-41000-34303 Dust Control$ 3,630 $ - $ - $ 3,630 0.00% R 101-41000-34304 Reimbursement for Services$ 1,000 $ - $ - $ 1,000 0.00% R 101-41000-34305 Other Street Services$ - $ - $ - $ - 0.00% R 101-41000-34730 Ad Revenue$ 1,000 $ - $ - $ 1,000 0.00% R 101-41000-34750 Facilities Rental$ 7,400 $ 200 $ 200 $ 7,200 2.70% R 101-41000-34760 Cleaning Fees$ - $ - $ - $ - 0.00% R 101-41000-34790 Recreation Programs$ 1,500 $ 10 $ 10 $ 1,490 0.67% R 101-41000-35101 Fines & Forfeitures$ 7,000 $ 1,045 $ 1,045 $ 5,955 14.93% distributed among funds at EOYR101-41000-36210 Interest Income$ 5,636 $ 10,969 $ 10,969 $ (5,333) 194.62% R 101-41000-36230 Donations$ 5,000 $ 38 $ 38 $ 4,962 0.76% R 101-41000-36240 Insurance Dividend$ 4,000 $ - $ - $ 4,000 0.00% R 101-41000-36250 Misc. Refund$ 2,000 $ - $ - $ 2,000 0.00% Total General Fund Revenue$ 2,328,248 $ 74,555 $ 74,555 $ 2,253,693 3.20% Operating TransfersR 101-41000-39200 Interfund Operating Transfer$ - R 101-49000-39203 Transfer from Other Funds$ - R 101-49000-39204 Money Market Transfer$ - $ 350,000 $ 350,000 $ (350,000) Total Operating Transfers$ 350,000$ 350,000$ (350,000) CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND ExpenditureADMINISTRATION & FINANCE E 101-41000-101 Regular Wages & Salaries$ 196,713 $ 20,531 $ 20,531 $ 176,182 10.44% E 101-41000-121 PERA Coord. Employer Contribu.$ 13,801 $ 1,540 $ 1,540 $ 12,261 11.16% E 101-41000-122 FICA Employer Contribution$ 12,196 $ 1,243 $ 1,243 $ 10,953 10.19% E 101-41000-126 MEDICARE Employer Contribution$ 2,852 $ 291 $ 291 $ 2,561 10.19% E 101-41000-131 Employer Paid Health$ 46,482 $ 3,147 $ 3,147 $ 43,335 6.77% E 101-41000-132 Dental Insurance$ 1,990 $ 128 $ 128 $ 1,862 6.43% E 101-41000-134 Employer Paid Life$ 643 $ 50 $ 50 $ 593 7.71% E 101-41000-135 Employer Paid Disability$ 960 $ 72 $ 72 $ 888 7.47% E 101-41000-151 Worker s Comp Insurance Prem$ 1,339 $ 1,837 $ 1,837 $ (498) 137.19% E 101-41000-200 Office Supplies$ 1,133 $ 29 $ 29 $ 1,104 2.55% E 101-41000-203 Printed Forms & Papers$ 1,957 $ - $ - $ 1,957 0.00% E 101-41000-210 Operating Supplies$ 824 $ 41 $ 41 $ 783 4.95% E 101-41000-301 Auditing and Acct g Services$ 27,000 $ 590 $ 590 $ 26,410 2.19% E 101-41000-303 Engineering Fees$ - $ - $ - $ - 0.00% E 101-41000-304 Legal Services$ 65,000 $ 5,531 $ 5,531 $ 59,470 8.51% E 101-41000-306 Personal Testing & Recruit$ - $ - $ - $ - 0.00% E 101-41000-308 Other Professional Services$ 5,000 $ 500 $ 500 $ 4,500 10.00% E 101-41000-309 Software Support & Maintenance$ 18,746 $ 796 $ 796 $ 17,950 4.25% E 101-41000-314 Animal Control$ - $ - $ - $ - 0.00% E 101-41000-316 Conferences & Seminars$ 721 $ 330 $ 330 $ 391 45.77% E 101-41000-317 Employee Training$ 206 $ - $ - $ 206 0.00% E 101-41000-319 Other Services$ 700 $ 550 $ 550 $ 150 78.57% E 101-41000-321 Telephone$ 5,100 $ 475 $ 475 $ 4,625 9.31% E 101-41000-322 Postage$ 2,200 $ 26 $ 26 $ 2,174 1.17% E 101-41000-331 Travel Expenses$ 1,000 $ 42 $ 42 $ 958 4.19% E 101-41000-351 Legal Notices Publishing$ 1,500 $ 747 $ 747 $ 753 49.78% E 101-41000-361 Liability/Property Ins$ 11,516 $ - $ - $ 11,516 0.00% E 101-41000-365 Insurance Claims$ 1,000 $ - $ - $ 1,000 0.00% E 101-41000-381 Utilities-Electric & Gas$ 12,000 $ 511 $ 511 $ 11,489 4.26% E 101-41000-413 Equipment Rental$ 1,800 $ 32 $ 32 $ 1,768 1.76% E 101-41000-430 Recycling$ - $ - $ - $ - 0.00% E 101-41000-433 Dues and Subscriptions$ 5,000 $ - $ - $ 5,000 0.00% E 101-41000-434 Youth Service Bureau$ 5,500 $ - $ - $ 5,500 0.00% E 101-41000-435 Misc Expense$ - $ - $ - $ - 0.00% Website Host; ABDO accounting assistanceE101-41000-438 Misc. Contractual$ 4,120 $ - $ - $ 4,120 0.00% E 101-41000-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-41000-560 Furniture and Fixtures$ - $ - $ - $ - 0.00% E 101-41000-570 Office Equipment$ 1,500 $ - $ - $ 1,500 0.00% Total Admin & Finance Dept. Expenditures$ 450,499$ 39,035$ 39,035 $ 411,4648.66% CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 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 $ 5,193 $ 15,579 25.00% E 101-41110-122 FICA Employer Contribution$ 1,288 $ 62 $ 62 $ 1,226 4.78% E 101-41110-126 MEDICARE Employer Contribution$ 301 $ 75 $ 75 $ 226 25.02% E 101-41110-127 PERA Defined$ 703 $ 210 $ 210 $ 493 29.87% E 101-41110-151 Worker s Comp Insurance Prem$ 100 $ 52 $ 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,592 $ 5,592 $ 17,922 23.78% ELECTIONS ExpendituresE 101-41410-199 Election Judge$ 5,400 $ - $ - $ 5,400 0.00% E 101-41410-200 Office Supplies$ 50 $ - $ - $ 50 0.00% E 101-41410-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-41410-210 Operating Supplies$ 750 $ - $ - $ 750 0.00% E 101-41410-351 Legal Notices Publishing$ 200 $ - $ - $ 200 0.00% E 101-41410-413 Equipment Rental$ 1,700 $ - $ - $ 1,700 0.00%Wash. Cty. Equip. Maintenance Fee Total Elections Dept. Expenditures$ 8,100 $ - $ - $ 8,100 0.00% PLANNING & BUILDING ExpendituresE 101-41910-101 Regular Wages & Salaries$ 60,010 $ 6,583 $ 6,583 $ 53,427 10.97% E 101-41910-121 PERA Coord. Employer Contribu.$ 4,263 $ 494 $ 494 $ 3,769 11.58% E 101-41910-122 FICA Employer Contribution$ 3,721 $ 395 $ 395 $ 3,326 10.62% E 101-41910-126 MEDICARE Employer Contribution$ 870 $ 92 $ 92 $ 778 10.62% E 101-41910-131 Employer Paid Health$ 17,353 $ 1,345 $ 1,345 $ 16,008 7.75% E 101-41910-132 Dental Insurance$ 724 $ 55 $ 55 $ 669 7.57% E 101-41910-134 Employer Paid Life$ 173 $ 14 $ 14 $ 159 8.32% E 101-41910-135 Employer Paid Disability$ 416 $ 35 $ 35 $ 381 8.32% E 101-41910-203 Printed Forms & Papers$ 100 $ - $ - $ 100 0.00% E 101-41910-311 Contract Permit Inspections$ 60,000 $ 2,055 $ 2,055 $ 57,945 3.42% E 101-41910-312 Planning Services$ 60,000 $ 3,409 $ 3,409 $ 56,591 5.68% E 101-41910-313 Committee & Commission Reimbur$ 5,200 $ - $ - $ 5,200 0.00% E 101-41910-316 Conferences & Seminars$ - $ - $ - $ - 0.00% E 101-41910-319 Other Services$ - $ - $ - $ - 0.00% E 101-41910-361 Liability/Property Ins$ 5,563 $ - $ - $ 5,563 0.00% E 101-41910-438 Misc. Contractual$ 5,000 $ - $ - $ 5,000 0.00% E 101-41910-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-41910-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Planning & Building Dept. Expenditures$ 223,393 $ 14,477 $ 14,477 $ 208,916 6.48% ASSESSOR ExpendituresE 101-41960-300 Assessor$ 23,200 $ 1,800 $ 1,800 $ 21,400 7.76% POLICE ExpendituresE 101-42100-318 Police Contract$ 183,442 $ 84,250 $ 84,250 $ 99,192 45.93% E 101-42100-319 Other Services$ 960 $ - $ - $ 960 0.00%Code Red System Total GF Police Dept. Expenditures$ 184,402 $ 84,250 $ 84,250 $ 100,152 45.69% CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.FIRE ExpendituresE 101-42200-101 Regular Wages & Salaries$ 160,554 $ 25,128 $ 25,128 $ 135,426 15.65% E 101-42200-121 PERA Coord. Employer Contribu.$ - $ - $ - $ - 0.00% E 101-42200-122 FICA Employer Contribution$ 9,954 $ 1,600 $ 1,600 $ 8,354 16.07% E 101-42200-124 Police & Fire PERA$ 8,983 $ 1,093 $ 1,093 $ 7,890 12.16% E 101-42200-126 MEDICARE Employer Contribution$ 2,328 $ 370 $ 370 $ 1,958 15.90% E 101-42200-134 Employer Paid Life$ 192 $ 16 $ 16 $ 176 8.33% 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 $ 5,909 $ 5,909 $ 6,091 49.24% E 101-42200-200 Office Supplies$ 200 $ - $ - $ 200 0.00% E 101-42200-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-42200-209 Medical Supplies$ 3,500 $ 157 $ 157 $ 3,343 4.47% E 101-42200-210 Operating Supplies$ 8,800 $ 139 $ 139 $ 8,661 1.58% E 101-42200-211 Cleaning Supplies$ 100 $ - $ - $ 100 0.00% E 101-42200-212 Fuel$ 4,000 $ 207 $ 207 $ 3,793 5.16% E 101-42200-217 Uniforms & Safety Equipment$ 10,000 $ - $ - $ 10,000 0.00% 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 $ - $ - $ 800 0.00% E 101-42200-240 Small Tools and Minor Equip$ 10,000 $ - $ - $ 10,000 0.00% SCBA User Exams + Annual Fit TestE101-42200-305 Medical Services$ 5,600 $ - $ - $ 5,600 0.00% E 101-42200-306 Personal Testing & Recruit$ 500 $ - $ - $ 500 0.00% E 101-42200-309 Software Support & Maintenance$ 17,000 $ 648 $ 648 $ 16,352 3.81% E 101-42200-310 Medical Training$ 2,000 $ - $ - $ 2,000 0.00% E 101-42200-316 Conferences & Seminars$ 250 $ - $ - $ 250 0.00% E 101-42200-317 Employee Training$ 12,000 $ - $ - $ 12,000 0.00% E 101-42200-319 Other Services$ 500 $ 889 $ 889 $ (389) 177.89% E 101-42200-321 Telephone$ 7,000 $ 532 $ 532 $ 6,468 7.60% E 101-42200-322 Postage$ - $ - $ - $ - 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 $ - $ - $ 2,000 0.00% E 101-42200-334 Licenses & Permits$ 500 $ - $ - $ 500 0.00% MNBoard ofFirefighter Training & Education License E 101-42200-340 Advertising$ - $ - $ - $ - 0.00% E 101-42200-361 Liability/Property Ins$ 7,339 $ - $ - $ 7,339 0.00% E 101-42200-381 Utilities-Electric & Gas$ 8,000 $ 785 $ 785 $ 7,215 9.82% E 101-42200-384 Refuse/Garbage Disposal$ - $ 98 $ 98 $ (98) 0.00% E 101-42200-385 Sewer Pumping & Maintenance$ 550 $ - $ - $ 550 0.00% E 101-42200-401 Building Maintenance/Repairs$ 3,500 $ 150 $ 150 $ 3,350 4.29%Cleaning, Pest Control,Repairs E 101-42200-403 Improvements Other Than Bldgs$ - $ - $ - $ - 0.00% E 101-42200-404 Repair Machinery/Equipment$ 8,500 $ 19 $ 19 $ 8,481 0.22% E 101-42200-407 Well Repair & Maintenance$ - $ - $ - $ - 0.00% E 101-42200-433 Dues and Subscriptions$ 3,200 $ 50 $ 50 $ 3,150 1.56%Truck inspection renewal 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 $ - $ - $ 900 0.00% Total Fire Dept Expenditures$ 357,724 $ 37,790 $ 37,790 $ 319,934 10.56% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$ 6,000 $ 150 $ 150 $ 5,850 2.50% CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PUBLIC WORKS ExpendituresE 101-43000-101 Regular Wages & Salaries$ 255,022 $ 28,489 $ 28,489 $ 226,533 11.17% E 101-43000-102 OT Regular Wages$ 5,014 $ 1,039 $ 1,039 $ 3,975 20.73% E 101-43000-104 Temporary Employee Wages$ 2,262 $ - $ - $ 2,262 0.00%snowplowing E 101-43000-121 PERA Coord. Employer Contribu.$ 19,503 $ 2,215 $ 2,215 $ 17,288 11.36% E 101-43000-122 FICA Employer Contribution$ 16,262 $ 1,769 $ 1,769 $ 14,493 10.88% E 101-43000-126 MEDICARE Employer Contribution$ 3,803 $ 414 $ 414 $ 3,389 10.88% E 101-43000-131 Employer Paid Health$ 66,939 $ 4,832 $ 4,832 $ 62,107 7.22% E 101-43000-132 Dental Insurance$ 1,164 $ 88 $ 88 $ 1,076 7.57% E 101-43000-133 Union Training Center$ 1,872 $ - $ - $ 1,872 0.00% E 101-43000-134 Employer Paid Life$ 698 $ 58 $ 58 $ 640 8.33% E 101-43000-135 Employer Paid Disability$ 1,365 $ 115 $ 115 $ 1,250 8.43% E 101-43000-141 Unemployment Compensation$ - $ - $ - $ - 0.00% E 101-43000-151 Worker s Comp Insurance Prem$ 27,000 $ 22,615 $ 22,615 $ 4,385 83.76% E 101-43000-200 Office Supplies$ 50 $ - $ - $ 50 0.00% E 101-43000-210 Operating Supplies$ 8,500 $ 68 $ 68 $ 8,432 0.80% E 101-43000-212 Fuel$ 25,000 $ 1,880 $ 1,880 $ 23,120 7.52% E 101-43000-217 Uniforms & Safety Equipment$ 2,300 $ - $ - $ 2,300 0.00% E 101-43000-221 Equipment Parts$ 17,000 $ - $ - $ 17,000 0.00% 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 $ 2,627 $ 2,627 $ 4,373 37.52% 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 $ - $ - $ 22,000 0.00% E 101-43000-240 Small Tools and Minor Equip$ 8,000 $ - $ - $ 8,000 0.00% E 101-43000-302 Surveying$ - $ - $ - $ - 0.00% E 101-43000-303 Engineering Fees$ 10,500 $ 123 $ 123 $ 10,377 1.17%Gen. Eng. & Crack filling & seal coat fees E 101-43000-304 Legal Services$ - $ - $ - $ - 0.00% E 101-43000-305 Medical Services$ 1,000 $ - $ - $ 1,000 0.00% IWORQ subscription; GIS map updatesE101-43000-309 Software Support & Maintenance$ 6,000 $ - $ - $ 6,000 0.00% E 101-43000-317 Employee Training$ 1,500 $ - $ - $ 1,500 0.00% E 101-43000-319 Other Services$ 7,000 $ 8 $ 8 $ 6,992 0.12% E 101-43000-321 Telephone$ 4,000 $ 354 $ 354 $ 3,646 8.85% E 101-43000-331 Travel Expenses$ 500 $ - $ - $ 500 0.00% E 101-43000-334 Licenses & Permits$ 500 $ 182 $ 182 $ 318 36.45% E 101-43000-361 Liability/Property Ins$ 8,766 $ - $ - $ 8,766 0.00% E 101-43000-365 Insurance Claims$ - $ - $ - $ - 0.00% E 101-43000-381 Utilities-Electric & Gas$ 6,000 $ 570 $ 570 $ 5,430 9.50% E 101-43000-384 Refuse/Garbage Disposal$ - $ 65 $ 65 $ (65) 0.00% E 101-43000-385 Sewer Pumping & Maintenance$ 1,500 $ - $ - $ 1,500 0.00% E 101-43000-387 Street Light Utilities$ 4,200 $ 1,020 $ 1,020 $ 3,180 24.28% E 101-43000-401 Building Maintenance/Repairs$ 6,000 $ 220 $ 220 $ 5,780 3.67% E 101-43000-403 Improvements Other Than Bldgs$ - $ - $ - $ - 0.00% E 101-43000-404 Repair Machinery/Equipment$ 25,000 $ - $ - $ 25,000 0.00% E 101-43000-405 Contractual Road Maint/Repair$ 200,000 $ - $ - $ 200,000 0.00% E 101-43000-407 Well Repair & Maintenance$ 500 $ - $ - $ 500 0.00% E 101-43000-413 Equipment Rental$ 4,000 $ - $ - $ 4,000 0.00% E 101-43000-417 Uniform Rental$ 1,200 $ 77 $ 77 $ 1,123 6.43% 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$ - $ - $ - $ - E 101-43000-720 Operating Transfers$ - $ - $ - $ - Total Public Works Dept. Expenditures$ 826,270 $ 68,828 $ 68,828 $ 757,442 8.33% CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$ 11,328 $ 1,213 $ 1,213 $ 10,115 10.71% E 101-45000-104 Temporary Employee Wages$ 39,985 $ 1,691 $ 1,691 $ 38,294 4.23% E 101-45000-121 PERA Coord. Employer Contribu.$ 850 $ 91 $ 91 $ 759 10.70% E 101-45000-122 FICA Employer Contribution$ 3,181 $ 178 $ 178 $ 3,003 5.58% E 101-45000-126 MEDICARE Employer Contribution$ 744 $ 42 $ 42 $ 703 5.58% E 101-45000-131 Employer Paid Health$ 2,562 $ 184 $ 184 $ 2,378 7.20% E 101-45000-132 Dental Insurance$ 42 $ 3 $ 3 $ 39 7.62% E 101-45000-134 Employer Paid Life$ 27 $ 2 $ 2 $ 25 8.30% E 101-45000-135 Employer Paid Disability$ 76 $ 4 $ 4 $ 72 5.89% E 101-45000-141 Unemployment Compensation$ - $ - $ - $ - 0.00% E 101-45000-151 Worker s Comp Insurance Prem$ 2,700 $ 2,251 $ 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 $ 47 $ 47 $ 953 4.70% E 101-45000-212 Fuel$ 1,000 $ - $ - $ 1,000 0.00% E 101-45000-221 Equipment Parts$ 2,500 $ 120 $ 120 $ 2,380 4.79% E 101-45000-223 Structure Repair & Supplies$ 2,500 $ - $ - $ 2,500 0.00% 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$ - $ - $ - $ - 0.00% E 101-45000-319 Other Services$ 1,750 $ 11 $ 11 $ 1,739 0.64% E 101-45000-322 Postage$ - $ - $ - $ - 0.00% E 101-45000-340 Advertising$ - $ - $ - $ - 0.00% E 101-45000-353 Sales& Use Tax$ - $ - $ - $ - 0.00% E 101-45000-361 Liability/Property Ins$ 3,489 $ - $ - $ 3,489 0.00% E 101-45000-381 Utilities-Electric & Gas$ 6,500 $ 360 $ 360 $ 6,140 5.53% E 101-45000-384 Refuse/Garbage Disposal$ 5,000 $ 149 $ 149 $ 4,851 2.98% E 101-45000-385 Sewer Pumping & Maintenance$ 1,250 $ 168 $ 168 $ 1,082 13.43% E 101-45000-401 Building Maintenance/Repairs$ 6,000 $ 120 $ 120 $ 5,880 2.00% E 101-45000-403 Improvements Other Than Bldgs$ 2,500 $ - $ - $ 2,500 0.00% E 101-45000-404 Repair Machinery/Equipment$ 1,000 $ - $ - $ 1,000 0.00% E 101-45000-406 Grounds Care$ 4,000 $ - $ - $ 4,000 0.00% E 101-45000-438 Misc. Contractual$ 8,000 $ 2,500 $ 2,500 $ 5,500 31.25% E 101-45000-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-45000-440 Events$ 7,000 $ 404 $ 404 $ 6,596 5.77% E 101-45000-490 Financial Assistance$ - $ - $ - $ - 0.00% E 101-45000-530 Capital Impr Other Than Bldgs$ 9,900 $ 4,500 $ 4,500 $ 5,400 45.45% E 101-45000-720 Operating Transfers$ - $ - #DIV/0! Total Parks & Rec Dept. Expenditures$ 125,684 $ 14,038 $ 14,038 $ 111,646 11.17% CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$ 16,600 $ 1,772 $ 1,772 $ 14,828 10.67% E 101-45180-104 Temporary Employee Wages$ - $ - $ - $ - 0.00% E 101-45180-121 PERA Coord. Employer Contribu.$ 1,245 $ 133 $ 133 $ 1,112 10.67% E 101-45180-122 FICA Employer Contribution$ 1,029 $ 106 $ 106 $ 923 10.31% E 101-45180-126 MEDICARE Employer Contribution$ 241 $ 25 $ 25 $ 216 10.29% E 101-45180-131 Employer Paid Health$ 3,692 $ 256 $ 256 $ 3,436 6.92% E 101-45180-134 Employer Paid Life$ 43 $ 4 $ 4 $ 39 8.37% E 101-45180-135 Employer Paid Disability$ 95 $ 8 $ 8 $ 87 8.93% E 101-45180-151 Worker s Comp Insurance Prem$ - $ 152 $ 152 $ (152) 0.00% E 101-45180-210 Operating Supplies$ 2,900 $ 58 $ 58 $ 2,842 2.00% E 101-45180-223 Structure Repair & Supplies$ 4,000 $ - $ - $ 4,000 0.00% E 101-45180-334 Licenses & Permits$ 1,000 $ - $ - $ 1,000 0.00% E 101-45180-361 Liability/Property Ins$ 835 $ - $ - $ 835 0.00% E 101-45180-381 Utilities-Electric & Gas$ 9,135 $ 929 $ 929 $ 8,206 10.17% E 101-45180-384 Refuse/Garbage Disposal$ - $ 240 $ 240 $ (240) 0.00% E 101-45180-385 Sewer Pumping & Maintenance$ 4,000 $ 1,201 $ 1,201 $ 2,799 30.03% E 101-45180-401 Building Maintenance/Repairs$ 15,000 $ 580 $ 580 $ 14,420 3.87% E 101-45180-404 Repair Machinery/Equipment$ 5,000 $ 290 $ 290 $ 4,710 5.81%Kitchen/HVACrepairandmaintenance 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% E 101-45180-438 Misc. Contractual$ 3,500 $ - $ - $ 3,500 0.00% E 101-45180-439 Refunds Issued$ - $ - $ - $ - 0.00% E 101-45180-520 Capital Improvements to Bldgs$ 9,900 $ - $ - $ 9,900 0.00%Building/Equipment Improvements E 101-45180-530 Capital Impr Other Than Bldgs$ - $ - #DIV/0! E 101-45180-570 Office Equipment$ - $ - #DIV/0! E 101-45180-720 Operating Transfers$ - $ - #DIV/0! Total Community Center Dept. Expenditures$ 80,515 $ 5,754 $ 5,754 $ 74,761 7.15% TOTAL GENERAL FUND EXPENDITURES$ 2,309,301 $ 271,713$ 271,713$ 2,037,588 11.77% E 101-49000-421 Cash Over/Short Operating TransfersE 101-49000-720 Operating Transfers$ 350,000 $ 350,000 $ (350,000) TOTAL GENERAL FUND EXPENDITURES W/TRANSFERS$ 2,309,301 $ 621,713 $ 621,713 $ 1,687,588 CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 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$ - $ - $ - $ - 0.00% R 225-46500-39203 Transfer from Other Funds$ - $ - $ - $ - 0.00% Total EDA Fund Revenue$ 5,400$ - $ -$ 5,4000.00% ExpenditureE 225-46500-210 Operating Supplies$ 300 $ - $ - $ 300 0.00% 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% E 225-46500-340 Advertising$ 1,500 $ - $ - $ 1,500 0.00% EDAM Membership; Sister City DuesE225-46500-433 Dues and Subscriptions$ 1,203 $ - $ - $ 1,203 0.00% E 225-46500-440 Events$ 1,500 $ - $ - $ 1,500 0.00% E 225-46500-720 Operating Transfers$ - $ - $ - $ - #DIV/0! Total EDA Fund Expenditures$ 4,603$ - $ -$ 4,6030.00% 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 $ 1,636 $ 1,636 $ 15,064 9.80% R 226-41950-38051 PEG Fees$ 4,400 $ 442 $ 442 $ 3,958 10.05% Total Cable TV Fund Revenue$ 21,200$ 2,078$ 2,078$ 19,1229.80% ExpenditureE 226-41950-240 Small Tools and Minor Equip$ 300 $ - $ - $ 300 0.00% E 226-41950-309 Software Support & Maintenance$ 3,500 $ 184 $ 184 $ 3,316 5.26% E 226-41950-438 Misc. Contractual$ 7,750 $ - $ - $ 7,750 0.00% E 226-41950-570 Office Equipment$ - $ - $ - $ - 0.00% Total Cable TV Fund Expenditures$ 11,550$ 184 $ 184$ 11,3661.59% GATEWAY TRAIL FUND RevenueR 230-45000-36230 Donations$ - $ - $ - $ - 0.00% ExpenditureE 230-45000-308 Other Professional Services$ - $ - $ - $ - 0.00% 2017 EQUIPMENT CERTIFICATES RevenueR 317-47000-31000 Washington Cty. Tax Settlement$ 34,524 $ - $ - $ 34,524 0.00% ExpenditureE 317-47000-601 Long Term Debt Principal$ 32,000 $ - $ - $ 32,000 0.00% E 317-47000-611 Long Term Debt Interest$ 880 $ - $ - $ 880 0.00% E 317-47000-620 Fiscal Agent s Fees$ - $ - $ - $ - 0.00% Total 2017 Fund Expenditures$ - $ 32,880$ -$ - #DIV/0! 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$ - $ - $ 345,634 0.00% 345,634 ExpenditureE 318-47000-601 Long Term Debt Principal$ 245,000 $ - $ - $ 245,000 0.00% E 318-47000-611 Long Term Debt Interest$ 84,175 $ - $ - $ 84,175 0.00% E 318-47000-620 Fiscal Agent s Fees$ 495 $ - $ - $ 495 0.00% Total 2018 Street Reconstruction Fund Expenditures$ 329,670$ - $ -$ 329,6700.00% CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments 2024 STREET RECONSTRUCTION RevenueR 324-47000-31000 Washington Cty. Tax Settlement$ - $ - $ - $ - 0.00% R 324-47000-36210 Interest Income$ - $ - $ - $ - 0.00% Total 2024 Street Reconstruction Fund Revenue$ - $ - $ -$ - #DIV/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 2018 Street Reconstruction Fund Expenditures$ 495 $ - $ -$ 495 0.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$ - $ - $ - #DIV/0! R 401-48000-36210 Interest Income$ 3,000 $ - $ - $ 3,000 0.00% Total Capital Improvement Fund Revenue$ 238,000$ - $ -$ 238,0000.00% 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$ - $ 7,098 $ 7,098 $ (7,098) 0.00%Gateway Trail Engineering E 401-48000-308 Other Professional Services$ - $ 2,400 $ 2,400 $ (2,400) 0.00%Gateway Trail Lobbying E 401-48000-312 Planning Services$ - $ - $ - $ - #DIV/0! E 401-48000-435 Misc Expense$ - $ - $ - $ - #DIV/0! E 401-48000-438 Misc. Contractual$ - $ - $ - $ - #DIV/0! 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 $ 9,498 $ 9,498 $ 468,051 1.99% PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$ 60,000 $ 60,000 0.00% R 404-48000-33422 Other State Grants & Aids$ - $ - #DIV/0! R 404-48000-34780 Park Dedication Fees$ - $ - #DIV/0! R 404-48000-36210 Interest Income$ 66 $ 66 0.00% R 404-48000-36230 Donations$ - $ - #DIV/0! Total Park Development Fund Revenue$ 60,066$ - $ -$ 60,0660.00% ExpenditureE 404-48000-312 Planning Services$ - $ - #DIV/0! E 404-48000-520 Capital Improvements to Bldgs$ - $ - #DIV/0! E 404-48000-530 Capital Impr Other Than Bldgs$ 150,000 $ 150,000 0.00% E 404-48000-720 Operating Transfers$ - $ - #DIV/0! Total Park Development Fund Expenditures$ 150,000$ - $ -$ 150,0000.00% 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 $ 10,000 $ 10,000 $ 857,000 1.15% E 406-48500-550 Motor Vehicles Capital$ 84,356 $ - $ - $ 84,356 0.00% Total Equipment Replacement Fund Expenditures$ 951,356$ 10,000$ 10,000 $ 941,3561.05% LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$ 375,000 $ - $ - $ 375,000 0.00% R 408-43100-33422 Other State Grants & Aids$ - $ - $ - $ - #DIV/0! R 408-43100-36210 Interest Income$ 10,705 $ - $ - $ 10,705 0.00% R 408-43100-39310 Proceeds-Gen Obligation Bond$ 4,000,000 $ - $ - $ 4,000,000 0.00% Total LRIF Revenue$ 4,385,705 $ - $ -$ 4,385,705 0.00% ExpenditureE 408-43100-303 Engineering Fees$ 120,000 $ 23,284 $ 23,284 $ 96,717 19.40% E 408-43100-530 Capital Impr Other Than Bldgs$ 3,575,000 $ - $ - $ 3,575,000 0.00% Total LRIF Expenditures$ 3,695,000 $ 23,284 $ 23,284 $ 3,671,717 0.63% CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments 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 $ 894 $ 894 $ 124,336 0.71% R 602-43210-34402 Sewer Connection Fee$ - $ - $ - $ - 0.00% R 602-43210-36100 Special Assessments$ - $ - $ - $ - 0.00% R 602-43210-36102 Penalties and Interest$ - $ - $ - $ - 0.00% R 602-43210-36210 Interest Income$ 210 $ - $ - $ 210 0.00% Total Big Marine Sewer Revenue$ 125,860 $ 894 $ 894 $ 124,966 0.71% ExpenditureE 602-43210-101 Regular Wages & Salaries$ 17,458 $ 2,261 $ 2,261 $ 15,197 12.95% E 602-43210-120 Pension Expense$ - $ - $ - $ - 0.00% E 602-43210-121 PERA Coord. Employer Contribu.$ 1,309 $ 170 $ 170 $ 1,139 12.95% E 602-43210-122 FICA Employer Contribution$ 1,082 $ 136 $ 136 $ 946 12.53% E 602-43210-126 MEDICARE Employer Contribution$ 253 $ 32 $ 32 $ 221 12.53% E 602-43210-131 Employer Paid Health$ - $ - $ - $ - 0.00% E 602-43210-151 Worker s Comp Insurance Prem$ 525 $ 783 $ 783 $ (258) 149.14% E 602-43210-200 Office Supplies$ 91 $ 48 $ 48 $ 43 53.12% E 602-43210-210 Operating Supplies$ 700 $ 10 $ 10 $ 690 1.38% E 602-43210-240 Small Tools and Minor Equip$ 420 $ - $ - $ 420 0.00% Bliss Collector Permit RenewalE602-43210-303 Engineering Fees$ 7,718 $ 752 $ 752 $ 6,966 9.74% E 602-43210-304 Legal Services$ - $ - $ - $ - 0.00% E 602-43210-308 Other Professional Services$ 3,500 $ - $ - $ 3,500 0.00%Water/Wastewateranalyticaltesting E 602-43210-309 Software Support & Maintenance$ 910 $ - $ - $ 910 0.00%SCADA E 602-43210-317 Employee Training$ 980 $ - $ - $ 980 0.00% E 602-43210-321 Telephone$ 1,750 $ 131 $ 131 $ 1,619 7.46%SCADAdialers E 602-43210-322 Postage$ 420 $ - $ - $ 420 0.00% E 602-43210-331 Travel Expenses$ 525 $ - $ - $ 525 0.00% E 602-43210-334 Licenses & Permits$ 1,400 $ - $ - $ 1,400 0.00%WastewaterCertification/PermitRenewal E 602-43210-361 Liability/Property Ins$ 2,535 $ - $ - $ 2,535 0.00% E 602-43210-381 Utilities-Electric & Gas$ 2,100 $ 157 $ 157 $ 1,943 7.49%Connexus & Excel E 602-43210-385 Sewer Pumping & Maintenance$ 14,000 $ - $ - $ 14,000 0.00% E 602-43210-386 Operation & Maintenance$ 3,500 $ - $ - $ 3,500 0.00% E 602-43210-404 Repair Machinery/Equipment$ 11,200 $ - $ - $ 11,200 0.00%Pumpandcontrolrepair/replacement 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 $ 1,830 $ 1,830 $ 5,170 26.15% E 602-43210-439 Refunds Issued$ - $ - $ - $ - 0.00% E 602-43210-530 Capital Impr Other Than Bldgs$ 6,930 $ - $ - $ 6,930 0.00% Total BLISS Sewer Expenditures$ 127,606$ 6,309$ 6,309$ 121,2974.94% CITY OF SCANDIA Revenue - Expenditure Summary JANUARY 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$ 22,400 $ - $ - $ 22,400 0.00% R 612-43210-36210 Interest Income$ 50 $ - $ - $ 50 0.00% Total Uptown Sewer Revenue$ 22,450$ - $ -$ 22,4500.00% ExpenditureE 612-43210-101 Regular Wages & Salaries$ 10,725 $ 922 $ 922 $ 9,803 8.60% E 612-43210-120 Pension Expense$ - $ - $ - $ - 0.00% E 612-43210-121 PERA Coord. Employer Contribu.$ 804 $ 69 $ 69 $ 735 8.60% E 612-43210-122 FICA Employer Contribution$ 665 $ 55 $ 55 $ 610 8.32% E 612-43210-126 MEDICARE Employer Contribution$ 156 $ 13 $ 13 $ 143 8.30% E 612-43210-151 Worker s Comp Insurance Prem$ 300 $ 522 $ 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 $ 310 $ 441 41.27%WastewaterAnalyticaltesting E 612-43210-309 Software Support & Maintenance$ 84 $ - $ - $ 84 0.00% E 612-43210-317 Employee Training$ 200 $ - $ - $ 200 0.00% 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 $ - $ - $ 250 0.00% E 612-43210-361 Liability/Property Ins$ 502 $ - $ - $ 502 0.00% E 612-43210-381 Utilities-Electric & Gas$ 1,000 $ 118 $ 118 $ 882 11.83% 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 $ 449 $ 1,051 29.92%LiftStationInspection/PumpTesting E 612-43210-530 Capital Impr Other Than Bldgs$ 9,900 $ - $ - $ 9,900 0.00%PumpReplacement E 612-43210-720 Operating Transfers$ 2,640 $ - $ - $ 2,640 0.00% Total Uptown Sewer Expenditures$ 42,526$ 2,458$ 2,458$ 40,0685.78% A-E SEWER RevenueR 624-43210-31952 SA Penalties & Interest$ 180 $ - $ - $ 180 0.00% R 624-43210-34401 Sewer User Fees$ 53,670 $ - $ - $ 53,670 0.00% R 624-43210-36210 Interest Income$ 90 $ - $ - $ 90 0.00% Total A-E Sewer Revenue$ 53,940 $ - $ - $ 53,940 0.00% 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 $ - $ - $ 39 0.00% 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 $ 310 $ 1,191 20.63% E 624-43210-309 Software Support & Maintenance$ 390 $ - $ - $ 390 0.00% E 624-43210-317 Employee Training$ 420 $ - $ - $ 420 0.00% E 624-43210-321 Telephone$ 750 $ 120 $ 120 $ 630 16.04% E 624-43210-322 Postage$ 180 $ - $ - $ 180 0.00% E 624-43210-331 Travel Expenses$ 225 $ - $ - $ 225 0.00% E 624-43210-334 Licenses & Permits$ 600 $ - $ - $ 600 0.00% E 624-43210-361 Liability/Property Ins$ 1,086 $ - $ - $ 1,086 0.00% E 624-43210-381 Utilities-Electric & Gas$ 900 $ 42 $ 42 $ 858 4.63% 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 $ - $ - $ 4,800 0.00% 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 $ 624 $ 624 $ 2,376 20.81% E 624-43210-530 Capital Impr Other Than Bldgs$ 2,970 $ - $ - $ 2,970 0.00% E 602-43210-438 Misc. Contractual$ - $ - $ - $ - #DIV/0! E 602-43210-439 Refunds Issued$ - $ - $ - $ - #DIV/0! E 602-43210-530 Capital Impr Other Than Bldgs$ - $ - $ - $ - #DIV/0! Total A-E Sewer Expenditures$ 51,380$ 1,096$ 1,096$ 50,2842.13%