unit 2 individual project quot chief administrator of uptown clinic quot 501331

Unit 2 Individual Project
Deliverable Length: Excel Spreadsheet and 4-5 body pages
Details: Consider the following scenario:
the Chief Administrator of Uptown Clinic, a community mental health agency, is concerned about the dilemma of coping with reduced budgets next year and into the foreseeable future but increasing demand for services. To plan for reduced budgets, she must first identify where costs can be cut or reduced and still keep the agency functioning. Below are some data from the past year.

Program Area
Costs
Administration
Salaries:
Administrator
$60,000
Assistant
$35,000
Two Secretaries
$42,000
Supplies
$35,000
Advertising and promotion
$9,000
Professional meetings/dues
$14,000
Purchased Services:
Accounting and billing
$15,000
Custodial
$13,000
Security
$12,000
Consulting
$10,000
Community Mental Health Services
Salaries (two social workers)
$46,000
Transportation
$10,000
Outpatient mental health treatment
Salaries:
Psychiatrist
$86,000
Two Social Workers
$70,000
In an Excel spreadsheet:
Provide a dollar range of costs to reduce budgets (worst and best case analysis).
She needs to cut $94,000 in cost. Prioritize those cuts that can be made without impacting the operation or quality care of the organization.