4. On the Budgets worksheet, determine the actual amount spent on each expenditure for 2016. Enter the total amount spent in 2016 in cell C20. (what formula to input for C20)

A D F G H L L M M N Cty of Somerville, MA Budgeted Expenditures hypothetical) For Year Ended December 31, 2016 2016 Actual Varice $ Variance Budget 66,048 300,000 62,334,159 17,598 170,000 12,500,000 75,000,000 15,000,000 10,000,000 430,000 14,000,000 75,000 550,000 3,300,000 193,B12,901 1 2 3 4 5 Expenditure (item Clas! E Advertising 7 Athletics expense A Bonds and debatedeperditures 9 Boaks 10 Dues and subscriptions 11 Education related 12 Miscellaneouslina ito 13 Professional services expense 14 Property plantedequipment 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 Covernment 27 Total 28 Average 29 Public Works 30 Total 31 Average 32 33 Breakdown of Education Expenses 34 Athletics expense 35 Education-related 36 Miscellaneous line item 37 Professional services expense 38 Property, plant and equipmen 39 Rental expense Documentation Department ARTS COUNCIL AUDITING DEPARTMENT BOARD OF ALDERMEN BOARD OF ASSESSORS BOARD OF HEALTH CITY 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 EXEC OS ENVIRONMENT FIRE DEPTHEADQUARTERS GRANTS MANAGEMENT INSPECTIONAL SERVICES IT DEPARTMENT CITY HALL LAW DEPARTMENT OFFICE OF MAYOR OSPCD ADMINISTRATION PENSION PERSONNEL DEPARTMENT POLICE DEPARTMENT PURCHASING DEPARTMENT RECREATION AND YOUTH SCHOOL ADMINISTRATION SOMERPROMISE ALLIANCE SOMERSTAT DEPARTMENT SOMERVILLE PUBLIC LIBRARY THAFFIC AND PARKING TREASURY DEPARTIVENT IVETERANS SERVICES Category of Government Department Code 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 General Government General Government Education General Government General Government General Government General Government General Government General Government 2013 2014 2015 2016 1 1 1 2013 2014 2015 2016 3 1 Data Budgets G H I Department Code 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 Department ARTS COUNCIL AUDITING DEPARTMENT BOARD OF ALDERMEN BOARD OF ASSESSORS BOARD OF HEALTH CITY 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 EXEC OS ENVIRONMENT FIRE DEPT HEADQUARTERS GRANTS MANAGEMENT INSPECTIONAL SERVICES IT DEPARTMENT CITY HALL LAW DEPARTMENT OFFICE OF MAYOR OSPCD ADMINISTRATION PENSION PERSONNEL DEPARTMENT POLICE DEPARTMENT PURCHASING DEPARTMENT RECREATION AND YOUTH SCHOOL ADMINISTRATION SOMERPROMISE ALLIANCE SOMERSTAT DEPARTMENT SOMERVILLE PUBLIC LIBRARY TRAFFIC AND PARKING TREASURY DEPARTMENT VETERANS SERVICES WORKER COMPENSATION 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 General Government General Government Education General Government General Government General Government General Government General Government General Government General Government 1 1 1 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 1 1 H2 C H j Department Code 1 Vendor Name 2 GLOBA. PETROLEUM CORP. 3 MAY INSTITUTE INC 4 QUO A CONSTRUCTIONING S EENTERS FOR MEDICARE X MEDICAID SERVICES 6 MANAGED HEALTH RESOURCES INC 7 MARKINSS INC 8 BOSTON HIGASHI SCHOOL INC 9 LAST COAST PETROLEUM STATE 10 MASS. ASSOC.FOR THE BLIND 11 ELIZABETH A FLEMING A 12 JAL.LY CULLAVORATIVL 13 MCLFAN HOSPITAL INC 14 BAY COVE HUMAN SERVICES 15 USTICE RESOURCE INSTITUTE INC 16 FUTURES CLINIC INC 17 CANDELE CONSTRUCTION COMPANY INC. . 18 FRANCISCAN CHILDREN'S HOSPITAL 19 IGHTHOUSE SCHOOL INC 20 POTTING SCHOOL INC 21 TOME FOR LITTLE WANDERERS 22 TRIUMPH CENTER 23 WALKER INC 24 COMMUNICATIVE HEALTH CARE ASSOCIATES, INC. 25 ANDMARK SCHOOL 26 DAVID MACEACHERN 27 ALL AMERICAN SPORTS CORP 28 GOLDEN RIDERS INC 29 CAMBRIDGE PUBLIC HEALTH COMMISSON 30 CITY OF HAVERHILL 31 CHAMPIONS CHOICHING 32 SOMERVILLE HAITIAN COALITION, INC 33 WORK OPPORTUNITIES 34 IONFLS. LYON 35 ADAMSON INDUSTRIES CORP 36 MGRAM INDUSTRIES INC 37 SPIRING ARTIST 32 ATLANTIC BROOM SERVICE INC 39 CHAMPIONS CHOICE INC Documentation Data D Amount 75.648.03 S $ 32.701.33 $ 25,525.00 $ 20.263.00 S 19,547.00 $ 17,723.03 $ 16.716.30 $ 14,245.63 $ 17,457.76 $ 11.809.51 $ 9,886.72 $ 8,100.83 S 8.090.01 S 7,504.80 $ 7,348.35 S 7.251.50 $ 6,894.53 $ 6,380.58 S 5.890.20 S 5,832.00 $ 4,970.00 S 4.762.08 $ 4,537.50 $ 4,505.76 S 3.489.50 S 3,176.50 $ 3,150.00 S $ 2.700.00 $ 2.665.00 $ 2,540.00 S 2.500.00 S 2,362.50 $ 2,255.00 S 2.131.35 S 2,046.85 $ 2,000.00 $ 1.700.00 5 1,700.00 E F Check Date Year Department 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 OSPCA ADMINISTRATION 1/2/13 2013 PERSONNEL DEPARTMENT 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 TRAFFIC AND PARKING 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 WORKER COMPENSATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 OSPCD ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/7/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/19 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/7/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/18 2013 COUNCIL ON MINI 1/2/19 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/19 2013 OSPCD ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SOMERVILLE PUBLIC LIBRARY 1/2/13 2013 RECREATION AND YOUTH 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION Item Number 18720 2013 15337-2013 22980-2013 4179 2013 14096-2013 14862-2013 2972 2013 7206-2013 15117-2013 7704 2013 25422-2013 1539R-2013 2631 2013 12556-2013 R301-2013 3806 2013 8240-2013 14331-2013 5993 2013 11242-2013 25095-2013 25837 2013 5630-2013 13162-2013 5267 2013 1526-2013 R801-2013 3GOS 2013 4800-2013 4588-2013 2326G 2013 26207-2013 14500-2013 1180 2013 11486-2013 2163-2013 2292 2013 4587-2013 Org Description DPW BLGOX GRNDS ORDINARY MAINT SPLO-TUITNPSCH DW-SPLD QUINCY STREET EXPENSE HEALTH CLAIMS TRUST SPLO-MEDICAL-DW-SPED TRAFFIC & PARKING ORD MAINT SPEDTUITNPSCH DW SPED DPW-BLGU&GRNUS ORDINARY MINT SPED-TUITNPSCH-DW-SPED WORKERS COMP ORDINARY MAINT SPLO-TUIINCULAW-OW-SPED SPED-TLITNPSCH-DW-SPED SPEO TUITNPSCH DW SPED SPLO-TUITNPSCH-DW- SPLD SPED-TUITNPSCH.DW-SPED LOWER MYSTIC RR IMPRMET SPLO-TUITNPSCH-DW-SPED SPED-TLIITNPSCH-DW-SPED SPED-TUITNPSCH DW SPED SPLO-TUITNPSCHOW-SPED SPED-PSYCH-OW-SPED SPED TUITNPSCH DW SPED SPLO-MEDICAL-DW-SPED SPED-TLIITNPSCH-DW-SPED DPW BLGO&GRNDS ORDINARY MAINT ATHLETICS-DW-UND COUNCIL ON AGING SHS PSYCH SHS REG SPED-TUITION-DW-SPED ATHLETICS-W-UND 2011 LEAD HAZARD REDUCTION SPLO-OS-OW-SPED SPED-PSYCH-OW-SPED DPW SNOW REMVL ORDINARY MAINT LIBRARIES ORDINARY MAINTENANCE PARKS AND RECREATION DPW-SNOW REMVL ORDINARY MAINT ATHLETICS-DW-UND Account Desc CIL SPED-TUITNPSCH-DW-SPLD-P&T SITE IMP-PARK RECONSTRUCTION MEDICARE PENALLTIES SPLD-MLDICAL-OW-SPLD-PROFIECH REPAIRS-HISHWAYS SPED TUITNPSCH DW SPED PUT CAL SPED-TUITNPSCH-OW-SPED-P&T LEGAL SERVICES SPED-TVITNCOLAL-OW-SPED-P&T SPED-TUITNPSCH-OW-SPED-P&T SPED TUITNPSCH DW SPED PUT SPLD-TUITNPSCH-OW-SPED-P&T SPED-TUITNPSCH.DW-SPED-PAT SITEIMP PARK RECONSTRUCTION SPLD-TUITNPSCH-OW-SPED-P&T SPED-TUITNPSCHOW-SPED-P&T SPED TUITNPSCH DW SPED PUT SPED-TUITNPSCH-OW-SPED-P& SPED-PSYCH-OW-SPED-PROF TECH SPED TUITNPSCH DW SPED P&T SPED-MEDICAL-OW-SPED-PROF&TECH SPED-TUITNPSCH-OW-SPED-P&T INTERIOR BLOG MAINT ATHLETICS-DWUND SUPPLIES RECREATION-TRANSPORTATN. SHS PSYCH SHS REG PROF&TECH SPED-TUITION-OW-SPED-PROF&TECH ATHLETICS DWUND SUPPLIES PROFESSIONAL & TECHNCAL SVC SPED-OIS-OW-SPED PROF & TECH SPED-PSYCH-OW-SPED-PROF&TECH SNOW REMONAL TEXTBOOKS PROFESSIONL & TECH INCL SMC SNOW REMOVAL ATHLETICS-DW-UND-SUPPLIES Budgets + JA . M Department Code D 1 Amount 2 5 75,548 03 3 $ 32,704.33 $ 25,525.00 5 S 20,263.00 6 $ 19,547.00 S 17,223.93 8 5 16,716.30 $ 14.245.53 10 S 12,457.76 11 5 11,BOS 61 12 $ 9,886.77 13 $ 8.180.33 14 5 8,090.01 15 $ 7,504.00 16 $ $ 7,342.35 17 5 7,251.50 18 $ 6,894.53 19 S S 6.380.59 20 S 5,890.20 21 $ 5,832.00 22 S $ 4,970.00 23 $ 1,762.08 24 $ 4,537.50 25 S S 4,503.70 26 S 3,489 50 27 $ 3,176.50 28 $ 3,150.00 29 5 2.700.00 30 $ 2,565.00 31 $ S 2.640.00 32 $ 2.500.00 33 S 2,362.50 34 $ 2.255.00 35 $ 2,131.35 36 $ 2.046.35 37 S 2,000.00 38 $ 1,700.00 39 S 1,700.00 E F Check Date Year Department 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 OSPCD ADMINISTRATION 1/2/13 2013 PERSONNEL DEPARTMENT 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 TRAFFIC AND PARKING 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 WORKER COMPENSATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 OSPCD ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 COUNCIL ON AGING 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 OSPCD ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 DEPARTMENT OF PURLIC WORKS 1/2/13 2013 SOMERVILLE PUBLIC LIBRARY 1/2/13 2013 RECREATION AND YOUTH 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION Item Number 2 8730-2013 3 15337-2013 1 22980-2013 1 $179-2013 314695-2013 1 14262-2013 3 2972-2013 2 7266-2013 3 15117-2013 1 7704-2013 3 25422-2013 3 15999-2013 3 2631-2013 3 12555-2013 3 9301-2013 1 3806-2013 3 8240-2013 3 14331-2013 3 5993-2013 3 11142-2013 3 25096-2013 3 25887-2013 3 5630-2013 3 13162-2013 2 5267-2013 3 1516-2013 1 8801.2013 33605-2013 3 4800 2013 3 4528-2013 1 23265-2013 3 26207-2013 3 14500-2013 3 2 1180-2013 1 11485 2013 1 2168-2013 2 2232-2013 3 4587-2013 Org Description DPV-BLGD&GRNDS ORDINARY MAINT SPED-TUITNPSCH-DW-SPED QUINCY STREET EXPENSE-HEALTH CLAIMS TRUST SPED MEDICAL DW.SPED TRAFFIC & PARKING ORD MAINT SPEO-TUITNPSCH-DW-SPED DPW-BLGD&GRNDS ORDINARY MAINT SPED-TUITNPSCH DW SPED WORKERS COMP ORDINARY MANT SPED-TUITNCOLAR-DW-SPED SPED-TUITNPSCH-DW-SPED SPED-TUITNPSCH-DW-SPED SPEO TUITNPSCH-DW-SPED SPED-TUITNPSCH-DW-SPED LOWER WYSTIC RR INPRMET SPED-TUITNPSCH-DW-SPED SPED-TUITNPSCH DW SPED SPED-TUITNPSCH-DW-SPED SPED-TUITNPSCH-DW-SPED SPED-PSYCH-OW-SPED SPEO-TUITNPSCH-DW-SPED SPED MEDICAL-DW-SPED SPED-TUITNPSCH DW-SPLO DPW-BLGO&GANDS ORDINARY MAINT ATHLETICS OW-UND COUNCIL ON AGING SHS PSYCH-SHS-REO - SPED-TUITION DW SPED ATHLETICS-OW-UND 2011 LEAD HAZARD REDUCTION SPED OS DW SPED SPED-PSYCH-OW-SPED DPW-SNOW REMVL ORDINARY WANT LIBRARIES ORDINARY MAINTENANCE PARKS AND RECREATION DPW-SNOW REMVL ORDINARY WANT ATHLETICS DWUND Account Desc CIL SPED-TUITNPSCH-DW-SPED-P&T SITE IMP-PARK RECONSTRUCTION MEDICARE PENALLTIES SPED-MEDICAL-DW-SPED PROFATECH REPA RS-HIGHWAYS SPED-TUITNPSCH-DW-SPED-P&T CIL SPED-TUITNPSCH-DW-SPED-P&T LEGAL SERVICES SPED-TUITNCOLAB-OW-SPED-P&T SPED-TUITNPSCH DW SPED-P&T SPED-TUITNPSCH-DW-SPED-P&T SPED-TUITNPSCH DW-SPED-P&T SPED-TUITNPSCH DW-SPED-P&T SITEIMP-PARK RECONSTRUCTION SPED-TUITNPSCH DW SPED-PAT SPEO-TUITNPSCH DW-SPED-P&T SPED-TUITNPSCH-DW-SPED-PAT SPED-TUITNPSCH DW SPED PAT SPED-PSYCH-OW-SPED PROF&TECH SPED-TUITNPSCH-DW-SPED-P&T SPED MEDICAL DW-SPED PROFETECH SPED-TUITNPSCH-DW-SPED-P&T INTERIOR BLOG MANT ATHLETICS DWUND SUPPLIES RECREATION TRANSPORTATN. SHSDSYCHSS-REG-PROERTECH SPED-TUITION-DW-SPED PROFX TECH ATHLETICS-DW-UND-SUPPLIES PROFESSIONAL & TECHNCAL SVO SPED OS-OW-SPED PROFZ.TECH SPED-PSYCH-OW-SPED PROF& TECH SNOW REMOVAL TEXTBOOKS PROFESSIONL & TECHNCL SVC SNOW REMOVAL ATHLETICS DWUND SUPPLIES Item Class Miscellaneous line item Education-related Repairs and maintenance expense Miscelaneousline item Education related Repairs and maintenance expense Education-related Miscellaneaus line item Education-related Midlaneousline item Education related Ecuation-related Education-related Education-related Education-related Reas and inaintenance expense Education related Education related Education-related Education related Ecuation-related Education related Education-related Ecuration related Miscellaneous line item Athletics expense Miscellaneous line item Education-elated Education-related Athletics expense Profesional services expense Education related Education-related Miscellaneous line item Education related Professional services expense Miscellaneous line item Athletics expense Documentation Data Budgets + A D F G H L L M M N Cty of Somerville, MA Budgeted Expenditures hypothetical) For Year Ended December 31, 2016 2016 Actual Varice $ Variance Budget 66,048 300,000 62,334,159 17,598 170,000 12,500,000 75,000,000 15,000,000 10,000,000 430,000 14,000,000 75,000 550,000 3,300,000 193,B12,901 1 2 3 4 5 Expenditure (item Clas! E Advertising 7 Athletics expense A Bonds and debatedeperditures 9 Boaks 10 Dues and subscriptions 11 Education related 12 Miscellaneouslina ito 13 Professional services expense 14 Property plantedequipment 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 Covernment 27 Total 28 Average 29 Public Works 30 Total 31 Average 32 33 Breakdown of Education Expenses 34 Athletics expense 35 Education-related 36 Miscellaneous line item 37 Professional services expense 38 Property, plant and equipmen 39 Rental expense Documentation Department ARTS COUNCIL AUDITING DEPARTMENT BOARD OF ALDERMEN BOARD OF ASSESSORS BOARD OF HEALTH CITY 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 EXEC OS ENVIRONMENT FIRE DEPTHEADQUARTERS GRANTS MANAGEMENT INSPECTIONAL SERVICES IT DEPARTMENT CITY HALL LAW DEPARTMENT OFFICE OF MAYOR OSPCD ADMINISTRATION PENSION PERSONNEL DEPARTMENT POLICE DEPARTMENT PURCHASING DEPARTMENT RECREATION AND YOUTH SCHOOL ADMINISTRATION SOMERPROMISE ALLIANCE SOMERSTAT DEPARTMENT SOMERVILLE PUBLIC LIBRARY THAFFIC AND PARKING TREASURY DEPARTIVENT IVETERANS SERVICES Category of Government Department Code 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 General Government General Government Education General Government General Government General Government General Government General Government General Government 2013 2014 2015 2016 1 1 1 2013 2014 2015 2016 3 1 Data Budgets G H I Department Code 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 Department ARTS COUNCIL AUDITING DEPARTMENT BOARD OF ALDERMEN BOARD OF ASSESSORS BOARD OF HEALTH CITY 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 EXEC OS ENVIRONMENT FIRE DEPT HEADQUARTERS GRANTS MANAGEMENT INSPECTIONAL SERVICES IT DEPARTMENT CITY HALL LAW DEPARTMENT OFFICE OF MAYOR OSPCD ADMINISTRATION PENSION PERSONNEL DEPARTMENT POLICE DEPARTMENT PURCHASING DEPARTMENT RECREATION AND YOUTH SCHOOL ADMINISTRATION SOMERPROMISE ALLIANCE SOMERSTAT DEPARTMENT SOMERVILLE PUBLIC LIBRARY TRAFFIC AND PARKING TREASURY DEPARTMENT VETERANS SERVICES WORKER COMPENSATION 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 General Government General Government Education General Government General Government General Government General Government General Government General Government General Government 1 1 1 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 1 1 H2 C H j Department Code 1 Vendor Name 2 GLOBA. PETROLEUM CORP. 3 MAY INSTITUTE INC 4 QUO A CONSTRUCTIONING S EENTERS FOR MEDICARE X MEDICAID SERVICES 6 MANAGED HEALTH RESOURCES INC 7 MARKINSS INC 8 BOSTON HIGASHI SCHOOL INC 9 LAST COAST PETROLEUM STATE 10 MASS. ASSOC.FOR THE BLIND 11 ELIZABETH A FLEMING A 12 JAL.LY CULLAVORATIVL 13 MCLFAN HOSPITAL INC 14 BAY COVE HUMAN SERVICES 15 USTICE RESOURCE INSTITUTE INC 16 FUTURES CLINIC INC 17 CANDELE CONSTRUCTION COMPANY INC. . 18 FRANCISCAN CHILDREN'S HOSPITAL 19 IGHTHOUSE SCHOOL INC 20 POTTING SCHOOL INC 21 TOME FOR LITTLE WANDERERS 22 TRIUMPH CENTER 23 WALKER INC 24 COMMUNICATIVE HEALTH CARE ASSOCIATES, INC. 25 ANDMARK SCHOOL 26 DAVID MACEACHERN 27 ALL AMERICAN SPORTS CORP 28 GOLDEN RIDERS INC 29 CAMBRIDGE PUBLIC HEALTH COMMISSON 30 CITY OF HAVERHILL 31 CHAMPIONS CHOICHING 32 SOMERVILLE HAITIAN COALITION, INC 33 WORK OPPORTUNITIES 34 IONFLS. LYON 35 ADAMSON INDUSTRIES CORP 36 MGRAM INDUSTRIES INC 37 SPIRING ARTIST 32 ATLANTIC BROOM SERVICE INC 39 CHAMPIONS CHOICE INC Documentation Data D Amount 75.648.03 S $ 32.701.33 $ 25,525.00 $ 20.263.00 S 19,547.00 $ 17,723.03 $ 16.716.30 $ 14,245.63 $ 17,457.76 $ 11.809.51 $ 9,886.72 $ 8,100.83 S 8.090.01 S 7,504.80 $ 7,348.35 S 7.251.50 $ 6,894.53 $ 6,380.58 S 5.890.20 S 5,832.00 $ 4,970.00 S 4.762.08 $ 4,537.50 $ 4,505.76 S 3.489.50 S 3,176.50 $ 3,150.00 S $ 2.700.00 $ 2.665.00 $ 2,540.00 S 2.500.00 S 2,362.50 $ 2,255.00 S 2.131.35 S 2,046.85 $ 2,000.00 $ 1.700.00 5 1,700.00 E F Check Date Year Department 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 OSPCA ADMINISTRATION 1/2/13 2013 PERSONNEL DEPARTMENT 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 TRAFFIC AND PARKING 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 WORKER COMPENSATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 OSPCD ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/7/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/19 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/7/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/18 2013 COUNCIL ON MINI 1/2/19 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/19 2013 OSPCD ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SOMERVILLE PUBLIC LIBRARY 1/2/13 2013 RECREATION AND YOUTH 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION Item Number 18720 2013 15337-2013 22980-2013 4179 2013 14096-2013 14862-2013 2972 2013 7206-2013 15117-2013 7704 2013 25422-2013 1539R-2013 2631 2013 12556-2013 R301-2013 3806 2013 8240-2013 14331-2013 5993 2013 11242-2013 25095-2013 25837 2013 5630-2013 13162-2013 5267 2013 1526-2013 R801-2013 3GOS 2013 4800-2013 4588-2013 2326G 2013 26207-2013 14500-2013 1180 2013 11486-2013 2163-2013 2292 2013 4587-2013 Org Description DPW BLGOX GRNDS ORDINARY MAINT SPLO-TUITNPSCH DW-SPLD QUINCY STREET EXPENSE HEALTH CLAIMS TRUST SPLO-MEDICAL-DW-SPED TRAFFIC & PARKING ORD MAINT SPEDTUITNPSCH DW SPED DPW-BLGU&GRNUS ORDINARY MINT SPED-TUITNPSCH-DW-SPED WORKERS COMP ORDINARY MAINT SPLO-TUIINCULAW-OW-SPED SPED-TLITNPSCH-DW-SPED SPEO TUITNPSCH DW SPED SPLO-TUITNPSCH-DW- SPLD SPED-TUITNPSCH.DW-SPED LOWER MYSTIC RR IMPRMET SPLO-TUITNPSCH-DW-SPED SPED-TLIITNPSCH-DW-SPED SPED-TUITNPSCH DW SPED SPLO-TUITNPSCHOW-SPED SPED-PSYCH-OW-SPED SPED TUITNPSCH DW SPED SPLO-MEDICAL-DW-SPED SPED-TLIITNPSCH-DW-SPED DPW BLGO&GRNDS ORDINARY MAINT ATHLETICS-DW-UND COUNCIL ON AGING SHS PSYCH SHS REG SPED-TUITION-DW-SPED ATHLETICS-W-UND 2011 LEAD HAZARD REDUCTION SPLO-OS-OW-SPED SPED-PSYCH-OW-SPED DPW SNOW REMVL ORDINARY MAINT LIBRARIES ORDINARY MAINTENANCE PARKS AND RECREATION DPW-SNOW REMVL ORDINARY MAINT ATHLETICS-DW-UND Account Desc CIL SPED-TUITNPSCH-DW-SPLD-P&T SITE IMP-PARK RECONSTRUCTION MEDICARE PENALLTIES SPLD-MLDICAL-OW-SPLD-PROFIECH REPAIRS-HISHWAYS SPED TUITNPSCH DW SPED PUT CAL SPED-TUITNPSCH-OW-SPED-P&T LEGAL SERVICES SPED-TVITNCOLAL-OW-SPED-P&T SPED-TUITNPSCH-OW-SPED-P&T SPED TUITNPSCH DW SPED PUT SPLD-TUITNPSCH-OW-SPED-P&T SPED-TUITNPSCH.DW-SPED-PAT SITEIMP PARK RECONSTRUCTION SPLD-TUITNPSCH-OW-SPED-P&T SPED-TUITNPSCHOW-SPED-P&T SPED TUITNPSCH DW SPED PUT SPED-TUITNPSCH-OW-SPED-P& SPED-PSYCH-OW-SPED-PROF TECH SPED TUITNPSCH DW SPED P&T SPED-MEDICAL-OW-SPED-PROF&TECH SPED-TUITNPSCH-OW-SPED-P&T INTERIOR BLOG MAINT ATHLETICS-DWUND SUPPLIES RECREATION-TRANSPORTATN. SHS PSYCH SHS REG PROF&TECH SPED-TUITION-OW-SPED-PROF&TECH ATHLETICS DWUND SUPPLIES PROFESSIONAL & TECHNCAL SVC SPED-OIS-OW-SPED PROF & TECH SPED-PSYCH-OW-SPED-PROF&TECH SNOW REMONAL TEXTBOOKS PROFESSIONL & TECH INCL SMC SNOW REMOVAL ATHLETICS-DW-UND-SUPPLIES Budgets + JA . M Department Code D 1 Amount 2 5 75,548 03 3 $ 32,704.33 $ 25,525.00 5 S 20,263.00 6 $ 19,547.00 S 17,223.93 8 5 16,716.30 $ 14.245.53 10 S 12,457.76 11 5 11,BOS 61 12 $ 9,886.77 13 $ 8.180.33 14 5 8,090.01 15 $ 7,504.00 16 $ $ 7,342.35 17 5 7,251.50 18 $ 6,894.53 19 S S 6.380.59 20 S 5,890.20 21 $ 5,832.00 22 S $ 4,970.00 23 $ 1,762.08 24 $ 4,537.50 25 S S 4,503.70 26 S 3,489 50 27 $ 3,176.50 28 $ 3,150.00 29 5 2.700.00 30 $ 2,565.00 31 $ S 2.640.00 32 $ 2.500.00 33 S 2,362.50 34 $ 2.255.00 35 $ 2,131.35 36 $ 2.046.35 37 S 2,000.00 38 $ 1,700.00 39 S 1,700.00 E F Check Date Year Department 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 OSPCD ADMINISTRATION 1/2/13 2013 PERSONNEL DEPARTMENT 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 TRAFFIC AND PARKING 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 WORKER COMPENSATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 OSPCD ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 COUNCIL ON AGING 1/2/13 2013 SCHOOL ADM NISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 OSPCD ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 SCHOOL ADMINISTRATION 1/2/13 2013 DEPARTMENT OF PURLIC WORKS 1/2/13 2013 SOMERVILLE PUBLIC LIBRARY 1/2/13 2013 RECREATION AND YOUTH 1/2/13 2013 DEPARTMENT OF PUBLIC WORKS 1/2/13 2013 SCHOOL ADMINISTRATION Item Number 2 8730-2013 3 15337-2013 1 22980-2013 1 $179-2013 314695-2013 1 14262-2013 3 2972-2013 2 7266-2013 3 15117-2013 1 7704-2013 3 25422-2013 3 15999-2013 3 2631-2013 3 12555-2013 3 9301-2013 1 3806-2013 3 8240-2013 3 14331-2013 3 5993-2013 3 11142-2013 3 25096-2013 3 25887-2013 3 5630-2013 3 13162-2013 2 5267-2013 3 1516-2013 1 8801.2013 33605-2013 3 4800 2013 3 4528-2013 1 23265-2013 3 26207-2013 3 14500-2013 3 2 1180-2013 1 11485 2013 1 2168-2013 2 2232-2013 3 4587-2013 Org Description DPV-BLGD&GRNDS ORDINARY MAINT SPED-TUITNPSCH-DW-SPED QUINCY STREET EXPENSE-HEALTH CLAIMS TRUST SPED MEDICAL DW.SPED TRAFFIC & PARKING ORD MAINT SPEO-TUITNPSCH-DW-SPED DPW-BLGD&GRNDS ORDINARY MAINT SPED-TUITNPSCH DW SPED WORKERS COMP ORDINARY MANT SPED-TUITNCOLAR-DW-SPED SPED-TUITNPSCH-DW-SPED SPED-TUITNPSCH-DW-SPED SPEO TUITNPSCH-DW-SPED SPED-TUITNPSCH-DW-SPED LOWER WYSTIC RR INPRMET SPED-TUITNPSCH-DW-SPED SPED-TUITNPSCH DW SPED SPED-TUITNPSCH-DW-SPED SPED-TUITNPSCH-DW-SPED SPED-PSYCH-OW-SPED SPEO-TUITNPSCH-DW-SPED SPED MEDICAL-DW-SPED SPED-TUITNPSCH DW-SPLO DPW-BLGO&GANDS ORDINARY MAINT ATHLETICS OW-UND COUNCIL ON AGING SHS PSYCH-SHS-REO - SPED-TUITION DW SPED ATHLETICS-OW-UND 2011 LEAD HAZARD REDUCTION SPED OS DW SPED SPED-PSYCH-OW-SPED DPW-SNOW REMVL ORDINARY WANT LIBRARIES ORDINARY MAINTENANCE PARKS AND RECREATION DPW-SNOW REMVL ORDINARY WANT ATHLETICS DWUND Account Desc CIL SPED-TUITNPSCH-DW-SPED-P&T SITE IMP-PARK RECONSTRUCTION MEDICARE PENALLTIES SPED-MEDICAL-DW-SPED PROFATECH REPA RS-HIGHWAYS SPED-TUITNPSCH-DW-SPED-P&T CIL SPED-TUITNPSCH-DW-SPED-P&T LEGAL SERVICES SPED-TUITNCOLAB-OW-SPED-P&T SPED-TUITNPSCH DW SPED-P&T SPED-TUITNPSCH-DW-SPED-P&T SPED-TUITNPSCH DW-SPED-P&T SPED-TUITNPSCH DW-SPED-P&T SITEIMP-PARK RECONSTRUCTION SPED-TUITNPSCH DW SPED-PAT SPEO-TUITNPSCH DW-SPED-P&T SPED-TUITNPSCH-DW-SPED-PAT SPED-TUITNPSCH DW SPED PAT SPED-PSYCH-OW-SPED PROF&TECH SPED-TUITNPSCH-DW-SPED-P&T SPED MEDICAL DW-SPED PROFETECH SPED-TUITNPSCH-DW-SPED-P&T INTERIOR BLOG MANT ATHLETICS DWUND SUPPLIES RECREATION TRANSPORTATN. SHSDSYCHSS-REG-PROERTECH SPED-TUITION-DW-SPED PROFX TECH ATHLETICS-DW-UND-SUPPLIES PROFESSIONAL & TECHNCAL SVO SPED OS-OW-SPED PROFZ.TECH SPED-PSYCH-OW-SPED PROF& TECH SNOW REMOVAL TEXTBOOKS PROFESSIONL & TECHNCL SVC SNOW REMOVAL ATHLETICS DWUND SUPPLIES Item Class Miscellaneous line item Education-related Repairs and maintenance expense Miscelaneousline item Education related Repairs and maintenance expense Education-related Miscellaneaus line item Education-related Midlaneousline item Education related Ecuation-related Education-related Education-related Education-related Reas and inaintenance expense Education related Education related Education-related Education related Ecuation-related Education related Education-related Ecuration related Miscellaneous line item Athletics expense Miscellaneous line item Education-elated Education-related Athletics expense Profesional services expense Education related Education-related Miscellaneous line item Education related Professional services expense Miscellaneous line item Athletics expense Documentation Data Budgets +