bmgf budget report nov2012

7/28/2019 BMGF Budget Report Nov2012

http://slidepdf.com/reader/full/bmgf-budget-report-nov2012 1/10

version 02.28.07

BUDGET TEMPLATE INSTRUCTIONS

. Getting Started

I. General Guidelines

INPUT

Orange TextExpand/Collapse +/-

These are INPUT cells. Most of your time will be spent entering data in these cells.

When you click on one of these cells, you'll see a message box with guiding instructions.Click on the "+" or "-" signs located on the left side or top of the screen to expand ("+" ) or collapse ("-

") rows or columns. You may need to expand some areas to have sufficient room to enter your

budgeted or actual expenses

Budget for Project Costs: Complete the Direct Personnel and Direct Cost budget templates for the expenses for which youare requesting funding from the Gates Foundation. The Proposal Summary template has a separate section for listing othercommitted funding and any unfunded costs.

Indirect Cost Policy: The indirect rate entered in the 'Basic Info' tab should not exceed 10% for higher education institutions,and 15% for NGOs (501(c)3 non-profits). The indirect rate entered for government agencies should be zero. Computer andequipment costs are excluded from the Indirect Cost calculation.

Budget Template Formatting: This Excel workbook includes formulas and is formatted to help you use the differentworksheets. Please note the following:

Prospective Grants: All grant proposals must include a proposed budget. If your request is for conference support, skip tothe applicable section below.

1) Read the sections 'General Guidelines' and 'Worksheet Instructions' below.2) Click the yellow 'Basic Info' tab and provide the requested information.3) Click the orange 'Personnel' tab and provide the requested information.4) If you are subgranting, please complete the 'Total Subgrants' worksheet in this workbook.5) Click the orange 'Direct Costs Detail' tab and provide the requested information.6) Review the orange 'Budget Proposal Summary' tab. It will be completed automatically based on information

entered on other worksheets. If applicable, manually enter information on Other Funders, Unfunded Costs,and Number of Subgrantee Schools and Students. Sign the non-lobbying certification, if applicable.7) Save the workbook and submit it to the Foundation with your Grant Proposal.

Prospective Grants for Conference Support:1) Use the separate Excel file 'Short Form Budget & Actuals' and provide the requested information.2) Save the workbook and submit it to the Foundation with your Grant Proposal.

Existing Grants: Your required progress report must include a report on actual expenses and any budget revisions foradditional grant years.

1) Review the budget you had submitted with your approved grant proposal.2) If you submitted your budget on the Short Form, use that form again to report actual.3) All other grantees, please use the dark orange 'Actuals Results' and 'Recast Budget tabs (as applicable).4) Review the variances in the 'Budget Variance' worksheet and the 'Recast Variance' worksheet. These should

be explained in the narrative of your progress report.

Direct Cost Categories: When entering detail on direct costs, please adhere to the following categories shown on the'Direct Costs Detail' tab:Personnel: compensation to officers, directors, trustees and employees for work on this projectBenefits: cost of ordinary employee benefits (stated as a % of salary)Consultin g & Professional Fees: amounts paid to non-employees retained to complete work for this projectMaterials & Supplies: cost of office supplies and services (photocopying, shipping, etc.) specifically related to this project(not general indirect costs)Computers & Equipment: cost of computers, peripherals, and other office equipment purchased and used for this project(not general indirect costs)Printing & Publications: cost of producing or purchasing printed materials (books, newsletters, etc) or electronic media(videos, DVD's etc.) used or produced as a part of this projectTravel & Accommodations: all travel related expenses incurred as a result of this projectConferences, Conventions, Meetings: registration fees for employees or consultants working on this project; facility costsfor meetings or conferences held in conjunction with this projectFacilities: Facility-related costs are typically covered by indirect costs and are not included within the direct cost detail.However, in rare cases, facility-related expenses can be included as a direct cost when a grantee requires additional buildingexpenses in order to execute the grant (for example a start-up organization or the creation of a new regional office). Note:Facilities costs for schools are not funded by the foundation.Other Costs: Other costs are direct program expenses which do not fit into one of the above cost categories. These costsshould be clearly labeled with a description of the expense so that foundation staff can understand the type of expense.



Basic Info 1

version 02.28.07

Alliance for Education (AFE)Support for Seattle Public Schools' Strategic Plan

Prepared by:

1) Enter Project Information

Organization NameProject Title

2) Enter Budget Periods: You may enter one or as many budget periods as needed for the project.Budget periods may span any # of months, including a year (12 months).

Start Date End Date #of months

Budget Period 1 11/01/2008 08/31/2009 10

Budget Period 2 09/01/2009 08/31/2010 12

Budget Period 3 09/01/2010 08/31/2011 12

Budget Period 4 09/01/2011 08/31/2012 12

Budget Period 5 09/01/2012 08/31/2013 12

4) Specify Other Budget FactorsInflation Factor Indirect Cost Rate* 15.0% See NOTE Line 49

No IDC authorized

10% IDC maximum

15% IDC maximum

No IDC authorized

No IDC authorized

1. excludes Private Foundations and Private Operating Foundations

2. excludes 501(c)(4); 501(c)(6); and 501(c)(7) organizations

NOTE: Indirect costs (IDC) should not exceed the percentages reflected in this table

Government agencies

Higher education agencies

501(c)(3) charitable organizations (see exceptions below)

Karen Demorest & Mark Taylor (AFE);

Carol Rava Treat (SPS)

Support for Seattle Public Schools' Strategic PlanAlliance for Education (AFE)

ENTER BASIC BUDGET INFORMATION



Direct Personnel 1

version 02.28.07

All iance for Educat ion (AFE)Support for Seattle Public Schools' Strategic Plan

DIRECT PERSONNEL DETAIL % of 1.0 FTE BY BUDGET PERIOD

Title

Starting

Salary

Benefit

Percent

Salary

Inflation

Budget

Period 1

Budget

Period 2

Budget

Period 3

Budget

Period 4

Budge

Period1 Community Engagement Manager (1 FTE) 65,000$ 20% 5% 100% 100% 100%2 Partial Time for Alliance President CEO in Community Engagement Work 10,000$ 0% 0% 100% 50% 40%3 Staff T ime for School Board Leadership Development planning 10,000$ 20% 0% 100% 90% 80%

Direct Personnel Input:

1) Complete the table below for each position in the proposed budget. If there are more than 30 positions budgeted, please contact your foundation officer for a customized

workbook.

2) The information you enter will automatically populate the Personnel and Benefits section of the Direct Costs Detail worksheet. Please review that information.

3) If/when making corrections to the Direct Personnel Detail below, please do not delete rows as they are linked to the Direct Costs Detail worksheet.



erson . .

All iance f or Ed ucati on (AFE)Support for Seattle Public Schools' Strategic PlanBudget Proposal Direct Cost Detail

Budget Period1 2 3 4 5 Total Notes

Title1 Community Engagement Manager 1 FTE 65,000 68,250 71,663 - - 204,913

2 Partia Time or A iance Presi ent CEO in Community Engagement Wor 10,000 5,000 4,000 - - 19,000

3 S ta Time or Sc oo Boar Lea ers ip Deveopment panning 10,000 9,000 8,000 - - 27,000

Total Personnel 85,000$ 82,250$ 83,663$ -$ -$ 250,913$

Total Benefits 15,000$ 15,450$ 15,933$ -$ -$ 46,383$

Total Personnel and Benefits 100,000$ 97,700$ 99,595$ -$ -$ 297,295$

If less than $50,000 annually, enter total (detail not required): -

If $50,000 or more annually, enter detail by line item, below. Enter the total per line item under the applicable bud get period:ItemsFacilitators and Consultants - Community Engagement 4,800 4,800 4,800 14,400

Data Gat ering an Summary - Community Engagement 6,000 8,000 10,000 24,000 Interpreters or Community Engagement Meetings 6,000 6,500 7,000 19,500

Facilitators and Consultants - School Board Leadership Development 20,000 22,500 25,000 67,500

Total CONSULTING & PROFESSIONAL FEES 36,800$ 41,800$ 46,800$ -$ -$ 125,400$

If less than $10,000 annually, enter total etai not require : -

If $10,000 or more annually, enter detail by line item, below. Enter the total per line item under the applicable bud get period:Items

Materials for Community Engagement Outreach Efforts 1,500 1,500 1,500 4,500

Inflation on above expenses - - - - -

Total MATERIALS & SUPPLIES 1,500$ 1,500$ 1,500$ -$ -$ 4,500$



-

Total COMPUTERS & EQUIPMENT -$ -$ -$ -$ -$ -$



Web Development Costs - Design for Community Engagement 5,000 1,500 1,500 8,000

Media and Public Relations Materials 5,000 5,000 5,000 15,000


Total PRINTING & PUBLICATIONS 10,000$ 6,500$ 6,500$ -$ -$ 23,000$



Transportation for School Board members 250 250 250 750


Total TRAVEL & ACCOMMODATIONS 250$ 250$ 250$ -$ -$ 750$



Annual Support for Conference Attendance - School Board - 4 at $5000/ea 20,000 20,000 20,000 60,000

Facilities rentals for Community Engagement events 3,500 3,500 3,500 10,500

Facilities Rentals for School Board Leadership Development 1,500 1,750 2,000 5,250

Meals and C atering for Community Engagement Task Force meetings 400 400 400

Meals and Catering for Community Engagement Task Community meetings $2,800 $2,800 $2,800

Miscellaneous Costs for Community Engagement efforts 1,500 1,500 1,500

Meals and Catering for School Board Development 1,700 1,800 1,900 5,400


Total CONFERENCES, CONVENTIONS, MEETINGS 31,400$ 31,750$ 32,100$ -$ -$ 95,250$

For Other Expenses, enter detail by line item, below. Enter the total per line item under the applicable bud get period:Item

Miscellaneous Costs for School Board Development 2,000 2,500 3,000 7,500


Total OTHER DIRECT EXPENSES 2,000$ 2,500$ 3,000$ -$ -$ 7,500$

Total Direct Costs 181,950$ 182,000$ 189,745$ -$ -$ 553,695$

CONSULTING & PROFESSIONAL FEES

MATERIALS & SUPPLIES

PERSONNEL & BENEFITSPersonnel Amounts will be input automatically from

personnel sheet.

OTHER DIRECT EXPENSES

COMPUTERS & EQUIPMENT

PRINTING & PUBLICATIONS

RAVEL & ACCOMMODATIONS

CONFERENCES, CONVENTIONS, MEETINGS



Total Subgrants 1

ersion 02.28.07

All iance for Educat ion (AFE)Support fo r Seattle Public Schools' Strategic Plan

Total Subgrants

ubgrants to Organizations & Schools

1) Complete the table below for each organization or school receiving a subgrant. If there are more than 10 organizations expected to receivesubgrants, please contact your foundation officer for a customized workbook.

roject Budget Period 1 2 3 Total Notes

ubgrants to Schools Primary Cost Category

Seattle Public Schools See rows 46 to 58 below. 2,393,318 2,409,873 1,444,489 6,247,680 otal Subgrants to Schools 2,393,318$ 2,409,873$ 1,444,489$ 6,247,680$

SUBGRANT SUMMARY BY COST CATEGORY PER OCTOBER 2008 BUDGET:Personnel and Benefits $812,613 $1,069,407 $716,563 $2,598,584

Consulting & Professional Fees $906,600 $834,300 $581,600 $2,322,500Materials & Supplies $0 $200,000 $0 $200,000

Computers & Equipment $0 $0 $0 $0Printing & Publications $0 $0 $0 $0

Travel & Accommodations $30,000 $30,000 $0 $60,000

Conferences, Conventions, Meetings $15,000 $15,000 $0 $30,000Facilities $0 $0 $0 $0

Other $129,105 $261,165 $146,326 $536,596TOTAL SUBGRANT DIRECT $2,393,318 $2,409,873 $1,444,489 $6,247,680Indirect* (15% of first $100K per BMGF policy) $15,000 $15,000 $15,000 $45,000

*Enables AFE (grantee) to recover costs of

project oversight and processing subgrantee'smonthly invoices requesting reimbursement of

allowable project expenses.

Budget Period This is the original 3 year subgrant budget approved in late 2008. The next 4 tabs reflect the supplements, budget amendments and

no cost extensions approved between 2009 and 2012.


http://slidepdf.com/reader/full/bmgf-budget-report-nov2012 6/10 TOTAL Budget Summary 1

version 02.28.07

Al liance for Education (AFE)Support for Seattle Public Schools' Strategic Plan

BUDGET SUMMARY BY COST CATEGORY 1 2 3 Total % of BMGFPersonnel and Benefits 70,980 125,400 127,995 324,375 4.7%

Consulting & Professional Fees 19,683 71,500 57,000 148,183 2.1%

Materials & Supplies - 2,000 2,000 4,000 0.1%

Computers & Equipment - - - - 0.0%

Printing & Publications - 17,500 13,000 30,500 0.4% Travel & Accommodations 28 3,500 4,000 7,528 0.1%

Conferences, Conventions, Meetings 4,176 27,380 30,133 61,689 0.9%

Facilities - - - - 0.0%

Other 20 2,087 1,400 3,507 0.1%

Subgrants 2,393,318 2,409,873 1,444,489 6,247,680 89.8%

TOTAL DIRECT COSTS FUNDED BY BMGF 2,488,205$ 2,659,240$ 1,680,017$ 6,827,462$ 98.1%Indirect Costs (incl Subgrant Oversight by AFE) 29,233 52,405 50,329 131,967 1.9%

TOTAL COSTS FUNDED BY BMGF 2,517,438$ 2,711,645$ 1,730,346$ 6,959,430$ 100.0%

OTHER COMMITTED FUNDING (List source and amount of other funding that has been committed to this project). % of ProjectStuart Foundation 254,000 254,000 1.3%

Seattle Public Schools direct resources 3,458,710 3,458,710 18.1%

The Broad & Dell Foundations (grant pending) 2,788,595 1,610,454 1,644,084 6,043,133 31.6%

The Boeing Company 280,000 280,000 1.5%

OSPI grants (toward math & science improvements) 1,000,000 1,000,000 5.2%

- 0.0%- 0.0%

- 0.0%

- 0.0%

- 0.0%

Total Other Funders 7,781,305$ 1,610,454$ 1,644,084$ 11,035,843$ 57.7%

UNFUNDED PROJECT COSTS (Enter any unfunded project cos ts)Total Unfunded Project Costs 438,373$ 335,360$ 351,457$ 1,125,190$ 5.9%

TOTAL PROJECT COST 10,737,116$ 4,657,459$ 3,725,887$ 19,120,463$

SUMMARY OF SCHOOL SUBGRANTEES

un ng per

School

un ng per

Student

Total Number of Subgrantee Schools at End of Grant Period 96 Tota Num er o Stu ents at En o Grant Perio 49,800

Subgrant per School/Student 65,080$ 125$Gates Funding per School/Student 72,494$ 140$

Project Funding per School/Student 199,171$ 384$

Total project budget $ 19,120,463

Percentage of Lobbying activityPercentage of Non-Lobbying activity

Certified by:

Signature

Budget Summary

Name

Title

Date Signed

Non-Lobbying Certification : Required for Prospective Advocacy GranteesGrantee certifies that the funds received from the Gates Foundation for this project (from this grant and any other Gates

Foundation grant for this project received to date this year) are less than or equal to the non-lobbying portion of the

project budget and that there is no agreement, oral or written, directing the grant funds to be used for lobbying activities.

Grantee agrees to assume sole responsibility for ensuring compliance with U.S. federal laws, rules, and regulations as

they pertain to lobbying and the use of private foundation funds.

BUDGET PERIODRows 8 to 18 reflect the supplements and budget

amendments approved during the 3 periods.



version 02.28.07

All iance for Education (AFE)Support for Seattle Public Schools' Strategic Plan

Nov 08-Aug09 Sept 09-Aug10 Sept 10-Aug11 Sept 11-Aug12 Sept 12-Aug13

Budget Period 1 2 3 4 5 Total % of BCarryover from Previous Budget Period N/A 1,087,807 611,864 683,052 141,582

SOURCES OF FUNDS (GATES FUNDING ONLY)Grant (Gates Funding) 2,617,561 2,634,173 1,707,696 - 6,959,430 Interest Income -

Subtotal - Current Period Funding 2,617,561$ 2,634,173$ 1,707,696$ -$ -$ 6,959,430$

Total Sources of Cash -- Gates Grant 2,617,561$ 3,721,980$ 2,319,560$ 683,052$ 141,582$ 6,959,430$

Direct CostsPersonnel and Benefits 70,980 103,142 110,484 55,799 340,405

Consulting & Professional Fees 19,683 27,176 72,462 42,395 161,716

Materials & Supplies - 2,976 876 1,313 5,165

Computers & Equipment -

Printing & Publications 3,400 381 191 3,971

Travel & Accommodations 28 5,278 3,556 5,117 13,979

Conferences, Conventions, Meetings 4,176 18,429 7,005 12,028 41,638

Facilities - -

Other 20 449 200 44 713

Total Direct Costs 94,887$ 160,850$ 194,964$ 116,887$ -$ 567,588$

SUBGRANTSSubgrants to Schools

Seattle Public Schools 1,405,634 $2,910,138 $1,397,300 $392,050 6,105,122

Total Subgrants 1,405,634$ 2,910,138$ 1,397,300$ 392,050$ -$ 6,105,122$

TOTAL DIRECT COSTS FUNDED BY BMGF 1,500,521$ 3,070,988$ 1,592,264$ 508,937$ -$ 6,672,710$ 9

Total Indirect Costs (incl Subgrant Oversight by AFE) 29,233$ 39,128$ 44,245$ 32,533$ -$ 145,138$

TOTAL COSTS FUNDED BY BMGF 1,529,754$ 3,110,116$ 1,636,509$ 541,470$ -$ 6,817,848$ 10

OTHER COMMITTED FUNDING (List source and amount of other funding that has been committed to this project)Broad Foundation (Academic Data Warehouse) 1,250,000

Stuart Foundation (HR sytm; Leadership Dev) 1,049,000 Boeing (AP/PSAT; STEM) 290,448

Total Other Funders -$ -$ -$ -$ -$ 2,589,448$

UNFUNDED PROJECT COSTSTotal Unfunded Project Costs -$

TOTAL PROJECT COST 1,529,754$ 3,110,116$ 1,636,509$ 541,470$ -$ 9,407,296$

Subgrant Expenses by Category Nov08-Aug09 Sept09-Aug10 Sept10-Aug11 Sept11-Aug12 Sept12-Aug13Personnel and Benefits 80,778 668,765 649,401 85,382

Consulting & Professional Fees 1,188,993 1,997,694 612,566 189,698

Materials & Supplies 6,575 2,148

Computers & Equipment

Printing & Publications

Travel & Accommodations 33,933 15,868 9,386

Conferences, Conventions, Meetings 4,879 5,218 1,200

Facilities

Other 97,051 216,018 122,599 116,970

TOTAL SUBGRANT $1,405,634 $2,910,138 $1,397,300 $392,050

Actual Resul ts1) Enter the actual expenditures in the applicable budget period below.

2) If necessary, complete the Recast worksheet for the upcoming budget period.

<------- These 3 investments are closely related to this project



BudgetVariance 1

02.28.07

ance fo r Educ atio n (AFE)port for Seattle Public Schools' Strategic Plan

u al to B udget Variance Budget Period 1 Budget Period 2 Budget Period 3 Budget Period 4 Budget Period 5 TOTAL PROJECT

ACTUALS Budget Var $$ Var % ACTUALS Budget Var $$ Var % ACTUALS Budget Var $$ Var % ACTUALS Budget Var $$ Var % FORECAST Budget Var $$ Var % Actuals Orig Budget Var $$ Var %

arryover fromPrevious Budget Period N/A N/A N/A N/A 1,087,807 - (1,087,807) N/A 611,864 - (611,864) N/A 683,052 - (683,052) N/A 141,582 - (141,582) N/A N/A

RCES OF CASH (GATES FUNDING ONLY)rant 2,617,561 2,517,438 (100,123) - 4% 2, 634, 173 2,711,645 77,472 3% 1,707,696 1,730,346 22,650 1% - - - 0% - - - 0% 6,959,430 6,959,430 (0) 0%

tereston Gates Funding - N/A N/A N/A - N/A N/A N/A - N/A N/A N/A - N/A N/A N/A N/A N/A N/A N/A - N/A N/A N/A

otal Sources of Cash 2,617,561 2,517,438 (100,123) 3, 72 1, 980 2, 711 ,645 ### ### ## 2, 31 9, 560 1, 73 0, 346 ( 589 ,214 ) 683,052 - (683,052) 141,582 - (141,582) 6,959,430 6,959,430 (0)

ct Costsersonne an ene s , , - , , , 18% , , , 14% , - ( , ) - - - , , ( , ) -

onsulting & Professional F ees 19,683 19,683 - 0% 27,176 71,500 44,324 62% 72,462 57,000 (15,462) -27% 42,395 - (42,395) 0% - - - 0% 161,716 148,183 (13,533) -9%

aterials & Supplies - - - 0% 2,976 2,000 (976) -49% 876 2,000 1,124 56% 1,313 - (1,313) 0% - - - 0% 5,165 4,000 (1,165) -29%omputers &Equipment - - - 0% - - - 0% - - - 0% - - - 0% - - - 0% - - - 0%

rinting & Publications - - - 0% 3,400 17,500 14,100 81% 381 13,000 12,619 97% 191 - (191) 0% - - - 0% 3,971 30,500 26,529 87%rave ccommo a ons - , , ( , ) -51% , , 11% , - ( , ) - - - , , ( , ) -86%onf erences , C onventi ons, e eti ngs 4, 176 4,176 - 0% 18,429 27,380 8,951 33% 7,005 30,133 23,128 77% 12,028 - (12,028) 0% - - - 0% 41,638 61,689 20,051 33%acilities - - - 0% - - - 0% - - - 0% - - - 0% - - - 0% - - - 0%

ther 20 20 - 0% 449 2,087 1,638 78% 200 1,400 1,200 86% 44 - (44) 0% - - - 0% 713 3,507 2,794 80%otal Direct Costs 94,887 94,887 - 0% 160 ,850 249,367 88,517 35% 194,964 235,528 40,564 17% 116,887 - (116,887) 0% - - - 0% 567,588 579,782 12,194 2%

grantsSubgrants to Organizations

- - - - 0% - - - 0% - - - 0% - - - 0% - - - 0% - - - 0%

Subgrants to Schoolseattle Public Schools 1,405,634 2,393,318 987,684 41% 2,910,138 2,409,873 (500,265) -21% 1,397,300 1,444,489 47,189 3% 392,050 - (392,050) 0% - - - 0% 6,105,122 6,247,680 142,558 2%

otal Subgrants 1,405,634 2,393,318 987,684 41% 2,910,138 2,409,873 (500,265) -21% 1 ,3 97 ,3 00 1 ,4 44 ,4 89 4 7, 18 9 3 % 39 2, 050 - (392,050) 0% - - - 0% 6,105,122 6,247,680 142,558 2%

AL DIRECT COSTS FUNDED BY BMGF 1,500,521 2,488,205 987,684 40% 3,070,988 2,659,240 (411,748) -15% 1 ,5 92 ,2 64 1 ,6 80 ,0 17 8 7, 75 3 5 % 50 8, 937 - (508,937) 0% - - - 0% 6,672,710 6,827,462 154,752 2%

otal Indirect Costs 29,233 29,233 - 0% 39,128 52,405 13,278 25% 44,245 50,329 6,085 12% 32,533 - (32,533) 0% - - - 0% 145,138 131,967 (13,171) -10%

AL CO ST S F UN DED BY BM GF 1 ,5 29 ,7 54 2 ,5 17 ,4 38 987,684 39% 3,110,116 2,711,645 (398,471) -15% 1 ,6 36 ,5 09 1 ,7 30 ,3 46 9 3, 83 8 5 % 54 1, 470 - (541,470) 0% - - - 0% 6,817,848 6,959,430 141,581 2%



Recast - Period 4verson . .

Alliance fo r Education (AFE)Support fo r Seattle Public Schools' Strategic PlanRevised Budget Forecast - Period Four

BUDGET PERIOD 1 2 3 4 Total Budget Variance Var %

STATUS ACTUALS ACTUALS ACTUALS FORECASTCarryover from Previous Budget Period N/A 1,087,807 611,864 683,052

SOURCES OF FUNDS (GATES FUNDING ONLY)Grant (Gates Funding) 2,617,561 2,634,173 1,707,696 - 6,959,430 6,959,430 (0) 0.0%

Interest Income - - - - - - Subtotal - Current Period Funding 2,617,561$ 2,634,173$ 1,707,696$ -$ 6,959,430$ 6,959,430$ (0)$ 0.0%

Total Sources of Cash -- Gates Grant 2,617,561$ 3,721,980$ 2,319,560$ 683,052$ 6,959,430$ 6,959,430$ (0)$ 0.0%

Direct CostsPersonnel and Benefits 70,980 103,142 110,484 36,840 321,446 324,375 2,929 0.9%

Consulting & Professional Fees 19,683 27,176 72,462 41,000 160,321 148,183 (12,138) -8.2%

Materials & Supplies - 2,976 876 1,300 5,152 4,000 (1,152) -28.8%

Computers & Equipment - - - - - -

Printing & Publications - 3,400 381 9,000 12,781 30,500 17,719 58.1%

Travel & Accommodations 28 5,278 3,556 9,500 18,362 7,528 (10,834) -143.9%

Conferences, Conventions, Meetings 4,176 18,429 7,005 5,800 35,410 61,689 26,279 42.6%

Facilities - - - - - -

Other 20 449 200 1,467 2,136 3,507 1,371 39.1%

Total Direct Costs 94,887$ 160,850$ 194,964$ 104,907$ 555,608$ 579,782$ 24,174$

SUBGRANTSSubgrants to Schools

Seatte Pu ic Sc oos 1,405,634 2,910,138 1,397,300 590,310 6,303,382 6,247,680 55,702 -0.9%

Total Subgrants 1,405,634$ 2,910,138$ 1,397,300$ 590,310$ 6,303,382$ 6,247,680$ (55,702)$ -

TOTAL DIRECT COSTS FUNDED BY BMGF 1,500,521$ 3,070,988$ 1,592,264$ 695,217$ 6,858,990$ 6,827,462$ (31,528)$ -

Total Indirect Costs (incl Subgrant Oversight by AFE) 29,233$ 39,128$ 44,245$ 30,736$ 143,341$ 131,967$ (11,374)$ -

TOTAL COSTS FUNDED BY BMGF 1,529,754$ 3,110,116$ 1,636,509$ 725,953$ 7,002,331$ 6,959,430$ (42,902)$ -

ORIGINAL BUDGET - Funded by BMGF 2,517,438$ 2,711,645$ 1,730,346$ -$ 6,959,430$

Variance From Budget 987,684$ (398,471)$ 93,838$ (725,953)$ (42,902)$

Variance % 39.2% -14.7% 5.4% -0.6%

Total project budget $ 7,002,331Percentage of Lobbying activity

Percentage of Non-Lobbying activity

Certified by:

Signature

Date Signed

Grantee certifies that the funds received from the Gates Foundation for this project (from this grant and any other Gates

Foundation grant for this project received to date this year) are less than or equal to the non-lobbying portion of the project

budget and that there is no agreement, oral or written, directing the grant funds to be used for lobbying activities. Grantee

agrees to assume sole responsibility for ensuring compliance with U.S. federal laws, rules, and regulations as they pertain

to lobbying and the use of private foundation funds.

Name Title

Non-Lobbying Certification: Required for Advocacy Grantees Only

1) Review the Budget Proposal Summary (on separate tab), Actuals to date (carried forward below), and any Carryover(below). If needed, revise the expenditures for current and future budget periods in the section at the bottom of thisworksheet.2) Check your Budget Proposal Summary for the scheduled payout of grant funds. Discuss with your foundation officerwhether that schedule should change based on revisions to expenditures or carryover from the prior year. If so, enter thenew amounts under Sources of Cash, Grant line item.3) Submit your recast budget with your progress report. Describe in the progress report any material differences(>10%)



Recast - Period 5version 02.28.07

All iance fo r Educat ion (AFE)Support for Seattle Public Schools' Strategic PlanRevised Budget Forecast - Period Five

BUDGET PERIOD 1 2 3 4 5 6 Total Budget Variance Var

STATUS ACTUALS ACTUALS ACTUALS ACTUALS FORECAST FORECAST

Carryover from Previous Budget Period N/A 1,087,807 611,864 683,052 141,582 72,582

SOURCES OF FUNDS (GATES FUNDING ONLY)Grant (Gates Funding) 2,617,561 2,634,173 1,707,696 - 6,959,430 6,959,430 (0) 0.0

Interest Income - - - - - - - Subtotal - Current Period Funding 2,617,561$ 2,634,173$ 1,707,696$ -$ -$ -$ 6,959,430$ 6,959,430$ (0)$ 0.0

Total Sources of Cash -- Gates Grant 2,617,561$ 3,721,980$ 2,319,560$ 683,052$ 141,582$ 72,582$ 6,959,430$ 6,959,430$ (0)$ 0.0

Direct Costs

Personnel and Benefits 70,980 103,142 110,484 55,799 340,405 324,375 (16,030) -4.9

Consulting & Professional Fees 19,683 27,176 72,462 42,395 161,716 148,183 (13,533) -9.1

Materials & Supplies - 2,976 876 1,313 5,165 4,000 (1,165) -29.

Computers & Equipment - - - - - - -

Printing & Publications - 3,400 381 191 3,971 30,500 26,529 87.

Travel & Accommodations 28 5,278 3,556 5,117 13,979 7,528 (6,451) -85.

Conferences, Conventions, Meetings 4,176 18,429 7,005 12,028 41,638 61,689 20,051 32.

Facilities - - - - - - -

Other 20 449 200 44 713 3,507 2,794 79.

Total Direct Costs 94,887$ 160,850$ 194,964$ 116,887$ -$ -$ 567,588$ 579,782$ 12,194$ 2

SUBGRANTS

Subgrants to Organizations

Subgrants to SchoolsSeatte Pu ic Sc oos 1,405,634 2,910,138 1,397,300 392,050 60,000 6,165,122 6,247,680 82,558 1.3

Total Subgrants 1,405,634$ 2,910,138$ 1,397,300$ 392,050$ 60,000$ -$ 6,165,122$ 6,247,680$ 82,558$ 1

TOTAL DIRECT COSTS FUNDED BY B MGF 1,500,521$ 3,070,988$ 1,592,264$ 508,937$ 60,000$ -$ 6,732,710$ 6,827,462$ 94,752$ 1

Total Indirect Costs (AFE for Subgrant Oversight) 29,233$ 39,128$ 44,245$ 32,533$ 9,000$ -$ 154,138$ 131,967$ (22,171)$ -16

TOTAL COSTS FUNDED BY BMGF 1,529,754$ 3,110,116$ 1,636,509$ 541,470$ 69,000$ -$ 6,886,848$ 6,959,430$ 72,581$ 1

ORIGINAL BUDGET - Funded by BMGF 2,517,438$ 2,711,645$ 1,730,346$ -$ -$ -$ 6,959,430$

Variance From Budget 987,684$ (398,471)$ 93,838$ (541,470)$ (69,000)$ -$ 72,581$

Variance % 39.2% -14.7% 5.4% 1.0%

Total project budget $ 6,886,848Percentage of Lobbying activity 0%Percentage of Non-Lobbying activity 100%

Certified by:

Signature

NameTitle

Date Signed

Mark A. Taylor

Grants Director, Alliance for Education

11/8/2012

Grantee certifies that the funds received from the Gates Foundation for this project (from this grant and any other Gates

Foundation grant for this project received to date this year) are less than or equal to the non-lobbying portion of theproject budget and that there is no agreement, oral or written, directing the grant funds to be used for lobbying

activities. Grantee agrees to assume sole responsibility for ensuring compliance with U.S. federal laws, rules, and

regulations as they pertain to lobbying and the use of private foundation funds.

Non-Lobbying Certification: Required for Advocacy Grantees Only

1) Review the Budget Proposal Summary (on separate tab), Actuals to date (carried forward below), and any Carryover (below). If needed, revise theexpenditures for current and future budget periods in the section at the bottom of this worksheet.2) Check your Budget Proposal Summary for the scheduled payout of grant funds. Discuss with your foundation officer whether that schedule shouldchange based on revisions to expenditures or carryover from the prior year. If so, enter the new amounts under Sources of Cash, Grant line item.3) Submit your recast budget with your progress report. Describe in the progress report any material differences(>10%) (compare the totals by CostCategory below with that amount from the original budget.)

bmgf budget report nov2012

Documents