{"id":13261,"date":"2021-12-09T23:26:10","date_gmt":"2021-12-10T07:26:10","guid":{"rendered":"https:\/\/michaeljbrumm.com\/dcl-v3\/?p=13261"},"modified":"2023-06-30T10:42:56","modified_gmt":"2023-06-30T17:42:56","slug":"ecommerce-supply-chain-formulas","status":"publish","type":"post","link":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/","title":{"rendered":"Ecommerce Supply Chain Formulas You Need to Know"},"content":{"rendered":"

A critical step in determining the effectiveness of your ecommerce fulfillment process is determining the key performance indicators (KPIs) that matter most to your business. Once you know the metrics that are most important to your operation, you can benchmark your current performance and monitor improvements and progress towards your goals.<\/span><\/p>\n

While the formulas used to calculate these KPIs are well known to logistics professionals, it helps to explain them so you can figure out which one is applicable to your unique business situation. Below, we have gathered some of the most important formulas for key supply chain and order fulfillment KPIs.<\/span><\/p>\n

 <\/p>\n

Key Ecommerce Supply Chain Formulas<\/span><\/p>\n

Perfect Order Percentage<\/span><\/p>\n

Perfect order percentage measures what percentage of orders ship on-time, complete, damage-free, and with correct documentation. It is a measurement of whether or not an order fulfillment operation is meeting customer expectations.\u00a0<\/span><\/p>\n

 <\/p>\n

Formula: % orders on time X % orders shipped complete X % orders shipped no damage X % orders with correct documentation<\/span><\/p>\n

 <\/p>\n

On-Time Shipping Percentage<\/span><\/p>\n

On-time shipping measures the percentage of orders that are shipped on time from an order fulfillment operation. Like perfect order percentage, on-time shipping percentage is a critical KPI used to monitor whether or not an operation is meeting customer expectations.<\/span><\/p>\n

 <\/p>\n

Formula: number of orders shipped on time \/ number of orders shipped<\/span><\/p>\n

 <\/p>\n

Order Fill Rate<\/span><\/p>\n

Order fill rate reflects the percentage of orders filled 100 percent complete to the total number of orders filled. It can be used as a broad indicator of the accuracy and efficiency of an operation.\u00a0<\/span><\/p>\n

 <\/p>\n

Formula: total orders filled to customer request \/ total orders filled<\/span><\/p>\n

 <\/p>\n

Line Item Fill Rate<\/span><\/p>\n

Like order fill rate above, line item fill rate is another way that an operation can measure their overall efficiency and identify room for improvement. It reflects a ratio of order lines filled 100 percent to the total number of lines.<\/span><\/p>\n

 <\/p>\n

Formula: total order lines filled complete \/ total order lines filled<\/span><\/p>\n

 <\/p>\n

Orders Picked Per Hour<\/span><\/p>\n

Orders picked per hour is a metric that measures order fulfillment and shipping productivity in lines per hour per person. This is a bottom line benchmark that allows an operation to compare their performance against others in the industry. It should include all functions within the operation and the total hours worked across shifts.<\/span><\/p>\n

 <\/p>\n

Formula: total orders picked and successfully shipped \/ total hours worked in picking and shipping<\/span><\/p>\n

 <\/p>\n

Lines Picked and Shipped Per Hour<\/span><\/p>\n

Lines picked and shipped per hour measures the productivity of picking and shipping operations in lines per person per hour. By determining the total lines processed throughout your operation, it is possible to gain an accurate representation of your operational efficiency.<\/span><\/p>\n

 <\/p>\n

Formula: total order lines picked and successfully shipped \/ total hours worked in picking and shipping<\/span><\/p>\n

 <\/p>\n

Inventory Accuracy<\/span><\/p>\n

Inventory accuracy is used to calculate the accuracy of your inventory. It works by taking a count of items in stock and comparing that number against what\u2019s recorded in your database. Bench-marking and monitoring your inventory accuracy can help ensure that your bookkeeping and data management practices are in order.<\/span><\/p>\n

 <\/p>\n

Formula: # of items counted \/ # of items books count<\/span><\/p>\n

 <\/p>\n

Storage Utilization Rate<\/span><\/p>\n

Storage utilization rate reflects how efficiently you are utilizing the amount of available space in your warehouse or fulfillment center. Operations with suboptimal storage utilization can leverage a number of options to reclaim lost space.\u00a0<\/span><\/p>\n

 <\/p>\n

Formula: inventory cubic ft. \/ total warehouse cubic ft.<\/span><\/p>\n

 <\/p>\n

You are likely to find that your utilization rate is low\u2014often between 22 and 27 percent. This is because you must maintain enough space around the inventory for machinery and personnel to operate. A systems integrator can help you determine the appropriate level of utilization for you.<\/span><\/p>\n

 <\/p>\n

Inventory Days of Supply<\/span><\/p>\n

Inventory days of supply (IDS) measures how much inventory you have on hand within your operation to cover a number of days of projected use. For most operations, a lower IDS is ideal, but should only be measured within the content of the operation. It can vary widely between industries, product lines, business models, and even warehousing strategies.\u00a0<\/span><\/p>\n

 <\/p>\n

Formula: on-hand finished goods inventory value \/ total annual COGS \/ 365<\/span><\/p>\n

 <\/p>\n

Total Order Cycle Time<\/span><\/p>\n

Total order cycle time reflects the average length of time that passes between a customer placing an order and the order being shipped. Because the velocity and efficiency in which orders move throughout the fulfillment process impacts profitability and customer service, monitoring and improving total order cycle time is critical for most order fulfillment operations.\u00a0<\/span><\/p>\n

 <\/p>\n

Formula: time order received by customer \u2013 time order placed \/ total number of orders shipped<\/span><\/p>\n

 <\/p>\n

Internal Order Cycle Time<\/span><\/p>\n

Internal order cycle time reflects the average amount of time that it takes from the moment that a customer order is released into the warehouse for processing and the moment that the order is shipped. It is a key reflection of all of the order fulfillment aspects that a warehouse\/DC has control over.\u00a0<\/span><\/p>\n

 <\/p>\n

Formula: time order shipped \u2013 time order received \/ number of orders shipped<\/span><\/p>\n

 <\/p>\n

The Bottom Line<\/span><\/p>\n

Once you have bench-marked your key performance indicators, it is possible to track your performance over time and identify which areas of your business and operation might benefit from added attention. Once you know what component of your operation you would like to optimize, a trusted third-party logistics provider (3PL) can help you consider your options, whether that includes adjustments to your internal workflows, deployment of automation technologies, or something else altogether.<\/span><\/p>\n

 <\/p>\n

Are you having trouble setting KPIs and could use a 3PL to outsource your order fulfillment to? You can read <\/span>DCL\u2019s list of services<\/span><\/a> to learn more, or check out <\/span>the many companies we work with<\/span><\/a> to ensure great logistics support. <\/span>Send us a note<\/span><\/a> to connect about how we can help your company grow.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

A critical step in determining the effectiveness of your ecommerce fulfillment process is determining the key performance indicators (KPIs) that matter most to your business. Once you know the metrics that are most important to your operation, you can benchmark your current performance and monitor improvements and progress towards your goals. While the formulas used […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[122],"tags":[2050],"class_list":["post-13261","post","type-post","status-publish","format-standard","hentry","category-supply-chain","tag-calculators-formulas"],"acf":[],"yoast_head":"\nEcommerce Supply Chain Formulas You Need to Know | DCL Logistics<\/title>\n<meta name=\"description\" content=\"Explaining some of the most important formulas for ecommerce supply chain and order fulfillment KPIs to better help you evaluate your process.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ecommerce Supply Chain Formulas You Need to Know\" \/>\n<meta property=\"og:description\" content=\"Explaining some of the most important formulas for ecommerce supply chain and order fulfillment KPIs to better help you evaluate your process.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/\" \/>\n<meta property=\"og:site_name\" content=\"DCL Logistics\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DCLLogistics\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-10T07:26:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-30T17:42:56+00:00\" \/>\n<meta name=\"author\" content=\"Hadleigh Reid\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dcl_logistics\" \/>\n<meta name=\"twitter:site\" content=\"@dcl_logistics\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hadleigh Reid\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Ecommerce Supply Chain Formulas You Need to Know | DCL Logistics","description":"Explaining some of the most important formulas for ecommerce supply chain and order fulfillment KPIs to better help you evaluate your process.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/","og_locale":"en_US","og_type":"article","og_title":"Ecommerce Supply Chain Formulas You Need to Know","og_description":"Explaining some of the most important formulas for ecommerce supply chain and order fulfillment KPIs to better help you evaluate your process.","og_url":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/","og_site_name":"DCL Logistics","article_publisher":"https:\/\/www.facebook.com\/DCLLogistics\/","article_published_time":"2021-12-10T07:26:10+00:00","article_modified_time":"2023-06-30T17:42:56+00:00","author":"Hadleigh Reid","twitter_card":"summary_large_image","twitter_creator":"@dcl_logistics","twitter_site":"@dcl_logistics","twitter_misc":{"Written by":"Hadleigh Reid","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/#article","isPartOf":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/"},"author":{"name":"Hadleigh Reid","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#\/schema\/person\/da6717f42cf9f668559023de5ff93aa6"},"headline":"Ecommerce Supply Chain Formulas You Need to Know","datePublished":"2021-12-10T07:26:10+00:00","dateModified":"2023-06-30T17:42:56+00:00","mainEntityOfPage":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/"},"wordCount":979,"commentCount":0,"publisher":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#organization"},"keywords":["Calculators & Formulas"],"articleSection":["Supply Chain"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/","url":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/","name":"Ecommerce Supply Chain Formulas You Need to Know | DCL Logistics","isPartOf":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#website"},"datePublished":"2021-12-10T07:26:10+00:00","dateModified":"2023-06-30T17:42:56+00:00","description":"Explaining some of the most important formulas for ecommerce supply chain and order fulfillment KPIs to better help you evaluate your process.","breadcrumb":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/supply-chain\/ecommerce-supply-chain-formulas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/michaeljbrumm.com\/dcl-v3\/"},{"@type":"ListItem","position":2,"name":"Ecommerce Supply Chain Formulas You Need to Know"}]},{"@type":"WebSite","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#website","url":"https:\/\/michaeljbrumm.com\/dcl-v3\/","name":"DCL Logistics","description":"Logistics and Fulfillment Experts","publisher":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/michaeljbrumm.com\/dcl-v3\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#organization","name":"DCL Logistics","url":"https:\/\/michaeljbrumm.com\/dcl-v3\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#\/schema\/logo\/image\/","url":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-content\/uploads\/2023\/05\/DCL-Icon-Transparent.png","contentUrl":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-content\/uploads\/2023\/05\/DCL-Icon-Transparent.png","width":153,"height":153,"caption":"DCL Logistics"},"image":{"@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DCLLogistics\/","https:\/\/x.com\/dcl_logistics","https:\/\/www.linkedin.com\/company\/dcl\/"]},{"@type":"Person","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#\/schema\/person\/da6717f42cf9f668559023de5ff93aa6","name":"Hadleigh Reid","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/michaeljbrumm.com\/dcl-v3\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c5013befad8eff04fe16ec86f138a6ce6ad76a1e7ead9470408af4a80a6e5da6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c5013befad8eff04fe16ec86f138a6ce6ad76a1e7ead9470408af4a80a6e5da6?s=96&d=mm&r=g","caption":"Hadleigh Reid"},"description":"Hadleigh is the Content Manager at DCL Logistics. He drives the content marketing strategy and writes articles to help ecommerce businesses understand the 3PL and fulfillment world and grow and improve their strategy. Feel free to reach out at hadleighr@dclcorp.com","url":"https:\/\/michaeljbrumm.com\/dcl-v3\/blog\/author\/hadleigh\/"}]}},"_links":{"self":[{"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/posts\/13261","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/comments?post=13261"}],"version-history":[{"count":0,"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/posts\/13261\/revisions"}],"wp:attachment":[{"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/media?parent=13261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/categories?post=13261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michaeljbrumm.com\/dcl-v3\/wp-json\/wp\/v2\/tags?post=13261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}