IDEAS home Printed from https://ideas.repec.org/a/inm/orinte/v38y2008i4p241-250.html
   My bibliography  Save this article

Spreadsheet Models for Inventory Target Setting at Procter & Gamble

Author

Listed:
  • 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)

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.

Suggested Citation

  • Ingrid Farasyn & Koray Perkoz & Wim Van de Velde, 2008. "Spreadsheet Models for Inventory Target Setting at Procter & Gamble," Interfaces, INFORMS, vol. 38(4), pages 241-250, August.
    • Handle: RePEc:inm:orinte:v:38:y:2008:i:4:p:241-250
    DOI: 10.1287/inte.1080.0345
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/inte.1080.0345
    Download Restriction: no
    File URL: https://libkey.io/10.1287/inte.1080.0345?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Ingrid Farasyn & Salal Humair & Joel I. Kahn & John J. Neale & Oscar Rosen & John Ruark & William Tarlton & Wim Van de Velde & Glenn Wegryn & Sean P. Willems, 2011. "Inventory Optimization at Procter & Gamble: Achieving Real Benefits Through User Adoption of Inventory Tools," Interfaces, INFORMS, vol. 41(1), pages 66-78, February.
    2. Luis Guimarães & Pedro Amorim & Fabrício Sperandio & Fabío Moreira & Bernardo Almada-Lobo, 2014. "Annual Distribution Budget in the Beverage Industry: A Case Study," Interfaces, INFORMS, vol. 44(6), pages 605-626, December.
    3. Ayan Chatterjee & Debmallya Chatterjee, 2024. "A Journey of Business Analytics in Improving Supply Chain Performance: A Systematic Review of Literature," Management and Labour Studies, XLRI Jamshedpur, School of Business Management & Human Resources, vol. 49(2), pages 337-361, May.
    4. Mauro Falasca & Christopher Zobel & Cliff Ragsdale, 2011. "Helping a Small Development Organization Manage Volunteers More Efficiently," Interfaces, INFORMS, vol. 41(3), pages 254-262, June.
    5. Thomas A. Grossman & Vijay Mehrotra & Mouwafac Sidaoui, 2016. "A Student-Centered Approach to the Business School Management Science Course," INFORMS Transactions on Education, INFORMS, vol. 16(2), pages 42-53, January.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:inm:orinte:v:38:y:2008:i:4:p:241-250. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.