Raw Material Management at Welch's, Inc.
Authors:
- 1 October 1998
- journal article
- Published by Institute for Operations Research and the Management Sciences (INFORMS) in Interfaces
- Vol. 28 (5) , 13-24
Abstract
Welch's, a large grape-processing company owned by a grower cooperative, faced complex logistics in planning recipes for products sold in retail stores. The recently installed integrated MRP and cost-accounting systems did not include ways to calculate recipes at optimal cost based on plant-raw-material and capacity constraints. An imbalance of supply and demand further complicated this problem in raw-materials management. The cross-functional team in charge of managing raw materials spent increasing amounts of time deciding what recipes to use at each plant. We formulated the problem as a linear program model and used spreadsheet optimization to incorporate the model in daily decision making. The company has run the model each month since 1994 to provide senior management with information on the optimal logistics plan. This simple application saved Welch's between $130,000 to $170,000 during the first year.Keywords
This publication has 5 references indexed in Scilit:
- Spreadsheets and OR/MS Models: An End-User PerspectiveInterfaces, 1996
- The Teachers' Forum: Management Science with Spreadsheets for MBAs at Indiana UniversityInterfaces, 1996
- A Note on the Growth of a Production Planning System: A Case Study in EvolutionInterfaces, 1993
- A Hierarchical Production Planning SystemInterfaces, 1985
- PRODUCTION‐DISTRIBUTION PLANNING IN A LARGE SCALE COMMODITY PROCESSING NETWORKDecision Sciences, 1976