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 the final Operating Budget for Year 1 and Year 2?
Year 1 and Year 2 Revenue
Corporate Donations $ 40,000.00
Fundraising $ 20,000.00
Individual Contributions $ 10,000.00
Interest $ 40.00
Program Fees $ 30,000.00
Grants $ 350,000.00
Year 1 Expenses
Admin. Supplies and Services $ 10,000.00
Building Expenses
Insurance $ 2,000.00
Miscellaneous $ 3,000.00
Utilities $ 4,500.00
Loan Payments $ 1 6,000.00
Equipment $ 5,000.00
Insurance $ 1 3,000.00
Legal Fees $ 5 00.00
Marketing $ 1 0,000.00
Phone Services $ 3,500.00
Postage $ 2,000.00
Salaries and Benefits
Administrative $ 15,000.00
Benefits $ 10,000.00
Executive Director $ 100,000.00
Developmental Director $ 75,000.00
FICA & Taxes $ 2 0,000.00
Health Insurance $ 8,000.00
Signs $ 1,000.00
T-Shirts $ 1 0,000.00
Travel & Conference $ 2,000.00
