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.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 $ 10,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