Healthcare Business Operations Executive Project Management Research Paper

Develop a spreadsheet that address a hypothetical poorly run Critical Access Hospital with the below elements. Hypothetical business workflow data is highly suggested to build a business case. Please also ensure that you have 12month worth financials of in your spreadsheet and address the below:
o (1) Net Days in Accounts Receivable; (2) Gross Days in Accounts Receivable; (3) Days Cash in Hand; (4) Total Margin; (5) Operating Margin; (6) Debt Service Coverage, (7) Salaries to Net Patient Revenue; (8) Medicare Inpatient Payor Mix; (9) Average Age of Plant; (10) Long Term Debt to Capitalization
o Produce a (1) Pareto Chart; (2) FEMA analysis; (3) 5-Whys analysis; (4) Fishbone Diagram

• GRADED ITEM #2: Executive Dashboard. Please use spreadsheet to create a dashboard (linked to your data) that shows how this rural hospital should track its financial health for staff. The director is also concerned with viewing how you are addressing many KPIs and metrics for at least 8 departments. Show how the data supports the below:
o (1) Efficiency in care; (2) Decreasing HIPAA issues and breaches; (3) Increasing patient satisfaction (reports and surveys); (4) Decreasing the no-show rate; (5) Increasing BH in primary care; (6) National Patient Safety Goal adherence

• GRADED ITEM #3: In a 15 page paper, with at least 10 peer reviewed references, provide a comprehensive business case analysis on this company. Include information from the spreadsheet and Dashboard in Graded items 1&2. The title page, reference page, and ANNEXES (charts/graphs/figures) are not included in the 15 page APA format final project paper. Your excel spreadsheets showing calculations will also be turned in at the same time as submitting your paper. Within your 15 page paper, ensure that you address these concepts to demonstrate to the Director that you are meeting his vision and values for the company for a cultural change:
o (1) Creativity and Innovation; (2) Partnering; (3) Human Capital Management; (4) Leveraging Diversity; (5) Corporate Perspective; (6) Team Building; (7) Accountability; (8) Decisiveness; (9) Resilience; (10) Flexibility; (11) Lead Programs; (12) Financial Management
• GRADED ITEM #4: Recommend a Project to be completed based off the first Graded Items above. After you have gathered your data, created the dashboard, and written your assigned paper, you will need to create the below You should reference the recommended project in the paper. Place each of the below in an ANNEX:
o Recommended Project Scope: Include a Work Breakdown sheet (see example)
o Recommended Deliverables: Include specification sheets (see example)
o Recommended Milestone Chart or Tables: (see examples)
o Recommended Budget: Include a Cost Breakdown sheet (see example)
o Recommended Quality Plan (QA)(QC) – (see example)
o Recommended Schedule: Include a Gantt chart or Network Chart (see example)
o Recommended Resourcing this project: Organizational Breakdown sheet, LRC and RACI (see example)
o Recommended Communication Plan: Include a Stakeholder Communication Plan (see example)
o Recommended Governance Structure: Include how processes will be collected and data collection (see ex)
o Recommended Risk Register: Include SWOT/Root Cause Analysis/Probability and Impact/ Risk Register (ex)