{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["BUDGET 2023"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BUDGET 2023","index":0,"n_rows":115,"n_cols":19,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[null,"2020 ACTUAL ",null,"2021 BUDGET",null,"2021 ACTUAL ",null,"2022 BUDGET",null,"2022 ACTUAL",null,"2023 Proposed Budget"]
["INCOME"]
["360.00 · Drought Relief Grant",0,null,0,null,0,null,0,null,135000,null,0]
["324.10 · Frost Protection Income",4194,null,4194,null,3581.39,null,3581,null,2814,null,4500]
["345.00 · Income - Permits & Fees",55,null,0,null,0,null,1000,null,0,null,1000]
["306.00 · Interest Pool Account #5940",8254.17,null,8500,null,3860.83,null,4000,null,5450.3,null,7000]
["306.20 · Interest Pool Account #5941",3876.3,null,4000,null,1714.17,null,2000,null,1622.78,null,2000]
["301.00 · Joint Works & Assessments",32081.06,null,25000,null,23529.21,null,25000,null,15141.76,null,28000]
["300.10 · Labor & Materials",0,null,500,null,0,null,500,null,1215.42,null,500]
["300.20 · Lien Search",50680,null,40000,null,53975,null,50000,null,46310,null,55000]
["311.00 · Miscellaneous",6734.23,null,500,null,72890.460000000006,null,500,null,397,null,500]
["307.11 · SDAO Safety",0,null,0,null,0,null,0,null,0,null,5000]
["307.00 · SDIS Longevity Credit- SDAO",3297.5,null,3297,null,3297.5,null,3297,null,4886,null,5000]
["316.00 · Transfer Processing Fees",18305.25,null,6000,null,2964,null,6000,null,2660,null,8000]
["314.00 · Water Right Sales",0,null,10000,null,0,null,10000,null,0]
["306.41 · Water User Late Fees",10125,null,9000,null,9045.1,null,9000,null,9675,null,10000]
["306.40 · Water User Payment Interest",15531.92,null,10000,null,18986.330000000002,null,15000,null,17298.02,null,15500]
["328.00 · W.U. Liens Processing Fees",5400,null,3000,null,0,null,3000,null,0,null,5000,2,3,4]
["305.00 · Water User Revenue",1238415.25,null,1136668,null,1149302.1299999999,null,1145668,null,1149125.05,null,1145000,24310.5,36465.75,48621]
["TOTAL",{"$f":"SUM(B3:B19)","v":1396949.68},null,{"$f":"SUM(D3:D19)","v":1260659},null,{"$f":"SUM(F3:F19)","v":1343146.1199999999},null,{"$f":"SUM(H3:H19)","v":1278546},null,{"$f":"SUM(J3:J19)","v":1391595.33},null,{"$f":"SUM(L3:L19)","v":1292000},"12,155.25 Acres   1373 Accounts"]
[]
["EXPENSE"]
["506.00 · AD - Canal & Bank",0,null,300,null,303.68,null,300,null,0,null,500]
["511.00 · AD - Dam Repair (Fish, 4 mile)",181.85,null,200,null,38.92,null,200,null,0,null,500]
["500.40 · AD-Elect-Lake CK/SF/NF DIV",237.7,null,900,null,236.59,null,900,null,0,null,500]
["512.00 · AD - F L Cabin Repair / Permit",212.35,null,250,null,220.84,null,250,null,0,null,500]
["515.00 · AD - Gages (Fish, 4 mile)",0,null,100,null,0,null,100,null,0,null,500]
["514.00 · AD - Hydro/Telem-Maint / Cells",3955.67,null,1900,null,4162.26,null,3500,null,856.91,null,4000]
["508.00 · AD - Repair Spillways",0,null,100,null,0,null,100,null,0,null,500]
["500.45 · AD-NF-SF Fish Facilities",2988.82,null,1000,null,85.81,null,1000,null,129.94999999999999,null,1000]
["517.00 · AD - Slide Gate",0,null,250,null,0,null,250,null,0,null,500]
["540.00 · AD - Snowmobile Rental",1050,null,1400,null,1200,null,1400,null,450,null,1500]
["415.00   Attorney FeesLegal ",320,null,0,null,6170.55,null,5000,null,0,null,5000]
["416.00 · Audit",12750,null,12750,null,20250,null,15000,null,17750,null,23000]
["415.01 · Bank Fees/Checking Acct",1391.3,null,1600,null,1623.63,null,1600,null,785.25,null,1500]
["756.00 · Bear Creek - Automated Gates",237.84,null,200,null,0,null,500,null,0,null,500]
["429.30 · Board meeting exp.",237.84,null,1500,null,1050,null,1500,null,825,null,1500]
["602.20 · Bor-Hydromet Services",9964.7000000000007,null,5007,null,4957.3500000000004,null,5007,null,0,null,5000]
["704.00 · Bridges & Culverts",0,null,3000,null,350,null,3000,null,509.79,null,5000]
["910.22 · Building Improvements",1535.98,null,1500,null,0,null,1500,null,550.84,null,1000]
["706.00 · Canal/Bank Reapir / Moss Cntrl",5280.2,null,3600,null,16418.38,null,7500,null,2468.85,null,13000]
["709.00 · Canal Lining Repairs & Maint",25733.11,null,5000,null,6885.33,null,8000,null,9678.2900000000009,null,13000]
["428.00 · Computer services",14070.22,null,12000,null,13653.83,null,13000,null,10928.66,null,15000]
["429.20 · Conferences & seminars",995.4,null,2000,null,1779.62,null,2000,null,274.39,null,1500]
["451.00 · Copier lease (36 mo)",2909.61,null,3060,null,3458.37,null,3200,null,1967.7,null,3200]
["450.00 · Debt - US Contract",28978.69,null,28978.69,null,28978.69,null,29410]
["708.00 · Diversions",6295.04,null,400,null,33844.230000000003,null,1000,null,134.93,null,10000]
["714.00 · Elec Motor Fishwheels / Bear Cr",0,null,200,null,0,null,200,null,0,null,2500]
["423.20 · Elections",0,null,0,null,0,null,0,null,576.51,null,3000]
["904.00 · Equipment Rentals & Leases",513.21,null,800,null,1459.99,null,1000,null,511.01,null,2000]
["415.10 ·  Fees & Licenses",null,null,null,null,null,null,180]
["426.10 · Garbage Disposal",1765.59,null,1693.89,null,1693.89,null,1745,null,1102.8,null,2000]
["900.00 · Gas, Diesel & Oil",27138.720000000001,null,33000,null,30022.86,null,33000,null,27094.28,null,40000]
["417.00 · General Liab Ins/Bonds",45209,null,45500,null,46192,null,46500,null,52580,null,55000]
["602.25 · GIS - Annual License Renewal",6900,null,7000,null,4140,null,5000,null,2715,null,5000]
["415.18 · Government Ethics Charges",548.87,null,950,null,548.83000000000004,null,600,null,0,null,548.83000000000004]
["706.01 · Joint System Proj. Consulting",0,null,0,null,0,null,0,null,14570.85,null,35000]
["803.00 · Kime Reservoir / Fac. Maint",111.89,null,250,null,0,null,250,null,59.99]
["910.03 · Kime Reservoir - Impvts",0,null,200,null,0,null,200,null,370.79]
["910.13 · Large Tools",450,null,400,null,0,null,400,null,0,null,20000]
["710.00 · Laterals / Auger Rods",1573.62,null,1600,null,0,null,1600,null,760.85,null,1500]
["415.15 · Legal Exp-Adjudication",21581.91,null,50000,null,6937.29,null,25000,null,4990.82,null,20000]
["903.00 · Licenses & Permits",500,null,600,null,544.79999999999995,null,600,null,540,null,750]
["424.02 · Maint agreements / copier / SOS",2600.65,null,3600,null,2610.4299999999998,null,3600,null,2190.31,null,3000]
["429.10 · Meetings - General",595.59,null,600,null,624.48,null,600,null,105.15,null,500]
["429.00 · Membership dues",11936.53,null,11000,null,11997.45,null,11000,null,6841.16,null,12500]
["425.10 · O&M crew & shop supplies",726.29,null,700,null,484.37,null,700,null,267.99,null,5000]
["602.00 · O & M - T.I.D.",34820.39,null,36128,null,71207.89,null,37673.08,null,0,null,35000]
["424.00 · Office equipment repairs",0,null,200,null,41.18,null,200,null,57.5,null,2500]
["425.00 · Office maint cleaning",15.4,null,300,null,8.67,null,300,null,0,null,500]
["423.00 · Office Supplies",4237.42,null,5500,null,3025.37,null,4000,null,3281.97,null,5000,"ALL INCLUSIVE PAYROLL  BELOW"]
["PAYROLL EXPENSE ",null,null,null,null,null,null,null,null,null,null,null,"BUDGET","ACTUAL","BUDGET","ACTUAL"]
["414.20 · Accrued Sick/Administration",6599,null,6838,null,0,null,5655.52,null,0,null,null,"2021",2021,"2022",2022]
["600.00 · Crew Salary / Sick Bonus","290.672.60",null,309206,null,311002.87,null,321574.24,null,219271.91,null,325000,{"$f":"SUM(D73:D83)","v":873602},{"$f":"SUM(F73:F83)","v":790498.22000000009},{"$f":"SUM(H73:H83)","v":883753.3600000001},{"$f":"SUM(J73:J83)","v":590347.66}]
["418.00 · Employer PR taxes",42028.84,null,44356,null,48302.32,null,50290.239999999998,null,28657.35,null,50000,"Increase in wages per"]
["414.17 · Finance/Accounting",43223.839999999997,null,44540,null,36339.89,null,0,null,0,null,null,"year by percentage.",null,"Pers/Taxes","Total"]
["421.00 · Group Insurance",119554.94,null,133838,null,110325.02,null,146150.16,null,91426.22,null,95000,"CPI 9.0%",4118,{"$f":"SUM(N77*19%)","v":782.42},{"$f":"SUM(N77:O77)","v":4900.42}]
["411.10 · Manager's Salary",76989.600000000006,null,81073,null,79872,null,84315.92,null,63448.87,null,85000,"CPI 8.5%",3890,{"$f":"SUM(N78*19%)","v":739.1},{"$f":"SUM(N78:O78)","v":4629.1000000000004}]
["414.00 · Office Assistant/RRA",38295.160000000003,null,39549,null,39593.08,null,45449.04,null,34818.32,null,48000,"CPI 8.0%",3661,695.59,4356.59]
["414.15 · Office Supervisor",48687.44,null,50096,null,13132.06,null,60569.599999999999,null,26924.14,null,59000,"CPI 7.5%",3432,652.08000000000004,4084.08]
["411.20 · Operations Foreman/Admin Asst",32167.45,null,46509,null,31519.85,null,32780.639999999999,null,27456.66,null,36000,"CPI 7.0%",3203,608.57000000000005,3811.57]
["419.00 · Retirement / PERS",105517.36,null,105391,null,104549.96,null,119808,null,87188.29,null,110000,"CPI 6.5%",2974,565.06000000000006,3539.06]
["420.00 · Workers Compensation",10855.5,null,12206,null,15861.17,null,17160,null,11155.9,null,12000,"CPI 6.0%",2746,{"$f":"SUM(N83*19%)","v":521.74},3267.74]
["425.00 · CDL Expense",0,null,0,null,0,null,0,null,0,null,5000]
["609.00 · Physicals, Drug Screens",155,null,200,null,194,null,200,null,368,null,1000]
["431.00 · Postage",1786.25,null,1800,null,1419.16,null,1800,null,1165.4100000000001,null,2000]
["431.10 · Professional Fees",1786.25,null,0,null,4620,null,18000,null,10500,null,5000]
["700.00 · Pump Repair - Electric",290.94,null,500,null,287.81,null,500,null,72.97,null,1500]
["432.00 · Recording fees",3602,null,4000,null,2622,null,3000,null,114,null,5000]
["902.30 · Repairs - Equipment",4689.96,null,2500,null,4099.4399999999996,null,12500,null,3943.41,null,12000]
["902.00 · Repairs - Vehicles",2726.38,null,6000,null,5577.07,null,6000,null,3746.62,null,12000]
["403.00 · RRVID Jnt Assesmnt From MID",8617.82,null,8716,null,0,null,8716,null,0,null,8617.82]
["610.00 · Safety Equipment / Clothing",663.12,null,1000,null,831.72,null,1500,null,277.92,null,2000,null,null,null,null,null,null,0]
["910.45 · SDAO Safety",0,null,0,null,0,null,0,null,0,null,5000]
["905.00 · Shop Acct Small Supplies",530.14,null,400,null,1171.99,null,1000,null,372.86,null,2000]
["707.00 · Siphons",0,null,250,null,41.72,null,250,null,0]
["423.10 · Small furnishings / Equip",0,null,300,null,276.70999999999998,null,300,null,13.82,null,1000]
["603.00 · Small Tools",523.03,null,1000,null,536.08000000000004,null,1500,null,216.16,null,3000]
["460.00 · Smith West Consultation",12000,null,12000,null,12000,null,12000,null,7000]
["435.00 · Software / Dues / Subscription",0,null,0,null,1338.99,null,1518.87,null,606.92999999999995,null,2000]
["711.00 · Spillways",915.38,null,500,null,3816.63,null,1500,null,0,null,5000]
["601.00 · State Watermaster",0,null,2000,null,2000,null,2000,null,0,null,2000]
["713.0 · Stock Gates",0,null,100,null,0,null,100,null,0,null,2000]
["400.10 · Supplies - Chemicals",0,null,100,null,0,null,100,null,0,null,3000]
["400.50 · Supplies - Welding",1129.96,null,1000,null,3042.22,null,1000,null,642.07000000000005,null,1800]
["427.00 · Tele/radio/pgrs/cell/telem cel",9391.16,null,13500,null,9045.27,null,9000,null,5222.38,null,10000]
["629.00 · Training",500,null,0,null,0,null,500,null,626.91,null,1000]
["440.00 · Transfers Water Right Exp",2200,null,1000,null,0,null,1000,null,0]
["910.26 · Truck/Equipment& Safety",0,null,0,null,0,null,0,null,0,null,1000]
["703.00 · Turns - Checks / Staff Gauges",1478.54,null,2000,null,5922.69,null,6000,null,59.6,null,6000]
["426.00 · Utilities / propane / water sys",8471.68,null,12000,null,8267.6,null,12000,null,3578.77,null,10000]
["910.12 · Yard Maint & Equip",24.51,null,400,null,82.98,null,400,null,0,null,1000]
[null,{"$f":"SUM(B23:B112)","v":865952.64999999991},null,{"$f":"SUM(D23:D112)","v":1232085.58},null,{"$f":"SUM(F23:F112)","v":1184899.8799999997},null,{"$f":"SUM(H23:H112)","v":1265703.3100000003},null,{"$f":"SUM(J23:J112)","v":794803.03000000014},null,{"$f":"SUM(L23:L112)","v":1289416.6500000001}]
[]
[null,{"$f":"SUM(B20-B113)","v":530997.03},null,{"$f":"SUM(D20-D113)","v":28573.419999999925},null,158246.24000000022,null,12842.689999999711,null,596792.29999999993]