NURS 6211 Walden University Health Care Budget Case Study
NURS 6211 Walden University Health Care Budget Case Study
Finalize your Healthcare Budget Request by completing the following:
Part 1: Financial Statement Calculations and Analysis:
Open your Excel Assignment Workbook and navigate to the “W10/11A6 Financials” worksheet.
You have 2 Options for completing this Assignment as noted in the Excel Assignment Workbook.
- Using the Healthcare Budget Request Guide for guidance, conduct analyses as directed on either your organization’s financial statements or those provided in the HealthWays Financial Statements worksheet. Your analysis will include spreadsheet calculation of financial statement ratios.
ORDER NOW FOR COMPREHENSIVE, PLAGIARISM-FREE PAPERS
Part 2: Summary of Analyses and Interpretation of Results:
Create a brief (1- to 2-page) description of your analyses. Be sure to address the following in your summary:
- Describe the results of each statement analysis. What do the results of each analysis mean?
- What does your complete financial statement analysis suggest about the financial health of the organization?
- If using your current organization’s data, does your analysis help describe any observed organizational behaviors or actions? Explain.
- What assumptions have you made in your analyses?
- What implications do these analyses have for your proposed healthcare product or service?
- Part 3: Summary of Work and Final Healthcare Budget RequestCompile and summarize your work in previous assignments. Place your final work on the Healthcare Budget Request template. Your final Healthcare Budget Request should include:
- A final version of your Executive Summary
- A final version of your projected expenses and revenues
- A product/service budget for the launch and the first 5 years
- A summary of financial and SWOT analyses that you conducted, including your interpretation of the results
UNFORMATTED ATTACHMENT PREVIEW
Table 1. HealthWays Clinic, Monthly Expense Budget Report, June 2018. Item June 2018 May 2018 Budget Actual Difference Actual 1.0 1.0 0 1.0 3.0 3.0 0 3.0 Physician FTE Nurse PractitionerFTE Encounters: Established patients 275 291 New patients 25 18 Total encounters 300 309 Expenses: Physician Salaries & Benefits $10,500 $10,502 NP Salaries & Benefits $20,000 $20,992 Clerical (2 FTE) Salaries & Benefits $6,667 $6,771 Total personnel expense 37167 38264 Medical supplies $7,500 $8,136 Office supplies $623 $583 Rent $2,917 $2,917 Depreciation $333 $346 Capital Expenses $3,333 $3,480 Overhead $167 $167 Total non-personnel expense 14873 15628 Total health center expense 52040 53892 (16) 7 (9) (2) (992) (104) (1098) (636) 40 0 (13) (147) 0 (755) (1852) 286 27 313 $10,509 $20,191 $6,683 37383 $7,994 $508 $2,917 $346 $3,480 $167 15412