Sales Order Backlog Challenge

Sales Backlog stands for the amount of sales orders that a company has received but has not completed yet, also referred to as order backlog or BI.

The perception of the impact backlog orders have on a company varies. The majority of companies measure their backlog rations in sales values. If the backlog sales value is high, this is considered very positive on the business, as it shows a high level of customer demand as well as future financial stability.

Backlog KPIs in BSC Designer: KPI 1: Backlog relative to weekly sales; KPI 2: Backlog closure capacity; KPI 3 : Backlog Days.
Backlog Balanced Scorecard
View View Sales Order KPIs online in BSC Designer Sales Order KPIs online - sign-up with a free account for immediate access to 28 scorecard templates.

For example, if a phone manufacturer has a backlog of $200,000 worth of orders, investors consider that a positive figure that ensures a revenue a minimum sales revenue of $200,000.

Backlog – Positive or Negative Impact on Business?

However, if backlog is measured in days, this becomes a company performance matter.  Here, most companies assess the health of the customer orders that are in Backlog (orders placed that have not been shipped out) relative to last week’s sales.

Research shows that a healthy backlog ranges between 1 day and 2 weeks, as it highly depends on the business and their performance objectives.

If a backlog decreases, this could be a sign of higher business performance or even a significant sales drop. For example, if more orders are processed daily per employee, this is definitely an improvement; however, if sales dropped, and the company is now focusing solely on delivering backlog orders, that is an alarming situation for the business.
Therefore, it is fundamental to analyze the backlog performance of your business and analyze how changes in backlog affect business success.

Sales Backlog Challenge

Company A aims to increase its backlog performance from an operational perspective and reach an ultimate goal of 1 day per customer order backlog.

In order to achieve this, we put together a list of useful Key Performance Indicators and purposed a breakdown analysis to help Company A measure the performance success of their backlog management.

KPI 1: Backlog relative to weekly sales

  • Formula: Total backlog (as of measurement day) / Weekly Sales

Backlog Weekly Sales KPI

Sales Order KPIs
Sign-up with a free plan to access Sales Order KPIs as well as 30 other scorecard templates.

Hypothetical Example

  • Date – 15h April
  • Weekly Sales (8th-14th April) = 100 orders
  • End of week total backlog = 40 orders

Backlog to Weekly Sales Ratio: 40/100 = 0.4: 1. Usually companies measure this in sales value.

Weekly Backlog Settings

Sales Order KPIs
Sign-up with a free plan to access Sales Order KPIs as well as 30 other scorecard templates.

KPI 2: Daily order closure capacity

  • Formula: Total number of orders closed/ total number of days (measured over given time period) e.g. 1 week (working 7 days a week)

Total number of orders closed: 60. Total number of days: 7. 60/7 = 8.5 orders closed per day

Backlog Closure Capacity KPI

Sales Order KPIs
Sign-up with a free plan to access Sales Order KPIs as well as 30 other scorecard templates.

KPI 3: Backlog Days

  • Formula: Total Open Orders as of measurement day (Orders backlog) / Orders Closed per Day (Order closure capacity)

Backlog Days KPI

Sales Order KPIs
Sign-up with a free plan to access Sales Order KPIs as well as 30 other scorecard templates.

Backlog Performance Analysis Breakdown

Case 1

Let us assume 40 orders backlog. The company receives weekly 100 orders and closes weekly 60.

  • Backlog closure capacity: 8.5 orders per day.
  • Total backlog: 40. 40/8.5 =4.7 days backlogged.

Backlog increases weekly if orders continue at this rate – because orders are higher than the company’s capacity to process orders.

Case 2

Weekly orders: 100. Weekly capacity: 60. 60/100 = 0.4. Ratio 0.4: 1 – for every order processed 0.4 are backlogged.

Figures at 21st of April look like:

Backlog at the start of the week + new orders – orders closed. 40+ 100 – 60 = 80.

  • Backlog days : 80/8.5 =  9.4 days

Case 3

Let us assume the company increases the daily order capacity to 12 orders per day.

  • Total open orders: 40
  • Orders closed per day: 12
  • Total open orders/orders closed per day
  • 40/12 = 3.3 days backlogged

With a capacity of 12 orders per day, figures at 21st of April will look like:

  • Formula: Backlog at the start of the week + new orders – orders closed
  • 40+ 100 – (7×12) =  40 + 100 – 84 = 56

Backlog days:

  • 56/12 = 4.6 days

The backlog will still be increasing because the company is working under capacity – either the company has to increase orders closure capacity over the weekly sales, or sales should decrease – the first option is preferred

Best Practice Advice

Best practice shows that the backlog should be measured against previous week’s sales, as this will show the backlog performance efficiency relative to sales performance.

However, if the company is working towards a target, in our case the 1-day backlog challenge, they could measure the current backlog against last week’s backlog.  This will help to measure progress, such as % increase or % decrease in backlog days.

Automation software

If tracking backlog indicators is relevant to your business strategy, then consider using professional Balanced Scorecard software BSC Designer for this purpose.

Backlog Order KPIs in BSC Designer

Sales Order KPIs
Sign-up with a free plan to access Sales Order KPIs as well as 30 other scorecard templates.

On the one hand, you can use it to track your Key Performance Indicators and align them with appropriate action plans, and on the other hand, you can monitor your metrics (like, for example, backlog) automatically, and if it gets into the yellow or red zone, the person responsible will get a notification that something has gone wrong.

What's next?

  • Access templates. Sign-up with a free plan at BSC Designer for immediate access to 30 scorecard templates, including Sales Order KPIs discussed in this article.
  • Master skills. Check out free video tutorial for the Balanced Scorecard. Master your strategy planning and execution skills with Strategy Execution training.
  • Automate. Learn what Balanced Scorecard software is and how it can make your life easier by automating strategy execution, KPIs, and strategy maps.
Online wizard will help even inexperienced users to create a professional strategy map with business goals, KPIs, and initiatives.

Strategy Map Wizard – Balanced Scorecard in 6 Minutes

Answer simple questions - build a professional strategy map in 6 minutes.

Strategy formulation and description might be a time-consuming project even for an experienced strategist. This Strategy Scorecard Wizard will make the whole process fast and intuitive.

Start now!

More Examples of the Balanced Scorecard

Customer service strategy map with KPIs
8 STEPS To Create a Strategy Map By BSC Designer
Corporate Governance Dashboard with KPIs
Cite as: Oana Boteanu, "Sales Order Backlog Challenge," BSC Designer, April 19, 2013, https://bscdesigner.com/sales-order-backlog-challenge.htm.

Leave a Comment