. For 2018, develop a statistical budget using regression analysis; then develop a revenue budget (using...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
. 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 . 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
Expert Answer:
Answer rating: 100% (QA)
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 the full answer
Related Book For
Applied Regression Analysis and Other Multivariable Methods
ISBN: 978-1285051086
5th edition
Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg
Posted Date:
Students also viewed these accounting questions
-
Listed below are amounts (in millions of dollars) collected from parking meters by a security service company and other companies during similar time periods. Do the limited data listed here show...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Why do you think many people might be skeptical about psychology being a science?
-
In Figure a broad beam of monochromatic light is directed perpendicularly through two glass plates that are held together at one end to create a wedge of air between them. An observer intercepting...
-
Name the six components of an IS.
-
A common-size income statement for Liberty would report (amounts rounded) a. Net income of \(16 \%\) b. Cost of sales at \(36 \%\) c. Sales of \(100 \%\) d. All the above
-
Rockwall RV Centers accounting records include the following accounts at December 31, 2016. Cost of Goods Sold............$ 368,000 Accounts Payable............ 20,000 Rent Expense..................
-
As we advance in your career, you will encounter different types of problems, such as complaints, conflicts, and mistakes. In order to address the problem effectively, we need to understand and know...
-
A shaft is to be designed to support the spur pinion and helical gear shown in the figure on two bearings spaced 700 mm center-to-center. Bearing A is a cylindrical roller and is to take only radial...
-
Need to answer quickly, please use Excel to answer questions, and calculate accurately and in detail. For the exact answer, I will click and give a thumbs up. thank you Gogba, is a former...
-
Use Euler's method to obtain numerical solutions on the specified time interval for step sizes h = 0.1, h = 0.05, and h = 0.025. (b) Solve the problem analytically and plot the exact solution and the...
-
[The following information applies to the questions displayed below.] Jorgensen High Tech Incorporated is a calendar-year, accrual-method taxpayer. At the end of year 1, Jorgensen accrued and...
-
Robbie Hunter, a famous South African cyclist trains for his next cycle race. He cycles 7 2 km in a direction 7 5 degrees west of south, then 4 6 km 6 0 degrees west of north, and from there 9 7 km 5...
-
The following data pertain to costs at Upside Company: Total fixed costs Total variable costs $330,000 $77,000 Production level The variable cost per unit is OA. $15.00 OB. $18.50 C. $11.50 OD. $3.50...
-
Tesla How effective has the company been in using its assets? How effective has the company been in generating returns to its shareholders? What has been the main driver of the returns to...
-
Outline the key components of policies in place for protecting confidential and private business information and intellectual property in data assets, including: privacy policies security policies ...
-
Element compound homogeneous mixture (heterogeneous mixture) 4) A piece of gold has a mass of 49.75 g. What should the volume be if it is pure gold? Gold has a density of 19.3 g/cm (3 points) D=m/v...
-
A company wants to compare three different point-of-sale promotions for its snack foods. The three promotions are Promotion 1: Buy two items, get a third free. Promotion 2: Mail in a rebate for $1.00...
-
Trough urine samples were analyzed for sodium content for each of two collection periods, one before and one after administration of Mercuhydrin, for each of 30 dogs. The experimenter used 7 dogs as...
-
a. P(X27 ?) = .01 b. P(X212 14) = ?
-
Which of the following questions would an auditor ask while auditing accounts receivable to add value to an audit? a. Are accounts receivable pledged? b. Are customers satisfied with your billing...
-
What are some inquiries an auditor can make when examining the long-term debt account to add value to the audit?
-
Beta, Inc., is an affiliate of an audit client and is audited by another firm of auditors. Which of the following is most likely to be used by the auditor to obtain assurance that all guarantees of...
Study smarter with the SolutionInn App