Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

Excel Spreadsheet and 4-5 body pages Points Possible: 125 Due Date: 8/1/2010 11:59 PM CT Consider the following scenario:

Excel Spreadsheet and 4-5 body pages Due Date: 8/1/2010 11:59:59 PM CT 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 CostsAdministrationSalaries:Administrator $60,000Assistant $35,000Two Secretaries $42,000Supplies $35,000Advertising and promotion $9,000Professional meetings/dues $14,000Purchased Services:Accounting and billing $15,000Custodial $13,000Security $12,000Consulting $10,000Community Mental Health ServicesSalaries (two social workers) $46,000Transportation $10,000Outpatient mental health treatmentSalaries:Psychiatrist $86,000Two Social Workers $70,000Provide 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. 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.I do not understand this assignment and you give me the name of the resources please

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question