Nu-kote's spreadsheet linear-programming models for optimizing transportation

Nu-kote's spreadsheet linear-programming models for optimizing transportation

0.00 Avg rating0 Votes
Article ID: iaor2005393
Country: United States
Volume: 34
Issue: 2
Start Page Number: 139
End Page Number: 146
Publication Date: Mar 2004
Journal: Interfaces
Authors: , , ,
Keywords: materials, systems, transportation: general
Abstract:

Nu-kote International manufactures ink-jet, laser, and toner cartridges; ribbons; and thermal fax supplies. We developed spreadsheet linear-programming models for planning shipments of finished goods between vendors, manufacturing plants, warehouses, and customers to minimize overall cost subject to maximum-shipping-distance policies. Nu-kote used versions of these linear programs (LPs) to model supply chains with different warehouse configurations. The LPs have between 5,000 and 9,700 variables and 2,452 constraints. Nu-kote has used these LPs for an inherently nonlinear problem to identify improved shipments that will reduce annual costs by approximately $1 million and customer transit time by two days. It has already saved $425,000 from insight gained from the model.

Reviews

Required fields are marked *. Your email address will not be published.