Budgeting class question

file1.docx

Home >Business & Finance homework help >Accounting homework help >Budgeting class question

Budget Preparation using Excel

Scenario and Background Information

Community Services Department

The Community Service Department delivers a significant portion of the services and programs rendered directly to the residents of the City of Anytown, California. The Department spearheaded by the Director, with the support from the Senior Administrative Analyst and the Administrative Secretary. The Director ensures that all services and programs provided by the Department deliver on the Department’s core values, vision, brand promise and mission to proactively and productively meet the social and recreational needs of Anytown’s diverse community. In addition to supporting each division’s overall goals and objective in 2019-2020, the Director’s initiatives will encompass stabilizing staffing levels, developing department pricing policies and enhancing computerized registration and reservations. The Department will take the lead on events and activities that celebrate the City of Anytown’s 50th anniversary. The Community Services department is comprised of three divisions: The James Brown Community Center, Transportation, and Recreation and Human Services.

The James Brown Community Center

The community Center Division is responsible for venue services, events, and programs, and provides catering through Good Food Catering Services. The Division oversees the 10,000 square foot Community Center and is comprised of sales and operations sections to ensure the entire facility is utilized to its maximum potential. Directed public relations efforts, careful planning, aggressive sales programs, and efficient operating procedures are combined to produce optimum revenues.

Fiscal Year 2019-2020 Goals

· Attend four trade shows marketing the Community Center to increase the number of paid booking by 15%.

· Schedule, coordinate and enhance City-Sponsored meetings and events.

· Work in conjunction with the Information Technology Department to update, improve and enhance the Community Center website.

Organizational Chart

City Parks

Veterans Sports Complex

Events Transportation

Anytown Shuttle

Shuttle

Rentals

Community Events

Transportation

Recreation & Human Services

Community Center

Department Administration