managerial accounting dr stephanie white 498855

Dr. Stephanie White, is concerned about the dilemma of coping with reduced budgetsd and demand for services. In order to plan for reduced budgets, she must first identify where costs can be cut or reduced and still keep the agency functioning. Below data from past year.
Program Area Costs Administration Salaries: Administrator 60,000 Assist 35,000 2 Secretaries 42,000 Supplies 35,000 Advert & promotion 9,000 Professional meetings/dues 14,000 Purchased Services:Acct & bill 15,000 Custodial 13,000 Security 12,000 Consulting 10,000 Community Mental Health Services Salaries (two s w) 46,000 ;Trans 10,000 Outpt mental health tx Salaries:Psychiatrist 86,000 2 SW 70,000

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

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

c.How would you advise Dr. White to prepare for reduced budgets? excel spread sheet