FY2027.xlsx

Excel · 31 KB · released by the City of Moscow on request 26-262
Excel file. Download it to open in the matching program.
SHA-256 20a5786daa8ac8798aad29d9ccde5139b28bdd2d248a216e90ccf5296826794c
Extracted text

Machine-extracted text layer of the file above, shown verbatim for search and reading. Tables and slides lose their layout. The original file governs.
# FY2027.xlsx
- path: - path: FY2027.xlsx
- type: xlsx
- size: 30741 bytes
- sheets: 4
- extraction method: xlsx (openpyxl, cached values)

=== Sheet: Medical Only ===
 |  |  |  |  | Medical Only
 |  |  |  |  | GROUP MEDICAL BREAKOUT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -84073.30211044662
 |  |  |  |  | Moscow Employees | Employee | Employee + Spouse | Employee + Child | Employee + 2 or more Children | Employee/Spouse + 1 Child | Family
 | Revenue/Expense FY2027 |  |  |  | 2026 |  |  |  |  |  |  |  | Insurance | 2% COLA | 2% Performance | All
 | General Fund Increase After Allocation | -420000 |  |  | Total Monthly Premium | 771.1 | 1619 | 1231.6 | 1467.4 | 2079.5 | 2315.3 |  | -325795.895568 | -168146.60422089323 | -75875.71600089362 | -569818.2157897868
 | ICAC Reduction | -138000 |  |  | Annual Premium | 9253.2 | 19428 | 14779.199999999999 | 17608.800000000003 | 24954 | 27783.600000000002
 | PD Overtime Expense | -125000 |  |  | Employee's Share of Spouse and Dependent Cost - Monthly | 0 | 296.7649999999999 | 161.17499999999995 | 243.70499999999993 | 457.94000000000005 | 540.4699999999998
 | State Liquor Tax Reduction | -22300 |  |  | City's Share of Employee, Spouse and Dependent Cost - Monthly | 771.1 | 1322.2350000000001 | 1070.425 | 1223.6950000000002 | 1621.56 | 1774.8300000000004 |  | Employee Only  | 0
 | Additional 1% Cola |  |  |  | City's Share of Employee, Spouse and Dependent Cost - Annual | 9253.2 | 15866.820000000002 | 12845.099999999999 | 14684.340000000002 | 19458.72 | 21297.960000000006 |  | Employee + Spouse | 2981.216400000003
 | Estimated Property Tax Revenue Increase | 389275 |  |  | Assumed Increase | 0.286 |  |  |  |  |  |  | Employee + 1 Child  | 1619.1179999999977
 | State Shared Revenue Increase | 118409 |  |  |  |  |  |  |  |  |  |  | Employee + Children  | 2448.190800000001
 | Police Patrol Postion Elimination | 117000 |  |  | 2027 |  |  |  |  |  |  |  | Employee + Spouse + 1 Child  | 4600.334399999998
 | Rec & Culture Transaction Fees | 100000 |  |  | Total Monthly Premium | 991.6346000000001 | 2082.034 | 1583.8375999999998 | 1887.0764000000001 | 2674.237 | 2977.4758 |  | Employee + Spouse + Children  | 5429.4072000000015
 | University Services Agreement Increase | 32569.4 |  |  | Annual Premium | 11899.6152 | 24984.408000000003 | 19006.051199999998 | 22644.916800000003 | 32090.844 | 35729.7096
 | Permit Fee Increases | 20000 |  |  | Employee's Share of Spouse and Dependent Cost - Monthly | 0 | 545.1997000000001 | 296.10149999999976 | 447.72090000000003 | 841.3011999999999 | 992.9205999999999 |  | City Median Hourly | 36.58
 | Department Reduction | 96715 |  |  | City's Share of Employee, Spouse and Dependent Cost - Monthly | 991.6346000000001 | 1536.8343 | 1287.7361 | 1439.3555000000001 | 1832.9358000000002 | 1984.5552000000002 |  | 2% Annual Pre Tax | 1521.728
 | Sanitation Franchise Fee | 32000 |  |  | City's Share of Employee, Spouse and Dependent Cost - Annual | 11899.615200000002 | 20404.73052 | 16518.7986 | 18884.061240000003 | 25023.913920000003 | 27389.176560000007 |  | 2.5% Annual Pre Tax | 1902.1599999999999
 | Employee Insurance Participation |  |  |  |  |  |  |  |  |  |  |  | 3% Annual Pre Tax | 2282.5919999999996
 | Fund Balance Utilization |  |  |  | Employee Monthly Increase | 0 | 248.43470000000025 | 134.9264999999998 | 204.0159000000001 | 383.3611999999998 | 452.4506000000001
 | Variance | 200668.4 |  |  | Employee Annual Increase | 0 | 2981.216400000003 | 1619.1179999999977 | 2448.190800000001 | 4600.334399999998 | 5429.4072000000015
 |  |  |  |  | City Monthly Increase | 220.53460000000007 | 214.59929999999986 | 217.31110000000012 | 215.66049999999996 | 211.37580000000025 | 209.72519999999986
 |  |  |  |  | City Annual Increase (per employee) | 2646.415200000001 | 2575.1915999999983 | 2607.7332000000015 | 2587.9259999999995 | 2536.509600000003 | 2516.7023999999983
 |  |  |  |  | Employee contribution per month | 0 | Dependent Coverage Percentage | 0.5 |  | GF Cost | 238173.4007999999
 |  |  |  |  | Employee contribution total revenue | 0
 |  |  |  |  |  |  | Regence Current | Regence Renewal | State of Idaho | Regence Renewal Premium | State Total Premium
 |  |  |  |  | Employee Only  | 85 | 786522 | 1011467.2920000001 | 1347154.7999999998 | 991.6346000000001 | 1391.48
 |  |  |  |  | Employee + Spouse | 14 | 222135.48 | 258188.16239999997 | 221884.32 | 2082.034 | 1535.78
 |  |  |  |  | Employee + 1 Child  | 15 | 192676.5 | 231792.498 | 237733.19999999998 | 1583.84 | 1442.62
 |  |  |  |  | Employee + Children  | 15 | 220265.10000000003 | 259083.99 | 237733.19999999998 | 1887.08 | 1513.38
 |  |  |  |  | Employee + Spouse + 1 Child  | 7 | 136211.04 | 153966.60720000003 | 110942.16 | 2674.24 | 1584.28
 |  |  |  |  | Employee + Spouse + Children  | 16 | 340767.3600000001 | 381034.5984 | 253582.08000000002 | 2977.48 | 1673.8400000000001
 |  |  |  |  |  | 152 | 1898577.4800000002 | 2295533.148 | 2409029.76 | 396955.66799999983 | 542993.15928
 |  |  |  |  |  |  |  |  |  | 238173.4007999999
 |  |  |  |  | Employee Contribution |  | Regence Current | Regence Renewal | State of Idaho
 |  |  |  |  | Employee Only  |  | 0 | 0 | 70.74 |  |  | 0 | 0 | 0
 |  |  |  |  | Employee + Spouse |  | 296.7649999999999 | 545.1997000000001 | 215.04 |  |  | 545.1997000000001 | 163.55991000000017 | 1962.718920000002
 |  |  |  |  | Employee + 1 Child  |  | 161.17499999999995 | 296.10149999999976 | 121.88 |  |  | 296.10149999999976 | 88.83044999999993 | 1065.9653999999991
 |  |  |  |  | Employee + Children  |  | 243.70499999999993 | 447.72090000000003 | 192.64 |  |  | 447.72090000000003 | 134.31627000000003 | 1611.7952400000004
 |  |  |  |  | Employee + Spouse + 1 Child  |  | 457.94000000000005 | 841.3011999999999 | 263.54 |  |  | 841.3011999999999 | 252.39035999999987 | 3028.6843199999985
 |  |  |  |  | Employee + Spouse + Children  |  | 540.4699999999998 | 992.9205999999999 | 353.1 |  |  | 992.9205999999999 | 297.87617999999975 | 3574.514159999997
 |  |  |  |  | 70% Coverage Cost - Medical Only
 |  |  |  |  |  | City Monthly Cost Increase | Employee Monthly Cost Increase | Total Employee Monthly Cost
 |  |  |  |  | Employee Only  | 220.53460000000007 | 0 | 0
 |  |  |  |  | Employee + Spouse | 432.6791800000001 | 30.354820000000018 | 327.1198199999999
 |  |  |  |  | Employee + 1 Child  | 335.7517 | 16.4858999999999 | 177.66089999999986
 |  |  |  |  | Employee + Children  | 394.7488599999999 | 24.927540000000135 | 268.63254000000006
 |  |  |  |  | Employee + Spouse + 1 Child  | 547.8962800000004 | 46.84071999999969 | 504.78071999999975
 |  |  |  |  | Employee + Spouse + Children  | 606.8934399999994 | 55.28236000000061 | 595.7523600000004
 |  |  |  |  |  | Current Monthly Premium | New Monthly Premium | City Monthly Cost | Employee Monthly Cost
 |  |  |  |  | Employee Only  | 771.1 | 991.6346000000001 | 991.6346000000001 | 0
 |  |  |  |  | Employee + Spouse | 1619 | 2082.034 | 1754.9141800000002 | 381.63978999999995
 |  |  |  |  | Employee + 1 Child  | 1231.6 | 1583.8375999999998 | 1406.1767 | 207.27104999999983
 |  |  |  |  | Employee + Children  | 1467.4 | 1887.0764000000001 | 1618.44386 | 313.40463
 |  |  |  |  | Employee + Spouse + 1 Child  | 2079.5 | 2674.237 | 2169.4562800000003 | 588.91084
 |  |  |  |  | Employee + Spouse + Children  | 2315.3 | 2977.4758 | 2381.7234399999998 | 695.0444200000002
 |  |  |  |  | 70% Dependent Coverage
 |  |  |  |  |  | Dental  | Vision | Medical | Dental | Vision | total
 |  |  |  |  | Employee Only  | 53.85 | 7.06 | 991.6346000000001 | 53.85 | 7.06 | 1052.5446 | 12630.535199999998 | 85 | 1073595.4919999999
 |  |  |  |  | Employee + Spouse | 107.7 | 14.12 | 1754.9141800000002 | 91.545 | 12.001999999999999 | 1858.4611800000002 | 22301.534160000003 | 14 | 312221.47824
 |  |  |  |  | Employee + 1 Child  | 107.7 | 15.1 | 1406.1767 | 91.545 | 12.687999999999999 | 1510.4097000000002 | 18124.916400000002 | 15 | 271873.74600000004
 |  |  |  |  | Employee + Children  | 107.7 | 15.1 | 1618.44386 | 91.545 | 12.687999999999999 | 1722.6768600000003 | 20672.122320000002 | 15 | 310081.8348
 |  |  |  |  | Employee + Spouse + 1 Child  | 161.65 | 24.16 | 2169.4562800000003 | 129.31 | 19.03 | 2317.7962800000005 | 27813.555360000006 | 7 | 194694.88752000005
 |  |  |  |  | Employee + Spouse + Children  | 161.65 | 24.16 | 2381.7234399999998 | 129.31 | 19.03 | 2530.06344 | 30360.76128 | 26 | 789379.79328 | 16
 |  |  |  |  |  |  |  |  |  | 37.47 |  |  | 162 | 2951847.23184
 |  |  |  |  | 65% Dependent Coverage
 |  |  |  |  | Employee Only  | Dental  | Vision | Medical | Dental | Vision | total
 |  |  |  |  | Employee + Spouse | 53.85 | 7.06 | 991.6346000000001 | 53.85 | 7.06 | 1052.5446 | 12630.535199999998 | 85 | 1073595.4919999999
 |  |  |  |  | Employee + 1 Child  | 107.7 | 14.12 | 1700.3942100000002 | 88.8525 | 11.649 | 1800.89571 | 21610.74852 | 14 | 302550.47928
 |  |  |  |  | Employee + Children  | 107.7 | 15.1 | 1376.56655 | 88.8525 | 12.286 | 1477.70505 | 17732.4606 | 15 | 265986.909
 |  |  |  |  | Employee + Spouse + 1 Child  | 107.7 | 15.1 | 1573.6717700000002 | 88.8525 | 12.286 | 1674.8102700000002 | 20097.723240000003 | 15 | 301465.8486
 |  |  |  |  | Employee + Spouse + Children  | 161.65 | 24.16 | 2085.32616 | 123.92000000000002 | 18.175 | 2227.4211600000003 | 26729.053920000006 | 7 | 187103.37744000004
 |  |  |  |  |  | 161.65 | 24.16 | 2282.43138 | 123.92000000000002 | 18.175 | 2424.5263800000002 | 29094.316560000003 | 26 | 756452.23056 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | 162 | 2887154.33688
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 64692.89496000018
 |  |  |  |  |  |  |  |  | 1036.6355999999998
 |  |  |  |  | Employee Only  | Employee Monthly Cost at 65% Coverage
 |  |  |  |  | Employee + Spouse | 0 | 0
 |  |  |  |  | Employee + 1 Child  | 381.63978999999995 | 327.1198199999999
 |  |  |  |  | Employee + Children  | 207.27104999999983 | 177.66089999999986
 |  |  |  |  | Employee + Spouse + 1 Child  | 313.40463 | 268.63254000000006
 |  |  |  |  | Employee + Spouse + Children  | 588.91084 | 504.78071999999975
 |  |  |  |  |  | 695.0444200000002 | 595.7523600000004
[83 non-empty rows]

=== Sheet: Sheet3 ===
 |  | Year | City COLA | CPI Change
 |  | FY2020 |  | 0.018
 |  | FY2021 | 0 | 0.012
 |  | FY2022 | 0.03 | 0.047
 |  | FY2023 | 0.047 | 0.08
 |  | FY2024 | 0 | 0.041
 |  | FY2025 | 0.04 | 0.029
 |  | FY2026 | 0.04 | 0.026
 |  | FY2027 | 0.02
 |  | Total % Change | 0.177 | 0.253
[10 non-empty rows]

=== Sheet: Sheet1 ===
 |  | Request | Amended | Reduction
 | Finance- Office Supplies | 3000 | 2800 | 200
 | Finance Overtime | 400 | 0 | 400
 | Legal Professional Services | 24500 | 19200 | 5300
 | Police Minor Equipment | 2500 | 1500 | 1000
 | Police - Public Education | 4500 | 3500 | 1000
 | Police - SRT Supplies | 15400 | 15400 | 0
 | Police R&M Equipment | 6000 | 6000 | 0
 | Parking Professional Services | 900 | 250 | 650
 | Fire Overtime Expenses | 14000 | 14000 | 0
 | Fire Department Supplies | 113065 | 100000 | 13065
 | Fire Uniform | 10000 | 8500 | 1500
 | Fire Professional Development | 18500 | 16000 | 2500 | New Personnel EMS
 | Fire Minor Equipment | 26000 | 22000 | 4000
 | B&G Buildings | 126215 | 107815 | 18400
 | Community Development Dues, Subscriptions, Memberships | 11500 | 7500 | 4000
 | Non-Departmental | 63000 | 63000 | 0
 | Parks Overtime | 25700 | 18000 | 7700
 | Parks Donated Purchases | 3000 | 2000 | 1000
 | Parks R&M Equipment | 15500 | 3500 | 12000 | $12,000 scoreboard project Moved to Capital Projects
 | Parks Mower | 24000 | 0 | 24000 | Moved to Fleet
 |  |  |  | 0
 |  |  |  | 0
 | Total reductions |  |  | 96715
[24 non-empty rows]

=== Sheet: Sheet2 ===
Historical Rate Increases
2021 | 0.0501
2022 | 0.048
2023 | 0.049
2024 | 0.088
2025 | 0.025
2026 | 0.0188
2027 | 0.286
[8 non-empty rows]