Links Advisory

Pricing Consumer Goods

Pricing Consumer Goods

Business Problem:

Client has one week to price all products for its multi-million dollar consumer goods business in anticipation of the new fiscal year.  The most challenging part of the task is to propose pricing tiers for MSRP, MAP, and Net programs.

Consulting Services Provided:

Working with the VP of Sales, Sales Operations Manager, and supporting staff, Links Advisory:

  • Provided guidance on organizing data to establish uniqueness at the item level; included up to five separate fields from multiple tables in the client’s AS400 system
  • Joined multiple tables in a data visualization tool called Microsoft Power BI in an effort to quickly display meaningful information to the CEO, CFO, and VP of Sales
  • Created one global price list eligible for import into new ERP system called NetSuite

Software:

The following software platforms were involved in this project:

  • NetSuite
  • AS400
  • Microsoft Excel
  • Microsoft Power BI

 

  URL Project:  Balfour
  Category: 
Visit Project
Share
Elizabeth Adams

Posts by 

Enter your keyword: