SMBA Regular Board Meeting

July 28, 2022 |  8:30 AM |  Public Meeting Room, Oshtemo Township Hall
Minutes of the Regular Board Meeting Southwest Michigan Building Authority (SMBA) Board of Directors July 28, 2022 | 8:30am | Public Meeting Room, Oshtemo Township Hall Page 1 of 2 Action Items # Item Description: Assigned To: Due By: 4 Compile a list of specific requirements re: site development processes. Garrett Reitenour 2022-08-25 5a Compile qualifications for FA/S reviewers for Board consideration. Kyle Gibson 2022-08-25 Minutes 1. Call to Order: Chair Dusty Farmer called the meeting to order at approximately 8:33am. Name Present or Absent Dusty Farmer, Board Chair (Oshtemo Representative) Present Jeff Sorensen (Cooper Representative) Absent Carol Dehaan, Treasurer (Cooper Representative) Present Cheri Bell (Oshtemo Representative) Present Larry Stehouwer (Cooper Representative) Present Also present were: Attorney Jim Porter, Building Official Garrett Reitenour, Administrative Assistant Elvira Oropeza, Oshtemo Township Planning Director Iris Lubbert, Oshtemo Township Public Works Director Anna Horner, and Board Secretary Kyle Gibson. 2. Public Comments on Non-Agenda Items: There was no public comment. 3. Consent Agenda: a. Meeting Minutes – June 28, 2022 Regular Meeting b. Meeting Minutes – July 18, 2022 Special Meeting c. July 2022 Financial Reports d. Request for Adjustment to Schedule – Kyle Gibson Cheri Bell requested that item D be removed from the consent agenda for further discussion. A motion was made by Dusty Farmer and supported by Carol DeHaan to approve consent agenda items A through C and insert item D as item 8 on the meeting agenda. Upon a voice vote, the motion was carried 4-0 with 1 absent. 4. Discussion Re: Active Development Quality Assurance Processes for Site Plan Compliance: Planning Director Lubbert presented a request to the Board for the consideration of SMBA’s involvement in the pre-construction phase of planning/zoning review. The Board held discussion with input from Attorney Porter and Building Official Reitenour. Chair Farmer directed Building Official Reitenour to continue the discussion with Oshtemo Township staff and compile a list of requirements for further consideration at the next regular meeting. 5. Unfinished Business from Prior Meeting(s): a. Qualified Fire Alarm / Suppression Plan Reviewers: Attorney Porter shared an opinion with the Board. A motion was made by Dusty Farmer and supported by Carol DeHaan to continue utilizing Code Savvy Consultants LLC for Fire Alarm / Suppression plan reviews, to be re-evaluated at the next regular meeting pending review of additional information. Upon a voice vote, the motion was carried 4-0 with 1 absent. Minutes of the Regular Board Meeting Southwest Michigan Building Authority (SMBA) Board of Directors July 28, 2022 | 8:30am | Public Meeting Room, Oshtemo Township Hall Page 2 of 2 6. Review of Appeals Process: Chair Farmer addressed the Board. No action was necessary. 7. Aunalytics Server Upgrade Proposal: Chair Farmer shared the proposal with the Board with input from Office Manager Gibson. A motion was made by Larry Stehouwer and supported by Dusty Farmer to approve the proposal as presented. Upon a voice vote, the motion was carried 4-0 with 1 absent. 8. Request For Adjustment to Schedule – Kyle Gibson: Cheri Bell asked a clarifying question which Office Manager Gibson answered. Board consensus was to approve the request, and asked that the matter be reviewed in six months to ensure that there are no issues. No formal action was required or taken. 9. Board Chair’s Report: Chair Farmer had nothing to report. 10. Other Business: There was no other business brought forward. 11. Public Comment: There was no public comment. 12. Adjournment: Seeing and hearing no other business, and having exhausted the agenda, Board Chair Dusty Farmer declared the meeting adjourned at approximately 10:14am. Next Regular Board Meeting August 25, 2022 | 8:30am | Public Meeting Room, Oshtemo Township Hall Prepared By: KYLE GIBSON Board Secretary & Office Manager
Southwest Michigan Building Authority 7275 West Main Street Kalamazoo MI 49009 269-585-4150 www.swmiba.org Regular Board Meeting July 28, 2022 8:30 AM Oshtemo Township Hall Public Meeting Room 7275 W Main St Kalamazoo, MI 49009 Agenda 1. Call to Order 2. Public Comments on Non-Agenda Items 3. Consent Agenda a. Meeting Minutes – June 28, 2022 Regular Meeting b. Meeting Minutes – July 18, 2022 Special Meeting c. July 2022 Financial Reports d. Request For Adjustment to Schedule – Kyle Gibson 4. Unfinished Business from Prior Meeting(s) a. Qualified Fire Alarm / Suppression Plan Reviewers 5. Discussion Re: Active Development Quality Assurance Processes for Site Plan Compliance – Iris Lubbert & Anna Horner 6. Discussion Re: Review of Appeals Process 7. Aunalytics Server Upgrade Proposal 8. Board Chair’s Report 9. Other Business 10. Public Comment 11. Adjournment 2022-07-28 SMBA Board Packet | Page 1 of 38 Minutes of the Regular Board Meeting Southwest Michigan Building Authority (SMBA) Board of Directors June 28, 2022 | 8:30am | North Conference Room, Oshtemo Township Hall Page 1 of 2 Action Items # Item Description: Assigned To: Due By: 7 Prepare a list of qualified fire alarm/suppression plan reviewers. Kyle Gibson 2022-07-28 Minutes 1. Call to Order: Chair Dusty Farmer called the meeting to order at approximately 8:33am. Roll Call: Name Present or Absent Dusty Farmer, Board Chair (Oshtemo Representative) Present Jeff Sorensen (Cooper Representative) Present Carol Dehaan, Treasurer (Cooper Representative) Present Cheri Bell (Oshtemo Representative) ABSENT Larry Stehouwer (Cooper Representative) Present Also present were: SeberTans Representative Adam Lanter, Attorney Jim Porter, Administrative Assistant Elvira Oropeza, and Board Secretary Kyle Gibson. 2. Public Comments on Non-Agenda Items: There was no public comment. 3. SeberTans Audit Presentation – Adam Lanter: Adam presented the draft financial documents and accompanying documents to the Board. There was brief discussion, and the Board expressed no concerns. Note: Cheri Bell arrived at 9:01am 4. Consent Agenda: a. Meeting Minutes – May 26, 2022 Regular Meeting b. Meeting Minutes – June 9, 2022 Special Meeting c. June 2022 Financial Reports A motion was made by Jeff Sorensen and supported by Larry Stehouwer to approve the consent agenda as presented. Upon a voice vote, the motion was carried 5-0. 5. Unfinished Business from Prior Meeting(s): a. Request for Purchase of Digital Plan Review Table: Office Manager Gibson shared that he was unable to find any architecture, plan review, or municipal entities in the area who are currently using similar hardware. Following brief discussion, a motion was made by Jeff Sorensen and supported by Cheri Bell to approve the purchase of the digital plan review table as presented and authorize the necessary budget amendment. Upon a voice vote, the motion was carried 5-0. 6. Selection of Temporary Part-Time Clerical Assistant: A motion was made by Jeff Sorensen and supported by Carol DeHaan to hire the selected applicant. Upon a voice vote, the motion was carried 5-0. 2022-07-28 SMBA Board Packet | Page 2 of 38 Minutes of the Regular Board Meeting Southwest Michigan Building Authority (SMBA) Board of Directors June 28, 2022 | 8:30am | North Conference Room, Oshtemo Township Hall Page 2 of 2 7. Closed Session to Discuss Written Opinion of Counsel: Office Manager Gibson read aloud a resolution to meet in closed session to consult with Attorney Porter regarding written opinion of counsel. A motion was made by Dusty Farmer and supported by Jeff Sorensen to adopt the foregoing resolution. Upon a roll call vote, the following voted: Yes: Jeff Sorensen, Dusty Farmer, Carol DeHaan, Cheri Bell, Larry Stehouwer The Board adjourned to closed session at approximately 9:19am. Note: Cheri Bell left at approximately 9:55am. A motion was made by Dusty Farmer and supported by Carol DeHaan to exit closed session. Upon a voice vote, the motion was carried 5-0. The Board exited closed session at approximately 10:09am. The Board directed Office Manager Gibson to prepare a list of qualified fire alarm/suppression plan reviewers for the Board’s review at the next regular meeting. 8. Board Chair’s Report: Chair Farmer had nothing to report. 9. Other Business: There was no other business brought forward. 10. Public Comment: There was no public comment. 11. Adjournment: Seeing and hearing no other business, and having exhausted the agenda, Board Chair Dusty Farmer declared the meeting adjourned at approximately 10:15am. Next Regular Board Meeting July 28, 2022 | 8:30am | North Conference Room, Oshtemo Township Hall Prepared By: KYLE GIBSON Board Secretary & Office Manager 2022-07-28 SMBA Board Packet | Page 3 of 38 Minutes of the Special Board Meeting Southwest Michigan Building Authority (SMBA) Board of Directors July 18, 2022 | 10:00am | Public Meeting Room, Oshtemo Township Hall Page 1 of 1 Minutes 1. Call to Order: Chair Dusty Farmer called the meeting to order at approximately 10:00am. Name Present or Absent Dusty Farmer, Board Chair (Oshtemo Representative) Present Jeff Sorensen (Cooper Representative) Present Carol Dehaan, Treasurer (Cooper Representative) Present Cheri Bell (Oshtemo Representative) Present Larry Stehouwer (Cooper Representative) Present Also present were: Building Official Garrett Reitenour, Attorney Jim Porter, and Board Secretary Kyle Gibson. 2. Public Comment on Non-Agenda Items: None 3. Consideration of a Personnel Evaluation: A motion was made by Jeff Sorensen and supported by Carol DeHaan to adopt a resolution to enter closed session. Upon a Roll Call Vote, the following voted: Yes: Dusty Farmer, Carol DeHaan, Cheri Bell, Larry Stehouwer, Jeff Sorensen Board Chair Dusty Farmer declared that the motion was carried 5-0 and the resolution duly adopted. The board adjourned to closed session at approximately 10:02am. Note: Cheri Bell was excused from the meeting at approximately 11:10am. A motion was made by Jeff Sorensen and supported by Larry Stehouwer to return to open session. Opposed: None. The motion was carried 4-0 with 1 absent. The board returned to open session at approximately 11:56am. The board found no issue with the performance of the Building Official. A motion was made by Dusty Farmer and supported By Carol DeHaan to direct the Building Official and the Attorney to meet with the property owner to discuss options for a code-compliant resolution. Opposed: None. The motion was carried 4-0 with 1 absent. The board directed Office Manager Gibson to add a discussion on the appeals process to the agenda at the next regular meeting. 4. Public Comment: There was no public comment. 5. Adjournment: Having exhausted the agenda, Board Chair Dusty Farmer declared the meeting adjourned at approximately 12:05pm. Next Regular Board Meeting July 28, 2022 | 8:30am | Public Meeting Room, Oshtemo Township Hall Prepared By: KYLE GIBSON Board Secretary & Office Manager 2022-07-28 SMBA Board Packet | Page 4 of 38 Southwest Michigan Building Authority 7275 West Main Street Kalamazoo MI 49009 269-585-4150 www.swmiba.org Financial Reports for: July 2022 As of 2022-07-22 1. Permit Revenue & Inspections Report 2. Bank Account Balance Report 3. Accounts Payable Detailed Disbursement Report 4. Payroll Expense Report 5. Budget Snapshot 2022-07-28 SMBA Board Packet | Page 5 of 38 SOUTHWEST MICHIGAN BUILDING AUTHORITY REVENUE / INSPECTIONS REPORT Reporting Period: 06/20/2022 to 07/22/2022 Building Electrical Mechanical Plumbing Totals Oshtemo 37 22 55 21 135 Revenue $17,578.00 $3,882.00 $7,462.00 $3,001.00 $31,923.00 YTD Oshtemo 274 169 256 125 824 YTD Revenue $123,028.32 $29,712.00 $40,118.75 $18,887.00 $211,746.07 Cooper 18 9 16 6 49 Revenue $5,471.00 $1,448.00 $2,013.00 $937.00 $9,869.00 YTD Cooper 105 78 91 23 297 YTD Revenue $36,555.00 $12,597.00 $13,643.00 $3,546.00 $66,341.00 Total Permits 55 31 71 27 184 Total Revenue $23,049.00 $5,330.00 $9,475.00 $3,938.00 $41,792.00 YTD Total Permits 379 247 347 148 1121 YTD Total Revenue $159,583.32 $42,309.00 $53,761.75 $22,433.00 $278,087.07 Building Electrical Mechanical Plumbing Totals Oshtemo Inpsections 113 64 64 34 275 Cooper Inspections 46 17 14 7 84 YTD Oshtemo Inspections 752 351 395 260 1758 YTD Cooper Inspections 220 109 109 55 493 Total Inspections 159 81 78 41 359 YTD Total Inspections 972 460 504 315 2251 Permit Revenue Inspections 0 100 200 300 400 500 600 $0.00 $20,000.00 $40,000.00 $60,000.00 $80,000.00 $100,000.00 2021 Revenue by Month 2022 Revenue by Month 2021 Inspections by Month 2022 Inspections by Month Printed 7/22/2022 at 8:58 AM I:\Board Meetings\01 TEMPLATES\Revenue & Inspections Report 2022-07-28 SMBA Board Packet | Page 6 of 38 SOUTHWEST MICHIGAN BUILDING AUTHORITY BANK BALANCE REPORT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2021 $503,222.53 $523,735.52 $538,097.75 $534,031.68 $547,884.78 $585,009.74 $582,810.88 $605,716.44 $651,192.93 $663,095.00 $660,676.17 $656,042.63 2022 $626,707.80 $625,317.91 $612,116.01 $617,783.73 $631,620.06 $664,256.90 $650,949.16 $0.00 $100,000.00 $200,000.00 $300,000.00 $400,000.00 $500,000.00 $600,000.00 $700,000.00 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Bank Account Balance by Month 2021 2022 Printed 7/22/2022 at 8:58 AM I:\Board Meetings\01 TEMPLATES\Revenue & Inspections Report 2022-07-28 SMBA Board Packet | Page 7 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 1/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 07/13/2022 Y 700.00 CASSOPOLIS MI, 49031-9454 / / 0.0000 N 0.00 2032 21670 SHIAWASSEE DR 07/13/2022 N 700.00 ADAHLGREN ADAM J DAHLGREN 07/13/2022 2022-07-13-1 SWBA BUILDING INSPECTIONS 569-273-80100 Building Inspector 700.00 VENDOR TOTAL: 700.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/23/2022 N 75.98 SEATTLE WA, 98124-5184 / / 0.0000 Y 0.00 2010 PO BOX 035184 06/23/2022 N 75.98 AMAZON AMAZON CAPITAL SERVICES 06/23/2022 197T-34Q3-NXRC SWBA SUPPLIES 569-273-72700 VERTICAL LAPTOP STANDS QTY 2 75.98 GL NUMBER DESCRIPTION AMOUNT Paid 08/15/2022 N 22.59 SEATTLE WA, 98124-5184 / / 0.0000 Y 0.00 2037 PO BOX 035184 07/18/2022 N 22.59 AMAZON AMAZON CAPITAL SERVICES 07/18/2022 1WJN-T3P6-Y3KG SWBA SUPPLIES 569-273-72700 CASH BOX 22.59 VENDOR TOTAL: 98.57 GL NUMBER DESCRIPTION AMOUNT Paid 07/31/2022 N 1,705.00 CHICAGO IL, 60680-9113 / / 0.0000 N 0.00 2017 PO BOX 809113 07/06/2022 N 1,705.00 AUNALYTICS AUNALYTICS, INC 07/06/2022 29965406 SWBA CLOUD HOSTING SERVICES AUG 2022 569-273-80900 IT / Infrastructure 1,705.00 VENDOR TOTAL: 1,705.00 2022-07-28 SMBA Board Packet | Page 8 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 2/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 07/28/2022 N 4,221.17 DETROIT MI, 48267-4416 / / 0.0000 N 0.00 2043 PO BOX 674416 07/18/2022 N 4,221.17 BCBS BLUE CROSS BLUE SHIELD OF MICHIGAN 07/18/2022 007043238-0000 SWBA HEALTH INSURANCE SEP 2022 PREPAY 569-273-71002 Health Insurance 4,221.17 VENDOR TOTAL: 4,221.17 2022-07-28 SMBA Board Packet | Page 9 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 3/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 07/12/2022 N 570.00 ANN ARBOR MI, 48104-1354 / / 0.0000 Y 0.00 CODE ENFORCEMENT SERVICES DIVISION 07/12/2022 N 570.00 117 N 1ST ST STE 70 2028 CWA CARLISLE WORTMAN ASSOCIATES 07/12/2022 2165659 SWBA REVIEW PB22-05-0272 1750 S DRAKE RD STE 569-273-80500 BALANCE DUE 570.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/12/2022 N 120.00 ANN ARBOR MI, 48104-1354 / / 0.0000 Y 0.00 CODE ENFORCEMENT SERVICES DIVISION 07/12/2022 N 120.00 117 N 1ST ST STE 70 2030 CWA CARLISLE WORTMAN ASSOCIATES 07/12/2022 2165660 SWBA REVIEW PB22-05-0071 5130 W MAIN ST KIDS 569-273-80500 VP REVISED MEPS 1@120 120.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/12/2022 N 240.00 ANN ARBOR MI, 48104-1354 / / 0.0000 Y 0.00 CODE ENFORCEMENT SERVICES DIVISION 07/12/2022 N 240.00 117 N 1ST ST STE 70 2029 CWA CARLISLE WORTMAN ASSOCIATES 07/12/2022 2165661 SWBA REVIEW PB22-05-0137 5299 W MAIN ST PNC 569-273-80500 CS REVIEW REVISIONS / REPORT 2@120 240.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/12/2022 N 540.00 ANN ARBOR MI, 48104-1354 / / 0.0000 Y 0.00 CODE ENFORCEMENT SERVICES DIVISION 07/12/2022 N 540.00 117 N 1ST ST STE 70 2027 CWA CARLISLE WORTMAN ASSOCIATES 07/12/2022 2165662 SWBA REVIEW PB22-05-0301 5622 W MAIN ST VW S569-273-80500 JS REVISION REVIEW 3@120 360.00 569-273-80500 LP PEER REVIEW 1@120 120.00 569-273-80500 LP PLAN REVIEW CONSULTATION .5@120 60.00 540.00 2022-07-28 SMBA Board Packet | Page 10 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 4/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID VENDOR TOTAL: 1,470.00 GL NUMBER DESCRIPTION AMOUNT Paid 08/06/2022 N 265.00 BRIGHTON MI, 48114 / / 0.0000 N 0.00 2022 9032 ROSEMARY LN 07/07/2022 N 265.00 CSC CODE SAVVY CONSULTANTS LLC 07/07/2022 2017 SWBA FA REVIEW PE22-05-0233 563 N DRAKE RD FA569-273-80500 2022-0107-1 265.00 VENDOR TOTAL: 265.00 GL NUMBER DESCRIPTION AMOUNT Paid 06/27/2022 Y 1,400.00 KALAMAZOO MI, 49009-8911 / / 0.0000 N 0.00 2013 6323 WINDDRIFT AVE 06/27/2022 N 1,400.00 GHECKMAN GARYAIRE, LLC 06/27/2022 2022-06-27-2 SWBA PLUMBING / MECHANICAL INSPECTIONS 569-273-80400 Plumbing Inspector 550.00 569-273-80300 Mechanical Inspector 850.00 1,400.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/13/2022 Y 600.00 KALAMAZOO MI, 49009-8911 / / 0.0000 N 0.00 2034 6323 WINDDRIFT AVE 07/13/2022 N 600.00 GHECKMAN GARYAIRE, LLC 07/13/2022 2022-07-13-3 SWBA PLUMBING / MECHANICAL INSPECTIONS 569-273-80400 Plumbing Inspector 250.00 569-273-80300 Mechanical Inspector 350.00 600.00 VENDOR TOTAL: 2,000.00 2022-07-28 SMBA Board Packet | Page 11 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 5/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 07/11/2022 N 547.16 KALAMAZOO MI, 49007-4713 / / 0.0000 N 0.00 2025 211 S ROSE ST 07/11/2022 N 547.16 GREENLEAF GREENLEAF TRUST 07/11/2022 00016954 SWBA Q2-2022 TRUSTEE AND RECORDKEEEPING FEES 569-273-71009 TRUSTEE MARKET VALUE FEE 119.16 569-273-71009 RECORDKEEPING BASE FEE 400.00 569-273-71009 RECORDKEEPING PER PARTICIPANT FEE 28.00 547.16 VENDOR TOTAL: 547.16 GL NUMBER DESCRIPTION AMOUNT Paid 08/31/2022 N 348.00 BIRMINGHAM AL, 35213 / / 0.0000 N 0.00 ATTN MEMBERSHIP 07/18/2022 N 348.00 900 MONTCLAIR RD 2045 ICC INTERNATIONAL CODE COUNCIL 07/18/2022 3338129 SWBA MEMBERSHIP RENEWAL 3YRS 569-273-71103 Education / Membership Dues 348.00 VENDOR TOTAL: 348.00 2022-07-28 SMBA Board Packet | Page 12 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 6/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 07/18/2022 N 90.00 KALAMAZOO MI, 49009-5469 / / 0.0000 N 0.00 2038 2615 W F AVE 07/18/2022 N 90.00 LSTEHOUWER LARRY STEHOUWER 07/18/2022 2022-07-18-1 SWBA BOARD MEETING ATTENDANCE Q2-2022 569-273-70204 2022-04-28 30.00 569-273-70204 2022-05-26 30.00 569-273-70204 2022-06-28 30.00 90.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/18/2022 N 30.00 KALAMAZOO MI, 49009-5469 / / 0.0000 Y 0.00 2039 2615 W F AVE 07/18/2022 N 30.00 LSTEHOUWER LARRY STEHOUWER 07/18/2022 2022-07-18-2 SWBA BOARD MEETING ATTENDANCE 2022-07-18 SPE569-273-70204 2022-07-18 SPECIAL 30.00 VENDOR TOTAL: 120.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/22/2022 N 547.83 KALAMAZOO MI, 49009-1332 / / 0.0000 N 0.00 2020 811 S DRAKE RD 07/06/2022 N 547.83 VISA MERCANTILE VISA 07/06/2022 2022-07-06-01 SWBA VISA BILL JUN 2022 569-273-86000 GAS 282.03 569-273-86000 CAR WASH MONTHLY SUBSCRIPTION 29.99 569-273-80901 COGNITO FORMS SUBSCRIPTION 127.00 569-273-80901 ELEMENTOR PRO RENEWAL SWMIBA.ORG 49.00 569-273-72800 Postage / Shipping 8.95 569-273-72700 WALGREENS / COVID RAPID TESTS QTY 2 50.86 547.83 VENDOR TOTAL: 547.83 2022-07-28 SMBA Board Packet | Page 13 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 7/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 07/20/2022 N 50.00 KALAMAZOO MI, 49001 07/20/2022 0.0000 N 0.00 2046 918 JASPER ST 07/20/2022 N 0.00 MISC MILESTONE SENIOR SERVICES 07/20/2022 00035307 SWBA BD Payment Refund 569-272-49100 01. Building Fee 50.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/20/2022 N 50.00 KALAMAZOO MI, 49001 07/20/2022 0.0000 N 0.00 2047 918 JASPER ST 07/20/2022 N 0.00 MISC MILESTONE SENIOR SERVICES 07/20/2022 00035989 SWBA BD Payment Refund 569-272-49100 01. Building Fee 50.00 VENDOR TOTAL: 100.00 GL NUMBER DESCRIPTION AMOUNT Paid 06/27/2022 Y 1,750.00 COLDWATER MI, 49036-9553 / / 0.0000 N 0.00 2012 426 SARAH LN 06/27/2022 N 1,750.00 TTHATCHER MP SERVICES LLC 06/27/2022 2022-06-27-1 SWBA MECHANICAL / PLUMBING INSPECTIONS 569-273-80300 Mechanical Inspector 1,350.00 569-273-80400 Plumbing Inspector 400.00 1,750.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/13/2022 Y 1,250.00 COLDWATER MI, 49036-9553 / / 0.0000 N 0.00 2035 426 SARAH LN 07/13/2022 N 1,250.00 TTHATCHER MP SERVICES LLC 07/13/2022 2022-07-13-4 SWBA MECHANICAL / PLUMBING INSPECTIONS 569-273-80300 Mechanical Inspector 600.00 569-273-80400 Plumbing Inspector 650.00 1,250.00 VENDOR TOTAL: 3,000.00 2022-07-28 SMBA Board Packet | Page 14 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 8/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 07/03/2022 N 20.71 CINCINNATI OH, 45263-3301 / / 0.0000 N 0.00 2007 PO BOX 633301 06/21/2022 N 20.71 ODP ODP BUSINESS SOLUTIONS 06/21/2022 248524708001 SWBA OFFICE SUPPLIES 569-273-72700 COVID TEST KITS 2-PACK QTY 2 20.71 GL NUMBER DESCRIPTION AMOUNT Paid 07/03/2022 N 18.39 CINCINNATI OH, 45263-3301 / / 0.0000 N 0.00 2008 PO BOX 633301 06/21/2022 N 18.39 ODP ODP BUSINESS SOLUTIONS 06/21/2022 250459289001 SWBA OFFICE SUPPLIES 569-273-72700 ADDRESS LABELS 18.39 GL NUMBER DESCRIPTION AMOUNT Paid 07/17/2022 N 49.98 CINCINNATI OH, 45263-3301 / / 0.0000 N 0.00 2018 PO BOX 633301 07/06/2022 N 49.98 ODP ODP BUSINESS SOLUTIONS 07/06/2022 252024055001 SWBA OFFICE SUPPLIES 569-273-72700 YELLOW COPY PAPER QTY 2 REAMS 49.98 GL NUMBER DESCRIPTION AMOUNT Paid 07/31/2022 N 48.00 CINCINNATI OH, 45263-3301 / / 0.0000 N 0.00 2044 PO BOX 633301 07/18/2022 N 48.00 ODP ODP BUSINESS SOLUTIONS 07/18/2022 254415107001 SWBA OFFICE SUPPLIES 569-273-72700 COVID TESTS 2/BOX QTY 3 BOX 48.00 VENDOR TOTAL: 137.08 2022-07-28 SMBA Board Packet | Page 15 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 9/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 07/18/2022 N 315.00 MEDINA OH, 44256 07/18/2022 0.0000 N 0.00 ATTN OWEN CLEVENGER 07/18/2022 N 0.00 1093 MEDINA RD STE 100 2040 MISC PLEASANT VALLEY CORPORATION 07/18/2022 00036118 SWBA BD PAYMENT REFUND 569-272-49100 Fee Adjustment at Applicant Request 315.00 VENDOR TOTAL: 315.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/27/2022 N 150.00 ATLANTA GA, 30374-0709 / / 0.0000 N 0.00 2023 PO BOX 740709 07/07/2022 N 150.00 QUEST QUEST DIAGNOSTICS 07/07/2022 9199314892 SWBA ACCOUNT SET UP FEE 569-273-95500 Miscellaneous 150.00 VENDOR TOTAL: 150.00 GL NUMBER DESCRIPTION AMOUNT Paid 06/24/2022 Y 250.00 VAN BUREN TWP MI, 48111-1677 / / 0.0000 N 0.00 2011 9593 REVERE DR 06/24/2022 N 250.00 REDMOND REDMOND ENGINEERING & DESIGN 06/24/2022 22-014-001 SWBA FS REVIEW PM22-05-0257 5481 W MAIN ST L569-273-80500 Plan Review 250.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/07/2022 Y 250.00 VAN BUREN TWP MI, 48111-1677 / / 0.0000 N 0.00 2021 9593 REVERE DR 07/07/2022 N 250.00 REDMOND REDMOND ENGINEERING & DESIGN 07/07/2022 22-015-001 SWBA FS REVIEW PM22-05-0284 563 N DRAKE RD FA569-273-80500 Plan Review 250.00 VENDOR TOTAL: 500.00 2022-07-28 SMBA Board Packet | Page 16 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 10/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 06/25/2022 N 108.22 CHICAGO IL, 60680-2815 / / 0.0000 N 0.00 2009 PO BOX 802815 06/21/2022 N 108.22 RICOH RICOH 06/21/2022 5064880238 SWBA JUN 2022 CONTRACT # 4470926 569-273-95600 MPC2504 BASE 2022-06-15 TO 2022-07-14 15.41 569-273-95600 MPC2504 BW READ 2.87 569-273-95600 MPC2504 COLOR READ 89.94 108.22 GL NUMBER DESCRIPTION AMOUNT Paid 07/11/2022 N 224.16 CHICAGO IL, 60680-2815 / / 0.0000 N 0.00 2024 PO BOX 802815 07/08/2022 N 224.16 RICOH RICOH 07/08/2022 5064968197 SWBA Q3-2022 CONTRACT # 5137948 569-273-95600 MPCW2201SP BASE 2022-07-01 TO 2022-09-30 210.00 569-273-95600 MPCW2201SP COLOR READ 14.16 224.16 VENDOR TOTAL: 332.38 GL NUMBER DESCRIPTION AMOUNT Paid 08/10/2022 N 2,950.00 KALAMAZOO MI, 49008-1981 / / 0.0000 N 0.00 2042 555 W CROSSTOWN PKWY STE 304 07/18/2022 N 2,950.00 SEBERTANS SEBER TANS PLC 07/18/2022 1000058112 SWBA AUDIT FEES 569-273-80700 Accounting / Audit Fees 2,950.00 VENDOR TOTAL: 2,950.00 2022-07-28 SMBA Board Packet | Page 17 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 11/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 07/11/2022 N 170.00 PORTAGE MI, 49002-0507 / / 0.0000 N 0.00 2026 246 E KILGORE RD 07/11/2022 N 170.00 SIEGFRIED SIEGFRIED CRANDALL PC 07/11/2022 109746 SWBA ACCOUNTING SERVICES JUN 2022 569-273-80700 Accounting / Audit Fees 170.00 VENDOR TOTAL: 170.00 GL NUMBER DESCRIPTION AMOUNT Paid 08/01/2022 N 209.43 PHILADELPHIA PA, 19170-0001 / / 0.0000 N 0.00 2036 PO BOX 7247-0381 07/15/2022 N 209.43 SUN LIFE SUN LIFE FINANCIAL 07/15/2022 247757 SWBA LIFE INSURANCE AUG 2022 569-273-71003 Disability / Life Insurance 209.43 VENDOR TOTAL: 209.43 GL NUMBER DESCRIPTION AMOUNT Paid 07/13/2022 N 144.07 CHICAGO IL, 60677-8000 / / 0.0000 N 0.00 2031 8020 SOLUTIONS CTR 07/13/2022 N 144.07 TELNET TELNET WORLDWIDE 07/13/2022 251554 SWBA PHONE JUL 2022 569-273-85000 Telephone 144.07 VENDOR TOTAL: 144.07 GL NUMBER DESCRIPTION AMOUNT Paid 07/14/2022 N 51.00 CINCINNATI OH, 45274-2596 / / 0.0000 N 0.00 2016 PO BOX 742596 06/30/2022 N 51.00 TMOBILE T-MOBILE 06/30/2022 977195739 SWBA MOBILE HOTSPOT USAGE JUN 2022 569-273-80900 IT / Infrastructure 51.00 VENDOR TOTAL: 51.00 2022-07-28 SMBA Board Packet | Page 18 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 12/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID GL NUMBER DESCRIPTION AMOUNT Paid 07/21/2022 N 97.47 CHICAGO IL, 60680-1741 / / 0.0000 N 0.00 ATTN ACCOUNTS RECEIVABLE 07/06/2022 N 97.47 PO BOX 88741 2019 ULINE ULINE 07/06/2022 150438139 SWBA OFFICE SUPPLIES 569-273-72700 2′ X 3′ ANTI FATIGUE STANDING MAT FOR EL 97.47 VENDOR TOTAL: 97.47 GL NUMBER DESCRIPTION AMOUNT Paid 07/06/2022 N 11,371.00 MORGAN HILL CA, 95037 / / 0.0000 Y 0.00 2015 18440 TECHNOLOGY DR STE 130 06/29/2022 N 11,371.00 MISC VOLANTI DISPLAYS 06/29/2022 461 SWBA 65″ PLAN REVIEW TABLE DISPLAY 569-273-97100 Capital Outlay 11,371.00 VENDOR TOTAL: 11,371.00 GL NUMBER DESCRIPTION AMOUNT Paid 06/27/2022 Y 1,600.00 MATTAWAN MI, 49071-9746 / / 0.0000 N 0.00 2014 38159 24TH ST 06/27/2022 N 1,600.00 WWILCOX WILLIAM WILCOX 06/27/2022 2022-06-27-03 SWBA ELECTRICAL INSPECTIONS 569-273-80200 Electrical Inspector 1,600.00 GL NUMBER DESCRIPTION AMOUNT Paid 07/13/2022 Y 2,250.00 MATTAWAN MI, 49071-9746 / / 0.0000 N 0.00 2033 38159 24TH ST 07/13/2022 N 2,250.00 WWILCOX WILLIAM WILCOX 07/13/2022 2022-07-13-2 SWBA ELECTRICAL INSPECTIONS 569-273-80200 Electrical Inspector 1,150.00 569-273-80100 Building Inspector 1,100.00 2,250.00 2022-07-28 SMBA Board Packet | Page 19 of 38 Due Date 1099 Net Amount City/State/Zip Disc. Date Disc. % Sep CK Discount Ref # Address CK Run Date PO Hold Gross Amount Vendor Code Vendor name Post Date Invoice Bank Invoice Description 07/22/2022 09:00 AM INVOICE APPROVAL BY INVOICE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 13/13 User: kgibson DB: Smba POST DATES 06/20/2022 – 07/22/2022 BOTH JOURNALIZED AND UNJOURNALIZED PAID VENDOR TOTAL: 3,850.00 TOTAL – ALL VENDORS: 35,400.16 2022-07-28 SMBA Board Packet | Page 20 of 38 Fund Item Amount 07/22/2022 09:02 AM Page 1 of 1 For Journal Entries with Post Dates Between 06/20/2022 and 07/22/2022 Journal Totals By Fund Report Total Payroll: 16,938.63 Net Payment: 10,756.68 Gross Payment: 14,779.12 569 Pay Codes Amount HOLIDAY 705.39 HOURLY 4,860.34 OPT-OUT 334.93 PHONE 145.37 PTO 1,787.51 SALARY 2,923.14 Pay Code Totals: 10,756.68 Deductions Amount FITW 795.20 HSA_EE 400.00 MEDICARE_EE 206.32 PENSION_EE_PRE 120.89 PENSION_EE_ROTH 983.60 SITW 634.22 SOCSEC_EE 882.21 Deduction Totals: 4,022.44 Expenses Amount MEDICARE_ER 206.32 PENSION_ER 535.49 PENSION_ER_MTCH 535.49 SOCSEC_ER 882.21 Expense Totals: 2,159.51 2022-07-28 SMBA Board Packet | Page 21 of 38 07/22/2022 09:03 AM REVENUE AND EXPENDITURE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 1/2 User: kgibson DB: Smba PERIOD ENDING 07/31/2022 % Fiscal Year Completed: 58.08 % BDGT USED AVAILABLE BALANCE ACTIVITY FOR MONTH 07/31/2022 YTD BALANCE 07/31/2022 2022 GL NUMBER DESCRIPTION AMENDED BUDGET Fund 569 – Building Authority Revenues Dept 000 – A&L, Balance Sheet Accounts 569-000-99999 Carryover 0.00 0.00 0.00 0.00 0.00 Total Dept 000 – A&L, Balance Sheet Accounts 0.00 0.00 0.00 0.00 0.00 Dept 272 – Revenue Accounts 569-272-49100 Building Permits 200,000.00 113,521.57 8,110.00 86,478.43 56.76 569-272-49200 Electrical Permits 50,000.00 20,854.00 1,614.00 29,146.00 41.71 569-272-49300 Mechanical Permits 50,000.00 28,346.75 3,269.00 21,653.25 56.69 569-272-49400 Plumbing Permits 25,000.00 9,103.00 669.00 15,897.00 36.41 569-272-60701 FOIA Fees 500.00 239.80 7.70 260.20 47.96 569-272-62600 Building Services to Others 0.00 0.00 0.00 0.00 0.00 569-272-62701 Building Inspections 85,000.00 35,430.00 2,200.00 49,570.00 41.68 569-272-62702 Electrical Inspections 40,000.00 22,900.00 1,900.00 17,100.00 57.25 569-272-62703 Mechanical Inspections 45,000.00 25,000.00 2,800.00 20,000.00 55.56 569-272-62704 Plumbing Inspections 35,000.00 14,650.00 1,100.00 20,350.00 41.86 569-272-63000 Plan Review 70,000.00 15,361.75 1,775.00 54,638.25 21.95 569-272-66300 Bond Forfeitures and Bond Costs 0.00 0.00 0.00 0.00 0.00 569-272-66500 Interest on Investments 1,100.00 732.60 0.00 367.40 66.60 569-272-67300 Gain/Loss on Sale of Assets 0.00 0.00 0.00 0.00 0.00 569-272-67500 Miscellaneous 1,100.00 (576.00) 0.00 1,676.00 (52.36) Total Dept 272 – Revenue Accounts 602,700.00 285,563.47 23,444.70 317,136.53 47.38 TOTAL REVENUES 602,700.00 285,563.47 23,444.70 317,136.53 47.38 Expenditures Dept 273 – Building Authority Expense Activity 569-273-70200 Salaries 181,814.00 94,372.93 7,526.10 87,441.07 51.91 569-273-70203 Building Board of Appeals 0.00 0.00 0.00 0.00 0.00 569-273-70204 Board Member At Large Stipend 360.00 210.00 120.00 150.00 58.33 569-273-71002 Health Insurance 51,000.00 37,349.02 4,221.17 13,650.98 73.23 569-273-71003 Disability / Life Insurance 2,160.00 1,366.46 209.43 793.54 63.26 569-273-71004 Work Comp Insurance 2,200.00 1,395.00 0.00 805.00 63.41 569-273-71005 Payroll Taxes – FICA 13,464.00 7,228.46 576.37 6,235.54 53.69 569-273-71006 HSA 7,270.00 7,257.00 0.00 13.00 99.82 569-273-71009 Pension Plan 14,080.00 8,537.15 1,083.24 5,542.85 60.63 569-273-71101 In Lieu of Insurance 5,420.00 2,916.76 208.34 2,503.24 53.81 569-273-71102 Clothing Allowance 1,500.00 264.00 0.00 1,236.00 17.60 569-273-71103 Education / Membership Dues 3,500.00 2,923.45 348.00 576.55 83.53 569-273-72700 Supplies 4,500.00 1,184.19 268.90 3,315.81 26.32 569-273-72800 Postage / Shipping 2,750.00 855.53 8.95 1,894.47 31.11 569-273-72900 General Insurance 9,400.00 8,818.00 0.00 582.00 93.81 569-273-80100 Building Inspector 10,000.00 3,700.00 1,800.00 6,300.00 37.00 569-273-80200 Electrical Inspector 40,000.00 20,200.00 1,150.00 19,800.00 50.50 569-273-80300 Mechanical Inspector 45,000.00 22,200.00 950.00 22,800.00 49.33 569-273-80400 Plumbing Inspector 35,000.00 14,300.00 900.00 20,700.00 40.86 569-273-80500 Plan Review 70,000.00 15,446.75 1,985.00 54,553.25 22.07 569-273-80600 Consultants 0.00 0.00 0.00 0.00 0.00 569-273-80700 Accounting / Audit Fees 10,500.00 6,925.00 3,120.00 3,575.00 65.95 569-273-80800 Legal Fees 5,000.00 2,454.50 0.00 2,545.50 49.09 569-273-80900 IT / Infrastructure 22,500.00 14,256.28 1,705.00 8,243.72 63.36 569-273-80901 IT / Software 15,000.00 3,905.75 176.00 11,094.25 26.04 2022-07-28 SMBA Board Packet | Page 22 of 38 07/22/2022 09:03 AM REVENUE AND EXPENDITURE REPORT FOR SOUTHWEST MICHIGAN BUILDING AUTHORITY Page: 2/2 User: kgibson DB: Smba PERIOD ENDING 07/31/2022 % Fiscal Year Completed: 58.08 % BDGT USED AVAILABLE BALANCE ACTIVITY FOR MONTH 07/31/2022 YTD BALANCE 07/31/2022 2022 GL NUMBER DESCRIPTION AMENDED BUDGET Fund 569 – Building Authority Expenditures 569-273-80902 IT / Support 500.00 185.00 0.00 315.00 37.00 569-273-85000 Telephone 4,260.00 2,026.43 294.07 2,233.57 47.57 569-273-86000 Vehicle Gas / Maintenance 3,000.00 1,844.26 312.02 1,155.74 61.48 569-273-86100 Mileage 500.00 107.76 0.00 392.24 21.55 569-273-94000 Facility Rent 22,000.00 22,000.00 0.00 0.00 100.00 569-273-95500 Miscellaneous 0.00 (146.05) 150.00 146.05 100.00 569-273-95600 Equipment / Maintenance 2,000.00 1,279.21 224.16 720.79 63.96 569-273-96401 Refund of Overpayment 0.00 0.00 0.00 0.00 0.00 569-273-96500 Bank Service Charges 660.00 367.95 26.00 292.05 55.75 569-273-96800 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 569-273-97100 Capital Outlay 17,650.00 13,675.56 0.00 3,974.44 77.48 569-273-97200 Capital Outlay – Vehicle 0.00 0.00 0.00 0.00 0.00 569-273-99300 Interest/Penalty IRS/State Withholdings 0.00 0.00 0.00 0.00 0.00 Total Dept 273 – Building Authority Expense Activity 602,988.00 319,406.35 27,362.75 283,581.65 52.97 TOTAL EXPENDITURES 602,988.00 319,406.35 27,362.75 283,581.65 52.97 NET OF REVENUES & EXPENDITURES (288.00) (33,842.88) (3,918.05) 33,554.88 11,751.00 TOTAL EXPENDITURES 602,988.00 319,406.35 27,362.75 283,581.65 52.97 TOTAL REVENUES 602,700.00 285,563.47 23,444.70 317,136.53 47.38 Fund 569 – Building Authority: NET OF REVENUES & EXPENDITURES (288.00) (33,842.88) (3,918.05) 33,554.88 11,751.00 TOTAL EXPENDITURES – ALL FUNDS 602,988.00 319,406.35 27,362.75 283,581.65 52.97 TOTAL REVENUES – ALL FUNDS 602,700.00 285,563.47 23,444.70 317,136.53 47.38 2022-07-28 SMBA Board Packet | Page 23 of 38 Page 1 of 1 Southwest Michigan Building Authority Board of Directors Meeting Agenda Item Request / Cover Sheet For Meeting Date 7/28/2022 Subject Request for Adjustment to Schedule Submitted By Kyle Gibson Assigned Item # 03d Is board action required? ☐ Yes ☑ No Background Information / Request: I am requesting that the board authorize a change to my work schedule. I would like to come in at 7am instead of 8am, then take a two-hour lunch from 12pm to 2pm (which partially coincides with the closure of the office from 1pm to 2pm). I have discussed this with El and she has no concerns. I would also be flexible with this schedule as required to ensure coverage. Implications / Financial Impact: Not applicable. List / Describe Any Supporting Documents: Not applicable. Suggested Motion: Not applicable. 2022-07-28 SMBA Board Packet | Page 24 of 38 Page 1 of 1 Southwest Michigan Building Authority Board of Directors Meeting Agenda Item Request / Cover Sheet For Meeting Date 7/28/2022 Subject Qualified Fire Alarm / Suppression Plan Reviewers Submitted By Kyle Gibson, Office Manager Assigned Item # 04a Is board action required? ☐ Yes ☑ No Background Information / Request: As requested at the June 28, 2022 regular meeting, provided below for the board’s consideration is a list of the fire alarm / suppression plan reviewers who are currently in use by SMBA, and a company put forth by Attorney Porter which SMBA has not worked with before. Code Savvy Consultants LLC (Alarms, Suppression, Tanks, Radio Systems, Clean Agent Systems) Redmond Engineering (Suppression) Code Enforcement Services (Full Service) Firedyne Engineering PC (Full Service) Implications / Financial Impact: N/a List / Describe Any Supporting Documents: N/a Suggested Motion: N/a 2022-07-28 SMBA Board Packet | Page 25 of 38 Page 1 of 1 Southwest Michigan Building Authority Board of Directors Meeting Agenda Item Request / Cover Sheet For Meeting Date 7/28/2022 Subject Discussion: Active Development Quality Assurance Processes for Site Plan Compliance Submitted By Iris Lubbert, Oshtemo Township Planning Director Assigned Item # 005 Is board action required? ☑ Yes ☐ No Background Information / Request: Oshtemo Township staff has recognized the inability to keep up with ongoing development/construction observation needs. Staff has completed a gap analysis and completed a proposed development milestone inspection check list which was presented to the Township Board at their 7/12 meeting. It was agreed that additional staffing and or a change in structure was needed to adequately complete all the milestones identified. The Township Board identified a next step as meeting with the SMBA Board to discuss how SMBA may be able to assist and if any of the identified milestones were appropriate for SMBA to incorporate into their review process. Implications / Financial Impact: TBD – discussion needed List / Describe Any Supporting Documents: development milestone inspection check list Suggested Motion: N/A 2022-07-28 SMBA Board Packet | Page 26 of 38 Development milestone inspections: verify compliance with approved plans and conditions + identifying deficiencies + review and approve corrective measures Technical Development Review Team member – assist with site visits/assessments as needed. Become liaison or report to Zoning Administrator (?) – the point of contact for projects that enter the build phase Beginning of the process/prior to construction: 1. Ensure township conditions of approval has been satisfied – Zoning Administrator a. Confirm permits obtained from outside agencies (RCKC/MDOT, EGLE, KCDC). Zoning Administrator b. Water and sewer fees are paid – Zoning Administrator c. Etc. 2. Preconstruction staking (Site layout/Elevations) prior to foundation permit being issued to be done by contractor. To be confirmed by Oshtemo. No one a. Property line: Oshtemo to make sure property pins are installed/present at beginning /correct locations. Developer to install or correct if needed. b. staking of major structures to confirm setbacks. c. finish floor elevation reference point – stake onsite for FFE/benchmark set 3. Once foundation is poured – setbacks and elevations certification form/statement filed with the Township. No one 4. Onsite inspection of any infrastructure that will be within a public easement (water minimal and sewer full time – make sure what is installed meets plans and specifications). 5. Confirm construction layout, dimensions, thickness of all roads (private and public). No one a. Public: Testing of construction materials (see RCKC booklet) conducted by contractor/developer. Documentation provided to Township (to confirm with RCKC). Township to verify layout/thickness/compliance. b. Private: Contractor to submit material tickets – document material (to be built to public road standards). Township to verify layout/thickness/compliance. Throughout process: 1. Sidewalk installation and scheduling [a pre (24 hour notice minimum) and post pour inspection]. Public Works 2. Road construction – ensure proper material testing is done per RCKC ‘Procedures, Guidelines, and Specifications for developing public roads’ for both private and public roads. Observe that associated drainage system is in place as approved. Check grading. No one 2022-07-28 SMBA Board Packet | Page 27 of 38 3. Overall ADA site accessibility (ex. ensure ADA parking spots are compliant and proper material; check ramps into building, review any proposed network connections and site access). P&N/PW at end of process 4. Confirm that parking lot overall approved layout and specifications are met. No one 5. Other agency permit compliance (City of Kalamazoo, RCKC/MDOT, EGLE, KCDC). Zoning Administrator 6. Stormwater Systems/Management (verify location, size, and general construction meet approved plans and are functioning properly) P&N as requested a. Soil erosion (ensure safety, access, and general order at site is maintained with proper soil erosion measures). 7. Confirm necessary easements are drafted/are in place, both private and public. No one 8. Coordinate with PW and Planning all modifications post approval. Run biweekly status meetings to give updates. Zoning Admin with P&N a. Make recommendation on Temp CofOs are warranted as progress occurs b. Keep apprised of addendums or plan changes are submitted to Township End of process: 1. Property pins in place + correct location. Developer to correct or install. No one 2. Landscaping inspection Zoning Administrator 3. Misc. plan compliance (dumpster, fencing, bike racks, etc) Zoning Administrator 4. Pavement markings and signage Zoning Administrator or P&N 5. Photometric plan Zoning Administrator 6. Confirm that all easement documents/restrictions/ master deed/ etc recorded/ match as built Zoning Administrator 7. File all as-builts and distribute to appropriate Depts/Agencies PW/Zoning Admin/SMBA 8. Development Certification No one a. Survey provided by owner/applicant to record as built conditions – see below b. Licensed Engineer confirms approved plan conditions and intent are in place on behalf of Owner and Designer 2022-07-28 SMBA Board Packet | Page 28 of 38 Post Development: 7. Check landscaping in the Spring after approval. Zoning Admin 8. Random audit of sites as time allows Is currently complaint based a. Ensure approved site plan and relevant special use conditions are being followed (outdoor storage and display + landscaping is being maintained+ etc). b. Make sure stormwater basins / storm water system is being properly maintained c. Report other ordinance non-compliance as warranted 2022-07-28 SMBA Board Packet | Page 29 of 38 Page 1 of 1 Southwest Michigan Building Authority Board of Directors Meeting Agenda Item Request / Cover Sheet For Meeting Date 7/28/2022 Subject Discussion Re: Review of Appeals Process Submitted By Board Request Assigned Item # 006 Is board action required? ☐ Yes ☑ No Background Information / Request: N/a Implications / Financial Impact: N/a List / Describe Any Supporting Documents: N/a Suggested Motion: N/a 2022-07-28 SMBA Board Packet | Page 30 of 38 Page 1 of 1 Southwest Michigan Building Authority Board of Directors Meeting Agenda Item Request / Cover Sheet For Meeting Date 7/28/2022 Subject Aunalytics Server Upgrade Proposal Submitted By Kyle Gibson, Office Manager Assigned Item # 007 Is board action required? ☑ Yes ☐ No Background Information / Request: On May 11th, we were notified by Aunalytics that Microsoft will be ending support for Windows Server 2012R2 on October 10, 2023. Therefore, it is necessary to upgrade our hosted servers to a more current operating system. Aunalytics has provided us with a proposal for the upgrade, which is provided for the Board’s review. The proposal includes the fixed labor costs to perform the upgrades, and it also includes a 1TB increase to our storage capacity (which would result in a minor increase in our monthly costs). Despite the unbudgeted cost, my recommendation is to accept the proposal and move forward with the upgrade prior to the end of this year. We could potentially wait until 2023 and include the costs in that year’s budget, but may run in to scheduling issues with Aunalytics as many other organizations will be making this change as well. Implications / Financial Impact: Fixed Costs: $13,492.50 List / Describe Any Supporting Documents: 007a Aunalytics Server Upgrade Proposal V2.pdf Suggested Motion: 2022-07-28 SMBA Board Packet | Page 31 of 38 We have prepared a Proposal for you Cloud Services (Windows 2012 Server Upgrades) Proposal # KZ010856 Version 2 PREPARED FOR: Southwest Michigan Building Authority Kyle Gibson kgibson@swmiba.org PREPARED BY: Aunalytics – Kalamazoo Jeff Ray jeff.ray@aunalytics.com Pre-Sales Engineer: David Warren 2022-07-28 SMBA Board Packet | Page 32 of 38 6395 TechnologyAvenue Kalamazoo, MI 49009 (269) 375-8996 Statement of Work Project Intent  Implement Cloud Services Windows Server upgrades for the environment, replacing the existing Windows 2012 Servers. o Servers include- SMBA-AD1 and SMBA-RDS1.  Important Note: Client and/or third-party vendor involvement will be required during this project (vendors TBD).  Important Note: Where coordinated third-party vendor involvement is required, Aunalytics labor specific to tasks associated with the third-party vendor will be billed separately from the project. Scope Preparation:  Review the environment.  Review/discuss current servers and associated services.  Discuss client and/or third-party vendor involvement associated with applications and/or Database service deployment and migration. o Important Note: Third-party vendor involvement will be required during this project (vendors TBD).  Determine any associated project risk.  Develop a detailed project timeline.  Install and configure Cloud Services for the following VMs-  Windows 2019/2022 Server for AD, File, and SQL services (to replace SMBA-AD1 Server).  Windows 2019/2022 Server for RDS services (to replace SMBA-RDS1 Server).  Install and configure a new virtual Windows 2019/2022 Server for AD, File, and SQL services to replace SMBA-AD1 Server.  Configure AD services (existing AD structure) and File services.  Install and configure SQL based on third-party vendor requirements.  Third-party vendor to redeploy other application/Database services. o Important Note: Third-party vendor involvement required during this phase of the project.  Install and configure a new virtual Windows 2019/2022 Server for Remote Desktop and Remote Desktop Gateway services to replace SMBA-RDS1 Server.  Configure RDGW services including SSL certificate.  Configure group policies and permissions specific to RDS.  Work with the client to install application client(s) within the RDS environment. o Note: Application vendor involvement may be required during this phase of the project.  Work with the client on testing the applications.  Help resolve open RDS client issues during the testing phase of the project.  Install and configure Cloud Monitoring and Management, Antivirus, and Backup services for the associated servers. Servers Deployment (AFTER HOURS):  Join the existing AD structure.  Migrate associated roles from old servers to new.  Migrate shared file and print services from old server to new.  Work with the client to verify functionality. SQL Servers Deployment (AFTER HOURS):  Work with the client and/or third-party vendor(s) on SQL data migration.  Work with the client and/or third-party vendor to verify functionality.  Important Note: Third-party vendor involvement required during this phase of the project. Southwest Michigan Building Authority, Proposal # KZ010856 Version 2, 07/07/2022 Page: 2 of 7 2022-07-28 SMBA Board Packet | Page 33 of 38 6395 TechnologyAvenue Kalamazoo, MI 49009 (269) 375-8996 Remote Desktop Servers Migration (AFTER HOURS):  Migrate user profiles and connections from old RDS Server to new.  Work with the client to verify functionality. Follow-up and Documentation:  Help to resolve open project related issues.  Document the project.  Decommission the old Cloud Server services once migrations have been completed.  Adjust Cloud Services contracts based on the quote.  Review the project with the client. Technical / Project Approach Experienced Aunalytics staff will be utilized for this initiative including; Project Manager and Supporting Engineers. Oversight for technical quality and functionality of all configured service features will be provided by Operations Management. All assigned staff have requisite experience to support the project Scope. All equipment configuration changes and replacements will require a maintenance window. These will be scheduled with the Client at their convenience. Aunalytics utilizes Autotask software for project management. The Client will be provided an account and portal for this software. If the scope warrants a Project Manager, the project phases and tasks will be built using this software. The Client will have the capability to view the project and its status. Regular project management meetings will be held to track the progress of the project. The frequency of these meetings can be adjusted per the Client’s request. Timeline for Execution The timeline for this installation will be coordinated between the Aunalytics Delivery Team and the Client. Client Responsibilities & Assumptions  Communicate changes with Client staff.  Coordination of maintenance windows with Aunalytics staff.  Client to provide access to the facility as well as systems being worked on during scheduled project hours.  Backups will be current before any technical tasks can be started.  Client to expect approximately 8-10 hours of server downtime during this project.  Client to verify any Line of Business application functionality prior to as well as after project implementation, which is ultimately part of the larger Project Test Plan.  Administrative usernames and passwords for existing equipment will be available.  Aunalytics by default will enable remote access capabilities to a client environment from the Aunalytics environment. This remote access is enabled for the sole purpose of providing remote support capabilities. Southwest Michigan Building Authority, Proposal # KZ010856 Version 2, 07/07/2022 Page: 3 of 7 2022-07-28 SMBA Board Packet | Page 34 of 38 6395 TechnologyAvenue Kalamazoo, MI 49009 (269) 375-8996 Change Management Procedures In the event it is necessary to change this SOW, the following terms will apply. A change request document (“Change Request”) will be executed by the parties, describing the nature of the (material) change, the reason for such change, and the effect such change will have on the scope of work, which may include changes to the deliverables, project personnel, or Services. Either party for any material changes to the SOW may initiate a Change Request. The requesting party will review the proposed change with the other party, and the appropriate authorized representatives of the parties will sign the Change Request, indicating the acceptance of the changes by the parties. Upon execution of the Change Request, said Change Request will be incorporated into and made part of the SOW. Whenever there is a conflict between the terms and conditions set forth in a Change Request and those set forth in the SOW or previous Change Request, the terms and conditions of the most recent Change Request shall prevail. Payment Terms 50% of Professional Services will be billed upon execution of this agreement with Net 30 payment terms. The remaining 50% will be billed upon project completion. Southwest Michigan Building Authority, Proposal # KZ010856 Version 2, 07/07/2022 Page: 4 of 7 2022-07-28 SMBA Board Packet | Page 35 of 38 6395 TechnologyAvenue Kalamazoo, MI 49009 (269) 375-8996 Recurring Services Description Recurring Qty Ext. Recurring NOTE: Additional Cloud Services resources have been added as part of the Windows Server upgrades. NOTE: Once the old servers are no longer needed, the associated Cloud Services resources and Managed Services will be removed from contracts and billing. vCPU $13.00 6 $78.00 GB RAM $6.00 32 $192.00 Performance Storage (1000 iops) – per TB $130.00 2 $260.00 Cloud Backup: Veeam Backup & Replication Enterprise Plus License $12.00 2 $24.00 Backup SAN Storage (per TB) $100.00 1 $100.00 SPLA: Windows Server (per vCPU) $7.00 6 $42.00 SPLA: SQL Standard User SAL (per User) $20.00 6 $120.00 SPLA: Windows Remote Desktop Services SAL (per User) $8.00 7 $56.00 Managed Service: Server (Windows Virtual) $75.00 2 $150.00 SSL Certificates $15.00 1 $15.00 File Level Archive: Aunalytics Storage 365 Server License $25.00 1 $25.00 File Level Archive: Aunalytics Storage 365 (per TB) $60.00 1 $60.00 File Level Archive: Aunalytics Storage Annual Archive $50.00 1 $50.00 Monthly Subtotal: $1,172.00 Aunalytics Professional Services Description Price Qty Ext. Price Professional Services (Fixed Fee) $13,492.50 1 $13,492.50 Subtotal: $13,492.50 Southwest Michigan Building Authority, Proposal # KZ010856 Version 2, 07/07/2022 Page: 5 of 7 2022-07-28 SMBA Board Packet | Page 36 of 38 6395 TechnologyAvenue Kalamazoo, MI 49009 (269) 375-8996 Cloud Services (Windows 2012 Server Upgrades) Prepared by: Prepared for: Proposal Details: Aunalytics – Kalamazoo Southwest Michigan Building Authority Proposal #: KZ010856 Jeff Ray 269.488.8081 jeff.ray@aunalytics.com 7275 West Main St Kalamazoo, MI 49009 Kyle Gibson (269) 585-4154 kgibson@swmiba.org Version: 2 Delivery Date: 07/07/2022 Expiration Date: 07/31/2022 Quote Summary Amount Aunalytics Professional Services $13,492.50 Total: $13,492.50 Monthly Expenses Summary Amount Recurring Services $1,172.00 Monthly Total: $1,172.00 Term: Co-terms with contract on file. The Statement of Work (“SOW”) will become effective upon CLIENT acceptance as indicated by signature and date of acceptance (“Effective Date”) on the last page of this Proposal, by and between AUNALYTICS, Inc. (“AU”), a Delaware corporation, with a corporate business address at 460 Stull Street, Suite 100, South Bend, Indiana 46601 and the CLIENT identified on the cover page and signature block of this SOW and is made pursuant to the terms and conditions of the Master Service Agreement (“MSA”) entered into between AU and CLIENT on file (the “Agreement”). Where no executed MSA (or T&C) exists on file for this CLIENT, Aunalytics current MSA (https://www.aunalytics.com/msa/) will apply. Capitalized terms used herein but not otherwise defined herein have the meanings ascribed to such terms in the Agreement. If the terms and/or conditions of this SOW conflict with the terms and/or conditions of the Agreement and/or with any other SOW, the terms and/or conditions of this SOW will control (unless otherwise expressly provided herein or in the Agreement) solely with respect to the Services and/or Hardware provided under this SOW. In the event of a conflict between the terms and conditions set forth herein and the terms and conditions set forth in an Exhibit attached hereto, the terms and conditions of such Exhibit shall control. Where recurring services are initiated through acceptance of this proposal, the term for those services will begin day 1 of the month and year in which the service is live and made available for client use and extend through to the term of service herein in accordance with the timeline set forth therein. Southwest Michigan Building Authority, Proposal # KZ010856 Version 2, 07/07/2022 Page: 6 of 7 2022-07-28 SMBA Board Packet | Page 37 of 38 6395 TechnologyAvenue Kalamazoo, MI 49009 (269) 375-8996 Aunalytics – Kalamazoo Southwest Michigan Building Authority Signature: Name: Jeff Ray Title: Account Executive, Cloud & Managed Services Date: 07/07/2022 Signature: Name: Kyle Gibson Date: Southwest Michigan Building Authority, Proposal # KZ010856 Version 2, 07/07/2022 Page: 7 of 7 2022-07-28 SMBA Board Packet | Page 38 of 38