Middlesex CC Vendor Expenses, FY15-FY24

AJ Vincelli filed this request with the Middlesex Community College of Massachusetts.
Status
Completed

From: AJ Vincelli

Hello,

Pursuant to the Massachusetts Public Records Law, I am hereby submitting a Public Records Request for all money given from Middlesex 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

From:

Mr. Vincelli,

Per your request below attached please find a spreadsheet of the data you requested.

Many Thanks

Allison Chambers

Allison Chambers, CPA
Vice President of Finance &
Chief Financial Officer
Middlesex Community College
Bedford/Lowell, MA
978-656-3287
chambersa@middlesex.edu<mailto:chambersa@middlesex.edu>
(Please note that my email at MCC has changed.)

From: AJ Vincelli

Hi Allison,

Thank you for this information. Unfortunately, I don't see some critical vendor expenses, such as payments to Sodexo for their dining services since FY22 and Apple Spice since FY24. Sometimes these types of payments are in a secondary auxiliary accounting system, and aren't included in the standard reports.

Could you please include these vendor expenses in the report, and any other similar types of missing expenses?

Thanks very much,

AJ Vincelli

From: AJ Vincelli

Hi Allison,

I'm just checking in about this FOIA request?

Thanks,

AJ Vincelli

From: Middlesex Community College

My apologies for a delayed response.

This list was all encompassing, we do not have contracted subsidized dining on site.

Apple Spice DBA “Boston Box Lunch and Catering” utilized our dining facilities using a “for profit” Business model for two semesters and has served a caterer on numerous occasions all of which is represented on this list.

Additionally we did not conduct any business with Sodexo.
Many Thanks

Allison Chambers

From: AJ Vincelli

Hi Allison,

I see the "Boston Box Lunch and Catering" entries, thank you for the additional info.

I'm getting the Sodexo information from the MCC Contracts webpage, under "Snack, Beverage and Fresh Food Vending" bid #MCC-2022-02:
https://www.middlesex.edu/finance/bidsandcontracts.html

I've attached a screenshot.

Am I misreading the contract entry?

Thanks for your help!

AJ Vincelli

From: Middlesex Community College

Sodexo won a contract to fill our vending machines. We do not pay them, we make a very small commission on the items moved through the vending machines.

From: AJ Vincelli

Oh, that makes sense! Thank you very much. In that case, I think I have everything I need!

Thanks again,

AJ Vincelli