Skip to content
Product cover

'Greening' Transportation in the Supply Chain

January 1, 2010 | Susan L. Golicic, Courtney N. Boerstler, Lisa M. Ellram | Operations

The country's largest corporations have hit a road bump on their way toward factoring sustainability into their transportation choices. Despite pressures from customers and investors — and the prospect of evervolatile energy costs--just 9% of Fortune 500 companies include environmental goals in their public documents. A study of those 44 companies reveals some of the best practices that can help a business go the distance, ultimately working with its partners to rethink its entire transportation infrastructure.

Companies must demonstrate three distinct levels of integration before they can embed the reduction of greenhouse gas emissions into their transportation strategies: establishing a foundation (acknowledging the problem), changing internal company practices (building an environmentally aware culture) and impacting supply chain practices (such as better vehicle utilization or more efficient routing). Within these categories, the tactics need to be measured by carefully calibrated metrics that can track both environmental and financial progress. As employees begin adapting their own decision making to the new priority--by, for instance, choosing videoconferencing instead of traveling--executives should spread such success stories, reinforcing the institutional preference.

Purchase Options

Educator and Student Discounts Available. Learn more »

  BENCHMARKS  
Loading Time: Base Classes  0.0009
My Controller Construct  0.0004
Build Nav  0.0006
Controller Execution Time ( Products / Route )  0.0485
Total Execution Time  0.0495
  GET DATA  
No GET data exists
  MEMORY USAGE  
1.5732 MB
  POST DATA  
No POST data exists
  URI STRING  
store/greening-transportation-in-the-supply-chain
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 77  (Hide)
0.0003  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '96b53276ef8b7d9151806cefa8d225d8'
ORDER BY `created_at` DESC 
0.0004  

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

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

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

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

SELECT SQL_CALC_FOUND_ROWS cat_id
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `url_friendly` =  'greening-transportation-in-the-supply-chain'
AND `parent_id` =  1 
0.0056  

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 = 'greening-transportation-in-the-supply-chain' OR
                            if(c.format_id = 'Certificate', '', p.url_friendly) = 'greening-transportation-in-the-supply-chain'
                        )
                    LIMIT 1 
0.0002  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  823 
0.0003  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '823' 
0.0003  

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

SELECT `cat_id`
FROM (`product_categories__products`)
WHERE `prod_id` =  '823' 
0.0002  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '823' 
0.0008  

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

SELECT SQL_CALC_FOUND_ROWS p.prod_id AS parent_id, p.pool_id AS parent_pool_id, p.type_id AS parent_type_id, p.title AS parent_title, p.description AS parent_description, p.url_friendly AS parent_url_friendly, p.product_type, p.publication_date, c.prod_id, c.avail_id, c.type_id, c.sku, c.title, c.price, c.sale_price, c.toggle_inventory_api, c.qty_available, c.expected_date, product_categories__products.cat_id, COALESCE(product_categories.name, '') as category_name
FROM (`products` AS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
LEFT JOIN (product_categories__products) ON `p`.`prod_id` = `product_categories__products`.`prod_id`
LEFT JOIN (product_categories) ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `c`.`type_id` =  'V'
AND c.sku IN ('58220P')
AND (c.avail_id IN ('A','B','D') AND (c.format_id != 'Physical'))
GROUP BY `c`.`parent_id`
ORDER BY FIELD(c.sku, '58220P'), `p`.`title`, IF(c.position = 0, 1, 0) ASC , `c`.`position`, `c`.`title` 
0.0003  

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

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '17' 
0.0004  

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '17'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`products` AS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_id` IN ('A', 'B', 'D') 
AND `c`.`type_id` =  'V'
AND `c`.`parent_id` =  '17' 
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` =  '17'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '9' 
0.0002  

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '9' 
0.0106  

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.0003  

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.0001  

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.0002  

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

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.0003  

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

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` =  '823'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '400' 
0.0004  

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` =  '823'
AND `kind` =  'gallery_image'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0004  

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'C', 'H') 
AND `parent_id` =  '823'
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` =  '824'
LIMIT 1 
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` =  '824'
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` =  '823'
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)