Uniform Citation Data Analysis and Report Grant Budget_05052026.xlsm
XLSM spreadsheet 115 KB Posted
- Attached to
- UNIFORM CITATION DATA ANALYSIS AND REPORT RFR
- Solicitation number
- BD-26-1044-EPS11-1044O-129244
- Issued by
- Massachusetts
About this file
This is a budget template document associated with a Request for Proposals (RFP) issued by the Massachusetts Executive Office of Public Safety and Security, Office of Grants and Research (OGR), for the Uniform Citation Data Analysis and Report grant project. The RFP seeks proposals from Massachusetts-based universities, non-profit organizations, or institutions with experience in analytical consultation services and expertise in analyzing demographic and other information collected from motor vehicle stops. The budget template covers two fiscal years: July 1, 2026 through June 30, 2027, and July 1, 2027 through June 30, 2028.
The budget template provides detailed guidance on allowable and unallowable cost categories, including personnel costs, fringe benefits, contractors and consultants, travel, equipment and technology, supplies, and other costs. Consultant rates are capped at $650 per eight-hour day or $81.25 per hour, excluding travel and subsistence costs, with any requests exceeding this rate requiring prior written approval from OGR. In-state mileage reimbursement is limited to $0.70 per mile. Unallowable costs include construction, office furniture, food, and beverages. The template requires applicants to provide detailed descriptions for each line item and forecasted expenses for both fiscal years. Award disbursement is contingent upon funding availability, and all proposed services must align with the scope of work detailed in the RFR document.
View the file
Other files
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
Opening Document
| UPON OPENING DOCUMENT… |
| IF THE RED BANNER OCCURS…. |
| 1. DOWNLOAD DOCUMENT AND SAVE TO DESKTOP |
| 2. RIGHT CLICK, PROPERTIES |
| 3. MAKE SURE THERE IS A CHECK IN THE UNBLOCK BOX, CLICK APPLY, CLICK OK |
| 4. REOPEN EXCEL WORKBOOK |
| 5. IF NEEDED, ENABLE EDITING, ENABLE CONTENT |
Budget Summary
| Enter Applicant Name Here: | |
| Project Title: | Uniform Citation Data Analysis and Report |
Any award or disbursement of payment is contingent upon the availability of funding. This budget will help the Office of Grants and Research (OGR) understand the true and unbiased costs for potential vendors to fulfill the requested services as stated in the RFR document. Using the respective tabs, please forecast expenses for the time periods of "July 1, 2026 - June 30, 2027" and "July 1, 2027 - June 30, 2028". To help the reviewer(s) understand what each budgeted line item is for, please provide a detailed description per line item.
| Cost | ||||
| Categories | 7/1/2026 - 6/30/2027 | 7/1/2027 - 6/30/2028 | Totals | |
| Personnel Costs | $ - 0 | $ - 0 | $ - 0 | |
| Fringe Costs | $ - 0 | $ - 0 | $ - 0 | |
| Contractors & Consultants | $ - 0 | $ - 0 | $ - 0 | |
| Travel Costs | $ - 0 | $ - 0 | $ - 0 | |
| Equipment & Technology | $ - 0 | $ - 0 | $ - 0 | |
| Supplies Costs | $ - 0 | $ - 0 | $ - 0 | |
| Other Costs | $ - 0 | $ - 0 | $ - 0 | |
| TOTALS: | $ - 0 | $ - 0 | $ - 0 |
July 1, 2026 - June 30, 2027
| Executive Office of Public Safety and Security |
| Office of Grants and Research |
| Uniform Citation Data Analysis and Report |
| July 1, 2026 - June 30, 2027 Budget - |
PERSONNEL
Employee Name Pay Rate Quantity Description Cash Expenditures
Subtotal: $ - 0
FRINGE & PAYROLL TAX
Employee Name Wages Applied to Fringe Contract Fringe Rate Description Cash Expenditures
Subtotal: $ - 0
CONTRACTS/CONSULTANTS
Contractor/Consultant Name Pay Rate Quantity Description Cash Expenditures
Subtotal: $ - 0
TRAVEL
Employee Name Rate Quantity Description Cash Expenditures
Subtotal: $ - 0
EQUIPMENT & TECHNOLOGY
Equipment/Company Cost Quantity Description Cash Expenditures
Subtotal: $ - 0
SUPPLIES
Supplies/Company Cost Quantity Description Cash Expenditures
Subtotal: $ - 0
OTHER
Item/Company Cost Quantity Description Cash Expenditures
Subtotal: $ - 0
Grand Total: $ - 0
Add Personnel Delete Row Add Fringe Delete Row Add Other Delete Row Add Travel Delete Row Add Equipment Delete Row Add Supplies Delete Row Add C/C Delete Row
July 1, 2027 - June 30, 2028
| Executive Office of Public Safety and Security |
| Office of Grants and Research |
| Uniform Citation Data Analysis and Report |
| July 1, 2027 - June 30, 2028 Budget - |
PERSONNEL
Employee Name Pay Rate Quantity Description Cash Expenditures
Subtotal: $ - 0
FRINGE & PAYROLL TAX
Employee Name Wages Applied to Fringe Contract Fringe Rate Description Cash Expenditures
Subtotal: $ - 0
CONTRACTS/CONSULTANTS
Contractor/Consultant Name Pay Rate Quantity Description Cash Expenditures
Subtotal: $ - 0
TRAVEL
Employee Name Rate Quantity Description Cash Expenditures
Subtotal: $ - 0
EQUIPMENT & TECHNOLOGY
Equipment/Company Cost Quantity Description Cash Expenditures
Subtotal: $ - 0
SUPPLIES
Supplies/Company Cost Quantity Description Cash Expenditures
Subtotal: $ - 0
OTHER
Item/Company Cost Quantity Description Cash Expenditures
Subtotal: $ - 0
Grand Total: $ - 0
Add Personnel Delete Row Add Fringe Delete Row Add Other Delete Row Add Travel Delete Row Add Equipment Delete Row Add Supplies Delete Row Add C/C Delete Row
Budget Guidelines
| Allowable Budget Cost Categories | Explanation of Allowable Costs |
| Personnel | · Full or part-time regular salaried employees working on the contract. |
| Fringe | · Employer Fringe benefits requested to be paid by this contract can be based on either: 1) actual known paid costs for each benefit category, or 2) an established formula applied to the base salary numbers, broken out by the benefit category. Fringe benefits are for the personnel listed in the Personnel budget category and only for the percentage of time devoted to the project. You may also include employer paid payroll taxes here as a separate cost. |
| Contracts/Consultants | · Consultant or contractor fees. |
| · The maximum rate for consultants is $650 for an eight-hour day or $81.25 per hour (excluding travel and subsistence costs). Any request for compensation over $650 per day requires prior written approval by OGR. | |
| · Contracts – a competitive process based on the agency’s procurement policy should be followed when procuring contracted services. | |
| · Contract salary, fringe benefit, travel, and other costs should follow instructions within direct salary, fringe benefit, travel, and other cost categories. | |
| Local Travel | · Travel directly related to the purpose of the contract. |
| · In-state travel costs associated with the contract shall include mileage rates not in excess of $0.70 per mile, as well as the actual costs of tolls and parking. | |
| Equipment (Communication, IT, etc.) | · Tangible, non-expendable personal property having a useful life of more than one year; cost based on classification of equipment. |
| Supplies | · General supplies required for project or office (pens, pencils, postage, training materials, copying paper, and other expendable items such as books, ink, etc.). |
| Other | · Items (e.g., rent costs, telephone costs, reproduction costs, training material costs, 10% contract administration costs). |
| · Printing costs. | |
| · Direct and/or support service costs relevant to the proposed project that cannot be listed within the personnel, fringe, consultants/ contracts, travel and/or supplies cost category can be included in the “Other” cost category. Please be sure to itemize each cost type and detail as to how the amount budgeted was calculated. |
| Unallowable Budget Cost Categories | Explanation of Unallowable Costs |
| Other | · No contract funds may be spent for construction, office furniture, or other like purchases. |
| · No contract funds may be spent on food or beverages |
Budget Sheet Instructions
&P
Examples
| PERSONNEL | ||||
| Employee Name | Pay Rate | Quantity | Description | Cash Expenditures |
| Example: Sue Smith | $ 23.4875 | 300.0000 | Please describe duties of Employee here. | $ 7,046.25 |
| Example: Tracey Thomas | $ 1,730.7700 | 6.0000 | Please describe duties of Employee here. | $ 10,384.62 |
| FRINGE AND PAYROLL TAX | ||||
| Employee Name | Wages Applied to Fringe | Contract Fringe Rate | Description | Cash Expenditures |
| Example: Sue Smith | $ 7,046.2500 | 21.0000% | Per the fringe rate agreement, find the applicable cost categories to apply fringe to. In this example, the applicable cost category is "Personnel." Take Sue Smith's total wages reported on this worksheet under the "Personnel" section and multiply by the federally approved fringe rate or the fringe rate that was proposed and approved by OGR in the application process. ($7,046.25 * 21%). Match expenditures should be in relation to the match in the applicable category. | $ 1,479.71 |
| Example: Tracey Thomas | $ 10,384.6200 | 10.0000% | Per the fringe rate agreement, find the applicable cost categories to apply fringe to. In this example, the applicable cost category is "Personnel." Take Tracey Thomas' total wages reported on this worksheet under the "Personnel" section and multiply by the breakout of what rates are being charged per eligible cost. (7.5% - health insurance, 2% - life insurance, .5% - workers compensation). | $ 1,038.46 |
| CONTRACTS/CONSULTANTS | ||||
| Contractor/Consultants Name | Pay Rate | Quantity | Description | Cash Expenditures |
| Example: JJ Counseling | $ 200.0000 | 24.0000 | Please provide the names of each Contractor and Consultant as well as duties/obligations that will be performed here. | $ 4,800.00 |
| Example: JJ Contracting | $ 45.0000 | 210.0000 | Please provide the names of each Contractor and Consultant as well as duties/obligations that will be performed here. | $ 9,450.00 |
| TRAVEL | ||||
| Employee Name | Rate | Quantity | Description | Cash Expenditures |
| Example: Sue Smith | $ 250.0000 | 1.0000 | Gas reimbursement related to contract. | $ 250.00 |
| Example: Tracey Thomas | $ 0.7000 | 500.0000 | Travel related to contract; $0.70/mile x 500 miles | $ 350.00 |
| EQUIPMENT | ||||
| Equipment | Cost | Quantity | Description | Cash Expenditures |
| Example: Laptop | $ 1,200.0000 | 1.0000 | Please describe purpose of Equipment here. | $ 1,200.00 |
| Example: Computer Keyboard | $ 50.0000 | 3.0000 | Please describe purpose of Equipment here. | $ 150.00 |
| SUPPLIES | ||||
| Supplies/Company | Cost | Quantity | Description | Cash Expenditures |
| Example: Copy Paper | $ 50.0000 | 4.0000 | Please describe purpose of Supplies here. | $ 200.00 |
| Example: ABC Office Supply | $ 75.0000 | 1.0000 | Please describe purpose of Supplies here. | $ 75.00 |
| OTHER | ||||
| Item/Company | Cost | Quantity | Description | Cash Expenditures |
| Example: Telephone | $ 65.0000 | 6.0000 | Please describe purpose of item/activity here. | $ 390.0000 |
| Example: Printing Costs | $ 6,000.0000 | 0.2500 | Please describe purpose of item/activity here. | $ 1,500.0000 |
Page &P of &N image1.png image2.png image3.png image4.png
File details come from the government source that posted it. Updated .