Uptown Clinic Cost Management: Using Excel for budgeting and cost reductions

See attached file.

Please explain how costs can be cut and still keep the clinic up and running.

What and how would you use excel and what formulas.

I am the Chief Administrator of Uptown Clinic, a community mental health agency, I am concerned about the dilemma of coping with reduced budgets next year and into the foreseeable future, but increasing demand for services. In order to plan for reduced budgets, I must first identify where costs can be cut or reduced and still keep the agency functioning

Here is some data from the past year…
© BrainMass Inc. brainmass.com March 21, 2019, 11:40 am ad1c9bdddf
https://brainmass.com/business/business-management/uptown-clinic-cost-management-using-excel-for-budgeting-and-cost-reductions-47688
Attachments

I am the Chief Administrator of Uptown Clinic.doc

Solution Preview

See attached Excel file.

1. Give a dollar range of costs to reduce budgets (worst and best case analysis).

Worse case for Uptown Clinic is $363,000 and the best case for the health agency is $457,000. The worse case is when the entire amount that is $94,000 needs to be deducted from the current budget that is $457,000.

1. I need to cut $94,000 in cost. Prioritize those cuts that can be made without impacting the operation or quality care of the organization.

Please note that there are two …