Given: All Salaries and Benefits costs involving inflation increased 10% for the Year 2. Please use the Excel template to complete the problem. You…
Given: All Salaries and Benefits costs involving inflation increased 10% for the Year 2. Please use the Excel template to complete the problem. You may amend the worksheet to complete the project. As a project or program manager, you are focused on cost, schedule, and performance. What is final Operating Budget for Year 1 and Year2? Year 1 and Year 2 Revenue Corporate Donations $ 40,000.00Fundraising $ 20,000.00Individual Contributions $ 10,000.00Interest $ 40.00Program Fees $ 30,000.00Grants $ 350,000.00Year 1 Expenses Admin. Supplies and Services $ 10,000.00Building ExpensesInsurance $ 2,000.00Miscellaneous $ 3,000.00Utilities $ 4,500.00Loan Payments $ 1 6,000.00Equipment $ 5,000.00Insurance $ 1 3,000.00Legal Fees $ 5 00.00Marketing $ 10,000.00Phone Services $ 3,500.00Postage $ 2,000.00Salaries and BenefitsAdministrative $ 15,000.00Benefits $ 10,000.00Executive Director $ 100,000.00Developmental Director $ 75,000.00FICA & Taxes $ 2 0,000.00Health Insurance $ 8,000.00Signs $ 1,000.00T-Shirts $ 1 0,000.00Travel & Conference $ 2,000.00