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. 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
Sign-up with a free account for immediate access to 23 scorecard templates including Sales Order KPIs.

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 health backlog ranges between 1 day and 2 weeks, as it highly depends on the business and their performance objectives.

If 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, which 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 analyzes 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 so, 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

Sign-up with a free account for immediate access to 23 scorecard templates including Sales Order KPIs.

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

Sign-up with a free account for immediate access to 23 scorecard templates including Sales Order KPIs.

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

Sign-up with a free account for immediate access to 23 scorecard templates including Sales Order KPIs.

KPI 3: Backlog Days

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

Backlog Days KPI

Sign-up with a free account for immediate access to 23 scorecard templates including Sales Order KPIs.

Backlog Performance Analysis Breakdown

Case 1

Let us assume 40 orders backlog. 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 increase 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

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 – 1st option preferred

Best Practice Advice

Best practice shows that backlog should be measured against previous week’s sales, as this will show 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 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

Sign-up with a free account for immediate access to 23 scorecard templates including Sales Order KPIs.

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 account at BSC Designer for immediate access to 23 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.

Oana Boteanu KPIs and Business Performance expert, she is a BA with Honours Management and Marketing graduate and has several years of experience working with performance management tools in employment performance and strategic performance. She also worked as a performance management online consultant at BSC Designer since from 2012 to 2013.

BSC Designer is a Balanced Scorecard software that is helping companies to better formulate their strategies and make the process of strategy execution more tangible with KPIs.

If you prefer to receive posts like these by email sign up to our newsletter.

How Business Professionals Use BSC DESIGNER

Strategy map
Capture their thoughts about strategy on a strategy map
KPIs
Track leading and lagging indicators to calculate performance
Initiatives
Engage employees in strategy execution and keep team accountable
Posted in Scorecard and KPIs Examples

Thank you for sharing!

Whether you are looking for a professional Balanced Scorecard software, or just researching information about Balanced Scorecard and business strategies, we recommend you to download and try our BSC Designer software (no credit card is required).

We will follow up with you with lessons about the Balanced Scorecard and will keep you informed about the trending articles on bscdesigner.com

Follow us in Social Media