Week 4 assignment-MY PROPOSED SERVICE/PRODUCT(Mobile Crisis Team)
Excel spreadsheet
Estimates for startup expenses are only in year 0
Estimates for operating expenses and revenue are only in years 1,2,3,4,5
Salaries are only in Operating Expenses. You need to show merit increases for each year
you must include formulas for your calculations
You need totals in the grand total column and the total Expense line and total revenue/savings line in order to calculate ROI
you need to calculate ROI; the formula is embedded when you scan cell B26 and in your guide. ROI = (Total Revenue –Total expense) /Total Expenses
ROI is a % not $
Be sure your estimates are based on numbers you can provide references for
Part 2 Healthcare Budget Request
Section: W4/A3 Projected Expenses and Revenue (5 years)
You must post your Part 2 summary in the Healthcare Budget Request Template following the Executive Summary in Section: W4/A3 Projected Expenses and Revenue (5 years)
You must write in APA format which means paragraphs not lists, proper indentations, introduction with purpose statement, conclusion.
you need to provide references for your sources of estimates. You can use sources online, peer reviewed journals, or personal communication
I have provided resources in doc sharing and the announcements, that have some qualified resources for estimates for savings or cost avoidance. For example, readmissions.
You also need to provide details on how you made estimates. For example, based on the ARHQ resource, readmission costs $17,546 for each readmission for a blood disorder, and you estimate you could save one readmission a month ($210,552 annual savings).