Budget and Finance Committee Meeting

City of Prosser CITY COUNCIL BUDGET AND FINANCE COMMITTEE AGENDA Council Chambers, 1002 Dudley Avenue, Prosser WA 99350 Tuesday, August 9, 2022 @ 6:30 PM Page 1. CALL TO ORDER 2. ROLL CALL 3. MINUTES a. Approve July 26, 2022 Meeting Minutes 2-3 Budget and Finance Committee Meeting - 26 Jul 2022 - Minutes - Pdf 4. ACCOUNTS PAYABLE a. Discuss Claim Checks For the Period Ending August 9, 2022 4 - 41 Check Register 8.9.22 US Bank CC July 2022 5. PAYROLL a. Discuss Payroll Checks For the Period Ending July 31, 2022 42 - 50 Payroll July 2022 VBO July 2022 6. OTHER ITEMS 7. NEXT MEETINGS a. August 23, 2022 8. ADJOURNMENT Page 1 of 50  CITY OF PROSSER WASHINGTON 1002 DUDLEY AVENUE CITY COUNCIL CHAMBERS BUDGET AND FINANCE COMMITTEE MEETING TUESDAY, JULY 26, 2022 Call to Order Council Member Becken called the meeting of the City of Prosser Budget and Finance Committee to order at 6:30 p.m. Roll Call Council Member Everett, Council Member Groom, Finance Director Yost, and City Administrator Glover were present. Minutes A motion was made by Council Member Everett, seconded by Council Member Groom to approve the July 12, 2022 meeting minutes. Motion carried unanimously. Accounts Payable The Committee reviewed and discussed the claim checks prepared for City Council approval. Questions included: -Planning certification and training for Tom Glover - Insurance Claim - Housing Action Plan - Locking Tool Boxes for Public Works Crews - Recording Equipment for Council Chambers - Well 5 Repairs - SEEK Grant and Scholarships Program Payroll The Committee reviewed and discussed the payroll checks for July, 2022 mid month advances. Other Items Finance Director Yost provided information on the following items: HDP Reimbursement: At a prior meeting this committee reviewed the reimbursement request for HDP and requested some additional information. Since that meeting the additional information was provided and HDP updated their reimbursement request to include a future reimbursement request for repairs to the Visitor Center restrooms. Council Members reviewed the information and approved the items for payment and also approved the restroom repairs project. Non Union Wage Study: Finance Director Yost reviewed with Council Members the process used to prepare the wages for non-union staff members. Typically, the year following union negotiations a review is prepared for non-union staff. In this review staff compare the average wage of similar positions in similar sized agencies. To determine which agencies to review, the Finance Director uses the AWC Salary Survey to find communities who are within 60% of the City's population, sales tax receipts, and assessed value. Then this average is compared to the current wage schedule. Council has previous established that non-union wages Page 1 of 2 Page 2 of 50 should be within 5% (+ or -) of the average. Council Members approved of these parameters and Finance Director Yost will bring the results to the next meeting for review. Garbage Fund: Finance Director Yost reported to the committee members regarding the current position of the Garbage Fund. Some years ago Council made the decision to offset utility rates to and operate the fund in a deficit in order to reduce a large fund balance. At this point the fund balance is very low and corrective action is necessary because, based on the projections and current activity, the fund will not have enough cash to make it through the year. Additionally, BDI notified the City that due to the increase in fuel prices that they would be implementing a rate increase effective immediately pursuant to the terms of the agreement. Staff will be preparing proposed rate changes and customer impacts for Council to consider at the August 2nd Council Work Session. Adjournment There being no further business before the Committee at this time, the Budget and Finance Committee Meeting was adjourned at 6:41 p.m. Committee Chair Finance Director Page 2 of 2 Page 3 of 50 Page 4 of 50 Page 5 of 50 Page 6 of 50 Page 7 of 50 Page 8 of 50 Page 9 of 50 Page 10 of 50 Page 11 of 50 Page 12 of 50 Page 13 of 50 Page 14 of 50 Page 15 of 50 Page 16 of 50 Page 17 of 50 Page 18 of 50 Page 19 of 50 Page 20 of 50 Page 21 of 50 Page 22 of 50 Page 23 of 50 Page 24 of 50 Page 25 of 50 Page 26 of 50 Page 27 of 50 Page 28 of 50 Page 29 of 50 Page 30 of 50 Page 31 of 50 Page 32 of 50 Page 33 of 50 Page 34 of 50 Page 35 of 50 Page 36 of 50 Page 37 of 50 Page 38 of 50 Page 39 of 50 Page 40 of 50 Page 41 of 50  EARNING ITEM SUMMARY City Of Prosser Time 16:42:26 Date: 07/26/2022 07/29/2022 To: 07/29/2022 Page: 1 ADMIN Group Pay Item Date Hours Pay ADMIN Salary 07/29/2022 165.33 9,061.00 Cell Phone Allowa 60.21 Car Allowance 250.00 Holiday Used 8.00 TOTAL ADMIN 173.33 9,371.21 BUILDING Group Pay Item Date Hours Pay BUILDING Hourly 07/29/2022 128.50 3,752.20 Hourly 149.00 3,733.94 Draw -150.00 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 FIre Code Pay 500.00 Holiday Used 8.00 233.60 Holiday Used 8.00 200.48 Sick Used 1.00 25.06 Vac Used 23.50 686.20 Vac Used 2.00 50.12 TOTAL BUILDING 320.00 9,152.02 CLERK Group Pay Item Date Hours Pay CLERK Hourly 07/29/2022 127.60 3,101.96 Salary 145.33 7,518.64 Draw -2,098.00 Cell Phone Allowa 60.21 Holiday Used 6.40 155.58 Holiday Used 8.00 Vac Used 20.00 TOTAL CLERK 307.33 8,738.39 COUNCIL Group Pay Item Date Hours Pay COUNCIL Salary 07/29/2022 8.00 345.00 Salary 8.00 360.00 Salary 8.00 345.00 Salary 8.00 345.00 Salary 8.00 345.00 Salary 8.00 345.00 Salary 8.00 345.00 Salary 8.00 743.00 TOTAL COUNCIL 64.00 3,173.00 FINANCE Page 42 of 50  EARNING ITEM SUMMARY City Of Prosser Time 16:42:26 Date: 07/26/2022 07/29/2022 To: 07/29/2022 Page: 2 FINANCE Group Pay Item Date Hours Pay FINANCE Hourly 07/29/2022 130.00 3,160.30 Hourly 144.00 2,584.80 Hourly 136.00 2,607.12 Salary 164.33 7,118.28 Salary 133.33 9,309.15 Draw -1,000.00 Draw -1,190.00 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Holiday Used 8.00 194.48 Holiday Used 8.00 143.60 Holiday Used 8.00 153.36 Holiday Used 8.00 Holiday Used 8.00 Sick Used 1.00 Vac Used 22.00 534.82 Vac Used 8.00 143.60 Vac Used 16.00 306.72 Vac Used 32.00 TOTAL FINANCE 826.66 24,186.65 PLANNING Group Pay Item Date Hours Pay PLANNING Salary 07/29/2022 159.33 7,548.66 Cell Phone Allowa 60.21 Holiday Used 8.00 Sick Used 6.00 TOTAL PLANNING 173.33 7,608.87 POLICE Group Pay Item Date Hours Pay POLICE Hourly 07/29/2022 95.00 1,821.15 Hourly 132.00 3,623.40 Hourly 112.00 2,369.92 Hourly 14.75 442.50 Salary 149.33 7,703.24 Salary 149.33 6,594.53 Salary 173.33 5,699.41 Salary 150.33 10,435.94 Salary 149.33 7,703.24 Salary 171.33 6,917.55 Salary 184.89 7,034.17 Salary 173.33 5,430.38 Salary 101.33 6,917.55 Salary 137.33 6,917.55 Salary 173.33 6,917.55 Page 43 of 50  EARNING ITEM SUMMARY City Of Prosser Time 16:42:26 Date: 07/26/2022 07/29/2022 To: 07/29/2022 Page: 3 POLICE Group Pay Item Date Hours Pay Salary 173.33 5,430.38 Draw -1,000.00 Draw -1,840.00 Draw -2,000.00 Draw -2,156.27 Draw -1,805.00 Draw -2,156.00 Draw -1,500.00 Out of Class Pay 22.94 Overtime 37.00 2,466.42 Overtime 78.00 4,452.24 Overtime 53.00 3,532.98 Overtime 4.00 126.96 Overtime 11.00 658.57 Overtime 22.00 1,255.76 Overtime 22.00 1,317.14 Overtime 20.00 1,197.40 Overtime 43.00 2,574.41 Overtime Hol (.5) 8.00 177.76 Overtime Hol (.5) 6.00 114.18 Overtime Hol (.5) 8.00 131.52 Overtime Hol (.5) 6.00 133.32 Overtime Hol (.5) 8.00 152.24 Overtime Hol (.5) 8.00 125.36 Overtime Hol (.5) 8.00 159.68 Overtime Hol (.5) 8.00 159.68 Overtime Hol (.5) 8.00 125.36 Overtime Hol (1.5 4.00 266.64 Overtime Hol (1.5 2.00 98.64 Overtime Hol (1.5 4.00 228.32 Overtime Hol (1.5 2.00 94.00 Overtime Hol (1.5 4.00 239.48 Overtime Hol (1.5 4.00 239.48 Overtime Hol (1.5 4.00 188.00 Signing Bonus 10,000.00 Cell Phone Allowa 60.21 Evidence Pay 50.00 BiLingual Pay 50.00 BiLingual Pay 197.84 BiLingual Pay 50.00 Education Pay 50.00 Education Pay 154.06 Education Pay 207.53 FTO Pay 50.00 FTO Pay 50.00 Comp Used 12.00 Page 44 of 50  EARNING ITEM SUMMARY City Of Prosser Time 16:42:26 Date: 07/26/2022 07/29/2022 To: 07/29/2022 Page: 4 POLICE Group Pay Item Date Hours Pay Comp Used 2.00 Comp Earned 10.00 Hol F Used 8.00 219.60 Holiday Used 5.00 95.85 Holiday Used 8.00 Holiday Used 8.00 219.60 Holiday Used 8.00 169.28 Vac Used 24.00 Vac Used 24.00 Vac Used 15.00 Vac Used 12.00 Vac Used 12.00 329.40 Vac Used 40.00 846.40 Vac Used 72.00 Vac Used 36.00 TOTAL POLICE 2,918.27 112,539.44 PUBLIC WORKS Group Pay Item Date Hours Pay PUBLIC WORKS Hourly 07/29/2022 150.00 3,502.50 Hourly 130.00 4,108.00 Hourly 140.00 2,710.40 Hourly 146.00 3,416.40 Hourly 90.00 3,426.30 Hourly 149.00 4,553.44 Hourly 146.50 5,257.89 Hourly 40.00 620.00 Hourly 142.00 4,470.16 Hourly 150.00 3,727.50 Hourly 150.00 4,330.50 Hourly 128.50 4,060.60 Hourly 152.00 4,100.96 Hourly 170.00 2,635.00 Hourly 51.00 1,472.37 Hourly 138.00 4,360.80 Hourly 137.00 4,916.93 Hourly 126.50 3,997.40 Hourly 94.00 3,373.66 Hourly 142.00 3,315.70 Salary 125.33 8,567.13 Draw -600.00 Draw -700.00 Draw -800.00 Draw -1,500.00 Out of Class Pay 50.00 135.00 Out of Class Pay O 7.00 28.35 Page 45 of 50  EARNING ITEM SUMMARY City Of Prosser Time 16:42:26 Date: 07/26/2022 07/29/2022 To: 07/29/2022 Page: 5 PUBLIC WORKS Group Pay Item Date Hours Pay Overtime 5.00 175.15 Overtime 3.00 142.20 Overtime 3.00 105.30 Overtime 7.00 399.77 Overtime 9.00 412.56 Overtime 5.00 269.20 Overtime 8.50 401.37 Overtime 11.00 410.08 Overtime 4.00 173.24 Overtime 5.00 237.00 Overtime 26.00 1,052.22 Overtime 19.00 822.89 Overtime 6.00 284.40 Overtime 9.50 511.48 Overtime 8.00 379.20 Overtime 10.00 538.40 Shift Pay 160.00 Shift Pay 160.00 Shift Pay 30.00 Shift Pay 270.00 Shift Pay 270.00 Shift Pay 220.00 Shift Pay 250.00 Shift Pay 550.00 Shift Pay 350.00 Shift Pay 250.00 Shift Pay 250.00 Shift Pay 190.00 Shift Pay 250.00 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Page 46 of 50  EARNING ITEM SUMMARY City Of Prosser Time 16:42:26 Date: 07/26/2022 07/29/2022 To: 07/29/2022 Page: 6 PUBLIC WORKS Group Pay Item Date Hours Pay Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Bereavement 10.00 380.70 Bereavement 10.00 316.00 Bereavement 3.00 86.61 Bereavement 10.00 233.50 BiLingual Pay 50.00 Holiday Used 8.00 186.80 Holiday Used 8.00 252.80 Holiday Used 8.00 154.88 Holiday Used 8.00 187.20 Holiday Used 8.00 304.56 Holiday Used 8.00 244.48 Holiday Used 8.00 287.12 Holiday Used 8.00 251.84 Holiday Used 8.00 Holiday Used 8.00 198.80 Holiday Used 8.00 230.96 Holiday Used 8.00 252.80 Holiday Used 8.00 215.84 Holiday Used 8.00 230.96 Holiday Used 8.00 252.80 Holiday Used 8.00 287.12 Holiday Used 8.00 252.80 Holiday Used 8.00 287.12 Holiday Used 8.00 186.80 Sick Used 10.00 316.00 Sick Used 4.00 93.60 Sick Used 1.00 30.56 Sick Used 3.50 125.62 Sick Used 1.50 47.40 Sick Used 17.50 505.23 Sick Used 2.00 63.20 Sick Used 3.00 107.67 Vac Used 2.00 46.70 Vac Used 12.00 379.20 Vac Used 12.00 232.32 Vac Used 52.00 1,979.64 Vac Used 2.00 71.78 Vac Used 10.00 314.80 Vac Used 40.00 Vac Used 2.00 57.74 Vac Used 10.00 316.00 Vac Used 80.50 2,324.04 Vac Used 12.00 379.20 Vac Used 12.00 430.68 Page 47 of 50  EARNING ITEM SUMMARY City Of Prosser Time 16:42:26 Date: 07/26/2022 07/29/2022 To: 07/29/2022 Page: 7 PUBLIC WORKS Group Pay Item Date Hours Pay Vac Used 25.50 805.80 Vac Used 58.00 2,081.62 TOTAL PUBLIC WORKS 3,451.33 104,186.73 RECREATION Group Pay Item Date Hours Pay RECREATION Hourly 07/29/2022 126.00 1,839.60 Hourly 73.50 1,091.48 Hourly 97.75 1,451.59 Hourly 129.00 1,902.75 Hourly 110.25 1,653.75 Hourly 117.50 1,744.88 Hourly 84.50 1,246.38 Hourly 107.50 1,596.38 Hourly 85.00 1,253.75 Hourly 121.25 1,788.44 Hourly 90.00 1,327.50 Hourly 163.75 2,783.75 Hourly 79.25 1,149.13 Hourly 53.00 787.05 Hourly 20.00 400.00 Hourly 102.75 1,525.84 Hourly 95.75 1,412.31 Hourly 117.75 1,736.81 Hourly 19.50 287.63 Hourly 88.50 1,305.38 Hourly 129.00 1,967.25 Hourly 119.75 1,826.19 Hourly 113.75 1,689.19 Hourly 59.75 881.31 Hourly 80.50 1,195.43 Hourly 24.50 363.83 Hourly 127.25 1,876.94 Hourly 14.75 217.56 Hourly 114.75 1,692.56 Hourly 68.25 996.45 Hourly 136.25 2,043.75 Hourly 96.50 1,433.03 Hourly 95.75 1,412.31 Hourly 14.75 217.56 Hourly 52.25 757.63 Hourly 96.50 1,433.03 Hourly 23.25 342.94 Hourly 14.25 210.19 Hourly 96.75 1,427.06 Hourly 78.50 1,177.50 Page 48 of 50  EARNING ITEM SUMMARY City Of Prosser Time 16:42:26 Date: 07/26/2022 07/29/2022 To: 07/29/2022 Page: 8 RECREATION Group Pay Item Date Hours Pay Hourly 18.50 272.88 Hourly 96.25 1,419.69 Salary 165.33 5,924.36 Hourly Alt 43.25 653.08 Hourly Alt 44.25 674.81 Hourly Alt 2.25 33.98 Hourly Alt 7.50 113.25 Hourly Alt 6.00 103.50 Hourly Alt 32.00 480.00 Hourly Alt 49.25 763.38 Hourly Alt 10.00 150.00 Hourly Alt 45.75 690.83 Hourly Alt 10.00 151.00 Hourly Alt 16.00 240.00 Hourly Alt 30.00 457.50 Hourly Alt 16.25 243.75 Hourly Alt 1.00 15.00 Hourly Alt 22.50 337.50 Overtime 0.25 5.63 Overtime 7.25 184.88 Overtime 5.25 120.12 Overtime 3.50 78.75 Overtime Alt 1.25 29.06 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 Cell Phone Allowa 60.21 BiLingual Pay 25.00 Holiday Used 8.00 Sick Used 2.00 30.00 Sick Used 5.75 85.39 Sick Used 4.75 70.54 Sick Used 17.00 259.25 Sick Used 6.25 91.25 TOTAL RECREATION 4,116.83 65,331.12 TOTAL 12,351.08 344,287.43 Page 49 of 50  VACATION BUY OUT DETAIL City Of Prosser Time 4:44 p.m. Date: 07/26/2022 MCAG #: 0205 07/01/2022 To: 07/31/2022 Page: 1 TOTAL Page 50 of 50