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 Scandia aug Treasurer’s Report 11/31/2023 FUND ACCOUNTING Beginning Cash Balance $ 2,956,314.96 11/1/2023 Beginning Checking Balance$ 107,043.35 Checking Receipts $ 1,243,010.69 Transfers to Checking $ 600,000.00 Total Deposits $ 1,843,010.69 Expenditures $ (641,745.44) Payroll$ (39,782.99) Total Payments $ (681,528.43) Ending Checking Balance $ 1,268,525.61 Beginning Money Market Balance $ 728,614.89 Money Market Receipts $ 259.77 Transfer to Checking $ (600,000.00) Transfer from Checking Ending Money Market Balance $ 128,874.66 Beginning Investments Balance $ 2,090,411.57 Investments Receipts $ - Ending Investments Balance$ 2,090,411.57 Beginning EDA Balance$ 33,356.07 EDA Receipts $ - EDA Expenditures EDA De;posit in Transit EDA Transfers from Checking Ending EDA Balance$ 33,356.07 Outstanding Checks $ (4,229.21) 11/31/2023 Ending Cash Balance $ 3,516,938.70 CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102$ 107,043.35 Beg Bal Credits$ 1,843,010.69 Debits$ (681,528.43) Transfer in Transit $ 1,268,525.61 End Bal Beg Bal Money Market *105 - Rate 1.25%$ 728,614.89 rate change from .25% Credits $ 259.77 Debits $ (600,000.00) End Bal$ 128,874.66 Investments CD *4422 - Rate 4.00% 12 mo., 3/25/2024 $ 324,258.66 CD *4424 - Rate 4.50% 12 mo., 7/27/2024 $ 457,543.39 CD *4425 - Rate 5.10% 12 mo., 9/28/2024$ 755,658.31 CD *4426 - Rate 3.50%% 12 mo., 1/29/2024 $ 552,951.21 Total Investments$ 2,090,411.57 Total Bank & Investment Accounts $ 3,487,811.84 $ (4,229.21) Checks in Transit *3102 Transfer to EDA in Transit Deposit in transit money market $ 3,483,582.63 Total Adjusted Undesignated Funds Scandia EDA *6301 $ 33,356.07 Receipts Expenditures Checks in Transit Deposit in Transit Total Designated EDA Funds$ 33,356.07 Total Funds$ 3,516,938.70 Submitted by: Colleen Firkus, Treasurer 2023 CASH BALANCES END OF MONTH FUNDJANUARYFEBRUARYMARCHAPRILMAYJUNEJULYAUGUSTSEPTEMBEROCTOBERNOVEMBER 101 GENERAL$1,365,932$1,204,052$1,078,538$925,847$839,539$1,564,703$1,423,907$1,284,843$1,226,725 1,645,772.39 539,283.54 203 COVID-19 RELIEF$456,363$456,363$456,363$456,363$456,363$456,363$456,362.62 456,362.62 $456,362.62$ 456,362.62 456,362.62 226 CABLE TV$11,271$12,786$9,481$11,524$13,529$12,551$14,346$14,945$16,869 18,667.84 $ 14,106.51 230 GATEWAY TRAIL$0$0$0$0$0$0$0$0$0$0 307 BLACKTOP PROJECT 2007$6,731$0$0$0$0$0$0$0$0$0 313 EQUIPMENT CERTIFICATES$28,825$28,873$28,873$28,873($32,057)$ (32,056.76)($57)($57)($57)($57) 31,943.24 315 EQUIPMENT CERTIFICATES$15,951$0$0$0$0$0$0$0$0$0 317 EQUIPMENT CERTIFICATES$2,187$0$0$0$0$0$0$0$0$0 318 BLACKTOP PROJECT$20,270$45,284$45,284($823)($823)$ (823.23) $170,445$170,445$170,445 170,444.77 61,100.26 401 CAPITAL IMPR$749,162$749,497$745,297$668,380$665,980$ 663,579.71 $861,809$848,700$845,691 607,127.49 772,707.49 404 PARK CAP IMPR$148,177$148,797$148,797$144,297$144,297$ 145,898.33 $158,898$151,178$148,305 95,361.57 55,044.41 406 EQUIPMENT REPLACEMENT$199,727$200,548$200,548$200,548$200,548$ 200,548.37 $200,548$200,548$137,530 124,812.34 143,663.34 408 LOCAL ROAD IMPROVEMENT$916,080$910,085$901,556$895,518$893,593$ 744,491.50 $187,297$145,243$130,266 118,489.93 203,351.14 602 BIG MARINE SEWER$80,462$74,771$75,858$58,322$49,682$ 60,689.30 $68,166$57,261$53,911 59,709.89 53,671.42 612 UPTOWN SEWER$10,330$15,160$13,957$12,136$15,967$ 15,833.56 $15,646$16,190$13,864 14,449.65 18,994.67 801 ESCROW$21,817$32,240$24,131$35,421$37,650$ 32,645.90 $43,496$48,082$47,031 38,761.99 22,303.99 SUBTOTAL$4,033,286$3,878,456$3,728,684$3,436,405$3,284,269$2,840,559$3,739,866$3,532,207$3,303,137$2,929,057$3,483,583 225 EDA$33,356$33,356$33,356$33,356$33,356$ 33,356.07 $ 33,356.07 $ 33,356.07 $ 33,356.07$ 33,356.07 $ 33,356.07 TOTAL$4,066,642$3,911,812$3,762,040$3,469,761$3,317,625$2,873,915$3,773,222$3,565,563$3,336,493$2,962,413$3,516,939 CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget Balance% of BudgetComments GENERAL FUND RevenueR 101-41000-31000 Washington Cty. Tax Settlement$ 1,865,918.00 $1,667,226.96$677,706.43$ 198,691.04 89.35% R 101-41000-31040 Fiscal Disparities$ - $122,124.75$35,175.37$ (122,124.75) 0.00% R 101-41000-31701 Gravel Taxes$ 20,000.00 $3,329.37$0.00$ 16,670.63 16.65% R 101-41000-31830 Solar Energy Production Tax$ 6,000.00 $5,873.56$0.00$ 126.44 97.89% R 101-41000-31900 Penalties & Interest Del Tax$ 400.00 $3,177.61$3,125.67$ (2,777.61) 794.40% R 101-41000-32150 ROW Utility Permit$ 3,000.00 $4,650.00$150.00$ (1,650.00) 155.00% R 101-41000-32180 Tobacco & Liquor Licenses$ 10,000.00 $744.00$0.00$ 9,256.00 7.44% R 101-41000-32190 Other City Permits$ 3,000.00 $2,620.00$250.00$ 380.00 87.33% R 101-41000-32210 Building Permits$ 145,000.00 $166,481.82$14,498.75$ (21,481.82) 114.82% R 101-41000-32260 Gambling Permits$ 100.00 $45.00$0.00$ 55.00 45.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid$ 7,000.00 $6,959.46$0.00$ 40.54 99.42% R 101-41000-33420 Fire Relief State PERA$ 37,000.00 $47,147.82$47,147.82$ (10,147.82) 127.43% R 101-41000-33422 Other State Grants & Aids$ 11,000.00 $9,052.50$0.00$ 1,947.50 82.30%Fire Training grants R 101-41000-33428 PILOT$ 6,000.00 $3,108.39$0.00$ 2,891.61 51.81% R 101-41000-33620 Recycling Grant$ 10,500.00 $8,165.00$0.00$ 2,335.00 77.76% R 101-41000-33630 Local Govt Grants & Aids$ - $0.00$0.00$ - 0.00% R 101-41000-33640 Other Grants$ 1,200.00 $0.00$0.00$ 1,200.00 0.00% R 101-41000-34103 Zoning and Planning$ 6,700.00 $7,742.00$0.00$ (1,042.00) 115.55% R 101-41000-34106 Engineering Fees$ 500.00 $0.00$0.00$ 500.00 0.00% R 101-41000-34107 Assessment Search Fees$ - $5.00$0.00$ (5.00) 0.00% R 101-41000-34109 Water Usage$ 100.00 $0.00$0.00$ 100.00 0.00% R 101-41000-34201 Impound Fees$ - $0.00$0.00$ - 0.00% R 101-41000-34202 Fire Protection Services$ 32,300.00 $32,300.00$0.00$ - 100.00% R 101-41000-34301 Damage Repairs$ - $0.00$0.00$ - 0.00% R 101-41000-34303 Dust Control$ 2,700.00 $3,524.46$0.00$ (824.46) 130.54% R 101-41000-34304 Reimbursement for Services$ 3,000.00 $1,800.00$0.00$ 1,200.00 60.00% R 101-41000-34305 Other Street Services$ - $0.00$0.00$ - 0.00% R 101-41000-34730 Ad Revenue$ - $900.00$0.00$ (900.00) 0.00% R 101-41000-34750 Facilities Rental$ 5,500.00 $7,583.67$0.00$ (2,083.67) 137.88% R 101-41000-34760 Cleaning Fees$ 100.00 $0.00$0.00$ 100.00 0.00% R 101-41000-34790 Recreation Programs$ 2,100.00 $1,728.33($45.00)$ 371.67 82.30% R 101-41000-35101 Fines & Forfeitures$ 7,400.00 $5,643.53$373.28$ 1,756.47 76.26% distributed among funds at EOY R 101-41000-36210 Interest Income$ 12,100.00 $62,012.95$262.06$ (49,912.95) 512.50% Veterans Memorial Upkeep $1,090; Lions: R 101-41000-36230 Donations$ 2,000.00 $3,043.47($3,048.98)$ (1,043.47) 152.17% Vinterfest Fireworks $2,000; Sister City $250 R 101-41000-36240 Insurance Dividend$ 4,100.00 $0.00$0.00$ 4,100.00 0.00% R 101-41000-36250 Misc. Refund$ 3,800.00 $4,076.20$0.00$ (276.20) 107.27% Total General Fund Revenue$ 2,208,518.00 $2,181,065.85$ 775,595.40 $ 27,452.15 98.76% Operating TransfersR 101-41000-39200 Interfund Operating Transfer$ - $6,097.96$ 3,048.98 $ (3,048.98) JE to move park bench donation receipt R 101-49000-39203 Transfer from Other Funds$ - $ 2,173,000.00 $ (2,173,000.00) 0 R 101-49000-39204 Money Market Transfer$ - $ 1,825,000.01 $ 600,000.00 $ (585,000.01) Total Operating Transfers$4,004,097.97$ 603,048.98$ (2,761,048.99) CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget Balance% of BudgetComments GENERAL FUND ExpenditureADMINISTRATION & FINANCE E 101-41000-101 Regular Wages & Salaries$ 192,700.00 $120,576.75$12,923.97$ 72,123.25 62.57% E 101-41000-121 PERA Coord. Employer Contribu.$ 13,400.00 $6,440.48$969.30$ 6,959.52 48.06% E 101-41000-122 FICA Employer Contribution$ 11,900.00 $6,548.89$770.23$ 5,351.11 55.03% E 101-41000-126 MEDICARE Employer Contribution$ 2,700.00 $2,393.01$180.13$ 306.99 88.63% E 101-41000-131 Employer Paid Health$ 47,300.00 $33,784.85$3,198.32$ 13,515.15 71.43% E 101-41000-132 Dental Insurance$ 3,400.00 $1,242.45$127.90$ 2,157.55 36.54% E 101-41000-134 Employer Paid Life$ 600.00 $510.70$49.60$ 89.30 85.12% E 101-41000-135 Employer Paid Disability$ 900.00 $844.01$71.67$ 55.99 93.78% E 101-41000-151 Worker s Comp Insurance Prem$ 1,300.00 $1,651.00$0.00$ (351.00) 127.00% E 101-41000-200 Office Supplies$ 1,100.00 $431.57$73.99$ 668.43 39.23% E 101-41000-203 Printed Forms & Papers$ 1,900.00 $2,590.25$286.00$ (690.25) 136.33% Award frames; March 10 meeting supplies E 101-41000-210 Operating Supplies$ 800.00 $574.78$0.00$ 225.22 71.85% E 101-41000-300 Assessor$ - $0.00$0.00$ - 0.00% E 101-41000-301 Auditing and Acct g Services$ 23,500.00 $28,500.00$0.00$ (5,000.00) 121.28% E 101-41000-303 Engineering Fees$ - $0.00$0.00$ - 0.00% E 101-41000-304 Legal Services$ 55,000.00 $49,748.75$4,887.00$ 5,251.25 90.45% E 101-41000-306 Personal Testing & Recruit$ - $0.00$0.00$ - 0.00% Intermin City Admin Salary E 101-41000-308 Other Professional Services$ 1,000.00 $815.71($49,483.48)$ 184.29 81.57% E 101-41000-309 Software Support & Maintenance$ 18,200.00 $17,020.43$3,183.43$ 1,179.57 93.52% E 101-41000-314 Animal Control$ - $0.00$0.00$ - 0.00% E 101-41000-316 Conferences & Seminars$ 700.00 $60.00$30.00$ 640.00 8.57% E 101-41000-317 Employee Training$ 200.00 $0.00$0.00$ 200.00 0.00% E 101-41000-319 Other Services$ 46,700.00 $50,158.48$49,483.48$ (3,458.48) 107.41% E 101-41000-321 Telephone$ 3,700.00 $4,606.11$425.99$ (906.11) 124.49% E 101-41000-322 Postage$ 2,200.00 $2,276.76$34.24$ (76.76) 103.49% E 101-41000-331 Travel Expenses$ 600.00 $1,033.37$0.00$ (433.37) 172.23%reimburse city admin applicant E 101-41000-351 Legal Notices Publishing$ 1,200.00 $1,530.45$22.50$ (330.45) 127.54% E 101-41000-361 Liability/Property Ins$ 7,100.00 $10,967.38$0.00$ (3,867.38) 154.47% E 101-41000-365 Insurance Claims$ - $1,000.00$0.00$ (1,000.00) 0.00% budget for all depts in Fund 101 E 101-41000-381 Utilities-Electric & Gas$ 13,000.00 $10,839.23$1,633.86$ 2,160.77 83.38% E 101-41000-413 Equipment Rental$ 1,900.00 $1,743.93$256.42$ 156.07 91.79% E 101-41000-430 Recycling$ 30,100.00 $0.00$0.00$ 30,100.00 0.00% E 101-41000-433 Dues and Subscriptions$ 6,100.00 $5,056.00$0.00$ 1,044.00 82.89% E 101-41000-434 Youth Service Bureau$ 5,500.00 $5,500.00$0.00$ - 100.00% E 101-41000-435 Misc Expense$ 500.00 $0.00$0.00$ 500.00 0.00% Website Host; ABDO accounting assistance E 101-41000-438 Misc. Contractual$ 4,000.00 $1,335.75($1,900.00)$ 2,664.25 33.39% E 101-41000-439 Refunds Issued$ - $0.00$0.00$ - 0.00% E 101-41000-560 Furniture and Fixtures$ - $0.00$0.00$ - 0.00% E 101-41000-570 Office Equipment$ 5,500.00 $1,983.26$0.00$ 3,516.74 36.06% E 101-41000-720 Operating Transfer$ - $146,620.00$146,620.00$ (146,620.00) 0.00% To Park Investment Fund for skating rink boards Total Admin & Finance Dept. Expenditures$ 235,805.22$ 12,380.9283.03% $ 284,000.00$ 48,194.78 CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget Balance% of BudgetComments GENERAL FUND CONT.CITY COUNCIL ExpendituresE 101-41110-101 Regular Wages & Salaries$ 18,100.00 $15,578.94$0.00$ 2,521.06 86.07% E 101-41110-122 FICA Employer Contribution$ 1,100.00 $237.71$0.00$ 862.29 21.61% E 101-41110-126 MEDICARE Employer Contribution$ 300.00 $173.85$0.00$ 126.15 57.95% E 101-41110-127 PERA Defined$ 600.00 $587.19$0.00$ 12.81 97.87% E 101-41110-151 Worker s Comp Insurance Prem$ 100.00 $95.00$0.00$ 5.00 95.00% E 101-41110-308 Other Professional Services$ - $30.00$0.00$ (30.00) 0.00% E 101-41110-316 Conferences & Seminars$ 700.00 $350.00$0.00$ 350.00 50.00% E 101-41110-331 Travel Expenses$ - $561.97$0.00$ (561.97) 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$ 20,900.00 $ 17,614.66 $ - $ 3,285.34 84.28% ELECTIONS ExpendituresE 101-41410-199 Election Judge$ - $ - $ - $ - 0.00% E 101-41410-200 Office Supplies$ - $ - $ - $ - 0.00% E 101-41410-203 Printed Forms & Papers$ - $ - $ - $ - 0.00% E 101-41410-210 Operating Supplies$ 200.00 $ - $ - $ 200.00 0.00% E 101-41410-351 Legal Notices Publishing$ - $ - $ - $ - 0.00% E 101-41410-413 Equipment Rental$ 850.00 $ 1,515.00 $ - $ (665.00) 178.24%Wash. Cty. Equip. Maintenance Fee Total Elections Dept. Expenditures$ 1,050.00 $ 1,515.00 $ - $ (465.00) 144.29% PLANNING & BUILDING ExpendituresE 101-41910-101 Regular Wages & Salaries$ 59,600.00 $57,485.25$4,307.84$ 2,114.75 54.31% E 101-41910-121 PERA Coord. Employer Contribu.$ 4,200.00 $3,237.69$323.08$ 962.31 42.71% E 101-41910-122 FICA Employer Contribution$ 3,700.00 $3,050.97$253.78$ 649.03 51.64% E 101-41910-126 MEDICARE Employer Contribution$ 900.00 $736.00$59.36$ 164.00 52.14% E 101-41910-131 Employer Paid Health$ 20,000.00 $14,631.21$1,367.18$ 5,368.79 45.81% E 101-41910-132 Dental Insurance$ 1,500.00 $584.64$54.81$ 915.36 24.36% E 101-41910-134 Employer Paid Life$ 200.00 $145.60$14.40$ 54.40 44.00% E 101-41910-135 Employer Paid Disability$ 500.00 $371.99$34.63$ 500.00 46.69% E 101-41910-203 Printed Forms & Papers$ 600.00 $0.00$0.00$ (59,903.74) 0.00% E 101-41910-311 Contract Permit Inspections$ 50,000.00 $60,503.74$9,710.87$ (20,567.91) 80.80% E 101-41910-312 Planning Services$ 50,000.00 $70,567.91$12,629.50$ 46,850.00 67.94% E 101-41910-313 Committee & Commission Reimbur$ 5,000.00 $3,150.00$0.00$ 5,000.00 37.00% E 101-41910-316 Conferences & Seminars$ 50.00 $0.00$0.00$ (73.00) 0.00% E 101-41910-319 Other Services$ - $123.00$0.00$ (5,400.60) 0.00% E 101-41910-361 Liability/Property Ins$ 4,900.00 $5,400.60$0.00$ 1,143.70 110.22% E 101-41910-438 Misc. Contractual$ 5,000.00 $3,756.30$0.00$ 4,400.00 53.22% E 101-41910-439 Refunds Issued$ 200.00 $600.00$500.00$ (400.00) 0.00% E 101-41910-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Planning & Building Dept. Expenditures$ 206,350.00 $ 224,344.90 $ 29,255.45 $ (18,222.91) 108.72% ASSESSOR ExpendituresE 101-41960-300 Assessor$ 21,600.00 $20,158.52$1,800.00$ 1,441.48 93.33% POLICE ExpendituresE 101-42100-318 Police Contract$ 168,499.00 $ 84,249.53 $ - $ 84,249.47 50.00% E 101-42100-319 Other Services$ 500.00 $959.36$ - $ (459.36) 61.87%2023 Code Red System Total GF Police Dept. Expenditures$ 168,999.00 $ 85,208.89 $ - $ 83,790.11 50.42% CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget Balance% of BudgetComments GENERAL FUND CONT.FIRE ExpendituresE 101-42200-101 Regular Wages & Salaries$ 147,200.00 $151,756.44$17,131.34$ (4,556.44) 103% E 101-42200-121 PERA Coord. Employer Contribu.$ - $0.00$0.00$ - 0% E 101-42200-122 FICA Employer Contribution$ 9,100.00 $8,850.19$1,051.36$ 249.81 97% E 101-42200-124 Police & Fire PERA$ 3,600.00 $8,364.50$637.18$ (4,764.50) 232% E 101-42200-126 MEDICARE Employer Contribution$ 2,100.00 $1,982.48$251.33$ 117.52 94% E 101-42200-134 Employer Paid Life$ 200.00 $176.00$16.00$ 24.00 88% E 101-42200-135 Employer Paid Disability$ 700.00 $0.00$0.00$ 700.00 0% E 101-42200-141 Unemployment Compensation$ - $0.00$0.00$ - 0% E 101-42200-151 Worker s Comp Insurance Prem$ 9,100.00 $11,617.00$0.00$ (2,517.00) 128% E 101-42200-200 Office Supplies$ 400.00 $197.87$0.00$ 202.13 49% E 101-42200-203 Printed Forms & Papers$ 150.00 $0.00$0.00$ 150.00 0% E 101-42200-209 Medical Supplies$ 3,000.00 $4,662.38$731.91$ (1,662.38) 155% Pagers $2,730; Fire Suppression supplies $686; E 101-42200-210 Operating Supplies$ 8,000.00 $7,135.70$55.64$ 864.30 89% Cintas; Dinners E 101-42200-211 Cleaning Supplies$ 100.00 $50.95$50.95$ 49.05 51% E 101-42200-212 Fuel$ 3,500.00 $5,093.92$492.95$ (1,593.92) 146% E 101-42200-217 Uniforms & Safety Equipment$ 10,000.00 $4,943.85$419.78$ 5,056.15 49% E 101-42200-221 Equipment Parts$ 3,000.00 $294.42$0.00$ 2,705.58 10% E 101-42200-222 Tires$ - $0.00$0.00$ - 0% E 101-42200-223 Structure Repair & Supplies$ 2,000.00 $399.78$0.00$ 1,600.22 20% E 101-42200-240 Small Tools and Minor Equip$ 9,000.00 $1,338.60$122.74$ 7,661.40 15% SCBA User Exams + Annual Fit Test E 101-42200-305 Medical Services$ 3,500.00 $4,610.00$0.00$ (1,110.00) 132% E 101-42200-306 Personal Testing & Recruit$ 1,300.00 $1,391.30$0.00$ (91.30) 107% E 101-42200-309 Software Support & Maintenance$ 17,000.00 $13,986.52$1,056.00$ 3,013.48 82% E 101-42200-310 Medical Training$ 2,000.00 $12,000.00$12,000.00$ (10,000.00) 600% E 101-42200-316 Conferences & Seminars$ 250.00 $0.00$0.00$ 250.00 0% E 101-42200-317 Employee Training$ 15,000.00 $5,763.76$950.00$ 9,236.24 38% E 101-42200-319 Other Services$ 500.00 $0.00$0.00$ 500.00 0% E 101-42200-321 Telephone$ 6,800.00 $5,527.91$532.23$ 1,272.09 81% E 101-42200-322 Postage$ - $0.00$0.00$ - 0% E 101-42200-324 State of MN-Fire Relief$ 35,300.00 $47,147.82$47,147.82$ (11,847.82) 134% E 101-42200-325 City Match-Fire Relief$ - $0.00$0.00$ - 0% E 101-42200-331 Travel Expenses$ 1,500.00 $1,693.39$0.00$ (193.39) 113% E 101-42200-334 Licenses & Permits$ 200.00 $536.25$0.00$ (336.25) 268% MN Board of Firefighter Training & Education License E 101-42200-340 Advertising$ - $0.00$0.00$ - 0% E 101-42200-361 Liability/Property Ins$ 6,500.00 $6,989.37$0.00$ (489.37) 108% E 101-42200-381 Utilities-Electric & Gas$ 8,000.00 $4,668.69$173.81$ 3,331.31 58% E 101-42200-384 Refuse/Garbage Disposal$ 1,100.00 $847.37$97.94$ 252.63 77% E 101-42200-385 Sewer Pumping & Maintenance$ 700.00 $0.00$0.00$ 700.00 0% E 101-42200-401 Building Maintenance/Repairs$ 2,500.00 $4,213.90$228.03$ (1,713.90) 169%Cleaning, Pest Control, Glass door repair E 101-42200-403 Improvements Other Than Bldgs$ - $0.00$0.00$ - 0% E 101-42200-404 Repair Machinery/Equipment$ 8,000.00 $17,936.90$4,869.04$ (9,936.90) 224% E 101-42200-407 Well Repair & Maintenance$ - $0.00$0.00$ - 0% E 101-42200-433 Dues and Subscriptions$ 2,400.00 $3,214.90$0.00$ (814.90) 134%Truck inspection renewal $1,685 E 101-42200-438 Misc. Contractual$ 4,100.00 $2,685.00$0.00$ 1,415.00 65% E 101-42200-440 Events$ 800.00 $1,196.09$552.21$ (396.09) 150% Taco Daze, Fire Prevention week, Safe Halloween E 101-42200-520 Capital Improvements to Bldgs$ - $6,264.00$6,264.00$ (6,264.00) 0% E 101-42200-530 Capital Impr Other Than Bldgs$ - $0.00$0.00$ - 0% E 101-42200-540 Heavy Machinery Capital$ - $0.00$0.00$ - 0% E 101-42200-560 Furniture and Fixtures$ 500.00 $235.90$0.00$ 264.10 47% E 101-42200-570 Office Equipment$ 900.00 $179.98$0.00$ 720.02 20% Total Fire Dept Expenditures$ 330,000.00 $ 347,953.13 $ 94,832.26 $ (17,953.13) 105.44% ANIMAL CONTROL ExpendituresE 101-42700-314 Animal Control$ 5,000.00 $6,335.01$816.94$ (1,335.01) 126.70% CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget Balance% of BudgetComments GENERAL FUND CONT.PUBLIC WORKS ExpendituresE 101-43000-101 Regular Wages & Salaries$ 229,700.00 $198,336.45$18,214.19$ 31,363.55 86% E 101-43000-102 OT Regular Wages$ 5,000.00 $5,520.49$116.77$ (520.49) 110% E 101-43000-104 Temporary Employee Wages$ 2,300.00 $4,162.73$0.00$ (1,862.73) 181%snowplowing E 101-43000-121 PERA Coord. Employer Contribu.$ 17,600.00 $15,259.08$1,374.81$ 2,340.92 87% E 101-43000-122 FICA Employer Contribution$ 14,600.00 $12,006.64$1,074.53$ 2,593.36 82% E 101-43000-126 MEDICARE Employer Contribution$ 3,400.00 $3,005.87$251.31$ 394.13 88% E 101-43000-131 Employer Paid Health$ 70,900.00 $56,657.59$4,860.27$ 14,242.41 80% E 101-43000-132 Dental Insurance$ 2,300.00 $1,057.81$88.15$ 1,242.19 46% E 101-43000-134 Employer Paid Life$ 700.00 $642.40$62.16$ 57.60 92% E 101-43000-135 Employer Paid Disability$ 1,700.00 $1,562.87$115.04$ 137.13 92% E 101-43000-141 Unemployment Compensation$ - $0.00$0.00$ - 0% E 101-43000-151 Worker s Comp Insurance Prem$ 19,800.00 $26,476.50$0.00$ (6,676.50) 134% E 101-43000-200 Office Supplies$ 600.00 $53.99$0.00$ 546.01 9% E 101-43000-210 Operating Supplies$ 8,400.00 $8,296.49$526.25$ 103.51 99% E 101-43000-212 Fuel$ 20,000.00 $25,069.35$2,524.00$ (5,069.35) 125% E 101-43000-217 Uniforms & Safety Equipment$ 2,200.00 $2,194.39$0.00$ 5.61 100% plow repair parts E 101-43000-221 Equipment Parts$ 14,000.00 $16,951.99$238.78$ (2,951.99) 121% E 101-43000-222 Tires$ 7,500.00 $1,287.89$1,287.89$ 6,212.11 17% E 101-43000-223 Structure Repair & Supplies$ 2,200.00 $56.42$0.00$ 2,143.58 3% E 101-43000-224 Materials for Road Maintenance$ 16,500.00 $3,587.88$271.92$ 12,912.12 22% E 101-43000-226 Sign Replacement and Repair$ - $173.83$0.00$ (173.83) 0% E 101-43000-228 Gravel$ 10,000.00 $6,862.87$0.00$ 3,137.13 69% snow, snow & snow E 101-43000-229 Salt$ 20,000.00 $28,068.71$0.00$ (8,068.71) 140% E 101-43000-240 Small Tools and Minor Equip$ 8,000.00 $3,875.58$0.00$ 4,124.42 48% E 101-43000-302 Surveying$ - $0.00$0.00$ - 0% E 101-43000-303 Engineering Fees$ 10,000.00 $13,704.00$120.00$ (3,704.00) 137%Gen. Eng. & Crack filling & seal coat fees E 101-43000-304 Legal Services$ - $0.00$0.00$ - 0% E 101-43000-305 Medical Services$ 1,200.00 $285.65$13.80$ 914.35 24% IWORQ subscription; GIS map updates E 101-43000-309 Software Support & Maintenance$ 2,000.00 $13,198.00$0.00$ (11,198.00) 660% E 101-43000-317 Employee Training$ 1,700.00 $1,210.00$0.00$ 490.00 71% E 101-43000-319 Other Services$ 13,600.00 $6,021.55$105.10$ 7,578.45 44% E 101-43000-321 Telephone$ 3,000.00 $3,745.10$354.08$ (745.10) 125% E 101-43000-331 Travel Expenses$ 500.00 $0.00$0.00$ 500.00 0% E 101-43000-334 Licenses & Permits$ 500.00 $10.00$0.00$ 490.00 2% E 101-43000-361 Liability/Property Ins$ 9,000.00 $8,348.14$0.00$ 651.86 93% E 101-43000-365 Insurance Claims$ - $0.00$0.00$ - 0% E 101-43000-381 Utilities-Electric & Gas$ 4,000.00 $3,421.06$143.21$ 578.94 86% E 101-43000-384 Refuse/Garbage Disposal$ 1,000.00 $730.53$65.29$ 269.47 73% E 101-43000-385 Sewer Pumping & Maintenance$ 1,600.00 $0.00$0.00$ 1,600.00 0% E 101-43000-387 Street Light Utilities$ 4,200.00 $3,635.78$385.09$ 564.22 87% E 101-43000-401 Building Maintenance/Repairs$ 8,000.00 $3,823.37$271.32$ 4,176.63 48% E 101-43000-403 Improvements Other Than Bldgs$ - $0.00$0.00$ - 0% plow truck repairs E 101-43000-404 Repair Machinery/Equipment$ 15,500.00 $25,588.32$1,540.00$ (10,088.32) 165% Street light repair $3,422; Patching $10,488, Dust Control $21,900; Crack Fill & Seal Coat $150,824 E 101-43000-405 Contractual Road Maint/Repair$ 157,500.00 $119,461.25$0.00$ 38,038.75 76% moved to LRIF E 101-43000-407 Well Repair & Maintenance$ - $0.00$0.00$ - 0% E 101-43000-413 Equipment Rental$ 4,000.00 $0.00$0.00$ 4,000.00 0% E 101-43000-417 Uniform Rental$ 1,100.00 $950.96$96.40$ 149.04 86% E 101-43000-433 Dues and Subscriptions$ 200.00 $0.00$0.00$ 200.00 0% E 101-43000-438 Misc. Contractual$ 15,750.00 $7,275.80$1,344.88$ 8,474.20 46% E 101-43000-439 Refunds Issued$ - $0.00$0.00$ - 0% E 101-43000-530 Capital Impr Other Than Bldgs$ - $0.00$0.00$ - 0% E 101-43000-550 Motor Vehicles Capital$ - $0.00$0.00$ - 0% E 101-43000-560 Furniture and Fixtures$ - $0.00$0.00$ - 0% E 101-43000-570 Office Equipment$ 1,000.00 $406.53$0.00$ 593.47 41% E 101-43000-720 Operating Transfers$ - $ - $ - $ - 0% Total Public Works Dept. Expenditures$ 732,750.00 $ 632,983.86 $ 35,445.24 $ 99,766.14 86.38% CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget Balance% of BudgetComments GENERAL FUND CONT.PARKS & RECREATION ExpendituresE 101-45000-101 Regular Wages & Salaries$ 10,200.00 $7,365.35$764.56$ 2,834.65 72.21% E 101-45000-104 Temporary Employee Wages$ 40,200.00 $19,368.26$0.00$ 20,831.74 48.18% E 101-45000-121 PERA Coord. Employer Contribu.$ 800.00 $549.31$57.34$ 250.69 68.66% E 101-45000-122 FICA Employer Contribution$ 3,300.00 $1,610.32$44.84$ 1,689.68 48.80% E 101-45000-126 MEDICARE Employer Contribution$ 800.00 $403.95$10.48$ 396.05 50.49% E 101-45000-131 Employer Paid Health$ 2,700.00 $2,002.80$185.45$ 697.20 74.18% E 101-45000-132 Dental Insurance$ 100.00 $38.40$3.20$ 61.60 38.40% E 101-45000-134 Employer Paid Life$ - $24.52$2.24$ (24.52) 0.00% E 101-45000-135 Employer Paid Disability$ 1,000.00 $54.71$4.48$ 945.29 5.47% E 101-45000-141 Unemployment Compensation$ - $0.00$0.00$ - 0.00% E 101-45000-151 Worker s Comp Insurance Prem$ 1,900.00 $2,614.50$0.00$ (714.50) 137.61% E 101-45000-200 Office Supplies$ 310.00 $0.00$0.00$ 310.00 0.00% E 101-45000-203 Printed Forms & Papers$ 930.00 $0.00$0.00$ 930.00 0.00% E 101-45000-210 Operating Supplies$ 930.00 $728.87$0.00$ 201.13 78.37% E 101-45000-212 Fuel$ 1,650.00 $250.72$0.00$ 1,399.28 15.20% E 101-45000-221 Equipment Parts$ 2,100.00 $1,372.60$0.00$ 727.40 65.36% E 101-45000-223 Structure Repair & Supplies$ 2,100.00 $1,096.26$0.00$ 1,003.74 52.20% E 101-45000-240 Small Tools and Minor Equip$ 400.00 $323.76$0.00$ 76.24 80.94% E 101-45000-312 Planning Services$ - $0.00$0.00$ - 0.00% E 101-45000-313 Committee & Commission Reimbur$ 1,200.00 $720.00$0.00$ 480.00 60.00% E 101-45000-319 Other Services$ - $1,380.50$112.75$ (1,380.50) 0.00% E 101-45000-322 Postage$ - $0.00$0.00$ - 0.00% SCVRTA 2023 Ad E 101-45000-340 Advertising$ 200.00 $0.00($250.00)$ 200.00 0.00% E 101-45000-353 Sales& Use Tax$ - $0.00$0.00$ - 0.00% E 101-45000-361 Liability/Property Ins$ 3,300.00 $3,323.03$0.00$ (23.03) 100.70% E 101-45000-381 Utilities-Electric & Gas$ 4,500.00 $4,630.39$294.12$ (130.39) 102.90% E 101-45000-384 Refuse/Garbage Disposal$ 2,500.00 $5,211.92$998.00$ (2,711.92) 208.48%new refuse hauler E 101-45000-385 Sewer Pumping & Maintenance$ 700.00 $876.16$0.00$ (176.16) 125.17%Warming House ice melt product E 101-45000-401 Building Maintenance/Repairs$ 4,800.00 $4,122.91$120.00$ 677.09 85.89% E 101-45000-403 Improvements Other Than Bldgs$ - $420.64$0.00$ (420.64) 0.00% E 101-45000-404 Repair Machinery/Equipment$ 750.00 $396.59$0.00$ 353.41 52.88% E 101-45000-406 Grounds Care$ 4,000.00 $3,724.22$500.00$ 275.78 93.11% E 101-45000-438 Misc. Contractual$ 3,300.00 $2,830.00$1,050.00$ 470.00 85.76% E 101-45000-439 Refunds Issued$ - $565.01$0.00$ (565.01) 0.00% Vinterfest E 101-45000-440 Events$ 7,000.00 $5,354.19$292.00$ 1,645.81 76.49% E 101-45000-490 Financial Assistance$ - $ - $ - $ - 0.00% E 101-45000-530 Capital Impr Other Than Bldgs$ 10,000.00 $ - $ - $ 10,000.00 0.00%Rink board and fencing improvements E 101-45000-720 Operating Transfers$ - $ - $ - $ - 0.00% Total Parks & Rec Dept. Expenditures$ 111,670.00 $ 71,359.89 $ 4,189.46 $ 40,310.11 63.90% CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget Balance% of BudgetComments GENERAL FUND CONT.COMMUNITY CENTER ExpendituresE 101-45180-101 Regular Wages & Salaries$ 15,000.00 $12,510.11$1,100.26$ 2,489.89 83.40% E 101-45180-104 Temporary Employee Wages$ - $0.00$0.00$ - 0.00% E 101-45180-121 PERA Coord. Employer Contribu.$ 1,100.00 $917.88$82.52$ 182.12 83.44% E 101-45180-122 FICA Employer Contribution$ 900.00 $729.38$64.34$ 170.62 81.04% E 101-45180-126 MEDICARE Employer Contribution$ 200.00 $180.17$15.07$ 19.83 90.09% E 101-45180-131 Employer Paid Health$ 3,700.00 $2,627.70$255.60$ 1,072.30 71.02% E 101-45180-134 Employer Paid Life$ - $37.08$3.60$ (37.08) 0.00% E 101-45180-135 Employer Paid Disability$ 200.00 $106.92$8.48$ 93.08 53.46% E 101-45180-151 Worker s Comp Insurance Prem$ - $0.00$0.00$ - 0.00% E 101-45180-210 Operating Supplies$ 2,900.00 $2,843.69$169.95$ 56.31 98.06% E 101-45180-223 Structure Repair & Supplies$ 6,500.00 $172.87$0.00$ 6,327.13 2.66% E 101-45180-334 Licenses & Permits$ 1,000.00 $792.00$0.00$ 208.00 79.20% E 101-45180-361 Liability/Property Ins$ 800.00 $795.60$0.00$ 4.40 99.45% E 101-45180-381 Utilities-Electric & Gas$ 11,200.00 $7,983.41$566.48$ 3,216.59 71.28% E 101-45180-384 Refuse/Garbage Disposal$ 1,900.00 $3,095.02$514.34$ (1,195.02) 162.90%new refuse hauler E 101-45180-385 Sewer Pumping & Maintenance$ 3,700.00 $3,408.32$0.00$ 291.68 92.12% Remove ice from Comm Ctr roof E 101-45180-401 Building Maintenance/Repairs$ 15,000.00 $13,192.78$678.91$ 1,807.22 87.95% E 101-45180-404 Repair Machinery/Equipment$ 5,000.00 $2,435.14$175.00$ 2,564.86 48.70% ice control products E 101-45180-406 Grounds Care$ 690.00 $1,254.57$554.57$ (564.57) 181.82% E 101-45180-407 Well Repair & Maintenance$ 1,000.00 $0.00$0.00$ 1,000.00 0.00% Helke's winter lighting work E 101-45180-438 Misc. Contractual$ 2,700.00 $2,057.12$557.12$ 642.88 76.19% E 101-45180-439 Refunds Issued$ - $450.00$0.00$ (450.00) 0.00% Council Chambers remodel E 101-45180-520 Capital Improvements to Bldgs$ 6,000.00 $7,475.61$0.00$ (1,475.61) 124.59% E 101-45180-530 Capital Impr Other Than Bldgs$ - $ - $ - $ - 0.00% E 101-45180-570 Office Equipment$ - $ - $ - $ - 0.00% E 101-45180-720 Operating Transfers$ - $ - $ - 0.00% Total Community Center Dept. Expenditures$ 79,490.00 $63,065.37$4,746.24$ 16,424.63 79.34% TOTAL GENERAL FUND EXPENDITURES$ 2,182,509.00 $ 1,988,923.58 $ 344,930.1491.13% E 101-49000-421 Cash Over/Short$50.00 Operating TransfersE 101-49000-720 Operating Transfers$3,998,000.01$600,000.00 TOTAL GENERAL FUND EXPENDITURES W/TRANSFERS$ 5,986,973.59 $ 944,930.14 CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget 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.00 $5,300.00$2,650.00$ 2,650.00 50.00% R 225-46500-33640 Other Grants$ - $0.00$0.00$ - 0.00% R 225-46500-34750 Facilities Rental$ - $800.00$700.00$ - 0.00% R 225-46500-36210 Interest Income$ 200.00 $0.00$0.00$ 200.00 0.00% R 225-46500-36230 Donations$ - $300.00$300.00$ - 0.00% R 225-46500-39203 Transfer from Other Funds$ - $3,524.94$0.00$ (3,524.94) 0.00% transfer of property tax settlement from checking Total EDA Fund Revenue$ 5,500.00$9,924.94$3,650.00$ (674.94)180.45% ExpenditureE 225-46500-210 Operating Supplies$ 500.00 $3,524.94$0.00$ (3,024.94) 704.99% journal entry for transfer between EDA accounts E 225-46500-303 Engineering Fees$ - $0.00$0.00$ - 0.00% E 225-46500-304 Legal Services$ - $0.00$0.00$ - 0.00% E 225-46500-308 Other Professional Services$ 300.00 $0.00$0.00$ 300.00 0.00% E 225-46500-340 Advertising$ 2,000.00 $1,487.00$842.00$ 513.00 74.35% EDAM Membership; Sister City Dues E 225-46500-433 Dues and Subscriptions$ 1,700.00 $1,168.00$0.00$ 532.00 68.71% E 225-46500-440 Events$ 800.00 $1,542.20$480.00$ (742.20) 192.78%Sister City & Vinterlights E 225-46500-720 Operating Transfers$ - $ - $ - $ - 0.00% Total EDA Fund Expenditures$ 5,300.00$7,722.14$ 1,322.00$ (2,422.14)145.70% CABLE TV FUND RevenueR 226-41950-36210 Interest Income$ 100.00 $0.00$0.00$ 100.00 0.00% R 226-41950-36260 Sale of Equipment$ - $300.00$0.00$ (300.00) 0.00% R 226-41950-38050 Cable TV Franchise Rebates$ 16,200.00 $16,838.64$1,678.75$ (638.64) 103.94% R 226-41950-38051 PEG Fees$ 4,200.00 $4,515.27$451.19$ (315.27) 107.51% Total Cable TV Fund Revenue$ 20,500.00$ 21,653.91$ 2,129.94$ (1,153.91)105.63% AV equipment; network cord & wallplate in Council ExpenditureE 226-41950-240 Small Tools and Minor Equip$ 300.00 $604.25$0.00$ (304.25) 201.42% Chambers E 226-41950-309 Software Support & Maintenance$ 3,500.00 $3,123.57$192.07$ 376.43 89.24% E 226-41950-438 Misc. Contractual$ 5,300.00 $6,369.00$0.00$ (1,069.00) 120.17%Zoom subscription & LATV filming E 226-41950-570 Office Equipment$ - $4,128.98$0.00$ (4,128.98) 0.00% Total Cable TV Fund Expenditures$ 9,100.00$ 14,225.80$ 192.07 $ (5,125.80)156.33% GATEWAY TRAIL FUND RevenueR 230-45000-36230 Donations$ - $ - $ - $ - 0.00% ExpenditureE 230-45000-308 Other Professional Services$ - $ - $ - $ - 0.00% 2013 EQUIPMENT CERTIFICATES RevenueR 313-47000-31000 Washington Cty. Tax Settlement$ 64,000.00 $ 64,000.00 $ 32,000.00 $ - 100.00% ExpenditureE 313-47000-601 Long Term Debt Principal$ 60,000.00 $ 60,000.00 $ - $ - 100.00% E 313-47000-611 Long Term Debt Interest$ 3,047.00 $ 930.00 $ - $ 2,117.00 30.52% E 313-47000-620 Fiscal Agent s Fees$ 500.00 $ - $ - $ 500.00 0.00% Total 2013 Fund Expenditures$ 63,547.00$ 60,930.00$ -$ 2,617.0095.88% 2018 STREET RECONSTRUCTION RevenueR 318-47000-31000 Washington Cty. Tax Settlement$ 342,546.00 $342,536.00$171,268.00$10.00100.00% ExpenditureE 318-47000-601 Long Term Debt Principal$ 250,000.00 $235,000.00$235,000.00$15,000.0094.00% E 318-47000-611 Long Term Debt Interest$ 91,225.00 $91,225.02$45,612.51($0.02)100.00% E 318-47000-620 Fiscal Agent s Fees$ 500.00 $ 495.00 $ - $5.0099.00% Total 2018 Street Reconstruction Fund Expenditures$ 341,725.00$ 326,720.02$ 280,612.51$ 15,004.9895.61% CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget Balance% of BudgetComments CAPITAL IMPROVEMENTS RevenueR 401-48000-31000 Washington Cty. Tax Settlement$ 293,791.00 $293,790.00$146,895.00$1.00100.00% R 401-48000-33422 Other State Grants & Aids$ - $56,231.78$0.00($56,231.78)0.00% R 401-48000-36210 Interest Income$ 2,300.00 $ - $ - $ 2,300.00 0.00% Total Capital Improvement Fund Revenue$ 296,091.00$ 350,021.78$ 146,895.00$ (53,930.78)118.21% ExpenditureE 401-41000-312 Planning Services$ - $ - $ - $ - 0.00% E 401-41000-520 Capital Improvements to Bldgs$ - $ - $ - $ - 0.00% E 401-41000-530 Capital Impr Other Than Bldgs$ 169,500.00 $ - $ - $ 169,500.00 0.00% E 401-42200-520 Capital Improvements to Bldgs$ 65,000.00 $90,034.00$0.00($25,034.00)138.51%Generator E 401-48000-303 Engineering Fees$ - $9,817.50$174.00($9,817.50)0.00%Gateway Trail Engineering E 401-48000-308 Other Professional Services$ - $26,400.00$2,400.00($26,400.00)0.00%Gateway Trail Lobbying E 401-48000-312 Planning Services$ - $ - $ - $ - 0.00% E 401-48000-435 Misc Expense$ - $ - $ - $ - 0.00% E 401-48000-438 Misc. Contractual$ - $ - $ - $ - 0.00% E 401-48000-520 Capital Improvements to Bldgs$ - $ - $ - $ - 0.00% E 401-48000-530 Capital Impr Other Than Bldgs$ 100,000.00 $ - $ - $ 100,000.00 0.00% Total Capital Improvement Fund Expenditures$ 334,500.00 $ 126,251.50 $ 2,574.00 $ 208,248.50 37.74% PARK DEVELOPMENT RevenueR 404-48000-31000 Washington Cty. Tax Settlement$ 20,000.00 $20,000.00$10,000.00$0.00100.00% R 404-48000-33422 Other State Grants & Aids$ - $ - $ - $ - 0.00% R 404-48000-34780 Park Dedication Fees$ 21,000.00 $24,000.00$0.00($3,000.00)114.29% R 404-48000-36210 Interest Income$ 66.00 $ - $ - $ 66.00 0.00% Lions Playground donation; Bench donation moved to R 404-48000-36230 Donations$ - $10,000.00$0.00($10,000.00)0.00% Gen Fund Transfer from General Fund for rink boards R 404-48000-39203 Transfer from Other Funds$ - $146,620.00$146,620.00$0.000.00% Total Park Development Fund Revenue$ 41,066.00$200,620.00$156,620.00($12,934.00)488.53% ExpenditureE 404-48000-312 Planning Services$ - $ 4,500.00 $ - $ (4,500.00) 0.00% E 404-48000-520 Capital Improvements to Bldgs$ - $ - $ - $ - 0.00% E 404-48000-530 Capital Impr Other Than Bldgs$ 17,306.00 $268,823.79$191,937.16($251,517.79)1553.36% Playground equipment; Hay Lake & Liten park signs E 404-48000-720 Operating Transfers$ - $ 3,048.00 $ - $ (3,048.00) 0.00% loan repayment to Gen Capital Fund 401 Total Park Development Fund Expenditures$ 17,306.00$ 276,371.79$ 191,937.16$ (259,065.79) 1596.97% EQUIPMENT REPLACEMENT RevenueR 406-48500-31000 Washington Cty. Tax Settlement$ - $ - $ - $ - 0.00% R 406-48500-36210 Interest Income$ 1,030.00 $ - $ - $ 1,030.00 0.00% R 406-48500-36260 Sale of Equipment$ 35,000.00 $18,851.00$18,851.00$16,149.0053.86% R 406-48500-39350 Certificate of Indebtedness$ 819,500.00 $ - $ - $ 819,500.00 0.00% Total Equipment Replacement Fund Revenue$ 855,530.00$ 18,851.00$ 18,851.00$ 836,679.002.20% ExpenditureE 406-48500-540 Heavy Machinery Capital$ 325,000.00 $63,018.78$0.00$261,981.2219.39%John Deere mower, snowblower & broom E 406-48500-550 Motor Vehicles Capital$ 189,500.00 $12,717.25$0.00$176,782.756.71%25% payment for Fire Rescue boat Total Equipment Replacement Fund Expenditures$ 514,500.00$ 75,736.03$ -$ 438,763.9714.72% LOCAL ROAD IMPROVEMENT FUND RevenueR 408-43100-31000 Washington Cty. Tax Settlement$ 212,012.00 $212,012.00$106,006.00$ - 100.00% R 408-43100-33422 Other State Grants & Aids$ - $ - $ - $ - 0.00% R 408-43100-36210 Interest Income$ 12,115.00 $ - $ - $ 12,115.00 0.00% R 408-43100-39310 Proceeds-Gen Obligation Bond$ - $ - $ - $ - 0.00% Total LRIF Revenue$ 224,127.00$ 212,012.00$ 106,006.00$ 12,115.0094.59% ExpenditureE 408-43100-303 Engineering Fees$ 20,000.00 $97,261.50$21,242.50($77,261.50)486.31% E 408-43100-530 Capital Impr Other Than Bldgs$ 973,000.00 $821,832.06$0.00$151,167.9484.46% Total LRIF Expenditures$ 993,000.00 $ 919,093.56 $ 21,242.50 $ 73,906.44 92.56% CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget Balance% of BudgetComments BIG MARINE SEWER RevenueR 602-43210-31951 Special Assessments Principal$ - $3,361.44$1,295.50($3,361.44)0.00% R 602-43210-31952 SA Penalties & Interest$ - $437.13$155.46($437.13)0.00% R 602-43210-33422 Other State Grants & Aids$ - $0.00$0.00$0.000.00% R 602-43210-34401 Sewer User Fees$ 140,700.00 $97,691.11$10,328.63$43,008.8969.43% R 602-43210-34402 Sewer Connection Fee$ - $8,000.00$0.00($8,000.00)0.00% R 602-43210-36100 Special Assessments$ 600.00 $0.00$0.00$600.000.00% R 602-43210-36102 Penalties and Interest$ - $132.41$44.38($132.41)0.00% R 602-43210-36210 Interest Income$ 400.00 $ - $ - $ 400.00 0.00% Total Big Marine Sewer Revenue$ 141,700.00 $ 109,622.09 $ 11,823.97 $ 32,077.91 77.36% ExpenditureE 602-43210-101 Regular Wages & Salaries$ 22,500.00 $18,271.60$1,504.96$4,228.4081.21% E 602-43210-102 OT Regular Wages$ - $0.00$0.00$0.000.00% E 602-43210-120 Pension Expense$ - $0.00$0.00$0.000.00% E 602-43210-121 PERA Coord. Employer Contribu.$ 17,000.00 $1,368.19$112.88$15,631.818.05% E 602-43210-122 FICA Employer Contribution$ 1,400.00 $1,066.62$88.68$333.3876.19% E 602-43210-126 MEDICARE Employer Contribution$ 300.00 $263.93$20.73$36.0787.98% E 602-43210-131 Employer Paid Health$ - $0.00$0.00$0.000.00% E 602-43210-151 Worker s Comp Insurance Prem$ 700.00 $736.40$0.00($36.40)105.20% E 602-43210-200 Office Supplies$ 200.00 $0.00$0.00$200.000.00% E 602-43210-210 Operating Supplies$ 2,500.00 $1,490.63$4.99$1,009.3759.63% E 602-43210-240 Small Tools and Minor Equip$ 600.00 $0.00$0.00$600.000.00% Bliss Collector Permit Renewal E 602-43210-303 Engineering Fees$ 10,500.00 $69,332.50$1,593.00($58,832.50)660.31% E 602-43210-304 Legal Services$ - $18.00$0.00($18.00)0.00% E 602-43210-308 Other Professional Services$ 2,500.00 $6,905.00$1,692.00($4,405.00)276.20%Pace Analytical monthly testing E 602-43210-309 Software Support & Maintenance$ 1,300.00 $0.00$0.00$1,300.000.00% E 602-43210-317 Employee Training$ 1,400.00 $336.00$68.02$1,064.0024.00% E 602-43210-321 Telephone$ 2,400.00 $2,527.50$393.30($127.50)105.31% E 602-43210-322 Postage$ 600.00 $0.00$0.00$600.000.00% E 602-43210-331 Travel Expenses$ 200.00 $632.55$0.00($432.55)316.28% E 602-43210-334 Licenses & Permits$ 1,600.00 $729.00$0.00$871.0045.56% E 602-43210-361 Liability/Property Ins$ 3,000.00 $3,449.06$0.00($449.06)114.97% E 602-43210-381 Utilities-Electric & Gas$ 2,500.00 $3,618.95$7,618.88($1,118.95)144.76%Connexus & Excel E 602-43210-385 Sewer Pumping & Maintenance$ 15,000.00 $4,395.22$625.00$10,604.7829.30% E 602-43210-386 Operation & Maintenance$ 5,000.00 $2,639.00$500.00$2,361.0052.78% E 602-43210-404 Repair Machinery/Equipment$ 16,000.00 $12,100.90$0.00$3,899.1075.63%Lift Station #2 pump replacement E 602-43210-413 Equipment Rental$ 400.00 $0.00$0.00$400.000.00% E 602-43210-420 Depreciation Expense$ 54,300.00 $0.00$0.00$54,300.000.00% E 602-43210-438 Misc. Contractual$ 10,000.00 $930.00$650.00$9,070.009.30% E 602-43210-439 Refunds Issued$ - $ - $ - $ - 0.00% E 602-43210-530 Capital Impr Other Than Bldgs$ 9,800.00 $ 2,990.00 $ 2,990.00 $ 6,810.00 30.51% Total Big Marine Sewer Expenditures$ 181,700.00$133,801.05$17,862.44$47,898.9573.64% CITY OF SCANDIA Revenue - Expenditure Summary November 2023 November Description2023 Budget2023 YTD AmountAmountBudget Balance% of BudgetComments UPTOWN SEWER RevenueR 612-43210-34401 Sewer User Fees$ 22,300.00 $16,995.43$5,282.36$5,304.5776.21% R 612-43210-36210 Interest Income$ 200.00 $ - $ - $ 200.00 0.00% Total Uptown Sewer Revenue$ 22,500.00$ 16,995.43$ 5,282.36$ 5,504.5775.54% ExpenditureE 612-43210-101 Regular Wages & Salaries$ 9,700.00 $7,614.52$585.94$2,085.4878.50% E 612-43210-102 OT Regular Wages$ - $0.00$0.00$0.000.00% E 612-43210-120 Pension Expense$ - $0.00$0.00$0.000.00% E 612-43210-121 PERA Coord. Employer Contribu.$ 700.00 $570.28$43.94$129.7281.47% E 612-43210-122 FICA Employer Contribution$ 600.00 $444.12$34.39$155.8874.02% E 612-43210-126 MEDICARE Employer Contribution$ 100.00 $109.86$8.03($9.86)109.86% E 612-43210-131 Employer Paid Health$ - $0.00$0.00$0.000.00% E 612-43210-151 Worker s Comp Insurance Prem$ 200.00 $315.60$0.00($115.60)157.80% E 612-43210-200 Office Supplies$ 100.00 $0.00$0.00$100.000.00% E 612-43210-210 Operating Supplies$ 300.00 $0.00$0.00$300.000.00% E 612-43210-221 Equipment Parts$ 300.00 $0.00$0.00$300.000.00% E 612-43210-303 Engineering Fees$ 1,000.00 $0.00$0.00$1,000.000.00% E 612-43210-304 Legal Services$ - $0.00$0.00$0.000.00% E 612-43210-308 Other Professional Services$ 500.00 $733.00$0.00($233.00)146.60%58% increase in testing costs E 612-43210-309 Software Support & Maintenance$ - $0.00$0.00$0.000.00% E 612-43210-317 Employee Training$ 350.00 $0.00$0.00$350.000.00% E 612-43210-319 Other Services$ - $0.00$0.00$0.000.00% E 612-43210-322 Postage$ - $0.00$0.00$0.000.00% E 612-43210-334 Licenses & Permits$ 400.00 $247.00$0.00$153.0061.75% E 612-43210-361 Liability/Property Ins$ 400.00 $477.82$0.00($77.82)119.46% E 612-43210-381 Utilities-Electric & Gas$ 1,700.00 $667.91$65.04$1,032.0939.29% E 612-43210-385 Sewer Pumping & Maintenance$ 1,500.00 $1,500.00$0.00$0.00100.00% E 612-43210-386 Operation & Maintenance$ 700.00 $0.00$0.00$700.000.00% E 612-43210-404 Repair Machinery/Equipment$ 2,000.00 $0.00$0.00$2,000.000.00% E 612-43210-420 Depreciation Expense$ 5,100.00 $0.00$0.00$5,100.000.00% E 612-43210-438 Misc. Contractual$ 1,300.00 $140.00$0.00$1,160.0010.77% E 612-43210-530 Capital Impr Other Than Bldgs$ 4,500.00 $ - $ - $ 4,500.00 0.00% Total Uptown Sewer Expenditures$ 31,450.00$ 12,820.11$ 737.34 $ 18,629.8940.76%