Strategic Plan line graph
I need someone who is proficient in graphs/ statistic nursing,here are the figures to use.I JUST NEED A LINE GRAPH THANKS.
The objective is to create a line graph for the following information:
Volumes projected in this area for the first year are 1275 patient days (or visits). With physician support and effective marketing, it is expected that the volume will increase 10% the second year, 14% the third year, and 20% the fourth year. The financial goal of this project is to break even by the end of the third year of operations.
For payroll, merit increases and overtime hours should be computed at 5% each. Use the salaries and benefit data from you’re your current knowledge of your local market or assume average hourly rate for the Registered Nurse is $28/hour and assistive personnel hourly rates at $9/hour. Benefit costs can be estimated at 25% of hourly rates.
Expected revenue is calculated at $4864 per case for the first year. The payer mix for this facility is: Medicare 37.9%; Medicaid 4.5%; Managed Care (HMO/PPO) 38.8%; Private Pay 6%; other insurance 10.6%; Worker's Comp 2.2%.
7 years ago
15
Purchase the answer to view it

- UpdatedAnswer.xlsx
- Marketing
- SCI 250 Week 1 Identifying Bacteria
- Please consider the data presented above for the monthly sales of Ever-cool brand of refrigerators in 1,000s of
- Service records in a used car dealership show that for every 100 cars sold, 30 cars breakdown in
- Discussion—Social Stratification
- Need Help!! Review for Exams
- needed in 7 hours from now. dont text me if you can't do it.
- Creative instructor
- NRS-437V Module 3 Applying Ethical Frameworks in Practice - Using "Bioethics on NBC's ER:......
- essay