Loading...
06.b Treasurer's ReportCity of Scandiaaug Treasurer’sReport 6/31/2024 FUNDACCOUNTING Beginning CashBalance $ 6,373,515.606/2/2024 BeginningCheckingBalance$ 90,168.27 CheckingReceipts 80,684.12 Transfers toChecking 975,000.00 TotalDeposits 1,055,684.12 Expenditures 934,189.97)CASHBALANCES6/30/2024 Payroll$ (47,616.13) TransferstoMoneyMarket$ - G101-10100GENERAL FUND$ 707,262.05 TotalPayments 981,806.10)G203-10100COVID-19RELIEF$ 466,422.00 G225-10100EDA$ 37,320.23 Ending CheckingBalance 164,046.29 G226-10100CABLE TV$ 26,530.39 G230-10100GATEWAY TRAIL$ - Beginning MoneyMarketBalance 283,225.49 G 240-10100PUBLIC SAFETYAID$ 176,529.00 MoneyMarketReceipts 40.15G 313-101002013 EQUIP CERT$ 31,943.24 TransfertoChecking 275,000.00)G318-101002018 EQUIPCERT$ 19,258.68 TransferfromChecking G324-101002024ROADPROJECTS$ 3,888,689.62 G401-10100CAPITALIMPROVEMENT$ 780,239.70 EndingMoneyMarket Balance 8,265.64G404-10100PARKDEVELOPMENT$ 50,500.57 G406-10100EQUIPMENT REPLACE$ (147,640.18) BeginningInvestmentsBalance 6,006,282.10G 408-10100LRIF-$602,734.23 Investments Receipts-Interest 27,941.67G602-10100BLISS SEWER$ (8,368.20) 700,000.00)G612-10100UPTOWN SEWER$ 20,633.15TransferstoChecking EndingInvestmentsBalance$ 5,334,223.77G624-10100A-E SEWER$ 22,412.44 G801-10100$ 27,965.77ESCROW Outstanding Checks$ 5,496,964.239,571.47) 6/31/2024$ - EndingCashBalance $ 5,496,964.23 CHECKING, MONEYMARKET & INVESTMENTCD's Checking *102$ 90,168.27BegBal Credits$ 1,055,684.12 Debits$ (981,806.10) ReceiptinTransit 164,046.29EndBal MoneyMarket *105 - Rate1.25%$ 283,225.49BegBal ratechangefrom .25% Credits 40.15 Debits 275,000.00) EndBal$ 8,265.64 Investments CD *4422 - Rate5.10% 12mo., 3/25/2025$ 334,924.96 CD *4424 - Rate4.50% 12mo., 7/27/2024 $ 467,924.54 CD *4425 - Rate5.10% 9mo., 9/28/2024$ 784,855.35 CD *4426 - Rate5.10% 9mo., 10/30/2024 557,829.30 BondProceeds 3,188,689.62 TotalInvestments$ 5,334,223.77 TotalBank & Investment Accounts 5,506,535.70 9,571.47) ChecksinTransit *3102 5,496,964.23TotalAdjustedUndesignatedFunds TotalFunds$ 5,496,964.23 CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERALFUND RevenueR101-41000-31000 WashingtonCty. TaxSettlement$ 1,865,916 $ - $ - $ 1,865,916 0.00% Distributed July 1and Dec. 1 R101-41000-31040 Fiscal Disparities$ 107,857 $ - $ - $ 107,857 0.00% R101-41000-31701 GravelTaxes$ 20,000 $ - $ - $ 20,000 0.00% R101-41000-31830 SolarEnergyProduction Tax$ 5,500 $ - $ - $ 5,500 0.00% R101-41000-31900 Penalties & InterestDelTax$ 1,000 $ - $ - $ 1,000 0.00% R101-41000-32150 ROWUtilityPermit$ 5,000 $ 2,100 $ - $ 2,900 42.00% R101-41000-32180 Tobacco & LiquorLicenses$ 11,000 $ 1,150 $ - $ 9,850 10.45% R101-41000-32190 OtherCityPermits$ 3,000 $ 1,169 $ 400 $ 1,831 38.97% R101-41000-32210 BuildingPermits$ 160,000 $ 77,554 $ 18,018 $ 82,446 48.47% R101-41000-32260 GamblingPermits$ 100 $ 130 $ 15 $ (30)130.00% R101-41000-33401 LGA/MVHC/AG/PERAAid$ 7,000 $ - $ - $ 7,000 0.00% R101-41000-33420 FireReliefStatePERA$ 40,474 $ - $ - $ 40,474 0.00% Fire Training Grants; $5k Street R101-41000-33422 OtherStateGrants & Aids$ 6,000 $ 13,493 $ 1,893 $ (7,493)224.89% Sweeping Grant R101-41000-33428 PILOT$ 6,000 $ - $ - $ 6,000 0.00% R 101-41000-33620 Recycling Grant$ 11,000 $ 8,164 $ - $ 2,836 74.22% R101-41000-33630 Local GovtGrants & Aids$ 10,000 $ 10,228 $ - $ (228) 102.28%Washington County Dive Gear Grant R101-41000-33640 OtherGrants$ 1,200 $ - $ - $ 1,200 0.00% R101-41000-34103 ZoningandPlanning$ 5,000 $ 4,700 $ 450 $ 300 94.00% R101-41000-34107 AssessmentSearchFees$ 20 $ - $ - $ 20 0.00% R101-41000-34109 WaterUsage$ 100 $ - $ - $ 100 0.00% R101-41000-34202 FireProtectionServices$ 33,915 $ 35,816 $ - $ (1,901) 105.61%Town of May Fire Service Contract R101-41000-34301 DamageRepairs$ - $ 3,070 $ - $ (3,070) 0.00% R101-41000-34303 DustControl$ 3,630 $ 2,673 $ 2,386 $ 957 73.63% R101-41000-34304 ReimbursementforServices$ 1,000 $ 900 $ - $ 100 90.00% FLCC bookkeeping services $3,600/yr. R101-41000-34305 OtherStreetServices$ - $ - $ - $ - 0.00% R101-41000-34730 AdRevenue$ 1,000 $ 450 $ 150 $ 550 45.00% R101-41000-34750 FacilitiesRental$ 7,400 $ 3,445 $ 327 $ 3,955 46.56% R101-41000-34760 CleaningFees$ - $ - $ - $ - 0.00% R101-41000-34790 RecreationPrograms$ 1,500 $ 1,189 $ - $ 311 79.28% R101-41000-35101 Fines & Forfeitures$ 7,000 $ 2,260 $ 287 $ 4,740 32.28% R101-41000-36210 InterestIncome$ 5,636 $ 46,251 $ 14,169 $ (40,615) 820.63% distributed among funds at EOY R101-41000-36230 Donations$ 7,195 $ 1,352 $ - $ 5,843 18.79% Vinterfest button donations R101-41000-36240 Insurance Dividend$ 4,000 $ - $ - $ 4,000 0.00% R101-41000-36250 Misc. Refund$ 2,000 $ 229 $ 87 $ 1,771 11.43% TotalGeneralFundRevenue$ 2,340,443 $ 216,323 $ 38,183 $ 2,124,120 9.24% OperatingTransfersR101-41000-39200 InterfundOperating Transfer$ - R101-49000-39203 TransferfromOtherFunds$ - 500,000.00$0.00($500,000.00) R101-49000-39204 MoneyMarketTransfer$ - 1,325,000.00$975,000.00($1,325,000.00) TotalOperatingTransfers$ 1,825,000$ 975,000$ (1,825,000) CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERALFUND ExpenditureADMINISTRATION & FINANCE E101-41000-101 RegularWages & Salaries$ 196,713 $ 75,361 $ 13,737 $ 121,352 38.31% E101-41000-121 PERACoord. EmployerContribu.$ 13,801 $ 6,289 $ 1,030 $ 7,512 45.57% E101-41000-122 FICAEmployerContribution$ 12,196 $ 4,929 $ 821 $ 7,267 40.42% E101-41000-126 MEDICAREEmployerContribution$ 2,852 $ 1,283 $ 192 $ 1,569 44.97% E101-41000-131 EmployerPaidHealth$ 46,482 $ 21,227 $ 3,147 $ 25,255 45.67% E101-41000-132 DentalInsurance$ 1,990 $ 895 $ 128 $ 1,095 44.99% E101-41000-134 EmployerPaidLife$ 643 $ 349 $ 50 $ 294 54.31% E101-41000-135 EmployerPaidDisability$ 960 $ 502 $ 72 $ 458 52.26% E101-41000-151 WorkersCompInsurance Prem$ 1,339 $ 1,837 $ - $ (498)137.19% E101-41000-200 OfficeSupplies$ 1,133 $ 420 $ 77 $ 713 37.11% E101-41000-203 Printed Forms & Papers$ 1,957 $ 1,874 $ - $ 83 95.78% E101-41000-210 OperatingSupplies$ 824 $ 329 $ 110 $ 495 39.93% E101-41000-301 AuditingandAcctgServices$ 27,000 $ 32,050 $ - $ (5,050)118.70% Accounting Assistance w/Audit E101-41000-303 EngineeringFees$ - $ (474) $ (237) $ 474 0.00% E101-41000-304 LegalServices$ 65,000 $ 15,110 $ 2,933 $ 49,890 23.25% E101-41000-306 PersonalTesting & Recruit$ - $ - $ - $ 0.00% American Legal Web Fee & OrdinanceE101-41000-308 Other ProfessionalServices$ 5,000 $ 1,747 $ - $ 3,253 34.94% Updates E101-41000-309 SoftwareSupport & Maintenance$ 18,746 $ 7,244 $ 269 $ 11,502 38.64% E101-41000-316 Conferences & Seminars$ 721 $ 20 $ - $ 701 2.77% E101-41000-317 EmployeeTraining$ 206 $ - $ - $ 206 0.00% E101-41000-319 OtherServices$ 700 $ 85 $ (515) $ 615 12.14% E101-41000-321 Telephone$ 5,100 $ 2,636 $ 494 $ 2,464 51.70% E101-41000-322 Postage$ 2,200 $ 1,260 $ 26 $ 940 57.26% E101-41000-331 TravelExpenses$ 1,000 $ 148 $ - $ 852 14.77% E 101-41000-351 Legal Notices Publishing$ 1,500 $ 1,318 $ - $ 182 87.85% E101-41000-361 Liability/Property Ins$ 11,516 $ 9,166 $ - $ 2,350 79.60% E101-41000-365 InsuranceClaims$ 1,000 $ - $ - $ 1,000 0.00% E101-41000-381 Utilities-Electric & Gas$ 12,000 $ 3,287 $ 1,059 $ 8,713 27.39% E101-41000-413 EquipmentRental$ 1,800 $ 714 $ 30 $ 1,086 39.65% E101-41000-430 Recycling$ - $ 20 $ - $ (20) 0.00% E101-41000-433 DuesandSubscriptions$ 5,000 $ 90 $ - $ 4,910 1.80% E101-41000-434 YouthServiceBureau$ 5,500 $ - $ - $ 5,500 0.00% E101-41000-435 MiscExpense$ - $ 7 $ - $ (7) 0.00% Annual website host & maintenance; E101-41000-438 Misc. Contractual$ 4,120 $ 2,198 $ - $ 1,923 53.34% ABDO help E101-41000-439 RefundsIssued$ - $ - $ - $ - 0.00% E101-41000-560 FurnitureandFixtures$ - $ 233 $ - $ (233)0.00% E101-41000-570 OfficeEquipment$ 1,500 $ 34 $ - $ 1,466 2.27% TotalAdmin & FinanceDept. Expenditures$ 450,499$ 192,188$ 23,424$ 258,31142.66% CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERALFUNDCONT.CITYCOUNCIL ExpendituresE101-41110-101 RegularWages & Salaries$ 20,772 $ 5,193 $ - $ 15,579 25.00% E101-41110-122 FICAEmployerContribution$ 1,288 $ 123 $ - $ 1,165 9.55% E101-41110-126 MEDICAREEmployerContribution$ 301 $ 23 $ - $ 278 7.72% E101-41110-127 PERADefined$ 703 $ 160 $ - $ 543 22.82% E101-41110-151 WorkersCompInsurance Prem$ 100 $ 52 $ - $ 48 52.00% E101-41110-308 Other ProfessionalServices$ - $ - $ - $ 0.00% E101-41110-316 Conferences & Seminars$ 350 $ 30 $ 30 $ 320 8.57% E101-41110-331 TravelExpenses$ - $ - $ - $ - 0.00% E101-41110-560 FurnitureandFixtures$ - $ - $ - $ - 0.00% E101-41110-570 OfficeEquipment$ - $ - $ - $ - 0.00% TotalCityCouncilDept. Expenditures$ 23,514 $ 5,582 $ 30 $ 17,932 23.74% ELECTIONS ExpendituresE 101-41410-199 Election Judge$ 5,400 $ 1,750 $ - $ 3,650 32.41% E101-41410-200 OfficeSupplies$ 50 $ 28 $ - $ 22 55.70% E101-41410-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E101-41410-210 OperatingSupplies$ 750 $ 304 $ - $ 446 40.49% E101-41410-351 LegalNoticesPublishing$ 200 $ 15 $ - $ 185 7.72% E101-41410-413 EquipmentRental$ 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 ExpendituresE101-41910-101 RegularWages & Salaries$ 60,010 $ 27,639 $ 4,489 $ 32,371 46.06% E101-41910-121 PERACoord. EmployerContribu.$ 4,263 $ 2,071 $ 337 $ 2,192 48.58% E101-41910-122 FICAEmployerContribution$ 3,721 $ 1,617 $ 265 $ 2,104 43.46% E101-41910-126 MEDICAREEmployerContribution$ 870 $ 403 $ 62 $ 467 46.28% E101-41910-131 EmployerPaidHealth$ 17,353 $ 9,080 $ 1,345 $ 8,273 52.32% E101-41910-132 DentalInsurance$ 724 $ 384 $ 55 $ 340 53.00% E101-41910-134 EmployerPaidLife$ 173 $ 101 $ 14 $ 72 58.27% E101-41910-135 EmployerPaidDisability$ 416 $ 242 $ 35 $ 174 58.27% E101-41910-203 Printed Forms & Papers$ 100 $ - $ - $ 100 0.00% E101-41910-311 ContractPermitInspections$ 60,000 $ 21,973 $ 2,979 $ 38,027 36.62% E101-41910-312 PlanningServices$ 60,000 $ 24,372 $ 18,471 $ 35,629 40.62% E101-41910-313 Committee & CommissionReimbur$ 5,200 $ 2,600 $ 1,300 $ 2,600 50.00% E101-41910-316 Conferences & Seminars$ - $ 30 $ - $ (30)0.00% E101-41910-319 OtherServices$ - $ - $ - $ - 0.00% E101-41910-361 Liability/Property Ins$ 5,563 $ 4,937 $ - $ 626 88.75% E101-41910-438 Misc. Contractual$ 5,000 $ 1,006 $ - $ 3,994 20.12% E101-41910-439 RefundsIssued$ - $ - $ - $ - 0.00% E101-41910-720 OperatingTransfers$ - $ - $ - $ - 0.00% TotalPlanning & BuildingDept. Expenditures$ 223,393 $ 96,454 $ 29,351 $ 126,939 43.18% ASSESSOR ExpendituresE 101-41960-300 Assessor$ 23,200 $ 11,260 $ 2,060 $ 11,940 48.53% POLICE ExpendituresE101-42100-318 Police Contract$ 183,442 $ - $ - $ 183,442 0.00% E101-42100-319 OtherServices$ 960 $ - $ - $ 960 0.00% Code Red System TotalGFPoliceDept. Expenditures$ 184,402 $ - $ - $ 184,402 0.00% CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERALFUNDCONT.FIRE ExpendituresE101-42200-101 RegularWages & Salaries$ 160,554 $ 83,852 $ 19,784 $ 76,702 52.23% E101-42200-121 PERACoord. EmployerContribu.$ - $ - $ - $ 0.00% E101-42200-122 FICAEmployerContribution$ 9,954 $ 5,428 $ 1,160 $ 4,526 54.53% E101-42200-124 Police & FirePERA$ 8,983 $ 4,696 $ 796 $ 4,287 52.28% E101-42200-126 MEDICAREEmployerContribution$ 2,328 $ 849 $ 290 $ 1,479 36.46% E101-42200-134 EmployerPaidLife$ 192 $ 112 $ 16 $ 80 58.33% E101-42200-135 EmployerPaidDisability$ - $ - $ - $ - 0.00% E101-42200-141 Unemployment Compensation$ - $ - $ - $ -0.00% E101-42200-151 WorkersCompInsurance Prem$ 12,000 $ 6,249 $ - $ 5,751 52.08% E101-42200-200 OfficeSupplies$ 200 $ 150 $ - $ 50 75.00% E101-42200-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E101-42200-209 MedicalSupplies$ 3,500 $ 133 $ - $ 3,367 3.80% E101-42200-210 OperatingSupplies$ 8,800 $ 942 $ 206 $ 7,858 10.71% E 101-42200-211 Cleaning Supplies$ 100 $ - $ - $ 100 0.00% E101-42200-212 Fuel$ 4,000 $ 1,764 $ 580 $ 2,236 44.10% E101-42200-217 Uniforms & SafetyEquipment$ 10,000 $ 16,322 $ 2,850 $ (6,322) 163.22% E101-42200-221 EquipmentParts$ 1,500 $ - $ - $ 1,500 0.00% E101-42200-222 Tires$ - $ - $ - $ - 0.00% E101-42200-223 StructureRepair & Supplies$ 800 $ 6 $ - $ 794 0.81% E101-42200-240 SmallToolsandMinorEquip$ 22,195 $ 14,286 $ 78 $ 7,909 64.37% E101-42200-305 MedicalServices$ 5,600 $ 5,630 $ - $ (30) 100.54% E101-42200-306 PersonalTesting & Recruit$ 500 $ - $ - $ 500 0.00% E101-42200-309 SoftwareSupport & Maintenance$ 17,000 $ 5,969 $ 272 $ 11,031 35.11% E101-42200-310 MedicalTraining$ 2,000 $ 50 $ - $ 1,950 2.50% E101-42200-316 Conferences & Seminars$ 250 $ - $ - $ 250 0.00% E101-42200-317 EmployeeTraining$ 12,000 $ 2,505 $ - $ 9,495 20.87% E101-42200-319 OtherServices$ 500 $ 105 $ 105 $ 395 21.00% E101-42200-321 Telephone$ 7,000 $ 2,895 $ 534 $ 4,105 41.36% E101-42200-322 Postage$ - $ 18 $ - $ (18) 0.00% E101-42200-324 StateofMN-FireRelief$ 40,474 $ - $ - $ 40,474 0.00% E101-42200-325 CityMatch-FireRelief$ - $ - $ - $ - 0.00% E101-42200-331 TravelExpenses$ 2,000 $ 1,818 $ - $ 182 90.91% E101-42200-334 Licenses & Permits$ 500 $ - $ - $ 500 0.00% E101-42200-340 Advertising$ - $ - $ - $ - 0.00% E101-42200-361 Liability/Property Ins$ 7,339 $ 7,208 $ - $ 131 98.21% E101-42200-381 Utilities-Electric & Gas$ 8,000 $ 2,718 $ 87 $ 5,282 33.97% E101-42200-384 Refuse/GarbageDisposal$ - $ - $ - $ - 0.00% E101-42200-385 SewerPumping & Maintenance$ 550 $ 526 $ - $ 24 95.64% E101-42200-401 BuildingMaintenance/Repairs$ 3,500 $ 1,255 $ 424 $ 2,245 35.84% E101-42200-403 Improvements OtherThanBldgs$ - $ - $ - $ 0.00% E101-42200-404 RepairMachinery/Equipment$ 8,500 $ 6,314 $ 3,178 $ 2,186 74.28% E101-42200-407 WellRepair & Maintenance$ - $ - $ - $ -0.00% E101-42200-433 DuesandSubscriptions$ 3,200 $ 3,245 $ 1,735 $ (45) 101.42% E101-42200-438 Misc. Contractual$ 3,500 $ - $ - $ 3,500 0.00% E101-42200-440 Events$ 1,000 $ 148 $ 148 $ 852 14.84% E101-42200-520 CapitalImprovementstoBldgs$ - $ - $ - $ 0.00% E101-42200-530 CapitalImprOtherThanBldgs$ - $ - $ - $ 0.00% E101-42200-540 HeavyMachineryCapital$ - $ - $ - $ - 0.00% E101-42200-560 FurnitureandFixtures$ 500 $ 51 $ 51 $ 449 10.18% E101-42200-570 OfficeEquipment$ 900 $ 379 $ 200 $ 521 42.14% TotalFireDeptExpenditures$ 369,919 $ 175,623 $ 32,495 $ 194,296 47.48% ANIMALCONTROL ExpendituresE101-42700-314 Animal Control$ 6,000 $ 2,584 $ 295 $ 3,416 43.07% CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERALFUNDCONT.PUBLICWORKS ExpendituresE101-43000-101 RegularWages & Salaries$ 255,022 $ 128,078 $ 20,122 $ 126,944 50.22% E101-43000-102 OTRegularWages$ 5,014 $ 2,572 $ 208 $ 2,442 51.30% E101-43000-104 TemporaryEmployeeWages$ 2,262 $ 338 $ - $ 1,924 14.93% E101-43000-121 PERACoord. EmployerContribu.$ 19,503 $ 9,138 $ 1,525 $ 10,365 46.85% E101-43000-122 FICAEmployerContribution$ 16,262 $ 7,095 $ 1,197 $ 9,167 43.63% E101-43000-126 MEDICAREEmployerContribution$ 3,803 $ 1,811 $ 280 $ 1,992 47.62% E101-43000-131 EmployerPaidHealth$ 66,939 $ 34,297 $ 4,949 $ 32,642 51.24% E101-43000-132 DentalInsurance$ 1,164 $ 620 $ 88 $ 544 53.29% E101-43000-133Union TrainingCenter$ 1,872 $ 792 $ 216 $ 1,080 42.31% E101-43000-134 EmployerPaidLife$ 698 $ 414 $ 58 $ 284 59.29% E101-43000-135 EmployerPaidDisability$ 1,365 $ 810 $ 120 $ 555 59.33% E101-43000-141 Unemployment Compensation$ - $ - $ - $ -0.00% E101-43000-151 WorkersCompInsurance Prem$ 27,000 $ 22,615 $ - $ 4,385 83.76% E101-43000-200 OfficeSupplies$ 50 $ - $ - $ 50 0.00% E 101-43000-210 Operating Supplies$ 8,500 $ 4,189 $ 197 $ 4,311 49.28% E101-43000-212 Fuel$ 25,000 $ 9,710 $ 1,568 $ 15,290 38.84% E101-43000-217 Uniforms & SafetyEquipment$ 2,300 $ 866 $ 183 $ 1,434 37.66% E101-43000-221 EquipmentParts$ 17,000 $ 6,619 $ 11 $ 10,381 38.94% E101-43000-222 Tires$ 7,500 $ - $ - $ 7,500 0.00% E101-43000-223 StructureRepair & Supplies$ 2,000 $ - $ - $ 2,000 0.00% E101-43000-224 MaterialsforRoadMaintenance$ 7,000 $ 11,595 $ - $ (4,595)165.64% Cold Patch; New Streetlight Flags E101-43000-226 SignReplacementandRepair$ 750 $ - $ - $ 750 0.00% E101-43000-228 Gravel$ 10,000 $ 330 $ 330 $ 9,670 3.30% E101-43000-229 Salt$ 22,000 $ 12,375 $ 7,323 $ 9,625 56.25% E101-43000-240 SmallToolsandMinorEquip$ 8,000 $ 6,422 $ 4,450 $ 1,578 80.27% E101-43000-302 Surveying$ - $ - $ - $ - 0.00% E101-43000-303 EngineeringFees$ 10,500 $ 6,918 $ (3,526) $ 3,583 65.88% E101-43000-304 LegalServices$ - $ - $ - $ - 0.00% E101-43000-305 MedicalServices$ 1,000 $ - $ - $ 1,000 0.00% E101-43000-309 SoftwareSupport & Maintenance$ 6,000 $ 200 $ 200 $ 5,800 3.33% E101-43000-317 EmployeeTraining$ 1,500 $ 459 $ - $ 1,041 30.63% E101-43000-319 OtherServices$ 7,000 $ 4,115 $ 3,590 $ 2,885 58.78% E101-43000-321 Telephone$ 4,000 $ 2,132 $ 356 $ 1,868 53.30% Travel to Arborist workshop & Water E101-43000-331 TravelExpenses$ 500 $ 291 $ - $ 209 58.14%School E101-43000-334 Licenses & Permits$ 500 $ - $ - $ 500 0.00% E101-43000-361 Liability/Property Ins$ 8,766 $ 9,713 $ - $ (947) 110.80% E101-43000-365 InsuranceClaims$ - $ - $ - $ - 0.00% E101-43000-381 Utilities-Electric & Gas$ 6,000 $ 1,917 $ 89 $ 4,083 31.96% E101-43000-384 Refuse/GarbageDisposal$ - $ - $ - $ - 0.00% holding tank & floor drainoil separator E101-43000-385 SewerPumping & Maintenance$ 1,500 $ 2,285 $ - $ (785)152.35% tank pumping E101-43000-387 Street LightUtilities$ 4,200 $ 1,797 $ 311 $ 2,403 42.78% E101-43000-401 BuildingMaintenance/Repairs$ 6,000 $ 1,775 $ 198 $ 4,225 29.58% E101-43000-403 Improvements OtherThanBldgs$ - $ - $ - $ 0.00% E101-43000-404 RepairMachinery/Equipment$ 25,000 $ 3,349 $ - $ 21,651 13.40% E101-43000-405 ContractualRoadMaint/Repair$ 200,000 $ 73,536 $ 44,047 $ 126,464 36.77% E101-43000-407 WellRepair & Maintenance$ 500 $ - $ - $ 500 0.00% E101-43000-413 EquipmentRental$ 4,000 $ 26 $ - $ 3,974 0.65% E101-43000-417 UniformRental$ 1,200 $ 439 $ 83 $ 761 36.61% E101-43000-433 DuesandSubscriptions$ 200 $ - $ - $ 200 0.00% E101-43000-438 Misc. Contractual$ 16,000 $ - $ - $ 16,000 0.00% E101-43000-439 RefundsIssued$ - $ - $ - $ - 0.00% E101-43000-530 CapitalImprOtherThanBldgs$ 9,900 $ - $ - $ 9,900 0.00% E101-43000-550 MotorVehiclesCapital$ - $ - $ - $ - 0.00% E101-43000-560 FurnitureandFixtures$ 1,000 $ - $ - $ 1,000 0.00% E101-43000-570 OfficeEquipment$ - $ 487 $ - $ (487) 0.00% E101-43000-720 OperatingTransfers$ - $ - $ - $ - 0.00% TotalPublicWorksDept. Expenditures$ 826,270 $ 370,123 $ 88,174 $ 456,147 44.79% CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERALFUNDCONT.PARKS & RECREATION ExpendituresE101-45000-101 RegularWages & Salaries$ 11,328 $ 5,061 $ 846 $ 6,267 44.68% E101-45000-104 TemporaryEmployeeWages$ 39,985 $ 5,667 $ 2,556 $ 34,318 14.17% E101-45000-121 PERACoord. EmployerContribu.$ 850 $ 379 $ 63 $ 471 44.58% E101-45000-122 FICAEmployerContribution$ 3,181 $ 644 $ 208 $ 2,537 20.26% E101-45000-126 MEDICAREEmployerContribution$ 744 $ 157 $ 49 $ 587 21.14% E101-45000-131 EmployerPaidHealth$ 2,562 $ 1,177 $ 189 $ 1,385 45.95% E101-45000-132 DentalInsurance$ 42 $ 19 $ 3 $ 23 45.71% E101-45000-134 EmployerPaidLife$ 27 $ 16 $ 2 $ 11 58.07% E101-45000-135 EmployerPaidDisability$ 76 $ 32 $ 5 $ 44 41.50% E101-45000-141 Unemployment Compensation$ - $ - $ - $ -0.00% E101-45000-151 WorkersCompInsurance Prem$ 2,700 $ 2,251 $ - $ 449 83.37% E101-45000-200 OfficeSupplies$ 100 $ - $ - $ 100 0.00% E101-45000-203 Printed Forms & Papers$ 200 $ - $ - $ 200 0.00% E101-45000-210 OperatingSupplies$ 1,000 $ 444 $ 157 $ 556 44.39% E101-45000-212 Fuel$ 1,000 $ 138 $ - $ 862 13.80% E101-45000-221 EquipmentParts$ 2,500 $ 436 $ 37 $ 2,064 17.42% E101-45000-223 StructureRepair & Supplies$ 2,500 $ 138 $ 30 $ 2,362 5.52% E101-45000-240 SmallToolsandMinorEquip$ 500 $ - $ - $ 500 0.00% E 101-45000-312 Planning Services$ - $ - $ - $ - 0.00% E101-45000-313 Committee & CommissionReimbur$ - $ 480 $ 240 $ 480) 0.00% E101-45000-319 OtherServices$ 1,750 $ 1,019 $ 468 $ 731 58.24% E101-45000-322 Postage$ - $ - $ - $ - 0.00% E101-45000-340 Advertising$ - $ 275 $ - $ (275) 0.00% E101-45000-353 Sales& UseTax$ - $ - $ - $ - 0.00% E101-45000-361 Liability/Property Ins$ 3,489 $ 5,333 $ - $ (1,844) 152.86% E101-45000-381 Utilities-Electric & Gas$ 6,500 $ 1,454 $ 280 $ 5,046 22.37% E101-45000-384 Refuse/GarbageDisposal$ 5,000 $ 1,659 $ 499 $ 3,341 33.19% E101-45000-385 SewerPumping & Maintenance$ 1,250 $ 191 $ - $ 1,059 15.31% Lighted ballfield fence repair - insurance E101-45000-401 BuildingMaintenance/Repairs$ 6,000 $ 3,977 $ 120 $ 2,023 66.28% reimbursed E101-45000-403 Improvements OtherThanBldgs$ 2,500 $ 716 $ 716 $ 1,784 28.63% E101-45000-404 RepairMachinery/Equipment$ 1,000 $ 380 $ - $ 620 38.01% E101-45000-406 GroundsCare$ 4,000 $ 1,174 $ 1,102 $ 2,826 29.34% E101-45000-438 Misc. Contractual$ 8,000 $ 3,148 $ 935 $ 4,852 39.35% E101-45000-439 RefundsIssued$ - $ - $ - $ - 0.00% E101-45000-440 Events$ 7,000 $ 1,334 $ - $ 5,666 19.06% E101-45000-490 Financial Assistance$ - $ - $ - $ - 0.00% E101-45000-530 CapitalImprOtherThanBldgs$ 9,900 $ 1,800 $ - $ 8,100 18.18% E101-45000-720 OperatingTransfers$ - $ - $ - $ - 0.00% TotalParks & RecDept. Expenditures$ 125,684 $ 39,499 $ 8,505 $ 86,185 31.43% CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments GENERALFUNDCONT.COMMUNITY CENTER ExpendituresE101-45180-101 RegularWages & Salaries$ 16,600 $ 7,435 $ 1,244 $ 9,165 44.79% E101-45180-104 TemporaryEmployeeWages$ - $ - $ - $ - 0.00% E101-45180-121 PERACoord. EmployerContribu.$ 1,245 $ 557 $ 93 $ 688 44.72% E101-45180-122 FICAEmployerContribution$ 1,029 $ 430 $ 73 $ 599 41.77% E101-45180-126 MEDICAREEmployerContribution$ 241 $ 110 $ 17 $ 131 45.70% E101-45180-131 EmployerPaidHealth$ 3,692 $ 1,583 $ 266 $ 2,109 42.88% E101-45180-134 EmployerPaidLife$ 43 $ 25 $ 4 $ 18 58.60% E101-45180-135 EmployerPaidDisability$ 95 $ 60 $ 9 $ 35 62.89% E101-45180-151 WorkersCompInsurance Prem$ - $ 152 $ - $ 152) 0.00% E101-45180-210 OperatingSupplies$ 2,900 $ 783 $ 155 $ 2,117 27.00% E101-45180-223 StructureRepair & Supplies$ 4,000 $ 236 $ - $ 3,764 5.91% E101-45180-334 Licenses & Permits$ 1,000 $ 955 $ 40 $ 45 95.50% E101-45180-361 Liability/Property Ins$ 835 $ 801 $ - $ 34 95.89% E101-45180-381 Utilities-Electric & Gas$ 9,135 $ 3,560 $ 389 $ 5,575 38.97% E101-45180-384 Refuse/GarbageDisposal$ - $ 124 $ - $ (124)0.00% E101-45180-385 SewerPumping & Maintenance$ 4,000 $ 1,260 $ - $ 2,740 31.50% E101-45180-401 BuildingMaintenance/Repairs$ 15,000 $ 5,258 $ 630 $ 9,742 35.05% E101-45180-404 RepairMachinery/Equipment$ 5,000 $ 125 $ - $ 4,875 2.49% E 101-45180-406 Grounds Care$ 1,300 $ 117 $ 117 $ 1,183 9.00% E101-45180-407 WellRepair & Maintenance$ 1,000 $ - $ - $ 1,000 0.00% Seasonal lightingE101-45180-438 Misc. Contractual$ 3,500 $ 1,500 $ - $ 2,000 42.86% E101-45180-439 RefundsIssued$ - $ - $ - $ - 0.00% E101-45180-520 CapitalImprovementstoBldgs$ 9,900 $ - $ - $ 9,900 0.00% E101-45180-530 CapitalImprOtherThanBldgs$ - $ - $ - $ 0.00% E101-45180-570 OfficeEquipment$ - $ - $ - $ - 0.00% E101-45180-720 OperatingTransfers$ - $ - $ - $ - 0.00% TotalCommunityCenterDept. Expenditures$ 64,490 $ 36,808 $ 3,492 $ 27,682 57.08% TOTALGENERALFUNDEXPENDITURES$ 2,321,496 $ 729,757 $ 214,919 $ 1,403,273 27.37% E101-49000-421 CashOver/Short$ - $ 0.01 $ - $ (0.01) 0.00% OperatingTransfersE101-49000-720 OperatingTransfers$ - $ 1,825,000 $ 975,000 $ (1,825,000)0.00% TOTALGENERALFUNDEXPENDITURESW/TRANSFERS$ 2,321,496 $ 1,579,757 $ 714,919 $ 553,273 CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments COVIDRELIEFFUND RevenueR203-46200-33150 FederalGrant$ - $ - $ - $ - 0.00% ExpendituresE203-49000-720OperatingTransfers$ - $ - $ - $ EDAFUND RevenueR225-46500-31000 WashingtonCty. TaxSettlement$ 5,300 $ - $ - $ 5,300 0.00% R225-46500-33640 OtherGrants$ - $ - $ - $ - 0.00% R225-46500-34750 FacilitiesRental$ - $ - $ - $ - 0.00% R225-46500-36210 InterestIncome$ 100 $ - $ - $ 100 0.00% R225-46500-36230 Donations$ - $ 310 $ - $ (310) 0.00% R225-46500-39200 InterfundOperating Transfer$ - $ 33,356 $ - $ (33,356)0.00% closed checking account TotalEDAFund Revenue$ 5,400$ 33,666 $ -$ (28,266)623.45% ExpenditureE225-46500-210 OperatingSupplies$ 300 $ 23 $ - $ 277 7.74% E225-46500-303 EngineeringFees$ - $ - $ - $ - 0.00% E225-46500-304 LegalServices$ - $ - $ - $ - 0.00% E225-46500-308 Other ProfessionalServices$ 100 $ - $ - $ 100 0.00% EDAM Membership; Sister City DuesE225-46500-340 Advertising$ 1,500 $ - $ - $ 1,500 0.00% E225-46500-433 DuesandSubscriptions$ 1,203 $ 364 $ - $ 839 30.26% E225-46500-440 Events$ 1,500 $ 310 $ 310 $ 1,190 20.67% E225-46500-720 OperatingTransfers$ - $ 33,356 $ - $ (33,356) 0.00% closed checking account TotalEDAFundExpenditures$ 4,603$ 34,030 $ 310$ (29,450)739.30% CABLETVFUND RevenueR226-41950-36210 Interest Income$ 100 $ - $ - $ 100 0.00% R226-41950-36260 SaleofEquipment$ - $ - $ - $ - 0.00% R226-41950-38050 Cable TVFranchise Rebates$ 16,700 $ 8,339 $ 1,652 $ 8,361 49.93% R226-41950-38051 PEG Fees$ 4,400 $ 2,170 $ 432 $ 2,230 49.32% TotalCableTVFundRevenue$ 21,200 $ 10,509 $ 2,084 $ 10,69149.57% ExpenditureE226-41950-240 SmallToolsandMinorEquip$ 300 $ - $ - $ 300 0.00% E226-41950-309 SoftwareSupport & Maintenance$ 3,500 $ 2,187 $ 163 $ 1,313 62.49% E226-41950-438 Misc. Contractual$ 7,750 $ 3,170 $ 1,860 $ 4,580 40.90% E226-41950-570 OfficeEquipment$ - $ - $ - $ - 0.00% TotalCableTVFundExpenditures$ 11,550 $ 5,357$ 2,023 $ 6,193 46.38% GATEWAYTRAILFUND RevenueR230-45000-36230 Donations$ - $ - $ - $ - 0.00% ExpenditureE 230-45000-308 Other Professional Services$ - $ - $ - $ 0.00% CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments 2018STREETRECONSTRUCTION RevenueR318-47000-31000 WashingtonCty. TaxSettlement$ 342,546 $ - $ - $ 342,546 0.00% ExpenditureE318-47000-601 LongTermDebtPrincipal$ 245,000 $ - $ - $ 245,000 0.00% E318-47000-611 LongTermDebtInterest$ 84,175 $ 42,088 $ - $ 42,087 50.00% E318-47000-620 FiscalAgentsFees$ 495 $ 1,045 $ 550 $ (550) 211.11% Total2018 StreetReconstructionFund Expenditures$ 329,670$ 43,133 $ 550$ 286,53713.08% 2024STREETRECONSTRUCTION RevenueR324-47000-31000 WashingtonCty. TaxSettlement$ - $ - $ - $ 0.00% R324-47000-36210InterestIncome$ - 0.00% Total2024 StreetReconstructionFund Expenditures$ - $ 3,888,690 $ 13,814 $ (3,888,690) 0.00% ExpenditureE324-47000-601 LongTermDebtPrincipal$ - $ - 0.00% E324-47000-611 LongTermDebtInterest$ - 0.00% E324-47000-620 FiscalAgentsFees$ 495 $ - $ 495 0.00% Total2024 StreetReconstructionFund Expenditures$ 495 $ - $ -$ 4950.00% CAPITALIMPROVEMENTS RevenueR401-48000-31000 WashingtonCty. TaxSettlement$ 235,000 $ - $ - $ 235,000 0.00% R401-48000-33422 OtherStateGrants & Aids$ - $ 34,110 $ 27,009 $ (34,110) 0.00% R401-48000-36210 InterestIncome$ 3,000 $ - $ - $ 3,000 0.00% TotalCapitalImprovementFundRevenue$ 238,000$ 34,110 $ 27,009$ 203,89014.33% ExpenditureE401-41000-312 PlanningServices$ - $ - $ - $ 0.00% E401-41000-520 CapitalImprovementstoBldgs$ - $ - $ - $ 0.00% E401-41000-530 CapitalImprOtherThanBldgs$ 250,000 $ - $ - $ 250,000 0.00% E401-42200-520 CapitalImprovementstoBldgs$ - 0.00% E401-45180-520 CapitalImprovementstoBldgs$ 67,548 $ - $ - $ 67,548 0.00% E401-48000-303 EngineeringFees$ - $ 24,222 $ 895 $ (24,222) 0.00% Gateway Trail Engineering E401-48000-308 Other ProfessionalServices$ - $ 2,400 $ 2,400 $ (2,400)0.00% Gateway Trail Lobbying E401-48000-435 MiscExpense$ - $ - $ - $ - 0.00% E401-48000-438 Misc. Contractual$ - $ - $ - $ - 0.00% E401-48000-520 CapitalImprovementstoBldgs$ - $ - $ - $ 0.00% E401-48000-530 CapitalImprOtherThanBldgs$ 160,000 $ - $ - $ 160,000 0.00% 477,548 $ 26,622 $ 3,295 $ 450,926 5.57% PARKDEVELOPMENT RevenueR404-48000-31000 WashingtonCty. TaxSettlement$ 60,000 $ - $ - $ 60,000 0.00% R404-48000-33422 OtherStateGrants & Aids$ - $ 101,250 $ - $ (101,250) 0.00%2023 Playground grant R404-48000-34780 ParkDedicationFees$ - $ - $ - $ - 0.00% R404-48000-36210 InterestIncome$ 66 $ - $ - $ 66 0.00% R404-48000-36230 Donations$ - $ - $ - $ - 0.00% TotalParkDevelopment FundRevenue$ 60,066 $ 101,250$ -$ (41,184)168.56% ExpenditureE 404-48000-303EngineeringFees$ - $ 38,681$ 19,533 $ (39,681)0.00% E404-48000-312 PlanningServices$ - $ - $ - $ - 0.00% E404-48000-520 CapitalImprovementstoBldgs$ - $ - $ - $ 0.00% E404-48000-530 CapitalImprOtherThanBldgs$ 150,000 $ 2,686 $ - $ 147,314 1.79% E404-48000-720 OperatingTransfers$ - $ - $ - $ - 0.00% TotalParkDevelopmentFundExpenditures$ 150,000$ 2,686$ -$ 147,3141.79% EQUIPMENTREPLACEMENT RevenueR406-48500-31000 WashingtonCty. TaxSettlement$ 110,000 $ - $ - $ 110,000 0.00% R406-48500-36210 InterestIncome$ 1,045 $ - $ - $ 1,045 0.00% R406-48500-36260 SaleofEquipment$ - $ - $ - $ - 0.00% R406-48500-39350 CertificateofIndebtedness$ 350,000 $ - $ - $ 350,000 0.00% TotalEquipmentReplacementFundRevenue$ 461,045$ - $ -$ 461,0450.00% ExpenditureE406-48500-540 HeavyMachinery Capital$ 867,000 $ 165,745 $ 165,745 $ 701,255 19.12%Fire Truck & Drum Mulcher E406-48500-550 MotorVehiclesCapital$ 84,356 $ 119,516 $ 58,399 $ (35,160) 141.68% FD Utility Truck & PW F550 TotalEquipmentReplacementFundExpenditures$ 951,356$ 285,261$ 224,144$ 666,09529.98% CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments LOCALROADIMPROVEMENTFUND RevenueR408-43100-31000 WashingtonCty. TaxSettlement$ 375,000 $ - $ - $ 375,000 0.00% R408-43100-33422 OtherStateGrants & Aids$ - $ - $ - $ 0.00% R408-43100-36210 InterestIncome$ 10,705 $ 20,148 $ 13,814 $ (20,148) 0.00% R408-43100-39310 Proceeds-GenObligationBond$ 4,000,000 $ 3,868,542 $ - $ (3,868,542) 0.00% TotalLRIFRevenue$ 4,385,705$ 3,888,690$ 13,814$ (3,513,690)88.67% ExpenditureE408-43100-303 EngineeringFees$ 120,000 $ - $ - $ 120,000 0.00% E408-43100-319 OtherServices$0.00$375.00$0.00($375.00)0.00% E408-43100-351 LegalNoticesPublishing$0.00$59.38$0.00($59.38)0.00% E408-43100-530 CapitalImprOtherThanBldgs$ 3,575,000 $ 575,761 $ 487,224 $ 2,999,239 16.11% TotalLRIFExpenditures$ 3,695,000 $ 576,195 $ 487,224 $ 3,118,805 15.59% BLISSSEWER RevenueR602-43210-31951 Special AssessmentsPrincipal$ - $ - $ - $ 0.00% R602-43210-31952 SAPenalties & Interest$ 420 $ - $ - $ 420 0.00% R602-43210-33422 OtherStateGrants & Aids$ - $ - $ - $ 0.00% R602-43210-34401 SewerUserFees$ 125,230 $ 38,669 $ 11,188 $ 86,561 30.88% R602-43210-34402 SewerConnectionFee$ - $ - $ - $ - 0.00% R602-43210-36100 SpecialAssessments$ - $ 47 $ - $ (47)0.00% R 602-43210-36102 Penalties and Interest$ - $ 72 $ 33 $ 72) 0.00% R602-43210-36210 InterestIncome$ 210 $ - $ - $ 210 0.00% TotalBLISSSewerRevenue$ 125,860 $ 38,788 $ 11,220 $ 87,072 30.82% ExpenditureE602-43210-101 RegularWages & Salaries$ 17,458 $ 9,305 $ 1,608 $ 8,153 53.30% E602-43210-120 PensionExpense$ - $ - $ - $ - 0.00% E602-43210-121 PERACoord. EmployerContribu.$ 1,309 $ 697 $ 121 $ 612 53.22% E602-43210-122 FICAEmployerContribution$ 1,082 $ 538 $ 95 $ 544 49.73% E602-43210-126 MEDICAREEmployerContribution$ 253 $ 141 $ 22 $ 112 55.54% E602-43210-131 EmployerPaidHealth$ - $ - $ - $ - 0.00% E602-43210-151 WorkersCompInsurance Prem$ 525 $ 783 $ - $ 258) 149.14% E602-43210-200 OfficeSupplies$ 91 $ 102 $ - $ (11) 112.31% E602-43210-210 OperatingSupplies$ 700 $ 19 $ 17 $ 681 2.77% E602-43210-240 SmallToolsandMinorEquip$ 420 $ - $ - $ 420 0.00% E602-43210-303 EngineeringFees$ 7,718 $ 65,025 $ 4,072 $ (57,307) 842.51% Bliss Treatment Project E602-43210-304 LegalServices$ - $ - $ - $ - 0.00% E602-43210-308 Other ProfessionalServices$ 3,500 $ 13,091 $ - $ (9,591)374.03% Monthly Sampling & Lobbying E602-43210-309 SoftwareSupport & Maintenance$ 910 $ - $ - $ 910 0.00% E602-43210-317 EmployeeTraining$ 980 $ 598 $ - $ 382 61.05% E602-43210-321 Telephone$ 1,750 $ 1,051 $ 143 $ 699 60.08% E602-43210-322 Postage$ 420 $ - $ - $ 420 0.00% E602-43210-331 TravelExpenses$ 525 $ 78 $ - $ 447 14.93% E602-43210-334 Licenses & Permits$ 1,400 $ 505 $ - $ 895 36.07% E602-43210-361 Liability/Property Ins$ 2,535 $ 2,383 $ - $ 152 93.99% E 602-43210-381 Utilities-Electric & Gas$ 2,100 $ 516 $ 128 $ 1,584 24.57% E602-43210-385 SewerPumping & Maintenance$ 14,000 $ 1,245 $ - $ 12,755 8.89% E602-43210-386 Operation & Maintenance$ 3,500 $ - $ - $ 3,500 0.00% E602-43210-404 RepairMachinery/Equipment$ 11,200 $ 795 $ - $ 10,405 7.10% E602-43210-413 EquipmentRental$ 700 $ - $ - $ 700 0.00% E602-43210-420 DepreciationExpense$ 40,600 $ - $ - $ 40,600 0.00% E602-43210-438 Misc. Contractual$ 7,000 $ 765 $ 267 $ 6,235 10.93% E602-43210-439 RefundsIssued$ - $ - $ - $ - 0.00% E602-43210-530 CapitalImprOtherThanBldgs$ 6,930 $ - $ - $ 6,930 0.00% 30% of Fund Balance moved to new A-E E602-43210-720 OperatingTransfers$ - $ 17,584 $ - $ (17,584) 0.00% Fund 624 TotalBLISSSewerExpenditures$ 127,606$ 115,222$ 6,471 $ 12,38490.29% CITY OF SCANDIA Revenue - Expenditure Summary JUNE 2024 Description2024 Budget2024 YTD AmountMonth AmountBudget Balance% of BudgetComments UPTOWNSEWER RevenueR612-43210-34401 Sewer UserFees$ 22,400 $ 5,480 $ - $ 16,920 24.46% R612-43210-36210 InterestIncome$ 50 $ - $ - $ 50 0.00% TotalUptownSewerRevenue$ 22,450 $ 5,480$ -$ 16,97024.41% ExpenditureE612-43210-101 RegularWages & Salaries$ 10,725 $ 3,737 $ 635 $ 6,988 34.84% E612-43210-120 PensionExpense$ - $ - $ - $ - 0.00% E612-43210-121 PERACoord. EmployerContribu.$ 804 $ 280 $ 48 $ 524 34.77% E612-43210-122 FICAEmployerContribution$ 665 $ 215 $ 37 $ 450 32.40% E612-43210-126 MEDICAREEmployerContribution$ 156 $ 57 $ 9 $ 99 36.34% E612-43210-151 WorkersCompInsurance Prem$ 300 $ 522 $ - $ 222) 174.00% E612-43210-200 OfficeSupplies$ 100 $ - $ - $ 100 0.00% E612-43210-210 OperatingSupplies$ 500 $ - $ - $ 500 0.00% E612-43210-221 EquipmentParts$ 500 $ - $ - $ 500 0.00% E612-43210-303 EngineeringFees$ 1,050 $ - $ - $ 1,050 0.00% E612-43210-308 Other ProfessionalServices$ 750 $ 310 $ - $ 441 41.27% E612-43210-309 SoftwareSupport & Maintenance$ 84 $ - $ - $ 84 0.00% E612-43210-317 EmployeeTraining$ 200 $ 1,138 $ - $ (938) 568.82%Class CWater Operator Training E612-43210-319 OtherServices$ 1,500 $ - $ - $ 1,500 0.00% E 612-43210-322 Postage$ - $ - $ - $ - 0.00% E612-43210-334 Licenses & Permits$ 250 $ 231 $ - $ 19 92.40% E612-43210-361 Liability/Property Ins$ 502 $ 464 $ - $ 38 92.41% E612-43210-381 Utilities-Electric & Gas$ 1,000 $ 254 $ 35 $ 746 25.35% E612-43210-385 SewerPumping & Maintenance$ 1,500 $ - $ - $ 1,500 0.00% E612-43210-386 Operation & Maintenance$ 1,000 $ - $ - $ 1,000 0.00% E612-43210-404 RepairMachinery/Equipment$ 2,000 $ - $ - $ 2,000 0.00% E612-43210-420 DepreciationExpense$ 4,900 $ - $ - $ 4,900 0.00% E612-43210-438 Misc. Contractual$ 1,500 $ 449 $ - $ 1,051 29.92% E612-43210-530 CapitalImprOtherThanBldgs$ 9,900 $ - $ - $ 9,900 0.00% E612-43210-720 OperatingTransfers$ 2,640 $ - $ - $ 2,640 0.00% TotalUptownSewerExpenditures$ 42,526 $ 7,655$ 763$ 34,87118.00% A-ESEWER RevenueR 624-43210-31952 SAPenalties & Interest$ 180 $ - $ - $ 180 0.00% R624-43210-34401 SewerUserFees$ 53,670 $ 16,146 $ 4,237 $ 37,524 30.08% R624-43210-36102 PenaltiesandInterest$ - $ 30 $ 10 $ 30) 0.00% R624-43210-36210 InterestIncome$ 90 $ - $ - $ 90 0.00% TotalA-ESewerRevenue$ 53,940 $ 16,176 $ 4,247 $ 37,764 29.99% ExpenditureE624-43210-101 RegularWages & Salaries$ 7,482 $ - $ - $ 7,482 0.00% E624-43210-121 PERACoord. EmployerContribu.$ 561 $ - $ - $ 561 0.00% E624-43210-122 FICAEmployerContribution$ 464 $ - $ - $ 464 0.00% E624-43210-126 MEDICAREEmployerContribution$ 108 $ - $ - $ 108 0.00% E624-43210-131 EmployerPaidHealth$ - $ - $ - $ - 0.00% E624-43210-151 WorkersCompInsurance Prem$ 225 $ - $ - $ 225 0.00% E624-43210-199 ElectionJudge$ - $ - $ - $ - 0.00% E624-43210-200 OfficeSupplies$ 39 $ 44 $ - $ (5) 112.31% E624-43210-210 OperatingSupplies$ 300 $ - $ - $ 300 0.00% E624-43210-240 SmallToolsandMinorEquip$ 180 $ - $ - $ 180 0.00% E624-43210-303 EngineeringFees$ - $ - $ - $ - 0.00% E624-43210-308 Other ProfessionalServices$ 1,500 $ 310 $ - $ 1,191 20.63% E624-43210-309 SoftwareSupport & Maintenance$ 390 $ - $ - $ 390 0.00% E624-43210-317 EmployeeTraining$ 420 $ 109 $ - $ 311 25.99% E624-43210-321 Telephone$ 750 $ 425 $ 133 $ 325 56.71% E624-43210-322 Postage$ 180 $ - $ - $ 180 0.00% E624-43210-331 TravelExpenses$ 225 $ 78 $ - $ 147 34.84% E624-43210-334 Licenses & Permits$ 600 $ 231 $ - $ 369 38.50% E624-43210-361 Liability/Property Ins$ 1,086 $ 985 $ - $ 101 90.74% E624-43210-381 Utilities-Electric & Gas$ 900 $ 247 $ 37 $ 653 27.44% E624-43210-385 SewerPumping & Maintenance$ 6,000 $ - $ - $ 6,000 0.00% E624-43210-386 Operation & Maintenance$ 1,500 $ - $ - $ 1,500 0.00% E624-43210-404 RepairMachinery/Equipment$ 4,800 $ 230 $ - $ 4,570 4.79% E624-43210-413 EquipmentRental$ 300 $ - $ - $ 300 0.00% E624-43210-420 DepreciationExpense$ 17,400 $ - $ - $ 17,400 0.00% E624-43210-438 Misc. Contractual$ 3,000 $ 4,368 $ - $ (1,368) 145.60% E624-43210-530 CapitalImprOtherThanBldgs$ 2,970 $ - $ - $ 2,970 0.00% TotalA-ESewerExpenditures$ 51,380 $ 7,028$ 170$ 44,35213.68%