Massasoit CC Vendor Expenses, FY15-FY24

Hello,

Pursuant to the Massachusetts Public Records Law, I am hereby submitting a Public Records Request for all money given from Massasoit Community College to external vendors/suppliers in FY2015 through (and including) FY2024, a total of 10 years.

Specifically, the data I am requesting include (but are not limited to):
* all vendors, suppliers, individuals, and public-private partnerships
* all materials, goods, services, properties, commodities, equipment leases, property leases, and licenses
* all catalog orders, non-catalog orders, blanket orders, direct payments, bank card purchases, strategic sourcing, and competitive procurements
* all auxiliary services purchases (starts in 2022, may be from a different accounting system)
* all purchase orders, requisitions, and invoices
* all products, goods, services, contracts, and subcontracts
* all accounts, classes, commodities, and departments
* regardless of the funding source

I’m requesting the data in a single Excel spreadsheet file (.xlsx format) with at least the following columns:
* Amount
* Supplier/Vendor Name
* Account Description
* Commodity Description
* Fiscal Year
* Department/Origin Description

Please report every expense, even if one or more of the above fields is blank. Please also include negative expense amounts, which is rare but does occur.

In case it’s helpful, I've attached an image example of what I’m hoping to receive. The columns may be in any order, and the fiscal years may be on one sheet or different sheets. The columns can be sorted in any order, or unsorted if that’s easiest.

I’m anticipating that this request may be fulfilled by a simple financial report generation and export of the generated file, and therefore shouldn’t take much human time or incur any fees. Please let me know immediately if this isn’t the case, so I can modify my request as necessary to meet the PRL deadline of 10 business days.

Please email the Excel file by the deadline of Monday August 26th, 2024.

Thank you very much!

Sincerely,

AJ Vincelli
Graduate Student Union at UMass Dartmouth

Hi Alex and Karina,

Oh dear, this sounds like a lot of work. Also, I apologize for my delay in responding.

I was hoping that a spreadsheet with the info I requested would be relatively simple. For example, these other community colleges were able to fulfill my request:

MassBay CC:
https://www.muckrock.com/foi/framingham-105/massbay-cc-vendor-expenses-fy15-fy24-171633/

Springfield Tech CC:
https://www.muckrock.com/foi/massachusetts-1/springfield-tech-cc-vendor-expenses-fy15-fy24-171624/

MCLA:
https://www.muckrock.com/foi/north-adams-604/mcla-vendor-expenses-fy15-fy24-171620/

Cape Cod CC:
https://www.muckrock.com/foi/massachusetts-1/cape-cod-cc-vendor-expenses-fy15-fy24-171645/

Is Massasoit CC's system truly that burdensome? If so, which portions of my request are causing the most trouble?

Thanks,

AJ Vincelli

Hi Alex,

That's great news! The info looks good.

May I confirm that any amounts listed in the "Encumbered Amount" column is not an actual expenditure for the college, and can be safely ignored? In other words, am I correct that only the amount listed in the "Transaction Amount" column is money that actually left the college?

Thanks very much,

AJ Vincelli

Hi Alex,

Excellent, thanks very much! I think I'm all set with this FOIA request. I really appreciate your help.

Sincerely,

AJ Vincelli