Chapter 2, Problem 2.3.3CP

Case Problem 3  Queen City
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

DATA file QueenCity 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.

Managerial Report
Use tabular and graphical methods of descriptive statistics to help the city manager get a better understanding of how the city is spending its funding. Your report should include the following:
3. A table that shows the amount of by fund and the percentage of total expenditures by fund. Combine any fund with less than 1 % into a category named "Other."