Fluent Essays

Dr. Sole,I appreciate your help on spreadsheet. I read your recommendations and agree that I need to remove the years on the spreadsheet. Change your data, so that your numbers make more sense and you pay off the debt and balance the books earlier in the project. (RECOMMENDED). The expense and revenue numbers doesnt matter, then you can just change random figures around, balance it all and I can then just use what you give me.The next part of AssignmentConduct a financial analysis of the proposed healthcare product or service by completing the following:Part 1: Develop the Ratio Analyses Worksheet:Open your Healthcare Budget Request workbook that you created in the previous Assignment, and navigate to the “A5 Ratio Analyses” worksheet.Using the Healthcare Budget Request Workbook Step-by-Step Guide for guidance, create cost-benefit, break-even, marginal cost, and other analyses as directed for the product or service that you have proposed.NOTE: You will copy your worksheet and analysis onto the Healthcare Budget Request Template (Word document) for submission.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:When will your organization’s investment(s) in the healthcare product or service break even?What is the payback period?What assumptions have you made in your analyses?What do these analyses mean for your organization? filled___hcbr_template__1_.docx garrett_i_assn5part1.docx _revised__fresh_start___payback_period_calc_2.xlsx Unformatted Attachment Preview Healthcare Budget Request New Service Line for Patient Transportation Prepared by: Student Name Submitted: January 19, 2020 Executive Summary Nursing Shortage and the Cost of Recruitment The Introductory Paragraph with a clear purpose statement goes in this first paragraph. *Check for grammar and APA formatting because I will! Existing Practice and Problem Identification A clear, succinct description of the problem or gap goes in this paragraph. Include scholarly support as needed. Proposed Solution A clear, succinct description of the proposed solution goes in this paragraph. Include scholarly support as needed. Conclusion A short wrap up. The conclusion should not introduce any new ideas and should not need any citation. References Example, J (2017). Title of article: Be sure you format to APA standards. Health Research, 2 (2). Projected Expenses and Revenues (Five Year) ESTIMATED EXPENSES and ROI (US Dollars $) This worksheet presents the estimated expenses for the development, launch and maintenance of Nursing Shortage and the Cost of Recruitment. Also presented is a Return on investment (ROI) analysis. Expenses/Cost Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total Start up expenses Office Space 88,542.72 Equipement 132,814.08 Advertising 147,571.20 Payroll 472,227.84 Website 177,085.44 Total start up expenses ($) 1,018,241.28 Operating Expenses Personnel 230,400. 00 81,920.00 65,536.00 52,428.80 41,943.04 472,227.84 Equipement 64,800.0 0 23,040.00 18,432.00 14,745.60 11,796.48 132,814.08 Supplies 7,200.00 2,560.00 2,048.00 1,638.40 1,310.72 14,757.12 Marketing 28,800.0 0 10,240.00 8,192.00 6,553.60 5,242.88 59,028.48 Training 43,200.0 0 15,360.00 12,288.00 9,830.40 7,864.32 88,542.72 Total operating expenses ($) 374,400. 00 133,120.00 106,496.00 85,196.80 68,157.44 767,370.24 374,400. 00 133,120.00 106,496.00 85,196.80 68,157.44 1,785,611. 52 Appropriated funds 300,000. 00 300,000.00 300,000.00 300,000.00 300,000.00 1500000 Technology advancement 16,000.0 0 16,000.00 16,000.00 16,000.00 16,000.00 80000 Attrition 34,000.0 0 34,000.00 34,000.00 34,000.00 34,000.00 170000 Reduction in work space 40,000.0 0 10,000.00 8,000.00 8,000.00 9,000.00 75000 Total Revenue/savings ($) 390,000. 00 360,000.00 358,000.00 358,000.00 359,000.00 1825000 Total Expenses ($) 1,018,241.28 Revenue/Savings Return on Investment (\%) 4.17\% 1.7043269 2.3616286 23 06 Intro here tells the reader what this section is about. Startup Expenses 3.2020357 4.2672166 0.0220588 57 09 1826 The startup expenses, as seen in your Spreadsheet, are defined here. Operating Expenses The operating expenses, as seen in your Spreadsheet, are defined here. Revenue /Savings The revenue, as seen in your Spreadsheet, are defined here. Conclusion Your conclusion paragraph here. Projected Budget (Five Year) !!!!!!!!Budget Table Goes Here!!!!!! I suggest the following headings: Five-year budget for The five-year budget is shown above. Then give a synopsis of the budget. Possible Risks/Budget Variances Your paragraph on risks/variances. What does this budget mean to ? Paragraph “conclusion” what it means to your org. References Example, J (2017). Title of article: Be sure you format to APA standards. Health Research, 2 (2). Summary/Elevator Speech (PPT slides) This is not due until Week 11, DAY 2. ● ● ● Place your Summary/Elevator Speech here, using APA format. This does not need a Title page or Reference. It is you presenting your project, only hitting the “highlights” in a short speech. The PPT should be 2-3 slides copied on to this document with narrative notes below each slide. Use proper grammar please. Healthcare Budget Request Reducing Nursing Shortage by Increasing Recruitment Efforts Prepared by: Ivy Garrett Submitted: January 19, 2020 Executive Summary Nursing Shortage and the Cost of Recruitment The nursing shortage is one issue that is plaguing healthcare organizations globally. The nursing workforce is expected to grow from 2.9 million in 2016 to 3.4 million in 2026. There is a projection for an additional 203,700 new nurses each year through 2026 to fill newly created positions and to replace retiring nurses (Grant, 2016). Stakeholders, according to their focal point, can be organized into the following three groups: internal, external, and interface. Internal stakeholders are management and professional organizations, physicians. External stakeholders are legislators and competitors. Interface stakeholders either operate simultaneously inside and outside the perimeters of the organization, such as members of the hospital board, or work mainly outside those borders but influence the internal practices of the organization, such as professional associations, patients, and patient families (Kallio, Tevameri, & Vähätalo, 2018). The stakeholder groups that would be responsible for helping address the nursing shortage would be the American Nursing Association because the nursing profession’s task is to take care of patients and healthcare. Nurses’ Association contributes to writing collegiality guidance for nurses (ANA, n.d.). Existing Practice and Problem Identification Nursing shortages result in low morale among nurses, dissatisfaction, exhaustion, unnecessary work pressure, conflict with assignments, excessive and mandatory overtime work, stress during shifts and a resulting turnover. Health care agencies, due to excessive working hours, incur high human resources and financial costs; and these are correlated with sick leave, absenteeism, exhaustion and decreased productivity (Farahani, Oskouie, & Ghaffari, 2016). Proposed Solution To help decrease the nursing shortage, I propose to increase recruitment efforts by expanding the multimedia proposal to promote careers in nursing and enhance the image of nursing. This multimillion-dollar effort includes television commercials, a recruitment video, a Web site, brochures. Conclusion Feeling the financial stress, hospitals want to reduce their reliance on additional staffing. Hospital turnover is rising, and executives need to be concerned as this is a leading indicator of future financial pressure and satisfaction of patients and employees. References ANA. (n.d.). Nurse Staffing. Retrieved from American Nurses Association: https://www.nursingworld.org/practice-policy/nurse-staffing/ Farahani, M. A., Oskouie, F., & Ghaffari, F. (2016, 16 April). Factors affecting nurse turnover in Iran: A qualitative study. Retrieved from Medical Journal of the Islamic Republic of Iran: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4934483/ Grant, R. (2016, February 3). The U.S. Is Running Out of Nurses. Retrieved from The Atlantic: https://www.theatlantic.com/health/archive/2016/02/nursingshortage/459741/ Kallio, T. J., Tevameri, T., & Vähätalo, M. (2018, May 30). Nurses’ organizational roles— Stakeholders’ expectations. Retrieved from Professions and Professionalism: https://journals.hioa.no/index.php/pp/article/view/1973/2754 NSI Nursing Solutions, Inc. (2019). 2019 National Health Care. Retrieved from NSI Nursing Solutions, Inc: http://www.nsinursingsolutions.com/Files/assets/library/retentioninstitute/2019\%20National\%20Health\%20Care\%20Retention\%20Report.pdf Projected Expenses and Revenues (Five Year) ESTIMATED EXPENSES and ROI (US Dollars $) This worksheet presents the estimated expenses for the development, launch and maintenance of Nursing Shortage and the Cost of Recruitment. Also presented is a Return on investment (ROI) analysis. Expenses/Cost Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total Start up expenses Office Space 88,542.72 Equipement 132,814.08 Advertising 147,571.20 Payroll 472,227.84 Website 177,085.44 Total start up expenses ($) 1,018,241.28 Operating Expenses Personnel 230,400. 00 81,920.00 65,536.00 52,428.80 41,943.04 472,227.84 Equipement 64,800.0 0 23,040.00 18,432.00 14,745.60 11,796.48 132,814.08 Supplies 7,200.00 2,560.00 2,048.00 1,638.40 1,310.72 14,757.12 Marketing 28,800.0 0 10,240.00 8,192.00 6,553.60 5,242.88 59,028.48 Training 43,200.0 0 15,360.00 12,288.00 9,830.40 7,864.32 88,542.72 Total operating expenses ($) 374,400. 00 133,120.00 106,496.00 85,196.80 68,157.44 767,370.24 374,400. 00 133,120.00 106,496.00 85,196.80 68,157.44 1,785,611. 52 Appropriated funds 300,000. 00 300,000.00 300,000.00 300,000.00 300,000.00 1500000 Technology advancement 16,000.0 0 16,000.00 16,000.00 16,000.00 16,000.00 80000 Attrition 34,000.0 0 34,000.00 34,000.00 34,000.00 34,000.00 170000 Reduction in work space 40,000.0 0 10,000.00 8,000.00 8,000.00 9,000.00 75000 Total Revenue/savings ($) 390,000. 00 360,000.00 358,000.00 358,000.00 359,000.00 1825000 Total Expenses ($) 1,018,241.28 Revenue/Savings Return on Investment (\%) 4.17\% 1.7043269 2.3616286 23 06 3.2020357 4.2672166 0.0220588 57 09 1826 Intro here tells the reader what this section is about. Startup Expenses The startup expenses, as seen in your Spreadsheet, are defined here. Operating Expenses The operating expenses, as seen in your Spreadsheet, are defined here. Revenue /Savings The revenue, as seen in your Spreadsheet, are defined here. Conclusion Your conclusion paragraph here. Projected Budget (Five Year) !!!!!!!!Budget Table Goes Here!!!!!! I suggest the following headings: Five-year budget for The five-year budget is shown above. Then give a synopsis of the budget. Possible Risks/Budget Variances Your paragraph on risks/variances. What does this budget mean to ? Paragraph “conclusion” what it means to your org. References Example, J (2017). Title of article: Be sure you format to APA standards. Health Research, 2 (2). Summary/Elevator Speech (PPT slides) This is not due until Week 11, DAY 2. ● ● ● Place your Summary/Elevator Speech here, using APA format. This does not need a Title page or Reference. It is you presenting your project, only hitting the “highlights” in a short speech. The PPT should be 2-3 slides copied on to this document with narrative notes below each slide. Use proper grammar please. ESTIMATED EXPENSES and ROI (US Dollars $) This worksheet presents the estimated expenses for the development, launch and maintenance of Nursing Shortage and the Cost of Recruitment. Also presented is a Return on investment (ROI) analysis. Expenses/Cost 2020 2021 2022 2023 2024 2025 230,400.00 81,920.00 65,536.00 52,428.80 41,943.04 64,800.00 23,040.00 18,432.00 14,745.60 11,796.48 Start up expenses Office Space 88,542.72 Equipement 132,814.08 Advertising 147,571.20 Payroll 472,227.84 Website 177,085.44 Total start up expenses ($) 1,018,241.28 Operating Expenses Personnel Equipement Supplies 7,200.00 2,560.00 2,048.00 1,638.40 1,310.72 Marketing 28,800.00 10,240.00 8,192.00 6,553.60 5,242.88 Training 43,200.00 15,360.00 12,288.00 9,830.40 7,864.32 374,400.00 133,120.00 106,496.00 85,196.80 68,157.44 374,400.00 133,120.00 106,496.00 85,196.80 68,157.44 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 Technology advancement 16,000.00 16,000.00 16,000.00 16,000.00 16,000.00 Attrition 34,000.00 34,000.00 34,000.00 34,000.00 34,000.00 Reduction in work space 40,000.00 10,000.00 8,000.00 8,000.00 9,000.00 Total Revenue/savings ($) 390,000.00 360,000.00 358,000.00 358,000.00 359,000.00 Return on Investment (\%) 4.17\% 1.704326923 2.361628606 3.202035757 4.267216609 Total operating expenses ($) Total Expenses ($) 1,018,241.28 Revenue/Savings Appropriated funds d is a Return on investment (ROI) analysis. Grand Total 472,227.84 132,814.08 14,757.12 59,028.48 88,542.72 767,370.24 1,785,611.52 1500000 80000 170000 75000 1825000 0.022058818 Budget Development This worksheet presents the budget for the development, launch and maintenance of Nursing Shortage and the Cost of Recruitment. Also presented is cash fl Expenses/Cost 2020 2021 2022 2023 230,400.00 81,920.00 65,536.00 64,800.00 23,040.00 18,432.00 Start up expenses Office Space 88,542.72 Equipement 132,814.08 Advertising 147,571.20 Payroll 472,227.84 Website 177,085.44 Total start up expenses ($) 1,018,241.28 Operating Expenses Personnel Equipement Supplies 7,200.00 2,560.00 2,048.00 Marketing 28,800.00 10,240.00 8,192.00 Training 43,200.00 15,360.00 12,288.00 374,400.00 133,120.00 106,496.00 374,400.00 133,120.00 106,496.00 300,000.00 300,000.00 300,000.00 Technology advancement 16,000.00 16,000.00 16,000.00 Attrition 34,000.00 34,000.00 34,000.00 Reduction in work space 40,000.00 10,000.00 8,000.00 Total Revenue/savings ($) 390,000.00 360,000.00 358,000.00 Return on Investment (\%) 4.17\% 1.704326923 2.361628606 15,600.00 226,880.00 503,504.00 Total operating expenses ($) Total Expenses ($) 1,018,241.28 Revenue/Savings Appropriated funds Cash flow Payback Period* -1,018,241.28 2.00 Plus212k t of Recruitment. Also presented is cash flow and pay 2024 2025 Grand Total 52,428.80 41,943.04 472,227.84 14,745.60 11,796.48 132,814.08 1,638.40 1,310.72 14,757.12 6,553.60 5,242.88 59,028.48 9,830.40 7,864.32 88,542.72 85,196.80 68,157.44 767,370.24 85,196.80 68,157.44 1,785,611.52 300,000.00 300,000.00 1500000 16,000.00 16,000.00 80000 34,000.00 34,000.00 170000 8,000.00 9,000.00 75000 358,000.00 359,000.00 1825000 3.202035757 4.267216609 0.022058818 272,803.20 78,842.56 39,388.48 Take 212k *Payback Period Calculation Year 2020 Cash Flow ($) -1,018,241.28 2021 15,600.00 2022 226,880.00 2023 503,504.00 2024 272,803.20 2025 78,842.56 Period Calculation Net Cash Flow ($) -1,018,241.28 -1,002,641.28 -775,761.28 -272,257.28 545.92 79,388.48  ... Purchase answer to see full attachment