Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06.b Treasurer's Monthly Report
City of Scandiaaug Treasurer’sReport August 31, 2024 FUNDACCOUNTING Beginning CashBalance $ 6,281,022.008/1/2024 BeginningCheckingBalance$ 159,078.57 CheckingReceipts 74,912.93 Transfers toChecking 1,687,333.42 TotalDeposits 1,762,246.35 Expenditures 1,599,174.28) CASHBALANCES6/30/2024 Payroll$ (46,088.93) Transfers toMoneyMarket G101-10100GENERAL FUND$ 1,442,582.05 TotalPayments 1,645,263.21) G203-10100COVID-19RELIEF$ 466,422.00 G225-10100EDA$ 39,970.23 Ending CheckingBalance 276,061.71G226-10100CABLE TV$ 30,319.21 G230-10100GATEWAY TRAIL$ - Beginning MoneyMarketBalance 1,609,147.73G 240-10100PUBLIC SAFETY AID$ 176,529.00 MoneyMarketReceipts 1,454.17G 313-101002013 EQUIP CERT$ 31,943.24 TransfertoChecking 430,000.00)G318-101002018EQUIPCERT$ 192,075.68 TransferfromChecking G324-101002024 ROADPROJECTS$ 40,319.45 G401-10100CAPITALIMPROVEMENT$ 744,439.84 EndingMoneyMarket Balance 1,180,601.90 G404-10100PARKDEVELOPMENT$ 220,875.75 G406-10100EQUIPMENT REPLACE$ (153,007.82) BeginningInvestmentsBalance 4,522,670.13G 408-10100LRIF$ 1,433,190.64 Investments Receipts-Interest 8,277.66G 602-10100BLISS SEWER$ (6,916.10) TransferfromChecking G612-10100UPTOWN SEWER$ 23,324.84 1,257,333.42) G 624-10100A-ESEWER$ 28,316.99TransferstoChecking EndingInvestmentsBalance$ 3,273,614.37 G801-10100$ 12,355.45ESCROW 4,722,740.45 Outstanding Checks$ (7,537.53) 8/31/2024EndingCashBalance $ 4,722,740.45 CHECKING, MONEYMARKET & INVESTMENTCD's Checking *102$ 159,078.57BegBal Credits$ 1,762,246.35 Debits$ (1,645,263.21) ReceiptinTransit 276,061.71EndBal MoneyMarket *105 - Rate1.25%$ 1,609,147.73BegBal ratechangefrom .25% Credits 1,454.17 Debits 430,000.00) EndBal$ 1,180,601.90 Investments CD *4422 - Rate5.10% 12mo., 3/25/2025$ 334,924.96 CD *4424 - Rate5.00% 12mo., 7/27/2025$ 473,174.27 CD *4425 - Rate5.10% 9mo., 9/28/2024$ 784,855.35 CD *4426 - Rate5.10% 9mo., 10/30/2024 557,829.30 BondProceeds 1,122,830.49 TotalInvestments$ 3,273,614.37 TotalBank & Investment Accounts 4,730,277.98 7,537.53) ChecksinTransit *3102 TotalFunds$ 4,722,740.45 Submitted by: ColleenFirkus, Treasurer CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments GENERALFUND RevenueR101-41000-31000 WashingtonCty. TaxSettlement$ 1,865,916 $ 1,003,106 $ - $ 862,810 53.76% Distributed July 1 and Dec. 1 R101-41000-31040 Fiscal Disparities$ 107,857 $ 76,018 $ - $ 31,839 70.48% R101-41000-31701 GravelTaxes$ 20,000 $ 5,565 $ 5,565 $ 14,435 27.83% R101-41000-31830 SolarEnergyProduction Tax$ 5,500 $ 2,000 $ - $ 3,500 36.37% R101-41000-31900 Penalties & InterestDelTax$ 1,000 $ - $ - $ 1,000 0.00% R101-41000-32150 ROWUtilityPermit$ 5,000 $ 2,400 $ 300 $ 2,600 48.00% R101-41000-32180 Tobacco & LiquorLicenses$ 11,000 $ 1,175 $ 25 $ 9,825 10.68% R101-41000-32190 OtherCityPermits$ 3,000 $ 1,969 $ 550 $ 1,031 65.63% R101-41000-32210 BuildingPermits$ 160,000 $ 131,993 $ 24,559 $ 28,007 82.50% R101-41000-32260 GamblingPermits$ 100 $ 130 $ - $ (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 $ 19,324 $ 5,831 $ (13,324) 322.06%Sweeping Grant R101-41000-33428 PILOT$ 6,000 $ 3,302 $ 18 $ 2,698 55.03% 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,900 $ 1,900 $ (700) 158.33% R101-41000-34103 ZoningandPlanning$ 5,000 $ 5,146 $ 346 $ (146) 102.92% 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 $ - $ 957 73.63% R101-41000-34304 ReimbursementforServices$ 1,000 $ 1,800 $ 900 $ (800)180.00% FLCC bookkeeping services $3,600/yr. R101-41000-34305 OtherStreetServices$ - $ - $ - $ - 0.00% R101-41000-34730 AdRevenue$ 1,000 $ 450 $ - $ 550 45.00% R101-41000-34750 FacilitiesRental$ 7,400 $ 5,161 $ 600 $ 2,239 69.75% R101-41000-34760 CleaningFees$ - $ - $ - $ - 0.00% R101-41000-34790 RecreationPrograms$ 1,500 $ 1,409 $ 220 $ 91 93.95% R101-41000-35101 Fines & Forfeitures$ 7,000 $ 3,290 $ 643 $ 3,710 46.99% R101-41000-36210 InterestIncome$ 5,636 $ 53,851 $ (10,435) $ (48,215) 955.47% distributed among funds at EOY R101-41000-36230 Donations$ 7,195 $ 2,536 $ 1,184 $ 4,659 35.25% Vinterfest button donations R101-41000-36240 Insurance Dividend$ 4,000 $ 2 $ 2 $ 3,998 0.05% R101-41000-36250 Misc. Refund$ 2,000 $ 828 $ 562 $ 1,172 41.40% TotalGeneralFundRevenue$ 2,340,443 $ 1,383,306 $ 32,771 $ 957,137 59.10% OperatingTransfersR101-41000-39200 InterfundOperating Transfer$ - R101-49000-39203 TransferfromOtherFunds$ - $ 2,187,333 $ 1,687,333 $ (2,187,333) R101-49000-39204 MoneyMarketTransfer$ - $ 5,153,697 $ - $ (5,153,697) TotalOperatingTransfers$ 7,341,031$ 1,687,333 $ (7,341,031) CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments GENERALFUND ExpenditureADMINISTRATION & FINANCE E101-41000-101 RegularWages & Salaries$ 196,713 $ 109,692 $ 14,014 $ 87,021 55.76% E101-41000-121 PERACoord. EmployerContribu.$ 13,801 $ 8,864 $ 1,051 $ 4,937 64.23% E101-41000-122 FICAEmployerContribution$ 12,196 $ 6,997 $ 838 $ 5,199 57.37% E101-41000-126 MEDICAREEmployerContribution$ 2,852 $ 1,766 $ 196 $ 1,086 61.93% E101-41000-131 EmployerPaidHealth$ 46,482 $ 27,522 $ 3,147 $ 18,960 59.21% E101-41000-132 DentalInsurance$ 1,990 $ 1,151 $ 128 $ 839 57.84% E101-41000-134 EmployerPaidLife$ 643 $ 448 $ 50 $ 195 69.74% E101-41000-135 EmployerPaidDisability$ 960 $ 645 $ 72 $ 315 67.19% E101-41000-151 WorkersCompInsurance Prem$ 1,339 $ 1,837 $ - $ (498)137.19% E101-41000-200 OfficeSupplies$ 1,133 $ 420 $ - $ 713 37.11% E101-41000-203 Printed Forms & Papers$ 1,957 $ 1,874 $ - $ 83 95.78% E101-41000-210 OperatingSupplies$ 824 $ 386 $ 57 $ 438 46.89% E101-41000-301 AuditingandAcctgServices$ 27,000 $ 32,050 $ - $ (5,050)118.70% E101-41000-303 EngineeringFees$ - $ - $ - $ - 0.00% E101-41000-304 LegalServices$ 65,000 $ 23,942 $ 3,648 $ 41,058 36.83% E101-41000-306 PersonalTesting & Recruit$ - $ - $ - $ 0.00% American Legal Web Fee & Ordinance E101-41000-308 Other ProfessionalServices$ 5,000 $ 1,747 $ - $ 3,253 34.94% Updates E101-41000-309 SoftwareSupport & Maintenance$ 18,746 $ 8,768 $ 1,249 $ 9,978 46.77% E101-41000-316 Conferences & Seminars$ 721 $ 20 $ - $ 701 2.77% E101-41000-317 EmployeeTraining$ 206 $ - $ - $ 206 0.00% E101-41000-319 OtherServices$ 700 $ 235 $ - $ 465 33.57% E101-41000-321 Telephone$ 5,100 $ 3,618 $ 535 $ 1,482 70.94% E101-41000-322 Postage$ 2,200 $ 1,613 $ 309 $ 587 73.34% E101-41000-331 TravelExpenses$ 1,000 $ 487 $ 243 $ 513 48.74% E101-41000-351 LegalNoticesPublishing$ 1,500 $ 1,339 $ 21 $ 161 89.28% 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 $ 5,997 $ 1,319 $ 6,004 49.97% E101-41000-413 EquipmentRental$ 1,800 $ 1,142 $ 358 $ 658 63.45% E101-41000-430 Recycling$ - $ 50 $ 30 $ (50) 0.00% E101-41000-433 DuesandSubscriptions$ 5,000 $ 90 $ - $ 4,910 1.80% E101-41000-434 YouthServiceBureau$ 5,500 $ 5,500 $ 5,500 $ - 100.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$ - $ 551 $ 551 $ (551) 0.00% E101-41000-560 FurnitureandFixtures$ - $ 233 $ - $ (233)0.00% E101-41000-570 OfficeEquipment$ 1,500 $ 122 $ 88 $ 1,378 8.15% TotalAdmin & FinanceDept. Expenditures$ 450,499$ 260,479$ 33,405$ 190,02057.82% CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments GENERALFUNDCONT.CITYCOUNCIL ExpendituresE101-41110-101 RegularWages & Salaries$ 20,772 $ 10,386 $ - $ 10,386 50.00% E101-41110-122 FICAEmployerContribution$ 1,288 $ 185 $ - $ 1,103 14.33% E101-41110-126 MEDICAREEmployerContribution$ 301 $ 99 $ - $ 202 32.74% E101-41110-127 PERADefined$ 703 $ 370 $ - $ 333 52.69% E101-41110-151 WorkersCompInsurance Prem$ 100 $ 52 $ - $ 48 52.00% E101-41110-308 Other ProfessionalServices$ - $ - $ - $ 0.00% E101-41110-316 Conferences & Seminars$ 350 $ 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 $ 11,121 $ - $ 12,393 47.30% ELECTIONS ExpendituresE 101-41410-199 Election Judge$ 5,400 $ 3,879 $ 2,129 $ 1,521 71.83% E101-41410-200 OfficeSupplies$ 50 $ 45 $ 17 $ 5 90.20% E101-41410-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E101-41410-210 OperatingSupplies$ 750 $ 483 $ 180 $ 267 64.46% E101-41410-351 LegalNoticesPublishing$ 200 $ 56 $ 40 $ 144 27.91% E101-41410-413 EquipmentRental$ 1,700 $ 1,672 $ - $ 28 98.35% Wash. Cty. Equip. Maintenance Fee Total Elections Dept. Expenditures$ 8,100 $ 6,135 $ 2,366 $ 1,965 75.74% PLANNING & BUILDING ExpendituresE101-41910-101 RegularWages & Salaries$ 60,010 $ 38,874 $ 4,489 $ 21,136 64.78% E101-41910-121 PERACoord. EmployerContribu.$ 4,263 $ 2,914 $ 337 $ 1,349 68.34% E101-41910-122 FICAEmployerContribution$ 3,721 $ 2,288 $ 265 $ 1,433 61.48% E101-41910-126 MEDICAREEmployerContribution$ 870 $ 559 $ 62 $ 311 64.30% E101-41910-131 EmployerPaidHealth$ 17,353 $ 11,770 $ 1,345 $ 5,583 67.83% E101-41910-132 DentalInsurance$ 724 $ 493 $ 55 $ 231 68.15% E101-41910-134 EmployerPaidLife$ 173 $ 130 $ 14 $ 43 74.91% E101-41910-135 EmployerPaidDisability$ 416 $ 312 $ 35 $ 104 74.92% E101-41910-203 Printed Forms & Papers$ 100 $ - $ - $ 100 0.00% E101-41910-311 ContractPermitInspections$ 60,000 $ 41,944 $ 12,057 $ 18,056 69.91% E101-41910-312 PlanningServices$ 60,000 $ 31,727 $ 5,833 $ 28,274 52.88% E101-41910-313 Committee & CommissionReimbur$ 5,200 $ 2,600 $ - $ 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 $ 2,391 $ - $ 2,609 47.82% E101-41910-439 RefundsIssued$ - $ - $ - $ - 0.00% E101-41910-720 OperatingTransfers$ - $ - $ - $ - 0.00% TotalPlanning & BuildingDept. Expenditures$ 223,393 $ 140,969 $ 24,492 $ 82,424 63.10% ASSESSOR ExpendituresE 101-41960-300 Assessor$ 23,200 $ 15,260 $ 2,000 $ 7,940 65.77% POLICE ExpendituresE101-42100-318 Police Contract$ 183,442 $ 91,721 $ 91,721 $ 91,721 50.00% E101-42100-319 OtherServices$ 960 $ 309 $ - $ 651 32.23%Code Red System TotalGFPoliceDept. Expenditures$ 184,402 $ 92,030 $ 91,721 $ 92,372 49.91% CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments GENERALFUNDCONT.FIRE ExpendituresE101-42200-101 RegularWages & Salaries$ 160,554 $ 121,278 $ 16,060 $ 39,276 75.54% E101-42200-121 PERACoord. EmployerContribu.$ - $ - $ - $ 0.00% E101-42200-122 FICAEmployerContribution$ 9,954 $ 7,515 $ 932 $ 2,439 75.50% E101-42200-124 Police & FirePERA$ 8,983 $ 6,576 $ 788 $ 2,407 73.21% E101-42200-126 MEDICAREEmployerContribution$ 2,328 $ 1,397 $ 236 $ 931 60.02% E101-42200-134 EmployerPaidLife$ 192 $ 144 $ 16 $ 48 75.00% 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 $ 447 $ - $ 3,053 12.76% E101-42200-210 OperatingSupplies$ 8,800 $ 4,835 $ 3,434 $ 3,965 54.94% E 101-42200-211 Cleaning Supplies$ 100 $ - $ - $ 100 0.00% E101-42200-212 Fuel$ 4,000 $ 2,842 $ 438 $ 1,158 71.06% E101-42200-217 Uniforms & SafetyEquipment$ 10,000 $ 18,020 $ 1,316 $ (8,020) 180.20%new employee uniforms 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 $ - $ 7,909 64.37% SCBA medical exams & flow testsE101-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 $ 9,897 $ 1,056 $ 7,103 58.22% 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 $ - $ 395 21.00% E101-42200-321 Telephone$ 7,000 $ 3,964 $ 840 $ 3,036 56.63% 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% Fire School travel costs MN Board of Firefighter Training & E101-42200-334 Licenses & Permits$ 500 $ - $ - $ 500 0.00%Education License 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,513 $ (301) $ 5,487 31.41% E101-42200-384 Refuse/GarbageDisposal$ - $ 72 $ 72 $ 72) 0.00% E101-42200-385 SewerPumping & Maintenance$ 550 $ 526 $ - $ 24 95.64% E101-42200-401 BuildingMaintenance/Repairs$ 3,500 $ 1,631 $ 150 $ 1,869 46.59% E101-42200-403 Improvements OtherThanBldgs$ - $ - $ - $ 0.00% E101-42200-404 RepairMachinery/Equipment$ 8,500 $ 6,525 $ 200 $ 1,975 76.76% E101-42200-407 WellRepair & Maintenance$ - $ - $ - $ -0.00% E101-42200-433 DuesandSubscriptions$ 3,200 $ 3,245 $ - $ (45) 101.42% E101-42200-438 Misc. Contractual$ 3,500 $ 1,440 $ 1,440 $ 2,060 41.14% E101-42200-440 Events$ 1,000 $ 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 $ - $ 449 10.18% E101-42200-570 OfficeEquipment$ 900 $ 1,078 $ 699 $ (178) 119.81% TotalFireDeptExpenditures$ 369,919 $ 232,171 $ 27,376 $ 137,748 62.76% ANIMALCONTROL ExpendituresE101-42700-314 Animal Control$ 6,000 $ 4,873 $ 866 $ 1,127 81.22% CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments GENERALFUNDCONT.PUBLICWORKS ExpendituresE101-43000-101 RegularWages & Salaries$ 255,022 $ 178,225 $ 20,317 $ 76,797 69.89% E101-43000-102 OTRegularWages$ 5,014 $ 2,884 $ 312 $ 2,130 57.51% E101-43000-104 TemporaryEmployeeWages$ 2,262 $ 338 $ - $ 1,924 14.93% E101-43000-121 PERACoord. EmployerContribu.$ 19,503 $ 12,922 $ 1,547 $ 6,581 66.26% E101-43000-122 FICAEmployerContribution$ 16,262 $ 10,097 $ 1,216 $ 6,165 62.09% E101-43000-126 MEDICAREEmployerContribution$ 3,803 $ 2,513 $ 284 $ 1,290 66.08% E101-43000-131 EmployerPaidHealth$ 66,939 $ 44,195 $ 4,949 $ 22,744 66.02% E101-43000-132 DentalInsurance$ 1,164 $ 797 $ 88 $ 367 68.44% E101-43000-133Union TrainingCenter$ 1,872 $ 1,080 $ 144 $ 792 57.69% E101-43000-134 EmployerPaidLife$ 698 $ 536 $ 62 $ 162 76.81% E101-43000-135 EmployerPaidDisability$ 1,365 $ 1,049 $ 120 $ 316 76.87% 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,439 $ 189 $ 4,061 52.22% E101-43000-212 Fuel$ 25,000 $ 15,401 $ 3,447 $ 9,599 61.60% E101-43000-217 Uniforms & SafetyEquipment$ 2,300 $ 1,111 $ 16 $ 1,189 48.30% E101-43000-221 EquipmentParts$ 17,000 $ 7,762 $ 965 $ 9,238 45.66% E101-43000-222 Tires$ 7,500 $ 4,754 $ 4,754 $ 2,746 63.39% E101-43000-223 StructureRepair & Supplies$ 2,000 $ - $ - $ 2,000 0.00% E101-43000-224 MaterialsforRoadMaintenance$ 7,000 $ 16,795 $ 485 $ (9,795)239.93% Cold Patch; New Streetlight Flags E101-43000-226 SignReplacementandRepair$ 750 $ - $ - $ 750 0.00% E101-43000-228 Gravel$ 10,000 $ 330 $ - $ 9,670 3.30% E101-43000-229 Salt$ 22,000 $ 12,375 $ - $ 9,625 56.25% E101-43000-240 SmallToolsandMinorEquip$ 8,000 $ 6,802 $ 380 $ 1,198 85.02% E101-43000-302 Surveying$ - $ - $ - $ - 0.00% E101-43000-303 EngineeringFees$ 10,500 $ 7,238 $ 495 $ 3,262 68.93% E101-43000-304 LegalServices$ - $ - $ - $ - 0.00% E101-43000-305 MedicalServices$ 1,000 $ - $ - $ 1,000 0.00% E101-43000-309 SoftwareSupport & Maintenance$ 6,000 $ 200 $ - $ 5,800 3.33% E101-43000-317 EmployeeTraining$ 1,500 $ 459 $ - $ 1,041 30.63% E101-43000-319 OtherServices$ 7,000 $ 4,147 $ 20 $ 2,853 59.24% E101-43000-321 Telephone$ 4,000 $ 2,835 $ 348 $ 1,165 70.87% Travel to Arborist workshop & Water E101-43000-331 TravelExpenses$ 500 $ 291 $ - $ 209 58.14%School E101-43000-334 Licenses & Permits$ 500 $ 10 $ 10 $ 490 2.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,818 $ (163) $ 4,182 30.31% E101-43000-384 Refuse/GarbageDisposal$ - $ - $ - $ - 0.00% holding tank & floor drain oil separator E101-43000-385 SewerPumping & Maintenance$ 1,500 $ 2,285 $ - $ (785)152.35% tank pumping E101-43000-387 Street LightUtilities$ 4,200 $ 2,055 $ 271 $ 2,145 48.94% E101-43000-401 BuildingMaintenance/Repairs$ 6,000 $ 2,817 $ 768 $ 3,183 46.95% E101-43000-403 Improvements OtherThanBldgs$ - $ - $ - $ 0.00% E101-43000-404 RepairMachinery/Equipment$ 25,000 $ 5,115 $ - $ 19,885 20.46% E101-43000-405 ContractualRoadMaint/Repair$ 200,000 $ 119,379 $ 44,200 $ 80,621 59.69% 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 $ 618 $ 100 $ 582 51.54% E101-43000-433 DuesandSubscriptions$ 200 $ - $ - $ 200 0.00% E101-43000-438 Misc. Contractual$ 16,000 $ 5,000 $ 5,000 $ 11,000 31.25% 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 $ 511,514 $ 90,323 $ 314,756 61.91% CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments GENERALFUNDCONT.PARKS & RECREATION ExpendituresE101-45000-101 RegularWages & Salaries$ 11,328 $ 7,176 $ 846 $ 4,152 63.34% E101-45000-104 TemporaryEmployeeWages$ 39,985 $ 14,042 $ 3,912 $ 25,943 35.12% E101-45000-121 PERACoord. EmployerContribu.$ 850 $ 537 $ 63 $ 313 63.23% E101-45000-122 FICAEmployerContribution$ 3,181 $ 1,289 $ 292 $ 1,892 40.54% E101-45000-126 MEDICAREEmployerContribution$ 744 $ 308 $ 68 $ 436 41.41% E101-45000-131 EmployerPaidHealth$ 2,562 $ 1,555 $ 189 $ 1,007 60.71% E101-45000-132 DentalInsurance$ 42 $ 26 $ 3 $ 16 60.95% E101-45000-134 EmployerPaidLife$ 27 $ 20 $ 2 $ 7 74.67% E101-45000-135 EmployerPaidDisability$ 76 $ 41 $ 5 $ 35 53.76% 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 $ 547 $ 25 $ 453 54.71% E101-45000-212 Fuel$ 1,000 $ 138 $ - $ 862 13.80% E101-45000-221 EquipmentParts$ 2,500 $ 588 $ - $ 1,912 23.51% E101-45000-223 StructureRepair & Supplies$ 2,500 $ 138 $ - $ 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 $ - $ 480) 0.00% E101-45000-319 OtherServices$ 1,750 $ 1,019 $ - $ 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 $ 2,242 $ 689 $ 4,258 34.49% E101-45000-384 Refuse/GarbageDisposal$ 5,000 $ 2,657 $ 499 $ 2,343 53.15% E101-45000-385 SewerPumping & Maintenance$ 1,250 $ 384 $ 193 $ 866 30.73% Lighted ballfield fence repair - insurance E101-45000-401 BuildingMaintenance/Repairs$ 6,000 $ 4,271 $ 120 $ 1,729 71.18% reimbursed E101-45000-403 Improvements OtherThanBldgs$ 2,500 $ 716 $ - $ 1,784 28.63% E101-45000-404 RepairMachinery/Equipment$ 1,000 $ 418 $ 38 $ 582 41.81% E101-45000-406 GroundsCare$ 4,000 $ 1,265 $ 28 $ 2,735 31.62% E101-45000-438 Misc. Contractual$ 8,000 $ 5,958 $ 2,235 $ 2,042 74.47% E101-45000-439 RefundsIssued$ - $ - $ - $ - 0.00% E101-45000-440 Events$ 7,000 $ 1,450 $ 66 $ 5,550 20.71% 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 $ 56,923 $ 9,274 $ 68,761 45.29% CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments GENERALFUNDCONT.COMMUNITY CENTER ExpendituresE101-45180-101 RegularWages & Salaries$ 16,600 $ 10,665 $ 1,364 $ 5,935 64.25% E101-45180-104 TemporaryEmployeeWages$ - $ - $ - $ - 0.00% E101-45180-121 PERACoord. EmployerContribu.$ 1,245 $ 790 $ 93 $ 455 63.46% E101-45180-122 FICAEmployerContribution$ 1,029 $ 622 $ 81 $ 407 60.45% E101-45180-126 MEDICAREEmployerContribution$ 241 $ 155 $ 19 $ 86 64.35% E101-45180-131 EmployerPaidHealth$ 3,692 $ 2,114 $ 266 $ 1,578 57.26% E101-45180-134 EmployerPaidLife$ 43 $ 32 $ 4 $ 11 75.35% E101-45180-135 EmployerPaidDisability$ 95 $ 77 $ 9 $ 18 81.57% E101-45180-151 WorkersCompInsurance Prem$ - $ 152 $ - $ 152) 0.00% E101-45180-210 OperatingSupplies$ 2,900 $ 1,056 $ 160 $ 1,844 36.41% E101-45180-223 StructureRepair & Supplies$ 4,000 $ 236 $ - $ 3,764 5.91% E101-45180-321 Telephone$ - $ 307 $ 307 $ (307) 0.00% E101-45180-334 Licenses & Permits$ 1,000 $ 955 $ - $ 45 95.50% E101-45180-361 Liability/Property Ins$ 835 $ 801 $ - $ 34 95.89% E101-45180-381 Utilities-Electric & Gas$ 9,135 $ 4,094 $ 534 $ 5,041 44.82% E101-45180-384 Refuse/GarbageDisposal$ - $ 156 $ 32 $ (156)0.00% E101-45180-385 SewerPumping & Maintenance$ 4,000 $ 1,971 $ 712 $ 2,029 49.28% E101-45180-401 BuildingMaintenance/Repairs$ 15,000 $ 6,725 $ 837 $ 8,275 44.83% E 101-45180-404 Repair Machinery/Equipment$ 5,000 $ 125 $ - $ 4,875 2.49% E101-45180-406 GroundsCare$ 1,300 $ 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$ 80,515 $ 32,650 $ 4,415 $ 47,865 40.55% TOTALGENERALFUNDEXPENDITURES$ 2,321,496.00 $ 1,364,125.63 $ 286,237.24 $ 957,370.37 58.76% E101-49000-421 CashOver/Short OperatingTransfersE101-49000-720 OperatingTransfers$ 7,341,030.86 $ 1,687,333.42 $ (7,341,030.86) TOTALGENERALFUNDEXPENDITURESW/TRANSFERS$ 2,321,496.00 $ 8,705,156.49 $ 1,973,570.66 $ (6,383,660.49) CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments COVIDRELIEFFUND RevenueR203-46200-33150 FederalGrant$ - $ - $ - $ - ExpendituresE203-49000-720OperatingTransfers$ - $ - $ - $ EDAFUND RevenueR225-46500-31000 WashingtonCty. TaxSettlement$ 5,300 $ 2,650 $ 2,650 $ 2,650 50.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$ 36,316 $ 2,650 $ (30,916)672.52% ExpenditureE225-46500-210 OperatingSupplies$ 300 $23$0$2777.74% E225-46500-303 EngineeringFees$ - $0$0$00.00% E225-46500-304 LegalServices$ - $0$0$00.00% E225-46500-308 Other ProfessionalServices$ 100 $0$0$1000.00% EDAM Membership; Sister City DuesE225-46500-340 Advertising$ 1,500 $0$0$1,5000.00% E225-46500-433 DuesandSubscriptions$ 1,203 $364$0$83930.26% E225-46500-440 Events$ 1,500 $310$0$1,19020.67% E225-46500-720 OperatingTransfers$ - $33,356$0($33,356)0.00% closed checking account TotalEDAFundExpenditures$ 4,603$ 34,053 $ -$ (29,450)739.81% CABLETVFUND RevenueR226-41950-36210 Interest Income$ 100 $ - $ - $ 100 0.00% R226-41950-36260 SaleofEquipment$ - $ - $ - $ - 0.00% R226-41950-38050 Cable TVFranchise Rebates$ 16,700 $ 12,039 $ 1,630 $ 4,661 72.09% R226-41950-38051 PEG Fees$ 4,400 $ 2,594 $ 424 $ 1,806 58.95% TotalCableTVFundRevenue$ 21,200 $ 14,633 $ 2,054 $ 6,567 69.02% ExpenditureE226-41950-240 SmallToolsandMinorEquip$ 300 $ - $ - $ 300 0.00% E226-41950-309 SoftwareSupport & Maintenance$ 3,500 $ 2,523 $ 170 $ 977 72.08% E226-41950-438 Misc. Contractual$ 7,750 $ 3,170 $ - $ 4,580 40.90% E226-41950-570 OfficeEquipment$ - $ - $ - $ - 0.00% TotalCableTVFundExpenditures$ 11,550 $ 5,693$ 170$ 5,857 49.29% GATEWAYTRAILFUND RevenueR230-45000-36230 Donations$ - $ - $ - $ - 0.00% ExpenditureE 230-45000-308 Other Professional Services$ - $ - $ - $ 0.00% CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments 2018STREETRECONSTRUCTION RevenueR318-47000-31000 WashingtonCty. TaxSettlement$ 345,634 $ 172,817 $ - $ 172,817 50.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) 211.11% Total2018 StreetReconstructionFund Expenditures$ 329,670$ 43,133 $ -$ 286,53713.08% 2024STREETRECONSTRUCTION RevenueR324-47000-31000 WashingtonCty. TaxSettlement$ - $ - $ - $ 0.00% R324-47000-36210InterestIncome$ - $ 40,319 $ 20,712 $ (40,319) 0.00% Total2024StreetReconstructionFundRevenues$ - $ 40,319 $ 20,712 $ (40,319) 0.00% ExpenditureE324-47000-601 LongTermDebtPrincipal$ - $ - E324-47000-611 LongTermDebtInterest$ - E324-47000-620 FiscalAgentsFees$ 495 $ - $ 495 0.00% Total2024 StreetReconstructionFund Expenditures$ 495 $ - $ -$ 4950.00% CAPITALIMPROVEMENTS RevenueR 401-48000-31000 Washington Cty. Tax Settlement$ 235,000 $ 117,500 $ 117,500 $ 117,500 50.00% R401-48000-33422 OtherStateGrants & Aids$ - $ 34,110 $ - $ (34,110) 0.00% R401-48000-33640 OtherGrants$ - $ 10,972 $ 10,972 $ (10,972) 0.00% R401-48000-36210 InterestIncome$ 3,000 $ - $ - $ 3,000 0.00% TotalCapitalImprovementFundRevenue$ 238,000$ 162,582$ 128,472$ 75,41868.31% 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$ - $ 36,094 $ 5,351 $ (36,094) 0.00% Gateway Trail Engineering E401-48000-308 Other ProfessionalServices$ - $ 4,800 $ - $ (4,800)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 $ 40,894 $ 5,351 $ 436,654 8.56% PARKDEVELOPMENT RevenueR404-48000-31000 WashingtonCty. TaxSettlement$ 60,000 $ 30,000 $ - $ 30,000 50.00% R404-48000-33422 OtherStateGrants & Aids$ - $ 101,250 $ - $ (101,250) 0.00%2023Playgroundgrant R404-48000-34780 ParkDedicationFees$ - $ - $ - $ - 0.00% R404-48000-39203 TransferfromOtherFunds$ - $ 150,000 $ 150,000 $ (150,000) 0.00%fromGeneralFundbalance R404-48000-36210 InterestIncome$ 66 $ - $ - $ 66 0.00% R404-48000-36230 Donations$ - $ - $ - $ - 0.00% TotalParkDevelopment FundRevenue$ 60,066 $ 281,250$ 150,000$ (221,184) 468.23% ExpenditureE404-48000-303 EngineeringFees$0.00$ 47,896 $ 2,971 $ (47,896) 0.00%tenniscourts E404-48000-308 Other ProfessionalServices$0.00$ 410 $ 410 $ (410) 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$ 50,992 $ 3,380 $ 99,00833.99% EQUIPMENTREPLACEMENT RevenueR406-48500-31000 WashingtonCty. TaxSettlement$ 110,000 $ 55,000 $ 55,000 $ 55,000 50.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$ 55,000 $ 55,000$ 406,04511.93% ExpenditureE406-48500-540 HeavyMachinery Capital$ 867,000 $ 226,113 $ 60,368 $ 640,887 26.08%FireTruck & DrumMulcher E406-48500-550 MotorVehiclesCapital$ 84,356 $ 119,516 $ - $ (35,160) 141.68%FDUtilityTruck & PWF550 TotalEquipmentReplacementFundExpenditures$ 951,356$ 345,629$ 60,368$ 605,72736.33% CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments LOCALROADIMPROVEMENTFUND RevenueR408-43100-31000 WashingtonCty. TaxSettlement$ 375,000 $ 187,500 $ - $ 187,500 50.00% R408-43100-33422 OtherStateGrants & Aids$ 63,082 $ - $ (63,082) 0.00% R408-43100-36210 InterestIncome$ 10,705 $ - $ - $ 10,705 0.00% R408-43100-39310 Proceeds-GenObligationBond$ 4,000,000 $ 3,868,542 $ 3,868,542 $ 131,458 96.71% TotalLRIFRevenue$ 4,385,705$ 4,119,123$ 3,868,542 $ 266,58293.92% ExpenditureE408-43100-303 EngineeringFees$ 120,000 $ 169,617 $ 48,885 $ (98,502) 182.09% E408-43100-319 OtherServices$ - $ 375 $ - $ (375) 0.00% E408-43100-351 LegalNoticesPublishing$ - $ 59 $ - $ 59) 0.00% E408-43100-530 CapitalImprOtherThanBldgs$ 3,575,000 $ 2,567,094 $ 1,208,448 $ 1,007,906 71.81% TotalLRIFExpenditures$ 3,695,000 $ 2,737,146 $ 1,257,333 $ 908,970 74.08% BLISSSEWER RevenueR602-43210-31951 Special AssessmentsPrincipal$ - $ 2,652 $ - $ 2,652) 0.00% R602-43210-31952 SAPenalties & Interest$ 420 $ 318 $ - $ 102 75.76% R602-43210-33422 OtherStateGrants & Aids$ - $ - $ - $ 0.00% R602-43210-34401 SewerUserFees$ 125,230 $ 56,114 $ 4,364 $ 69,116 41.32% R602-43210-34402 SewerConnectionFee$ - $ - $ - $ - 0.00% R 602-43210-36100 Special Assessments$ - $ 47 $ - $ (47)0.00% R602-43210-36102 PenaltiesandInterest$ - $ 82 $ 10 $ 82) 0.00% R602-43210-36210 InterestIncome$ 210 $ - $ - $ 210 0.00% TotalBLISSSewerRevenue$ 125,860 $ 59,213 $ 4,374 $ 66,647 47.05% ExpenditureE602-43210-101 RegularWages & Salaries$ 17,458 $ 13,219 $ 1,555 $ 4,239 75.72% E602-43210-120 PensionExpense$ - $ - $ - $ - 0.00% E602-43210-121 PERACoord. EmployerContribu.$ 1,309 $ 990 $ 117 $ 319 75.65% E602-43210-122 FICAEmployerContribution$ 1,082 $ 771 $ 92 $ 311 71.29% E602-43210-126 MEDICAREEmployerContribution$ 253 $ 195 $ 21 $ 58 77.10% 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 $ 29 $ 10 $ 671 4.15% E602-43210-240 SmallToolsandMinorEquip$ 420 $ - $ - $ 420 0.00% E602-43210-303 EngineeringFees$ 7,718 $ 73,553 $ 5,537 $ (65,835) 953.01% Bliss Treatment Project E602-43210-304 LegalServices$ - $ - $ - $ - 0.00% E602-43210-308 Other ProfessionalServices$ 3,500 $ 15,367 $ 1,802 $ (11,867) 439.06%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,492 $ 298 $ 258 85.27% 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% E 602-43210-361 Liability/Property Ins$ 2,535 $ 2,383 $ - $ 152 93.99% E602-43210-381 Utilities-Electric & Gas$ 2,100 $ 793 $ 230 $ 1,307 37.78% E602-43210-385 SewerPumping & Maintenance$ 14,000 $ 1,820 $ 575 $ 12,180 13.00% E602-43210-386 Operation & Maintenance$ 3,500 $ - $ - $ 3,500 0.00% E602-43210-404 RepairMachinery/Equipment$ 11,200 $ 2,611 $ 1,816 $ 8,589 23.31% E602-43210-413 EquipmentRental$ 700 $ - $ - $ 700 0.00% E602-43210-420 DepreciationExpense$ 40,600 $ - $ - $ 40,600 0.00% 30% of Fund Balance moved to new A-E E602-43210-438 Misc. Contractual$ 7,000 $ 1,330 $ 565 $ 5,670 19.00% Fund 624 E602-43210-439 RefundsIssued$ - $ - $ - $ - 0.00% E602-43210-530 CapitalImprOtherThanBldgs$ 6,930 $ - $ - $ 6,930 0.00% E602-43210-720 OperatingTransfers$ - $ 17,584 $ - $ (17,584) 0.00% TotalBLISSSewerExpenditures$ 127,606$ 134,205$ 12,617$ (6,599)105.17% CITY OF SCANDIA Revenue - Expenditure Summary AUG 2024 Description2024 Budget2024 YTD AmountAUG AmountBudget Balance% ofBudgetComments UPTOWNSEWER RevenueR612-43210-34401 Sewer UserFees$ 22,400 $ 11,142 $ 3,483 $ 11,258 49.74% R612-43210-36210 InterestIncome$ 50 $ - $ - $ 50 0.00% TotalUptownSewerRevenue$ 22,450 $ 11,142 $ 3,483 $ 11,30849.63% ExpenditureE612-43210-101 RegularWages & Salaries$ 10,725 $ 5,336 $ 635 $ 5,389 49.75% E612-43210-120 PensionExpense$ - $ - $ - $ - 0.00% E612-43210-121 PERACoord. EmployerContribu.$ 804 $ 399 $ 48 $ 405 49.68% E612-43210-122 FICAEmployerContribution$ 665 $ 311 $ 37 $ 354 46.73% E612-43210-126 MEDICAREEmployerContribution$ 156 $ 79 $ 9 $ 77 50.63% 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%WaterOperatortraining 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 $ 303 $ 38 $ 697 30.31% E612-43210-385 SewerPumping & Maintenance$ 1,500 $ 1,084 $ 1,084 $ 417 72.23% E612-43210-386 Operation & Maintenance$ 1,000 $ - $ - $ 1,000 0.00% E 612-43210-404 Repair Machinery/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 $ 10,625 $ 1,850 $ 31,90124.98% A-ESEWER RevenueR 624-43210-31952 SAPenalties & Interest$ 180 $ - $ - $ 180 0.00% R624-43210-34401 SewerUserFees$ 53,670 $ 23,464 $ 1,543 $ 30,206 43.72% R624-43210-36102 PenaltiesandInterest$ - $ 30 $ - $ 30) 0.00% R624-43210-36210 InterestIncome$ 90 $ - $ - $ 90 0.00% R624-43210-39200 InterfundOperating Transfer$ - $ 17,584 $ - $ (17,584)0.00% TotalA-ESewerRevenue$ 53,940 $ 41,078 $ 1,543 $ 12,862 76.15% 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 $ 705 $ 280 $ 45 94.00% 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 $ 320 $ 37 $ 580 35.60% 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 $ 1,289 $ 1,059 $ 3,511 26.86% E624-43210-413 EquipmentRental$ 300 $ - $ - $ 300 0.00% E624-43210-420 DepreciationExpense$ 17,400 $ - $ - $ 17,400 0.00%