110x Filetype XLSX File size 0.02 MB Source: purchase.umd.edu
Sheet 1: Revised Instructions
MBE Prime Contractor Monthly Reporting Instructions (MBE Attachment 4A) | ||||||||||||||
Distributed June, 2020 | ||||||||||||||
All participating Prime and subcontractors are required to submit their MBE Monthly Payment reports to University of Maryland College Park (UMCP) for each contract by the State of Maryland and Attestation Signature. Please submit in the attached EXCEL FORMAT no later than the 15th of each month via email to mbe@umd.edu. The submission should include: | ||||||||||||||
· The signature page and detailed spreadsheet Monthly. (template attached). | ||||||||||||||
· NOTE: These worksheets are protected. All fields are required. Fields A-1, B-1, E-3, N-3 have fixed drop-down menus. | ||||||||||||||
*Per COMAR 21.11.03.13, the Contractor shall submit monthly to the MBE Liaison a Prime Contractor MBE Monthly Payment Report (MBE-4A) and MBE Subcontractor Monthly Payment Report (MBE-5). | ||||||||||||||
Sec. 21.07.02.05-2. Prompt Payment of Subcontractors | ||||||||||||||
FY2020 MBE PRIME AND SUBCONTRACTOR REPORTING REQUIREMENTS | ||||||||||||||
REQUIRED SIGNATURES: | ||||||||||||||
Print the sheet, execute as requested, and submit in pdf format. | ||||||||||||||
COLUMNS | ||||||||||||||
Column A-1 REPORTING MONTH (required field): Select the Month you are reporting for from the drop-down menu. | ||||||||||||||
Column B-1 REPORTING Year (required field): Select the Year you are reporting for from the drop-down menu. . | ||||||||||||||
Column A-2 PRIME CONTRACTOR (required field): Enter prime contractor’s company name | ||||||||||||||
Column B-2 Prime Contractor’s UMD Contract Number (required field): Enter prime contractor’s UMD contract number. Prime contractor will supply you with this information. | ||||||||||||||
Column C-2 Project Name: Enter the project’s name. | ||||||||||||||
Column D-2 MBE Subcontractor Name: Enter each Subcontractor(s) Company name(s). | ||||||||||||||
Column E-3 Work/Service Performed (required Field): Select an entry from the drop down menu. You must use one of the options on the drop down menu. Attempts to enter something else will be rejected. | ||||||||||||||
Column F-2 Original Subcontract Amount | ||||||||||||||
Column G-2 Current Subcontract Amount | ||||||||||||||
Column H-2 Payment Date | ||||||||||||||
Column I-2 Amount Paid this Reporting Period (Monthly): Enter the amount paid to each subcontractor for this reporting period. If you paid multiple payments to a subcontractor this reporting period you should make an entry for each payment paid. | ||||||||||||||
Column J-2 Amount of Paid this Fiscal Year: Enter the amount paid to each subcontractor for this Fiscal Year (July 1 to June 30) | ||||||||||||||
Column K-2 Amount Paid to Date: Enter the amount paid to each subcontractor for all invoices on this contract to date. | ||||||||||||||
Column L-2 Amount of Payments 30 Days Late: Enter payment that is more than 30 days late for each subcontractor. If you have multiple payments to the same vendor that are late, you should make an entry for each payment owed. | ||||||||||||||
Column M-2 Balance to Finish (automatically calculated) | ||||||||||||||
Column N-3 Minority Description: Select the appropriate description from the drop down menu. Attempts to enter values not on the drop down menu will be rejected. | ||||||||||||||
Column O-2 MBE Certificate Number: Enter the subcontractor’s MDOT MBE certification number. If you do not know the certificate number it can be found herehttps://mbe.mdot.maryland.gov/directory/ | ||||||||||||||
Column P-2 Comments |
May | 2020 | University of University of Maryland, College Park - PRIME CONTRACTOR MBE MONTHLY PAYMENT REPORT - MBE ATTACHMENT 4A (Last revised 6/1/2020) |
|||||||||||||||||
Prime Contractor | Prime Contractor’s UMD Contract Number | Project Name | MBE Sub-Contractor | Work Service Performed | Original Sub-Contract Amount | Current Sub-Contract Amount | Payment Date | Amount Paid by Prime for this Reporting Period (Monthly) | Amount Paid this Fiscal Year (July 1 to June 30) | Amount Paid to Date | Amount of Payments Over 30 Days Late | Balance to Finish | Minority Description | MBE CERT Number | Comments | Minority Sub-Categories Drop Down Values | Work, Service Performed Drop Down Values | Reporting Date Drop Down Values | Fiscal Year Drop Down Values |
$0.00 | African American | Architectural | January | 2020 | |||||||||||||||
$0.00 | African American Woman | Engineering | February | 2021 | |||||||||||||||
$0.00 | Asian American | Construction | March | 2022 | |||||||||||||||
$0.00 | Asian American Woman | Construction Related Services | April | 2023 | |||||||||||||||
$0.00 | Hispanic American | Maintenance | May | 2024 | |||||||||||||||
$0.00 | Hispanic American Woman | Services | June | ||||||||||||||||
$0.00 | Native American | Supplies & Equipment | July | ||||||||||||||||
$0.00 | Native American Woman | IT Services | August | ||||||||||||||||
$0.00 | Woman | IT Supplies & Equipment | September | ||||||||||||||||
$0.00 | October | ||||||||||||||||||
$0.00 | November | ||||||||||||||||||
$0.00 | December | ||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 | |||||||||||||||||||
$0.00 |
no reviews yet
Please Login to review.