Answered step by step
Verified Expert Solution
Question
1 Approved Answer
. For 2018, develop a statistical budget using regression analysis; then develop a revenue budget (using a financial model, determine whether to increase charges
. For 2018, develop a statistical budget using regression analysis; then develop a revenue budget (using a financial model, determine whether to increase charges found in Table IV-C and if so, how much) and then develop an expense budget using the staffing found in Table VI-B, in statement of operations format including detailed footnotes explaining any changes in the numbers. I would like to see at least four different expense scenarios: (1) Maintain expenses at 2017 levels after adjusting for volumes and mandated expenditures identified in earlier steps (2) Maintain expenses at 2017 levels after adjusting for volumes and mandated expenditures identified in earlier steps and honoring all requests (i.e., raises, additional personnel, etc.) (3) Cut expenses (from expense scenario 1) to break even in 2018 (4) Cut expenses (from expense scenario 1) to break even in 2018 and recover fiscal year 2017 losses TABLE VI-B Hays County IDS Staffing Department Chief Executives Administrators Below Chiefs Medical Records Dietary housekeeping Laundry physical Plant Nursing Laboratory Radiology Respiratory Therapy Physical Therapy Emergency Department Physicians 9 50 10 35 25 * 4 500 20 10 5 * FTES = full-time equivalent employees *contract 84% RNs, 10% Nursing Assistants, 5% Head Nurses, 1% Clerks
Step by Step Solution
★★★★★
3.41 Rating (160 Votes )
There are 3 Steps involved in it
Step: 1
A multistep procedure comprising regression analysis for the statistical budget income budgeting and several spending scenarios is usually followed to create a complete budget for 2018 Ill provide the ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started