DepartmentInformation.xlsx

XLSX spreadsheet 22 KB Posted

Attached to
Purchase Card (Pcard Program)
Contract number
PRF79
Issued by
Massachusetts

About this file

This document is a comprehensive spreadsheet detailing annual transactions and card count for Massachusetts state government departments. The file encompasses 69 distinct governmental agencies and departments, ranging from the Attorney General's Office and Department of Transportation to smaller entities like the Board of Bar Examiners and Department of Elder Affairs. The spreadsheet provides a detailed breakdown of total spend and card count for each participating Commonwealth department, with total annual transactions amounting to $16,802,873.80.

The transaction data reveals significant spending variations across departments, with the Emergency Management Agency ($12,971,325.69) and Department of Transportation ($219,966.21) representing some of the highest expenditures. Other notable departments include the Suffolk District Attorney's Office ($163,664.12), Committee for Public Counsel ($155,240.96), and Massachusetts Military Division ($1,193,447.49). The document includes card count metrics, showing departments like the Department of Revenue using 54 cards, while many others operate with minimal card usage (1-3 cards). This data appears to track government procurement and spending across various state agencies, providing transparency into operational financial activities.

View the file

Other files

Show all 12

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Annual Transactions and CC Num

Department NameTotal SpendTotal Card Count
ADD - DEVELOPMENTAL DISABILITES COUNCIL$ 11,468.231
AGO - ATTORNEY GENERAL OFFICE$ 43,186.3611
AGR-Department of Agricultural Resources$ 12,397.591
APC-Appeals Court$ 6,786.482
ART - MASS CULTURAL COUNCIL$ 36,127.226
BBE - Board of Bar Examiners$ 1,516.791
BER - BERKSHIRE DISTRICT ATTORNEY$ 77,949.313
BLC - BOARD OF LIBRARY COMMISSIONER$ 2,235.602
BSB-Bureau of State Office Buildings$ 799.131
BSD - BRISTOL SHERIFFS DPT$ 17,666.482
CAD-Commission Against Discrimination$ 3,351.521
CDA - EMERGENCY MGMT AGENCY$ 12,971,325.691
CJT-Municipal Police Training Committee$ 40,002.991
CME - CHIEF MEDICAL EXAMINER$ 39,409.881
CNB - CANNABIS CONTROL COMMISSION$ 29,571.152
CPC - COMMITTEE FOR PUBLIC COUNCI$ 155,240.967
CPF-Campaign and Political Finance$ 28,733.821
CTR - OFFICE OF THE COMPTROLLER$ 25,399.022
DAA - DIST ATTYS ASSOC$ 6,376.431
DAC-DISABLED PERSON PROTECTION COMMISSION$ 636.442
DCP - CAPTIAL ASSET MANAGEMENT$ 57,000.061
DCR-Department of Conservation and Recreation$ 4,026.831
DFS - DEPT OF FIRE SERVICES$ 27,433.2414
DMH - DEPT MENTAL HEALTH$ 68,520.5318
DMR - DEPT OF MENTAL R$ 58,783.8210
DOC-Department of Correction$ 15,938.206
DOE - DEPT ELEMENTARY SEC EDU$ 25,000.251
DOR - MA DEPT OF REVENUE$ 94,182.3854
DOT - MA DEPT OF TRANSPORTATION$ 219,966.2114
DPH - DEPT OF PUBLIC HEALTH$ 12,121.367
DPU-Department of Public Utilities$ 49,266.811
DYS - MA DEPT OF YOUTH SERVICES$ 12,687.592
EAS-Eastern District Attorney$ 47,285.703
EDU-Executive Office of Education$ 9,600.021
EED-Executive Office of Housing and Economic Development$ 6,876.791
EHS - EO HEALTH & HUMAN SERVICES$ 13,088.752
ELD - DEPARTMENT OF ELDER AFFAIRS$ 681.931
ENE-Department of Energy Resources$ 2,744.491
ENV - EO OFFICE ENERGY & ENVIRON AFFAIRS$ - 01
EPS - EXEC OFFICE PUBLIC SAFETY$ 3,757.901
FWE-Department of Fish and Game$ 12,295.672
GIC - GROUP INSURANCE COMMISSION$ 360.362
GOV - THE GOVERNOR'S OFFICE$ 19,649.712
HCF - HEALTH CARE FINANCE & POLICY$ 81,235.521
HLY - SOLDIERS HOME HOLYOKE$ 46,547.443
HOU-House of Representatives$ 40,142.431
HPC-Health Policy Commission$ 51,284.381
HRD - HUMAN RESOURCES DIVISION$ 8,218.512
HSD - HAMPSHIRE SHERIFFS DEPT$ 43,527.041
ITD - INFORMATION TECH DIVISION$ 17,096.573
LIB-STATE LIBRARY OF MASSACHUSETTS$ 1,810.663
LOT-Lottery Commission$ 4,570.121
MCB - MASS COMMISSION FOR THE BLIND$ 4,496.833
MCD - MASS COMM FOR THE DEAF & HARD OF HEARING$ 12,181.881
MGC - Mass Gaming Commission$ 12,996.922
MHL-Mental Health Legal Advisors$ 58,037.072
MID - MIDDLE DISTRICT ATTORNEY$ 101,613.292
MIL - MASSACHUSETTS MILITARY DIV$ 1,193,447.492
MRC - MASS REHAB COMMISSION$ 66,015.006
NSD-Nantucket Sheriff's Department$ 29,619.196
OCA - OFFICE OF THE CHILD ADVOCATE$ 5,562.702
OCD - DEPT HOUSING & COMM DEV$ 14,950.211
OHA - MA OFFICE OF DISABILITY$ 2,746.281
OSD - DIV OPERATIONAL SERVICES$ 6,001.221
PAR - MASSACHUSETTS PAROLE BOARD$ 3,038.891
POL - MASS STATE POLICE$ 22,860.872
RGT-DEPT HIGHER EDUCATION$ 3,822.2110
SAO-State Auditor's Office$ 18,825.731
SCA-Office of Consumer Affairs and Business Regulation$ 2,541.692
SDC - BARNSTABLE SHERIFFS DPT$ 10,944.981
SDD-Dukes Sheriff's Department$ 64,815.161
SDE- Essex Sheriff's Department$ 32,060.713
SDF - SHERRIFF DEPARTMENT FRANKLIN$ 69,741.565
SDH-Hampden Sheriff's Department$ 22,956.508
SDM - SHERIFF DEPARTMENT MIDDLESEXOFFICE$ 32,981.022
SDN - NORFOLK SHERRIFF'S DEPT$ 51,326.871
SDO - SUPPLIER DIVERSITY$ - 03
SDP-Plymouth Sheriff's Department$ 55,644.201
SDS - SUFFOLK SHERIFFS DPT$ 71,459.601
SEN - SENATE$ 3,059.814
SUF - SUFFOLK DISTRICT ATTORNEY$ 163,664.121
TRC - MASSACHUSETTS TRIAL COURT$ 1,436.374
TRE - OFFICE STATE TREASURER$ 67,470.762
VWA-Victim & Witness Assistance Board$ 15,772.276
WEL - DEPARTMENT OF TRANSITIONAL ASST$ 14,900.044
Total$ 16,802,873.80

Participating Commonwealth Departments by spend and card count

File details come from the government source that posted it. Updated .