Determine the variance and variance percentage for 2016. Enter the total amount for variance and variance percentage in cells D20 and E20.

A C D E F G H 1 2 City of Somerville, MA Budgeted Expenditures (hypothetical) For Year Ended December 31, 2016 2016 Department Code Actual Variance $ Variance % 1 1 1 1 1 1 Budget 66,048 300,000 62334.155 17,698 170,000 12,500,000 75,000,000 15.000.000 10,000,000 430,000 14,000,000 75,000 650.000 3,300,000 193,842 901 1 1 1 1 1 1 3 4 5 Expenditure (Item Class) 6 Advertising 7 Athletics expense 8 Bonds and debt-related expenditures 9 Books 10 Dues and subscriptions 11 Education-related 12 Miscellaneous line item 13 Professional services expense 14 Property, plant and equipment 15 Rental expense 16 Repairs and maintenance expense 17 Supplies expense 18 Technology expense 19 Utilities expense 20 Total expenditures 21 22 Category of Government Spending 23 Education 24 Total 25 Average 26 General Government 27 Total 28 Average 29 Public Works 30 Total 21. As Documentation Dala 2 2 Department ARTS COUNAL AUDITING DEPARTMENT BOARD OF ALDERMEN BOARD OF ASSESSORS BOARD OF HEALTH CTY CLERK OFFICE CLERK OF COMMITTEES COMMUNICATIONS DEPARTMENT CONSTITUENT SERVICES 311 COUNCIL ON AGING CPA COMMITTEE DEPARTMENT OF PUBLIC WORKS DISABILITY AND COMPLIANCE ELECTION COMMISSIONER EXEC - CAPITAL PROJ MGMT EXECOS ENVIRONMENT FIRE DEPT HEADQUARTERS GRANTS MANAGEMENT INSPECTIONAL SERVICES IT DEPARTMENT CITY HALL LAW DEPARTMENT OFFICE OF MAYOR OSPCD ADMINISTRATION PENSION PERSONNEL DEPARTMENT POLICE DEPARTMENT OLDALASING DERARTMENT Category of Government General Government General Government General Government General Government General Government General Government General Government General Government General Government General Government General Government Public Works General Government General Government General Government General Government General Government General Government General Government General Government General Government General Government General Government General Government General Government General Government COROLLOW ant 1 1 1 190,742,852.00 1 1 1 2013 2014 2015 2016 1 1 1 1 1 1 Budgets +