Purchase Solution

Budget and Sensitivity Analysis

Not what you're looking for?

Ask Custom Question

Dr Stephanie White the chief Administrator of Uptown Clinic ,a community mental health agency, is concerned about the the dilemna of coping with reduced budgets next year and into the foreseeable future ,but increasing demand for services. In order to plan for reduced budget ,she must first identify where costs can be cut or reduced and still keep the agency functioning.

Program area and costs :administrator =$60,000;assistant=$35,000;two secretaries=$42,000;supplies=$35,000;advertising and promotion=$9,000;professional meetings/dues=$14,000. Purchases services:accounting and billing=$15,000; custodial=$13,000; security=$12,000;consulting=$10,000 .Community mental health services:Salaries(2socialworkers)=$46,000; transportation=$10,000. Outpatient mental health treatment :salaries: psychiatrist=$86,000;2 social workers=$70,000.

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

2-You need to cut $94,000 incost .Prioritize those cuts that canbe made without impacting the operation or quality care of the organization.

3-How would you advise Dr White to prepare for reduce budgets.

Purchase this Solution

Solution Summary

The solution includes a word document and an excel sheet that show calculations and address the problem requirements and explain the difference between discretionary and committed costs.

Solution Preview

Please see the attached sheets for a better formatted solution

To be able to answer the questions and decide on costs that could be cut, we must divide costs into discretionary and committed costs. Discretionary Fixed Costs (also known as Managed Fixed Costs) usually arise from annual decisions by management to spend in certain fixed costs. There are basically 2 differences between Discretionary and Committed Fixed Costs; 1) The planning horizon for Discretionary Fixed Costs is fairly short-term, usually a single year; and 2) Discretionary Fixed Costs can be cut for short periods of time with minimal ...

Solution provided by:
Education
  • BA, Ain Shams University, Cairo Egypt
  • MBA, California State University, Sacramento
Recent Feedback
  • "ty i have more need help with"
  • "ty i have jmore i need help with"
  • "great help"
  • "excellent help"
  • "Very helpful and easy to understand."
Purchase this Solution


Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Motivation

This tests some key elements of major motivation theories.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.