The URL can be used to link to this page

Home My WebLink About2021-07-26 City Council Meeting Packet AGENDA MAPLEWOOD CITY COUNCIL 7:00 P.M. Monday, July 26,2021 City Hall, Council Chambers Meeting No. 14-21 CALLTO ORDER PLEDGE OFALLEGIANCE ROLL CALL APPROVAL OFAGENDA APPROVALOF MINUTES July12, 2021City CouncilMeeting Minutes APPOINTMENTSANDPRESENTATIONS Administrative Presentations Council Calendar Update Council Presentations Swearing-In Ceremony–Police Officers Terrell HerandTawnyMattheis CONSENTAGENDA–Itemsonthe Consent Agenda are considered routineand non- controversialand are approved by one motion ofthe council.Ifacouncilmemberrequests additional information orwantstomake a commentregarding an item, thevote shouldbe held until the questions or comments are made then the single vote should betaken.If a councilmember objectsto an item it shouldberemoved and acted upon asa separate item. Approval of Claims Financial ReportJune 30,2021 Resolution Dedicating Local FundingforMinnesota DNR ShadeTree Program Bonding Grant PUBLIC HEARINGS–If you are herefor a Public Hearing please familiarize yourselfwiththe Rules of Civility printed on the back of the agenda. Sign inwith the City Clerk before addressing the council. At the podium please state your name and address clearlyfor the record. All comments/questions shallbe posedtothe Mayorand Council.The Mayorwill thendirect staff, as appropriate,to answer questions orrespondto comments. None UNFINISHED BUSINESS None NEW BUSINESS None AWARD OF BIDS None ADJOURNMENT Sign language interpreters for hearing impaired persons are available for public hearings upon request. The request for this must be made at least 96 hours in advance. Please call the CityClerk’s Office at 651.249.2000to make arrangements. Assisted Listening Devices are also available. Please check with the City Clerk for availability. RULES OF CIVILITY FOR THE CITY COUNCIL, BOARDS, COMMISSIONS AND OUR COMMUNITY Following are rules of civility the City of Maplewood expects of everyone appearing at Council Meetings - elected officials, staff and citizens. It is hoped that by following these simple rules, everyone’s opinions can be heard and understood in a reasonable manner. We appreciatethe fact that when appearing at Council meetings, it is understood that everyone will follow these principles: Speak only for yourself, not for other councilmembers or citizens -unless specifically tasked by your colleagues to speak for the group or for citizens in the form of a petition. Show respect during comments and/or discussions, listen actively and do not interrupt or talk amongst each other. Be respectful of the process, keeping order and decorum. Do not be critical of councilmembers, staff or others in public. Be respectful of each other’s time keeping remarks brief, to the point and non-repetitive. E1 MINUTES MAPLEWOOD CITY COUNCIL 7:00 P.M. Monday, July 12, 2021 City Hall, Council Chambers Meeting No. 13-21 A.CALL TO ORDER A meeting of the City Council was held in the City Hall Council Chambers and was called to order at7:00p.m. by Mayor Abrams. Mayor Abrams welcomed everyone back to in-person meetings and introduced the new Public Safety Director, Brian Bierdeman. Public Safety Director Bierdeman addressed the council. B.PLEDGE OF ALLEGIANCE C.ROLL CALL Marylee Abrams, MayorPresent Rebecca Cave,CouncilmemberPresent Kathleen Juenemann, CouncilmemberPresent William Knutson, CouncilmemberPresent Nikki Villavicencio, CouncilmemberPresent D.APPROVAL OF AGENDA The following items were added to Council Presentations: National Night Out Tax Exemption Legislation World’s Largest Bottle of Soap CouncilmemberJuenemannmoved to approve the agenda as amended. Seconded by CouncilmemberCaveAyes – All The motion passed. E.APPROVAL OF MINUTES 1.June 28,2021City CouncilWorkshop Meeting Minutes CouncilmemberJuenemannmoved to approve the June 28, 2021City Council Workshop Meeting Minutes as submitted. Seconded by CouncilmemberKnutsonAyes – All The motion passed. 2.June 28, 2021 City Council Meeting Minutes July 12, 2021 City Council Meeting Minutes 1 Council Packet Page Number 1 of 75 E1 CouncilmemberVillavicenciomoved to approve the June 28, 2021City Council Meeting Minutes as submitted. Seconded by CouncilmemberKnutsonAyes – All The motion passed. F.APPOINTMENTS AND PRESENTATIONS 1.Administrative Presentations a.Council Calendar Update City Manager Coleman gave an update to the council calendarandreviewed other topics of concern or interest requested by councilmembers. 2.Council Presentations The following items were added to Council Presentations: National Night Out Councilmember Juenemann gave a reminder that National Night Out will take place in Maplewood on Tuesday, August 3, 2021. Tax Exemption Legislation Mayor Abrams announced that during the last legislative session Maplewood successfully received a tax exemption for the new fire station construction materials. World’s Largest Bottle of Soap Mayor Abramsannounced Hy-Vee will be displaying the world’s largest bottle of soap. 3. Swearing-in Ceremonyfor Public Safety Director Brian Bierdeman City Manager Coleman gave the introduction. City Clerk Sindt performed the ceremonial swearing in of Public Safety Director Bierdeman.Public Safety Director Bierdeman addressed the council and expressed gratitude. 4.Ramsey County HRA Levy Assistant Community Development Director Martin introduced the item. Kari Collins, Ramsey County Community & Economic Development Director, addressed the council, gave the presentation, and answered questions of the council. No Action Needed G.CONSENT AGENDA – Items on the Consent Agenda are considered routine and non- controversial and are approved by one motion of the council. If a councilmember requests additional information or wants to make a comment regarding an item, the vote July 12, 2021 City Council Meeting Minutes 2 Council Packet Page Number 2 of 75 E1 should be held until the questions or comments are made then the single vote should be taken. If a councilmember objects to an item it should be removed and actedupon as a separate item. CouncilmemberCavemoved to approve agenda items G1-G4. Seconded by CouncilmemberJuenemannAyes – All The motion passed. 1.Approval of Claims CouncilmemberCave moved to approve the approval of claims. ACCOUNTS PAYABLE: $ 1,217,494.88 Checks # 107608 thru # 107651 dated 06/29/21 $ 280,750.80 Checks # 107652 thru # 107679 dated 07/06/21 $ 1,139,547.72 Disbursements via debits to checking account dated 06/21/21 thru 07/04/21 $ 2,637,793.40 Total Accounts Payable PAYROLL $ 597,696.82 Payroll Checks and Direct Deposits dated 06/25/21 $ 210,466.33 Payroll Checks and Direct Deposits dated 07/01/21 $ 808,163.15 Total Payroll $ 3,445,956.55 GRAND TOTAL Seconded by CouncilmemberJuenemannAyes – All The motion passed. 2.Resolution to Accept the Coronavirus Local Fiscal Recovery Fund CouncilmemberCavemoved toadopt the Resolution to Accept the Coronavirus Local Fiscal Recovery Fund Established under the American Rescue Plan Act. Resolution 21-07-1963 RESOLUTION TO ACCEPT THE CORONAVIRUS LOCAL FISCAL RECOVERY FUND ESTABLISHED UNDER THE AMERICAN RESCUE PLAN ACT WHEREAS, since the first case of coronavirus disease 2019 (COVID-19) was July 12, 2021 City Council Meeting Minutes 3 Council Packet Page Number 3 of 75 E1 discovered in the United States in January 2020, the disease has infected over 33.7 million and killed over 600,000 Americans (“Pandemic”). The disease has impacted every part of life: as social distancing became a necessity, businesses closed, schools transitioned to remote education, travel was sharply reduced, and millions of Americans lost their jobs; WHEREAS, as a result of the Pandemic cities have been called on to respond to the needs of their communities through the prevention, treatment, and vaccination of COVID-19. WHEREAS, city revenues, businesses and nonprofits in the city have faced economic impacts due to thePandemic. WHEREAS, Congress adopted the American Rescue Plan Act in March 2021 (“ARPA”) which included $65 billion in recovery funds for cities across the country. WHEREAS, ARPA funds are intended to provide support to state, local, and tribal governments in responding to the impact of COVID-19 and in their efforts to contain COVID-19 in their communities, residents, and businesses. WHEREAS, an estimated $4,292,925 has been allocated to the City of Maplewood (“City”) pursuant to the ARPA (“Allocation”). WHEREAS, the United States Department of Treasury has adopted guidance regarding the use of ARPA funds. WHEREAS, the City, in response to the Pandemic, has had expenditures and anticipates future expenditures consistent with the Department of Treasury’s ARPA guidance. WHEREAS, the State of Minnesota will distribute ARPA funds to the City because its population is less than 50,000. NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF MAPLEWOOD, MINNESOTA AS FOLLOWS: 1.The City intends to collect its share of ARPA funds from the State of Minnesota to use in a manner consistent with the Department of Treasury’s guidance. 2.City staff, together with the Mayor and the City Attorney are hereby authorized to take any actions necessary to receive the City’s share of ARPA funds from the State of Minnesota for expenses incurred because of the Pandemic. 3.City staff, together with the Mayor and the City Attorney are hereby authorized to make recommendations to the City Council for future expenditures that may be reimbursed with ARPA funds Seconded by CouncilmemberJuenemannAyes – All July 12, 2021 City Council Meeting Minutes 4 Council Packet Page Number 4 of 75 E1 The motion passed. 3.Resolution to Accept a Donation from the Kachelmyer Family CouncilmemberCavemoved to approve resolution accepting a donation in the amount of $138.55 from the Kachelmyers for a new plaque for their memorial bench at Fish Creek Preserve. Resolution 21-07-1964 ACCEPTANCE OF DONATION WHEREAS the City of Maplewood and the Parks and Recreation Department has received a donation of $138.55 for a bench plaque from Philip and Marlene Kachelmyer; NOW, THEREFORE, BE IT RESOLVED that the MaplewoodCity Council authorizes the City of Maplewood, Parks and Recreation Department to accept this donation. Seconded by CouncilmemberJuenemann Ayes – All The motion passed. 4.Resolution for a Lawful Gambling Premises Permit for White Bear Youth Football Association at Acapulco Mexican Restaurant, 3069 White Bear Avenue CouncilmemberCavemoved to approve theresolution for a lawful gambling premises permit for White Bear Youth Football Association to conduct gambling activities at Acapulco Mexican Restaurant, 3069 White Bear Avenue. Resolution 21-07-1965 LAWFUL GAMBLING PREMISES PERMIT FORWHITE BEAR YOUTH FOOTBALL ASSOCIATION AT ACAPULCO MEXICAN RESTAURANT WHEREAS, White Bear Youth Football Associationhas submitted an application to the City of Maplewood requesting City approval of a Lawful Gambling Premises permit application, to be used at Acapulco Mexican Restaurant, 3069 White Bear Avenue; WHEREAS, local approval is required prior to the GamblingControl Board’s issuance of a premises permit; BE IT HEREBY RESOLVED, by the City Council of Maplewood, MN, that the premises permit for lawful gambling is approved for White Bear Youth Football Associationto conduct gambling activities at Acapulco Mexican Restaurant, 3069 White Bear Avenue, Maplewood, MN. FURTHERMORE, that the Maplewood City Council requests that the Gambling Control Board approve said permit application as being in compliance with Minnesota Statute §349.213. NOW, THEREFORE, be it further resolved that this Resolution by the City Council of Maplewood, MN, be forwarded to the Gambling Control Board for their approval. July 12, 2021 City Council Meeting Minutes 5 Council Packet Page Number 5 of 75 E1 Seconded by CouncilmemberJuenemann Ayes – All The motion passed. H.PUBLIC HEARINGS– If you are here for a Public Hearing please familiarize yourself with the Rules of Civility printed on the back of the agenda. Sign in with the City Clerk before addressing the council. At the podium please state your name and address clearly for the record. All comments/questions shall be posed to the Mayor and Council. The Mayor will then direct staff, as appropriate, to answer questions or respond to comments. None I.UNFINISHED BUSINESS None J.NEW BUSINESS 1.Resolution Terminating the Local Emergency Related to COVID-19 City Manager Coleman gave the staff report. City Attorney Batty provided further information. Mayor Abramsmoved to approve the Resolution Terminating the Local Emergency Related to COVID-19, Resolution 21-07-1966 RESOLUTION TERMINATING THE LOCAL EMERGENCY RELATED TO COVID-19 WHEREAS, on March 16, 2020, Mayor Marylee Abrams issued Mayoral Declaration 2020-1 declaring a local emergency in response to the COVID-19 pandemic; and WHEREAS, on March 16, 2020, the City Council exercised its authority under Minnesota Statutes, section 12.29 to adopt Resolution No. 20-03-1794 to extend the local emergency “until further action of the City Council”; and WHEREAS, as of July 1, 2021 at 11:59pm, the statewide emergency is no longer in effect and all emergency restrictions and regulations related to COVID-19, including social distancing, mask wearing, and capacity restrictions have ended; and WHEREAS, the City Council finds and determines as follows: a.The declaration of a local emergency allows a city to implement local emergency operations plans and to access certain emergency powers to meet, enter into contracts, and raise funds without having to follow typical procedures to allow it to rapidly respond to the emergency; b.The initial uncertainties associated with the pandemic, the potential need for a local emergency response, and the possibility a local declaration would be required to be eligible for federal or state relief funds made the declaration of a local emergency appropriate; July 12, 2021 City Council Meeting Minutes 6 Council Packet Page Number 6 of 75 E1 c. Given that the local emergency related to the pandemic has extended for more than one year, the need for a rapid response using emergency powers is no longer necessary and the City has learned how to continue its work without having to rely on emergency plans or the exercise of emergency powers; d.While the pandemic remains a public health risk, the increased availability of vaccines has caused the number and severity of cases to continue to drop; and e.It is no longer necessary to continue the local emergency because the City can and will continue to respond to the pandemic without having to rely on local emergency operations plans or emergency powers. NOW, THEREFORE, BE IT RESOLVED BY THE MAPLEWOOD CITYCOUNCIL as follows: 1.The local emergency declared by Mayoral Declaration No. 2020-1 on March 16, 2020 and extended on March 16, 2020 by City Council Resolution No. 20-03-1794 is terminated, effective immediately. 2.Resolution No. 20-03-1794 is repealed immediately. 3.The City shall continue its work to resume normal operations as soon as possible. 4.This Resolution will be given prompt and general publicity and filed in accordance with Minnesota Statutes, section 12.29 Seconded by CouncilmemberKnutsonAyes – All The motion passed. K.AWARD OF BIDS None L.ADJOURNMENT Mayor Abramsadjourned the meeting at8:37 p.m. July 12, 2021 City Council Meeting Minutes 7 Council Packet Page Number 7 of 75 F1a Council Packet Page Number 8 of 75 F1a Council Packet Page Number 9 of 75 F3 Council Packet Page Number 10 of 75 F3 Council Packet Page Number 11 of 75 THIS PAGE IS INTENTIONALLY LEFT BLANK Council Packet Page Number 12 of 75 G 1 Council Packet Page Number 13 of 75 G1, Attachments Council Packet Page Number 14 of 75 G1, Attachments Council Packet Page Number 15 of 75 G1, Attachments Council Packet Page Number 16 of 75 G1, Attachments Council Packet Page Number 17 of 75 G1, Attachments Council Packet Page Number 18 of 75 G1, Attachments Council Packet Page Number 19 of 75 G1, Attachments Council Packet Page Number 20 of 75 G1, Attachments Council Packet Page Number 21 of 75 G1, Attachments Council Packet Page Number 22 of 75 G1, Attachments Council Packet Page Number 23 of 75 CITY COUNCIL STAFF REPORT Meeting Date July 26, 2021 Melinda Coleman REPORT TO: REPORT FROM: Ellen Paulseth, Finance Director PRESENTER: Ellen Paulseth, Finance Director AGENDA ITEM: Financial Report for the Month Ended June 30, 2021 Action Requested: MotionDiscussion Public Hearing Form of Action: Resolution Ordinance Contract/Agreement Proclamation Policy Issue: The City Council receives monthly financial reports at Council meetings, in addition to the emailed reports to provide greater transparency for taxpayers and interested parties. Recommended Action: No action is required. Fiscal Impact: Is There a Fiscal Impact? No Yes, the true or estimated cost is N/A Financing source(s): Adopted Budget Budget Modification New Revenue Source Use of Reserves Other: N/A Strategic Plan Relevance: Financial SustainabilityIntegrated CommunicationTargeted Redevelopment Operational EffectivenessCommunity InclusivenessInfrastructure & Asset Mgmt. Financial reports are primarily about communication and transparency; however, the budget covers all areas of the strategic plan. Background Council members receive an emailed financial report on a monthly basis, in addition to the council meeting report. The council meeting report allows greater access of the information to the public. This report includes the monthly investment and General Fund budget report for the month ended June 30, 2021. Notes to the financial report precede the report. Attachments 1.Financial Report for the Month Ended June 30, 2021 Council Packet Page Number 24 of 75 Investments The investment portfolio meets investment policy parameters for diversification by security sector and maturity range. Portfolio yield to maturity is .70%, down from the previous month of .92%. Interest earnings exceed budget year-to-date expectations at 52.28% year-to-date. General Fund Budget Revenues The County settles property taxes in two main installments, July and December; therefore, the monthly report will not reflect property tax revenues until July. Because the first-half settlement arrived shortly after the date of this report, we can report that the City received approximately 52% of budgeted property tax revenues in July. Licenses and Permits exceed budget expectations for the year at 62.1%, due to continued robust building permit activity. Charges for services are still slightly below budget year-to-date. DMV charges are at 38%, including driversÓ license fees, which are in the same account. This should increase after the doors open in July. Most intergovernmental revenue arrives in the second half of the year. Therefore, this report does not reflect most of the intergovernmental revenue expected. Investment earnings are negative due to an annual reversing entry to convert the investment portfolio from market value back to book value on January 1. This is normal and will work its way out by the end of the year. We expect interest earnings to exceed budget for the year. Total revenues are at 7.4% of budget for the year, due in part to the payment dates of property taxes. Total revenue is below prior year levels at the same period, mostly due to the market value entry for interest earnings. Revenues are approximately as expected for this time of year. Expenditures Departmental expenditures are at or below expected levels year-to-date. Total expenditures are at 45.0% for the year, with the budget expectation being 50.0% for June 30. This compares with 44.7% in the prior year. Transfers In/Out Budgeted Transfers in from Enterprise Funds are complete for the year. There may be additional transfers as necessary throughout the year. Council Packet Page Number 25 of 75 G2, Attachment Monthly Financial Report Ȩ´ ´£¨³¤£ȩ Month Ending June 30, 2021 Prepared By: Approved By: Finance Director City Manager Council Packet Page Number 26 of 75 G2, Attachment 1 Month 1 51.16% 0 Months 0.99% 3 1 Years 2.05% 10 Months 5 Range 3.79% 6 3 Years 5 2.74% 4 Maturity Months 4.23% 9 Years 6 4 6.39% Months 3 Years 2.16% 12 3 11.49% Years 9 2 2 15.00% 1 Diversification Bonds 27.83% Municipal of and 3.69% 18.81% Deposit Agencies Treasury Certificate US Sector Security Petty by and Cash Market 19.55% 10.64% Cash Money Local Pool Diversification 19.48% 4M Government Council Packet Page Number 27 of 75 G2, Attachment 1 City of Maplewood, Minnesota General Fund Statement of Revenues, Expenditures, and Changes in Fund Balance June 30, 2021 20212020 PercentPercent YTD AmendedAmended Of ActualOf Actual YTD Actual BudgetBudget To BudgetTo Budget Actual Revenues: TAXES$17,324,330$0%0.0$17,481,000$0%0.0 LICENSES AND PERMITS1,316,000817,065%62.11,328,000865,337%65.2 FINES AND FORFEITS160,00052,466%32.8166,00057,941%34.9 INTERGOVERNMENTAL1,243,100230,503%18.51,557,110342,320%22.0 CHARGES FOR SERVICES1,337,500557,976%41.71,780,000786,065%44.2 INVESTMENT EARNINGS50,000)(122,894%(245.8)87,5601,086%1.2 MISCELLANEOUS52,84054,350%102.9126,72039,959%31.5 Total revenues21,483,7701,589,467%7.422,526,3902,092,707%9.3 Expenditures: COMMUNITY DEVELOPMENT1,550,630683,914%44.11,481,840637,538%43.0 ADMINISTRATION1,863,190719,610%38.61,889,880801,663%42.4 FINANCE1,436,150765,095%53.31,375,520686,065%49.9 FIRE2,422,8501,173,784%48.42,486,0501,166,977%46.9 LEGISLATIVE155,01059,922%38.7157,70065,238%41.4 PARKS1,458,000658,06045.1%1,314,050477,22936.3% POLICE10,413,7504,735,427%45.510,238,6204,687,186%45.8 PUBLIC WORKS3,374,1901,401,470%41.54,372,7301,895,549%43.3 Total expenditures22,673,77010,197,281%45.023,316,39010,417,446%44.7 Excess (deficit) of revenues over expenditures(1,190,000)(8,607,814)723.3%(790,000)(8,324,739%)1,053.8 Other financing sources (uses): TRANSFERS IN1,290,0001,290,000%100.01,240,0001,240,000100.0% Total other financing sources (uses)1,290,0001,290,000%100.01,240,0001,240,000%100.0 Excess (deficit) of revenues over expenditures and other financing sources (uses)100,000(7,317,814%)(7,317.8450,000)(7,084,739%))(1,574.4 Fund balance - beginning013,694,729%0.0010,149,083%0.0 Fund balance - ending$100,000$6,376,915%6,376.9$450,000$3,064,345681.0% Norm = 50.0 % Council Packet Page Number 28 of 75 G2, Attachment 1 t 1 1 d Prc Rcv Page:Page: 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 435.0089.13 -405.00104.05 2,250.0025.00 26,495.7581.3420,420.0062.8713,009.007.08 Balance 158,567.0016.54 17,324,330.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 750.00991.00 3,565.00 31,433.0010,405.0034,580.00 115,504.25 Revenues Year-to-date 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 750.00991.00 3,565.00 31,433.0010,405.0034,580.00 115,504.25 Revenues 6/30/2021 d 0.000.000.000.000.000.000.000.000.000.000.000.000.000.00 through uste j 3,000.004,000.00 10,000.0055,000.0014,000.00 190,000.00 142,000.00 Estimate Ad 17,324,330.00 CITY OF MAPLEWOOD Revenue Status Report 1/1/2021 h 6 g 9:33AM GENERAL FUND' ccount Number Periods: 0 throu revstat.rpt07/19/2021101000 A 000-3011 TAXES - CURRENT000-3012 TAXES - DELINQUENT000-3014 TAXES-FORFTD TAX SALE APP000-3016 TAXES-MOBILE HOMES000-3017 TAXES-INTEREST000-3018 TAXES - OTHER000-3019 TAXES - EXCESS TIF000-3031 CABLE TV FRANCHISE TAXES000-3110 SPECIAL ASSESSMENTS CURRENT000-3130 SPECIAL ASSESSMENTS DELINQUENT000-3140 SPECIAL ASSESSMENTS DEFERRED000-3160 SP. ASSESS.-PENALTIES/INTEREST000-3170 SP/A FORFTD TAX SALE APRT000-3190 SP/A DEFERRED - COUNTY000-3201 LIQUOR000-3203 CIGARETTE000-3204 ENTERTAINMENT-AMUSEMENTS000-3205 GENERAL BUSINESS000-3207 CONTRACTOR000-3208 GARBAGE & RUBBISH REMOVAL000-3209 SERVICE & REPAIR STATIONS000-3210 BUSINESS REGISTRATION FEE Council Packet Page Number 29 of 75 G2, Attachment 1 t 2 2 d Prc Rcv Page:Page: 0.000.000.000.000.000.000.000.000.000.000.000.000.000.00 8,000.000.00 -4,240.00142.40 -2,542.500.00 18,591.0019.1787,671.5583.4629,041.2047.2073,136.5959.3754,312.4832.1117,953.0040.1674,272.5138.1133,261.0016.8576,266.5523.73 Balance 195,000.000.00137,500.0050.00 103,510.1326.06435,000.000.00 0.000.000.000.000.000.000.000.000.000.00 4,409.002,542.506,739.00 25,958.8025,687.5212,047.0045,727.4936,489.8723,733.4514,240.00 137,500.00 442,328.45106,863.41 Revenues Year-to-date 0.000.000.000.000.000.000.000.000.000.00 2,542.50 4,409.006,739.00 25,958.8025,687.5212,047.0045,727.4936,489.8723,733.4514,240.00 442,328.45106,863.41137,500.00 Revenues 6/30/2021 d 0.000.000.000.000.000.000.000.00 through uste j 8,000.00 23,000.0055,000.0080,000.0030,000.0040,000.0010,000.00 530,000.00180,000.00140,000.00100,000.00 120,000.00195,000.00435,000.00275,000.00 Estimate Ad CITY OF MAPLEWOOD Revenue Status Report 1/1/2021 h 6 g 9:33AM GENERAL FUND' ccount Number Periods: 0 throu revstat.rpt07/19/2021101000 A 000-3219 MISCELLANEOUS000-3301 BUILDING000-3302 ELECTRIC PERMIT FEES000-3303 HEATING000-3304 PLUMBING000-3306 ANIMAL000-3319 MISCELLANEOUS000-3321 MISC LIC/PERMITS - TASTE OF MAPLEWOOD000-3401 FINES000-3402 PENALTIES000-3512 FEDERAL DISASTER AID000-3513 FEDERAL EMERGENCY MGMT ASSISTANCE000-3516 FEDERAL POLICE GRANTS000-3517 MISC FEDERAL GRANTS000-3520 STATE FIRE AID000-3521 STATE LOCAL GOVT. AID000-3522 STATE MN DOT GRANTS000-3523 STATE HOMESTEAD CREDIT000-3524 STATE POLICE AID000-3526 STATE ST. MTNCE. AID000-3527 STATE POLICE GRANTS000-3528 STATE FIRE/PARAMEDIC GRANTS000-3530 MISC. STATE AID/GRANTS Council Packet Page Number 30 of 75 G2, Attachment 1 t 3 3 d Prc Rcv Page:Page: 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 53.0047.00 195.342.33282.0443.59 1,700.000.005,700.000.002,631.5056.14 1,900.0024.00 54,160.0025.5050,862.2962.3225,000.000.0029,190.0016.6020,000.000.00 Balance 344,001.2337.68 0.000.000.000.000.000.004.660.000.000.000.000.000.000.000.00 47.00 600.00217.96 3,368.50 5,810.00 18,540.0084,137.71 207,998.77 Revenues Year-to-date 0.00 0.000.000.000.000.000.004.660.000.000.000.000.000.000.00 47.00 600.00217.96 3,368.50 5,810.00 18,540.0084,137.71 207,998.77 Revenues 6/30/2021 d 0.000.00 0.000.000.000.000.000.000.000.00 through 200.00100.00500.00 uste j 1,700.005,700.006,000.00 2,500.00 72,700.0025,000.0035,000.0020,000.00 552,000.00 135,000.00 Estimate Ad CITY OF MAPLEWOOD Revenue Status Report 1/1/2021 h 6 g 9:33AM GENERAL FUND' ccount Number Periods: 0 throu revstat.rpt07/19/2021101000 A 000-3531 COUNTY ROAD BRIDGE AID000-3532 STATE LOCAL PERFORMANCE AID000-3534 COUNTY - OTHER GRANTS/AID000-3541 OTHER GOVT SCHL LIAS OFF PROG000-3542 OTHER GOVT JPA000-3544 OTHER GOVT-MISC. GRANTS000-3610 ELECTION SERVICES000-3611 GENERAL GOVT.-TAXABLE000-3612 GENERAL GOVT. NON TAXABLE000-3613 GENERAL-MOTOR VEHICLE FEES000-3614 GENERAL GOVT. DRIVERS LIC FEES000-3615 DNR FILING FEES000-3616 GENERAL GOVT ADMIN. CH/SWR FND000-3617 PASSPORT FEES000-3618 INVESTMENT MGMT. FEES REVENUE000-3619 GEN.GOVT.-ADMIN CHRG-PIP FUNDS000-3620 ADMINISTRATIVE CHARGES -T.I.F000-3624 PUBLIC SAFETY MISCELLANEOUS000-3625 D.A.R.E. PROGRAM000-3626 PAWNBROKER TRANSACTION FEES000-3627 TOW/IMPOUND FEES000-3628 PUBLIC WORKS ABATEMENT PROPERTY CHARGE000-3629 ADMIN. FEE ABATEMENT PROPERTIES Council Packet Page Number 31 of 75 G2, Attachment 1 t 4 4 d Prc Rcv Page:Page: 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 454.009.20150.0025.00207.9158.42691.2230.88 -120.00108.00 6,429.360.001,951.0621.96 -1,422.870.00 -9,244.821948.96 48,671.3479.2927,149.0850.6420,397.5354.51 Balance 231,800.0014.15172,893.76-245.79 0.00 0.000.000.000.000.000.000.000.00 46.0050.00 292.09548.94308.78 1,422.87 9,744.821,620.00 -6,429.36 27,850.9238,200.0024,442.47 186,328.66 -122,893.76 Revenues Year-to-date 0.00 0.000.000.000.000.000.000.000.00 46.0050.00 292.09548.94308.78 1,422.87 9,744.821,620.00 -6,429.36 27,850.9238,200.0024,442.47 186,328.66 -122,893.76 Revenues 6/30/2021 d 0.00 0.000.000.000.000.000.000.000.000.000.00 through 500.00500.00200.00500.00 uste j 1,500.002,500.001,000.00 55,000.0050,000.0044,840.00 235,000.00270,000.00 Estimate Ad CITY OF MAPLEWOOD Revenue Status Report 1/1/2021 h 6 g 9:33AM GENERAL FUND' ccount Number Periods: 0 throu revstat.rpt07/19/2021101000 A 000-3631 PUBLIC WORKS ENG CH/SP FUND000-3632 PUBLIC WORKS COUNTOUR MAPS000-3633 PUBLIC WORKS MISC.000-3641 RECREATION PROGRAM FEES000-3643 REC. - NATURE CTR. FEES000-3681 COMM DEV-PLAN CHECK FEES000-3682 COMM DEV-MISCELLANEOUS000-3683 COMM/DEV CNTY RECORD FEES000-3685 COMM DEV-RENTAL LICENSING000-3691 SUPPRESSION SERVICES000-3692 FIRE DEPT. MISC. CHARGES000-3693 LIFE SAFETY INSPECTION FEE000-3694 EXTRICATION FEES000-3801 INTEREST ON INVESTMENTS000-3802 RENT000-3803 DONATIONS & CONTRIBUTIONS000-38 04 SALE OF PROPERTY000-3806 SURTAX RETAINER000-3807 S.A.C. RETAINER000-3809 OTHER000-3810 DRUG & ALCOHOL AWARENESS PROGRAMS000-3811 ADVERTISING FEES000-3812 REVENUE BOND FEES Council Packet Page Number 32 of 75 G2, Attachment 1 t 5 5 d 0.000.000.000.000.000.000.000.00 Prc Rcv Page:Page: 0.000.000.000.000.000.00 -5.590.00 2,500.000.00 -25,709.280.00 Balance 0.000.000.005.590.00 25,709.28 Revenues Year-to-date 0.000.000.005.590.00 25,709.28 Revenues 6/30/2021 d 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 through uste j 2,500.00 Estimate Ad CITY OF MAPLEWOOD Revenue Status Report 1/1/2021 h 6 g 9:33AM GENERAL FUND' BIRTHDAY PARTIESCOMMUNITY GROUPSCONCESSIONSPUBLIC PROGRAMSMAILING LISTDAYCARE/PRESCHOOLSCHOOLSRENTAL EQUIPMENT Total Total Total Total Total Total Total Total ccount Number Periods: 0 throu revstat.rpt07/19/2021101000 A 000-3814 ADVERTISING FEES - TASTE OF MAPLEWOOD000-3816 OTHER - TASTE OF MAPLEWOOD000-3823 NATURE CENTER - DONATIONS000-3872 RENTALS-ROOM000-3873 RECREATION CONCESSIONS101-3643 REC.- NATURE CTR. FEES102-3643 REC.- NATURE CTR. FEES0.000.000.000.000.00103-3643 REC.- NATURE CTR. FEES0.000.000.000.000.00104-3643 REC.- NATURE CTR. FEES0.000.000.000.000.00105-3643 REC.- NATURE CTR. FEES0.000.000.000.000.00106-3643 REC.- NATURE CTR. FEES0.000.000.000.000.00107-3643 REC.- NATURE CTR. FEES0.000.000.000.000.00108-3643 REC.- NATURE CTR. FEES0.000.000.000.000.00 Council Packet Page Number 33 of 75 G2, Attachment 1 t 6 6 d 0.007.40 Prc Rcv Page:Page: 0.000.00 Balance 0.00 Revenues Year-to-date 0.00 Revenues 6/30/2021 d 0.000.000.000.000.00 through uste j Estimate Ad 21,483,770.001,589,466.641,589,466.6419,894,303.36 CITY OF MAPLEWOOD Revenue Status Report 1/1/2021 h 6 g 9:33AM GENERAL FUND' CONSULTING & TRAINING' Total Total ccount Number Periods: 0 throu revstat.rpt07/19/2021101000 A 109-3643 REC.- NATURE CTR. FEES Council Packet Page Number 34 of 75 G2, Attachment 1 t 7 7 d Prc 12.64 100.00 Rcv Page:Page: 0.00100.00 Balance 19,894,303.3619,894,303.3612.64 1,290,000.002,879,466.642,879,466.64 Revenues Year-to-date 1,290,000.002,879,466.642,879,466.64 Revenues 6/30/2021 d through uste j Estimate Ad 1,290,000.001,290,000.001,290,000.001,290,000.000.00 22,773,770.0022,773,770.00 CITY OF MAPLEWOOD Revenue Status Report 1/1/2021 h 6 g Grand Total 9:33AM GENERAL FUNDTRANSFERS TRANSFERSGENERAL FUND Total Total ccount Number Periods: 0 throu revstat.rpt07/19/2021101999 A 000-3999 TRANSFERS IN Council Packet Page Number 35 of 75 G2, Attachment 1 t 1 1 d 0.000.000.000.000.000.000.000.000.009.230.000.000.000.000.00 Prc 48.6150.0049.9948.0624.5650.0132.8113.7750.00 191.73 Use Page: Page: 0.000.000.000.000.000.000.000.000.000.00 65.01 -91.73 129.84250.00905.31249.94200.00200.00 3,990.005,000.003,631.007,550.01 32,424.0830,237.5010,347.04 95,088.0038.66 Balance 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.000.00 64.99 120.16294.69191.73250.06369.00 3,990.001,652.967,549.99 30,675.9214,762.5059,922.00 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.000.000.00 64.99 120.16294.69191.73250.06369.00 3,990.001,652.967,549.99 59,922.00 30,675.9214,762.50 Expenditures d 0.000.000.000.000.000.000.000.000.000.00 130.00250.00250.00100.00500.00200.00200.00 uste j 7,980.005,000.001,200.004,000.00 63,100.0045,000.0012,000.0015,100.00 CITY OF MAPLEWOOD 155,010.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDCITY COUNCIL CITY COUNCIL Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101101 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4025 WAGES/TEMPORARY000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4220 SIGNS & SIGNALS000-4310 TELEPHONE000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4580 INTERNAL I. T. CHARGES Council Packet Page Number 36 of 75 G2, Attachment 1 t 2 2 d 0.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Prc 46.2550.0050.0050.0050.0065.4410.9846.9062.9388.2917.7150.0022.7421.7450.00 Use Page: Page: 0.000.000.000.000.000.000.000.000.000.00 -0.02 111.21 500.00172.80500.00468.44 1,115.13 2,160.002,480.014,005.878,229.431,200.001,158.907,500.002,738.99 24,120.00 19,380.0010,350.00 Balance 165,824.07252,014.8345.54 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.020.000.000.000.000.000.00 327.20494.13984.87188.79341.10761.01 2,160.00 2,479.993,531.561,770.571,200.00 24,120.0019,380.0010,350.00 Year-to-date Expenditures 0.000.000.000.000.000.000.000.020.000.000.000.000.000.00 327.20494.13984.87188.79341.10761.01 2,160.002,479.993,531.561,770.571,200.00 24,120.0019,380.0010,350.00 142,675.93142,675.93210,765.17210,765.17 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.00 500.00500.00500.00300.00 uste j 4,320.004,960.00 4,500.002,100.004,000.002,400.001,500.007,500.003,500.00 48,240.0038,760.0010,000.0020,700.00 CITY OF MAPLEWOOD 308,500.00 462,780.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDADMINISTRATION ADMINISTRATION Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101102 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4310 TELEPHONE000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4391 EDUCATION REIMBURSEMENTS000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4550 DUPLICATING COSTS000-4580 INTERNAL I. T. CHARGES000-4630 EQUIPMENT - OFFICE Council Packet Page Number 37 of 75 G2, Attachment 1 t 3 3 d 0.000.000.000.000.000.000.000.000.000.00 Prc 47.8734.36 Use Page: Page: 0.000.000.000.000.000.000.000.000.000.00 260.66 98,460.0098,720.6634.40 Balance 0.000.00 0.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.00 0.000.000.000.000.000.000.000.000.00 239.34 51,540.0051,779.34 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.00 239.34 51,540.0051,779.34 Expenditures d 0.00 0.000.000.000.000.000.000.000.000.00 500.00 uste j CITY OF MAPLEWOOD 150,000.00150,500.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDLEGAL SERVICES LEGAL SERVICES Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101103 A 000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4110 SUPPLIES - OFFICE000-4310 TELEPHONE000-4370 INSURANCE000-4390 TRAVEL & TRAINING000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4970 JUDGEMENTS & LOSSES000-4975 SMALL LIABILITY CLAIMS Council Packet Page Number 38 of 75 G2, Attachment 1 t d 10 10 0.000.000.000.000.000.000.000.00 Prc Use Page: Page: 0.000.000.000.000.000.00 1,000.00 11,000.000.00 10,000.00 Balance 0.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.00 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.00 Expenditures d 0.000.000.000.000.000.00 uste j 1,000.00 11,000.00 10,000.00 CITY OF MAPLEWOOD Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g Y 9:46AM GENERAL FUNDSAFETY SAFET Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101114 A 000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4550 DUPLICATING COSTS Council Packet Page Number 39 of 75 G2, Attachment 1 t d 11 11 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.006.98 Prc 46.9057.5250.0050.0150.0050.0044.9533.6824.4046.2534.7550.0057.0152.91 304.66 Use Page: Page: 0.000.000.000.000.000.000.000.00 400.00756.00500.00100.00 4,374.963,000.001,225.009,339.998,807.591,000.001,000.007,000.001,021.216,500.011,000.00 -2,046.58 25,116.10 30,093.0516,951.59 92,954.1416,603.0017,794.0016,580.8164,596.59 Balance 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 244.00878.79 1,225.003,046.586,499.991,883.90 5,925.049,340.017,192.418,419.19 82,085.8616,607.0017,796.0034,403.4139,906.9519,048.41 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 244.00878.79 5,925.041,225.009,340.017,192.418,419.193,046.586,499.991,883.90 39,906.9519,048.41 82,085.8616,607.0017,796.0034,403.41 Expenditures d 0.000.000.000.000.000.000.000.00 400.00500.00100.00 uste j 3,000.002,450.001,000.001,000.001,000.001,000.007,000.001,900.001,000.00 10,300.0033,210.0035,590.0018,680.0016,000.0025,000.0099,000.0013,000.0070,000.0027,000.0036,000.00 CITY OF MAPLEWOOD 175,040.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDBUILDING OPERATIONS ccount Number Periods: 0 throu expstat.rpt07/19/2021101115 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4130 SUPPLIES - JANITORIAL000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4180 MAINTENANCE MATERIALS000-4190 CHEMICALS000-4210 FUEL & OIL000-4220 SIGNS & SIGNALS000-4230 SMALL TOOLS000-4240 UNIFORMS & CLOTHING000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4320 UTILITIES000-4325 SOLAR SYSTEM000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4391 EDUCATION REIMBURSEMENTS000-4400 VEHICLE ALLOWANCE000-4410 REPAIR & MAINT/BUILDINGS000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE Council Packet Page Number 40 of 75 G2, Attachment 1 t d 12 12 0.000.000.000.000.000.000.000.000.00 Prc 50.00 Use Page: Page: 0.000.000.000.000.000.000.00 2,250.00 12,000.0035,000.00 Balance 373,917.4640.71 0.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.00 2,250.00 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.00 2,250.00 256,752.54256,752.54 Expenditures d 0.000.000.000.000.000.000.00 uste j 4,500.00 12,000.0035,000.00 CITY OF MAPLEWOOD 630,670.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDBUILDING OPERATIONS BUILDING OPERATIONS Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101115 A 000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4540 INTERNAL RENTAL - VEHICLE000-4590 MISC. CONTRACTUAL SERVICES000-4610 VEHICLES000-4630 EQUIPMENT - OFFICE000-4640 EQUIPMENT - OTHER000-4720 LAND IMPROVEMENT000-4730 BUILDING IMPROVEMENT000-4759 OTHER CONSTRUCTION COSTS Council Packet Page Number 41 of 75 G2, Attachment 1 t d 13 13 0.000.007.850.000.000.000.001.650.000.000.000.000.00 11.67 Prc 53.4428.5750.0050.0050.0050.0020.2667.4437.9148.9820.5016.7550.00 114.04 250.00 Use Page: Page: 0.000.000.000.000.000.000.00 800.00520.91310.44 1,000.001,680.001,910.011,382.241,993.591,325.007,376.001,250.001,248.81 -1,404.00-3,000.00 11,340.00 84,550.7541,577.6310,000.0022,564.0012,000.0039,749.8126,600.01 Balance 264,775.2044.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.00 117.76 506.41189.56175.00124.00251.19 1,680.001,909.991,079.091,200.005,000.00 11,340.0011,404.00 97,049.2516,632.3722,566.0010,250.1926,599.99 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.00 117.76 506.41189.56175.00124.00251.19 1,680.001,909.991,079.091,200.005,000.00 11,340.0011,404.00 97,049.2516,632.3722,566.0010,250.1926,599.99 208,074.80208,074.80 Expenditures d 0.000.000.000.000.000.000.00 800.00500.00 uste j 1,000.00 3,360.003,820.001,500.002,500.001,600.001,500.007,500.002,450.002,000.001,500.00 58,210.0010,000.0045,130.0022,680.0010,000.0012,000.0050,000.0053,200.00 CITY OF MAPLEWOOD 181,600.00 472,850.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDHUMAN RESOURCES ADMINISTRATION HUMAN RESOURCES ADMINISTRATION Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101116 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4310 TELEPHONE000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4391 EDUCATION REIMBURSEMENTS000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4550 DUPLICATING COSTS000-4580 INTERNAL I. T. CHARGES000-4630 EQUIPMENT - OFFICE Council Packet Page Number 42 of 75 G2, Attachment 1 t d 15 15 0.000.000.000.000.000.000.000.000.000.000.000.000.000.00 7.640.000.00 Prc 45.5850.0050.0050.0050.0029.0550.7023.2750.0064.3846.1585.9320.2050.00 Use Page: Page: 0.000.000.000.000.000.000.000.00 0.000.000.00 190.00200.00 285.00 -418.80 3,265.003,435.001,773.851,500.001,281.851,687.992,000.015,080.001,400.009,148.723,032.47 -1,090.65 41,880.0036,424.0031,050.00 Balance 253,667.12395,791.5649.84 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.000.00 418.80726.15512.01515.00420.00767.53 1,090.653,265.003,435.001,318.151,999.991,200.00 41,880.0036,426.0055,851.2831,050.00 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.00 0.000.00 418.80726.15512.01515.00 420.00767.53 1,090.653,265.003,435.001,318.151,999.991,200.00 41,880.0036,426.0055,851.2831,050.00 212,422.88212,422.88393,298.44393,298.44 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.000.000.00 190.00200.00800.00 uste j 6,530.006,870.002,500.001,500.002,600.002,200.004,000.005,500.002,600.003,800.00 83,760.0072,850.0065,000.0062,100.00 CITY OF MAPLEWOOD 466,090.00 789,090.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDFINANCE FINANCE Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101201 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4391 EDUCATION REIMBURSEMENTS000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4550 DUPLICATING COSTS000-4580 INTERNAL I. T. CHARGES000-4630 EQUIPMENT - OFFICE000-4901 LATE PAYMENT PENALTIES000-4940 CASH OVER & SHORT Council Packet Page Number 43 of 75 G2, Attachment 1 t d 16 16 0.000.000.000.000.000.000.000.000.000.000.000.000.000.00 3.20 Prc 31.2565.9850.0450.0050.0050.0031.1238.2039.9676.9023.7250.0060.0043.3738.3344.0550.00 Use Page: Page: 0.000.000.000.000.000.000.000.000.000.00 -11.09 400.00500.01280.00300.00185.00 2,833.002,859.992,755.074,325.722,401.642,288.552,904.008,494.554,028.32 -2,710.80 12,037.9736,591.0031,633.0015,921.2419,400.01 Balance 253,916.21 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.00 11.09 96.00 711.45115.00 499.99420.00 2,710.802,837.002,860.011,244.932,674.281,598.366,505.453,171.68 -6,921.24 23,342.0336,589.0031,637.0019,399.99 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.00 11.09 96.00 711.45115.00 499.99420.00 2,710.802,837.002,860.011,244.932,674.281,598.366,505.453,171.68 -6,921.24 23,342.0336,589.0031,637.0019,399.99 115,413.79115,413.79 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.000.00 400.00700.00300.00300.00 uste j 5,670.005,720.004,000.007,000.004,000.009,000.003,000.001,000.003,000.007,200.00 35,380.0073,180.0063,270.0015,000.0038,800.00 CITY OF MAPLEWOOD 369,330.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDCITY CLERK ccount Number Periods: 0 throu expstat.rpt07/19/2021101301 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4240 UNIFORMS & CLOTHING000-4310 TELEPHONE000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4540 INTERNAL RENTAL - VEHICLE000-4550 DUPLICATING COSTS000-4580 INTERNAL I. T. CHARGES000-4630 EQUIPMENT - OFFICE000-4640 EQUIPMENT - OTHER000-4730 BUILDING IMPROVEMENT Council Packet Page Number 44 of 75 G2, Attachment 1 t d 17 17 0.000.00 Prc Use Page: Page: 0.00 -43.89 Balance 401,289.5037.90 0.000.000.00 Year-to-date Encumbrances 0.00 43.89 Year-to-date Expenditures 0.00 43.89 244,960.50244,960.50 Expenditures d 0.000.00 uste j CITY OF MAPLEWOOD 646,250.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDCITY CLERK CITY CLERK Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101301 A 000-4940 CASH OVER & SHORT000-4945 UNCOLLECTIBLE CHECKS Council Packet Page Number 45 of 75 G2, Attachment 1 t d 18 18 1.980.000.000.000.00 0.000.000.00 Prc 73.1942.5750.0050.0050.0050.0051.5440.5410.8296.2536.5238.5040.0750.00 173.04 Use Page: Page: 0.000.000.00 0.000.00 30.0020.60 118.93 980.24872.21200.00 444.36369.00 2,995.002,859.994,012.944,075.40 -1,314.76 71,074.3897,635.4839,471.0032,019.0019,400.01 Balance 275,263.7857.46 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.00 19.7681.07 -20.60 927.79487.06770.00255.64231.00 3,114.76 2,995.002,860.012,724.60 72,384.5239,469.0032,021.0019,399.99 Year-to-date Expenditures 0.000.000.000.00 0.000.00 19.7681.07 -20.60 927.79487.06770.00255.64 231.00 3,114.76 2,995.002,860.012,724.60 72,384.5239,469.0032,021.0019,399.99 194,075.62194,075.62371,796.22371,796.22 Expenditures d 0.000.000.000.000.000.00 200.00800.00200.00700.00600.00 uste j 5,990.00 1,000.005,720.001,800.001,800.004,500.006,800.00 78,940.0064,040.0038,800.00 CITY OF MAPLEWOOD 265,150.00 170,020.00647,060.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDDEPUTY REGISTRAR DEPUTY REGISTRAR Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101303 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4310 TELEPHONE000-4330 POSTAGE000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4480 FEES FOR SERVICE000-4550 DUPLICATING COSTS000-4580 INTERNAL I. T. CHARGES000-4630 EQUIPMENT - OFFICE000-4730 BUILDING IMPROVEMENT000-4940 CASH OVER & SHORT Council Packet Page Number 46 of 75 G2, Attachment 1 t d 19 19 0.000.000.000.001.840.000.000.006.510.000.000.000.000.000.000.000.00 Prc 50.0047.5057.79 Use Page: Page: 0.000.000.000.000.000.000.00 800.00300.00157.50126.64 2,711.18 5,500.003,505.001,079.771,400.001,400.002,000.00 80,700.0016,100.00 Balance 115,780.093.36 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 20.23 188.82142.50173.36 3,505.004,029.91 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 20.23 188.82142.50173.36 3,505.004,029.91 Expenditures d 0.000.000.000.000.000.000.00 800.00300.00300.00300.00 uste j 5,500.007,010.001,100.001,400.001,400.002,900.002,000.00 80,700.0016,100.00 CITY OF MAPLEWOOD 119,810.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDELECTIONS ELECTIONS Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101304 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4040 RETIREMENT BENEFITS000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4310 TELEPHONE000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4550 DUPLICATING COSTS000-4640 EQUIPMENT - OTHER Council Packet Page Number 47 of 75 G2, Attachment 1 t d 20 20 5.51 0.000.000.009.310.000.000.00 Prc 43.4645.3114.4745.9250.0050.0050.0050.0023.9574.7822.3268.6553.0140.2621.7550.0077.6012.2678.0740.5355.0441.04 245.10 Use 179.97 Page: Page: 0.000.000.00 -138.88 6,490.007,869.732,408.011,643.261,140.16 -4,877.98-1,108.50 54,378.5139,189.0010,037.9929,969.6488,816.7732,048.9927,600.0027,480.4536,500.0113,487.7490,456.7022,673.38 -22,200.00 Balance 611,695.00116,750.00 213,310.32424,183.00207,630.00217,366.95142,867.26 0.003,129,905.330.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.00 691.99456.74138.88 9,201.495,510.003,162.015,183.232,326.624,059.841,108.50 39,191.0023,330.2765,630.3637,500.0036,151.0118,519.5536,499.9910,977.9846,712.2612,643.3081,250.00 Year-to-date Expenditures 0.00 0.000.000.00 691.99 456.74138.88 9,201.495,510.003,162.015,183.232,326.624,059.841,108.50 39,191.0023,330.2765,630.3637,500.0036,151.0118,519.5536,499.9910,977.9846,712.2612,643.3081,250.00 611,695.00611,695.00 176,689.68176,689.68424,187.00424,187.00207,630.00207,630.00148,133.05148,133.05174,932.74174,932.74 2,405,364.672,405,364.67 Expenditures d 0.000.000.000.000.00 uste j 3,100.002,100.006,100.005,200.00 63,580.0012,000.0078,380.0013,200.0031,200.0095,600.0015,300.0094,000.0068,200.0027,600.0046,000.0073,000.0060,200.0025,000.00 CITY OF MAPLEWOOD 390,000.00 848,370.00415,260.00103,100.00365,500.00317,800.00198,000.00 Ad 5,535,270.001,223,390.00 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDPOLICE ccount Number Periods: 0 throu expstat.rpt07/19/2021101401 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4140 SUPPLIES - VEHICLE000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4210 FUEL & OIL000-4240 UNIFORMS & CLOTHING000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4330 POSTAGE000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4391 EDUCATION REIMBURSEMENTS000-4400 VEHICLE ALLOWANCE000-4420 REPAIR & MAINT/VEHICLE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4440 REPAIR & MAINT/RADIO000-4475 FEES FOR DISPATCHING000-4480 FEES FOR SERVICE000-4482 PROSECUTION FEES000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS Council Packet Page Number 48 of 75 G2, Attachment 1 t d 21 21 0.000.000.000.000.000.00 Prc 31.4250.00 Use Page: Page: 0.000.000.000.000.000.00 7,750.04 Balance 143,000.01 0.000.000.000.000.000.000.000.000.005,678,322.8945.47 Year-to-date Encumbrances 0.000.000.000.000.000.00 3,549.96 Year-to-date Expenditures 0.000.000.000.000.000.00 3,549.96 142,999.99142,999.99 4,735,427.114,735,427.11 Expenditures d 0.000.000.000.000.000.00 uste j 11,300.00 CITY OF MAPLEWOOD 286,000.00 Ad 10,413,750.00 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDPOLICE POLICE Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101401 A 000-4540 INTERNAL RENTAL - VEHICLE000-4550 DUPLICATING COSTS000-4580 INTERNAL I. T. CHARGES000-4610 VEHICLES000-4630 EQUIPMENT - OFFICE000-4640 EQUIPMENT - OTHER000-4730 BUILDING IMPROVEMENT000-4940 CASH OVER & SHORT Council Packet Page Number 49 of 75 G2, Attachment 1 t d 22 22 0.000.000.005.290.000.000.000.000.000.00 Prc 45.0787.2077.5437.4450.0050.0050.0050.0027.6441.5254.5819.6113.8362.3238.2554.2047.5037.7650.0075.8980.14 102.68 Use Page: Page: 0.000.000.000.000.000.000.000.00 -15.94 311.21 999.16401.96376.78843.95 -936.50 6,283.193,128.077,530.001,447.265,848.385,038.259,264.72 17,918.9386,035.0058,320.0049,976.8318,941.6714,820.7715,750.9510,650.00 Balance 129,111.00 575,542.71 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.00 98.0415.94 552.74623.22188.79 1,871.937,530.004,151.621,200.848,023.171,058.339,179.235,961.752,656.05 21,686.8186,035.0058,320.0035,936.5014,249.0510,650.0037,385.28 Year-to-date Expenditures 0.000.000.000.000.000.000.000.00 98.0415.94 552.74623.22188.79 1,871.937,530.004,151.621,200.848,023.171,058.339,179.235,961.752,656.05 21,686.8186,035.0058,320.0035,936.5014,249.0510,650.0037,385.28 472,247.29472,247.29122,081.07122,081.07129,109.00129,109.00 Expenditures d 0.000.000.000.000.000.000.000.000.00 500.00500.00 uste j 5,000.002,000.002,200.001,000.003,500.00 11,000.00 27,970.0015,060.0010,000.0058,000.0035,000.0020,000.0024,000.0030,000.0021,300.0046,650.00 CITY OF MAPLEWOOD 116,640.00 140,000.00 258,220.00172,070.00 Ad 1,047,790.00 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDFIRE ccount Number Periods: 0 throu expstat.rpt07/19/2021101404 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4060 FIREFIGHTERS PENSION BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4130 SUPPLIES - JANITORIAL000-4140 SUPPLIES - VEHICLE000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4180 MAINTENANCE MATERIALS000-4190 CHEMICALS000-4210 FUEL & OIL000-4220 SIGNS & SIGNALS000-4230 SMALL TOOLS000-4240 UNIFORMS & CLOTHING000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4320 UTILITIES000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4391 EDUCATION REIMBURSEMENTS000-4400 VEHICLE ALLOWANCE Council Packet Page Number 50 of 75 G2, Attachment 1 t d 23 23 0.000.000.000.000.00 21.11 Prc 39.7914.1917.1040.5314.6331.7750.00 410.56 Use Page: Page: 0.000.000.000.000.00 -931.69 9,031.559,439.183,316.002,729.19 57,986.4042,815.6094,629.2836,999.99 Balance 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.001,273,603.8547.22 Year-to-date Encumbrances 0.000.000.000.000.00 684.00 5,968.451,560.821,231.691,270.81 15,513.6029,184.4016,220.7237,000.01 Year-to-date Expenditures 0.000.000.000.000.00 684.00 5,968.451,560.821,231.691,270.81 15,513.6029,184.4016,220.7237,000.01 1,139,446.151,139,446.15 Expenditures d 0.000.000.000.000.00 300.00 uste j 4,000.004,000.00 11,000.00 15,000.0073,500.0072,000.0074,000.00 CITY OF MAPLEWOOD 110,850.00 Ad 2,413,050.00 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDFIRE FIRE Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101404 A 000-4410 REPAIR & MAINT/BUILDINGS000-4420 REPAIR & MAINT/VEHICLE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4440 REPAIR & MAINT/RADIO000-4475 FEES FOR DISPATCHING000-4480 FEES FOR SERVICE000-4520 OUTSIDE RENTAL - EQUIPMENT000-4540 INTERNAL RENTAL - VEHICLE000-4550 DUPLICATING COSTS000-4580 INTERNAL I. T. CHARGES000-4610 VEHICLES000-4630 EQUIPMENT - OFFICE000-4640 EQUIPMENT - OTHER000-4730 BUILDING IMPROVEMENT Council Packet Page Number 51 of 75 G2, Attachment 1 t d 25 25 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.700.000.000.00 Prc 34.6650.00 Use Page: Page: 0.000.000.000.000.000.000.000.000.000.00 -1.41 400.00392.04249.99300.00500.00 -183.82-434.68 7,447.87 -9,744.37 -24,538.09350.39 -23,463.71 Balance 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.001.410.000.000.000.000.000.00 52.13 183.82434.68207.96250.01 9,744.37 23,463.7134,338.09 Year-to-date Expenditures 0.000.000.000.000.000.000.001.410.000.000.000.000.000.00 52.13 183.82434.68207.96250.01 9,744.37 34,338.09 23,463.71 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 400.00600.00500.00300.00500.00 uste j 7,500.009,800.00 CITY OF MAPLEWOOD Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDEMERGENCY MANAGEMENT EMERGENCY MANAGEMENT Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101413 A 000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4040 RETIREMENT BENEFITS000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4210 FUEL & OIL000-4240 UNIFORMS & CLOTHING000-4310 TELEPHONE000-4320 UTILITIES000-4330 POSTAGE000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4420 REPAIR & MAINT/VEHICLE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4550 DUPLICATING COSTS000-4640 EQUIPMENT - OTHER Council Packet Page Number 52 of 75 G2, Attachment 1 t d 26 26 0.000.000.000.000.000.000.000.000.007.384.310.003.750.000.000.000.000.000.000.000.000.00 Prc 46.3850.0650.0050.0047.5596.7948.0037.7550.00 294.01 Use Page: Page: 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 -50.83 814.00185.25102.68260.00 1,573.613,000.004,784.293,850.001,000.006,000.003,984.25 -8,924.34 62,349.99 62,463.0410,551.0010,761.00 Balance 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 50.8314.75 816.00215.71150.00240.00 3,097.322,415.75 1,426.39 54,036.9610,549.0010,759.0013,524.3462,350.01 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 50.8314.75 816.00215.71150.00240.00 1,426.393,097.322,415.75 62,350.01 54,036.9610,549.0010,759.0013,524.34 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 200.00500.00 uste j 1,630.005,000.003,200.004,000.001,000.004,600.006,000.006,400.00 3,000.003,000.00 21,100.0021,520.00 CITY OF MAPLEWOOD 116,500.00 124,700.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDPUBLIC WORKS ADMINISTRATION ccount Number Periods: 0 throu expstat.rpt07/19/2021101501 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4210 FUEL & OIL000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4330 POSTAGE000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4550 DUPLICATING COSTS000-4580 INTERNAL I. T. CHARGES000-4630 EQUIPMENT - OFFICE000-4710 LAND PURCHASE000-4730 BUILDING IMPROVEMENT000-4759 OTHER CONSTRUCTION COSTS000-4940 CASH OVER & SHORT Council Packet Page Number 53 of 75 G2, Attachment 1 t d 27 27 0.00 Prc Use Page: Page: 0.00 Balance 162,703.9449.53 0.000.00 Year-to-date Encumbrances 0.00 Year-to-date Expenditures 0.00 159,646.06159,646.06 Expenditures d 0.00 uste j CITY OF MAPLEWOOD 322,350.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDPUBLIC WORKS ADMINISTRATION PUBLIC WORKS ADMINISTRATION Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101501 A 000-4945 UNCOLLECTIBLE CHECKS Council Packet Page Number 54 of 75 G2, Attachment 1 t d 28 28 0.000.000.000.000.000.230.007.580.000.000.000.000.000.007.990.000.000.000.00 Prc 33.1276.4950.0250.0050.0050.0044.8396.8778.3540.5833.4650.0050.00 Use Page: Page: 0.000.000.000.000.000.000.000.000.00 312.67108.26100.00 1,175.637,200.002,229.001,000.002,206.896,000.005,942.096,987.173,000.001,000.003,000.00 99,769.2125,877.0512,500.0132,202.8284,999.99 28,864.0033,609.0051,990.00 Balance 213,079.01 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 230.79391.74 1,793.11 2,231.009,687.333,512.83 3,824.372,122.954,057.912,797.18 33,611.00 28,866.0051,990.0012,499.9985,000.01 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 230.79391.74 1,793.11 3,824.372,231.002,122.959,687.334,057.913,512.832,797.18 33,611.00 85,000.01 28,866.0051,990.0012,499.99 105,530.99105,530.99 Expenditures d 0.000.000.000.000.000.000.000.000.00 500.00100.00 uste j 5,000.007,200.004,460.004,000.006,000.003,000.001,000.003,000.00 1,000.00 57,730.0067,220.0028,000.0010,000.0010,000.0010,500.0025,000.0035,000.00 CITY OF MAPLEWOOD 318,610.00100,000.00170,000.00 103,980.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDSTREET MAINTAINANCE ccount Number Periods: 0 throu expstat.rpt07/19/2021101502 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4120 PROGRAM SUPPLIES000-4140 SUPPLIES - VEHICLE000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4180 MAINTENANCE MATERIALS000-4190 CHEMICALS000-4210 FUEL & OIL000-4220 SIGNS & SIGNALS000-4230 SMALL TOOLS000-4240 UNIFORMS & CLOTHING000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4320 UTILITIES000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4540 INTERNAL RENTAL - VEHICLE000-4610 VEHICLES Council Packet Page Number 55 of 75 G2, Attachment 1 t d 29 29 0.000.000.000.000.000.00 Prc Use Page: Page: 0.000.000.000.000.000.00 Balance 623,152.8035.84 0.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.00 Year-to-date Expenditures 0.000.000.000.000.000.00 348,147.20348,147.20 Expenditures d 0.000.000.000.000.000.00 uste j CITY OF MAPLEWOOD 971,300.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDSTREET MAINTAINANCE STREET MAINTAINANCE Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101502 A 000-4630 EQUIPMENT - OFFICE000-4640 EQUIPMENT - OTHER000-4710 LAND PURCHASE000-4730 BUILDING IMPROVEMENT000-4759 OTHER CONSTRUCTION COSTS000-4975 SMALL LIABILITY CLAIMS Council Packet Page Number 56 of 75 G2, Attachment 1 t d 30 30 0.000.000.000.000.000.000.000.000.005.690.000.000.000.000.000.00 Prc 46.2817.8849.9850.0050.0021.5221.9933.7945.6018.7525.0050.00 120.00 Use Page: Page: 0.000.000.000.000.000.000.000.000.000.000.00 -40.00 780.10272.00 2,721.001,177.211,000.002,000.003,310.423,250.006,000.00 11,316.98 25,000.0016,424.0036,085.0033,883.0012,000.0015,000.00 Balance 208,579.36378,759.0742.25 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 322.79219.90228.00750.00240.00683.02 3,576.002,719.001,689.582,000.00 36,085.0033,887.0015,000.00 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 322.79219.90228.00750.00240.00683.02 3,576.002,719.001,689.582,000.00 36,085.0033,887.0015,000.00 179,690.64179,690.64277,090.93277,090.93 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.00 500.00200.00 uste j 5,440.001,500.001,000.001,000.002,000.005,000.004,000.008,000.00 25,000.0020,000.0072,170.0067,770.0012,000.0012,000.0030,000.00 CITY OF MAPLEWOOD 388,270.00655,850.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDENGINEERING ENGINEERING Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101503 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4230 SMALL TOOLS000-4240 UNIFORMS & CLOTHING000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4391 EDUCATION REIMBURSEMENTS000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4540 INTERNAL RENTAL - VEHICLE000-4610 VEHICLES000-4630 EQUIPMENT - OFFICE000-4640 EQUIPMENT - OTHER000-4761 LEGAL & FISCAL Council Packet Page Number 57 of 75 G2, Attachment 1 t d 31 31 0.000.000.000.004.690.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Prc 47.0212.3549.9550.0150.0070.2250.00 163.96 Use Page: Page: 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 400.00 -191.88 1,011.00 4,765.752,500.003,000.00 99,999.99 76,426.4526,294.4514,983.0015,939.0026,801.68 Balance 0.000.000.000.000.000.000.000.000.000.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 234.25491.88 1,009.00 3,705.55 67,823.5514,987.0015,941.0063,198.32 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 234.25491.88 3,705.551,009.00 67,823.5514,987.0015,941.0063,198.32 100,000.01100,000.01 Expenditures d 0.000.000.000.000.000.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.00 400.00300.00 uste j 2,020.005,000.002,500.003,000.00 30,000.0029,970.0031,880.0090,000.00 CITY OF MAPLEWOOD 144,250.00200,000.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDSNOW AND ICE CONTROL ccount Number Periods: 0 throu expstat.rpt07/19/2021101514 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4120 PROGRAM SUPPLIES000-4140 SUPPLIES - VEHICLE000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4180 MAINTENANCE MATERIALS000-4190 CHEMICALS000-4210 FUEL & OIL000-4220 SIGNS & SIGNALS000-4230 SMALL TOOLS000-4240 UNIFORMS & CLOTHING000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4320 UTILITIES000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4540 INTERNAL RENTAL - VEHICLE000-4610 VEHICLES000-4630 EQUIPMENT - OFFICE000-4640 EQUIPMENT - OTHER Council Packet Page Number 58 of 75 G2, Attachment 1 t d 32 32 0.000.000.00 Prc Use Page: Page: 0.000.000.00 Balance 271,929.4449.58 0.000.000.000.00 Year-to-date Encumbrances 0.000.000.00 Year-to-date Expenditures 0.000.000.00 267,390.56267,390.56 Expenditures d 0.000.000.00 uste j CITY OF MAPLEWOOD 539,320.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDSNOW AND ICE CONTROL SNOW AND ICE CONTROL Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101514 A 000-4710 LAND PURCHASE000-4730 BUILDING IMPROVEMENT000-4759 OTHER CONSTRUCTION COSTS Council Packet Page Number 59 of 75 G2, Attachment 1 t d 34 34 0.000.000.000.000.000.000.000.000.000.00 Prc 47.7650.0750.0050.0082.1321.63 124.56 Use Page: Page: 0.000.000.000.000.000.00 -24.56 699.00357.48 -638.69 8,880.002,000.001,300.008,000.00 78,367.46 52,367.0610,950.00 Balance 162,257.7536.29 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.00 638.69701.00124.56 8,880.001,642.52 47,872.9410,950.0021,632.5492,442.25 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.00 638.69701.00124.56 8,880.001,642.52 47,872.9410,950.0021,632.5492,442.25 Expenditures d 0.000.000.000.000.000.000.00 100.00 uste j 8,000.00 1,400.002,000.002,000.001,300.00 17,760.0021,900.00 CITY OF MAPLEWOOD 100,240.00100,000.00254,700.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation Y h 6 g 9:46AM GENERAL FUNDFORESTRY FORESTR Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101516 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4140 SUPPLIES - VEHICLE000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4210 FUEL & OIL000-4240 UNIFORMS & CLOTHING000-4310 TELEPHONE000-4370 INSURANCE000-4390 TRAVEL & TRAINING000-4420 REPAIR & MAINT/VEHICLE000-4480 FEES FOR SERVICE000-4520 OUTSIDE RENTAL - EQUIPMENT Council Packet Page Number 60 of 75 G2, Attachment 1 t d 35 35 0.002.630.000.004.740.000.000.008.750.000.000.000.000.00 Prc 18.9450.0450.0050.0050.0019.4545.5550.3321.1873.7550.00 106.71101.00168.00 Use Page: Page: 0.000.000.000.000.000.000.00 -20.13-10.00 943.68708.67 -340.00 5,000.001,389.007,884.992,013.821,361.314,762.971,000.001,500.002,554.927,882.332,000.00 16,553.0019,950.0012,000.0010,350.00 Balance 161,105.74258,590.3027.69 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.00 447.00486.18320.13956.32237.03840.00245.08 2,117.67 1,991.33 1,391.007,885.011,138.691,010.00 37,654.2619,950.0012,000.0010,350.0099,019.70 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.00 447.00486.18320.13956.32237.03840.00245.08 2,117.67 1,391.007,885.011,138.691,010.001,991.33 37,654.2619,950.0012,000.0010,350.0099,019.70 Expenditures d 0.000.000.000.000.000.000.00 300.00500.00 uste j 5,000.002,700.00 2,780.002,500.002,500.001,900.005,000.001,000.001,000.001,500.002,800.002,000.00 17,000.0039,900.0024,000.0015,770.0010,000.0020,700.00 CITY OF MAPLEWOOD 198,760.00357,610.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDPARKS & REC. ADMINISTRATION PARKS & REC. ADMINISTRATION Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101601 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4310 TELEPHONE000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4540 INTERNAL RENTAL - VEHICLE000-4550 DUPLICATING COSTS000-4580 INTERNAL I. T. CHARGES000-4630 EQUIPMENT - OFFICE Council Packet Page Number 61 of 75 G2, Attachment 1 t d 36 36 0.000.000.000.006.490.000.000.000.000.000.000.000.000.000.00 Prc 44.6430.7310.4049.9850.0050.0050.0047.0152.0737.4148.4933.5250.0053.3750.00 113.67 127.37 Use Page: Page: 0.000.000.000.000.000.000.000.000.000.000.00 500.00 -410.00-400.00-410.56 5,541.692,631.007,949.193,755.141,699.895,000.00 11,825.0111,499.9922,850.11 19,171.9418,702.3099,000.00 17,920.0034,414.0039,514.0038,559.91 Balance 208,068.68 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.00 400.00 1,600.11 7,050.812,244.863,410.001,910.56 2,458.312,080.002,629.001,297.70 11,824.9911,500.01 34,416.0039,516.0020,828.0619,440.0926,149.8999,000.00 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.000.00 400.00 1,600.11 2,458.312,080.002,629.007,050.811,297.702,244.863,410.001,910.56 11,824.9911,500.01 20,828.0626,149.89 34,416.0039,516.0019,440.0999,000.00 167,771.32167,771.32 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.000.00 500.00 uste j 8,000.005,260.006,000.003,300.003,000.005,000.001,500.00 20,000.0068,830.0079,030.0023,650.0015,000.0040,000.0020,000.0058,000.0023,000.0049,000.00 CITY OF MAPLEWOOD 375,840.00198,000.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDPARK MAINTENANCE ccount Number Periods: 0 throu expstat.rpt07/19/2021101602 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4120 PROGRAM SUPPLIES000-4130 SUPPLIES - JANITORIAL000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4180 MAINTENANCE MATERIALS000-4210 FUEL & OIL000-4220 SIGNS & SIGNALS000-4230 SMALL TOOLS000-4240 UNIFORMS & CLOTHING000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4320 UTILITIES000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4410 REPAIR & MAINT/BUILDINGS000-4420 REPAIR & MAINT/VEHICLE000-4 430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4540 INTERNAL RENTAL - VEHICLE000-4610 VEHICLES Council Packet Page Number 62 of 75 G2, Attachment 1 t d 37 37 0.000.000.000.000.00 Prc Use Page: Page: 0.000.000.000.000.00 Balance 547,382.2945.42 0.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.00 Year-to-date Expenditures 0.000.000.000.000.00 455,527.71455,527.71 Expenditures d 0.000.000.000.000.00 uste j CITY OF MAPLEWOOD Ad 1,002,910.00 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDPARK MAINTENANCE PARK MAINTENANCE Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101602 A 000-4630 EQUIPMENT - OFFICE000-4640 EQUIPMENT - OTHER000-4720 LAND IMPROVEMENT000-4730 BUILDING IMPROVEMENT000-4970 JUDGEMENTS & LOSSES Council Packet Page Number 63 of 75 G2, Attachment 1 t d 38 38 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Prc Use Page: Page: 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 -8.00 38.30 -601.55-360.00 -79,481.190.00 -54,489.69-24,060.25 Balance 0.000.000.000.000.000.000.000.000.000.000.000.000.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.00 0.000.000.000.000.008.000.000.000.000.000.000.000.00 -38.30 601.55360.00 54,489.6924,060.2579,481.19 Year-to-date Expenditures 0.000.000.000.000.008.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 -38.30 601.55360.00 79,481.19 54,489.6924,060.25 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.000.000.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 uste j CITY OF MAPLEWOOD Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDRECREATION PROGRAMS *** Title Not Found ***SENIOR HIGH BASKETBALL LEAGUE Total Total ccount Number Periods: 0 throu 268-4040 RETIREMENT BENEFITS268-4120 PROGRAM SUPPLIES268-4480 FEES FOR SERVICE268-4530 OUTSIDE RENTAL-PROPERTY/BLDGS expstat.rpt07/19/2021101603 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4120 PROGRAM SUPPLIES000-4240 UNIFORMS & CLOTHING000-4310 TELEPHONE000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4580 INTERNAL I. T. CHARGES000-4660 CONSTRUCTION - BUILDING000-4940 CASH OVER & SHORT237-4025 WAGES/TEMPORARY237-4040 RETIREMENT BENEFITS237-4120 PROGRAM SUPPLIES237-4480 FEES FOR SERVICE237-4530 OUTSIDE RENTAL-PROPERTY/BLDGS268-4025 WAGES/TEMPORARY Council Packet Page Number 64 of 75 G2, Attachment 1 t d 39 39 Prc Use Page: Page: 0.000.00 -79,481.190.00 Balance 0.000.00 Year-to-date Encumbrances 0.00 79,481.19 Year-to-date Expenditures 0.00 79,481.19 Expenditures d 0.000.00 uste j CITY OF MAPLEWOOD Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDRECREATION PROGRAMS YOUTH BASKETBALLRECREATION PROGRAMS Total Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101603 A Council Packet Page Number 65 of 75 G2, Attachment 1 t d 40 40 0.000.000.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Prc 50.00 109.71 Use Page: Page: 0.000.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 -275.00 -558.42-165.02 3,000.00 Balance 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 0.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 0.000.000.000.000.000.000.000.00 558.42275.00 1,865.023,000.00 Year-to-date Expenditures 0.000.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 275.00 558.42 1,865.023,000.00 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 0.000.000.000.000.000.000.000.00 uste j 1,700.006,000.00 CITY OF MAPLEWOOD Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDNATURE CENTER ccount Number Periods: 0 throu 000-4210 FUEL & OIL000-4220 SIGNS & SIGNALS000-4230 SMALL TOOLS000-4240 UNIFORMS & CLOTHING000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4320 UTILITIES000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4391 EDUCATION REIMBURSEMENTS000-4400 VEHICLE ALLOWANCE000-4410 REPAIR & MAINT/BUILDINGS000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE expstat.rpt07/19/2021101604 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4130 SUPPLIES - JANITORIAL000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4180 MAINTENANCE MATERIALS000-4190 CHEMICALS Council Packet Page Number 66 of 75 G2, Attachment 1 t d 41 41 0.000.000.000.000.000.000.000.000.00 Prc Use Page: Page: 0.000.000.000.000.000.000.000.00 -636.88 1,364.6882.28 Balance 0.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.00 636.88 6,335.32 Year-to-date Expenditures 0.000.000.000.000.000.000.000.00 636.88 6,335.32 Expenditures d 0.000.000.000.000.000.000.000.000.00 uste j 7,700.00 CITY OF MAPLEWOOD Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDNATURE CENTER NATURE CENTER Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101604 A 000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4540 INTERNAL RENTAL - VEHICLE000-4550 DUPLICATING COSTS000-4630 EQUIPMENT - OFFICE000-4640 EQUIPMENT - OTHER000-4720 LAND IMPROVEMENT000-4730 BUILDING IMPROVEMENT000-4940 CASH OVER & SHORT Council Packet Page Number 67 of 75 G2, Attachment 1 t d 42 42 0.000.000.000.000.000.000.000.008.990.000.000.000.000.000.000.000.009.580.000.000.000.000.000.000.000.00 Prc 51.7350.7450.0050.0650.00 Use Page: Page: 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 133.00500.00600.00800.00100.00300.00200.00250.00700.00 9,185.447,000.001,945.001,663.001,820.20 13,563.6038,760.2428.51 Balance 0.000.000.000.000.000.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.00 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 137.00179.80250.00 1,945.001,667.001,436.40 9,844.56 15,459.76 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 137.00179.80250.00 9,844.561,945.001,667.001,436.40 15,459.76 Expenditures d 0.000.000.000.000.00 0.000.000.000.000.000.000.000.000.000.000.00 270.00500.00600.00800.00100.00300.00200.00500.00700.00 uste j 7,000.003,890.003,330.002,000.00 19,030.0015,000.0054,220.00 CITY OF MAPLEWOOD Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDOPEN SPACE MANAGEMENT OPEN SPACE MANAGEMENT Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101605 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4180 MAINTENANCE MATERIALS000-4190 CHEMICALS000-4210 FUEL & OIL000-4220 SIGNS & SIGNALS000-4240 UNIFORMS & CLOTHING000-4310 TELEPHONE000-4360 PUBLISHING000-4370 INSURANCE000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4610 VEHICLES000-4630 EQUIPMENT - OFFICE000-4640 EQUIPMENT - OTHER000-4690 CONSTRUCTION - OTHER000-4720 LAND IMPROVEMENT Council Packet Page Number 68 of 75 G2, Attachment 1 t d 44 44 0.000.006.270.00 Prc 40.1550.00 Use Page: Page: 0.00 897.82249.99 2,500.009,000.00 20,676.0033,323.816.29 Balance 0.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.00 602.18250.01 1,384.002,236.19 Year-to-date Expenditures 0.000.000.00 602.18250.01 1,384.002,236.19 Expenditures d 0.00 500.00 uste j 1,500.00 2,500.009,000.00 22,060.0035,560.00 CITY OF MAPLEWOOD Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDLIGHT IT UP MAPLEWOOD LIGHT IT UP MAPLEWOOD Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101622 A 000-4025 WAGES/TEMPORARY000-4120 PROGRAM SUPPLIES000-4360 PUBLISHING000-4370 INSURANCE000-4480 FEES FOR SERVICE000-4520 OUTSIDE RENTAL - EQUIPMENT Council Packet Page Number 69 of 75 G2, Attachment 1 t d 45 45 0.000.000.000.000.000.000.000.000.003.001.290.000.000.000.000.000.00 Prc 47.2947.0349.9950.0050.0050.0056.1572.2714.7650.0050.0080.9350.3720.0050.00 Use Page: Page: 0.000.000.000.000.000.000.000.000.00 915.18 -203.94-129.99 5,119.80 2,000.003,381.003,245.011,315.521,500.003,000.004,261.921,000.004,850.006,120.001,200.003,394.05 25,806.0643,869.0041,854.0012,000.0012,407.5030,399.99 Balance 436,118.7247.70 228,813.62 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.000.000.00 80.00 203.94738.08150.00129.99 2,384.821,200.001,280.20 3,379.003,244.991,684.48 22,913.9443,871.0041,856.0012,000.0014,405.9512,592.5030,400.01 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.000.000.00 80.00 203.94738.08150.00129.99 3,379.003,244.991,684.482,384.821,200.001,280.20 14,405.95 22,913.9443,871.0041,856.0012,000.0012,592.5030,400.01 397,811.28397,811.28 205,296.38205,296.38 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.00 uste j 3,300.005,000.001,000.005,000.006,200.002,400.006,400.00 2,000.006,760.006,490.003,000.001,500.003,000.00 48,720.0087,740.0083,710.0024,000.0017,800.0025,000.0060,800.00 CITY OF MAPLEWOOD 434,110.00 833,930.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDCOMMUNITY DEVELOPMENT ADMIN. COMMUNITY DEVELOPMENT ADMIN. Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101701 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4110 SUPPLIES - OFFICE000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4220 SIGNS & SIGNALS000-4290 MISCELLANEOUS COMMODITIES000-4310 TELEPHONE000-4330 POSTAGE000-4360 PUBLISHING000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4400 VEHICLE ALLOWANCE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4490 FEES - CONSULTING000-4520 OUTSIDE RENTAL - EQUIPMENT000-4530 OUTSIDE RENTAL-PROPERTY/BLDGS000-4550 DUPLICATING COSTS000-4580 INTERNAL I. T. CHARGES000-4630 EQUIPMENT - OFFICE000-4940 CASH OVER & SHORT000-4945 UNCOLLECTIBLE CHECKS Council Packet Page Number 70 of 75 G2, Attachment 1 t d 47 47 0.000.000.003.420.000.000.000.000.000.000.000.000.000.00 Prc 35.4962.7850.0250.0050.0050.0022.7020.4251.8618.9322.6033.2250.00 Use Page: Page: 0.000.000.000.000.000.000.000.000.00 -50.64 750.00 2,319.11 3,129.003,420.001,931.571,034.521,203.591,216.003,870.009,750.00 -2,779.92 21,125.1821,000.0039,553.0027,939.0043,340.48 Balance 251,846.64430,597.5339.92 0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 Year-to-date Encumbrances 0.000.000.000.000.000.000.000.000.000.000.00 50.6468.43 680.89265.48284.00 2,779.923,131.003,420.001,296.411,130.009,750.00 35,634.8239,557.0027,941.0021,559.52 Year-to-date Expenditures 0.000.000.000.000.000.000.000.000.000.000.00 50.6468.43 680.89265.48284.00 2,779.923,131.003,420.001,296.411,130.009,750.00 35,634.8239,557.0027,941.0021,559.52 138,553.36138,553.36286,102.47286,102.47 Expenditures d 0.000.000.000.000.000.000.000.000.000.000.00 750.00 uste j 6,260.006,840.002,000.003,000.001,300.002,500.001,500.005,000.00 79,110.00 56,760.0021,000.0055,880.0064,900.0019,500.00 CITY OF MAPLEWOOD 390,400.00716,700.00 Ad 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g 9:46AM GENERAL FUNDBUILDING INSPECTIONS BUILDING INSPECTIONS Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101703 A 000-4010 WAGES/FULL-TIME EMPLOYEES000-4011 OVERTIME PAY000-4020 WAGES/PART-TIME000-4025 WAGES/TEMPORARY000-4030 LEAVE BENEFITS000-4040 RETIREMENT BENEFITS000-4050 INSURANCE BENEFITS000-4090 WORKERS' COMPENSATION000-4120 PROGRAM SUPPLIES000-4160 SUPPLIES - EQUIPMENT000-4165 SMALL EQUIPMENT000-4170 BOOKS000-4240 UNIFORMS & CLOTHING000-4310 TELEPHONE000-4370 INSURANCE000-4380 SUBSCRIPTIONS & MEMBERSHIPS000-4390 TRAVEL & TRAINING000-4391 EDUCATION REIMBURSEMENTS000-4400 VEHICLE ALLOWANCE000-4410 REPAIR & MAINT/BUILDINGS000-4420 REPAIR & MAINT/VEHICLE000-4430 REPAIRS & MTNCE./EQUIPMENT000-4480 FEES FOR SERVICE000-4540 INTERNAL RENTAL - VEHICLE000-4610 VEHICLES000-4630 EQUIPMENT - OFFICE000-4730 BUILDING IMPROVEMENT Council Packet Page Number 71 of 75 G2, Attachment 1 t d 50 50 0.00 Prc 44.97 Use Page: Page: 0.000.000.00 Balance 0.000.000.0012,476,489.1144.970.0012,476,489.11 Year-to-date Encumbrances 0.000.00 Year-to-date Expenditures 0.000.00 10,197,280.8910,197,280.8910,197,280.8910,197,280.89 Expenditures d 0.000.00 uste j CITY OF MAPLEWOOD Ad 22,673,770.0022,673,770.00 1/1/2021through6/30/2021 Expenditure Status Report Appropriation h 6 g Grand Total 9:46AM GENERAL FUNDTRANSFERS TRANSFERSGENERAL FUND Total Total ccount Number Periods: 0 throu expstat.rpt07/19/2021101999 A 000-4999 TRANSFERS OUT Council Packet Page Number 72 of 75 G3 Council Packet Page Number 73 of 75 G3 Council Packet Page Number 74 of 75 G3, Attachment 1 Council Packet Page Number 75 of 75