Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06.b Treasurer's Report
City 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%