tour Assignment Number 2: Create an excel spreadsheet budget {like the example in class] with a tab for every project budget [provided below], as well as a tab for the newsletters {which you will need to create], and a tab for membership and administration {please add membership to the revenues on the administration budget]. I have provided a template. You will have to build your own newsletter tab, and fill In all of the numbers and Formulas for both years. You do not need a tab for marketing or fundraising. Then create a Board Summary tab that amalgamates all of the project and overhead revenues and expense. Like the example in class, structure it like a profit-andvloss statement using the categories listed in schedule five. Unlike the example in class, you are not creating year-to-date columns or projections columns. Instead, you are creating two budget columns- one for the EBB-2|] fiscal year and one for 2B2B-21 fiscal year {two years, because that is the programming cycle of two the organization's main program]. PLEASE MAKE SURE 'I'DU HAVE MADE TWO SEPARATEF! YEARS ON EACH TAB. Please note any assumptions or decisions you are making in the notes column of the budget tabs. You have been provided with a single year of numbers some future budgets and some current years- for future years of annual programs and overhead that is not changing because of the new strategic plan, assume they will be the same [for simplicity- but don't do this with real-world budgets in future]. irou are not being asked to change or make up any numbers not provided, the board wants to see how their usual SI] budget approach will change with this new model. If there is a large surplus or deficit, it is not part of you job to troubleshoot it, only to show it in the budget. Finally, write a one page letter summarizing your findings to Ms. Smith, Board President. Explain whether or not their goal of breaking even on projects to ensure they will break even overall will work with their new operating model {should be brief]. ***This is in two parts - the excel spreadsheet, and the word document. This is both Assignment 8 and 9 as this is larger than most single assignments, and there are two dellverables. But please treat them as part of the same assignment as the excel spreadsheet MUST relate to what you write in the letter