Improved Process and Optimization Tool

November 15th, 2005 7:17 pm Category: Case Study, Excel Solver, Optimization, Solver Optimization, Supply Chain Improvement, Supply Chain Planning, by: Editor

0 Flares 0 Flares ×

Business Problem: Dole Food Company, Inc. is a producer and marketer of high-quality fresh fruit, fresh vegetables and fresh-cut flowers, and markets several lines of packaged foods. Dole globally purchases containerboard from several paper companies to manufacture containers to transport and inventory their products.

Dole uses an MS Excel spreadsheet to optimize the variables and constraints to develop an annual strategic purchasing plan and on-going monthly tactical purchase plans for the year to minimize the total costs of buying paper products.

Dole had a desire to improve the optimization tool by using Profit Point’s supply chain consultants to:

  • Validate the current optimization methodology and algorithms
  • Investigate if there might be a better approach or tool to solve this problem

One of Dole’s purchase challenges was developing dynamic monthly plans that were consistent with the annual plan as they move through the year. The terms and conditions offered by the containerboard manufactures include variable costs and constraints that were non-linear. The monthly plan needed to consider these conditions to produce a purchasing plan that provided Dole an optimal cost minimization solution as they reach year-end.

Profit Point’s Solution: Validation: Profit Point reviewed Dole’s data inputs, assumptions, optimization process and validated that the current spreadsheet model was operating correctly and that the spreadsheet was providing Dole an optimal answer. A few modifications were made to the model which allowed Dole’s purchase managers to quickly update and run the tool, and review the output reports. This provided them the ability to confidently make a purchase decision by using the model output or a variant of the output or change the input and re-run the Optimization Tool.

Improved Process and Tool: Profit Point provided Dole with an improved Containerboard Optimization Tool using Frontline Systems‘ solvers that gave management the ability to:

  • Dynamically solve the optimization problem on a monthly basis and consider all the contractual terms associated with optimizing annual tonnage purchase levels.
  • Easily develop strategic plans that include multiple prices and programs offered by suppliers.
  • Improve the current optimization performance.

A better model and process created value to Dole by:

  • Reducing management’s time to analyze multiple scenarios each month
  • Improving management’s confidence in making purchase recommendations
  • Reducing total paper purchase costs through use of better management practices and model resources

And creating the opportunity for Dole to:

  • Decrease paper purchase costs
  • Increase management productivity
  • Provide Dole’s container production plants with improved purchase plans

To learn more about how Profit Point can help improve your Excel Solver optimization, contact us here:

(866) 347-1130 or
(435) 487-9141

Send us an Email

0 Flares LinkedIn 0 Google+ 0 Twitter 0 Email -- Buffer 0 0 Flares ×
Contact Us Now


Contact Us

Contact UsInfo

Please call:
+1 (610) 645-5557

Meet our Team

Our Clients

Published articles

  • A Fresh Approach to Improving Total Delivered Cost
  • Filling the Gap: Tying ERP to the Business Strategy
  • 10 Guidelines for Supply Chain Network Infrastructure Planning
  • Making Sound Business Decisions in the Face of Complexity
  • Leveraging Value in the Executive Suite
  • Should you swap commodities with your competitors?
  • Supply Chain: Time to Experiment
  • Optimization Technology Review
  • The Future of Network Planning: On the Verge of a New Cottage Industry?
  • Greening Your Supply Chain… and Your Bottom Line
  • Profit Point’s CEO and CTO Named a "Pro to Know" by Supply & Demand Chain Executive Magazine

Ready to optimize?


0 Flares LinkedIn 0 Google+ 0 Twitter 0 Email -- Buffer 0 0 Flares ×