6.b Treasurer's Monthly ReportCity of Scandiaaug
Treasurer’s Report
4/30/2023
FUND ACCOUNTING
Beginning Cash Balance $ 3,761,990.304/1/2023
Beginning Checking Balance$ 125,072.73
Checking Receipts 55,137.79
Transfers toChecking 230,000.00
Total Deposits 285,137.79
Expenditures$ (240,867.37)
Payroll$ (38,597.32)
Transfer to EDA inTransit
Total Payments 279,464.69)
Ending Checking Balance 130,745.83
Beginnging Money Market Balance 1,561,604.07
Money Market Receipts 1,395.03
Tranfer to Checking 230,000.00)
0
Ending Money Market Balance 1,332,999.10
Beginning Investments Balance 2,048,403.49
Investments Receipts 7,307.58
Ending Investments Balance$ 2,055,711.07
Beginning EDA Balance$ 33,356.07
EDA Receipts
EDA Expenditures
EDA De;positin Transit
EDA Transfers from Checking
Ending EDA Balance$ 33,356.07
Outstanding Checks 83,050.68)
4/30/2023EndingCashBalance $ 3,469,761.39
CHECKING, MONEY MARKET & INVESTMENT CD's
Checking *102$ 125,072.73BegBal
Credits$ 285,137.79
Debits$ (279,464.69)
Transfer inTransit
130,745.83EndBal
Money Market *105 - Rate 1.25%$ 1,561,604.07BegBal
rate change from .25% Credits 1,395.03
Debits 230,000.00)
End Bal$ 1,332,999.10
Investments
CD *4422 - Rate 4.00% 12mo., 3/25/2024 **NEW RATE$ 317,850.51
CD *4424 - Rate 2.50% 12 mo., 7/17/2023 $ 449,661.94
CD *4425 - Rate 2.875% 12 mo., 9/28/2023 $ 744,824.34
CD *4426 - Rate 3.50%% 12mo., 1/29/2024 543,374.28
Total Investments$ 2,055,711.07
Total Bank & Investment Accounts 3,519,456.00
83,050.68) Checks in Transit *3102
Transfer toEDA in Transit
Deposit in transit money market
3,436,405.32TotalAdjustedUndesignatedFunds
Scandia EDA *6301 $ 33,356.07
Receipts
Expenditures
Checks inTransit
Deposit inTransit
Total Designated EDA Funds$ 33,356.07
Total Funds$ 3,469,761.39
Submitted by: Colleen Firkus, Treasurer
2023CASH BALANCES
ENDOFMONTH
FUNDJANUARYFEBRUARYMARCHAPRIL
101 GENERAL$1,365,932$1,204,052$1,078,538$925,847
203 COVID-19 RELIEF$456,363$456,363$456,363456,362.62
226 CABLE TV$11,271$12,786$9,481$11,524
230 GATEWAY TRAIL$0$0$0$0
307 BLACKTOP PROJECT 2007$6,731$0$0$0
313 EQUIPMENT CERTIFICATES$28,825$28,873$28,873$28,873
315 EQUIPMENT CERTIFICATES$15,951$0$0$0
317 EQUIPMENT CERTIFICATES$2,187$0$0$0
318 BLACKTOP PROJECT$20,270$45,284$45,284($823)
401 CAPITAL IMPR$749,162$749,497$745,297$668,380
404 PARK CAP IMPR$148,177$148,797$148,797$144,297
406 EQUIPMENT REPLACEMENT$199,727$200,548$200,548$200,548
408 LOCAL ROAD IMPROVEMENT$916,080$910,085$901,556$895,518
602 BIG MARINE SEWER$80,462$74,771$75,858$58,322
612 UPTOWN SEWER$10,330$15,160$13,957$12,136
801 ESCROW$21,817$32,240$24,131$35,421
SUBTOTAL$4,033,286$3,878,456$3,728,684$3,436,405
225 EDA$33,356$33,356$33,356$33,356
TOTAL$4,066,642$3,911,812$3,762,040$3,469,761
CITY OF SCANDIA
Revenue - Expenditure Summary
Apr-23
2023 YTD April Budget
Description2023 BudgetAmountAmountBalance% of BudgetComments
GENERAL FUND
RevenueR 101-41000-31000 Washington Cty. Tax Settlement$1,865,918$0.00$0.00$1,865,918.000.00%
R 101-41000-31040 Fiscal Disparities$0$0.00$0.00$0.000.00%
R 101-41000-31701 Gravel Taxes$20,000$0.00$0.00$20,000.000.00%
R 101-41000-31830 Solar Energy Production Tax$6,000$0.00$0.00$6,000.000.00%
R 101-41000-31900 Penalties & Interest Del Tax$400$0.00$0.00$400.000.00%
R 101-41000-32150 ROW Utility Permit$3,000$1,200.00$150.00$1,800.0040.00%
R 101-41000-32180 Tobacco & Liquor Licenses$10,000$50.00$0.00$9,950.000.50%
R101-41000-32190 Other City Permits$3,000$595.00$170.00$2,405.0019.83%
R101-41000-32210 Building Permits$145,000$40,447.84$5,385.04$104,552.1627.90%
R 101-41000-32260 Gambling Permits$100$15.00$15.00$85.0015.00%
R 101-41000-33401 LGA/MVHC/AG/PERA Aid$7,000$0.00$0.00$7,000.000.00%
R 101-41000-33420 Fire Relief State PERA$37,000$0.00$0.00$37,000.000.00%
Fire Training grantsR101-41000-33422 Other State Grants & Aids$11,000$6,897.00$0.00$4,103.0062.70%
R 101-41000-33428 PILOT$6,000$0.00$0.00$6,000.000.00%
R 101-41000-33620 Recycling Grant$10,500$8,165.00$8,165.00$2,335.0077.76%
R 101-41000-33630 Local Govt Grants & Aids$0$0.00$0.00$0.000.00%
R 101-41000-33640 Other Grants$1,200$0.00$0.00$1,200.000.00%
R 101-41000-34103 Zoning and Planning$6,700$2,100.00$900.00$4,600.0031.34%
R 101-41000-34106 Engineering Fees$500$0.00$0.00$500.000.00%
R 101-41000-34107 Assessment Search Fees$0$5.00$0.00($5.00)0.00%
R 101-41000-34109 Water Usage$100$0.00$0.00$100.000.00%
R 101-41000-34201 Impound Fees$0$0.00$0.00$0.000.00%
R 101-41000-34202 Fire Protection Services$34,300$0.00$0.00$34,300.000.00%
R 101-41000-34301 Damage Repairs$0$0.00$0.00$0.000.00%
R 101-41000-34303 Dust Control$2,700$0.00$0.00$2,700.000.00%
R 101-41000-34304 Reimbursement for Services$3,000$900.00$600.00$2,100.0030.00%
R 101-41000-34305 Other Street Services$0$0.00$0.00$0.000.00%
R 101-41000-34730 Ad Revenue$0$0.00$0.00$0.000.00%
R 101-41000-34750 Facilities Rental$5,500$2,037.67$1,071.00$3,462.3337.05%
R 101-41000-34760 Cleaning Fees$100$0.00$0.00$100.000.00%
R 101-41000-34790 Recreation Programs$2,100$985.00$225.00$1,115.0046.90%
R 101-41000-35101 Fines & Forfeitures$7,400$2,283.45$1,081.55$5,116.5530.86%
distributed among funds at EOYR101-41000-36210 Interest Income$12,100$19,416.57$8,703.92($7,316.57)160.47%
Veterans Memorial Upkeep $1,090; Lions: Vinterfest
R 101-41000-36230 Donations$2,000$4,191.30$250.00($2,191.30)209.57% Fireworks $2,000; Sister City $250
R 101-41000-36240 Insurance Dividend$4,100$0.00$0.00$4,100.000.00%
R 101-41000-36250 Misc. Refund$3,800$0.00$0.00$3,800.000.00%
R 101-41000-39200 Interfund Operating Transfer$0$0.00$0.00$0.000.00%
R 101-41000-39204 Money Market Transfer$0$0.00$0.00$0.000.00%
R101-41910-32210 Building Permits$0$0.00$0.00$0.000.00%
R 101-45000-34730 Ad Revenue$0$0.00$0.00$0.000.00%
R 101-49000-37000 Cash Over$0$0.00$0.00$0.000.00%
Total General Fund Revenue$2,210,518$89,288.83$26,716.51$2,121,229.174.04%
Operating TransfersR 101-49000-39203 Transfer from Other Funds$0$445,000.00$230,000.00($445,000.00)0.00%
R 101-49000-39204 Money Market Transfer$0$355,000.01$0.00($355,000.01)0.00%
Total Operating Transfers$800,000.01$230,000.00($800,000.01)
GENERAL FUNDADMINISTRATION & FINANCE
ExpenditureE 101-41000-101 Regular Wages & Salaries$192,700$19,836.57$8,305.56$172,863.4310.29%
audit journal entriesE101-41000-121 PERA Coord. Employer Contribu.$13,400($1,115.04)$622.93$14,515.04-8.32%
E 101-41000-122 FICA Employer Contribution$11,900$520.35$483.88$11,379.654.37%
E 101-41000-126 MEDICARE Employer Contribution$2,700$983.21$113.16$1,716.7936.42%
E 101-41000-131 Employer Paid Health$47,300$11,399.36$2,798.32$35,900.6424.10%
E 101-41000-132 Dental Insurance$3,400$347.15$127.90$3,052.8510.21%
E 101-41000-134 Employer Paid Life$600$163.50$36.80$436.5027.25%
E 101-41000-135 Employer Paid Disability$900$330.40$59.75$569.6036.71%
E 101-41000-151 Worker sComp Insurance Prem$1,300$1,651.00$1,651.00($351.00)127.00%
E 101-41000-200 Office Supplies$1,100$19.68$0.00$1,080.321.79%
E 101-41000-203 Printed Forms & Papers$1,900$959.05$773.37$940.9550.48%
Award frames; March 10 meeting suppliesE101-41000-210 Operating Supplies$800$428.51$78.58$371.4953.56%
E 101-41000-300 Assessor$0$0.00$0.00$0.000.00%
E 101-41000-301 Auditing and Acct gServices$23,500$0.00$0.00$23,500.000.00%
E 101-41000-303 Engineering Fees$0$0.00$0.00$0.000.00%
E101-41000-304 Legal Services$55,000$15,327.50$6,587.00$39,672.5027.87%
E 101-41000-306 Personal Testing & Recruit$0$0.00$0.00$0.000.00%
Intermin City Admin SalaryE101-41000-308 Other Professional Services$1,000$42,476.69$16,271.69($41,476.69)4247.67%
E 101-41000-309 Software Support & Maintenance$18,200$2,794.47$969.85$15,405.5315.35%
E 101-41000-314 Animal Control$0$0.00$0.00$0.000.00%
E 101-41000-316 Conferences & Seminars$700$0.00$0.00$700.000.00%
E 101-41000-317 Employee Training$200$0.00$0.00$200.000.00%
E 101-41000-319 Other Services$46,700$551.00$0.00$46,149.001.18%
E 101-41000-321 Telephone$3,700$1,645.79$421.59$2,054.2144.48%
E 101-41000-322 Postage$2,200$705.02$298.21$1,494.9832.05%
E 101-41000-331 Travel Expenses$600$1,033.37$33.37($433.37)172.23%reimburse city admin applicant
E101-41000-351 Legal Notices Publishing$1,200$961.18$121.52$238.8280.10%
E 101-41000-361 Liability/Property Ins$7,100$10,967.38$0.00($3,867.38)154.47%
E 101-41000-365 Insurance Claims$0$1,000.00$0.00($1,000.00)0.00%
budget for all depts in Fund 101E101-41000-381 Utilities-Electric & Gas$13,000$2,121.56$1,806.81$10,878.4416.32%
E 101-41000-413 Equipment Rental$1,900$572.56$89.32$1,327.4430.13%
E 101-41000-430 Recycling$30,100$0.00$0.00$30,100.000.00%
E 101-41000-433 Dues and Subscriptions$6,100$112.00$37.00$5,988.001.84%
E 101-41000-434 Youth Service Bureau$5,500$5,500.00$5,500.00$0.00100.00%
E 101-41000-435 Misc Expense$500$0.00$0.00$500.000.00%
Website Host; ABDO accounting assistanceE101-41000-438 Misc. Contractual$4,000$3,235.75$739.50$764.2580.89%
E 101-41000-439 Refunds Issued$0$0.00$0.00$0.000.00%
E 101-41000-560 Furniture and Fixtures$0$0.00$0.00$0.000.00%
E 101-41000-570 Office Equipment$5,500$0.00$0.00$5,500.000.00%
E 101-41000-710 Residual Equity Transfers$0$0.00$0.00$0.000.00%
E 101-41000-720 Operating Transfers$0$0.00$0.00$0.000.00%
Total Admin & Finance Dept. Expenditures$504,700$124,528.01$47,927.11$380,171.9924.67%
GENERAL FUND CONT.CITY COUNCIL
ExpendituresE 101-41110-101 Regular Wages & Salaries$18,100$5,192.98$5,192.98$12,907.0228.69%
E 101-41110-122 FICA Employer Contribution$1,100$114.67$61.52$985.3310.42%
E 101-41110-126 MEDICARE Employer Contribution$300$23.23$75.31$276.777.74%
E 101-41110-127 PERA Defined$600$167.15$210.02$432.8527.86%
E 101-41110-151 Worker sComp Insurance Prem$100$95.00$95.00$5.0095.00%
E 101-41110-308 Other Professional Services$0$0.00$0.00$0.000.00%
E 101-41110-316 Conferences & Seminars$700$350.00$0.00$350.0050.00%
E 101-41110-331 Travel Expenses$0$561.97$0.00($561.97)0.00%
E 101-41110-439 Refunds Issued$0$0.00$0.00$0.000.00%
E 101-41110-560 Furniture and Fixtures$0$0.00$0.00$0.000.00%
E 101-41110-570 Office Equipment$0$0.00$0.00$0.000.00%
Total City Council Dept. Expenditures$20,900$6,505.00$5,634.83$14,395.0031.12%
ELECTIONS
ExpendituresE 101-41410-199 Election Judge$0$0.00$0.00$0.000.00%
E 101-41410-200 Office Supplies$0$0.00$0.00$0.000.00%
E 101-41410-203 Printed Forms & Papers$0$0.00$0.00$0.000.00%
E 101-41410-210 Operating Supplies$200$0.00$0.00$200.000.00%
E101-41410-351 Legal Notices Publishing$0$0.00$0.00$0.000.00%
E 101-41410-413 Equipment Rental$850$1,515.00$0.00($665.00)178.24%
Total Elections Dept. Expenditures$1,050$1,515.00$0.00($465.00)144.29%
PLANNING & BUILDING
ExpendituresE 101-41910-101 Regular Wages & Salaries$59,600$19,596.21$2,931.33$40,003.7932.88%
E 101-41910-121 PERA Coord. Employer Contribu.$4,200$835.55$219.85$3,364.4519.89%
E 101-41910-122 FICA Employer Contribution$3,700$1,158.41$168.43$2,541.5931.31%
E 101-41910-126 MEDICARE Employer Contribution$900$293.33$39.40$606.6732.59%
E 101-41910-131 Employer Paid Health$20,000$5,060.95$1,267.18$14,939.0525.30%
E 101-41910-132 Dental Insurance$1,500$200.97$54.81$1,299.0313.40%
E 101-41910-134 Employer Paid Life$200$44.80$11.20$155.2022.40%
E 101-41910-135 Employer Paid Disability$500$126.60$31.65$373.4025.32%
E 101-41910-203 Printed Forms & Papers$600$0.00$0.00$600.000.00%
E 101-41910-311 Contract Permit Inspections$50,000$17,717.06$2,961.42$32,282.9435.43%
E 101-41910-312 Planning Services$50,000$17,546.41$6,618.00$32,453.5935.09%
E 101-41910-313 Committee & Commission Reimbur$5,000$550.00$0.00$4,450.0011.00%
E 101-41910-316 Conferences & Seminars$50$0.00$0.00$50.000.00%
E 101-41910-319 Other Services$0$0.00$0.00$0.000.00%
E 101-41910-361 Liability/Property Ins$4,900$5,400.60$0.00($500.60)110.22%
E 101-41910-438 Misc. Contractual$5,000$1,188.43$1,188.43$3,811.5723.77%
E 101-41910-439 Refunds Issued$200$0.00$0.00$200.000.00%
E 101-41910-720 Operating Transfers$0$0.00$0.00$0.000.00%
Total Planning & Building Dept. Expenditures$206,350$69,719.32$15,491.70$136,630.6833.79%
ASSESSOR
ExpendituresE 101-41960-300 Assessor$21,600$7,200.00$1,800.00$14,400.0033.33%
POLICE
ExpendituresE 101-42100-318 Police Contract$168,499$0.00$0.00$168,499.000.00%
E 101-42100-319 Other Services$500$309.36$0.00$190.6461.87%2023 Code Red System
Total GF Police Dept. Expenditures$168,999$309.36$0.00$168,689.6433.33%
FIREGENERALFUNDCONT.
ExpendituresE 101-42200-101 Regular Wages & Salaries$147,200$36,158.02$12,734.96$111,041.9824.56%
E 101-42200-121 PERA Coord. Employer Contribu.$0$0.00$0.00$0.000.00%
E 101-42200-122 FICA Employer Contribution$9,100$2,125.49$764.96$6,974.5123.36%
E 101-42200-124 Police & Fire PERA$3,600$2,856.87$676.57$743.1379.36%
E 101-42200-126 MEDICARE Employer Contribution$2,100$285.89$187.56$1,814.1113.61%
E 101-42200-134 Employer Paid Life$200$64.00$16.00$136.0032.00%
E 101-42200-135 Employer Paid Disability$700$0.00$0.00$700.000.00%
E 101-42200-141 Unemployment Compensation$0$0.00$0.00$0.000.00%
E 101-42200-151 Worker sComp Insurance Prem$9,100$11,617.00$11,617.00($2,517.00)127.66%
E 101-42200-200 Office Supplies$400$0.00$0.00$400.000.00%
E 101-42200-203 Printed Forms & Papers$150$0.00$0.00$150.000.00%
E 101-42200-209 Medical Supplies$3,000$195.50$0.00$2,804.506.52%
Pagers $2,730; Fire Suppression supplies $686; Cintas;
E 101-42200-210 Operating Supplies$8,000$3,789.23$49.54$4,210.7747.37% Dinners
E 101-42200-211 Cleaning Supplies$100$0.00$0.00$100.000.00%
E 101-42200-212 Fuel$3,500$877.27$193.42$2,622.7325.06%
E 101-42200-217 Uniforms & Safety Equipment$10,000$1,073.13$0.00$8,926.8710.73%
E 101-42200-221 Equipment Parts$3,000$55.73$0.00$2,944.271.86%
E 101-42200-222 Tires$0$0.00$0.00$0.000.00%
E 101-42200-223 Structure Repair & Supplies$2,000$185.61$0.00$1,814.399.28%
E 101-42200-240 Small Tools and Minor Equip$9,000$38.00$0.00$8,962.000.42%
SCBA User Exams + Annual Fit TestE101-42200-305 Medical Services$3,500$4,610.00$0.00($1,110.00)131.71%
E 101-42200-306 Personal Testing & Recruit$1,300$0.00$0.00$1,300.000.00%
E 101-42200-309 Software Support & Maintenance$17,000$1,674.00$558.00$15,326.009.85%
E 101-42200-310 Medical Training$2,000$0.00$0.00$2,000.000.00%
E 101-42200-316 Conferences & Seminars$250$0.00$0.00$250.000.00%
E 101-42200-317 Employee Training$15,000$2,185.00$745.00$12,815.0014.57%
E 101-42200-319 Other Services$500$0.00$0.00$500.000.00%
E 101-42200-321 Telephone$6,800$1,815.63$529.51$4,984.3726.70%
E 101-42200-322 Postage$0$0.00$0.00$0.000.00%
E 101-42200-324 State of MN-Fire Relief$35,300$0.00$0.00$35,300.000.00%
E 101-42200-325 City Match-Fire Relief$0$0.00$0.00$0.000.00%
E 101-42200-331 Travel Expenses$1,500$500.38$0.00$999.6233.36%
E 101-42200-334 Licenses & Permits$200$300.00$300.00($100.00)150.00% MN Board of Firefighter Training & Education License
E 101-42200-340 Advertising$0$0.00$0.00$0.000.00%
E 101-42200-361 Liability/Property Ins$6,500$6,989.37$0.00($489.37)107.53%
E 101-42200-381 Utilities-Electric & Gas$8,000$4,569.17$1,110.22$3,430.8357.11%
E 101-42200-384 Refuse/Garbage Disposal$1,100$276.06$92.02$823.9425.10%
E 101-42200-385 Sewer Pumping & Maintenance$700$0.00$0.00$700.000.00%
E 101-42200-401 Building Maintenance/Repairs$2,500$1,106.06$728.03$1,393.9444.24%Cleaning, Pest Control, Glass door repair
E 101-42200-403 Improvements Other Than Bldgs$0$0.00$0.00$0.000.00%
E 101-42200-404 Repair Machinery/Equipment$8,000$1,652.31$563.38$6,347.6920.65%
E 101-42200-407 Well Repair & Maintenance$0$0.00$0.00$0.000.00%
E 101-42200-433 Dues and Subscriptions$2,400$1,184.00$0.00$1,216.0049.33%
E 101-42200-438 Misc. Contractual$4,100$0.00$0.00$4,100.000.00%
E101-42200-440 Events$800$0.00$0.00$800.000.00%
E 101-42200-520 Capital Improvements to Bldgs$0$0.00$0.00$0.000.00%
E 101-42200-530 Capital Impr Other Than Bldgs$0$0.00$0.00$0.000.00%
E 101-42200-540 Heavy Machinery Capital$0$0.00$0.00$0.000.00%
E 101-42200-560 Furniture and Fixtures$500$0.00$0.00$500.000.00%
E 101-42200-570 Office Equipment$900$0.00$0.00$900.000.00%
E 101-42200-720 Operating Transfers$0$0.00$0.00$0.000.00%
Total Fire Dept Expenditures$330,000$86,183.72$30,866.17$243,816.2826.12%
ANIMAL CONTROL
ExpendituresE 101-42700-314 Animal Control$5,000$1,062.63$556.38$3,937.3721.25%
PUBLIC WORKSGENERALFUNDCONT.
ExpendituresE 101-43000-101 Regular Wages & Salaries$229,700$68,720.29$17,387.32$160,979.7129.92%
E 101-43000-102 OT Regular Wages$5,000$4,610.96$1,003.20$389.0492.22%
snow plowingE101-43000-104 Temporary Employee Wages$2,300$4,162.73$182.50($1,862.73)180.99%
E 101-43000-121 PERA Coord. Employer Contribu.$17,600$5,485.26$1,379.26$12,114.7431.17%
E 101-43000-122 FICA Employer Contribution$14,600$4,314.90$1,090.68$10,285.1029.55%
E 101-43000-126 MEDICARE Employer Contribution$3,400$1,206.97$255.09$2,193.0335.50%
E 101-43000-131 Employer Paid Health$70,900$24,657.78$4,860.27$46,242.2234.78%
E 101-43000-132 Dental Insurance$2,300$440.76$88.15$1,859.2419.16%
E 101-43000-134 Employer Paid Life$700$239.76$58.16$460.2434.25%
E 101-43000-135 Employer Paid Disability$1,700$741.10$144.80$958.9043.59%
E 101-43000-141 Unemployment Compensation$0$0.00$0.00$0.000.00%
E 101-43000-151 Worker sComp Insurance Prem$19,800$25,673.00$25,673.00($5,873.00)129.66%
E 101-43000-200 Office Supplies$600$53.99$53.99$546.019.00%
E 101-43000-210 Operating Supplies$8,400$707.30$393.27$7,692.708.42%
E 101-43000-212 Fuel$20,000$10,526.00$3,425.44$9,474.0052.63%
E 101-43000-217 Uniforms & Safety Equipment$2,200$201.44$0.00$1,998.569.16%
plow repair partsE101-43000-221 Equipment Parts$14,000$10,336.33$275.43$3,663.6773.83%
E 101-43000-222 Tires$7,500$0.00$0.00$7,500.000.00%
E 101-43000-223 Structure Repair & Supplies$2,200$0.00$0.00$2,200.000.00%
E 101-43000-224 Materials for Road Maintenance$16,500$1,184.82$69.99$15,315.187.18%
E 101-43000-226 Sign Replacement and Repair$0$0.00$0.00$0.000.00%
E101-43000-228 Gravel$10,000$0.00$0.00$10,000.000.00%
snow, snow & snowE101-43000-229 Salt$20,000$18,093.42$0.00$1,906.5890.47%
E 101-43000-240 Small Tools and Minor Equip$8,000$3,770.62$147.00$4,229.3847.13%
E 101-43000-302 Surveying$0$0.00$0.00$0.000.00%
E 101-43000-303 Engineering Fees$10,000$2,921.50$2,789.50$7,078.5029.22%
E101-43000-304 Legal Services$0$0.00$0.00$0.000.00%
E 101-43000-305 Medical Services$1,200$99.90$0.00$1,100.108.33%
IWORQ subscriptionE101-43000-309 Software Support & Maintenance$2,000$5,000.00$0.00($3,000.00)250.00%
E 101-43000-317 Employee Training$1,700$1,010.00$0.00$690.0059.41%
E 101-43000-319 Other Services$13,600$63.50$5.40$13,536.500.47%
E 101-43000-321 Telephone$3,000$1,408.45$478.81$1,591.5546.95%
E 101-43000-331 Travel Expenses$500$0.00$0.00$500.000.00%
E 101-43000-334 Licenses & Permits$500$0.00$0.00$500.000.00%
E 101-43000-361 Liability/Property Ins$9,000$8,348.14$0.00$651.8692.76%
E 101-43000-365 Insurance Claims$0$0.00$0.00$0.000.00%
E 101-43000-381 Utilities-Electric & Gas$4,000$3,160.19$771.51$839.8179.00%
E 101-43000-384 Refuse/Garbage Disposal$1,000$184.08$61.36$815.9218.41%
E 101-43000-385 Sewer Pumping & Maintenance$1,600$0.00$0.00$1,600.000.00%
E 101-43000-387 Street Light Utilities$4,200$1,652.08$465.72$2,547.9239.34%
E 101-43000-401 Building Maintenance/Repairs$8,000$1,014.97$563.60$6,985.0312.69%
E 101-43000-403 Improvements Other Than Bldgs$0$0.00$0.00$0.000.00%
plow truck repairsE101-43000-404 Repair Machinery/Equipment$15,500$10,662.61$1,409.87$4,837.3968.79%
E 101-43000-405 Contractual Road Maint/Repair$157,500$3,422.53$3,422.53$154,077.472.17%
E 101-43000-407 Well Repair & Maintenance$0$0.00$0.00$0.000.00%
E 101-43000-413 Equipment Rental$4,000$0.00$0.00$4,000.000.00%
E 101-43000-417 Uniform Rental$1,100$249.47$76.76$850.5322.68%
E 101-43000-433 Dues and Subscriptions$200$0.00$0.00$200.000.00%
E 101-43000-438 Misc. Contractual$15,750$0.00$0.00$15,750.000.00%
E 101-43000-439 Refunds Issued$0$0.00$0.00$0.000.00%
E 101-43000-530 Capital Impr Other Than Bldgs$0$0.00$0.00$0.000.00%
E 101-43000-550 Motor Vehicles Capital$0$0.00$0.00$0.000.00%
E 101-43000-560 Furniture and Fixtures$0$0.00$0.00$0.000.00%
E 101-43000-570 Office Equipment$1,000$406.53$406.53$593.4740.65%
E 101-43000-720 Operating Transfers$0$0.00$0.00$0.000.00%
Total Public Works Dept. Expenditures$732,750$224,731.38$66,939.14$508,018.6230.67%
GENERAL FUND CONT.PARKS & RECREATION
ExpendituresE 101-45000-101 Regular Wages & Salaries$10,200$1,837.92$757.48$8,362.0818.02%
E 101-45000-104 Temporary Employee Wages$40,200$4,776.38$0.00$35,423.6211.88%
E 101-45000-121 PERA Coord. Employer Contribu.$800$135.45$56.80$664.5516.93%
E 101-45000-122 FICA Employer Contribution$3,300$379.75$44.44$2,920.2511.51%
E 101-45000-126 MEDICARE Employer Contribution$800$116.23$10.38$683.7714.53%
E 101-45000-131 Employer Paid Health$2,700$784.17$185.45$1,915.8329.04%
E 101-45000-132 Dental Insurance$100$16.00$3.20$84.0016.00%
E 101-45000-134 Employer Paid Life$0$9.24$2.24($9.24)0.00%
E 101-45000-135 Employer Paid Disability$1,000$22.68$5.67$977.322.27%
E 101-45000-141 Unemployment Compensation$0$0.00$0.00$0.000.00%
E 101-45000-151 Worker sComp Insurance Prem$1,900$2,311.00$2,311.00($411.00)121.63%
E 101-45000-200 Office Supplies$310$0.00$0.00$310.000.00%
E 101-45000-203 Printed Forms & Papers$930$0.00$0.00$930.000.00%
E 101-45000-210 Operating Supplies$930$31.96$0.00$898.043.44%
E 101-45000-212 Fuel$1,650$229.92$0.00$1,420.0813.93%
E 101-45000-221 Equipment Parts$2,100$290.38$0.00$1,809.6213.83%
E 101-45000-223 Structure Repair & Supplies$2,100$0.00$0.00$2,100.000.00%
E 101-45000-240 Small Tools and Minor Equip$400$0.00$0.00$400.000.00%
E 101-45000-312 Planning Services$0$0.00$0.00$0.000.00%
E 101-45000-313 Committee & Commission Reimbur$1,200$240.00$0.00$960.0020.00%
E 101-45000-319 Other Services$0$284.00$284.00($284.00)0.00%
E 101-45000-322 Postage$0$0.00$0.00$0.000.00%
SCVRTA 2023 AdE101-45000-340 Advertising$200$250.00$0.00($50.00)125.00%
E 101-45000-353 Sales& Use Tax$0$0.00$0.00$0.000.00%
E 101-45000-361 Liability/Property Ins$3,300$3,323.03$0.00($23.03)100.70%
E 101-45000-381 Utilities-Electric & Gas$4,500$1,850.62$461.47$2,649.3841.12%
E 101-45000-384 Refuse/Garbage Disposal$2,500$420.00$115.00$2,080.0016.80%
E 101-45000-385 Sewer Pumping & Maintenance$700$564.73$195.73$135.2780.68%
ice melt productE101-45000-401 Building Maintenance/Repairs$4,800$3,192.91$0.00$1,607.0966.52%
E 101-45000-403 Improvements Other Than Bldgs$0$170.49$0.00($170.49)0.00%
E 101-45000-404 Repair Machinery/Equipment$750$0.00$0.00$750.000.00%
E 101-45000-406 Grounds Care$4,000$0.00$0.00$4,000.000.00%
E 101-45000-438 Misc. Contractual$3,300$0.00$0.00$3,300.000.00%
E 101-45000-439 Refunds Issued$0$565.01$0.00($565.01)0.00%
VinterfestE101-45000-440 Events$7,000$2,361.00$0.00$4,639.0033.73%
E 101-45000-490 Financial Assistance$0$0.00$0.00$0.000.00%
E 101-45000-530 Capital Impr Other Than Bldgs$10,000$0.00$0.00$10,000.000.00%
E 101-45000-720 Operating Transfers$0$0.00$0.00$0.000.00%
Total Parks & Rec Dept. Expenditures$111,670$24,162.87$4,432.86$87,507.1321.64%
GENERAL FUND CONT.COMMUNITY CENTER
ExpendituresE 101-45180-101 Regular Wages & Salaries$15,000$4,413.09$1,103.26$10,586.9129.42%
E 101-45180-104 Temporary Employee Wages$0$0.00$0.00$0.000.00%
E 101-45180-121 PERA Coord. Employer Contribu.$1,100$330.11$82.73$769.8930.01%
E 101-45180-122 FICA Employer Contribution$900$251.96$64.66$648.0428.00%
E 101-45180-126 MEDICARE Employer Contribution$200$68.36$15.14$131.6434.18%
E 101-45180-131 Employer Paid Health$3,700$1,008.90$255.60$2,691.1027.27%
E 101-45180-134 Employer Paid Life$0$15.00$3.60($15.00)0.00%
E 101-45180-135 Employer Paid Disability$200$45.72$11.43$154.2822.86%
E 101-45180-151 Worker sComp Insurance Prem$0$0.00$0.00$0.000.00%
E 101-45180-210 Operating Supplies$2,900$665.53$154.42$2,234.4722.95%
E 101-45180-223 Structure Repair & Supplies$6,500$0.00$0.00$6,500.000.00%
E 101-45180-334 Licenses & Permits$1,000$752.00$0.00$248.0075.20%
E 101-45180-361 Liability/Property Ins$800$795.60$0.00$4.4099.45%
E 101-45180-381 Utilities-Electric & Gas$11,200$4,433.06$1,122.24$6,766.9439.58%
E 101-45180-384 Refuse/Garbage Disposal$1,900$631.39$235.61$1,268.6133.23%
E 101-45180-385 Sewer Pumping & Maintenance$3,700$1,827.71$1,827.71$1,872.2949.40%
Remove ice from Comm Ctr roofE101-45180-401 Building Maintenance/Repairs$15,000$7,206.17$991.80$7,793.8348.04%
E 101-45180-404 Repair Machinery/Equipment$5,000$50.00$0.00$4,950.001.00%
E 101-45180-406 Grounds Care$690$0.00$0.00$690.000.00%
E 101-45180-407 Well Repair & Maintenance$1,000$0.00$0.00$1,000.000.00%
E 101-45180-438 Misc. Contractual$2,700$0.00$0.00$2,700.000.00%
E 101-45180-439 Refunds Issued$0$450.00$0.00($450.00)0.00%
Council Chambers remodelE101-45180-520 Capital Improvements to Bldgs$6,000$7,475.61$0.00($1,475.61)124.59%
E 101-45180-530 Capital Impr Other Than Bldgs$0$0.00$0.00$0.000.00%
E 101-45180-570 Office Equipment$0$0.00$0.00$0.000.00%
E 101-45180-720 Operating Transfers$0$0.00$0.00$0.000.00%
Total Community Center Dept. Expenditures$79,490$30,420.21$5,868.20$49,069.7938.27%
Operating TransfersE 101-49000-720 Operating Transfers$800,000.00$230,000.00($800,000.00)
TOTAL GENERAL FUND EXPENDITURES$2,182,509$576,337.50$179,516.39$1,606,171.5026.41%
COVID RELIEF FUND
RevenueR 203-46200-33150 Federal Grant$0$0.00$0.00$0.000.00%
ExpendituresE 203-49000-720 Operating Transfers$0.00$0.00$0.00$0.00
EDA FUND
RevenueR 225-46500-31000 Washington Cty. Tax Settlement$5,300$0.00$0.00$5,300.000.00%
R 225-46500-33640 Other Grants$0$0.00$0.00$0.000.00%
R 225-46500-34750 Facilities Rental$0$0.00$0.00$0.000.00%
R 225-46500-36210 Interest Income$200$0.00$0.00$200.000.00%
R 225-46500-36230 Donations$0$0.00$0.00$0.000.00%
R 225-46500-39203 Transfer from Other Funds$0$3,524.94$0.00($3,524.94)0.00% transfer of property tax settlement from checking
Total EDA Fund Revenue$5,500.00$3,524.94$0.00$1,975.0664.09%
ExpenditureE 225-46500-210 Operating Supplies$500$0.00$0.00$0.00704.99%
E 225-46500-303 Engineering Fees$0$0.00$0.00$0.000.00%
E225-46500-304 Legal Services$0$0.00$0.00$0.000.00%
E 225-46500-308 Other Professional Services$300$0.00$0.00$300.000.00%
E 225-46500-340 Advertising$2,000$0.00$0.00$2,000.000.00%
EDAM Membership; Sister City DuesE225-46500-433 Dues and Subscriptions$1,700$805.00$0.00$895.0047.35%
E225-46500-440 Events$800$0.00$0.00$800.000.00%
E 225-46500-720 Operating Transfers$0$3,524.94$0.00$0.000.00% transfer of property tax settlement from checking
Total EDA Fund Expenditures$5,300.00$4,329.94$0.00$3,995.0081.70%
CABLE TV FUND
RevenueR 226-41950-36210 Interest Income$100$0.00$0.00$100.000.00%
R 226-41950-36260 Sale of Equipment$0$300.00$300.00($300.00)0.00%
R 226-41950-38050 Cable TV Franchise Rebates$16,200$4,922.10$1,701.30$11,277.9030.38%
R 226-41950-38051 PEG Fees$4,200$1,330.56$446.51$2,869.4431.68%
Total Cable TV Fund Revenue$20,500.00$6,552.66$2,447.81$13,947.3431.96%
Council Chambers AV equipmentExpenditureE226-41950-240 Small Tools and Minor Equip$300$593.48$249.00($293.48)197.83%
E 226-41950-309 Software Support & Maintenance$3,500$304.72$155.56$3,195.288.71%
E 226-41950-438 Misc. Contractual$5,300$1,380.00$0.00$3,920.0026.04%
E 226-41950-570 Office Equipment$0$4,128.98$0.00($4,128.98)0.00%
Total Cable TV Fund Expenditures$9,100.00$6,407.18$404.56$2,692.8270.41%
GATEWAY TRAIL FUND
RevenueR 230-45000-36230 Donations$0$0.00$0.00$0.000.00%
ExpenditureE 230-45000-308 Other Professional Services$0$0.00$0.00$0.000.00%
2013 EQUIPMENT CERTIFICATES
RevenueR 313-47000-31000 Washington Cty. Tax Settlement$64,000$0.00$0.00$64,000.000.00%
ExpenditureE 313-47000-601 Long Term Debt Principal$60,000$0.00$0.00$60,000.000.00%
E 313-47000-611 Long Term Debt Interest$3,047$0.00$0.00$3,047.000.00%
E313-47000-620 Fiscal Agent sFees$500$0.00$0.00$500.000.00%
Total 2013 Fund Expenditures$63,547.00$0.00$0.00$63,547.000.00%
2018 STREET RECONSTRUCTION
RevenueR 318-47000-31000 Washington Cty. Tax Settlement$342,546$0.00$0.00$342,546.000.00%
ExpenditureE 318-47000-601 Long Term Debt Principal$250,000$0.00$0.00$250,000.000.00%
E 318-47000-611 Long Term Debt Interest$91,225$45,612.51$45,612.51$45,612.4950.00%
E318-47000-620 Fiscal Agent sFees$500$495.00$495.00$5.0099.00%
Total 2018 Street Reconstruction Fund Expenditures$341,725.00$46,107.51$46,107.51$295,617.4913.49%
CAPITAL IMPROVEMENTS
RevenueR 401-48000-31000 Washington Cty. Tax Settlement$293,791$0.00$0.00$293,791.000.00%
R 401-48000-33422 Other State Grants & Aids$0$0.00$0.00$0.000.00%
R 401-48000-36210 Interest Income$2,300$0.00$0.00$2,300.000.00%
Total Capital Improvement Fund Revenue$0.00$0.00$296,091.00$0.000.00%
ExpenditureE 401-41000-312 Planning Services$0$0.00$0.00$0.000.00%
E 401-41000-520 Capital Improvements to Bldgs$0$0.00$0.00$0.000.00%
E 401-41000-530 Capital Impr Other Than Bldgs$169,500$0.00$0.00$169,500.000.00%
E 401-42200-520 Capital Improvements to Bldgs$65,000$73,775.00$73,775.00($8,775.00)113.50%Generator
E 401-48000-435 Misc Expense$0$12,142.50$3,142.50($12,142.50)0.00%Gateway Trail: Lobbying & Engineering
E 401-48000-438 Misc. Contractual$0$0.00$0.00$0.000.00%
E 401-48000-520 Capital Improvements to Bldgs$0$0.00$0.00$0.000.00%
E 401-48000-530 Capital Impr Other Than Bldgs$100,000$0.00$0.00$100,000.000.00%
Total Capital Improvement Fund Expenditures$334,500.00$85,917.50$76,917.50$248,582.5025.69%
PARK DEVELOPMENT
RevenueR 404-48000-31000 Washington Cty. Tax Settlement$20,000$0.00$0.00$20,000.000.00%
R 404-48000-33422 Other State Grants & Aids$0$0.00$0.00$0.000.00%
R 404-48000-34780 Park Dedication Fees$21,000$0.00$0.00$21,000.000.00%
R 404-48000-36210 Interest Income$66$0.00$0.00$66.000.00%
Lions Playground donationR404-48000-36230 Donations$0$10,000.00$0.00($10,000.00)0.00%
Total Park Development Fund Revenue$41,066.00$10,000.00$0.00$31,066.0024.35%
ExpenditureE 404-48000-312 Planning Services$0$4,500.00$4,500.00($4,500.00)0.00%
E 404-48000-520 Capital Improvements to Bldgs$17,306$0.00$0.00$17,306.000.00%
E 404-48000-720 Operating Transfers$0$0.00$0.00$0.000.00%
Total Park Development Fund Expenditures$17,306.00$4,500.00$4,500.00$12,806.0026.00%
EQUIPMENT REPLACEMENT
RevenueR 406-48500-31000 Washington Cty. Tax Settlement$0$0.00$0.00$0.000.00%
R 406-48500-36210 Interest Income$1,030$0.00$0.00$1,030.000.00%
R 406-48500-36260 Sale of Equipment$35,000$0.00$0.00$35,000.000.00%
R 406-48500-39350 Certificate of Indebtedness$819,500$0.00$0.00$819,500.000.00%
Total Equipment Replacement Fund Revenue$855,530.00$0.00$0.00$855,530.000.00%
ExpenditureE 406-48500-540 Heavy Machinery Capital$325,000$0.00$0.00$325,000.000.00%
E 406-48500-550 Motor Vehicles Capital$189,500$0.00$0.00$189,500.000.00%
Total Equipment Replacement Fund Expenditures$514,500.00$0.00$0.00$514,500.000.00%
LOCAL ROAD IMPROVEMENT FUND
RevenueR 408-43100-31000 Washington Cty. Tax Settlement$212,012$0.00$0.00$212,012.000.00%
R 408-43100-33422 Other State Grants & Aids$0$0.00$0.00$0.000.00%
R 408-43100-36210 Interest Income$12,115$0.00$0.00$12,115.000.00%
R 408-43100-39310 Proceeds-Gen Obligation Bond$0$0.00$0.00$0.000.00%
Total LRIF Revenue$224,127.00$0.00$0.00$224,127.00$0.00
ExpenditureE 408-43100-303 Engineering Fees$20,000$14,557.00$6,038.50$5,443.0072.79%
E 408-43100-530 Capital Impr Other Than Bldgs$973,000$260.08$0.00$972,739.920.03%
Total LRIF Expenditures$973,000.00$260.08$0.00$972,739.920.03%
BIG MARINE SEWER
RevenueR 602-43210-31951 Special Assessments Principal$0$0.00$0.00$0.000.00%
R 602-43210-31952 SA Penalties & Interest$0$10.00$10.00($10.00)0.00%
R 602-43210-33422 Other State Grants & Aids$0$0.00$0.00$0.000.00%
R 602-43210-34401 Sewer User Fees$140,700$32,151.88$15,635.28$108,548.1222.85%
R 602-43210-34402 Sewer Connection Fee$0$8,000.00$0.00($8,000.00)0.00%
R 602-43210-36100 Special Assessments$600$0.00$0.00$600.000.00%
R 602-43210-36102 Penalties and Interest$0$29.96$29.96($29.96)0.00%
R 602-43210-36210 Interest Income$400$0.00$0.00$400.000.00%
Total Big Marine Sewer Revenue$141,700.00$40,191.84$15,675.24$101,508.1628.36%
ExpenditureE 602-43210-101 Regular Wages & Salaries$22,500$6,702.25$1,675.56$15,797.7529.79%
E 602-43210-102 OT Regular Wages$0$0.00$0.00$0.000.00%
E 602-43210-120 Pension Expense$0$0.00$0.00$0.000.00%
E 602-43210-121 PERA Coord. Employer Contribu.$17,000$501.46$125.67$16,498.542.95%
E 602-43210-122 FICA Employer Contribution$1,400$382.89$98.36$1,017.1127.35%
E 602-43210-126 MEDICARE Employer Contribution$300$104.04$23.00$195.9634.68%
E 602-43210-131 Employer Paid Health$0$0.00$0.00$0.000.00%
E 602-43210-151 Worker sComp Insurance Prem$700$736.40$736.40($36.40)105.20%
E 602-43210-200 Office Supplies$200$0.00$0.00$200.000.00%
E 602-43210-210 Operating Supplies$2,500$12.37$6.99$2,487.630.49%
E 602-43210-240 Small Tools and Minor Equip$600$0.00$0.00$600.000.00%
Bliss Collector Permit RenewalE602-43210-303 Engineering Fees$10,500$31,391.50$20,704.00($20,891.50)298.97%
E602-43210-304 Legal Services$0$18.00$0.00($18.00)0.00%
E 602-43210-308 Other Professional Services$2,500$915.00$392.00$1,585.0036.60%
E 602-43210-309 Software Support & Maintenance$1,300$0.00$0.00$1,300.000.00%
E 602-43210-317 Employee Training$1,400$0.00$0.00$1,400.000.00%
E 602-43210-321 Telephone$2,400$1,051.01$0.00$1,348.9943.79%
E 602-43210-322 Postage$600$0.00$0.00$600.000.00%
E 602-43210-331 Travel Expenses$200$0.00$0.00$200.000.00%
E 602-43210-334 Licenses & Permits$1,600$729.00$0.00$871.0045.56%
E 602-43210-361 Liability/Property Ins$3,000$3,449.06$0.00($449.06)114.97%
E 602-43210-381 Utilities-Electric & Gas$2,500$1,893.13$736.10$606.8775.73%
E 602-43210-385 Sewer Pumping & Maintenance$15,000$0.00$0.00$15,000.000.00%
E 602-43210-386 Operation & Maintenance$5,000$2,139.00$0.00$2,861.0042.78%
E 602-43210-404 Repair Machinery/Equipment$16,000$9,428.30$9,428.50$6,571.7058.93%Lift Station #2 pump replacement
E 602-43210-413 Equipment Rental$400$0.00$0.00$400.000.00%
E 602-43210-420 Depreciation Expense$54,300$0.00$0.00$54,300.000.00%
E 602-43210-438 Misc. Contractual$10,000$0.00$0.00$10,000.000.00%
E 602-43210-439 Refunds Issued$0$0.00$0.00$0.000.00%
E 602-43210-530 Capital Impr Other Than Bldgs$9,800$0.00$0.00$9,800.000.00%
Total Big Marine Sewer Expenditures$159,200.00$52,751.16$32,251.02$106,448.8433.14%
UPTOWN SEWER
RevenueR 612-43210-34401 Sewer User Fees$22,300$143.56$143.56$22,156.440.64%
R 612-43210-36210 Interest Income$200$0.00$0.00$200.000.00%
Total Uptown Sewer Revenue$22,500.00$143.56$143.56$22,356.440.64%
ExpenditureE 612-43210-101 Regular Wages & Salaries$9,700$2,874.32$718.58$6,825.6829.63%
E 612-43210-121 PERA Coord. Employer Contribu.$700$215.25$53.94$484.7530.75%
E 612-43210-122 FICA Employer Contribution$600$164.24$42.18$435.7627.37%
E 612-43210-126 MEDICARE Employer Contribution$100$44.52$9.84$55.4844.52%
E 612-43210-131 Employer Paid Health$0$0.00$0.00$0.000.00%
E 612-43210-151 Worker sComp Insurance Prem$200$315.60$315.60($115.60)157.80%
E 612-43210-200 Office Supplies$100$0.00$0.00$100.000.00%
E 612-43210-210 Operating Supplies$300$0.00$0.00$300.000.00%
E 612-43210-221 Equipment Parts$300$0.00$0.00$300.000.00%
E 612-43210-303 Engineering Fees$1,000$0.00$0.00$1,000.000.00%
E612-43210-304 Legal Services$0$0.00$0.00$0.000.00%
E 612-43210-308 Other Professional Services$500$733.00$733.00($233.00)146.60%58% increase in testing costs
E 612-43210-309 Software Support & Maintenance$0$0.00$0.00$0.000.00%
E 612-43210-317 Employee Training$350$0.00$0.00$350.000.00%
E 612-43210-319 Other Services$0$0.00$0.00$0.000.00%
E 612-43210-322 Postage$0$0.00$0.00$0.000.00%
E 612-43210-334 Licenses & Permits$400$224.00$0.00$176.0056.00%
E 612-43210-361 Liability/Property Ins$400$477.82$0.00($77.82)119.46%
E 612-43210-381 Utilities-Electric & Gas$1,700$418.11$91.24$1,281.8924.59%
E 612-43210-385 Sewer Pumping & Maintenance$1,500$0.00$0.00$1,500.000.00%
E 612-43210-386 Operation & Maintenance$700$0.00$0.00$700.000.00%
E 612-43210-404 Repair Machinery/Equipment$2,000$0.00$0.00$2,000.000.00%
E 612-43210-420 Depreciation Expense$5,100$0.00$0.00$5,100.000.00%
E 612-43210-438 Misc. Contractual$1,300$0.00$0.00$1,300.000.00%
E 612-43210-530 Capital Impr Other Than Bldgs$4,500$0.00$0.00$4,500.000.00%
Total Uptown Sewer Expenditures$21,050.00$2,377.29$1,191.86$18,672.7111.29%