Please help with this and show work

PART 1: Create a Budget Create a budget that supports the work required to achieve the strategic goal for which you created objectives, strategies, and action steps in the Team Project Part II assignment. Begin by making a list of all the expenses associated with implementing the goal. Conduct research to determine a reasonable estimate for each expense. Next, open the budget template. In column A, you will see a list of revenues and expenses based on Exhibit 5b from the case. In column B you will see the actual revenues and expenses reported for 2016 . For the purposes of this case, we will imagine fiscal year 2016 has ended and we are making projections for next year (2017). First, provide projections for each of the revenue categories for 2017. Inspection of the 2015 and 2016 numbers indicate line item values change from year to year. As you fill in your 2017 projections for each of the revenue categories, include a brief note explaining any changes. For example, if grants and contributions projection for 2017 is 2,968,756, include a note about the $500,000 increase (e.g., anticipated NSF grant). Next, add your expenses related to your strategic goal to the spreadsheet. You will first need to categorize expenses as "Program services", "General and administrative", or "Fundraising". Add rows to the spreadsheet as needed for each expense category. Your budget needs to be comprehensive and reflect all costs (within reason) related to your goals, objectives, strategies, and action steps. For example, in the screenshot below, I added in a "salary" into the general and administrative category with the note "Part-time programmer" (see the row highlighted in orange). Please ensure all new line items are entered in red font. The $45,000 appears in column D. The new Total general and administrative category would equal the projected number for 2017+$45,000 for the salary. Budget Justification Narrative: Following your budget, please include a narrative justification/explanation for each of the new line items listed in your proposed budget column. You will have at least one full page of numerical budget data and at least one full page of budget narrative. The budget justification narrative is your explanation/reasoning for the new expense items (i.e., any numbers in red) that will be submitted to Silkroad's Board of Directors for approval Budget Justification Narrative: Following your budget, please include a narrative justification/explanation for each of the new line items listed in your proposed budget column. You will have at least one full page of numerical budget data and at least one full page of budget narrative. The budget justification narrative is your explanation/reasoning for the new expense items (i.e., any numbers in red) that will be submitted to Silkroad's Board of Directors for approval (imaginary of course). Provide adequate details in your budget justification narrative so that any reader easily understands the rationale you have used for your amounts. You do not need to provide a justification for any of the numbers provided in the case. Example of a Weak and Strong Budget Narrative for an Expense Item: - Expense Item \#1: Salary =$45,000 - Weak Narrative: A part-time programmer's salary is $45,000. - Strong Narrative: Although an IT department is already in place, a website update is needed to accommodate online ticket sales. Current IT staff do not have necessary training and experience to implement this upgrade. [Insert source here] suggests average full-time programmer salary is $90,000. The update and maintenance is estimated to require approximately 20 hours of staff time per week [include source]. PART 1: Create a Budget Create a budget that supports the work required to achieve the strategic goal for which you created objectives, strategies, and action steps in the Team Project Part II assignment. Begin by making a list of all the expenses associated with implementing the goal. Conduct research to determine a reasonable estimate for each expense. Next, open the budget template. In column A, you will see a list of revenues and expenses based on Exhibit 5b from the case. In column B you will see the actual revenues and expenses reported for 2016 . For the purposes of this case, we will imagine fiscal year 2016 has ended and we are making projections for next year (2017). First, provide projections for each of the revenue categories for 2017. Inspection of the 2015 and 2016 numbers indicate line item values change from year to year. As you fill in your 2017 projections for each of the revenue categories, include a brief note explaining any changes. For example, if grants and contributions projection for 2017 is 2,968,756, include a note about the $500,000 increase (e.g., anticipated NSF grant). Next, add your expenses related to your strategic goal to the spreadsheet. You will first need to categorize expenses as "Program services", "General and administrative", or "Fundraising". Add rows to the spreadsheet as needed for each expense category. Your budget needs to be comprehensive and reflect all costs (within reason) related to your goals, objectives, strategies, and action steps. For example, in the screenshot below, I added in a "salary" into the general and administrative category with the note "Part-time programmer" (see the row highlighted in orange). Please ensure all new line items are entered in red font. The $45,000 appears in column D. The new Total general and administrative category would equal the projected number for 2017+$45,000 for the salary. Budget Justification Narrative: Following your budget, please include a narrative justification/explanation for each of the new line items listed in your proposed budget column. You will have at least one full page of numerical budget data and at least one full page of budget narrative. The budget justification narrative is your explanation/reasoning for the new expense items (i.e., any numbers in red) that will be submitted to Silkroad's Board of Directors for approval Budget Justification Narrative: Following your budget, please include a narrative justification/explanation for each of the new line items listed in your proposed budget column. You will have at least one full page of numerical budget data and at least one full page of budget narrative. The budget justification narrative is your explanation/reasoning for the new expense items (i.e., any numbers in red) that will be submitted to Silkroad's Board of Directors for approval (imaginary of course). Provide adequate details in your budget justification narrative so that any reader easily understands the rationale you have used for your amounts. You do not need to provide a justification for any of the numbers provided in the case. Example of a Weak and Strong Budget Narrative for an Expense Item: - Expense Item \#1: Salary =$45,000 - Weak Narrative: A part-time programmer's salary is $45,000. - Strong Narrative: Although an IT department is already in place, a website update is needed to accommodate online ticket sales. Current IT staff do not have necessary training and experience to implement this upgrade. [Insert source here] suggests average full-time programmer salary is $90,000. The update and maintenance is estimated to require approximately 20 hours of staff time per week [include source]