COUNCIL MEETING AGENDA Monday, August 14, 2023 - 7:00PM I. II. Call to Order Reflection and Pledge of Allegiance III. Roll Call: M. Heckmann, J. Maloney, R. Astor, N. Kovach, W. Oates, M. Randazzo, D. Swisher, D. Baumgarten, E. O'Malley, D. Biondo, K. Truver, P. Vietmeier, J. Trant. IV. Approval ofMinutes - July 24, 2023 and August 7, 2023 V. Public Comments Agenda Items Only- - VI. Bid Openings VII. Public Hearings VIII. Civil Service Commission IX. Real Estate Tax Collector July Report X. Council Committee Reports A. Public Relhtiom/Communications - Discussion: Garbage Accommodation for Disabled Residents Police Department Fines and Fees Report; Department Accreditation; Swearing in of Officer Rebholz; Mayor Baumgarten to receive the. Abbie. Montecalvo Award for Longevity of Service E. Community Activities/Planning: & Codes - Real Estate Transfer Tax Report; Violations Report B. Buildings & Grounds/Public Works C. Public Safety/Fire D. Finance - July Finance Report F. Library G. MRTSA H. Associations . South Hills Area Council of Governments (SHACOG) I. Police Pension - Account Statement April-June 2023 J. Non-Uniformed Pension Account Statement. April-June 2023 Motion to. Approve Castle Shannon Library Sign Quote Through COSTARS CONNECT Solar Energy Feasibility Study Presentation ii. Allegheny County Borough's Association/Allegheny League ofl Municipalities (ACBA/ALOM) XI. Manager's Report- Ratification to rebid Contract 23-PK10- -I Lower Hamilton Park Multi-Purpose Structure Installation Bid Report for Contract No. 23-R03 - 981 Castle Shannon Boulevard Parking Lot Improvements Motion to Accept Resolution to opt-in for the Allegheny County CDBG/HOME programs Motion to Award Contract from SHACOG: 2023. Joint Bid for Solid Waste XII. MS4 XIII. Mayor's Report XIV. Planning Commission XV. Solicitor's Report XVI. Keystone Oaks XVIII. Other Business XIX. Adjournment XVII. Public Comment Period - Any Open Items SACherylGreen Boasgz4aganleAugpat 20231GENDA.doc CASTLE SHANNON BOROUGH MINUTES OF REGULAR MEETING July 24,2023 The following elected officials were present: M. Heckmann, J. Maloney; R. Astor; N. Kovach; B. Oates; M. Randazzo; D. Swisher; D. Baumgarten; E. O'Malley. The following appointed officials were present: P. Vietmeier, Codes Official; D. Biondo, Solicitor; J. Stanton, Borough Minutes: The minutes of the July 10, 2023 council meeting were presented. Ms. Randazzo motioned to approve the: minutes. Mr. Maloney seconded; all in favor; motion carried. Public Comment - Agenda Items: Mr. Heckmann opened the public comment section on Bid Openings: Mr. Heckmann presented three written quotes for a generator at the public works garage. Ms. Kovach motioned to accept the proposal from the lowest responsible bidder - McGervey Electric Inc. for $13,240.00. Mr. Astor seconded; all in favor; motion carried. Albert Pasquarelli, Public Sector Area Manager for Waste Management and Mike Liscinski of Westmoreland Sanitary Landfill LLC attended the meeting to discuss their proposals for trash Mr. Pasquarelli noted that many businesses are struggling with labor issues and as such, Waste Management is moving towards automated (cart loaded) trash collection. Waste Management submitted options for either traditional manual collection or automated. Each household would receive a 96-gallon trash cart and a 64-gallon recycling cart. Only items in the cart would be collected. Two bulk items can be put out once a month on designated bulk item days. Residents have the option of contacting Waste Management for additional bulk pickups and pay for the items to be collected. Billing can, be done on a per household per unit per month basis or per ton basis. Families have the option to contract through Waste Management for additional carts at their cost. The one cart system may prompt more people to recycle. Glass recycling is once again included in the comingled recycling stream. Waste Management would work on educating the public on the new automated system which would start in April of 2024; and they believe the automated process is quicker, more efficient, and causes less injuries to their Ms. Kovach questioned if numbers 1-5 can be recycled for plastics and glass. Mr. Pasquarelli answered plastics numbered 1-5 can be recycled, and glass can also be recycled. Paul Vietmeier questioned if the cart lids must be closed and noted a business that was denied collection due to overflowing the dumpster. Mr. Pasquarelli answered that businesses should be using the correct size dumpster for their needs. Ideally, residential carts should have the lid Engineer. Police ChiefK. Truver was absent. agenda items. Being none, the public comment section was closed. collection through the SHACOG Solid Waste Contract. employees. closed. Minl Bob Sutton questioned if smaller carts were available. Mr. Pasquarelli answered that each household would use the standard 96 gallon for two months before given the option (once) to Annie Shaw questioned what would happen if the trash company broke the can. Mr. Pasquarelli said that either the municipality purchases the carts for residents or Waste Management would provide the carts; but ifdamaged, the cart would bei replaced by the contractor at no charge. Bill Reffner questioned if residents could use their own carts. Mr. Pasquarelli said no, residents must use the standard designated carts that are compatible with the truck. Old trash containers David Seiler asked ifthe automated system has been used in the wintertime with excessive snow and cars parked on the street. Mr. Pasquarelli stated it is tough, but it does work. Ms. Miller questioned how the cart system would work with homes with multiple sets of steps between the house and road/sidewalk. Mr. Pasquarelli answered that they will address this situation and find a way to work with those types of residents. Mr. Pasquarelli concluded stating that the carts make the municipality look more uniform, and there are no longer open bags of Mike Liscinski distributed a handout with background information about Noble Environmental, the company who owns and operates Westmoreland Sanitary Landfill. Westmoreland is proposing manual collection and does not believe that automation is the way to go in certain communities in Southwestern Pennsylvania. Mr. Liscinski provided al breakdown ofi rates based on a per unit pricing. Although the bid specifications allow for up to 5 bags of trash per residence, the hauler would collect up to 15 bags at no additional cost to the resident. In the bid specifications, glass recycling is included, and residents can put out two bulk items on a designated week each month. Westmoreland identified Castle Shannon as ai municipality that the automated system would not work well due to the hills and tight streets and low power lines. Mr. Liscinski noted that labor shortage is not an issue for their company, and employee retention is good. Trucks would be coming from Belle Vernon. Calculating the per unit pricing that was submitted, Mr. Liscinski stated that the borough would save $264,000 over the life of the contract with Westmoreland versus Waste Management, not including the cost oft the carts to the Mr. Heckmann thanked Mr. Pasquarelli and Mr. Liscinski for addressing council and the public at this meeting. Council will be deciding on the solid waste contract in August. Real Estate Tax Collector: Due to COVID, Ms. O'Malley noted that Keystone Oaks School District Real Estate Taxes were mailed last week. A 2% discount is offered if paid by August change to a smaller cart. could be recycled. Carts would be distributed by Waste Management. trash attracting rodents and animals. municipality. 31St. Council Committee Reports mM2 Public Relations/Communications - Mr. Heckmann stated that council met in executive session prior to this meeting to discuss the borough manager search. Applications are being received, and Mr. Heckmann encouraged interested candidates to apply. Building & Grounds/Public Works = Mr. Maloney reported that the public works crew completed exterior painting at the borough garage and is painting the exterior of the Vitte's building. A few sewer issues were discovered and were resolved. Mr. Heckmann thanked Bob Ausman, Public Works Foreman, for keeping his eyes on the ground and reporting to thel borough engineers on various projects in the borough. Public Safety/Fire: Fire Chief William Reffner presented the July incident report of 26 fire calls - 21 in Castle Shannon, 1 in Baldwin Township, and 4 mutual aid/out of town. CSVFD crews did a great job on two confirmed structure fires that were contained to ai room: and contents fire. ChiefReffner believes the fire on Middleboro was due to a lithium battery being plugged in overnight. Overcharging of lithium batteries is a serious concern for firefighters as they can CSVFD conducted in-house training on July 10th for hose line dvancemenmangemen with cause fires. nozzle pressure and on July 17h to critique two residential structure fires. Two new applications for membership are being reviewed. Bob Sutton, CSVFD President, was pleased to report that a six-minute recruitment and retention video is completed and on the new website. Mr. Sutton thanked Bob Astor for his cameo Mr. Sutton explained that Lora Howard has been working as administrative assistance for the fire department for almost 30 years. When the pandemic arrived, Ms. Howard started working remotely and has since moved to Conneaut. The fire department felt that it was necessary to have an employee in-house and has therefore hired Lori Williams as of August Ist. Ms. Williams is a member of the fire department and is Firefighter 1 and Firefighter 2 certified along with being EMT certified. Ms. Williams is currently completing her emergency vehicle training course. Ms. Williams will be available to join a volunteer on a rig and respond to calls received during the day. A future goal is to get Ms. Williams qualified on the apparatus to get on scene The Castle Shannon Volunteer Fire Department's mini-carnival will be July 26-29 from 6 pm to dark. Rides will be provided by Reinhart Amusements. Live bands are scheduled for Thursday, Friday, and Saturday. A community business vendor show, car raffle drawing, and fireworks Ms. Astor stated that the police department is working with the interim manager on a resolution for the animal control contract. In addition, the police department is sending out information on the Ring Network for notices advising residents to keep their car doors locked as there has been Finance: Mr. Swisher reviewed the check register for. July 14th and had no further questions. Ms. Kovach questioned an expenditure for the Mainstreet conference in the. July 24th check appearance in the video. quickly, establish command, and report to county dispatch. will be held on Saturday. an uptick in car burglaries in local neighborhoods. w3 3 register. Ms. Miller explained the conference was the PA Downtown Conference heldi in Scranton, PA. There being no further questions, Mr. Maloney motioned to approve the July 14th Library - Ms. Randazzo reported that the library isi in full gear with the summer reading Ms. Randazzo was proud to announce that the library is listed in the Pittsburgh City Paper Best ofPittsburgh Readers Poll for 2023. Patrons can place a vote for our library as Pittsburgh's Best Tiny Free Library under the People & Places category. More information is available on the Ini the back oft the library is a Little Free Pantry for anyone who wishes to donate or needs pantry Friends oft the Library will hold an informational meeting on August gth at 7 pm for patrons to SHACOG - Mr. Oates reported that the SHACOG GolfOuting was a success. He plans to Manager: Ms. Puff introduced Jason Stanton from Lennon, Smith, Souleret Engineering to discuss new library signage. Mr. Heckmann explained that this is part ofthe wayfinding signage project. The sign will have a digital LED board to list their many events and programs. Mr. Stanton presented two options for the sign with two different dimensions and two different facing options from a COSTARS vendor. A prevailing wage rate request will be provided to the vendor to provide a formal quote. Mr. Heckmann noted that the LED screen would not be using Ms. Randazzo questioned whether both face options are available on the smaller sign. Mr. Stanton answered the revised quote allows the ability to still customize the sign without the flexibility of rolling banners. Ms. Randazzo questioned whether software training for the staff Mr. Swisher asked about the savings for the smaller sized sign. Mr. Stanton answered approximately $5,000; however, confirmation of prevailing wage will be factored in the formal Annie Shaw asked if council was going to vote to approve the sign without a formal quote. Mr. Heckmann answered that council would approve to advance the diligence subsequent to the Bryan Gigliotti asked if there would be a difference in screen size capabilities between the two sized signs. Mr. Heckmann answered that the two different sizes signs have different specs. Mr. Stanton added that the sign is customizable to add lines, however the fonts would be smaller. check register. Ms. Randazzo seconded; all in: favor; motion carried. programs for both adults and children. library's website. items. get more information on this group and ways they support our library. attend the next meeting in Green Tree. bright colors or high contrast images, as this is ai residential street. would bei included in the pricing. Mr. Stanton answered yes. quote. wage determination. Council is deciding which scope to perfect. 4 win 4 Paul Salvayon asked if the sign would conform to the borough's zoning ordinance for signs, specifically for illumination. Mr. Vietmeier answered that the sign would have to meet the Ms. Randazzo motioned to continue diligence on the smaller sign format to receive a final quote Mr. Heckmann stated that the borough participated in a free solar study on municipal buildings in the borough with a firm hired by CONNECT. The agenda contained information on PA Solar Center's completed assessments on the municipal center, library, public works garage, the fire department buildings, and a car port array for 981 Castle Shannon Boulevard (Vitte's). The Engineer: Mr. Stanton presented information regarding the July 13, 2023 Work-in-Progress Report for Castle Shannon Borough projects. Mr. Stanton stated that contracts were awarded to Mele & Mele on the 2023 Road Improvement Programs and construction will be starting in August. Paving Contract No. 23-PK-6 (Rebid) was awarded to A. Folino Construction. Bid opening for Vitte's parking lot paving will be. August 10th with three different paving options. A new MS-4 permit was received. The pollution reduction plan stream restoration work on Saw Mill Run has been completed with plantings. A retainage is being held to ensure plantings take root. Since the borough received grant funding through PADEP Growing Greener that covered the construction cost for this project, LSSE is working on amending the grant agreement for a $150,000 Gaming Economic Development Tourism Grant through Allegheny County from the An ALCOSAN GROW grant application was submitted for $563,000 for the Killarney sewer- shed and Hamilton Park sewer-shed for the Phase II Consent Order for source flow: reduction and Group 11 Parks oft the parks plus master plan has been completed at Prospect Park, Myrtle Parklet, and the library, with the exception oft the shade sail issue. The vendor will be doing a site visit for the shade sails and will make a recommendation to increase the shade area. Mr. Stanton Group 2 Parks - Lower Hamilton Park - the design was received by Romtec, and the building permit was received for the multi-purpose structure for a kitchen, restrooms, pavilion, and storage. The contract for assembling the building will be advertised in August. A preconstruction meeting was held with the vendor for turf, lighting, fencing, and trails. Keystone Sports Construction anticipates being in the borough the end of August. Duquesne Light finally disconnected power to the park sO that the contractor can begin site and utility work. Mr. Stanton presented three variations for an earthen retaining wall with similar costs. A lengthy discussion continued. Mr. Swisher believes the retaining wall should extend further along Terrace, and Mr. Stanton will review the site. Council agreed that the earthen wall was brightness restriction, and the text cannot be flashing or blinking. for council's approval. Mr. Maloney seconded; all in favor; motion carried. study included a cash flow analysis for each building. Saw Mill Run project to the parks' projects. relocation of storm and sanitary sewers in the park. agrees that the area needs works. aesthetically pleasing. m5 Group 3 Parks - Upper Hamilton Park - the sewage planning facilities module will be approved soon that will allow for construction to start on the splash pad that had been ordered. A public bathing permit will be filed with Allegheny Health Department to operate the splash pad. The play structure was ordered. June 15t. Grading for site is included in the lower park contract. Mr. Stanton presented a portion of Fountain Street deteriorating from a rain event. A recommendation from the Allegheny Connector Study was to construction a pedestrian corridor connecting the downtown area to the parks utilizing Fountain Street. Mr. Stanton presented design options for the step construction that will also reinforce the street. Mr. Heckmann noted that the expenditure of steps from the park to Fountain Street is covered under the bond issuance. The Fountain Street Steps and Mindful Brewery Stairs/Wall would be add alternates to Contract No. 23-PK-12 for Trails and Splash pad concrete. To economize on the project, Mr. Heckmann asked Mr. Stanton to determine if the area from Fountain Street to Shady Run could support a LSSE is getting a COSTARS quote for Wayfinding System Phase 2 for post mounted signs for secondary entrance, vehicular directional, park identification, park directional, and destination identification along with primary entrance signs which require a PennDOT Highway Occupancy Surveys have been completed for a multi-modal grant application for sidewalks on Smith Street Bridge, Killarney, and Sleepy Hollow. Mr. Swisher asked about the railroad's involvement with the Sleepy Hollow sidewalk under the trestle. Mr. Stanton answered that there will be some Ms. Kovach questioned activity regarding PennDOT's bridge on Castle Shannon Boulevard. Mr. Stanton advised that Verizon has moved their conduit lines under the bridge which will Mayor's Report: Mayor Baumgarten attended the Pennsylvania Mayor's Association Conference where Dr. Seth Goldstein, Faculty Member oft the Department of Computer Science Ms. Kovach congratulated Mayor Baumgarten for receiving the Abbie Montecalvo Award for sidewalk to Route 88. Permit. coordination with the railroad. allow PennDOT to move: forward on the bridge repairs and streetscape. at Carnegie Mellon discussed AI(Artificial Intelligence). longevity of service for his work in the community of Castle Shannon. Public Comment: Bryan Gigliotti, Poplar Avenue - reported that CSYA tournaments have concluded for 2023. It was a very exciting season for the participants. Many positive comments were received about the venue, the fields, and management oftournaments by CSYA volunteers. The CSYA Golf Outing is seeking business sponsors for banners, team, and hole sponsorships. Two new businesses are participating: Apples to Rainbows and Miller Mulligans. Mr. Gigliotti said that he will be taking a turn in the dunk tank on Wednesday at the CSVFD carnival. mil Last Friday the CSVFD sponsored a pizza day and brought the dunk tank for the Summer Recreation Program. Thanks to Jeremy Emph, Rich Kessler, and Shane Dodd for providing the tank for the children. The last day of the Summer Recreation Program will be July 27th. The program was a great success. It was very wonderful to see the community come together to support the program. Myrtle Avenue PFO donated two pizza days. The CSYA sponsored a Kona Ice and pizza day. McGervey Electric donated dilly bars. Community Library donated a Kona Ice day. Everyone is excited about returning to the new and improved Hamilton Park for next year's program. Ms. O'Malley added that many parents (when paying their taxes) tell her Annie Shaw, Glen Shannon Drive - inquired about a discrepancy regarding the sale price for the Vitte's property. The Allegheny County Real Estate website lists a price of $600,000. Mr. Heckmann explained that the borough paid $500,000 for the property, and one parcel valued at how wonderful the program is for the children. $100,000 was donated. Mr. Heckmann closed the public comment section. Other Business: Nothing to report. Mr. Astor motioned to adjourn. Mr. Swisher seconded; all in favor; motion carried. Approved as presented this 14th day of August 2023. John) K. Trant Jr. Interim Manager Mark J. Heckmann Council President mn 7 7 CASTLE SHANNON BOROUGH MINUTES OF SPECIAL MEETING August 7, 2023 The following elected officials were present: M. Heckmann, J. Maloney; R. Astor; N. Kovach; B. Oates; M. Randazzo; D. Swisher; D. Baumgarten. Tax Collector E. O'Malley was absent. The following appointed officials were present: D. Biondo, Solicitor; J. Stanton, Borough Engineer; J. Trant, Interim Manager. Police Chief K. Truver and Codes Official P. Vietmeier Public Comment - Agenda Items: Mr. Heckmann stated that this evening's session was advertised as a special session to review and discuss the results of the SHACOG 2023 Joint Bid for Solid Waste Collection. Mr. Heckmann opened the public comment section on agenda items. Mayor Baumgarten commented that council received a letter from Waste Management that debated the quote by Westmoreland, and hel believes that was unethical. Mayor Baumgarten also asked the manager ifh he had analyzed the bids and had a recommendation. Mr. Trant answered that he conducted an in-depth analysis of the extensive bid results from SHACOG, and provided al list of options for council's consideration, but not a specific vendor. Mr. Heckmann noted that council will not be voting this evening, and the item on the agenda is for discussion only. Mr. Heckmann also stated that both vendors contacted borough officials after the meeting via mail or Jerry Coombs - asked for a brief synopsis of the last council meeting on this subject. Mr. Heckmann stated that both Albert Pasquarelli, Public Sector Area Manager for Waste Management and Mike Liscinski of Westmoreland Sanitary Landfill LLC attended the meeting to discuss their proposals for trash collection through the SHACOG Solid Waste Contract. were absent. email to clarify information. The public comment section was closed. Bid Openings: Mr. Heckmann reiterated that council is meeting to discuss, but not vote, on the SHACOG 2023 Joint Bid for Solid Waste Collection, Removal and Disposal Services. The contracts are proposed for five-year terms. Both proposals are very expensive compared to our current contract. Council will be weighing options for how garbage is collected, and what is in the best interest oft the community long-term on how much waste is generated, how we are billed, Ms. Kovach questioned the bidding process through SHACOG and asked if the borough was choosing a vendor as a member of SHACOG. Mr. Heckmann noted that in previous years there may have been only one bidder for solid waste. For the current bid opening, there were two vendors. Every community can choose for themselves; however, through SHACOG the borough receives bulk bidding prices. Mr. Trant explained that SHACOG provides the bidding process Mr. Trant has provided council with several emailed information on the schedule. A decision needs to be made by August 19th. Mr. Trant has also provided council with notes on individual meetings with the vendors, and information provided directly from the vendors. the aesthetics of waste collection in our borough, etc. and results, and council chooses the best vendor for their municipality. w8 Council also received a multi-tab excel spreadsheet with information and the extremely complex SHACOG bid tabulation with a multitude of options. Policy decisions need to be made by council for the type of service provided to residents, then follow up decisions in terms of For this evening's discussion, Mr. Trant provided information and estimated pricing on automated or manual collection by unit or by tonnage. Waste Management is focusing on automated cart collection, while Westmoreland is focused on manual collection. Mr. Heckmann clarified that automated is one worker on a truck that can load a lidded bin that is standardized with a mechanical lift, and manual is two workers in a truck picking up cans/bags by hand. Mr. Trant explained that automated requires standardized carts either purchased by the municipality Mr. Trant provided estimated costs for a year one increase and five-year contract totals and discussed each option and cost. Mr. Trant noted that Westmoreland did not submit a bid for tonnage disposal, was the higher bid for automated collection, and was low bidder for manual Mr. Coombs questioned if the carts would be provided by the vendor, municipality, or resident. Mr. Heckmann answered that the standardized carts can be provided by either the municipality ort the vendor. Ifa resident wants an additional cart, that cost would be billed by the hauler to the resident. Mr. Trant added that garage-door pickup would also be an extra charge to the resident. Mr. Swisher noted that the representative from Waste Management who attended the July 24th council meeting had stated that their company will make it work for residential streets that cannot utilize automated pickup. Mr. Astor listed concerns that residents may stockpile garbage Mr. Trant stated that bulk pickup would be one week ai month with two items per. household. Council had a lengthy discussion on whether to use cart automated collection or continue with manual collection. The borough currently uses manual collection and pays per tonnage which can be abused by people disposing of business trash and excess yard waste. The shift to carts means that trash that is not in the cart will not be collected, other than collections on selected Ms. Kovach questioned if data could be obtained from municipalities regarding the reduction in tonnage amounts when changing to automated cart collection. Mr. Trant will ask the vendor for this data. This data could determine whether the borough will pay by tonnage or by unit. Mr. Heckmann discussed the benefits of carts: they deter pests and rodents, are aesthetically more pleasing that piles of trash bags, and keep trash out of the street from storms. The standard carts are 96 gallons; however, residents may have a one-time option to downsize to a smaller cart. Mr. Oates and Mr. Maloney both stated that they are in favor ofa cart system. recycling and carts. or provided by the vendor. collection. until large pickup collections ori illegal dumping may increase. bulk pick up days. mia9 2 The majority of council agreed that an automated cart system would be the preferred collection method for the contract with the cart provided by the vendor. Some manual collection may still Billing by tonnage or by unit will be decided once additional information is obtained regarding a ber required on certain streets. possible reduction in current tonnage when migrating to a cart system. Mr. Heckmann closed the public comment section. meeting to discuss the manager search. Other Business: Mr. Heckmann reported that council met in executive session prior to this Mr. Astor motioned to adjourn. Mr. Swisher seconded; all in favor; motion carried. Approved as presented this 14th day of August 2023. John K. Trant Jr. Interim Manager Mark J. Heckmann Council President ID yia 3 TAXING DISTRICT: CASTLE SHANNON BOROUGH TAX COLLECTOR'S REPORT TO TAXING DISTRICTS PREPARED ON: 08/07/2023 FOR TAX YEAR 2023 FOR THE PERIOD: 07/01/2023 TO 07/31/2023 REAL ESTATE 282,531.91 .00 .00 282,531.91 24,642.16 .00 .00 .00 257,889.75 24,642.16 2,384.07 .00 27,026.23 INTERIM/OTHER PER CAPITA A. COLLECTIONS Balance Collectable Additions: During the Period Deductions: Credits during the Period Total Collectable LESS: Face Collected for the Period LESS: Deletions from the List LESS: Exonerations LESS: Liens/Non-Lienable Installments BALANCE COLLECTABLE - END OF PERIOD B. RECONCILIATION OF CASH COLLECTED Face Amount of Collections Plus: Penalties Less: Discounts Total Cash Collected per Column TOTAL CASH COLLECTED C. PAYMENT OF TAXES .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 27,026.23 27,026.23 .00 27,026.23 Amount Remitted During the Period (SEE ATTACHED SCHEDULE) Amount Paid with this Report Applicable to this Reporting Period TOTAL REMITTED THIS PERIOD List Other Credit Adjustments (SEE ATTACHED SCHEDULE) .00 .00 Interest Earnings (if applicable) TAXING DISTRICT USE (OPTIONAL) Carryover from Previous Period $ Amount Collected this Period $ Less Amount Paid this Period $ Ending Balance $ Tax Collector Date IV verify this is a complete and accurate reporting of the balance collectable, taxes collected and remitted for the period. Received by (taxing district): Title: Date: Ia acknowledge the receipt of this report. TCI TAXING DISTRICT: CASTLE SHANNON BOROUGH TAX COLLECTOR'S REPORT TO TAXING DISTRICTS PREPARED ON: 08/07/2023 FOR TAX YEAR 2023 FOR THE PERIOD: 07/01/2023 TO 07/31/2023 SUPPORTING SCHEDULE FOR PAYMENT OF TAXES DEPOSIT DATE 07/25/2023 ** TOTAL: REAL ESTATE COLLECTED 27,026.23 27,026.23 PER CAPITA COLLECTED TOTAL COLLECTED 27,026.23 27,026.23 .00 .00 TL2 TAXING DISTRICT: CASTLE SHANNON BOROUGH TAX COLLECTOR'S REPORT TO TAXING DISTRICTS PREPARED ON: 08/07/2023 FOR TAX YEAR 2023 FOR THE PERIOD: 07/01/2023 TO 07/31/2023 SUPPORTING SCHEDULE FOR ASSESSMENT ADJUSTMENTS NET CHANGE VALUATION NET TAX CHANGE PARCEL NO. OWNER NAME DATE TOTAL ADDITIONS: TOTAL DELETIONS: TOTAL EXONERATIONS: ** TOTAL CREDITS: 0 0 0 0 0 0 .00 .00 .00 .00 .00 ** TOTAL EXEMPTION ADJUSTMENTS: Tc3 TAXING DISTRICT: CASTLE SHANNON BOROUGH TAX COLLECTOR'S REPORT TO TAXING DISTRICTS PREPARED ON: 08/07/2023 FOR TAX YEAR 2023 FOR THE PERIOD: 01/01/2023 TO 07/31/2023 REAL ESTATE 4,067,670.95 .00 .00 408.67 4,068,079.62 3,810,189.87 .00 .00 .00 257,889.75 3,810,189.87 2,679.39 71,314.84 3,741,554.42 INTERIM/OTHER PER CAPITA A. COLLECTIONS Balance Collectable Additions: During the Period Deductions: Credits during the Period Adjust for Refunds during the Period Total Collectable LESS: Face Collected for the Period LESS: Deletions from the List LESS: Exonerations LESS: Liens/Non-lienable Installments BALANCE COLLECTABLE - END OF PERIOD B. RECONCILIATION OF CASH COLLECTED Face Amount of Collections Plus: Penalties Less: Discounts Total Cash Collected per Column TOTAL CASH COLLECTED c. PAYMENT OF TAXES .00 .00 .00 .00 .00 622.79 .00 .00 .00 622.79 622.79 .00 .00 622.79 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 3,742,177.21 3,742,177.21 3,742,177.21 Amount Remitted During the Period (SEE ATTACHED SCHEDULE) Amount Paid with this Report Applicable to this Reporting Period .00 TOTAL REMITTED THIS PERIOD List Other Credit Adjustments (SEE ATTACHED SCHEDULE) .00 .00 Interest Earnings (if applicable) TAXING DISTRICT USE (OPTIONAL) Carryover from Previous Period $_ Amount Collected this Period $ Less Amount Paid this Period $ Ending Balance $ Tax Collector Date I verify this is a complete and accurate reporting of the balance collectable, taxes collected and remitted for the period. Received by (taxing district): Title: Date: Ia acknowledge the receipt of this report. TC4 TAXING DISTRICT: CASTLE SHANNON BOROUGH TAX COLLECTOR'S REPORT TO TAXING DISTRICTS PREPARED ON: 08/07/2023 FOR TAX YEAR 2023 FOR THE PERIOD: 01/01/2023 TO 07/31/2023 SUPPORTING SCHEDULE FOR PAYMENT OF TAXES DEPOSIT DATE. 02/22/2023 02/24/2023 02/24/2023 02/24/2023 02/28/2023 03/01/2023 03/01/2023 03/01/2023 03/03/2023 03/04/2023 03/07/2023 03/08/2023 03/11/2023 03/16/2023 03/16/2023 03/20/2023 03/22/2023 03/22/2023 03/24/2023 03/29/2023 03/31/2023 03/31/2023 03/31/2023 04/05/2023 04/05/2023 04/05/2023 04/08/2023 04/08/2023 04/10/2023 04/10/2023 04/12/2023 04/12/2023 04/12/2023 04/14/2023 04/14/2023 04/14/2023 04/14/2023 04/15/2023 04/15/2023 04/15/2023 04/15/2023 04/15/2023 04/15/2023 04/15/2023 REAL ESTATE COLLECTED 37,027.39 45,173.55 72,975.11 69,217.67 27,599.72 21,914.78 144,981.59 116,508.90 40,135.91 45,080.08 48,527.88 52,417.28 110,972.76 56,195.10 38,242.61 77,438.49 34,190.15 38,685.88 79,667.08 22,762.96 55,437.23 228,470.07 53,335.40 50,177.67 42,245.20 39,337.80 35,027.03 95,842.89 50,807.85 94,007.51 64,763.93 169,975.52 47,323.26 66,800.29 70,049.85 49,071.38 86,772.76 88,579.30 262,566.63 72,137.73 72,129.07 56,403.45 65,020.59 52,223.24 PER CAPITA COLLECTED TOTAL COLLECTED 37,027.39 45,173.55 72,975.11 69,217.67 27,599.72 21,914.78 144,981.59 116,508.90 40,135.91 45,080.08 48,527.88 52,417.28 110,972.76 56,195.10 38,242.61 77,438.49 34,190.15 38,685.88 79,667.08 22,762.96 55,437.23 228,470.07 53,335.40 50,177.67 42,245.20 39,337.80 35,027.03 95,842.89 50,807.85 94,007.51 64,763.93 169,975.52 47,323.26 66,800.29 70,049.85 49,071.38 86,772.76 88,579.30 262,566.63 72,137.73 72,129.07 56,403.45 65,020.59 52,223.24 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 00 00 .00 .00 -00 .00 -00 .00 .00 .00 .00 .00 .00 .00 .00 .00 TC5 TAXING DISTRICT: CASTLE SHANNON BOROUGH TAX COLLECTOR'S REPORT TO TAXING DISTRICTS PREPARED ON: 08/07/2023 FOR TAX YEAR 2023 FOR THE PERIOD: 01/01/2023 TO 07/31/2023 SUPPORTING SCHEDULE FOR PAYMENT OF TAXES DEPOSIT DATE 04/15/2023 04/15/2023 04/15/2023 04/28/2023 04/30/2023 04/30/2023 05/13/2023 05/31/2023 05/31/2023 06/10/2023 06/15/2023 06/30/2023 07/25/2023 ** TOTAL: REAL ESTATE COLLECTED 61,424.00 91,728.50 93,146.05 45,585.06 51,823.90 622.79 25,719.78 25,738.42 13,885.48 63,193.73 66,783.64 26,870.42 27,026.23 3,741,768.54 PER CAPITA COLLECTED TOTAL COLLECTED 61,424.00 91,728.50 93,146.05 45,585.06 51,823.90 622.79 25,719.78 25,738.42 13,885.48 63,193.73 66,783.64 26,870.42 27,026.23 3,741,768.54 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 TLG TAXING DISTRICT: CASTLE SHANNON BOROUGH TAX COLLECTOR'S REPORT TO TAXING DISTRICTS PREPARED ON: 08/07/2023 FOR TAX YEAR 2023 FOR THE PERIOD: 01/01/2023 TO 07/31/2023 SUPPORTING SCHEDULE FOR ASSESSMENT ADJUSTMENTS NET CHANGE VALUATION NET TAX CHANGE PARCEL NO. OWNER NAME DATE TOTAL ADDITIONS: TOTAL DELETIONS: TOTAL EXONERATIONS: ** TOTAL CREDITS: 0 0 0 0 0 0 .00 00 .00 .00 .00 ** TOTAL EXEMPTION ADJUSTMENTS: TC7 CASTLE SHANNON POLICE DEPARTMENT FINES AND FEES REPORT MONTH OF July 2023 District Court Fines $ 2.887.02 District Attorney Fines_ $ 547.97 Parking Citations Report Fees $ 370.00 $ 225.00 Solicitor Permits $ 00.00 00.00 00.00 Animal Control Fines $ Pawn Broker's License $ Pawn Outstanding $ Alarms Billed $ Mr Magic 00.00 100.00 $100.00 Alarm Fines Received $ 300.00 Alarms Outstanding $ 00.00 Special Services From: ChiefKenneth Truver pSf Castle Shannon Police 2023 DJ Fines DATE State JAN FEB MAR APR MAY JUN JUL AUG SEPT OCT NOV DEC Alleg. Co DA (DUI) DJ-05-2-17 $523.61 $1,055.12 $993.95 $1,178.51 $989.56 $488.72 $547.97 $4,072.55 $3,296.19 $5,714.28 $3,022.81 $3,380.61 $3,755.40 $2,887.02 1391.8 $1,391.80 x2 Kenneth M.Truver, Chief of Police $5,777.44 $26,128.86 p5f Pennsylvania Law Enforcement Accreditation Commission ofthe. Pennsylvania Chiefs ofPolice. Association 3905 North Front Street, Harrisburg, PA17110 Phone (717). 236-1059 Fax (717) 236-0226 www.pachie/s.0rg August 1, 2023 Kenneth Truver ChiefofPdlice Castle Shannon Police Department 3310 McRoberts Road Castle Shannon, PA 15234 Dear ChiefTruver: On July 25, 2023, the Pennsylvania Law Enforcement Accreditation Commission unanimously voted to accredit the Castle Shannon Police Department. Allow me to extend my heartiest congratulations on the accreditation of your agency. You have become a member of an elite, but growing group of law enforcement agencies in Pennsylvania who are aj part oft this great Pennsylvania Accreditation Program. As an accredited agency, there are ai few things Iwould like to make you aware oft that may assist you. 1. An annual report is due from each accredited agency every year within 30 days ofyour accreditation anniversary date (which is listed on your most recent accreditation certificate), with the exception of re-assessment years. You can find the annual report form after signing into the secured side oft the accreditation website under PLEAC-Only. Itwill be your responsibility to send your annual report within 30 days ofyour 2. Lapel pins and challenge coins are available and will only be sold to accredited. agencies. Please contact me: at. headquarters ifs you are: interested in purchasing any. Also available are: accreditation service bar pins. These can be purchased online at www.copshop.com. 3. As an accredited agency, we encourage you to display the accreditation logo on) your 4. Ifyoul have received any press foryour recognition as being accredited, we would like you to: forward a copy to us for our files. Wei may also use these in the future to continue accreditation anniversary date. vehicles. See attached for ordering information. our efforts tol bring more agencies on board with thej program. Thank you for being a part of this landmark program in Pennsylvania law enforcement. You have the right to be very proud of your agency and I know you are. We at PCPA look forward to continuing our work with you in the years to come with this and other programs that will assist in the further Please feel free to contact me: at any time if youl have questions regarding. your agency'saccreditation. professionalism ofl Pennsylvania law enforcement. Sincerely, Adams Accreditation RE Program Enclosures P583 Coordinator Ce 3 ARNIA STAR ANABLE ABLE FORCEMEIR Mayor Tom Riel presented Mayor Don Baumgarten with the Abbie Montecalvo Longevity of Service award for 53 years of dedicated service to the Borough of Castle Shannon at the Pennsylvania Mayors Conference in Lancaster-July 2023 PSFY Page: 1 Castie Shannon Borough JULY2023 Include Non-Anticipated: Yes Include Non-Budget: Yes 08/08/2023 11:09AM Revenue. Account Range: 01-00-000-000 to 36-99-999-999 Expend Account. Range: 01-00-000-000 to 36-99-999-999 Print Zero YTD Activity: Yes Revenue Account 01-00-300-000 01-00-301-000 01-00-301-100 01-00-301-300 01-00-301-500 Year To Date As Of: 07/31/23 Current Period: 07/01/23 to 07/31/23 Prior Year: 07/01/22 to 07/31/22 Description GENERAL FUND REVENUES REAL ESTATE TAXES Real Estate Taxes-Current Year Real Estate Taxes-Delinquent Real Estate Taxes-Liened 301 REAL ESTATE TAXES ACT511TAXES Real Estate Transfer Taxes Earned Income Taxes-Current Eamed Income Taxes-Prior Earned Income Taxes-Delinquent Local Services Tax Local Services Tax- Prior Year Local Services Tax- Delinquent Mechanical Device Tax 310 ACT511 TAXES LICENSES AND PERMITS Amusement Permits Cable Television Franchise 321 LICENSES AND PERMITS STREET ENCROACHMENTS FINES Prior Yr Rev Anticipated Curr Rev YTD. Rev Cancel 0.00 0.00 0.00 0.00 0.00 0.00 0.00 331,199.25- 89 0.00 0.00 0.00 1,684.30 41,705.49 0.00 277,592.72 2,817,705.38 0.00 14,349.65 58,015,94 437,571.91 0.00 1,182.23 0.00 0.00 0.00 0.00 73,547.82 572,212.93 0.00 0.00 0.00 0.00 180.00 0.00 Excess/Deficit % Real 0.00 0 0.00 0 0.00 0 78,294.51- 35 0.00 409,493.76- 87 0.00 0.00 0.00 83,906.61 120,000.00 2,827,358.44 3,227,199.14 0.00 96,387.49 120,000.00 384,072.29 1,200,000.00 0.00 22,201.52 6,082.35 0.00 51.10 15,675,00 524,469.75 1,442,500.00 0.00 0.00 39,588.53 160,000.00 39,588.53 160,000.00 6,175.00 0.00 0.00 0.00 0.00 2,743,451.83 3,107,199.14 275,908.42 2,775,999.89 01-00-310-000 01-00-310-100 01-00-310-210 01-00-310-220 01-00-310-230 01-00-310-510 01-00-310-520 01-00-310-530 01-00-310-700 0.00 0,00 67,830.56 0.00 11,623.82 38,005.94 0.00 280.70 16,900.00 0.00 0.00 0 0.00 52,169.44- 57 0,00 762,428.09- 36 0.00 0.00 0 0.00 3,376.18- 77 0.00 46,994.06- 45 0.00 8,000.00- 0 0.00 219.30- 56 0.00 2,900.00 121 0.00 870,287.07- 40 0.00 15,000.00 85,000.00 8,000.00 500.00 14,000.00 01-00-321-000 01-00-321-700 01-00-321-800 0.00 0.00 0.00 0,00 34,797.11 34,797.11 9,335.00 0.00 0.00 0,00 0.00 0 0.00 0 0.00 125,202.89- 22 0,00 125,202.89. 22 01-00-322-820 01-00-331-000 6,000.00 0.00 0.00 0.00 3,335.00 156 0.00 0 FMl ( Page: 2 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue Account 01-00-331-100 01-00-331-110 01-00-331-120 Description District Attorney Fines District Justice Fines PennDot Fines 331 FINES ASSET FORFEITURE INTEREST EARNINGS CHECKING INTEREST EARNINGS PLGIT 341 INTEREST EARNINGS CHECKING BUILDING RENTALS STATE CAPTALOPERATING GRANTS Recycling Performance Grant DARE Program Grant Task Force Police Equipment Prior Yr Rev Anticipated Curr Rev YTD Rev Cancel 488.72 5,548.35 3,755.40 23,241.84 0.00 1,391,80 4,244.12 30,181.99 0.00 0.00 240.24 878.77 0.02 0.14 240.26 878.91 0.00 150.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,934.78 34,429.75 239,278.16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 34,429.75 241,212.94 Excess/Deficit %/ Real 0.00 19,451.65- 22 0.00 16,758.16- 58 0.00 2,608.20- 35 0.00 38,818.01- 44 0.00 0.00 0 0.00 278.77 146 0.00 49.86- 0 0.00 228.91 135 0.00 150.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 4,600.00- 0 0.00 434.78 129 0.00 115,721.84- 67 0.00 2,650.00- 0 0.00 0.00 0 7,403.47 19,819.58 1,446.59 28,669.64 11,000.00 271.37 13.27 284.64 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 1,575.31 198,408.36 355,000.00 0.00 0.00 0.00 195,000.00 0.00 45,000.00 199,983.67 603,750.00 25,000.00 40,000.00 4,000.00 69,000.00 0.00 600.00 50,00 650.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,600.00 1,500.00 2,650,00 0.00 01-00-332-000 01-00-341-000 01-00-341-100 01-00-342-200 01-00-354-000 01-00-354-010 01-00-354-021 01-00-354-022 01-00-354-023 354 STATE CAPITALOPERATING GRAN' STATE SHARED REVENUE Public Utility Realty Tax Act13 County Sales & Use Tax Beverage Licenses Maçellus Shale Impact Fee Foreign Casualty Ins Premium Foreign Fire Ins Premium 355 STATE SHARED REVENUE 01-00-355-000 01-00-355-010 01-00-355-011 01-00-355-044 01-00-355-080 01-00-355-090 01-00-355-120 01-00-355-130 0.00 195,000.00- 0 0.00 45,000,00- 0 0.00 362,537.06- 40 Fina Page: 3 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue Account 01-00-361-000 01-00-361-310 01-00-361-340 01-00-361-500 Description GENERAL GOVERNMENT Planning Commission Fees Zoning Hearing Board Fees Sale of Publications 361 GENERAL GOVERNMENT PUBLIC SAFETY Seatbelt Grant Federally Forfeited Property Police Services Keystone Oaks School Guards Building Permits Safety Occupancy Permits Police/Fire False Alarms 362 PUBLIC SAFETY HIGHWAY AND STREETS Parking Fines Parking Permits Penndot Snow Contract 363 HIGHWAY AND STREETS ANIMAL CONTROL CULTURERECREATION Park Fees 367 CULTURERECREATION MISCELLANEOUS REVENUES Prior Yr Rev Anticipated Curr Rev YTD Rev Cancel 0.00 0.00 0.00 0.00 250.00 0,00 0.00 273.85 0.00 210,00 990.00 0.00 210.00 1,513.85 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25,158.26 169,127.95 1,414.50 21,149.91 7,707.00 38,184.08 0,00 0.00 420.00 620.00 34,699.76 229,081.94 0.00 160.00 0.00 0.00 160.00 0.00 480.00 150.00 630.00 20.00 Excess/Delicit %1 Real 0.00 0 250.00- 50 1,726.15- 14 1,510.00- 40 3,486.15- 30 0.00 0 0.00 0 60,000.00- 0 0.00 109,127.95 282 0.00 22,505.09- 48 0.00 36,815.92- 51 0.00 0.00 0 0.00 380.00- 62 0.00 10,673.06- 96 0,00 0.00 0 0.00 3,845.00- 36 0.00 0.00 0 0.00 15,000.00- 0 0.00 18,845.00- 10 0.00 79.75- 20 0.00 390.00 120 0.00 3,085.00- 61 0.00 2,695.00- 73 0.00 16,239.65 564 Fin 3 0.00 0.00 0.00 500.00 2,000.00 2,000.00 1,564.50 2,500.00 3,564.50 5,000.00 0.00 0.00 0.00 0.00 0.00 60,000.00 60,748.60 60,000.00 22,582.60 43,755.00 44,241.90 75,000.00 0.00 0.00 300.00 1,000.00 127,873.10 239,755.00 0.00 3,115.00 0.00 0.00 3,115.00 12.50 2,390.00 15,550.00 17,940.00 41,723.43 01-00-362-000 01-00-362-010 01-00-362-011 01-00-362-100 01-00-362-101 01-00-362-410 01-00-362-420 01-00-362-500 01-00-363-000 01-00-363-210 01-00-363-220 01-00-363-510 0,00 6,000.00 0.00 15,000.00 21,000.00 100.00 2,000.00 8,000.00 10,000.00 3,500.00 0.00 2,155.00 0.00 0.00 2,155.00 20.25 2,390.00 4,915.00 7,305.00 19,739.65 01-00-365-500 01-00-367-000 01-00-367-300 01-00-380-000 Page: 4 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue Account 01-00-380-100 01-00-380-101 01-00-380-300 01-00-380-350 01-00-380-351 01-00-380-354 01-00-380-400 01-00-380-500 01-00-380-600 Description Surplus Vehicle Sale Tax CerticalonsDupicales Memora/Communty Day Donations Refund/Liability Insurance Baldwin wp/wVorkers Comp Refunds /Workers' Comp. Health Insurance Contribution Flexible Spending Account CARES Act 380 MISCELLANEOUS REVENUES Fire Insurance/Demonton Escrow ICE CASTLE-ANNUAL ASSESSMENT 383 Total K-9 Donations Sale of Boro Property Transfer from Capital Fund Transfer from Sanitary Sewer Fund Transfer From Bond Fund 392 Total Prior Yr Rev Anticipated Curr Rev YTD. Rev Cancel Excess/Deficit % Real 0.00 33,901.00 0.00 6,099.00- 85 978.00 7,468.00 0.00 7,532.00- 50 0.00 0.00 0.00 13,000.00- 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 4,500.00- 0 0.00 0.00 0.00 0.00 0 1,264.14 9,902.75 0.00 3,097.25- 76 386.49 1,263.78 0.00 5,736.22- 18 0.00 0.00 0.00 0.00 0 2,648.63 72,275.18 0.00 23,724.82- 75 0.00 18,908.76 0.00 20,000,00- 0 0.00 1,091.24- 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 100 0.00 0.00 0 0.00 0.00 100 0.00 0,00 0 58,700.00 40,000.00 8,517.25 15,000.00 10,027.00 13,000.00 0.00 0.00 5,979.00 4,500.00 0.00 0.00 9,210.62 13,000.00 116.56- 7,000.00 0.00 0.00 134,040.74 96,000.00 24,562.57 0.00 0.00 20,000.00 24,562.57 20,000.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 150,000.00 0.00 0.00 0.00 150,000.00 0.00 1,008,601.52 1,039,170.13 4,957,239.60 7,090,124.27 2,662.41 4,959,902.01 7,090,124.27 01-00-383-160 01-00-383-500 24,562.57- 18,908.76 0.00 24,562.57- 18,908.76 0.00 0.00 0.00 0.00 150,000.00 0.00 0.00 150,000.00 0.00 0.00 800,101.90 404,020.49 4,987,836.14 0.00 404,020.49 4,987,836.14 0 0.00 01-00-387-100 01-00-391-100 01-00-392-361 01-00-392-362 01-00-392-363 0.00 0.00 0.00 0.00 01-00-394-100 01-00-399-000 TAX. ANTICIPATION NOTE FUND BALANCE FORWARD 00 Total 0.00 0.00 0,00 239,068.23- 77 0.00 2,102,288.13- 70 01-99-999-999 Cancel Revenue. Account GENERAL FUND EXPENDITURES Reven 0.00 0.00 0.00 0.00 0 0.00 2,102,288.13- 70 Fin4 Page: 5 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure. Account Description 01-00-000-000 01-00-400-000 01-00-400-111 01-00-400-112 01-00-400-158 01-00-400-210 01-00-400-320 01-00-400-324 01-00-400-420 01-00-400-460 Prior Yr Expd Budgeted 0.00 0.00 8,749.86 1,249.98 192.00 0.00 15,667.82 408.21 575.00 3,938.14 30,781.01 0.00 51,738.52 3,800.03 298.40 71.60 2,412.59 459.75 0.00 48.05 0.00 750.00 1,218.68 0.00 60,797.62 115,223.00 Current Expd YTD Expended Cancel Balance %Expd 0.00 0.00 0 0.00 0.00 0 0.00 7,291.83 58 0.00 1,041.69 58 0.00 211.20 56 0.00 18.04 82 0.00 4,456.29- 546 0.00 309.59 57 0.00 1,300.00 35 0.00 459,51 92 0.00 6,175.57 80 0.00 0.00 0 0.00 52,076.41 46 0.00 4,119.24 46 0.00 207.38 57 0.00 99.30 29 0.00 2,602.30 42 0.00 640.25 42 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 979.15 35 0.00 1,381.28 54 0.00 0.00 0 0.00 62,105.31 46 GENERAL FUND EXPENDITURES LEGISLATIVE BODY Council Salary Mayor Salary Life Insurance Office Supplies Communication Telephone Dues & Memberships Meetings & Conferences 400 LEGISLATIVE BODY EXECUTIVE Salary Pension Contribution Dental Insurance Optical Insurance Health/Hospital Insurance Life Insurance Vacation Buy Back Office Supplies Mobile Phone Dues & Memberships Meetings & Conferences Vehicle Reimbursement 401 EXECUTIVE 0.00 0.00 17,500.00 2,500.00 480.00 100.00 1,000.00 720.00 2,000.00 6,000.00 30,300.00 0.00 96,900.00 7,650.00 480.00 140,00 4,453.00 1,100.00 0.00 0.00 0.00 1,500.00 3,000,00 0.00 0.00 0.00 2,916.62 416.66 38.40 0.00 0.00 58.40 0.00 913,12 4,343.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,208.17 1,458.31 268.80 81.96 5,456.29 410.41 700.00 5,540.49 24,124.43 0.00 44,823.59 3,530.76 272.62 40.70 1,850.70 459.75 0.00 0.00 0.00 520.85 1,618.72 0.00 53,117.69 01-00-401-000 01-00-401-121 01-00-401-122 01-00-401-152 01-00-401-155 01-00-401-156 01-00-401-158 01-00-401-189 01-00-401-210 01-00-401-324 01-00-401-420 01-00-401-460 01-00-401-461 Fins Page:6 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure. Account Description 01-00-402-000 01-00-402-311 01-00-403-000 01-00-403-114 01-00-403-115 01-00-403-116 01-00-403-158 01-00-403-210 01-00-403-212 01-00-403-260 01-00-403-316 01-00-403-317 01-00-403-318 01-00-403-353 01-00-403-374 01-00-403-400 01-00-403-401 01-00-403-460 01-00-403-500 01-00-403-501 Prior Yr Expd Budgeted 0.00 2,500.00 0.00 4,400.89 2,700.54 9,054.00 24.00 227.05 2,095.65 0.00 1,295,00 349.73 0.00 0.00 0.00 15,089.44 0.00 60.00 1,250.34 0.00 36,546.64 0.00 26,406.83 2,250.00 6,405.50 0.00 35,062.33 Current Expd YTD. Expended Cancel Balance % Expd 0.00 0.00 0 0.00 18,200.00 13 0.00 0.00 0 0.00 3,446.80 58 0.00 895.53 82 0.00 7,814,00 48 0.00 26.40 56 0.00 827.21 59 0.00 126.45 94 0.00 0.00 0 0,00 300.00 80 0.00 500.00 0 0.00 0.00 0 0.00 5,000.00 0 0.00 0.00 0 0.00 11,535.28 52 0.00 0.00 0 0.00 100.00 0 0.00 1,500.00 0 0.00 1,000.00 0 0.00 33,071.67 50 0.00 0.00 0 0.00 17,981.19 49 0.00 1,875.00 58 0.00 8,982.00 40 0.00 0.00 0 0.00 28,838.19 47 Fhle FINANCIAL ADMINISTRATION Auditor Services TAXCOLLECTION Real Estate-Current Fees Real Estate-Delinquent Fees Tax Certlfication/Dupicate Fees Life Insurance Offiçe Supplies Tax Duplicates Tax Office Computer Software Services Wage Tax Collection EIT Assessment Bonds Computer Maintenance Real Estate-Lien Collection Act1Legal Fees Meetings & Conferences Tax Refunds Act 77 Refunds 403 TAX COLLECTION LAW Labor Counsel Services Solicitor Retainer Solicitor Services Civil Service Commission 404LAW 0.00 21,000.00 0.00 8,140.00 5,000.00 15,000.00 60.00 2,000.00 2,200.00 0.00 1,500,00 500.00 0.00 5,000.00 0.00 24,000.00 0.00 100.00 1,500.00 1,000.00 66,000.00 0.00 35,000.00 4,500.00 15,000.00 0.00 54,500.00 0.00 0.00 0.00 938.64 0.00 524.00 4.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 434.11 0.00 0.00 0.00 0.00 1,901.55 0.00 3,974.70 375.00 1,224.00 0.00 5,573.70 0.00 2,800.00 0.00 4,693.20 4,104.47 7,186,00 33.60 1,172.79 2,073.55 0.00 1,200,00 0.00 0.00 0.00 0.00 12,464.72 0.00 0.00 0.00 0.00 32,928.33 0.00 17,018.81 2,625.00 6,018.00 0.00 25,661.81 01-00-404-000 01-00-404-314 01-00-404-316 01-00-404-317 01-00-404-319 Page:7 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 01-00-405-000 01-00-405-141 01-00-405-142 01-00-405-143 01-00-405-144 01-00-405-156 01-00-405-158 01-00-405-210 01-00-405-212 01-00-405-325 01-00-405-341 01-00-405-420 01-00-405-461 Prior Yr Expd Budgeted 0.00 37,000.00 23,353.97 7,643.95 25,769.66 30,040.95 779.80 200.37 1,558.86 1,097.23 1,379.15 325.00 0.00 129,148.94 162,040.00 0.00 0.00 357.70 500.00 0.00 2,000.00 253.03 207,238.00 53,905.69 105,000.00 80.00 2,583.16 7,907.98 46,176.04 100,683.00 102,229.05 125,000.00 213,492.65 560,071.00 0.00 Current Expd YTD Expended Cancel Balance % Expd 0.00 0.00 0 0.00 26,050.00 61 0.00 19,038.45 58 0,00 5,404.32 68 0.00 0.00 0 0.00 9,567.79 62 0.00 837.63 48 0.00 36.65 96 0.00 566.78 62 0.00 670,45- 134 0.00 694,80- 135 0.00 36.85- 107 0.00 0,00 0 CLERASECRETARY Assistant Manager Accounts Payable Clerk Secretary/Par-time Wages Keystone community Coordinator Health/Hospital Insurance Life Insurance Office Supplies Forms Postage Advertising Meetings & Conferences Mileage Reimbursement 405 CLERNSECRETARY PERSONNEL ADMINISTRATION Employee Hiring Costs Asst Mgmt-ICMA Pension/Retirement FICA Ambulance Subscriptions Employer FSA Contributions Payroll Service Insurance & Bonding Workers Compensation 406 PERSONNEL ADMINISTRATION DATAI PROCESSING 0.00 66,300.00 45,000.00 16,640.00 0.00 25,500.00 1,600.00 1,000.00 1,500.00 2,000.00 2,000.00 500.00 0.00 0.00 7,650.00 5,192.31 0.00 0.00 2,276.03 108.91 116.94 0.00 0.00 372,00 0.00 0.00 15,716.19 101,940.48 0.00 0.00 0.00 351.96 12,080.99 0.00 371.08 1,323.91 0.00 10,871.47 24,999.41 214,134.69 0.00 0.00 40,250.00 25,961.55 11,235.68 0.00 15,932.21 762.37 963.35 933.22 2,670.45 2,694.80 536.85 0.00 0.00 60,099.52 63 01-00-406-000 01-00-406-100 01-00-406-159 01-00-406-160 01-00-406-161 01-00-406-163 01-00-406-164 01-00-406-316 01-00-406-350 01-00-406-354 0.00 422.00 0.00 3,223.86 64,605.30 0.00 2,975.35 9,438.22 54,798.20 78,671.76 0.00 0.00 0 0.00 78.00 84 0.00 2,000.00 0 0.00 204,014.14 2 0.00 40,394.70 62 0.00 150.00 0 0.00 2,024.65 60 0.00 5,061.78 65 0.00 45,884.80 54 0.00 46,328.24 63 0.00 345,936.31 0.00 150.00 5,000.00 14,500.00 38 0.00 0 An7 01-00-407-000 0.00 0.00 Page:8 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 01-00-407-201 01-00-407-202 01-00-407-203 01-00-407-316 01-00-407-374 01-00-407-375 01-00-407-376 01-00-407-377 01-00-407-452 01-00-407-700 Prior Yr Expd Budgeted 0.00 348.46 126.17 1,275.00 9,415.33 2,398.33 0.00 182.62 336.00 2,178.39 16,260,30 0,00 14,979.43 0.00 3,691.10 1,373.37 0.00 0.00 507.70 2,318.45 0,00 14,264.50 10,113.20 816.31 1,152.60 12,251.23 0.00 Current Expd YTD Expended Cancel Balance %Expd 0.00 100.00 0 0.00 412.26 18 0.00 373.83 25 0.00 4,000.00 0.00 7,505.50 58 0.00 1,249.77 69 0.00 0.00 0 0.00 56.56 77 0.00 597.05 8 0,00 93,03 73 0.00 14,388.00 49 0.00 0.00 0 0.00 1,178.84 95 0.00 0.00 0 0.00 4,138.84 48 0.00 2,501.60- 163 0.00 0.00 0 0.00 0.00 0 0.00 599.46 25 0.00 1,891.25 76 0.00 466.43 28 0.00 12,895.28 54 0.00 8,042.19 40 0.00 364.96 70 0.00 280.35 87 0.00 3,855.79 85 0.00 0.00 0 Fin8 Computer Supplies Copier Supplies Website Maintenance Software Services Computer Maintenance Agreement Copier Maintenance Agreement Fax Maintenance Printer Maintenance Contracted Services Computer/Fax 407 DATA PROCESSING ENGINEER Engineer Service Fees GENERAL GOVERNMENT BUILDINGS Custodian Wages Operating Supplies Municipal Center Signs Uniform Small Tools & Minor Equipment Telephone Internet Fees Electricity Gas Sewage Water Repairs tol Building Contract Lawn Maintenance 100.00 500,00 500.00 4,000.00 18,000.00 4,000.00 0.00 250.00 648.00 350.00 28,348.00 0.00 25,000.00 0.00 8,000.00 4,000.00 0.00 0.00 800.00 8,000.00 650.00 28,000.00 13,500.00 1,200.00 2,100.00 25,750.00 0.00 0.00 0.00 15.00 0.00 1,359.00 123.48 0.00 0.00 0.00 60.62 1,558.10 0.00 3,432.11 0.00 675.50 248.69 0.00 0.00 161.91 597.71 131,85 804.21 124.07 195.81 387.25 4,894.41 0.00 0.00 87.74 126.17 0.00 10,494.50 2,750.23 0.00 193.44 50.95 256.97 13,960,00 0.00 23,821.16 0.00 3,861.16 6,501.60 0.00 0.00 200.54 6,108.75 183.57 15,104.72 5,457.81 835.04 1,819.65 21,894.21 0.00 0 01-00-408-000 01-00-408-316 01-00-409-000 01-00-409-141 01-00-409-220 01-00-409-221 01-00-409-238 01-00-409-260 01-00-409-321 01-00-409-325 01-00-409-361 01-00-409-362 01-00-409-364 01-00-409-366 01-00-409-373 01-00-409-375 Page: 9 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 01-00-409-376 01-00-409-377 01-00-409-450 01-00-409-452 01-00-409-453 Prior Yr Expd Budgeted 0.00 0.00 0.00 9,545.36 0.00 56,033.82 127,100.00 0.00 77,457.67 145,173.00 121,945.68 231,067.00 221,871.92 436,164.00 369,086.36 637,985.00 7,399.00 14,661.00 24,242.40 46,670.00 36,294.62 86,776.00 9,560.18 18,000.00 1,923.14 3,600.00 109,777.68 216,000.00 2,853.35 15,600.00 0.00 353,613.00 10,324.43 21,800.00 0.00 7,598.93 30,000.00 28,931.24 29,679.78 47,470.32 0.00 185.00 Current Expd YTD Expended Cancel 711.60 0.00 0.00 1,709.03 110.83 10,752.87 0.00 16,750.56 26,661.48 132,990.32 50,220.00 247,331.64 69,478.28 390,483.01 1,346.88 5,630.80 0.00 1,096.44 236.06 16,858.05 119,156.43 701.61 0.00 2,512.59 0.00 913.46 6,249.13 15,364.06 20,595.12 129,132.60 0.00 0.00 Balance 0.00 0.00 0.00 0.00 0.00 %6 Expd 288.40 71 2,100.00 0 0.00 0 5,564.26 75 8,608.31 14 0.00 46,593.92 63 Landscaping Materials Heating System Maintenance Building Rental Refunds Contracted Services Fumiture & Equipment 409 GENERAL GOVERNMENT BUILDING 1,000.00 2,100,00 0.00 22,000.00 10,000.00 711.60 0.00 0.00 16,435.74 1,391.69 80,506.08 0.00 83,752.80 01-00-410-000 01-00-410-122 01-00-410-123 01-00-410-131 01-00-410-132 01-00-410-140 01-00-410-141 01-00-410-142 01-00-410-152 01-00-410-155 01-00-410-156 01-00-410-158 01-00-410-160 01-00-410-161 01-00-410-163 01-00-410-179 01-00-410-182 01-00-410-183 01-00-410-187 01-00-410-188 01-00-410-189 POLICE Chiefs Salary Lieutenant's Wages Sargeant's Wages Patrolman's Wages Parking Enforcement Officer Clerk's Wages School Guard Wages Dental Insurance Optical Insurance Health/Hospital Insurance Life Insurance Pension/Retirement Chief's Pension Ambulance Subscriptions Court Time Longevity Overtime Special Detail Holiday Pay Vacation Buy Back 0.00 0.00 0.00 0.00 0.00 0 61,420.20 58 98,076.68 58 0.00 188,832.36 57 0.00 247,501,99 61 0.00 6,995,44 52 0.00 19,546.40 58 0.00 51,079.39 41 0.00 9,734.16 46 0.00 1,845.83 49 0.00 96,843.57 55 0.00 10,487.13 33 0.00 353,613.00 0.00 9,237.05 58 0.00 80.00 0.00 21,920.64 27 0.00 32,714.61 49 0.00 43,543.73 49 0.00 59,132.60- 184 0.00 52,000.00 0.00 12,000.00 7,665.56 27,123.60 35,696.61 8,265.84 1,754.17 5,112.87 0.00 12,562.95 0.00 8,079.36 31,085.39 41,456.27 0.00 0.00 0 0 80.00 63,800.00 85,000.00 70,000.00 52,000.00 12,000.00 0 0 FMy Page: 10 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 07-00-410-190 01-00-410-191 01-00-410-192 01-00-410-193 01-00-410-210 01-00-410-212 01-00-410-213 01-00-410-214 01-00-410-220 01-00-410-231 01-00-410-239 01-00-410-240 01-00-410-316 01-00-410-321 01-00-410-322 01-00-410-324 01-00-410-325 01-00-410-326 01-00-410-327 01-00-410-328 01-00-410-372 01-00-410-374 01-00-410-375 01-00-410-377 01-00-410-378 01-00-410-384 01-00-410-387 01-00-410-388 Prior Yr Expd Budgeted 450.00 18,728.16 0.00 0.00 2,798.92 561.28 2,766.87 0.00 7,573.60 21,185.28 0,00 18.71 53,693.03 1,910.10 1,920.68 1,030.99 306.60 119.00 634,45 0.00 0.00 13,739.43 738.73 1,823.35 0.00 0.00 0.00 0.00 Current. Expd YTD Expended Cancel Balance 0.00 35,325.00 16 0.00 1,547.26 92 0.00 2,092.47 25 0.00 0.00 0 0.00 3,300.69 34 0.00 400.00 0 0.00 6,807.41 15 0.00 0.00 0 0.00 2,504.19 64 0.00 17,828.78 49 0.00 2,352.00 22 0.00 2,519.46 16 0.00 33,397.90 65 0.00 3,648.21 48 0.00 1,860.49 53 0.00 1,133.75 44 0.00 581.49 17 0.00 71.00 53 0.00 1,502.17 25 0.00 4,000.00 0 0.00 0.00 0 0.00 16,511.56 45 0.00 1,302.86 48 0.00 2,620.90 25 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 Flo %6 Expd Sick Days Buy Back Uniform Allowance/Police Uniform Allowance/Schoo: Guard Vest Replacements Office Supplies Forms Minor Equipment Minor Equipment (Encumbered) Operating Supplies Vehicle Fuel Tires 42,000.00 19,000.00 2,800.00 0.00 5,000.00 400.00 8,000.00 0.00 7,000.00 35,000.00 3,000,00 3,000.00 94,712.70 7,000.00 4,000.00 2,030.85 700.00 150.00 2,000.00 4,000.00 0.00 30,000.00 2,500.00 3,500.00 0.00 0.00 0.00 0.00 0.00 2,725.05 0.00 0.00 109.44 0.00 31.79 0.00 95.31 2,465,85 0.00 180.25 437.03 227.43 579.06 166.00 0.00 0.00 0,00 0.00 0.00 736.98 230.00 19.70 0.00 0.00 0.00 0.00 6,675.00 17,452.74 707.53 0.00 1,699.31 0.00 1,192.59 0.00 4,495.81 17,171.22 648.00 480.54 61,314.80 3,351.79 2,139.51 897.10 118.51 79,00 497.83 0.00 0.00 13,488.44 1,197,14 879.10 0.00 0.00 0.00 0.00 Other Operating Supplies/D.A.R Software Services Telephone MDT Air Cards Mobile Phone Postage Court Parking Police Radio Maintenance Police Radiol Installation Parking Meter Repair Vehicle Repair/Parts Speed Control Equipment Copier Maintenance Fax Maintenance Identikit Rental Breathalyzer Breathalyzer Maintenance Page: 11 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Descrption 01-00-410-420 01-00-410-451 01-00-410-452 01-00-410-453 01-00-410-460 01-00-410-461 01-00-410-462 01-00-410-542 01-00-410-741 01-00-410-742 01-00-410-743 01-00-410-744 01-00-410-745 01-00-410-747 01-00-410-748 01-00-410-749 01-00-410-752 01-00-410-753 01-00-410-754 Prior Yr Expd Budgeted 1,205.00 0.00 9,255.70 35,000.00 2,550.00 1,501.16 7,405.60 0.00 889.27 0.00 749.00 8,700,00 142.30 0.00 1,227.68 2,447.28 1,715.00 950.00 725.00 41,645.00 1,317,708.87 3,007,282.55 0.00 0.00 13,950.08 0.00 7,388.99 75,000.00 21,339.07 187,000.00 Current. Expd YTD Expended Cancel Balance %Expd 0.00 2,255.00 25 0.00 0.00 0 0.00 25,949.00 26 0.00 2,100.00 30 0.00 1,595.41 65 0.00 1,773.83 87 0.00 5,000.00 0.00 1,224.50 39 0.00 8,940.00- 0 0.00 10,429,48 35 0.00 7,735.00 57 0.00 3,927.00 72 0.00 0.00 0 0.00 3,657.50 19 0.00 70.77- 101 0.00 1,785.00 49 0.00 4.07- 100 0.00 2,284,80 24 0.00 60,000.00 0.00 1,520,348.85 49 Dues Contract Vehicle Service Animal Control Service Contracted Services Meetings and Conferences Officer Training Education Reimbursement Community Programs Police Vehicle Purchase Computer Computer Maintenance MDT-Lap Tops Speed Monitor Trailors Speed Monitor Maintenance K-91 Expense K-9Handler Truck Inspection AED Maintenance Asset Forfeiture Purchases 410 POLICE FIRE VFD Relief Assoc. Hydrant Service Fire Department Warehouse Lease Fire Department Donation 411 FIRE 3,000.00 0.00 3,000,00 4,500.00 14,000.00 5,000.00 2,000.00 0.00 16,000.00 18,000.00 14,000.00 0.00 4,500.00 5,000.00 3,500.00 1,000.00 3,000.00 60,000.00 0.00 0.00 0.00 210.00 70.69 4,745.28 0.00 0.00 0.00 0.00 3,760.00 10,073.00 0.00 202.50 139.98 490.00 0.00 0.00 0.00 262,309.86 1,486,933.70 0.00 0.00 2,415.70 1,111.33 0.00 3,527.03 101,642.78 745.00 0.00 9,051.00 900.00 2,904.59 12,226.17 0.00 775.50 8,940.00 5,570.52 10,265,00 10,073.00 0.00 842.50 5,070.77 1,715.00 1,004.07 715.20 0,00 0 0 01-00-411-000 01-00-411-163 01-00-411-363 01-00-411-383 01-00-411-550 0.00 44,000.00 28,000.00 40,000.00 0.00 0.00 14,419.69 5,556.43 81,666.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 44,000.00 0 13,580.31 52 34,443.57 14 6,666.66- 109 85,357.22 54 Pinl( Page: 12 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 01-00-412-530 01-00-412-531 Prior Yr Expd Budgeted 132,428.00 128,000.00 3,504.65 135,932.65 131,500.00 0.00 0.00 31,595.99 61,405.00 2,352.25 0.00 0.00 0.00 2,769.24 0.00 0.00 48,000.00 20,694.40 45,000.00 0.00 0.00 342.21 2,760.00 67.08 552.00 10,546.22 32,400.00 274.86 800.00 0.00 80.00 291.03 300,00 63.00 150.00 2,441.29 2,400.00 493.39 1,600.00 323.68 1,000.00 696.19 1,000.00 753.86 1,500.00 145.00 1,200.00 0.00 0.00 15,382.32 50,000.00 0.00 3,000.00 Current Expd YTD Expended Cancel 0.00 124,761.48 0.00 400.00 0.00 125,161.48 0.00 7,571.17 0.00 0.00 0.00 3,825.00 5,193.60 0,00 96.96 20.35 1,264.69 44.34 0,00 0.00 0.00 110.89 124.19 59.94 0.00 148.97 0.00 0.00 2,384.74 660.00 Balance % Expd 0.00 3,238.52 97 0.00 3,100.00 11 0.00 6,338.52 95 0.00 0.00 0 0.00 23,303.79 62 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 Ambulance/Rescue Assessment EME Equpment/raining 412 Total 3,500.00 01-00-413-000 01-00-413-130 01-00-413-131 01-00-413-132 01-00-413-133 01-00-413-134 01-00-413-143 01-00-413-144 01-00-413-152 01-00-413-155 01-00-413-156 01-00-413-158 01-00-413-763 01-00-413-210 01-00-413-212 01-00-413-220 01-00-413-324 01-00-413-325 01-00-413-374 01-00-413-375 01-00-413-420 01-00-413-451 01-00-413-452 01-00-413-460 PROTECTIVE INSPECTION Building Official Wages Building Official Building Inspector Code Enforcement Officer Building & Codes Assistant Secretary Wages Local Government. Academy Intern Dental Insurance Optical Insurance Hospital Insurance Life Insurance Ambulance Subscriptions Office Supplies Forms Operating Supplies Mobile Phone Postage Vehicle Repairs Fuel Dues Vehicle Purchase Contracted Outside Services Meetings & Conferences 0.00 38,101.21 0.00 0.00 0.00 19,648.14 25,842.00 0.00 969.60 243.04- 12,200.83 416.70 0.00 220.56 72.00 1,057.80 745.26 369.81 588.00 1,001.06 50.00 0.00 7,978.27 1,105.00 0.00 28,351.86 41 0.00 19,158.00 57 0.00 0.00 0 0.00 1,790.40 35 0.00 795.04 44- 0.00 20,199.17 38 0.00 383.30 52 0.00 80.00 0 0.00 79.44 74 0.00 78.00 48 0.00 1,342.20 44 0.00 854.74 47 0.00 630.19 37 0.00 412.00 59 0.00 498.94 67 0.00 1,150.00 4 0.00 0.00 0 0.00 42,021.73 16 0.00 1,895.00 37 Fin/a Page: 13 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Descrption 01-00-413-500 Prior Yr Expd Budgeted 0.00 89,232.01 253,147.00 0.00 112,86 0.00 0.00 905.95 744.00 0.00 0.00 1,762.81 0.00 225,024.30 500,000.00 27,811.87 0.00 2,477.60 255,313.77 568,000.00 0.00 179,561.06 460,000.00 6,710.00 4,790.94 939.12 44,454.02 1,182.37 0.00 Current Expd YTD Expended Cancel 0.00 21,504.84 110,123.20 0.00 0.00 0.00 0.00 217.50 0.00 0.00 0.00 217.50 0.00 42,676.79 224,993.13 4,879.52 0.00 400.00 47,956.31 257,150.41 0.00 52,831.20 263,664.40 4,813,13 678.72 142.45 7,830.00 313.60 0.00 Balance %Expd 0.00 0.00 0 Refunds 0.00 0.00 413 PROTECTIVE INSPECTION PLANNING & ZONING Forms Special Legal Services Planning Consultant Advertising Dues Contracted Consulting Refunds 414 PLANNING & ZONING SOLID WASTE COLLECTION Garbage Hauling Recycling Collection Leaf Collection Fire Dept. Site Glass Pickup 427 SOLID WASTE COLLECTION HIGHWAY MAINTENANCE-GENERAL Driver's Wages Part-time Seasonal Workers Dental Insurance Optical Insurance Health/Hospital Insurance Life Insurance Ambulance Subscription 0.00 143,023.80 44 01-00-414-000 01-00-414-212 01-00-414-314 01-00-414-316 01-00-414-341 01-00-414-420 01-00-414-452 01-00-414-500 0.00 500.00 2,000.00 0.00 1,500.00 800.00 0.00 1,500.00 6,300.00 0.00 50,000.00 13,000.00 5,000.00 0.00 0.00 157.00 0.00 301.20 852.00 0.00 0.00 1,310.20 0.00 29,807.28 0.00 2,350.00 0.00 0.00 0 0,00 500.00 0 0.00 1,843.00 8 0.00 0.00 0 0.00 1,198.80 20 0.00 52.00- 106 0.00 0.00 0 0.00 1,500.00 0 0.00 4,989,80 21 0.00 0.00 0 0.00 275,006.87 45 0.00 20,192.72 60 0.00 13,000.00 0.00 2,650.00 47 0.00 310,849.59 45 01-00-427-000 01-00-427-450 01-00-427-451 01-00-427-452 01-00-427-453 0 01-00-430-000 01-00-430-142 01-00-430-143 01-00-430-152 01-00-430-155 01-00-430-156 01-00-430-158 01-00-430-163 0.00 12,000.00 9,000.00 1,700.00 82,000.00 4,000.00 300.00 0.00 9,690.13 4,751.04 997.15 53,895.12 2,195.20 80.00 0.00 0.00 0 0.00 196,335.60 57 0.00 2,309.87 81 0.00 4,248.96 53 0.00 702.85 59 0.00 28,104.88 66 0.00 1,804.80 55 0.00 220.00 27 Fin13 Page: 14 Castle Shannon Borough JULY2023 08/08/2023 11:09 AM Expenditure. Account Description 01-00-430-182 01-00-430-183 01-00-430-190 01-00-430-210 01-00-430-220 01-00-430-231 01-00-430-232 01-00-430-238 01-00-430-239 01-00-430-251 01-00-430-260 01-00-430-321 01-00-430-324 01-00-430-327 01-00-430-361 01-00-430-362 01-00-430-364 01-00-430-366 01-00-430-373 01-00-430-374 01-00-430-451 01-00-430-453 01-00-430-454 01-00-430-460 01-00-430-740 Prior Yr Expd Budgeted 2,330.00 33,352.08 0.00 0.00 1,713.02 2,604.15 9,087.01. 12,000.00 5,232.79 46.00 10,513.73 3,028.74 2,533.72 253.22 885.01 1,001.22 3,766.94 385,46 414.47 3,237.00 7,305.28 0.00 0.00 203.71 530.00 0.00 326,061.06 689,994.73 0.00 Current Expd YTD Expended Cancel 820.00 1,762.20 0.00 0.00 84.39 222.79 929.39 467.72 0.00 67.46 113.14 234.47 78.03 0.00 161.93 35.40 68.32 0,00 0.00 0.00 0.00 0.00 20.48 0.00 0.00 71,674.82 408,126.48 0.00 Balance %Expd 0.00 2,145.00 57 0.00 9,751.28- 295 0.00 4,300.00 54- 0.00 87.00 13 0,00 897.96- 113 0.00 4,866.00 28 0.00 5,429.55 55 0.00 1,480.19 80 0.00 6,484.93 0.00 5,660,06 62 0.00 2,215.91- 131 0.00 2,763.41 39 0.00 261.46 52 0.00 936.20- 194 0.00 1,153.45 52 0.00 3,179.94 46 0.00 233.42 61 0.00 720.00 0.00 1,437.63 59 0.00 17,140.72 14 0.00 0.00 0 0.00 3,000.00 40 0.00 554.88 8 0.00 1,045.00 30 0.00 0.00 0 Longevity Overtime Sick Time Bonus Office Supplies Operating Supplies Gasoline Diesel Fuel Clothing & Uniforms Tires Vehicle Repair/Maintenace Small Tools & Equipment Telephone Mobile Phone Radio Equipment Maintenance Electricity Gas Sewage Charges Water Building Repair Equipment Repair Vehicle Contract Maintenance Contracted Tree Removal PA One Call Service Meetings & Conferences Vehicle Purchase 5,000.00 5,000.00 2,800.00 100.00 7,013.38 6,756.02 7,500.00 6,500.00 15,000.00 7,092.00 4,500.00 550.00 1,000.00 2,414.63 5,848.70 600.00 720.00 3,500.00 20,000.00 0.00 5,000.00 600.00 1,500.00 0.00 2,855.00 14,751.28 1,500.00- 13,00 7,911.34 1,890.02 6,570.45 6,019.81 15.07 9,339,94 9,307,91 1,736.59 288.54 1,936.20 1,261.18 2,668.76 366.58 0.00 2,062.37 2,859.28 0.00 2,000.00 45.12 455.00 0.00 0 0 430 HIGHWAY MAINTENANCE-GENERAL HIGHWAY MANTEMANCESNOWAICE 0.00 281,868.25 59 01-00-432-000 0.00 0.00 0.00 0.00 0 Fn14 Page: 15 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 01-00-432-220 01-00-432-221 Prior Yr Expd Budgeted 0.00 980.00 980.00 0.00 4,446.16 1,878.82 942.80 0.00 0.00 7,267.78 0.00 3,174.96 0.00 0.00 0.00 0.00 0.00 0.00 3,174.96 0.00 14,812.50 0.00 14,812.50 0.00 Current Expd YTD. Expended Cancel 0.00 0.00 0.00 0.00 774.27 247.83 0.00 0.00 0.00 1,022.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Balance %Expd 0.00 0.00 0 0.00 1,000.00 0 0.00 1,000.00 0 0,00 0.00 0 0.00 17,244.07 15 0.00 2,082.76 45 0.00 1,145.00 43 0.00 20,000.00 0 0.00 0.00 0 0.00 40,471.83 12 0.00 0.00 0 0.00 617.36- 0 0.00 5,000.00 0 0.00 4,005.96 20 0.00 4,827.20 40 0.00 2,752.02 45 0.00 5,000.00 0.00 5,000.00 0.00 25,967.82 21 0.00 0.00 0 0.00 29,700.00 15 0.00 0.00 0 Salt, Etc. Calcium Chloride 0.00 1,000.00 1,000.00 0.00 20,203.87 3,800.00 2,000.00 20,000.00 0.00 46,003.87 0.00 0.00 5,000.00 5,000.00 8,000.00 5,000.00 5,000.00 5,000.00 33,000.00 0.00 35,000.00 0.00 35,000.00 0.00 0.00 0.00 0.00 0.00 2,959.80 1,717.24 855.00 0.00 0.00 5,532.04 0.00 617.36 0.00 994.04 3,172.80 2,247.98 0.00 0.00 7,032.18 0.00 5,300.00 0.00 5,300.00 0.00 432 HIGHWAY MANTENANCE-SNOW. &1 HIGHWAY MAINTENANCE-SIDEWALKS 01-00-433-000 01-00-433-220 07-00-433-361 01-00-433-374 01-00-433-376 01-00-433-452 Signs Electricity Equipment Repair Crosswalk Paint Contract Services 433 HIGHWAY MAINTENANCE-SIDEWAL HWYN MAINTENANCE-STREEISCAPE Crosswalk Paint Decorative St. Light Repair Brick Repair and Replacement Banner/Flag Repair and Replacement LandscapingiPanung Street Furniture Maintenance Curb and Line Painting 435 HWY MANTEMANCESTREETSCA HWY MANTEMANCESTORM: SEWERS Storm Sewer Repair Contracted Services 436 HWY MANTENANCE-STORM SEWE HWY MAINTENANCE-HWYS & BRIDGES 01-00-435-000 01-00-435-220 01-00-435-251 01-00-435-253 01-00-435-255 01-00-435-258 01-00-435-259 01-00-435-260 0 0 01-00-436-000 01-00-436-374 01-00-436-454 0,00 29,700.00 15 01-00-438-000 0.00 0.00 0 Fin/s Page: 16 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure. Account Description 01-00-438-220 01-00-438-221 01-00-438-313 Prior Yr Expd Budgeted 175.00 1,719.11 0.00 1,894.11 0.00 0.00 0.00 0.00 0.00 0.00 1,230.00 712.50 2,153.32 1,400.00 3,514.42 1,418.22 85.63 0.00 668.28 146.71 529.18 1,835.00 1,438.70 0.00 5,305.50 0.00 Current Expd YTD Expended Cancel Balance %Expd 0.00 1,656.64 17 0.00 3,238.01 19 0.00 0.00 0 0.00 4,894.65 18 0.00 0.00 0 0.00 6,000.00 0 0.00 7,774.00 3 0.00 4,000.00 0 0.00 17,774.00 1 0.00 0.00 0 0.00 620.00 78 0.00 957.50 52 0.00 1,407.78- 123 0.00 350.00 83 0.00 3,191.21 51 0,00 716.99 64 0.00 903.57 10 0.00 424.29 15 0.00 724.73 52 0.00 567.27 0.00 1,476,53 0.00 2,065.50 59 0.00 2,956.35- 199 0.00 2,000.00 0 0.00 1,938.75 74 0.00 0.00 0 Fnle Operating Supplies Cold Patch Engineering Services 438 HWY MANTENANCE-HWIS & BRIDI CULTURE & RECREATION Decorative St. Banners Entertainment Services Rec. Share Dormont Pool 451 CULTURE & RECREATION 2,000.00 4,000.00 0.00 6,000.00 0.00 6,000.00 8,000.00 4,000.00 18,000.00 0.00 2,780.00 2,000.00 6,000.00 2,100.00 6,500.00 2,000.00 1,000.00 500.00 1,500.00 600.00 1,600.00 5,000.00 3,000.00 2,000.00 7,500.00 0.00 0.00 127.80 0.00 127.80 0.00 0.00 0.00 0.00 0.00 0.00 2,000.00 1,012.50 7,407.78 700.00 548.00 1,072.49 0.00 0.00 110.21 14.70 123.47 170.00 1,541.90 0.00 1,130.43 0.00 343.36 761,99 0.00 1,105.35 0.00 0.00 226.00 0.00 226.00 0,00 2,160.00 1,042.50 7,407.78 1,750.00 3,308.79 1,283.01 96.43 75.71 775.27 32.73 123.47 2,934.50 5,956.35 0.00 5,561.25 0.00 01-00-451-000 01-00-451-200 01-00-451-300 01-00-451-450 01-00-454-000 01-00-454-120 01-00-454-121 01-00-454-141 01-00-454-142 01-00-454-220 01-00-454-221 01-00-454-252 01-00-454-260 01-00-454-361 01-00-454-364 01-00-454-366 01-00-454-373 01-00-454-374 01-00-454-375 01-00-454-376 01-00-454-452 PARKS Summer Recreation Director Supervisor's Wages Recreation Counselors Wages Security Officer Operating Supplies Recreation Program Repair Material Minor Equipment Electricity Sewage Water Repairs to Building Park Maintenance Tree Removal Landscaping Contract Lawn Maintenance 5 8 Page: 17 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 01-00-454-500 01-00-454-540 01-00-454-550 Prior Yr Expd Budgeted 2,900.00 0.00 0.00 23,337.46 0.00 0.00 0.00 0.00 0.00 250.00 23,172.91 0.00 23,422.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 Current Expd YTD Expended Cancel 400.00 0.00 0.00 16,231.48 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,000.00 4,000.00 0.00 5,633.55 549.91 52.20 50.00 0.00 0.00 345.00 0.00 0.00 751.08 7,381.74 Balance %Expd 0.00 4,000.00 20 0.00 0.00 0 0.00 0.00 0 0.00 15,572.21 68 0.00 0.00 0 0.00 2,500.00 0 0.00 15,000.00 0 0.00 17,500.00 0 0.00 0.00 0 0.00 26,700,00 11 0.00 893.95 55 0.00 18,000.00 18 0.00 45,593.95 16 0.00 0.00 0 0.00 20,656.25 58 0.00 2,282.63 63 0.00 264.60 58 0.00 1,565.34 22 0.00 18,705.00 25 0.00 2,500.00 0 0.00 655.00 34 0.00 1,000.00 0 0.00 5,000.00 0 0.00 583.92 61 0.00 53,212.74 43 FM 17 Refunds CSYA Donation Senior Citizen Donation 454PARKS TREES Street Tree Maintenance Tree Planting Program 455 TREES 5,000.00 0.00 0.00 49,080.00 0.00 2,500.00 15,000.00 17,500.00 0.00 30,000.00 2,000.00 22,000.00 54,000.00 0.00 48,824.00 6,132.00 630.00 2,000.00 25,000.00 2,500.00 1,000.00 1,000.00 5,000.00 1,500.00 93,586.00 1,000.00 0.00 0.00 33,507,79 0.00 0.00 0.00 0.00 0.00 3,300.00 1,106.05 4,000.00 8,406.05 0.00 28,167.75 3,849.37 365.40 434.66 6,295.00 0.00 345.00 0.00 0.00 916.08 40,373.26 01-00-455-000 01-00-455-700 01-00-455-701 01-00-457-000 01-00-457-540 01-00-457-543 01-00-457-546 CIVIL & MILITARY CELEBRATIONS Civic Group Contributions Memorial Day Community Day 457 CIVIL & MILITARY CELEBRATIONS ECONOMIC DEVELOPMENT Department Wages Health/Hospital Insurance Life Insurance Development Supplies Professional Services Advertising Dues & Memberships Website Maintenance Community Events Meetings & Conferences 463 ECONOMIC DEVELOPMENT 01-00-463-000 01-00-463-112 01-00-463-196 01-00-463-198 01-00-463-248 01-00-463-310 01-00-463-341 01-00-463-420 01-00-463-453 01-00-463-454 01-00-463-460 Page: 18 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Descnption 01-00-471-000 01-00-471-100 01-00-471-600 Prior Yr Expd Budgeted 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 76,500.00 100,000.00 25.00 0.00 150,000.00 76,525.00 250,000.00 0.00 0.00 0.00 0.00 Current Expd YTD Expended Cancel 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 Balance %Expd 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0,00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 9,200.00 8 0.00 0.00 0 0.00 9,200.00 8 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 15,000.00 85 0.00 0.00 0 0.00 150,000.00 0 0.00 165,000.00 34 DEBT PRINCIPAL Capital Lease Principal Tax Anticipation Note Princip 471 DEBT PRINCIPAL DEBT INTEREST Capital Lease Interest Tax Anticipation Note Interest 472 DEBT INTEREST 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,000.00 0.00 10,000.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 800.00 0.00 800.00 0.00 0.00 0.00 85,000.00 0.00 0.00 85,000.00 0.00 0.00 0.00 0.00 01-00-472-000 01-00-472-100 01-00-472-600 01-00-481-000 01-00-481-510 01-00-481-511 NIERGOVERNMENIAL EXPENDITURES Snacog/Dues Shacog/Rad 481 NIERGOVERMMENTAL EXPENDITU INTERFUND OPERATING TRANSFERS Transfer to Street Lights Transfer to Capital Projects Transfer to Emp/Ret Sinking Transfer to General Oblig Bond Transfer to Capital Reserve Fund 492 INTERFUND OPERATING TRANSFEF 01-00-492-000 01-00-492-020 01-00-492-180 01-00-492-210 01-00-492-220 01-00-492-221 01-00-500-000 01-00-501-000 01-00-501-100 Refund of Revenues Due to/from Bond Fund Due to/Due from Payroll Fund 501 Due to/from Bond Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0 0.00 0 0.00 0 F18 Page: 19 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure. Account Description Prior Yr Expd Budgeted 2,894,367.70 6,645,976.15 2,894,367.70 6,645,976.15 Current Expd YTD. Expended Cancel 504,230.61 3,250,725.59 504,230.61 3,250,725.59 Current 404,020.49 504,230.61 100,210.12- Balance 0.00 3,395,250.56 49 0.00 3,395,250.56 49 %Expd 00 GENERAL FUNDI EXPENDITURES GENERAL FUND EXPENDITUR Expendit 01 GENERAL FUND EXPENDITURES Prior YTD 4,987,836.14 3,250,725.59 1,737,110.55 Revenues: 4,959,902.01 Expenditures: 2,894,367.70 Net Income: 2,065,534.31 Finl Page: 20 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue Account 02-00-300-000 02-00-301-000 02-00-301-100 02-00-301-300 02-00-301-500 Description STREET LIGHTING FUND REVENUES REAL ESTATE TAXES Real Estate Taxes-Current Real Estate Taxes-Delinquent Real Estate Taxes-Liened 301 REAL ESTATE TAXES Interest Earnings Transfer from General Fund FUND BALANÇE FORWARD 00 Total Prior Yr Rev Anticipated Curr Rev YTD. Rev Cancel 0.00 0.00 0.00 0.00 0.00 0.00 9,660.45 97,706.68 0.00 0.00 0.00 0.00 67.01 1,659.15 0.00 9,727.46 99,365.83 0.00 0.00 0.00 0.00 0.00 48,781.19 9,727.46 148,147.02 9,727,46 148,147.02 Current Expd YTD Expended Cancel Excess/Deficit % Real 0.00 0 0.00 0 14,293.32- 87 0.00 0 2,840.85- 37 0.00 17,134.17- 85 0.00 0.00 95,074.72 112,000.00 0.00 3,648.12 98,722,84 116,500.00 0.00 0.00 58,478.23 157,201.07 188,407.17 157,201.07 188,407.17 Prior Yr Expd Budgeted 0.00 0.00 0.00 59,555.54 114,000.00 0.00 59,555.54 159,000.00 59,555.54 159,150.00 59,555.54 159,150.00 0.00 0.00 0.00 4,500.00 02-00-341-000 02-00-392-010 02-00-399-000 0.00 0.00 71,907.17 0.00 0.00 0.00 0.00 0 0.00 0 23,125.98- 68 0.00 40,260.15. 79 STREET LIGHTING FUND Revenue Total 0.00 40,260.15- 79 Balance %Expd 0.00 0.00 0 0.00 150.00 0 0.00 0.00 0 0 Expenditure Account Description 02-00-000-000 02-00-403-500 02-00-434-000 02-00-434-361 02-00-434-362 STREET LIGHTING FUND Tax Refunds STREET LIGHTING EXPENDITURES Electricity LED Conversion 0.00 150.00 0.00 45,000.00 0.00 0.00 0.00 9,925.83 0.00 9,925.83 9,925.83 9,925.83 Current 9,727.46 0.00 0.00 0,00 59,672.40 0.00 59,672.40 59,672.40 59,672.40 0.00 54,327.60 52 0.00 45,000.00 0.00 99,327.60 38 0.00 99,477.60 37 0.00 99,477.60 37 434 STREETI LIGHTING EXPENDITURES 00 STREET LIGHTING FUND STREET LIGHTING FUND Expenditure T 02 STREET LIGHTING FUND Prior 157,201.07 YTD 148,147.02 Revenues: Fin 30 Page: 21 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditures: Net Income: 59,555.54 97,645.53 9,925.83 198.37- 59,672.40 88,474.62 Pn Page: 22 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue. Account 08-00-300-000 08-00-341-000 08-00-341-001 Description SANITARY SEWER FUND REVENUES Interest Earnings PLGIT Interest 341 Interest Earnings COVID 19-ARPA STATE CAPITAL/OPERATING: GRANTS ALCOSAN Grow Grant South McCully Sewer Repairs Killarney Inlet Repairs 354 STATE CAPTALOPERATING GRAN Prior Yr Rev Anticipated Curr Rev YTD. Rev Cancel 0.00 0.00 0.00 322.30 2,478.54 0.00 2,232.20 15,988.98 0.00 2,554.50 18,467.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 350.00 2,650,00 0.00 0.00 15,046.05 100,690.45 0.00 0.00 0.00 11,003.70 261,440.78 1,194,569.59 0.00 0.00 0.00 0.00 0.00 3,878,232.07 263,995.28 5,091,269.18 Excess/Deficit %Real 0.00 0 1,328.54 216 15,988.98 0 17,317.52 216 0.00 493.27 991.03 1,484.30 0.00 1,150.00 0.00 1,150.00 08-00-357-010 08-00-354-000 08-00-354-100 08-00-354-110 08-00-354-111 1,359.49 535,356.22 0.00 219,360.00- 96,000.00- 0.00 315,360.00- 0.00 74,625.00 3,450.00 0.00 160,701.55 225,000.00 0.00 10,380.96 1,280,314.13 2,458,000.00 0.00 0.00 0.00 0.00 3,750,951.15 3,925,103.81 4,718,749.07 6,919,610.03 0.00 535,356.22- 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 124,309.55- 45 0.00 0.00 1,119,774.56- 49 0.00 0.00 1,263,430.41- 49 0.00 0.00 0.00 0.00 0.00 0.00 15,000.00 7,000.00 0.00 0.00 11,000.00 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 15,000.00- 0 4,350.00- 38 0.00 0 0.00 0 3.70 100 08-00-364-000 08-00-364-110 08-00-364-111 08-00-364-120 08-00-364-121 08-00-364-122 08-00-364-123 08-00-364-600 SANITATION Sewage Tap-in Fee Dye Test Fees Current Sewage Collections Delinquent Sewage Collections Surcharge Sewage Billing Collections Alcosan Billing Refund 364SANITATION Proceeds from Bond Issue Miscellaneous Revenue Transfer from Bond Fund USC Municipal Pooled Trust Fund Balance Forward 00 Total 1,031,156.62 2,200,000.00 246,044.73 1,080,225.44 08-00-371-601 08-00-380-000 08-00-392-015 08-00-394-301 08-00-399-000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0 0.00 0 0.00 0 0.00 0 46,871.74- 99 0.00 1,828,340.85- 73 F - 28 Page: 23 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue Account Description Prior Yr Rev Anticipated Curr Rev 4,718,749.07 6,919,610.03 Prior YrExpd Budgeted 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,444,44 375.66 39.99 341.44 25.00 0.00 0.00 5,298.51 0.00 0.00 YTD. Rev 263,995.28 5,091,269.18 Current Expd YTD Expended Cancel Cancel Excess/Delicit %F Real 0.00 1,828,340.85- 73 Balance % Expd 0.00 0.00 0 0.00 0.00 0 0.00 0,00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0,00 0 0.00 0,00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0,00 2,087.00 30 0.00 114.32- 111 0.00 200.00 0 0.00 744.18- 174 0.00 23.99- 116 0.00 0.00 0 0.00 0.00 0 0.00 10,889.42 27 0,00 0.00 0 0.00 0.00 0 Fna3 SANITARY SEWER FUND Revenue Total: Expenditure Account Description 08-00-000-000 08-00-407-201 08-00-429-000 08-00-429-142 08-00-429-143 08-00-429-144 08-00-429-152 08-00-429-155 08-00-429-156 08-00-429-158 08-00-429-161 08-00-429-182 08-00-429-183 08-00-429-200 08-00-429-210 08-00-429-220 08-00-429-231 08-00-429-238 08-00-429-250 08-00-429-260 08-00-429-300 08-00-429-301 08-00-429-302 08-00-429-303 08-00-429-304 SANITARY SEWER FUND Computer Supplies WASTEWATER COLLECTION Driver's Wages/30% Secretary Wages/30% Collection Fee Dental Insurance Optical Insurance Health Insurance Life Insurance FICA Longevity Overtime Data Processing Supplies Office Supplies Operating Supplies Gasoline Clothing & Uniforms Vehicle Repair Supplies Small Tools & Equipment NSF Check Charges Physical Survey/lInspection Line Cleaning & CCTV Inspect GIS Data Base Development Dye Testing 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 3,000.00 1,000.00 200.00 1,000.00 150.00 0.00 0,00 15,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 265.09 196.59 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 913,00 1,114.32 0.00 1,744.18 173.99 0.00 0.00 4,110.58 0,00 0.00 Page: 24 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 08-00-429-305 08-00-429-306 08-00-429-307 08-00-429-313 08-00-429-314 08-00-429-315 08-00-429-316 08-00-429-325 08-00-429-354 08-00-429-361 08-00-429-364 08-00-429-365 08-00-429-366 08-00-429-374 08-00-429-452 08-00-429-453 08-00-429-460 08-00-429-500 08-00-429-700 08-00-429-701 08-00-429-800 Prior Yr Expd Budgeted 0.00 17,836.29- 325,000.00 0.00 0.00 0.00 0.00 62,495.00 0.00 0.00 518.91 600,500,78 2,132,576.00 0.00 22,652.89 4,500.00 6,244.44 10,476.00 0,00 790.19- 322,412.27 320,568.00 1,748.00 0.00 1,020,446.85 2,997,294.00 0.00 52,000.00 0.00 0.00 0.00 0.00 Current Expd YTD. Expended Cancel 0.00 81,450.00 0.00 0.00 0.00 0.00 9,699.01 0.00 0.00 37.18 3,587.98 642,188.63 0.00 18,198,48 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 113,434.33 831,359.51 0.00 0.00 0.00 0.00 Balance % Expd 0.00 0.00 0 0.00 253,237.77 22 0.00 0.00 0 0.00 0.00 0 0.00 30,000.00 0 0.00 1,500.00 0 0.00 23,844.05 74 0.00 0.00 0 0.00 0.00 0 0.00 701.11 30 0.00 1,490,387.37 30 0.00 500.00 0.00 14,295.86 58 0.00 7,762.80 48 0.00 3,792.40 71 0.00 8,634.23 14 0.00 100.00 0,00 1,000.00 0.00 317,384.97 0.00 0.00 Hydraulic Design/Capacity Eval Structural Repairs Feasibility Study CAP Implementation EPA SSO Flow Monitoring Flow Monitoring Equipment Engineering Fees Postage Workers compensation Electricity Alcosan Charges PAWC Shutoff Charges Sewage Billing Sewer Repair Contract Sewer Repair Pump Station Maintenance Meetings & Conferences Customer Refunds Jetter & Chassis Sewer Camera Repairs Depreciation Expense 429 WASTEWATER COLLECTION 0.00 0.00 0.00 30,000.00 1,500.00 90,000.00 0.00 0.00 1,000.00 500.00 33,700.00 15,000.00 13,000.00 10,000.00 100.00 1,000.00 3,000.00 0.00 0.00 71,762.23 0.00 0.00 0.00 0.00 66,155.95 0.00 0.00 298.89 0.00 19,404,14 7,237.20 9,207.60 1,365.77 0,00 0,00 3,183.03 2,500.00 0.00 0 D 0 1 500.00 83 0.00 0 0.00 2,165,934,49 28 08-00-430-701 08-00-463-730 08-00-470-000 08-00-471-601 08-00-472-601 F550 Upfit 51,511.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 489.00 99 0.00 0 0.00 0 0.00 0 0.00 0 PM3y Economic Development Property Purchase CAPITAL PROJECTS DEBT ACO- Debt Principal ACO- Debt Interest 0.00 513,520.46- 0.00 0.00 0.00 Page: 25 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure. Account Description 08-00-492-000 08-00-492-180 08-00-492-181 08-00-492-182 08-00-492-183 Prior Yr Expd Budgeted 0.00 Current Expd YTD Expended Cancel Balance %Expd 0.00 0.00 0 0.00 0.00 100 0.00 0.00 100 0.00 150,000.00 0 0.00 400,000.00 0 0.00 550,000.00 54 INTERFUND OPERATING TRANSFERS Transfer to Capital Projects Transfer to General Fund Transfer to Debt Service Transfer to Capital Reserve Fund 492 INTERFUND OPERATING TRANSFEH Due to/Due from Payroll Fund 00 SANITARY SEWER FUND 0.00 0.00 0.00 0.00 500,000.00 500,000.00 500,000.00 0.00 150,000.00 0.00 150,000.00 0.00 400,000.00 0.00 1,200,000.00 0.00 1,020,446,85 4,249,294.00 1,020,446.85 4,249,294.00 0.00 150,000.00 0.00 0.00 500,000.00 650,000.00 0.00 99,913.87 1,532,870.51 99,913,87 1,532,870.51 Current 263,995.28 99,913.87 164,081.41 0.00 0.00 08-00-501-100 0.00 0.00 0.00 0.00 0 0.00 2,716,423.49 36 0.00 2,716,423.49 36 SANITARY SEWER FUND Expenditure Tc 08 SANITARY SEWER FUND Prior YTD 5,091,269.18 1,532,870.51 3,558,398.67 Revenues: 4,718,749.07 Expenditures: 1,020,446.85 Net Income: 3,698,302.22 Fm Page: 26 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue Account 18-00-300-000 18-00-301-000 18-00-301-100 18-00-301-300 18-00-301-500 Description CAPITAL PROJECTS FUNDI REVENUES REAL ESTATE TAXES Real Estate Taxes-Current Year Real Estate Taxes-Delinquent Real Estate Taxes-Liened 301 REAL ESTATE TAXES Interest Earnings Interest Eamings-PLGIT Interest-6 Parks 341 Interest Earnings Prior Yri Rev Anticipated Curr Rev YTD Rev Cancel 0.00 0.00 0.00 0.00 0.00 0.00 21,260.32 215,028.69 0.00 24,971.31- 90 0.00 0.00 0.00 145.63 3,605.89 0.00 21,405.95 218,634.58 66.37 0.00 0.00 66.37 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 412,027.43- 0.00 0.00 0.00 0.00 412,027.43- 0.00 Excess/Delicit %Real 0.00 0 0.00 0 0.00 0 6,894.11- 34 0.00 31,865.42- 87 0.00 0.00 209,236.40 240,000.00 0.00 14,227.65 223,464,05 250,500.00 46.89 0.00 36.29 83.18 0.00 0.00 300,000.00 0.00 0.00 0.00 0.00 0.00 1,144.00- 1,750.00- 0.00 0.00 0.00 0.00 258,000.00 2,894.00- 558,000.00 0.00 0.00 0.00 0.00 10,500.00 18-00-341-000 18-00-341-001 18-00-341-002 75.00 1.00 0.00 76.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 514.77 0.00 0.00 514.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 300,000.00- 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 412,027,43- 0 0,00 0,00 439.77 686 1.00- 0 0.00 0 438.77 677 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 18-00-354-000 18-00-354-120 18-00-354-122 18-00-354-123 18-00-354-124 18-00-354-125 18-00-354-126 18-00-354-127 18-00-354-128 18-00-354-129 18-00-354-130 18-00-354-131 18-00-354-132 STATE CAPTALOPERATNG GRANTS DCNR GrantHamilton Park DCED Grant Library Cameras DCED/Community Enhancements Sleepy Hollow Flood Mitigation DCED-Public Works Garage Exp. DCED- Rebecca Street Retaining' Wall DCED/Act 13 Walking Trail Park Master Planning Streetscape Grant Murphy Earmark CDBG Year 48 Saw Mill Run PRP 0.00 258,000.00- 0 0.00 970,027.43- 0 354 STATE CAPTALOPERATING GRAN Miscellaneous Revenues 18-00-380-000 0.00 0.00 0.00 0.00 0 Fin 86o Page: 27 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue Account 18-00-387-000 18-00-391-100 18-00-392-010 18-00-392-011 18-00-392-012 18-00-392-018 Description Revitalization Sale of Boro Property Transfer from General Fund Transfer from Sewer Fund Transfer from Bond Fund Transfer from Library Fund 392 Total Prior Yr Rev Anticipated Curr Rev YTD Rev Cancel Excess/Deficit %/ Real 0.00 80.00 0.00 80.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 100 0,00 4,029,147.59- 27 0.00 60,000.00- 0 0.00 4,089,147.59- 33 315.00 0.00 0.00 0.00 0.00 0.00 0.00 500,000.00 500,000.00 500,000.00 0.00 5,504,428.00 878,089.79 1,475,280.41 0.00 6,064,428.00 1,378,089.79 1,975,280.41 0.00 60,000.00 0.00 0.00 18-00-393-100 18-00-393-130 Proceeds from Bond Refinancing Proceeds of Debt 393 Total 0.00 0.00 0.00 453,829.57 200,547.71 139,767.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 747,912.28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0 0.00 0 0.00 0 18-00-394-110 18-00-399-000 Proceeds from Line of Credit Fund Balance Forward 00 Total 0.00 608,145.28 535 0.00 4,482,376.39- 42 0.00 4,482,376.39- 42 875,345.51 7,012,771.00 1,399,562.11 2,530,394.61 875,345.51 7,012,771,00 1,399,562.11 2,530,394.61 CAPITAL PROJECTS Revenue Totals Expenditure Account Description 18-00-000-000 18-00-400-400 18-00-403-500 18-00-404-100 18-00-406-000 18-00-406-100 Prior Yr Expd Budgeted 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Current Expd YTD Expended Cancel 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Balance %6 Expd 0.00 0.00 0 0.00 0.00 0 0.00 400.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 A77 CAPITAL PROJECTS Line of Credit Fees Real Estate Tax Refunds Codification Personnal Policy Code Enforcement Car 406 Personnal Policy DATA PROCESSING 0.00 0.00 400.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18-00-407-000 Page: 28 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Descrption 18-00-407-120 18-00-407-710 18-00-407-711 18-00-407-712 Prior Yr Expd Budgeted 0.00 0.00 2,000.00 0.00 2,000.00 105,000.00 83,088.20 170,000.00 0.00 0.00 8,460.00 25,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 8,460.00 25,000.00 0,00 0.00 0.00 14,000.00 0.00 18,200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 32,200.00 0.00 0.00 0.00 12,000.00 0.00 20,000.00 0.00 0.00 Current Expd YTD Expended Cancel Balance %Expd 0.00 48,550,00 3 0.00 0.00 0 0.00 25,696.75 14 0.00 14,987.83 40 0.00 89,234.58 15 Zoning Audit Copier ITS Support Document Management 407 DATA PROCESSING Engineer Service Fees GOVERNMENT BUILDINGS Repairs to Government Building Public Works Garage Roof MC Generator Replacement Library Generator Contracted Services 409 GOVERNMENT BUILDINGS 50,000.00 0.00 30,000.00 25,000.00 0.00 0.00 0.00 0.00 0.00 18,434.82 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 13,258.54 0.00 0.00 0.00 0.00 13,258.54 0.00 0.00 0.00 0.00 1,450.00 0.00 4,303.25 10,012.17 15,765.42 33,946.02 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16,636.21 14,718.48 0.00 0.00 0.00 0.00 31,354.69 0.00 14,235.35 0,00 0.00 18-00-408-316 18-00-409-000 18-00-409-373 18-00-409-374 18-00-409-375 18-00-409-376 18-00-409-452 0.00 136,053.98 20 0.00 0.00 0 0.00 25,000.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0,00 0 0.00 25,000.00 0 0.00 0.00 0 0.00 2,636.21- 119 0.00 3,481.52 81 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 845.31 97 0.00 0,00 0 0.00 2,235.35- 119 0.00 20,000.00 0 0.00 0.00 0 Finas 18-00-410-000 18-00-410-742 18-00-410-747 18-00-410-748 18-00-410-749 18-00-410-752 18-00-410-753 POLIÇE Computer Infrastructure Bulletproof Vest Replacement Weapons Replacement Taser Replacement Truck Inspection Patrol Car 410POLICE 18-00-413-000 18-00-413-700 18-00-413-701 18-00-413-702 PROTECTIVE INSPECTION Video Camera Conservatorship Program CDBG Demolitions Page: 29 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 18-00-413-703 Prior Yr Expd Budgeted 0.00 0.00 0.00 32,000.00 0,00 0.00 0.00 0.00 10,348.15 15,000.00 0.00 0.00 0.00 65,000.00 0.00 0.00 10,348.15 80,000.00 0.00 0.00 0.00 5,000.00 0.00 1,000.00 0.00 50,000.00 0.00 56,000,00 0.00 0.00 7.427.98 35,000.00 0.00 0.00 0.00 4,000.00 0.00 240,000.00 1,144.00- 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 124,900.00 Current Expd YTD Expended Cancel Balance %8 Expd 0.00 0.00 0 0.00 17,764.65 44 0,00 0.00 0 0.00 0.00 0 0.00 15,000.00 0 0.00 0.00 0 0.00 14,119.00- 122 0.00 0.00 0 0.00 881.00 99 0.00 0.00 0 0.00 5,000.00 0 0.00 1,000.00 0 0.00 33,137.25 34 0.00 39,137.25 30 0.00 0.00 0 0.00 23,672.37 32 0.00 0.00 0 0.00 3,600.10 10 0.00 240,000.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 8,622.56 93 Finag CDBG 47 Demolitions 413 PROTECTIVE INSPECTION Jetter Purchase WWYMANTEMANCEGENERA Small Tools & Equipment Backhoe Truck Purchase PWD Garage Door Replacement 430 HWY MAINTENANCE-GENERAL HWY MAINTENANCE-SIDEWALKS Engineer Service Fees Advertising Contract Services 435 HWY MAINTENANCE-SIDEWALKS HWY MANIENANCESTORM SEWERS Engineering Fees Small Equipment-Push Camera Advertising Contracted Services-May St. Killarney Inlets Joint Project Baldwin Twp Inlet Inspections & Repairs Elm Street Repair May Street Storm Sewer Saw Mill Run PRP 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,588.46 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 64,504.94 116,277.44 0.00 14,235.35 0.00 0.00 0.00 0.00 79,119.00 0.00 79,119.00 0.00 0.00 0.00 16,862.75 16,862.75 0.00 11,327,63 0.00 399.90 0.00 0.00 0.00 0.00 0.00 0.00 18-00-429-700 18-00-430-000 18-00-430-260 18-00-430-700 18-00-430-701 18-00-430-702 18-00-435-000 18-00-435-313 18-00-435-341 18-00-435-452 18-00-436-000 18-00-436-313 18-00-436-314 18-00-436-341 18-00-436-452 18-00-436-453 18-00-436-454 18-00-436-455 18-00-436-456 18-00-436-457 18-00-436-460 Page: 30 Castie Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 18-00-436-605 18-00-436-607 Prior YrExpd Budgeted 0.00 0.00 6,283.98 403,900.00 0.00 9,980.70 4,938.97 1,454.75 1,457.85 250,000.00 0.00 0.00 0.00 426,969.25 0.00 771,428.00 444,801.52 1,058,428.00 0.00 0.00 0.00 1,323,000.00 9,495.00 5,000.00 673.91 1,000.00 0.00 10,000.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 1,500.00 0.D0 20,000.00 0.00 32,000.00 Current Expd YTD Expended Cancel Balance %Expd 0.00 0.00 0 0.00 0.00 0 Sleepy Hollow Flood Mitigation Phase III Improvements 436 HWY MANTENANCE-STORM SEWE HWY MAINTENANCE-HWISABRIDGES Yard Restoration Engineering Services Advertising Contract Paving Guide Rail Installation/Repair Bridge Repairs ARLE Projects PennDot/Street Scape Match RACP Match 0.00 0.00 0.00 0.00 67,093.40 128,004.97 0.00 0.00 1,311.81 0.00 0.00 0.00 0.00 0.00 0.00 358,387.33- 0.00 1,311.81 347,033.45- 0.00 32,000.50 181,933.96 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 275,895.03 32 18-00-438-000 18-00-438-200 18-00-438-313 18-00-438-341 18-00-438-452 18-00-438-453 18-00-438-601 18-00-438-602 18-00-438-603 18-00-438-604 0,00 4,000.00 16,000.00 2,000.00 15,000.00 0.00 0.00 0.00 0.00 0.00 7,493.88 0.00 0.00 3,860.00 0.00 0.00 0.00 0,00 0.00 0 0.00 4,000.00 0 0.00 8,506.12 47 0.00 2,000.00 0 0.00 250,000.00 0 0.00 11,140.00 26 0.00 0.00 0 0.00 0.00 0 0.00 358,387.33 0 0.00 771,428.00 0 0.00 1,405,461.45 33- 438 HWY MAINTENANCE-WIS & BRIDI 18-00-454-000 18-00-454-313 18-00-454-611 18-00-454-612 18-00-454-613 18-00-454-615 18-00-454-616 18-00-454-617 18-00-454-618 18-00-454-620 18-00-454-621 18-00-454-624 PARKS Engineering Fees Playground Equipment Park Equipment Field Maintenance MC Shed Park Master Plan mprovements Park Master Planning MC Volley Ball Facility Veterans Memorial Park Borough Wide Trail improvements DCED Greenways, Trails & Rec. Match 0.00 5,582.50 0.00 16,700.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 1,141,066.04 14 0.00 582.50- 112 0.00 1,000.00 0 0.00 6,700.00- 167 0.00 0.00 0 0.00 2,463,945.59 23 0.00 0,00 0 0.00 0.00 0 0.00 1,500.00 0 0.00 20,000.00 0 0.00 32,000.00 0 FM30 0,00 3,195,000.00 263,558.30 731,054.41 Page:31 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Descriplion Prior Yr Expd Budgeted 10,168.91 4,587,500.00 0.00 0.00 0.00 0.00 0.00 3,038.41 0.00 0.00 25,000.00 0.00 0.00 3,023.44 5,500.00 0.00 245,000.00 8,523.44 270,000.00 0.00 0.00 0.00 Current Expd YTD. Expended Cancel 295,558.80 935,270.87 Balance 0.00 3,652,229.13 20 0.00 513,520.46- 0 0.00 0,00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 6,000.00 0 0.00 0.00 0 0.00 18,273.44 27 0.00 0.00 0 0.00 0.00 0 0.00 720.00- 0 0.00 2,475.00- 0 0.00 245,000.00 0.00 260,078.44 0.00 0.00 0.00 %Expd 454PARKS 18-00-463-730 18-00-470-000 18-00-471-100 18-00-471-300 Economic Development Property Purchase CAPITAL PROJECTS DEBT Debt Principal Short Term Note Principal/Interest 471 Total Debt Interest MAIN: STREET Professional Services DCED-Keystone Community Study Act 13 Walking Trail Study Community Revitalization Wayfinding Study Wayfinding Installation 480 MAIN STREET Transfer to General Fund Transfer to Debt Service Fund 492 Total 0.00 513,520.46 513,520.46 0.00 0.00 0.00 0.00 6,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 944.95 0.00 0.00 0.00 0.00 0.00 944.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6,726.56 0.00 0.00 720.00 2,475.00 0.00 9,921.56 0.00 0.00 0.00 18-00-472-100 18-00-480-000 18-00-480-100 18-00-480-200 18-00-480-300 18-00-480-530 18-00-480-531 18-00-480-532 0 4 0.00 0 0.00 0 0.00 0 18-00-492-010 18-00-492-101 0.00 0.00 0.00 00 CAPITAL PROJECTS 576,712.61 6,826,428.00 576,712.61 6,826,428.00 910,122.78 1,430,967.64 910,122.78 1,430,967.64 Current 1,399,562.11 0.00 5,395,460.36 21 0.00 5,395,460.36 21 CAPITAL PROJECTS Expenditure Totals 18 CAPITAL PROJECTS Prior 875,345.51 YTD 2,530,394.61 Revenues: Fn31 Page: 32 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditures: Net Income: 576,712.61 298,632.90 910,122.78 489,439.33 1,430,967.64 1,099,426.97 Pin Page: 33 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue. Account 21-00-341-000 21-00-341-100 Description Interest Earnings 341 Interest Earnings Hosptaizalon-Caruso COBRA 380 Total Prior YrA Rev Anticipated Curr Rev YTD Rev Cancel 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 85,000,00 0.00 0.00 611.53 0.00 0.00 85,611.53 0.00 0.00 85,611.53 Excess/Deficit % Real 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 15,000.00- 85 7,228.81- 8 22,228.81- 79 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 21-00-380-150 21-00-380-151 21-00-392-010 21-00-399-000 Transfer from General Fund Fund Balance Forward 00 Total 76,500.00 100,000.00 2,236.55 78,736.55 107,840.34 78,736.55 107,840.34 Prior Yr Expd Budgeted 0.00 0.00 54,548.31 0.00 1,418.16 0.00 55,966.47 55,966.47 55,966.47 7,840.34 SINKING FUND Revenue Totals 0.00 22,228.81- 79 Balance %E Expd 0.00 0.00 0 0.00 0.00 0 0.00 17,332.45 80 0.00 0.00 0 0.00 1,227.48- 0 0.00 0.00 0 0.00 16,104.97 81 0.00 16,104.97 81 0.00 16,104.97 81 Rn33 Expenditure Account Description 21-00-000-000 21-00-406-000 21-00-406-150 21-00-406-151 21-00-406-152 21-00-406-153 Current Expd YTD Expended Cancel SINKING FUND PERSONNEL ADMINISTRATION HRA Hosptaizaton-Caruso Hospltalization-yonek COBRA 0.00 0.00 85,000.00 0.00 0.00 0.00 85,000.00 85,000.00 85,000.00 Prior 0.00 0.00 5,732.04 0.00 0.00 0.00 5,732.04 5,732.04 5,732.04 Current 0.00 0.00 67,667,55 0.00 1,227.48 0.00 68,895.03 68,895.03 68,895.03 406 PERSONNEL ADMINISTRATION 00 SINKING FUND SINKING FUND Expenditure Totals 21 SINKING FUND YTD Page: 34 Castle Shannon Borough JULY2023 08/08/2023 11:09A AM Revenues: Expenditures: Net Income: 78,736.55 55,966.47 22,770.08 0.00 5,732.04 5,732,04- 85,611,53 68,895.03 16,716.50 Fin34 Page: 35 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue. Account 22-00-300-000 22-00-301-000 22-00-301-100 22-00-301-300 22-00-301-500 Description SINKING FUND- SERIES 2022 REAL ESTATE TAXES Real Estate Taxes-Current Real Estate Taxes-Delinquent Real Estate Taxes-Liened 301 REAL ESTATE TAXES Interest Eamings Transfer from General Fund Transfer from Capital Fund Transfer from Sewer Fund 392 Total Prior Yr Rev Anticipated Curr Rev YTD. Rev Cancel 0.00 0.00 0,00 0.00 0.00 0.00 50,497.83 510,739.42 0.00 0.00 0.00 0.00 275.17 6,813.58 0.00 50,773.00 517,553.00 35,332.31 232,570.09 0.00 0.00 0.00 0.00 0.00 0.00 8,870,764.78 86,105.31 9,620,887.87 86,105.31 9,620,887.87 Current Expd YTD Expended Cancel Excess/Deficit %Real 0.00 0 0,00 0 58,003.47- 90 0.00 0 186.42- 97 0.00 58,189.89- 90 0.00 132,570.09 233 0.00 0.00 0.00 0.00 468,891.23 568,742.89 0.00 14,957.25 483,848.48 575,742.89 20,645.93 100,000.00 25.00 0.00 0,00 150,000.00 25.00 150,000.00 0.00 0.00 0.00 7,000.00 22-00-341-000 22-00-392-010 22-00-392-101 22-00-392-221 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0 0.00 150,000.00- 0 0.00 150,000.00- 0 22-00-393-100 22-00-399-000 General Oblig. Bond Proceeds Fund Balance Forward 00 Total 9,608,221.68 38,334.36 8,827,118.30 10,151,075.45 9,652,861.19 10,151,075.45 9,652,861.19 Prior Yr Expd Budgeted 0.00 0.00 0.00 200.00 0,00 402,643.75 784,995.05 0.00 784,995.05 402,643.75 50,167.05 260,706.25 750.00 0.00 0.00 0.00 0.00 0 43,646.48 100 0.00 31,973.32- 100 SINKING FUND/BOND Revenue Totals 0.00 31,973.32- 100 Balance % Expd 0.00 0.00 0 0.00 200.00 0 0.00 402,643.75 0 0.00 0.00 0 0.00 402,643.75 0 0.00 128,381.25 51 0.00 1,500.00- 300 Fin35 Expenditure Account Description 22-00-000-000 22-00-403-500 22-00-471-100 22-00-471-400 SINKING FUND/BOND Real Estate Tax Refunds Debt Principal Line of Credit 471 Total Debt Interest Fiscal Agent Fees 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 22-00-472-100 22-00-475-000 0.00 132,325.00 0.00 2,250.00 750.00 Page: 36 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 22-00-492-010 22-00-492-350 22-00-492-351 Prior Yr Expd Budgeted 0.00 0.00 Current Expd YTD Expended Cancel Balance %Expd 0.00 0.00 0 0.00 0.00 0 Transfer to General Fund Transfer tol Liquid Fuels Transfer to Capital Fund 492 Total 0.00 0.00 0.00 0.00 0.00 0,00 0.00 5,504,428.00 878,089.79 1,475,280.41 0.00 4,029,147.59 27 0.00 4,029,147.59 27 0.00 5,504,428.00 0.00 835,912.10 6,168,728.00 835,912.10 6,168,728.00 878,089.79 1,475,280.41 0.00 878,089.79 1,609,855,41 878,089.79 1,609,855.41 Current 86,105.31 878,089.79 791,984.48- 22-00-501-000 Due to/Due from General 00 SINKING FUND/BOND 0.00 0.00 0.00 0.00 0 0.00 4,558,872.59 26 0.00 4,558,872.59 26 SINKING FUND/BOND Expenditure Total. 22 SINKING FUND/BOND Prior 835,912.10 YTD 9,620,887.87 1,609,855.41 8,011,032.46 Revenues: 10,151,075,45 Expenditures: Net Income: 9,315,163.35 Fin 300 Page: 37 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue. Account 30-00-392-010 30-00-392-011 Descriplion Transfer from General Fund Transfer from Sewer Fund 392 Total 00Total Prior Yr Rev Anticipated Curr Rev 0.00 150,000.00 0.00 400,000.00 0.00 550,000.00 0.00 550,000,00 0.00 550,000.00 YTD. Rev Cancel 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Current 0.00 0.00 0.00 Excess/Deficit % Real 0.00 150,000.00- 0 0.00 400,000.00- 0 0.00 550,000.00- 0 0.00 550,000.00- 0 0.00 550,000.00- Fund 30 Revenue Totals 0 30 Fund Revenues: Expenditures: Net Income: Prior 0.00 0.00 0.00 YTD 0.00 0.00 0.00 A37 Page: 38 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue Account 35-00-300-000 35-00-341-000 35-00-341-100 Description LIQUID FUEL FUND REVENUES Interest Earnings PLGIT Prime 341 Interest Earnings Motor Vehicle Fuel Taxes Miscellaneous Fund Balance Forward 00 Total Prior Yr Rev Anticipated Curr Rev YTD Rev Cancel 0.00 0.00 0.00 992.37 4,819.44 0.00 0.00 0.00 0.00 992,37 4,819.44 0.00 0.00 0.00 Excess/Deficit %Real 0.00 0 3,319.44 321 0.00 0 3,319,44 321 4,452.17 102 0.00 0 0.00 800.15 0.00 800.15 0.00 1,500.00 0.00 1,500,00 35-00-355-050 35-00-380-000 35-00-399-000 222,429.30 226,606.00 0.00 229,099.41 201,750.52 452,328.86 429,856.52 452,328.86 429,856.52 Prior Yr Expd Budgeted 0.00 0.00 0.00 93,825.04 105,000.00 93,825.04 105,000.00 0.00 0.00 0.00 0.00 0.DO 0.00 0.00 0.00 0.00 0.00 231,058.17 0.00 0.00 0.00 6,308.75 992.37 242,186.36 992,37 242,186.36 Current Expd YTD. Expended Cancel 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 195,441.77- 3 0.00 187,670.16- 56 0.00 187,670.16- 56 Balance % Expd 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 105,000,00 0 0,00 105,000.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 Fin38 LIQUID FUEL FUND Revenue Totals Expenditure Account Description 35-00-000-000 35-00-430-000 35-00-430-740 35-00-430-741 LIQUID FUEL FUND LIQUID FUELI PURCHASES Vehicle Purchase Salt, Etc. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 430 LIQUID FUEL PURCHASES HWYI MANTENANCEHWT REPAIRS Driver Wages Dental Insurance Optical Insurance Health Insurance Life Insurance FICA Longevity Overtime 35-00-438-000 35-00-438-142 35-00-438-152 35-00-438-155 35-00-438-156 35-00-438-158 35-00-438-161 35-00-438-182 35-00-438-183 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Page: 39 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure. Account Description 35-00-438-220 35-00-438-313 35-00-438-341 35-00-438-452 Prior Yr Expd Budgeted 0.00 4,051.63 0.00 18,889.50 200,000.00 22,941,13 219,000.00 0.00 116,766.17 324,000.00 116,766.17 324,000.00 Current Expd YTD. Expended Cancel Balance %Expd 0.00 0.00 0 0.00 11,766.92 35 0.00 1,000.00 0 0.00 200,000.00 0 0.00 212,766.92 3 0.00 0.00 0 0.00 317,766.92 2 0.00 317,766.92 2 Operating Supplies Engineering Fees Advertising Contract Paving 0.00 18,000.00 1,000.00 0.00 993.71 0.00 0.00 993.71 0.00 993.71 993.71 Current 992.37 993.71 1.34- 0.00 6,233.08 0.00 0.00 6,233.08 0.00 6,233.08 6,233.08 438 HWY MAINTENANCE-WYI REPAIRS Due to/Due from Payroll Fund 00 LIQUID FUELFUND 35-00-501-700 0.00 LIQUID FUEL FUND Expenditure Totals 35 LIQUID FUEL FUND Prior 452,328,86 116,766.17 335,562.69 YTD 242,186.36 6,233.08 235,953.28 Revenues: Expenditures: Net Income: fi39 Page: 40 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Revenue Account 36-00-300-000 36-00-301-000 36-00-301-100 36-00-301-500 Description LIBRARY FUND REVENUES REAL ESTATE TAXES Real Estate Taxes-Current Real Estate Taxes-Liened 301 REAL ESTATE TAXES Library Fines Interest Eamings State Aid Table Game Revenue 354 Total ARAD Library Rentals Miscellaneous Contributions & Donations Fundraising Proceeds Computer Fees Revenue 387 Contributions & Donations Fund Balance Forward 00 Total Prior Yr Rev Anticipated Curr Rev YTDA Rev Cancel 0.00 0.00 0.00 0.00 0.00 0.00 8,599.27 86,973.74 0.00 61.42 1,520.88 0.00 8,660.69 88,494.62 0.00 0.00 201.80 0.00 18.76 115.68 0.00 0.00 36,399.00 0.00 0.00 2,972.00 0.00 0.00 39,371,00 0.00 7,338,00 78,600.13 0.00 0.00 0.00 0.00 65.20 207.31 0.00 213.60 4,356.15 0.00 159.54 706.33 0.00 108.78 667.27 0.00 481.92 5,729.75 0.00 0.00 98,339.79 0.00 16,564.57 311,060.08 0.00 16,564.57 311,060.08 0.00 Current Expd YTD Expended Cancel Excess/Deficit %Real 0.00 0 0.00 0 23,026.26- 79 4,479.12- 25 27,505.38- 76 1.80 101 65.68 231 1.00- 100 1,728.00- 63 1,729.00- 96 1,449,87- 98 0.00 0 292.69- 41 10,643.85- 29 293.67- 71 167.27 133 10,770.25- 35 2,113.61- 98 43,793.32- 88 43,793.32- 88 Balance % Expd 0.00 0.00 0 0.00 0.00 0 finyo 0.00 0.00 84,630.90 110,000.00 4,864.15 89,495.05 116,000.00 27.65 28.54 31,048.00 3,099.00 34,147,00 39,303.00 0.D0 68.00 3,947.35 879.32 249.75 5,076.42 0.00 0.00 6,000.00 36-00-331-200 36-00-341-000 36-00-354-070 36-00-354-071 200.00 50.00 36,400.00 4,700,00 41,100,00 80,050.00 0.00 500.00 15,000.00 1,000.00 500.00 16,500.00 36-00-357-036 36-00-367-600 36-00-380-000 36-00-387-000 36-00-387-100 36-00-387-300 36-00-399-000 133,167.40 100,453.40 301,313.06 354,853.40 301,313.06 354,853.40 Prior Yr Expd Budgeted 0.00 0.00 LIBRARY FUND Revenue Totals Expenditure. Account Description 36-00-000-000 36-00-403-500 LIBRARYFUND Real Estate Tax Refunds 0.00 0.00 0.00 0.00 0.00 0.00 Page: 41 Castle Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 36-00-456-000 36-00-456-130 36-00-456-133 36-00-456-134 36-00-456-140 36-00-456-141 36-00-456-142 36-00-456-156 36-00-456-158 36-00-456-161 36-00-456-210 36-00-456-220 36-00-456-222 36-00-456-226 36-00-456-247 36-00-456-248 36-00-456-250 36-00-456-252 36-00-456-253 36-00-456-254 36-00-456-321 36-00-456-325 36-00-456-354 36-00-456-360 36-00-456-373 36-00-456-380 36-00-456-420 36-00-456-451 Prior Yr Expd Budgeted 0.00 31,402.98 19,384.68 21,840.00 12,472.00 281.25 2,735.40 9,099.91 709.80 6,710.53 1,542.93 891.11 1,469.85 661.66 9,874.83 900.97 0.00 1,890.50 4,269.33 2,889.89 955.56 118.00 333.20 0.00 0.00 273.74 461.74 875.00 Current Expd YTD. Expended Cancel Balance %Expd 0.00 0.00 0 0.00 24,134.55 59 0.00 16,922.95 58 0.00 17,503.00 58 0.00 11,827.18 54 0.00 2,850.00 63 0.00 3,620.04 47 0.00 5,594.61 64 0.00 564.32 67 0.00 5,153.19 60 0.00 1,176.89 22 0.00 882.87 41 0.00 1,250.14 37 0.00 463.15 63 0.00 8,622.73 46 0.00 404.64 66 0.00 0.00 0 0.00 19.57- 100 0.00 1,559.51 65 0.00 1,658.42 59 0.00 124.44- 107 0.00 191.95 4 0.00 184.15 56 0.00 361.46 0 0.00 0.00 0 0.00 0.00 0 0.00 51.00 91 0.00 0.00 100 Finyl LIBRARY Library Director Children's Librarian-ARAD Clerical Library Assistants Programming Part-Time Janitorial Health Insurance Life Insurance FICA Office Supplies Computer Supplies Library Supplies Janitorial Supplies Adult Reference Books Periodicals CD/ideo Games Audio Material Children's Books DVD Telephone Postage Workers Compensation Utilities Building & Maintenance Miscellaneous Dues & Memberships Contracted Services 0.00 58,319.00 40,000.00 41,371,00 25,600.00 7,800.00 6,802.00 15,435.00 1,700.00 13,000.00 1,500.00 1,500.00 2,000.00 1,250.00 16,000.00 1,200.00 0.00 5,659.00 4,500.00 4,000.00 1,800.00 200.00 417.00 361.46 0.00 0.00 550.00 900.00 0.00 6,830.16 4,615.41 4,773.60 2,929.96 1,350.00 654.00 1,405.77 141.96 1,611.12 24.99 0.00 12.99 30.56 464.05 54.99 0.00 0.00 193.42 282.50 194.39 8.05 40.53 0.00 0.00 0.00 0.00 0.00 0.00 34,184.45 23,077.05 23,868.00 13,772.82 4,950.00 3,181.96 9,840.39 1,135.68 7,846.81 323.11 617.13 749.86 786.85 7,377.27 795.36 0.00 5,678.57 2,940.49 2,341.58 1,924.44 8.05 232.85 0.00 0.00 0.00 499.00 900.00 Page: 42 Castie Shannon Borough JULY2023 08/08/2023 11:09AM Expenditure Account Description 36-00-456-453 36-00-456-460 36-00-456-462 36-00-456-463 36-00-456-745 36-00-456-746 Prior Yr Expd Budgeted 1,901.46 172,57 2,959.35 2,029.06 6,843.40 0.00 145,950.70 272,908.46 0.00 60,000.00 0.00 145,950.70 332,908.46 145,950.70 332,908,46 Current Expd YTD. Expended Cancel 121.36 0.00 499.66 208.39 428.81 0.00 26,876.67 163,737.09 0.00 0.00 26,876.67 163,737.09 26,876.67 163,737.09 Current 16,564.57 26,876.67 10,312.10- Balance %Expd 0.00 1,155.32 67 0.00 208.13 58 0.00 2,110.30 65 0.00 1,511.16 62 0.00 646.28- 109 0.00 0.00 0 Fumniture & Equipment Training & Conferences Public Relations/Programs Children's Programs EINLeasing-ARAD Other Operating Expenditures 456LIBRARY 3,500.00 500.00 6,000.00 4,000.00 7,044.00 0.00 2,344.68 291.87 3,889.70 2,488.84 7,690.28 0.00 0.00 109,171.37 60 0.00 60,000.00 0.00 36-00-492-180 36-00-501-100 Transfer to Government Account Due to/Due from Payroll Fund OOLIBRARY FUND 0.00 0.00 0 0.00 0 0.00 0.00 169,171.37 49 0.00 169,171.37 49 LIBRARY FUND Expenditure Totals 36 LIBRARY FUND Prior 301,313.06 145,950.70 155,362.36 YTD 311,060.08 163,737.09 147,322.99 Revenues: Expenditures: Net Income: Grand Totals Prior Current 2,180,967.59 2,435,885.30 254,917.71- 14,894,436.04 YTD 23,017,392.79 8,122,956.75 Revenues: 21,694,651.58 Expenditures: 5,705,678.14 Net Income: 15,988,973.44 F143 lunicipality Receipt Document astle Shannon Boro CASTLE SHANNON Real Estate Transfer Tax Issued - Detail by Tax District/Selective Allegheny County, Jessica Garofolo, Department ofk Real Estate For Jul01, 2023 thru Jul31,2023 Recorded Partyoft theF First Part Entity Base Commission Commission Payment Consideration TaxAmount Percent Amount Amount Number Number Vol/Page Tax Number Date Party of the Second Part 4261346 17196 19351 198 T14261 07/03/2023 DEFAZIO NICHOLASJ Location- CASTLE SHANNON Ward/ /BIklot- 99-NO WARD Certificate- JOSEPHEKATHLEENI DEFAZIO 3518E ELMAVE PITTSBURGH PA 15234 Location- CASTLE SHANNON Ward/Biklot- 99-NO WARD Certificate- SOUTHHILLSREAL ESTATELLC 108VALLEYDR. BEAVER PA 15009 Location- CASTLE SHANNON Ward/BiKlot- 99-NO WARD Certificate- PLAZAHOME! MTGINC 9808 SCRANTONRD SAN DIEGO CA 92121 Location- CASTLE SHANNON Ward/Biklot- 99-NOV WARD Certificate- TIMOTHY SSCHALL 370LYNDELLST PITTSBURGH PA 15234 Location- CASTLE SHANNON Ward /BIklot- 99-NO WARD Certificate- RETREDLLC 11WOODSIDE AVE BERWYN PA 19312 Location- CASTLE SHANNON Ward/Biklot- 99-NOWARD Certificate- PRUDENTIAL REALTYCO 3700SWATERST: STE1 100 PITTSBURGH PA 15203 .00 0191M0022200000 0.00 .0200 0.00 .00 Exempt Override Affidavit Exempt Override Affidavit Exempt Override Affidavit Exempt Override 0250300138000000 Affidavit Exempt Override 0190600035000000 Affidavit Exempt Override 0191H00086900000 Affidavit 0191H0009000000 DEFAZIO JOSEPH 4261508 17273 19352 67 T14338 07/03/2023 SMITHSANDRAL 60,000.00 01906003420000 300.00 .0200 6.00 294.00 SOUTHHILLS REAL ESTATELLC 4262505 17571 19355 133 T14599 07/06/2023 COLEMAN, JOSEPH 170,000.00 0190N00206000000 850.00 .0200 17.00 833.00 VLIOAMOWARDSALAREZ 4263067 17733 19357 134 T14713 07/07/2023 CHRISTINE LYNNE BROOKLINELLC 145,000.00 0250G0013800000 725.00 .0200 14.50 710.50 SCHALLT TIMOTHYS 4263833 17985 19359 531 T14928 07/11/2023 SINGH. JAGPINDER 144,900.00 0190600035000000 724.50 .0200 14.49 710.01 RETREDLLC 4264361 18173 19361 484 T15101 07/12/2023 ENGELBERG MAURICE .00 0191H000860000 0.00 .0200 0.00 .00 ENGELBERGI MAURICEATRUST rintedBy: PhillipHunkele From Workstation: ADMIN0S On:Aug02,2023 08:33a RM2020PerietlVsion GA AlIRights Reserved (sg!) Page1of4 psc - I lunicipality Receipt Document astle Shannon Boro CASTLE SHANNON Real Estate Transfer Tax Issued - Detail by Tax DistrictSelective Allegheny County, Jessica Garofolo, Department ofReal Estate For Jul01, 2023 thru Jul 31, 2023 Recorded Party oft the FirstF Part EntityE Base Commission Commission Payment Consideration TaxAmount Percent Amount Amount Number Number Vol/Page Tax Number Date Partyoft the Second Part 4264361 18174 19361 490 T15102 07/12/2023 HEINN MARILYN Location- CASTLE SHANNON Certificate- PRUDENTIAL REALTY 3700SWATERST STE100 PITTSBURGH PA 15203 Location- CASTLE SHANNON Certificate- MAURCILYNF RUBIN 4425 WELLINGTONI DR FORT COLLINS CO 80526 Location- CASTLE SHANNON Ward/ /Biklot- 99-NOV WARD Certificate- LARRY DBUCHER TRSTE 205-CASTLERD PITTSBURGH PA 15234 Location- CASTLE SHANNON Ward/Biklot- 99-NOWARD Certificate- CORELOGIC ATTNBILLS RECEMVED 3001 HACKBERRY RD IRVING TX 75063 Location- CASTLE SHANNON Ward/ /Biklot- 99-NO WARD Certificate- PENNYMACI LOAN SERVICESLLC 3001 HACKBERRY RD IRVING TX 75063 Location- CASTLE SHANNON Ward/Biklot- 99-NOV WARD Certificate- ALLANAMI KONDISKO JOSEPHRI KONDISKO 215W0 CHURCHST LIGONIER PA 15658 .00 0191H0008600000 0.00 .0200 0.00 .00 Exempt Override 0191-00086900000 Affidavit 0191H0008800000 0191H0009000000 0191H00094000000 Exempt Override 0191H0008600000 Affidavit 0191H00088000000 0191-0009000000 HEINI MARLPISREVOCABLETAUST Ward/ /Biklot- 99-NO WARD 4264361 18175 19361 496 T15103 07/12/2023 RUBIN MAURCILYN .00 0191H000860000 0.00 .0200 0.00 .00 RUBIN MALRCILVNEREVOCALE TRUST Ward/ Biklot- 99-NOV WARD 4264390 18186 19361 565 T15114 07/12/2023 BUCHERLARRYD .0200 0.00 .00 Exempt Override 0249A00242000000 Affidavit Exempt Override 0190C0020000000 Affidavit Exempt Override Affidavit Exempt Override 0190K00020000000 Affidavit BUCHERL LARRYDTRSTE 0249A00242000000 4264501 18243 19362 334 T15164 07/12/2023 MEYHARRYC 170,000.00 0190C0020000000 850.00 .0200 17.00 833.00 SMITHCATHERNEM 4265355 18517 19365 283 T15402 07/14/2023 HARRISON CONCETTAEST .00 0191D0012200000 0.00 .0200 0.00 .00 HARRISON! DONALD 4265850 18678 19367 34 T15547 07/17/2023 KONDISKO. JOSEPHR .00 0190K0002000000 0,00 .0200 0,00 .00 KONDSOALAMAMIRSTE rinted By:F PhillipHunkele From Workstation: ADMIN05 On:Aug02, 2023 08:33a RM2 20/20 Perfect Vision @ All Rights Reserved (sg!) Page2of4 a PyC lunicipality Receipt Document astle Shannon Boro CASTLE SHANNON Real Estate Transfer Tax Issued Detail by Tax DistrictSelective Allegheny County, Jessica Garofolo, Department ofReal Estate For Jul01, 20231 thru Jul31,2023 Recorded Partyoft the First Part Entity Base Commission Commission Payment Consideration TaxA Amount Percent Amount Amount Number Number Vol/Page Tax Number Date Partyoft the Second Part 4267274 19081 19371 66 T15886 07/20/2023 NONES THERESAM Location- CASTLE SHANNON Ward/ BIKlot- 99-NOWARD Certificate- LAURAPELLEGRINI UNITED WHOLESALE! MORTGAGELLC POBOX2 202028 FLORENCE SC 295022028 Location- CASTLE SHANNON Ward/ BIKlot- 99-NO WARD Certificate- ERIC. JKOWALSKI ANNETTELI KOWALSKI 3553 LIBRARY RD PITTSBURGH PA 15234 Location- CASTLE SHANNON Ward/BIklot- 99-NOV WARD Certificate- BAY EQUITYHOME! LOANS 9261 THIRDA AVE STE2 201 NEW BRIGHTON PA 15066 Location- CASTLE SHANNON Ward/ /Biklot- 99-NO WARD Certificate- UNITED WHOLESALE MTGLLC POE BOX 202028 FLORENCE Sc 295022028 Location- CASTLE SHANNON Ward/Biklot- 99-NOV WARD Certificate- AARON PLOPISHILLARYI PLOPI 1715. JANET DR PITTSBURGH PA 15234 185,000.00 0250J00068000000 925.00 .0200 18.50 906.50 Exempt Override 0250100068000000 Affidavit Exempt Override Affidavit Exempt Override 0249F00222000000 Affidavit Exempt Override 0190H00324000000 Affidavit Exempt Override Affidavit PELLEGRINILAURAL 4267433 19157 19371 528 T15956 07/20/2023 DUNEGANI RAYMONDI DANIEL EST 46,500.00 0190N00184000000 232.50 .0200 4.65 227.85 KOWALSKI ERICJ 4269236 19726 19377 430 T16460 07/26/2023 GORTONA ANNE M 200,000.00 1,000.00 .0200 0249F00222000000 20.00 980.00 YOUNGI BRIAN 4269373 19760 19378 22 T16493 07/27/2023 BARSZCZ CHRISA TRSTE 155,000.00 0190h0032400000 775.00 .0200 15.50 759.50 GATETE BLAISEP 4269628 19819 19378 365 T16541 07/27/2023 BOXHEIMER WILLIAMI NEIL .00 0250P0002600000 0.00 .0200 0.00 .00 PLOPIAARON rinted By: Phillip Hunkele From Workstation: ADMIN05 On:Aug02, 2023 08:33a RM20/20 Perfect Vision @ AIIRighis Reserved (sgl) Page3of4 PEC3 lunicipality Receipt Document astle Shannon Boro CASTLE SHANNON Real Estate Transfer Tax Issued - Detail by Tax District/Selective Allegheny County, Jessica Garofolo, Department ofR Real Estate For Jul01, 20231 thru Jul31,2023 Recorded PartyoftheFistPart Entity Base Commission Commission Payment Consideration TaxAmount Percent Amount Amount Number Number Vol/Page Tax Number Date Partyo of the Second Part 4270014 19948 19379 551 T16645 07/28/2023 MONTERO MANUELG Location- CASTLE SHANNON Ward/Biklot- 99-NO WARD Certificate- ROCKET MORTGAGELLC POE BOX 6577 CAROL STREAM IL 60197 182,500.00 0250AD0140000000 912.50 .0200 18.25 894.25 Exempt Override 0250A00140000000 Affidavit LAZARUS MATTHEW CASTLE SHANNON Castle Shannon Boro 7,294.50 7,294.50 145,89 7,148.61 145.89 7,148.61 rinted By: PhillipH Hunkele From Workstation: ADMIN05 On:Aug.02, 2023 08:33a RM2 20/20F Perfect Vision @ AlRights Reserved (sgl) Page4of4 PIc4 8/11/2023 Paul Vietmeier Corrected Date Regular & Certified Corrected Date Çorrected Date Corrected Date Regular & Certified Regular & Certified Corrected Date Regular and Certified Regular and Certified Corrected Date Regular & Certified Regular and Certified waiting for hearings waiting for hearings Waitingf for hearing date 3more citation Regular & Certified Corrected Date Regular and Certified Street 259 McCully Road Street 284 Library Road Street 226 Rolling Rock Street 105 McRoberts Road 336 Rolling Rock Road 587 Oakdale. Ave Street 100 McCully Road 106 Library Road 123 Library Road 569 Lindenwood Drive Street 129 Grove Road 213 Belleville Street 314 Glen Shannon Dr 344 Grove Road 387 Grove Road 531 Library! Road 549 Grove Road 704 Grove Road 705 Sleepy Hollow Road Street 144 Library Road 148 Grove Road 163 Belleville Street 164 Grove Road 168 Library Road 178 Prospect Ave 197 Sleepy Hollow Road 273 Prospect Ave 322 Belleville Street 327 Willow Ave 340 Cooke Drive 343 Cooke Drive 349 Myrtie Ave. 397 Killamey Drive No Name 1402 Wayne Less No Name 3301 Budget Transmission No Name 914 Floyd Arbogast No Name 3141 Thomas A Moses 914 Floyd L. Arbogast 910 Frank RN Menardi No Name 1402 Wayne ALess 3840 Anthony Fazio 3301-3307 James Busch No Name 1301 apt 2 Robert Nagy 2909 Zachary Myles Diberadin 567 Kopila Thapa 1301 Robert Nagy 1301 Robert Nagy 3603 Original Gyro 1301 Robert Nagy 1301 Robert Nagy 900 Daharmishtha Lodaliya No Name 3421 Jason Alan Roberts 1301 apt 2 Robert Nagy 2909 Christopher Schmitt 1301 Robert Nagy 1220 RetredLLC 921 Lobos Management 1220 Retredl LLC Ashish Shah 2909 Christopher Schmitt 3762 William DNedzesky 786 A Schnabletier LLC 811 Jodi L Doyle Violation- 2014 did not comply with occupancy violations &p parking on Grass 10/1/14 Violation- 2016 remove banner, and clean-up debris in parking lot Violation- 2017 Camper int the driveway Violation- 2019 Date Date to Correct 11/1/14 Date Date to Correct 12/29/16 1/5/17 Date Date to Correct 6/6/18 6/11/18 Date Date to Correct 4/29/19 7/20/19 12/20/19 12/31/19 Date Date to Correct 2/20/20 4/5/20 2/26/20 4/30/20 3/11/20 5/30/20 9/29/20 10/4/20 Date Date to Correct 2/23/21 2/24/21 4/14/21 5/17/21 5/22/21 6/10/21 8/10/21 8/13/21 1/7/22 Date Date to Correct UCC hearing ont the lack ofp progress to take out of Condemn 4/17/19 Unsanitary Conditions: Trailer, outside storage, Junk Vehicle 7/10/19 2nd notice for Rental Unit Registration Violation- 2020 Junk' Vehicles int the back yard Land use violations storage of. Junk Cars Violation- 2021 808 Ronald C&. Janet R Sabatasso no Occupancy Registration 2nd noticei for feeding the animals & $25.00 ticket fine 2nd Garbage and cans at the curb, and storage ofp pallets ini 4/9/21 Building a Roof over a deck with no permit 2nd time submitting citations feeding animals &i infestation 5/27/21 another 2 citations forf feeding Animals & Birds Sanitationi issue int the back, blocking clear site exiting the lot 8/5/21 2 citations feeding animals, Infestation ofr rodents 3 more citations feeding animals, uninhabitable, infestation 12/17/21 operating a Mini MarlConvenience: store ina a R-2 District 12/27/21 Roof leaking inside Apt2 2, No Sign permit, or unit registration 3/7/22 3/18/22 another 2 citations forf feeding animals and birds, rodents 3/10/22 2011 Carry-on Trailer and ATVi int the front oft the house Installed gravel and no permitf for a parking pad no Occupancy forr new tenants, unit registration, on grass 5/5/22 2nd Notice gravel ons street, no pad permit & Occ+Unit Reg. 5/24/22 2nd notice for trailer, 311 appl High Grass High Grass and no Unit Registration Garbage out, no Unit registration no Occupancy or Unit Registration Violation- 2022 3/28/22 3/30/22 4/1/22 4/12/22 3/30/22 Regular and Certified was received 6/11/22 4/17/22 issued: 2 more waiting for a hearing date 6/3/22 issued 2 more waiting for al hearing datel 6/9/22 6/14/22 Regular and Certified was received 6/11/22 2 more citations 3757 Pele Castle Shannon LLC Dustin. JorLandslide between 375583757: along Fountain Road 4/11/22 5/15/22 6/10/22 6/15/22 6/15/22 6/22/22 6/25/22 7/8/22 7/15/22 regular and certified Regular and Certified justt the grass was cut 7/11/2022 Regular and Certified 781 Apt1 Stevenson' Williams Management DcUninhabitable: contains filth and contamination, mold Lack M 6/13/22 7/28/22 3750 Pittsburgh Myanmar Christian Fellow, Needs a Grading Permitf fort the retaining wall for parking 6/15/22 5 c5 Page 1 of8 8/11/2023 Paul Vietmeier 424 Riehl Drive 430 Rosalia Ave 446 Library Road 456 Prospect Ave 470 Library Road 473 Rosalia Ave 481 Lyndell Street 535 Saint Anne Street 546 Library Road 597 Saint Anne Street 664 Prospect Ave 665 Saint. Anne Street 677 Green Ct. 708 Park Avenue 774 Middleboro Road 817 Broadway Ave 837 Rosalia Ave 865 Saint Anne Street 869 Cooke Drive 884 Broadway Ave 902 Murrays Ln 909 Pine Avenue 915 Sleepy Hollow Road 941 Highland Villa Drive 942 Broadway Ave 954 Murrays Ln 978 Middleboro Road 1022 Lyndell Street Street 115 Castle Shannon Blvd 194 Prospect Ave 195 Sleepy Hollow Road 203 Saint Anne Street 230 Willow Avenue 234 Hamilton Road 242 Library Road 265 Steiger Street 317 Willow Avenue 323 Willow Avenue 327 Saint Anne Street 740 Sarah Rappaport 3521 Linda Ann Daube 3301 & 3307 James Busch. Jr. 1220 Asif Shah 3421 Jason Alan Roberts 3521 Linda Daube 938 Marshall Gregory 3505 Realty Income Trust6 938 Marshall Gregory 1220 Asif RetredLLC 938 Marshall Gregory 222 Andrew Sweiter 918 H&P Partners LLC 3564 Caley PI Mangan 3521 Linda Ann Daube 938 Marshall Gregory 797B Joann Groman 289 Linnea Rae Ondick 967 Adam & Samantha Elliott 1412 John Jay Thigpen II 289 Linnea Rae Ondick 3564 Caley PI Mangan 3800 Tania Wang No Name 1106 Josephine McGonigle 1220 Ashesh Shan 967 Samantha and Adam Elliott 917-919 Barry T Langan 3827 Debbie Schweiger 1349 Joshua Bush 3611 Original Gyro 4102 Matthew Stonebraker 3926 Barry TL Langan 3855 John French 911 Richard PI Fest Installed a fence with no permit High Grass and weeds, house needs repairs Banner Sign and abandoned Castrol sign, High Grass 4Citation parking pad, Rental Unit Reg. Occupancy, Gravel 7/29/22 2nd notice ony violations from 3/7/22, weeds, no occupancy 8/3/22 2nd notice for High Grass and Weeds Dog Feces disposal ofr rubbish, sanitation and means of egres 8/17/22 $25.00 Ticketf for high grass 2nd Notice for dog Feces disposal ofr rubbish, sanitation Another 4 Citations submitted 30 citations submitted Re-occurrence ofs sanitation conditions &F Rodents No gutter for proper drainage 4r more citation No Occupancy and no Unit Registration 2003 toyota with expired plate & Stickers no Occupancy for the tenants Unsafe side Deck with not floorboards and railings Junk Ford F-150 expired stickers No Unit Registered Violation- 2023 7/25/22 8/4/22 7/27/22 10/25/22 7/28/22 8/2/22 8/10/22 8/3/22 8/8/22 9/4/22 8/22/22 8/19/22 8/24/22 8/31/22 9/5/22 9/15/22 9/15/22 9/20/22 9/21/22 10/18/22 10/28/22 10/27/22 11/4/22 11/7/22 11/8/22 11/15/22 11/9/22 11/18/22 11/18/22 11/28/22 11/28/22 issued 2 more waitingf for al hearing date Regular and Certified Regular and Certified Regular and Certified waiting for hearing datel Regular and Certified waitingf for hearing date issued 2 more Waiting for the hearing datel Waiting for the hearing datel Regular and Certified Regular and Certified waiting for hearings Regular and Certified Regular and Certified 7/19/23 Regular and Certified Ford gone on 2/7/23 3707 Catherine & Clair Smith Brothers Tarpi iny yard, no electric, chimney, porchf foundation, vacant 8/4/22 Doingy work without a permit and conditional OCC. ran out 9/27/22 10/12/22 2nd notice for repairs not being completed on the property 11/1/22 11/30/22 3215 Milton E&I Dorothy Hamel Jr. Tree causing damage porch roof 3215 Milton E&I Dorothy Hamel Jr. 2nd notice for Rotted roof and tree causing damage 958 Apt2 Marco A&I Martha Honores Recycling out too early, no Occupancyfor tenants, no Unit 11/21/22 11/26/22 11/21/22 11/28/22 Unauthorized Busness Regular and Certified 12/8/22 12/8/22 12/9/22 12/6/22 12/16/22 12/14/22 12/15/22 Date Date to Correct 1/30/23 2/10/23 2/20/23 2/23/23 3/3/23 3/9/23 3215 Milton E&I Dorothy Hamel Jr. 3rd notice Rotted roof, broken gutter and tree causing damag 11/28/22 2nd Notice 2003 Toyota and 2007 Ford with expired plates ar 11/29/22 Corrected Date Garbage out before 6:001 Pm, No Occ, & No Unit Registration 1/25/23 Gravel and mud into the street al MS4 issue parked on Grass 2/10/23 2/14/23 issued 2r morecitations waiting fort the hearing Unauthorized Home Base Busniess Trash left at the curb, no rental Unit and No Occupancy 2/14/23 2/19/23 No Occupancy for Polished Nails Studio & Spa Dead trees out front that pose at threat to the road & Public 2/23/23 Unsafe equipment Did not complete violations for Occupancy and rental Garbage out before 6:00 Pm & no Occupancy: & unit Registra 3/30/23 Feeding birds causing rodent problems and close tot the creel 3/31/23 2nd Notice Gradinglexcavating in vacant lot with no permit 4/4/23 Regular and Certified Regular & Certified 2/28/23 3/9/23 4/3/23 3/16/23 4/6/23 4/2/23 submit citation on5/17/23 4/11/23 Regular and Certified 6o pdc Page 2 of8 8/11/2023 Paul Vietmeier 341 Castle Shannon Blvd 347 Sleepy Hollow Road 371 Willow Avenue 372/Pine Avenue 373 Library Road 391 Connor Rd 396 Prospect Ave 410 Connor Road 476 Library Road 479 Home Ave 488 Home Ave 539 Broadway Ave 547 Baldwin Street 554 Library Road 557 Willow Avenue 564 McCully Road 567 Londonderry Drive 629 Library Road 631 Redwood Drive 638 Castle Road 662 Poplar Avenue 663 Broadway Ave 665 Home Ave 666 Broadway Avenue 671 Broadway Ave 672 Willow Ave 673 Library Road 674 Pine Avenue 675 Broadway Ave 688 Thornwood Drive 690 Pine Avenue 691 Poplar Avenue 692 Poplar Avenue 721 Broadway Ave 722 Broadway Ave 725 Poplar Avenue 727 Prospect Ave 732 Highland Villa Drive 733 Middleboro Road 735 Library Road 1116 Raymond Lackner 964 9624 Sleepy Hollowl LLC 3855 John French Parapet, lintels, Windows Collapsing ont the Southwestern sic 4/14/23 Immediate Regular & Certiffed 30 days just toget permits records show as vacant, no unit registration 2nd Noticef for feeding the birds causing rodent problems 4/19/23 4/17/23 4/18/23 4/21/23 4/19/23 5/3/23 4/19/23 5/3/23 4/25/23 5/5/23 4/26/23 5/12/23 5/9/23 11/9/23 5/10/23 5/20/23 5/10/23 5/15/23 5/15/23 5/31/23 5/17/23 5/17/23 5/27/23 5/28/23 6/2/23 6/14/23 7/6/23 6/17/23 6/18/23 submit citation on5/17/23 Regular and Certified wait fora a Hearing Date Regular and Certified waiting for hearing date grass only on 7/17/23 Waiting for hearing grass only on 7/30/23 just the grass on 5/24/23 Regular and Certified extention till August 6th Waiting for the hearing date Waiting for the hearing date Waiting for the hearing date Waiting fort the hearing date Waiting fort the hearing date Waiting for the hearing date 905 Skylar Stewart PGHI Property Group No Occupancy. no unit registration parking on the grass 3547 Skylar Stewart PGH Property Group No Occupancy, no unit registration 1061 Matthew Templeton 1220 Ashesh Shah 1013 John McGhee 3138 Jagpinder Singh 3254 Rashid HE Boumasoud 921 CKZ Properties LLC 3301 James & Michele Busch. Jr 3855 John French 1404 Michael AH Kalanish 4156 Paul & Kathy Hess 985 Donald &A Amyl Krtanjek 153 Mary El Munnell 3254 Rashid HE Boumasoud 3006 Christine ETatka 3254 Rashid HI Boumasoud 3254 Rashid! HI Boumasoud 3855 John French Trailers parkedi inf front of house 2 citationf for gravel in the street and and no parking pad 2nd noticet trailer infront ofH house, and building and scrape 5/2/23 3563 OAP Ventures LLC. James Brocato Condemed for faulty construction & Unsafe Structure 3105 Matthew Simmons Aux Funding LLC/No Occ, No Unit Reg, High Grass High Grass and no Unit Registration 3citations submitted,High Grass,Storage.unk Vehicles No Occupancy for tenant, nou unit registration, high grass 5/16/23 5/26/23 3rd Notice for signage, no unit registration, and High Grass 5/16/23 Citation for Feeding the birds No Occupancy, Violation: since 11/9/20, and High Grass No Occ for new tenant, no unit reg, banner and no sign permi 5/26/23 No reinspection and piling! brush under pine trees int backyard 5/30/23 Walli is crumbling and falling down causing a safety hazard 6/6/23 3 Citation Storage, High Grass, Inoperative vehicles High Grass int the backyard 3r more citations Grass,Slorage.lunk. cars &1 Trailer 3 more citations Grass,Slorage.unk cars & Trailer Citation forf feeding the wildlife 809 RP2ALLI LLCI Maurice Makay 2nd Noticef for High Grass, and No Unit Reg. include 3017Be 5/18/23 3538 Stephen Nickles & Kristy Heslet High Grass in the back yard 6/12/23 6/8/23 6/13/23 6/13/23 6/14/23 6/14/23 6/14/23 6/14/23 6/14/23 6/14/23 6/15/23 6/15/23 6/15/23 6/19/23 6/20/23 6/20/23 6/20/23 6/20/23 6/20/23 6/20/23 7/17/23 3547 Skylar Stewart PGHI Property Group Citation for no occupancy 905 Skylar Stewart PGHI Property Group Citation for no occupancy 3141 Craig D& Karen! Lachappell Front porch crumbling andi inr need of repairs 974 Thomas Owen & Mary Margaret Em High Grass around the parking area 3725 Coccaro & Associates Bob Coccaro No Occupancy and Ford Van with expired stickers 8/14/23 6/15/23 6/20/23 6/25/23 6/25/23 6/25/23 6/25/23 7/20/23 7/1/23 2/15/24 1058 Michael Barron 3730 Stepen Poremski 3254 Rashid! HE Boumasoud 3254 Rashid! HE Boumasoud 3538 Stephen Nickles 1210 AlbertE Byers 1412 John, Jay Thigpen II 3564 Caley P Mangan 3563 James Brocato 2nd Notice Silver Nissan parking on the grass 7/17/23 7/17/23 extent till 7/8/23 7/17/23 Waiting for the hearing date Waiting for the hearing date GreenVan int the parking! lot with expired stickers 3 more citations Grass,Storage, Junk car 31 more citations Grass,Storage, Junk car 2nd notice for high grass in the backyard Weeds along the street are High 2nd Notice for side porch and steps 3rd Notice missing gutter, uninspected ford pickup Condemn the structure, with a 240 day asis 7/31/23 7/19/23 PEC7 Page 3of8 8/11/2023 Paul Vietmeier 737/Connor Road 741 Baldwin Street 742 Baldwin Street 743 Pine Avenue 754 Broadway. Ave 755 Broadway Ave 762 Clara Ave 763 Maple Hill Avenue 767 Elm Avenue 779 Saint Anne Street 785/Edgewood. Avenue 791 Newport Drive 792 Library Road 802 Hastie Road 803 Thornwood Drive 804 Willow Ave 805 Saint Anne Street 806 Frank Street 807 Killarney Drive 808 Kerry Hill Drive 809 Mount Lebanon Blvd 810 Oakdale. Ave 811 Oakdale. Ave 812 Middle Road 813 Pine Avenue 814 Francis Road 816 Belleville Street 817 Home Ave 818 Home Ave 819 Sleepy Hollow Road 822 Mount Lebanon Blvd 823 Willow Avenue 824 Prospect Ave 825 Castle Road 826 Belleville Street 842 Sleepy Hollow Road 846 May Street 847 St. Anne Street 848 Elm Avenue 1013 John McGhee 921 Andy Bekich 919! Charles FE Eberenz 3254 Rashid HE Boumasoud 3254 Rashid HI Boumasoud 1333 Anthony Pellarin 3916 Patricia. Al Bosko 3628 Regis & Helene McQuaide 915 Robert E8 &V Valerie Mally 918 Brent Uselton 3107 WETGO Portfolio IILLC 1043 Khang Nguyen 1006 Alexei Vankirk 3918 Jason & Kayla Bailey 915 Robert E&V Valerie Malley 3800 Jennifer Daube 847 Daniel Mark Kohr 826 Emily MOlah 325 Supercuts 930 Edward! L IIIE Ewing 946 Ron Opatchen 889 David Goudy 1036 Shawn Guy 3017 Ryan Miller 3105 Charles Tipton 971 Ryan Henderson 3768 Gracious living Dev, LLC 271 Olivia Rae Pishioneri 2909 Christopher Scmitt 815 Adnan, Jakupi 3109 Cheyenne Swearingen 940 Natalie Friedrich 3630 Regis & Helene McQuaide Garbage out before 6:00 Pm, tractor &3rd for trailer in drivewi 6/21/23 High Grass and weeds int the backyard, along with brush pile 6/21/23 High Grass & Weeds, with a brush pile inb backyard 3more citations Grass, Storage, Junk car 31 more citations Grass, Storage, Junk car Honda inc driveway expiredi inspection, Outdoor Storage Wall ont the side is deteriorating andi fallingi inr neighbors prope 6/27/23 Pallets laying against the house ons side &back, high grass 6/27/23 Weeds are high around the motorcycles Fence along the road is old and falling down, Hazard to Publi 6/29/23 High Grass, restoons/penants, & no permit for portable sign 7/3/23 High Grass & weeds int the front and side. Shutter hanging 7/10/23 High Weedsi int the front And Driveway. Hedges out of cont 7/10/23 7/15/23 High Grass and weeds around the property 2nd Notice for high grass int front & around the motorcycles 7/10/23 High Grass and weeds int thef front and backyard High Grass and weeds all around the property High Grass and weeds throughout the property Banner Hangign on the front of the building Railing required onf front steps,outdoor storage of building ma 7/11/23 High Grass and weeds throughout the property 2nd noticeinspection is expired on the Silver Mercury Mounta 7/11/23 Dumpster bag and materials in driveway over thirty days 7/11/23 2nd notice Red Cherokee jeep expired on High Grass High Grass and weeds ons side hill and backyard High Grass and weeds High Grass and' Weeds around the property Chair placed out for garbage way too early White Nissan Parked ont the front lawn/grass Trailer and ATVi in front oft the house, next will be a citation 7/12/23 2008 Honda parking ont the grass High Grass and weeds int the backyard Garbage cans left ato curb after pick-up 2nd notice for building materials stored outside 7/1/23 6/26/23 6/26/23 6/26/23 7/2/23 7/2/23 7/2/23 7/3/23 7/29/23 7/13/23 7/8/23 7/15/23 7/10/23 7/15/23] 7/15/23 7/10/23 7/15/23 7/11/23 7/16/23 7/11/23 7/16/23 7/11/23 7/18/23 7/21/23 7/11/23 7/16/23 7/21/23 7/11/23 7/16/23 7/16/23 7/11/23 7/21/23 7/11/23 7/16/23 7/11/23 7/16/23 7/11/23 8/11/23 7/12/23 7/17/23 7/12/23 7/17/23 7/12/23 7/13/23 7/12/23 7/17/23 7/12/23 7/13/23 7/17/23 7/13/23 7/14/23 7/14/23 7/20/23 7/17/23 7/18/23 7/17/23 7/23/23 Trash only 6/26/23 7/17/23 7/17/23 7/17/23 6/21/23 6/21/23 6/22/23 6/23/23 6/27/23 6/28/23 7/3/23 974 Thomas Owen & Mary Margaret Eme 2nd Notice for high grass around the vehicle Waiting fort the hearing date Waiting for the hearing date 8/1/23 only the grass 6/30/23 7/19/23 car only 7/10/23 grass only 7/10/23 grass only on 7/17/23 7/17/23 7/17/23 7/17/23 removed on7/1723waring! 7/19/23 7/18/23 7/24/23 7/17/23 7/19/23 7/19/23 7/17/23 7/17/23 7/18/23 7/17/23 7/17/23 7/17/23 7/17/23 Regular and Certified 7/17/23 7/24/23 7/24/23 930 Frederick C& Carol HBoden High Grass, Silver Mitsubishi stickers expired since 4-19 974 Thomas Owen & Mary Margaret Ems 3rd notice High Grass and around the vehicle 815 Willow Avenue 3829 Rear202 Christine Kuntch 3013 Maceol L& Debral LI Fulmore Rotted backyard wall that's unstable and a hazard 437 Luxury Property Group Aspen High grass & Weeds along Castle Shannon Blvd 1244 Timothy P& Nancy M Geyer High Grass and weeds and across the street,still at tarp Pc8 Page 4 of8 8/11/2023 Paul Vietmeier 849 Hastie Road 850 Frank Street 851 Home Ave 852 Elm Avenue 853 Baldwin Street 854 Saint Anne Street 855 Middleboro Road 856 Willow Avenue 857 Hastie Road 858 Rebecca Street 859 Saint Anne Street 860 Canal Street 861 Middleboro Road 862 Connor Road 863 McCully Road 864 McCully Road 865 Greenridge Road 866 Baldwin Street 867 Baldwin Street 868 Baldwin Street 869 Hastie Road 870 Mt. Lebanon Blvd 871 Baldwin Street 872 Baldwin Street 873 Lindenwood Drive 874 Lindenwood Drive 875 Lindenwood Drive 876 Sleepy Hollow Road 877 Maple Hill Avenue 878 Ulrich Avenue 879 Glen Shannon Dr 880 Thornwood Drive 881 Thornwood Drive 882 Hastie Road 883 Willow 884Willow 885 Willow 886 Killarney Drive 887 Linden Avenue 888 Riehl Drive 1006 Samijoe Jeniqueal Latham 3800 Jennifer Daube 3616 Victoria Ruth 923 Rachel Seiler Sandberg 3572 Karen Sloss 4124 John &E Barbara Fabus 1006 Widad Salim Lako 938 Marshall Gregory 3998 #2 Lisa Yarber 3564 Caley Mangan 1023 Desiree Saunders 1405 Michael Kalanish 4225 Jill & Brian Vogel 859 Laura Scheibel 901 Jenny Moore 914 Carl Marbello 1046 Daniel &I Michele Haney 400 Lebanon Shops Properties 921 Andy Bekich 924 Regis & Elizabeth Ahearn 823 Meredith Ann Hoppe 915 Mark &A Amy Geller 919 Dawn Karger 912 Marissa McGill 911 Josh Mey 536 Donald & Chery! Seese 1016 Lynnel McAllister 1023 Christine Tate 1038 Matthew Miller 3919#2 Aidon Quatana 39201 #1 Carly Beck 3921 #3 Nicholas Morris 816 Charles & Karen Shultz 767 Nadine Dambrosio Silver Honda parked on the grass 2nd notice for high grass and weeds. Vehiçles parkedi int the grass/mud. High Grass and weeds int the front and backyard Garbage cans left at curb after pick-up, front hedges need cu 7/18/23 Washer (garbage) placed out too early. Silver 2017 Hondap parked on grass (let Samijo! Latham know) 7/18/23 7/19/23 High grass and weeds. Inoperable Ford F-150 onj jack stand and parkedi inf front of #2 7/18/23 Last notification for lack ofg gutters/downspouts. Weeds Recycle container left out att the curbf for more than ay week. 7/19/23 2nd notice fort the weeds, brush pile, pallets, broken fence 7/19/23 High grass, weeds and shrubs, #'s noty visible, hedges high 7/19/23 Hedges out of control and encroaching walkway Hedges out of control and encroaching walkway Garbage out before designated time. Multiple times Chair plaçed out for garbage way too early Area has high weeds and fence around dumpster is damagec 7/19/23 Garbage out before designated time. Not the first time for this 7/19/23 High grass and weeds. Hedges/bushes are a little out of conti 7/19/23 7/17/23 7/18/23 7/18/23 7/23/23 7/18/23 7/23/23 7/18/23 7/19/23 7/18/23 7/23/23 7/18/23 7/23/23 7/19/23 7/18/23 7/19/23 7/18/23 7/23/23 7/18/23 7/23/23 7/28/23 7/19/23 9/19/23 7/20/23 7/29/23 7/29/23 7/19/23 7/29/23 7/19/23 7/29/23 7/19/23 7/20/23 7/19/23 7/20/23 8/19/23 7/19/23 7/21/23 7/21/23 7/19/23 7/21/23 7/19/23 7/21/23 7/21/23 7/19/23 7/21/23 7/19/23 7/21/23 7/19/23 7/21/23 7/19/23 7/21/23 7/19/23 7/21/23 7/19/23 7/21/23 7/19/23 7/21/23 7/19/23 7/21/23 7/19/23 7/21/23 7/24/23 7/28/23 7/24/23 7/30/23 7/24/23 7/30/23 7/31/23 7/25/23 7/24/23 7/24/23 7/24/23 7/31/23 7/31/23 7/31/23 7/25/23 Regular & Certified weeds and brush only on 8/1/23 remove not! livingt there grass only on 7/26/23 7/31/23 7/31/23 7/24/23 3130 Daniel Alejandro Figuero Romero High grass and weeds are high all around the property 915 Robert, Jr. &' Valerie Malley 3rd notice for weeds around motorcycles. removed on7 7124/23warning 3711 Three B Dev/Aaron Buechel High grass and weeds (sent to 901 Killarney owner) 1405 Michael Kalanish(sent to 4209 Willov 2nd notice fort the weeds, brush pile, pallets, broken fence 7/19/23 7/29/23 removed on7 7/24/23 warning removed on7 7/24/23 warning 922 Howard & Cheryll Lynn Gothe Garbage out before designated time. 7/24/23 7/24/23 7/24/23 grass only on 7/31/23 7/24/23 removed on 7/24/23 warning removed on 7/24/23 waring removed on 7/24/23 warning removed on7 7/24/23 warning removed on7 7/24/23 warning removed on7 7/24/23 warning removed on 7?24/23 warning removed on7?24/23 warning 8/1/23 cut on 8/1/23 Warning 8/7/23 Garbage out before designated time. Garbage out before designated time. Garbage out before designated time. Garbage out before designated time. Garbage out before designated time. Garbage out before designated time. Garbage out before designated time. Garbage out before designated time. Garbage out before designated time. Garbage out before designated time. Garbage out before designated time. Garbage and a chair throwni int thef front oft the property High Grass and weeds around the property Garbage out before designated time. Isn't thet first time. Next 7/19/23 7/21/23 7/24/23 3640 Michael & Stefanie Marrotti High Grass and weeds around the property PIC9 Page 5of8 8/11/2023 Paul' Vietmeier trimed on 8/1/23 warning 7/31/23: 2nd notice 7/31/23 removed on7 7/31/23warning! removed on7 7/31/23warning! grass only on7 7/31/23 7/31/23 8/1/23 grass only 7/31/23 7/31//2023 7/31/23 8/1/23 8/1/23 7/31/23 8/8/23 only the grass is cut7/31/23 warning 7/31/23 cleaned ups 8/2/23 warning 7/31/23 7/31/23 7/31/23 7/31/23 7/31/23 7/31/23 7/31/23 7/31/23 7/31/23 Garbage only 7/31/23 7/31/23 7/31/23 removed on7/31/23 waming 7/31/23 8/9/23 8/2/23 8/7/23 8/9/23 8/3/23 8/3/23 889 Maplewood Drive 890 Rebecca Street 891 Lyndell Street 892 Hamilton Road 893 Library Road 894 Poplar Avenue 895 Clara Ave 896 Corbett Drive 897 Willow Ave 898 Arch Ave 899 Lindenwood Drive 900 Hastie Road 901 Thornwood Drive 902 Vallevistta. Ave 903 Baldwin Street 904 Willow Avenue 905 Library Road 906 Blossom Hill Road 907 Shady Run Ave 908 McRoberts Road 909 Sleepy Hollow Road 910 Blossom Hilll Road 911 Maplene Drive 912 Nilden Avenue 913 Killarney Drive 914 Killamey Drive 915 Kerry Hill Drive 916 Glen Shannon Drive 917 Elm Avenue 918 Shady Run Ave 919 Saint Anne Street 920 Willow Avenue 921 Willow Avenue 922 Greenridge Rd 923Willow Avenue 924 Blossom Hilll Road 925 Castle Drive 926Willow Avenue 927 Poplar Avenue 928 Oakdale Ave 903 Lifesteps 3704 Sardor Ergashev 1375 Christina Bowman 3563 James Brocato 3628 Dianne Choudhry 1329 Mary Ochs 801 Marcia AF French 3944 Stacie Lee Saracco 941 Marlene ME Bateman 915 TH Property Owner 1LLC 1006 Samijoe Jeniquea Latham 966 Paul N& Mary E Fournier 932 Jonathan G1 Turban 3918 Jason & Kayla Bailey 3549 Andy &Lauren Tuskin 1211 Annamarie Neville 3349 Dijana Rovcanin 900 Dharmishtha Lodaliya 1488 Three B Development 3148 Susan Daube 810 Barbara AS Smith 826 Shannon Lehman 536 Donald & Cheryl Seese 3526 Michael DF Foglia 1226-1230 Brian Dudukovich 940 Natalie Friedrich 4212 JoshuaJames Staley 4217 Bogoljub &L Luca Markovic 3827 Robertl Lang 1494 Blossom Hilll Road 3827 Rear Robert lang Hedges are out of control and protruding outi into the street 7/24/23 7/30/23 3711 Three B Dev/Aaron Buechel 2nd notice for high grass and weeds 7/24/23 7/30/23 7/24/23 7/30/23 7/24/23 7/30/23 7/24/23 7/30/23 7/24/23 7/30/23 7/25/23 7/26/23 7/25/23 7/30/23 7/25/23 8/4/23 7/26/23 7/26/23 7/27/23 7/26/23 7/31/23 7/26/23 7/30/23 7/26/23 7/30/231 7/31/23 7/27/23 7/26/23 7/30/23 7/26/23 7/27/23 7/26/23 7/31/23 7/26/23 7/27/23 7/26/23 7/27/23 7/26/23 7/27/23 7/26/23 7/27/23 7/26/23 7/27/23 7/26/23 7/27/23 7/26/23 7/27/23 7/27/23 7/26/23 7/27/23 7/26/23 7/27/23 7/26/23 7/27/23 7/27/231 7/28/23 7/27/23 7/28/23 8/1/23 8/1/23 8/6/23 8/1/23 8/2/23 8/2/23 8/1/23 8/2/23 High Grass and weeds around thep property High weedsi int the back of the property along McRoberts High Grass and weeds around the property. Brush pile Bamboo int the front and side yard out of control. Garbage placed out way before the designated time Garbage plaçed out way before the designated time High Grass and weeds throughtout the property no Occ. High Grass.weedsovergrown trees and bushes 3rd notice for parking on the grass posted ont the windsheild 7/25/23 High Grass, weeds throughout the property Hedges out contr 7/26/23 7/31/23 hedges growing over the sidewalk, ,& Blocking the veiw High grass and weeds on the front and hill side High grass and weeds around the property High grass and weeds, brush! has taken over, no premise ID 7/24/23 7/30/23 7/25/23 7/26/23 did a good deed and cleaned up from street 1067 Patrick R& Janet AI Donahoe Garbage out way before the designated time 1480 Daniel A& Audreyl L Stabb High grass, weeds throughtout the property & Brush/tarps 7/26/23 Either the garbage out 4 days early, or was left att the curb 7/26/23 High weeds along the side oft the property on Trance U-Haul trailer blocking the view att the intersction High Grass and weeds throughout the property Garbage out before 6:00 Pm Garbage out before 6:00 Pm Garbage placed out before the designated time Garbage out before 6:00 Pm, next time will be a citation Garbage placed out before the disignated time No Occupancy, garbage placed out 471/2 days before pick up 7/26/23 Garbage out before 6:00 Pm Garbage out before 6:00 Pm Garbage plaçed out before the disignated time Gray, Jeep parked on the grass 3173 David E&F Pamela MI Bragano Waiga Garbage out before 6:00 Pm 847 Lerario Family Revocable Living trus Garbage out before 6:00 Pm 4212 Samir Alqass & Siba Alqass Ishaq Gray Toyota parked ont the grass Mishandling oft the garbage. Birds & Rodents tore into garbag 7/31/23 2nd Notice for Parking ont the grass behind the building 214 Wilmington Savings Fund Soc. High grass and weeds in backyard causing rodents. 3726 Coccaro &A Associates Bob Coccaro Garbage bags out way before the disignated time. No Occ#3 8/1/23 960 Raymond S &F Patricia A Ewing Garbage outy way before the designated time PIc 10 Page 6 of8 8/11/2023 Paul Vietmeier 929 Riehl Drive 930 Kerry Hilll Drive 931 Belleville Street 932 Wabash Avenue 933 Wabash Avenue 934 Riehl Drive 935 Middle Road 936 Maplewood Drive 937/Lindenwood Drive 938 Lindenwood Drive 939 Poplar Avenue 940 Cooke Drive 941 Baldwin Street 942 Corbett Drive 943 Thornwood Drive 944 Greenridge Road 945 Connor Road 946 Connor Road 947 Connor Road 948 Bockstoce. Avenue 949 Greenridge Road 950 Connor Road 951 McRoberts Road 952 Killamey Drive 953 Killarney Drive 954 Glen Shannon Drive 955 Middle Road 956 Hiwood Drive 957 Belleville Street 958 Connor Road 959 Rebecca Street 960 Willow Avenue 961 Willow Avenue 962 Baldwin Street 963 Baldwin Street 964 Mount Lebanon Blvd 965 Rebecca Street 966 Lyndell Street 967 Middleboro Road 968 6Th Street 767 Nadinel L Dambrosio 826 Emily MG Olah 3129 Jeffery Studeny 3122 Rita Arena 3138 Shane Becker 888 Ralph & Deborah Bilski 915 THF Property Owner 1LLC 838 Thomas Aaron 3538 Stephen Nickles 801B Joel Delrosario 931 Brady Davoli 1017 Cheryl! Lambert 4242 Russell Bruner 1061 Matthew Templeton 1019 Robert Hoffmann, Jr. 911 Charleigh Barnes 1059 Pavlo Lebedyev Thomas Al Moses 783 Colleen MI Derbish 784 Boyd MG Guenther 536 Donald & Cheryl Seese 3388 Colleen Jessie Waldron 2909 Christopher Schmitt 1059 Pavlo Lebedyev 3737 Sean Browne 3915 Linda Diane Dell 927 David Al Palermo 911 Joshua Gaallagher 400/Lebanon Shops Properties 3814 Daniel JFlorent 2nd Notice High Grass and weeds throughout the property 8/1/23 High grass and) Weeds throughout, Blue Tarpi in the back yan 8/1/23 Garbage receptacles left at the curb past the designated time 8/1/23 Recycle container either placed out before orl left out Garbage placed out before the designated time Garbage placed out before the designated time Overal exterior oft the property is in disarray. Garbage placed out before the designated time 4th Notice Cut and maintain the weeds. Garbage placed out before the designated time Garbage placed out before the designated time Garbage placed out before the designated time Garbage placed out before the designated time. Garbage placed out before the designated time Garbage placed out before the designated time Outstanding violations/permit not paid High Grass backyard, No Occ, No Unit Registration Moving forward to condemn the house, Lack ofr maintenance 8/4/23 Garbage receptacles are stored too close to the street. Garbe 8/7/23 Garbage receptacle left at the curb for day's after the pickl-up. 8/7/23 3rd Garbage out way before designated time, Ticketi issued 8/7/23 Garbage receptacle left att the curb for day's after the pickl-up 8/7/23 4t tickets, GrassTraller.Junk, Property Maintenance citation for high grass in backyard Swimming pool with no permit Rubbish Dresser, cabinet, Tv, over a month Garbage and brush pile placed out before disgnated time High Grass and weedst throughout the property dumpster noti ina a enclosure, and a damaged enclosure Garbage receptacles left out beyond the designated time 8/1/23 8/6/23 8/2/23 8/2/23 8/3/23 8/2/23 8/3/23 8/2/23 8/3/23 8/2/23 8/3/23 8/2/23 8/3/23 8/2/23 9/2/23 8/2/23 8/3/23 8/2/23 8/13/23 8/2/23 8/3/23 8/2/23 8/3/23 8/2/23 8/3/23 8/2/23 8/3/23 8/2/23 8/3/23 8/2/23 8/3/23 8/2/23 8/3/23 8/2/23 8/13/23 8/2/23 9/2/23 8/9/23 8/4/23 8/9/23 8/8/23 8/8/23 8/8/23 8/7/23 8/12/23 8/8/23 8/7/23 8/22/23 8/7/23 8/7/23 8/20/23 8/8/23 8/15/23 8/8/23 9/8/23 8/8/23 8/9/23 8/8/23 8/13/23 8/8/23 8/22/23 8/8/23 8/9/23 8/7/23 8/3/23 waming 8/7/23 waming waring warning Warning Ticket 8/7/23 8/7/23 720 Patrick &E Elizabeth Mangan Garbage placed out before the designated time 818 Merle & Laura Lee Michelucc Garbage placed out before the designated time 817 William &E Eileen Steingraber Garbage placed out before the designated time removed on 8/7/23 warning removed on 8/7/23 warning removed on 8/7/23 warning 8/7/23 removed on 8/7/23 warning just garbage on 8/7/23 Regular and Certified just garbage on 8/7/23 Citation ont the 7th warning warning 8/10/23 issued a citation Regular and Certified warning warning warning warning 1021 1021 Connor LLC/Riva Ridge Garbage placed out before the designated time/no ocC 4236 Imagine Investments & Consulting Garbage out a day after pick up, no Occ. No Rental Regist 8/4/23 884 Ronald' W & Karen. AF Rodgers High Grass and weeds around the front parking space 3919 Three Suns Properly Sol. Steve Salyu Unsafe wall and handrail,high weeds,along Willow Ave 3713 Michael L & Denise AI Macklen Clean up property Plastic bags, garbage cans, hose, paper 8/8/23 8/19/23 3929 Paul A &L Lynne A Turnquist Garbage receptacle left att the curb beyond designated time 1241-1245 MOJO Properties LLC James Moss Garbage cans left out beyond the designated time No Occupi 8/9/23 8/10/23 DEL (( Page 7of8 8/11/2023 Paul Vietmeier 969 Oakdale. Avenue 970 Oakdale. Avenue 971 Sleepy Hollow Road 972 Sleepy Hollow Road 973 Chestnut Avenue 974 Poplar Avenue 975 Poplar Avenue 976 Elm Avenue 977 Saint Anne Street 978 Saint Anne Street 979 Thornwood Drive 980 Thornwood Drive 981 Greenridge Road 982 Riehl Drive 938 CICC &Sons Investments LLC Garbage out a day and a half before scheduled pick up 960 Raymond S & Patricia Ewing Garbage placed out way before the disignated time 8/8/23 8/9/23 8/9/23 8/10/23 8/9/23 8/10/23 8/9/23 8/10/23 8/10/23 8/9/23 8/10/23 8/9/23 8/10/23 8/10/23 8/9/23 8/10/23 8/9/23 8/10/23 8/9/23 8/10/23 8/10/23 removed 8/10/23 warning 8/11/23 8/11/23 8/11/23 8/11/23 8/11/23 8/11/23 warning waring 924 Shane King 801 Teri Sue Obiecunas 922 Fadiyya Salim 3617 Apt1 Hayley Whittaker 3617 Apt2 Nicole Evans 3526 Michael DF Foglia 911 Richard PF Fest 915 Robert E & Valerie Malley 1041 Margaret Kearney 1090 Rachel Cathryn O'Rourke Garbage paced out before the disignated time Garbage placed out before the disignated time Garbage placed out before the disignated time. Front &E Back 8/9/23 Garbage placed out before the disignated time Garbage placed out before the disignated time Garbage plaçed out before the disignated time. No accident 8/9/23 Garbage plaçed out before the designated time Garbage plaçed out before the designated time Garbage plaçed out before the designated time Garbage placed out before the designated time. Out for days 8/9/23 8/10/23 4204 Salvatore &L Laurie Falcone White Hyundai parked ont the grass between two houses 9/10/23 8/11/23 720 Patrick R&E Elizabeth E Mangan Mishandling of garbage. Garbage on the ground that fell over 8/10/23 8/11/23 PEC 13 Page 8 of8 GGirard AUNIVEST WEALTH DIVISION Girard Pension Services 4600 Broadway Allentown, PA 18104 610-821-1331 Statement of Account CASTLE SHANNON BOROUGH POLICE Account Number: 632-80435 For the Period April 1, 2023 Through June 30, 2023 We hereby certify that to the best of our knowledge this report is complete and accurate pursuant to Section 401 (a) of the Internal Revenue Code. We further certify that the securities, mutual funds and cash on the listing of Summary of Investment Holdings held on dates illustrated in this report are or were held by Nationwide Trust Company as Pension Plan Custodian. You should also receive a statement directly from your Pension Plan Custodian. Please compare both statements for accuracy and contact your administrator, Kelle Kichline, at (610) 821-1331 with any questions concerning your account. Confidential And Privileged Information pp cc: Lt Lone Lt YE R2o April 1, 2023 to June 30, 2023 Account Name: CASTLE SHANNON BOROUGH POLICE Account Number:6 632-80435 Account Summary Beginning Market Value $6,138,772.15 Deposits: Contributions: Asset Transfer In: $27,314.78 0.00 Total Deposits: $27,314.78 Payments: Withdrawals and Distributions: Administrative Fees: Total Payments: (101,207.25) (9,208.16) ($110,415.41) Investment Change: Investment Gain Interest $208,707.70 0.00 Investment Gain $208,707.70 $6,264,379.22 Ending Market Value: pp April 1, 2023 to June 30, 2023 Account Name: CASTLE SHANNON BOROUGH POLICE Account Number: 632-80435 Account Transactions Process Date Effective Date Description Amount Deposits 04/10/2023 04/21/2023 05/05/2023 05/19/2023 06/01/2023 06/15/2023 06/29/2023 04/10/2023 04/21/2023 05/05/2023 05/19/2023 06/01/2023 06/15/2023 06/29/2023 Contribution Contripution Contribution Contribution Contribution Contribution Contribution $4,256.07 $4,108.68 $4,031.23 $4,501.64 $3,698.50 $3,304.39 $3,414.27 $27,314.78 Sub Total: Third Party Fees 04/11/2023 04/11/2023 Third Party Fee ($9,208.16) ($9,208.16) Sub Total: Trade Transaction 06/23/2023 06/23/2023 06/23/2023 06/23/2023 Exchange In- Variable to Variable Exchange Out - Variable to' Variable $193,384.45 ($193,384.45) $0.00 Sub Total: Withdrawals 04/25/2023 05/25/2023 06/26/2023 04/24/2023 05/24/2023 06/26/2023 Benefit Payment Benefit Payment Benefit Payment ($33,735.75) ($33,735.75) ($33,735.75) ($101,207.25) Sub Total: TOTAL: ($83,100.63) pp3 April 1, 2023 to June 30, 2023 Account Name: CASTLE SHANNON BOROUGH POLICE Account Number: 632-80435 Benefit Payments Run Date 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 Annuitant Name CAMPBELL,AMESL CARUSO.JOSEPHA CHEBERENCHICKMCHAE CRAWFORD.JOHND FISHER.GERARD. LANE,HAROLDC MASON.BARBARAA SMITH,DONALDE SNIEGOCK,ERVNA YONEK,THOMAS CAMPBELL.JAMESL CARUSOJOSEPHA CHEBERENCHICKMCHAE CRAWFORD.JOHND FISHER.GERARDJ LANE,HAROLDC MASON.BARBARAA SMITH,DONALDE SNIEGOCKIERVNA YONEK,THOMAS CAMPBELL.AMESL CARUSONOSEPHA CHEBERENCHCKMICHAE CRAWFORD.OHND FISHER,GERARDJ LANE,HAROLDC MASON.BARBARAA SMITH,DONALDE SNIEGOCKIERVNA YONEK,THOMAS Amount $2,252.94 $5,117.33 $5,598.55 $3,088.86 $1,643.51 $4,560.31 $1,120.00 $3,452.15 $1,847.55 $5,054.55 $2,252.94 $5,117.33 $5,598.55 $3,088.86 $1,643.51 $4,560.31 $1,120.00 $3,452.15 $1,847.55 $5,054.55 $2,252.94 $5,117.33 $5,598.55 $3,088.86 $1,643.51 $4,560.31 $1,120.00 $3,452.15 $1,847.55 $5,054.55 $101,207.25 TOTAL: pp4 June 30, 2023 Account Name: CASTLE SHANNON BOROUGH POLICE Summary Of Investment Holdings Account Number: 632-80435 Investment Category Domestic Equity Fund Name Market Value $380,737.12 $255,063.08 $257,128.32 $128,063.41 $318,640.19 $317,336.54 $252,767.90 $194,560.78 $128,282.84 $254,489.43 $257,140.15 $444,419.69 AllianceBern Large Cap Growthl American Century MidCap Value Inst Baird MidCap Inst Brown Capital Small Companyl Columbia Dividend Income Inst Edgewood Growthl JP Morgan US Equity R6 JPM SmCap Eq R5 JPM UM BehVal Fd R6 JPMorgan Equity Income Fund R5 Principal MidCap Blend Inst Vanguard Large Cap Index Fund Adm $3,188,629.45 Fixed Income Diamond Hill Corporate Credit Y Federal Total Return Inst Guggenheim Total Returnl Janus Henderson Multi-Sector Income N John Hancock BondI Voya Intermediate Bondl $311,171.41 $432,132.93 $433,141.10 $372,291.54 $371,631.66 $371,490.34 $2,291,858.98 International Equity American Funds - New Perspective R6 Artisan Intl Valuel Goldman Sachs Emg Mkt Equity! MFS Intl Intrinsic Val R6 Oppenheimer Intl Small Company Y WCM Focs Intl Gr Inst $63,302.71 $126,132.53 $125,278.52 $126,376.09 $62,975.48 $127,620.47 $631,685.80 Cash/ST Fixed Prncpl ST Inc Inst $152,204.99 P $152,204.99 $6,264,379.22 Total Market Value: GGirard AUNIVEST WEALTH DIVISION Girard Pension Services 4600 Broadway Allentown, PA 18104 610-821-1331 Statement of Account CASTLE SHANNON NON-UNIFORMED Account Number: 632-80025 For the Period April 1, 2023 Through June 30, 2023 We hereby certify that to the best of our knowledge this report is complete and accurate pursuant to Section 401 (a) of the Internal Revenue Code. We further certify that the securities, mutual funds and cash on the listing of Summary of Investment Holdings held on dates illustrated in this report are or were held by Nationwide Trust Company as Pension Plan Custodian. You should also receive a statement directly from your Pension Plan Custodian. Please compare both statements for accuracy and contact your administrator, Kelle Kichline, at (610) 821-1331 with any questions concerning your account. Confidential And Privileged Information Nup / April 1, 2023 to. June 30, 2023 Account Name: : CASTLE SHANNON NON-UNIFORMED Account Number:632-80025 Account Summary Beginning Market' Value $1,497,259.45 Deposits: Contributions: Asset Transfer In: $9,886.74 0.00 Total Deposits: $9,886.74 Payments: Withdrawals and Distributions: Administrative Fees: Total Payments: (45,901.69) (2,245.89) ($48,147.58) Investment Change: Investment Gain Interest $40,418.91 0.00 Investment Gain $40,418.91 $1,499,417.52 Ending Market Value: 2 NUP April 1, 2023 to June 30, 2023 Account Name: CASTLE SHANNON NON-UNIFORMED Account Number: 632-80025 Account Transactions Process Date Effective Date Description Amount Deposits 04/10/2023 04/21/2023 05/05/2023 05/19/2023 06/01/2023 06/07/2023 06/15/2023 06/29/2023 04/10/2023 04/21/2023 05/05/2023 05/19/2023 06/01/2023 06/07/2023 06/15/2023 06/29/2023 Contribution Contribution Contribution Contribution Contribution Contribution Contribution Contribution $1,452.90 $1,441.94 $1,403.13 $1,437.59 $1,254.35 $175.98 $1,437.59 $1,283.26 $9,886.74 Sub Total: Third Party Fees 04/11/2023 04/11/2023 Third Party Fee ($2,245.89) ($2,245.89) Sub Total: Trade Transaction 05/19/2023 05/19/2023 06/02/2023 06/02/2023 06/23/2023 06/23/2023 05/19/2023 05/19/2023 06/02/2023 06/02/2023 06/23/2023 06/23/2023 Exchange Out Variable to' Variable Exchange In Variable to Variable Exchange Out Variable to Variable Exchange In Variable to Variable Exchange Out - Variable to' Variable Exchange In Variable to' Variable ($2,071.01) $2,071.01 ($2,378.54) $2,378.54 ($91,097.11) $91,097.11 $0.00 Sub Total: Withdrawals 04/25/2023 05/24/2023 06/07/2023 06/26/2023 04/24/2023 05/24/2023 06/07/2023 06/26/2023 Benefit Payment Benefit Payment Premature Participant Withdrawal Benefit Payment ($14,676.49) ($14,676.49) ($1,872.22) ($14,676.49) ($45,901.69) Sub Total: Mp3 April 1, 2023 to June 30, 2023 Account Name: CASTLE SHANNON NON-UNIFORMED Account Number: 632-80025 Account Transactions Process Date Effective Date Description Amount TOTAL: ($38,260.84) NuR April 1, 2023 to June 30, 2023 Account Name: CASTLE SHANNON NON-UNIFORMED Account Number: 632-80025 Benefit Payments Run Date 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 04/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 05/24/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 06/26/23 Annuitant Name DAMICOPAIRICIAA DELALLO,RAYMONDI D EICHEL JR,RAYMONDC FUSS,GEORGEJ HART,FREDERICKH KARLOVICHLINDAM KRAH,EMMAM MATTHEWSJOSEPHIF MCMONAGLE,SHIRLEYA SCHUMACHER.EFREYA TORRIS,SHIRLEYS DAMICOPATRICIAA DELALLO,RAYMONDD EICHEL JR,RAYMONDC FUSS,GEORGEJ HART.FREDERICKH KARLOVICH.LINDA M KRAH,EMMAI M MATTHEWSJOSEPHF MCMONAGESHRLEYA SCHUMACHER.EFREYA TORRIS,SHIRLEYS DAMICO,PATRICIAA. DELALLO,RAYMONDD EICHEL: JR,RAYMONDC FUSS,GEORGE HART.FREDERICKH KARLOVICH,LINDA M KRAH,EMMAN M MATTHEWS.OSEPHE MCMONAGLESHIRLEYA SCHUMACHEREFFREYA TORRISSHIRLEYS Amount $1,185.46 $1,962.39 $2,072.43 $945.19 $1,242.20 $744.34 $912.09 $1,259.19 $1,399.01 $2,194.41 $759.78 $1,185.46 $1,962.39 $2,072.43 $945.19 $1,242.20 $744.34 $912.09 $1,259.19 $1,399.01 $2,194.41 $759.78 $1,185.46 $1,962.39 $2,072.43 $945.19 $1,242.20 $744.34 $912.09 $1,259.19 $1,399.01 $2,194.41 $759.78 $44,029.47 TOTAL: Nup5 June 30, 2023 Account Name: CASTLE SHANNON NON-UNIFORMED Summary Of Investment Holdings Account Number: 632-80025 Investment Category Domestic Equity Fund Name Market Value $76,359.20 $61,385.21 $46,411.66 $30,820.61 $76,686.24 $76,372.60 $60,833.09 $46,824.14 $30,873.30 $61,247.26 $61,885.03 $76,398.16 AllianceBern Large Cap Growthl American Century MidCap Value Inst Baird MidCap Inst Brown Capital Small Companyl Columbia Dividend Income Inst Edgewood Growthi JP Morgan US Equity R6 JPM SmCap Eq R5 JPM UM BehVal FdR6 JPMorgan Equity Income Fund R5 Principal MidCap Blend Inst Vanguard Large Cap Index Fund Adm $706,096.50 Fixed Income Diamond Hill Corporate Credit Y Federal Total Return Inst Guggenheim Total Returnl Janus Henderson Multi-Sector Income N John Hancock BondI Voya Intermediate Bondl $74,889.09 $104,000.78 $119,135.32 $89,598.70 $104,346.59 $119,207.94 $611,178.42 International Equity American Funds New Perspective R6 Artisan Intl Valuel Goldman Sachs Emg Mkt Equityl MFS Intl Intrinsic' Val R6 Oppenheimer Int! Small Company' Y WCM Focs Intl Gr Inst $30,469.83 $30,356.03 $30,150.51 $15,207.34 $15,156.20 $30,714.07 $152,053.98 Cash/ST Fixed Prncpl ST Inc Inst $30,088.62 $30,088.62 $1,499,417.52 Nup Total Market Value: MANAGING GLSSE PRINCIPALS Kevin A. Brett, P.E. Ned Mitrovich, P.E. Jason E. Stanton, P.E. August 10, 2023 S.0.No.0253-109 Civil Engineers and Surveyors HEADQUARTERS IN CORAOPOLIS, PENNSYLVANIA VIA EMAILONLY manager@cboroorg, Mr. John Trant, Interim Manager Borough of Castle Shannon 33101 McRoberts Road Castle Shannon, Pennsylvania 15234 Subject: Request for COSTARS Proposal Castle Shannon Library Contract No. 23-WF1 - Wayfinding Signs (Phase 2) Dear Mr. Trant: LSSE has completed a review of the proposal (attached) dated August 4, 2023 received from Visual Information Systems, Inc. for the supply and installation ofthe electronic message lidentification sign for the Castle Shannon Library. The quote has been revised to include Council's input from the. July 24, 2023 Council meeting. LSSE suggests awardofthe COSTARS proposal to Visual Information Systems, Inc. int the amount of$27,786.00 subject to Visual Information Systems, Inc. obtaining required insurance certificates, and review and approval of The work proposed is eligible through procurement via COSTARS Vendor Contract No. 032-E22-049. The related COSTARS Contract Overview, Vendor Contract, COSTARS Specifications, COSTARS Terms and same by the Borough Solicitor prior to execution oft the. Agreement by the Borough. Conditions, and Prevailing Wage Rates are also attached for the Solicitor'si review. Should you have any questions, please contact. Joshua R. Callender, E.I.T. directly (Ext. 284). Sincerely, at Jason E. Stanton, P.E. JES/nlk Attachments cc/att: Lorretta Miller, Assistant Manager (miler@csboro.org) Mark Heckmann, Council President mheckmamneeborore Dennis Biondo, Solicitor (drbiondo@aol.com) Mgfl OFFICES IN: Allegheny, Beaver, Erie and' Westmoreland Counties Pennsylvania; Franklin County, Ohio 846 Fourth Avenue 150 Pleasant Drive, Suite 204 10560' Walnut Street 4534 Route 136, Suite 9 5980 Wilcox Place, Suite. J Coraopolis, PA15108 (412)264-4400 Fax: (412)264-1200 Aliquippa, PA15001 (412)264-4400 Fax: (412)264-1200 Albion, PA 16401 (814)756-4384 www.Isse.com Greensburg, PA 15601 (724)837-1057 Dublin, OH43016 (614)395-1661 Fax: (814)756-5638 Fax: (412)264-1200 NAPROM2S3259-109 Wayfinding Sign:Docs25109C02 VISI Library Proposal. docx VIS SIGNS Suite 100 517 Milbeth Drive Pittsburgh, PA 15228 Date: To: VISUALI INFORMATION SYSTEMS, INC. Phone: 412.306.7446 (SIGN) Fax: 412.306.7453 poDD/@vissigns.com www.yissigns.com Total Pages, including cover: 3 Email: calender@'sse.com August 4, 2023 Josh Callender Phone: 412.264.4400 x284 Subject: Sign Quote - Castle Shannon Library Revision 2 confirm our quotation on this work as follows: LED Display Specifications: Pitch: 7mm Matrix: 40x280 COSTARS Bid #032-E22-049 Thank you for the opportunity of quoting to you on the sign work for the two locations. This will LEDs per pixel point: 1R, 1G.1B (SMD Design) Minimum Brightness: 9000+ NITS Cabinet Size: 1'47/16'Hx76Wx315/16D RGB - 281 trillion colors Viewing Angle: 160° horizontal/70" vertical Estimated LED Lifetime: 100,000 hours Display Dimming Levels - Automatic, 100 levels Low maintenance and electrical consumption Brightness/Contrast Enhancement: Individual louvers for each individual LED Front Serviceable Frame Rate: 60 fps temperature Full matrix display, capable of showing text, picture, animations, video along with time and LED display shows up to 5 lines of 2.19" characters with approximately 46 characters per line. We will supply onsite training for the Windows based software at the time of installation Free unlimited phone and webinar support provided after the installation Software/Firmware updates included at no charge during the 5-year warranty Windows based software may be loaded on a shared drive for multiple user access or ona designated PC hard drive. The PC will need internet access. We will provide the cell modem IP Communications to be cell modem Software Specifications: Graphics and video clip library included at no charge address prior to installation Highlights of the software include: Easy to use interface Provides 'real time editing' Unique effects and video movie maker Supports all true type fonts Comprenensive speed controls Display time, temperature, and date Import the following file formats: BMP, JPEG, GIF, TIF, PNG, AVI, WMV, MPEG Comprehensive scheduling by time day, week, month or year mgra Signage Specifications: The top portion to be a double-faced identification sign as per new drawings. The sign portion reading LIBRARY will be internally illuminated using LED lighting. The letters will be fabricated from %" cutout aluminum as specified. We will fabricate the custom topper Celtic knot, reveals, perforated metal and pole cover from aluminum. Faux stone will be installed on the pole cover. Installation Details: Detailed drawings will be supplied to you for approval prior to fabrication. Faux stone samples will be The LED display and signage will be manufactured and installed according to the National Electrical The signage and LED displays will be installed on a new steel structure provided and installed by us. We will excavate and supply the reinforced concrete foundation and install a new structure for this We will take care of the clearance from the Pennsylvania One Call System. Customer would be responsible for locating any on site utility lines. We will be as careful as possible; however, we cannot assume any responsibility for any on site utility lines. A site survey will need to be done and the location of the sign marked together with the municipality prior to the PA One Call. We will furnish the Cell Modem system for communication for the LED displays. This includes 5 years of cell service that includes a data plan, standard public static IP address, SIM card and monthly fee from cell phone provider. Our quote includes the cell modem, five-year prepaid service, setup, and We will furnish and install the Windows based software on your computer terminal. We will furnish on- Adequate electrical service to the sign area will be supplied by others. Your electrician should also furnish and install one 8' grounding rod buried at least 8' in the ground to be connected to the LED display as required by the National Electrical Code. The ground wire which will go from the grounding rod to the back of the LED display should be 6-gauge solid copper wire (not stranded). VIS will make The LED displays will draw a maximum of 6.7 amps per side @ 110-120 volts. The average energy consumption is considerably less. The LED displays should be on a dedicated circuit. A total of two circuits 20 amps each at 110-120 volts will be required. One for the ID sign and one for the LED Although we have an excellent safety record, we do maintain liability insurance for $2,000,000 and would be happy to have a copy of our insurance certificate sent to you upon request. provided to yout for final selection prior to fabrication. Code. LED display will bear a UL or ETL label. location. Our quotation assumes normal soil conditions. testing/support. site training and support for the software at the time of installation. the final connection to the back of the LED display. displays. Permits: We will file any standard permits required from the local municipality. Customer would be responsible Services beyond the scope of this quotation can be provided for an additional cost to be discussed for any permit fees at cost. prior to initiating. 3 Mr3 Pricing: COSTARS Bid #032-E22-049 We have included the prevailing wage per serial number 23-06530 1. LED Display pricing as per CoStar's contract per above specs: $10,957.00 2. Double-faced identification sign with only LIBRARY internally illuminated with LED lighting, custom topper, pole cover with faux stone, custom perforated metal, custom base cap, reveals, cell modem package, all materials included for the steel and concrete structure: $10,628.00 3. Installation of the new steel and concrete structure and installation of all signage on the new steel structure: $6,201.00 Total: $27,786.00 Prices are complete including LED displays (master/slave), software, temperature probe, cell modem with 5-year prepaid plan, double faced identification sign, custom topper, pole cover with faux stone, custom perforated metal and reveals, new steel and concrete structure, installation of all, freight, and Prices do not include permit fees at cost, electrical service to the sign location, engineering drawings ifrequired by local municipality, sales tax if applicable and any additional services out oft the scope of onsite software training and communication testing at the time of installation. this quotation. Prices subject to acceptance within 30 days. Special pricing and guarantee have been extended for this job with the understanding that we can use photos of this display for advertising purposes. In addition, we would ask that you give us a testimonial letter concerning this sign. TERMS: 50% with order, balance due on completion DELIVERY: Delivery is approximately 10. - 12 weeks following receipt of all necessary approvals into our office. However, we will do everything possible to expedite the delivery of same. GUARANTEE: One-year parts and labor except in the case of vandalism or acts of God. Five years on the LED lighting, FOB factory except in the case of vandalism or acts of God. The LED display is guaranteed for a period of five years except in the case of vandalism or Labor and routine maintenance during the second to fifth year to be paid for by customer. After the first-year sign should be cleaned and preventive maintenance performed yearly bya acts of God by thet factory. FOB factory. factory trained technician to validate the warranty at this location. Among our many other customers are First Commonwealth Bank, Riverhounds Highmark Stadium, The Pennsylvania State University, Pine Township, Scott Township, Collier Community Center, and The Byham Theatre - Pittsburgh Cultural Trust. VISUAL INFORMATION SYSTEMS, INC. Sincerely yours, Bobbi Gerson, President Mgr4 ACCEPTANCE DATE Suite 100 517 Milbeth Drive Pittsburgh, PA 15228 Phone: 1412,3067446/S10N) Fax: (412)306-7453 Email: bobb@visigns.com Website: www.vissigns.com Client: Castle Shannon Address:, Library Phone & Fax: Drawing #:. Date:, 8/2/23 Rev. 4 1of3 VIS Signs File Name: Castle Shannon Library Customer Approval: Notice: This drawing is the property, of Visual Information Systems, Inc. andis loaned be used only for upon furnishing the condition information thati itis to not others tol be copied or for. or any reproduced, other nor to detrimental to the interests of Visual Information Systems, purpose Inc. Artwork copyright o 2023 by Visual Information Systems VIS Signs will design, manufacture and install a new double sided monument sign at this location. Top cabinet to be stencil cut aluminum with 1/4"t thick cut aluminum letters. The word "LIBRARY" to be the only thing illuminated. Bottom portion to be full color LED displays, 7mm with a 40x 280 matrix. Aluminum pole cover tol have faux stone look. 7'-6" 10" CASTLE SHANNON 4-1/4" 5-1/2" 2'-6" LIBRARY 2" BOOK FAIR THIS FRIDAY! september 12, 2023 October 13, 2023 1'-4.7/16" VIRTUAL BOOK CLUB - JOIN US! 2" 1'-1" grade 3-5/16" 3-5/16" Scale: 3/4"= 1' Mgr5 CASTLESHANNON LIBRARY BOOK FAIR THIS FRIDAVI VIRTUAL BOOK October 2023 JOIN US! - ( myr Suite 100 5171 Milbeth Drive Pittsburgh, PA 15228 Phone: 306-7446 (412)3 Fax: (412)306-7453 Email: bobbl@visigns.com Client: Castle Shannon Library Phone & Fax: Address:. Drawing #:. 3of3 Date:, 8/2/23 Rev. 4 VIS (SIGN) signs Website: www.vissigns.com File Name: Castle Shannon Library Customer Approval: Notice: This drawing is the property, of Visuall Information Systems, Inc. andis loaned only upon the condition thatitis not to be copied or reproduced, nor to be used for furnishing information to others or for any other purpose detrimental to the interests of Visual Information Systems, Inc. Artwork copyright 0 2023 by Visual Information Systems 7'-6" 10" 2'-6" 2" 1'-4 7/16" 2" 1'-1" grade 2.25wx4tx4.5d footers with 4'x4'x5/16posts I I I I - - - - 7 mgf Scale: 1/2"= 1' Overview of Contract Prior to utilizing a contract, the user. should read the contract in it's entirety. DESCRIPTION CONTRACT INFO Thel Department of General Services developed this contract for Signage under DGS's COSTARS Program. > Signage includes Banners; Billboards; Decals; Digital, Electric, and] LED Signs; Hanging Signs; Map Signs; Marquee Signs; Message Boards; Neon and Lettering; Park Signs; Plaques and Markers; Posters; Scoreboards; Support Posts, Fasteners, Hardware, and PAS supplier may also choose to offer ancillary services such as After-Hours Service; Ay.mA.NCaNste Activities; Asset Tagging; Customization; Disposal/ Relocation; Extended Warranty; Post Warranty Support and Maintenance Service; Special Contract Number & Title COSTARS-32 Signage Number of Suppliers Validity Period DGS Point of Contact Contact Phone# Email 33 01132012-082312024 Emanuel Williams 717-703-2946 emwillams@pa.gov Accessories. Delivery Arrangements DESCRIPTION PROCESS TO PURCHASE >S Shop around by clicking on a supplier contract number to review Contact suppliers to review products and pricingi in detail, PE Establish products and pricing. Choose a supplier. A Order the products directly from the selected supplier usinga purchase order. Include COSTARS Contract Number (COSTARS-32 )and your COSTARS Member Name onj purchase order. >S Send a request to DGS and the supplier to ask for addition of any missing manutacturers and/or products to the supplier'scontract. E Because of the multiple award nature, you may see that prices vary greatly among suppliers. DGS encourages you to comparison shop. PDGS encourages suppliers to offer quantity discounts. Some suppliers offer quantity discounts in their public pricing, while others ask that you contact them for a quote. > COSTARS members may purchase. jointly to mutually benefit from the quantity discounts. Offered products and pricing are updated Quarterly Members are encouraged to negotiate lower prices. Pleasel keep DGS informed so that we may share your success stories with all of their offered products and pricing. the COSTARS membership. mgr8 MANAGING PRINCIPALS KevinA. Brett, P.E. Ned Mitrovich, P.E. Jason E. Stanton, P.E. August 10, 2023 S.O.No.: 253-112 ALSSE Civil Engineers and Surveyors HEADQUARTERS IN CORAOPOLIS, PENNSYLVANIA VIA EMAIL ONLY manager@esboro.rg, Mr. John Trant, Interim Borough Manager Borough of Castle Shannon 3310McRoberts Road Castle Shannon, Pennsylvania 15234-2711 Subject: Contract No. 23-R03 Bid Report 981 Castle Shannon Boulevard Parking Lot Improvements Dear Mr. Trant: In accordance with the Advertisement, sealed bids for the subject contract were received through the Quest Construction Data Network (QuestCDN) until 11:00 AM on August 10, 2023. The bids received were opened Prior to the bid opening, three contractors requested proposal bid forms. Bid proposals were received from three Contractors for Contract No. 23 - R03 - 981 Castle Shannon Boulevard Parking Lot Improvements with bid and read aloud. There was one addendum issued for this contract. amounts as follows: Contractor Contract A $34,750.00 $44,625.00 $52,375.00 Contract B $56,750.00 $75,625.00 $84,875.00 Contract C $59,250.00 $78,125.00 $94,125.00 Independent Enterprises, Inc. Michael Facchiano Contracting, Inc. Mele & Mele & Sons, Inc. Scope for Contract A-2.5" Binder (Area A- existing millings) and 1.5" Wearing Overlay (Area A, B,C)-1 No1 milling. Scope for Contract B - 4" Stone Subbase and 2.5" Binder (Area A - existing millings), 1.5" milling (Area B, C) and 1.5" Scope for Contract C- 6" Stone Subbase and 2.5" Binder (Area A - existing millings), 1.5" milling (Area B, C) and Wearing Overlay (Area A,B,C). Wearing Overlay (Area A, B,C). Line-striping by others in each contract. 1.5" mgrg OFFICES IN: Allegheny, Beaver, Erie and Westmoreland Counties Pennsylvania; Franklin County, Ohio 846 Fourth Avenue 150 Pleasant Drive, Suite 204 10560 Walnut Street 4534 Route 136, Suite 9 59801 Wilcox Place, Suite. J Coraopolis, PA 15108 (412)264-4400 Fax: (412)264-1200 Aliquippa, PA 15001 (412)264-4400 Fax: (412): 264-1200 Albion, PA 16401 (814),756-4384 www.lsse.com Greensburg, PA 15601 (724)837-1057 Dublin, OH4 43016 (614)395-1661 Fax: (814)756-5638 Fax: (412)264-1200 NAPROM455-112 VittesP vingDos:235112c03 BRd docx Mr. John Trant, Interim Borough Manager Borough of Castle Shannon August 10, 2023 Page2 Per the Instructions to Bidders, bid bond companies were checked and all are listed on the U.S. Treasury Circular In accordance with Section B.3 of the Instructions to Bidders, using the bid quantities and contractors bid unit prices, eachl bid was checked fori mathematical errors in extension and addition. No errors in extension or addition were discovered. The enclosed bid tabulation presents a listing oft the item descriptions and Unit Price Bid for each item for all bids received. As presented above and ini the bid tabulation, Independent Enterprises, Inc. is the apparent low bidder for Contract No. 23- R03 - 981 Castle Shannon Boulevard Parking Lot Improvements. A Based on the bids submitted, we suggest award of the Contract No. 23- R03 - 981 Castle Shannon Boulevard Parking Lot Improvements to Independent Enterprises, Inc. as low bidder subject tol Independent Enterprises, Inc. obtaining the required insurance certificates, performance bond, and payment bond, and review and approval of 570. copy ofl Independent Enterprises, Inc.'s bid proposal acknowledgement is enclosed herewith. same by the Borough Solicitor prior to execution of the Agreement by the Borough. Award of Contract A, Contract B or Contract Ci is subject to the Borough's discretion. Should you have any questions, please contact. Joshua R. Callender, E.I.T. directly (Ext. 284). Sincerely, Jason E. Stanton, P.E. E JES/vcl Attachments cc/att: Loretta Miller, Assistant Manager - via email only (miler@csbor.org) Dennis R. Biondo, Solicitor (drbiondo@aol.com) mgrio NAPROJ2S929-1121 Vites PavingDos2s2c031 BR.docx BOROUGH OF CASTLE SHANNON, PENNSYLVANIA RESOLUTION NUMBER WHEREAS, Title I oft the Housing and Community Development Act of1974, as amended, has established the Community Development Block Grant Program ("CDBG");and WHEREAS, the National Affordable Housing Act of1990, as amended, has established the WHEREAS, the United States Department of Housing and Urban Development ("HUD"), has determined that the County of Allegheny (the "County"), has the ability to qualify as an "urban HOME Investment Partnerships Program ("HOME"); and county" under the CDBG Program and the HOME Program; and WHEREAS, the Attorney General of the Commonwealth of Pennsylvania has issued a legal opinion that the County can undertake essential community development and housing assistance activities within the jurisdiction of the Borough of Castle Shannon (the "Borough") only upon the consent of said Municipality; and WHEREAS, the County, through its Department of Economic Development, has requested the Borough give its consent for the County to undertake essential community development and housing assistance activities within the Borough from annual CDBG grants and HOME funds for program years 2024, 2025, and 2026.; and WHEREAS, the Borough is willing to give its consent for the County to undertake the aforementioned activities within its jurisdiction for program years 2024, 2025, and 2026, and to include the Borough's population as part of the threshold population figure necessary to qualify the County as an "urban county". NOW,THEREFORE, the Borough Council of the Borough of Castle Shannon resolves 1. The Borough of Castle Shannon is hereby authorized to enter into a Cooperation Agreement with the County and all amendments thereto, if necessary, for the County to undertake essential community development and housing assistance activities within the Borough from annual CDBG grants and HOME funds received by the County from HUD for the program years 2024, as follows: 2025, and 2026. 2. The appropriate officers and officials of the Borough are hereby authorized to take all actions necessary to effectuate this Resolution. RESOLVED this day of 20_ by the Borough Council of the Borough of Castle Shannon in lawful session duly assembled. ATTEST John Trant BOROUGH OF CASTLE SHANNON Mark Heckmann President ofCouncil Interim Borough Manager/Secretary (I mgr Motion to award the contract for Solid Waste Collection, Removal and Disposal Services to Waste Management of] Pennsylvania, Inc. for a five-year period beginning January 1,2024 through December 31, 2028, at the costs quoted in the SHACOG 2023 Joint Bid For Solid Waste Collection, Removal And Disposal Services, with services to be provided in accordance with the 1.F For Trash - Automated weekly collection for Garbage, Rubbish and Residential Refuse with cost based on aj per unit basis and any necessary trash container/cart tol be provided by the 2. For Recycling - Automated collection for Recyclables with cost based on aj per unit basis and collection every other week and any necessary container/cart to be provided by the vendor. specifications set forth in the SHACOG Bid specifications, as follows: vendor. 3. For Leaf and Yard Waste - (Optional) 4. For E Waste - (Optional) The appropriate Borough officials are authorized to execute any necessary Agreement with the vendor. 12 Mgf Municipality Name: Service Trash Borough of Castle Shannon Yeari Monthly Rate Check Service Service Options: PARTI Alternate A:T Traditional Manual Collection for allE Elements of Solid Waste for Full Contract Term Traditional/ Per Unit $ Traditional/ Per Ton $ 20.50 Inci in Above 242.13 16.45 Inc in Above 17.50 Inci in Above 242.13 Inci in Above 242.13 Inci inA Above Bulk 2 Items 1x/month Alternate B:1 Traditional Manual Collection for allE Elements of Solid Waste then switchtol Automated Collection for allE Elements ofs Solid' Waste Automated/ Muni Cart/ Per Unit $ Bulk 2 Items 1x/month Automated/ Contractor Cart/ Per Unit $ Bulk: 2 Items 1x/month Automated/ Muni Cart/ Per Ton $ Bulk 21 Items 1x/month Automated/ Contractor Cart/ Per Ton $ Bulk: 21 Items 1x/month XX Alternate C: Currently using Traditional Manual Collection for all Elements of Solid Waste: and Automated Collectioni for Recyclables and retain this configuration Traditional/ Per Unit $ Traditional/ Per Ton $ 20.50 Inci in Above 242.13 Bulk 21 Items 1x/month Alternate D: Currently using Traditional Manual Collection for allE Elements of Solid Waste and Automated Collection1 for Recyclables and then switch to Automated Collection of Garbage, Rubbish, and Refuse Automated/ Muni Cart/ Per Unit $ Bulk: 21 Items 1x/month Automated/ Contractor Cart/ Per Unit $ Bulk: 2 Items 1x/month Automated/ Muni Cart/ Per Ton $ Bulk: 21 Items 1x/month Automated/ Contractor Cart/ Per Ton $ Bulk: 21 Items 1x/month 16.45 Inci inA Above 17.50 Inci inA Above 242.13 Inci inA Above 242.13 Inci inA Above Alternate E: Currently using Automated Collection for Garbage, Rubbish, and Residential Refuse and will contianue tof fore entire contracti term. Bulk: 21 Items 1x/month Bulk 21 Items 1x/month Automated/ Per Unit $ Automated/ Per Ton $ 16.95 Inci inA Above 242.13 Inci inA Above 38.95 69.81 2.00 Backdoor Service Trash Only $ Backdoor Service Trasha and Recycle $ invoicing: and Collection Service Fee $ MBris PARTII Recycling Alternate A: Traditional Manual Collection fora all elements of solid wastei for entire contract. Traditional/ Per Unit/Weekly $ Traditional/. Per Unit/EOW $ Traditional/ Per1 Ton/Weekly $ Traditional/ Per Ton/EOW $ 14.17 7.41 1,900.00 950.00 9.87 11.37 5.46 6.96 9.87 11.37 5.46 6.96 Alternate B:T Traditional Manual Collection fora alle elements ofs solid waste then switcht to Automated Collection for alle elements ofs solid waste. Automated/ Muni Cart/ Per Unit/Weekly $ Automated/ Contractor Cart/ Per Unit/Weekly $ Automated/ Muni Cart/ Per Unit/EOW $ Automated/ Contractor Cart/ Per Unit/EOW $ XX Alternate C: Currently using Automated Collectioni for Recyclables and Traditional Manual Collection for Garbage, Rubbish, and Residential Refuse and retain this configuration. Automated/ Muni Cart/ Per Unit/Weekly $ Automated/ Contractor Cart/ Per Unit/Weekly $ Automated/ Muni Cart/ Per Unit/EOW $ Automated/ Contractor Cart/ Per Unit/EOW $ for Garbage, Rubbish, & Residential Refuse. Automated/ Muni Cart/ Per Unit/Weekly $ Automated/ Contractor Cart/ Per Unit/Weekly $ Automated/ Muni Cart/ Per Unit/EOW $ Automated/ Contractor Cart/ Per Unit/EOW $ Alternate D: Currently using/ Automated Collectioni for Recyclables and Traditional Manual Collectioni for Garbage, Rubbish, & Residential Refuse and switching to Automated Collection 9.87 11.37 5.46 6.96 PARTIII Leaf and' Yard Waste Scheduled Exhibit FLeaf Collections Alternate. A: Traditional Manual Collection for alle elements ofs solid waste. Manual Collection, removal, and composting for entire contract. Per Unit Per Collection $ How! Many Collections per Year Per Ton Per Collection How Many Collections per Year $ 1.50 10,000.00 Alternate B:1 Traditional Manual Collectioni fora alle elements ofs solid wastet then switcht to Currently using Manual Collection, removal, and composting then switch to Automated Automated Collection for alle elements ofs solid waste. Collection, removal, and composting. Leafa and' Yard Waste Per Unit Per Month Per Ton Per Collection Automated/ Muni Cart/ Per Unit $ Automated/ Contractor Cart/ Per Unit $ Automated/ Munic Cart/ Per Ton $ Automated/ Contractor Cart/ Per Ton $ 15.00 16.50 10,000.00 10,000.00 14 Mgf Alternate C: Currently using Automated Collection for Recyclables and Traditional Manual Collection1 for Garbage, Rubbish, and Residential Refuse: and retain this configuration. Manual Collection, removal, and composting for entire contract. Scheduled ExhibitFLeaf Collections Per Unit Per Collection $ How Many Collections per Year Per1 Ton Per Collection How Many Collections per Year $ 1.50 10,000.00 Alternate D: Currently using Automated Collection for Recyclables and Traditional Manual Collection for Garbage, Rubbish, & Residential Refuse and switching to Automated Collection for Garbage, Rubbish, & Residential Refuse. Automated Collection, removal, and composting fore entire contract. Leafa and' Yard Waste Per Ton Per Collection 10,000.00 10,000.00 Price Per Vehicle 1,712.46 Price Per Container 541.17 $ 38.95 1.61 500.00 5,000.00 Automated/ Muni Cart/ Per Ton $ Automated/ Contractor Cart/ Per Ton $ Special Collection' Vehicle $ 30y yd Rolloff Container $ BackDoor Trash EWaste and HHW PARTI IV Per Unit/ Per Month $ Special Collection Per Item $ Special Collection Per Ton $ 2024 Monthly Service Signature and" Title Date Date WMI Municipal Rep Signature vg5