Vikas

Budgeting

Individual Project   Deliverable Length: Excel Spreadsheet and 4-5 body pages    
 Plse include an Abstract

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
1.	Provide a dollar range of costs to reduce budgets (worst and best case analysis). 
2.	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. 
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:
•	Describe how managerial accounting is different from cost accounting. 
•	Describe the lean production philosophy. 
•	Compare and contrast accounting principles in lean production to those of typical production. 
•	Describe how you would advise Dr. White to prepare for reduced budgets

Business Management Assignment Help, Business Management Homework help, Business Management Study Help, Business Management Course Help
Answered
Other / Other
01 Feb 2016

Answers (1)

  1. Vikas

    Budgeting

    In the present case, the Chief Administrator of Uptown ****** ******
    To see full answer buy this answer.
    Answer Attachments

    2 attachments —

    • img
      Budgeting204356.doc
    • img
      Budgeting204357.xls

Report As Dispute

Share Your Feedback

Give Review : A+ A B C D F