2020-JAII-04 Attachment D RD Grant Capital Budget and Invoice Template-Match.xlsx
XLSX spreadsheet 100 KB Posted
- Attached to
- 2020-JAII-04 Collaborative Research Matching Grant Program Request for Grant Applications
- Solicitation number
- BD-20-1367-1367C-1367L-46253
- Issued by
- Worcester County, Massachusetts
About this file
This document is a budget and invoice template for a Request for Grant Applications (RFA) issued by the John Adams Innovation Institute, a division of the Massachusetts Technology Collaborative. The RFA offers matching funds for capital expenditures related to collaborative research projects sponsored by public, private, and nonprofit entities in Massachusetts. The budget template provides guidelines for allowable capital and non-capital costs, match requirements, and invoicing procedures. It includes sections for applicant information, budget period, cost elements, capital expenditures, and other project expenses. The template also specifies documentation requirements, variance allowances, and the need for prior approvals from the Program Manager for certain budget changes. The RFA is a rolling solicitation that will remain open until closed by the Massachusetts Technology Collaborative.
The budget template outlines the required cost elements and format for submitting invoices and match documentation. It specifies that match can be provided in the form of cash or in-kind contributions, and that match expenditures must be directly relevant and beneficial to the project. The template also provides guidelines for determining the valuation of in-kind contributions and the need to properly document the source and nature of all match funds.
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
Budget&Invoice_Template
| Line Number | Budgeting | LEGEND: | |||||||||||||||||||||||||||||||||||||||||||||||
| 2 | Applicant Information | Tab | These tabs need to be completed and submitted with proposal | ||||||||||||||||||||||||||||||||||||||||||||||
| 3 | Applicant: | Solicitation No.: | Tab | These tabs are guidelines for Budget and Match requirements | |||||||||||||||||||||||||||||||||||||||||||||
| 4 | Budget Period: | Title of Proposed Project: | Cell | Formula cell | |||||||||||||||||||||||||||||||||||||||||||||
| 5 | Address: | Cell | Data entry cell | ||||||||||||||||||||||||||||||||||||||||||||||
| 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 7 | This section is for post-contract invoicing only. Do not complete with proposal. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 8 | MTC Funding Requested: | ||||||||||||||||||||||||||||||||||||||||||||||||
| 9 | Total Project Cost: | Invoicing Year 1 | Invoicing Year 2 | Invoicing Year 3 | Invoicing Year 4 | Invoicing Year 5 | |||||||||||||||||||||||||||||||||||||||||||
| 10 | Cost Elements | Total Project | Match Funds | MTC Funding | Check (should be zero) | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Cumulative | |||||||||||||||||||||||
| 11 | CAPITAL | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | |||||||||||||||||||||||||||
| 12 | The acquisition cost of capital assets or the expenditures to make improvement to capital assets that materially increase their value. Acquisition cost includes the cost of putting the asset in place. | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Expended | Remaining | ||||||||||||||||||||||||||
| 13 | I. Equipment, land, building, etc. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 14 | $0 | $0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||||||
| 15 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 16 | $ - 0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 17 | $ - 0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 18 | $ - 0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 19 | Total Capital Expenditures | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 20 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 21 | II. Capital Labor | ||||||||||||||||||||||||||||||||||||||||||||||||
| 22 | name/title | Annual Salary | Percent Effort | ||||||||||||||||||||||||||||||||||||||||||||||
| 23 | $0 | $0 | $0 | $0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||||
| 24 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 25 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 26 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 27 | Total Labor | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 28 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 29 | II. Direct Labor Fringe Cost | Rate (%): | $0 | $0 | $0 | -$0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| 30 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 31 | III. Capital Subcontractors/Consultants | ||||||||||||||||||||||||||||||||||||||||||||||||
| 32 | Firm name/title of consultant/type of services to be provided | hours | rate/hr | ||||||||||||||||||||||||||||||||||||||||||||||
| 33 | $0 | $0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||||||
| 34 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 35 | $0.00 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 36 | $0.00 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 37 | Total Subcontractors/Consultants | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 38 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 39 | IV. Capital Direct Materials | ||||||||||||||||||||||||||||||||||||||||||||||||
| 40 | $0.00 | $0.00 | $ - 0 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||
| 41 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||||
| 42 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||||
| 43 | Total Direct Materials | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 44 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 45 | V. Other Capital Costs (list by type) | ||||||||||||||||||||||||||||||||||||||||||||||||
| 46 | $0.00 | $0.00 | $ - 0 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||
| 47 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||||
| 48 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||||
| 49 | Total Other Capital Costs | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 50 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 51 | VI. Capital Overhead/Indirect Costs | Rate (%): | 0% | $0.00 | $0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||||
| 52 | TOTAL Capital Project Expenditures | $0 | $0 | $0 | -$0.00 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||
| 53 | Other Project Expenses | ||||||||||||||||||||||||||||||||||||||||||||||||
| 54 | (not capitalizable under GAAP and not reimbursable) | ||||||||||||||||||||||||||||||||||||||||||||||||
| 55 | I. Direct Labor | ||||||||||||||||||||||||||||||||||||||||||||||||
| 56 | name/title | HRS | Rate | ||||||||||||||||||||||||||||||||||||||||||||||
| 57 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 58 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 59 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 60 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 61 | Total Direct Labor | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 62 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 63 | II. Direct Labor Fringe Cost | Rate (%): | |||||||||||||||||||||||||||||||||||||||||||||||
| 64 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 65 | II. Subcontractors/Consultants | ||||||||||||||||||||||||||||||||||||||||||||||||
| 66 | Firm name/title of consultant/type of services to be provided | hours | rate/hr | ||||||||||||||||||||||||||||||||||||||||||||||
| 67 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 68 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 69 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 70 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 71 | Total Subcontractors/Consultants | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 72 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 73 | III. Direct Materials | ||||||||||||||||||||||||||||||||||||||||||||||||
| 74 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 75 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 76 | Total Direct Materials | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 77 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 78 | IV. Travel | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 80 | V. Other Direct Costs (list by type) | ||||||||||||||||||||||||||||||||||||||||||||||||
| 81 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 82 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 83 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 84 | Total Other Direct Costs | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 85 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 86 | VI. General & Administrative Expense/Overhead | Rate (%): | 0% | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 87 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 88 | Total Other Project Costs | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||||
| 89 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 90 | Total PROJECT COSTS | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 91 | Cost Share | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||||||||||||||||
| 92 | Contractual Minimum Cost Share Met (Yes/No) | 1 | 1 | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | |||||||||||||||||||||||||
| Additional detail in support of the budget should be provided on the Budget Assumptions tab | |||||||||||||||||||||||||||||||||||||||||||||||||
| Upon invoicing, additional detail in support of the match expenditures should be provided on the Supporting Schedule |
&"Arial,Bold"&11Massachusetts Technology Collaborative
Research and Development Standard Budget and Invoice Template Invoiced Costs
Budget- Cost by Fiscal Year
| FY'22 (July 1, 2021-June 30, 2022) | FY'23(July 1, 2022-June 30, 2023) | FY'24 (July 1, 2023-June 30, 2024) | FY'23(July 1, 2024-June 30, 2025) | FY'24 (July 1, 2025-June 30, 2026) | Total | Check Against Approved Budget Totals | |
| Capital Expenditures Budget | |||||||
| Equipment, Land, Buildings, etc. | $0.00 | $0.00 | |||||
| Labor | $0.00 | $0.00 | |||||
| Direct Benefits/Fringe Cost | $0.00 | $0.00 | |||||
| Subcontractors/Consultants | $0.00 | $0.00 | |||||
| Direct Materials | $0.00 | $0.00 | |||||
| Other Capitalizable Costs | $0.00 | $0.00 | |||||
| Capital Overhead/Indirect Costs | $0.00 | $0.00 | |||||
| Total Capital | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Non-Capital Budget Costs | |||||||
| Direct Labor | $0.00 | $0.00 | |||||
| Direct Benefits/Fringe Cost | $0.00 | $0.00 | |||||
| Subcontractors/Consultants | $0.00 | $0.00 | |||||
| Direct Materials | $0.00 | $0.00 | |||||
| Other Direct Costs | $0.00 | $0.00 | |||||
| Overhead/Indirect Costs | $0.00 | $0.00 | |||||
| Total Non-Capital | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Total Project Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Grant Funds Expenditures by Fiscal Year** | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Match/Costs Share Funds | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
** Project the costs from the budget template annually based upon the Participants anticipated timing of expending the grant funds. Availability of funds from MassTech is subject to authorization from the Commonwealth, and is not guaranteed at the levels requested.
Budget Breakdown: Annually
Budget Assumptions
| Budget Assumptions -- Standard Budget Form | |
| Please provide supporting details to line items on the budget template if not self explanatory. | |
| Budget Line # | Item detailed description, basis of budgeted costs, explanation of determination of capitalize costs vs. non-capital costs, basis of indirect cost rate and approving authority, and any other relevant details to support budget costs |
| Example: Line 86 | G&A % is based upon our federally approved rate, indirect cost rate agreement is attached. |
Budget Guidelines
PARTICIPANT BUDGET/INVOICE GUIDELINES
These guidelines apply to MassTech R&D grants that require Participants to incur expenditures in line with approved budgets within their contracts. In developing these guidelines, MassTech has drawn heavily from the policies and practices applied by federal and other state agencies that also require adherence to grant budgets. Adherence to approved budgets ensures that MassTech is expending funds in a fiscally responsible manner and, managing to the legislation of the state appropriated funds.
Capital Grant Expenditure Categories:
• Capital Labor: Direct labor at actual cost to the Participant, based upon an hourly rate, or percent effort of an annual base salary.
• Capital Fringe: Benefits related to direct labor costs, can either be incurred as a direct expense or an allocated cost with an approved rate. Documentation of Participant approved rates should be submitted at the time of proposal.
• Capital Consultants/Subcontracts: contracted services to perform a specific task related to the project or, subcontracts granting funds for performance of a key aspect of the project.
• Capital Direct Materials: Materials and supplies needed in direct support of the project, in order to obtain the objectives as stated in the approved budget and contract.
• Other Capital Direct Costs: This includes categories such as travel and materials.
• Capital General & Administrative Expense/Overhead: An allocated cost that must be capital and based upon an approved rate. Indirect cost rates shall be assessed in accordance with your institutions rate agreement as it pertains to capital expenditures. Documentation of Participant approved rates should be submitted at the time of proposal.
Capital Expenditure Guidelines:
• Participant may only be reimbursed for capital cost incurred and expenditures must be properly recorded as capital, and verifiable in the Participant’s records.
• MassTech may allow up to a 5% annual increase in the direct labor rates set forth in the budget to account for actual cost of living increases over multiyear reimbursement periods. This variance must be explained in the supporting schedule when invoicing and is subject to approval by the Program Manager.
• MassTech may allow up to a 20% variance from the rates on services/consultants if estimates where used in creating the budget. This variance must be explained in the supporting schedule when invoicing and is subject to approval by the Program Manager.
• MassTech may allow up to a 10% variance from cost categories set forth in the approved budget and explained in the supporting schedule when invoicing.
• Any variance greater than the thresholds listed above, must be formally approved by the Program Manager prior to invoice submission and may require formal amendment to the contract.
• Participant must incur costs within the grant period. Pre-award spending is only allowed when incorporated through a provision in the grant agreement.
• Participant may not be reimbursed for grant expenditures by any other source.
• Direct replacement of personnel with similar roles and rates should be explained in the supporting schedule. Any newly added staff/roles meant to be in addition to personnel identified in the approved budget must be approved by the Program Manager prior to invoice submission.
Participant Documentation Requirements:
• To the extent the Participant can produce accounting-system generated reports, deemed acceptable by MassTech, to verify expenditure amounts consistent with the budget categories that tie to invoice amounts and categories, they should be submitted with all invoices. MassTech reserves the right to request additional supporting documentation at any time.
• To the extent the Participant can’t provide, or MassTech does not accept the form of accounting-system generated reports, the Participant must provide supporting documentation that could include, but is not limited to, vendor invoices, labor reports listing hours and rates by employee.
• Participant must submit with its invoice, the certification relating to the appropriateness of the reimbursable costs and amounts of match costs, as attached to the contract, with a signature by an individual with knowledge of the information to which the certification relates and who is authorized to certify on behalf of the organization.
Match Guidelines
PARTICIPANT MATCH GUIDELINES
These guidelines apply to MassTech grants that require Participant’s to secure and provide matching funds to cover the portion of the project expenses not to be reimbursed by MassTech. In developing this policy, MassTech has drawn heavily from the policies and practices applied by federal and other state agencies that require match under their programs.
Forms and Source of Match:
• Cash Contribution: Cash contributions specifically to cover a portion of the actual costs incurred of the grant-funded project.
• In-kind Contribution: In-Kind donations can be in the form of necessary services, volunteers, materials, and equipment if it’s directly related to the project objectives.
• Source: The cash and in-kind contributions can come from the Participant or from third parties, so long as it is not sourced by, or considered discretionary funds under the control of, a state agency as defined in Mass. Gen. Laws Ch. 6, § 39.
Match Fund Guidelines:
• Participant must include use of match funds in the approved budget, within the MassTech grant agreement.
• At project start, Participant must clearly document the direct relevance and benefit of the proposed match to the project. MassTech will review the source and nature of the match, and document approval internally.
• Participant must document match met within the invoice period, and to the extent possible it should be ratable with the expenditure of the MassTech grant funds .
• Participant must incur match expenditures and receive in-kind contributions within the grant period. Prior approval is required to allow match that falls outside that period.
• Participant must properly document the basis for determining the valuation for items such as volunteer services and donated property, if the matching funds include in-kind contributions.
• Participant may not apply approved match amounts as match on any other award.
Participant Documentation Requirements:
•Participant should provoide a narrative explanation of the source of match as well as the relevance of the match to the funded project, if this is not included as part of the proposal it shoudl be done wiht the first invoice and then any necessary updates to that narrative should be provided during the grant period to the extent there are changes or addtional match items.
•Participant should record amounts considered as match in the Participant’s books and this must be verifiable from the Participant’s records.
• Invoices shall provide reasonable documentation including system-generated detailed activity reports showing income and expenses to provide evidence of costs incurred for the required match met (just as it is for reimbursable costs). Additional documentation to support costs may be requested by MassTech from time to time and may include vendor invoices and effort reports listing percent effort and annual base salary by employee/volunteer. • When In-Kind contributions are booked on the Participants accounting records, this should be documented using a detailed system-generated report. To the extent it is not booked, we will need a donation letter from the donor stating its value and intent to support the project. For any in-kind contributions not recorded on the Participants books, the basis for determining the valuation must be documented within the donation letter.
• Participant must submit with its invoice, the certification relating to the appropriateness of the matching funds, as attached to the contract, with a signature by an individual with knowledge of the information to which the certification relates and who is authorized to certify on behalf of the organization.
Invoice Form_Match Recorded
| Line Number | Budgeting | LEGEND: | |||||||||||||||||||||||||||||||||||||||||||||||
| 2 | Applicant Information | ||||||||||||||||||||||||||||||||||||||||||||||||
| 3 | Applicant: | Solicitation No.: | Formula cell | ||||||||||||||||||||||||||||||||||||||||||||||
| 4 | Budget Period: | Title of Proposed Project: | Data entry cell | ||||||||||||||||||||||||||||||||||||||||||||||
| 5 | Address: | 0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 7 | This section is for post-contract invoicing only. Do not complete with proposal. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 8 | MTC Funding Requested: | $0 | |||||||||||||||||||||||||||||||||||||||||||||||
| 9 | Total Project Cost: | $0 | Match Year 1 | Match Year 2 | Match Year 3 | Match Year 4 | Match Year 5 | ||||||||||||||||||||||||||||||||||||||||||
| 10 | Cost Elements | Total Project | Match Funds | MTC Funding | Check (should be zero) | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Cumulative | |||||||||||||||||||||||
| 11 | CAPITAL | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | Period: MM/DD/YYYY-MM/DD/YYYY | |||||||||||||||||||||||||||
| 12 | The acquisition cost of capital assets or the expenditures to make improvement to capital assets that materially increase their value. Acquisition cost includes the cost of putting the asset in place. | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Expended | Remaining | ||||||||||||||||||||||||||
| 13 | I. Equipment, land, building, etc. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 14 | $ - 0 | $0.00 | $0.00 | $0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||||
| 15 | $ - 0 | $0.00 | $0.00 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 16 | $ - 0 | $0.00 | $0.00 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 17 | $ - 0 | $0.00 | $0.00 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 18 | $ - 0 | $0.00 | $0.00 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 19 | Total Capital Expenditures | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 20 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 21 | II. Capital Labor | ||||||||||||||||||||||||||||||||||||||||||||||||
| 22 | name/title | Annual Salary | Percent Effort | ||||||||||||||||||||||||||||||||||||||||||||||
| 23 | 0 | $0 | $0 | $0 | $0 | $0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| 24 | 0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||
| 25 | 0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||
| 26 | 0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||
| 27 | Total Labor | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 28 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 29 | II. Direct Labor Fringe Cost | Rate (%): | 0% | $0 | $0 | $0 | -$0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||||||
| 30 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 31 | III. Capital Subcontractors/Consultants | ||||||||||||||||||||||||||||||||||||||||||||||||
| 32 | Firm name/title of consultant/type of services to be provided | hours | rate/hr | ||||||||||||||||||||||||||||||||||||||||||||||
| 33 | 0 | $0 | $0 | $0 | $0 | $0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| 34 | 0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||
| 35 | 0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||
| 36 | 0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||
| 37 | Total Subcontractors/Consultants | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 38 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 39 | IV. Capital Direct Materials | ||||||||||||||||||||||||||||||||||||||||||||||||
| 40 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||
| 41 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||
| 42 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||
| 43 | Total Direct Materials | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 44 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 45 | V. Other Capital Costs (list by type) | ||||||||||||||||||||||||||||||||||||||||||||||||
| 46 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||
| 47 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||
| 48 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||||||
| 49 | Total Other Capital Costs | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 50 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 51 | VI. Capital Overhead/Indirect Costs | Rate (%): | 0% | $0 | $0 | $0 | $0.00 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||
| 52 | TOTAL Capital Project Expenditures | $0 | $0 | $0 | -$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||
| 53 | Other Project Expenses | ||||||||||||||||||||||||||||||||||||||||||||||||
| 54 | (not capitalizable under GAAP) | ||||||||||||||||||||||||||||||||||||||||||||||||
| 55 | I. Direct Labor | ||||||||||||||||||||||||||||||||||||||||||||||||
| 56 | name/title | Annual Salary | Percent Effort | ||||||||||||||||||||||||||||||||||||||||||||||
| 57 | 0 | $0 | $0 | $0 | $0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||||||||
| 58 | 0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 59 | 0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 60 | 0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 61 | Total Direct Labor | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 62 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 63 | II. Direct Labor Fringe Cost | Rate (%): | 0% | $0 | $0 | $0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| 64 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 65 | II. Subcontractors/Consultants | ||||||||||||||||||||||||||||||||||||||||||||||||
| 66 | Firm name/title of consultant/type of services to be provided | hours | rate/hr | ||||||||||||||||||||||||||||||||||||||||||||||
| 67 | 0 | $0 | $0 | $0 | $0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||||||||
| 68 | 0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 69 | 0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 70 | 0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||
| 71 | Total Subcontractors/Consultants | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 72 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 73 | III. Direct Materials | ||||||||||||||||||||||||||||||||||||||||||||||||
| 74 | $0.00 | $0.00 | $0.00 | $ - 0 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||
| 75 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||||
| 76 | Total Direct Materials | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 77 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 78 | IV. Travel | $0.00 | 0 | $0.00 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||||
| 79 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 80 | V. Other Direct Costs (list by type) | ||||||||||||||||||||||||||||||||||||||||||||||||
| 81 | $0.00 | $0.00 | $0.00 | $ - 0 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||
| 82 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||||
| 83 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||||||||||||
| 84 | Total Other Direct Costs | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||
| 85 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 86 | VI. General & Administrative Expense/Overhead | Rate (%): | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $ - 0 | |||||||||||||||||||||
| 87 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 88 | Total Other Project Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $ - 0 | |||||||||||||||||||||||
| 89 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 90 | Total PROJECT COSTS | $0 | $0 | $0 | -$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $ (0.00) | ||||||||||||||||||||||
| 91 | Cost Share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||||||||||||||||||||||||||||||||||||||||
| 92 | Upon invoicing, additional detail in support of the match expenditures should be provided on the Supporting Schedule, in the sixth tab of this workbook. |
&"Arial,Bold"&11Massachusetts Technology Collaborative
Standard Budget and Invoice Template Match Costs
Invoice Supporting Schedule Supporting Schedule -- Standard Invoicing Form
| Invoice Period (Y#Q#) & Line # | Please provide below, a detailed explanation for any categorical variance within 10%, labor rate variance within 5%, and consultant/subcontractor cost variance within 20% from approved budget amounts. The following require prior written approval from your Project Manager before submitting the invoice, variance above the thresholds mentioned here, new line items to the approved budget, and any changes to indirect cost allocation methodologies. Any such approvals should also be listed with any helpful explanation that might be helpful in reviewing the supporting documentation. |
| Example: Y1Q1 Line 15 | Example: XYZ equipment was 12% over budget. The variance was due to finding out that the vendor with the most competitive quote amount, could not deliver within the schedule. So the equipment ended up costing more then projected in the approved budget, but within the allowable variance per the budget guidelines. |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .