Consider the following scenario:
Dr. Stephanie White, 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:
For more information on creating Excel Spreadsheets, please visit the Excel Lab.
In addition to the Excel spreadsheet required to support your responses, you must prepare an APA formatted paper that will address the following:
Submitting your assignment in APA format means, at a minimum, you will need the following:
Economic Debate- Progressive Income Tax For this Economic Debate, we are going to discuss the…
TOPIC: Going Global Discussion Thread 1 (initial post due Wednesday for full credit) Please note:…
Assignment Topic This week will culminate in the creation of a narrated PowerPoint to create…
The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted…
you need to post your 2-page information flier to share with your Final Project Group.…
discussion: Discuss the methods used at your company to measure and ensure quality products and…