Detailed Proposal Budget Template

Instructions for completing the following Worksheets: Please format each spreadsheet to include Lead Applicant's name and SDTC file number. Worksheet #2 is the “Funding Source Summary”: SDTC requires the Applicant to differentiate between total proposed Project Costs and total proposed Eligible Project Costs. This form also identifies the requested amounts from SDTC as well as other Government sources to confirm compliance with Federal Stacking regulations. Worksheet #3 is the "Detailed Eligible Project Funding Contribution": This is a further breakdown of Worksheet #2 identifying each consortium member’s contribution into the project. SDTC requires the Applicant to identify the type of contribution that is being made, specifically if it is a cash or in-kind contribution. SDTC also requires that the applicant identify if the contributions into the project have been confirmed or not and then clarify the Source Type of the contribution from the provided legend. Worksheet #4 is the “Detailed Budget Summary” The final worksheet provides a high level Project Cost break down by Milestone & Sources of Expenditures. All project costs should be organized by Milestone and categorized into SDTC’s 5 costing categories: Labour, Travel, Equipment, Sub-Contractors & Consultants and Other. Each line item must then be broken down to have the level of contribution by SDTC and the consortia identified. The additional worksheets in the file are provided as a tool to assist you in forecasting your project expenditures using SDTC’s costing categories. While the population and submission of the summary sheet and milestone costing breakdown sheets is not mandatory at this stage, they will need to be completed in full as part of the contracting process should your proposal be selected for funding. Worksheets # 5 – 10: Support document for Worksheet #4 The SDTC Milestone Budget Template consisting of 6 Excel worksheets will be used to provide detailed budget information for each SDTC Project Milestone. This will be required prior to executing a Contribution Agreement with SDTC. All project costs will be organized by Milestone and categorized into SDTC’s 5 costing categories: Labour, Travel, Equipment, Sub-Contractors & Consultants and Other. An SDTC Milestone represents a terminal element that marks the completion of a project work package or phase, typically marked by a high level event such as completion, endorsement or signing of a deliverable. As a minimum, SDTC requires that each project have at least one milestone per calendar year during the funding period of the project, however it is recommended that where appropriate, a shorter interval between Milestones be used (6 to 9 months). For the SDTC Milestone Budget, all costs related to all project activities during the time frame of the given Milestone will need to be captured in that Milestone’s budget. It is intended that these 6 worksheets will be used to show the budget for a single SDTC Milestone. They will then need to be reused for each additional milestone. 1 of 10 Funding Source Summary Funding Source A B C D E F Total Estimated Project Costs Non Eligible Project Costs Total Estimated Eligible Project Costs (A-B) SDTC Funds (Limited to 33% of eligible project costs) Consortium Members Funds Other Governments Funds NOTE: C=A-B D+E+F MUST =C Amount Percentage of Eligible Project Costs 2 of 10 Detailed Eligible Project Funding Contribution Funding Commitments SDTC Eligible Project Cost Time Period to Obtain Funding *Source Type Confirmed Totals ($k) Confirmed Cash ($k) Unconfirmed Cash ($k) *Source Type Confirmed In-kind**($k) Unconfirmed Inkind** ($k) Consortium Members: Lead Partner #2 Partner #3 Partner #4 Other: SDTC SDTC % of Total Project Costs SDTC % of Eligible Project Costs TOTAL ELIGIBLE PROJECT FUNDING TOTAL PROJECT FUNDING * Source Type: Working Capital Cash, Working Capital In-Kind, Expense In-Kind, Outside Investment Debt, Outside Investment Equity, Outside Investmet Other, Government Contribution Federal, Government Contribution - Provincia, Government Contribution - Municipal ** Refer to Annex A section 7.10 for a description of in-kind contribution. 3 of 10 Project Financial Certification Report (PFCR) Contract Number: Company Name: Date of Report: NOTE: A detailed report of all project expendatures must be included with this report (a copy of the project expendature ledger will suffice) and copies of Invoices over $1000.00 must be made available for review and submitted with the Final Project Report. NOTE: SDTC's contribution can never exceed the percentage contribution approved by the Board at any given time. The information provided on this report is hereby certified to be true and accurate: _________________________________________________ Name Title Original Budget Date Milestone Activity/Discription of Expenses Eligible Cash Milestone 1 Labour Travel Equipment Sub-contractors & Consultants Other Costs Totals for Milestone 1: Labour Travel Equipment Sub-contractors & Consultants Other Costs Totals for Milestone 2: Labour Travel Equipment Sub-contractors & Consultants Other Costs Totals for Milestone 3: Labour Travel Equipment Sub-contractors & Consultants Other Costs Totals for Milestone 4: Totals for all Milestones: Totals Elegible Project Costs: Total Project Costs: Eligible In-kind Non-eligible SDTC Contribution Source of expenditures Percentage Contribution Other Contribution Cash or In-kind Contributor $ - $ - $ - Milestone 2 $ - $ - $ - Milestone 3 $ - $ - $ - Milestone 4 $ $ $ $ - $ $ - $ $ - 4 of 10 SDTC Budget Summary (Do not enter any information in shaded cells) SDTC Contract # Milestone # Milestone Start Date (dd/mm/yy): Milestone End Date (dd/mm/yy): Total Budget Amount for Milestone: Labour Travel Equipment Sub-contractors & Consultants Other Costs Total Project Amounts Eligible Amounts - In-Eligible Amounts - Notes: The amounts from each milestone will be carried into the Contribution Agreement and associated with the Payment Schedule and the PFCR. This Template is provided to facilitate the following: 1) initial development of a detailed Budget in determining what is an eligible expense. It is expected that some of the specifics of the details will not be available at budget development time in which case the best information possible can be utilized or provided at a higher level. (i.e. the exact details for travel, who, where and when, may not be available at the time of contracting in which case the best information estimate of the travel budget required for each milestone is acceptable). 2) Detailed reporting of milestone claim during project execution for incorporation into the PFCR this level of reporting will be required for payment of each claim and project status reporting against budget. Please refer to Eligible and Non-Eligible Expenses at the SDTC Website http://www.sdtc.ca/en/funding/advice/eligible_costs.htm 5 of 10 SDTC Labour Spreadsheet SDTC Contract # Milestone # Milestone Start Date: Milestone End Date: Eligible Labour for this Milestone: $ NOTE: 0 0 0-Jan-00 0-Jan-00 - Fill in the blank white fields. Do not fill in the grey shaded areas, these amounts are calculated automatically. Total eligible direct labour and total benefits paid during the reporting period for the quarter must be based on actuals from your payroll department. Benefits claimed cannot exceed 20% of labour claimed. TOTALS: - - - - Consortium Member Employee Name Title / Function Description of Contribution Cash or In-kind Is this an Eligible (E) or In-Eligible (I) Project Expense Hourly Rate Total SDTC Project Hours for this Milestone Total Direct Labour (hourly rate X # of hours) Fringe Benefits on Total Direct Labour (SDTC Maximum 20%) Total Eligible Labour Amount (Direct Labour + Benefits) Total In-Eligible Labour Amount (Direct Labour + Benefits) 6 of 10 SDTC Travel Spreadsheet SDTC Contract # Milestone # Milestone Start Date: Milestone End Date: Total Eligible Travel Amount for this Milestone: $ 0 0 0-Jan-00 0-Jan-00 NOTE: TOTALS: Description of Contribution Cash or In-kind Is this an Eligible (E) or In-Eligible (I) Project Expense Eligible Travel Amount In-Eligible Travel Amount Consortium Member Employee Name Purpose and Description of Trip Trip Start Date Trip End Date Description of Trip Expense 7 of 10 SDTC Equipment Spreadsheet SDTC Contract # Milestone # Milestone Start Date: Milestone End Date: Total Eligible Equipment amount for this Milestone: $ 0 0 0-Jan-00 0-Jan-00 - NOTE: *CA-Capital Asset : Equipment that will be capitalized and not expensed; will have a residual value. Only Depreciation Expense can be claimed to SDTC. *DM-Direct Material : Consumable equipment, typically would be expensed. TOTALS: - - - Consortium Member Item Description Item Category CA-Capital Asset* DM-Direct Material* Description of Contribution Cash or In-kind Is this an Eligible (E) or In-Eligible (I) Project Expense Total Item Cost Depreciation Rate if Item is a Depreciated Capital Asset Expense For This (% per year) Milestone Eligible Equipment Amount In-Eligible Equipment Amount 8 of 10 SDTC Sub-Contracting and Consulting Spreadsheet SDTC Contract # Milestone # Milestone Start Date: Milestone End Date: Budgeted Sub-Contracting and Consulting amount for this Milestone: $ 0 0 0-Jan-00 0-Jan-00 NOTE: Consortium Member Expense Type C- consulting SC - Sub-Contractor Name of Sub-Contracting or Consulting Organization Hourly Rate (if applicable) Description of Work TOTALS: Is this an Eligible (E) or InDescription of Eligible (I) Contribution Cash or In-kind Project Expense - - Eligible Amount In-Eligible Amount ` 9 of 10 SDTC Other Costs Spreadsheet SDTC Contract # Milestone # Milestone Start Date: Milestone End Date: Total Eligible Other Costs for this Milestone: $ 0 0 0-Jan-00 0-Jan-00 NOTE: TOTALS: Description of Contribution Cash or In-kind Is this an Eligible (E) or In-Eligible (I) Project Expense - In-Eligible Other Cost Amount Consortium Member Type of Expense Description of Item Eligible Other Cost Amount 10 of 10