I have attached a spreadsheet with the following:
- Data Tab
- Key Assumptions and a mock up with description
In my business we receive referrals from medical networks. Those referrals then go on to have various visits. In the assumptions tab, I have a plug for average visits for each referral category. In addition, I have outlined the timing of those referrals.
What I need to determine is a way to project future month visits based on prior and current month referrals.
This should be a fun analysis to piece together. I have hit a wall with the analysis.
Thank you in advance for any time spent on this.
MarkVisits Estimator Template.xlsx (167.1 KB)