1. Tables and/or graphical displays that show the amount of expenditures by category and percentage of total expenditures by category.

2. A table that shows the amount of expenditures by department and the percentage of total expenditures by department. Combine any department with less than 1% into a category named €œOther.€

3. A table that shows the amount of expenditures by fund and the percentage of total expenditures by fund. Combine any fund with less than 1% into a category named €œOther.€

Cincinnati, Ohio, also known as the Queen City, has a population of approximately 298,000 and is the third largest city in the state of Ohio. The Cincinnati metropolitan area has a population of about 2.2 million. The city is governed by a mayor and a nine-member city council. The city manager, who is responsible for the day-to-day operation of the city, reports to the mayor and city council. The city manager recently created the Office of Performance and Data Analytics with the goal of improving the efficiency of city operations. One of the first tasks of this new office is to review the previous year€™s expenditures. The file QueenCity contains data on the previous year€™s expenditures, including the following:

Department The number of the department incurring the expenditure

Department Description The name of the department incurring the description

Category The category of the expenditure

Fund The fund to which the expenditure was charged

Expenditure The dollar amount of the expense

Table 2.21 shows the first four entries of the 5427 expenditures for the year. The city manager would like to use this data to better understand how the city€™s budget is being spent.

Transcribed Image Text:

Department Department Description Expenditure $ 7,085.21 Category Department of Human Resources | Fringe Benefits Fringe Benefits Department of Human Resources Fringe Benefits Contractual Services Fund 050 - GENERAL FUND 050 - GENERAL FUND 050 - GENERAL FUND 050 - GENERAL FUND 121 Department of Human Resources 121 $102,678.64 $ 79,112.85 $ 3,572.50 121 Department of Human Resources 121