Walker Community Center board has voted to provide training to develop community members skills and help the county with a reduction in smoking practices among local community members. The institution CEO requested the project manager to develop a budget for the next 3 months. You are requested to use the information provided below to develop the requested budget for the indicated time frame. Also, community partners have pledged to provide financial support with a second year training program that should include year one activities. Create a new sheet that includes the budget for year 1 and 2 with a new column for the total budget.

The program manager worked with the staff to create a budget that will satisfy the board and the CEO goals. Personnel salary is expected to increase by 2%, and non-personnel expenses will increase due to an annual deficit of 1.5%. The institutions indirect cost (ICD) and the travel rate remain as is the for both periods. The workshop trainers have decided to provide training during the second year of the project with no additional costs ($55 an hour). Personnel Expenses (12% of total budget): Project Manager: Annual salary $75,000 (10% time dedicated) The PM functions are limited to scheduling and management of the workshops, recruitment and manage workshop training, and problem solving among other duties. Travel expenses were budgeted for 100 miles. Project Coordinator: Annual salary $55,000 (20% time dedicated to the project), work primarily with participants in the project. Support Project Manager, inform participants of events, register them for events, mail materials to workshops, facilitate participant use of internet site, forward communication to participants. Travel expenses were budgeted for 200 miles. Finance Director: Annual salary $60,000 (30% time dedicated to the project), provide finance/accounting workshops, provide phone-based coaching on finance issues to participants, provide all financial management and reports for the project, payments to participants, develop all financial reporting. Travel expenses were budgeted for 500 miles.

Prepare a budget for year 1 and 2