Question: . 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 TABLE VI-B Hays County IDS Staffing Department Chief Executives Administrators Below Chiefs Medical Records

. 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

1 Expert Approved Answer
Step: 1 Unlock

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 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!