Prediction Model to Estimate Product Sales of a Fortune 100 Firm During a Specific Campaign Period

Business Challenge:

The client was a Fortune 50 technology firm and worldwide leader in software, services and solutions. The client used to periodically offer promotions on products for a limited period to enhance sales.

The client approached TurnB to predict the sales of products for the period in which they plan to offer discount.

TurnB Approach:

We collaborated with the client to create a prediction model and estimate sales during a specific campaign period using the following approach:

• Extracted historical sales data related to products from the customer database
• Performed data audit to check for missing values and normalized/eliminated the outliers
• A predictive model was designed to predict sales of products for the offer period

Implications:

• The sales of products during the offer period were predicted
• The client was able to plan the inventory in a better way which helped in maximizing the sales during campaign period
• The estimates helped the client to understand the impact of sales on the revenue and profits for the campaign duration