Homework Help is Here – Start Your Trial Now!
Business
Accounting
Review the data for the city of Rome and discuss what the year 2015 is showing.

Review the data for the city of Rome and discuss what the year 2015 is showing.

Essentials of Business Analytics (MindTap Course List)
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter5: Probability: An Introduction To Modeling Uncertainty
Section: Chapter Questions
Problem 8P: As was discussed in the Analytics in Action from Chapter 2, the U.S. Census Bureau is a leading...
See similar textbooks
icon
Related questions
Question
Required information [The following information applies to the questions displayed below.] In any data analytics exercise, it is important to understand the underlying data as an aid in interpreting the results of any analysis undertaken. In this comprehensive problem that covers multiple chapters of the textbook, five cities in the state of New York are the basis for the analysis. The five cities are: . City of Elmira City of Poughkeepsie . City of Rome . City of Saratoga Springs City of Watertown These five cities were selected because they are all in one state, thus governed by the same state reporting and audit requirements. The fact that the cities are governed by one set of reporting requirements means that the data reported follows the same chart of accounts and rules for what should be reported in each account. As you will see, state i requirements may not always follow GAAP requirements or the recommendations of the text. Cities selected are fairly comparable in population size, but they are geographically dispersed within the state, which has an impact on their economy. A data set including information for the five cities has been provided. The data set includes: . Five years of data from 2014-2018 Modified accrual information for the General Fund, Capital Projects Funds, and Debt Service Funds Budget information for the General Fund Click here to download the data set Click here for a brief tutorial on Pivot Tables in Excel. Click here for a brief tutorial on Pivot Table Filters and Charts in Excel. Show Transcribed Text Click here to download the data set. Click here for a brief tutorial on Pivot Tables in Excel. Click here for a brief tutorial on Pivot Table Filters and Charts in Excel. Substantial detail is provided for some types of data. Although the assignments do not require the use of all data detail, your professor may ask for additional support for analysis that could include you preparing additional reports and analysis relating to the detail provided. Depending on your professor's preference, the assignments will require that you prepare visualizations of the data using either Excel charts/graphs or Tableau. Using Excel to create graphs/charts can be accomplished by using pivot tables (click on insert). Once in your pivot table, filter the data to include only those items you would like charted (click on insert and then recommended charts or create your own chart). Some calculations may require you to create a new column and/or row and/or table that includes the calculations you will graph. Although the cities involved in these exercises are quite small, all but one of them had debt required to be serviced all five years. The City of Rome shows debt activity for only one year. The activity in the funds provides good indicators of how debt is handled by cities. The purpose of this assignment is to provide you with greater familiarity of the sources and uses of funds for debt. Review the data for the city of Rome and discuss what the year 2015 is showing.
Transcribed Image Text:Required information [The following information applies to the questions displayed below.] In any data analytics exercise, it is important to understand the underlying data as an aid in interpreting the results of any analysis undertaken. In this comprehensive problem that covers multiple chapters of the textbook, five cities in the state of New York are the basis for the analysis. The five cities are: . City of Elmira City of Poughkeepsie . City of Rome . City of Saratoga Springs City of Watertown These five cities were selected because they are all in one state, thus governed by the same state reporting and audit requirements. The fact that the cities are governed by one set of reporting requirements means that the data reported follows the same chart of accounts and rules for what should be reported in each account. As you will see, state i requirements may not always follow GAAP requirements or the recommendations of the text. Cities selected are fairly comparable in population size, but they are geographically dispersed within the state, which has an impact on their economy. A data set including information for the five cities has been provided. The data set includes: . Five years of data from 2014-2018 Modified accrual information for the General Fund, Capital Projects Funds, and Debt Service Funds Budget information for the General Fund Click here to download the data set Click here for a brief tutorial on Pivot Tables in Excel. Click here for a brief tutorial on Pivot Table Filters and Charts in Excel. Show Transcribed Text Click here to download the data set. Click here for a brief tutorial on Pivot Tables in Excel. Click here for a brief tutorial on Pivot Table Filters and Charts in Excel. Substantial detail is provided for some types of data. Although the assignments do not require the use of all data detail, your professor may ask for additional support for analysis that could include you preparing additional reports and analysis relating to the detail provided. Depending on your professor's preference, the assignments will require that you prepare visualizations of the data using either Excel charts/graphs or Tableau. Using Excel to create graphs/charts can be accomplished by using pivot tables (click on insert). Once in your pivot table, filter the data to include only those items you would like charted (click on insert and then recommended charts or create your own chart). Some calculations may require you to create a new column and/or row and/or table that includes the calculations you will graph. Although the cities involved in these exercises are quite small, all but one of them had debt required to be serviced all five years. The City of Rome shows debt activity for only one year. The activity in the funds provides good indicators of how debt is handled by cities. The purpose of this assignment is to provide you with greater familiarity of the sources and uses of funds for debt. Review the data for the city of Rome and discuss what the year 2015 is showing.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS