Sales Department Mines Pricing History to Discover Trends
Sales Department at a Manufacturing company wanted to mine their pricing history to identify positive trends they could capitalize on while minimizing negative trends which pulled down gross profit for the organization.
ProjectLead worked with sales analysts to identify key reporting requirements.
ProjectLead developed custom Excel spreadsheets that would import sales history data from the company's ERP system.
ProjectLead designed and developed charts to highlight relevant information for the program.
RESULTS
Trend Visibility
Charts of historical data made it possible to identify positive and negative pricing trends.
Reduced Manual Labor
Automating this analysis eliminated the need for developing reports manually on a regular basis.
Increased Gross Margin
Key trend information led to changes in sales compensation plans that positively impacted gross margin.
Commenti