Hello, I need help with the financial data (which is in red on the instructions). I sent the background financial data and template that I have to use. I need you to complete me the template with appropriate data and also provide me the spreadsheet data calculations in Excel , because I have to add it to the project as well. I need it for Friday February 12 at 5pm and I would like your help. Tell me your suggested price and if you can manage it. This project cost a large part of the final grade and I want to pass, please, need your help.

Background and Financial Data for Investment in the Rural Urgent Care Center Background Urgent care is the delivery of ambulatory care in a facility dedicated to the delivery of unscheduled, walk-in care outside of a hospital emergency department. Development of the Rural Urgent Care (RUC) facility will facilitate access to care providers through extended service hours within closer geographic proximity to patients, families, and caregivers. The Director of Emergency Services will provide clinical monitoring to ensure quality service provisions. The RUC facility will act to alleviate demand for emergency department (ED) services by shifting lower acute patients to a less resource-intensive environment. I. Market Opportunities and Utilization Patterns The RUC will provide treatment to patients suffering from non-life-threatening conditions that require quick attention, including bone fractures, pneumonia and flu, and minor lacerations. Since the late 1980s and early 1990s, hospitals have looked to facilities such as RUCs as a means to reduce rates of inappropriate ED utilization by triaging non-emergent patients to less acute settings. The ED is not the most appropriate care setting for many patients. Non-urgent patients account for well over 10 percent of the average ED's caseload, and semi-urgent cases account for another 20 percent (refer to Figure 1)1. At the other end of the acuity spectrum, most emergent patients would be better served in an inpatient unit, but many are forced to board in the ED because beds are unavailable. Figure 1 1 Centers for Disease Control, National Hospital Ambulatory Care Survey. Advisory Board Company. Washington, D.C. 2015 Laureate Education, Inc. Page 1 of 10 Triaging patients to an appropriate site of care properly allocates resources to meet patient acuity and results in better clinical outcomes. RUC staffing and treatment approaches are fundamentally different from those in an ED; patients get more abbreviated and pointed clinical work-ups, which provides care more efficiently by clinicians who are oriented to less intense discovery and intervention. The RUC will also address community needs for convenient, reliable access to care. Current alternatives to RUCs include the ED, which like other comparable U.S. and U.K. EDs, has long wait times and potentially stressful patient environments. Decreasing wait times is positively correlated with better outcomes. Figure 2 Services To meet the needs of the community and provide the appropriate level of care without unnecessary duplication of a resource-intensive emergency department, the RUC will provide basic emergent procedures, diagnoses, and treatments. Nursing triage Physician assessments Minor procedures Basic lab services Basic diagnostic imaging Vital signs IV therapy EKG Wound care The potential to house ambulance services out of the RUC provides additional requirements and opportunities. To accommodate the needs of the EMS crew, multiple waiting room/bunk rooms will be added to the facility, as well as a separate entry point for the ambulance service. Supplies will also be warehoused at RUC for easy restocking of ambulances. The RUC can also be part of the disaster-planning strategy by providing easy access to needed equipment and supplies during emergencies. 2015 Laureate Education, Inc. Page 2 of 10 Other Potential Offerings The RUC could offer opportunities to leverage the convenient retail setting to provide additional revenue-generating clinical services. For example, Occupational Safety Testing could be provided utilizing a secure bathroom to provide basic drug testing. Currently, the service is offered at the hospital, but is much better suited for a freestanding center. The RUC's diagnostic lab and x-ray services could also be offered on a referral basis for local GPs, providing a more convenient location for these services than the hospital and creating greater access to care. Yearly Staffing Costs by Clinical Lead Model STAFFING FTE ED Physicians 2.0 Subtotal Benefits as Percentage of Salary Housing Allowance Total Wage and Salary Cost Salary $ 200,000 $ 20% $ 48,000 $ 528,000 Hourly Rate Subtotal Travel Allowance Housing Allowance Total Wage and Salary Cost Total Hours $ 120 Locum Tenens Physicians 60 $ $ $ $ 470,400 Nurse Practitioners 2015 Laureate Education, Inc. Total $ 374,400 374,400 24,000 96,000 FTE Subtotal Benefits as Percentage of Salary Total Wage and Salary Cost Total $ 400,000 400,000 2.0 $ Salary $ 100,000 Total $ 200,000 200,000 20% $ 240,000 Page 3 of 10 Staffing Model per Shift Position Clinical Lead Nurse Physician Assistant Radiology Technician Medical Assistant/Receptionist FTEs 1.0 1.0 1.0 1.0 1.0 Facility Facility design must meet the needs of clinicians and consumers. Consumers invariably associate the quality of healthcare services with the aesthetics of the site of care. The facility will be designed to blend into the local architecture to be a part of both the eastern and western communities. The RUC will have the following basic space layout: Facility Description Space Description Central nursing/Physician station Exam rooms Treatment room Radiology room Staff offices Reception/waiting area Employee break room Medical records Laboratory Restrooms EMS facilities Utility rooms Quantity Square Feet Per Room 1 500 5 100 1 150 1 200 2 100 1 400 1 250 1 250 1 200 3 50 2 80 2 150 Subtotal Usable Sq. Ft. Circulation, mechanical, telecom/IT, other space 500 500 150 200 200 400 250 250 200 150 160 300 3260 915 Total Facility Size 2015 Laureate Education, Inc. Total Space 4,175 Page 4 of 10 Operating Model The RUC will open after the normal working hours of local physicians. These operating hours also align with the peak ED visit times, which significantly trail off after midnight. II. Market Profile Market Overview Define your service area. RUC Service Area Area Number of people in the RUC service area Total 3 years ago 64,009 2 years ago 1 year ago 64,209 64,395 Demand Forecasting Adjusted Demand of Services Forecast Service Area Visits Year Month Week Day 2015 Laureate Education, Inc. Year 1 Year 2 Year 3 Year 4 Year 5 4,882 407 94 13.4 4,914 410 95 13.5 4,946 412 95 13.6 4,979 415 96 13.6 5,012 418 96 13.7 Page 5 of 10 III. Financial Analysis Capital Requirements To estimate the total funds required for launch prior to commencement of operations, the hospital has developed the following assessment of anticipated expenses related to the building of a single RUC with 3,260 sq. ft. of usable space and 4,175 gross sq. ft., as described in an earlier section relating to facility design and a basic review of expected equipment costs. Capital Requirements per RUC Site Total Construction Cost $ 3,246,605 Contingencies, Professional Fees, Management & Overhead, Equipment $ 2,216,341 Total Project Costs Construction Costs per Square Foot Project Costs per Square Foot Square Footage $ 5,462,946 $ 777.63 $ 1,308.49 4,175 Reimbursement Model The RUC will charge a flat per-visit fee of $262, based on similar current hospital ED visit charges. This averages the costs of Level 1-Level 3 visits, with expected fee growth of 5%. The reimbursement would remain consistent with similar visits at the current ED, thus local payers should be willing to accommodate the fee. Break-Even Analysis per RUC Site Revenue per Case Cost per Case Contribution Margin $ $ $ 262.01 13.47 248.54 Direct Costs Indirect Costs Total Costs $ $ $ 1,914,607 118,840 1,976,647 Pro Forma 2015 Laureate Education, Inc. Page 6 of 10 Services Offered Nursing Triage Physician Assessments Potential Diagnoses Services Common illness Respiratory illness Allergies Bladder infections Eye/ear/sinus infection Strep throat Mononucleosis Pregnancy testing Skin rashes Sport injuries/sprains/strains Emergency transfer to KEMH Vital signs IV therapy (antibiotic, hydration) EKG Wound care Immunizations, TD, Pneumovax, Flu Vaccines Minor procedures Incision and draining of abscess Excision of skin Aspiration of cyst Sutures Lab services Blood Urine Other Diagnostic imaging 2015 Laureate Education, Inc. Ultrasound X-ray Page 7 of 10 Operating Model Phased Operating Hours Phase I Phase II Phase III Monday- Friday Hours Saturday & Sunday Hours Hours of Operation per Week Total Operating Hours Phase IV 8 16 20 24 10 16 20 24 5 PM-1AM (M- F) 10AM-8 PM (Sat. & Sun) 60 112 140 168 Financial Analysis Detailed RUC OPERATING HOURS Monday-Friday Hours Saturday & Sunday Hours Hours of Operation per Week Total Operating Hours REVENUE 8 10 5PM-1AM M-F 10AM-8PM Sat. & Sunday 60 FORECASTED VOLUME 4, 881.84 Adjusted Demand Forecast Visits per Month 406.82 Visits per Week 93.88 Visits per Day 13.37 PATIENT REVENUE Payer Reimbursement Fee per Visit $ 1,279,043 $ 262 ADJUSTMENTS Government Grant 2015 Laureate Education, Inc. $ 820,155 Page 8 of 10 $ 2,099,197 Total Revenue RUC STAFFING Physicians Nurses Physician Assistants Radiology Technicians Medical Assistants/Receptionists Medical Director IT Support Subtotal FTE 2.0 2.0 2.0 2.0 Salary Total $ 200,000 $ 400,000 $ 80,000 $ 160,000 $ 80,000 $ 160,000 $ 63,000 $ 126,000 2.0 $ 55,000 1.0 0.5 $ $ 25,000 $ 80,000 $ $ 1,021,000 Benefits as Percentage of Salary Housing Allowance Total Wage and Salary Cost $ 110,000 25,000 40,000 20% $ 48,000 $ 1,273,200 OCCUPANCY COSTS Utilities Repair/Maintenance Housekeeping $ 208,750 $ 40,500 $ 20,000 Communication Internet Telephone Service Miscellaneous/Other Total Occupancy Costs SUPPLIES Variable Medical Supply Costs 2015 Laureate Education, Inc. $ 240,000 $ 16,806 $ 20,000 $ 546,056 $ 65,767 Page 9 of 10 Other Non-Personnel Costs Total Supply Direct Operating Expense $ 95,351 $ 161,119 $ 1,980,375 INDIRECT EXPENSE Management Overhead Total Expense Costs per Visit Operating Income 2015 Laureate Education, Inc. $ 118,822.49 $ 2,099,197 $ 430 PROFITABILITY $ - $ s - Page 10 of 10 Final Project: Business Plan Business planning is a mapping of your vision for the future of an organization. As a health care administrator, it is important that you are able to create an effective business plan. For this Assignment, you examine the following scenario and develop a business plan for the organization. Scenario: A city-based community hospital is looking at adding an urgent care facility in a rural area. Urgent care is the delivery of ambulatory care in a facility dedicated to the delivery of unscheduled, walk-in care outside of a hospital emergency department. Development of the Rural Urgent Care (RUC) facility will facilitate access to care providers through extended service hours within closer geographic proximity to patients, families, and caregivers. RUC will act to alleviate demand for emergency department services by shifting lower acute patients to a less resource-intensive environment. This project is in response to the shift from volume- to value-based health care. Payers and purchasers are interested in improving economic efficiency by shifting utilization from emergency department to lower cost settings, such as RUC. Several competing hospitals have hired emergency department physicians, as part of their integration strategy to participate in accountable care organizations (ACO) contracts. The hospital needs to respond to the competitive situation by making a sound investment in the RUC facility that addresses both financial and economic situations. The facility will be staffed with physicians and will include a radiology suite, laboratory suite, and other health-related ventures to help the hospital grow. You must help the board develop a business plan for this urgent care unit. To prepare for this Final Project: Examine the provided scenario. Refer to the document \"Background and Financial Data for Investment in the Rural Urgent Care Center\" in this week's Learning Resources. Analyze the background and financial data for the RUC facility. The Final Project Assignment: Using the \"Rural Urgent Care Centers Business Plan Template\" document in this week's Learning Resources, create a business plan (8-10 pages) that includes the following: Executive summary Market analysis, including: o Macro- and microeconomic implications of market competition o ACO payment incentives to the organization o How the RUC impacts economic efficiency 2 Financial analysis, including: o Capital requirements o Reimbursement model o Cost per patient visit o Pro forma, including: Patient revenue Operating expense Income from operations Total expense Net cash flow Note: You must support your business plan with financial documents in an Excel spreadsheet. The 8to 10-page paper requirement, submitted as a Word document, does not include the title, Excel spreadsheet, or reference pages. Your Assignment must be written in standard edited English. Be sure to support your work with specific citations from this module's Learning Resources and additional scholarly sources as appropriate. Refer to the Essential Guide to APA Style for Walden Students to ensure that your in-text citations and reference list are correct. See the rubric for additional requirements related to research and scholarly writing. Your Final Project is due by Day 7. Rural Urgent Care Centers Business Plan Template I. Executive Summary: II. Market Analysis: Discuss how economic principles presented throughout the course relate to investment in the Rural Urgent Care Center (RUC), including the following: a. Macro- and microeconomic implications of market competition b. ACO payment incentives to the organization c. How the RUC impacts economic efficiency III. Financial Analysis: Capital Requirements To estimate the total funds required for launch prior to commencement of operations, RUC has developed the following assessment of anticipated expenses related to the building of a single urgent care facility with 3,260 sq. ft. of usable space and 4,175 gross sq. ft. Capital Requirements RUC Site Total Construction Cost Contingencies, Professional Fees, Management & Overhead, Equipment Total Project Costs $ $ $ Reimbursement Model The RUC will charge a flat per-visit fee of $262, based on similar current hospital ED visit charges. This averages the costs of Level 1-Level 3 visits, with expected fee growth of 5%. The reimbursement would remain consistent with similar visits at the Emergency Department, thus local payers should be willing to accommodate the fee. Break-Even Analysis for RUC 2015 Laureate Education, Inc. Page 1 of 3 Revenue per Case Cost per Case Contribution Margin Direct Costs Indirect Costs Total Costs Break-Even Quantity (Visits) Cost per Patient Visit Cost per Patient Visit $ RUC Pro Forma A Pro Forma has been generated for each RUC based on proposed Phase I operating hours (both revenue and expenses will change significantly for additional phases). RUC Pro Forma RUC Line Item Patient Revenue Gross Revenue Government Grant Net Operating Revenue1 Operating Expense Salaries and Benefits NET CASH FLOW ANALYSIS Year 1 Year 2 Year 3 Year 4 Year 5 Variable Care Related Expenses Other Non-Personnel Costs Occupancy Costs Repairs & Maintenance 2015 Laureate Education, Inc. Page 2 of 3 Housekeeping Communications Miscellaneous Direct Operating Expense2 Income from Operations3 Indirect Expense4 Total Expense5 Net Cash Flow6 2015 Laureate Education, Inc. Page 3 of 3