Skip to content
Product cover

How To Do Strategic Supply-Chain Planning

October 15, 2003 | ManMohan S. Sodhi | Operations

It is not uncommon in many companies for tactical planners to use computer models to optimize the supply chain -- while, in a completely separate activity, senior managers formulate strategy. The endeavors are understandably separate as they differ fundamentally in nature. But today, the author posits, a few leading organizations are discovering the benefits of having the tactical planners in close communication with the big-picture strategists early on. A new approach called strategic supply-chain planning can ensure that critical supply-chain details inform a company's business strategy and that supply-chain management aligns with the strategic direction -- a synergy companies could benefit from at any time but is often most urgently needed after mergers or acquisitions. Companies routinely weigh long-term supply-chain-related decisions in light of alternative sources of supply, new geographic markets or new products, but tactical managers think about the issues differently than strategic managers. According to the author, a step-by-step approach can leverage the best of both worlds, and his research suggests how to combine the strategist's scenario planning with the tactical planner's optimization modeling while avoiding the downsides of each approach. As long as the two teams work together, he says, strategic supply-chain planning can improve a company's competitiveness.

Purchase Options

Educator and Student Discounts Available. Learn more »

  BENCHMARKS  
Loading Time: Base Classes  0.0018
My Controller Construct  0.0004
Build Nav  0.0007
Controller Execution Time ( Products / Route )  0.0410
Total Execution Time  0.0427
  GET DATA  
No GET data exists
  MEMORY USAGE  
1.5595 MB
  POST DATA  
No POST data exists
  URI STRING  
store/how-to-do-strategic-supply-chain-planning
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 68  (Hide)
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '9b3a149b233a8628fda6e2fe7f9c401e'
ORDER BY `created_at` DESC 
0.0003  

SELECT SQL_CALC_FOUND_ROWS cat_id
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `url_friendly` =  'how-to-do-strategic-supply-chain-planning'
AND `parent_id` =  1 
0.0073  

SELECT c.parent_id, c.format_id
                    FROM products AS p, products AS c
                    WHERE p.prod_id = c.parent_id AND
                        c.avail_id IN ('A','B','D') AND
                        c.type_id = 'V' AND
                        (
                            c.sku = 'how-to-do-strategic-supply-chain-planning' OR
                            if(c.format_id = 'Certificate', '', p.url_friendly) = 'how-to-do-strategic-supply-chain-planning'
                        )
                    LIMIT 1 
0.0002  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  1681 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1681' 
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1681'
ORDER BY `sort` ASC 
0.0001  

SELECT `cat_id`
FROM (`product_categories__products`)
WHERE `prod_id` =  '1681' 
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1681' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1681'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0090  

SELECT `products`.`parent_id`
FROM (`transaction_lines`)
JOIN `products` ON `products`.`sku` = `transaction_lines`.`sku`
JOIN `product_categories__products` ON `products`.`parent_id` = `product_categories__products`.`prod_id`
WHERE `products`.`avail_id` =  'A'
AND TO_DAYS(transaction_lines.updated_at) < (TO_DAYS(NOW()) - 90)
AND `product_categories__products`.`cat_id` IN ('248') 
GROUP BY `products`.`parent_id`
ORDER BY COUNT(*) DESC
LIMIT 6 
0.0002  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '2343' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2343' 
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '2343'
ORDER BY `sort` ASC 
0.0002  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '217' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '217' 
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '217'
ORDER BY `sort` ASC 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '3775' 
0.0001  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '3775' 
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '3775'
ORDER BY `sort` ASC 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '2699' 
0.0001  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2699' 
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '2699'
ORDER BY `sort` ASC 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '2723' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2723' 
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '2723'
ORDER BY `sort` ASC 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '655' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '655' 
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '655'
ORDER BY `sort` ASC 
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1681'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '814' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '814' 
0.0002  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1681'
AND `kind` =  'gallery_image'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'C', 'H') 
AND `parent_id` =  '1681'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0001  

SELECT `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`products` AS c)
WHERE `c`.`prod_id` =  '1682'
LIMIT 1 
0.0002  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1682'
AND `kind` =  'thumbnail'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1681'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0005  

SELECT `cat_id` AS id, `parent_id` AS parent, `status_id`, `name`, `description`, `url_friendly`, `page_title`, `meta_keywords`, `meta_description`, `position`, `updated_at`
FROM (`product_categories`)
WHERE `cat_id` != 1
ORDER BY `parent_id`, IF(position = 0, 1, 0) ASC , `position`, `name` 
0.0003  

SELECT *
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `parent_id` =  1
AND `cat_id` NOT IN (1, 261) 
ORDER BY `name` 
0.0002  

SELECT *
FROM (`site_settings`)
WHERE `option_key` =  'announcement' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)