Our calculation logic will use the following simple data structures:

Product Master

Contains Product Group information for each Product. We will need only the Product Group attribute for our calculation.

Product_Costs PX

Contains products' Average Costs valid at different Valid From dates. We will use this information to calculate product cost on a specific target date and also an average cost for a whole product group.

MarginAdj PP

Contains a percentual Margin adjustment for each Product Group. We will add this percentage to the final price based on the product group.

CountryFactor PP

Contains a Factor per Country code and Product Group. We will multiply the final price with this factor. Country code will be a user input.