Spreadsheet Models for Inventory Target Setting at Procter & Gamble

Ingrid Farasyn (), Koray Perkoz () and Wim Van de Velde ()
Additional contact information
Ingrid Farasyn: Procter & Gamble Services Company NV, Global Business Services--Business Analysis Solutions, Strombeek-Bever, Belgium
Koray Perkoz: Procter & Gamble Services Company NV, Global Business Services--Business Analysis Solutions, Strombeek-Bever, Belgium
Wim Van de Velde: Procter & Gamble Services Company NV, Global Business Services--Business Analysis Solutions, Strombeek-Bever, Belgium

Interfaces, 2008, vol. 38, issue 4, 241-250

Abstract: Spreadsheet models have been instrumental in helping Procter & Gamble (P&G) to set inventory targets. The Global Analytics group of P&G's Business Analysis Solutions organization, an in-house modeling, decision-support, and consultancy group, created global inventory models. The models determine the best inventory levels and yield the required customer-service levels, subject to the characteristics and constraints of a particular supply chain. These spreadsheet models are easy to use and share. Therefore, they have become the standard tool for setting inventory targets at P&G; hundreds of supply chain planners worldwide now use them. They have contributed to inventory reductions of over $350 million and significant intangible benefits.

Keywords: information systems; decision-support systems; inventory/production; applications (search for similar items in EconPapers)
Date: 2008
References: Add references at CitEc
Citations: View citations in EconPapers (5)

Downloads: (external link)
http://dx.doi.org/10.1287/inte.1080.0345 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orinte:v:38:y:2008:i:4:p:241-250

Access Statistics for this article

More articles in Interfaces from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().