EPA 2020 COVID-19 WATER SECTOR SURVEY Appendix G: Data Tables for All Utility Types ml l\ j \ June 2021 &EPA 810-R-21-001 ------- Notes on Appendix G Appendices C-G present tables with detailed findings from the EPA 2020 COVID-19 Water Sector Survey. This appendix, Appendix G, presents total findings for all utility types. Each table includes findings for subgroups based on size (population served). The order of presentation in this appendix follows the order of questions in the survey (see Appendix B). The title of each table generally includes the applicable survey question number and the text of the question itself (or a close paraphrase). EPA used financial data from Part D of the survey to generate some derived measures. The tables presenting these measures are labeled as "calculated" rather than labelled with a question number. Some questions asked survey participants specifically about experiences from January 2020 to the present day, or from present day to December 2020. For these questions, "January to the Present" or "Present to December" is listed above each table to show the time period covered by the table. In most cases, findings are presented as point estimates and 95 percent confidence intervals. For an explanation of confidence intervals, see the discussion of methodology in Appendix A. Several questions asked respondents to provide responses on a scale. For example, questions Bl.1.1 and B2.1.1 asked respondents to rank the severity of their treatment chemical shortages as "no impact," "slight impact," "moderate impact," or "severe impact." EPA calculated a mean score for each such question by assigning numeric values to the responses (for example, 0 for no impact, 1 for slight impact, 2 for moderate impact, and 3 for severe impact) and averaging the results. Each table lists the number of observations, which is the number of responses received from survey participants to a given question or response option. The quantitative findings presented in the tables are weighted to provide national estimates, using weightings calculated and assigned to each utility type and size subgroup. For more information on the weightings, see the discussion of methodology in Appendix A. Blank cells indicate that no applicable responses were received. "N/A" indicates that a confidence interval cannot be calculated because there was no variance in responses. G-2 ------- Table G.l. Question Bl.l: What kinds of shortages or supply chain disruptions did your organization experience from January 2020 through present day? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Chain Issue Percentage Reporting by Population Served < 10,000 > 10,000 All Treatment Chemicals 4.1% 2.7% - 6.0% 5.5% 4.0% - 7.5% 4.2% 3.0% - 5.9% PPE 27.5% 24.5% - 30.8% 60.9% 55.7% - 65.8% 31.8% 29.1% - 34.8% Durable Goods and Other Equipment and Supplies 9.5% 7.7% - 11.7% 19.1% 15.5% - 23.3% 10.7% 9.1% - 12.7% None 68.6% 65.2% - 71.8% 34.7% 29.9% - 39.8% 64.2% 61.2% - 67.1% Observations 939 843 1,782 G-3 Table G.1 Page 1 of 1 ------- Table G.2. Question Bl.1.1: How severe were the treatment chemical shortages or supply chain disruptions that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Carbon Mean score (0 to 3) 0.006 0.013 0.007 dioxide 0.000 - 0.012 0.007 - 0.019 0.002 - 0.012 No impact (0) 99.4% 99.1% 99.4% 98.4% - 99.8% 98.7% - 99.4% 98.6% - 99.7% Slight (1) 0.6% 0.5% 0.6% 0.2% - 1.6% 0.3% - 0.8% 0.2% - 1.4% Moderate (2) 0.0% 0.4% 0.1% 0.0% - 0.1% 0.2% - 0.8% 0.0% - 0.1% Severe (3) Observations 939 841 1,780 Ferric Mean score (0 to 3) 0.002 0.006 0.003 chloride 0.000 - 0.004 0.002 - 0.009 0.001 - 0.005 No impact (0) 99.8% 99.5% 99.8% 99.4% - 99.9% 99.1% - 99.7% 99.5% - 99.9% Slight (1) 0.2% 0.4% 0.2% 0.1% - 0.6% 0.2% - 0.8% 0.1% - 0.5% Moderate (2) 0.0% 0.1% 0.0% 0.0% - 0.1% 0.0% - 0.3% 0.0% - 0.1% Severe (3) Observations 939 841 1,780 G-4 Table G.2 Page 1 of 6 ------- Table G.2. Question Bl.1.1: How severe were the treatment chemical shortages or supply chain disruptions that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Fluoride Mean score (0 to 3) 0.001 0.008 0.002 0.000 - 0.003 0.000 - 0.017 0.000 - 0.004 No impact (0) 99.9% 99.3% 99.8% 99.6% - 100.0% 97.9% - 99.8% 99.5% - 99.9% Slight (1) 0.1% 0.5% 0.1% 0.0% - 0.5% 0.1% - 2.2% 0.0% - 0.4% Moderate (2) 0.0% 0.1% 0.0% 0.0% - 0.1% 0.0% - 0.5% 0.0% - 0.1% Severe (3) Observations 939 841 1,780 Gaseous Mean score (0 to 3) 0.008 0.020 0.010 chlorine 0.002 - 0.015 0.005 - 0.035 0.004 - 0.016 No impact (0) 99.2% 98.0% 99.0% 98.2% - 99.6% 95.8% - 99.1% 98.2% - 99.5% Slight (1) 0.8% 1.9% 1.0% 0.4% - 1.8% 0.9% - 4.2% 0.5% - 1.8% Moderate (2) 0.0% 0.0% 0.0% 0.0% - 0.1% 0.0% - 0.1% 0.0% - 0.1% Severe (3) Observations 939 841 1,780 G-5 Table G.2 Page 2 of 6 ------- Table G.2. Question Bl.1.1: How severe were the treatment chemical shortages or supply chain disruptions that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Liquid Mean score (0 to 3) 0.001 0.001 0.001 oxygen 0.000 - 0.003 0.000 - 0.002 0.000 - 0.003 No impact (0) 99.9% 99.9% 99.9% 99.6% - 100.0% 99.7% - 100.0% 99.6% - 100.0% Slight (1) 0.1% 0.1% 0.1% 0.0% - 0.5% 0.0% - 0.3% 0.0% - 0.4% Moderate (2) 0.0% 0.0% 0.0% 0.0% - 0.1% N/A - N/A 0.0% - 0.1% Severe (3) 0.0% 0.0% 0.0% 0.0% - 0.1% N/A - N/A 0.0% - 0.1% Observations 939 841 1,780 Lime Mean score (0 to 3) 0.003 0.003 0.003 0.000 - 0.006 0.001 - 0.005 0.001 - 0.005 No impact (0) 99.8% 99.8% 99.8% 99.3% - 99.9% 99.5% - 99.9% 99.4% - 99.9% Slight (1) 0.2% 0.2% 0.2% 0.1% - 0.7% 0.1% - 0.4% 0.1% - 0.6% Moderate (2) 0.0% 0.0% 0.0% 0.0% - 0.1% 0.0% - 0.2% 0.0% - 0.1% Severe (3) Observations 939 841 1,780 G-6 Table G.2 Page 3 of 6 ------- Table G.2. Question Bl.1.1: How severe were the treatment chemical shortages or supply chain disruptions that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Orthophosphate Mean score (0 to 3) 0.002 0.007 0.002 0.000 - 0.004 -0.001 - 0.015 0.000 - 0.004 No impact (0) 99.8% 99.3% 99.8% 99.5% - 100.0% 97.8% - 99.8% 99.5% - 99.9% Slight (1) 0.1% 0.6% 0.2% 0.0% - 0.5% 0.2% - 2.2% 0.1% - 0.5% Moderate (2) 0.0% 0.0% 0.0% 0.0% - 0.1% 0.0% - 0.2% 0.0% - 0.1% Severe (3) Observations 939 841 1,780 Polymers Mean score (0 to 3) 0.002 0.021 0.004 0.000 - 0.003 0.010 - 0.033 0.002 - 0.006 No impact (0) 99.8% 98.3% 99.6% 99.6% - 99.9% 97.0% - 99.0% 99.4% - 99.8% Slight (1) 0.1% 1.2% 0.3% 0.0% - 0.4% 0.6% - 2.5% 0.1% - 0.5% Moderate (2) 0.0% 0.5% 0.1% 0.0% - 0.1% 0.2% - 1.0% 0.0% - 0.2% Severe (3) Observations 939 841 1,780 G-7 Table G.2 Page 4 of 6 ------- Table G.2. Question Bl.1.1: How severe were the treatment chemical shortages or supply chain disruptions that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Potassium Mean score (0 to 3) 0.003 0.009 0.004 permanganate 0.001 - 0.006 0.000 - 0.018 0.002 - 0.006 No impact (0) 99.7% 99.3% 99.6% 99.3% - 99.9% 97.8% - 99.8% 99.3% - 99.8% Slight (1) 0.3% 0.5% 0.3% 0.1% - 0.7% 0.1% - 2.3% 0.1% - 0.7% Moderate (2) 0.0% 0.2% 0.0% 0.0% - 0.1% 0.1% - 0.7% 0.0% - 0.1% Severe (3) Observations 939 841 1,780 Sodium Mean score (0 to 3) 0.002 0.005 0.002 hydroxide 0.000 - 0.003 0.001 - 0.009 0.001 - 0.004 No impact (0) 99.9% 99.6% 99.8% 99.6% - 100.0% 99.1% - 99.8% 99.6% - 99.9% Slight (1) 0.1% 0.3% 0.1% 0.0% - 0.5% 0.1% - 0.8% 0.0% - 0.4% Moderate (2) 0.0% 0.1% 0.0% 0.0% - 0.1% 0.0% - 0.6% 0.0% - 0.1% Severe (3) 0.0% 0.0% 0.0% 0.0% - 0.1% N/A - N/A 0.0% - 0.1% Observations 939 841 1,780 G-8 Table G.2 Page 5 of 6 ------- Table G.2. Question Bl.1.1: How severe were the treatment chemical shortages or supply chain disruptions that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Sodium Mean score (0 to 3) 0.030 0.014 0.028 hypochlorite 0.007 - 0.053 0.005 - 0.024 0.008 - 0.048 No impact (0) 98.2% 98.7% 98.3% 96.6% - 99.1% 97.5% - 99.4% 96.9% - 99.1% Slight (1) 0.8% 1.1% 0.8% 0.3% - 2.0% 0.5% - 2.4% 0.4% - 1.8% Moderate (2) 0.7% 0.2% 0.7% 0.3% - 2.1% 0.1% - 0.7% 0.2% - 1.8% Severe (3) 0.3% 0.0% 0.2% 0.0% - 1.8% N/A - N/A 0.0% - 1.6% Observations 939 841 1,780 N/A: confidence interval could not be calculated. G-9 Table G.2 Page 6 of 6 ------- Table G.3. Question Bl.1.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Carbon Unavailable from 43.6% 68.4% 48.1% dioxide supplier(s) 43.6% - 43.6% 43.9% - 85.7% 44.1% - 52.1% Delayed / backordered 30.4% 21.0% 28.7% from supplier(s) 10.8% - 61.3% 7.3% - 47.3% 11.8% - 54.9% Transportation / 3.3% 47.3% 11.3% distribution difficulties 3.3% - 3.3% 25.6% - 70.1% 7.6% - 16.4% Price 0.0% 10.5% 1.9% N/A - N/A 2.4% - 36.4% 0.5% - 7.6% Other 0.0% 47.3% 8.6% N/A - N/A 27.2% - 68.3% 5.3% - 13.5% Observations 7 18 25 Ferric Unavailable from 0.0% 9.3% 2.6% chloride supplier(s) N/A - N/A 0.7% - 59.3% 0.2% - 22.8% Delayed / backordered 38.8% 44.6% 40.4% from supplier(s) 1.3% - 96.8% 12.2% - 82.4% 3.9% - 91.9% Transportation / 22.5% 46.0% 28.9% distribution difficulties 12.1% - 37.9% 10.7% - 85.9% 16.6% - 45.4% Price 7.1% 0.0% 5.2% 0.7% - 44.8% N/A - N/A 0.4% - 39.6% Other 0.0% 8.6% 2.4% N/A - N/A 0.7% - 56.4% 0.2% - 21.2% Observations 6 9 15 G-10 Table G.3 Page 1 of 6 ------- Table G.3. Question Bl.1.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Fluoride Unavailable from 8.1% 0.0% 4.1% supplier(s) 0.3% - 72.9% N/A - N/A 0.2% - 53.4% Delayed / backordered 81.2% 86.1% 83.6% from supplier(s) 45.0% - 95.8% 31.4% - 98.8% 54.2% - 95.6% Transportation / 26.9% 20.8% 23.9% distribution difficulties 26.9% - 26.9% 6.4% - 50.1% 14.8% - 36.3% Price 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 4 6 10 Gaseous Unavailable from 7.0% 0.0% 5.2% chlorine supplier(s) 0.8% - 40.9% N/A - N/A 0.5% - 35.2% Delayed / backordered 75.7% 51.6% 69.4% from supplier(s) 37.4% - 94.2% 13.5% - 87.9% 40.7% - 88.2% Transportation / 57.3% 49.2% 55.2% distribution difficulties 28.3% - 82.1% 12.3% - 87.0% 30.5% - 77.6% Price 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Other 0.0% 2.4% 0.6% N/A - N/A 0.2% - 19.5% 0.1% - 5.3% Observations 13 11 24 G-11 Table G.3 Page 2 of 6 ------- Table G.3. Question Bl.1.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Liquid Unavailable from 0.0% 0.0% 0.0% oxygen supplier(s) N/A - N/A N/A - N/A N/A - N/A Delayed / backordered 69.4% 50.0% 67.3% from supplier(s) 69.4% - 69.4% 0.0% - 100.0% 7.6% - 98.1% Transportation / 17.9% 0.0% 15.9% distribution difficulties 17.9% - 17.9% N/A - N/A 15.9% - 15.9% Price 0.0% 50.0% 5.6% N/A - N/A 0.0% - 100.0% 0.0% - 100.0% Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 4 2 6 Lime Unavailable from 5.7% 0.0% 5.0% supplier(s) 0.4% - 48.1% N/A - N/A 0.4% - 44.1% Delayed / backordered 85.5% 40.0% 79.9% from supplier(s) 85.5% - 85.5% 3.1% - 93.2% 69.4% - 87.4% Transportation / 17.2% 60.0% 22.5% distribution difficulties 6.9% - 36.9% 6.8% - 96.9% 10.6% - 41.7% Price 3.0% 0.0% 2.6% 3.0% - 3.0% N/A - N/A 2.6% - 2.6% Other 3.5% 0.0% 3.0% 0.3% - 33.2% N/A - N/A 0.2% - 30.0% Observations 8 5 13 G-12 Table G.3 Page 3 of 6 ------- Table G.3. Question Bl.1.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Orthophosphate Unavailable from 0.0% 0.0% 0.0% supplier(s) N/A - N/A N/A - N/A N/A - N/A Delayed / backordered 87.3% 86.0% 86.8% from supplier(s) 51.6% - 97.8% 1.9% - 100.0% 45.5% - 98.1% Transportation / 12.7% 20.9% 16.0% distribution difficulties 2.2% - 48.4% 0.2% - 97.0% 3.1% - 52.6% Price 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 4 5 9 Polymers Unavailable from 0.0% 11.1% 6.9% supplier(s) N/A - N/A 2.5% - 37.9% 1.6% - 25.4% Delayed / backordered 59.0% 78.0% 70.8% from supplier(s) 51.0% - 66.6% 54.2% - 91.4% 57.7% - 81.2% Transportation / 30.8% 33.3% 32.4% distribution difficulties 19.6% - 44.8% 16.7% - 55.4% 20.4% - 47.2% Price 10.2% 0.0% 3.9% 3.1% - 28.6% N/A - N/A 1.3% - 11.3% Other 0.0% 2.5% 1.6% N/A - N/A 0.3% - 18.4% 0.2% - 11.9% Observations 9 18 27 G-13 Table G.3 Page 4 of 6 ------- Table G.3. Question Bl.1.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Potassium Unavailable from 19.7% 26.1% 21.4% permanganate supplier(s) 1.3% - 81.6% 3.0% - 80.3% 3.0% - 70.2% Delayed / backordered 48.8% 73.9% 55.4% from supplier(s) 13.1% - 85.7% 19.7% - 97.0% 18.7% - 87.0% Transportation / 29.1% 13.1% 24.9% distribution difficulties 4.4% - 78.7% 0.6% - 78.7% 4.5% - 69.8% Price 2.4% 0.0% 1.8% 1.5% - 3.9% N/A - N/A 1.8% - 1.8% Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 9 5 14 Sodium Unavailable from 0.0% 0.0% 0.0% hydroxide supplier(s) N/A - N/A N/A - N/A N/A - N/A Delayed / backordered 60.8% 33.6% 51.8% from supplier(s) 41.4% - 77.3% 3.5% - 87.6% 32.0% - 71.1% Transportation / 22.3% 77.5% 40.6% distribution difficulties 16.2% - 30.0% 10.4% - 99.0% 20.3% - 64.8% Price 5.7% 0.0% 3.8% 4.2% - 7.8% N/A - N/A 3.8% - 3.8% Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 6 6 12 G-14 Table G.3 Page 5 of 6 ------- Table G.3. Question Bl.1.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Sodium Unavailable from 34.1% 14.2% 32.1% hypochlorite supplier(s) 8.3% - 74.6% 3.2% - 45.2% 8.6% - 70.4% Delayed / backordered 68.1% 32.7% 64.6% from supplier(s) 27.0% - 92.5% 10.5% - 66.8% 28.4% - 89.4% Transportation / 47.6% 71.0% 49.9% distribution difficulties 16.5% - 80.7% 36.5% - 91.2% 19.8% - 80.1% Price 6.0% 0.0% 5.4% 5.6% - 6.4% N/A - N/A 5.4% - 5.4% Other 14.8% 3.4% 13.7% 1.5% - 66.9% 0.4% - 25.1% 1.5% - 62.8% Observations 17 13 30 N/A: confidence interval could not be calculated. G-15 Table G.3 Page 6 of 6 ------- Table G.4. Question Bl.1.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Carbon Found alternative supplier 0.0% 58.0% 10.5% dioxide N/A - N/A 35.2% - 77.7% 5.8% - 18.4% Drew down existing inventory 74.1% 68.4% 73.0% 38.5% - 92.9% 48.0% - 83.5% 44.4% - 90.2% Switched chemicals, procedures, or 1.4% 10.5% 3.1% technologies 0.2% - 10.1% 2.4% - 35.9% 0.9% - 9.9% Sought help from other utilities 1.9% 0.0% 1.5% or mutual aid network (e.g., WARN) 1.2% - 3.1% N/A - N/A 1.0% - 2.3% Coordinated with local or state 0.0% 1.6% 0.5% emergency management agency N/A - N/A 0.2% - 11.5% 0.1% - 3.5% Other 0.0% 26.3% 4.8% N/A - N/A 11.0% - 50.7% 1.9% - 11.5% Observations 15 26 41 Ferric Found alternative supplier 0.0% 0.0% 0.0% chloride N/A - N/A N/A - N/A N/A - N/A Drew down existing inventory 51.3% 72.7% 57.1% 7.9% - 92.8% 40.6% - 91.2% 16.8% - 89.8% Switched chemicals, procedures, or 4.3% 35.9% 12.9% technologies 0.5% - 29.6% 13.0% - 67.6% 4.4% - 32.7% Sought help from other utilities 5.7% 0.0% 4.1% or mutual aid network (e.g., WARN) 2.1% - 14.5% N/A - N/A 2.0% - 8.4% Coordinated with local or state 0.0% 0.0% 0.0% emergency management agency N/A - N/A N/A - N/A N/A - N/A Other 0.0% 9.3% 2.6% N/A - N/A 1.1% - 47.7% 0.3% - 18.5% Observations 16 28 44 G-16 Table G.4 Page 1 of 6 ------- Table G.4. Question Bl.1.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Fluoride Found alternative supplier 0.0% 27.9% 13.6% N/A - N/A 6.2% - 69.5% 4.2% - 36.3% Drew down existing inventory 81.2% 93.0% 87.0% 34.8% - 97.2% 55.2% - 99.3% 61.9% - 96.5% Switched chemicals, procedures, or 8.1% 0.0% 4.1% technologies 0.6% - 56.3% N/A - N/A 0.4% - 30.0% Sought help from other utilities 10.7% 0.0% 5.5% or mutual aid network (e.g., WARN) 2.3% - 38.4% N/A - N/A 2.1% - 13.7% Coordinated with local or state 0.0% 0.0% 0.0% emergency management agency N/A - N/A N/A - N/A N/A - N/A Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 18 38 56 Gaseous Found alternative supplier 0.0% 0.0% 0.0% chlorine N/A - N/A N/A - N/A N/A - N/A Drew down existing inventory 53.7% 98.4% 65.4% 17.5% - 86.4% 96.6% - 99.3% 28.2% - 90.1% Switched chemicals, procedures, or 1.0% 0.0% 0.8% technologies 0.1% - 7.8% N/A - N/A 0.1% - 5.6% Sought help from other utilities 14.0% 0.0% 10.3% or mutual aid network (e.g., WARN) 2.0% - 56.6% N/A - N/A 1.6% - 45.3% Coordinated with local or state 0.6% 0.0% 0.4% emergency management agency 0.1% - 4.4% N/A - N/A 0.1% - 2.7% Other 31.3% 2.4% 23.8% 5.3% - 78.7% 0.3% - 16.8% 4.1% - 69.7% Observations 35 55 90 G-17 Table G.4 Page 2 of 6 ------- Table G.4. Question Bl.1.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Liquid Found alternative supplier 0.0% 50.0% 5.6% oxygen N/A - N/A 2.2% - 97.8% 0.4% - 46.4% Drew down existing inventory 69.4% 50.0% 67.3% 19.0% - 95.6% 2.2% - 97.8% 19.7% - 94.5% Switched chemicals, procedures, or 7.7% 0.0% 6.8% technologies 0.5% - 56.1% N/A - N/A 0.5% - 50.2% Sought help from other utilities 10.2% 0.0% 9.1% or mutual aid network (e.g., WARN) 2.0% - 38.6% N/A - N/A 2.2% - 31.0% Coordinated with local or state 0.0% 0.0% 0.0% emergency management agency N/A - N/A N/A - N/A N/A - N/A Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 10 7 17 Lime Found alternative supplier 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Drew down existing inventory 89.0% 80.0% 87.9% 66.7% - 97.0% 27.9% - 97.6% 66.6% - 96.3% Switched chemicals, procedures, or 3.5% 20.0% 5.5% technologies 0.3% - 27.3% 2.4% - 72.1% 1.0% - 25.9% Sought help from other utilities 7.5% 0.0% 6.6% or mutual aid network (e.g., WARN) 2.5% - 20.7% N/A - N/A 2.5% - 16.3% Coordinated with local or state 1.5% 0.0% 1.0% emergency management agency 0.2% - 10.8% N/A - N/A 0.1% - 7.4% Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 18 27 45 G-18 Table G.4 Page 3 of 6 ------- Table G.4. Question Bl.1.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Orthophos- Found alternative supplier 37.7% 0.0% 22.9% phate 4.4% - 88.8% N/A - N/A 3.0% - 74.3% Drew down existing inventory 49.6% 100.0% 69.4% 7.3% - 92.4% N/A - N/A 25.1% - 93.9% Switched chemicals, procedures, or 5.5% 6.9% 6.1% technologies 0.5% - 38.7% 0.7% - 44.7% 1.2% - 26.0% Sought help from other utilities 7.3% 0.0% 4.4% or mutual aid network (e.g., WARN) 2.0% - 23.3% N/A - N/A 1.8% - 10.5% Coordinated with local or state 0.0% 0.0% 0.0% emergency management agency N/A - N/A N/A - N/A N/A - N/A Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 16 35 51 Polymers Found alternative supplier 0.0% 2.8% 1.7% N/A - N/A 0.4% - 17.9% 0.2% - 11.7% Drew down existing inventory 77.0% 91.9% 86.2% 43.1% - 93.6% 69.0% - 98.3% 71.6% - 94.0% Switched chemicals, procedures, or 5.5% 7.6% 6.8% technologies 0.6% - 36.3% 2.4% - 21.8% 2.4% - 18.1% Sought help from other utilities 12.0% 5.6% 8.0% or mutual aid network (e.g., WARN) 4.1% - 30.3% 0.7% - 32.1% 3.0% - 19.7% Coordinated with local or state 0.4% 0.0% 0.3% emergency management agency 0.1% - 3.0% N/A - N/A 0.0% - 1.8% Other 0.0% 2.7% 1.7% N/A - N/A 0.4% - 17.9% 0.2% - 11.7% Observations 39 79 118 G-19 Table G.4 Page 4 of 6 ------- Table G.4. Question Bl.1.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Potassium Found alternative supplier 19.7% 19.6% 19.6% perman- 2.3% - 71.4% 2.7% - 68.3% 3.8% - 60.0% ganate Drew down existing inventory 68.0% 93.5% 74.8% 26.6% - 92.6% 57.6% - 99.3% 39.1% - 93.2% Switched chemicals, procedures, or 2.9% 0.0% 2.1% technologies 0.3% - 21.4% N/A - N/A 0.2% - 15.5% Sought help from other utilities 9.5% 0.0% 7.0% or mutual aid network (e.g., WARN) 4.1% - 20.5% N/A - N/A 3.7% - 12.9% Coordinated with local or state 0.0% 0.0% 0.0% emergency management agency N/A - N/A N/A - N/A N/A - N/A Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 18 21 39 Sodium Found alternative supplier 0.0% 22.5% 7.4% hydroxide N/A - N/A 2.8% - 74.6% 0.8% - 43.5% Drew down existing inventory 67.5% 88.8% 74.6% 21.4% - 94.1% 47.5% - 98.6% 41.2% - 92.5% Switched chemicals, procedures, or 6.7% 43.9% 19.0% technologies 0.6% - 47.2% 11.6% - 82.4% 4.7% - 52.8% Sought help from other utilities 14.7% 0.0% 9.8% or mutual aid network (e.g., WARN) 3.8% - 42.5% N/A - N/A 4.0% - 22.1% Coordinated with local or state 0.0% 0.0% 0.0% emergency management agency N/A - N/A N/A - N/A N/A - N/A Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 17 34 51 G-20 Table G.4 Page 5 of 6 ------- Table G.4. Question Bl.1.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Sodium Found alternative supplier 29.7% 10.8% 27.9% hypochlorite 7.5% - 68.7% 2.1% - 40.1% 7.6% - 64.6% Drew down existing inventory 47.7% 96.6% 52.5% 18.3% - 78.8% 78.1% - 99.6% 23.4% - 80.0% Switched chemicals, procedures, or 30.2% 7.4% 28.0% technologies 7.8% - 68.8% 0.9% - 40.5% 7.6% - 64.6% Sought help from other utilities 1.3% 0.0% 1.2% or mutual aid network (e.g., WARN) 0.4% - 4.4% N/A - N/A 0.3% - 3.9% Coordinated with local or state 0.2% 0.0% 0.2% emergency management agency 0.0% - 1.7% N/A - N/A 0.0% - 1.4% Other 10.4% 0.0% 9.3% 2.4% - 35.2% N/A - N/A 2.2% - 32.1% Observations 67 78 145 N/A: confidence interval could not be calculated. G-21 Table G.4 Page 6 of 6 ------- Table G.5. Question Bl.2.1: How severe were the personal protective equipment shortages or supply chain disruptions that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All N95 masks Mean score (0 to 3) 0.316 0.734 0.371 and/or 0.267 - 0.366 0.639 - 0.829 0.326 - 0.415 elastomeric No impact (0) 79.8% 54.5% 76.5% respirators 76.9% - 82.5% 49.2% - 59.7% 73.9% - 78.9% Slight (1) 12.7% 24.0% 14.2% 10.5% - 15.3% 20.0% - 28.5% 12.2% - 16.5% Moderate (2) 3.4% 15.2% 5.0% 2.5% - 4.7% 12.0% - 19.1% 4.0% - 6.1% Severe(3) 4.0% 6.3% 4.3% 2.9% - 5.6% 4.5% - 8.9% 3.2% - 5.7% Observations 937 837 1,774 Alternative Mean score (0 to 3) 0.247 0.643 0.299 mask 0.206 - 0.288 0.553 - 0.733 0.260 - 0.337 options No impact (0) 83.1% 54.6% 79.4% (surgical, 80.3% - 85.5% 49.1% - 59.9% 76.9% - 81.7% cloth, etc.) Slight (1) 9.8% 28.3% 12.2% 7.9% - 12.1% 23.6% - 33.5% 10.4% - 14.3% Moderate (2) 6.3% 15.3% 7.5% 4.9% - 8.1% 11.3% - 20.4% 6.1% - 9.2% Severe(3) 0.7% 1.8% 0.9% 0.3% - 1.7% 0.9% - 3.4% 0.5% - 1.6% Observations 937 837 1,774 G-22 Table G.5 Page 1 of 3 ------- Table G.5. Question Bl.2.1: How severe were the personal protective equipment shortages or supply chain disruptions that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Face shield and/or protective eye wear Mean score (0 to 3) 0.164 0.131 - 0.197 0.374 0.304 - 0.443 0.191 0.161 - 0.221 No impact (0) 88.9% 86.6% - 90.8% 72.0% 66.3% - 77.0% 86.7% 84.5% - 88.5% Slight (1) 6.4% 5.0% - 8.2% 19.7% 15.0% - 25.5% 8.1% 6.7% - 9.9% Moderate (2) 4.3% 3.1% - 5.9% 7.2% 5.0% - 10.3% 4.7% 3.6% - 6.1% Severe(3) 0.5% 0.2% - 1.0% 1.0% 0.5% - 2.4% 0.6% 0.3% - 1.0% Observations 937 837 1,774 Nitrile and/or latex gloves Mean score (0 to 3) 0.313 0.267 - 0.360 0.645 0.557 - 0.732 0.356 0.315 - 0.398 No impact (0) 80.0% 77.1% - 82.6% 57.2% 51.9% - 62.4% 77.1% 74.5% - 79.5% Slight (1) 11.3% 9.2% - 13.8% 25.1% 20.7% - 30.0% 13.1% 11.1% - 15.3% Moderate (2) 6.0% 4.7% - 7.7% 13.7% 10.5% - 17.8% 7.0% 5.8% - 8.5% Severe(3) 2.7% 1.8% - 4.0% 4.0% 2.6% - 6.2% 2.8% 2.0% - 4.0% Observations 937 837 1,774 G-23 Table G.5 Page 2 of 3 ------- Table G.5. Question Bl.2.1: How severe were the personal protective equipment shortages or supply chain disruptions that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Tyvek suite Mean score (0 to 3) 0.139 0.241 0.152 and/or 0.104 - 0.174 0.185 - 0.296 0.121 - 0.184 disposable No impact (0) 91.9% 83.2% 90.8% coveralls 90.0% - 93.5% 79.3% - 86.5% 89.1% - 92.3% Slight (1) 4.1% 11.3% 5.0% 3.0% - 5.6% 8.6% - 14.6% 4.0% - 6.4% Moderate (2) 2.1% 3.8% 2.3% 1.4% - 3.1% 2.2% - 6.5% 1.6% - 3.3% Severe(3) 1.9% 1.7% 1.9% 1.1% - 3.1% 1.0% - 2.8% 1.2% - 2.9% Observations 937 837 1,774 Sanitizing Mean score (0 to 3) 0.407 0.938 0.476 wipes, 0.352 - 0.462 0.827 - 1.050 0.426 - 0.526 sprays for No impact (0) 76.6% 46.3% 72.7% cleaning 73.6% - 79.4% 41.0% - 51.7% 70.0% - 75.2% work Slight (1) 10.5% 22.0% 12.0% offices, or 8.5% - 12.9% 18.3% - 26.2% 10.1% - 14.1% gels for Moderate (2) 8.5% 23.3% 10.5% hand 6.9% - 10.5% 18.8% - 28.5% 8.9% - 12.3% sanitizing Severe(3) 4.4% 8.4% 4.9% 3.2% - 6.0% 6.0% - 11.8% 3.8% - 6.3% Observations 937 837 1,774 G-24 Table G.5 Page 3 of 3 ------- Table G.6. Question Bl.2.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All N95 masks Unavailable from 56.1% 53.1% 55.4% and/or supplier(s) 48.4% - 63.6% 45.9% - 60.1% 49.3% - 61.2% elastomeric Delayed / backordered 60.4% 68.2% 62.4% respirators from supplier(s) 52.5% - 67.8% 61.0% - 74.7% 56.2% - 68.2% Transportation / 8.5% 5.1% 7.6% distribution difficulties 4.9% - 14.2% 3.7% - 6.8% 4.9% - 11.8% Price 11.1% 9.3% 10.7% 6.9% - 17.5% 6.3% - 13.6% 7.3% - 15.4% Other 7.6% 3.8% 6.7% 4.2% - 13.4% 2.3% - 6.3% 4.0% - 10.9% Observations 268 441 709 Alternative Unavailable from 20.3% 27.0% 22.2% mask supplier(s) 14.4% - 27.9% 20.7% - 34.5% 17.5% - 27.8% options Delayed / backordered 74.6% 79.7% 76.0% (surgical, from supplier(s) 66.8% - 81.0% 72.5% - 85.4% 70.2% - 81.0% cloth, etc.) Transportation / 11.0% 8.1% 10.2% distribution difficulties 6.7% - 17.7% 4.9% - 13.2% 6.8% - 15.0% Price 4.7% 4.8% 4.7% 2.5% - 8.6% 2.7% - 8.3% 3.0% - 7.5% Other 7.7% 4.3% 6.7% 4.0% - 14.3% 2.3% - 7.7% 3.9% - 11.4% Observations 228 403 631 G-25 Table G.6 Page 1 of 3 ------- Table G.6. Question Bl.2.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Face shield and/or protective eye wear Unavailable from supplier(s) 26.3% 18.5% - 35.9% 27.4% 19.2% - 37.6% 26.6% 20.4% - 33.9% Delayed / backordered from supplier(s) 85.2% 78.9% - 89.9% 67.3% 53.4% - 78.7% 80.3% 73.9% - 85.5% Transportation / distribution difficulties 3.3% 1.4% - 7.4% 4.3% 1.3% - 13.1% 3.6% 1.8% - 6.9% Price 5.5% 2.1% - 14.1% 2.4% 1.3% - 4.5% 4.7% 2.0% - 10.6% Other 0.0% N/A - N/A 0.0% N/A - N/A 0.0% N/A - N/A Observations 169 245 414 Nitrile and/or latex gloves Unavailable from supplier(s) 36.0% 28.9% - 43.8% 29.6% 23.3% - 36.8% 34.4% 28.8% - 40.6% Delayed / backordered from supplier(s) 72.2% 64.7% - 78.6% 85.8% 79.2% - 90.6% 75.5% 69.6% - 80.5% Transportation / distribution difficulties 4.2% 2.3% - 7.6% 5.6% 2.7% - 11.5% 4.5% 2.8% - 7.3% Price 12.9% 8.4% - 19.4% 9.3% 6.5% - 13.1% 12.1% 8.4% - 17.0% Other 0.8% 0.2% - 3.0% 0.5% 0.2% - 1.7% 0.7% 0.2% - 2.2% Observations 274 393 667 G-26 Table G.6 Page 2 of 3 ------- Table G.6. Question Bl.2.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Tyvek suite Unavailable from 39.4% 26.9% 36.4% and/or supplier(s) 28.3% - 51.7% 18.2% - 37.7% 27.6% - 46.2% disposable Delayed / backordered 71.0% 77.6% 72.6% coveralls from supplier(s) 60.0% - 80.0% 65.4% - 86.4% 63.8% - 79.9% Transportation / 21.3% 15.6% 20.0% distribution difficulties 12.7% - 33.5% 8.5% - 26.8% 13.0% - 29.4% Price 18.5% 11.9% 16.9% 10.5% - 30.6% 7.4% - 18.7% 10.5% - 26.2% Other 1.7% 0.6% 1.4% 0.4% - 6.6% 0.1% - 3.9% 0.4% - 5.0% Observations 129 178 307 Sanitizing Unavailable from 52.3% 52.5% 52.4% wipes, supplier(s) 45.2% - 59.3% 45.3% - 59.6% 46.8% - 57.9% sprays for Delayed / backordered 55.7% 67.7% 58.8% cleaning from supplier(s) 48.5% - 62.6% 59.9% - 74.6% 53.1% - 64.2% work Transportation / 2.0% 4.0% 2.5% offices, or distribution difficulties 0.9% - 4.2% 1.9% - 8.4% 1.5% - 4.3% gels for Price 4.9% 7.6% 5.6% hand 2.9% - 8.2% 4.8% - 11.7% 3.8% - 8.1% sanitizing Other 6.3% 2.5% 5.3% 3.4% - 11.3% 1.8% - 3.6% 3.1% - 9.0% Observations 313 492 805 N/A: confidence interval could not be calculated. G-27 Table G.6 Page 3 of 3 ------- Table G.7. Question Bl.2.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All N95 masks Found alternative supplier 35.1% 45.3% 37.7% and/or 28.3% - 42.6% 38.3% - 52.4% 32.2% - 43.5% elastomeric Drew down existing inventory 42.2% 57.6% 46.1% respirators 34.7% - 50.1% 50.4% - 64.4% 40.1% - 52.2% Switched chemicals, procedures, or 12.2% 6.9% 10.9% technologies 7.6% - 18.9% 4.6% - 10.2% 7.3% - 15.9% Sought help from other utilities 7.6% 10.6% 8.4% or mutual aid network (e.g., WARN) 4.6% - 12.5% 7.1% - 15.4% 5.8% - 12.0% Coordinated with local or state 18.6% 21.3% 19.3% emergency management agency 13.5% - 25.1% 16.0% - 27.8% 15.1% - 24.3% Other 10.7% 5.2% 9.3% 6.5% - 17.1% 3.1% - 8.7% 6.1% - 14.1% Observations 268 441 709 Alternative Found alternative supplier 48.3% 58.8% 51.3% mask 40.1% - 56.6% 49.8% - 67.3% 44.8% - 57.7% options Drew down existing inventory 34.8% 35.0% 34.9% (surgical, 27.1% - 43.5% 26.8% - 44.2% 28.8% - 41.5% cloth, etc.) Switched chemicals, procedures, or 12.7% 3.8% 10.1% technologies 8.0% - 19.5% 2.7% - 5.4% 6.7% - 15.1% Sought help from other utilities 9.2% 17.2% 11.5% or mutual aid network (e.g., WARN) 6.1% - 13.5% 12.3% - 23.5% 8.8% - 14.8% Coordinated with local or state 23.8% 29.2% 25.3% emergency management agency 17.5% - 31.4% 21.5% - 38.3% 20.2% - 31.2% Other 2.1% 5.7% 3.1% 0.8% - 5.5% 3.1% - 10.3% 1.8% - 5.5% Observations 228 403 631 G-28 Table G.7 Page 1 of 3 ------- Table G.7. Question Bl.2.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Face shield Found alternative supplier 40.6% 51.9% 43.7% and/or 31.7% - 50.3% 39.5% - 64.1% 36.3% - 51.5% protective Drew down existing inventory 39.3% 37.7% 38.8% eye wear 29.8% - 49.7% 27.8% - 48.8% 31.2% - 47.0% Switched chemicals, procedures, or 2.5% 2.8% 2.6% technologies 0.9% - 6.8% 1.0% - 7.9% 1.2% - 5.6% Sought help from other utilities 4.1% 3.7% 4.0% or mutual aid network (e.g., WARN) 1.9% - 8.4% 1.6% - 8.4% 2.2% - 7.1% Coordinated with local or state 15.4% 7.7% 13.3% emergency management agency 9.5% - 23.9% 4.3% - 13.6% 8.8% - 19.6% Other 3.6% 2.7% 3.4% 0.9% - 13.4% 0.9% - 7.9% 1.1% - 9.8% Observations 169 245 414 Nitrile Found alternative supplier 43.0% 56.7% 46.4% and/or latex 35.8% - 50.6% 48.6% - 64.5% 40.4% - 52.4% gloves Drew down existing inventory 57.5% 63.3% 58.9% 49.7% - 64.9% 54.7% - 71.2% 52.7% - 64.9% Switched chemicals, procedures, or 9.3% 6.1% 8.5% technologies 5.4% - 15.6% 4.1% - 9.0% 5.4% - 13.2% Sought help from other utilities 4.2% 5.7% 4.6% or mutual aid network (e.g., WARN) 2.4% - 7.4% 3.0% - 10.5% 3.0% - 7.1% Coordinated with local or state 8.0% 8.8% 8.2% emergency management agency 4.6% - 13.7% 5.4% - 13.9% 5.3% - 12.4% Other 3.4% 2.7% 3.2% 1.3% - 8.5% 1.7% - 4.4% 1.5% - 6.8% Observations 274 393 667 G-29 Table G.7 Page 2 of 3 ------- Table G.7. Question Bl.2.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Tyvek suite Found alternative supplier 43.7% 51.9% 45.6% and/or 32.7% - 55.3% 40.2% - 63.3% 36.7% - 54.9% disposable Drew down existing inventory 36.5% 52.2% 40.2% coveralls 25.9% - 48.5% 40.6% - 63.5% 31.5% - 49.6% Switched chemicals, procedures, or 21.2% 18.1% 20.5% technologies 12.6% - 33.4% 10.3% - 29.9% 13.4% - 29.9% Sought help from other utilities 5.4% 4.5% 5.2% or mutual aid network (e.g., WARN) 2.6% - 11.0% 1.5% - 12.7% 2.8% - 9.5% Coordinated with local or state 13.8% 2.5% 11.1% emergency management agency 7.2% - 24.9% 1.1% - 5.6% 6.0% - 19.7% Other 19.0% 7.7% 16.3% 10.8% - 31.3% 5.2% - 11.2% 9.9% - 25.8% Observations 129 178 307 Sanitizing Found alternative supplier 54.1% 56.9% 54.8% wipes, 47.0% - 61.1% 49.3% - 64.2% 49.2% - 60.4% sprays for Drew down existing inventory 40.0% 52.2% 43.1% cleaning 33.2% - 47.1% 44.9% - 59.4% 37.7% - 48.7% work Switched chemicals, procedures, or 19.8% 24.6% 21.0% offices, or technologies 14.6% - 26.3% 18.3% - 32.2% 16.7% - 26.1% gels for Sought help from other utilities 5.9% 8.6% 6.6% hand or mutual aid network (e.g., WARN) 3.8% - 9.1% 5.3% - 13.7% 4.7% - 9.2% sanitizing Coordinated with local or state 10.7% 11.1% 10.8% emergency management agency 7.2% - 15.7% 8.0% - 15.2% 7.9% - 14.6% Other 7.7% 8.9% 8.0% 4.5% - 12.9% 4.2% - 17.7% 5.2% - 12.2% Observations 313 492 805 G-30 Table G.7 Page 3 of 3 ------- Table G.8. Question Bl.3.1: How severe were the shortages or supply chain disruptions involving durable goods and other critical equipment that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Filter media Mean score (0 to 3) 0.009 0.026 0.012 0.003 - 0.016 0.007 - 0.045 0.005 - 0.018 No impact (0) 99.2% 98.1% 99.1% 98.3% - 99.6% 96.2% - 99.1% 98.3% - 99.5% Slight (1) 0.7% 1.2% 0.7% 0.3% - 1.6% 0.5% - 2.9% 0.3% - 1.5% Moderate (2) 0.1% 0.7% 0.2% 0.0% - 0.4% 0.2% - 2.2% 0.1% - 0.5% Severe (3) 0.0% 0.0% 0.0% 0.0% - 0.1% N/A - N/A 0.0% - 0.1% Observations 937 842 1,779 Granular/ Mean score (0 to 3) 0.007 0.015 0.008 Powdered 0.001 - 0.012 0.003 - 0.026 0.002 - 0.013 Activated No impact (0) 99.6% 98.7% 99.5% Carbon (GAC/ 99.1% - 99.8% 97.0% - 99.5% 99.1% - 99.7% PAC) Slight (1) 0.2% 1.1% 0.3% 0.1% - 0.6% 0.4% - 2.9% 0.2% - 0.7% Moderate (2) 0.1% 0.2% 0.1% 0.0% - 0.5% 0.1% - 0.5% 0.0% - 0.4% Severe (3) 0.1% 0.0% 0.1% 0.0% - 0.5% N/A - N/A 0.0% - 0.5% Observations 937 842 1,779 G-31 Table G.8 Page 1 of 5 ------- Table G.8. Question Bl.3.1: How severe were the shortages or supply chain disruptions involving durable goods and other critical equipment that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Membrane modules Mean score (0 to 3) 0.007 0.001 - 0.012 0.016 0.003 - 0.029 0.008 0.003 - 0.013 No impact (0) 99.6% 99.1% - 99.8% 98.7% 97.0% - 99.5% 99.5% 99.1% - 99.7% Slight (1) 0.2% 0.1% - 0.6% 1.0% 0.4% - 2.9% 0.3% 0.1% - 0.6% Moderate (2) 0.2% 0.1% - 0.5% 0.1% 0.0% - 0.5% 0.2% 0.1% - 0.5% Severe (3) 0.1% 0.0% - 0.4% 0.1% 0.0% - 0.6% 0.1% 0.0% - 0.3% Observations 937 842 1,779 Pumps Mean score (0 to 3) 0.068 0.048 - 0.089 0.134 0.097 - 0.172 0.077 0.058 - 0.095 No impact (0) 95.1% 93.2% - 96.4% 89.9% 86.9% - 92.4% 94.4% 92.8% - 95.7% Slight (1) 3.3% 2.1% - 5.1% 7.1% 5.1% - 9.8% 3.8% 2.7% - 5.3% Moderate (2) 1.4% 0.9% - 2.1% 2.5% 1.4% - 4.4% 1.5% 1.0% - 2.2% Severe (3) 0.3% 0.1% - 0.8% 0.4% 0.2% - 0.9% 0.3% 0.1% - 0.7% Observations 937 842 1,779 G-32 Table G.8 Page 2 of 5 ------- Table G.8. Question Bl.3.1: How severe were the shortages or supply chain disruptions involving durable goods and other critical equipment that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Motors Mean score (0 to 3) 0.042 0.026 - 0.059 0.115 0.079 - 0.152 0.052 0.037 - 0.067 No impact (0) 97.0% 95.5% - 98.0% 91.1% 87.9% - 93.4% 96.2% 94.9% - 97.2% Slight (1) 2.0% 1.1% - 3.5% 6.7% 4.6% - 9.5% 2.6% 1.7% - 3.8% Moderate (2) 0.9% 0.5% - 1.5% 2.0% 1.0% - 3.9% 1.0% 0.6% - 1.6% Severe (3) 0.2% 0.0% - 0.7% 0.3% 0.1% - 0.7% 0.2% 0.1% - 0.6% Observations 937 842 1,779 Pipes Mean score (0 to 3) 0.066 0.043 - 0.089 0.153 0.104 - 0.203 0.077 0.056 - 0.098 No impact (0) 95.1% 93.2% - 96.5% 88.4% 84.7% - 91.4% 94.2% 92.6% - 95.5% Slight (1) 3.4% 2.3% - 5.1% 8.0% 5.7% - 11.1% 4.0% 3.0% - 5.5% Moderate (2) 1.3% 0.7% - 2.5% 3.4% 1.8% - 6.3% 1.6% 0.9% - 2.6% Severe (3) 0.2% 0.1% - 0.7% 0.2% 0.1% - 0.6% 0.2% 0.1% - 0.6% Observations 937 842 1,779 G-33 Table G.8 Page 3 of 5 ------- Table G.8. Question Bl.3.1: How severe were the shortages or supply chain disruptions involving durable goods and other critical equipment that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Valves Mean score (0 to 3) 0.069 0.043 - 0.096 0.137 0.099 - 0.175 0.078 0.054 - 0.101 No impact (0) 95.6% 93.9% - 96.8% 89.2% 85.9% - 91.8% 94.8% 93.3% - 95.9% Slight (1) 2.5% 1.6% - 3.8% 8.2% 5.9% - 11.2% 3.2% 2.4% - 4.3% Moderate (2) 1.4% 0.7% - 2.6% 2.2% 1.2% - 4.1% 1.5% 0.9% - 2.5% Severe (3) 0.6% 0.2% - 1.6% 0.4% 0.2% - 0.8% 0.5% 0.2% - 1.4% Observations 937 842 1,779 Fuel Mean score (0 to 3) 0.005 0.002 - 0.009 0.017 0.005 - 0.028 0.007 0.003 - 0.010 No impact (0) 99.6% 99.1% - 99.8% 98.4% 96.7% - 99.2% 99.4% 99.0% - 99.6% Slight (1) 0.3% 0.2% - 0.7% 1.6% 0.7% - 3.3% 0.5% 0.3% - 0.9% Moderate (2) 0.1% 0.0% - 0.3% 0.0% 0.0% - 0.2% 0.1% 0.0% - 0.3% Severe (3) Observations 937 842 1,779 G-34 Table G.8 Page 4 of 5 ------- Table G.8. Question Bl.3.1: How severe were the shortages or supply chain disruptions involving durable goods and other critical equipment that you experienced? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Vehicles Mean score (0 to 3) 0.013 0.083 0.022 0.004 - 0.021 0.046 - 0.120 0.013 - 0.030 No impact (0) 99.0% 93.8% 98.4% 98.1% - 99.5% 90.4% - 96.0% 97.5% - 98.9% Slight (1) 0.7% 4.2% 1.1% 0.3% - 1.6% 2.4% - 7.2% 0.7% - 1.9% Moderate (2) 0.3% 2.1% 0.5% 0.1% - 0.8% 1.0% - 4.3% 0.3% - 0.9% Severe (3) 0.0% 0.0% 0.0% 0.0% - 0.1% N/A - N/A 0.0% - 0.1% Observations 937 842 1,779 N/A: confidence interval could not be calculated. G-35 Table G.8 Page 5 of 5 ------- Table G.9. Question Bl.3.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Filter media Unavailable from 20.0% 11.9% 17.8% supplier(s) 4.1% - 59.2% 3.5% - 33.2% 5.0% - 47.2% Delayed / backordered 45.4% 73.4% 52.8% from supplier(s) 20.2% - 73.2% 51.2% - 87.9% 32.8% - 72.0% Transportation / 48.9% 6.8% 37.8% distribution difficulties 38.7% - 59.1% 2.8% - 15.6% 33.7% - 41.9% Price 0.0% 9.8% 2.6% N/A - N/A 5.6% - 16.3% 2.6% - 2.6% Other 2.8% 0.0% 2.1% 0.9% - 9.0% N/A - N/A 0.6% - 6.6% Observations 19 16 35 Granular/ Unavailable from 20.7% 14.1% 18.6% Powdered supplier(s) 2.2% - 75.5% 3.2% - 44.4% 3.5% - 59.0% Activated Delayed / backordered 51.7% 78.6% 60.2% Carbon (GAC/ from supplier(s) 35.3% - 67.7% 52.4% - 92.5% 54.5% - 65.7% PAC) Transportation / 4.8% 17.4% 8.8% distribution difficulties 1.0% - 20.1% 5.0% - 45.9% 3.7% - 19.7% Price 2.7% 0.0% 1.9% 0.3% - 19.9% N/A - N/A 0.2% - 13.9% Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 14 11 25 G-36 Table G.9 Page 1 of 5 ------- Table G.9. Question Bl.3.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Membrane modules Unavailable from supplier(s) 3.2% 0.8% - 12.6% 3.4% 0.3% - 27.0% 3.3% 1.0% - 10.0% Delayed / backordered from supplier(s) 55.5% 29.8% - 78.5% 75.3% 43.0% - 92.4% 61.8% 38.6% - 80.6% Transportation / distribution difficulties 24.7% 15.0% - 38.0% 48.5% 9.0% - 90.0% 32.3% 14.6% - 57.1% Price 0.0% N/A - N/A 0.0% N/A - N/A 0.0% N/A - N/A Other 0.0% N/A - N/A 3.4% 0.3% - 27.0% 1.1% 0.1% - 8.7% Observations 15 10 25 Pumps Unavailable from supplier(s) 6.4% 2.5% - 15.2% 6.3% 3.2% - 12.0% 6.4% 3.1% - 12.7% Delayed / backordered from supplier(s) 89.1% 71.4% - 96.4% 95.9% 91.0% - 98.2% 90.7% 77.3% - 96.6% Transportation / distribution difficulties 13.3% 5.1% - 30.4% 15.4% 8.4% - 26.7% 13.8% 6.7% - 26.2% Price 3.5% 1.0% - 11.2% 2.3% 0.8% - 6.4% 3.2% 1.1% - 8.6% Other 0.5% 0.1% - 2.0% 0.9% 0.2% - 3.5% 0.6% 0.2% - 1.7% Observations 69 108 177 G-37 Table G.9 Page 2 of 5 ------- Table G.9. Question Bl.3.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Motors Unavailable from 5.0% 11.4% 7.0% supplier(s) 1.7% - 13.8% 4.7% - 25.0% 3.5% - 13.4% Delayed / backordered 92.2% 95.3% 93.1% from supplier(s) 82.0% - 96.8% 89.4% - 98.0% 86.4% - 96.7% Transportation / 8.2% 22.3% 12.5% distribution difficulties 3.5% - 18.2% 12.0% - 37.5% 7.6% - 20.1% Price 0.5% 1.0% 0.6% 0.1% - 3.3% 0.2% - 4.0% 0.2% - 2.1% Other 0.4% 0.5% 0.4% 0.1% - 2.5% 0.1% - 3.6% 0.1% - 1.7% Observations 47 89 136 Pipes Unavailable from 12.3% 13.6% 12.6% supplier(s) 4.4% - 30.1% 5.8% - 28.7% 5.8% - 25.3% Delayed / backordered 82.4% 84.1% 82.8% from supplier(s) 65.4% - 92.0% 65.2% - 93.7% 70.1% - 90.8% Transportation / 10.0% 18.9% 12.3% distribution difficulties 3.0% - 28.6% 8.6% - 36.6% 5.6% - 25.0% Price 7.3% 5.4% 6.8% 2.8% - 17.8% 1.4% - 18.0% 3.0% - 14.6% Other 0.2% 0.0% 0.2% 0.0% - 1.5% N/A - N/A 0.0% - 1.1% Observations 66 99 165 G-38 Table G.9 Page 3 of 5 ------- Table G.9. Question Bl.3.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Valves Unavailable from 13.4% 7.7% 11.9% supplier(s) 4.6% - 33.1% 2.8% - 19.7% 4.9% - 26.1% Delayed / backordered 83.4% 97.8% 87.3% from supplier(s) 64.4% - 93.3% 93.1% - 99.3% 72.9% - 94.6% Transportation / 8.5% 16.9% 10.7% distribution difficulties 3.7% - 18.3% 8.7% - 30.1% 6.2% - 17.9% Price 6.6% 4.9% 6.1% 2.2% - 18.4% 1.1% - 19.3% 2.4% - 14.8% Other 0.3% 0.4% 0.3% 0.0% - 1.7% 0.1% - 2.9% 0.1% - 1.2% Observations 63 110 173 Fuel Unavailable from 2.2% 0.0% 1.4% supplier(s) 0.3% - 15.9% N/A - N/A 0.2% - 10.3% Delayed / backordered 22.0% 41.7% 29.0% from supplier(s) 3.0% - 71.9% 10.6% - 81.2% 8.5% - 64.3% Transportation / 53.7% 49.9% 52.3% distribution difficulties 15.5% - 88.0% 14.7% - 85.1% 22.3% - 80.8% Price 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Other 5.8% 0.0% 3.7% 1.3% - 22.8% N/A - N/A 0.8% - 15.3% Observations 16 13 29 G-39 Table G.9 Page 4 of 5 ------- Table G.9. Question Bl.3.2: What contributed to each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Vehicles Unavailable from 1.0% 20.9% 10.9% supplier(s) 0.1% - 7.2% 7.4% - 46.6% 4.1% - 25.6% Delayed / backordered 75.1% 88.8% 81.9% from supplier(s) 46.9% - 91.1% 67.7% - 96.7% 63.5% - 92.1% Transportation / 2.4% 10.7% 6.5% distribution difficulties 0.9% - 6.6% 2.9% - 32.5% 2.3% - 17.3% Price 11.0% 0.0% 5.5% 1.4% - 51.7% N/A - N/A 0.7% - 33.0% Other 2.2% 1.4% 1.8% 0.5% - 8.9% 0.3% - 5.9% 0.6% - 5.0% Observations 19 41 60 N/A: confidence interval could not be calculated. G-40 Table G.9 Page 5 of 5 ------- Table G.10. Question Bl.3.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Filter media Found alternative supplier 10.2% 24.3% 13.9% 2.2% - 36.1% 10.8% - 46.0% 5.6% - 30.4% Drew down existing inventory 43.3% 73.2% 51.2% 34.2% - 52.8% 52.1% - 87.3% 37.0% - 65.1% Switched chemicals, 0.0% 2.4% 0.6% procedures, or technologies N/A - N/A 0.3% - 18.3% 0.1% - 4.9% Sought help from other utilities 5.5% 0.0% 4.0% or mutual aid network (e.g., WARN) 2.1% - 13.5% N/A - N/A 1.6% - 10.0% Coordinated with local or state 1.1% 0.0% 0.8% emergency management agency 0.1% - 7.7% N/A - N/A 0.1% - 5.7% Other 44.1% 2.3% 33.0% 31.9% - 57.0% 0.3% - 16.9% 22.6% - 45.5% Observations 19 16 35 Granular/ Found alternative supplier 2.7% 14.3% 6.4% Powdered 0.3% - 19.9% 3.1% - 46.5% 2.0% - 18.4% Activated Drew down existing inventory 73.3% 89.6% 78.5% Carbon (GAC/ 44.5% - 90.3% 67.2% - 97.3% 49.6% - 93.1% PAC) Switched chemicals, 1.6% 0.0% 1.1% procedures, or technologies 0.2% - 11.9% N/A - N/A 0.1% - 8.4% Sought help from other utilities 2.7% 0.0% 1.9% or mutual aid network (e.g., WARN) 0.3% - 19.9% N/A - N/A 0.2% - 13.9% Coordinated with local or state 2.1% 0.0% 1.4% emergency management agency 0.2% - 15.5% N/A - N/A 0.2% - 10.7% Other 14.2% 6.7% 11.8% 1.9% - 58.3% 1.5% - 25.1% 1.8% - 49.7% Observations 14 11 25 G-41 Table G.10 Page 1 of 5 ------- Table G.10. Question Bl.3.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Membrane Found alternative supplier 27.1% 6.7% 20.6% modules 17.2% - 39.9% 1.5% - 25.7% 16.2% - 25.8% Drew down existing inventory 39.6% 75.0% 50.9% 25.5% - 55.7% 42.3% - 92.5% 27.4% - 74.0% Switched chemicals, 0.0% 0.0% 0.0% procedures, or technologies N/A - N/A N/A - N/A N/A - N/A Sought help from other utilities 2.8% 7.3% 4.2% or mutual aid network (e.g., WARN) 0.3% - 20.6% 0.7% - 47.1% 0.9% - 17.8% Coordinated with local or state 0.0% 0.0% 0.0% emergency management agency N/A - N/A N/A - N/A N/A - N/A Other 15.4% 18.0% 16.2% 2.1% - 61.0% 4.5% - 50.8% 3.7% - 49.3% Observations 15 10 25 Pumps Found alternative supplier 43.1% 26.7% 39.2% 27.9% - 59.6% 16.1% - 40.7% 27.3% - 52.5% Drew down existing inventory 22.0% 44.5% 27.3% 13.7% - 33.4% 30.6% - 59.3% 19.6% - 36.6% Switched chemicals, 3.0% 6.6% 3.9% procedures, or technologies 0.8% - 10.5% 1.9% - 20.4% 1.6% - 9.3% Sought help from other utilities 5.8% 3.9% 5.4% or mutual aid network (e.g., WARN) 2.0% - 16.0% 0.5% - 23.1% 2.1% - 13.3% Coordinated with local or state 0.3% 0.0% 0.2% emergency management agency 0.1% - 1.2% N/A - N/A 0.1% - 0.9% Other 28.5% 26.4% 28.1% 15.3% - 46.9% 18.6% - 36.1% 17.3% - 42.1% Observations 69 108 177 G-42 Table G.10 Page 2 of 5 ------- Table G.10. Question Bl.3.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Motors Found alternative supplier 41.0% 31.0% 37.9% 23.3% - 61.3% 18.5% - 47.1% 24.9% - 53.0% Drew down existing inventory 23.3% 50.6% 31.7% 13.0% - 38.1% 35.0% - 66.1% 22.2% - 43.1% Switched chemicals, 0.8% 6.4% 2.5% procedures, or technologies 0.2% - 3.2% 1.6% - 23.0% 0.8% - 7.6% Sought help from other utilities 4.5% 4.3% 4.4% or mutual aid network (e.g., WARN) 0.9% - 19.3% 0.6% - 25.9% 1.2% - 14.6% Coordinated with local or state 0.5% 0.0% 0.4% emergency management agency 0.2% - 1.5% N/A - N/A 0.1% - 1.0% Other 28.0% 20.8% 25.8% 12.0% - 52.5% 13.9% - 29.8% 13.7% - 43.1% Observations 47 89 136 Pipes Found alternative supplier 25.2% 22.7% 24.6% 12.7% - 44.0% 11.3% - 40.4% 14.3% - 38.9% Drew down existing inventory 62.0% 64.7% 62.7% 43.7% - 77.5% 48.5% - 78.1% 48.5% - 75.1% Switched chemicals, 1.4% 3.7% 2.0% procedures, or technologies 0.2% - 7.3% 0.6% - 19.6% 0.6% - 6.6% Sought help from other utilities 4.2% 5.0% 4.4% or mutual aid network (e.g., WARN) 1.3% - 12.8% 1.2% - 18.2% 1.7% - 10.7% Coordinated with local or state 0.1% 0.0% 0.1% emergency management agency 0.0% - 1.0% N/A - N/A 0.0% - 0.7% Other 19.4% 17.1% 18.8% 9.2% - 36.4% 10.1% - 27.5% 10.6% - 31.3% Observations 66 99 165 G-43 Table G.10 Page 3 of 5 ------- Table G.10. Question Bl.3.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Valves Found alternative supplier 32.0% 26.1% 30.4% 18.4% - 49.6% 15.7% - 40.2% 19.7% - 43.8% Drew down existing inventory 65.7% 65.1% 65.5% 49.0% - 79.2% 51.4% - 76.7% 53.0% - 76.2% Switched chemicals, 1.3% 0.9% 1.2% procedures, or technologies 0.2% - 8.9% 0.1% - 6.0% 0.2% - 6.0% Sought help from other utilities 6.0% 4.5% 5.6% or mutual aid network (e.g., WARN) 2.2% - 15.4% 0.9% - 19.8% 2.4% - 12.7% Coordinated with local or state 0.2% 0.0% 0.1% emergency management agency 0.0% - 1.1% N/A - N/A 0.0% - 0.8% Other 19.9% 22.7% 20.7% 11.5% - 32.2% 14.5% - 33.7% 13.8% - 29.8% Observations 63 110 173 Fuel Found alternative supplier 34.8% 11.6% 26.6% 6.8% - 79.5% 2.4% - 41.3% 7.1% - 63.2% Drew down existing inventory 38.3% 77.2% 52.1% 16.3% - 66.5% 47.9% - 92.6% 33.4% - 70.3% Switched chemicals, 2.2% 0.0% 1.4% procedures, or technologies 0.3% - 15.9% N/A - N/A 0.2% - 10.3% Sought help from other utilities 4.8% 0.0% 3.1% or mutual aid network (e.g., WARN) 1.0% - 19.6% N/A - N/A 0.7% - 12.6% Coordinated with local or state 0.0% 0.0% 0.0% emergency management agency N/A - N/A N/A - N/A N/A - N/A Other 5.8% 11.2% 7.7% 1.3% - 22.8% 2.7% - 36.0% 3.0% - 18.2% Observations 16 13 29 G-44 Table G.10 Page 4 of 5 ------- Table G.10. Question Bl.3.3: How did you address each shortage or supply chain disruption? (select all that apply) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Vehicles Found alternative supplier 19.0% 20.1% 19.5% 4.1% - 56.4% 6.9% - 46.0% 7.6% - 41.7% Drew down existing inventory 20.8% 53.8% 37.1% 6.1% - 51.7% 31.4% - 74.7% 22.5% - 54.6% Switched chemicals, 1.0% 8.2% 4.6% procedures, or technologies 0.1% - 7.2% 4.0% - 15.9% 2.5% - 8.2% Sought help from other utilities 1.2% 0.0% 0.6% or mutual aid network (e.g., WARN) 0.2% - 8.4% N/A - N/A 0.1% - 4.2% Coordinated with local or state 0.0% 0.0% 0.0% emergency management agency N/A - N/A N/A - N/A N/A - N/A Other 44.3% 26.5% 35.5% 24.2% - 66.5% 12.3% - 47.9% 23.6% - 49.4% Observations 19 40 59 N/A: confidence interval could not be calculated. G-45 Table G.10 Page 5 of 5 ------- Table G.ll. Question B2.1: What kinds of shortages or supply chain disruptions are you most concerned about from present day through December 2020? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Chain Issue Percentage Reporting by Population Served < 10,000 > 10,000 All Treatment Chemicals 10.3% 8.2% - 12.9% 21.2% 17.4% - 25.5% 11.7% 9.8% - 13.9% PPE 17.1% 14.5% - 20.0% 33.6% 29.1% - 38.5% 19.2% 16.9% - 21.8% Durable Goods and Other Equipment and Supplies 16.8% 14.1% - 19.9% 25.1% 20.9% - 29.8% 17.9% 15.4% - 20.6% None 70.2% 66.6% - 73.6% 47.5% 42.3% - 52.8% 67.3% 64.1% - 70.4% Observations 925 830 1,755 G-46 Table G.11 Page 1 of 1 ------- Table G.12. Question B2.1.1: How severe are your concerns about treatment chemical shortages or supply chain disruptions? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Carbon dioxide Mean score (0 to 3) 0.012 0.005 - 0.020 0.051 0.019 - 0.082 0.017 0.010 - 0.025 None (0) 99.0% 98.0% - 99.5% 97.0% 94.7% - 98.3% 98.7% 97.9% - 99.2% Slight (1) 0.8% 0.4% - 1.8% 1.5% 0.6% - 3.7% 0.9% 0.5% - 1.7% Moderate (2) 0.2% 0.1% - 0.5% 0.8% 0.3% - 2.2% 0.3% 0.1% - 0.6% Severe (3) 0.0% 0.0% - 0.1% 0.6% 0.2% - 2.2% 0.1% 0.0% - 0.3% Observations 924 829 1,753 Ferric chloride Mean score (0 to 3) 0.011 0.005 - 0.017 0.041 0.020 - 0.062 0.015 0.009 - 0.021 None (0) 99.2% 98.6% - 99.6% 97.5% 95.9% - 98.5% 99.0% 98.5% - 99.4% Slight (1) 0.5% 0.3% - 1.1% 1.2% 0.6% - 2.5% 0.6% 0.4% - 1.1% Moderate (2) 0.1% 0.0% - 0.4% 0.9% 0.3% - 2.3% 0.2% 0.1% - 0.5% Severe (3) 0.1% 0.0% - 0.3% 0.4% 0.2% - 0.8% 0.1% 0.0% - 0.3% Observations 924 829 1,753 G-47 Table G.12 Page 1 of 6 ------- Table G.12. Question B2.1.1: How severe are your concerns about treatment chemical shortages or supply chain disruptions? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Fluoride Mean score (0 to 3) 0.016 0.007 - 0.025 0.074 0.040 - 0.108 0.024 0.015 - 0.033 None (0) 98.6% 97.6% - 99.2% 94.2% 91.1% - 96.2% 98.1% 97.2% - 98.7% Slight (1) 1.2% 0.6% - 2.2% 4.2% 2.5% - 7.0% 1.5% 1.0% - 2.4% Moderate (2) 0.1% 0.0% - 0.5% 1.6% 0.7% - 3.7% 0.3% 0.2% - 0.7% Severe (3) 0.1% 0.0% - 0.4% 0.0% N/A - N/A 0.1% 0.0% - 0.4% Observations 924 829 1,753 Gaseous chlorine Mean score (0 to 3) 0.029 0.017 - 0.042 0.203 0.128 - 0.278 0.052 0.037 - 0.066 None (0) 97.7% 96.5% - 98.5% 90.5% 86.8% - 93.2% 96.8% 95.7% - 97.6% Slight (1) 1.8% 1.0% - 3.0% 3.4% 1.9% - 5.9% 2.0% 1.3% - 3.0% Moderate (2) 0.4% 0.2% - 0.9% 1.5% 0.6% - 3.7% 0.5% 0.3% - 1.0% Severe (3) 0.1% 0.0% - 0.5% 4.6% 2.8% - 7.5% 0.7% 0.4% - 1.1% Observations 924 829 1,753 G-48 Table G.12 Page 2 of 6 ------- Table G.12. Question B2.1.1: How severe are your concerns about treatment chemical shortages or supply chain disruptions? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Liquid Mean score (0 to 3) 0.006 0.006 0.006 oxygen 0.002 - 0.011 0.002 - 0.010 0.002 - 0.010 None (0) 99.5% 99.7% 99.5% 99.0% - 99.8% 99.4% - 99.8% 99.1% - 99.8% Slight (1) 0.3% 0.1% 0.3% 0.1% - 0.9% 0.0% - 0.3% 0.1% - 0.8% Moderate (2) 0.1% 0.2% 0.1% 0.0% - 0.5% 0.1% - 0.4% 0.0% - 0.4% Severe (3) 0.0% 0.0% 0.0% 0.0% - 0.0% 0.0% - 0.3% 0.0% - 0.0% Observations 924 829 1,753 Lime Mean score (0 to 3) 0.012 0.069 0.019 0.005 - 0.018 0.026 - 0.111 0.011 - 0.027 None (0) 99.1% 96.9% 98.8% 98.4% - 99.5% 94.6% - 98.2% 98.2% - 99.2% Slight (1) 0.7% 0.5% 0.6% 0.4% - 1.2% 0.3% - 0.9% 0.4% - 1.1% Moderate (2) 0.2% 1.6% 0.4% 0.1% - 0.7% 0.7% - 3.7% 0.2% - 0.8% Severe (3) 0.0% 1.1% 0.1% 0.0% - 0.1% 0.4% - 3.0% 0.1% - 0.4% Observations 924 829 1,753 G-49 Table G.12 Page 3 of 6 ------- Table G.12. Question B2.1.1: How severe are your concerns about treatment chemical shortages or supply chain disruptions? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Orthophosphate Mean score (0 to 3) 0.014 0.005 - 0.023 0.078 0.039 - 0.118 0.022 0.013 - 0.031 None (0) 98.9% 97.9% - 99.4% 94.8% 91.8% - 96.7% 98.4% 97.5% - 98.9% Slight (1) 0.8% 0.4% - 1.8% 3.1% 1.7% - 5.7% 1.1% 0.7% - 1.9% Moderate (2) 0.2% 0.1% - 0.7% 1.6% 0.7% - 3.7% 0.4% 0.2% - 0.8% Severe (3) 0.1% 0.0% - 0.4% 0.5% 0.1% - 2.4% 0.1% 0.0% - 0.4% Observations 924 829 1,753 Polymers Mean score (0 to 3) 0.027 0.016 - 0.037 0.163 0.111 - 0.216 0.044 0.032 - 0.056 None (0) 98.1% 97.0% - 98.8% 90.8% 87.6% - 93.2% 97.1% 96.2% - 97.8% Slight (1) 1.4% 0.8% - 2.4% 4.1% 2.6% - 6.4% 1.7% 1.1% - 2.6% Moderate (2) 0.4% 0.2% - 0.9% 3.1% 1.8% - 5.5% 0.8% 0.5% - 1.2% Severe (3) 0.1% 0.0% - 0.4% 2.0% 1.1% - 3.6% 0.4% 0.2% - 0.7% Observations 924 829 1,753 G-50 Table G.12 Page 4 of 6 ------- Table G.12. Question B2.1.1: How severe are your concerns about treatment chemical shortages or supply chain disruptions? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Potassium Mean score (0 to 3) 0.014 0.025 0.015 permanganate 0.006 - 0.021 0.011 - 0.038 0.008 - 0.022 None (0) 98.9% 98.2% 98.8% 98.2% - 99.4% 96.6% - 99.1% 98.2% - 99.2% Slight (1) 0.8% 1.3% 0.9% 0.4% - 1.5% 0.6% - 3.1% 0.5% - 1.5% Moderate (2) 0.3% 0.3% 0.3% 0.1% - 0.8% 0.1% - 0.6% 0.1% - 0.7% Severe (3) 0.0% 0.2% 0.0% N/A - N/A 0.1% - 0.6% 0.0% - 0.1% Observations 924 829 1,753 Sodium Mean score (0 to 3) 0.012 0.068 0.019 hydroxide 0.004 - 0.020 0.034 - 0.101 0.011 - 0.027 None (0) 99.0% 95.8% 98.6% 98.1% - 99.5% 93.3% - 97.4% 97.8% - 99.1% Slight (1) 0.8% 2.2% 1.0% 0.4% - 1.8% 1.1% - 4.5% 0.5% - 1.8% Moderate (2) 0.1% 1.4% 0.3% 0.0% - 0.3% 0.7% - 2.7% 0.1% - 0.5% Severe (3) 0.1% 0.6% 0.1% 0.0% - 0.4% 0.2% - 2.2% 0.0% - 0.4% Observations 924 829 1,753 G-51 Table G.12 Page 5 of 6 ------- Table G.12. Question B2.1.1: How severe are your concerns about treatment chemical shortages or supply chain disruptions? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Sodium Mean score (0 to 3) 0.086 0.134 0.092 hypochlorite 0.058 - 0.115 0.090 - 0.178 0.067 - 0.118 None (0) 94.0% 91.7% 93.7% 91.8% - 95.6% 88.8% - 94.0% 91.8% - 95.1% Slight (1) 3.8% 4.8% 3.9% 2.5% - 5.5% 3.1% - 7.4% 2.8% - 5.4% Moderate (2) 2.0% 1.8% 2.0% 1.1% - 3.6% 1.1% - 3.0% 1.2% - 3.3% Severe (3) 0.3% 1.6% 0.5% 0.1% - 0.8% 0.8% - 3.3% 0.2% - 0.9% Observations 924 829 1,753 N/A: confidence interval could not be calculated. G-52 Table G.12 Page 6 of 6 ------- Table G.13. Question B2.1.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Carbon Unavailable from 16.1% 59.1% 29.0% dioxide supplier(s) 3.2% - 53.1% 27.6% - 84.6% 13.2% - 52.3% Delayed / backordered 33.7% 18.9% 29.3% from supplier(s) 15.9% - 57.8% 9.8% - 33.4% 15.0% - 49.3% Transportation / 7.4% 39.4% 17.0% distribution difficulties 1.5% - 29.7% 14.4% - 71.5% 7.6% - 33.9% Price 7.6% 31.4% 14.7% 0.9% - 43.0% 9.3% - 67.0% 4.8% - 37.3% Other 0.0% 19.2% 17.2% N/A - N/A 2.0% - 73.5% 2.1% - 66.6% Observations 15 25 40 Ferric Unavailable from 29.1% 40.8% 32.9% chloride supplier(s) 14.3% - 50.2% 17.2% - 69.6% 19.4% - 49.8% Delayed / backordered 64.5% 45.2% 58.3% from supplier(s) 37.2% - 84.7% 24.4% - 67.8% 37.2% - 76.7% Transportation / 9.9% 40.6% 19.8% distribution difficulties 2.0% - 37.5% 17.0% - 69.5% 9.1% - 37.9% Price 17.7% 1.8% 12.6% 3.6% - 55.1% 0.2% - 12.6% 2.9% - 41.3% Other 0.0% 100.0% 61.2% N/A - N/A N/A - N/A 11.9% - 94.9% Observations 16 30 46 G-53 Table G.13 Page 1 of 6 ------- Table G.13. Question B2.1.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Fluoride Unavailable from 22.2% 30.4% 25.3% supplier(s) 7.3% - 50.7% 13.7% - 54.6% 12.8% - 44.0% Delayed / backordered 54.4% 54.3% 54.4% from supplier(s) 30.8% - 76.2% 31.2% - 75.7% 36.9% - 70.8% Transportation / 22.0% 26.8% 23.9% distribution difficulties 8.1% - 47.4% 12.3% - 49.0% 12.5% - 40.8% Price 14.4% 22.2% 17.4% 4.4% - 37.9% 7.7% - 49.3% 8.0% - 33.6% Other 0.0% 100.0% 87.3% N/A - N/A N/A - N/A 29.0% - 99.1% Observations 18 40 58 Gaseous Unavailable from 32.6% 38.4% 34.8% chlorine supplier(s) 12.1% - 62.9% 22.5% - 57.2% 19.1% - 54.6% Delayed / backordered 53.4% 57.5% 55.0% from supplier(s) 26.9% - 78.1% 39.1% - 74.1% 36.3% - 72.3% Transportation / 17.3% 42.8% 27.0% distribution difficulties 7.3% - 35.6% 26.4% - 61.1% 17.4% - 39.4% Price 3.7% 13.0% 7.2% 0.6% - 20.5% 4.4% - 32.9% 2.8% - 17.6% Other 0.0% 10.6% 9.4% N/A - N/A 0.7% - 66.2% 0.7% - 59.3% Observations 34 55 89 G-54 Table G.13 Page 2 of 6 ------- Table G.13. Question B2.1.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Liquid Unavailable from 34.9% 27.9% 34.2% oxygen supplier(s) 13.4% - 64.9% 5.1% - 73.5% 14.2% - 62.2% Delayed / backordered 43.7% 41.9% 43.5% from supplier(s) 10.5% - 83.7% 11.8% - 79.5% 12.0% - 81.3% Transportation / 3.6% 27.9% 5.8% distribution difficulties 3.5% - 3.7% 5.1% - 73.5% 3.2% - 10.3% Price 17.9% 14.0% 17.5% 1.7% - 73.2% 1.1% - 69.5% 2.0% - 69.0% Other 0.0% 100.0% 45.0% N/A - N/A N/A - N/A 8.0% - 88.5% Observations 10 7 17 Lime Unavailable from 27.8% 40.7% 32.1% supplier(s) 7.2% - 65.7% 16.2% - 70.9% 13.6% - 58.7% Delayed / backordered 55.3% 45.1% 51.9% from supplier(s) 23.9% - 83.0% 19.2% - 73.9% 28.3% - 74.6% Transportation / 7.4% 61.0% 25.5% distribution difficulties 1.2% - 34.7% 30.2% - 85.0% 13.4% - 43.2% Price 8.5% 14.2% 10.4% 1.0% - 46.6% 2.1% - 55.4% 2.4% - 35.4% Other 100.0% 10.6% 20.9% N/A - N/A 0.7% - 67.5% 2.2% - 76.0% Observations 17 28 45 G-55 Table G.13 Page 3 of 6 ------- Table G.13. Question B2.1.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Orthophosphate Unavailable from 25.0% 42.7% 32.3% supplier(s) 15.8% - 37.1% 20.8% - 67.9% 20.8% - 46.5% Delayed / backordered 54.1% 35.6% 46.4% from supplier(s) 33.9% - 73.1% 16.5% - 60.7% 31.3% - 62.2% Transportation / 12.4% 51.9% 28.8% distribution difficulties 3.8% - 33.9% 27.9% - 75.0% 17.3% - 43.9% Price 12.6% 24.7% 17.6% 2.8% - 42.1% 8.6% - 53.4% 7.4% - 36.5% Other 0.0% 10.6% 9.4% N/A - N/A 0.7% - 67.1% 0.7% - 60.2% Observations 16 36 52 Polymers Unavailable from 49.0% 29.4% 40.9% supplier(s) 30.7% - 67.5% 17.2% - 45.6% 29.0% - 54.0% Delayed / backordered 57.9% 63.5% 60.2% from supplier(s) 39.7% - 74.2% 46.5% - 77.7% 47.4% - 71.8% Transportation / 16.1% 38.7% 25.4% distribution difficulties 6.0% - 36.4% 25.3% - 54.1% 16.3% - 37.3% Price 8.5% 12.2% 10.0% 2.3% - 26.6% 4.4% - 29.6% 4.4% - 21.3% Other 0.0% 18.6% 14.2% N/A - N/A 2.0% - 71.9% 2.1% - 55.6% Observations 39 81 120 G-56 Table G.13 Page 4 of 6 ------- Table G.13. Question B2.1.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Potassium Unavailable from 9.8% 15.8% 11.0% permanganate supplier(s) 1.1% - 51.4% 5.7% - 36.6% 2.3% - 39.5% Delayed / backordered 64.9% 86.9% 69.2% from supplier(s) 33.5% - 87.1% 68.6% - 95.3% 42.2% - 87.4% Transportation / 11.4% 29.1% 14.9% distribution difficulties 1.7% - 48.6% 11.9% - 55.5% 4.6% - 39.0% Price 17.0% 2.5% 14.1% 3.4% - 54.6% 0.3% - 18.2% 3.1% - 46.1% Other 62.4% 8.6% - 96.7% 62.4% 8.6% - 96.7% Observations 18 21 39 Sodium Unavailable from 25.1% 39.4% 30.7% hydroxide supplier(s) 10.4% - 49.2% 18.7% - 64.9% 17.5% - 48.0% Delayed / backordered 65.6% 66.3% 65.9% from supplier(s) 42.2% - 83.2% 39.5% - 85.6% 48.3% - 80.0% Transportation / 16.6% 52.5% 30.6% distribution difficulties 4.5% - 45.7% 27.9% - 75.9% 17.0% - 48.8% Price 8.0% 17.4% 11.7% 0.9% - 44.2% 5.1% - 45.4% 3.7% - 31.2% Other 62.4% 100.0% 71.2% 8.9% - 96.6% N/A - N/A 16.9% - 96.8% Observations 17 36 53 G-57 Table G.13 Page 5 of 6 ------- Table G.13. Question B2.1.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Sodium Unavailable from 31.8% 32.9% 32.0% hypochlorite supplier(s) 18.4% - 49.0% 19.5% - 49.9% 20.3% - 46.4% Delayed / backordered 72.7% 67.5% 71.9% from supplier(s) 56.4% - 84.6% 49.7% - 81.4% 58.2% - 82.4% Transportation / 19.9% 42.9% 23.8% distribution difficulties 9.6% - 36.9% 27.6% - 59.6% 14.0% - 37.3% Price 15.9% 8.2% 14.6% 6.7% - 33.3% 2.4% - 24.8% 6.6% - 29.1% Other 0.0% 100.0% 37.3% N/A - N/A N/A - N/A 7.5% - 81.2% Observations 66 80 146 N/A: confidence interval could not be calculated. G-58 Table G.13 Page 6 of 6 ------- Table G.14. Question B2.1.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Carbon Seek alternative supplier 30.3% 48.8% 35.8% dioxide 9.5% - 64.1% 20.7% - 77.7% 17.0% - 60.3% Increase purchasing / maintain a 19.3% 60.6% 31.7% larger than typical inventory 7.7% - 40.7% 28.5% - 85.6% 19.2% - 47.5% Switch chemicals, procedures, or 5.8% 0.0% 4.0% technologies 0.7% - 33.6% N/A - N/A 0.5% - 26.1% Make arrangements with neighboring 9.5% 18.1% 12.1% utilities or mutual aid network 1.7% - 39.4% 3.7% - 56.3% 3.7% - 33.3% Other 100.0% 26.3% 68.3% N/A - N/A 3.4% - 78.1% 13.0% - 96.9% Observations 15 25 40 Ferric Seek alternative supplier 42.6% 42.4% 42.6% chloride 18.9% - 70.4% 18.4% - 70.7% 23.5% - 64.2% Increase purchasing / maintain a 44.0% 53.8% 47.2% larger than typical inventory 21.1% - 69.7% 26.7% - 78.9% 28.5% - 66.6% Switch chemicals, procedures, or 7.7% 3.6% 6.3% technologies 1.0% - 41.6% 0.8% - 13.7% 1.1% - 28.9% Make arrangements with neighboring 12.6% 17.9% 14.3% utilities or mutual aid network 2.2% - 48.5% 3.0% - 60.6% 3.9% - 41.0% Other 100.0% N/A - N/A 100.0% N/A - N/A Observations 16 30 46 G-59 Table G.14 Page 1 of 6 ------- Table G.14. Question B2.1.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Fluoride Seek alternative supplier 22.8% 45.7% 31.6% 7.7% - 51.1% 24.3% - 68.8% 17.7% - 49.9% Increase purchasing / maintain a 58.6% 46.5% 53.9% larger than typical inventory 34.0% - 79.5% 25.0% - 69.4% 36.5% - 70.4% Switch chemicals, procedures, or 0.0% 0.8% 0.3% technologies N/A - N/A 0.1% - 5.9% 0.0% - 2.3% Make arrangements with neighboring 15.0% 17.8% 16.1% utilities or mutual aid network 3.6% - 45.2% 5.8% - 43.4% 6.3% - 35.2% Other 55.3% 7.9% - 94.7% 55.3% 7.9% - 94.7% Observations 18 40 58 Gaseous Seek alternative supplier 28.2% 40.9% 33.0% chlorine 15.1% - 46.5% 24.6% - 59.4% 22.1% - 46.1% Increase purchasing / maintain a 60.6% 50.2% 56.6% larger than typical inventory 33.3% - 82.5% 32.5% - 67.9% 38.4% - 73.2% Switch chemicals, procedures, or 0.4% 1.0% 0.6% technologies 0.4% - 0.5% 0.1% - 7.1% 0.2% - 2.1% Make arrangements with neighboring 14.4% 15.6% 14.9% utilities or mutual aid network 5.4% - 33.2% 6.2% - 34.1% 7.5% - 27.4% Other 42.5% 9.0% - 84.7% 42.5% 9.0% - 84.7% Observations 34 55 89 G-60 Table G.14 Page 2 of 6 ------- Table G.14. Question B2.1.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Liquid Seek alternative supplier 54.5% 27.9% 52.1% oxygen 15.4% - 88.7% 5.1% - 73.5% 16.4% - 85.8% Increase purchasing / maintain a 26.7% 41.9% 28.1% larger than typical inventory 7.8% - 60.9% 11.8% - 79.5% 9.7% - 58.7% Switch chemicals, procedures, or 0.0% 0.0% 0.0% technologies N/A - N/A N/A - N/A N/A - N/A Make arrangements with neighboring 18.8% 0.0% 17.1% utilities or mutual aid network 2.0% - 72.4% N/A - N/A 1.9% - 69.0% Other 100.0% N/A - N/A 100.0% N/A - N/A Observations 10 7 17 Lime Seek alternative supplier 46.0% 46.7% 46.2% 24.3% - 69.3% 20.4% - 75.0% 28.6% - 64.8% Increase purchasing / maintain a 45.3% 72.1% 54.4% larger than typical inventory 23.1% - 69.7% 42.0% - 90.2% 35.6% - 72.0% Switch chemicals, procedures, or 0.0% 0.0% 0.0% technologies N/A - N/A N/A - N/A N/A - N/A Make arrangements with neighboring 10.7% 18.8% 13.5% utilities or mutual aid network 1.9% - 43.1% 4.4% - 54.2% 4.2% - 35.3% Other 19.2% 2.0% - 73.2% 19.2% 2.0% - 73.2% Observations 17 28 45 G-61 Table G.14 Page 3 of 6 ------- Table G.14. Question B2.1.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Orthophos- Seek alternative supplier 27.8% 41.4% 33.4% phate 8.7% - 60.7% 20.1% - 66.5% 17.3% - 54.6% Increase purchasing / maintain a 46.7% 58.5% 51.6% larger than typical inventory 32.4% - 61.6% 33.4% - 79.9% 38.3% - 64.8% Switch chemicals, procedures, or 0.0% 0.9% 0.4% technologies N/A - N/A 0.1% - 6.6% 0.1% - 2.8% Make arrangements with neighboring 18.7% 17.1% 18.1% utilities or mutual aid network 4.3% - 54.1% 4.7% - 46.3% 6.6% - 40.7% Other 52.8% 6.4% - 94.8% 52.8% 6.4% - 94.8% Observations 16 36 52 Polymers Seek alternative supplier 27.7% 34.6% 30.6% 13.7% - 48.1% 21.1% - 51.3% 19.9% - 43.9% Increase purchasing / maintain a 65.7% 65.0% 65.4% larger than typical inventory 45.3% - 81.6% 47.8% - 79.0% 51.6% - 77.1% Switch chemicals, procedures, or 0.0% 1.5% 0.6% technologies N/A - N/A 0.5% - 4.5% 0.2% - 1.9% Make arrangements with neighboring 5.0% 13.3% 8.5% utilities or mutual aid network 1.0% - 22.0% 5.2% - 30.1% 3.6% - 18.4% Other 88.2% 28.4% 52.9% 31.4% - 99.2% 7.6% - 65.9% 15.4% - 87.3% Observations 39 81 120 G-62 Table G.14 Page 4 of 6 ------- Table G.14. Question B2.1.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Potassium Seek alternative supplier 29.6% 76.2% 38.7% perman- 9.7% - 62.2% 50.5% - 91.0% 18.2% - 64.3% ganate Increase purchasing / maintain a 52.0% 36.9% 49.0% larger than typical inventory 23.4% - 79.4% 16.0% - 64.3% 25.0% - 73.5% Switch chemicals, procedures, or 0.0% 0.0% 0.0% technologies N/A - N/A N/A - N/A N/A - N/A Make arrangements with neighboring 18.8% 10.7% 17.2% utilities or mutual aid network 4.3% - 54.4% 2.6% - 35.1% 4.8% - 46.1% Other 100.0% 100.0% 100.0% N/A - N/A N/A - N/A N/A - N/A Observations 18 21 39 Sodium Seek alternative supplier 33.1% 35.9% 34.2% hydroxide 16.6% - 55.1% 16.0% - 62.3% 20.6% - 51.0% Increase purchasing / maintain a 64.6% 45.0% 56.9% larger than typical inventory 41.4% - 82.5% 22.8% - 69.3% 40.0% - 72.3% Switch chemicals, procedures, or 0.0% 1.1% 0.4% technologies N/A - N/A 0.1% - 8.2% 0.1% - 3.2% Make arrangements with neighboring 10.1% 4.6% 7.9% utilities or mutual aid network 1.8% - 40.7% 1.2% - 15.4% 2.1% - 25.8% Other 100.0% 100.0% 100.0% N/A - N/A N/A - N/A N/A - N/A Observations 17 36 53 G-63 Table G.14 Page 5 of 6 ------- Table G.14. Question B2.1.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Sodium Seek alternative supplier 25.8% 46.6% 29.3% hypochlo- 14.2% - 42.3% 30.7% - 63.2% 18.7% - 42.7% rite Increase purchasing / maintain a 69.6% 65.4% 68.9% larger than typical inventory 52.3% - 82.7% 48.6% - 79.1% 54.5% - 80.4% Switch chemicals, procedures, or 4.3% 0.6% 3.7% technologies 0.6% - 26.4% 0.1% - 4.0% 0.5% - 22.2% Make arrangements with neighboring 14.6% 14.8% 14.6% utilities or mutual aid network 5.8% - 32.0% 5.9% - 32.7% 6.8% - 28.9% Other 93.7% 94.3% 93.9% 57.9% - 99.4% 63.6% - 99.4% 72.3% - 98.9% Observations 66 80 146 N/A: confidence interval could not be calculated. G-64 Table G.14 Page 6 of 6 ------- Table G.15. Question B2.2.1: How severe are your concerns about personal protective equipment shortages or supply chain disruptions? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All N95 masks Mean score (0 to 3) 0.185 0.369 0.209 and/or 0.145 - 0.225 0.303 - 0.435 0.173 - 0.245 elastomeric None (0) 88.3% 75.0% 86.6% respirators 85.7% - 90.4% 70.5% - 79.0% 84.3% - 88.6% Slight (1) 7.1% 15.9% 8.2% 5.4% - 9.4% 12.5% - 19.9% 6.6% - 10.3% Moderate (2) 2.4% 6.5% 2.9% 1.6% - 3.6% 4.5% - 9.2% 2.2% - 4.0% Severe (3) 2.2% 2.7% 2.2% 1.4% - 3.5% 1.7% - 4.3% 1.5% - 3.3% Observations 924 830 1,754 Alternative Mean score (0 to 3) 0.161 0.314 0.180 mask 0.127 - 0.194 0.250 - 0.379 0.150 - 0.211 options None (0) 88.8% 77.3% 87.3% (surgical, 86.2% - 90.9% 72.9% - 81.1% 85.0% - 89.3% cloth, etc.) Slight (1) 6.9% 14.7% 7.9% 5.1% - 9.2% 11.7% - 18.3% 6.3% - 9.9% Moderate (2) 3.8% 7.4% 4.3% 2.7% - 5.4% 5.1% - 10.6% 3.3% - 5.6% Severe (3) 0.5% 0.6% 0.5% 0.2% - 1.1% 0.2% - 2.3% 0.3% - 1.0% Observations 924 830 1,754 G-65 Table G.15 Page 1 of 3 ------- Table G.15. Question B2.2.1: How severe are your concerns about personal protective equipment shortages or supply chain disruptions? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Face shield and/or protective eye wear Mean score (0 to 3) 0.122 0.094 - 0.150 0.210 0.162 - 0.258 0.133 0.108 - 0.158 None (0) 90.5% 88.1% - 92.5% 82.7% 78.7% - 86.1% 89.5% 87.4% - 91.3% Slight (1) 7.2% 5.4% - 9.5% 13.8% 10.7% - 17.5% 8.0% 6.4% - 10.0% Moderate (2) 1.9% 1.2% - 3.0% 3.4% 2.0% - 5.7% 2.1% 1.5% - 3.0% Severe (3) 0.4% 0.2% - 1.0% 0.1% 0.0% - 0.5% 0.4% 0.2% - 0.8% Observations 924 830 1,754 Nitrile and/or latex gloves Mean score (0 to 3) 0.208 0.170 - 0.247 0.398 0.323 - 0.472 0.233 0.198 - 0.267 None (0) 86.1% 83.4% - 88.4% 73.7% 69.2% - 77.8% 84.5% 82.1% - 86.6% Slight (1) 7.8% 6.0% - 10.1% 14.2% 11.3% - 17.7% 8.7% 7.0% - 10.6% Moderate (2) 5.3% 3.9% - 7.0% 10.8% 8.0% - 14.4% 6.0% 4.7% - 7.5% Severe (3) 0.8% 0.5% - 1.5% 1.3% 0.6% - 3.1% 0.9% 0.5% - 1.4% Observations 924 830 1,754 G-66 Table G.15 Page 2 of 3 ------- Table G.15. Question B2.2.1: How severe are your concerns about personal protective equipment shortages or supply chain disruptions? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Tyvek suite Mean score (0 to 3) 0.102 0.196 0.114 and/or 0.075 - 0.130 0.149 - 0.244 0.090 - 0.139 disposable None (0) 93.4% 85.1% 92.4% coveralls 91.5% - 94.9% 81.2% - 88.4% 90.7% - 93.8% Slight (1) 3.5% 10.1% 4.4% 2.4% - 5.1% 7.3% - 13.7% 3.3% - 5.7% Moderate (2) 2.5% 4.8% 2.8% 1.6% - 3.8% 3.2% - 7.0% 2.0% - 3.9% Severe (3) 0.6% 0.0% 0.5% 0.3% - 1.2% N/A - N/A 0.3% - 1.0% Observations 924 830 1,754 Sanitizing Mean score (0 to 3) 0.205 0.403 0.231 wipes, 0.164 - 0.246 0.330 - 0.476 0.194 - 0.268 sprays for None (0) 86.1% 72.5% 84.3% cleaning 83.4% - 88.4% 67.9% - 76.7% 81.9% - 86.5% work Slight (1) 8.7% 16.5% 9.7% offices, or 6.9% - 11.1% 13.3% - 20.2% 8.0% - 11.8% gels for Moderate (2) 3.7% 9.3% 4.4% hand 2.6% - 5.2% 6.7% - 12.8% 3.4% - 5.8% sanitizing Severe (3) 1.5% 1.8% 1.5% 0.8% - 2.7% 0.9% - 3.5% 0.9% - 2.6% Observations 924 830 1,754 N/A: confidence interval could not be calculated. G-67 Table G.15 Page 3 of 3 ------- Table G.16. Question B2.2.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All N95 masks Unavailable from 54.2% 50.8% 53.4% and/or supplier(s) 43.2% - 64.7% 41.1% - 60.4% 44.7% - 61.8% elastomeric Delayed / backordered 58.4% 72.3% 61.8% respirators from supplier(s) 47.3% - 68.8% 62.7% - 80.2% 52.9% - 69.9% Transportation / 15.9% 17.7% 16.3% distribution difficulties 9.5% - 25.2% 11.7% - 25.7% 11.0% - 23.4% Price 18.4% 15.0% 17.6% 11.2% - 28.7% 9.3% - 23.3% 11.8% - 25.5% Other 13.7% 5.1% 11.6% 7.7% - 23.1% 3.5% - 7.4% 7.0% - 18.8% Observations 150 232 382 Alternative Unavailable from 27.1% 31.2% 28.1% mask supplier(s) 18.6% - 37.7% 22.7% - 41.2% 21.0% - 36.4% options Delayed / backordered 69.6% 81.9% 72.4% (surgical, from supplier(s) 58.5% - 78.8% 73.5% - 88.1% 63.6% - 79.8% cloth, etc.) Transportation / 17.2% 21.5% 18.2% distribution difficulties 10.5% - 26.9% 14.5% - 30.6% 12.5% - 25.6% Price 20.1% 11.0% 18.0% 12.1% - 31.4% 6.6% - 17.9% 11.6% - 26.8% Other 12.7% 5.2% 10.9% 6.8% - 22.4% 3.6% - 7.5% 6.3% - 18.4% Observations 144 212 356 G-68 Table G.16 Page 1 of 3 ------- Table G.16. Question B2.2.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Face shield Unavailable from 39.3% 37.1% 38.8% and/or supplier(s) 28.0% - 51.9% 26.9% - 48.6% 29.5% - 49.1% protective Delayed / backordered 62.2% 71.7% 64.2% eye wear from supplier(s) 49.4% - 73.5% 60.2% - 81.0% 53.8% - 73.4% Transportation / 7.5% 15.3% 9.2% distribution difficulties 3.0% - 17.5% 8.4% - 26.3% 4.9% - 16.5% Price 16.1% 9.3% 14.6% 8.4% - 28.5% 5.0% - 16.6% 8.4% - 24.4% Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 120 159 279 Nitrile Unavailable from 47.7% 44.2% 46.9% and/or latex supplier(s) 38.1% - 57.5% 35.1% - 53.6% 39.1% - 54.9% gloves Delayed / backordered 70.2% 77.3% 71.7% from supplier(s) 60.3% - 78.4% 67.6% - 84.8% 63.8% - 78.5% Transportation / 15.9% 22.4% 17.3% distribution difficulties 9.8% - 24.7% 15.2% - 31.7% 12.1% - 24.2% Price 22.3% 21.3% 22.1% 15.1% - 31.7% 15.3% - 28.7% 16.1% - 29.5% Other 0.6% 0.9% 0.6% 0.1% - 3.9% 0.3% - 2.9% 0.2% - 2.5% Observations 181 240 421 G-69 Table G.16 Page 2 of 3 ------- Table G.16. Question B2.2.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Tyvek suite Unavailable from 45.9% 43.5% 45.3% and/or supplier(s) 33.0% - 59.4% 31.2% - 56.7% 34.9% - 56.1% disposable Delayed / backordered 61.8% 62.8% 62.0% coveralls from supplier(s) 47.6% - 74.1% 48.6% - 75.1% 50.9% - 72.0% Transportation / 1.3% 15.9% 5.0% distribution difficulties 0.3% - 5.1% 8.2% - 28.6% 2.7% - 8.8% Price 9.1% 10.0% 9.3% 4.5% - 17.4% 5.2% - 18.5% 5.4% - 15.5% Other 1.6% 0.3% 1.3% 0.2% - 10.8% 0.0% - 2.0% 0.2% - 7.9% Observations 95 130 225 Sanitizing Unavailable from 48.4% 54.1% 49.7% wipes, supplier(s) 38.6% - 58.3% 44.7% - 63.2% 41.7% - 57.6% sprays for Delayed / backordered 64.9% 77.8% 67.8% cleaning from supplier(s) 54.9% - 73.8% 69.5% - 84.3% 59.8% - 74.9% work Transportation / 4.6% 12.3% 6.3% offices, or distribution difficulties 2.3% - 8.8% 7.3% - 20.0% 4.0% - 9.7% gels for Price 19.5% 16.8% 18.9% hand 12.4% - 29.4% 11.0% - 24.9% 13.1% - 26.6% sanitizing Other 9.6% 4.0% 8.3% 5.0% - 17.7% 2.7% - 5.8% 4.6% - 14.5% Observations 177 252 429 N/A: confidence interval could not be calculated. G-70 Table G.16 Page 3 of 3 ------- Table G.17. Question B2.2.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All N95 masks Seek alternative supplier 54.6% 64.1% 56.9% and/or 43.6% - 65.2% 54.3% - 72.8% 48.1% - 65.2% elastomeric Increase purchasing / maintain a 56.2% 71.3% 59.8% respirators larger than typical inventory 45.1% - 66.7% 61.8% - 79.1% 51.0% - 68.0% Switch chemicals, procedures, or 13.8% 8.8% 12.6% technologies 7.9% - 23.2% 5.6% - 13.6% 7.9% - 19.7% Make arrangements w/ neighboring 13.6% 15.2% 14.0% utilities or mutual aid network 7.8% - 22.8% 8.6% - 25.4% 9.0% - 21.1% Other 3.0% 2.3% 2.8% 0.6% - 13.1% 1.1% - 4.7% 0.8% - 9.5% Observations 150 232 382 Alternative Seek alternative supplier 54.0% 59.4% 55.2% mask 42.6% - 64.9% 48.6% - 69.3% 46.1% - 64.0% options Increase purchasing / maintain a 67.3% 81.2% 70.5% (surgical, larger than typical inventory 55.8% - 77.1% 72.7% - 87.5% 61.4% - 78.2% cloth, etc.) Switch chemicals, procedures, or 0.2% 1.2% 0.4% technologies 0.0% - 0.6% 0.4% - 3.5% 0.2% - 0.9% Make arrangements w/ neighboring 10.6% 10.5% 10.5% utilities or mutual aid network 5.7% - 18.9% 5.7% - 18.4% 6.4% - 16.9% Other 0.9% 0.4% 0.8% 0.1% - 6.5% 0.1% - 1.6% 0.1% - 4.6% Observations 144 212 356 G-71 Table G.17 Page 1 of 3 ------- Table G.17. Question B2.2.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Face shield Seek alternative supplier 62.8% 57.1% 61.6% and/or 51.1% - 73.3% 45.1% - 68.3% 52.1% - 70.3% protective Increase purchasing / maintain a 40.0% 60.0% 44.3% eye wear larger than typical inventory 28.9% - 52.3% 48.0% - 70.9% 34.9% - 54.0% Switch chemicals, procedures, or 0.2% 2.2% 0.6% technologies 0.0% - 0.7% 0.9% - 5.4% 0.3% - 1.3% Make arrangements w/ neighboring 11.1% 7.9% 10.4% utilities or mutual aid network 5.6% - 20.8% 3.4% - 17.6% 5.8% - 18.1% Other 0.1% 1.1% 0.3% 0.0% - 0.6% 0.3% - 4.3% 0.1% - 1.0% Observations 120 159 279 Nitrile Seek alternative supplier 58.5% 61.6% 59.1% and/or latex 48.5% - 67.8% 51.7% - 70.5% 51.1% - 66.7% gloves Increase purchasing / maintain a 57.1% 75.4% 61.1% larger than typical inventory 47.2% - 66.5% 66.3% - 82.7% 53.0% - 68.7% Switch chemicals, procedures, or 10.6% 8.9% 10.2% technologies 5.8% - 18.7% 5.4% - 14.4% 6.2% - 16.5% Make arrangements w/ neighboring 9.5% 7.2% 9.0% utilities or mutual aid network 5.4% - 16.3% 3.7% - 13.3% 5.6% - 14.3% Other 1.6% 0.9% 1.4% 0.4% - 5.8% 0.3% - 2.9% 0.5% - 4.5% Observations 181 240 421 G-72 Table G.17 Page 2 of 3 ------- Table G.17. Question B2.2.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Tyvek suite Seek alternative supplier 63.9% 66.1% 64.4% and/or 49.6% - 76.1% 52.3% - 77.6% 53.2% - 74.3% disposable Increase purchasing / maintain a 38.0% 57.7% 42.9% coveralls larger than typical inventory 25.5% - 52.2% 44.4% - 70.0% 32.6% - 53.8% Switch chemicals, procedures, or 19.8% 9.0% 17.1% technologies 10.3% - 34.6% 6.2% - 12.8% 9.7% - 28.2% Make arrangements w/ neighboring 8.7% 8.3% 8.6% utilities or mutual aid network 4.4% - 16.6% 3.2% - 19.7% 4.9% - 14.8% Other 1.3% 0.9% 1.2% 0.2% - 7.5% 0.2% - 4.1% 0.3% - 5.1% Observations 95 130 225 Sanitizing Seek alternative supplier 54.8% 60.9% 56.2% wipes, 44.8% - 64.4% 51.3% - 69.7% 48.1% - 63.9% sprays for Increase purchasing / maintain a 61.7% 77.1% 65.2% cleaning larger than typical inventory 51.6% - 70.9% 69.1% - 83.4% 57.1% - 72.5% work Switch chemicals, procedures, or 2.9% 8.4% 4.1% offices, or technologies 0.7% - 10.6% 4.8% - 14.2% 1.9% - 8.8% gels for Make arrangements w/ neighboring 8.1% 8.3% 8.2% hand utilities or mutual aid network 5.0% - 12.9% 4.4% - 15.0% 5.5% - 12.0% Other 4.0% 1.7% 3.5% 1.3% - 11.6% 0.8% - 3.5% 1.3% - 9.1% Observations 177 252 429 G-73 Table G.17 Page 3 of 3 ------- Table G.18. Question B2.3.1: How severe are your concerns about shortages or supply chain disruptions involving durable goods and other critical equipment and supplies, etc.? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Filter media Mean score (0 to 3) 0.051 0.048 0.051 0.027 - 0.074 0.025 - 0.072 0.030 - 0.071 None (0) 96.6% 95.9% 96.5% 94.7% - 97.8% 93.5% - 97.4% 94.9% - 97.6% Slight (1) 2.0% 3.4% 2.2% 1.1% - 3.5% 2.0% - 5.7% 1.4% - 3.5% Moderate (2) 1.1% 0.6% 1.1% 0.5% - 2.6% 0.2% - 2.2% 0.5% - 2.3% Severe(3) 0.3% 0.0% 0.3% 0.1% - 0.9% 0.0% - 0.3% 0.1% - 0.7% Observations 921 827 1,748 Granular/ Mean score (0 to 3) 0.025 0.040 0.027 Powdered 0.011 - 0.040 0.017 - 0.063 0.014 - 0.040 Activated None (0) 98.2% 97.0% 98.0% Carbon (GAC/ 96.9% - 98.9% 94.7% - 98.3% 96.9% - 98.7% PAC) Slight (1) 1.2% 2.2% 1.4% 0.7% - 2.2% 1.1% - 4.4% 0.8% - 2.2% Moderate (2) 0.5% 0.7% 0.5% 0.2% - 1.6% 0.2% - 2.2% 0.2% - 1.4% Severe(3) 0.1% 0.1% 0.1% 0.0% - 0.5% 0.0% - 0.6% 0.0% - 0.4% Observations 921 827 1,748 G-74 Table G.18 Page 1 of 5 ------- Table G.18. Question B2.3.1: How severe are your concerns about shortages or supply chain disruptions involving durable goods and other critical equipment and supplies, etc.? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Membrane modules Mean score (0 to 3) 0.021 0.008 - 0.035 0.022 0.007 - 0.038 0.022 0.009 - 0.034 None (0) 98.3% 96.9% - 99.1% 97.8% 95.6% - 99.0% 98.2% 97.1% - 98.9% Slight (1) 1.3% 0.7% - 2.5% 2.1% 1.0% - 4.3% 1.4% 0.8% - 2.4% Moderate (2) 0.4% 0.1% - 1.5% 0.1% 0.0% - 0.3% 0.4% 0.1% - 1.3% Severe(3) 0.0% 0.0% - 0.1% 0.0% N/A - N/A 0.0% 0.0% - 0.1% Observations 921 827 1,748 Pumps Mean score (0 to 3) 0.159 0.118 - 0.201 0.263 0.194 - 0.331 0.173 0.136 - 0.210 None (0) 89.7% 87.1% - 91.9% 82.6% 78.4% - 86.2% 88.8% 86.5% - 90.8% Slight (1) 6.2% 4.6% - 8.3% 10.5% 7.8% - 13.9% 6.7% 5.2% - 8.6% Moderate (2) 2.5% 1.6% - 4.1% 4.9% 3.0% - 7.7% 2.8% 1.9% - 4.2% Severe(3) 1.6% 0.8% - 3.0% 2.0% 0.9% - 4.3% 1.6% 0.9% - 2.8% Observations 921 827 1,748 G-75 Table G.18 Page 2 of 5 ------- Table G.18. Question B2.3.1: How severe are your concerns about shortages or supply chain disruptions involving durable goods and other critical equipment and supplies, etc.? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Motors Mean score (0 to 3) 0.136 0.098 - 0.174 0.262 0.194 - 0.330 0.152 0.118 - 0.186 None (0) 91.3% 88.9% - 93.2% 82.2% 77.9% - 85.9% 90.1% 88.0% - 91.9% Slight (1) 5.1% 3.7% - 7.0% 11.3% 8.4% - 15.1% 5.9% 4.5% - 7.5% Moderate (2) 2.4% 1.5% - 4.0% 4.4% 2.7% - 7.1% 2.7% 1.8% - 4.0% Severe(3) 1.2% 0.6% - 2.4% 2.1% 1.0% - 4.3% 1.3% 0.8% - 2.4% Observations 921 827 1,748 Pipes Mean score (0 to 3) 0.138 0.101 - 0.175 0.236 0.173 - 0.299 0.151 0.117 - 0.184 None (0) 90.3% 87.8% - 92.3% 82.3% 77.9% - 86.1% 89.3% 87.1% - 91.1% Slight (1) 6.6% 5.0% - 8.7% 13.5% 10.2% - 17.7% 7.5% 6.0% - 9.4% Moderate (2) 2.0% 1.1% - 3.6% 2.4% 1.3% - 4.3% 2.1% 1.3% - 3.4% Severe(3) 1.0% 0.5% - 2.3% 1.8% 0.7% - 4.2% 1.1% 0.6% - 2.2% Observations 921 827 1,748 G-76 Table G.18 Page 3 of 5 ------- Table G.18. Question B2.3.1: How severe are your concerns about shortages or supply chain disruptions involving durable goods and other critical equipment and supplies, etc.? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Chain Issue Response Percentage Reporting by Population Served < 10,000 > 10,000 All Valves Mean score (0 to 3) 0.133 0.096 - 0.170 0.258 0.192 - 0.325 0.149 0.116 - 0.182 None (0) 91.0% 88.6% - 92.9% 81.5% 77.0% - 85.3% 89.8% 87.7% - 91.6% Slight (1) 5.7% 4.2% - 7.6% 13.1% 9.9% - 17.0% 6.6% 5.2% - 8.3% Moderate (2) 2.4% 1.4% - 3.9% 3.5% 2.0% - 6.2% 2.5% 1.6% - 3.8% Severe(3) 1.0% 0.4% - 2.2% 1.9% 0.9% - 4.3% 1.1% 0.6% - 2.1% Observations 921 827 1,748 Fuel Mean score (0 to 3) 0.066 0.037 - 0.095 0.136 0.082 - 0.190 0.075 0.049 - 0.101 None (0) 96.3% 94.6% - 97.5% 90.9% 87.2% - 93.7% 95.6% 94.1% - 96.7% Slight (1) 1.4% 0.9% - 2.2% 5.8% 3.6% - 9.1% 1.9% 1.4% - 2.7% Moderate (2) 1.7% 0.9% - 3.3% 2.0% 1.0% - 4.0% 1.8% 1.0% - 3.1% Severe(3) 0.6% 0.2% - 1.6% 1.3% 0.5% - 3.6% 0.7% 0.3% - 1.5% Observations 921 827 1,748 G-77 Table G.18 Page 4 of 5 ------- Table G.18. Question B2.3.1: How severe are your concerns about shortages or supply chain disruptions involving durable goods and other critical equipment and supplies, etc.? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Vehicles Mean score (0 to 3) 0.037 0.134 0.050 0.020 - 0.054 0.078 - 0.189 0.033 - 0.066 None (0) 97.7% 90.5% 96.8% 96.6% - 98.5% 86.3% - 93.5% 95.7% - 97.6% Slight (1) 1.1% 6.8% 1.8% 0.7% - 1.9% 4.3% - 10.6% 1.3% - 2.6% Moderate (2) 0.9% 1.5% 1.0% 0.4% - 1.8% 0.6% - 3.7% 0.5% - 1.8% Severe(3) 0.3% 1.2% 0.4% 0.1% - 0.9% 0.4% - 3.6% 0.2% - 0.9% Observations 921 827 1,748 N/A: confidence interval could not be calculated. G-78 Table G.18 Page 5 of 5 ------- Table G.19. Question B2.3.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Filter media Unavailable from 27.6% 21.9% 26.8% supplier(s) 11.3% - 53.3% 7.1% - 50.7% 12.2% - 49.0% Delayed / backordered 55.5% 62.7% 56.6% from supplier(s) 32.3% - 76.5% 36.2% - 83.3% 36.1% - 75.1% Transportation / 9.7% 20.1% 11.3% distribution difficulties 1.7% - 39.5% 6.9% - 46.3% 3.1% - 33.4% Price 15.5% 14.3% 15.3% 4.6% - 41.2% 3.5% - 43.8% 5.3% - 36.9% Other 3.1% 0.0% 2.6% 0.4% - 20.2% N/A - N/A 0.3% - 17.4% Observations 39 40 79 Granular/ Unavailable from 40.3% 49.8% 42.1% Powdered supplier(s) 13.9% - 73.7% 22.6% - 77.2% 18.5% - 70.1% Activated Delayed / backordered 44.2% 59.1% 47.1% Carbon (GAC/ from supplier(s) 16.4% - 76.2% 27.7% - 84.5% 22.1% - 73.7% PAC) Transportation / 0.5% 27.2% 5.7% distribution difficulties 0.1% - 3.4% 9.0% - 58.5% 2.1% - 14.2% Price 18.9% 32.5% 21.6% 3.2% - 62.3% 11.0% - 65.2% 5.9% - 54.8% Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 28 27 55 G-79 Table G.19 Page 1 of 5 ------- Table G.19. Question B2.3.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Membrane Unavailable from 47.7% 31.0% 45.1% modules supplier(s) 17.5% - 79.6% 6.8% - 73.3% 18.9% - 74.3% Delayed / backordered 58.0% 40.5% 55.3% from supplier(s) 23.7% - 86.0% 12.5% - 76.4% 25.7% - 81.6% Transportation / 0.5% 26.8% 4.6% distribution difficulties 0.1% - 3.8% 5.8% - 68.4% 1.2% - 16.4% Price 20.5% 4.3% 18.0% 3.3% - 66.4% 0.8% - 19.5% 3.2% - 59.4% Other 0.0% 2.2% 0.3% N/A - N/A 0.2% - 17.3% 0.0% - 2.7% Observations 24 16 40 Pumps Unavailable from 31.3% 28.8% 30.8% supplier(s) 20.9% - 43.9% 18.9% - 41.3% 22.0% - 41.1% Delayed / backordered 72.4% 82.1% 74.3% from supplier(s) 59.6% - 82.3% 67.9% - 90.8% 63.8% - 82.6% Transportation / 10.4% 21.5% 12.6% distribution difficulties 5.3% - 19.3% 12.5% - 34.4% 7.8% - 19.7% Price 18.5% 13.7% 17.5% 10.6% - 30.2% 6.5% - 26.6% 10.9% - 27.0% Other 1.0% 0.0% 0.8% 0.1% - 7.1% N/A - N/A 0.1% - 5.7% Observations 116 141 257 G-80 Table G.19 Page 2 of 5 ------- Table G.19. Question B2.3.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Motors Unavailable from 30.7% 28.2% 30.1% supplier(s) 19.9% - 44.2% 18.3% - 40.7% 21.2% - 40.8% Delayed / backordered 76.0% 86.5% 78.4% from supplier(s) 62.0% - 86.0% 74.5% - 93.4% 67.4% - 86.4% Transportation / 9.9% 16.4% 11.4% distribution difficulties 4.7% - 19.8% 9.3% - 27.3% 6.7% - 18.8% Price 20.4% 11.6% 18.3% 11.5% - 33.5% 5.8% - 21.9% 11.2% - 28.6% Other 1.2% 0.0% 0.9% 0.2% - 8.3% N/A - N/A 0.1% - 6.4% Observations 104 136 240 Pipes Unavailable from 37.9% 32.9% 36.8% supplier(s) 27.2% - 49.9% 21.9% - 46.1% 28.0% - 46.7% Delayed / backordered 64.6% 80.6% 68.0% from supplier(s) 51.9% - 75.5% 66.2% - 89.9% 57.6% - 76.8% Transportation / 7.3% 25.1% 11.1% distribution difficulties 3.9% - 13.4% 15.1% - 38.8% 7.4% - 16.4% Price 14.6% 9.9% 13.6% 8.4% - 24.2% 4.9% - 18.8% 8.4% - 21.2% Other 3.8% 0.3% 3.1% 0.8% - 16.0% 0.0% - 1.8% 0.7% - 12.7% Observations 111 129 240 G-81 Table G.19 Page 3 of 5 ------- Table G.19. Question B2.3.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Valves Unavailable from 35.6% 30.1% 34.3% supplier(s) 24.6% - 48.3% 19.8% - 42.7% 25.4% - 44.5% Delayed / backordered 71.8% 81.3% 74.0% from supplier(s) 58.3% - 82.3% 67.3% - 90.1% 63.2% - 82.5% Transportation / 5.5% 20.4% 8.9% distribution difficulties 2.7% - 10.6% 12.2% - 32.0% 5.9% - 13.3% Price 14.2% 14.5% 14.3% 7.8% - 24.5% 7.1% - 27.4% 8.8% - 22.3% Other 1.2% 0.0% 0.9% 0.2% - 8.0% N/A - N/A 0.1% - 6.2% Observations 107 137 244 Fuel Unavailable from 47.1% 39.3% 45.0% supplier(s) 30.2% - 64.6% 22.7% - 58.7% 31.7% - 59.0% Delayed / backordered 50.2% 34.3% 46.0% from supplier(s) 30.3% - 70.0% 19.7% - 52.7% 30.6% - 62.2% Transportation / 17.5% 39.8% 23.4% distribution difficulties 6.4% - 39.5% 23.1% - 59.4% 12.8% - 38.8% Price 41.7% 27.8% 38.1% 23.3% - 62.9% 14.1% - 47.6% 23.6% - 55.0% Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 49 54 103 G-82 Table G.19 Page 4 of 5 ------- Table G.19. Question B2.3.2: For each item, what are you most concerned about? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Vehicles Unavailable from 29.6% 30.3% 29.9% supplier(s) 17.3% - 45.9% 14.5% - 52.8% 19.5% - 42.9% Delayed / backordered 60.3% 81.5% 68.3% from supplier(s) 41.7% - 76.3% 61.6% - 92.3% 54.1% - 79.8% Transportation / 12.0% 19.9% 15.0% distribution difficulties 4.7% - 27.2% 8.5% - 39.7% 8.3% - 25.7% Price 47.3% 15.7% 35.3% 30.4% - 64.8% 6.1% - 34.8% 23.7% - 48.9% Other 0.0% 0.0% 0.0% N/A - N/A N/A - N/A N/A - N/A Observations 37 44 81 N/A: confidence interval could not be calculated. G-83 Table G.19 Page 5 of 5 ------- Table G.20. Question B2.3.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Filter media Seek alternative supplier 33.1% 61.6% 37.4% 18.0% - 52.7% 35.4% - 82.5% 23.3% - 54.0% Increase purchasing / maintain 62.3% 35.1% 58.2% a larger than typical inventory 42.7% - 78.6% 15.1% - 62.3% 41.6% - 73.2% Switch chemicals, procedures, 0.0% 0.0% 0.0% or technologies N/A - N/A N/A - N/A N/A - N/A Make arrangements with neighbor- 6.4% 0.0% 5.4% ing utilities or mutual aid network 1.8% - 20.0% N/A - N/A 1.6% - 17.2% Other 6.2% 1.2% 5.5% 1.7% - 20.4% 0.2% - 8.4% 1.6% - 17.4% Observations 39 40 79 Granular/ Seek alternative supplier 61.6% 52.8% 59.9% Powdered 44.2% - 76.4% 23.9% - 79.9% 44.8% - 73.2% Activated Increase purchasing / maintain 38.4% 57.1% 42.0% Carbon (GAC/ a larger than typical inventory 13.1% - 72.1% 27.9% - 82.1% 18.8% - 69.4% PAC) Switch chemicals, procedures, 0.0% 0.0% 0.0% or technologies N/A - N/A N/A - N/A N/A - N/A Make arrangements with neighbor- 5.3% 0.0% 4.2% ing utilities or mutual aid network 1.0% - 23.5% N/A - N/A 0.8% - 19.6% Other 4.2% 0.0% 3.4% 0.5% - 26.2% N/A - N/A 0.4% - 22.0% Observations 28 27 55 G-84 Table G.20 Page 1 of 5 ------- Table G.20. Question B2.3.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Membrane Seek alternative supplier 42.0% 60.8% 45.0% modules 15.4% - 74.4% 24.1% - 88.4% 19.8% - 73.0% Increase purchasing / maintain 43.3% 39.7% 42.7% a larger than typical inventory 15.9% - 75.5% 12.0% - 76.1% 18.2% - 71.5% Switch chemicals, procedures, 0.0% 0.0% 0.0% or technologies N/A - N/A N/A - N/A N/A - N/A Make arrangements with neighbor- 5.7% 3.9% 5.4% ing utilities or mutual aid network 1.0% - 25.8% 1.9% - 7.8% 1.2% - 21.5% Other 0.0% 2.2% 0.3% N/A - N/A 0.2% - 17.3% 0.0% - 2.7% Observations 24 16 40 Pumps Seek alternative supplier 60.5% 54.2% 59.2% 48.0% - 71.7% 41.6% - 66.2% 49.0% - 68.7% Increase purchasing / maintain 29.7% 43.9% 32.6% a larger than typical inventory 20.0% - 41.7% 32.3% - 56.3% 24.2% - 42.2% Switch chemicals, procedures, 1.3% 0.0% 1.1% or technologies 0.3% - 5.3% N/A - N/A 0.3% - 4.2% Make arrangements with neighbor- 10.5% 8.5% 10.1% ing utilities or mutual aid network 5.4% - 19.4% 3.8% - 18.0% 5.7% - 17.2% Other 5.2% 13.3% 6.8% 2.4% - 11.0% 6.2% - 26.3% 3.9% - 11.6% Observations 116 141 257 G-85 Table G.20 Page 2 of 5 ------- Table G.20. Question B2.3.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Motors Seek alternative supplier 63.3% 57.1% 61.9% 49.7% - 75.1% 43.9% - 69.4% 51.1% - 71.6% Increase purchasing / maintain 29.1% 49.7% 33.8% a larger than typical inventory 19.0% - 41.8% 37.3% - 62.1% 25.1% - 43.8% Switch chemicals, procedures, 1.6% 0.0% 1.2% or technologies 0.4% - 6.2% N/A - N/A 0.3% - 4.8% Make arrangements with neighbor- 9.5% 8.2% 9.2% ing utilities or mutual aid network 4.2% - 19.9% 3.6% - 17.6% 4.8% - 17.0% Other 4.3% 11.4% 5.9% 1.7% - 10.5% 4.7% - 25.0% 3.1% - 11.0% Observations 104 136 240 Pipes Seek alternative supplier 46.0% 53.1% 47.5% 34.1% - 58.5% 40.0% - 65.7% 37.5% - 57.7% Increase purchasing / maintain 51.6% 49.5% 51.2% a larger than typical inventory 39.3% - 63.7% 36.7% - 62.5% 41.1% - 61.2% Switch chemicals, procedures, 1.4% 3.5% 1.8% or technologies 0.3% - 5.6% 0.6% - 16.6% 0.6% - 5.2% Make arrangements with neighbor- 7.6% 9.9% 8.1% ing utilities or mutual aid network 4.1% - 13.6% 3.9% - 22.9% 4.8% - 13.2% Other 1.1% 6.3% 2.2% 0.2% - 7.5% 2.3% - 16.4% 0.8% - 5.8% Observations 111 128 239 G-86 Table G.20 Page 3 of 5 ------- Table G.20. Question B2.3.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Valves Seek alternative supplier 58.2% 57.3% 58.0% 45.2% - 70.1% 44.4% - 69.2% 47.6% - 67.7% Increase purchasing / maintain 41.7% 54.4% 44.6% a larger than typical inventory 29.7% - 54.7% 41.9% - 66.3% 34.8% - 54.9% Switch chemicals, procedures, 0.7% 0.0% 0.5% or technologies 0.1% - 4.5% N/A - N/A 0.1% - 3.5% Make arrangements with neighbor- 8.1% 7.0% 7.8% ing utilities or mutual aid network 4.3% - 14.5% 3.4% - 14.0% 4.7% - 12.8% Other 1.3% 8.0% 2.8% 0.2% - 7.6% 2.7% - 21.4% 1.1% - 7.1% Observations 107 137 244 Fuel Seek alternative supplier 67.3% 37.6% 59.4% 47.4% - 82.4% 21.1% - 57.6% 44.5% - 72.8% Increase purchasing / maintain 31.2% 45.4% 35.0% a larger than typical inventory 15.1% - 53.7% 27.3% - 64.7% 21.1% - 52.0% Switch chemicals, procedures, 1.6% 0.0% 1.2% or technologies 0.2% - 10.7% N/A - N/A 0.2% - 8.1% Make arrangements with neighbor- 7.4% 10.9% 8.4% ing utilities or mutual aid network 3.0% - 17.3% 3.5% - 29.6% 4.1% - 16.1% Other 0.0% 7.1% 1.9% N/A - N/A 1.9% - 23.3% 0.5% - 6.7% Observations 49 54 103 G-87 Table G.20 Page 4 of 5 ------- Table G.20. Question B2.3.3: What steps have you taken or are you taking to prepare for potential shortages and supply chain disruptions? (select all that apply) All Utilities Present to December Estimates and 95 Percent Confidence Intervals Supply Percentage Reporting by Population Served Chain Issue Response < 10,000 > 10,000 All Vehicles Seek alternative supplier 46.2% 52.5% 48.6% 29.3% - 63.9% 32.1% - 72.0% 35.2% - 62.2% Increase purchasing / maintain 31.5% 32.5% 31.9% a larger than typical inventory 18.6% - 48.0% 15.9% - 55.2% 20.9% - 45.3% Switch chemicals, procedures, 0.0% 0.0% 0.0% or technologies N/A - N/A N/A - N/A N/A - N/A Make arrangements with neighbor- 16.0% 10.5% 13.9% ing utilities or mutual aid network 6.4% - 34.6% 3.2% - 29.2% 6.7% - 26.6% Other 3.9% 19.6% 9.9% 0.7% - 19.9% 7.4% - 42.7% 4.1% - 22.1% Observations 37 44 81 N/A: confidence interval could not be calculated. G-88 Table G.20 Page 5 of 5 ------- Table G.21. Question B3: Has your organization made any requests for personnel, supplies, or equipment to your tribal, local, or state emergency operations center (EOC), primacy agency, or similar organization? All Utilities Estimates and 95 Percent Confidence Intervals Percentage Reporting by Population Served Response < 10,000 > 10,000 All Yes, entirely fulfilled 9.6% 20.5% 11.0% 7.7% - 11.8% 16.9% - 24.7% 9.3% - 12.9% Yes, partly fulfilled 3.3% 7.6% 3.8% 2.2% - 4.8% 5.4% - 10.4% 2.8% - 5.2% Yes, not fulfilled 0.3% 0.7% 0.3% 0.1% - 0.9% 0.2% - 2.2% 0.1% - 0.8% No, support was not needed 77.0% 58.3% 74.7% 73.9% - 79.9% 53.2% - 63.3% 71.9% - 77.2% No, but we would have used it if it had 3.8% 5.0% 3.9% been available or if we had known of it 2.6% - 5.4% 2.9% - 8.3% 2.8% - 5.4% Do not know 6.0% 7.9% 6.3% 4.5% - 8.0% 5.7% - 11.0% 4.9% - 8.0% Observations 917 822 1,739 G-89 Table G.21 Page 1 of 1 ------- Table G.22. Question C.l: To what extent did your organization experience shortages of key personnel, including contractors performing critical functions to maintain operations, from January 2020 through present day? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Personnel Percentage Reporting by Population Served Type Response < 10,000 > 10,000 All Licensed or Mean Score (0- 0.15 0.44 0.19 certified 3) 0.12 - 0.19 0.36 - 0.52 0.16 - 0.22 operators No Shortage 88.8% 68.2% 86.1% (0) 86.3% - 90.9% 63.2% - 72.8% 83.9% - 88.0% Slight Shortage 7.5% 20.9% 9.3% (1) 5.8% - 9.6% 17.1% - 25.2% 7.7% - 11.1% Moderate 3.4% 9.3% 4.2% Shortage (2) 2.3% - 4.9% 6.9% - 12.4% 3.1% - 5.5% Severe 0.3% 1.7% 0.5% Shorage(3) 0.2% - 0.8% 0.6% - 4.6% 0.3% - 1.0% Laboratory Mean Score (0- 0.10 0.25 0.12 technicians/ 3) 0.07 - 0.13 0.19 - 0.31 0.09 - 0.15 sample analysts No Shortage 93.5% 81.4% 91.9% (0) 91.4% - 95.2% 77.1% - 85.0% 90.1% - 93.4% Slight Shortage 3.6% 13.6% 4.9% (1) 2.4% - 5.2% 10.5% - 17.4% 3.8% - 6.3% Moderate 2.3% 3.6% 2.5% Shortage (2) 1.4% - 3.7% 2.4% - 5.5% 1.6% - 3.7% Severe 0.6% 1.4% 0.7% Shorage(3) 0.2% - 1.7% 0.5% - 4.2% 0.3% - 1.6% G-90 Table G.22 Page 1 of 4 ------- Table G.22. Question C.l: To what extent did your organization experience shortages of key personnel, including contractors performing critical functions to maintain operations, from January 2020 through present day? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Personnel Percentage Reporting by Population Served Type Response < 10,000 > 10,000 All Field Workers Mean Score (0- 0.17 0.43 0.20 (meter reading, 3) 0.14 - 0.20 0.36 - 0.50 0.18 - 0.23 sampling, No Shortage 87.5% 66.1% 84.7% maintenance, (0) 85.0% - 89.7% 60.9% - 71.0% 82.4% - 86.7% etc.) Slight Shortage 8.8% 25.7% 11.1% (1) 6.9% - 11.1% 21.4% - 30.7% 9.3% - 13.1% Moderate 2.9% 6.9% 3.4% Shortage (2) 2.1% - 3.9% 5.0% - 9.6% 2.7% - 4.4% Severe 0.8% 1.2% 0.8% Shorage(3) 0.4% - 1.8% 0.5% - 2.9% 0.4% - 1.7% Engineering/ Mean Score (0- 0.07 0.25 0.09 design/ 3) 0.04 - 0.10 0.18 - 0.31 0.07 - 0.12 construction No Shortage 94.6% 81.4% 92.9% personnel (0) 92.6% - 96.1% 77.1% - 85.1% 91.1% - 94.3% Slight Shortage 4.0% 13.6% 5.3% (1) 2.8% - 5.7% 10.5% - 17.4% 4.1% - 6.8% Moderate 1.1% 3.9% 1.4% Shortage (2) 0.5% - 2.3% 2.5% - 6.1% 0.9% - 2.4% Severe 0.3% 1.1% 0.4% Shorage(3) 0.1% - 1.7% 0.3% - 4.4% 0.1% - 1.4% G-91 Table G.22 Page 2 of 4 ------- Table G.22. Question C.l: To what extent did your organization experience shortages of key personnel, including contractors performing critical functions to maintain operations, from January 2020 through present day? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Personnel Percentage Reporting by Population Served Type Response < 10,000 > 10,000 All Critial Mean Score (0- 0.09 0.30 0.11 equipment 3) 0.06 - 0.11 0.23 - 0.36 0.09 - 0.14 repair No Shortage 93.7% 77.4% 91.5% (0) 91.7% - 95.2% 72.9% - 81.4% 89.8% - 93.0% Slight Shortage 4.2% 16.9% 5.9% (1) 3.0% - 5.8% 13.4% - 21.0% 4.7% - 7.3% Moderate 1.9% 4.4% 2.2% Shortage (2) 1.1% - 3.3% 2.9% - 6.6% 1.4% - 3.4% Severe 0.2% 1.4% 0.4% Shorage(3) 0.1% - 0.6% 0.5% - 3.5% 0.2% - 0.7% Administrative Mean Score (0- 0.11 0.30 0.13 3) 0.08 - 0.14 0.24 - 0.35 0.11 - 0.16 No Shortage 92.7% 76.3% 90.5% (0) 90.8% - 94.3% 71.5% - 80.5% 88.8% - 92.1% Slight Shortage 4.2% 18.9% 6.1% (1) 3.1% - 5.6% 15.0% - 23.5% 5.0% - 7.5% Moderate 2.6% 4.0% 2.8% Shortage (2) 1.6% - 4.1% 2.7% - 5.8% 1.9% - 4.1% Severe 0.5% 0.9% 0.6% Shorage(3) 0.2% - 1.1% 0.3% - 2.9% 0.3% - 1.1% G-92 Table G.22 Page 3 of 4 ------- Table G.22. Question C.l: To what extent did your organization experience shortages of key personnel, including contractors performing critical functions to maintain operations, from January 2020 through present day? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Personnel Type Response Percentage Reporting by Population Served < 10,000 > 10,000 All Customer Service Mean Score (0- 3) 0.11 0.08 - 0.14 0.30 0.23 - 0.36 0.14 0.11 - 0.16 No Shortage (0) 92.5% 90.4% - 94.2% 77.1% 72.4% - 81.3% 90.4% 88.6% - 92.1% Slight Shortage (1) 4.1% 2.9% - 5.8% 16.7% 13.0% - 21.1% 5.8% 4.6% - 7.3% Moderate Shortage (2) 3.1% 2.0% - 4.7% 5.7% 3.8% - 8.4% 3.4% 2.4% - 4.8% Severe Shorage(3) 0.3% 0.1% - 0.8% 0.5% 0.1% - 2.2% 0.3% 0.1% - 0.8% Other Mean Score (0- 3) 0.44 0.06 - 0.81 0.88 0.06 - 1.71 0.51 0.17 - 0.84 No Shortage (0) 82.4% 63.7% - 92.6% 53.5% 24.5% - 80.2% 77.9% 62.8% - 88.0% Slight Shortage (1) 0.3% 0.3% - 0.4% 22.2% 10.2% - 41.8% 3.8% 2.3% - 6.2% Moderate Shortage (2) 8.2% 2.5% - 23.4% 6.8% 2.3% - 18.7% 8.0% 2.9% - 20.4% Severe Shorage(3) 9.0% 2.5% - 27.6% 17.6% 3.2% - 58.1% 10.4% 3.9% - 24.9% Observations 917 837 1,751 G-93 Table G.22 Page 4 of 4 ------- Table G.23. Question C.2: To what extent do you expect to experience shortages of key personnel, including contractors performing critical functions to maintain operations, from present day through December 2020? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Personnel Percentage Reporting by Population Served Type Response < 10,000 > 10,000 All Licensed or Mean Score (0- 0.14 0.48 0.18 certified 3) 0.11 - 0.17 0.40 - 0.56 0.15 - 0.21 operators No Shortage 89.6% 65.8% 86.4% (0) 87.3% - 91.6% 60.5% - 70.7% 84.3% - 88.3% Slight Shortage 7.3% 22.1% 9.3% (1) 5.7% - 9.4% 18.1% - 26.6% 7.7% - 11.2% Moderate 2.7% 10.6% 3.7% Shortage (2) 1.7% - 4.1% 7.8% - 14.3% 2.8% - 5.0% Severe 0.4% 1.5% 0.5% Shorage(3) 0.2% - 0.8% 0.6% - 3.6% 0.3% - 0.9% Laboratory Mean Score (0- 0.08 0.27 0.11 technicians/ 3) 0.06 - 0.11 0.21 - 0.33 0.08 - 0.13 sample analysts No Shortage 93.8% 79.7% 92.0% (0) 91.7% - 95.4% 75.2% - 83.5% 90.1% - 93.5% Slight Shortage 4.5% 14.7% 5.8% (1) 3.1% - 6.5% 11.5% - 18.6% 4.5% - 7.6% Moderate 1.4% 4.6% 1.8% Shortage (2) 0.8% - 2.4% 2.8% - 7.3% 1.2% - 2.7% Severe 0.3% 1.0% 0.4% Shorage(3) 0.1% - 0.9% 0.3% - 3.0% 0.2% - 0.9% G-94 Table G.23 Page 1 of 4 ------- Table G.23. Question C.2: To what extent do you expect to experience shortages of key personnel, including contractors performing critical functions to maintain operations, from present day through December 2020? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Personnel Percentage Reporting by Population Served Type Response < 10,000 > 10,000 All Field Workers Mean Score (0- 0.13 0.41 0.17 (meter reading, 3) 0.10 - 0.16 0.33 - 0.49 0.14 - 0.20 sampling, No Shortage 89.9% 70.1% 87.3% maintenance, (0) 87.5% - 91.9% 65.0% - 74.7% 85.2% - 89.1% etc.) Slight Shortage 7.4% 20.2% 9.1% (1) 5.7% - 9.6% 16.4% - 24.6% 7.5% - 11.0% Moderate 2.3% 8.3% 3.1% Shortage (2) 1.4% - 3.5% 5.9% - 11.7% 2.2% - 4.2% Severe 0.4% 1.4% 0.6% Shorage(3) 0.2% - 1.0% 0.5% - 3.6% 0.3% - 1.1% Engineering/ Mean Score (0- 0.06 0.24 0.09 design/ 3) 0.04 - 0.09 0.18 - 0.30 0.07 - 0.11 construction No Shortage 95.0% 82.4% 93.3% personnel (0) 93.0% - 96.4% 78.1% - 86.0% 91.6% - 94.7% Slight Shortage 3.8% 12.7% 5.0% (1) 2.5% - 5.6% 9.6% - 16.5% 3.8% - 6.5% Moderate 1.1% 3.7% 1.5% Shortage (2) 0.6% - 2.1% 2.3% - 6.0% 0.9% - 2.3% Severe 0.1% 1.2% 0.3% Shorage(3) 0.0% - 0.6% 0.4% - 3.5% 0.1% - 0.7% G-95 Table G.23 Page 2 of 4 ------- Table G.23. Question C.2: To what extent do you expect to experience shortages of key personnel, including contractors performing critical functions to maintain operations, from present day through December 2020? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Personnel Percentage Reporting by Population Served Type Response < 10,000 > 10,000 All Critial Mean Score (0- 0.09 0.32 0.12 equipment 3) 0.06 - 0.13 0.24 - 0.39 0.10 - 0.15 repair No Shortage 93.9% 78.6% 91.8% (0) 91.9% - 95.4% 74.1% - 82.5% 90.1% - 93.3% Slight Shortage 3.6% 13.0% 4.8% (1) 2.5% - 5.1% 10.1% - 16.5% 3.8% - 6.1% Moderate 1.9% 6.5% 2.5% Shortage (2) 1.1% - 3.3% 4.3% - 9.7% 1.7% - 3.7% Severe 0.7% 1.9% 0.9% Shorage(3) 0.3% - 1.8% 0.9% - 4.2% 0.4% - 1.8% Administrative Mean Score (0- 0.09 0.26 0.11 3) 0.06 - 0.12 0.21 - 0.32 0.09 - 0.14 No Shortage 93.3% 79.3% 91.4% (0) 91.2% - 94.9% 74.7% - 83.3% 89.5% - 92.9% Slight Shortage 4.8% 15.4% 6.2% (1) 3.5% - 6.6% 12.0% - 19.5% 4.9% - 7.8% Moderate 1.6% 4.8% 2.1% Shortage (2) 0.9% - 3.0% 3.1% - 7.5% 1.3% - 3.2% Severe 0.3% 0.5% 0.3% Shorage(3) 0.1% - 0.9% 0.1% - 2.3% 0.1% - 0.8% G-96 Table G.23 Page 3 of 4 ------- Table G.23. Question C.2: To what extent do you expect to experience shortages of key personnel, including contractors performing critical functions to maintain operations, from present day through December 2020? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Personnel Type Response Percentage Reporting by Population Served < 10,000 > 10,000 All Customer Service Mean Score (0- 3) 0.09 0.06 - 0.12 0.25 0.19 - 0.30 0.11 0.09 - 0.14 No Shortage (0) 93.1% 91.0% - 94.8% 80.9% 76.4% - 84.6% 91.5% 89.6% - 93.0% Slight Shortage (1) 4.8% 3.5% - 6.6% 14.1% 10.8% - 18.2% 6.1% 4.8% - 7.7% Moderate Shortage (2) 1.7% 0.9% - 3.1% 4.5% 2.9% - 7.0% 2.1% 1.3% - 3.3% Severe Shorage(3) 0.3% 0.1% - 0.9% 0.5% 0.1% - 2.3% 0.3% 0.1% - 0.8% Other Mean Score (0- 3) 0.06 -0.02 - 0.14 0.61 0.19 - 1.04 0.14 0.06 - 0.21 No Shortage (0) 95.2% 78.7% - 99.1% 64.9% 38.5% - 84.6% 90.8% 80.9% - 95.9% Slight Shortage (1) 4.3% 0.7% - 22.7% 16.4% 5.2% - 41.3% 6.0% 1.8% - 18.3% Moderate Shortage (2) 0.0% N/A - N/A 10.9% 3.5% - 29.0% 1.6% 0.6% - 3.8% Severe Shorage(3) 0.6% 0.5% - 0.6% 7.8% 3.0% - 18.7% 1.6% 1.0% - 2.6% Observations 894 800 1,693 N/A: confidence interval could not be calculated. G-97 Table G.23 Page 4 of 4 ------- Table G.24. Question C.3: What factors contribute to personnel shortages you identified in questions C.l and C.2? (check all that apply) All Utilities Estimates and 95 Percent Confidence Intervals Factor Response Percentage Reporting by Population Served < 10,000 > 10,000 All Absenteeism (illness, care of family members, daycare closure, virtual schooling, etc.) Mean Score (0-2) 1.04 0.93 - 1.14 1.30 1.22 - 1.38 1.10 1.02 - 1.18 Does Not Contribute (0) 25.7% 19.4% - 33.1% 9.3% 6.2% - 13.7% 21.4% 16.7% - 27.0% Contributes Somewhat (1) 45.1% 37.8% - 52.7% 51.7% 45.0% - 58.4% 46.9% 41.1% - 52.7% Contributes Significantly (2) 29.2% 23.5% - 35.6% 39.0% 32.7% - 45.6% 31.7% 27.1% - 36.7% Layoffs or furloughs Mean Score (0-2) 0.16 0.10 - 0.23 0.18 0.11 - 0.25 0.17 0.12 - 0.22 Does Not Contribute (0) 87.0% 80.6% - 91.5% 86.8% 81.2% - 90.9% 86.9% 82.2% - 90.6% Contributes Somewhat (1) 9.7% 5.7% - 16.1% 8.3% 5.1% - 13.2% 9.4% 6.1% - 14.0% Contributes Significantly (2) 3.3% 1.8% - 6.0% 4.9% 2.6% - 8.9% 3.7% 2.4% - 5.8% Reduced work hours of current staff Mean Score (0-2) 0.44 0.35 - 0.53 0.62 0.52 - 0.73 0.49 0.41 - 0.56 Does Not Contribute (0) 65.1% 57.2% - 72.2% 53.1% 45.9% - 60.1% 62.0% 55.9% - 67.7% Contributes Somewhat (1) 25.7% 19.2% - 33.5% 31.6% 25.2% - 38.9% 27.2% 21.9% - 33.2% Contributes Significantly (2) 9.3% 6.4% - 13.2% 15.3% 10.7% - 21.4% 10.8% 8.3% - 14.0% G-98 Table G.24 Page 1 of 3 ------- Table G.24. Question C.3: What factors contribute to personnel shortages you identified in questions C.l and C.2? (check all that apply) All Utilities Estimates and 95 Percent Confidence Intervals Factor Response Percentage Reporting by Population Served < 10,000 > 10,000 All Delayed or cancelled plans to hire staff Mean Score (0-2) 0.36 0.25 - 0.46 0.62 0.50 - 0.73 0.42 0.34 - 0.51 Does Not Contribute (0) 74.1% 66.7% - 80.4% 55.5% 48.3% - 62.4% 69.4% 63.7% - 74.5% Contributes Somewhat (1) 16.0% 11.2% - 22.3% 27.4% 21.7% - 34.1% 18.9% 14.9% - 23.7% Contributes Significantly (2) 9.9% 6.0% - 15.9% 17.1% 12.1% - 23.6% 11.7% 8.3% - 16.2% Lack of backup certified personnel Mean Score (0-2) 0.78 0.66 - 0.90 0.68 0.57 - 0.79 0.76 0.66 - 0.85 Does Not Contribute (0) 43.1% 35.6% - 50.9% 49.2% 42.1% - 56.3% 44.6% 38.6% - 50.7% Contributes Somewhat (1) 35.8% 28.7% - 43.5% 34.0% 27.6% - 41.0% 35.4% 29.7% - 41.4% Contributes Significantly (2) 21.1% 15.6% - 27.9% 16.8% 11.9% - 23.2% 20.1% 15.6% - 25.4% Operators unable to obtain or maintain needed certification due to lack of in-person training Mean Score (0-2) 0.68 0.57 - 0.79 0.62 0.52 - 0.73 0.67 0.58 - 0.75 Does Not Contribute (0) 51.0% 43.3% - 58.7% 52.2% 45.1% - 59.3% 51.3% 45.2% - 57.4% Contributes Somewhat (1) 30.0% 23.2% - 37.7% 33.2% 26.7% - 40.5% 30.8% 25.3% - 36.8% Contributes Significantly (2) 19.0% 14.2% - 24.9% 14.5% 10.2% - 20.3% 17.9% 14.1% - 22.5% G-99 Table G.24 Page 2 of 3 ------- Table G.24. Question C.3: What factors contribute to personnel shortages you identified in questions C.l and C.2? (check all that apply) All Utilities Estimates and 95 Percent Confidence Intervals Factor Response Percentage Reporting by Population Served < 10,000 > 10,000 All Restrictions on travel Mean Score (0-2) 0.41 0.33 - 0.50 0.53 0.43 - 0.63 0.44 0.38 - 0.51 Does Not Contribute (0) 67.3% 60.3% - 73.6% 58.9% 51.7% - 65.8% 65.2% 59.7% - 70.3% Contributes Somewhat (1) 23.9% 18.2% - 30.8% 29.2% 23.0% - 36.2% 25.2% 20.5% - 30.6% Contributes Significantly (2) 8.8% 6.0% - 12.7% 11.9% 7.9% - 17.5% 9.6% 7.2% - 12.7% Lack of I.T. infrastructure (e.g., equipment, network capacity) Mean Score (0-2) 0.27 0.19 - 0.34 0.37 0.27 - 0.47 0.30 0.23 - 0.36 Does Not Contribute (0) 79.8% 73.6% - 84.8% 71.0% 63.6% - 77.4% 77.5% 72.7% - 81.7% Contributes Somewhat (1) 13.6% 9.3% - 19.4% 20.8% 15.5% - 27.4% 15.4% 11.8% - 19.9% Contributes Significantly (2) 6.6% 4.2% - 10.4% 8.2% 4.5% - 14.4% 7.0% 4.9% - 10.1% Other Mean Score (0-2) 0.54 0.14 - 0.94 0.35 0.13 - 0.56 0.51 0.17 - 0.84 Does Not Contribute (0) 65.4% 39.6% - 84.5% 78.7% 63.4% - 88.8% 67.7% 45.7% - 84.0% Contributes Somewhat (1) 15.0% 3.6% - 45.3% 7.9% 2.9% - 19.9% 13.8% 3.9% - 38.7% Contributes Significantly (2) 19.6% 6.2% - 47.3% 13.3% 6.2% - 26.5% 18.5% 6.8% - 41.4% Observations 295 482 777 G-100 Table G.24 Page 3 of 3 ------- Table G.25. Question C.4: What strategies or resources has your organization used to address potential shortages of certified operators, laboratory staff, or other trained personnel during the COVID-19 pandemic? (select all that apply) All Utilities Estimates and 95 Percent Confidence Intervals Strategy or Resource Percentage Reporting by Population Served < 10,000 > 10,000 All Used technology to allow some operational tasks to be performed remotely 22.7% 19.2% - 26.6% 43.8% 38.5% - 49.3% 26.1% 23.0% - 29.4% Used telework for job functions that could be performed remotely 20.8% 17.2% - 24.9% 53.3% 47.8% - 58.6% 26.0% 22.8% - 29.6% Decreased staffing/changed shift work while maintaining core operations 20.6% 17.5% - 24.0% 56.7% 51.1% - 62.1% 26.4% 23.6% - 29.3% Delayed non-critical work 33.4% 29.4% - 37.7% 61.8% 56.4% - 66.9% 38.0% 34.4% - 41.7% Increased use of contractors 9.6% 7.2% - 12.6% 9.4% 6.8% - 12.9% 9.6% 7.5% - 12.1% Accessed operators from nearby utilities, via WARN or other mutual aid networks 7.6% 5.5% - 10.4% 3.2% 1.5% - 6.6% 6.9% 5.1% - 9.3% Utilized backup laboratory services 5.0% 3.4% - 7.4% 8.2% 5.9% - 11.4% 5.6% 4.1% - 7.5% Other 29.9% 25.6% - 34.5% 14.5% 10.4% - 19.8% 27.4% 23.8% - 31.4% Observations 694 770 1,464 G-101 Table G.25 Page 1 of 1 ------- Table G.26. Question C.4.1: Did the strategies you implemented help mitigate staffing shortages? All Utilities Estimates and 95 Percent Confidence Intervals Strategy or Percentage Reporting by Population Served Resource Response < 10,000 > 10,000 All Used technology (e.g., Strategy Did 7.0% 2.8% 5.8% live video feeds) to allow Not Help 3.6% - 12.9% 1.3% - 6.0% 3.3% - 10.1% some operational tasks Strategy 75.8% 85.0% 78.3% to be performed Helped 66.8% - 83.0% 78.2% - 90.0% 71.5% - 83.8% remotely Not Sure 17.3% 12.1% 15.9% 11.0% - 26.0% 7.5% - 18.9% 11.0% - 22.4% Used telework for job Strategy Did 3.1% 4.0% 3.4% functions that could be Not Help 1.3% - 7.4% 1.9% - 8.1% 1.9% - 6.2% performed remotely Strategy 86.0% 80.7% 84.2% Helped 77.4% - 91.7% 74.0% - 86.1% 78.4% - 88.6% Not Sure 10.9% 15.3% 12.4% 5.9% - 19.4% 10.5% - 21.7% 8.4% - 18.0% Decreased staffing/ Strategy Did 4.4% 4.8% 4.5% changed shift work Not Help 2.3% - 8.0% 2.4% - 9.5% 2.8% - 7.2% while maintaining core Strategy 82.6% 82.3% 82.5% operations Helped 75.1% - 88.1% 76.5% - 86.9% 77.4% - 86.6% Not Sure 13.1% 12.9% 13.0% 8.1% - 20.4% 9.2% - 17.8% 9.4% - 17.8% Delayed non-critical Strategy Did 6.6% 4.3% 6.0% work Not Help 3.9% - 10.9% 2.2% - 8.1% 3.9% - 9.2% Strategy 72.3% 81.0% 74.6% Helped 65.0% - 78.5% 75.0% - 85.9% 69.0% - 79.4% Not Sure 21.1% 14.7% 19.4% 15.5% - 28.1% 10.5% - 20.2% 15.0% - 24.7% G-102 Table G.26 Page 1 of 2 ------- Table G.26. Question C.4.1: Did the strategies you implemented help mitigate staffing shortages? All Utilities Estimates and 95 Percent Confidence Intervals Strategy or Resource Response Percentage Reporting by Population Served < 10,000 > 10,000 All Increased use of contractors Strategy Did Not Help 8.7% 2.6% - 25.8% 5.1% 0.9% - 24.2% 8.1% 2.7% - 22.2% Strategy Helped 83.2% 68.5% - 91.9% 87.1% 70.1% - 95.1% 83.8% 71.5% - 91.5% Not Sure 8.1% 3.7% - 17.0% 7.8% 2.4% - 22.6% 8.0% 4.0% - 15.4% Accessed operators from nearby utilities, including via WARN or other mutual aid networks Strategy Did Not Help 11.9% 4.6% - 27.4% 22.9% 4.8% - 63.5% 12.7% 5.5% - 26.9% Strategy Helped 77.0% 62.0% - 87.4% 53.6% 20.5% - 83.8% 75.3% 61.2% - 85.5% Not Sure 11.0% 5.3% - 21.7% 23.5% 6.4% - 58.2% 12.0% 6.2% - 21.8% Utilized backup laboratory services Strategy Did Not Help 2.4% 0.6% - 9.5% 17.8% 5.9% - 42.8% 6.1% 2.4% - 14.8% Strategy Helped 85.5% 71.3% - 93.3% 74.6% 53.7% - 88.2% 82.9% 71.3% - 90.5% Not Sure 12.0% 5.0% - 26.2% 7.6% 3.7% - 15.0% 11.0% 5.3% - 21.4% Other Strategy Did Not Help 21.1% 13.8% - 30.8% 13.7% 4.6% - 34.1% 20.6% 13.8% - 29.8% Strategy Helped 53.7% 43.1% - 64.0% 70.3% 52.2% - 83.7% 54.8% 44.7% - 64.5% Not Sure 25.1% 16.9% - 35.6% 16.0% 7.6% - 30.7% 24.6% 16.8% - 34.4% Observations 282 502 784 G-103 Table G.26 Page 2 of 2 ------- Table G.27. Question C.5: What is the greatest concern your organization has associated with maintaining staffing during the pandemic? (select one) All Utilities Estimates and 95 Percent Confidence Intervals Concern Percentage Reporting by Population Served < 10,000 > 10,000 All Availability of testing for illness 6.3% 4.5% - 8.8% 10.9% 7.9% - 14.7% 7.0% 5.3% - 9.1% Availability of PPE 12.1% 9.5% - 15.3% 10.4% 8.1% - 13.4% 11.9% 9.6% - 14.6% Ability to house personnel on site 1.7% 0.9% - 3.1% 4.7% 2.9% - 7.5% 2.1% 1.4% - 3.3% Cross-training personnel 9.3% 7.1% - 11.9% 7.6% 5.3% - 10.8% 9.0% 7.1% - 11.3% Protecting high-risk employees 21.7% 18.3% - 25.6% 27.4% 23.1% - 32.2% 22.6% 19.6% - 25.9% Adhering to changing local and state 28.6% 24.7% - 32.8% 29.6% 24.6% - 35.1% 28.7% 25.4% - 32.4% Other 20.4% 16.9% - 24.3% 9.5% 6.9% - 12.9% 18.7% 15.8% - 22.1% Observations 783 802 1,585 G-104 Table G.27 Page 1 of 1 ------- Table G.28. Question Dl.1.2: Please indicate the state of your organization's operating budget from January 2020 to the present All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Average Operating Budget by Population Served (Dollars) Parameter < 10,000 > 10,000 All Budgeted $376,271 $15,033,541 $2,385,643 Revenue $262,105 - $490,437 $11,504,776 - $18,562,306 $1,905,012 - $2,866,274 Actual $352,208 $14,753,752 $2,326,523 Revenue $236,185 - $468,231 $11,260,528 - $18,246,976 $1,848,005 - $2,805,040 Budgeted $312,882 $12,095,451 $1,928,160 Expenses $239,649 - $386,115 $9,222,401 - $14,968,501 $1,538,323 - $2,317,997 Actual $280,859 $10,984,744 $1,748,260 Expenses $214,224 - $347,494 $8,296,954 - $13,672,534 $1,384,942 - $2,111,577 Observations 222 319 541 G-105 Table G.28 Page 1 of 1 ------- Table G.29. Average Budgeted and Actual Net Revenue (Calculated) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Parameter Average Net Revenue by Population Served (Dollars) < 10,000 > 10,000 All Budgeted Net Revenue $63,389 $15,727 - $111,051 $2,938,090 $1,884,544 - $3,991,635 $457,483 $309,891 - $605,076 Actual Net Revenue $71,349 $16,458 - $126,240 $3,769,009 $2,640,039 - $4,897,978 $578,263 $417,111 - $739,414 Observations 222 319 541 G-106 Table G.29 Page 1 of 1 ------- Table G.30. Percentage of Utilities with a Deficit/Loss, and Total Deficit/Loss at Those Utilities (Calculated) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Utility Deficits by Population Served (Dollars in Millions) Parameter < 10,000 > 10,000 All Percentage of Utilities 24% 17% 23% with Deficit/Loss 17% - 34% 12% - 24% 17% - 32% Total Deficit/Loss $638.6 $1,566.1 $2,204.7 (Utilities with Deficit/Loss) $407.0 - $870.2 $816.6 - $2,315.6 $1,442.8 - $2,966.7 Observations 222 319 541 G-107 Table G.30 Page 1 of 1 ------- Table G.31. Average Difference between Actual and Budgeted Net Revenue, Percentage of Utilities with a Shortfall, and Total Shortfall at Those Utilities (Calculated) All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Parameter Difference between Actual and Budgeted Net Revenue by Population Served < 10,000 > 10,000 All Average Difference in Net Revenue (Actual Minus Budgeted Net Revenue) $7,960 -$9,021 - $24,941 $830,919 $486,307 - $1,175,530 $120,780 $69,660 - $171,899 Percentage of Utilities with Shortfall 32% 24% - 42% 31% 23%- 39% 32% 25%- 40% Total Shortfall in Utilities with Shortfall (Millions of Dollars) $1,252.0 $775.0 - $1,729.1 $2,506.2 $1,538.3 - $3,474.2 $3,758.2 $2,695.9 - $4,820.6 Observations 222 319 541 G-108 Table G.31 Page 1 of 1 ------- Table G.32. Question D.1.2: Your answers indicate that actual operating revenue was lower than budgeted during the January to present period. What COVID-19-related factors contributed to this? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Percentage Reporting by Population Served Factor Response < 10,000 > 10,000 All Nonpayment Mean Score 0.73 0.82 0.74 of bills (Oto 2) 0.54 - 0.92 0.66 - 0.97 0.59 - 0.90 Not a Contributor 48.7% 32.3% 45.6% (0) 37.8% - 59.8% 22.6% - 43.7% 36.5% - 54.9% Contributor (1) 26.3% 45.0% 29.9% 18.1% - 36.7% 33.7% - 56.8% 22.6% - 38.4% Significant 22.3% 15.2% 21.0% Contributor (2) 14.1% - 33.4% 9.1% - 24.3% 14.1% - 30.0% Do Not Know 2.6% 7.5% 3.6% 1.0% - 6.8% 3.2% - 16.4% 1.8% - 6.9% Decreased use Mean Score 0.36 0.63 0.41 (Oto 2) 0.23 - 0.50 0.45 - 0.81 0.29 - 0.53 Not a Contributor 71.2% 47.0% 66.6% (0) 61.0% - 79.7% 35.7% - 58.6% 58.3% - 74.0% Contributor (1) 15.2% 29.4% 17.9% 9.5% - 23.4% 20.3% - 40.5% 12.8% - 24.5% Significant 9.9% 13.8% 10.6% Contributor (2) 5.2% - 18.0% 7.6% - 23.9% 6.4% - 17.1% Do Not Know 3.7% 9.8% 4.9% 1.0% - 12.8% 4.6% - 19.7% 2.1% - 11.0% G-109 Table G.32 Page 1 of 2 ------- Table G.32. Question D.1.2: Your answers indicate that actual operating revenue was lower than budgeted during the January to present period. What COVID-19-related factors contributed to this? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Percentage Reporting by Population Served Factor Response < 10,000 > 10,000 All Reduction in Mean Score 0.09 0.24 0.11 rates/fees (Oto 2) -0.01 - 0.18 0.10 - 0.38 0.03 - 0.20 Not a Contributor 94.0% 76.5% 90.7% (0) 85.9% - 97.6% 64.7% - 85.2% 84.7% - 94.5% Contributor (1) 2.1% 8.8% 3.3% 0.7% - 6.4% 3.9% - 18.7% 1.7% - 6.7% Significant 3.2% 6.7% 3.9% Contributor (2) 0.7% - 13.0% 2.7% - 15.6% 1.4% - 10.4% Do Not Know 0.7% 8.1% 2.1% 0.2% - 2.8% 3.3% - 18.4% 1.0% - 4.4% Observations 128 162 290 G-110 Table G.32 Page 2 of 2 ------- Table G.33. Question D.1.3: Your answers indicate that actual operating expenses were higher than budgeted during the January to present period. What COVID-19-related factors contributed? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Percentage Reporting by Population Served Factor Response < 10,000 > 10,000 All Personnel Costs Mean Score 0.38 0.40 0.39 (Oto 2) 0.18 - 0.59 0.21 - 0.59 0.21 - 0.57 Not a Contributor 68.9% 64.3% 68.2% (0) 52.7% - 81.5% 45.7% - 79.4% 54.3% - 79.5% Contributor (1) 22.4% 28.0% 23.2% 12.1% - 37.9% 14.3% - 47.5% 13.8% - 36.4% Significant 7.8% 5.8% 7.5% Contributor (2) 2.4% - 22.7% 2.5% - 12.5% 2.6% - 19.8% Do Not Know 0.9% 2.0% 1.1% 0.1% - 6.3% 0.4% - 8.4% 0.2% - 4.7% Consumables Mean Score 0.57 0.66 0.58 (Oto 2) 0.35 - 0.79 0.41 - 0.91 0.39 - 0.78 Not a Contributor 56.1% 42.4% 54.1% (0) 40.2% - 70.8% 25.2% - 61.6% 40.4% - 67.3% Contributor (1) 30.7% 47.7% 33.1% 18.1% - 46.8% 30.1% - 65.9% 21.7% - 46.9% Significant 13.3% 8.6% 12.6% Contributor (2) 6.0% - 26.8% 2.3% - 27.4% 6.1% - 24.2% Do Not Know 0.0% 1.3% 0.2% N/A - N/A 0.2% - 9.1% 0.0% - 1.3% G-111 Table G.33 Page 1 of 2 ------- Table G.33. Question D.1.3: Your answers indicate that actual operating expenses were higher than budgeted during the January to present period. What COVID-19-related factors contributed? All Utilities January to the Present Estimates and 95 Percent Confidence Intervals Factor Response Percentage Reporting by Population Served < 10,000 > 10,000 All Utilities Costs Mean Score (Oto 2) 0.43 0.21 - 0.64 0.23 0.08 - 0.39 0.40 0.21 - 0.58 Not a Contributor (0) 61.7% 45.2% - 75.8% 78.0% 59.5% - 89.6% 64.0% 49.5% - 76.3% Contributor (1) 26.9% 14.8% - 43.7% 20.7% 9.4% - 39.5% 26.0% 15.3% - 40.6% Significant Contributor (2) 6.8% 1.8% - 22.6% 1.3% 0.3% - 5.2% 6.0% 1.7% - 19.6% Do Not Know 4.6% 1.6% - 12.3% 0.0% N/A - N/A 4.0% 1.4% - 10.6% PPE Mean Score (Oto 2) 0.25 0.12 - 0.39 0.52 0.32 - 0.71 0.29 0.17 - 0.41 Not a Contributor (0) 75.2% 60.1% - 86.0% 50.2% 31.9% - 68.4% 71.7% 59.0% - 81.7% Contributor (1) 22.8% 12.4% - 38.2% 46.0% 28.3% - 64.8% 26.1% 16.4% - 39.0% Significant Contributor (2) 1.0% 0.2% - 5.8% 2.5% 0.8% - 8.0% 1.2% 0.3% - 4.4% Do Not Know 0.9% 0.1% - 6.3% 1.3% 0.2% - 9.1% 1.0% 0.2% - 4.8% Observations 64 59 123 N/A: confidence interval could not be calculated. G-112 Table G.33 Page 2 of 2 ------- Table G.34. Question D.2.1: Do you expect your financial situation for the remainder of the year to improve, to worsen, or to stay about the same, compared with the January to present timeframe? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Value Type Response Percentage Reporting by Population Served < 10,000 > 10,000 All Operating Revenue Mean Score (0 to 2) 1.02 0.99 - 1.06 0.99 0.94 - 1.05 1.02 0.99 - 1.05 Improve (0) 5.8% 4.2% - 8.0% 12.0% 9.0% - 15.8% 6.6% 5.1% - 8.5% Stay About the Same (1) 69.4% 65.3% - 73.2% 67.6% 62.5% - 72.4% 69.1% 65.6% - 72.5% Worsen (2) 7.6% 5.8% - 9.9% 11.4% 8.3% - 15.5% 8.1% 6.5% - 10.2% Do Not Know 17.2% 14.1% - 20.8% 9.0% 6.8% - 12.0% 16.2% 13.4% - 19.3% Operating Expenses Mean Score (0 to 2) 1.02 1.00 - 1.05 1.03 0.99 - 1.07 1.03 1.00 - 1.05 Improve (0) 3.3% 2.1% - 5.2% 5.1% 3.4% - 7.5% 3.5% 2.4% - 5.1% Stay About the Same (1) 73.3% 69.4% - 76.9% 79.6% 75.2% - 83.5% 74.1% 70.7% - 77.3% Worsen (2) 5.4% 4.0% - 7.1% 8.0% 5.4% - 11.6% 5.7% 4.5% - 7.3% Do Not Know 18.0% 14.8% - 21.6% 7.3% 5.2% - 10.1% 16.6% 13.8% - 19.8% Observations 824 763 1,587 G-113 Table G.34 Page 1 of 1 ------- Table G.35. Question D.2.2: To what COVID-19-related factors do you attribute the worsening outlook for operating revenue in the remainder of 2020? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Factor Response Percentage Reporting by Population Served < 10,000 > 10,000 All Nonpayment of bills Mean Score (0 to 2) 1.36 1.18 - 1.55 1.31 1.08 - 1.54 1.35 1.20 - 1.51 Not a Contributor (0) 11.8% 6.5% - 20.6% 12.6% 5.1% - 27.7% 12.0% 7.1% - 19.3% Contributor (1) 35.7% 23.1% - 50.7% 43.0% 27.2% - 60.4% 37.1% 26.1% - 49.6% Significant Contributor (2) 45.8% 31.8% - 60.4% 43.6% 27.7% - 60.9% 45.4% 33.5% - 57.8% Do Not Know 6.7% 1.8% - 21.9% 0.8% 0.2% - 3.2% 5.6% 1.6% - 18.0% Decreased use Mean Score (0 to 2) 0.44 0.26 - 0.62 0.67 0.39 - 0.96 0.49 0.33 - 0.64 Not a Contributor (0) 58.9% 44.2% - 72.2% 55.1% 38.6% - 70.6% 58.2% 45.9% - 69.6% Contributor (1) 21.0% 11.4% - 35.3% 22.0% 12.4% - 36.0% 21.2% 12.9% - 32.8% Significant Contributor (2) 9.0% 4.4% - 17.6% 22.5% 11.5% - 39.3% 11.5% 6.9% - 18.7% Do Not Know 11.1% 4.5% - 24.9% 0.4% 0.1% - 2.9% 9.1% 3.7% - 20.6% G-114 Table G.35 Page 1 of 2 ------- Table G.35. Question D.2.2: To what COVID-19-related factors do you attribute the worsening outlook for operating revenue in the remainder of 2020? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Percentage Reporting by Population Served Factor Response < 10,000 > 10,000 All Reduction in Mean Score (0 to 2) 0.23 0.70 0.33 rates/fees 0.08 - 0.38 0.37 - 1.04 0.19 - 0.47 Not a Contributor (0) 67.9% 57.7% 66.0% 52.7% - 80.0% 40.2% - 73.6% 53.3% - 76.7% Contributor (1) 15.4% 13.6% 15.0% 6.8% - 31.0% 6.8% - 25.4% 7.6% - 27.5% Significant Contributor 2.1% 28.2% 6.9% (2) 0.6% - 7.7% 14.3% - 48.0% 3.6% - 12.8% Do Not Know 14.6% 0.5% 12.0% 7.0% - 28.1% 0.1% - 3.2% 5.8% - 23.2% Observations 86 82 168 G-115 Table G.35 Page 2 of 2 ------- Table G.36. Question D.2.3: To what COVID-19-related factors do you attribute the worsening outlook for operating expenses in the remainder of 2020? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Factor Response Percentage Reporting by Population Served < 10,000 > 10,000 All Personnel Costs Mean Score (0 to 2) 0.72 0.51 - 0.92 1.19 0.88 - 1.49 0.81 0.64 - 0.98 Not a Contributor (0) 47.8% 35.9% - 59.9% 16.7% 6.4% - 37.3% 41.9% 32.1% - 52.4% Contributor (1) 27.2% 17.1% - 40.5% 47.9% 28.5% - 67.9% 31.1% 21.9% - 42.2% Significant Contributor (2) 20.8% 12.0% - 33.4% 35.4% 17.8% - 58.1% 23.5% 15.3% - 34.5% Do Not Know 4.2% 1.1% - 15.2% 0.0% N/A - N/A 3.4% 0.9% - 12.5% Consumables Mean Score (0 to 2) 1.18 0.95 - 1.42 1.28 0.97 - 1.58 1.20 1.00 - 1.40 Not a Contributor (0) 21.7% 10.2% - 40.3% 14.8% 5.1% - 36.0% 20.3% 10.5% - 35.7% Contributor (1) 33.7% 19.9% - 50.9% 38.6% 21.3% - 59.5% 34.6% 22.5% - 49.2% Significant Contributor (2) 39.0% 27.3% - 52.1% 41.1% 23.1% - 61.8% 39.4% 29.1% - 50.8% Do Not Know 5.7% 1.8% - 16.8% 5.5% 0.7% - 31.3% 5.6% 2.0% - 14.7% G-116 Table G.36 Page 1 of 2 ------- Table G.36. Question D.2.3: To what COVID-19-related factors do you attribute the worsening outlook for operating expenses in the remainder of 2020? All Utilities Present to December Estimates and 95 Percent Confidence Intervals Factor Response Percentage Reporting by Population Served < 10,000 > 10,000 All Utilities Costs Mean Score (0 to 2) 0.93 0.61 - 1.24 0.64 0.30 - 0.97 0.87 0.60 - 1.14 Not a Contributor (0) 33.6% 19.6% - 51.3% 54.0% 33.8% - 72.9% 37.5% 24.8% - 52.2% Contributor (1) 31.8% 21.0% - 45.2% 21.0% 9.4% - 40.5% 29.8% 20.5% - 41.2% Significant Contributor (2) 27.0% 14.3% - 44.9% 19.5% 8.3% - 39.5% 25.5% 14.7% - 40.5% Do Not Know 7.6% 2.7% - 19.3% 5.5% 0.7% - 31.3% 7.2% 2.9% - 16.8% PPE Mean Score (0 to 2) 0.65 0.43 - 0.87 0.86 0.57 - 1.15 0.69 0.50 - 0.88 Not a Contributor (0) 48.0% 31.8% - 64.6% 35.6% 18.9% - 56.8% 45.6% 32.0% - 59.9% Contributor (1) 33.8% 19.7% - 51.5% 43.0% 24.4% - 63.8% 35.6% 23.1% - 50.3% Significant Contributor (2) 14.2% 7.4% - 25.6% 21.4% 9.7% - 40.8% 15.6% 9.3% - 25.0% Do Not Know 4.0% 0.9% - 15.4% 0.0% N/A - N/A 3.2% 0.8% - 12.7% Observations 65 52 118 N/A: confidence interval could not be calculated. G-117 Table G.36 Page 2 of 2 ------- Table G.37. Question D.3.1: If your organization has experienced or anticipates a decrease in cash flow due to COVID-19, what mitigating actions are you taking or planning? (select all that apply) All Utilities Estimates and 95 Percent Confidence Intervals Response Percentage Reporting by Population Served < 10,000 > 10,000 All Drawing down days cash 7.0% 9.4% 7.3% on hand 5.1% - 9.5% 6.8% - 12.9% 5.6% - 9.5% Drawing on reserve 22.2% 38.9% 24.5% funds 18.8% - 26.0% 33.3% - 44.8% 21.4% - 27.8% Delaying maintenance 16.2% 26.4% 17.6% 13.5% - 19.5% 21.2% - 32.4% 15.1% - 20.5% Reducing statt hours 5.3% 5.3% 5.3% 3.7% - 7.5% 3.4% - 8.1% 3.9% - 7.2% Reducing staff pay and/or 1.5% 4.6% 1.9% benefits 0.7% - 3.2% 2.7% - 7.9% 1.1% - 3.3% Laying off staff 2.0% 3.3% 2.1% 1.1% - 3.5% 1.9% - 5.8% 1.3% - 3.4% Incurring additional debt 5.6% 4.2% 5.4% 3.9% - 8.1% 2.6% - 6.6% 3.9% - 7.6% Refinancing debt and/or 2.0% 3.5% 2.2% deferring debt payments 1.2% - 3.5% 2.2% - 5.7% 1.4% - 3.5% Delaying/canceling capital 19.2% 36.1% 21.5% improvement projects 16.1% - 22.7% 31.0% - 41.6% 18.7% - 24.5% Adjusting rates higher than 5.9% 6.3% 5.9% originally planned 4.3% - 8.1% 4.3% - 9.1% 4.5% - 7.9% Not applicable (no 55.1% 33.2% 52.1% decrease in cash flow) 50.6% - 59.4% 28.2% - 38.6% 48.2% - 55.9% Observations 734 707 1,441 G-118 Table G.37 Page 1 fo 1 ------- Table G.38. Question D.3.2: What type of impact do you think these actions are making or will make in mitigating the decrease in your organization's cash flow? All Utilities Estimates and 95 Percent Confidence Intervals Action Response Percentage Reporting by Population Served < 10,000 > 10,000 All Drawing down days cash on hand Mean Score (1 to 2) 1.26 1.09 - 1.43 1.20 1.02 - 1.38 1.25 1.11 - 1.39 Small Impact (1) 62.0% 45.6% - 76.1% 67.4% 49.1% - 81.7% 63.0% 49.0% - 75.1% Large Impact (2) 21.6% 10.2% - 40.0% 17.0% 6.3% - 38.5% 20.8% 10.9% - 36.2% Do Not Know 16.3% 6.8% - 34.2% 15.5% 7.3% - 30.0% 16.2% 7.8% - 30.6% Observations 63 87 150 Drawing on reserve funds Mean Score (1 to 2) 1.30 1.20 - 1.40 1.29 1.17 - 1.41 1.30 1.22 - 1.38 Small Impact (1) 53.6% 44.4% - 62.6% 55.4% 44.9% - 65.4% 54.0% 46.5% - 61.4% Large Impact (2) 23.3% 16.2% - 32.2% 22.7% 14.0% - 34.5% 23.1% 17.2% - 30.4% Do Not Know 23.1% 16.1% - 32.0% 22.0% 15.1% - 30.8% 22.9% 17.0% - 30.0% Observations 193 253 446 Delaying maintenance Mean Score (1 to 2) 1.35 1.24 - 1.46 1.24 1.14 - 1.35 1.33 1.24 - 1.41 Small Impact (1) 47.9% 38.1% - 57.9% 67.8% 55.9% - 77.8% 52.0% 43.5% - 60.4% Large Impact (2) 26.1% 18.4% - 35.6% 21.9% 13.8% - 32.9% 25.2% 18.7% - 33.0% Do Not Know 26.0% 17.8% - 36.4% 10.3% 5.4% - 18.7% 22.8% 16.0% - 31.4% Observations 165 172 337 G-119 Table G.38 Page 1 of 4 ------- Table G.38. Question D.3.2: What type of impact do you think these actions are making or will make in mitigating the decrease in your organization's cash flow? All Utilities Estimates and 95 Percent Confidence Intervals Action Response Percentage Reporting by Population Served < 10,000 > 10,000 All Reducing staff hours Mean Score (1 to 2) 1.41 1.21 - 1.60 1.28 1.01 - 1.54 1.39 1.22 - 1.56 Small Impact (1) 50.1% 33.8% - 66.3% 60.4% 37.1% - 79.8% 51.5% 36.9% - 65.9% Large Impact (2) 34.5% 20.0% - 52.6% 23.0% 7.9% - 51.0% 32.9% 20.0% - 49.0% Do Not Know 15.4% 8.3% - 26.8% 16.6% 8.9% - 29.0% 15.6% 9.2% - 25.3% Observations 57 41 98 Reducing staff pay and/or benefits Mean Score (1 to 2) 1.30 1.09 - 1.52 1.42 1.23 - 1.62 1.34 1.22 - 1.46 Small Impact (1) 53.2% 14.0% - 88.9% 44.5% 30.6% - 59.4% 50.3% 21.9% - 78.6% Large Impact (2) 23.3% 10.6% - 43.8% 32.5% 14.7% - 57.5% 26.4% 16.6% - 39.2% Do Not Know 23.4% 2.3% - 80.0% 22.9% 8.1% - 50.2% 23.3% 4.9% - 64.0% Observations 11 28 39 Laying off staff Mean Score (1 to 2) 1.68 1.14 - 2.22 1.63 1.23 - 2.02 1.67 1.24 - 2.11 Small Impact (1) 21.8% 3.3% - 69.6% 25.6% 7.6% - 58.8% 22.6% 5.3% - 60.4% Large Impact (2) 46.8% 15.0% - 81.5% 43.4% 17.0% - 74.2% 46.1% 18.9% - 75.8% Do Not Know 31.4% 15.0% - 54.4% 31.0% 10.7% - 62.9% 31.4% 16.9% - 50.6% Observations 19 24 43 G-120 Table G.38 Page 2 of 4 ------- Table G.38. Question D.3.2: What type of impact do you think these actions are making or will make in mitigating the decrease in your organization's cash flow? All Utilities Estimates and 95 Percent Confidence Intervals Action Response Percentage Reporting by Population Served < 10,000 > 10,000 All Incurring additional debt Mean Score (1 to 2) 1.59 1.35 - 1.82 1.29 1.03 - 1.56 1.55 1.35 - 1.76 Small Impact (1) 33.8% 17.6% - 54.9% 58.5% 34.7% - 78.9% 36.4% 21.1% - 55.1% Large Impact (2) 47.9% 28.9% - 67.5% 24.3% 8.8% - 51.5% 45.4% 28.4% - 63.6% Do Not Know 18.3% 8.1% - 36.4% 17.2% 8.1% - 32.8% 18.2% 8.7% - 34.2% Observations 46 36 82 Refinancing debt and/or deferring debt payments Mean Score (1 to 2) 1.60 1.39 - 1.81 1.57 1.28 - 1.85 1.59 1.42 - 1.76 Small Impact (1) 24.1% 13.2% - 40.0% 39.3% 18.0% - 65.6% 27.4% 17.3% - 40.5% Large Impact (2) 35.6% 10.2% - 72.8% 51.3% 27.1% - 74.8% 39.0% 15.8% - 68.5% Do Not Know 40.3% 13.0% - 75.4% 9.5% 3.2% - 25.0% 33.6% 12.4% - 64.6% Observations 25 36 61 Delaying/ canceling capital improvement projects Mean Score (1 to 2) 1.48 1.38 - 1.59 1.34 1.24 - 1.43 1.45 1.37 - 1.53 Small Impact (1) 39.5% 31.3% - 48.2% 56.9% 47.9% - 65.5% 43.5% 36.8% - 50.5% Large Impact (2) 37.0% 28.3% - 46.7% 28.9% 21.5% - 37.8% 35.2% 28.2% - 42.8% Do Not Know 23.5% 16.1% - 33.0% 14.2% 9.5% - 20.6% 21.3% 15.4% - 28.7% Observations 175 276 451 G-121 Table G.38 Page 3 of 4 ------- Table G.38. Question D.3.2: What type of impact do you think these actions are making or will make in mitigating the decrease in your organization's cash flow? All Utilities Estimates and 95 Percent Confidence Intervals Action Response Percentage Reporting by Population Served < 10,000 > 10,000 All Adjusting rates Mean Score (1 to 1.53 1.56 1.54 higher than 2) 1.33 - 1.74 1.34 - 1.78 1.36 - 1.72 originally Small Impact (1) 38.2% 37.0% 38.0% planned 23.1% - 56.0% 20.3% - 57.6% 24.6% - 53.6% Large Impact (2) 43.7% 47.0% 44.1% 27.3% - 61.5% 27.8% - 67.0% 29.6% - 59.7% Do Not Know 18.2% 16.0% 17.9% 10.3% - 30.1% 5.8% - 37.2% 10.7% - 28.2% Observations 57 48 105 G-122 Table G.38 Page 4 of 4 ------- Table G.39. Question D.4: Which of the following is your organization considering regarding capital infrastructure projects due to COVID-19? (select all that apply) All Utilities Estimates and 95 Percent Confidence Intervals Changes Percentage Reporting by Population Served < 10,000 > 10,000 All Not applicable (no projects planned) 35.9% 31.8% - 40.2% 5.3% 3.4% - 8.3% 31.9% 28.3% - 35.7% No changes to current or planned projects 34.8% 30.9% - 39.1% 52.4% 46.9% - 57.8% 37.2% 33.6% - 40.9% Pausing/slowing a project for which construction has begun 4.2% 2.9% - 5.9% 9.1% 6.3% - 13.1% 4.8% 3.7% - 6.4% Delaying starting a project 9.7% 7.6% - 12.4% 24.8% 20.5% - 29.7% 11.7% 9.7% - 14.0% Accelerating starting a project 2.5% 1.5% - 4.3% 2.8% 1.4% - 5.5% 2.5% 1.6% - 4.0% Reducing the scope or funding for a project for which construction has begun 1.1% 0.5% - 2.5% 2.2% 1.4% - 3.6% 1.3% 0.7% - 2.4% Increasing the scope or funding for a project (current or planned) 0.9% 0.4% - 1.7% 1.9% 0.8% - 4.4% 1.0% 0.6% - 1.7% Delaying applying for a subsidized loan/grant by at least six months 1.3% 0.7% - 2.5% 1.9% 0.9% - 3.8% 1.4% 0.8% - 2.4% Accelerating interest in applying for a subsidized loan/grant for a shovel-ready project 0.6% 0.3% - 1.3% 5.5% 3.4% - 8.8% 1.3% 0.8% - 1.9% Other 2.8% 1.8% - 4.4% 2.7% 1.8% - 4.0% 2.8% 1.8% - 4.2% Do not know 8.3% 6.2% - 11.1% 5.2% 3.2% - 8.3% 7.9% 6.1% - 10.3% Observations 800 749 1,549 G-123 Table G.39 Page 1 of 1 ------- Table G.40. Question D.5: In response to COVID-19, what actions has your organization taken to help alleviate economic impacts on customers? (select all that apply) All Utilities Estimates and 95 Percent Confidence Intervals Actions Percentage Reporting by Population Served < 10,000 > 10,000 All Suspended service shutoffs 49.4% 45.2% - 53.6% 68.8% 63.9% - 73.4% 51.9% 48.2% - 55.6% Waived late payment fees 33.3% 29.7% - 37.2% 50.1% 44.7% - 55.6% 35.5% 32.2% - 39.0% Provided extensions on bill payment 41.9% 37.8% - 46.1% 57.8% 52.5% - 62.9% 44.0% 40.3% - 47.7% Expanded customer assistance programs 6.0% 4.4% - 8.1% 24.3% 19.5% - 29.8% 8.4% 6.8% - 10.3% Expanded water conservation programs 1.5% 0.8% - 2.8% 4.6% 2.8% - 7.5% 1.9% 1.2% - 3.0% Delayed or eliminated planned rate adjustment 5.4% 3.9% - 7.5% 11.7% 8.1% - 16.6% 6.2% 4.8% - 8.1% Lowered rates 0.1% 0.0% - 0.4% 1.1% 0.4% - 3.1% 0.2% 0.1% - 0.5% Other 2.2% 1.2% - 3.9% 2.3% 1.3% - 4.1% 2.2% 1.3% - 3.7% None (no actions taken) 32.2% 28.3% - 36.4% 11.2% 8.6% - 14.5% 29.5% 26.1% - 33.2% Do not know 4.9% 3.3% - 7.2% 8.3% 5.9% - 11.6% 5.4% 3.9% - 7.3% Observations 817 759 1,576 G-124 Table G.40 Page 1 of 1 ------- Table G.41. Question El: What COVID-19-related conditions have interfered with your organization's ability to complete the required sampling needed to operate your system and to determine compliance with regulations? Percentage Reporting by Population Served Response < 10,000 > 10,000 All Lack of available personnel 2.4% 5.0% 2.7% for sample collection 1.3% - 4.3% 3.1% - 8.0% 1.7% - 4.3% Lack of available supplies 1.1% 1.5% 1.1% for sampling and/or shipping 0.5% - 2.2% 0.7% - 3.0% 0.6% - 2.1% Lack of available personal 0.7% 6.4% 1.5% protective equipment 0.4% - 1.5% 3.2% - 12.3% 0.9% - 2.5% Lack of access to approved 5.1% 12.9% 6.1% monitoring locations 3.5% - 7.3% 9.0% - 18.0% 4.6% - 8.1% Other 1.5% 2.6% 1.7% 0.8% - 3.0% 1.5% - 4.3% 1.0% - 2.8% None 88.8% 78.6% 87.5% 85.9% - 91.2% 73.1% - 83.2% 84.8% - 89.7% Do not know 2.1% 0.3% 1.9% 1.1% - 4.1% 0.1% - 0.8% 1.0% - 3.5% Observations 798 752 1,550 G-125 Table G.41 Page 1 of 1 ------- Table G.42. Question E2: What COVID-19-related conditions have interfered with your organization's ability to complete required laboratory analyses needed to operate your system and to determine compliance with regulations? All Utilities Estimates and 95 Percent Confidence Intervals Percentage Reporting by Population Served Response < 10,000 > 10,000 All Lack of available laboratory 1.0% 4.2% 1.4% personnel 0.5% - 2.2% 2.8% - 6.3% 0.9% - 2.3% Lack of available supplies for 0.8% 1.7% 0.9% sampling and/or shipping 0.3% - 1.9% 0.8% - 3.6% 0.4% - 1.8% Lack of available personal 0.6% 3.3% 1.0% protective equipment 0.3% - 1.3% 1.7% - 6.0% 0.6% - 1.6% Internal laboratory capacity 1.0% 1.5% 1.1% shortages that delay timely analysis 0.4% - 2.8% 0.6% - 3.4% 0.5% - 2.5% Decreased access to external 3.2% 3.2% 3.2% laboratory services 1.9% - 5.3% 1.8% - 5.6% 2.0% - 5.0% Delays in external laboratory 4.6% 6.8% 4.9% services 3.0% - 7.0% 4.3% - 10.5% 3.4% - 7.0% Sample transport delays 3.0% 2.7% 2.9% 1.8% - 4.8% 1.5% - 4.9% 1.9% - 4.5% Travel restrictions 0.9% 1.4% 1.0% 0.4% - 2.4% 0.7% - 2.8% 0.5% - 2.1% Revenue interruption 0.8% 0.2% 0.7% 0.3% - 2.4% 0.1% - 0.6% 0.3% - 2.0% Other 1.1% 2.6% 1.3% 0.4% - 2.9% 1.5% - 4.4% 0.6% - 2.7% None 85.1% 84.1% 85.0% 81.6% - 88.0% 79.9% - 87.5% 81.9% - 87.6% Do not know 3.2% 1.3% 2.9% 1.9% - 5.3% 0.5% - 3.4% 1.8% - 4.7% Observations 799 750 1,549 G-126 Table G.42 Page 1 of 1 ------- Table G.43. Question Fl: Has your organization experienced any issues or concerns related to cybersecurity during the pandemic? (Yes/No) All Utilities Estimates and 95 Percent Confidence Intervals Response Percentage Reporting by Population Served < 10,000 > 10,000 All Percentage of Systems with Cybersecurity Concerns 0.9% 0.4% - 2.0% 5.2% 3.6% - 7.5% 1.4% 0.9% - 2.3% Observations 814 753 1,567 G-127 Table G.43 Page 1 of 1 ------- Table G.44. Gl. Looking ahead to the next several months, please indicate your level of concern about topics covered in this survey. All Utilities Estimates and 95 Percent Confidence Intervals Topics of Concern Response Percentage Reporting by Population Served < 10,000 > 10,000 All Supply Chain Mean Score 0.59 0.54 - 0.65 0.89 0.83 - 0.96 0.63 0.59 - 0.68 No Concern 45.4% 41.1% - 49.8% 22.9% 18.6% - 27.9% 42.4% 38.6% - 46.3% Mild Concern 41.8% 37.6% - 46.0% 62.9% 57.4% - 68.0% 44.6% 40.9% - 48.4% Serious Concern 6.9% 5.2% - 9.2% 12.3% 9.1% - 16.6% 7.7% 6.0% - 9.7% Do Not Know 5.9% 4.1% - 8.4% 1.9% 1.3% - 2.6% 5.3% 3.7% - 7.6% Observations 784 733 1,517 Workforce Mean Score 0.59 0.54 - 0.65 1.07 0.99 - 1.15 0.66 0.61 - 0.71 No Concern 48.8% 44.5% - 53.2% 20.7% 16.7% - 25.5% 45.0% 41.2% - 48.9% Mild Concern 36.4% 32.3% - 40.6% 49.8% 44.3% - 55.3% 38.2% 34.6% - 41.9% Serious Concern 10.1% 8.0% - 12.7% 27.9% 22.8% - 33.6% 12.5% 10.5% - 14.9% Do Not Know 4.7% 3.2% - 7.0% 1.6% 1.1% - 2.2% 4.3% 2.9% - 6.2% Observations 781 747 1,528 G-128 Table G.44 Page 1 of 3 ------- Table G.44. Gl. Looking ahead to the next several months, please indicate your level of concern about topics covered in this survey. All Utilities Estimates and 95 Percent Confidence Intervals Topics of Concern Response Percentage Reporting by Population Served < 10,000 > 10,000 All Financial Mean Score 0.62 0.56 - 0.68 0.83 0.76 - 0.90 0.65 0.59 - 0.70 No Concern 47.7% 43.3% - 52.1% 31.1% 26.3% - 36.3% 45.5% 41.7% - 49.3% Mild Concern 33.6% 29.7% - 37.7% 50.6% 45.1% - 56.2% 35.8% 32.3% - 39.5% Serious Concern 12.2% 9.6% - 15.3% 14.8% 11.4% - 19.1% 12.5% 10.2% - 15.3% Do Not Know 6.6% 4.6% - 9.3% 3.5% 2.3% - 5.2% 6.2% 4.4% - 8.5% Observations 780 734 1,514 Analytical Support Mean Score 0.28 0.24 - 0.32 0.46 0.40 - 0.52 0.30 0.27 - 0.34 No Concern 68.0% 63.8% - 71.9% 55.2% 49.6% - 60.7% 66.2% 62.6% - 69.7% Mild Concern 23.6% 20.1% - 27.5% 38.9% 33.6% - 44.4% 25.7% 22.6% - 29.1% Serious Concern 1.0% 0.5% - 2.2% 2.7% 1.5% - 4.9% 1.3% 0.7% - 2.2% Do Not Know 7.4% 5.4% - 10.1% 3.2% 2.0% - 4.9% 6.8% 5.0% - 9.2% Observations 770 727 1,497 G-129 Table G.44 Page 2 of 3 ------- Table G.44. Gl. Looking ahead to the next several months, please indicate your level of concern about topics covered in this survey. All Utilities Estimates and 95 Percent Confidence Intervals Topics of Percentage Reporting by Population Served Concern Response < 10,000 > 10,000 All Cybersecurity Mean Score 0.23 0.54 0.27 0.19 - 0.27 0.47 - 0.61 0.24 - 0.31 No Concern 72.6% 50.5% 69.6% 68.7% - 76.3% 44.9% - 56.1% 66.1% - 72.9% Mild Concern 18.5% 41.1% 21.6% 15.5% - 22.0% 35.6% - 46.8% 18.8% - 24.6% Serious 1.3% 5.9% 1.9% Concern 0.8% - 2.2% 3.9% - 8.9% 1.4% - 2.8% Do Not Know 7.5% 2.5% 6.8% 5.4% - 10.3% 1.9% - 3.4% 5.0% - 9.3% Observations 769 726 1,495 G-130 Table G.44 Page 3 of 3 ------- |