Create a program budget for diversity recruitment, management, and assessment based on the line item budgets of the Nassau County departments presented below. It should also include a PowerPoint Presentation. chec

First Part

This assignment for requires you to create a program budget for diversity recruitment, management, and assessment based on the line item budgets of the following Nassau County departments:

• Asian American Affairs;
• Office of Hispanic Affairs;
• Office of Human Resources;
• Office of Minority Affairs; and,
• Veterans Affairs.

Use the Nassau County budget documents to understand the purpose and functions of each department. The Nassau County budget summary contains the revenue and expenditure data of each department listed above. You will use the data to create a 5-year forecast for each department’s line item budget and to create the program budget for the diversity initiative.

To create the diversity program for Nassau County, use the case study created for the County of XYZ as a guide to develop sub-program units. Each sub-program unit will include personnel and other than personnel services (OTPS) expenditures from each of the departments listed above based on a proportional allocation of resources necessary to perform the tasks and activities of each sub-program unit. Each sub-program unit will also include departmental revenue based on a proportional allocation of personnel and OTPS to each sub-program unit.

The development of the program budget will require you to use Excel to create each department’s line item budget and to link each line item revenue and expenditure object and sub-object to the diversity program and its sub-program budgets. A summary sheet will be created to total the 5-year line item revenue and expenditure forecast of each department listed above. A second summary sheet will link the 5-year line item departmental revenue and expenditure forecast to the diversity program and its sub-program units which you created.

The creation of the diversity program will be presented in a report consisting of the following sections:

• Cover letter
• Executive Summary
• Report

Second Part

Power Point Deck/Presentation (11 Slides)

The mandatory structure of the Power Point deck is as follows:

1. Cover Page (1 page)
2. Presentation Deck
3. Overview (1 slide )
4. Introduction (1 slide
5. Departments and functions (1 slide –)
6. Department personnel (1 slide with table or graph –)
7. Department budgets ( 1 slide –)
8. Creation of the diversity program (1 slide )
9. Creation of the program budget (1 slide with table)
10. 5-year line item budget forecast (1 slide with table )
11. 5-year program budget forecast (1 slide with table – )
12. Conclusion (1 slide )