The URL can be used to link to this page

Home My WebLink About2021.10.19_OPWA AgendaPUBLIC NOTICE OF THE MEETING OF THE OWASSO PUBLIC WORKS AUTHORITY (OPWA) Council Chambers Old Central Building 109 North Birch, Owasso, OK Tuesday, October 19, 2021 - 6:30 PM NOTE: APPROPRIATE ACTION may include, but is not limited to: acknowledging, affirming, amending, approving, authorizing, awarding, denying, postponing, or fabling. AGENDA RECEIVED 1. Call to Order OCT 15 2021 Chair Bill Bush 2. Roll Call City Clerk's Office 3. Consideration and appropriate action relating to a request for approval of the Consent Agenda. (All matters listed under "Consent" are considered by the Trustees to be routine and will be enacted by one motion. Any Trustee may, however, remove an item from the Consent Agenda by request. A motion to adopt the Consent Agenda is non - debatable.) A. Approve minutes -October 5, 2021, and October 12, 2021, Regular Meetings B. Approve claims 4. Consideration and appropriate action relating to items removed from the Consent Agenda 5. Consideration and appropriate action relating to a Fiscal Year 2021 -2022 budget amendment for the re- appropriation of carryover funds from Fiscal Year 2020 -2021 Jennifer Newman Staff recommends approval of a budget amendment, increasing the estimate of revenues by $30,295,392.00 and the appropriation for expenditures by $33,938,026.00. 6. Consideration and appropriate action relating to a sole source purchase of automated water meter data collection equipment and data management software Travis Blundell Staff recommends approval for the sole source purchase of four Neptune Gateway V4 Cellular Data Collectors and the Neptune 360 Advanced AMI Software, in the amount of $108,550.00, from Core & Main of Owasso, Oklahoma. 7. Report from OPWA Manager B. Report from OPWA Attorney 9. Official Notices (documents for acknowledgment or information only, no discussion or action will be taken) • Payroll Payment Report - Pay Period Ending Date October 9, 2021 • Monthly Budget Status Report -September 2021 10. New Business (New Business is any item of business which could not have been foreseen at the time of posting of the agenda) OPWA October 19, 2021 Page 2 11. Adjournment Notice of Public Meeting filed in the office of the City Clerk on Friday, December 11, 2020, and the Agenda posted at City Hall, 200 South Main Street, at 2:00 pm on Friday, October 15, 2021. M. Stevens, City Clerk The City of Owasso encourages citizen participation. To request on accommodation due to a disability, contact the City Clerk at least 48 hours prior to the scheduled meeting by phone 918- 376 -1502 or by email to istevens@citvofowosso.com OWASSO PUBLIC WORKS AUTHORITY (OPWA) MINUTES OF REGULAR MEETING Tuesday, October 5, 2021 The Owasso Public Works Authority (OPWA) met in regular session on Tuesday, October 5, 2021, in the Council Chambers at Old Central, 109 North Birch, Owasso, Oklahoma per the Notice of Public Meeting filed Friday, December 11, 2020; and the Agenda filed in the office of the City Clerk and posted at City Hall, 200 South Main Street, at 1:00 pm on Friday, October 1, 2021, and the Addendum filed and posted on Monday, October 4, 2021, at 1:30 pm. 1. Call to Order Chair Bill Bush called the meeting to order at 8:28 pm. 2. Roil Call Present Absent Chair - Bill Bush None Vice Chair- Kelly Lewis Trustee - Alvin Fruga Trustee - Doug Bonebrake Trustee - Lyndell Dunn A quorum was declared present. Staff: Authority Manager- Warren Lehr Authority Attorney - Julie Lombardi 3. Consideration and appropriate action relating to a request for approval of the Consent Agenda. (All matters listed under "Consent' are considered by the Authority to be routine and will be enacted by one motion. Any Trustee may, however, remove an item from the Consent Agenda by request. A motion to adopt the Consent Agenda is non - debatable.) A. Approve minutes -September 21, 2021, Regular Meeting B. Approve claims Mr. Fruga moved, seconded by Mr. Dunn to approve the Consent Agenda, as presented with claims totaling $938,789.94. YEA: Bonebrake, Dunn, Fruga, Lewis, Bush NAY: None Motion carried: 5 -0 4. Consideration and appropriate action relating to items removed from the Consent Agenda None 5. Report from OPWA Manager None 6. Report from OPWA Attorney None 7. Official Notices (documents for acknowledgment or information only, no discussion or action will be taken) The Chair acknowledged receipt of the following: • Payroll Payment Report -Pay Period Ending Date September 25, 2021 8. New Business (New Business is any item of business which could not have been foreseen at the time of posting of the agenda) None Owasso Public Works Authority October 5, 2021 Page 2 9. Adjournment Mr. Dunn moved, seconded by Ms. Lewis to adjourn the meeting. YEA: Bonebrake, Dunn, Fruga, Lewis, Bush NAY: None Motion carried: 5 -0 and the meeting adjourned at 8:29 pm. Bill Bush, Chair Juliann M. Stevens, Authority Clerk OWASSO CITY COUNCIL, OWASSO PUBLIC WORKS AUTHORITY (OPWA), AND OWASSO PUBLIC GOLF AUTHORITY (OPGA) MINUTES OF JOINT REGULAR MEETING Tuesday, October 12, 2021 The Owasso City Council, Owasso Public Works Authority (OPWA), and Owasso Public Golf Authority (OPGA) met in a joint regular meeting on Tuesday, October 12, 2021, in the Council Chambers at Old Central, 109 North Birch Street, Owasso, Oklahoma, per the Notice of Public Meeting filed Friday, December 11, 2020; and the Agenda filed in the office of the City Clerk and posted at City Hall, 200 South Main Street, at 12:00 pm on Friday, October 8, 2021, 1. Call to Order /Roll Call Mayor /Chair Bill Bush called the meeting to order at 6:00 pm. Present Mayor /Chair - Bill Bush Councilor /Trustee -Alvin Fruga Councilor /Trustee - Doug Bonebrake Councilor /Trustee - Lyndell Dunn A quorum was declared present. Absent Vice Mayor /Vice Chair- Kelly Lewis 2. Discussion relating to Finance Department Items A. Proposed FY 2020 -2021 Carryover Funds - General Fund, OPWA Fund, OPGA Fund B. Proposed Budget Amendment - American Rescue Plan Act, COVID -19 Funds Jennifer Newman presented item A, and discussion was held. It was further explained that an item will be placed on the October 19, 2021, City Council, OPWA, and OPGA agendas for consideration and action. Linda Jones -Holt presented item B, and discussion was held. It was further explained that this item will be placed on the October 19, 2021, City Council agenda for consideration and action. 3. Discussion relating to Community Development Items A. Request for an amendment to the Lissou Landing Plat and Deeds of Dedication, at 11610 North 1371h East Avenue, to clarify language related to water service utility maintenance B. Request for a Specific Use Permit (SUP 21 -05) - 1.49 acres located at 9155 North Owasso Expressway (Caliber Collision) C. Request for a final plat - Owasso Assisted Living Center, approximately 7.6 acres located at the northwest intersection of East 1 16th Street North and North 1261h East Avenue Karl Fritschen presented items A, B, and C, and discussion was held. It was further explained these items will be placed on the October 19, 2021, City Council agenda for consideration and action. 4. Discussion relating to the proposed purchase of Data Collectors and Data Management Software for automated water meter readings Travis Blundell presented the item, and discussion was held. It was further explained this item will be placed on the October 19, 2021, OPWA agenda for consideration and action. 5. Discussion relating to City /Authority Manager items A. 2022 City Council Election for Ward 5 B. Monthly sales tax report C. City Manager report Warren Lehr presented item A, and discussion was held. It was further explained this item will be placed on the October 19, 2021, City Council agenda for consideration and action. Linda Jones -Holt presented item B, and discussion was held. Under item C, Mr. Lehr reported on the Annual Harvest Festival held at Redbud Festival Park. 6. City Councilor /Trustee comments and inquiries Mr. Dunn commented on the Harvest Festival. Owasso City Council, OPWA & OPGA October 12, 2021 Page 2 7. Adjournment The meeting adjourned at 6:55 pm. Bill Bush, Mayor /Chair Juliann M. Stevens, City Clerk Claims List - 10/1912021 Fund Vendor Name Payable Description Payment Amount 61 OPWA MSS CONSTRUCTION LLC CONSTRUCTION SVCS - CFFFE $263,682.28 COFFEE CREEK LIFT STATION -Total $27,169.64 $263,682.28 AMERICAN MUNICIPAL SERVICES LTD COLLECTION SERVICES $85.95 OPWA -Total $46.66 $85.95 AEP IPSO ELECTRIC USE $1,650.88 CITY OF OWASSO ADMIN OVERHEAD $25,000.00 JPMORGAN CHASE BANK BEST BUY- EQUIPMENT $99.98 JPMORGAN CHASE BANK CAMFIL- FILTERS $63.52 JPMORGAN CHASE BANK MURPHY - SUPPLIES $148.36 JPMORGAN CHASE BANK OFFICE DEPOT - SUPPLIES $28.94 JPMORGAN CHASE BANK PIKEPASS -FEES $3.30 OFFICE DEPOT INC OFFICE SUPPLY ORDE $9.80 ONEOK INC OKLAHOMA NATURAL GAS NATURAL GAS USAGE $101.90 UNIFIRST HOLDINGS LP UNIFORM SERVICES $62.96 OPWA ADMINISTRATION -Total $27,169.64 AEP IPSO ELECTRIC USE $175.26 JPMORGAN CHASE BANK SEMI TRUCK -WASH $104.00 UNIFIRST HOLDINGS LP UNIFORM SERVICES $46.66 RECYCLE CENTER -Total $325.92 JPMORGAN CHASE BANK ABERDEEN DYN -TUBES $269.84 JPMORGAN CHASE BANK BUMP2BUMP- FILTERS $137.08 JPMORGAN CHASE BANK BUMP2BUMP -PAINT $5.99 JPMORGAN CHASE BANK BUMP2BUMP- SUPPLIES $231.51 JPMORGAN CHASE BANK COVANTA -WASTE FEE $15,708.75 JPMORGAN CHASE BANK INLAND TRUCK -PARTS $637.18 JPMORGAN CHASE BANK KIMS INTL -HOSES $106.24 JPMORGAN CHASE BANK KIMS INTL -PARTS $496.28 JPMORGAN CHASE BANK LOWES - GREASE GUN $227.96 JPMORGAN CHASE BANK SAMS- SUPPLIES $27.98 JPMORGAN CHASE BANK UNITED ENGINES- FLUID! $816.63 JPMORGAN CHASE BANK UNITED ENGINES -PARTS $114.37 JPMORGAN CHASE BANK UNITED ENGINES- SUPPLI $365.04 JPMORGAN CHASE BANK UNITED ENGINES -TOOLS $2,003.20 JPMORGAN CHASE BANK WELDON -PARTS $61.04 UNIFIRST HOLDINGS LP UNIFORM SERVICES $144.36 VERIZON WIRELESS WIRELESS CONNECTION $156.40 REFUSE COLLECTIONS -Total $21,709.85 JPMORGAN CHASE BANK AMAZON- SUPPLIES $15.73 JPMORGAN CHASE BANK OFFICE DEPOT - SUPPLIES $19.90 JPMORGAN CHASE BANK SAMS -FACE MASKS $4.32 0 Claims List - 10/19/2021 Fund Vendor Name Payable Description Payment Amount 61 OPWA TECHNICAL PROGRAMMING SERVICES BILLING SERVICES $1,207.78 INC AMERIFLEX -PARTS $70.00 UTILITY BILLING -Total GRAINGER - BOTTLES $1,247.73 AEP(PSO ELECTRIC USE $6,100.02 JPMORGAN CHASE BANK ATWOODS - STRAPS $28.99 JPMORGAN CHASE BANK CORE &MAIN -PARTS $111.17 JPMORGAN CHASE BANK DP SUPPLY -PARTS $96.00 ONEOK INC OKLAHOMA NATURAL GAS NATURAL GAS USAGE $229.32 UNIFIRST HOLDINGS LP UNIFORM SERVICES $123.12 VERDIGRIS VALLEY ELECTRIC COOP COFFEE CREEK ELECTRIC $602.08 VERDIGRIS VALLEY ELECTRIC COOP GARRETT CREEK ELECTRI $179.33 VERIZON WIRELESS WIRELESS CONNECTION $80.02 WASTEWATER COLLECTIONS -Total $7,550.05 AEPIPSO ELECTRIC USE $31,241.66 JPMORGAN CHASE BANK AMERIFLEX -PARTS $70.00 JPMORGAN CHASE BANK GRAINGER - BOTTLES $357.34 JPMORGAN CHASE BANK GRAINGER- GREASE $138.40 JPMORGAN CHASE BANK GRAINGER- MATERIAL $45.65 JPMORGAN CHASE BANK GRAINGER- REAGENT $96.40 JPMORGAN CHASE BANK GRAINGER- RULERS $14.37 JPMORGAN CHASE BANK GRAINGER -TOOLS $117.29 JPMORGAN CHASE BANK HOME DEPOT- SUPPLIES $16.96 JPMORGAN CHASE BANK NCL OF WISC- BOTTLES $30.95 JPMORGAN CHASE BANK UV DOCTOR -PARTS $137.24 JPMORGAN CHASE BANK WASTE MGMT- SLUDGE REM $7,422.71 SCHUERMANN ENTERPRISES, INC TROUBLESHOOT MAIN LS PLC $916.70 SCHUERMANN ENTERPRISES, INC TROUBLESHOOT RAS & VFD AT $3,462.65 UNIFIRST HOLDINGS LP UNIFORM SERVICES $108.84 VERIZON WIRELESS WIRELESS CONNECTION $80.02 WASTEWATER TREATMENT -Total $44,257.18 AEP IPSO ELECTRIC USE $259.93 CITY OF TULSA UTILITIES WATER $387,867.75 JPMORGAN CHASE BANK LOWES -PARTS $9.56 JPMORGAN CHASE BANK LOWES- REFUND ($14.48) JPMORGAN CHASE BANK MEETING EXPENSE $26.21 JPMORGAN CHASE BANK TWIN CITIES- CONCRETE $440.00 UNIFIRST HOLDINGS LP UNIFORM SERVICES $147.02 VERDIGRIS VALLEY ELECTRIC COOP WATER CONTROL ELECTRI $30.60 WATER -Total $388,766.59 CROSSLAND HEAVY CONTRACTORS WWTP UPGRADE -LS $1,111,805.45 EXPANSION 2 Fund 61 OPWA Claims List - 10/19/2021 Vendor Name Payable Description Payment Amount GREELEY & HANSEN LLC LBX 619776 INSPECTION SERVICES $27,630.37 WWTP UPGRADE -Total $1,139,435.82 OPWA -Total $1,894,231.01 OPWA Grand Total $1,894,231.01 o _ S TO: The Honorable Chair and Trustees Owasso Public Works Authority (OPWA) FROM: Jennifer Newman, Assistant Finance Director SUBJECT: Supplemental Appropriation Carryover Budget DATE: October 15, 2021 BACKGROUND: Every year, at the June 30th fiscal year end, there are unspent budgets. While appropriations were included in the FY 2021 Budget, the actual expenditure for all or part of open items will occur during FY 2022. Because the FY 2022 budget was prepared prior to year -end, and before it was known whether funds would be expended or not, the fund balance used to develop the OPWA Budget was projected as though all non -salary budgets would be expended by year -end. Therefore, approval of carryover non -salary budgets does not reduce the estimated June 30, 2021, fund balance. In order to keep from having purchase orders open for multiple years, past practice of the Authority is to close prior year purchase orders at the end of September, and re- appropriate the funds in the subsequent year, along with authorizing the Authority to re -issue the purchase orders in the new fiscal year. Since Generally Accepted Accounting Principles (GAAP) do not recognize encumbrances, closing out old encumbrances where goods and services have not been received, will enable the Authority's budgetary financial statements to more closely align with audited GAAP statements, OPWA Department FY 2022 Expenditure Budget Expenditure Carryover Requested Revised FY 2022 Expenditure Budget Revenue Carryover OPWA Debt Proceeds $ 2,142,000 $ 2,142,000 $23,621,072 OPWA Administration 2,161,292 2,161,292 - Utility Billing 493,126 2,328 495,454 Water 4,558,917 41,644 4,600,561 Wastewater Treatment 1,406,542 20,574,733 21,981,275 Wastewater Collect ions 7,784,583 6,339,169 14,123,752 - Refuse 1,262,038 85,949 1,347,987 - Recycle 712,186 39,095 751,281 - Redbud TIF 588,363 180,789 769,152 - Debt Services Exp 8,204,765 - 8,204,765 - Transfers to Vision Recapture Debt Proceeds 21100,000 2,100,000 - Transfers Out Sales Tax 4,086,647 - 4,086,647 Transfer to CIP Debt Proceeds - 1 6,674,320 6,674,320 6,674,320 Total Carryover Requested $ 35,500,459 1 $ 33,938,026 $ 69,438,485 $30,295,392 Page 2 Carryover Budget RECOMMENDATION: Staff recommends approval of a budget amendment in the OPWA Fund, increasing the estimate of revenues by $30,295,392.00 and the appropriation for expenditures by $33,938,026.00. TO: The Honorable Chair and Trustees Owasso Public Works Authority (OPWA) FROM: Travis Blundell Assistant Public Works Director SUBJECT: Procurement and Installation of Water Meter Reading Equipment DATE: October 15, 2021 BACKGROUND: On July 15, 2014, the OPWA approved the Water Meter Replacement Program, following an assessment of the commercial and residential water meters. The assessment had revealed the water meters were nearing the recommended age of replacement, the water meter reading equipment was becoming obsolete and could not be repaired due to age, and the accounting software utilized by Utility Billing was not compatible with the water meter software. Phase I of the Program included replacing the existing manual read meters with new Neptune Automated Meter Read (AMR) meters over a five -year period. Phase I was completed in September of 2020. The AMR meters have reduced Utility Billing work orders by as much as 55 %. The new meters are currently read by a mobile system unit from a vehicle, thereby eliminating manual meter reads and inaccuracies due to human error. The AMR meters also provide staff with the ability to run reports on water usage when a customer believes there to be a discrepancy in their bill. PROPOSED WATER METER READING EQUIPMENT AND SOFTWARE: The proposed water meter reading equipment includes four Gateway Data Collectors and access to the Neptune 360 Data Software. The Data Collectors function is to receive data from the water meters and then transmit the data to the Neptune 360 software, a web -based system. Neptune 360 "Software as a Service" Program is a data management solution providing a complete view of water metering data and analytics with an annual subscription and maintenance fee of $23,500. The subscription includes the following services: • Neptune 360 Web App • Neptune Mobile App • Neptune 360 Sync (required for Trimble Handheld compatibility) • 24x7 application and security monitoring • Database preventative maintenance and scalability monitoring • Software upgrades and updates, with prior notice via email • Providing all server operating system and hardware update requirements • Data back -up and replication for approximately 11,724 water meters • Data security and Business Continuity Plan Processes Provides telephone or email support Data Collector Page 2 The Neptune 360 data platform will provide staff with tools to improve customer service and labor efficiency by providing the following benefits: • Improve customer service by allowing Utility Billing personnel access to real time data for setting up new accounts and when discussing water usage concerns with customers; • Reassign approximately 100 hours of labor, eliminating the need to drive each meter route to collect water usage and eliminating approximately 150 work orders per month for meter read on / read offs; • Reduce overtime cost by approximately $5,200 per year; • Monitor the water distribution system in greater detail with the ability to run water consumption reports for any individual account during any given time frame. SOLE SOURCE PURCHASING: The Code of Ordinances for the City of Owasso does not require competitive bidding if the supplies, materials, equipment, or contractual services can only be furnished by a single vendor, or which have a uniform price wherever bought. This provision within City Ordinance is commonly referred to as "sole source" purchasing. The proposed Neptune automated meter reading equipment is a proprietary system and is the only system compatible with our existing Neptune automated water meters. Core & Main of Owasso, Oklahoma, is the sole distributor for Neptune products in the region. FUNDING: Funding is included in the FY 2022 Water Division Budget. RECOMMENDATION: Staff recommends Trustee approval for the sole source purchase of four Neptune Gateway V4 Cellular Data Collectors and the Neptune 360 Advanced AMI Software, in the amount of $108,550.00, from Core & Main of Owasso, Oklahoma. ATTACHMENT: Core & Main Quote Run Date: 10/05/21 ia (" iEIE Sold To: CITY OF OWASSO PO BOX 180 OWASSO, OK 74055 0160 Bid Seq# Product Code Description Quote Ship To: CITY OF OWASSO 111 N MAIN OWASSO, OK 74055 Customer # 197245 Order # P329257 Date Ordered 07/28/21 Job # AMR Job Name AMR Purchase Order # Method of Shipment OUR TRUCK Contract Order # P329254 Ordered By RON Ship Via CORE & MAIN LP Qty Qty Ordered Shipped Qt Branch: OWASSO OK BRANCH 343 14701 E 116th ST N OWASSO, OK 74055 Phone: 918 -586 -7100 Net Price UOM Ext Price 42NEP13458000 NEPTUNE 13458 -000 GATEWAY V4 4 9950.00000 EA CELLULAR (CDMA /GPRS) 42NE13070100 13070 -100 OUTDOOR UPS SYSTEM 4 N/C EA /45016640490 NEP 360 ADVANCED AMI SOFTWARE 1 23500.00000 EA /45016640491 NEP 360 ADVANCED SET -UP FEE 1 3250.00000 EA /45016715957 GATEWAY INSTALL 4 10500.00000 EA Special Instructions /Comments: BID # 1645366 C/O # P329254 BID NM: OWASSO 2021 AMI METER PROJECT 1 Total Ordered: 108550.00 Tax Amount: .00 Other Charges: .00 Total: 108550.00 39800.00 23500.00 3250.00 42000.00 OWASSO PUBLIC WORKS AUTHORITY PAYROLL PAYMENT REPORT PAY PERIOD ENDING DATE 10/09121 Department Payroll Expenses Total Expenses 400 OPWA Administration 16,404.32 24,723.25 405 Utility Billing 7,018.40 12,335.80 420 Water 16,478.26 27,610.98 450 Wastewater 12,620.75 22,721.97 455 Wastewater Collection 14,301.91 26,779.50 480 Refuse 14,188.95 25,050.31 485 Recycle Center 1,283.12 2,286.26 FUND TOTAL 82,295.71 141,508.07 CITY OF OWASSO OWASSO PUBLIC WORKS AUTHORITY FISCAL YEAR 2021 -2022 Budgetary Basis Statement of Revenues & Expenses As of September 30, 2021 OPERATING REVENUES: Water Wastewater Refuse & recycle Other Utility fees TOTAL OPERATING REVENUES OPERATING EXPENSES: OPWA administration Utility Billing Water Wastewater Refuse & Recycle Debt payments TOTAL OPERATING EXPENSES OPERATING FUND OPERATING REVENUES OVER /(UNDER) EXPENDITURES NONOPERATING REVENUES (EXPENSES): Interest Other revenues /(expenses) TIF revenues /(expenses) Transfers in Transfers out TOTAL NONOPERATING REVENUES (EXPENSES) LONG -TERM DEBT PROCEEDS AND EXPENDITURES: Proceeds of long -term debt Expenditures of long -term debt TOTAL LONG -TERM DEBT PROCEEDS AND EXPENDITURES NET INCOME (LOSS) ENCUMBRANCES OUTSTANDING BOND PROCEEDS RECEIVABLE FUND BALANCE (Budgetary Basis) Beginning Balance Ending Balance $ (1,045,254) $ (2,922,951) $ (23,600,884) 12.38% $ MONTH $ YEAR $ (8,041,176) PERCENT TO -DATE TO -DATE BUDGET OF BUDGET $ 874,175 $ 2,277,502 $ 7,341,475 31.02% 50,912 491,318 58,022 1,408,856 24,838 5,387,234 26.15% 19,351 225,557 83,241 682,696 (205,852) 2,550,340 26.77% - 16,812 - 51,608 3,042,000 280,659 18.39 %, $ 1,607,862 $ 4,420,662 $ 15,559,708 28.41% $ (80,504) $ (386,850) $ (2,161,292) 17.907. (39,732) (113,379) (493,126) 22.99% $ (463,204) $ (1,016,207) (4,558,917) 22.29% (173,781) (494,981) (9,191,125) 5.39% $ (84,765) $ (278,653) (1,974,224) 14.11% $ (203,268) $ (632,881) (5,222,200) 12.127. $ (1,045,254) $ (2,922,951) $ (23,600,884) 12.38% $ 562,608 $ 1,497,711 $ (8,041,176) $ 2,260 $ 6,869 $ 27,670 24.83% 50,912 58,022 24,838 233.607. 19,351 83,241 (205,852) - 40.44% - - 3,042,000 0.00% - - - #DIV /01 $ 72,523 $ 148,132 $ 2,888,656 $ 1,259,617 $ 3,789,632 $ 7,100,000 (2,669,457) (4,257,824) - $ (1,409,840) $ (468,192) $ 7,100,000 $ (774,709) $ 1,177,651 $ 1,947,480 $ (26,307,152) $ 23,226,469 5,378,682 5,378,682 $ 3,475,650 $ 7,326,162