06.b Treasurer's Monthly Report 2022 (2)
City of Scandia
aug
Treasurer’s Report
7/31/2022
FUND ACCOUNTING
Beginning Cash Balance $ 4,733,719.73
7/1/2022
Beginning Checking Balance$ 1,522,431.67
Checking Receipts
$ 264,862.42
Transfers to Checking
Total Deposits
$ 264,862.42
Expenditures$ (200,867.57)
Payroll$ (39,916.72)
Transfer to Money Market$ (1,250,000.00)
Total Payments
$ (1,490,784.29)
Ending Checking Balance
$ 296,509.80
Beginnging Money Market Balance
$ 1,177,308.76
Money Market Receipts
$ 335.59
Tranfer from Checking
$ 1,250,000.00
Ending Money Market Balance
$ 2,427,644.35
Beginning Investments Balance
$ 2,030,090.05
Investments Receipts
$ 731.96
Ending Investments Balance$ 2,030,822.01
Beginning EDA Balance$ 27,019.70
EDA Receipts
EDA Expenditures
EDA Transfers from Checking - in transit$ 4,000.00
Ending EDA Balance$ 31,019.70
Outstanding Checks
$ (48,022.19)
7/31/2022
Ending Cash Balance $ 4,737,973.67
CHECKING, MONEY MARKET & INVESTMENT CD's
Checking *102$ 1,522,431.67
Beg Bal
Credits$ 264,862.42
Debits$ (1,490,784.29)
$ 296,509.80
End Bal
Money Market *105 - Rate .25%$ 1,177,308.76
Beg Bal
rate change from 1.25% Credits
$ 1,250,335.59
Debits
End Bal$ 2,427,644.35
Investments
CD *4422 - Rate .45% 12 mo., 3/25/2023$ 317,375.52
CD *4424 - Rate 2.50% 12 mo., 7/17/2023 **NEW RATE$ 441,355.21
CD *4425 - Rate .30% 12 mo., 9/28/2022$ 734,083.62
CD *4426 - Rate .30% 12 mo., 1/29/2023
$ 538,007.66
Total Investments$ 2,030,822.01
Total Bank & Investment Accounts
$ 4,754,976.16
$ (48,022.19)
Checks in Transit *3102
Deposit in transit checking
Deposit in transit money market
$ 4,706,953.97
Total Adjusted Undesignated Funds
Scandia EDA *6301 $ 27,019.70
Receipts
Property Tax Settlement$ 4,000.00
Expenditures
Checks in Transit
Deposit in Transit
Total Designated EDA Funds$ 31,019.70
Total Funds$ 4,737,973.67
Submitted by: Colleen Firkus, Treasurer
CASH BALANCES
2022END OF MONTH
FUNDJANUARYFEBRUARYMARCHAPRILMAYJUNEJULY
101 GENERAL$ 1,375,256.03$ 1,243,313.89$ 1,124,142.19 $ 1,012,873.90$ 890,924.57$ 1,701,216.18$ 1,517,797.37
203 COVID-19 RELIEF$ 228,181.31$ 228,181.31$ 228,181.31 $ 228,181.31$ 228,181.31$ 228,181.31$ 456,362.62
226 CABLE TV$ 39,431.38$ 41,288.08$ 42,940.54 $ 43,836.65$ 44,302.18$ 17,599.67$ 19,525.37
230 RESTRICTED DONATIONS$ 175.00$ 175.00$ 925.00 $ 2,525.00$ 3,575.00$ 3,575.00$ -
307 BLACKTOP PROJECT 2007$ -$ -$ 6,463.65 $ 6,463.65$ 6,463.65$ 6,730.52$ 6,730.52
313 EQUIPMENT CERTIFICATES$ 24,314.07$ 24,314.07$ 24,314.07 $ 25,110.07$ 25,110.07$ (3,744.93)$ (3,744.93)
315 EQUIPMENT CERTIFICATES$ 15,452.35$ 15,452.35$ 15,452.35 $ 15,951.35$ 15,951.35$ 15,951.35$ 15,951.35
317 EQUIPMENT CERTIFICATES$ (297.54)$ (297.54)$ (297.54)$ 103.46$ 103.46$ 17,365.46$ (15,074.54)
318 BLACKTOP PROJECT$ 603.14$ 603.14$ 603.14 $ 4,359.14$ (45,198.37)$ 127,067.13$ 127,067.13
401 CAPITAL IMPR$ 818,049.51$ 811,649.51$ 719,740.45 $ 716,800.12$ 716,431.08$ 822,054.08$ 819,894.08
404 PARK CAP IMPR$ 144,888.28$ 144,888.28$ 153,888.28 $ 154,216.28$ 154,216.28$ 165,491.28$ 165,616.28
406 EQUIPMENT REPLACEMENT$ 316,104.69$ 316,104.69$ 316,104.69 $ 104,259.83$ 104,259.83$ 155,827.01$ 155,827.01
408 LOCAL ROAD IMPROVEMENT$ 1,258,339.81$ 1,248,055.95$ 1,220,765.95 $ 1,226,717.45$ 1,220,617.45$ 1,329,096.45$ 1,319,327.95
602 BIG MARINE SEWER$ 96,112.55$ 91,195.97$ 78,021.72 $ 79,320.98$ 49,281.22$ 64,260.55$ 71,515.96
612 UPTOWN SEWER$ 14,094.48$ 16,430.41$ 15,020.58 $ 15,050.60$ 14,347.68$ 13,148.48$ 9,512.61
801 ESCROW$ 33,340.59$ 38,526.39$ 34,870.13 $ 33,870.23$ 36,986.33$ 42,880.49$ 40,645.19
SUBTOTAL$ 4,364,045.65$ 4,219,881.50$ 3,981,136.51 $ 3,669,640.02$ 3,465,553.09$ 4,706,700.03$ 4,706,953.97
225 EDA$ 28,903.67$ 28,903.67$ 27,702.55 $ 27,344.55$ 27,399.55$ 27,019.70$ 31,019.70
TOTAL$ 4,392,949.32$ 4,248,785.17$ 4,008,839.06 $ 3,696,984.57$ 3,492,952.64$ 4,733,719.73$ 4,737,973.67
CITY OF SCANDIA
Revenue - Expenditure Summary
July 2022
Description2022 BudgetYTD AmountJuly AmountBudget Balance% of BudgetComments
GENERAL FUND
RevenueADMINSTRATION & FINANCE
R 101-41000-31000 Washington Cty. Tax Settlement$1,583,000.00$811,918.35$0.00$771,081.6551.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$0.00$0.00$20,000.000.00%
R 101-41000-31830 Solar Energy Production Tax$5,000.00$4,115.14$0.00$884.8682.30%
R 101-41000-31900 Penalties & Interest Del Tax$400.00$234.87$0.00$165.1358.72%
R 101-41000-32150 Utility Permits$3,000.00$2,550.00$300.00$450.0085.00%
R 101-41000-32180 Tobacco & Liquor Licenses$8,500.00$422.00$0.00$8,078.004.96%
R 101-41000-32190 Other City Permits$3,000.00$2,275.00$535.00$725.0075.83%
R 101-41000-32210 Building Permits$135,000.00$90,085.09$12,631.66$44,914.9166.73%
R 101-41000-32260 Gambling Permits$0.00$115.00$0.00($115.00)0.00%
R 101-41000-33401 LGA/MVHC/AG/PERA Aid$13,200.00$410.00$410.00$12,790.003.11%
R 101-41000-33420 Fire Relief State PERA$39,600.00$0.00$0.00$39,600.000.00%
R 101-41000-33422 Other State Grants & Aids$5,400.00$0.00$0.00$5,400.000.00%
R 101-41000-33428 PILOT$6,000.00$3,102.02$0.00$2,897.9851.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.000.00%
R 101-41000-33640 Other Grants$1,000.00$0.00$0.00$1,000.000.00%
R 101-41000-34102 Legal Services$0.00$0.00$0.00$0.000.00%
R 101-41000-34103 Zoning and Planning$4,300.00$3,050.00$0.00$1,250.0070.93%
R 101-41000-34106 Engineering Fees$0.00$0.00$0.00$0.000.00%
R 101-41000-34107 Assessment Search Fees$100.00$20.00$0.00$80.0020.00%
R 101-41000-34109 Water Usage$200.00$0.00$0.00$200.000.00%
R 101-41000-34201 Impound Fees$0.00$0.00$0.00$0.000.00%
R 101-41000-34202 Fire Protection Services$31,493.00$31,493.00$0.00$0.00100.00%
R 101-41000-34301 Damage Repairs$0.00$0.00$0.00$0.000.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$1,800.00$0.00$1,800.0050.00%
R 101-41000-34305 Other Street Services$0.00$0.00$0.00$0.000.00%
R 101-41000-34730 Ad Revenue$2,100.00$1,400.00$0.00$700.0066.67%
R 101-41000-34740 Coffee Sales$0.00$0.00$0.00$0.000.00%
R 101-41000-34750 Facilities Rental$5,000.00$7,021.80$1,010.00($2,021.80)140.44%
R 101-41000-34760 Cleaning Fees$200.00$0.00$0.00$200.000.00%
R 101-41000-34790 Recreation Programs$1,000.00$1,465.00$0.00($465.00)146.50%
R 101-41000-34950 Solar Subscription$0.00$0.00$0.00$0.000.00%
R 101-41000-35101 Fines & Forfeitures$7,000.00$4,129.59$834.92$2,870.4158.99%
R 101-41000-35201 Forfeited Land Sales$0.00$0.00$0.00$0.000.00%
R 101-41000-36210 Interest Income$15,900.00$5,992.30$1,078.44$9,907.7037.69%
R 101-41000-36230 Donations$1,500.00$2,841.35$0.00($1,341.35)189.42%
Ice Sculpture Donations
R 101-41000-36240 Insurance Dividend$2,000.00$0.00$0.00$2,000.000.00%
R 101-41000-36250 Misc. Refund$2,500.00$154.57$4.72$2,345.436.18%
Total General Fund Revenue$1,911,393.00$1,080,502.74$16,804.74$830,890.2656.53%
Operating TransfersR 101-49000-39203 Transfer from Other Funds$1,275,000.00$1,250,000.00($1,275,000.00)
R 101-49000-39204 Money Market Transfer$470,000.00$0.00($470,000.00)
$1,745,000.00$1,250,000.00($1,745,000.00)
CITY OF SCANDIA
Revenue - Expenditure Summary
July 2022
Description2022 BudgetYTD AmountJuly AmountBudget Balance% of BudgetComments
GENERAL FUND
ADMINISTRATION & FINANCE
Expenditures
E 101-41000-101 Regular Wages & Salaries$162,600.00$82,507.50$12,023.75$80,092.5050.74%
E 101-41000-121 PERA Coord. Employer Contribu.$12,000.00$6,177.57$901.79$5,822.4351.48%
E 101-41000-122 FICA Employer Contribution$10,100.00$4,051.09$722.74$6,048.9140.11%
E 101-41000-126 MEDICARE Employer Contribution$2,400.00$1,261.30$169.02$1,138.7052.55%
E 101-41000-131 Employer Paid Health$23,600.00$15,556.87$2,055.74$8,043.1365.92%
E 101-41000-132 Dental Insurance$2,900.00$564.27$80.61$2,335.7319.46%
E 101-41000-134 Employer Paid Life$600.00$280.00$40.00$320.0046.67%
E 101-41000-135 Employer Paid Disability$1,200.00$293.23$41.89$906.7724.44%
E 101-41000-151 Worker s Comp Insurance Prem$1,200.00$1,775.67$47.12($575.67)147.97%
E 101-41000-200 Office Supplies$1,000.00$600.50$3.48$399.5060.05%
E 101-41000-203 Printed Forms & Papers$1,800.00$973.07$0.00$826.9354.06%
E 101-41000-210 Operating Supplies$900.00$665.83$0.00$234.1773.98%
E 101-41000-300 Assessor$0.00$0.00$0.00$0.000.00%
E 101-41000-301 Auditing and Acct g Services$20,800.00$21,600.00$4,400.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$18,455.90($51.00)$21,544.1046.14%
E 101-41000-306 Personal Testing & Recruit$0.00$0.00$0.00$0.000.00%
E 101-41000-308 Other Professional Services$1,000.00$1,403.95$0.00($403.95)140.40%
American Legal $1,315; PSN $89
E 101-41000-309 Software Support & Maintenance$12,000.00$5,122.07($7,032.31)$6,877.9342.68%
E 101-41000-314 Animal Control$0.00$464.99$0.00($464.99)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.000.00%
E 101-41000-319 Other Services$1,300.00$74.00$0.00$1,226.005.69%
E 101-41000-321 Telephone$4,500.00$2,854.93$420.44$1,645.0763.44%
E 101-41000-322 Postage$2,300.00$1,065.66$0.00$1,234.3446.33%
E 101-41000-323 $0.00$0.00$0.00$0.000.00%
E 101-41000-331 Travel Expenses$2,500.00$1,136.70$683.39$1,363.3045.47%
E 101-41000-351 Legal Notices Publishing$2,000.00$894.15$0.00$1,105.8544.71%
E 101-41000-361 Liability/Property Ins$4,100.00$4,568.15$0.00($468.15)111.42%
E 101-41000-365 Insurance Claims$0.00$0.00$0.00$0.000.00%
E 101-41000-381 Utilities-Electric & Gas$12,000.00$3,953.70$1,172.37$8,046.3032.95%
E 101-41000-413 Equipment Rental$2,800.00$892.89$32.71$1,907.1131.89%
E 101-41000-430 Recycling$27,800.00$16,243.50$2,320.50$11,556.5058.43%
E 101-41000-433 Dues and Subscriptions$5,900.00$289.62$0.00$5,610.384.91%
E 101-41000-434 Youth Service Bureau$5,500.00$5,500.00$0.00$0.00100.00%
E 101-41000-435 Misc Expense$0.00$0.00$0.00$0.000.00%
E 101-41000-437 Cable TV Franchise$0.00$0.00$0.00$0.000.00%
E 101-41000-438 Misc. Contractual$3,600.00$3,562.00$0.00$38.0098.94%
E 101-41000-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-41000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00%
E 101-41000-570 Office Equipment$4,000.00$2,603.23$0.00$1,396.7765.08%
E 101-41000-710 Residual Equity Transfers$0.00$0.00$0.00$0.000.00%
$373,700.00$206,621.34$18,032.24$167,078.6655.29%
CITY COUNCIL
ExpendituresE 101-41110-101 Regular Wages & Salaries$18,100.00$8,972.77$4,486.38$9,127.2349.57%
E 101-41110-122 FICA Employer Contribution$1,100.00$159.45$53.15$940.5514.50%
E 101-41110-126 MEDICARE Employer Contribution$300.00$78.02$65.05$221.9826.01%
E 101-41110-127 PERA Defined$600.00$320.03$181.45$279.9753.34%
E 101-41110-151 Worker s Comp Insurance Prem$100.00$3.20$3.20$96.803.20%
E 101-41110-308 Other Professional Services$0.00$0.00$0.00$0.000.00%
E 101-41110-316 Conferences & Seminars$1,000.00$398.00$0.00$602.0039.80%
E 101-41110-331 Travel Expenses$1,800.00$0.00$0.00$1,800.000.00%
E 101-41110-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-41110-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00%
E 101-41110-570 Office Equipment$0.00$0.00$0.00$0.000.00%
$23,000.00$9,931.47$4,789.23$13,068.5343.18%
ELECTIONS
ExpendituresE 101-41410-199 Election Judge$4,800.00$0.00$0.00$4,800.000.00%
E 101-41410-200 Office Supplies$100.00$0.00$0.00$100.000.00%
E 101-41410-203 Printed Forms & Papers$0.00$0.00$0.00$0.000.00%
E 101-41410-210 Operating Supplies$1,000.00$0.00$0.00$1,000.000.00%
E 101-41410-351 Legal Notices Publishing$200.00$0.00$0.00$200.000.00%
E 101-41410-413 Equipment Rental$1,500.00$1,515.00$0.00($15.00)101.00%
$7,600.00$1,515.00$0.00$6,085.0019.93%
CITY OF SCANDIA
Revenue - Expenditure Summary
July 2022
Description2022 BudgetYTD AmountJuly AmountBudget Balance% of BudgetComments
PLANNING & BUILDING
ExpendituresE 101-41910-101 Regular Wages & Salaries$49,800.00$28,218.01$3,872.66$21,581.9956.66%
E 101-41910-121 PERA Coord. Employer Contribu.$3,600.00$2,115.34$290.46$1,484.6658.76%
E 101-41910-122 FICA Employer Contribution$3,100.00$1,634.51$225.04$1,465.4952.73%
E 101-41910-126 MEDICARE Employer Contribution$700.00$395.07$52.62$304.9356.44%
E 101-41910-131 Employer Paid Health$11,400.00$7,749.91$996.34$3,650.0967.98%
E 101-41910-132 Dental Insurance$1,900.00$291.83$41.69$1,608.1715.36%
E 101-41910-134 Employer Paid Life$200.00$100.80$14.40$99.2050.40%
E 101-41910-135 Employer Paid Disability$400.00$234.71$33.53$165.2958.68%
E 101-41910-203 Printed Forms & Papers$20.00$253.55$0.00($233.55)1267.75%
2 copies of Unified Dev Code
E 101-41910-311 Contract Permit Inspections$55,000.00$35,680.14$8,723.46$19,319.8664.87%
E 101-41910-312 Planning Services$28,000.00$10,769.73$4,599.17$17,230.2738.46%
E 101-41910-313 Committee & Commission Reimbur$5,000.00$2,600.00$0.00$2,400.0052.00%
E 101-41910-316 Conferences & Seminars$0.00$0.00$0.00$0.000.00%
E 101-41910-319 Other Services$0.00$0.00$0.00$0.000.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$1,724.86$6,932.8236.97%
E 101-41910-439 Refunds Issued$0.00($572.80)$0.00$572.800.00%
$171,920.00$95,543.51$20,574.23$76,376.4955.57%
GENERAL FUND CONT.ASSESSOR
ExpendituresE 101-41960-300 Assessor$21,600.00$12,678.19$1,800.00$8,921.8158.70%
POLICE
ExpendituresE 101-42100-318 Police Contract$150,400.00$75,206.76$75,206.76$75,193.2450.00%
E 101-42100-319 Other Services$500.00$309.36$0.00$190.6461.87%
$150,900.00$75,516.12$75,206.76$75,383.8850.04%
FIRE
ExpendituresE 101-42200-101 Regular Wages & Salaries$95,000.00$65,967.59$11,155.41$29,032.4169.44%
E 101-42200-121 PERA Coord. Employer Contribu.$9,700.00$0.00$0.00$9,700.000.00%
E 101-42200-122 FICA Employer Contribution$5,900.00$3,420.23$546.97$2,479.7757.97%
E 101-42200-124 Police & Fire PERA$0.00$4,974.14$716.17($4,974.14)0.00%
E 101-42200-126 MEDICARE Employer Contribution$1,400.00$637.62$163.22$762.3845.54%
E 101-42200-134 Employer Paid Life$200.00$112.00$16.00$88.0056.00%
E 101-42200-135 Employer Paid Disability$700.00$0.00$0.00$700.000.00%
E 101-42200-141 Unemployment Compensation$0.00$0.00$0.00$0.000.00%
E 101-42200-151 Worker s Comp Insurance Prem$9,550.00$13,008.42$367.94($3,458.42)136.21%
E 101-42200-200 Office Supplies$400.00$0.00$0.00$400.000.00%
E 101-42200-203 Printed Forms & Papers$150.00$0.00$0.00$150.000.00%
E 101-42200-209 Medical Supplies$2,500.00$2,222.86$0.00$277.1488.91%
E 101-42200-210 Operating Supplies$8,000.00$1,001.15$166.84$6,998.8512.51%
E 101-42200-211 Cleaning Supplies$100.00$17.88$0.00$82.1217.88%
E 101-42200-212 Fuel$2,500.00$2,235.60$504.92$264.4089.42%
E 101-42200-217 Uniforms & Safety Equipment$10,000.00$0.00$0.00$10,000.000.00%
E 101-42200-221 Equipment Parts$3,000.00$258.79$54.29$2,741.218.63%
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$97.51$84.67$5,202.491.84%
E 101-42200-240 Small Tools and Minor Equip$8,500.00$8,768.55$58.90($268.55)103.16%
Regions Hospital Education Agreement
E 101-42200-305 Medical Services$4,500.00$7,330.00$1,695.00($2,830.00)162.89%
$2,875; SCBA Exams
E 101-42200-306 Personal Testing & Recruit$1,500.00$903.00$0.00$597.0060.20%
E 101-42200-309 Software Support & Maintenance$17,000.00$9,018.12$3,328.56$7,981.8853.05%
E 101-42200-310 Medical Training$11,000.00$0.00$0.00$11,000.000.00%
E 101-42200-316 Conferences & Seminars$300.00$0.00$0.00$300.000.00%
E 101-42200-317 Employee Training$8,000.00$1,980.00$410.00$13,520.0024.75%
E 101-42200-319 Other Services$500.00$478.00$408.00$22.0095.60%
E 101-42200-321 Telephone$6,400.00$3,753.09$454.08$2,646.9158.64%
E 101-42200-322 Postage$0.00$0.00$0.00$0.000.00%
E 101-42200-324 State of MN-Fire Relief$35,300.00$0.00$0.00$35,300.000.00%
E 101-42200-325 City Match-Fire Relief$0.00$0.00$0.00$0.000.00%
E 101-42200-331 Travel Expenses$2,000.00$0.00$0.00$2,000.000.00%
E 101-42200-334 Licenses & Permits$200.00$0.00$0.00$200.000.00%
E 101-42200-340 Advertising$0.00$0.00$0.00$0.000.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,834.60($160.69)($1,834.60)145.87%
E 101-42200-384 Refuse/Garbage Disposal$850.00$574.88$67.24$275.1267.63%
E 101-42200-385 Sewer Pumping & Maintenance$700.00$300.00$0.00$400.0042.86%
E 101-42200-401 Building Maintenance/Repairs$2,500.00$1,530.49$228.03$969.5161.22%
E 101-42200-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00%
E 101-42200-404 Repair Machinery/Equipment$8,000.00$3,115.69$134.69$4,884.3138.95%
E 101-42200-407 Well Repair & Maintenance$140.00$0.00$0.00$140.000.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.0039.15%
E 101-42200-440 Events$800.00$0.00$0.00$800.000.00%
E 101-42200-520 Capital Improvements to Bldgs$0.00$0.00$0.00$0.000.00%
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.000.00%
E 101-42200-570 Office Equipment$900.00$0.00$0.00$900.000.00%
$280,190.00$150,898.24$20,400.24$136,791.7653.86%
ExpendituresANIMAL CONTROL
E 101-42700-314 Animal Control$4,000.00$2,028.79$793.75$1,971.2150.72%
CITY OF SCANDIA
Revenue - Expenditure Summary
July 2022
Description2022 BudgetYTD AmountJuly AmountBudget Balance% of BudgetComments
GENERAL FUND CONT.PUBLIC WORKS
ExpendituresE 101-43000-101 Regular Wages & Salaries$220,300.00$116,414.97$17,116.03$103,885.0352.84%
E 101-43000-102 OT Regular Wages$4,900.00$7,110.63$86.40($2,210.63)145.11%
E 101-43000-104 Temporary Employee Wages$3,700.00$2,721.07$0.00$978.9373.54%
E 101-43000-121 PERA Coord. Employer Contribu.$16,900.00$9,248.22$1,290.18$7,651.7854.72%
E 101-43000-122 FICA Employer Contribution$14,000.00$7,999.07$1,009.23$6,000.9357.14%
E 101-43000-126 MEDICARE Employer Contribution$3,300.00$1,893.50$236.05$1,406.5057.38%
E 101-43000-131 Employer Paid Health$53,600.00$36,938.01$4,634.22$16,661.9968.91%
E 101-43000-132 Dental Insurance$2,000.00$581.98$83.14$1,418.0229.10%
E 101-43000-134 Employer Paid Life$700.00$432.04$58.16$267.9661.72%
E 101-43000-135 Employer Paid Disability$1,700.00$1,013.53$144.79$686.4759.62%
E 101-43000-141 Unemployment Compensation$1,500.00$0.00$0.00$1,500.000.00%
E 101-43000-151 Worker s Comp Insurance Prem$16,890.00$23,017.71$651.06($6,127.71)136.28%
E 101-43000-200 Office Supplies$600.00$0.00$0.00$600.000.00%
E 101-43000-210 Operating Supplies$8,000.00$4,933.78$231.60$3,066.2261.67%
E 101-43000-212 Fuel$18,000.00$12,593.53$2,554.52$5,406.4769.96%
E 101-43000-217 Uniforms & Safety Equipment$2,000.00$343.81$0.00$1,656.1917.19%
E 101-43000-221 Equipment Parts$12,100.00$6,501.34$0.00$5,598.6653.73%
E 101-43000-222 Tires$6,500.00$4,064.00$4,064.00$2,436.0062.52%
E 101-43000-223 Structure Repair & Supplies$2,000.00$0.00$0.00$2,000.000.00%
E 101-43000-224 Materials for Road Maintenance$15,000.00$5,256.21$437.52$9,743.7935.04%
E 101-43000-226 Sign Replacement and Repair$2,000.00$570.95$0.00$1,429.0528.55%
E 101-43000-228 Gravel$9,900.00$696.65$0.00$9,203.357.04%
E 101-43000-229 Salt$19,000.00$15,652.75$0.00$3,347.2582.38%
E 101-43000-240 Small Tools and Minor Equip$5,000.00$61.94$29.85$4,938.061.24%
E 101-43000-302 Surveying$0.00$0.00$0.00$0.000.00%
E 101-43000-303 Engineering Fees$9,400.00$3,079.00$0.00$6,321.0032.76%
E 101-43000-304 Legal Services$0.00$0.00$0.00$0.000.00%
E 101-43000-305 Medical Services$1,200.00$502.65$45.00$697.3541.89%
E 101-43000-309 Software Support & Maintenance$1,900.00$0.00$0.00$1,900.000.00%
E 101-43000-317 Employee Training$1,700.00$0.00$0.00$1,700.000.00%
E 101-43000-319 Other Services$13,200.00$1,181.11$18.90$12,018.898.95%
E 101-43000-321 Telephone$4,800.00$3,007.26$801.52$1,792.7462.65%
E 101-43000-331 Travel Expenses$500.00$0.00$0.00$500.000.00%
E 101-43000-334 Licenses & Permits$500.00$173.25$0.00$326.7534.65%
E 101-43000-361 Liability/Property Ins$9,300.00$10,361.91$0.00($1,061.91)111.42%
E 101-43000-365 Insurance Claims$0.00$0.00$0.00$0.000.00%
E 101-43000-381 Utilities-Electric & Gas$3,200.00$4,070.91($71.00)($870.91)127.22%
E 101-43000-384 Refuse/Garbage Disposal$900.00$690.67$44.84$209.3376.74%
E 101-43000-385 Sewer Pumping & Maintenance$800.00$755.80$0.00$44.2094.48%
E 101-43000-387 Street Light Utilities$4,000.00$2,472.72$225.75$1,527.2861.82%
E 101-43000-401 Building Maintenance/Repairs$5,500.00$1,507.44$281.57$3,992.5627.41%
E 101-43000-403 Improvements Other Than Bldgs$0.00$0.00$0.00$0.000.00%
E 101-43000-404 Repair Machinery/Equipment$14,000.00$1,128.25$750.00$12,871.758.06%
E 101-43000-405 Contractual Road Maint/Repair$150,000.00$38,447.31$6,301.70$111,552.6925.63%
E 101-43000-407 Well Repair & Maintenance$0.00$0.00$0.00$0.000.00%
E 101-43000-413 Equipment Rental$3,500.00$2,046.32$741.97$1,453.6858.47%
E 101-43000-417 Uniform Rental$1,000.00$495.17$95.95$504.8349.52%
E 101-43000-433 Dues and Subscriptions$200.00$0.00$0.00$200.000.00%
E 101-43000-438 Misc. Contractual$15,000.00$931.00$0.00$14,069.006.21%
E 101-43000-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-43000-530 Capital Impr Other Than Bldgs$0.00$1,178.00$0.00($1,178.00)0.00%
E 101-43000-550 Motor Vehicles Capital$0.00$0.00$0.00$0.000.00%
E 101-43000-560 Furniture and Fixtures$0.00$0.00$0.00$0.000.00%
E 101-43000-570 Office Equipment$3,300.00$589.49$0.00$2,710.5117.86%
$683,490.00$330,663.95$41,862.95$352,826.0548.38%
CITY OF SCANDIA
Revenue - Expenditure Summary
July 2022
Description2022 BudgetYTD AmountJuly AmountBudget Balance% of BudgetComments
GENERAL FUND CONT.PARKS & RECREATION
ExpendituresE 101-45000-101 Regular Wages & Salaries$9,800.00$4,533.54$738.48$5,266.4646.26%
E 101-45000-104 Temporary Employee Wages$29,100.00$10,896.88$1,712.75$18,203.1237.45%
E 101-45000-121 PERA Coord. Employer Contribu.$700.00$338.56$55.38$361.4448.37%
E 101-45000-122 FICA Employer Contribution$2,600.00$927.51$149.53$1,672.4935.67%
E 101-45000-126 MEDICARE Employer Contribution$600.00$233.87$34.96$366.1338.98%
E 101-45000-131 Employer Paid Health$2,100.00$1,716.13$176.83$383.8781.72%
E 101-45000-132 Dental Insurance$100.00$21.14$3.02$78.8621.14%
E 101-45000-134 Employer Paid Life$0.00$83.86$11.84($83.86)0.00%
E 101-45000-135 Employer Paid Disability$1,000.00$217.35$31.05$782.6521.74%
E 101-45000-141 Unemployment Compensation$0.00$119.13$119.13($119.13)0.00%
E 101-45000-151 Worker s Comp Insurance Prem$1,450.00$1,970.60$55.74($520.60)135.90%
E 101-45000-200 Office Supplies$300.00$0.00$0.00$300.000.00%
E 101-45000-203 Printed Forms & Papers$900.00$77.60$0.00$822.408.62%
E 101-45000-210 Operating Supplies$900.00$495.76$236.84$404.2455.08%
E 101-45000-212 Fuel$1,500.00$450.77$0.00$1,049.2330.05%
E 101-45000-221 Equipment Parts$2,000.00$576.19$343.47$1,423.8128.81%
E 101-45000-223 Structure Repair & Supplies$500.00$289.32$289.32$210.6857.86%
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.000.00%
E 101-45000-313 Committee & Commission Reimbur$1,200.00$540.00$0.00$660.0045.00%
E 101-45000-319 Other Services$0.00$121.60$0.00($121.60)0.00%
E 101-45000-322 Postage$0.00$0.00$0.00$0.000.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.000.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$5,446.02$996.19($1,446.02)136.15%
E 101-45000-384 Refuse/Garbage Disposal$1,900.00$2,187.52$45.68($287.52)115.13%
E 101-45000-385 Sewer Pumping & Maintenance$500.00$330.39$187.42$169.6166.08%
E 101-45000-401 Building Maintenance/Repairs$6,000.00$3,195.57$2,757.59$2,804.4353.26%
E 101-45000-403 Improvements Other Than Bldgs$0.00$1,594.97$108.48($1,594.97)0.00%
E 101-45000-404 Repair Machinery/Equipment$700.00$100.00$0.00$600.0014.29%
E 101-45000-406 Grounds Care$4,000.00$516.66$516.66$3,483.3412.92%
E 101-45000-438 Misc. Contractual$3,000.00$0.00$0.00$3,000.000.00%
E 101-45000-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-45000-440 Events$3,000.00$6,567.69$75.00($3,567.69)218.92%
Ice Sculpture $5,000
E 101-45000-490 Financial Assistance$0.00$0.00$0.00$0.000.00%
E 101-45000-530 Capital Impr Other Than Bldgs$10,000.00$0.00$0.00$10,000.000.00%
E 101-45000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
$94,950.00$51,999.22$8,645.36$42,950.7854.76%
COMMUNITY CENTER
ExpendituresE 101-45180-101 Regular Wages & Salaries$14,400.00$7,859.42$1,191.33$6,540.5854.58%
E 101-45180-104 Temporary Employee Wages$0.00$0.00$0.00$0.000.00%
E 101-45180-121 PERA Coord. Employer Contribu.$1,100.00$561.38$80.31$538.6251.03%
E 101-45180-122 FICA Employer Contribution$900.00$455.91$70.15$444.0950.66%
E 101-45180-126 MEDICARE Employer Contribution$200.00$115.81$16.42$84.1957.91%
E 101-45180-131 Employer Paid Health$3,100.00$1,740.47$242.10$1,359.5356.14%
E 101-45180-134 Employer Paid Life$0.00$27.30$3.60($27.30)0.00%
E 101-45180-135 Employer Paid Disability$100.00$80.08$11.44$19.9280.08%
E 101-45180-151 Worker s Comp Insurance Prem$0.00$0.00$0.00$0.000.00%
E 101-45180-210 Operating Supplies$2,800.00$835.74$207.50$1,964.2629.85%
E 101-45180-223 Structure Repair & Supplies$6,500.00$21.71$12.94$6,478.290.33%
E 101-45180-334 Licenses & Permits$900.00$777.00$0.00$123.0086.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$6,472.49$433.47$4,127.5161.06%
E 101-45180-384 Refuse/Garbage Disposal$1,800.00$957.60$153.42$842.4053.20%
E 101-45180-385 Sewer Pumping & Maintenance$3,500.00$2,184.69$608.88$1,315.3162.42%
E 101-45180-401 Building Maintenance/Repairs$13,000.00$7,913.24$668.63$5,086.7660.87%
E 101-45180-404 Repair Machinery/Equipment$3,000.00$0.00$0.00$3,000.000.00%
E 101-45180-406 Grounds Care$650.00$0.00$0.00$650.000.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.000.00%
E 101-45180-439 Refunds Issued$0.00$0.00$0.00$0.000.00%
E 101-45180-520 Capital Improvements to Bldgs$6,000.00$1,999.00$0.00$4,001.0033.32%
E 101-45180-530 Capital Impr Other Than Bldgs$0.00$0.00$0.00$0.000.00%
E 101-45180-570 Office Equipment$0.00$0.00$0.00$0.000.00%
E 101-45180-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
$73,950.00$48,239.46$3,700.19$25,710.5465.23%
Operating TransfersE 101-49000-720 Operating Transfers$1,745,000.00$1,250,000.00($1,745,000.00)
TOTAL GENERAL FUND EXPENDITURES$1,605,110.00$834,737.05$175,404.71$770,372.9552.00%
CITY OF SCANDIA
Revenue - Expenditure Summary
July 2022
Description2022 BudgetYTD AmountJuly AmountBudget Balance% of BudgetComments
COVID RELIEF FUND
RevenueR 203-46200-33150 Federal Grant$0.00$228,181.31$228,181.31($228,181.31)0.00%
ExpendituresE 203-49000-720 Operating Transfers$0.00$0.00$0.00$0.000.00%
EDA FUND
RevenueR 225-46500-31000 Washington Cty. Tax Settlement$8,000.00$4,000.00$0.00$4,000.0050.00%
R 225-46500-33640 Other Grants$0.00$0.00$0.00$0.000.00%
R 225-46500-36210 Interest Income$200.00$0.00$0.00$200.000.00%
Total EDA Fund Revenue$8,200.00$4,000.00$0.00$4,200.0048.78%
ExpenditureE 225-46500-210 Operating Supplies$0.00$0.00$0.00$0.000.00%
E 225-46500-303 Engineering Fees$5,000.00$0.00$0.00$5,000.000.00%
E 225-46500-304 Legal Services$0.00$0.00$0.00$0.000.00%
E 225-46500-308 Other Professional Services$125.00$0.00$0.00$125.000.00%
E 225-46500-340 Advertising$2,000.00$75.00$0.00$1,925.003.75%
E 225-46500-433 Dues and Subscriptions$2,650.00$1,653.00$0.00$997.0062.38%
E 225-46500-440 Events$400.00$614.93$24.08($214.93)153.73%
Total EDA Fund Expenditures$10,175.00$2,342.93$24.08$7,832.0723.03%
CABLE TV FUND
RevenueR 226-41950-36210 Interest Income$0.00$0.00$0.00$0.000.00%
R 226-41950-38050 Cable TV Franchise Rebates$15,400.00$9,406.83$1,592.00$5,993.1761.08%
R 226-41950-38051 PEG Fees$3,500.00$2,556.84$438.60$943.1673.05%
Total Cable TV Fund Revenue$18,900.00$11,963.67$2,030.60$6,936.3363.30%
ExpendituresE 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,123.74$104.90$1,376.2660.68%
E 226-41950-438 Misc. Contractual$8,000.00$2,300.00$0.00$5,700.0028.75%
Council Chambers AV equipment 1/2
E 226-41950-570 Office Equipment$250.00$26,989.63$0.00($26,739.63)10795.85%
payment
Total Cable TV Fund Expenditures$11,750.00$31,911.37$104.90($20,161.37)271.59%
GATEWAY TRAIL FUND
RevenueR 230-45000-36230 Donations$0.00$3,400.00$0.00($3,400.00)0.00%
ExpendituresE 230-45000-308 Other Professional Services$0.00$3,575.00$3,575.00($3,575.00)0.00%
BLACKTOP PROJECT 2007
RevenueR 307-47000-31952 SA Penalties & Interest$0.00$6,698.52$0.00($6,698.52)0.00%
2013 EQUIPMENT CERTIFICATES
RevenueR 313-47000-31000 Washington Cty. Tax Settlement$67,000.00$33,500.00$0.00$33,500.0050.00%
ExpenditureE 313-47000-601 Long Term Debt Principal$60,000.00$60,000.00$0.00$0.00100.00%
E 313-47000-611 Long Term Debt Interest$2,790.00$1,860.00$0.00$930.0066.67%
E 313-47000-620 Fiscal Agent s Fees$495.00$495.00$0.00$0.00100.00%
Total 213 Fund Expenditures
$63,285.00$62,355.00$0.00$930.0098.53%
2017 EQUIPMENT CERTIFICATES
RevenueR 317-47000-31000 Washington Cty. Tax Settlement$34,524.00$17,262.00$0.00$17,262.0050.00%
ExpendituresE 317-47000-601 Long Term Debt Principal$32,000.00$32,000.00$32,000.00$0.00100.00%
E 317-47000-611 Long Term Debt Interest$880.00$880.00$440.00$0.00100.00%
E 317-47000-620 Fiscal Agent s Fees$495.00$0.00$0.00$495.000.00%
Total 217 Fund Expenditures
$33,375.00$32,880.00$32,440.00$495.00$0.00
2018 STREET RECONSTRUCTION
RevenueR 318-47000-31000 Washington Cty. Tax Settlement$344,531.00$172,265.50$0.00$172,265.5050.00%
ExpenditureE 318-47000-601 Long Term Debt Principal$230,000.00$0.00$0.00$230,000.000.00%
E 318-47000-611 Long Term Debt Interest$98,125.00$49,062.51$0.00$49,062.4950.00%
E 318-47000-620 Fiscal Agent s Fees$495.00$495.00$0.00$0.00100.00%
Total 218 Fund Expenditures$328,620.00$49,557.51$0.00$279,062.4915.08%
CITY OF SCANDIA
Revenue - Expenditure Summary
July 2022
Description2022 BudgetYTD AmountJuly AmountBudget Balance% of BudgetComments
CAPITAL IMPROVEMENTS
RevenueR 401-48000-31000 Washington Cty. Tax Settlement$217,336.00$108,668.00$108,668.00$108,668.0050.00%
R 401-48000-33422 Other State Grants & Aids$240,625.00$0.00$0.00$240,625.000.00%
R 401-48000-36100 Special Assessments$510.00$0.00$0.00$510.000.00%
R 401-48000-36210 Interest Income$4,500.00$0.00$0.00$4,500.000.00%
Total Capital Improvement Fund Revenue
$462,971.00$108,668.00$108,668.00$354,303.00$0.00
ExpendituresE 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.001.55%
E 401-45180-520 Capital Improvements to Bldgs$52,000.00$16,609.43$0.00$35,390.5731.94%
E 401-48000-438 Misc. Contractual$286,000.00$0.00$0.00$286,000.000.00%
E 401-48000-530 Capital Impr Other Than Bldgs$0.00$7,800.00$7,800.00($7,800.00)0.00%
Total Capital Improvement Fund Expenditures$657,280.00$47,880.68$7,800.00$609,399.327.28%
PARK DEVELOPMENT
RevenueR 404-48000-31000 Washington Cty. Tax Settlement$20,000.00$10,000.00$0.00$10,000.0050.00%
R 404-48000-33422 Other State Grants & Aids$104,000.00$1,125.00$1,125.00$102,875.001.08%
R 404-48000-33640 Other Grants$0.00$0.00$0.00$0.000.00%
R 404-48000-34780 Park Dedication Fees$3,000.00$0.00$0.00$3,000.000.00%
R 404-48000-36210 Interest Income$1,200.00$0.00$0.00$1,200.000.00%
R 404-48000-36230 Donations$0.00$1,400.00$0.00($1,400.00)0.00%
Total Park Development Fund Revenue$128,200.00$12,525.00$1,125.00$115,675.009.77%
ExpenditureE 404-48000-312 Planning Services$15,600.00$0.00$0.00$15,600.000.00%
E 404-48000-530 Capital Impr Other Than Bldgs$219,008.00$4,125.00$1,000.00$214,883.001.88%
E 404-48000-720 Operating Transfers$1,440.00$0.00$0.00$1,440.000.00%
Total Park Development Fund Expenditures
$236,048.00$4,125.00$1,000.00$231,923.001.75%
EQUIPMENT REPLACEMENT FUND
RevenueR 406-48500-31000 Washington Cty. Tax Settlement$87,800.00$43,900.00$0.00$43,900.0050.00%
R 406-48500-36210 Interest Income$1,015.00$0.00$0.00$1,015.000.00%
R 406-48500-36260 Sale of Equipment$0.00$0.00$0.00$0.000.00%
Total Equipment Replacement Fund Revenue$88,815.00$43,900.00$0.00$44,915.0049.43%
ExpenditureE 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.000.00%
Total Equipment Replacement Fund Expenditures$198,500.00$204,505.68$0.00($6,005.68)
LOCAL ROAD IMPROVEMENT FUND
RevenueR 408-43100-31000 Washington Cty. Tax Settlement$216,860.00$108,430.00$0.00$108,430.0050.00%
R 408-43100-33422 Other State Grants & Aids$0.00$11,290.00$0.00($11,290.00)0.00%
R 408-43100-36210 Interest Income$19,613.00$0.00$0.00$19,613.000.00%
R 408-43100-39203 Transfer from Other Funds$0.00$0.00$0.00$0.000.00%
Total LRIF Revenue$236,473.00$119,720.00$0.00$116,753.0050.63%
ExpenditureE 408-43100-303 Engineering Fees$0.00$52,620.00$9,768.50($52,620.00)0.00%
E 408-43100-530 Capital Impr Other Than Bldgs$707,200.00$321.86$0.00$706,878.140.05%
Total LRIF Expenditures$707,200.00$52,941.86$9,768.50$654,258.147.49%
CITY OF SCANDIA
Revenue - Expenditure Summary
July 2022
Description2022 BudgetYTD AmountJuly AmountBudget Balance% of BudgetComments
BIG MARINE SEWER
RevenueR 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$20.00($361.53)0.00%
R 602-43210-34401 Sewer User Fees$109,592.00$51,883.36$14,138.08$57,708.6447.34%
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.000.00%
R 602-43210-36102 Penalties and Interest$0.00$16.83$0.00($16.83)0.00%
R 602-43210-36210 Interest Income$49.00$0.00$0.00$49.000.00%
Total Big Marine Sewer Revenue$109,941.00$63,107.57$14,158.08$46,833.4357.40%
ExpenditureE 602-43210-101 Regular Wages & Salaries$21,600.00$11,580.21$1,637.52$10,019.7953.61%
E 602-43210-121 PERA Coord. Employer Contribu.$1,600.00$867.57$122.83$732.4354.22%
E 602-43210-122 FICA Employer Contribution$1,300.00$671.89$96.17$628.1151.68%
E 602-43210-126 MEDICARE Employer Contribution$300.00$169.99$22.48$130.0156.66%
E 602-43210-151 Worker s Comp Insurance Prem$900.00$1,214.73$34.36($314.73)134.97%
E 602-43210-200 Office Supplies$200.00$127.77$42.77$72.2363.89%
E 602-43210-210 Operating Supplies$2,400.00$122.94$0.00$2,277.065.12%
E 602-43210-240 Small Tools and Minor Equip$550.00$0.00$0.00$550.000.00%
E 602-43210-303 Engineering Fees$10,400.00$9,313.00$1,232.50$1,087.0089.55%
E 602-43210-304 Legal Services$0.00$6,000.00$1,200.00($6,000.00)0.00%
E 602-43210-308 Other Professional Services$2,200.00$2,397.00$0.00($197.00)108.95%
E 602-43210-309 Software Support & Maintenance$1,200.00$0.00$0.00$1,200.000.00%
E 602-43210-317 Employee Training$1,400.00$572.84$0.00$827.1640.92%
E 602-43210-321 Telephone$2,100.00$1,292.19$209.88$807.8161.53%
E 602-43210-322 Postage$550.00$200.00$0.00$350.0036.36%
E 602-43210-331 Travel Expenses$200.00$157.95$0.00$42.0578.98%
E 602-43210-334 Licenses & Permits$1,600.00$767.97$0.00$832.0348.00%
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,210.95$168.19$1,289.0548.44%
E 602-43210-385 Sewer Pumping & Maintenance$11,000.00$710.00$0.00$10,290.006.45%
E 602-43210-386 Operation & Maintenance$5,000.00$1,805.69$1,093.44$3,194.3136.11%
E 602-43210-404 Repair Machinery/Equipment$16,000.00$2,065.09$1,500.00$13,934.9112.91%
E 602-43210-413 Equipment Rental$350.00$0.00$0.00$350.000.00%
E 602-43210-420 Depreciation Expense$52,200.00$0.00$0.00$52,200.000.00%
E 602-43210-438 Misc. Contractual$9,000.00$1,123.00$0.00$7,877.0012.48%
E 602-43210-530 Capital Impr Other Than Bldgs$79,612.00$45,830.00$0.00$33,782.0057.57%
Total Big Marine Sewer Expenditures$225,062.00$89,203.54$7,360.14$135,858.4639.64%
UPTOWN SEWER
RevenueR 612-43210-34401 Sewer User Fees$19,500.00$2,160.18$126.77$17,339.8211.08%
R 612-43210-36210 Interest Income$92.00$0.00$0.00$92.000.00%
Total Uptown Sewer Revenue$19,592.00$2,160.18$126.77$17,431.8211.03%
ExpenditureE 612-43210-101 Regular Wages & Salaries$9,300.00$5,023.38$701.14$4,276.6254.01%
E 612-43210-121 PERA Coord. Employer Contribu.$700.00$376.45$52.61$323.5553.78%
E 612-43210-122 FICA Employer Contribution$600.00$292.85$41.16$307.1548.81%
E 612-43210-126 MEDICARE Employer Contribution$100.00$72.40$9.63$27.6072.40%
E 612-43210-151 Worker s Comp Insurance Prem$0.00$303.67$8.58($303.67)0.00%
E 612-43210-200 Office Supplies$100.00$0.00$0.00$100.000.00%
E 612-43210-210 Operating Supplies$200.00$0.00$0.00$200.000.00%
E 612-43210-221 Equipment Parts$200.00$0.00$0.00$200.000.00%
E 612-43210-303 Engineering Fees$300.00$0.00$0.00$300.000.00%
E 612-43210-308 Other Professional Services$400.00$422.00$260.00($22.00)105.50%
E 612-43210-309 Software Support & Maintenance$0.00$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-322 Postage$0.00$0.00$0.00$0.000.00%
E 612-43210-334 Licenses & Permits$400.00$217.00$0.00$183.0054.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$267.98$49.52$1,432.0215.76%
E 612-43210-385 Sewer Pumping & Maintenance$1,200.00$327.17$0.00$872.8327.26%
E 612-43210-386 Operation & Maintenance$600.00$0.00$0.00$600.000.00%
E 612-43210-404 Repair Machinery/Equipment$1,500.00$0.00$0.00$1,500.000.00%
E 612-43210-420 Depreciation Expense$55,100.00$0.00$0.00$55,100.000.00%
E 612-43210-438 Misc. Contractual$1,200.00$448.00$0.00$752.0037.33%
E 612-43210-530 Capital Impr Other Than Bldgs$2,600.00$0.00$0.00$2,600.000.00%
Total Uptown Sewer Expenditures$76,850.00$8,085.15$1,122.64$68,764.8510.52%