Turning Data Into Dollars

When Menasha Packaging acquired Strive, both companies had different rate cards supporting PepsiCo’s $35 million annual business. The customer wanted one rate card. In Excel, rate modifiers were programmed to accommodate both companies display lines that were accepted by PepsiCo: The $35 million was preserved and both Strive and Menasha protected their site level profitability.
Kraft Foods wanted price certainty for their display programs. Designed an Excel Price Model linked to a rate sheet based on statistically calculated averages of historical business that was easy to use, scalable and included provisions for "what if" pricing.