Microsoft Dynamics 365 Blog

CRM MVP Mitch Milam returns as a guest blogger. You can read more from Mitch at his blog.

When implementing Dynamics CRM or designing a customized solution within Dynamics CRM you will often find yourself asked by the powers-that-be what their Return on Investment (ROI) will be. Since I consult for a living, I get asked this more than most.

Here is a common approach to show the ROI for a specific customization made to Dynamics CRM.

Understanding the User’s Workflow

Note: In this particular case, I’m not referring to the workflow process built into Dynamics CRM, but rather, the procedures and processes performed by the user.

The best way to understand how a user utilizes CRM is simply to watch them work. What you are looking for is repetitive, reproducible tasks that get performed on a frequent basis.

For example: The scheduling a follow-up call with a customer.

Ask yourself the following questions:

  1. What did the user need to do to make that action happen?
  2. How long did it take them to get to a location where they could enter data?
  3. How many times per day do they perform this operation?

Calculating ROI

Once we have the basics for our operation recorded, we can start the ROI calculation process.

Step 1: Calculating the cost per minute of the user

First of all, we need to know how much the user cost the company per minute, which we can determine using the following calculation:

Cost per Minute = Salary / Number of minutes per year

Which looks like this in Excel:


Step 2: How long does the operation take

As part of our user workflow analysis, we recorded the number of seconds it took the user to record our action. Using this calculation, we can determine the assumed cost of operation:

Cost = (cost per minute / 60) * time [in seconds] of the operation

Which looks like this in Excel:


Step 3: Determine Repetitions

Using the cost per operation, we can insert the number of times the user said they perform the action per day then extrapolate that number into weekly, monthly and yearly frequency and costs:


Step 4: Determining operational costs

Finally, we can calculate the operational cost of this activity:

Operational cost = Number of personnel * year cost [of action]


ROI in Action

Now that we know the assumed annual cost for the action, we can calculate our ROI for our solution.

Solution: Place a Phone Call button on the toolbar of the Contact Form.

Time Saved: 2 seconds

Cost Savings Is calculated by:

number of seconds saved * cost per second * yearly number of repetitions

Which we can as:


If it cost $150 to implement and test the solution, then our actual savings over the course of a year is $619.23. When you consider that other, similar solutions can be implemented, your ROI continues to rise.


Today I’ve shown you how to perform a simple and quick ROI calculation to justify a proposed customization change to CRM to make the job of the CRM user more efficient and easier.

An Excel worksheet with this calculation may be found on my blog in the Free Utilities section.


Mitch Milam

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!