https://data.sfgov.org/City-Management-and-Ethics/Vendor-Payments-Purchase-Order-Summary-/p5r5-fd7g (Links to an external site.)
Go to that website and then click on “EXPORT” and then choose “CSV FOR EXCEL”. You will then be given the option to save or open the file. This is a large excel file so please only bid if you think you will be able to open it!
I was able to open and save the data on my laptop. So please try to download it right away and let me know if you are able to access it.
Answer the following questions using the City of San Francisco vendor payments dataset (excel). You will need to use Excel’s Pivot Table and Pie Chart features to complete this assignment.
Please complete the following questions only on the company called “NIBBI BROS ASSOCIATES INC” from the excel sheet: (post all on a word doc)
Question 1: How much money did your assigned company earn from the City of San Francisco each fiscal year from 2013 through 2018? Answer this in writing and also with a bar chart in a word doc. (you can complete it on excel and paste on word doc
Question 2: How many transactions did your assigned company have with the City of San Francisco each fiscal year from 2013 through 2018? Answer this in writing and also with a bar chart on word.
Question 3: How many total vendors did the City of San Francisco make payment of $1 or greater to each year from 2013 through 2018? Answer this in writing and also with a bar chart.
Question 4: What is the total spend by the City of San Francisco from 2013 to 2018? Answer this in writing and also with a bar chart.
Question 5: What is the annual spend per organization group (City of San Francisco) for all vendors and what percent of the total annual spend does each group represent? Use a series of pie charts to answer this question (one pie chart per fiscal year).