Supplier Selection

Supplier Selection

Evaluate the impacts of supplier
perfomance on inventory and
material costs

Skip the intro, take me to the Calculator

Supplier Selection Scenarios

When designing a new product, several levels of supplier selection decisions must be made. First, the organization must decide whether a part or subsystem (we will refer to either as a “component”) is designed uniquely for the product or selected from a set of standard components. (In some cases, the standard component may have been previously designed uniquely for a different product.) Once the component has been specified, the organization must decide who supplies the component.

There are five main supplier selection scenarios shown below. This calculator will consider decisions under the fifth scenario.

img
  1. If the component was uniquely designed, the company may decide to manufacture internally
  2. The company may also decide to outsource manufacturing
  3. If the component was selected from a “sole-sourced” supplier, there are few options — the company must try to negotiate the best terms possible
  4. If the component is a pure commodity, then company may select from one or more vendors based on various supply chain performance criteria
  5. If similar versions of the component can be obtained from multiple vendors, the company must trade-off technical and supply chain performance criteria

The first four scenarios are predominantly driven by procurement and supply chain functions with only minor input from engineering. The part specifications have been given and the design is complete.

The fifth scenario, however, requires close interaction between engineering, procurement, and supply chain organizations. The Supplier Selection Calculator was designed for this fifth scenario.

Trading-off Materials Costs, Technical Performance and SC Performance

Engineering organizations are usually motivated to maximize technical performance and minimize material costs. This calculator will help you trade-off increased material costs against lower inventory costs. Decreased technical performance (if relevant to the decision) may or may not be a “show-stopper.” There are two situations when engineering might be willing to accept higher material costs and lower technical performance.

First, if the technical performance of the component relates only weakly to overall product performance. Usually, these types of components must only carry-out simple functions at or above a minimum level of performance. Better performance does not increase overall product performance and is simply “wasted.” You may be able to substitute a lower performance component so long as it still meets the minimum thresholds.

Second, if the technical performance of the component can be compensated for by “tuning up” another component that has “excess performance.” In most systems of moderate complexity, there are sufficient interactions between components that this type of compensation may be possible at little or no cost.

For these same two reasons, you may be able to use common parts and subsystems across multiple products. As shown in the Commonality Calculator, this is also a way to reduce inventory costs.

Inventory Impacts of Supplier Performance ?

As mentioned in the Inventory vs. Material Costs Calculator, there are four primary supplier factors that directly impact inventory.

First, lead time. The longer the lead-time, the farther out the forecast period, and the greater the chance that the amount required will be different from the amount that actually arrives. In addition, the shorter the lead time, the shorter the pipeline inventory. With long lead times (e.g. ocean freight from Asia to North America), pipeline inventory can be significant. Generally, if you pay for the components when you place the order, you are responsible for pipeline inventory. If you pay for the components when you receive the order, you are not. Of course, payment terms and return policies complicate this distinction.

Second, lead time reliability. The more uncertain the lead time, the higher the inventory buffers that are required. You don’t need to hold as much inventory when suppliers perform reliably.

Third, delivery frequency. The more frequent the deliveries, the shorter that components sit around before they are built into products. If deliveries are every month, then the average working inventory is about 2 weeks (about 4 weeks at the beginning of the month and 0 at the end, so an average of about 2 weeks). If deliveries are every week, then the average working inventory is ½ week. Frequent deliveries are usually obtained from local suppliers or those suppliers who establish programs like just-in-time and vendor hubs.

Fourth, component yield. In some cases, arriving components may be defective or otherwise unusable in a product (e.g. the component has wider tolerances than the design or manufacturing process requires). Yield has three main effects.

  1. It increases effective lead time. Only a fraction of the order will take the normal lead time. The defective components must be reordered, and then some of those replacements will be defective and need to be reordered, etc.
  2. It increases material costs (assuming the supplier doesn’t send free replacements.
  3. It increases ordering and rework costs for ordering replacements and fixing the assemblies (if the defects are not caught in an incoming test).

See below for a more detailed description of all the parameters used in this calculator.

To use the calculator, simply change one or more of the blue numbers and then click the Calculate button.

Supplier One Two Three
Annual holding cost (h) (%)
Inventory cost (c) ($/unit)
Component yield (y) (%)
Responsible for cost of defective?
Inventory Inputs
Delivery frequency (f) (per week)
Target service level (SL) (same for all)
Forecast error (fe) (%) (same for all)
Lead time (L) (weeks)
Responsible for pipeline inventory
Lead time uncertainty (lu) (%)
Review period (R) (weeks) (same for all)

What is the total cost of holding safety stock and cycle stock inventory?

Inventory holding cost

($/unit)
Material cost ($/unit)
Inventory holding cost plus material cost ($/unit)

To Introduction Reload Page

Note: These calculators were created to facilitate rapid analysis of DFSC decisions. Although these calculators make simplifying assumptions, they have proved useful in practice. For complex trade-offs of additional cost factors or for especially important decisions, you may want to perform a more detailed analysis.

Inventory Parameters

  • Demand: Mean demand or consumption at an inventory stockpile (units/week). In this calculator, we assume demand of all items is the same.
  • Forecast error (fe): Standard deviation of the difference between forecasted and actual customer orders, divided by the mean demand. This ratio is sometimes also called coefficient of variation (CoV). In this calculator, we assume forecast error for all items is the same. Lead time (L): Mean lead time to replenish product into an inventory stockpile (weeks). In this calculator, we assume that lead time for all items is the same.
  • Lead time uncertainty (lu): Standard deviation of replenishment lead time divided by the mean lead time. In this calculator, we assume no lead time uncertainty.
  • Target service level (SL): The desired percentage of demand periods where there are no stock-outs. It is sometimes called availability rate. Depending on the target service level, safety stock is scaled up or down by a factor “k.” In this calculator, we assume that target service level for all items is the same.
  • Review period (R): The period of time in-between physical review of inventory stockpiles (weeks). It is assumed that replenishment orders are placed after each inventory review. For continuous review systems, R is zero. In this calculator, we assume review period for all items is the same.
  • Inventory cost (c): The current cost of the inventory, including material costs and any incremental value-add ($/unit).
  • Annual inventory holding cost (h): Expressed as a percentage of inventory cost, the annual inventory holding cost typically includes financing, storage, devaluation, and scrap.
  • Inventory weeks of supply: Inventory units divided by the mean weekly demand (WOS).

Product Variety and Commonality

Marketing Drivers of Product Variety

Estimate the inventory benefits of using
part commonality to achieve
product variety

Skip the intro, take me to the Calculator

Marketing Drivers of Product Variety

In many industries, customers demand highly customized products to meet their individualized needs. Companies often respond by increasing the product variety — or the number of variety dimensions and corresponding options — made available to customers.

For example, a bicycle company may offer mountain bikes, road bikes, and racing bikes. Within each class of bikes, it may offer options along various dimensions such as color (red, blue, silver, etc.), geometry (men’s, woman’s, front suspension, full suspension, etc.), size (15″, 16″ 17″, 18″, etc.), materials (steel, aluminum, titanium, carbon fiber, etc.), component performance (H, M, L, etc.), and so on.

It doesn’t take long for the potential complexity to get mind-boggling. Consider even the variety offered by our hypothetical bicycle company. If all combinations are permissible, there would be 1,728 possible end items (3 x 3 x 4 x 4 x 4 x 3).

Design Drivers of Product Variety

The variety that is driven by the dimensions valued by customers is clearly intended to increase revenue and market share. Variety can also be the result of efforts to decrease the material costs or increase the technical performance of parts and sub-systems. The performance that is required of a component depends on the product that it is eventually assembled into. For example, handle bars on larger bikes will likely face more stress (heavier riders) than handle bars on smaller bikes. Designers could save material costs by specifying thinner bars on smaller bikes. Inevitably, however, the result will be another dimension of variety. People come in all shapes and sizes, so some short and heavy riders will want thicker bars for strength and some tall and thin riders will want thinner bars for weight savings.

Complexity Costs

If the benefits of variety are higher revenues, lower material costs, and better technical performance, what are the costs? Product variety often increases the cost of things such as design, tooling, information systems, manufacturing, inventory, and after-sales support.

Commonality as a Strategy

Commonality is one approach adopted by many manufacturers to keep these “costs of complexity” under control. With commonality, the same version of a part or sub-system (we will refer to either as a “component”) is shared across multiple products. To avoid damaging perceived differentiation, designers often standardize the components that customers don’t care that much about. For example, bicycle companies often standardize components such as handle bars, frame tubes, brake- and shift-cables, tires, etc. These common components are engineered to meet the most stringent requirements and then “substituted downwards.” In other words, some products will have components that are “better than they need to be.” In other words, “higher cost than they need to be.”

Inventory Benefits of Commonality

So, what are the inventory benefits of commonality? The main benefit is reduced safety stock through lower forecast error. Intuitively, people understand that it is easier to forecast an aggregate quantity (e.g. all bikes sold in June) than individual items (e.g. the number of blue, front-suspension, 18″, steel mountain bikes with high-end component sets that are sold in June). If every bike shares a standard handle bar, then it will be easier to forecast consumption of handle bars, and handle bar inventory costs will be lower. The reduction of forecast errors through aggregation of demand is often called “risk pooling.”

The calculator on this page will help you understand the inventory benefits of commonality under three situations.

Take me to the Calculator

Situation 1: The common component is used across all products, also known as a universal component. Example: All bikes use the same handle bar.

img

Situation 2: The common component allows you to spread the demand of one or more eliminated products across the remaining products. Example: Offer frame sizes that are 2″ apart, so riders pick the closest size and then adjust the seat height.

img

Situation 3: The common component allows you to consolidate the demand of two or more products together. Example: Make the geometry for the men’s frame the same as that of the front suspension frame.

img

See below for a more detailed description of all the parameters used in this calculator. Note that because of the assumptions made, this calculator generally provides an upper-bound on inventory savings achieved through risk-pooling.

To use the calculator, simply change one or more of the blue numbers and then click the Calculate button.

Number of End Items
Item count before (n) number
Item count after (m) number
Inventory Carrying Costs
Annual holding cost (h) (%)
Inventory cost (c) ($/unit)
Safety Stock
Target service level (SL)
Forecast error (fe) (%)
Lead time (L) (weeks)
Review period (R) (weeks)

What is the cost of safety stock?

Inventory cost

($/unit/WOS)
Safety stock (SS) (WOS)
Safety stock cost ($/unit)
What are the potential savings in safety stock?

Situation 1: If you could design a universal item, it might be worth spending as much as $/unit more in material costs.

Situation 2: In going from from items to items by spreading demand across the remaining items, it might be worth spending as much as$/unit more in material costs.

Situation 3: In going from from items to items by consolidating demand onto one particular item, it might be worth spending as much as $/unit more in material costs.

To Introduction Reload Page

Note: These calculators were created to facilitate rapid analysis of DFSC decisions. Although these calculators make simplifying assumptions, they have proved useful in practice. For complex trade-offs of additional cost factors or for especially important decisions, you may want to perform a more detailed analysis.

Inventory Parameters

  • Demand: Mean demand or consumption at an inventory stockpile (units/week). In this calculator, we assume demand of all items is the same.
  • Forecast error (fe): Standard deviation of the difference between forecasted and actual customer orders, divided by the mean demand. This ratio is sometimes also called coefficient of variation (CoV). In this calculator, we assume forecast error for all items is the same. Lead time (L): Mean lead time to replenish product into an inventory stockpile (weeks). In this calculator, we assume that lead time for all items is the same.
  • Lead time uncertainty (lu): Standard deviation of replenishment lead time divided by the mean lead time. In this calculator, we assume no lead time uncertainty.
  • Target service level (SL): The desired percentage of demand periods where there are no stock-outs. It is sometimes called availability rate. Depending on the target service level, safety stock is scaled up or down by a factor “k.” In this calculator, we assume that target service level for all items is the same.
  • Review period (R): The period of time in-between physical review of inventory stockpiles (weeks). It is assumed that replenishment orders are placed after each inventory review. For continuous review systems, R is zero. In this calculator, we assume review period for all items is the same.
  • Inventory cost (c): The current cost of the inventory, including material costs and any incremental value-add ($/unit).
  • Annual inventory holding cost (h): Expressed as a percentage of inventory cost, the annual inventory holding cost typically includes financing, storage, devaluation, and scrap.
  • Inventory weeks of supply: Inventory units divided by the mean weekly demand (WOS).

Design for Supply Chain: Inventory Calculators

Sixty to eighty percent of all costs are locked-in during the design phase.

Are you considering the supply chain impacts of your product designs, or do inventory, manufacturing, and transportation costs come back to bite you? Most design for supply chain (DFSC) decisions slow to a crawl as companies struggle to quantify the costs and benefits of the various alternatives. There’s a better way. Leading organizations use “rough-cut” techniques rapidly trade-off important cost and benefits like material, inventory, manufacturing, distribution, and lost sales costs. The reason? Decisions come up constantly, and there isn’t always time to collect the data you need to complete a detailed analysis.

The principles of effective design for supply chain are to:

  • Utilize cross-functional teams
  • Capture intangibles through a qualitative assessment
  • Quantify what you can using rapid analysis techniques
  • Perform sensitivity analyses on your assumptions

These web pages provide you with several very effective rapid analysis techniques.

The Role of Inventory Calculators

One of the most common trade-offs that design teams make is:

“Should I pay $X more per unit in material costs to enable future inventory reductions through
(commonality, postponement, shorter supplier lead times, etc.)?”

Design teams find this question difficult to answer because they don’t always have experience in quantifying the drivers of inventory. No problem. These web-calculators capture the drivers.

The calculators:

  • Don’t require a lot of data
  • Help you quantify the inventory benefits of things like increased part commonality or decreased supplier lead times
  • Give you answers in $/unit so you can make direct trade-offs against material and assembly costs

Each of the three calculator pages are described below. Click on the button that best describes the decision you’re facing.

Inventory vs. Material Costs

Quickly decide whether the relative costs justify any further analysis

When you are making trade-offs that impact inventory, you first need to understand the relative importance of inventory costs and material costs. As a way of estimating the size of the opportunity, you might ask questions about the extremes.

For example:

  • If you could eliminate all inventory, how much more would you be willing to pay in material costs?
  • If you could save $X/unit in material costs, how much more inventory could you afford to stock?

Inventory vs. Material Costs

Quickly decide whether the relative costs justify any further analysis

Inventory vs. Material Costs

Quickly decide whether the relative costs justify any further analysis

One approach for reducing inventory levels while maintaining end-product variety is to use common parts and subsystems.

Another approach for reducing inventory levels is to select suppliers that have short and reliable lead times, frequent deliveries, and low defect rates.

Commonality reduces inventory, because the forecast error for aggregate demand is lower than that of individual-item demand.

With high performance suppliers, you don’t need to carry as much inventory in-between deliveries or to buffer their uncertainty.

Inventory vs. Material Costs

Inventory vs. Material Costs

Quickly decide whether the relative costs justify any further analysis

Skip the intro, take me to the Calculator

Inventory Primer

People often refer to three types of inventory: pipeline inventory, cycle stock inventory, and safety stock inventory.

  • Pipeline is the inventory that you’re responsible for (if any) over the lead time. It is sometimes called inbound inventory.
  • Cycle stock is the inventory used to satisfy average customer demand in-between supplier deliveries. It is sometimes called working inventory.
  • Safety stock inventory is used to “insure” against demand and supply uncertainty. It is sometimes called buffer inventory.

Inventory levels are determined by three main factors: customer behavior, supplier performance, and operating policies.

Customer Driven Factors Supplier Driven Factors Policy Driven Factors
  • Demand
  • Forecast error
  • Lead time
  • Lead time uncertainty
  • Part yield
  • Target service level
  • Delivery frequency
  • Review period

Eliminating All the Inventory

Say you’ve got a design idea that will reduce inventory levels. How much is it worth? Well, as an absolute upper limit on its value, imagine that it could eliminate all inventory! This is the most that you would be willing to pay to pursue an idea.

  • If the idea costs more than the savings, it probably won’t pay for itself
  • If the idea costs less than the savings, you should do a little more analysis by using the next set of calculators (commonality or supplier selection)

How would you eliminate all inventory? By eliminating pipeline and cycle stock and safety stock inventory. How would you eliminate each? Here are some examples.

  • Pipeline inventory: don’t take ownership of the components until you get them, or use suppliers with zero lead times
  • Cycle stock inventory: use suppliers with true “just-in-time” deliveries (essentially an infinite delivery frequency)
  • Safety stock inventory: no forecast errors and no lead time uncertainty, or zero lead times and continuous inventory review, or 50% target service levels

See below for a more detailed description of all the parameters used in this calculator.

To use the calculator, simply change one or more of the blue numbers and then click the Calculate button.

Inventory Carrying Costs
Annual holding cost (h) (%)
Inventory cost (c) ($/unit)
Pipeline Inventory
Responsible for pipeline?
Cycle Stock
Delivery frequency (f) (times per week)
Safety Stock
Target service level (SL)
Forecast error (fe) (%)
Lead time (L) (weeks)
Lead time uncertainty (lu) (%)
Review period (R) (weeks)

What is the total cost of holding safety stock and cycle stock inventory?

Inventory cost

($/unit/WOS)
Pipeline Inventory (P) (WOS)
Cycle stock (CS) (WOS)
Safety stock (SS) (WOS)
Total inventory (WOS)
Inventory cost ($/unit)
Do the relative costs justify further analysis?

If you were able to decrease inventory to zero, it might be worth spending as much as $/unit more in material costs.

For a material cost savings of $/unit, you could afford to carry an additional WOS of inventory.

This may allow you to increase your service levels to % or more.

Note: These calculators were created to facilitate rapid analysis of DFSC decisions. Although these calculators make simplifying assumptions, they have proved useful in practice. For complex trade-offs of additional cost factors or for especially important decisions, you may want to perform a more detailed analysis.

Inventory Parameters:

  • Demand: Mean demand or consumption at an inventory stockpile (units/week).
  • Forecast error (fe): Standard deviation of the difference between forecasted and actual customer orders, divided by the mean demand. This ratio is sometimes also called coefficient of variation (CoV).
  • Lead time (L): Mean lead time to replenish product into an inventory stockpile (weeks).
  • Pipeline inventory: The inventory that you’re responsible for (if any) from the time you place an order to the time you receive the components.
  • Generally, if you pay for the components when you place the order, you are responsible for pipeline inventory. If you pay when you receive the order, you are not. Of course, payment terms and return policies complicate this distinction.
  • Lead time uncertainty (lu): Standard deviation of replenishment lead time divided by the mean lead time.
  • Component yield (y): Probability that a component is not defective or unusable when it arrives from a supplier.
  • Target service level (SL): The desired percentage of demand periods where there are no stock-outs. It is sometimes called availability rate. Depending on the target service level, safety stock is scaled up or down by a factor “k.”
  • Delivery frequency (f): The frequency of replenishment deliveries from suppliers (times/week). In some cases, suppliers may be upstream assembly processes.
  • Review period (R): The period of time in-between physical review of inventory stockpiles (weeks). It is assumed that replenishment orders are placed after each inventory review. For continuous review systems, R is zero.
  • Inventory cost (c): The current cost of the inventory, including material costs and any incremental value-add ($/unit).
  • Annual inventory holding cost (h): Expressed as a percentage of inventory cost, the annual inventory holding cost typically includes financing, storage, devaluation, and scrap.
  • Inventory weeks of supply: Inventory units divided by the mean weekly demand (WOS).

To Introduction Reload Page