SLA is one kind of contract between companies to ensure the service quality of a product or service. SLA is very important to maintain service quality. This article will discuss how to calculate SLA percentage in Excel.
What Is SLA and SLA Percentage?
SLA stands for service level agreement. It expresses the level of service quality the customer expects from the vendor or service provider. It also includes a set of penalties if the service level is below the expected value.
And SLA percentage is the presentation of SLA in percentage. It can be expressed as the amount of service served following the SLA criteria divided by the total amount of service served by the vendor in percentage form. The formula for the SLA percentage is given below.
How to Calculate SLA Percentage in Excel: 2 Simple Steps
Here, we will discuss all the steps to calculate SLA percentage in Excel in detail.
In this article, we will show the SLA conducted by a logistic service provider and electronics product manufacturer. Assume that the manufacturer informs the logistic provider to collect the product from 9:00 AM to 02:00 PM every day and the logistic provider will collect the product within 4:00 PM according to the SLA. But the logistic provider can also collect the product after 4:00 PM but within 6:00 AM and they will get a 25% penalty for late collection of the product according to the SLA. Now, we will calculate the SLA percentage in Excel to express this scenario.
📌 Step 1: Calculate SLA Percentage with Formula
- We noted the data on the datasheet of Excel.
- Go to Cell C8 and put in the following formula.
=C6/C7
This is created based on the division of the product collected within the SLA criteria and the total number of products collected on that day.
- Press the Enter
Read More: Make an Excel Spreadsheet Automatically Calculate Percentage
📌 Step 2: Apply % Format in Excel to Get SLA Percentage
We get the result in decimal form. But we want to get the result in percentage form. Change the format of Cell C8. Press Ctrl + 1.
- Format Cells window appears.
- Choose Percentage from the Number tab.
- Choose the number of decimal places.
- Finally, press the OK button.
We get the SLA percentage.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
In this article, we described in detail the process of how to calculate the SLA percentage in Excel. I hope this will satisfy your needs. You can also use the comment section below for further queries or suggestions.
Related Articles
- How to Calculate Error Percentage in Excel
- How to Calculate Cumulative Percentage in Excel
- How to Calculate Mean Percentage Error in Excel
- How to Calculate Remaining Shelf Life Percentage in Excel
- How to Calculate Percentage of Completion in Excel
- How to Calculate Percentage of Budget Spent in Excel
- How to Calculate Utilization Percentage in Excel
- How to Calculate Absenteeism Percentage in Excel
- How to Calculate Savings Percentage in Excel
- How to Calculate Productivity Percentage in Excel
- How to Calculate Variance Percentage in Excel
- How to Calculate Accuracy Percentage in Excel
- How to Calculate Grade Percentage in Excel
- How to Calculate Win-Loss Percentage in Excel
<< Go Back to Percentage Formula Examples | Calculating Percentages | Calculate in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!