{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cost Eligibility","1. Budget and Workplan","2. Sources of Funding","Phases","Other examples"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cost Eligibility","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Workplan and Budget - MAMP Funding Offer"]
[null,"Eligible and Ineligible Costs "]
["This table outlines which costs are eligible - and, more specifically, which costs are not eligible - for fund matching by the Municipal Asset Management Program. \n"]
["Please also note that definitions and eligibility of costs may vary from other FCM programs."]
["Note: If your application is approved, expenses that are eligible must be:"]
["·    cash costs incurred by the lead applicant - in-kind contributions are not eligible"]
["·    an integral and an essential component of the initiative, required to help achieve the project objectives"]
["·    actually and reasonably incurred in accordance with applicable industry standards"]
["·    supported by auditable documentation to enable verification of the actual cost incurred, eligibility of the activity conducted and level of effort required "]
["FCM reserves the right to audit financial statements or expenses incurred at a future date, as audits of the submitted costs will not be conducted in the normal course of business when a disbursement claim is submitted. "]
["Please keep financial accounts and records, including but not limited to contracts, invoices, statements, receipts, timesheets and vouchers, for at least six years."]
["Cost category","Eligible costs","Ineligible costs"]
["1) Pre-application","N/A","• Any expenditure incurred prior to FCM’s eligible expenditure date. \n• Expenditure of developing this proposal or application."]
["2) Administrative and Overhead Expenditures","Administrative expenditures that are directly linked to and have been incurred for the project, such as:\n                                                \n• Communication expenditures (e.g. long-distance calls or faxes).\n• Outsourced printing or photocopying.\n• Acquisition of documents used exclusively for the project.\n• Document translation.\n• Transportation, shipping and courier expenditures for delivery of materials essential for the project.\n• Design and production of communication products to promote project outcomes and benefits to the public.","General overhead expenditures incurred in the regular course of business, such as:\n\n• Office space, real estate fees and supplies.\n• Financing charges and interest payments.\n• Promotional items.\n• Permits or certifications.\n• Advertising, website development, project education materials or expenditures to disseminate project communications products.\n• Hospitality expenses (food and drink, alcohol, entertainment, etc.).\n",null,"               "]
[null,"·         telecommunications charges","·         office space, real estate fees, supplies"]
[null,"·         printing or photocopying ","·         financing charges and interest payments"]
[null,"·         acquisition of documents used exclusively for the project","·         promotional items"]
[null,"·         document translation ","·         permits or certifications"]
[null,"·         shipping, transportation and courier charges","·         advertising, website development, general education materials or costs to disseminate communications products"]
[null,"design and production of communication products to promote project outcomes and benefits to the public","·         hospitality expenses (food and drink, alcohol, entertainment, music, etc.)"]
["3) Capital Expenditures","Asset management-related software. \n\nNote: FCM’s contribution to this expense may not exceed 50% of FCM’s total contribution to the project. ","Any other capital expenditures or amortization expenses."]
["4) Equipment Rental","• Rental of tools and equipment.\n• Related operating expenditures such as fuel and maintenance expenditures.","Rental of tools or equipment related to regular business activities."]
["5) In-Kind","N/A","Any goods and services received through donation."]
["6) Training","• Expenditures associated with accessing reference materials such as standards, templates and toolkits.\n• Expenditures associated with attending training sessions, (provided externally) or bringing training in-house.","Any hospitality expenses such as:\n\n• Food and drink\n• Alcohol\n• Door prizes\n• Entertainment\n• Music\n• Decorations\n• Flowers, centerpieces\n• Etc."]
["7) Professional and/or technical Services","Fees for professional or technical consultants and contractors, incurred in support of eligible activities.","• Expenditures associated with regular business activities not related to the project. \n• Legal fees."]
["8) Staff remuneration","Daily rates actually paid by the Eligible Recipient to its Employees in Canada for time actually worked on the implementation of the Project. \n\nThe daily rate per employee shall include the following costs:\n\n    a) direct salaries: actual and justifiable sums paid by the Eligible Recipient to Employees in accordance with the Eligible Recipient’s pay scales as regular salary excluding overtime pay and bonuses.\n    b) fringe benefit: in accordance with the Eligible Recipient’s policies, as follows:\n            i. time-off benefits (prorated to the annual percentage (%) of time actually worked on the implementation of the Project): allowable number of days to be paid by the Eligible Recipient for the following payable absences: statutory holidays, annual vacation, and paid benefits: actual sums paid by the Eligible Recipient for paid benefits (prorated to the annual percentage (%) of time actually worked on the implementation of the Project): the Eligible Recipient’s contribution to employment insurance and workers’ compensation plans (where applicable), health and medical insurance, group life insurance, or other mandatory government benefits;\n\nNote: Labour costs must be documented in a manner that meets audit standards for verification of eligibility of cost and level of effort.\n","• In-kind contribution of services.\n• Participant salaries.\n• Expenditures related to regular business activities.\n• Overtime Pay\n•  Bonuses / performance pay.\n• Fringe benefits such as;\no sick days\no pension plan\no any other fringe benefits not listed as eligible\n• Costs related to ongoing or other business activities and not specifically required for the project. \n• Staff wages while receiving training or attending learning events.\n• Professional membership fees or dues.\n"]
["9) Supplies and Materials","Supplies and materials required to undertake the project. ","Expenditures related to regular business activities"]
["10) Taxes","The portion of Provincial/Harmonized Sales Tax and Goods and Services Tax for which your organization is not eligible for rebate.","The portion of Provincial/Harmonized Sales Tax and Goods and Services Tax for which your organization is eligible for rebate, and any other expenditures eligible for rebates.\n"]
["11) Travel and Accommodation","For individuals on travel status (individuals travelling more than 16 km from their assigned workplace - using the most direct, safe and practical road.);\n\n• Travel and associated expenses for implementing partners, guest speakers and consultants to the extent that the travel and accommodation rates comply with the Treasury Board of Canada guidelines, and to the extent that such travel is necessary to conduct the initiative. www.canada.ca/en/treasury-board-secretariat/services/travel-relocation/travel-government-business.html \n\n• Where justified, participant travel costs may be claimed with prior written consent from FCM. Under no circumstances will participant honorariums be covered. ","Any travel expense that is not paid in accordance with the National Joint Council Travel Directive."]

{"sheet":"1. Budget and Workplan","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,"Workplan and Budget - MAMP Funding Offer",null,null,null,null,"Instructions"]
["Lead applicant:",null,null,null,null,null,null,"This is the legal name of your organization."]
["Project title:",null,null,null,null,null,null,"This is the title describing your project in 10 words or less."]
["Activity",null,"Start date","End date","Eligible cost \n($)","Ineligible cost ($)","Total cost \n($)"]
["Activity 1:  (please insert name of activity)",null,"dd/mm/yyyy","dd/mm/yyyy",null,null,null,"Notes: Activities should match those in Section C of the Application Form. Project timeline may not exceed 11 months."]
["[Add task description here]",null,null,null,0,0,{"$f":"E6+F6","v":0},"Describe the steps that will be taken to complete the activity. \n"]
["[Add task description here]",null,null,null,0,0,0,"Provide details broken down by major tasks needed to achieve the deliverables noted in the Application Form."]
["[Add task description here]",null,null,null,0,0,0,"Identify who will be doing the work."]
["[Add task description here]",null,null,null,0,0,0]
["[Add task description here]",null,null,null,0,0,0]
["Activity 1 Subtotals",null,null,null,{"$f":"SUM(E6:E10)","v":0},{"$f":"SUM(F6:F10)","v":0},{"$f":"SUM(G6:G10)","v":0}]
["Activity 2: (please insert name of activity)",null,"dd/mm/yyyy","dd/mm/yyyy",null,null,null,"If you have only one activity, leave the remaining cells blank. "]
["[Add task description here]",null,null,null,0,0,{"$f":"E13+F13","v":0}]
["[Add task description here]",null,null,null,0,0,0]
["[Add task description here]",null,null,null,0,0,0]
["[Add task description here]",null,null,null,0,0,0]
["[Add task description here]",null,null,null,0,0,0]
["Activity 2 Subtotals",null,null,null,{"$f":"SUM(E13:E17)","v":0},{"$f":"SUM(F13:F17)","v":0},{"$f":"SUM(G13:G17)","v":0}]
["Activity 3: (please insert name of activity)",null,"dd/mm/yyyy","dd/mm/yyyy"]
["[Add task description here]",null,null,null,0,0,{"$f":"E20+F20","v":0}]
["[Add task description here]",null,null,null,0,0,{"$f":"E21+F21","v":0}]
["[Add task description here]",null,null,null,0,0,0]
["[Add task description here]",null,null,null,0,0,0]
["[Add task description here]",null,null,null,0,0,0]
["Activity 3 Subtotals",null,null,null,{"$f":"SUM(E20:E24)","v":0},{"$f":"SUM(F20:F24)","v":0},{"$f":"SUM(G20:G24)","v":0}]
["Total costs",null,null,null,{"$f":"SUM(E6:E10,E13:E17,E20:E24)","v":0},{"$f":"SUM(F6:F10,F13:F17,F20:F24)","v":0},{"$f":"SUM(G6:G10,G13:G17,G20:G24)","v":0}]
[]
[null,null,null,"Total eligible costs",null,null,{"$f":"E26","v":0}]
[]
["NB: Click on the Calculate Budget button to round off all figures to the nearest $100."]
[]
[]
["Contingency costs: Have you included room for contingencies in some or all of your task costs? Please explain.",null,null,null,null,null,null,"Contingency is not mandatory. "]
["[Add explanation about contingency here.]"]
[]
["Other Notes:"]
["[Add any other relevant details about your workplan and budget here.]"]

{"sheet":"2. Sources of Funding","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Sources of Funding"]
["Instructions\n"]
["Use the table below to demonstrate how you will cover all costs of your proposed project. "]
["The total of all funding sources, including your municipal contribution, must equal the total costs (eligible + ineligible) in Tab 1: Budget and Workplan."]
[]
["Sources of funding include your FCM grant, plus budget allocations from your organization (with date of budget approval), cash contributions stated in your council resolution, or funds from other government or non-government sources."]
[]
["FCM grants may cover up to 80% of eligible costs, to a maximum of $50,000, to undertake eligible activities. "]
["The spreadsheet will auto-calculate the maximum grant amount for which you are eligible, based on the total eligible costs in the budget."]
["Funding source","Description","Confirmed (Y/N)","Date committed\nDD-MM-YYYY","Amount \n($)","Percentage of total budget"]
["FCM grant","Grant","N",null,{"$f":"MIN('1. Budget and Workplan'!G28*0.8,50000)","v":0},{"$f":"E11/$E$20","v":{"$error":"#DIV/0!"}}]
["Source of funding",null,null,null,0,{"$error":"#DIV/0!"}]
["Source of funding",null,null,null,0,{"$error":"#DIV/0!"}]
["Source of funding",null,null,null,0,{"$error":"#DIV/0!"}]
["Source of funding",null,null,null,0,{"$error":"#DIV/0!"}]
["Source of funding",null,null,null,0,{"$error":"#DIV/0!"}]
["Total funding:",null,null,null,{"$f":"SUM(E11:E16)","v":0}]
["[Should equal budget total costs, Line 20 below]"]
[]
[null,null,"Budget total costs",null,{"$f":"'1. Budget and Workplan'!G26","v":0}]
[null,null,"Budget total eligible costs",null,{"$f":"'1. Budget and Workplan'!G28","v":0}]

{"sheet":"Phases","index":3,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Phases for Feasibility Studies"]
[]
["Phase A: Develop evaluation framework"]
["The first phase is to identify the evaluation criteria and methods, as well as the performance measures to be evaluated. The evaluation criteria may be based on lifecycle, triple-bottom-line, cost-benefit, or another type of analysis. If a task has already been completed, please specify this."]
["Phase B: Conduct study"]
["This phase entails assessing and analyzing the technical and financial feasibility and environmental impacts of implementing the municipal environmental project. A municipal environmental project is a project that responds to a municipal need and contributes to cleaner air, water, and/or soil, and/or reduces greenhouse gas emissions. Social and economic impacts of the project should also be considered. Depending on the study, you may be evaluating just one option, or a range of options."]
["Phase C: Evaluate and make recommendations"]
["In this phase, tasks should include evaluating the results, selecting the option(s) that meet(s) the established evaluation criteria, formulating recommendations and identifying next steps. In some cases, it may be appropriate to develop a conceptual design, or an implementation strategy, based on the results obtained and the recommendations made as a result."]
["Phase D: Reporting"]
["The last phase includes preparing a final version of the feasibility study, and obtaining council approval for it."]

{"sheet":"Other examples","index":4,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":true,"merged":[[5,0,5,3],[0,0,0,6],[1,1,1,6],[2,1,2,6],[3,0,3,1],[4,0,4,1],[17,0,17,5],[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[29,0,29,5],[18,0,18,1],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[41,0,41,5],[30,0,30,1],[31,0,31,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,3],[39,0,39,3],[40,0,40,3],[53,0,53,5],[42,0,42,1],[43,0,43,3],[44,0,44,3],[45,0,45,3],[46,0,46,3],[47,0,47,3],[48,0,48,3],[49,0,49,3],[50,0,50,3],[51,0,51,3],[52,0,52,3],[65,0,65,5],[54,0,54,1],[55,0,55,3],[56,0,56,3],[57,0,57,3],[58,0,58,3],[59,0,59,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[77,0,77,5],[66,0,66,1],[67,0,67,3],[68,0,68,3],[69,0,69,3],[70,0,70,3],[71,0,71,3],[72,0,72,3],[73,0,73,3],[74,0,74,3],[75,0,75,3],[76,0,76,3],[88,0,88,6],[89,0,89,6],[91,0,91,6],[92,0,92,6],[78,0,78,3],[79,0,79,3],[80,0,80,3],[81,0,81,3],[83,4,83,5],[85,1,86,4]]}
["WORK PLAN AND BUDGET - Feasibility Studies"]
["Lead Applicant:"]
["Project title:"]
["Phases",null,"Start date:","End date:","Eligible Cost ($)","Ineligible Cost ($)","Total Cost ($)"]
["Milestone 1 : Start-up",null,"mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,null,{"$f":"E6+F6","v":0}]
["[Add task description here]",null,null,null,null,null,{"$f":"E7+F7","v":0}]
["Develop evaluation framework",null,null,null,null,null,51401]
["Initial consultation",null,null,null,null,null,51151]
["Hiring of consultants",null,null,null,null,null,5454]
["dddggdfbd",null,null,null,null,null,{"$f":"E11+F11","v":0}]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["Phase 1 Subtotal",null,null,null,null,null,{"$f":"SUM(G6:OFFSET(G18,-1,0))","v":108006}," Ist disbursement"]
["Milestones 2 : GHG reduction plan",null,"mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,null,{"$f":"E20+F20","v":0}]
["[Add task description here]",null,null,null,null,null,56464,null,null,null,"Necessary info"]
["[Add task description here]",null,null,null,null,null,{"$f":"E22+F22","v":0},null,null,null,"Milestones/deliverable"]
["[Add task description here]",null,null,null,null,null,0,null,null,null,"High level of activities for milestone"]
["[Add task description here]",null,null,null,null,null,0,null,null,null,"expected completion date"]
["[Add task description here]",null,null,null,null,null,4545,null,null,null,"cost for the milestone"]
["[Add task description here]",null,null,null,null,null,0,null,null,null,"What is the maximum number of disbursement?"]
["[Add task description here]",null,null,null,null,null,7845]
["[Add task description here]",null,null,null,null,null,0,null,null,null,"We need to define what a milestone is. (e.g. does it have to be a report/plan etc. or can it be an output e.g. a public consultation"]
["[Add task description here]",null,null,null,null,null,0]
["Phase 2 Subtotal",null,null,null,null,null,{"$f":"SUM(G20:OFFSET(G30,-1,0))","v":68854},"2nd Disbursement "]
["Phase 3: Evaluate and make recommendations",null,"mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,null,{"$f":"E32+F32","v":0}]
["[Add task description here]",null,null,null,null,null,{"$f":"E33+F33","v":0}]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,4546]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["Phase 3 Subtotal",null,null,null,null,null,{"$f":"SUM(G32:OFFSET(G42,-1,0))","v":4546},"Final disbursement"]
["Phase 4: Reporting",null,"mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,null,{"$f":"E44+F44","v":0}]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["Phase 4 Subtotal",null,null,null,null,null,{"$f":"SUM(G44:OFFSET(G54,-1,0))","v":0}]
["Phase 5: Additional phase",null,"mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,null,{"$f":"E56+F56","v":0}]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["Phase 5 Subtotal",null,null,null,null,null,{"$f":"SUM(G56:OFFSET(G66,-1,0))","v":0}]
["Phase 6: Additional phase",null,"mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,null,{"$f":"E68+F68","v":0}]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["[Add task description here]",null,null,null,null,null,0]
["Phase 6 Subtotal",null,null,null,null,null,{"$f":"SUM(G68:OFFSET(G78,-1,0))","v":0}]
["Subtotal - Cash costs:",null,null,null,{"$f":"SUM(E6:OFFSET(E79,-1,0))","v":0},{"$f":"SUM(F6:OFFSET(F79,-1,0))","v":0},{"$f":"E79+F79","v":0}]
["In-kind costs (Lead applicant - staff time)  - Change ONLY if less than 10% of Eligible Cash Costs",null,null,null,{"$f":"ROUNDDOWN((0.1*E79), -2)","v":0},0,{"$f":"E80+F80","v":0}]
["In-kind costs (Other)",null,null,null,"n/a",0,{"$f":"F81","v":0}]
["Total Costs",null,null,null,{"$f":"E79+E80","v":0},{"$f":"F79+F80+F81","v":0},{"$f":"SUM(E82,F82)","v":0}]
[]
[null,null,null,null,"Total Eligible Costs",null,{"$f":"E82","v":0}]
[]
[null,"NB: Click on the Calculate Budget button to round off all figures to the nearest $100."]
[]
[]
["Contingency costs: Have you included room for contingencies in some or all of your task costs? Please explain."]
["[Add explanation about contingency here]"]
[]
["Other Notes:"]
["[Add any other relevant details about your workplan and budget here]"]