{"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":7,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[null,"2021 ACTUAL ","2022 BUDGET","2022 ACTUAL TO DATE","2023 Approved Budget"]
["INCOME"]
["324.10 · Frost Protection Income",3581.39,3581,2814,4500]
["345.00 · Income - Permits & Fees",0,1000,null,1000]
["306.00 · Interest Pool Account #5940",3860.83,4000,11534.71,7000]
["306.20 · Interest Pool Account #5941",1714.17,2000,4035.74,2000]
["301.00 · Joint Works & Assessments",23529.21,25000,17381.7,28000]
["300.10 · Labor & Materials",0,500,1215.42,500]
["300.20 · Lien Search",53975,50000,50586.85,55000]
["311.00 · Miscellaneous",72890.460000000006,500,5428.74,500]
["307.11 · SDAO Safety",0,null,null,5000]
["307.00 · SDIS Longevity Credit- SDAO",3297.5,3297,4886,5000]
["316.00 · Transfer Processing Fees",2964,6000,2660,8000]
["314.00 · Water Right Sales",0,10000]
["306.41 · Water User Late Fees",9045.1,9000,9540,10000]
["306.40 · Water User Payment Interest",18986.330000000002,15000,20656.79,15500]
["328.00 · W.U. Liens Processing Fees",0,3000,null,5000]
["305.00 · Water User Revenue",1149302.1299999999,1145668,1146727.6499999999,1193621]
["TOTAL",{"$f":"SUM(B3:B18)","v":1343146.1199999999},{"$f":"SUM(C3:C18)","v":1278546},{"$f":"SUM(D3:D18)","v":1277467.5999999999},{"$f":"SUM(E3:E18)","v":1340621},"12,155.25 Acres   1373 Accounts"]
["EXPENSE"]
["506.00 · AD - Canal & Bank",303.68,300]
["511.00 · AD - Dam Repair (Fish, 4 mile)",38.92,200]
["500.40 · AD-Elect-Lake CK/SF/NF DIV",236.59,900]
["512.00 · AD - F L Cabin Repair / Permit",220.84,250,449.12]
["515.00 · AD - Gages (Fish, 4 mile)",0,100]
["514.00 · AD - Hydro/Telem-Maint / Cells",4162.26,3500,1033.25]
["508.00 · AD - Repair Spillways",0,100]
["500.45 · AD-NF-SF Fish Facilities",85.81,1000,245.84,null,null,{"$f":"SUM(D19-D115)","v":64778.20999999973}]
["517.00 · AD - Slide Gate",0,250]
["540.00 · AD - Snowmobile Rental",1200,1400,450]
["415.00   Attorney FeesLegal ",6170.55,5000,3583,5000]
["416.00 · Audit",20250,15000,17750,23000,8000]
["415.01 · Bank Fees/Checking Acct",1623.63,1600,1449.41,1500]
["756.00 · Bear Creek - Automated Gates",0,500,140.56,500]
["415.16 · Biological Opinion Exp",null,null,85]
["429.30 · Board meeting exp.",1050,1500,1100,1500]
["602.20 · Bor-Hydromet Services",4957.3500000000004,5007,4994.3100000000004,5000]
["704.00 · Bridges & Culverts",350,3000,1090.3599999999999,3000]
["910.22 · Building Improvements",0,1500,624.83000000000004,1000]
["706.00 · Canal/Bank Reapir / Moss Cntrl",16418.38,7500,3665.79,10000]
["709.00 · Canal Lining Repairs & Maint",6885.33,8000,9704.2099999999991,10000]
["428.00 · Computer services",13653.83,13000,14125.07,15000]
["429.20 · Conferences & seminars",1779.62,2000,749.39,1500]
["451.00 · Copier lease (36 mo)",3458.37,3200,3110.58,3200]
["450.00 · Debt - US Contract",28978.69,29410,28978.69,30000]
["708.00 · Diversions",33844.230000000003,1000,143.82,1000]
["714.00 · Elec Motor Fishwheels / Bear Cr",0,200,null,1000]
["423.20 · Elections",0,0,576.51,3000]
["904.00 · Equipment Rentals & Leases",1459.99,1000,511.01,2000]
["709.10 ·  EC Lateral",null,null,12775.11]
["426.10 · Garbage Disposal",1693.89,1745,1859.1,2000]
["900.00 · Gas, Diesel & Oil",30022.86,33000,41638.370000000003,40000]
["417.00 · General Liab Ins/Bonds",46192,46500,111419,55000]
["602.25 · GIS - Annual License Renewal",4140,5000,3885,5000]
["415.18 · Government Ethics Charges",548.83000000000004,600,548.83000000000004,550]
["456.00 ·  Interest Expense",null,null,33.67]
["706.01 · Joint System Proj. Consulting",0,null,18740.84,10000]
["803.00 · Kime Reservoir / Fac. Maint",0,250,59.99]
["910.03 · Kime Reservoir - Impvts",0,200,370.79]
["910.13 · Large Tools",0,400]
["710.00 · Laterals / Auger Rods",0,1600,760.85,1500]
["415.15 · Legal Exp-Adjudication",6937.29,25000,6550.82,25000]
["903.00 · Licenses & Permits",544.79999999999995,600,540,750]
["424.02 · Maint agreements / copier / SOS",2610.4299999999998,3600,3716.76,3000]
["429.10 · Meetings - General",624.48,600,149.96,500]
["429.00 · Membership dues",11997.45,11000,12249.48,12500]
["425.10 · O&M crew & shop supplies",484.37,700,1704.54,5000]
["602.00 · O & M - T.I.D.",71207.89,37673.08,37407.949999999997,35000]
["424.00 · Office equipment repairs",41.18,200,57.5,500]
["425.00 · Office maint cleaning",8.67,300,118.25,500]
["423.00 · Office Supplies",3025.37,4000,5207.8100000000004,5000]
["PAYROLL EXPENSE "]
["414.20 · Accrued Sick/Administration",0,5655.52]
["600.00 · Crew Salary / Sick Bonus",311002.87,321574.24,295311.84999999998,339200]
["418.00 · Employer PR taxes",48302.32,50290.239999999998,37991.769999999997,60000]
["412.00 · CDL Training",36339.89,null,2880]
["Merit Bonus",null,null,null,11988.2]
["421.00 · Group Insurance",110325.02,146150.16,109887.99,146000]
["411.10 · Manager's Salary",79872,84315.92,81014.67,90100]
["414.00 · Office Assistant",39593.08,45449.04,43167.32,48505.599999999999]
["414.15 · Office Supervisor",13132.06,60569.599999999999,38093.699999999997,58427.199999999997]
["411.20 · Operations Foreman/Admin Asst",31519.85,32780.639999999999,30820.02,32000]
["419.00 · Retirement / PERS",104549.96,119808,115639.47,130000]
["420.00 · Workers Compensation",15861.17,17160,7120.99,18000]
[]
["425.00 · CDL Expense",0,null,4935]
["609.00 · Physicals, Drug Screens",194,200,500,500]
["431.00 · Postage",1419.16,1800,2073.09,2000]
["431.10 · Professional Fees",4620,18000,18000,5000]
["700.00 · Pump Repair - Electric",287.81,500,72.97,1500]
["432.00 · Recording fees",2622,3000,8550,8000]
["902.30 · Repairs - Equipment",4099.4399999999996,12500,5569.13,10000]
["902.00 · Repairs - Vehicles",5577.07,6000,8435.91,10000]
["403.00 · RRVID Jnt Assesmnt From MID",0,8716,null,8700]
["610.00 · Safety Equipment / Clothing",831.72,1500,763.51,2000]
["910.45 · SDAO Safety",0,null,550]
["905.00 · Shop Acct Small Supplies",1171.99,1000,522.82000000000005,1000]
["707.00 · Siphons",41.72,250]
["423.10 · Small furnishings / Equip",276.70999999999998,300,13.82,1000]
["603.00 · Small Tools",536.08000000000004,1500,709.72,3000]
["460.00 · Smith West Consultation",12000,12000,7000]
["435.00 · Software / Dues / Subscription",1338.99,1518.87,3155.36,2000]
["711.00 · Spillways",3816.63,1500,null,2000]
["601.00 · State Watermaster",2000,2000,2000,2000]
["713.00 · Stock Gates",0,100,null,100]
["400.10 · Supplies - Chemicals",0,100,7.77,100]
["400.50 · Supplies - Welding",3042.22,1000,1176.3699999999999,1000]
["427.00 · Tele/radio/pgrs/cell/telem cel",9045.27,9000,11012.17,10000]
["629.00 · Training",0,500,6975.73,1000]
["440.00 · Transfers Water Right Exp",0,1000]
["910.26 · Truck/Equipment& Safety",0]
["703.00 · Turns - Checks / Staff Gauges",5922.69,6000,6243.81,6000]
["426.00 · Utilities / propane / water sys",8267.6,12000,8145.09,10000]
["910.12 · Yard Maint & Equip",82.98,400,-6.03,500]
[null,{"$f":"SUM(B21:B114)","v":1184899.8799999997},{"$f":"SUM(C21:C114)","v":1265523.3100000003},{"$f":"SUM(D21:D114)","v":1212689.3900000001},{"$f":"SUM(E31:E114)","v":1340621}]