Deliverable Length: 5-6 slides and speaker notes (75 word minimum per slide)OBJECTIVESFor this assignment, you will need to become familiar with specialized business intelligence (BI) software, and then download the software. Complete the following steps to begin:Step 1: Watch an instructional video on the BI software.Step 2: Review various BI Software options, including Tableau and Excel. Search the CTU Library and the Internet to learn about optional software. Step 3: If you choose Tableau, download the Tableau BI software. After you select the link, look for the orange icon in the middle portion of your screen to begin the download or use any BI software to create a graph illustrating comparison between the United States and zip code data.Consider the following scenario, continued from Unit 1 Individual Project:Big D Incorporated needs to prepare an assessment regarding the feasibility of making a recommendation for expansion into another market. As the business analyst, your assignment is to prepare a short presentation for the Board of Directors that apply concepts learned in Unit 1 and concepts from Unit 2 to make the necessary recommendations and justifications for those recommendations. You will need to compare and contrast the varying markets to make the best recommendation possible. Complete the following:Download the reports for the United States from this Web site. The Web site provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S. Census data. This particular file contains 4 reports: General Summary Census Trend 1980 to 2000 Summary Occupation and Employment Summary Income Summary (based on the entire United States) Download the reports for zip code 60614 from this Web site. This particular file contains 4 reports: General Summary Census Trend 1980 to 2000 Summary Occupation and Employment Summary Income Summary based on the U.S. zip code 60614Using all 4 demographic reports (General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary) for the United States and zip code 60614, prepare a 1-page summary slide explaining how your territory differs from the national profile. Feel free to note anything that you found surprising in the data. Use the BI software you choose to depict information from these reports. Prepare a presentation of 4–5 slides of your major findings. You may group a category of data from the Total United States and zip code 60614, and create a graph to show how they differ. The presentation should have at least 2 graphs and a headline that summarizes a key takeaway from the graph. Your presentation should include 5–6 slides in PowerPoint, plus title and reference slides with speaker notes (75-word minimum per slide). For assistance with the usage of Tableau for analysis and reporting, review and use the instructions below. Those should be helpful if you are having problems with the software usage or data. However, you do not need to use Tableau. For BI software usage such as Excel, resort to using the Help functions and other resources on the Internet and in videos to learn how to use Excel to create graphical presentations including table usage.The instructions to create a bar graph in Tableau (optional) or in another BI software are as follows.Open the assignment CTU instructions. Download the BI software. Create your Tableau Public Account. Click the download link for the 60614 file (file will open in Excel). Click the download link for the U.S. file (file will open in Excel). The following are some options: Create separate demographical worksheets (e.g., Educational Attainment or Household Income). Include zip code and U.S. data. See a sample of the file available with column headings and extraneous blanks.Household IncomeChicagoU.S.198019901980 to 199020001990 to 20001980Median Household Income18,43841,2271.23669,3110.68116,902Average household Income24,24567,6071.788114,6150.69520,382Per Capita Income13,56438,5181.8463,7910.6567,321See a sample of the file available with column headings and extraneous blanks.2000 Educational AttainmentU.S.ChicagoCollege: Associates Degree6.3%1.9%College: Bachelor's Degree15.5%44.2%College: Graduate Degree8.9%34.0%College: Some College, no Degree21.1%8.7%School: 9th to 11th grade, no diploma12.1%3.2%School: Grade K-9 6.1%2.0%School: High School Graduate28.6%5.6%Create a file with data organized without extraneous rows and columns but including headings. The idea is to clean up the file before usage. Separating files and worksheets may be the best way to make this happen Note that in the real situation, when using BI software, you will want to ensure that your data are clean and that you have similar data in your files.Save the file(s) on your computer. Open Tableau. Then do a File > Open > Open on your saved file. At the bottom of the screen on the left, click on the little box next to Sheet 1 (looks like a bar graph with a plus in the top left corner). Under “Measures” (on the left), you should see “Chicago” and “U.S.” Click on “U.S.,” and pull it into rows at the top of the screen. Then, click on Chicago and pull it over into rows. Under “Dimensions” on the left, you should see “Household Income.” Click on “Household Income,” and pull it into column. In the second column from the left, you should see “Measures.” In the top right corner, you should see a “show me” box illustrating ways you can view the data based on the values you have chosen. To do side-by-side comparisons, put your cursor over the rightmost picture on the third line with the side-by-side blue and orange bars. Click on it. Your graph should appear on the page. You can play around with how you want to portray your data. To save in Tableau Public, click File > Save to Tableau Public as… > give the file a descriptive name. You will be asked to log into Tableau Public using your e-mail and password. When your graph is saved in public, at the bottom right, there is a download button. Decide how you will save the file. (You can create an image and name the .png file. It will be saved in Tableau Public.) After the file is saved, open the .png file, and edit or copy the graph. Open your PowerPoint file, and then paste (special) it on the slide. You can adjust the size. Repeat the same in Tableau opening of any other prepped and cleaned file.Note: Measure values are your number fields; measure names are the descriptors.For more information on creating PowerPoint Presentations, please visit the Microsoft Office Applications Lab.Additional Resources to UseAmerican Marketing Association. (n.d.). Summary reports. Retrieved from http:/www.marketingpower.com/content753.phpIgines. (2012, December 9). How to make a line graph in Excel (Scientific data) [Video file]. Retrieved from Microsoft. (2018). Create a chart from start to finish. Retrieved from https://support.office.com/en-us/article/Create-a-... ReferencesPak, A. (2013, August 12). Tableau public - Overview and applications [Video file]. Retrieved from Tableau. (2018). Tableau public. Retrieved from http://www.tableausoftware.com/public

Use the document “Cost Benefit Analysis Worksheet” to complete this assignment.While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.You are not required to submit this assignment to LopesWrite.Benchmark Information:This benchmark assignment assesses the following programmatic competencies: Masters in Public Administration1.5: Use technology to manage data and organize information and 2.1: Conduct a cost benefit analysis to determine the best allocation of public resources.ADM-626 Public Budgeting and Financial Management Topic 7 – Cost Benefit Analysis Worksheet Directions: The questions below are the same question from your textbook. Please use this document to record your answers. Once you have answered all questions please upload the document to the LoudCloud dropbox. Module 17: Cost-Benefit Analysis What is cost-benefit analysis? What are the main steps in conducting cost-benefit analysis?A city has learned that by buying larger garbage trucks, it could reduce labor costs for garbage removal. Note: All the dollar amounts below are in this year’s dollars (constant dollars).Cost of the trucks today is $400,000.Annual savings in this year’s constant dollars is $90,000.Trucks will last for 4 years and then will be sold for $100,000.The city can borrow money at a 7% discount rate to purchase the trucks.Inflation (for the next 4 years) is expected to average 3%.Assuming the costs and benefits are incurred at the end of the year, should the city buy the trucks?This assignment extends the garbage truck problem from prompt 2. Two other lenders provide alternative scenarios. Alternate lender 1 suggests that the inflation rate will be 4% and offers an interest rate of 7.5%, while alternate lender 2 suggests that the inflation rate will be 1% and offers an interest rate of 6.5%. For all three sources, the interest rates are guaranteed if the decision is made in the next 90 days. Which of the following decisions should be made and why?The usual lender should be used because she offers a positive NPV.Alternate lender 1 should be used because he offers the highest NPV.The garbage trucks shouldn’t be purchased because there is a possibility of a negative NPV.Alternate lender 2 should be used because most scenarios have a positive NPV and she offers the highest NPV under each scenario.Each solution is as good as any other. Module 18: Life Cycle Costing What is life cycle costing (LCC)? What are the main issues in applying LCC in the government context?The city administration is considering refurbishing the lighting system of its administration building. After an initial investigation, the city procurement office has narrowed down the choices to the following two options:Option 1 is an Ergolight system that costs $500,000 to purchase and install. The energy cost for option 1 is $20,000, and its maintenance cost is $2,000.Option 2 is a conventional system that costs $100,000 to purchase and install. The energy cost for option 2 is $50,000, and its maintenance cost is $10,000. Both systems are expected to last for 20 years. Assume that the discount rate is 4% and all future costs are paid at the end of the year.Which lighting system should the city select based on LCC considerations? Module 19: Capitalization and Depreciation What are the differences in how depreciation is treated by government and by companies in the private sector?A city government purchases a new garbage truck for $120,000 this year. It is estimated that the truck will have a residual value of $20,000 and a useful economic life of 20 years. What would be the depreciation expense each year if the straight-line method were used.Why do organizations, government included, not capitalize all assets that last for more than one budgeting period, despite knowing that doing so would increase the accuracy of the accounting of assets and operations?City Hospital paid $500,000 for a piece of advanced diagnostic equipment. The total transportation and installation cost to make the equipment operational is $50,000. The staff-training cost to operate the new equipment is about $10,000. What should be the value of this capital asset? Module 20: Long-Term Financing Why do public organizations use municipal bonds to finance long-term capital projects?A major urban center is planning to issue a $100 million, 20-year, semiannual-interest-paying municipal bond for the construction of a stadium.The interest rate is 5.875%, based on the economic and financial conditions of the city and city government.The design and issuance costs are estimated to be $10 million and 1%, respectively.What is the total interest paid if the city decides to adopt a level debt service structure?How much will the city still owe on this bond at the end of each year? This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. This benchmark assignment assesses the following programmatic competencies: 1.5: Use technology to manage data and organize information and 2.1: Conduct a cost benefit analysis to determine the best allocation of public resources.