Appendix 1

Porters 5 ForcesAppendix 2: Medical History Assessment Form

 

Appendix 3: Preference Form

Appendix 4: Business Process Model and Diagram

 

Appendix 5: Microsoft Dynamics – CRM Software

And this video: https://www.youtube.com/watch?v=YEa_RNSX5Xo

Appendix 6: SalesForce – Service Cloud

Learn more at: http://www.salesforce.com/service-cloud/overview/

Appendix 7: Zoho Creator

https://www.zoho.com/creator/database-software.html

Appendix 8: Kotter’s 8 Steps of Change

 

Appendix 9: Timeline

 

Appendix 10: Total Costs (Span of two-years)

Implementation
Licensing Fees = $1,000,000 (one-time fee)
+ User-base monthly fee: 80 users x 66.80 per user license, per month x 24 months = $128,256
+ 145 gigabytes of data at $10.30 per gigabyte x 24 months = $35,844
=$1,164,100 total cost

Installation of CRM software
80 computers x installation time 2 hours = 160 hours
Technical and integration consultants for installation $150/hr x 160 hours = $70,200 x 4 consultants = $280,800
= $280,800 total cost (full-time consultants cost continues after 2-year implementation)

Appendix 11: Time Saved

Time Savings:
1.5 hr/day saved per employee x 90 employees
= 135 hours per day
x 7 days per week
=945 hours per week
x 52 weeks
= 49,140 hours per year

Appendix 12: Increase in Productivity – New Revenue Model

30 doctors x 7 hours/day x 52 weeks x 1.5 hr/day saved
= 16,380 hours saved from administrative work

16,380 hours x 60 minutes = 982,800 minutes saved by doctors

Patient appointment = 20 minutes per patient on average

982,800 / 20 = 49,140 more patient appointments

 49,140 x $20 = $982,800 increase in revenue

Appendix 13: Income Statement