Loading...
06.b Nov 2022 Treasurer Reportaug i➢I �3 SGANDIA FUND ACCOUNTING Beginning Cash Balance 11/1/2022 Beginning Checking Balance Checking Receipts Transfers to Checking Total Deposits Expenditures Payroll Transfer to EDA in Transit Total Payments Ending Checking Balance Beginnging Money Market Balance Money Market Receipts Tranfer to Checking Ending Money Market Balance Beginning Investments Balance Investments Receipts Ending Investments Balance Beginning EDA Balance EDA Receipts EDA Expenditures EDA Transfers to Checking EDA Transfers from Checking Ending EDA Balance Outstanding Checks Ending Cash Balance 11/30/2022 City of Scandia Treasurer's Report 11/30/2022 $ 90,579.19 $ 54,538.30 $ 95,000.00 $ 149,538.30 $ (98,734.81) $ (32,421.95) $ (131,156.76) $ 1,263,924.71 $ 247.86 $ (95,000.00) $ 2,034,697.24 $ 2,034,697.24 $ 175.00 $ (1,021.08) $ 29,831.13 $ (8,484.26) CHECKING, MONEY MARKET & INVESTMENT CD's Checking *102 Beg Bal $ 91,404.19 Credits $ 149,713.30 Debits $ (131,331.76) Transfer in Transit End Bal $ 109,785.73 Money Market *105 - Rate .25% Beg Bal $ 1,263,924.71 rate change from 1.25% Credits $ 247.86 Debits $ (95,000.00) End Bal $ 1,169,172.57 Investments CD *4422 - Rate .45% 12 mo., 3/25/2023 $ 317,535.51 CD *4424 - Rate 2.50% 12 mo., 7/17/2023 **NEW RATE $ 444,108.54 CD *4425 - Rate 2.875% 12 mo., 9/28/2023 **NEW RATE $ 734,638.71 CD *4426 - Rate .30% 12 mo., 1/29/2023 $ 538,414.48 Total Investments $ 2,034,697.24 Total Bank & Investment Accounts $ 3,313,655.54 Checks in Transit *3102 $ (8,484.26) Deposit in transit checking Deposit in transit money market Total Adjusted Undesignated Funds $ 3,305,171.28 Scandia EDA *6301 $ 30,995.62 Receipts $ 1,000.00 Expenditures $ (1,669.49) Checks in Transit $ (495.00) Deposit in Transit S (825.00) Total Designated EDA Funds $ 29,006.13 Total Funds $ 3,334,177.41 Submitted by: Colleen Firkus, Treasurer m�n�e&o�a 2022 FUND 101GENERAL 203 COVID-19 RELIEF 226 CABLE TV 230 RESTRICTED DONATIONS 307 BLACKTOP PROJECT 2007 313 EQUIPMENT CERTIFICATES 315 EQUIPMENT CERTIFICATES 317 EQUIPMENT CERTIFICATES 318 BLACKTOP PROJECT 401 CAPITAL IMPR 404 PARK CAP IMPR 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 BIG MARINE SEWER 612 UPTOWN SEWER 801 ESCROW 225 EDA SUBTOTAL TOTAL CASH BALANCES END OF MONTH JANUARY $ 1,375,256.03 $ $ 228,181.31 $ $ 39,431.38 $ $ 175.00 $ $ 24,314.07 $ $ 15,452.35 $ $ (297.54) $ $ 603.14 $ $ 818,049.51 $ $ 144,888.28 $ $ 316,104.69 $ $ 1,258,339.81 $ $ 96,112.55 $ $ 14,094.48 $ $ 33,340.59 $ $ 4,364,045.65 $ $ 28,903.67 $ $ 4,392,949.32 $ FEBRUARY MARCH APRIL MAY JUNE JULY 1,243,313.89 $ 1,124,142.19 $ 1,012,873.90 $ 890,924.57 $ 1,701,216.18 $ 1,517,797.37 $ 228,181.31 $ 228,181.31 $ 228,181.31 $ 228,181.31 $ 228,181.31 $ 456,362.62 $ 41,288.08 $ 42,940.54 $ 43,836.65 $ 44,302.18 $ 17,599.67 $ 19,525.37 $ 175.00 $ 925.00 $ 2,525.00 $ 3,575.00 $ 3,575.00 $ - - $ 6,463.65 $ 6,463.65 $ 6,463.65 $ 6,730.52 $ 6,730.52 $ 24,314.07 $ 24,314.07 $ 25,110.07 $ 25,110.07 $ (3,744.93) $ (3,744.93) $ 15,452.35 $ 15,452.35 $ 15,951.35 $ 15,951.35 $ 15,951.35 $ 15,951.35 $ (297.54) $ (297.54) $ 103.46 $ 103.46 $ 17,365.46 $ (15,074.54) $ 603.14 $ 603.14 $ 4,359.14 $ (45,198.37) $ 127,067.13 $ 127,067.13 $ 811,649.51 $ 719,740.45 $ 716,800.12 $ 716,431.08 $ 822,054.08 $ 819,894.08 $ 144,888.28 $ 153,888.28 $ 154,216.28 $ 154,216.28 $ 165,491.28 $ 165,616.28 $ 316,104.69 $ 316,104.69 $ 104,259.83 $ 104,259.83 $ 155,827.01 $ 155,827.01 $ 1,248,055.95 $ 1,220,765.95 $ 1,226,717.45 $ 1,220,617.45 $ 1,329,096.45 $ 1,319,327.95 $ 91,195.97 $ 78,021.72 $ 79,320.98 $ 49,281.22 $ 64,260.55 $ 71,515.96 $ 16,430.41 $ 15,020.58 $ 15,050.60 $ 14,347.68 $ 13,148.48 $ 9,512.61 $ 38,526.39 $ 34,870.13 $ 33,870.23 $ 36,986.33 $ 42,880.49 $ 40,645.19 $ 4,219,881.50 $ 3,981,136.51 $ 3,669,640.02 $ 3,465,553.09 $ 4,706,700.03 $ 4,706,953.97 $ 28,903.67 $ 27,702.55 $ 27,344.55 $ 27,399.55 $ 27,019.70 $ 31,019.70 $ 4,248,785.17 $ 4,008,839.06 $ 3,696,984.57 $ 3,492,952.64 $ 4,733,719.73 $ 4,737,973.67 $ AUGUST SEPTEMBER 1,400,512.58 $1,267,186 456,362.62 $456,363 19,480.07 $21,421 $0 6,730.52 $6,731 (3,744.93) ($3,745) 15,951.35 $15,951 (15,074.54) ($15,075) 127,067.13 $127,067 817,494.08 $815,094 165,616.28 $162,616 155,827.01 $155,827 1,058,762.40 $1,010,303 67,011.85 $62,716 12,143.58 $11,439 40,327.82 $34,577 4,324,467.82 $4,128,470 30,995.62 $30,996 4,355,463.44 $4,159,466 OCTOBER NOVEMBER $1,160,922 $1,082,091 $456,363 $456,363 $21,964 $23,876 $0 $0 $6,731 $6,731 ($3,745) ($4,675) $15,951 $15,951 ($15,075) ($15,075) ($151,995) ($151,995) $647,694 $647,694 $133,305 $133,829 $155,827 $155,827 $844,072 $841,438 $67,543 $66,353 $10,187 $13,169 $35,089 $32,769 $3,384,833 $3,304,346 $30,677 $29,831 $3,415,511 $3,334,177 1 CITY OF SCANDIA ,1.. VN V,- ANDIA Revenue - Expenditure Summary Nov-22 Description 2022 Budget YTD Amount November Amount Budget Balance % of Budget Comments GENERALFUND Revenue ADMINISTRATION & FINANCE R 101-41000-31000 Washington Cty. Tax Settlement $1,583,000.00 $811,918.35 $0.00 $771,081.65 51.29% R 101-41000-31040 Fiscal Disparities $0.00 $89,539.20 $0.00 ($89,539.20) 0.00% R 101-41000-31701 Gravel Taxes $20,000.00 $6,457.10 $0.00 $13,542.90 32.29% R 101-41000-31830 Solar Energy Production Tax $5,000.00 $4,115.14 $0.00 $884.86 82.30% R 101-41000-31900 Penalties & Interest Del Tax $400.00 $234.87 $0.00 $165.13 58.72% R 101-41000-32150 Utility Permits $3,000.00 $5,400.00 $450.00 ($2,400.00) 180.00% R 101-41000-32180 Tobacco & Liquor Licenses $8,500.00 $6,041.00 $5,044.00 $2,459.00 71.07% R 101-41000-32190 Other City Permits $3,000.00 $3,120.00 $250.00 ($120.00) 104.00% R 101-41000-32210 Building Permits $135,000.00 $148,817.81 $13,813.96 ($13,817.81) 110.24% R 101-41000-32260 Gambling Permits $0.00 $245.00 $0.00 ($245.00) 0.00% R 101-41000-33401 LGA/MVHC/AG/PERA Aid $13,200.00 $410.00 $0.00 $12,790.00 3.11% R 101-41000-33420 Fire Relief State PERA $39,600.00 $0.00 $0.00 $39,600.00 0.00% R 101-41000-33422 Other State Grants & Aids $5,400.00 $8,889.09 $1,980.00 ($3,489.09) 164.61% R 101-41000-33428 PILOT $6,000.00 $3,102.02 $0.00 $2,897.98 51.70% R 101-41000-33620 Recycling Grant $9,000.00 $13,188.00 $0.00 ($4,188.00) 146.53% R 101-41000-33630 Local Govt Grants & Aids $0.00 $0.00 $0.00 $0.00 0.00% R 101-41000-33640 Other Grants $1,000.00 $0.00 $0.00 $1,000.00 0.00% R 101-41000-34103 Zoning and Planning $4,300.00 $4,692.00 $950.00 ($392.00) 109.12% R 101-41000-34107 Assessment Search Fees $100.00 $20.00 $0.00 $80.00 20.00% R 101-41000-34109 Water Usage $200.00 $0.00 $0.00 $200.00 0.00% R 101-41000-34201 Impound Fees $0.00 $592.58 $0.00 ($592.58) 0.00% R 101-41000-34202 Fire Protection Services $31,493.00 $31,493.00 $0.00 $0.00 100.00% R 101-41000-34303 Dust Control $2,400.00 $3,180.46 $0.00 ($780.46) 132.52% R 101-41000-34304 Reimbursement for Services $3,600.00 $3,600.00 $900.00 $0.00 100.00% R 101-41000-34730 Ad Revenue $2,100.00 $2,400.00 $0.00 ($300.00) 114.29% R 101-41000-34750 Facilities Rental $5,000.00 $11,033.65 $1,172.00 ($6,033.65) 220.67% R 101-41000-34760 Cleaning Fees $200.00 $0.00 $0.00 $200.00 0.00% R 101-41000-34790 Recreation Programs $1,000.00 $1,840.00 $75.00 ($840.00) 184.00% R 101-41000-35101 Fines & Forfeitures $7,000.00 $5,404.46 $69.99 $1,595.54 77.21% R 101-41000-36210Interest Income $15,900.00 $11,401.93 $248.80 $4,498.07 71.71% R 101-41000-36230 Donations $1,500.00 $4,841.35 $0.00 ($3,341.35) 322.76% Ice Sculpture Donations R 101-41000-36240Insurance Dividend $2,000.00 $0.00 $0.00 $2,000.00 0.00% R 101-41000-36250 Misc. Refund $2,500.00 $1,284.29 $450.00 $1,215.71 51.37% Total General Fund Revenue $1,911,393.00 $1,183,261.30 $25,403.75 $728,131.70 61.91% Operating Transfers R 101-49000-39203 Transfer from Other Funds $0.00 $2,240,000.00 ($2,240,000.00) R 101-49000-39204 Money Market Transfer $0.00 $765,000.00 $95,000.00 ($765,000.00) Total Operating Transfers $3,005,000.00 $95,000.00 ($3,005,000.00) 1 CITY OF SCANDIA ,1.. VN V,_ ANDIA Revenue - Expenditure Summary Nov-22 Description 2022 Budget YTD Amount November Amount Budget Balance % of Budget Comments GENERAL FUND ADMINISTRATION & FINANCE Expenditures E 101-41000-101 Regular Wages & Salaries $162,600.00 $137,403.64 $12,498.73 $25,196.36 84.50% E 101-41000-121 PERA Coord. Employer Contribu. $12,000.00 $10,294.79 $937.38 $1,705.21 85.79% E 101-41000-122 FICA Employer Contribution $30,300.00 $7,363.74 $752.20 $2,736.26 72.91% E 101-41000-126 MEDICARE Employer Contribution $2,400.00 $2,035.98 $175.91 $364.02 84.83% E 101-41000-131 Employer Paid Health $23,600.00 $23,791.53 $2,061.59 ($191.53) 100.81% E 101-41000-132 Dental Insurance $2,900.00 $886.71 $80.61 $2,013.29 30.58% E 101-41000-134 Employer Paid Life $600.00 $440.00 $40.00 $160.00 73.33% E 101-41000-135 Employer Paid Disability $1,200.00 $460.79 $41.89 $739.21 38.40% E 101-41000-151 Workers Comp Insurance Prem $1,200.00 $1,775.67 $0.00 ($575.67) 147.97% E 101-41000-200 Office Supplies $1,000.00 $829.03 $170.83 $170.97 82.90% E 101-41000-203 Printed Forms & Papers $1,800.00 $1,936.53 $0.00 ($136.53) 107.59% E 101-41000-210 Operating Supplies $900.00 $738.16 $0.00 $161.84 82.02% E 101-41000-301 Auditing and Acct g Services $20,800.00 $21,600.00 $0.00 ($800.00) 103.85% E 101-41000-303 Engineering Fees $0.00 $180.00 $0.00 ($180.00) 0.00% E 101-41000-304 Legal Services $40,000.00 $24,690.90 $1,133.00 $15,309.10 61.73% E 101-41000-306 Personal Testing & Recruit $0.00 $0.00 $0.00 $0.00 0.00% American Legal $1,315; E 101-41000-308 Other Professional Services $1,000.00 $1,403.95 $0.00 ($403.95) 140.40% PSN $89 E 101-41000-309 Software Support & Maintenance $12,000.00 $16,794.26 $777.69 ($4,794.26) 139.95% E 101-41000-314 Animal Control $0.00 $0.00 ($929.98) $0.00 0.00% E 101-41000-316 Conferences & Seminars $800.00 $1,049.00 $0.00 ($249.00) 131.13% E 101-41000-317 Employee Training $500.00 $0.00 $0.00 $500.00 0.00% E 101-41000-319 Other Services $1,300.00 $155.00 $46.00 $1,145.00 11.92% E 101-41000-321 Telephone $4,500.00 $4,548.37 $471.38 ($48.37) 101.07% E 101-41000-322 Postage $2,300.00 $2,200.25 $323.55 $99.75 95.66% E 101-41000-331 Travel Expenses $2,500.00 $1,136.70 $0.00 $1,363.30 45.47% E 101-41000-351 Legal Notices Publishing $2,000.00 $979.16 $36.13 $1,020.84 48.96% E 101-41000-361 Liability/Property Ins $4,100.00 $4,568.15 $0.00 ($468.15) 111.42% E 101-41000-381 Utilities -Electric & Gas $12,000.00 $9,391.89 $1,191.87 $2,608.11 78.27% E 101-41000-413 Equipment Rental $2,800.00 $1,444.89 $75.36 $1,355.11 51.60% E 101-41000-430 Recycling $27,800.00 $25,525.50 $2,320.50 $2,274.50 91.82% E 101-41000-433 Dues and Subscriptions $5,900.00 $5,561.62 $513.00 $338.38 94.26% E 101-41000-434 Youth Service Bureau $5,500.00 $5,500.00 $0.00 $0.00 100.00% E 101-41000-438 Misc. Contractual $3,600.00 $3,562.00 $0.00 $38.00 98.94% E 101-41000-570 Office Equipment $4,000.00 $2,722.26 $0.00 $1,277.74 68.06% Total Admin & Finance Dept. Expenditures $373,700.00 $320,970.47 $22,717.64 $52,729.53 85.89% 1 CITY OF SCANDIA VANDIA Revenue - Expenditure Summary Nov-22 2022 YTD November Budget % of Description Budget Amount Amount Balance Budget Comments CITY COUNCIL Expenditures E 101-41110-101 Regular Wages & Salaries $18,100.00 $13,459.15 $0.00 $4,640.85 74.36% E 101-41110-122 FICA Employer Contribution $1,100.00 $212.60 $0.00 $887.40 19.33% E 101-41110-126 MEDICARE Employer Contribution $300.00 $143.07 $0.00 $156.93 47.69% E 101-41110-127 PERA Defined $600.00 $501.48 $0.00 $98.52 83.58% E 101-41110-151 Workers Comp Insurance Prem $100.00 $3.20 $0.00 $96.80 3.20% E 101-41110-308 Other Professional Services $30.00 $0.00 ($30.00) 0.00% E 101-41110-316 Conferences & Seminars $1,000.00 $398.00 $0.00 $602.00 39.80% E 101-41110-331 Travel Expenses $1,800.00 $0.00 $0.00 $1,800.00 0.00% Total City Council Dept. Expenditures $23,000.00 $14,747.50 $0.00 $8,252.50 64.12% ELECTIONS Expenditures E 101-41410-199 Election Judge $4,800.00 $3,900.37 $1,988.37 $899.63 81.26% E 101-41410-200 Office Supplies $100.00 $53.51 $11.99 $46.49 53.51% E 101-41410-203 Printed Forms & Papers $0.00 $0.00 $0.00 $0.00 0.00% E 101-41410-210 Operating Supplies $1,000.00 $496.93 $219.80 $503.07 49.69% E 101-41410-351 Legal Notices Publishing $200.00 $181.69 $144.50 $18.31 90.85% E 101-41410-413 Equipment Rental $1,500.00 $1,515.00 $0.00 ($15.00) 101.00% Total Elections Dept. Expenditures $7,600.00 $6,147.50 $2,364.66 $1,452.50 80.89% PLANNING & BUILDING Expenditures E 101-41910-101 Regular Wages & Salaries $49,800.00 $45,847.07 $3,899.13 $3,952.93 92.06% E 101-41910-121 PERA Coord. Employer Contribution $3,600.00 $3,437.58 $292.47 $162.42 95.49% E 101-41910-122 FICA Employer Contribution $3,100.00 $2,667.23 $226.67 $432.77 86.04% E 101-41910-126 MEDICARE Employer Contribution $700.00 $636.59 $53.02 $63.41 90.94% E 101-41910-131 Employer Paid Health $11,400.00 $11,735.27 $996.34 ($335.27) 102.94% E 101-41910-132 Dental Insurance $1,900.00 $458.59 $41.69 $1,441.41 24.14% E 101-41910-134 Employer Paid Life $200.00 $158.40 $14.40 $41.60 79.20% E 101-41910-135 Employer Paid Disability $400.00 $368.83 $33.53 $31.17 92.21% 2 copies of Unified Dev E 101-41910-203 Printed Forms & Papers $20.00 $253.55 $0.00 ($233.55) 1267.75% Code E 101-41910-311 Contract Permit Inspections $55,000.00 $55,824.34 $1,275.20 ($824.34) 101.50% E 101-41910-312 Planning Services $28,000.00 $22,744.73 $4,289.17 $5,255.27 81.23% E 101-41910-313 Committee & Commission Reimbur $5,000.00 $3,650.00 $0.00 $1,350.00 73.00% E 101-41910-316 Conferences & Seminars $0.00 $0.00 $0.00 $0.00 0.00% E 101-41910-319 Other Services $0.00 $0.00 $0.00 $0.00 0.00% E 101-41910-361 Liability/Property Ins $1,800.00 $2,005.53 $0.00 ($205.53) 111.42% E 101-41910-438 Misc. Contractual $11,000.00 $4,067.18 $0.00 $6,932.82 36.97% E 101-41910-439 Refunds Issued $0.00 ($572.80) $0.00 $572.80 0.00% E 101-41910-720 Operating Transfers $0.00 $0.00 $0.00 $0.00 0.00% Total Planning & Building Dept. Expenditures $171,920.00 $121,014.10 $12,792.40 $72,505.90 62.53% GENERAL FUND CONT. ASSESSOR Expenditures E 101-41960-300 Assessor $21,600.00 $19,878.19 $1,800.00 $1,721.81 92.03% POLICE E 101-42100-318 Police Contract $150,400.00 $75,206.76 $0.00 $75,193.24 50.00% E 101-42100-319 Other Services $500.00 $309.36 $0.00 $190.64 61.87% Total GF Police Dept. Expenditures $150,900.00 $75,516.12 $0.00 $75,383.88 50.04% 1 CITY OF SCANDIA VANDIA Revenue - Expenditure Summary Nov-22 2022 YTD November Budget % of Description Budget Amount Amount Balance Budget Comments FIRE Expenditures E 101-42200-101 Regular Wages & Salaries $95,000.00 $111,278.26 $9,053.32 ($16,278.26) 117.14% E 101-42200-121 PERA Coord. Employer Contribu. $9,700.00 $0.00 $0.00 $9,700.00 0.00% E 101-42200-122 FICA Employer Contribution $5,900.00 $5,631.54 $417.84 $268.46 95.45% E 101-42200-124 Police & Fire PERA $0.00 $7,893.91 $712.79 ($7,893.91) 0.00% E 101-42200-126 MEDICARE Employer Contribution $1,400.00 $1,300.48 $132.73 $99.52 92.89% E 101-42200-134 Employer Paid Life $200.00 $176.00 $16.00 $24.00 88.00% E 101-42200-135 Employer Paid Disability $700.00 $0.00 $0.00 $700.00 0.00% E 101-42200-151 Worker s Comp Insurance Prem $9,550.00 $13,008.42 $0.00 ($3,458.42) 136.21% E 101-42200-200 Office Supplies $400.00 $165.41 $0.00 $234.59 41.35% E 101-42200-203 Printed Forms & Papers $150.00 $0.00 $0.00 $150.00 0.00% E 101-42200-209 Medical Supplies $2,500.00 $2,632.41 $0.00 ($132.41) 105.30% E 101-42200-210 Operating Supplies $8,000.00 $1,848.19 $419.63 $6,151.81 23.10% E 101-42200-211 Cleaning Supplies $100.00 $44.34 $26.46 $55.66 44.34% E 101-42200-212 Fuel $2,500.00 $4,600.61 $304.86 ($2,100.61) 184.02% E 101-42200-217 Uniforms & Safety Equipment $10,000.00 $550.00 $550.00 $9,450.00 5.50% E 101-42200-221 Equipment Parts $3,000.00 $290.29 $0.00 $2,709.71 9.68% E 101-42200-222 Tires $0.00 $1,540.36 $0.00 ($1,540.36) 0.00% E 101-42200-223 Structure Repair & Supplies $5,300.00 $419.62 $0.00 $4,880.38 7.92% E 101-42200-240 Small Tools and Minor Equip $8,500.00 $9,939.37 $317.09 ($1,439.37) 116.93% SCBA user exams $2,595; E 101-42200-305 Medical Services $4,500.00 $7,330.00 $0.00 ($2,830.00) 162.89% SCBA fit test $1,695 E 101-42200-306 Personal Testing & Recruit $1,500.00 $954.26 $51.26 $545.74 63.62% E 101-42200-309 Software Support & Maintenance $17,000.00 $13,965.53 $528.00 $3,034.47 82.15% E 101-42200-310 Medical Training $11,000.00 $0.00 $0.00 $11,000.00 0.00% E 101-42200-316 Conferences & Seminars $300.00 $0.00 $0.00 $300.00 0.00% E 101-42200-317 Employee Training $8,000.00 $1,980.00 $0.00 $6,020.00 24.75% E 101-42200-319 Other Services $500.00 $548.00 $0.00 ($48.00) 109.60% E 101-42200-321 Telephone $6,400.00 $5,865.25 $832.87 $534.75 91.64% E 101-42200-324 State of MN -Fire Relief $35,300.00 $0.00 $0.00 $35,300.00 0.00% E 101-42200-325 City Match -Fire Relief $0.00 $0.00 $0.00 $0.00 0.00% E 101-42200-331 Travel Expenses $2,000.00 $0.00 $0.00 $2,000.00 0.00% E 101-42200-334 Licenses & Permits $200.00 $250.00 $0.00 ($50.00) 125.00% E 101-42200-361 Liability/Property Ins $6,000.00 $6,685.09 $0.00 ($685.09) 111.42% E 101-42200-381 Utilities -Electric & Gas $4,000.00 $5,846.21 $21.14 ($1,846.21) 146.16% E 101-42200-384 Refuse/Garbage Disposal $850.00 $954.75 $102.99 ($104.75) 112.32% E 101-42200-385 Sewer Pumping & Maintenance $700.00 $300.00 $0.00 $400.00 42.86% E 101-42200-401 Building Maintenance/Repairs $2,500.00 $3,242.42 $628.03 ($742.42) 129.70% E 101-42200-404 Repair Machinery/Equipment $8,000.00 $8,594.68 $60.96 ($594.68) 107.43% E 101-42200-407 Well Repair & Maintenance $140.00 $0.00 $0.00 $140.00 0.00% E 101-42200-433 Dues and Subscriptions $2,100.00 $2,349.58 $0.00 ($249.58) 111.88% E 101-42200-438 Misc. Contractual $4,100.00 $1,605.00 $0.00 $2,495.00 39.15% E 101-42200-440 Events $800.00 $837.94 $755.72 ($37.94) 104.74% E 101-42200-530 Capital Impr Other Than Bldgs $0.00 $1,178.00 $0.00 ($1,178.00) 0.00% E 101-42200-560 Furniture and Fixtures $500.00 $0.00 $0.00 $500.00 0.00% E 101-42200-570 Office Equipment $900.00 $0.00 $0.00 $900.00 0.00% Total Fire Dept Expenditures $280,190.00 $223,805.92 $14,931.69 $56,384.08 79.88% ANIMALCONTROL Expenditures E 101-42700-314 Animal Control $4,000.00 $4,316.52 $1,614.59 ($316.52) 107.91% 1 CITY OF SCANDIA VANDIA Revenue - Expenditure Summary Nov-22 Description 2022 Budget YTD Amount November Amount Budget Balance % of Budget Comments GENERAL FUND CONT. PUBLIC WORKS Expenditures E 101-43000-101 Regular Wages & Salaries $220,300.00 $193,211.20 $17,139.71 $27,088.80 87.70% E 101-43000-102 OT Regular Wages $4,900.00 $7,732.68 $0.00 ($2,832.68) 157.81% E 101-43000-104 Temporary Employee Wages $3,700.00 $3,011.60 $290.53 $688.40 81.39% E 101-43000-121 PERA Coord. Employer Contribu. $16,900.00 $15,054.59 $1,285.48 $1,845.41 89.08% E 101-43000-122 FICA Employer Contribution $14,000.00 $12,577.24 $1,012.78 $1,422.76 89.84% E 101-43000-126 MEDICARE Employer Contribution $3,300.00 $2,966.75 $239.37 $333.25 89.90% E 101-43000-131 Employer Paid Health $53,600.00 $55,478.79 $4,636.17 ($1,878.79) 103.51% E 101-43000-132 Dental Insurance $2,000.00 $914.54 $83.14 $1,085.46 45.73% E 101-43000-134 Employer Paid Life $700.00 $678.92 $61.72 $21.08 96.99% E 101-43000-135 Employer Paid Disability $1,700.00 $1,592.69 $144.79 $107.31 93.69% E 101-43000-141 Unemployment Compensation $1,500.00 $0.00 $0.00 $1,500.00 0.00% E 101-43000-151 Worker s Comp Insurance Prem $16,890.00 $23,017.71 $0.00 ($6,127.71) 136.28% E 101-43000-200 Office Supplies $600.00 $0.00 $0.00 $600.00 0.00% E 101-43000-210 Operating Supplies $8,000.00 $8,506.09 $1,129.57 ($506.09) 106.33% E 101-43000-212 Fuel $18,000.00 $20,887.70 $1,671.10 ($2,887.70) 116.04% E 101-43000-217 Uniforms & Safety Equipment $2,000.00 $643.54 $299.73 $1,356.46 32.18% E 101-43000-221 Equipment Parts $12,100.00 $13,073.74 $861.56 ($973.74) 108.05% E 101-43000-222 Tires $6,500.00 $6,092.70 $0.00 $407.30 93.73% E 101-43000-223 Structure Repair & Supplies $2,000.00 $0.00 $0.00 $2,000.00 0.00% E 101-43000-224 Materials for Road Maintenance $15,000.00 $11,809.07 $3,325.27 $3,190.93 78.73% E 101-43000-226 Sign Replacement and Repair $2,000.00 $3,062.62 $0.00 ($1,062.62) 153.13% E 101-43000-228 Gravel $9,900.00 $1,830.17 $163.03 $8,069.83 18.49% E 101-43000-229 Salt $19,000.00 $15,652.75 $0.00 $3,347.25 82.38% E 101-43000-240 Small Tools and Minor Equip $5,000.00 $876.90 $219.16 $4,123.10 17.54% E 101-43000-302 Surveying $0.00 $0.00 $0.00 $0.00 0.00% E 101-43000-303 Engineering Fees $9,400.00 $6,158.97 $510.00 $3,241.03 65.52% E 101-43000-305 Medical Services $1,200.00 $734.30 $36.80 $465.70 61.19% E 101-43000-309 Software Support & Maintenance $1,900.00 $1,635.00 $135.00 $265.00 86.05% E 101-43000-317 Employee Training $1,700.00 $798.55 $0.00 $901.45 46.97% E 101-43000-319 Other Services $13,200.00 $4,874.00 $9.45 $8,326.00 36.92% E 101-43000-321 Telephone $4,800.00 $4,904.13 $476.17 ($104.13) 102.17% E 101-43000-331 Travel Expenses $500.00 $0.00 $0.00 $500.00 0.00% E 101-43000-334 Licenses & Permits $500.00 $183.25 $0.00 $316.75 36.65% E 101-43000-361 Liability/Property Ins $9,300.00 $10,361.91 $0.00 ($1,061.91) 111.42% E 101-43000-381 Utilities -Electric & Gas $3,200.00 $4,213.84 $47.53 ($1,013.84) 131.68% E 101-43000-384 Refuse/Garbage Disposal $900.00 $1,032.63 $68.67 ($132.63) 114.74% E 101-43000-385 Sewer Pumping & Maintenance $800.00 $755.80 $0.00 $44.20 94.48% E 101-43000-387 Street Light Utilities $4,000.00 $3,537.71 $336.28 $462.29 88.44% E 101-43000-401 Building Maintenance/Repairs $5,500.00 $9,718.59 $6,302.81 ($4,218.59) 176.70% E 101-43000-404 Repair Machinery/Equipment $14,000.00 $19,439.41 $470.00 ($5,439.41) 138.85% E 101-43000-405 Contractual Road Maint/Repair $150,000.00 $90,705.97 $0.00 $59,294.03 60.47% E 101-43000-407 Well Repair & Maintenance $0.00 $0.00 $0.00 $0.00 0.00% E 101-43000-413 Equipment Rental $3,500.00 $2,276.29 $0.00 $1,223.71 65.04% E 101-43000-417 Uniform Rental $1,000.00 $821.40 $95.95 $178.60 82.14% E 101-43000-433 Dues and Subscriptions $200.00 $0.00 $0.00 $200.00 0.00% E 101-43000-438 Misc. Contractual $15,000.00 $6,146.52 $0.00 $8,853.48 40.98% E 101-43000-530 Capital Impr Other Than Bldgs $0.00 $1,178.00 $0.00 ($1,178.00) 0.00% E 101-43000-570 Office Equipment $3,300.00 $2,855.46 $0.00 $444.54 86.53% Total Public Works Dept. Expenditures $683,490.00 $571,003.72 $41,051.77 $112,486.28 83.54% 1 CITY OF SCANDIA ,1.. VN V,_ ANDIA Revenue - Expenditure Summary Nov-22 2022 YTD November Budget % of Description Budget Amount Amount Balance Budget Comments GENERAL FUND CONT. PARKS & RECREATION Expenditures E 101-45000-101 Regular Wages & Salaries $9,800.00 $7,875.15 $742.58 $1,924.85 80.36% E 101-45000-104 Temporary Employee Wages $29,100.00 $12,691.01 $0.00 $16,408.99 43.61% E 101-45000-121 PERA Coord. Employer Contribu. $700.00 $589.12 $55.68 $110.88 84.16% E 101-45000-122 FICA Employer Contribution $2,600.00 $1,236.08 $43.57 $1,363.92 47.54% E 101-45000-126 MEDICARE Employer Contribution $600.00 $306.01 $10.18 $293.99 51.00% E 101-45000-131 Employer Paid Health $2,100.00 $2,423.45 $176.83 ($323.45) 115.40% E 101-45000-132 Dental Insurance $100.00 $33.22 $3.02 $66.78 33.22% E 101-45000-134 Employer Paid Life $0.00 $131.78 $11.98 ($131.78) 0.00% E 101-45000-135 Employer Paid Disability $1,000.00 $341.55 $31.05 $658.45 34.16% E 101-45000-141 Unemployment Compensation $0.00 $119.13 $0.00 ($119.13) 0.00% E 101-45000-151 Workers Comp Insurance Prem $1,450.00 $1,970.60 $0.00 ($520.60) 135.90% E 101-45000-200 Office Supplies $300.00 $0.00 $0.00 $300.00 0.00% E 101-45000-203 Printed Forms & Papers $900.00 $77.60 $0.00 $822.40 8.62% E 101-45000-210 Operating Supplies $900.00 $805.92 $100.00 $94.08 89.55% E 101-45000-212 Fuel $1,500.00 $516.71 $0.00 $983.29 34.45% E 101-45000-221 Equipment Parts $2,000.00 $970.72 $0.00 $1,029.28 48.54% E 101-45000-223 Structure Repair & Supplies $500.00 $362.26 $0.00 $137.74 72.45% E 101-45000-240 Small Tools and Minor Equip $0.00 $359.90 $0.00 ($359.90) 0.00% E 101-45000-312 Planning Services $0.00 $0.00 $0.00 $0.00 0.00% E 101-45000-313 Committee & Commission Reimbur $1,200.00 $840.00 $0.00 $360.00 70.00% E 101-45000-319 Other Services $0.00 $1,861.01 $1,331.20 ($1,861.01) 0.00% E 101-45000-322 Postage $0.00 $0.00 $0.00 $0.00 0.00% E 101-45000-340 Advertising $0.00 $180.00 $0.00 ($180.00) 0.00% E 101-45000-353 Sales& Use Tax $0.00 $0.00 $0.00 $0.00 0.00% E 101-45000-361 Liability/Property Ins $7,100.00 $7,910.69 $0.00 ($810.69) 111.42% E 101-45000-381 Utilities -Electric & Gas $4,000.00 $6,900.30 $397.08 ($2,900.30) 172.51% E 101-45000-384 Refuse/Garbage Disposal $1,900.00 $4,849.12 $250.16 ($2,949.12) 255.22% E 101-45000-385 Sewer Pumping & Maintenance $500.00 $457.68 $0.00 $42.32 91.54% E 101-45000-401 Building Maintenance/Repairs $6,000.00 $3,937.80 $271.85 $2,062.20 65.63% E 101-45000-403Improvements Other Than Bldgs $0.00 $2,280.97 $0.00 ($2,280.97) 0.00% E 101-45000-404 Repair Machinery/Equipment $700.00 $100.00 $0.00 $600.00 14.29% E 101-45000-406 Grounds Care $4,000.00 $1,531.09 $71.58 $2,468.91 38.28% E 101-45000-438 Misc. Contractual $3,000.00 $500.00 $0.00 $2,500.00 16.67% E 101-45000-439 Refunds Issued $0.00 $0.00 $0.00 $0.00 0.00% E 101-45000-440 Events $3,000.00 $6,510.65 $0.00 ($3,510.65) 217.02% Ice Sculpture $5,000 E 101-45000-490 Financial Assistance $0.00 $0.00 $0.00 $0.00 0.00% E 101-45000-530 Capital Impr Other Than Bldgs $10,000.00 $50.00 $0.00 $9,950.00 0.50% E 101-45000-720 Operating Transfers $0.00 $0.00 $0.00 $0.00 0.00% Total Parks & Rec Dept. Expenditures $94,950.00 $68,719.52 $3,496.76 $26,230.48 72.37% 1 CITY OF SCANDIA VANDIA Revenue - Expenditure Summary Nov-22 2022 YTD November Budget % of Description Budget Amount Amount Balance Budget Comments COMMUNITY CENTER Expenditures E 101-45180-101 Regular Wages & Salaries $14,400.00 $12,800.40 $1,071.33 $1,599.60 88.89% E 101-45180-104 Temporary Employee Wages $0.00 $0.00 $0.00 $0.00 0.00% E 101-45180-121 PERA Coord. Employer Contribu. $1,300.00 $922.75 $80.30 $177.25 83.89% E 101-45180-122 FICA Employer Contribution $900.00 $747.31 $62.67 $152.69 83.03% E 101-45180-126 MEDICARE Employer Contribution $200.00 $184.05 $14.68 $15.95 92.03% E 101-45180-131 Employer Paid Health $3,100.00 $2,708.87 $242.10 $391.13 87.38% E 101-45180-134 Employer Paid Life $0.00 $42.90 $3.90 ($42.90) 0.00% E 101-45180-135 Employer Paid Disability $100.00 $125.84 $11.44 ($25.84) 125.84% E 101-45180-151 Workers Comp Insurance Prem $0.00 $0.00 $0.00 $0.00 0.00% E 101-45180-210 Operating Supplies $2,800.00 $2,260.41 $678.60 $539.59 80.73% E 101-45180-223 Structure Repair & Supplies $6,500.00 $117.71 $0.00 $6,382.29 1.81% E 101-45180-334 Licenses & Permits $900.00 $777.00 $0.00 $123.00 86.33% E 101-45180-361 Liability/Property Ins $2,300.00 $2,562.62 $0.00 ($262.62) 111.42% E 101-45180-381 Utilities -Electric & Gas $10,600.00 $8,561.19 $511.68 $2,038.81 80.77% E 101-45180-384 Refuse/Garbage Disposal $1,800.00 $1,602.52 $161.23 $197.48 89.03% E 101-45180-385 Sewer Pumping & Maintenance $3,500.00 $3,193.59 $0.00 $306.41 91.25% E 101-45180-401 Building Maintenance/Repairs $13,000.00 $10,649.05 $887.46 $2,350.95 81.92% E 101-45180-404 Repair Machinery/Equipment $3,000.00 $332.00 $120.00 $2,668.00 11.07% E 101-45180-406 Grounds Care $650.00 $0.00 $0.00 $650.00 0.00% E 101-45180-407 Well Repair & Maintenance $600.00 $13,675.00 $0.00 ($13,075.00) 2279.17% Well repair E 101-45180-438 Misc. Contractual $2,500.00 $0.00 $0.00 $2,500.00 0.00% E 101-45180-439 Refunds Issued $0.00 $0.00 $0.00 $0.00 0.00% E 101-45180-520 Capital Improvements to Bldgs $6,000.00 $4,121.50 $2,122.50 $1,878.50 68.69% E 101-45180-530 Capital Impr Other Than Bldgs $0.00 $0.00 $0.00 $0.00 0.00% E 101-45180-570 Office Equipment $0.00 $0.00 $0.00 $0.00 0.00% E 101-45180-720 Operating Transfers $0.00 $0.00 $0.00 $0.00 0.00% Total Community Center Dept. Expenditures $73,950.00 $65,384.71 $5,967.89 $8,565.29 88.42% Operating Transfers E 101-49000-720 Operating Transfers $3,005,825.00 $95,825.00 ($3,005,825.00) TOTAL GENERAL FUND EXPENDITURES $1,885,300.00 $1,370,490.17 $93,945.00 $342,889.83 72.69% 1 CITY OF SCANDIA ,1.. VN V,- ANDIA Revenue - Expenditure Summary Nov-22 2022 YTD November Budget % of Description Budget Amount Amount Balance Budget Comments COVID RELIEF FUND Revenue R 203-46200-33150 Federal Grant $0.00 $228,181.31 $0.00 ($228,181.31) 0.00% Expenditures E 203-49000-720 Operating Transfers $0.00 $0.00 $0.00 $0.00 0.00% EDAFUND Revenue R 225-46500-31000 Washington Cty. Tax Settlement R 225-46500-33640 Other Grants R 225-46500-34750 Facilities Rental R 225-46500-36210Interest Income R225-46500-36230 Donations R 225-46500-39203 Transfer from Other Funds $8,000.00 $4,000.00 $0.00 $4,000.00 50.00% $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $750.00 $0.00 ($750.00) 0.00% $200.00 $0.00 $0.00 $200.00 0.00% $0.00 $300.00 $150.00 ($300.00) 0.00% $0.00 50.00 $0.00 $0.00 0.00% Total EDA Fund Revenue $8,200.00 $5,050.00 $150.00 $3,150.00 61.59% Expenditure E 225-46500-210 Operating Supplies $0.00 $21.00 $21.00 ($21.00) 0.00% E 225-46500-303 Engineering Fees $5,000.00 $0.00 $0.00 $5,000.00 0.00% E 225-46500-308 Other Professional Services $125.00 $0.00 $0.00 $125.00 0.00% E 225-46500-340 Advertising $2,000.00 $75.00 $0.00 $1,925.00 3.75% E 225-46500-433 Dues and Subscriptions $2,650.00 $1,653.00 $0.00 $997.00 62.38% E 225-46500-440 Events $400.00 $2,808.42 $975.08 ($2,408.42) 702.11% E 225-46500-720 Operating Transfers $0.00 $0.00 $0.00 $0.00 0.00% Total EDA Fund Expenditures $10,175.00 $4,557.42 $996.08 $5,617.58 44.79% CABLE TV FUND Revenue R 226-41950-36210Interest Income $0.00 $0.00 $0.00 $0.00 0.00% R 226-41950-38050 Cable TV Franchise Rebates $15,400.00 $15,830.98 $1,594.45 ($430.98) 102.80% R 226-41950-38051 PEG Fees $3,500.00 $3,892.03 $0.00 ($392.03) 111.20% Total Cable TV Fund Revenue $18,900.00 $19,723.01 $1,594.45 ($823.01) 1.0435455 Expenditures E 226-41950-240 Small Tools and Minor Equip $0.00 $498.00 $0.00 ($498.00) 0.00% E 226-41950-309 Software Support & Maintenance $3,500.00 $2,596.16 $125.60 $903.84 74.18% E 226-41950-438 Misc. Contractual $8,000.00 $5,679.00 $1,380.00 $2,321.00 70.99% Council Chambers AV E 226-41950-570 Office Equipment $250.00 $26,989.63 $0.00 ($26,739.63) 10795.85% equipment 1/2 Total Cable TV Fund Expenditures $11,750.00 $35,762.79 $1,505.60 ($24,012.79) 304.36% GATEWAY TRAIL FUND Revenue R 230-45000-36230 Donations $0.00 $3,400.00 $0.00 ($3,400.00) 0.00% Expenditures E 230-45000-308 Other Professional Services $0.00 $3,575.00 $0.00 ($3,575.00) 0.00% 1 CITY OF SCANDIA ,1.. VN V,- ANDIA Revenue - Expenditure Summary Nov-22 2022 YTD November Budget % of Description Budget Amount Amount Balance Budget Comments BLACKTOP PROJECT 2007 Revenue R 307-47000-31952 SA Penalties 8, Interest $0.00 $6,698.52 $0.00 ($6,698.52) 0.00% 2013 EQUIPMENT CERTIFICATES Revenue R 313-47000-31000 Washington Cty. Tax Settlement $67,000.00 $33,500.00 $0.00 $33,500.00 50.00% Expenditure E 313-47000-601 Long Term Debt Principal $60,000.00 $60,000.00 $0.00 $0.00 100.00% E 313-47000-611 Long Term Debt Interest $2,790.00 $1,860.00 $0.00 $930.00 66.67% E 313-47000-620 Fiscal Agent s Fees $495.00 $495.00 $0.00 $0.00 100.00% Total2013 Fund Expenditures $63,285.00 $62,355.00 $0.00 $930.00 98.53% 2017 EQUIPMENT CERTIFICATES Revenue R 317-47000-31000 Washington Cty. Tax Settlement $34,524.00 $17,262.00 $0.00 $17,262.00 50.00% Expenditures E 317-47000-601 Long Term Debt Principal $32,000.00 $32,000.00 $0.00 $0.00 100.00% E 317-47000-611 Long Term Debt Interest $880.00 $880.00 $0.00 $0.00 100.00% E 317-47000-620 Fiscal Agent s Fees $495.00 $0.00 $0.00 $495.00 0.00% Total2017 Fund Expenditures $33,375.00 $32,880.00 $0.00 $495.00 98.52% 2018 STREET RECONSTRUCTION Revenue R 318-47000-31000 Washington Cty. Tax Settlement $344,531.00 $172,265.50 $0.00 $172,265.50 50.00% Expenditure E 318-47000-601 Long Term Debt Principal $230,000.00 $230,000.00 $0.00 $0.00 100.00% E 318-47000-611 Long Term Debt Interest $98,125.00 $98,125.02 $0.00 ($0.02) 100.00% E 318-47000-620 Fiscal Agent s Fees $495.00 $495.00 $0.00 $0.00 100.00% Total2018 Street Reconstruction Fund Expenditures $328,620.00 $328,620.02 $0.00 ($0.02) 100.00% 1 CITY OF SCANDIA VANDIA Revenue - Expenditure Summary Nov-22 2022 YTD November Budget % of Description Budget Amount Amount Balance Budget Comments CAPITAL IMPROVEMENTS Revenue R 401-48000-31000 Washington Cty. Tax Settlement $217,336.00 $108,668.00 $0.00 $108,668.00 50.00% R 401-48000-33422 Other State Grants & Aids $240,625.00 $0.00 $0.00 $240,625.00 0.00% R 401-48000-36100 Special Assessments $510.00 $0.00 $0.00 $510.00 0.00% R 401-48000-36210 Interest Income $4,500.00 $0.00 $0.00 $4,500.00 0.00% Total Capital Improvement Fund Revenue $462,971.00 $108,668.00 $0.00 $354,303.00 23.47% Expenditures E 401-41000-312 Planning Services $0.00 $5,771.25 $0.00 ($5,771.25) 0.00% E 401-41000-520 Capital Improvements to Bldgs $0.00 $12,750.00 $0.00 ($12,750.00) 0.00% E 401-41000-530 Capital Impr Other Than Bldgs $319,280.00 $4,950.00 $0.00 $314,330.00 1.55% E 401-45180-520 Capital Improvements to Bldgs $52,000.00 $16,609.43 $0.00 $35,390.57 31.94% E 401-48000-435 Misc Expense $0.00 $7,200.00 $0.00 ($7,200.00) 0.00% E 401-48000-438 Misc. Contractual $286,000.00 $0.00 $0.00 $286,000.00 0.00% E401-48000-530Capital Impr Other Than Bldgs $0.00 $7,800.00 $0.00 ($7,800.00) 0.00% Total Capital Improvement Fund Expenditures $657,280.00 $55,080.68 $0.00 $602,199.32 8.38% PARK DEVELOPMENT Revenue R 404-48000-31000 Washington Cty. Tax Settlement $20,000.00 $10,000.00 $0.00 $10,000.00 50.00% R 404-48000-33422 Other State Grants & Aids $104,000.00 $1,125.00 $0.00 $102,875.00 1.08% R 404-48000-34780 Park Dedication Fees $3,000.00 $0.00 $0.00 $3,000.00 0.00% R 404-48000-36210 Interest Income $1,200.00 $0.00 $0.00 $1,200.00 0.00% R 404-48000-36230 Donations $0.00 $7,948.98 $5,024.49 ($7,948.98) 0.00% Total Park Development Fund Revenue $128,200.00 $19,073.98 $5,024.49 $109,126.02 14.88% Expenditure E 404-48000-312 Planning Services $15,600.00 $7,500.00 $4,500.00 $8,100.00 48.08% E 404-48000-530 Capital Impr Other Than Bldgs $219,008.00 $34,961.00 $0.00 $184,047.00 15.96% E 404-48000-720 Operating Transfers $1,440.00 $0.00 $0.00 $1,440.00 0.00% Total Park Development Fund Expenditures $236,048.00 $42,461.00 $4,500.00 $193,587.00 0.1798829 EQUIPMENT REPLACEMENT FUND Revenue R 406-48500-31000 Washington Cty. Tax Settlement $87,800.00 $43,900.00 $0.00 $43,900.00 50.00% R 406-48500-36210 Interest Income $1,015.00 $0.00 $0.00 $1,015.00 0.00% R 406-48500-36260 Sale of Equipment $0.00 $0.00 $0.00 $0.00 0.00% Total Equipment Replacement Fund Revenue $88,815.00 $43,900.00 $0.00 $44,915.00 49.43% Expenditure E 406-48500-540 Heavy Machinery Capital $198,500.00 $204,505.68 $0.00 ($6,005.68) 103.03% E 406-48500-550 Motor Vehicles Capital $0.00 $0.00 $0.00 $0.00 0.00% Total Equipment Replacement Fund Expenditures $198,500.00 $204,505.68 $0.00 ($6,005.68) 103.03% LOCAL ROAD IMPROVEMENT FUND Revenue R 408-43100-31000 Washington Cty. Tax Settlement $216,860.00 $108,430.00 $0.00 $108,430.00 50.00% R 408-43100-33422 Other State Grants & Aids $0.00 $17,743.50 $6,453.50 ($17,743.50) 0.00% R 408-43100-36210 Interest Income $19,613.00 $0.00 $0.00 $19,613.00 0.00% Total LRIF Revenue $236,473.00 $126,173.50 $6,453.50 $110,299.50 53.36% Expenditure E 408-43100-303 Engineering Fees $0.00 $111,506.20 $9,087.50 ($111,506.20) 0.00% E 408-43100-530 Capital Impr Other Than Bldgs $707,200.00 $425,778.79 $0.00 $281,421.21 60.21% Total LRIF Expenditures $707,200.00 $537,284.99 $9,087.50 $169,915.01 75.97% 1 CITY OF SCANDIA VANDIA Revenue - Expenditure Summary Nov-22 2022 YTD November Budget % of Description Budget Amount Amount Balance Budget Comments BIG MARINE SEWER Revenue R 602-43210-31951 Special Assessments Principal $0.00 $2,845.85 $0.00 ($2,845.85) 0.00% R 602-43210-31952 SA Penalties & Interest $0.00 $361.53 $0.00 ($361.53) 0.00% R 602-43210-33422 Other State Grants & Aids $0.00 $0.00 $0.00 $0.00 0.00% R 602-43210-34401 Sewer User Fees $109,592.00 $77,099.70 $3,760.84 $32,492.30 70.35% R 602-43210-34402 SEWER HOOKUP FEE $0.00 $8,000.00 $0.00 ($8,000.00) 0.00% R 602-43210-36100 Special Assessments $300.00 $0.00 $0.00 $300.00 0.00% R 602-43210-36102 Penalties and Interest $0.00 $40.87 $0.00 ($40.87) 0.00% R 602-43210-36210 Interest Income $49.00 $0.00 $0.00 $49.00 0.00% Total Big Marine Sewer Revenue $109,941.00 $88,347.95 $3,760.84 $21,593.05 80.36% Expenditure E 602-43210-101 Regular Wages & Salaries $21,600.00 $19,189.01 $1,768.21 $2,410.99 88.84% E 602-43210-121 PERA Coord. Employer Contribu. $1,600.00 $1,438.26 $132.62 $161.74 89.89% E 602-43210-122 FICA Employer Contribution $1,300.00 $1,122.19 $104.26 $177.81 86.32% E 602-43210-126 MEDICARE Employer Contribution $300.00 $275.27 $24.37 $24.73 91.76% E 602-43210-151 Workers Comp Insurance Prem $900.00 $1,214.73 $0.00 ($314.73) 134.97% E 602-43210-200 Office Supplies $200.00 $127.77 $0.00 $72.23 63.89% E 602-43210-210 Operating Supplies $2,400.00 $130.71 $0.00 $2,269.29 5.45% E 602-43210-240 Small Tools and Minor Equip $550.00 $216.56 $216.56 $333.44 39.37% E 602-43210-303 Engineering Fees $10,400.00 $17,292.00 $1,340.00 ($6,892.00) 166.27% E 602-43210-304 Legal Services $0.00 $6,000.00 $0.00 ($6,000.00) 0.00% E 602-43210-308 Other Professional Services $2,200.00 $4,791.87 $607.08 ($2,591.87) 217.81% monthly testing E 602-43210-309 Software Support & Maintenance $1,200.00 $0.00 $0.00 $1,200.00 0.00% E 602-43210-317 Employee Training $1,400.00 $925.26 $0.00 $474.74 66.09% E 602-43210-321 Telephone $2,100.00 $1,926.93 $0.00 $173.07 91.76% E 602-43210-322 Postage $550.00 $200.00 $0.00 $350.00 36.36% E 602-43210-331 Travel Expenses $200.00 $157.95 $0.00 $42.05 78.98% E 602-43210-334 Licenses & Permits $1,600.00 $824.15 $0.00 $775.85 51.51% E 602-43210-361 Liability/Property Ins $900.00 $1,002.76 $0.00 ($102.76) 111.42% E 602-43210-381 Utilities -Electric & Gas $2,500.00 ($1,864.48) $757.50 $4,364.48 -74.58% E 602-43210-385 Sewer Pumping & Maintenance $11,000.00 $11,410.00 $0.00 ($410.00) 103.73% E 602-43210-386 Operation & Maintenance $5,000.00 $2,551.28 $0.00 $2,448.72 51.03% E 602-43210-404 Repair Machinery/Equipment $16,000.00 $2,401.09 $0.00 $13,598.91 15.01% E 602-43210-413 Equipment Rental $350.00 $0.00 $0.00 $350.00 0.00% E 602-43210-420 Depreciation Expense $52,200.00 $0.00 $0.00 $52,200.00 0.00% E 602-43210-438 Misc. Contractual $9,000.00 $1,655.76 $0.00 $7,344.24 18.40% E 602-43210-530 Capital Impr Other Than Bldgs $79,612.00 $45,830.00 $0.00 $33,782.00 57.57% Total Big Marine Sewer Expenditures $225,062.00 $118,819.07 $4,950.60 $106,242.93 52.79% 1 CITY OF SCANDIA VANDIA Revenue - Expenditure Summary Nov-22 2022 YTD November Budget % of Description Budget Amount Amount Balance Budget Comments UPTOWN SEWER Revenue R 612-43210-34401 Sewer User Fees $19,500.00 $11,192.74 $4,812.47 $8,307.26 57.40% R 612-43210-36210 Interest Income $92.00 $0.00 $0.00 $92.00 0.00% Total Uptown Sewer Revenue $19,592.00 $11,192.74 $4,812.47 $8,399.26 57.13% Expenditure E 612-43210-101 Regular Wages & Salaries $9,300.00 $8,222.78 $705.82 $1,077.22 88.42% E 612-43210-121 PERA Coord. Employer Contribu. $700.00 $616.60 $52.98 $83.40 88.09% E 612-43210-122 FICA Employer Contribution $600.00 $482.00 $41.45 $118.00 80.33% E 612-43210-126 MEDICARE Employer Contribution $100.00 $116.61 $9.69 ($16.61) 116.61% E 612-43210-151 Workers Comp Insurance Prem $0.00 $303.67 $0.00 ($303.67) 0.00% E 612-43210-200 Office Supplies $100.00 $0.00 $0.00 $100.00 0.00% E 612-43210-210 Operating Supplies $200.00 $500.00 $500.00 ($300.00) 250.00% E 612-43210-221 Equipment Parts $200.00 $0.00 $0.00 $200.00 0.00% E 612-43210-303 Engineering Fees $300.00 $0.00 $0.00 $300.00 0.00% E 612-43210-308 Other Professional Services $400.00 $422.00 $0.00 ($22.00) 105.50% E 612-43210-309 Software Support & Maintenance $0.00 $0.00 $0.00 $0.00 0.00% E 612-43210-317 Employee Training $350.00 $0.00 $0.00 $350.00 0.00% E 612-43210-322 Postage $0.00 $0.00 $0.00 $0.00 0.00% E 612-43210-334 Licenses & Permits $400.00 $217.00 $0.00 $183.00 54.25% E 612-43210-361 Liability/Property Ins $300.00 $334.25 $0.00 ($34.25) 111.42% E 612-43210-381 Utilities -Electric & Gas $1,700.00 $444.91 $55.94 $1,255.09 26.17% E 612-43210-385 Sewer Pumping & Maintenance $1,200.00 $327.17 $0.00 $872.83 27.26% E 612-43210-386 Operation & Maintenance $600.00 $461.55 $0.00 $138.45 76.93% E 612-43210-404 Repair Machinery/Equipment $1,500.00 $465.00 $465.00 $1,035.00 31.00% E 612-43210-420 Depreciation Expense $55,100.00 $0.00 $0.00 $55,100.00 0.00% E 612-43210-438 Misc. Contractual $1,200.00 $548.00 $0.00 $652.00 45.67% E 612-43210-530 Capital Impr Other Than Bldgs $2,600.00 $0.00 $0.00 $2,600.00 0.00% Total Uptown Sewer Expenditures $76,850.00 $13,461.54 $1,830.88 $63,388.46 17.52%