Regression model for product cost prediction

adf057

I have a business case to predict product cost for the next month for a product and to see how profitable a product is across the customers, so that I can plan if we need to work on the pricing of the product to increase our margin.

My dataset is a month sales and purchase report with fields -

productId, productName, customer, period, shopId, productRevenue, productCost

The dataset is for the last 26 months of the sales and purchase of these products across different customers.

I am trying to build new features and thinking what features I can build based on this dataset.

Appreciate your help and thoughts on this.