I need someone who can complete the decision assessment sheet based on the case study attached

I need someone who can complete the decision assessment sheet based on the case study attached
DECISION ASSESSMENT FOR BROWN COUNTY The Issue/Problem In one sentence pinpoint the issue requiring a descriptive analysis and a decision. Measurement of the Problem In one or two sentences write an operational definition of the problem that is being analyzed. Quantitative Approach Used In one or two sentences explain the quantitative approach used and justify its selection based on the level of measurement. Analysis of the Data Describe the trends in the operating ratios by month for 2019 and 2020. Compare those trends to the benchmark offered by AWWA. Decision Outcomes and Inquiry of Staff Draw conclusions on what the data in Section IV are showing you. Based on your conclusions, what are some decisions you might consider as the county manager? For example, do the considerations of the Director of Public Works have validity? Based on the analysis, what additional questions would you pose to the Director of Public Works?
I need someone who can complete the decision assessment sheet based on the case study attached
DESCRIBING WATER UTILITY PERFORMANCE: THE CASE OF BROWN COUNTY BACKGROUND You are a newly appointed county manager of Brown County, which is large suburban jurisdiction covering 1500 square miles. Reviewing the county budget by department you notice that infrastructure costs for water utilities comprises a large percentage of the public works department’s annual budget. The Division of Public Works is the largest department in Brown County and the water utilities department in the Division of Public Works serves approximately 41,952 water customers.  The utilities department currently operates 482 miles of water main with six water pump stations.  The department also oversees 12 water storage facilities with a combined capacity of 67 million gallons. You decide to embark on a performance measurement exercise of water utilities to help public works set a course to monitor operating efficiency and to justify potential capital expenses. PERFORMANCE MEASUREMENT: WHAT ARE WE MEASURING? As a first step toward performance assessment, you decide to examine the operating ratio of the water utility. This measure represents the total costs for operation and maintenance of the water distribution system as provided by the accounting division of Public Works divided by the total revenues generated from water purchased by the public from the county utility department. Therefore, costs are expressed as a percent of total revenue. Hence an operating ratio of .20, or 20% (move the decimal two places to the right) indicates that operating and maintenance costs comprise 20% of operating revenue. A higher operating cost percentage indicates that operating expenses are increasing relative to revenue. Conversely, if the operating ratio is decreasing, expenses are decreasing, or revenue is increasing, or some combination of both. WHAT IS “GOOD” PERFORMANCE? To establish if a performance measure is “good” it needs to be compared to a standard or best practice results established by an independent professional association within specific industries. In the case of water utilities, the American Water Works Association (AWWA) establishes bench marking guidelines. AWWA, using data gathered from suburban counties throughout the U.S. similar to Brown County, established the top quartile for operating ratio at 45%. According the AWWA, this benchmark indicates financial efficiency of water operations.  ASSESS HOW THE WATER UTILITY IS DOING The performance target goal for Brown County is .45 or 45%. Review the descriptive analysis of the operating ratios for FY 2019 and FY 2020. Describe the trends and assess the utility’s performance. DECISIONS CONSIDERATIONS The director of public works, who was recently appointed by you, completed a field visit to pump stations and conducted a random water main inspection in different parts of the county. Based on her field visit she is advocating hiring a consultant to conduct an inventory of water main capacity and a replacement cost study. The public works director also pointed out that the utilities department, in an effort to avoid installing and reading meters, has charged a flat rate for water (all customers pay the same amount each month regardless of quantity of service used).
I need someone who can complete the decision assessment sheet based on the case study attached
DECISION ASSESSMENT FOR BROWN COUNTY The Issue The main issue facing brown county is how water for the public is utilized in the area to fit the needs of the individuals at an annual utility ration. More focus is based on infrastructure costs for water utilities comprises a large percentage of the public works department’s annual budget. Measurement of the problem An operational ratio reflects the average cost of water delivery system service and repair. A higher proportion of fixed costs suggests a rise in operating expenditures compared to sales. The top operating quartile of Brown County is 45%. The AWWA notes that this benchmark shows that water operations are financially efficient. The director of public works also suggested that the utility department paid a fixed rate for water in an attempt to prevent construction and calculations. Quantitative Approach Used This case study discusses the potential of water savings at property, household and urban levels. The average drinking water consumption in urban households of industrialized countries could be reduced by approximately one third. By using a secondary water quality, the drinking water demand could even be reducing by 50%. This is achieved through statistical analysis of data obtained from households. Analysis of the data Tables 1 and 2 show the trends for the operating ratios by month for 2019 and 2020, respectively. Table 1 […discuss what see by month…do the operating costs comprised less 45% of revenues for all of the months, some of months? What do the data data suggest about improvement or decline in efficiency between certain months in 2019? What happens as you enter the fall and into the winter of 2019?]. Table 2 reveals that in 2020 […what happens to the operating costs as compared to 2019? Do they exceed the AWWA threshold? Do they fall below? What happens between January and April? What happens between May and September and between October and December]. Decision Outcomes and Inquiry of Staff As a newly director of public works, I can undertake a field visit to pump stations in numerous areas of the county and performed a random water main inspection. On my field visit I could suggest that a contractor be employed, to perform a water inventory and to carry out a cost substitute report. The Director of Public Works also found out that the utility department paid a flat rate for water in order to prevent installation and reading meters (all customers pay the same amount each month regardless of quantity of service used). This can all be achieved by used of automatic meters to read the data required equally.