Transcription

Appendix B: Budget and Annual Report TemplateProposal Application InstructionsInstructionsOVERALL INSTRUCTIONS - ALL TABS Please enter all figures in U.S. dollars ( USD).This budget should reflect only funds requested from the foundation.Some cells have "pull down" restricted choices, indicated by down arrow to right of cell (when selected). Click on the down arrow to select from the available options.CAUTION : This template can be used to create either a budget with a 1 to 5 year timeline or a 6 to 10 year timeline according to the "Budget Timeline" setting on the "General Information" tab. Please note thatif values are added for years 6 through 10 when in the "6 to 10 years" budget timeline mode and then the "1 to 5 years" budget timeline mode is selected, the hidden values for years 6 through 10will still count towards the budget totals . If your project is approved for funding, the "Annual Report" tabs will be used for providing progress information to the founation. These tabs are not to be used for the proposal process. (See Blue Progress Report tabs for format) You will be asked to report against each cost category by objective (i.e. Direct FTE Costs, Direct Travel, Direct Supplies & Other, Direct Consultants, and Sub-Awards)SUMMARY TABS (green tabs 1 and 2) NO DATA ENTRY is required on these tabs The Financial Summary and Objective Summary tabs will automatically calculate based on inputs from the following Data Input Tabs.Please do not modify the summary tabs.DATA INPUT TABS (yellow tabs 3 - 8)All Yellow Cells Are Data Input Cells. Do not enter data in a cell that is not yellow.If you are copy/pasting into yellow input cells make sure you paste VALUES only (Alt h,v,v).If you need to clear the contents of a cell do not cut the contents, please simply delete the content.If you need additional rows, there are additional rows you may unhide and use. You cannot insert or delete rows, but youmay hide/unhide them.General information (tab #3): Proposal Submission Date - Please enter the date this proposal budget is to be submitted to the Bill & Melinda Gates Foundation. Organization - Please enter the legal name of your organization. Project Title - Please enter the title of the project (this should match the title on the proposal form). Projected Start Date - Enter the date you anticipate starting the project. Budget Timeline - Select either the "1 to 5 years" template or the "6 to 10 years" template based on the timeline of the budget being proposed. Please note that selection via this dropdown launchesa macro that hides/unhides the columns for value entry for years 6 through 10 in all workbooks of the template. If macros do not work on your system you can do this operation manually by(for hiding columns) selecting the Years 6 - 10 columns on any worksheet, right clicking your mouse and choosing the "Hide" pop-up menu option, or (for unhiding columns) selecting the Year 5 columnas well as the column immediately to its right on any worksheet, right clicking your mouse and choosing the "Unhide" pop-up menu option. Organization Headquarters - Enter the location (city and country) of your organization's headquarters Exchange Rate Conversion Assumption USD/Local - If applicable, please enter USD/Local foreign exchange rate assumptions used to translate the budget in local currency to US dollars.These assumptions are for documentation purposes, and do not drive any budget calculations. Does your organization have indirect costs? - If "yes", the Foundation will reimburse indirect costs in accordance with Foundation policy.CLICK HERE for the Bill & Melinda Gates Foundation Indirect Cost Policy Indirect Costs Institution Type - Please enter your institution type from the following choices (using pull down menu): US University, Government, Other (includes NGOs and Non-US Universities); or For-Profit Actual indirect cost rate (enter as percentage) - Enter your actual indirect cost rate as a %. You may enter 0% if you have no indirect costs. Maximum Indirect Cost Rate Allowed Per Foundation Policy - Calculated Field - Not Data Entry. This calculates the maximum allowable indirect cost rate per the Foundation Policy. Non-US Grantees Only - Will there be funds expended in the US? - Enter yes, no, or not applicable (N/A) . Please especially consider if there will be any travel funds expended in US.This includes funds spent for travel to/from the US, payments for consultant services in the US, etc. The foundation is required to report on such spending. Optional - Your organization may choose to have a lower indirect cost rate applied to its subaward expenditures than the actual / allowable indirect cost rate provided by the foundation. This alternate ratecan be entered by overwriting the default rate in cell E31 on the General Information tab.Direct Full Time Equivalent (FTE) Costs tab (tab #4): Primary/Sub - Please indicate whether an FTE is from the primary grantee organization or a sub-awardee organization. Please list primary grantee personnel first, and then list subs.Please do not enter any dollar amounts in the grayed out cells. Primary grantee’s FTE costs are rolled up into the Total Personnel line item of the budget spreadsheet. Total costs forsub-awardee personnel will be included in various line items for each sub-contract or sub-grant in the “Sub-awards" tab. Objective - Please choose from the dropdown box to indicate to which objective this person will be allocated. The number of objectives in the budget should match what you havewritten in the proposal. Please note project management should not be confused with indirect costs (e.g. CEO, Executive Director, etc. should be part of indirect costs).File: Sample Appendix B Budget Spreadsheet.xlsmTab: InstructionsPage 1 of 19Printed: 2/21/2012 1:25 PM

Appendix B: Budget and Annual Report TemplateProposal Application Instructions Name - Please include the name of each individual working on this project. For individuals yet to be hired, please enter "TBD 1", "TBD 2", and so on so that there is a unique numberfollowing each TBD employee. If you expect an employee to work on more than one objective, please list their name and relevant information on a separate line for each objective. Pleaseensure that the total allocation for this employee does not exceed 1.0 FTE. Title - Please enter a title that describes the individual's function/role on the project. Rationale - Please include a brief rationale for funding this position on the project. Starting Salary - Please enter the starting salary in starting year dollars (e.g. if this employee will work for the first time in year one, the calculations will inflate the salary appropriately for the salary afteryear one; whereas if year 3 is the first time this employee will work, the calculations will inflate the salary appropriately for years 4 and onwards). For example, if the starting date is year two, enter theestimated dollars for the starting year two, and so on. This number should not include allocations for Facilities, IT, or other indirect costs. Fringe % - Please enter the fringe rate as a percentage of an employee's salary. This can be an individual percentage or an average percentage applied to all employees.The fringe rate would typically include non-wage compensation such as retirement, health insurance, as well as payroll taxes. Annual Salary Inflation - Please enter the assumption for inflation applied to salaries. Inflation factors can be entered by individual; however, if a different rate is applied todifferent individuals you must provide the rationale for this in the budget narrative.Once these data are entered, the spreadsheet will calculate the costs by employee including salary, fringe, and salary inflation factors. Please do not modify these calculations.Direct Travel Costs (tab #5): Objective - Please choose from the dropdown box to indicate to which objective this travel will be allocated. Typically, the travel should go to project management; however,if the travel cost is directly attributable to one objective please indicate by choosing the appropriate objective in the dropdown box.Please note project management should not be confused with indirect costs (e.g. should not include general organization travel not associated with this particular project). To/From - Please indicate where the travel will originate and to what destination the travel is planned (example, "Boston/Seattle") Airfare - Please enter the assumed airfare for each trip in starting year dollars (e.g. if this particular to/from trip were taken for the first time in year one, the calculations will inflate the airfare appropriately fortrips taken after year one; whereas if year 3 is the first time this particular to/from trip is taken, the calculations will inflate the airfare appropriately for trips in years 4 and onwards) Per Day Expenses - Please enter the estimated per day costs for hotel, meals, ground transport, and other travel costs. Please address the composition of the per day costs inthe budget narrative. Annual Per Person Expenses - Please enter the estimated expenses which are dependent on the number of people, but not the number of trips (for example innoculations, which may be required annually,even if several trips are taken over the course of the year). If these expenses are incurred multiple times (for example the need for innoculation against several diseases) then put the total cost per person(e.g., if need 2 innoculations per person at a cost of 10 each, enter 20). Duration (Days) - Please enter the number of days for each trip. Annual Airfare Inflation % - If budgeting for multiple instances of the same trip in different years on one row, you may enter an annual inflation factor for airfare. Enter as a percentage. Annual Per Day/Person Expected Inflation % - If budgeting for multiple instances of the same trip in different years on one row, you may enter an annual inflation factor for per day expenses (as a percentage). Number of Participants - Enter the number of participants for a given trip per year. Number of Trips - Enter the number of trips per person per yearOnce these data are entered, the spreadsheet will calculate the travel costs per year. Please do not modify these calculations.Direct Consulting (tab #6):Direct Consultants - A consultant is hired to provide advice and/or provide assistance with procedures, strategy, legal services that are directly attributable to theproject, etc. If you have a specific expense in question please contact your Program Coordinator for additional direction. Objective - Please choose from the dropdown box to indicate to which objective this consultant will be allocated. Typically, the consulting costs should go toproject management; however, if it is allocable to a specific objective please indicate which objective it supports. Please note project management should not be confusedwith indirect costs (e.g. organization-wide, non-specific legal fees, audit fees, etc). Consultant - If known, enter the name of the consultant or the consulting firm providing the service, otherwise please specify "TBD". Description - Please enter a description of the work effort. Daily Rate - Please enter a daily rate for the consultant. For rates other than daily rates please convert rates to daily rates. Days - Please enter the number of days the consultant will be employed on this project by year. Expense Estimates - Please enter the estimated expenses (travel, supplies, etc.) the consultant will incur on this project by year. These are expenses for which your organization will be billed by the consultant.If your organization will pay for any consultant expenses directly, these must be listed on the appropriate tab (Travel, Supplies, etc.)Once these data are entered, the spreadsheet will calculate the consultant costs per year. Please do not modify these calculations.Direct Supplies and Other (tab #7): Note there are two sections:1) Direct Supplies, Equipment, Services & Other 10,000/Year/Line Item - These are multiple items with an aggregated cost greater than or equal to 10,000 peryear per supply type. Objective - Please choose from the dropdown box to indicate to which objective these supplies or services will be allocated. Please note project management should not beconfused with indirect costs (e.g. general operating supplies should be included in indirect costs). Item(s) - Please enter the item required, and the unit of measure used in the cost per unit column (i.e., per day, per hour, per test, per FTE) Type - Please specify whether the item(s) should be categorized as equipment (individual item has a cost of 5,000 or more with a useful life of greater than one year) Description - Please enter a brief description of the item's use in the project.File: Sample Appendix B Budget Spreadsheet.xlsmTab: InstructionsPage 2 of 19Printed: 2/21/2012 1:25 PM

Appendix B: Budget and Annual Report TemplateProposal Application Instructions Cost Per Unit - Please enter the assumption for the cost per unit. (As noted above, please describe the unit of measurement in the "Item" column) Quantity - Please enter the estimated quantity required for use on the project by year.Once these data are entered, the spreadsheet will calculate the supplies and services costs per year. Please do not modify these calculations.2) Direct Supplies, Equipment, Services & Other 10,000/Year/Line Item - These are supplies with an annual cost less than 10,000 per year per line item. Objective - Please choose from the dropdown box to indicate to which objective these supplies or services will be allocated. Please note project management should not beconfused with indirect costs (e.g. general operating supplies should be included in indirect costs). Item(s) - Please enter the item (or type of item, if you'll be purchasing many units of the same item) required Type - Please spe