Find the optimum price points for each of the product to maximize the total profit earned.

[dranam]

Find the optimum price points for each of the product to maximize the total profit earned. In this case study, you are provided with a table with all 250 items on attached spreadsheet (Product List).

Following are the variables available in the data set:

1. Average Price/Unit: Market price of the product
2. Cost/Unit: Current cost of the product
3. Average Profit/Unit: Profit for each unit
4. Average units sold: Average number of units of product sold to a customer who makes a purchase
5. Incremental acquisition: For every 10% decline in unit price, this is the increase in total customer response rate. Note that overall response rate initially is 5% (5000 out of 100000 make a purchase). You are allowed to decrease the price of a product maximum by 10% by market laws.
6. Increase in sale volume: For every 10% decline in unit price of product, this is the increase in volume. Again, you are allowed to decrease the price of a product maximum by 10% by market laws.

Note: The maximum price hike permitted is 20%. So, basically the price of a product can be varied between -10% to +20% around the average price/unit.

[v-henryk-mstf]

Hi @dranam ,

Follow the link below to provide relevant test data (remove sensitive information) and other information, I will answer you as soon as possible.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry

[Fowmy]

@dranam 

Well explained! but provide data on Excel with the expected results for a few to work it out in Power BI.

You can save it in OneDrive or Google Drive and share the link here.